Query subjects S
Schedule
WFMBurst Burst Schedule Analysis
WFMStandard Scheduling
| Metadata model reference | Database reference |
|---|---|
| Schedule Name | SO_SCHEDULE.SKD_NAME |
| Schedule Description | SO_SCHEDULE.SKD_DESC |
| From Date | SO_SCHEDULE.SKD_from_DATE |
| To Date | SO_SCHEDULE.SKD_TO_DATE |
| Keys > SKD_ID | SO_SCHEDULE.SKD_ID |
| Foreign Keys > SKDGRP_ID | SO_SCHEDULE.SKDGRP_ID |
Schedule
Under . Fact table containing Schedule metrics for published schedules.
| Metadata model reference | Database reference |
|---|---|
| Scheduled Break Hours | EMPLOYEE_SCHED_DTL.BREAK_MINUTES / 60 |
| Scheduled Overtime Hours | EMPLOYEE_SCHED_DTL.OT_MINUTES / 60 |
| Scheduled Paid Hours | EMPLOYEE_SCHED_DTL.PAID_MINUTES / 60 |
| Scheduled Paid Time Off Hours | EMPLOYEE_SCHED_DTL.PAID_TIME_OFF_MINUTES / 60 |
| Scheduled Work Hours | EMPLOYEE_SCHED_DTL.WORKING_MINUTES / 60 |
| Total Scheduled Hours | EMPLOYEE_SCHED_DTL.TOTAL_MINUTES / 60 |
| Keys > EMP_ID | EMPLOYEE_SCHED_DTL.EMP_ID |
| Keys > ESCHD_STATUS | EMPLOYEE_SCHED_DTL.ESCHD_STATUS |
| Keys > ESCHD_TYPE | EMPLOYEE_SCHED_DTL.ESCHD_TYPE |
| Keys > ESCHD_WORK_DATE | EMPLOYEE_SCHED_DTL.ESCHD_WORK_DATE |
| Keys > TCODE_RPT_ISPRDCTV | EMPLOYEE_SCHED_DTL.TCODE_RPT_ISPRDCTV |
| Keys > WBT_ID | EMPLOYEE_SCHED_DTL.WBT_ID |
Schedule Budget
| Metadata model reference | Database reference |
|---|---|
| Date | SO_BUDGETING.BUDGET_DATE |
| Sales | SO_BUDGETING.SALES |
| Hours | SO_BUDGETING.HOURS |
| Payroll | SO_BUDGETING.PAYROLL |
| Foreign Keys > SKDGRP_ID | SO_BUDGETING.SKDGRP_ID |
Schedule Cost
| Metadata model reference | Database reference |
|---|---|
| Date | SO_SCHEDULE_COST.SKDCOST_DATE |
| Cost | SO_SCHEDULE_COST.SKDCOST_COST |
| Foreign Keys > SKD_ID | SO_SCHEDULE_COST.SKD_ID |
Schedule Cost Detail
| Metadata model reference | Database reference |
|---|---|
| Work Date | SCHED_COST_DETAIL.SCD_WORK_DATE |
| Minutes | SCHED_COST_DETAIL.SCD_MINUTES |
| Rate | SCHED_COST_DETAIL.SCD_RATE |
| Schedule Cost Detail UDFs > SCD_FLAG? | SCHED_COST_DETAIL.SCD_FLAG? |
| Schedule Cost Detail UDFs > SCD_UDF? | SCHED_COST_DETAIL.SCD_UDF? |
| Keys > SCD_ID | SCHED_COST_DETAIL.SCD_ID |
| Foreign Keys > DEPT_ID | SCHED_COST_DETAIL.DEPT_ID |
| Foreign Keys > DOCK_ID | SCHED_COST_DETAIL.DOCK_ID |
| Foreign Keys > EMP_ID | SCHED_COST_DETAIL.EMP_ID |
| Foreign Keys > HTYPE_ID | SCHED_COST_DETAIL.HTYPE_ID |
| Foreign Keys > JOB_ID | SCHED_COST_DETAIL.JOB_ID |
| Foreign Keys > PROJ_ID | SCHED_COST_DETAIL.PROJ_ID |
| Foreign Keys > SKDGRP_ID | SCHED_COST_DETAIL.SKDGRP_ID |
| Foreign Keys > TCODE_ID | SCHED_COST_DETAIL.TCODE_ID |
Schedule Period Definition
| Metadata model reference | Database reference |
|---|---|
| Schedule Period Name | SCHEDULE_PERIOD.SCPR_NAME |
| Schedule Period Duration | SCHEDULE_PERIOD.SCPR_DURATION |
| Schedule Period Start Date | SCHEDULE_PERIOD.SCPR_START_DATE |
| Keys > SCPR_ID | SCHEDULE_PERIOD.SCPR_ID |
| UDFs > SCPR_FLAG? | SCHEDULE_PERIOD.SCPR_FLAG? |
| UDFs > SCPR_UDF? | SCHEDULE_PERIOD.SCPR_UDF? |
Schedule Score
| Metadata model reference | Database reference |
|---|---|
| Budget | SO_SCHEDULE_SCORE.SKDSCORE_BUDGET |
| Service | SO_SCHEDULE_SCORE.SKDSCORE_SERVICE |
| Efficiency | SO_SCHEDULE_SCORE.SKDSCORE_EFFICNCY |
| Foreign Keys > SKD_ID | SO_SCHEDULE_SCORE.SKD_ID |
Schedule Template
| Metadata model reference | Database reference |
|---|---|
| Template Name | ES_SCHEDULE_TEMPLATE.TMPL_NAME |
| Template Description | ES_SCHEDULE_TEMPLATE.TMPL_DESC |
| Template Length | ES_SCHEDULE_TEMPLATE.TMPL_LENGTH |
| Template Create Date | ES_SCHEDULE_TEMPLATE.TMPL_CREATE_DATE |
| Template Start Date | ES_SCHEDULE_TEMPLATE.TMPL_START_DATE |
| Template End Date | ES_SCHEDULE_TEMPLATE.TMPL_END_DATE |
| Is Template Active | ES_SCHEDULE_TEMPLATE.TMPL_ACTIVE |
| UDFs > TMPL_FLAG? | ES_SCHEDULE_TEMPLATE.TMPL_FLAG? |
| UDFs > TMPL_UDF? | ES_SCHEDULE_TEMPLATE.TMPL_UDF? |
| Keys > TMPL_ID | ES_SCHEDULE_TEMPLATE.TMPL_ID |
| Foreign Keys > TMPL_PARENT_ID | ES_SCHEDULE_TEMPLATE.TMPL_PARENT_ID |
| Foreign Keys > TMPLTYP_ID | ES_SCHEDULE_TEMPLATE.TMPLTYP_ID |
| Foreign Keys > WBT_ID | ES_SCHEDULE_TEMPLATE.WBT_ID |
| Foreign Keys > WLT_ID | ES_SCHEDULE_TEMPLATE.WLT_ID |
Scheduled Shift
| Metadata model reference | Database reference |
|---|---|
| Date | EMPLOYEE_SCHED_DTL.ESCHD_WORK_DATE |
| Shift Start Time | EMPLOYEE_SCHED_DTL.ESCHD_START_TIME |
| Shift End Time | EMPLOYEE_SCHED_DTL.ESCHD_END_TIME |
| Scheduled Hours | EMPLOYEE_SCHED_DTL.ESCHD_MINUTES |
| Scheduled Minutes | EMPLOYEE_SCHED_DTL.ESCHD_MINUTES |
| Scheduled Type | EMPLOYEE_SCHED_DTL.ESCHD_TYPE |
| Rate | EMPLOYEE_SCHED_DTL.ESCHD_RATE |
| Quantity | EMPLOYEE_SCHED_DTL.ESCHD_QUANTITY |
| Status | EMPLOYEE_SCHED_DTL.ESCHD_STATUS |
| Schedule Published Flag | EMPLOYEE_SCHED_DTL.ESCHD_STATUS
Where ESCHD_STATUS = P. |
| Keys > EMP_ID | EMPLOYEE_SCHED_DTL.EMP_ID |
| Foreign Keys > ACT_ID | EMPLOYEE_SCHED_DTL.ACT_ID |
| Foreign Keys > DEPT_ID | EMPLOYEE_SCHED_DTL.DEPT_ID |
| Foreign Keys > DOCK_ID | EMPLOYEE_SCHED_DTL.DOCK_ID |
| Foreign Keys > HTYPE_ID | EMPLOYEE_SCHED_DTL.HTYPE_ID |
| Foreign Keys > JOB_ID | EMPLOYEE_SCHED_DTL.JOB_ID |
| Foreign Keys > PROJ_ID | EMPLOYEE_SCHED_DTL.PROJ_ID |
| Foreign Keys > STSKL_ID | EMPLOYEE_SCHED_DTL.STSKL_ID |
| Foreign Keys > TCODE_ID | EMPLOYEE_SCHED_DTL.TCODE_ID |
| Foreign Keys > WBT_ID | EMPLOYEE_SCHED_DTL.WBT_ID |
Scheduled Task
| Metadata model reference | Database reference |
|---|---|
| Job Name | JOBSKD_TASK.JSTSK_DESC |
| Java Class | JOBSKD_TASK.JSTSK_CLASS_NAME |
| Active | JOBSKD_TASK.JSTSK_ACTIVE |
| Last Run Time | JOBSKD_TASK.JSTSK_LST_STRT_TM |
| Next Run Time | Notes: The value of the Next Run Time query item is based on these conditions: • If the scheduled period is not set to 'Once' and the schedule has been previously executed, then the query will return the value from the JSTSK_NXT_RUN_TM column. • If the scheduled period is set to 'Once' and the schedule has been previously executed, then the query will return a NULL value. • For all other conditions, the query will return the next scheduled run time. |
| Schedule | Notes: The Schedule query item will return different values based on these different scheduled periods: • Daily • Weekly • Monthly • Once |
| Keys > JSTSK_ID | JOBSKD_TASK.JSTSK_ID |
Shift
WFMBurst Burst Work
WFMStandard Scheduling, Work
| Metadata model reference | Database reference |
|---|---|
| Shift Name | SHifT.SHFT_LOC_NAME |
| Shift Description | SHifT.SHFT_LOC_DESC |
| Start Time | SHifT.SHFT_START_TIME |
| End Time | SHifT.SHFT_END_TIME |
| Shift UDFs > SHFT_UDF? | SHifT.SHFT_UDF? |
| Shift UDFs > SHFT_VAL? | SHifT.SHFT_VAL? |
| Shift UDFs > SHFT_FLAG? | SHifT.SHFT_FLAG? |
| Keys > SHFT_ID | SHifT.SHFT_ID |
| Foreign Keys > SHFTGRP_ID | SHifT.SHFTGRP_ID |
Shift
Scheduling MVS > Shift Definition
| Metadata model reference | Database reference |
|---|---|
| Shift Display Label | ES_SHIFT_DISP_LABEL.ESSHIFTLAB_LABEL |
| Shift Description | ES_SHIFT.ESSHIFT_DESC |
| Shift Effective Start Date | ES_SHIFT_ATTRIBUTE.ESSHIFTATTR_EFF_START_DATE |
| Shift Effective End Date | ES_SHIFT_ATTRIBUTE.ESSHIFTATTR_EFF_END_DATE |
| Shift Start Time | ES_SHIFT_ATTRIBUTE.ESSHIFTATTR_START_TIME |
| Shift End Time | ES_SHIFT_ATTRIBUTE.ESSHIFTATTR_END_TIME |
| Apply to Sub Teams | ES_SHIFT.ESSHIFT_APPLYTO_SUB_TEAMS |
| Keys > ESSHIFT_ID | ES_SHIFT.ESSHIFT_ID |
| Keys > ESSHIFT_NAME | ES_SHIFT.ESSHIFT_NAME |
| Foreign Keys > ACT_ID | ES_SHIFT_ATTRIBUTE.ACT_ID |
| Foreign Keys > COLR_FONT_ID | ES_SHIFT_ATTRIBUTE.COLR_FONT_ID |
| Foreign Keys > ESSHIFTATTR_ID | ES_SHIFT_ATTRIBUTE.ESSHIFTATTR_ID |
| Foreign Keys > ESSHIFTLAB_ID | ES_SHIFT.ESSHIFTLAB_ID |
| Foreign Keys > SHFTYP_ID | ES_SHIFT_ATTRIBUTE.SHFTYP_ID |
| Foreign Keys > WBT_ID | ES_SHIFT.WBT_ID |
| Shift Attribute UDFs > ESSHIFTATTR_FLAG? | ES_SHIFT_ATTRIBUTE.ESSHIFTATTR_FLAG? |
| Shift Attribute UDFs > ESSHIFTATTR_UDF? | ES_SHIFT_ATTRIBUTE.ESSHIFTATTR_UDF? |
| UDFs > Shift Display Label UDFS > ESSHIFTLAB_FLAG? | ES_SHIFT_DISP_LABEL.ESSHIFTLAB_FLAG? |
| UDFs > Shift Display Label UDFS > ESSHIFTLAB_UDF? | ES_SHIFT_DISP_LABEL.ESSHIFTLAB_UDF? |
Shift Activity
| Metadata model reference | Database reference |
|---|---|
| Activity Name | SO_ACTIVITY.ACT_LOC_NAME |
| Activity Description | SO_ACTIVITY.ACT_LOC_DESC |
| Activity Type Name | ES_ACT_TYPE.ESACTTYPE_LOC_NAME |
| Activity Type Comments Required | ES_ACT_TYPE_MAP.ESACTTYPE_COMMENTS_REQUIRED |
| Activity Type Reason Required | ES_ACT_TYPE_MAP.ESACTTYPE_REASON_REQUIRED |
| Contributes to Cost | if (SO_ACTIVITY.ACT_CONT_TO_COST=1) then ('Y') else ('N') |
| Is Paid | if ( SO_ACTIVITY.ACT_PAID is null or SO_ACTIVITY.ACT_PAID = 0 ) then ( 'N' ) else ( 'Y' ) |
| Is Working | if ( SO_ACTIVITY.ACT_WORKING is null or SO_ACTIVITY.ACT_WORKING = 0 or SO_ACTIVITY.ACT_PAID = 0 ) then ( 'N' ) else ( 'Y' ) |
| Keys > ACT_ID | SO_ACTIVITY.ACT_ID |
| Keys > SKDGRP_ID | SO_ACTIVITY.SKDGRP_ID |
| Keys > TCODE_ID | SO_ACTIVITY.TCODE_ID |
Shift Break
| Metadata model reference | Database reference |
|---|---|
| Start Time | ES_SHIFT_BREAK.ESSHIFTBRK_START_TIME |
| End Time | ES_SHIFT_BREAK.ESSHIFTBRK_END_TIME |
| Keys > ESSHIFTBRK_ID | ES_SHIFT_BREAK.ESSHIFTBRK_ID |
| Foreign Keys > ACT_ID | ES_SHIFT_BREAK.ACT_ID |
| Foreign Keys > ESSHIFTATTR_ID | ES_SHIFT_BREAK.ESSHIFTATTR_ID |
| UDFs > ESSHIFTBRK_FLAG? | ES_SHIFT_BREAK.ESSHIFTBRK_FLAG? |
| UDFs > ESSHIFTBRK_UDF? | ES_SHIFT_BREAK.ESSHIFTBRK_UDF? |
Shift Day Part
| Metadata model reference | Database reference |
|---|---|
| Day Part Name | ES_SHIFT_DAY_PART.DP_NAME |
| Day Part Description | ES_SHIFT_DAY_PART.DP_DESC |
| Day Part Short Code | ES_SHIFT_DAY_PART.DP_SHORT_CODE |
| Day Part Start Time | ES_SHIFT_DAY_PART.DP_START_TIME |
| Day Part End Time | ES_SHIFT_DAY_PART.DP_END_TIME |
| Is Day Part Hidden | ES_SHIFT_DAY_PART.DP_HIDE |
| Is First Day Part | ES_SHIFT_DAY_PART.IS_FIRST_DP |
| UDFs > DP_FLAG? | ES_SHIFT_DAY_PART.DP_FLAG? |
| UDFs > DP_UDF? | ES_SHIFT_DAY_PART.DP_UDF? |
| Keys > ESSHIFTDP_ID | ES_SHIFT_DAY_PART.ESSHIFTDP_ID |
| Keys > DP_ID | ES_SHIFT_DAY_PART.DP_ID |
| Foreign Keys > ESSHIFTATTR_ID | ES_SHIFT_DAY_PART.ESSHIFTATTR_ID |
Shift Detail
| Metadata model reference | Database reference |
|---|---|
| Shift Detail Start Time | ES_SHIFT_DETAIL_LAYER.SDL_START_TIME |
| Shift Detail End Time | ES_SHIFT_DETAIL_LAYER.SDL_END_TIME |
| Shift Detail Hours | Calculated from ES_SHIFT_DETAIL_LAYER.SDL_START_TIMEand ES_SHIFT_DETAIL_LAYER.SDL_END_TIME |
| Keys > SDL_ID | ES_SHIFT_DETAIL_LAYER.SDL_ID |
| Foreign Keys > ACT_ID | ES_SHIFT_DETAIL_LAYER.ACT_ID |
| Foreign Keys > DEPT_ID | ES_SHIFT_DETAIL_LAYER.DEPT_ID |
| Foreign Keys > DOCK_ID | ES_SHIFT_DETAIL_LAYER.DOCK_ID |
| Foreign Keys > ESLVR_ID | ES_SHIFT_DETAIL_LAYER.ESLVR_ID |
| Foreign Keys > JOB_ID | ES_SHIFT_DETAIL_LAYER.JOB_ID |
| Foreign Keys > PROJ_ID | ES_SHIFT_DETAIL_LAYER.PROJ_ID |
| Foreign Keys > SDLTYPE_ID | ES_SHIFT_DETAIL_LAYER.SDLTYPE_ID |
| Foreign Keys > SHIFTLINK_ID | ES_SHIFT_DETAIL_LAYER.SHIFTLINK_ID |
| Foreign Keys > SHIFTSTAT_ID | ES_SHIFT_DETAIL_LAYER.SHIFTSTAT_ID |
| Foreign Keys > SHIFTSUM_ID | ES_SHIFT_DETAIL_LAYER.SHIFTSUM_ID |
| UDFs > SHIFTDTL_FLAG? | ES_SHIFT_DETAIL_LAYER.SHIFTDTL_FLAG? |
| UDFs > SHIFTDTL_UDF? | ES_SHIFT_DETAIL_LAYER.SHIFTDTL_UDF? |
Shift Detail Activity
| Metadata model reference | Database reference |
|---|---|
| Activity Name | SO_ACTIVITY.ACT_LOC_NAME |
| Activity Description | SO_ACTIVITY.ACT_LOC_DESC |
| Activity Type Name | ES_ACT_TYPE.ESACTTYPE_LOC_NAME |
| Activity Type Comments Required | ES_ACT_TYPE_MAP.ESACTTYPE_COMMENTS_REQUIRED |
| Activity Type Reason Required | ES_ACT_TYPE_MAP.ESACTTYPE_REASON_REQUIRED |
| Contributes to Cost | if (SO_ACTIVITY.ACT_CONT_TO_COST=1) then ('Y') else ('N') |
| Is Paid | if ( SO_ACTIVITY.ACT_PAID is null or SO_ACTIVITY.ACT_PAID = 0 ) then ( 'N' ) else ( 'Y' ) |
| Is Working | if ( SO_ACTIVITY.ACT_WORKING is null or SO_ACTIVITY.ACT_WORKING = 0 or SO_ACTIVITY.ACT_PAID = 0 ) then ( 'N' ) else ( 'Y' ) |
| Keys > ACT_ID | SO_ACTIVITY.ACT_ID |
| Keys > SKDGRP_ID | SO_ACTIVITY.SKDGRP_ID |
| Keys > TCODE_ID | SO_ACTIVITY.TCODE_ID |
Shift Detail Associated Parent Job
| Metadata model reference | Database reference |
|---|---|
| Job Name | JOB for ES_JOB_ASSOCIATION.JOB_NAME |
| Job Description | JOB for ES_JOB_ASSOCIATION.JOB_DESC |
| Is Job Tipped | JOB for ES_JOB_ASSOCIATION.JOB_TIP |
| Healthcare Type | JOB for ES_JOB_ASSOCIATION.JOB_RPT_HCTYPE |
| Job Association Rank | ES_JOB_ASSOCIATION.JOBASSOC_RANK |
| UDFs > JOB_FLAG? | JOB for ES_JOB_ASSOCIATION.JOB_FLAG? |
| UDFs > JOB_REFKEY? | JOB for ES_JOB_ASSOCIATION.JOB_REFKEY? |
| UDFs > JOB_VAL? | JOB for ES_JOB_ASSOCIATION.JOB_VAL? |
| UDFs > JOB_ASSOC_FLAG? | ES_JOB_ASSOCIATION.JOBASSOC_FLAG? |
| UDFs > JOB_ASSOC_UDF? | ES_JOB_ASSOCIATION.JOBASSOC_UDF? |
| Keys > JOB_ID | JOB for ES_JOB_ASSOCIATION.JOB_ID |
| Keys > JOBASSOC_ID | ES_JOB_ASSOCIATION.JOBASSOC_ID |
| Foreign Keys > JOB_CHILD_ID | ES_JOB_ASSOCIATION.JOB_CHILD_ID |
Shift Detail Department
| Metadata model reference | Database reference |
|---|---|
| Department Name | DEPARTMENT.DEPT_NAME |
| Department Description | DEPARTMENT.DEPT_DESC |
| Department Start Date | DEPARTMENT.DEPT_START_DATE |
| Department End Date | DEPARTMENT.DEPT_END_DATE |
| UDFs > DEPT_FLAG? | DEPARTMENT.DEPT_FLAG? |
| UDFs > DEPT_REFKEY? | DEPARTMENT.DEPT_REFKEY? |
| UDFs > DEPT_VAL? | DEPARTMENT.DEPT_VAL? |
| Keys > DEPT_ID | DEPARTMENT.DEPT_ID |
Shift Detail Docket
| Metadata model reference | Database reference |
|---|---|
| Docket Name | DOCKET.DOCK_NAME |
| Docket Description | DOCKET.DOCK_DESC |
| Start Date | DOCKET.DOCK_QTY |
| End Date | DOCKET.DOCK_STANDARD_QTY |
| Quantity | DOCKET.DOCK_STANDARD_DUR |
| Standard Duration | DOCKET.DOCK_PIECE_RATE |
| Standard Quantity | DOCKET.DOCK_START_DATE |
| Piece Rate | DOCKET.DOCK_END_DATE |
| UDFs > DOCK_FLAG? | DOCKET.DOCK_FLAG? |
| UDFs > DOCK_REFKEY? | DOCKET.DOCK_REFKEY? |
| UDFs > DOCK_UDF? | DOCKET.DOCK_UDF? |
| Keys > DOCK_ID | DOCKET.DOCK_ID |
Shift Detail Employee
| Metadata model reference | Database reference |
|---|---|
| Employee ID | EMPLOYEE.EMP_NAME |
| Full Name | EMPLOYEE.EMP_FULLNAME |
| First Name | EMPLOYEE.EMP_FIRSTNAME |
| Last Name | EMPLOYEE.EMP_LASTNAME |
| Is Full Time | EMPLOYEE.EMP_FULLTIME |
| Status | EMPLOYEE.EMP_STATUS |
| Is Home Team | SEC_EMPLOYEE.EMPT_HOME_TEAM |
| Base Rate | EMPLOYEE.EMP_BASE_RATE |
| Hire Rate | EMPLOYEE.EMP_HIRE_DATE |
| Effective Date | EMPLOYEE.EMP_EFFECTIVE_DATE |
| Termination Date | EMPLOYEE.EMP_TERMINIATION_DATE |
| Seniority Date | EMPLOYEE.EMP_SENIORITY_DATE |
| Birth Date | EMPLOYEE.EMP_BIRTH_DATE |
| SIN | EMPLOYEE.EMP_SIN |
| Shift Pattern Offset | EMPLOYEE.EMP_SHFTPAT_OFFSET |
| Default Minutes | EMPLOYEE.EMP_DEF_MINUTES |
| Full Time Equivalent | EMPLOYEE.EMP_FTE |
| Keys > EMP_ID | EMPLOYEE.EMP_ID |
| Keys > WBT_ID | SEC_EMPLOYEE.WBT_ID |
| Keys > TEAM_START_DATE | SEC_EMPLOYEE.START_DATE |
| Keys > TEAM_END_DATE | SEC_EMPLOYEE.END_DATE |
| UDFs > EMP_FLAG? | EMPLOYEE.EMP_FLAG? |
| UDFs > EMP_VAL? | EMPLOYEE.EMP_VAL? |
| Work Type > Work Type Name | EMPLOYEE_WORK_TYPE.EMPWRKTYP_NAME |
| Work Type > Work Type Description | EMPLOYEE_WORK_TYPE.EMPWRKTYP_DESC |
| Work Type > Work Type Full Time | EMPLOYEE_WORK_TYPE.EMPWRKTYP_FULLTIME |
| Work Type > Work Type Sort Order | EMPLOYEE_WORK_TYPE.EMPWRKTYP_SORTORDER |
| Work Type > Work Type UDFs > EMPWRKTYP_FLAG? | EMPLOYEE_WORK_TYPE.EMPWRKTYP_FLAG? |
| Work Type > Work Type UDFs > EMPWRKTYP_UDF? | EMPLOYEE_WORK_TYPE.EMPWRKTYP_UDF? |
| Employment Type > Employment Type Name | EMPLOYMENT_TYPE.EMPTYP_NAME |
| Employment Type > Employment Type Description | EMPLOYMENT_TYPE.EMPTYP_DESC |
| Employment Type > Employment Type Sort Order | EMPLOYMENT_TYPE.EMPTYP_SORTORDER |
| Employment Type > Employment Type UDFs > EMPTYPE_FLAG? | EMPLOYMENT_TYPE.EMPTYP_FLAG? |
| Employment Type > Employment Type UDFs > EMPTYPE_UDF? | EMPLOYMENT_TYPE.EMPTYP_UDF? |
Shift Detail Employee Team
| Metadata model reference | Database reference |
|---|---|
| Shift Detail Employee Team > Team Name | WORKBRAIN_TEAM.WBT_NAME |
| Shift Detail Employee Team > Team Description | WORKBRAIN_TEAM.WBT_DESC |
| Shift Detail Employee Team > Team Level | WORKBRAIN_TEAM.WBT_LEVEL |
| Shift Detail Emplpyee Team > Keys > WBT_ID | WORKBRAIN_TEAM.WBT_ID |
| Shift Detail Emplpyee Team > Keys > WBT_PARENT_ID | WORKBRAIN_TEAM.WBT_PARENT_ID |
| Shift Detail Emplpyee Team > Keys > WBT_START_DATE | SEC_WORKBRAIN_TEAM.WBUT_START_DATE |
| Shift Detail Emplpyee Team > Keys > WBT_END_DATE | SEC_WORKBRAIN_TEAM.WBUT_END_DATE |
| Team > Foreign Keys > CURRENT_TIMESTAMP | CURRENT_TIMESTAMP |
| Shift Detail Employee Team > UDFs > WBT_FLAG? | WORKBRAIN_TEAM.WBT_FLAG? |
| Shift Detail Emplpyee Team > UDFs > WBT_UDF? | WORKBRAIN_TEAM.WBT_UDF? |
Shift Detail Hour Type
WORKBRAIN_TEAM.WBT_UDF?
| Metadata model reference | Database reference |
|---|---|
| Hour Type | HOUR_TYPE.HTYPE_LOC_NAME |
| Hour Type Description | HOUR_TYPE.HTYPE_LOC_DESC |
| Hour Type YAG | HOUR_TYPE.HTYPE_YAG |
| Hour Type Multiple | HOUR_TYPE.HTYPE_MULITPLE |
| Is Overtime | HOUR_TYPE.HTYPE_RPT_ISOT |
| Hour Type UDFs > HTYPE_FLAG? | HOUR_TYPE.HTYPE_FLAG? |
| Hour Type UDFs > HTYPE_UDF? | HOUR_TYPE.HTYPE_UDF? |
| Keys > HTYPE_ID | HOUR_TYPE.HTYPE_ID |
| Keys > Htype Name | HOUR_TYPE.HTYPE_NAME |
Shift Detail Job
| Metadata model reference | Database reference |
|---|---|
| Job Name | JOB.JOB_NAME |
| Job Description | JOB.JOB_DESC |
| Tipped | JOB.JOB_TIP |
| Healthcare Type | JOB.JOB_RPT_HCTYPE |
| Job UDFs > JOB_FLAG? | JOB.JOB_FLAG? |
| Job UDFs > JOB_REFKEY? | JOB.JOB_REFKEY? |
| Job UDFs > JOB_VAL? | JOB.JOB_VAL? |
| Keys > JOB_ID | JOB.JOB_ID |
Shift Detail Layer Type
| Metadata model reference | Database reference |
|---|---|
| Shift Detail Type Name | ES_SHIFT_DETAIL_LAYER_TYPE.SDLTYPE_NAME |
| Shift Detail Type Description | ES_SHIFT_DETAIL_LAYER_TYPE.SDLTYPE_DESC |
| Keys > SDLTYPE_ID | ES_SHIFT_DETAIL_LAYER_TYPE.SDLTYPE_ID |
Shift Detail Project
| Metadata model reference | Database reference |
|---|---|
| Project Name | PROJECT.PROJ_NAME |
| Project Description | PROJECT.PROJ_DESC |
| Keys > PROJ_ID | PROJECT.PROJ_ID |
Shift Group
| Metadata model reference | Database reference |
|---|---|
| Shift Group Name | SHIFT_GROUP.SHFTGRP_NAME |
| Shift Group Description | SHIFT_GROUP.SHFTGRP_DESC |
| Keys > SHFTGRP_ID | SHIFT_GROUP.SHFTGRP_ID |
Shift Label Color
| Metadata model reference | Database reference |
|---|---|
| Color Name | COLOUR.COLR_NAME |
| Color Description | COLOUR.COLR_DESC |
| Color Value | COLOUR.COLR_VALUE |
| Keys > COLR_ID | COLOUR.COLR_ID |
Shift Link
| Metadata model reference | Database reference |
|---|---|
| Shift Link Comment | ES_SHIFT_LINK.SHIFTLINK_COMMENT |
| Shift Link Name | ES_LINK_TYPE.LINKTYPE_NAME |
| Keys > SHIFTLINK_ID | ES_SHIFT_LINK.SHIFTLINK_ID |
Shift Offer
| Metadata model reference | Database reference |
|---|---|
| Is Auto Approve Compliance Warning | ES_SHIFT_OFFER.ESSO_AUTOAPR_CMPLWRN |
| Shift Offer Date Time | ES_SHIFT_OFFER.ESSO_DATETIME |
| Shift Offer Duration | ES_SHIFT_OFFER.ESSO_DURATION |
| Keys > ESSO_ID | ES_SHIFT_OFFER.ESSO_ID |
| Foreign Keys > WBU_ID | ES_SHIFT_OFFER.WBU_ID |
| Foreign Keys > WBU_ID_ACTUAL | ES_SHIFT_OFFER.WBU_ID_ACTUAL |
| UDFs > ESSO_FLAG? | ES_SHIFT_OFFER.ESSO_FLAG? |
| UDFs > ESSO_UDF? | ES_SHIFT_OFFER.ESSO_UDF? |
Shift Offer Employee Shift
| Metadata model reference | Database reference |
|---|---|
| Shift Offer Employee Shift Rank | ES_SHIFT_OFFER_EMP_SHIFT.ESOESHFT_EMP_RANK |
| Keys > ESOESHFT_ID | ES_SHIFT_OFFER_EMP_SHIFT.ESOESHFT_ID |
| Foreign Keys > ESOSHFTSUM_ID | ES_SHIFT_OFFER_EMP_SHIFT.ESOSHFTSUM_ID |
| Foreign Keys > EMP_ID | ES_SHIFT_OFFER_EMP_SHIFT.EMP_ID |
| Foreign Keys > SSOFRSTAT_ID | ES_SHIFT_OFFER_EMP_SHIFT.SSOFRSTAT_ID |
| Foreign Keys > SSOFRREJRSN_ID | ES_SHIFT_OFFER_EMP_SHIFT.SSOFRREJRSN_ID |
| Foreign Keys > SSOFRCHNL_ID | ES_SHIFT_OFFER_EMP_SHIFT.SSOFRCHNL_ID |
| UDFs > ESOESHFT_FLAG? | ES_SHIFT_OFFER_EMP_SHIFT.ESOESHFT_FLAG? |
| UDFs > ESOESHFT_UDF? | ES_SHIFT_OFFER_EMP_SHIFT.ESOESHFT_UDF? |
Shift Offer Shift Summary
| Metadata model reference | Database reference |
|---|---|
| Shift Offer Shift Summary Ext Code | ES_SHIFT_OFFER_SHIFTSUM.ESOSHFTSUM_EXT_CODE |
| Is Shift Offer Shift Summary Cancelled | ES_SHIFT_OFFER_SHIFTSUM.ESOSHFTSUM_CANCELLED |
| Shift Offer Shift Summary Cancelled Date Time | ES_SHIFT_OFFER_SHIFTSUM.ESOSHFTSUM_CANCELLED_DATETIME |
| Keys > ESOSHFTSUM_ID | ES_SHIFT_OFFER_SHIFTSUM.ESOSHFTSUM_ID |
| Foreign Keys > ESSO_ID | ES_SHIFT_OFFER_SHIFTSUM.ESSO_ID |
| Foreign Keys > SHIFTSUM_ID | ES_SHIFT_OFFER_SHIFTSUM.SHIFTSUM_ID |
| Foreign Keys > WBU_ID | ES_SHIFT_OFFER_SHIFTSUM.WBU_ID |
| Foreign Keys > WBU_ID_ACTUAL | ES_SHIFT_OFFER_SHIFTSUM.WBU_ID_ACTUAL |
| UDFs > ESOSHFTSUM_FLAG? | ES_SHIFT_OFFER_SHIFTSUM.ESOSHFTSUM_FLAG? |
| UDFs > ESOSHFTSUM_UDF? | ES_SHIFT_OFFER_SHIFTSUM.ESOSHFTSUM_UDF? |
Shift Pattern
| Metadata model reference | Database reference |
|---|---|
| Shift Pattern Name | SHifT_PATTERN.SHFTPAT_LOC_NAME |
| Shift Pattern Description | SHifT_PATTERN.SHFTPAT_LOC_DESC |
| Start Date | SHifT_PATTERN.SHFTPAT_START_DATE |
| Shift Pattern UDFs > SHFTPAT_UDF? | SHifT_PATTERN.SHFTPAT_UDF? |
| Shift Pattern UDFs > SHFTPAT_VAL? | SHifT_PATTERN.SHFTPAT_VAL? |
| Shift Pattern UDFs > SHFTPAT_FLAG? | SHifT_PATTERN.SHFTPAT_FLAG? |
| Keys > SHFTPAT_ID | SHifT_PATTERN.SHFTPAT_ID |
| Foreign Keys > SHFTGRP_ID | SHifT_PATTERN.SHFTGRP_ID |
Shift Pattern Shifts
| Metadata model reference | Database reference |
|---|---|
| Shift Definitions > Shift Pattern Shifts > Day | SHifT_PAT_SHifTS.SHFTPATSHFT_DAY |
| Shift Definitions > Shift Pattern Shifts > Foreign Keys > SHFT_ID | SHifT_PAT_SHifTS.SHFT_ID |
| Shift Definitions > Shift Pattern Shifts > Foreign Keys > SHFTPAT_ID | SHifT_PAT_SHifTS.SHFT_PAT_ID |
Shift Preference Detail
| Metadata model reference | Database reference |
|---|---|
| Shift Preference Date | ES_SHIFTPREF_DETAIL.SPD_DATE |
| Keys > SPD_ID | ES_SHIFTPREF_DETAIL.SPD_ID |
| Foreign Keys > DAY_ID | ES_SHIFTPREF_DETAIL.DAY_ID |
| Foreign Keys > DP_ID | ES_SHIFTPREF_DETAIL.DP_ID |
| Foreign Keys > SHFTTYP_ID | ES_SHIFTPREF_DETAIL.SHFTTYP_ID |
| Foreign Keys > SHIFTPREFTYP_ID | ES_SHIFTPREF_DETAIL.SHIFTPREFTYP_ID |
| Foreign Keys > SPS_ID | ES_SHIFTPREF_DETAIL.SPS_ID |
| UDFs > SPD_FLAG? | ES_SHIFTPREF_DETAIL.SPD_FLAG? |
| UDFs > SPD_UDF? | ES_SHIFTPREF_DETAIL.SPD_UDF? |
Shift Preference Detail (History)
| Metadata model reference | Database reference |
|---|---|
| Shift Preference Detail (History) > Shift Preference Date | ES_SHIFTPREF_DETAIL_HISTORY.SPDHIST_DATE |
| Shift Preference Detail (History) > Keys > SPD_ID | ES_SHIFTPREF_DETAIL_HISTORY.SPDHIST_ID |
| Shift Preference Detail (History) > Foreign Keys > DAY_ID | ES_SHIFTPREF_DETAIL_HISTORY.DAY_ID |
| Shift Preference Detail (History) > Foreign Keys > DP_ID | ES_SHIFTPREF_DETAIL_HISTORY.DP_ID |
| Shift Preference Detail (History) > Foreign Keys > SHFTTYP_ID | ES_SHIFTPREF_DETAIL_HISTORY.SHFTTYP_ID |
| Shift Preference Detail (History) > Foreign Keys > SHIFTPREFTYP_ID | ES_SHIFTPREF_DETAIL_HISTORY.SHIFTPREFTYP_ID |
| Shift Preference Detail (History) > Foreign Keys > SPDHIST_SPD_ID | ES_SHIFTPREF_DETAIL_HISTORY.SPDHIST_SPD_ID |
| Shift Preference Detail (History) > Foreign Keys > SPDHIST_SPS_ID | ES_SHIFTPREF_DETAIL_HISTORY.SPDHIST_SPS_ID |
| Shift Preference Detail (History) > Foreign Keys > SPDHIST_ID | ES_SHIFTPREF_DETAIL_HISTORY.SPDHIST_SPS_ID |
| Shift Preference Detail (History) > UDFs > SPD_FLAG? | ES_SHIFTPREF_DETAIL_HISTORY.SPDHIST_FLAG? |
| Shift Preference Detail (History) > UDFs > SPD_UDF? | ES_SHIFTPREF_DETAIL_HISTORY.SPDHIST_UDF? |
Shift Preference Input Type
| Metadata model reference | Database reference |
|---|---|
| Shift Preference Input Type Name | ES_SHIFTPREF_TYPE.SPTYP_NAME |
| Shift Preference Input Type Description | ES_SHIFTPREF_TYPE.SPTYP_DESC |
| Keys > SPTYP_ID | ES_SHIFTPREF_TYPE.SPTYP_ID |
| UDFs > SPTYP_FLAG? | ES_SHIFTPREF_TYPE.SPTYP_FLAG? |
| UDFs > SPTYP_UDF? | ES_SHIFTPREF_TYPE.SPTYP_UDF? |
Shift Preference Summary
| Metadata model reference | Database reference |
|---|---|
| Shift Preference Comment | ES_SHIFTPREF_SUMMARY.SPS_COMMENT |
| Shift Preference Start Date | ES_SHIFTPREF_SUMMARY.SPS_START_DATE |
| Shift Preference End Date | ES_SHIFTPREF_SUMMARY.SPS_END_DATE |
| Shift Preference Created Date | ES_SHIFTPREF_SUMMARY.SPS_CREATED_DATE |
| Shift Preference Active Date | ES_SHIFTPREF_SUMMARY.SPS_ACTIVE_DATE |
| Is Shift Preference Active | ES_SHIFTPREF_SUMMARY.SPS_ACTIVE |
| Is Shift Preference Submitted Late | ES_SHIFTPREF_SUMMARY.SPS_SUBMITTED_LATE |
| Keys > SPS_ID | ES_SHIFTPREF_SUMMARY.SPS_ID |
| Foreign Keys > EMP_ID | ES_SHIFTPREF_SUMMARY.EMP_ID |
| Foreign Keys > SPS_PARENT_ID | ES_SHIFTPREF_SUMMARY.SPS_PARENT_ID |
| Foreign Keys > SPTYP_ID | ES_SHIFTPREF_SUMMARY.SPTYP_ID |
| Foreign Keys > WBT_ID | ES_SHIFTPREF_SUMMARY.WBT_ID |
| Foreign Keys > WBU_ID_ACTUAL_APPROVER | ES_SHIFTPREF_SUMMARY.WBU_ID_ACTUAL_APPROVER |
| Foreign Keys > WBU_ID_ACTUAL_SUBMITTER | ES_SHIFTPREF_SUMMARY.WBU_ID_ACTUAL_SUBMITTER |
| Foreign Keys > WBU_ID_APPROVER | ES_SHIFTPREF_SUMMARY.WBU_ID_APPROVER |
| Foreign Keys > WBU_ID_SUBMITTER | ES_SHIFTPREF_SUMMARY.WBU_ID_SUBMITTER |
| UDFs > SPS_FLAG? | ES_SHIFTPREF_SUMMARY.SPS_FLAG? |
| UDFs > SPS_UDF? | ES_SHIFTPREF_SUMMARY.SPS_UDF? |
Shift Preference Summary (History)
| Metadata model reference | Database reference |
|---|---|
| Shift Preference Comment | ES_SHIFTPREF_SUMMARY.SPS_COMMENT |
| Shift Preference Start Date | ES_SHIFTPREF_SUMMARY.SPS_START_DATE |
| Shift Preference End Date | ES_SHIFTPREF_SUMMARY.SPS_END_DATE |
| Shift Preference Created Date | ES_SHIFTPREF_SUMMARY.SPS_CREATED_DATE |
| Shift Preference Active Date | ES_SHIFTPREF_SUMMARY.SPS_ACTIVE_DATE |
| Is Shift Preference Active | ES_SHIFTPREF_SUMMARY.SPS_ACTIVE |
| Is Shift Preference Submitted Late | ES_SHIFTPREF_SUMMARY.SPS_SUBMITTED_LATE |
| Keys > SPS_ID | ES_SHIFTPREF_SUMMARY.SPS_ID |
| Foreign Keys > EMP_ID | ES_SHIFTPREF_SUMMARY.EMP_ID |
| Foreign Keys > SPS_PARENT_ID | ES_SHIFTPREF_SUMMARY.SPS_PARENT_ID |
| Foreign Keys > SPTYP_ID | ES_SHIFTPREF_SUMMARY.SPTYP_ID |
| Foreign Keys > WBT_ID | ES_SHIFTPREF_SUMMARY.WBT_ID |
| Foreign Keys > WBU_ID_ACTUAL_APPROVER | ES_SHIFTPREF_SUMMARY.WBU_ID_ACTUAL_APPROVER |
| Foreign Keys > WBU_ID_ACTUAL_SUBMITTER | ES_SHIFTPREF_SUMMARY.WBU_ID_ACTUAL_SUBMITTER |
| Foreign Keys > WBU_ID_APPROVER | ES_SHIFTPREF_SUMMARY.WBU_ID_APPROVER |
| Foreign Keys > WBU_ID_SUBMITTER | ES_SHIFTPREF_SUMMARY.WBU_ID_SUBMITTER |
| UDFs > SPS_FLAG? | ES_SHIFTPREF_SUMMARY.SPS_FLAG? |
| UDFs > SPS_UDF? | ES_SHIFTPREF_SUMMARY.SPS_UDF? |
Shift Preference Type
| Metadata model reference | Database reference |
|---|---|
| Shift Preference Type Name | ES_SHIFTPREF_PREF_TYPE.SHIFTPREFTYP_NAME |
| Shift Preference Type Description | ES_SHIFTPREF_PREF_TYPE.SHIFTPREFTYP_DESC |
| Shift Preference Type Short Code | ES_SHIFTPREF_PREF_TYPE.SHIFTPREFTYP_SHORT_CODE |
| Keys > SHIFTPREFTYP_ID | ES_SHIFTPREF_PREF_TYPE.SHIFTPREFTYP_ID |
Shift Property
| Metadata model reference | Database reference |
|---|---|
| Shift Property Name | ES_SHIFT_PROP_DEF.ESSHIFTPROP_NAME |
| Shift Property Description | ES_SHIFT_PROP_DEF.ESSHIFTPROP_DESC |
| Shift Property Value | ES_SHIFT_PROP_DATA.ESSHIFTPROPD_VALUE |
| Keys > ESSHIFTPROP_ID | ES_SHIFT_PROP_DATA.ESSHIFTPROP_ID |
| Foreign Keys > ESSSHIFTATTR_ID | ES_SHIFT_PROP_DATA.ESSHIFTATTR_ID |
| Foreign Keys > PARMTYP_ID | ES_SHIFT_PROP_DEF.PARMTYP_ID |
| UDFs > ESSHIFTPROP_FLAG? | ES_SHIFT_PROP_DEF.ESSHIFTPROP_FLAG? |
| UDFs > ESSHIFTPROP_UDF? | ES_SHIFT_PROP_DEF.ESSHIFTPROP_UDF? |
Shift Requirement Skills
| Metadata model reference | Database reference |
|---|---|
| Is Skills Mandatory | ES_TMPL_SHIFT_REQ_SHIFT_SKL.ETSHRSSKL_MANDATORY |
| Skill Weight | ES_TMPL_SHIFT_REQ_SHIFT_SKL.ETSHRSSKL_REQ_SKILL_WEIGHT |
| Keys > ETSHRSSKL_ID | ES_TMPL_SHIFT_REQ_SHIFT_SKL.ETSHRSSKL_ID |
| Foreign Keys > ETSHRS_ID | ES_TMPL_SHIFT_REQ_SHIFT_SKL.ETSHRS_ID |
| Foreign Keys > STSKL_ID | ES_TMPL_SHIFT_REQ_SHIFT_SKL.STSKL_ID |
Shift Requirements
| Metadata model reference | Database reference |
|---|---|
| Shift Requirement Priority | ES_SHIFT.WBT_ID |
| Shift Requirement Day | ES_TMPL_SHIFT_REQ_SHIFT_DAY.ETSHRSD_DAY |
| Shift Requirement Target | ES_TMPL_SHIFT_REQ_SHIFT_DAY.ETSHRSD_TARGET |
| Keys > ETSHR_ID | ES_TMPL_SHIFT_REQ.ETSHR_ID |
| Foreign Keys > DP_ID | ES_TMPL_SHIFT_REQ.DP_ID |
| Foreign Keys > ESSHIFT_ID | ES_TMPL_SHIFT_REQ_SHIFT.ESSHIFT_ID |
| Foreign Keys > JOB_ID | ES_TMPL_SHIFT_REQ.JOB_ID |
| Foreign Keys > TMPL_ID | ES_TMPL_SHIFT_REQ.TMPL_ID |
Shift Status
| Metadata model reference | Database reference |
|---|---|
| Shift Status Name | ES_SHIFT_STATUS.SHIFTSTAT_LOC_NAME |
| Shift Status Description | ES_SHIFT_STATUS.SHIFTSTAT_LOC_DESC |
| Shift Status Enabled | ES_SHIFT_STATUS.SHIFTSTAT_ENABLE |
| Keys > SHIFTSTAT_ID | ES_SHIFT_STATUS.SHIFTSTAT_ID |
| Foreign Keys > COLR_ID | ES_SHIFT_STATUS.COLR_ID |
| SHIFTSTAT_FLAG? | ES_SHIFT_STATUS.SHIFTSTAT_FLAG? |
| SHIFTSTAT_UDF? | ES_SHIFT_STATUS.SHIFTSTAT_UDF? |
Shift Status Color
| Metadata model reference | Database reference |
|---|---|
| Color Name | COLOUR.COLR_NAME |
| Color Description | COLOUR.COLR_DESC |
| Color Value | COLOUR.COLR_VALUE |
| Keys > COLR_ID | COLOUR.COLR_ID |
Shift Summary
| Metadata model reference | Database reference |
|---|---|
| Shift Summary Create Date | ES_SHIFT_SUMMARY.SHIFTSUM_CREATE_DATE |
| Shift Summary Is Adhoc | ES_SHIFT_SUMMARY.SHIFTSUM_IS_ADHOC |
| Shift Summary Is Modified | ES_SHIFT_SUMMARY.SHIFTSUM_IS_MODIFIED |
| Shift Summary Status | ES_SHIFT_SUMMARY.SHIFTSUM_STATUS |
| Shift Summary Row Number | ES_SHIFT_SUMMARY.SHIFTSUM_ROWLM_ROWNAME |
| Shift Summary Work Date | ES_SHIFT_SUMMARY.SHIFTSUM_WORK_DATE |
| Keys > SHIFTSUM_ID | ES_SHIFT_SUMMARY.SHIFTSUM_ID |
| Foreign Keys > EMP_ID | ES_SHIFT_SUMMARY.EMP_ID |
| Foreign Keys > ESSHIFT_ID | ES_SHIFT_SUMMARY.ESSHIFT_ID |
| Foreign Keys > RELBLK_ID | ES_SHIFT_SUMMARY.RELBLK_ID |
| Foreign Keys > RELTYPE_ID | ES_SHIFT_SUMMARY.RELTYPE_ID |
| Foreign Keys > ROT_ID | ES_SHIFT_SUMMARY.ROT_ID |
| Foreign Keys > ROTROW_ID | ES_SHIFT_SUMMARY.ROTROW_ID |
| Foreign Keys > ROWSHIFT_ID | ES_SHIFT_SUMMARY.ROWSHIFT_ID |
| Foreign Keys > SHIFTLINK_ID | ES_SHIFT_SUMMARY.SHIFTLINK_ID |
| Foreign Keys > SHIFTSUM_PARENT_ID | ES_SHIFT_SUMMARY.SHIFTSUM_PARENT_ID |
| Foreign Keys > SHIFTSUM_SWAP_ID | ES_SHIFT_SUMMARY.SHIFTSUM_SWAP_ID |
| Foreign Keys > TMPL_ID | ES_SHIFT_SUMMARY.TMPL_ID |
| Foreign Keys > TMPLSCHD_ID | ES_SHIFT_SUMMARY.TMPLSCHD_ID |
| Foreign Keys > WBT_ID | ES_SHIFT_SUMMARY.WBT_ID |
| SHIFTSUM_FLAG? | ES_SHIFT_SUMMARY.SHIFTSUM_FLAG? |
| SHIFTSUM_UDF? | ES_SHIFT_SUMMARY.SHIFTSUM_UDF? |
Shift Summary Employee
| Metadata model reference | Database reference |
|---|---|
| Employee ID | EMPLOYEE.EMP_NAME |
| Full Name | EMPLOYEE.EMP_FULLNAME |
| First Name | EMPLOYEE.EMP_FIRSTNAME |
| Last Name | EMPLOYEE.EMP_LASTNAME |
| Is Full Time | EMPLOYEE.EMP_FULLTIME |
| Status | EMPLOYEE.EMP_STATUS |
| Is Home Team | SEC_EMPLOYEE.EMPT_HOME_TEAM |
| Base Rate | EMPLOYEE.EMP_BASE_RATE |
| Hire Rate | EMPLOYEE.EMP_HIRE_DATE |
| Effective Date | EMPLOYEE.EMP_EFFECTIVE_DATE |
| Termination Date | EMPLOYEE.EMP_TERMINIATION_DATE |
| Seniority Date | EMPLOYEE.EMP_SENIORITY_DATE |
| Birth Date | EMPLOYEE.EMP_BIRTH_DATE |
| SIN | EMPLOYEE.EMP_SIN |
| Shift Pattern Offset | EMPLOYEE.EMP_SHFTPAT_OFFSET |
| Default Minutes | EMPLOYEE.EMP_DEF_MINUTES |
| Full Time Equivalent | EMPLOYEE.EMP_FTE |
| Keys > EMP_ID | EMPLOYEE.EMP_ID |
| Keys > WBT_ID | SEC_EMPLOYEE.WBT_ID |
| Keys > TEAM_START_DATE | SEC_EMPLOYEE.START_DATE |
| Keys > TEAM_END_DATE | SEC_EMPLOYEE.END_DATE |
| Work Type > Work Type Name | EMPLOYEE_WORK_TYPE.EMPWRKTYP_NAME |
| Work Type > Work Type Description | EMPLOYEE_WORK_TYPE.EMPWRKTYP_DESC |
| Work Type > Work Type Full Time | EMPLOYEE_WORK_TYPE.EMPWRKTYP_FULLTIME |
| Work Type > Work Type Sort Order | EMPLOYEE_WORK_TYPE.EMPWRKTYP_SORTORDER |
| Work Type > Work Type UDFs > EMPWRKTYP_FLAG? | EMPLOYEE_WORK_TYPE.EMPWRKTYP_FLAG? |
| Work Type > Work Type UDFs > EMPWRKTYP_UDF? | EMPLOYEE_WORK_TYPE.EMPWRKTYP_UDF? |
| Employment Type > Employment Type Name | EMPLOYMENT_TYPE.EMPTYP_NAME |
| Employment Type > Employment Type Description | EMPLOYMENT_TYPE.EMPTYP_DESC |
| Employment Type > Employment Type Sort Order | EMPLOYMENT_TYPE.EMPTYP_SORTORDER |
| Employment Type > Employment Type UDFs > EMPTYPE_FLAG? | EMPLOYMENT_TYPE.EMPTYP_FLAG? |
| Employment Type > Employment Type UDFs > EMPTYPE_UDF? | EMPLOYMENT_TYPE.EMPTYP_UDF? |
| UDFs > EMP_FLAG? | EMPLOYEE.EMP_FLAG? |
| UDFs > EMP_VAL? | EMPLOYEE.EMP_VAL? |
Shift Summary Employee Team
| Metadata model reference | Database reference |
|---|---|
| Team Name | WORKBRAIN_TEAM.WBT_NAME |
| Team Description | WORKBRAIN_TEAM.WBT_DESC |
| Team Level | WORKBRAIN_TEAM.WBT_LEVEL |
| Keys > WBT_ID | WORKBRAIN_TEAM.WBT_ID |
| Keys > WBT_PARENT_ID | WORKBRAIN_TEAM.WBT_PARENT_ID |
| Keys > WBT_START_DATE | SEC_WORKBRAIN_TEAM.WBUT_START_DATE |
| Keys > WBT_END_DATE | SEC_WORKBRAIN_TEAM.WBUT_END_DATE |
| Foreign Keys > Current_Timestamp | CURRENT_TIMESTAMP |
| UDFs > WBT_FLAG? | WORKBRAIN_TEAM.WBT_FLAG? |
| UDFs > WBT_UDF? | WORKBRAIN_TEAM.WBT_UDF? |
Shift Summary Shift Link
| Metadata model reference | Database reference |
|---|---|
| SHIFT_LINK_COMMENT | ES_SHIFT_LINK.SHIFTLINK_COMMENT |
| LINKTYPE_NAME | ES_LINK_TYPE.LINKTYPE_NAME |
| Keys > SHIFTLINK_ID | ES_SHIFT_LINK.SHIFTLINK_ID |
Shift Summary Shift Skills
| Metadata model reference | Database reference |
|---|---|
| Skill Name | ST_SKILL.STSKL_NAME |
| Skill Description | ST_SKILL.STSKL_DESC |
| Is Schedule Related | ST_SKILL.STSKL_SCHED_RELATED |
| UDFs > STSKL_FLAG? | ST_SKILL.STSKL_FLAG? |
| Shift Summary Shift SKills > UDFs > STSKL_UDF? | ST_SKILL.STSKL_UDF? |
| Keys > STSKL_ID | ST_SKILL.STSKL_ID |
| Foreign Keys > STSKLTYP_ID | ST_SKILL.STSKLTYP_ID |
Shift Summary Skill
| Metadata model reference | Database reference |
|---|---|
| Is Skill Required | ES_SHIFT_SUMMARY_SKILL.SHIFTSUMSKL_REQ |
| Shift Summary Skill Level | ES_SHIFT_SUMMARY_SKILL.SHIFTSUMSKL_LEVEL |
| UDFs > SHIFTSUMSKL_FLAG? | ES_SHIFT_SUMMARY_SKILL.SHIFTSUMSKL_FLAG? |
| UDFs > SHIFTSUMSKL_UDF? | ES_SHIFT_SUMMARY_SKILL.SHIFTSUMSKL_UDF? |
| Keys > SHIFTSUMSKL_ID | ES_SHIFT_SUMMARY_SKILL.SHIFTSUMSKL_ID |
| Foreign Keys > SHIFTSUM_ID | ES_SHIFT_SUMMARY_SKILL.SHIFTSUM_ID |
| Foreign Keys > STSKL_ID | ES_SHIFT_SUMMARY_SKILL.STSKL_ID |
Shift Team
| Metadata model reference | Database reference |
|---|---|
| Team Name | WORKBRAIN_TEAM.WBT_LOC_NAME |
| Team Description | WORKBRAIN_TEAM.WBT_LOC_DESC |
| Team Level | WORKBRAIN_TEAM.WBT_LEVEL |
| Keys > WBT_ID | WORKBRAIN_TEAM.WBT_ID |
| Keys > WBT_PARENT_ID | WORKBRAIN_TEAM.WBT_PARENT_ID |
| Keys > WBT_LFT | WORKBRAIN_TEAM.WBT_LFT |
| Keys > WBT_RGT | WORKBRAIN_TEAM.WBT_RGT |
| UDFs > WBT_FLAG? | WORKBRAIN_TEAM.WBT_FLAG? |
| UDFs > WBT_UDF? | WORKBRAIN_TEAM.WBT_UDF? |
Shift Team (with optional Sub Teams)
| Metadata model reference | Database reference |
|---|---|
| Team Name | WORKBRAIN_TEAM_PROMPT.WBT_NAME |
| Team Description | WORKBRAIN_TEAM_PROMPT.WBT_DESC |
| Team Level | WORKBRAIN_TEAM_PROMPT.WBT_LEVEL |
| Keys > WBT_ID | WORKBRAIN_TEAM_PROMPT.WBT_ID |
| Keys > WBT_PARENT_ID | WORKBRAIN_TEAM_PROMPT.WBT_PARENT_ID |
| Keys > WBT_LFT | WORKBRAIN_TEAM_PROMPT.WBT_LFT |
| Keys > WBT_RGT | WORKBRAIN_TEAM_PROMPT.WBT_RGT |
| UDFs > WBT_FLAG? | WORKBRAIN_TEAM_PROMPT.WBT_FLAG? |
| UDFs > WBT_UDF? | WORKBRAIN_TEAM_PROMPT.WBT_UDF? |
Shift Type
| Metadata model reference | Database reference |
|---|---|
| Shift Type Name | ES_SHIFT_TYPE.SHFTTYP_LOC_NAME |
| Shift Type Description | ES_SHIFT_TYPE.SHFTTYP_LOC_DESC |
| Keys > SHFTTYP_ID | ES_SHIFT_TYPE.SHFTTYP_ID |
Shifts
| Metadata model reference | Database reference |
|---|---|
| Shift Name | ES_SHIFT.ESSHIFT_NAME |
| Shift Description | ES_SHIFT.ESSHIFT_DESC |
| Is Shift Applied to Sub Team | ES_SHIFT.ESSHIFT_APPLYTO_SUB_TEAMS |
| Keys > ESSHIFT_ID | ES_SHIFT.ESSHIFT_ID |
| Foreign Keys > ESSHIFTLAB_ID | ES_SHIFT.ESSHIFTLAB_ID |
| Foreign Keys > WBT_ID | ES_SHIFT.WBT_ID |
| UDFs > ESSHIFT_FLAG? | ES_SHIFT.ESSHIFT_FLAG? |
| UDFs > ESSHIFT_UDF? | ES_SHIFT.ESSHIFT_UDF? |
Skill (also Required Skill)
| Metadata model reference | Database reference |
|---|---|
| Skill > Skill Name | ST_SKILL.STSKL_NAME |
| Skill > Skill Description | ST_SKILL.STSKL_DESC |
| Skill > Keys > STSKL_ID | ST_SKILL.STSKL_ID |
Skills
| Metadata model reference | Database reference |
|---|---|
| Skills > Skill Name | ST_SKILL.STSKL_NAME |
| Skills > Skill Description | ST_SKILL.STSKL_DESC |
| Skills > Is Schedule Related | ST_SKILL.STSKL_SCHED_RELATED |
| Skills > UDFs > STSKL_FLAG? | ST_SKILL.STSKL_FLAG? |
| Skills > UDFs > STSKL_UDF? | ST_SKILL.STSKL_UDF? |
| Skills > Keys > STSKL_ID | ST_SKILL.STSKL_ID |
| Skills > Foreign Keys > STSKLTYP_ID | ST_SKILL.STSKLTYP_ID |
Staffing
Under . Fact table containing the required staffing metrics for published schedules.
| Metadata model reference | Database reference |
|---|---|
| Forecasted Labor Hours | CASE WHEN SO_INTERVAL_REQ.INVTYP_NAME = '15' then ( SO_INTERVAL_REQ.INTREQ_TOTAL_REQ / 4 ) WHEN SO_INTERVAL_REQ.INVTYP_NAME = '30' then ( SO_INTERVAL_REQ.INTREQ_TOTAL_REQ / 2 ) WHEN SO_INTERVAL_REQ.INVTYP_NAME = '60' then ( SO_INTERVAL_REQ.INTREQ_TOTAL_REQ ) else ( SO_INTERVAL_REQ.INTREQ_TOTAL_REQ * 24 ) END |
| Keys > INTREQ_DATE | SO_INTERVAL_REQ.INTREQ_DATE |
| Keys > SKDGRP_ID | SO_INTERVAL_REQ.SKDGRP_ID |
Staffing Definition
| Metadata model reference | Database reference |
|---|---|
| Volume Per Hour | SO_CLIENT_STFDEF.WRKLD_STDVOL_HOUR |
| Foreign Keys > ACT_ID | SO_CLIENT_STFDEF.ACT_ID |
| Foreign Keys > JOB_ID | SO_CLIENT_STFDEF.JOB_ID |
| Foreign Keys > SKDGRP_ID | SO_CLIENT_STFDEF.SKDGRP_ID |
| Foreign Keys > STSKL_ID | SO_CLIENT_STFDEF.STSKL_ID |
Staffing Requirements
| Metadata model reference | Database reference |
|---|---|
| Staff Requirement Priority | ES_TMPL_STAFF_REQ.ETSR_PRIORITY |
| Keys > ETSR_ID | ES_TMPL_STAFF_REQ.ETSR_ID |
| Foreign Keys > DP_ID | ES_TMPL_STAFF_REQ.DP_ID |
| Foreign Keys > JOB_ID | ES_TMPL_STAFF_REQ.JOB_ID |
| Foreign Keys > TMPL_ID | ES_TMPL_STAFF_REQ.TMPL_ID |
Staffing Requirement Day
| Metadata model reference | Database reference |
|---|---|
| Staffing Requirement Day > Day of Staff Requirement | ES_TMPL_STAFF_REQ_DAY.ETSRD_DAY |
| Staffing Requirement Day > Staff Requirement Per Day | ES_TMPL_STAFF_REQ_DAY.ETSRD_REQ |
| Keys > ETSRD_ID | ES_TMPL_STAFF_REQ_DAY.ETSRD_ID |
| Foreign Keys > ETSR_ID | ES_TMPL_STAFF_REQ_DAY.ETSR_ID |
Staffing Requirement Skill
| Metadata model reference | Database reference |
|---|---|
| Skill Requirement Weight | ES_TMPL_STAFF_REQ_SKILL.ETSRS_REQ_SKILL_WEIGHT |
| Is Skill Requirement Mandatory | ES_TMPL_STAFF_REQ_SKILL.ETSRS_MANDATORY |
| Keys ETSRS_ID | ES_TMPL_STAFF_REQ_SKILL.ETSRS_ID |
| Foreign Keys > ETSR_ID | ES_TMPL_STAFF_REQ_SKILL.ETSR_ID |
| Foreign Keys > STSKL_ID | ES_TMPL_STAFF_REQ_SKILL.STSKL_ID |
Staffing Requirement Skill Day
| Metadata model reference | Database reference |
|---|---|
| Skill Day | ES_TMPL_STAFF_REQ_SKILL_DAY.ETSRSD_DAY |
| Staff Requirement Per Day | ES_TMPL_STAFF_REQ_SKILL_DAY.ETSRSD_REQ |
| Keys > ETSRSD_ID | ES_TMPL_STAFF_REQ_SKILL_DAY.ETSRSD_ID |
| Foreign Keys > ETSRS_ID | ES_TMPL_STAFF_REQ_SKILL_DAY.ETSRS_ID |
Staffing Requirement (SO)
| Metadata model reference | Database reference |
|---|---|
| Staffing Date | SO_INTERVAL_REQ.INTREQ_DATE |
| Raw Interval Requirement | [Staffing Requirement (SO)].[Raw Interval Requirement] |
| Interval Type | SO_INTERVAL_TYPE.INVTYP_LOC_NAME |
| Is Peak | SO_INTERVAL_REQ.INTREQ_PEAK_TIME_INTERVAL |
| Start Time | SO_INTERVAL_REQ.INTREQ_TIME |
| End Time | if (SO_INTERVAL_TYPE.INVTYP_NAME = 'Daily') then ( _add_days ( SO_INTERVAL_REQ.INTREQ_TIME, 1 ) ) else if ( SO_INTERVAL_TYPE.INVTYP_NAME = '15' ) then ( SO_INTERVAL_REQ.INTREQ_TIME + 000 00:15:00.000 ) else if ( SO_INTERVAL_TYPE.INVTYP_NAME = '30' ) then ( SO_INTERVAL_REQ.INTREQ_TIME + 000 00:30:00.000 ) else ( SO_INTERVAL_REQ.INTREQ_TIME + 000 01:00:00.000 ) |
| Number Required | SO_INTERVAL_REQ.INTREQ_TOTAL_REQ |
| Minimum Required | SO_INTERVAL_REQ.INTREQ_MINTOTL_REQ |
| Original Number Required (BAW) | SO_INTERVAL_REQ.INTREQ_TOTAL_REQ_HIST |
| Raw Interval Requirement | [Staffing Requirement (SO)].[Raw Interval Requirement] |
| Foreign Keys > ACT_ID | SO_INTERVAL_REQ.ACT_ID |
| Foreign Keys > JOB_ID | SO_INTERVAL_REQ.JOB_ID |
| Foreign Keys > SKDGRP_ID | SO_INTERVAL_REQ.SKDGRP_ID |
| Foreign Keys > STSKL_ID | SO_INTERVAL_REQ.STSKL_ID |
Store
| Metadata model reference | Database reference |
|---|---|
| Name | SO_SCHEDULE_GROUP.SKDGRP_NAME |
| Staffing Standard | SO_SCHEDULE_GROUP.SKDGRP_STAFF_STD |
| Forecast Method | SO_SCHEDULE_GROUP.SKDGRP_FCAST_MTD |
| Forecast Interval | SO_SCHEDULE_GROUP.SKDGRP_FCAST_INT |
| Start of Week | SO_SCHEDULE_GROUP.SKDGRP_STARTDOW |
| Internal Type | SO_SCHEDULE_GROUP.SKDGRP_INTRNL_TYPE |
| Volume Type | SO_VOLUME_TYPE.VOLTYP_LOC_NAME |
| Budget Type | SO_SCHEDULE_GROUP.SKDGRP_BUDG_TYP |
| Budget Value 1 | SO_SCHEDULE_GROUP.SKDGRP_BUDG_VAL1 |
| Budget Value 2 | SO_SCHEDULE_GROUP.SKDGRP_BUDG_VAL2 |
| Variable Staffing Calculation | SO_SCHEDULE_GROUP.SKDGRP_CALCVARSTF |
| Sales Based | SO_SCHEDULE_GROUP.SKDGRP_SALES_BASED |
| Client Key | SO_SCHEDULE_GROUP.SKDGRP_CLIENTKEY |
| Keys > SKDGRP_ID | SO_SCHEDULE_GROUP.SKDGRP_ID |
| Keys > SKDGRP_PARENT_ID | SO_SCHEDULE_GROUP.SKDGRP_PARENT_ID |
| Keys > VOLTYP_ID | SO_SCHEDULE_GROUP.VOLTYP_ID |
| Keys > WBT_ID | SO_SCHEDULE_GROUP.WBT_ID |