Mapping of BMC Helix Business Workflows fields to Foundation records
Field name changes
Form name | Field ID | Field name pre 21.3 | Field name from 21.3 onwards |
|---|---|---|---|
com.bmc.dsm.case-lib:Case | 300865500 | Template Name | Template ID |
com.bmc.dsm.case-lib:Case | 450000121 | Flowset | Flowset ID |
com.bmc.dsm.case-lib:Case | 450000155 | SITE_ID | Site |
com.bmc.dsm.case-lib:Case | 450000157 | ASSIGNED COMPANY_ID | Assigned Company |
com.bmc.dsm.case-lib:Case | 450000164 | External Email ID | External Requester Email ID |
com.bmc.dsm.case-lib:Case | 450000166 | REGION_ID | Region |
com.bmc.dsm.case-lib:Case | 450000381 | Assigned Business Unit | Assigned Support Organization |
com.bmc.dsm.case-lib:Case | 450000411 | Domain Tag | Line of Business |
com.bmc.dsm.case-lib:Case Assignment Mapping | 4 | Assignee | Assignee LoginID |
com.bmc.dsm.case-lib:Case Assignment Mapping | 450000153 | ASSIGNED COMPANY_ID | Assigned Company |
com.bmc.dsm.case-lib:Case Assignment Mapping | 450000155 | LOCATION COMPANY_ID | Location Company |
com.bmc.dsm.case-lib:Case Assignment Mapping | 450000156 | SITE_ID | Site |
com.bmc.dsm.case-lib:Case Assignment Mapping | 450000157 | REGION_ID | Region |
com.bmc.dsm.case-lib:Case Assignment Mapping | 450000381 | Business Unit | Support Organization |
com.bmc.dsm.case-lib:Case Audit | 300865500 | Template Name | Template ID |
com.bmc.dsm.case-lib:Case Audit | 450000121 | Flowset | Flowset ID |
com.bmc.dsm.case-lib:Case Audit | 450000155 | SITE_ID | Site |
com.bmc.dsm.case-lib:Case Audit | 450000157 | ASSIGNED COMPANY_ID | Assigned Company |
com.bmc.dsm.case-lib:Case Audit | 450000164 | External Email ID | External Requester Email ID |
com.bmc.dsm.case-lib:Case Audit | 450000166 | REGION_ID | Region |
com.bmc.dsm.case-lib:Case Audit | 450000381 | Assigned Business Unit | Assigned Support Organization |
com.bmc.dsm.case-lib:Case Audit | 450000411 | Domain Tag | Line of Business |
com.bmc.dsm.case-lib:Case Template | 4 | Assignee | Assignee LoginID |
com.bmc.dsm.case-lib:Case Template | 450000154 | ASSIGNED COMPANY_ID | Assigned Company |
com.bmc.dsm.case-lib:Case Template | 450000381 | Assignee Business Unit | Assignee Support Organization |
com.bmc.dsm.case-lib:Case Template | 450000401 | Owner Business Unit | Owner Support Organization |
com.bmc.dsm.knowledge:Content | 4 | Assignee | Assignee LoginID |
com.bmc.dsm.knowledge:Content | 450000381 | Business Unit | Support Organization |
com.bmc.dsm.knowledge:Knowledge Article | 4 | Assignee | Assignee LoginID |
com.bmc.dsm.knowledge:Knowledge Article | 200000007 | Region | Site Group |
com.bmc.dsm.knowledge:Knowledge Article | 200000012 | RegionLevel02 | Region Name |
com.bmc.dsm.knowledge:Knowledge Article | 301124400 | Reviewer | Reviewer LoginID |
com.bmc.dsm.knowledge:Knowledge Article | 450000381 | Business Unit | Support Organization |
com.bmc.dsm.knowledge:Knowledge Article | 450000401 | Reviewer Business Unit | Reviewer Support Organization |
com.bmc.dsm.knowledge:Knowledge Article | 450000411 | Domain Tag | Line of Business |
com.bmc.dsm.knowledge:Template Configuration | 450000420 | LOB Domain ID | Line of Business |
com.bmc.dsm.task-lib:Task | 450000121 | Flowset | Flowset ID |
com.bmc.dsm.task-lib:Task | 450000155 | SITE_ID | Site |
com.bmc.dsm.task-lib:Task | 450000157 | ASSIGNED COMPANY_ID | Assigned Company |
com.bmc.dsm.task-lib:Task | 450000164 | External Email ID | External Requester Email ID |
com.bmc.dsm.task-lib:Task | 450000166 | REGION_ID | Region |
com.bmc.dsm.task-lib:Task | 450000381 | Assigned Business Unit | Assigned Support Organization |
com.bmc.dsm.task-lib:Task | 450000411 | Domain Tag | Line of Business |
com.bmc.dsm.task-lib:Task Audit | 450000121 | Flowset | Flowset ID |
com.bmc.dsm.task-lib:Task Audit | 450000155 | SITE_ID | Site |
com.bmc.dsm.task-lib:Task Audit | 450000157 | ASSIGNED COMPANY_ID | Assigned Company |
com.bmc.dsm.task-lib:Task Audit | 450000164 | External Email ID | External Requester Email ID |
com.bmc.dsm.task-lib:Task Audit | 450000166 | REGION_ID | Region |
com.bmc.dsm.task-lib:Task Audit | 450000381 | Assigned Business Unit | Assigned Support Organization |
com.bmc.dsm.task-lib:Task Audit | 450000411 | Domain Tag | Line of Business |
com.bmc.dsm.task-lib:Task Template | 4 | Assignee | Assignee LoginID |
com.bmc.dsm.task-lib:Task Template | 450000153 | ASSIGNED COMPANY_ID | Assigned Company |
com.bmc.dsm.task-lib:Task Template | 450000381 | Assignee Business Unit | Assignee Support Organization |
com.bmc.dsm.task-lib:Task Template | 450000401 | Owner Business Unit | Owner Support Organization |
com.bmc.dsm.ticketing-lib:AttributeDefinition | 60021 | Write Permission | Read Permission |
com.bmc.dsm.ticketing-lib:Template | 450000381 | Assignee Business Unit | Assignee Support Organization |
com.bmc.dsm.ticketing-lib:Template | 450000401 | Owner Business Unit | Owner Support Organization |
com.bmc.dsm.ticketing-lib:Ticket | 450000121 | Flowset | Flowset ID |
com.bmc.dsm.ticketing-lib:Ticket | 450000155 | SITE_ID | Site |
com.bmc.dsm.ticketing-lib:Ticket | 450000157 | ASSIGNED COMPANY_ID | Assigned Company |
com.bmc.dsm.ticketing-lib:Ticket | 450000166 | REGION_ID | Region |
com.bmc.dsm.ticketing-lib:Ticket | 450000381 | Assigned Business Unit | Assigned Support Organization |
com.bmc.dsm.ticketing-lib:Ticket | 450000411 | Domain Tag | Line of Business |
Foundation field mappings from version 20.08 to 21.3 and later
Field | Steps in version 20.08 | Steps in version 21.3 and later | Source record |
|---|---|---|---|
Requester's Business Unit | Fetch Business Unit ID from Indirect Assoc with Node A = Req ID and Assoc ID = Person To BU > Fetch Organization Name from SecondaryOrganization with ID = BU ID | Fetch Organization from CTM:People where ID = Request ID | Case |
Requesters Manager | Fetch DIRECT MANAGER OF_ID from Person where ID = REQUESTER from case > query person where ID = DIRECT MANAGER OF_ID get Full Name | Fetch from CTM:People with Record ID = Requester from case -> get Manager's Name from output | Case |
Case Category Tier 1 2 3 4 | Search in com.bmc.arsys.rx.foundation:Operational Category where ID = Category Tier 1/2/3/4 | CFG:Service Catalog Domain Tag Copy Lookup use field Categorization Tier 1, Categorization Tier 2, Categorization Tier 3, Categorization Tier 4 | NA |
Requester's company | Fetch EMPLOYS_ID from com.bmc.arsys.rx.foundation:Person > query com.bmc.arsys.rx.foundation:Primary Organization get Organization Name | NA | NA |