Reltio DEA HCP Attributes Source Mapping

Learn about the DEA HCP source mapping.

Each Reltio DEA HCP attribute is mapped with the HCP columns/attributes available in the source file, based on the column range.

Table 1. Reltio DEA HCP Attributes Source Mapping
Reltio DEA HCP Attributes HCP Columns/Attributes in DEA Source File Attributes Mapping Logic/Attributes Position in Column Range (1 to 237) Comments
Identifiers.Type   DEA Hard-coded
Identifiers.ID DEA Registration Number 1 to 9  
DEABusinessActivity Business Activity Code 10  
DEABusinessSubActivity Business Activity SubCode 235

In DEA data tenant, the DEABusinessActivityPlusSubCode attribute value is shown as the DEABusinessSubActivity attribute value.

For more information on DEABusinessActivityPlusSubCode attribute, see the below row.

DEABusinessActivityPlusSubCode   235

Derived after combining the Business Activity Code + Business Activity SubCode attributes values.

DEABusinessActivityDescription   Derived from DEA Business Activity Code + DEA Business Activity SubCode For more information, see related links at the bottom of the page.
Name Name 35 to 74

In source file, the Name attribute comprise details in the following sequence:

  1. Last Name
  2. First Name
  3. Middle Name
FirstName Name First Name The FirstName attribute is mapped only with the column range (of Name attribute) that represents First Name. The Last and Middle Name are not taken into consideration.
LastName Name Last Name The LastName attribute is mapped only with the column range (of Name attribute) that represents Last Name. The First and Middle Name are not taken into consideration.
AdditionalCompanyInfo Additional Company Info 75 to 114  
Payment Indicator Payment Indicator - P = Paid, E - Exempt 236  
Address.AddressLine1 Address 1 115 to 114  
Address.AddressLine2 Address 2 155 to 194  
Address.City City 195 to 227  
Address.StateProvince=State State 228 to 229  
Address.Zip.Zip5=Zip Code Zip Code 230 to 234  
Address.DEA.Number DEA Registration Number 1 to 9  
Address.DEA.DrugSchedule Drug Schedules 11 to 26  
Address.DEA.DrugScheduleDescription   Derived from Drug Schedule For more information, see related links at the bottom of the page.
Address.DEA.ExpirationDate Expiration Date 27 to 34  
Address.DEA.Status Status - A=Active, I= Inactive 237  
Note: Business Activity Codes applicable for HCPs are C and M.