|
Name |
Type |
Discontinued? |
|
| 1 |
PAT_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table. |
|
|
| 2 |
LINE |
INTEGER |
No |
|
|
|
| The line number for the information associated with this record. Multiple pieces of information can be associated with this record. |
|
|
| 3 |
EXT_DEM_UPDATE_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| This column holds the instant that the associated patient's demographics were updated from an external system (Data Exchange Organization). |
|
|
| 4 |
EXT_DEM_UPDATE_ORG_ID |
NUMERIC |
No |
|
|
|
| This column holds the unique ID of the external system (Data Exchange Organization) from which we received the associated patient's demographic updates |
|
|
| 5 |
EXT_DEM_UPDATE_ORG_ID_EXTERNAL_NAME |
VARCHAR |
No |
|
|
|
| Organization's external name used as the display name on forms and user interfaces. |
|
|
