This documentation applies to the 8.1 version of Remedy IT Service Management Suite, which is in "End of Version Support." You will not be able to leave comments.

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.

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.

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

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

Comments

  1. Pat Zandi

    This is great...  however I do not see a list of Order...    you cannot import people if the Org Groups dont exsist... example is foundation data,,, (which does not have one either)...

    Mar 05, 2014 08:54
    1. Bruce Cane

      Hi Pat,

      I've added a link at the top of this page (and the other pages in this section) that point the reader to existing topics on the dependency, or order, of data loading. Included is a note alerting the reader that dependency is a consideration.

      Do you think this helps?

      Mar 11, 2014 11:52
  2. Bruce Cane

    Thanks for the suggestion, I'll put in a request to our subject matter experts to add this information to the page.

    Mar 05, 2014 11:24
  3. Krystian Nikolow

    CTM:PeoplePermission Groups form is duplicated

     

    Jun 13, 2014 03:52
    1. Bruce Cane

      Hello Krystian, ... thanks for pointing this out. I've removed the duplicate entry.

      Jun 16, 2014 11:35
  4. Theo Fondse

    Awesome! Thank you very much for this! 

    May 13, 2015 02:27
  5. David k Hill

    Wow...   This is handy!   Thank You!

     

    It may be really nice if there was one more column in the table to display the key linking field.  (Foreign) key.

    For example Company* for PeopleOrg, Location etc.. 

     

    -d

    Apr 05, 2016 06:38
    1. Priya Shetye

      Hello David,

      Thank you for your comment. I am working with the development team to update the information you require. I will update you soon.

      Regards,

      Priya

      Apr 14, 2016 05:55