ADMISSION_COMMENTS
Description:
This table contains the Admission Comments (I EPT 10155) for each patient

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
Contact serial number is unique accross all patients and all contacts
2 LINE INTEGER No
The Line Count
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 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.
5 CONTACT_DATE DATETIME No
The Contact Date for the Patient Record
6 ADMISSION_COMMENTS VARCHAR No
The admission comments entered for each patient.