HH_EPSD_ANC_PROV_HX
Description:
Contains audit information on the history of the Ancillary Providers.

Primary Key
Column Name Ordinal Position
SUMMARY_BLOCK_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 SUMMARY_BLOCK_ID NUMERIC No
The unique identifier for the episode record.
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 PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
4 ANC_PROV_COMMENT_HX VARCHAR No
History of the comments left about or for Ancillary Providers.
5 EDIT_USER_ID VARCHAR No
History of the user ID who entered the data about the Ancillary Providers.
6 EDIT_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
7 EDIT_USER_DTTM DATETIME (UTC) No
History of the instant the Ancillary Providers' data was edited.
8 EDIT_LINE INTEGER No
History of the line number of the Ancillary Provider whose data was edited. This is the line number found in column LINE of HH_EPSD_ANC_PROV.
9 ANC_PROV_REL_C_NAME VARCHAR No
History of the relationship to the patient for Ancillary Providers.
May contain organization-specific values: Yes
No Entries Defined
10 START_DATE DATETIME No
History of the start dates for Ancillary Providers.
11 END_DATE DATETIME No
History of the end dates for Ancillary Providers.