ASSIGN_CLINROLE_R



Column Section Top of Page


Table-level Detail

Description: Assignment / Clinical Role Relationship
Definition: This table will store relationships between assignment type and clinical roles.
Table Type: REFERENCE





Column Detail - ASSIGN_CLINROLE_R


Column Name Type Null? Definition
ASSIGNMENT_TYPE_CD DOUBLE N The assignment type code
ASSIGN_CR_RELTN_ID DOUBLE N Assignment Clinical Role Relation ID. Table primary key.
CLIN_ROLE_TYPE_CD DOUBLE N Clinical Role Code
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.


CN_DCP_SHIFT_ASSIGNMENT_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: CN DCP SHIFT ASSIGNMENT ST
Definition: Houses shift assignment information for legal reporting and QI purposes.
Table Type: ACTIVITY





Column Detail - CN_DCP_SHIFT_ASSIGNMENT_ST


Column Name Type Null? Definition
ASSIGNED_RELTN_TYPE_CD DOUBLE N The definition of the assignment that was made, (Charge Nurse, Secondary Nurse, On-Call Cardiologist, Sister, Brother).
ASSIGNMENT_GROUP_CD DOUBLE N The location group code for which this assignment was done, i.e. (Second Floor ICU, ED, etc.).
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CARETEAM_NAME VARCHAR(100) Y The name of the care team the provider was a member of for the purpose of this assignment.
CN_DCP_SHIFT_ASSIGNMENT_ST_ID DOUBLE N Unique identifier for assignment
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
END_EFFECTIVE_DT_TM DATETIME Y 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.
LOC_BED_CD DOUBLE N The bed location of the assignment.
LOC_BUILDING_CD DOUBLE N The building location of the assignment.
LOC_FACILITY_CD DOUBLE N The facility location of the assignment.
LOC_ROOM_CD DOUBLE N The room location of the assignment.
LOC_UNIT_CD DOUBLE N The nurse unit location of the assignment.
PCT_CARE_TEAM_ID DOUBLE N The Physician Care Team that this shift assignment pertains to.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRSNL_ID DOUBLE N The id of the user assigned by this row.
PRSNL_POS_CD DOUBLE N The position of the assigned provider at the time of the assignment.
RELATED_PERSON_ID DOUBLE N Supports relationships between a patient and a free-text person in Millennium, like Mother, Brother, Pastor, etc.
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 - CN_DCP_SHIFT_ASSIGNMENT_ST


Child Column in CN_DCP_SHIFT_ASSIGNMENT_ST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PCT_CARE_TEAM_ID PCT_CARE_TEAM PCT_CARE_TEAM_ID
PERSON_ID PERSON PERSON_ID
RELATED_PERSON_ID PERSON PERSON_ID
PRSNL_ID PRSNL PERSON_ID


DCP_CARE_TEAM



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP CARE TEAM
Definition: Shift assignment care teams.
Table Type: ACTIVITY





Column Detail - DCP_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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CARETEAM_ID DOUBLE N Unique id for care team.
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.
NAME VARCHAR(100) Y Display name for care 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 - DCP_CARE_TEAM




Parent Column in DCP_CARE_TEAM (PK) Child Table Name Child Column Name
Children: CARETEAM_ID DCP_CARE_TEAM_PRSNL CARETEAM_ID


DCP_CARE_TEAM_PRSNL



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP CARE TEAM PRSNL
Definition: Define prsnl on care team.
Table Type: ACTIVITY





Column Detail - DCP_CARE_TEAM_PRSNL


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CARETEAM_ID DOUBLE N Id of care team.
CARETEAM_PRSNL_ID DOUBLE N unique identifier
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.
PRSNL_ID DOUBLE N Id of prsnl on 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 - DCP_CARE_TEAM_PRSNL


Child Column in DCP_CARE_TEAM_PRSNL(FK) Parent Table Name Parent Column Name
Parents: CARETEAM_ID DCP_CARE_TEAM CARETEAM_ID


DCP_SHIFT_ASSIGNMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP SHIFT ASSIGNMENT
Definition: Shift locaition asssignments for users.
Table Type: ACTIVITY





Column Detail - DCP_SHIFT_ASSIGNMENT


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.
ASSIGNED_RELTN_TYPE_CD DOUBLE N The definition of the assignment that was made, (Charge Nurse, Secondary Nurse, On-Call Cardiologist, Sister, Brother).
ASSIGNMENT_GROUP_CD DOUBLE N The location group code for which this assignment was done, i.e. (Second Floor ICU, ED, etc.).
ASSIGNMENT_ID DOUBLE N Unique identifier for assignment
ASSIGNMENT_POS_CD DOUBLE N The position_cd of the user making the assignment. In conjunction with the assignment_group_cd it identifies a a set of assignments made for a particular department.(RN, LPN, etc.).
ASSIGN_TYPE_CD DOUBLE N Clinical venue or discipline for the assignment, (Nursing, Cardiology, Respiratory Therapy, etc.)
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CARETEAM_ID DOUBLE N The id of the care team that the assignment is for. If this field is set then prsnl_id should be 0.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
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.
LOC_BED_CD DOUBLE N Bed
LOC_BUILDING_CD DOUBLE N Building
LOC_FACILITY_CD DOUBLE N Facility
LOC_ROOM_CD DOUBLE N Room
LOC_UNIT_CD DOUBLE N Unit
PCT_CARE_TEAM_ID DOUBLE N The Physician Care Team that this shift assignment pertains to.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRSNL_ID DOUBLE N The id of the prsnl that the assignment is for. If this field is filled out the care team_id should be 0.
PURGE_IND DOUBLE Y The row is marked ready to purge once it has been migrated to the CN_DCP_SHIFT_ASSIGNMENT_ST table.
RELATED_PERSON_ID DOUBLE N Supports relationships between a patient and a free-text person in Millennium, like Mother, Brother, Pastor, etc.
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 - DCP_SHIFT_ASSIGNMENT


Child Column in DCP_SHIFT_ASSIGNMENT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
LOC_BED_CD LOCATION LOCATION_CD
LOC_BUILDING_CD LOCATION LOCATION_CD
LOC_FACILITY_CD LOCATION LOCATION_CD
LOC_ROOM_CD LOCATION LOCATION_CD
LOC_UNIT_CD LOCATION LOCATION_CD
PCT_CARE_TEAM_ID PCT_CARE_TEAM PCT_CARE_TEAM_ID
PERSON_ID PERSON PERSON_ID
RELATED_PERSON_ID PERSON PERSON_ID