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 |