|
Name |
Type |
Discontinued? |
|
1 |
PAT_ENC_CSN_ID |
NUMERIC |
No |
|
|
|
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI). |
|
|
2 |
LINE |
INTEGER |
No |
|
|
|
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact. |
|
|
3 |
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. |
|
|
4 |
CONTACT_DATE |
DATETIME |
No |
|
|
|
The date of this contact in calendar format. |
|
|
5 |
CM_CT_OWNER_ID |
VARCHAR |
No |
|
|
|
The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect. |
|
|
6 |
COORD_PLAN_AUDIT_EVENT_LINE |
INTEGER |
No |
|
|
|
This column indicates the line in the coordination plan audit trail that this service-specific audit data applies to. It can be used to join to DP_SVC_COORD_PLAN_AUDIT.LINE to link audit events together. Multiple rows of this table can join to the same line in DP_SVC_COORD_PLAN_AUDIT. |
|
|
7 |
PRIMARY_SVC_AUDIT_GROUPER_ID_GROUPER_NAME |
VARCHAR |
No |
|
|
|
|