Data Mapping / Warehousing assignment
y2crippler
managementmasterdata_v1.1.zipManagements_200701120200436746416.xml
2 Eastern Eastern Region true 0010012 true A120 USA US false 0010012 0010013 false A10
SQS Management Master Data Mapping.xls
Sheet1
| Special Instructions | ||||||||
| 1. Any node that is sent will replace the value in the database with the node value. If the node is empty, the value in the database will be removed. | ||||||||
| 2. In order to not effect a value in the database, the node should be omitted from the file that is sent. | ||||||||
| 3. Required nodes must always be sent. | ||||||||
| Steton Field | Freq (min, max) | Description | Data Type | XML Type | Lookup Reference | Len | Format | Possible Values |
| Control.RecordCount | 1,1 | Total number of management records in the file | xs:integer | |||||
| ListOfRecords.Management.ManagementID | 1,1 | Management ID | xs:string | 15 | ||||
| ListOfRecords.Management.ParentID | 1,1 | Parent ID for this record. This is the management ID of the parent record. | xs:string | 15 | ||||
| ListOfRecords.Management.RootID | 1,1 | Root ID for this record. This is the management ID of the record at top of the management hierarchy to which this record belongs. | xs:string | 15 | ||||
| ListOfRecords.Management.LogoID | 0,1 | Logo ID of the logo associated with this record. | xs:integer | Unless you know the appropriate Logo ID, exclude this node or leave it blank. | ||||
| ListOfRecords.Management.LevelID | 1,1 | Management Level ID for this record. | xs:integer | |||||
| ListOfRecords.Management.ManagementName | 1,1 | Management name | xs:string | 200 | ||||
| ListOfRecords.Management.Address1 | 0,1 | Address line 1 | xs:string | 100 | ||||
| ListOfRecords.Management.Address2 | 0,1 | Address line 2 | xs:string | 100 | ||||
| ListOfRecords.Management.City | 0,1 | Mail stop | xs:string | 100 | ||||
| ListOfRecords.Management.MailStop | 0,1 | City | xs:string | 100 | ||||
| ListOfRecords.Management.State | 0,1 | State | xs:string | 50 | Generally, this is a state abbreviation for US accounts | |||
| ListOfRecords.Management.PostalCode | 0,1 | Postal code | xs:string | 50 | ||||
| ListOfRecords.Management.Country | 0,1 | Country | xs:string | 100 | ||||
| ListOfRecords.Management.Phone1 | 0,1 | Phone 1 | xs:string | 50 | ||||
| ListOfRecords.Management.Phone2 | 0,1 | Phone 2 | xs:string | 50 | ||||
| ListOfRecords.Management.Fax | 0,1 | Fax | xs:string | 50 | ||||
| ListOfRecords.Management.Email | 0,1 | xs:string | 200 | |||||
| ListOfRecords.Management.UserID | 0,1 | Primary contact user ID | xs:string | 15 | This field references an SQS user as the primary contact for this record. | |||
| ListOfRecords.Management.UDF1 | 0,1 | This optional user defined field can be used to hold additional information about this management record | xs:string | 255 | ||||
| ListOfRecords.Management.UDF2 | 0,1 | This optional user defined field can be used to hold additional information about this management record | xs:string | 255 | ||||
| ListOfRecords.Management.UDF3 | 0,1 | This optional user defined field can be used to hold additional information about this management record | xs:string | 255 | ||||
| ListOfRecords.Management.UDF4 | 0,1 | This optional user defined field can be used to hold additional information about this management record | xs:string | 255 | ||||
| ListOfRecords.Management.UDF5 | 0,1 | This optional user defined field can be used to hold additional information about this management record | xs:string | 255 | ||||
| ListOfRecords.Management.UDF6 | 0,1 | This optional user defined field can be used to hold additional information about this management record | xs:string | 255 | ||||
| ListOfRecords.Management.UDF7 | 0,1 | This optional user defined field can be used to hold additional information about this management record | xs:string | 255 | ||||
| ListOfRecords.Management.UDF8 | 0,1 | This optional user defined field can be used to hold additional information about this management record | xs:string | 255 | ||||
| ListOfRecords.Management.UDF9 | 0,1 | This optional user defined field can be used to hold additional information about this management record | xs:string | 255 | ||||
| ListOfRecords.Management.UDF10 | 0,1 | This optional user defined field can be used to hold additional information about this management record | xs:string | 255 | ||||
| ListOfRecords.Management.AccountListIsDefinitive | 0,1 | Is this list of Accounts definitive? If so, any Accounts associated with this management that are not included in this file will be removed. | xs:boolean | true, false | "true" = delete any account associations for this record that are not included in this file. "false" = add account associations included in this file but DO NOT delete any existing account associations not included in this file. This node is case-sensitive and must be lowercase. | |||
| ListOfRecords.Management.ListOfAccounts.Account.AccountID | 0,1 | Account IDs associated with this record | xs:string | 15 | One Account ID per ListOfRecords.Management.ListOfAccounts.Account node | |||
| ListOfRecords.Management.AuditListIsDefinitive | 0,1 | Is this list of Audit Forms definitive? If so, any Audit Forms associated with this management that are not included in this file will be removed. | xs:boolean | true, false | "true" = delete any audit form associations for this record that are not included in this file. "false" = add audit form associations included in this file but DO NOT delete any existing audit form associations not included in this file. This node is case-sensitive and must be lowercase. | |||
| ListOfRecords.Management.ListOfAudits.Audit.AuditReference | 0,1 | Audit forms associated with this record | xs:string | 15 | One audit reference per ListOfRecords.Management.ListOfAudits.Audit node |
Sheet2
Sheet3
SwXsdSqsManagementMasterData v1.1.xsd
