TREATMENT_TEAM
Description:
This table stores information about patient treatment teams such as relationship, specialty, department, and start/end time. Each row represents a member of a patient's treatment team.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 TR_TEAM_BILL_PR_ID VARCHAR No
The unique ID of the billing provider record.
6 TR_TEAM_EM_CODE_ID NUMERIC No
The evaluation and management code for billing within the treatment team.
7 TR_TEAM_EM_REQ_C_NAME VARCHAR No
Used to determine if the evaluation and management code is required or not for use in the treatment team.
May contain organization-specific values: Yes
Category Entries:
Required
Not Applicable
8 TR_TEAM_SPEC_C_NAME VARCHAR No
The category value corresponding to the specialty of the treatment team member to the patient.
May contain organization-specific values: Yes
9 TR_TEAM_COMMENT VARCHAR No
The comment for the treatment team.
10 TR_TEAM_ISDE_YN VARCHAR No
Indicates whether or not this provider was deleted.
May contain organization-specific values: No
Category Entries:
No
Yes
11 TR_TEAM_ID VARCHAR No
The unique ID of the treatment team provider record.
12 TR_TEAM_REL_C_NAME VARCHAR No
The category value corresponding to the relationship of the treatment team member to the patient.
May contain organization-specific values: Yes
13 TR_TEAM_COMM_C_NAME VARCHAR No
Relates to communication being sent to the treatment team members.
May contain organization-specific values: No
Category Entries:
Yes
No
Sent
14 TR_TEAM_INFO_C_NAME VARCHAR No
Additional information related to the treatment team members.
May contain organization-specific values: Yes
No Entries Defined
15 TR_TEAM_BEG_DTTM DATETIME (Local) No
The date and time the treatment team member started for the patient.
16 TR_TEAM_END_DTTM DATETIME (Local) No
The date and time the treatment team member ended for the patient.
17 TR_TEAM_ED_YN VARCHAR No
Indicates whether or not this provider was on the treatment team in the ED.
The category values for this column were already listed for column: TR_TEAM_ISDE_YN
18 TR_TEAM_TEAM_ADD_YN VARCHAR No
Indicates whether the assignment was added by the team.
The category values for this column were already listed for column: TR_TEAM_ISDE_YN
19 TR_TEAM_SRC_CSN_ID NUMERIC No
This item stores the contact serial number corresponding to the encounter responsible for assigning a specific member of the treatment team. If you use IntraConnect, this is the Unique Contact Identifier (UCI).