Data Mapping / Warehousing assignment
y2crippler
data_mapping_version_0.1.xlsxSQS USER
| Steton Field | SUPPLIER COMPANY PROFILE | SUPPLIER FACILITY PROFILE | SUPPLIER CONTACT | COMMENTS |
| Control.RecordCount | ||||
| ListOfRecords.User.UserID | Not defined in Supplier Master Data sheet | |||
| ListOfRecords.User.NamePrefix | Name Prefix | |||
| ListOfRecords.User.NameFirst | Contact First Name | |||
| ListOfRecords.User.NameLast | Contact Last Name | |||
| ListOfRecords.User.Title | Not defined in Supplier Master Data sheet | |||
| ListOfRecords.User.Company | Responsible or Legal Owner ? | Responsible or Legal Owner ? | Parent Company / Facility Name | |
| ListOfRecords.User.Address1 | Physical, Postal or Billing ? | It has 4 fields: Address Line 1, Address Line 2, Address line 3 or Address line 4 | ||
| ListOfRecords.User.Address2 | ||||
| ListOfRecords.User.City | City | |||
| ListOfRecords.User.MailStop | NOT SURE What does these element exaclty means | |||
| ListOfRecords.User.State | Physical, Postal or Billing ? | State or Province | ||
| ListOfRecords.User.PostalCode | Postal Code | |||
| ListOfRecords.User.Country | Country | |||
| ListOfRecords.User.Phone1 | Phone # | Phone Number | ||
| ListOfRecords.User.Phone2 | Only Single Phone Number attribute listed | Is it Mobile/Pager number or Emergency Contact | ||
| ListOfRecords.User.Fax | Fax # | Fax | ||
| ListOfRecords.User.Email | Email Address | |||
| ListOfRecords.User.UserName | Not defined in Supplier Master Data sheet | |||
| ListOfRecords.User.InitialPassword | ||||
| ListOfRecords.User.Password | ||||
| ListOfRecords.User.Active | ||||
| ListOfRecords.User.DownloadFolder | ||||
| ListOfRecords.User.AdminNotifications | ||||
| ListOfRecords.User.SuperUser | ||||
| ListOfRecords.User.AppConfigName | ||||
| ListOfRecords.User.WebLanguage | ||||
| ListOfRecords.User.MALanguage | ||||
| ListOfRecords.User.ListOfPrimaryAccounts.PrimaryAccount.AccountID | ||||
| ListOfRecords.User.ListOfPrimaryManagements.PrimaryManagement.ManagementID | ||||
| ListOfRecords.User.ManagementIDs (OBSOLETE) | ||||
| ListOfRecords.User.ManagementListIsDefinitive | ||||
| ListOfRecords.User.ListOfManagements.Management.ManagementID | ||||
| ListOfRecords.User.AccountListIsDefinitive | ||||
| ListOfRecords.User.ListOfAccounts.Account.AccountID | ||||
| ListOfRecords.User.ListOfAccounts.Account.DirectReportAccess | ||||
| ListOfRecords.User.AuditListIsDefinitive | ||||
| ListOfRecords.User.ListOfAudits.Audit.AuditReference | ||||
| ListOfRecords.User.RoleIDs (OBSOLETE) | ||||
| ListOfRecords.User.RoleListIsDefinitive | ||||
| ListOfRecords.User.ListOfRoles.Role.RoleID | ||||
SQS ACCOUNT
| Steton Field | SUPPLIER COMPANY PROFILE | SUPPLIER FACILITY PROFILE | SUPPLIER CONTACT | COMMENTS |
| Control.AccountCount | ||||
| ListOfAccounts.Account.AccountId | Needs more description from Steton regarding the difference between Account.Account_____ and Account.Contact_____. | |||
| ListOfAccounts.Account.AccountName | Responsible or Legal Owner ? | Responsible or Legal Owner ? | Parent Company / Facility Name might be if it corresponds to SUPPLIER CONTACT | |
| ListOfAccounts.Account.Address1 | Physica, Postal or Billing | |||
| ListOfAccounts.Account.Address2 | ||||
| ListOfAccounts.Account.MailStop | NOT SURE What does these element exaclty means | |||
| ListOfAccounts.Account.City | Physica, Postal or Billing | |||
| ListOfAccounts.Account.State | ||||
| ListOfAccounts.Account.PostalCode | ||||
| ListOfAccounts.Account.Country | ||||
| ListOfAccounts.Account.Phone1 | Phone # | |||
| ListOfAccounts.Account.Phone2 | Only Single Phone Number attribute listed | |||
| ListOfAccounts.Account.Fax | Fax # | |||
| ListOfAccounts.Account.Email | ||||
| ListOfAccounts.Account.UserField1 | Needs more clarification | |||
| ListOfAccounts.Account.UserField2 | ||||
| ListOfAccounts.Account.UserField3 | ||||
| ListOfAccounts.Account.UserField4 | ||||
| ListOfAccounts.Account.UserField5 | ||||
| ListOfAccounts.Account.UserField6 | ||||
| ListOfAccounts.Account.UserField7 | ||||
| ListOfAccounts.Account.UserField8 | ||||
| ListOfAccounts.Account.UserField9 | ||||
| ListOfAccounts.Account.UserField10 | ||||
| ListOfAccounts.Account.ContactName | Are the values same as ListOfContacts | |||
| ListOfAccounts.Account.ContactPhone | ||||
| ListOfAccounts.Account.ContactEmail | ||||
| ListOfAccounts.Account.ContactFax | ||||
| ListOfAccounts.Account.UserID | Not defined in Supplier Master Data sheet | |||
| ListOfAccounts.Account.DivisionID | ||||
| ListOfAccounts.Account.ModifiedDate | ||||
| ListOfAccounts.Account.Active | ||||
| ListOfAccounts.Account.ActiveDate | Supplier Since Date | Facility Since Date | ||
| ListOfAccounts.Account.TimeZone | TIME ZONE | TIME ZONE | ||
| ListOfAccounts.Account.DaylightSaving | Daylight Savings Time | Daylight Savings Time | ||
| ListOfAccounts.Account.ManagementListIsDefinitive | Not defined in Supplier Master Data sheet | |||
| ListOfAccounts.Account.ListOfManagements.Management.ManagementID | ||||
| ListOfAccounts.Account.AuditListIsDefinitive | ||||
| ListOfAccounts.Account.ListOfAudits.Audit.AuditReference | ||||
| ListOfAccounts.Account.ReportAccess | ||||
| ListOfCustomFields.CustomField.UniqueKey | ||||
| ListOfCustomFields.CustomField.Value | ||||
| ListOfContacts.Contact.NameFirst | Contact First Name | |||
| ListOfContacts.Contact.NameMiddle | Contact Middle Name | |||
| ListOfContacts.Contact.NameLast | Contact Last Name | |||
| ListOfContacts.Contact.Title | Not defined in Supplier Master Data sheet | |||
| ListOfContacts.Contact.Address1 | It has 4 fields: Address Line 1, Address Line 2, Address line 3 or Address line 4 | |||
| ListOfContacts.Contact.Address2 | ||||
| ListOfContacts.Contact.MailStop | Not defined in Supplier Master Data sheet | |||
| ListOfContacts.Contact.City | City | |||
| ListOfContacts.Contact.State | State or Province | |||
| ListOfContacts.Contact.Country | Country | |||
| ListOfContacts.Contact.PostalCode | Postal Code | |||
| ListOfContacts.Contact.Email1 | Email Address | |||
| ListOfContacts.Contact.Email2 | Email Address | |||
| ListOfContacts.Contact.Phone1 | Phone Number | |||
| ListOfContacts.Contact.Phone2 | Mobile / Pager Number | |||
| ListOfContacts.Contact.ContactType | Contact Type | |||
SQS MANAGEMENT
| Steton Field | SUPPLIER COMPANY PROFILE | SUPPLIER FACILITY PROFILE | SUPPLIER CONTACT | COMMENTS |
| Control.RecordCount | Is Management same as Supplier or Facility ? | |||
| ListOfRecords.Management.ManagementID | ||||
| ListOfRecords.Management.ParentID | ||||
| ListOfRecords.Management.RootID | ||||
| ListOfRecords.Management.LogoID | ||||
| ListOfRecords.Management.LevelID | ||||
| ListOfRecords.Management.ManagementName | ||||
| ListOfRecords.Management.Address1 | ||||
| ListOfRecords.Management.Address2 | ||||
| ListOfRecords.Management.City | ||||
| ListOfRecords.Management.MailStop | ||||
| ListOfRecords.Management.State | ||||
| ListOfRecords.Management.PostalCode | ||||
| ListOfRecords.Management.Country | ||||
| ListOfRecords.Management.Phone1 | ||||
| ListOfRecords.Management.Phone2 | ||||
| ListOfRecords.Management.Fax | ||||
| ListOfRecords.Management.Email | ||||
| ListOfRecords.Management.UserID | Not defined in Supplier Master Data sheet | |||
| ListOfRecords.Management.UDF1 | ||||
| ListOfRecords.Management.UDF2 | ||||
| ListOfRecords.Management.UDF3 | ||||
| ListOfRecords.Management.UDF4 | ||||
| ListOfRecords.Management.UDF5 | ||||
| ListOfRecords.Management.UDF6 | ||||
| ListOfRecords.Management.UDF7 | ||||
| ListOfRecords.Management.UDF8 | ||||
| ListOfRecords.Management.UDF9 | ||||
| ListOfRecords.Management.UDF10 | ||||
| ListOfRecords.Management.AccountListIsDefinitive | ||||
| ListOfRecords.Management.ListOfAccounts.Account.AccountID | ||||
| ListOfRecords.Management.AuditListIsDefinitive | ||||
| ListOfRecords.Management.ListOfAudits.Audit.AuditReference | ||||
