HSP_TRTMT_TEAM

Description:

The HSP_TRTMT_TEAM table contains information on inpatient treatment teams. 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	LINE	INTEGER	No
	The line number of the treatment team member for the patient.
2	TRTMNT_TM_BEGIN_DT	DATETIME (Local)	No
	The date and time the treatment team member started for the patient.
3	TRTMNT_TM_END_DT	DATETIME (Local)	No
	The date and time the treatment team member ended for the patient.
4	TRTMNT_TM_ED_YN	VARCHAR	No
	Indicates whether or not this provider was on the treatment team in the ED. May contain organization-specific values: No Category Entries: No Yes
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	TEAM_ADD_YN	VARCHAR	No
	This stores whether the line was added by a team. The category values for this column were already listed for column: TRTMNT_TM_ED_YN