Table Detail Report

WF_STFG_HDR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Workforce staffing header
Definition: This table stores the header information of the predictive calculation model in Workforce solution.
Table Type: ACTIVITY





Column Detail - WF_STFG_HDR


Column Name Type Null? Definition
CENSUS DOUBLE Y Census at the time the staffing recommendation was generated.
COMMENT_TEXT VARCHAR(300) Y Text comments when manually submitting staffing requirements.
LOCATION_CD DOUBLE N Location of the staffing recommendation
MANUAL_IND DOUBLE N Indicates if the shift has been submitted manually or automatically by the system.
PENDING_ADMITS DOUBLE Y Pending admits coming into the location
PENDING_DISCHARGES DOUBLE Y Pending discharges leaving the location
QUEUE_ID DOUBLE N Identifies the record in the CQM_FSIESO_QUE table that is related to this staffing header record.
QUEUE_SUBMIT_DT_TM DATETIME Y The date and time the staffing recommended was sent to the ESO (External System Outbound) server.
REASON_CD DOUBLE N Reason the staffing recommendation was manually updated.
SHIFT_DT_TM DATETIME Y Date of the shift being recommended
SUBMITTED_DT_TM DATETIME Y Date and time the shift was submitted
SUBMITTED_PRSNL_ID DOUBLE N Personnel who submitted the shift
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.
USER_ADMITS DOUBLE Y Manually (user) entered pending admits
USER_DISCHARGES DOUBLE Y Manually (user) entered pending discharges
WF_STFG_HDR_ID DOUBLE N Uniquely identifies a workforce header of staffing requests.
WF_STFG_REQ_ID DOUBLE N Associates staffing requirements calculator data



Relationship Detail - WF_STFG_HDR


Child Column in WF_STFG_HDR(FK) Parent Table Name Parent Column Name
Parents: QUEUE_ID CQM_FSIESO_QUE QUEUE_ID
LOCATION_CD LOCATION LOCATION_CD
SUBMITTED_PRSNL_ID PRSNL PERSON_ID
TL_TIME_FRAME_ID TL_TIME_FRAME TL_TIME_FRAME_ID
WF_STFG_REQ_ID WF_STFG_REQ WF_STFG_REQ_ID




Parent Column in WF_STFG_HDR (PK) Child Table Name Child Column Name
Children: WF_STFG_HDR_ID WF_STFG_LINE WF_STFG_HDR_ID
WF_STFG_REQ_HDR_RELTN WF_STFG_HDR_ID


WF_STFG_LINE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Workforce staffing line
Definition: This table stores the line item information of the predictive calculation model in Workforce solution.
Table Type: ACTIVITY





Column Detail - WF_STFG_LINE


Column Name Type Null? Definition
RECOMMENDED_QTY DOUBLE Y The recommended number of staff for the shift; system determined.
ROLE_TYPE_CD DOUBLE N Identifies the type of role associated to the shift distribution.
SUBMITTED_QTY DOUBLE Y Number of staff submitted to the staffing system. Defaults from the recommended quantity, although can be overridden manually.
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_STFG_HDR_ID DOUBLE N Associated workforce header of staffing requests.
WF_STFG_LINE_ID DOUBLE N Uniquely identifies a staffing recommendation.



Relationship Detail - WF_STFG_LINE


Child Column in WF_STFG_LINE(FK) Parent Table Name Parent Column Name
Parents: WF_STFG_HDR_ID WF_STFG_HDR WF_STFG_HDR_ID


WF_STFG_REQ



Column Section Relationship Section Top of Page


Table-level Detail

Description: Workforce Staffing Requirements
Definition: This table stores the header information of the result of the predictive calculation after the calculation is executed against a specified date and time in workforce solution.
Table Type: REFERENCE





Column Detail - WF_STFG_REQ


Column Name Type Null? Definition
ACTIVE_CD DOUBLE N Active code for the staffing template.
ACTIVE_DT_TM DATETIME Y The date time the template was activated.
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.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ACUITY_IND DOUBLE Y Indicates the type of staffing calculator. 1 = acuity model, 0 = census model.
ADJ_CENSUS_IND DOUBLE Y Indicates if the staffing calculator will consider pending admits & discharges to calculate a total census. 1 = Accounts for pending admits / discharges 0 = No accout for pending admits / discharges
ALLOW_MOD_IND DOUBLE Y Indicates if the staffing recommendation can be manually updated. 1 = User allowed to modify staffing recommendations 0 = User not allowed to modify the recommended 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.
BUDGETED_CENSUS DOUBLE Y The budgeted census for a location
DESCRIPTION VARCHAR(200) Y Description of the staffing template.
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.
EXCLUDE_PREADMIT_IND DOUBLE N This indicator will determine whether pre-admit encounter will be excluded in the calculation of patient census.
LOCATION_CD DOUBLE N Location of the staffing recommendation
MANUAL_A_D_IND DOUBLE Y Indicates if pending admits and discharges can be manually captured when determining staffing requirements. 1 = User allowed to enter pending admits / discharges 0 = User not allowed to enter pending admits / discharges
NAME VARCHAR(60) Y Name of the staffing template
PREV_WF_STFG_REQ_ID DOUBLE N Associates the staffing requirements calculator data to the previous staffing requirements calculator data; used for versioning.
STATUS_CD DOUBLE N Determines the status of the staffing template
TASK_ASSAY_CD DOUBLE N Identifies the associated discrete element (task or assay)
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_STFG_REQ_ID DOUBLE N Identifies the staffing requirements calculator data



Relationship Detail - WF_STFG_REQ


Child Column in WF_STFG_REQ(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
LOCATION_CD LOCATION LOCATION_CD
PREV_WF_STFG_REQ_ID WF_STFG_REQ WF_STFG_REQ_ID




Parent Column in WF_STFG_REQ (PK) Child Table Name Child Column Name
Children: WF_STFG_REQ_ID WF_ACUITY WF_STFG_REQ_ID
WF_SHIFT_DISTRIBUTION WF_STFG_REQ_ID
WF_STFG_HDR WF_STFG_REQ_ID
WF_STFG_REQ PREV_WF_STFG_REQ_ID
WF_STFG_REQ_LINE WF_STFG_REQ_ID
WF_STFG_SHIFT_RELTN WF_STFG_REQ_ID
WF_STFG_TIME WF_STFG_REQ_ID


WF_STFG_REQ_HDR_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Workforce staffing header
Definition: This table stored the relationship between the predictive calculation model to the patient census (including manual adjustments entered) at the time the model was executed.
Table Type: ACTIVITY





Column Detail - WF_STFG_REQ_HDR_RELTN


Column Name Type Null? Definition
CENSUS DOUBLE Y Census for an acuity level at the time the staffing recommendation was generated.
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.
USER_ADMITS DOUBLE Y Manually (user) entered pending admits for a specific acuity level.
USER_DISCHARGES DOUBLE Y Manually (user) entered pending discharges for a specific acuity level.
WF_ACUITY_ID DOUBLE N Associated processing acuity level (times) of workforce staffing
WF_STFG_HDR_ID DOUBLE N Associated workforce header of staffing requests.
WF_STFG_REQ_HDR_RELTN_ID DOUBLE N Uniquely identifies a staffing request history.



Relationship Detail - WF_STFG_REQ_HDR_RELTN


Child Column in WF_STFG_REQ_HDR_RELTN(FK) Parent Table Name Parent Column Name
Parents: WF_STFG_HDR_ID WF_STFG_HDR WF_STFG_HDR_ID


WF_STFG_REQ_LINE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Workforce staffing requirements line
Definition: This table stores the line item information of the result of the predictive calculation after the calculation is executed against a specified date and time in workforce solution.
Table Type: REFERENCE





Column Detail - WF_STFG_REQ_LINE


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.
CENSUS_MULTIPLIER DOUBLE Y Census multiplier for a line
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.
HPPD DOUBLE Y Hours per patient day for a specific role
LINE_TYPE VARCHAR(40) Y Type of staffing requirement, e.g., variable, fixed, or budgeted
PREV_WF_STFG_REQ_LINE_ID DOUBLE N Associates line information for a staffing requirement to the previous line informatoin for a staffing requirement
ROLE_TYPE_CD DOUBLE N Identifies the type of role associated to the line staffing requirement.
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 Associated processing acuity level (times) of workforce staffing
WF_STFG_REQ_ID DOUBLE N Associates staffing requirements calculator data
WF_STFG_REQ_LINE_ID DOUBLE N Uniquely identifies line information for a staffing requirement



Relationship Detail - WF_STFG_REQ_LINE


Child Column in WF_STFG_REQ_LINE(FK) Parent Table Name Parent Column Name
Parents: WF_ACUITY_ID WF_ACUITY WF_ACUITY_ID
WF_STFG_REQ_ID WF_STFG_REQ WF_STFG_REQ_ID
PREV_WF_STFG_REQ_LINE_ID WF_STFG_REQ_LINE WF_STFG_REQ_LINE_ID




Parent Column in WF_STFG_REQ_LINE (PK) Child Table Name Child Column Name
Children: WF_STFG_REQ_LINE_ID WF_STFG_REQ_LINE PREV_WF_STFG_REQ_LINE_ID