This documentation supports the 18.05 version of Remedy IT Service Management Suite.

To view the latest version, select the version from the Product version menu.

Foundation data mapping

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

Important

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

Spreadsheet

Tab

Staging form

Target form or forms

Company.xlsx

COM_LoadCompany

COM:LoadCompany

COM:Company

COM_LoadCompanyAlias

COM:LoadCompanyAlias

COM:CompanyAlias

Financials.xlsx


FIN_LoadConfigCostCentersRep

FIN:LoadConfigCostCentersRep

FIN:ConfigCostCentersRepository

FIN_LoadCostCenterUDAAssoc

FIN:LoadCostCenterUDAAssoc

FIN:CostCenterUDAAssociations

GenericCatalog.xlsx



CFG_LoadGenericCatalog

CFG:LoadGenericCatalog

CFG:GenericCatalog

CFG_LoadGenericProdSerAssoc

CFG:LoadGenericProdSerAssoc

CFG:GenericProdServiceAssoc

CFG_LoadGenericCpyModuleAssoc

CFG:LoadGenericCpyModuleAssoc

CFG:GenericCompanyModuleAssoc

Geography.xlsx

CTM_LoadPostalCodes

CTM:LoadPostalCodes

CTM:PostalCodes

Location.xlsx





SIT_LoadSite

SIT:LoadSite

SIT:Site

SIT_LoadSiteAlias

SIT:LoadSiteAlias

SIT:Site Alias

CTM_LoadRegion

CTM:LoadRegion

CTM:Region

SIT_LoadSiteGroup

SIT:LoadSiteGroup

SIT:SiteGroup

SIT_LoadSiteCompanyAssoc

SIT:LoadSiteCompanyAssoc

SIT:SiteCompanyAssociation

Operational Catalog.xlsx


CFG_LoadServiceCatalog

CFG:LoadServiceCatalog

CFG:ServiceCatalog

CFG_LoadServiceCatalogAssoc

CFG:LoadServiceCatalogAssoc

CFG:ServiceCatalogAssoc

People.xlsx



















CTM_LoadPeopleTemplate

CTM:LoadPeopleTemplate

CTM:PeopleTemplate

CTM_LoadPeople

CTM:LoadPeople

  • CTM:People
  • User (if a Remedy Login ID is specified)

CTM_LoadPeopleTemplatePG

CTM:LoadPeopleTemplatePG

CTM:PeopleTemplatePG

CTM_LoadPeopleTemplateSG

CTM:LoadPeopleTemplateSG

CTM:PeopleTemplateSG

CTM_LoadPeopleTemplateSFR

CTM:LoadPeopleTemplateSFR

  • CTM:SupportGroupFunctionalRole
  • AP:Role

CTM_LoadPeopleAttributes

CTM:LoadPeopleAttributes

CTM:LoginID

CTM_LoadPeopleAttributes

CTM:LoadPeopleAttributes

CTM:PeopleWallet

CTM_LoadPeopleAttributes

CTM:LoadPeopleAttributes

CTM:PeopleHRAttendanceMgmt

CTM_LoadPeopleAttributes

CTM:LoadPeopleAttributes

CTM:PeopleHRTimeManagement

CTM_LoadPeopleAttributes

CTM:LoadPeopleAttributes

CTM:PeopleEducation

CTM_LoadPeopleAttributes

CTM:LoadPeopleAttributes

CTM:PeopleTravelProfile

CTM_LoadPeopleAttributes

CTM:LoadPeopleAttributes

CTM:PeopleBenefitInfo

CTM_LoadPeopleAttributes

CTM:LoadPeopleAttributes

CTM:PeopleITSkills

FIN_LoadCostCenterUDAAssoc

FIN:LoadCostCenterUDAAssoc

FIN:CostCenterUDAAssociations

CTM_LoadPeopleWorkLog

CTM:LoadPeopleWorkLog

CTM:PeopleWorkLog

NTE_LoadCFGNotificationEvents

NTE:LoadCFGNotificationEvents

NTE:CFG-NotificationEvents

CTM_LoadPeoplePermissionGroups

CTM:LoadPeoplePermissionGroups

CTM:PeoplePermissionGroups

CTM_LoadSupportGroupAssociation

CTM:LoadSupportGroupAssociation

CTM:Support Group Association

CTM_LoadSupportGroupFunctionalRole

CTM:LoadSupportGroupFunctionalRole

CTM:SupportGroupFunctionalRole

CTM_LoadPeopleBundledGroupCTM:LoadPeopleBundledGroupCTM:PeopleBundledGroup

PeopleOrg.xlsx

CTM_LoadPeopleOrganization

CTM:LoadPeopleOrganization

CTM:PeopleOrganization

Product Catalog.xlsx






PCT_LoadProductCatalog

PCT:LoadProductCatalog

PCT:ProductCatalog

PCT_LoadProductAlias

PCT:LoadProductAlias

PCT:ProductAlias

PCT_LoadProdComAssoc

PCT:LoadProdComAssoc

PCT:ProductCompanyAssociation

PCT_LoadProdModelVersion

PCT:LoadProdModelVersion

PCT:Product Model/Version

PCT_LoadModelVersionPatch

PCT:LoadModelVersionPatch

PCT:ModelVersionPatch

PCT_LoadProdCatAliasMapping

PCT:LoadProdCatAliasMapping

PCT:ProductCatalogAliasMappingForm

SupportGroup.xlsx






CTM_LoadSupportGroup

CTM:LoadSupportGroup

CTM:SupportGroup

CTM_LoadSGPAssignments

CTM:LoadSGPAssignments

CTM:SupportGroupAssignments

CTM_LoadSupportGroupAlias

CTM:LoadSupportGroupAlias

CTM:SupportGroupAlias

CTM_LoadSGPOnCall

CTM:LoadSGPOnCall

CTM:SupportGroupOn-Call

CFG_LoadBusinessTimeWorkdays

CFG:LoadBusinessTimeWorkdays

Business Time Workdays

CFG_LoadBusinessTimeHolidays

CFG:LoadBusinessTimeHolidays

  • CFG:BusinessHolidaysStorage
  • BusinessTimeHolidays

SystemSetup.xlsx

NTE_LoadCFGPagerServiceConfig

NTE:LoadCFGPagerServiceConfig

NTE:CFG-PagerServiceConfig




Was this page helpful? Yes No Submitting... Thank you

Comments