DEA source file attributes
Learn how DEA attributes are presented in the source file.
The Reltio Enrichment with DEA updates the data tenant with the DEA Active Registrants weekly file. This table lists the attributes in the DEA file, which are arranged in columns ranging from 1 to 237.
| DEA Source File Attributes | Length of Attributes/Number of Characters | Position in Column Range (1 to 237) |
|---|---|---|
| DEA Registration Number | 9 | 1 to 9 |
| Business Activity Code | 1 | 10 |
| Drug Schedules | 16 | 11 to 26 |
| Expiration Date | 8 | 27 to 34 |
| Name (always contains data) | 40 | 35 to 74 |
| Additional Company Info (can be blank) | 40 | 75 to 114 |
| Address 1 (always contains data) | 40 | 115 to 154 |
| Address 2 (can be blank) | 40 | 155 to 194 |
| City, State, Zip (always contains data) | 40 | 195 to 234 |
| City | 33 | 195 to 227 |
| State | 2 | 228 to 229 |
| Zip Code | 5 | 230 to 234 |
| Business Activity Sub-Code | 1 | 235 |
| Payment Indicator (Exempt or Paid) | 1 | 236 |
| Activity (Active or Inactive) | 1 | 237 |