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.