Reltio DEA HCO Attributes Source Mapping
Each Reltio DEA HCO attribute is mapped with the HCO columns/attributes available in the source file.
Each Reltio DEA HCO attribute is mapped with the HCO columns/attributes available in the source file based on the column range.
| Reltio DEA HCO Attributes | HCO 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 Reltio Enrichment with DEA, the
For more information on
|
| 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 | |
| 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 | 228 to 229 | |
| Address.Zip.Zip5 | 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 HCOs are
A,B,D,E,F,H,J,K,L,N,P,R,S,T,U,W, and X.
| |||