WF_ACUITY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Workforce staffing time table |
Definition: | This table contains the (patient) acuity included in the predictive calculation of the number of staff requuired in the shift. |
Table Type: | REFERENCE |
Column Detail - WF_ACUITY
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. |
ACUITY_LEVEL | DOUBLE | Y | The associated acuity level to a workforce staffing |
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. |
CENSUS_CUTOFF_NBR | DOUBLE | N | Minimum number of patients that must be present before a category (refers to unit secretary, charge nurse) is needed. |
DESCRIPTION | VARCHAR(400) | Y | Description of the acuity level of workforce staffing |
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. |
PREV_WF_ACUITY_ID | DOUBLE | N | Associates the processing acuity level (times) of workforce staffing to the previous processing acuity level (times) of workforce staffing |
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. |
WF_ACUITY_ID | DOUBLE | N | Uniquely identifies the processing acuity level (times) of workforce staffing |
WF_STFG_REQ_ID | DOUBLE | N | Associates staffing requirements calculator data |
Relationship Detail - WF_ACUITY
Child Column in WF_ACUITY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PREV_WF_ACUITY_ID | WF_ACUITY | WF_ACUITY_ID |
WF_STFG_REQ_ID | WF_STFG_REQ | WF_STFG_REQ_ID |
Parent Column in WF_ACUITY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | WF_ACUITY_ID | WF_ACUITY | PREV_WF_ACUITY_ID |
WF_STFG_REQ_LINE | WF_ACUITY_ID |
WF_ROLE_SHIFT_INFO
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Workforce staffing shift-role information |
Definition: | This table contains the staffing role required for a particular shift. |
Table Type: | REFERENCE |
Column Detail - WF_ROLE_SHIFT_INFO
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. |
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. |
MAXIMUM_STAFF | DOUBLE | Y | Maximum staff allowed for a shift. |
MINIMUM_STAFF | DOUBLE | Y | Minumum staff allowed for a shift. |
PREV_WF_ROLE_SHIFT_ID | DOUBLE | N | Associates the staffing shift requirement of a specific location to the previous staffing shift requirement of a specific location |
ROLE_TYPE_CD | DOUBLE | N | Identifies the type of role associated to the staffing shift requirement of a specific location |
TL_TIME_FRAME_ID | DOUBLE | N | The associated task list time frame |
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. |
WF_ROLE_SHIFT_ID | DOUBLE | N | Uniquely identifies the staffing shift requirement of a specific location |
WF_STFG_REQ_ID | DOUBLE | N | Associates staffing requirements calculator data |
Relationship Detail - WF_ROLE_SHIFT_INFO
Child Column in WF_ROLE_SHIFT_INFO(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TL_TIME_FRAME_ID | TL_TIME_FRAME | TL_TIME_FRAME_ID |
WF_SHIFT_DISTRIBUTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Workforce shift distribution |
Definition: | Workforce table that will store the role type / shift percentage distribution. |
Table Type: | REFERENCE |
Column Detail - WF_SHIFT_DISTRIBUTION
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. |
DIST_TYPE | VARCHAR(25) | Y | The type of shift distribution; variable or fixed. |
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. |
PERCENT | DOUBLE | Y | Percentage of the shift distribution |
PREV_WF_SHIFT_DISTRIBUTION_ID | DOUBLE | N | Associates the role type / shift percentage distribution to the previous role type / shift percentage distribution. |
ROLE_TYPE_CD | DOUBLE | N | Identifies the type of role associated to the shift distribution. |
TL_TIME_FRAME_ID | DOUBLE | N | The associated task list time frame |
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. |
WF_SHIFT_DISTRIBUTION_ID | DOUBLE | N | Uniquely identifies the role type / shift percentage distribution. |
WF_STFG_REQ_ID | DOUBLE | N | Associates staffing requirements calculator data |
Relationship Detail - WF_SHIFT_DISTRIBUTION
Child Column in WF_SHIFT_DISTRIBUTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TL_TIME_FRAME_ID | TL_TIME_FRAME | TL_TIME_FRAME_ID |
PREV_WF_SHIFT_DISTRIBUTION_ID | WF_SHIFT_DISTRIBUTION | WF_SHIFT_DISTRIBUTION_ID | |
WF_STFG_REQ_ID | WF_STFG_REQ | WF_STFG_REQ_ID |
Parent Column in WF_SHIFT_DISTRIBUTION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | WF_SHIFT_DISTRIBUTION_ID | WF_SHIFT_DISTRIBUTION | PREV_WF_SHIFT_DISTRIBUTION_ID |
WF_SHIFT_RESP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Workforce Shift Responsibility |
Definition: | This table stores the responsibilities that are required for a shift. |
Table Type: | ACTIVITY |
Column Detail - WF_SHIFT_RESP
Column Name | Type | Null? | Definition |
---|---|---|---|
RESPONSIBILITY_CD | DOUBLE | N | The responsibility of the person working the shift. |
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. |
WF_SHIFT_RESP_ID | DOUBLE | N | An value assigned to uniquely identify a given workforce shift responsibility. |
WF_SHIFT_SCHED_ID | DOUBLE | N | Relates the workforce shift responsibility to a specific workforce shift schedule. |
Relationship Detail - WF_SHIFT_RESP
Child Column in WF_SHIFT_RESP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | WF_SHIFT_SCHED_ID | WF_SHIFT_SCHED | WF_SHIFT_SCHED_ID |
WF_SHIFT_SCHED
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Work Force Shift Schedule |
Definition: | This table stores the shifts created in workforce solution. |
Table Type: | ACTIVITY |
Column Detail - WF_SHIFT_SCHED
Column Name | Type | Null? | Definition |
---|---|---|---|
CALL_SHIFT_IND | DOUBLE | Y | Used to determine if the shift is a call shift or a standard shift. Typically patients are not assigned to a call shift. |
CREATE_APPLCTX | DOUBLE | N | The application context number from the record info block. |
CREATE_DT_TM | DATETIME | N | The date and time the record was created |
CREATE_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. |
CREATE_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted the row. |
END_DT_TM | DATETIME | Y | The end date/time of the shift. |
END_TZ | DOUBLE | Y | The time zone of the shift end. |
ORGANIZATION_ID | DOUBLE | N | The organization to which the shift is assigned. |
PRSNL_ID | DOUBLE | N | The unique identifier of the person assigned to the shift. |
PRSNL_LOCATION_CD | DOUBLE | N | The location of the person assigned to the shift. |
PRSNL_SHIFT_ROLE_CD | DOUBLE | N | The role of the person working the shift. |
SALARIED_PRSNL_IND | DOUBLE | Y | Used to determine if the personnel is a salaried employee. |
SHIFT_DESC | VARCHAR(200) | Y | Free text description of the shift. |
SHIFT_IDENT | VARCHAR(100) | Y | Stores the unique key to the shift in a foreign staff schduling system. |
SHIFT_LOCATION_CD | DOUBLE | N | The location of the shift. |
SHIFT_ROLE_CD | DOUBLE | N | The role of the shift. |
START_DT_TM | DATETIME | Y | The start date and time of the shift. |
START_TZ | DOUBLE | Y | The time zone used to determine the start of the shift. |
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. |
WF_SHIFT_SCHED_ID | DOUBLE | N | Uniquely identifies a workforce shift schedule. |
Relationship Detail - WF_SHIFT_SCHED
Child Column in WF_SHIFT_SCHED(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in WF_SHIFT_SCHED (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | WF_SHIFT_SCHED_ID | WF_SHIFT_RESP | WF_SHIFT_SCHED_ID |
WF_XFI_SHIFT_SCHED | WF_SHIFT_SCHED_ID |