01Relates to the patient
reference data (no patient link)
Single-patient export: included in full (reference data).
02Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | PHARMACY_CODE PK | string | varchar(20) | no | |
| 2 | PHARMACY_NAME | string | varchar(40) | no | |
| 3 | ADDR1 | string | varchar(55) | yes | |
| 4 | ADDR2 | string | varchar(55) | yes | |
| 5 | CITY | string | varchar(30) | yes | |
| 6 | STATE | string | varchar(2) | yes | |
| 7 | ZIP | string | varchar(10) | yes | |
| 8 | COUNTRY_CODE | string | varchar(2) | yes | |
| 9 | string | varchar(254) | yes | ||
| 10 | COMMENT_TEXT | string | varchar(240) | yes | |
| 11 | ENTRY_DATE | datetime | datetime | no | |
| 12 | ENTRY_USER_ID | string | varchar(20) | no | |
| 13 | CHANGE_DATE | datetime | datetime | no | |
| 14 | CHANGE_USER_ID | string | varchar(20) | no |