Department of Financial Services

Object Crosswalk Excel Worksheet Creation Guide

Introduction:

An agency may use the DFS Excel worksheet to have Object Crosswalk data uploaded into FLAIR. The Object Crosswalk file allows only the addition or deletion of a record. To update a record, you must delete the existing record and then re-add it. This can be accomplished in the same Excel upload spreadsheet. The upload process will perform all DELETEs first; then it will process all ADDs. All alphanumeric characters must be uppercase. The first row in the spreadsheet must be a security header record. Because the field lengths in the security header record do not match the field lengths in the Object Crosswalk detail records, some of the security header records must be broken up into multiple cells.

Object Crosswalk Excel Worksheet Instruction

Excel Column Name / Type / Size / Allowed Values / Required / Comments
Header Record ID
or
Action / Text / 1 / “H” – for Security Header record
or
“A” – When adding an Object Crosswalk record
“D” – When deleting an Object Crosswalk record / Yes
Organization
or
OLO / Text
Numeric / 6 / Yes / If this is a Security Header record, only the first 6 characters of Organization can fit in this cell. NOTE: Wildcard ORG levels are denoted with an asterisk (*). Organization and User Name must be active on the Departmental Access Control file and have update capability for the Title function (TI).
If this is an Object Crosswalk record, enter the OLO. Must be valid for Organization on the Security Header record.
Organization (cont.)
or
Agency Object Code / Text
Numeric / 6 / Yes / If this is a Security Header record, enter the last 5 characters of Organization followed by the first character of User Name.
If this is an Object Crosswalk record, enter the Agency Object Code. Must be numeric and cannot start with 0 or 9.
User Name (cont.)
or
Statewide Object Code / Text
Numeric / 6 / Yes
Required if adding a Crosswalk record. / If this is a Security Header record, enter the remaining characters of User Name.
If this is an Object Crosswalk record, enter the Statewide Object Code if adding a record. Must be numeric, cannot start with 0 or 9, and must be active on the Title file.
Other Cost Accumulator / Text / 5 / No / Object Crosswalk records only. If entered, must be valid on the Title file.
External Category / Text / 6 / No / Object Crosswalk records only. If entered, must be valid on the Title file.
External Object / Text / 3 / No / Object Crosswalk records only. If entered, must be valid on the Title file.
External General Ledger / Text / 3 / No / Object Crosswalk records only. If entered, must be valid on the Title file.

Page 1 of 39/17/2014