HSP_PREADM_CONFRM
Description:
This table contains information on a confirmed preadmission. Each record in this table is based on patient contact serial number.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ID VARCHAR No
This column stores the unique identifier for the patient that was preadmission confirmed.
2 LINE INTEGER No
The line number of the preadmission confirmed for the patient.
3 PREADM_CONFRM_INST DATETIME (Local) No
Instant when the preadmission was confirmed.
4 PAT_ENC_CSN_ID NUMERIC No
This column stores the unique contact serial number for the encounter.