EXT_DATA_LAST_DONE

Description: |
This table stores the user and instant for the last time each external data type was marked as Done in Reconcile Outside Information.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ID | 1 |

Column Information

| 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 | EXTALG_D_UTC_DTTM | DATETIME (UTC) | No |
Instant that external allergies were last marked as reviewed.
3 | EXTALG_D_USER_ID | VARCHAR | No |
User who last marked external allergies as reviewed.
4 | EXTALG_D_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
5 | EXTMED_D_UTC_DTTM | DATETIME (UTC) | No |
Instant that external medications were last marked as reviewed.
6 | EXTMED_D_USER_ID | VARCHAR | No |
User who last marked external medications as reviewed.
7 | EXTMED_D_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
8 | EXTPRB_D_UTC_DTTM | DATETIME (UTC) | No |
Instant that external problems were last marked as reviewed.
9 | EXTPRB_D_USER_ID | VARCHAR | No |
User who last marked external problems as reviewed.
10 | EXTPRB_D_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
11 | EXTIMM_D_UTC_DTTM | DATETIME (UTC) | No |
Instant that external immunizations were last marked as reviewed.
12 | EXTIMM_D_USER_ID | VARCHAR | No |
User who last marked external immunizations as reviewed.
13 | EXTIMM_D_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
14 | EXTIMM_Q_UTC_DTTM | DATETIME (UTC) | No |
Instant (UTC) when external immunizations were last queried.