HSP_ADMIT_PROC

Description: |
The HSP_ADMIT_PROC table contains information on admission procedures. This table is based on PAT_ENC_CSN_ID.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ENC_CSN_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | LINE | INTEGER | No |
The line number of the admission procedure for this patient.
2 | PROC_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
3 | ADMIT_PROC_TEXT | VARCHAR | No |
Free text admission procedure for the patient.
4 | ADMIT_PROC_DATE | DATETIME | No |
The date that the admission procedure is scheduled for the patient.
5 | PAT_ENC_CSN_ID | NUMERIC | No |
A unique serial number for this encounter. This number is unique across all patients and encounters in the system.
6 | ADM_PXDX_ASSOC | VARCHAR | No |
Used for ABN checks. A comma delimited list of line numbers that associate this procedure to a diagnosis.
7 | ADM_PX2ABN_LINK | VARCHAR | No |
A comma-delimited list of line numbers that indicate which ABN's are associated with this procedure.