HH_ADMN_PAT_DATA

Description:

Contains Home Health Admin task data for individual patient contacts.

Primary Key

Column Name	Ordinal Position
EMP_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	EMP_ID	VARCHAR	No
	The unique identifier of the administration record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	PATIENT_ID	VARCHAR	No
	Unique identifier for the patient. Links to table PATIENT.
4	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. Links to table PAT_ENC.
5	COMMENTS	VARCHAR	No
	Entry in the Admin task Comments field for the contact.
6	START_TIME	DATETIME (Local)	No
	Visit start time for encounter-based admin data.
7	END_TIME	DATETIME (Local)	No
	Visit end time for encounter-based admin data.
8	DRIVING_START_TIME	DATETIME (Local)	No
	Driving start time for encounter-based admin data.
9	DRIVING_END_TIME	DATETIME (Local)	No
	Driving end time for encounter-based admin data.