PAT_OR_PREV_ADMS
Description:
This table stores contact serial numbers (CSNs) of the admission contacts to which this OR contact was linked and then later got unlinked.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ENC_CSN_ID NUMERIC No
OR Contact Serial Number
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_ENC_DATE_REAL FLOAT No
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
4 CM_CT_OWNER_ID VARCHAR No
The community ID of the owner of this encounter.
5 OLD_LINKED_CSNS NUMERIC No
This column will store CSNs of the admission contacts to which this OR contact was linked and then later got unlinked.