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 |