Table Detail Report

PCT_CARE_TEAM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Physician Care Team
Definition: Stores the current and historical build for the patient care teams, which are comprised of a Medical Service, a Personnel Group, an Encounter Personnel Relation, and Personnel.
Table Type: REFERENCE





Column Detail - PCT_CARE_TEAM


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEGIN_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is considered valid as active current data. This may be valued with the date that the row became active.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FACILITY_CD DOUBLE N The facility code of the care team
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
ORIG_PCT_TEAM_ID DOUBLE N Used to track versions of the care team information. This field will always point back to the original value created. This may be used to find the correct version when combined with the begin and end effective dates and times
PCT_CARE_TEAM_ID DOUBLE N Unique, generated number that identifies a single row on the PCT_CARE_TEAM table.
PCT_MED_SERVICE_CD DOUBLE N The medical service of the care team.
PCT_ROLE_CD DOUBLE N The role that the provider played for this encounter.
PCT_TEAM_CD DOUBLE N The team that belongs to the specified medical service.
PRSNL_ID DOUBLE N The personnel that is a member of the team.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - PCT_CARE_TEAM


Child Column in PCT_CARE_TEAM(FK) Parent Table Name Parent Column Name
Parents: FACILITY_CD LOCATION LOCATION_CD
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
ORIG_PCT_TEAM_ID PCT_CARE_TEAM PCT_CARE_TEAM_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in PCT_CARE_TEAM (PK) Child Table Name Child Column Name
Children: PCT_CARE_TEAM_ID CN_DCP_SHIFT_ASSIGNMENT_ST PCT_CARE_TEAM_ID
DCP_SHIFT_ASSIGNMENT PCT_CARE_TEAM_ID
PCT_CARE_TEAM ORIG_PCT_TEAM_ID
PCT_IPASS PCT_CARE_TEAM_ID