Foundation field mappings in Remedy ITSM and BMC Helix Platform
Before you load Foundation data from Remedy IT Service Management (Remedy ITSM) Suite to BMC Helix Platform, you might want to understand how Foundation data from fields in Remedy ITSM is mapped to fields in BMC Helix Platform. The Foundation data model differs between Remedy ITSM and BMC Helix Platform. Most fields from Remedy ITSM Foundation and mapped to fields in the BMC Helix Platform Foundation library.
Customers can refer this topic to understand which fields are mapped to the BMC Helix Platform Foundation library, and how they are mapped.
Field mappings in Company Foundation data
The following table provides information about Company, Person, and Site field mappings between Remedy ITSM and BMC Helix Platform:
BMC Helix Platform fields and their IDs | Remedy ITSM Suite fields and their IDs | Description |
|---|---|---|
BMC Helix Platform record definition—com.bmc.arsys.rx.foundation:Primary Organization (Common Base) | ||
Organization Name (1000000010) | Company (1000000001) | Commas replaced with space in translation. |
Status (7) | Status (7) | Remedy ITSM default status values that are provided out-of-the-box are mapped as is. |
Organization Description (1000000000) | Description (1000000000) | Mapped as is. |
Notification Email List (303500800) | Not applicable | Mapped as is. |
Primary Organization Type (304417291) | Client Type |
|
Budget Code (260100006) | Budget Code | Mapped as is. |
Organization Abbreviation (1000000071) | Company Abbreviation | Mapped as is. |
Organization Email (260000018) | Company Email | Mapped as is. |
Organization Hot Line (260000016) | Company Hiot Line (260000016) | Mapped as is. |
Company ID | Company ID | Mapped as is. |
Organization Web Page (260000019) | Company Web Page | Mapped as is. |
Cost Center (260100007) | Cost Center | Mapped as is. |
Currency (240600036) | Currency | Mapped as is. |
Hours of Operation (260100108) | Hours of Operation | Mapped as is. |
Lead Time in Days (260000013) | Lead Time (Days) | Mapped as is. |
Time Zone (240600035) | Time Zone | Out-of-the-box time zones from Remedy ITSM as mapped to matching IDs of time zones in BMC Helix Platform. |
Field mappings in Person Foundation data
The following table provides information about mapping of Person data in Remedy ITSM with BMC Helix Platform:
BMC Helix Platform field | Remedy ITSM field | Description |
|---|---|---|
BMC Helix Platform record definition—com.bmc.arsys.rx.foundation:Person (Base) | ||
Unique Person ID LEN(38) (179) | instanceId (179) |
|
Title (1000000021) | Title (304299880) |
|
First Name (1000000019) | First Name (1000000019) | Mapped as is. |
Preferred Name (1000000024) | Nick Name (1000000024) | Mapped as is. |
Middle Name (1000000020) | Middle Name (1000000020) | Mapped as is. |
Last Name (1000000018) | Last Name (1000000018) | Mapped as is. |
Employee Type (304410181) | Employee Type (304410181) | Only out-of-the-box values are taken. |
Employee ID (1000000054) | Corporate ID (1000000054) | Mapped as is. |
Job Title (1000000023) | Job Title (1000000023) | Mapped as is. |
NT Domain (420003300) | Not applicable | Not mapped from anywhere. |
Primary Phone Type (304409631) | Calculated Selection Field |
|
Primary Phone Number (1000000056) | Phone Number Business OR Phone Number Home OR Phone Number Mobile | Not applicable |
Primary Email Type (304409601) | Calculated Selection Field | In Remedy ITSM, if the Internet E-mail field is not null, it is set to Business. |
Primary Email Address (1000000048) | Internet E-mail | Mapped as is. |
Secondary Phone Type (304409621) | Calculated Selection Field | Depends on data Business if it exists. If the data Business does not exist, it is home if home-based user or mobile. |
Secondary Phone Number (1000000059) | Phone Number Business OR Phone Number Home OR Phone Number Mobile | Not applicable. |
Secondary Email Type (304409611) | Calculated Selection Field | In Remedy ITSM, if the Corporate E-mail field is not null, it is set to Other. |
Secondary Email Address LEN(255) (530013700) | Corporate E-mail | Mapped as is. |
VIP (1000000026) | VIP (1000000026) | Mapped as is. |
Sensitivity (1000000027) | Sensitivity (1000000027) | Mapped as is. |
Hire Date (304411651) | Not applicable | Not mapped |
Assignment Availability (1000000346) | Assignment Availability (1000000346) | Mapped as is. |
Notification Language (1000003974) | Notification Language (1000003974) | Out-of-the-box values for this field are mapped as is. |
Login ID (4) | Login ID (4) | Mapped as is. |
Password (123) | Password (in User form) | Mapped as is. |
License Type (109) | Not applicable | Set to Named. |
Default Notify Mechanism (430000003) | Default Notify Mechanism (430000003) | Mapped as is. |
Permissions (430000000) | Not applicable | Not mapped |
Functional Roles (430000002) | Unrestricted Access | If a person has Unrestricted Access, this functional role is granted in BMC Helix Platform. |
Application Licenses (430000001) | Not applicable | Not mapped |
Person Image (304411861) | Not applicable | Not mapped |
Status (7) | Status (7) | Mapped as is. |
Accounting Number (240000042) | Accounting Number | Mapped as is. |
Accounting Code (302006500) | Accounting Number 2 | Mapped as is. |
Cost Center (1000000188) | Cost Center | Mapped as is. |
Cost Center Code (300469300) | Cost Center Code | Mapped as is. |
Cost Center Name (300469200) | Cost Center Name | Mapped as is. |
Desk Location (1000000035) | Desk Location | Mapped as is. |
GEOnet (1000000046) | GEOnet (1000000046) | Not applicable |
Mail Station (1000000036) | Mail Station | Mapped as is. |
Association - Business Unit | Organization | Not applicable |
Association - Department | Department | Not applicable |
Agent | Support Staff | Mapped as is. |
Field mappings in Site Foundation data
The following table provides information about mapping of Site ITSM Foundation data with BMC Helix Platform:
BMC Helix Platform field | ITSM Suite field | Description |
|---|---|---|
BMC Helix Platform record definition—com.bmc.arsys.rx.foundation:Site (Base parent is com.bmc.arsys.rx.foundation:Location) | ||
Site Name (260000001) | Site (260000001) | Mapped as is. |
Site Description (1000000000) | Description (1000000000) | Mapped as is. |
Unique Site ID (179) | InstanceId (179) |
|
Site Type (304410811) | Not applicable |
|
Country (1000000002) | Country (1000000002) |
|
State, Province or District (1000000003) | State Province (1000000003) |
|
City (1000000004) | City (1000000004) |
Important: Cities are not loaded in BMC Helix Platform. You have to manually load the cities data. |
Street Address (1000000037) | Street (1000000037) | Mapped as is. |
ZIP/Postal Code (1000000039) | Not applicable |
|
Additional Site Details (1000001263) | Additional Site Details (1000001263) | Mapped as is. |
Time Zone (1000000541) | Not applicable | Out-of-the-box time zones from Remedy ITSM as mapped to matching IDs of time zones in BMC Helix Platform. |
Site Status (7) | Status (7) | Remedy ITSM standard values as mapped as is. |
Related topics
Leveraging-Remedy-ITSM-Foundation-data
Loading-and-verifying-Remedy-ITSM-Foundation-data
Creating-a-Pentaho-job-to-load-custom-Foundation-data