Foundation data mapping

This section lists the mapping of foundation data from spreadsheets to target forms.

Note

When entering data, be aware that data in one spreadsheet can depend on data that is either entered on another spreadsheet or already loaded in the system. For example, the company field, which is entered on most spreadsheets, must match a company either created in Company.xlsx or already loaded on the system. These dependencies are noted in the instructions in the spreadsheets.

The Dataload spreadsheet dependencies topic has more information about the order in which to load data.

Unknown macro: {multi-excerpt}

Foundation data mapping

Spreadsheet	Tab	Staging form	Target form or forms
Company.xlsx	COM_LoadCompany	COM:LoadCompany	COM:Company
Company.xlsx	COM_LoadCompany Alias	COM:LoadCompany Alias	COM:Company Alias
Financials.xlsx	FIN_LoadConfig CostCentersRep	FIN:LoadConfig CostCentersRep	FIN:ConfigCostCentersRepository
Financials.xlsx	FIN_LoadCost CenterUDAAssoc	FIN:LoadCost CenterUDAAssoc	FIN:CostCenterUDAAssociations
GenericCatalog.xlsx	CFG_Load GenericCatalog	CFG:LoadGeneric Catalog	CFG:Generic Catalog
GenericCatalog.xlsx	CFG_LoadGeneric ProdSerAssoc	CFG:LoadGeneric ProdSerAssoc	CFG:GenericProdServiceAssoc
GenericCatalog.xlsx	CFG_LoadGeneric CpyModuleAssoc	CFG:LoadGeneric CpyModuleAssoc	CFG:GenericCompanyModuleAssoc
Geography.xlsx	CTM_Load PostalCodes	CTM:Load PostalCodes	CTM:PostalCodes
Location.xlsx	SIT_LoadSite	SIT:LoadSite	SIT:Site
Location.xlsx	SIT_LoadSiteAlias	SIT:LoadSiteAlias	SIT:Site Alias
Location.xlsx	CTM_LoadRegion	CTM:LoadRegion	CTM:Region
Location.xlsx	SIT_LoadSiteGroup	SIT:LoadSiteGroup	SIT:Site Group
Location.xlsx	SIT_LoadSite CompanyAssoc	SIT:LoadSite CompanyAssoc	SIT:Site Company Association
Operational Catalog.xlsx	CFG_Load ServiceCatalog	CFG:Load ServiceCatalog	CFG:Service Catalog
Operational Catalog.xlsx	CFG_LoadService CatalogAssoc	CFG:LoadService CatalogAssoc	CFG:Service Catalog Assoc
People.xlsx	CTM_Load PeopleTemplate	CTM:LoadPeople Template	CTM:People Template
People.xlsx	CTM_LoadPeople	CTM:LoadPeople	CTM:People User (if a Remedy Login ID is specified)
People.xlsx	CTM_LoadPeople TemplatePG	CTM:Load PeopleTemplatePG	CTM:People Template PG
People.xlsx	CTM_LoadPeople TemplateSG	CTM:LoadPeople TemplateSG	CTM:People Template SG
People.xlsx	CTM_LoadPeople TemplateSFR	CTM:LoadPeople TemplateSFR	CTM:SupportGroup FunctionalRole AP:Role
People.xlsx	CTM_LoadPeople Attributes	CTM:LoadPeople Attributes	CTM:Login ID
People.xlsx	CTM_LoadPeople Attributes	CTM:LoadPeople Attributes	CTM:People Wallet
People.xlsx	CTM_LoadPeople Attributes	CTM:LoadPeople Attributes	CTM:People HR Attendance Mgmt
People.xlsx	CTM_LoadPeople Attributes	CTM:LoadPeople Attributes	CTM:People HR Time Management
People.xlsx	CTM_LoadPeople Attributes	CTM:LoadPeople Attributes	CTM:People Education
People.xlsx	CTM_LoadPeople Attributes	CTM:LoadPeople Attributes	CTM:People Travel Profile
People.xlsx	CTM_LoadPeople Attributes	CTM:LoadPeople Attributes	CTM:People Benefit Info
People.xlsx	CTM_LoadPeople Attributes	CTM:LoadPeople Attributes	CTM:People IT Skills
People.xlsx	FIN_LoadCost CenterUDAAssoc	FIN:LoadCost CenterUDAAssoc	FIN:CostCenterUDAAssociations
People.xlsx	CTM_LoadPeople WorkLog	CTM:LoadPeople WorkLog	CTM:People WorkLog
People.xlsx	NTE_LoadCFG NotificationEvents	NTE:LoadCFG NotificationEvents	NTE:CFG-Notification Events
People.xlsx	CTM_LoadPeople PermissionGroups	CTM:LoadPeople PermissionGroups	CTM:PeoplePermission Groups
People.xlsx	CTM_LoadSupport GroupAssociation	CTM:LoadSupport GroupAssociation	CTM:Support Group Association
People.xlsx	CTM_LoadSupport GroupFunctionalRole	CTM:LoadSupport GroupFunctionalRole	CTM:SupportGroupFunctionalRole
PeopleOrg.xlsx	CTM_LoadPeople Organization	CTM:LoadPeople Organization	CTM:People Organization
Product Catalog.xlsx	PCT_Load ProductCatalog	PCT:Load ProductCatalog	PCT:Product Catalog
Product Catalog.xlsx	PCT_Load ProductAlias	PCT:Load ProductAlias	PCT:Product Alias
Product Catalog.xlsx	PCT_LoadProd ComAssoc	PCT:LoadProd ComAssoc	PCT:ProductCompanyAssociation
Product Catalog.xlsx	PCT_LoadProd ModelVersion	PCT:LoadProd ModelVersion	PCT:Product Model/Version
Product Catalog.xlsx	PCT_LoadModel VersionPatch	PCT:Load ModelVersionPatch	PCT:ModelVersion Patch
Product Catalog.xlsx	PCT_LoadProd CatAliasMapping	PCT:LoadProdCat AliasMapping	PCT:ProductCatalogAlias MappingForm
SupportGroup.xlsx	CTM_LoadSupport Group	CTM:LoadSupport Group	CTM:Support Group
SupportGroup.xlsx	CTM_Load SGPAssignments	CTM:Load SGPAssignments	CTM:Support Group Assignments
SupportGroup.xlsx	CTM_LoadSupport GroupAlias	CTM:LoadSupport GroupAlias	CTM:Support Group Alias
SupportGroup.xlsx	CTM_LoadSGPOnCall	CTM:LoadSGPOnCall	CTM:Support Group On-Call
SupportGroup.xlsx	CFG_LoadBusiness TimeWorkdays	CFG:Load Business TimeWorkdays	Business Time Workdays
SupportGroup.xlsx	CFG_LoadBusiness TimeHolidays	CFG:LoadBusiness TimeHolidays	CFG:Business Holidays Storage Business Time Holidays
SystemSetup.xlsx	NTE_LoadCFG PagerServiceConfig	NTE:LoadCFG PagerServiceConfig	NTE:CFG-Pager Service Config

Foundation data mapping

Comments