|
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 |
|
|
|
|
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. |
|
|