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