CPR_CHANGE_HX
Description:
Table containing historical information about computerized patient records (CPRs).

Primary Key
Column Name Ordinal Position
PAT_ID 1
LINE 2

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 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 CPR_CHANGE_UTC_DTTM DATETIME (UTC) No
Stores the instant at which the patient's computerized patient record (CPR) is changed.
4 CPR_CHANGE_OLD_CPR VARCHAR No
Stores the old value of the computerized patient record (CPR) when it is changed.