Data Mapping / Warehousing assignment

profiley2crippler
accountmasterdata_v1.3.zip
Home>Information Systems homework help>Data Mapping / Warehousing assignment

Accounts_200705010800436745416.xml

3 123 LUBBOCK TX abc street #1 LUBBOCK TX 12345 US true true District1 Region12 456 ROCKY MOUNT 123 NORTH BOULEVARD ROCKY MOUNT NC 12345 US true false District24 Region20 true form1 789012 GREENVILLE STORE 3240 N. SOUTH DRIVE #2 GREENVILLE SC 12345 US true false District11 Region337

SQS Account 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.AccountCount 1,1 Total number of accounts included in the file xs:integer
ListOfAccounts.Account.AccountId 1,1 Account ID xs:string 15
ListOfAccounts.Account.AccountName 1,1 Account name xs:string 200
ListOfAccounts.Account.Address1 0,1 Address line 1 xs:string 100
ListOfAccounts.Account.Address2 0,1 Address line 2 xs:string 100
ListOfAccounts.Account.MailStop 0,1 Mail stop xs:string 100
ListOfAccounts.Account.City 0,1 City xs:string 100
ListOfAccounts.Account.State 0,1 State xs:string 50 Generally, this is a state abbreviation for US accounts
ListOfAccounts.Account.PostalCode 0,1 Postal code xs:string 50
ListOfAccounts.Account.Country 0,1 Country xs:string 100
ListOfAccounts.Account.Phone1 0,1 Phone 1 xs:string 50
ListOfAccounts.Account.Phone2 0,1 Phone 2 xs:string 50
ListOfAccounts.Account.Fax 0,1 Fax xs:string 50
ListOfAccounts.Account.Email 0,1 Email xs:string 200
ListOfAccounts.Account.UserField1 0,1 User defined field xs:string 255
ListOfAccounts.Account.UserField2 0,1 User defined field xs:string 255
ListOfAccounts.Account.UserField3 0,1 User defined field xs:string 255
ListOfAccounts.Account.UserField4 0,1 User defined field xs:string 255
ListOfAccounts.Account.UserField5 0,1 User defined field xs:string 255
ListOfAccounts.Account.UserField6 0,1 User defined field xs:string 255
ListOfAccounts.Account.UserField7 0,1 User defined field xs:string 255
ListOfAccounts.Account.UserField8 0,1 User defined field xs:string 255
ListOfAccounts.Account.UserField9 0,1 User defined field xs:string 255
ListOfAccounts.Account.UserField10 0,1 User defined field xs:string 255
ListOfAccounts.Account.ContactName 0,1 Primary contact name xs:string 200 Alternative primary contact name (this value is not applicable if a UserID has been associated with this account).
ListOfAccounts.Account.ContactPhone 0,1 Primary contact phone xs:string 200 Alternative primary contact phone (this value is not applicable if a UserID has been associated with this account).
ListOfAccounts.Account.ContactEmail 0,1 Primary contact email xs:string 200 Alternative primary contact email (this value is not applicable if a UserID has been associated with this account).
ListOfAccounts.Account.ContactFax 0,1 Primary contact fax xs:string 200 Alternative primary contact fax (this value is not applicable if a UserID has been associated with this account).
ListOfAccounts.Account.UserID 0,1 Primary contact user ID xs:string 15 This value takes precedence of the Contact fields and references an SQS user as the primary contact for this account.
ListOfAccounts.Account.DivisionID 0,1 Division ID xs:integer This field is only relevant for extracts from SQS. This field is ignored for imports to SQS
ListOfAccounts.Account.ModifiedDate 0,1 Date when any account attribute was last modified. xs:datetime yyyy-MM-ddTHH:mm:ss.fffffffK (Example: 2007-2-12T12:09:19.0000000-07:00) For exports, this field contains the date when any account attribute (i.e. Address1, UserField1, etc.) was last modified. This field is ignored for imports to SQS.
ListOfAccounts.Account.Active 1,1 Account status xs:boolean true, false "true" if the account is active. This node is case-sensitive and must be lowercase.
ListOfAccounts.Account.ActiveDate 0,1 Activation date xs:datetime Date the account was activated
ListOfAccounts.Account.TimeZone 0,1 Timezone xs:string One of the standard MS Windows timezones (e.g. "Atlantic Standard Time", "Atlantic Daylight Time", "China Standard Time", "Mountain Standard Time", "Mountain Daylight Time", etc.)
ListOfAccounts.Account.DaylightSaving 0,1 Daylight saving xs:boolean true, false "true" if the account observes daylight savings. This node is case-sensitive and must be lowercase.
ListOfAccounts.Account.ManagementListIsDefinitive 0,1 Is this list of Management IDs definitive? If so, any management IDs associated with this account that are not included in this file will be removed. xs:boolean true, false "true" = delete any management associations for this account that are not included in this file. "false" = add management associations included in this file but DO NOT delete any existing management associations not included in this file. This node is case-sensitive and must be lowercase.
ListOfAccounts.Account.ListOfManagements.Management.ManagementID 0,1 Management IDs associated with this account xs:string 15 One management ID per ListOfAccounts.Account.ListOfManagements.Management node
ListOfAccounts.Account.AuditListIsDefinitive 0,1 Is this list of Audit Forms definitive? If so, any Audit Forms associated with this account that are not included in this file will be removed. xs:boolean true, false "true" = delete any audit form associations for this account 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.
ListOfAccounts.Account.ListOfAudits.Audit.AuditReference 0,1 Audit forms associated with this account xs:string 15 One audit reference per ListOfAccounts.Account.ListOfAudits.Audit node
ListOfAccounts.Account.ReportAccess 0,1 Report Access xs:boolean true, false "true" if direct access to this location through reporting is allowed. This node is case-sensitive and must be lowercase.
ListOfCustomFields.CustomField.UniqueKey 0,1 Custom field identifier **NOTE: Steton will provide values for this field based on configuration completed in support of custom fields xs:string 50 **NOTE: Steton will provide values for this field based on configuration completed in support of custom fields
ListOfCustomFields.CustomField.Value 0,1 Custom field value xs:string
ListOfContacts.Contact.NameFirst 1,1 xs:string 50
ListOfContacts.Contact.NameMiddle 0,1 xs:string 50
ListOfContacts.Contact.NameLast 1,1 xs:string 50
ListOfContacts.Contact.Title 0,1 xs:string 100
ListOfContacts.Contact.Address1 0,1 xs:string 100
ListOfContacts.Contact.Address2 0,1 xs:string 100
ListOfContacts.Contact.MailStop 0,1 xs:string 50
ListOfContacts.Contact.City 0,1 xs:string 100
ListOfContacts.Contact.State 0,1 xs:string 50
ListOfContacts.Contact.Country 0,1 xs:string 100
ListOfContacts.Contact.PostalCode 0,1 xs:string 50
ListOfContacts.Contact.Email1 0,1 xs:string 200
ListOfContacts.Contact.Email2 0,1 xs:string 200
ListOfContacts.Contact.Phone1 0,1 xs:string 50
ListOfContacts.Contact.Phone2 0,1 xs:string 50
ListOfContacts.Contact.ContactType 1,1 xs:integer 1=primary, 2=secondary

Sheet2

Sheet3

SwXsdSqsAccountMasterData v1.3.xsd