HPF_TRTMNT_TEAM

Description:

The HPF_TRTMT_TEAM table contains information on 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 for the information associated with this record. Multiple pieces of information can be associated with this record.
2	BILLING_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
3	SERV_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
4	TRTMT_TM_BEGIN_DT	DATETIME (Local)	No
	The date and time a treatment team assignment began.
5	TRTMT_TM_END_DT	DATETIME (Local)	No
	The date and time a treatment team assignment ended.
6	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.