HSP_PREADM_TEST

Description:

The HSP_PREADM_TEST table contains information on preadmission testing. Each record in 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	PAT_ID	VARCHAR	No
	The ID of the patient with this preadmission test.
2	LINE	INTEGER	No
	The line number of the preadmission test for the patient.
3	DEPARTMENT_ID	NUMERIC	No
	The ID of the department where the preadmission test is scheduled for the patient.
4	PREADM_TST_STAT_C_NAME	VARCHAR	No
	The category value corresponding to the status of the preadmission test for the patient. May contain organization-specific values: Yes Category Entries: Pending Requested Scheduled Incomplete Completed Cancelled NoShow
5	PROC_ID	VARCHAR	No
	The coded procedure of the preadmission test for the patient.
6	PREADM_APPT_NOTE	VARCHAR	No
	Free text note associated with preadmission test appointment for the patient.
7	PREADM_TST_PRI_C_NAME	VARCHAR	No
	The priority category of the preadmission test for the patient. May contain organization-specific values: Yes Category Entries: High Routine Low
8	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.