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.