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	NUMERIC	No
	The coded admission procedure for the patient.
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.