Table Detail Report

WF_STFG_SHIFT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Workforce staffing shift relationship
Definition: This table stored the relationship between the result of the predictive calculation to the shift included in the model itself.
Table Type: REFERENCE





Column Detail - WF_STFG_SHIFT_RELTN


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.
PREV_WF_STFG_SHIFT_RELTN_ID DOUBLE N Associates the workforce staffing to the previous workforce staffing
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_STFG_REQ_ID DOUBLE N Associates staffing requirements calculator data
WF_STFG_SHIFT_RELTN_ID DOUBLE N Uniquely identifies the workforce staffing



Relationship Detail - WF_STFG_SHIFT_RELTN


Child Column in WF_STFG_SHIFT_RELTN(FK) Parent Table Name Parent Column Name
Parents: TL_TIME_FRAME_ID TL_TIME_FRAME TL_TIME_FRAME_ID
WF_STFG_REQ_ID WF_STFG_REQ WF_STFG_REQ_ID
PREV_WF_STFG_SHIFT_RELTN_ID WF_STFG_SHIFT_RELTN WF_STFG_SHIFT_RELTN_ID




Parent Column in WF_STFG_SHIFT_RELTN (PK) Child Table Name Child Column Name
Children: WF_STFG_SHIFT_RELTN_ID WF_STFG_SHIFT_RELTN PREV_WF_STFG_SHIFT_RELTN_ID


WF_STFG_TIME



Column Section Relationship Section Top of Page


Table-level Detail

Description: Workforce staffing time
Definition: This table stored the relationship of the predictive calculation to when such calculation shall be executed.
Table Type: REFERENCE





Column Detail - WF_STFG_TIME


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.
COLLECTION_TM DOUBLE Y Collection time for generating a staffing recommendation
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_STFG_TIME_ID DOUBLE N Associates the staffing matrix processing time to the previous staffing matrix processing time
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 Associates staffing requirements calculator data
WF_STFG_TIME_ID DOUBLE N Uniquely identifies the staffing matrix processing time



Relationship Detail - WF_STFG_TIME


Child Column in WF_STFG_TIME(FK) Parent Table Name Parent Column Name
Parents: WF_STFG_REQ_ID WF_STFG_REQ WF_STFG_REQ_ID
PREV_WF_STFG_TIME_ID WF_STFG_TIME WF_STFG_TIME_ID




Parent Column in WF_STFG_TIME (PK) Child Table Name Child Column Name
Children: WF_STFG_TIME_ID WF_STFG_TIME PREV_WF_STFG_TIME_ID


WF_XFI_SHIFT_RESP



Column Section Top of Page


Table-level Detail

Description: Workforce Interface Shift Responsibility
Definition: This is a staging table storing the responsibilities associated to the shift coming from third party system.
Table Type: ACTIVITY





Column Detail - WF_XFI_SHIFT_RESP


Column Name Type Null? Definition
ACTION_FLAG DOUBLE Y Flag used to determine the type of action to apply to the record.
CONTRIBUTOR_CD DOUBLE N The contributor code is used when building an alias for a code_value to determine the matching alias.
PROCESS_FLAG DOUBLE Y Flag used to determine the status of the reocrd being processed.
RESPONSIBILITY_CD DOUBLE N The responsibility of the person for the specified shift.
RESPONSIBILITY_TXT VARCHAR(60) Y The responsibility of the person for the specified shift.
TRANSACTION_ID DOUBLE N Uniquely identifies a row on the wf_xfi_shift_resp table. Primary Key.
TRANS_PARENT_ID DOUBLE N Relates the workforce interface shift responsibility record to a specific workforce interface shift schedule record.
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_XFI_SHIFT_SCHED



Column Section Relationship Section Top of Page


Table-level Detail

Description: Workforce Interface Shift Schedule
Definition: This is a staging table storing the shift information coming from third party system.
Table Type: ACTIVITY





Column Detail - WF_XFI_SHIFT_SCHED


Column Name Type Null? Definition
ACTION_FLAG DOUBLE Y Used to determine the type of action to apply to the record.
ALIAS_POOL_CD DOUBLE N Alias Pool Code. Used to resolve the personnel.
ALIAS_POOL_TXT VARCHAR(60) Y Alias pool used to resolve the personnel.
CALL_SHIFT_IND DOUBLE Y Used to determine if the shift is a call shift or a standard shift. Typically patients are not assinged to a call shift.
CONTRIBUTOR VARCHAR(60) Y Contains the contributor source of the foreign system used to resolve code values.
CONTRIBUTOR_CD DOUBLE N Contributor source code.
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 VARCHAR(100) Y Contains the organization of the shift location.
ORGANIZATION_ID DOUBLE N Organization identifier. Used to uniquely identify the organization for this shift schedule.
PERSON_ALIAS VARCHAR(200) Y Person Alias. Alias that will be used to resolve to a millennium personnel.
PROCESS_FLAG DOUBLE Y Flag used to determine the status of the record being processed.
PRSNL_ID DOUBLE N Identifier of the personnel that is assigned to the shift.
PRSNL_LOCATION_CD DOUBLE N The home location of the personnel. This could be different than the shift location.
PRSNL_LOCATION_TXT VARCHAR(60) Y The home location of the personnel. This could be different than the shift location.
PRSNL_SHIFT_ROLE_CD DOUBLE N The role of the person for the shift.
PRSNL_SHIFT_ROLE_TXT VARCHAR(60) Y The role of the person for the shift.
SALARIED_PRSNL_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.
SHIFT_DESC VARCHAR(200) Y Free text description of the shift.
SHIFT_IDENT VARCHAR(100) Y Used to store the unique value to the shift in a foreign system.
SHIFT_LOCATION_CD DOUBLE N The location of the shift.
SHIFT_LOCATION_TXT VARCHAR(60) Y The locatin of the shift.
SHIFT_ROLE_CD DOUBLE N The role of the shift.
SHIFT_ROLE_TXT VARCHAR(60) Y 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.
TRANSACTION_ID DOUBLE N Uniquely identifies a row on the wf_xfi_shift_schedule table. Primary Key.
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 row on the WF_SHIFT_SCHED table related to each row on the WF_XFI_SHIFT_SCHED table.



Relationship Detail - WF_XFI_SHIFT_SCHED


Child Column in WF_XFI_SHIFT_SCHED(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PRSNL_ID PRSNL PERSON_ID
WF_SHIFT_SCHED_ID WF_SHIFT_SCHED WF_SHIFT_SCHED_ID