|
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. |
|
|