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 |