Query subjects E to M
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 |
| System Scheduling Enabled | EMPLOYEE.EMP_SYSTEM_SCHEDULING_ENABLED |
| Base Rate | EMPLOYEE.EMP_BASE_RATE |
| Birth Date | EMPLOYEE.EMP_BIRTH_DATE |
| 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 Date | [EMPLOYEE].[EMP_HIRE_DATE] |
| Effective Date | [EMPLOYEE].[EMP_EFFECTIVE_DATE] |
| FTE | [EMPLOYEE].[EMP_FTE] |
| Termination Date | [EMPLOYEE].[EMP_TERMINATION_DATE] |
| Seniority Date | [EMPLOYEE].[EMP_SENIORITY_DATE] |
| Birth Date | [EMPLOYEE].[EMP_BIRTH_DATE] |
| SIN | EMPLOYEE.EMP_SIN |
| Seniority | [EMPLOYEE].[EMP_SENIORITY_NUMBER] |
| Shift Pattern Offset | [EMPLOYEE].[EMP_SHFTPAT_OFFSET] |
| Default Minutes | [EMPLOYEE].[EMP_DEF_MINUTES] |
| System Scheduling Enabled | [EMPLOYEE].[EMP_SYSTEM_SCHEDULING_ENABLED] |
| Hire Date | EMPLOYEE.EMP_HIRE_DATE |
| Effective Date | EMPLOYEE.EMP_EFFECTIVE_DATE |
| Termination Date | EMPLOYEE.EMP_TERMINIATION_DATE |
| Seniority Date | EMPLOYEE.EMP_SENIORITY_DATE |
| Seniority | EMPLOYEE.EMP_SENIORITY_NUMBER |
| Default Minutes | EMPLOYEE.EMP_DEF_MINUTES |
| Shift Pattern Offset | EMPLOYEE.EMP_SHFTPAT_OFFSET |
| Employee UDFs > EMP_FLAG? | EMPLOYEE.EMP_FLAG? |
| Employee UDFs > EMP_VAL? | EMPLOYEE.EMP_VAL? |
| 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 |
| Foreign Keys > CALCGRP_ID | EMPLOYEE.CALCGRP_ID |
| Foreign Keys > PAYGRP_ID | EMPLOYEE.PAYGRP_ID |
| Foreign Keys > SHFTPAT_ID | EMPLOYEE.SHFTPAT_ID |
| 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 Date | [EMPLOYEE].[EMP_HIRE_DATE] |
| Effective Date | [EMPLOYEE].[EMP_EFFECTIVE_DATE] |
| FTE | [EMPLOYEE].[EMP_FTE] |
| Termination Date | [EMPLOYEE].[EMP_TERMINATION_DATE] |
| Seniority Date | [EMPLOYEE].[EMP_SENIORITY_DATE] |
| Birth Date | [EMPLOYEE].[EMP_BIRTH_DATE] |
| SIN | [EMPLOYEE].[EMP_SIN] |
| Seniority | [EMPLOYEE].[EMP_SENIORITY_NUMBER] |
| Shift Pattern Offset | [EMPLOYEE].[EMP_SHFTPAT_OFFSET] |
| Default Minutes | [EMPLOYEE].[EMP_DEF_MINUTES] |
| System Scheduling Enabled | [EMPLOYEE].[EMP_SYSTEM_SCHEDULING_ENABLED] |
| EMP_FLAG1 | [EMPLOYEE].[EMP_FLAG1] |
| EMP_FLAG2 | [EMPLOYEE].[EMP_FLAG2] |
| EMP_FLAG3 | [EMPLOYEE].[EMP_FLAG3] |
| EMP_FLAG4 | [EMPLOYEE].[EMP_FLAG4] |
| EMP_FLAG5 | [EMPLOYEE].[EMP_FLAG5] |
| EMP_FLAG6 | [EMPLOYEE].[EMP_FLAG6] |
| EMP_FLAG7 | [EMPLOYEE].[EMP_FLAG7] |
| EMP_FLAG8 | [EMPLOYEE].[EMP_FLAG8] |
| EMP_FLAG9 | [EMPLOYEE].[EMP_FLAG9] |
| EMP_FLAG10 | [EMPLOYEE].[EMP_FLAG10] |
| EMP_FLAG11 | [EMPLOYEE].[EMP_FLAG11] |
| EMP_FLAG12 | [EMPLOYEE].[EMP_FLAG12] |
| EMP_FLAG13 | [EMPLOYEE].[EMP_FLAG13] |
| EMP_FLAG14 | [EMPLOYEE].[EMP_FLAG14] |
| EMP_FLAG15 | [EMPLOYEE].[EMP_FLAG15] |
| EMP_FLAG16 | [EMPLOYEE].[EMP_FLAG16] |
| EMP_FLAG17 | [EMPLOYEE].[EMP_FLAG17] |
| EMP_FLAG18 | [EMPLOYEE].[EMP_FLAG18] |
| EMP_FLAG19 | [EMPLOYEE].[EMP_FLAG19] |
| EMP_FLAG20 | [EMPLOYEE].[EMP_FLAG20] |
| EMP_VAL1 | [EMPLOYEE].[EMP_VAL1] |
| EMP_VAL2 | [EMPLOYEE].[EMP_VAL2] |
| EMP_VAL3 | [EMPLOYEE].[EMP_VAL3] |
| EMP_VAL4 | [EMPLOYEE].[EMP_VAL4] |
| EMP_VAL5 | [EMPLOYEE].[EMP_VAL5] |
| EMP_VAL6 | [EMPLOYEE].[EMP_VAL6] |
| EMP_VAL7 | [EMPLOYEE].[EMP_VAL7] |
| EMP_VAL8 | [EMPLOYEE].[EMP_VAL8] |
| EMP_VAL9 | [EMPLOYEE].[EMP_VAL9] |
| EMP_VAL10 | [EMPLOYEE].[EMP_VAL10] |
| EMP_VAL11 | [EMPLOYEE].[EMP_VAL11] |
| EMP_VAL12 | [EMPLOYEE].[EMP_VAL12] |
| EMP_VAL13 | [EMPLOYEE].[EMP_VAL13] |
| EMP_VAL14 | [EMPLOYEE].[EMP_VAL14] |
| EMP_VAL15 | [EMPLOYEE].[EMP_VAL15] |
| EMP_VAL16 | [EMPLOYEE].[EMP_VAL16] |
| EMP_VAL17 | [EMPLOYEE].[EMP_VAL17] |
| EMP_VAL18 | [EMPLOYEE].[EMP_VAL18] |
| EMP_VAL19 | [EMPLOYEE].[EMP_VAL19] |
| EMP_VAL20 | [EMPLOYEE].[EMP_VAL20] |
| EMP_ID | [EMPLOYEE].[EMP_ID] |
| WBT_ID | [SEC_EMPLOYEE].[WBT_ID] |
| TEAM_START_DATE | [SEC_EMPLOYEE].[START_DATE] |
| TEAM_END_DATE | [SEC_EMPLOYEE].[END_DATE] |
Employee Approval
| Metadata model reference | Database reference |
|---|---|
| Start Date | EA_TIME_APPROVAL.EATA_START_WORK_DATE |
| End Date | EA_TIME_APPROVAL.EATA_END_WORK_DATE |
| Create Time | EA_TIME_APPROVAL.EATA_CREATE_TIME |
| Update Time | EA_TIME_APPROVAL.EATA_UPDATE_TIME |
| Approval Minutes | EA_TIME_APPROVAL.EATA_WORK_MIN |
| Inactive Revision | EA_TIME_APPROVAL.EATA_INACTIVE_REVISION |
| Clock Device | EA_TIME_APPROVAL.EATA_DEVICE |
| Keys > EATA_ID | EA_TIME_APPROVAL.EATA_ID |
| Foreign Keys > EMP_ID | EA_TIME_APPROVAL.EMP_ID |
| Foreign Keys > EATST_ID | EA_TIME_APPROVAL.EATST_ID |
| UDFs > EATA_UDF? | EA_TIME_APPROVAL.EATA_UDF? |
Employee Approval Error
| Metadata model reference | Database reference |
|---|---|
| Error Message | EA_TIME_APPROVAL_ERROR.EATAE_ERROR_MESSAGE |
| Start Date | EA_TIME_APPROVAL_ERROR.EATAE_START_WORK_DATE |
| End Date | EA_TIME_APPROVAL_ERROR.EATAE_END_WORK_DATE |
| Create Time | EA_TIME_APPROVAL_ERROR.EATAE_CREATE_TIME |
| Update Time | EA_TIME_APPROVAL_ERROR.EATAE_UPDATE_TIME |
| Approval Minutes | EA_TIME_APPROVAL_ERROR.EATAE_WORK_MIN |
| Inactive Revision | EA_TIME_APPROVAL_ERROR.EATAE_INACTIVE_REVISION |
| Clock Device | EA_TIME_APPROVAL_ERROR.EATAE_DEVICE |
| UDFs > EATAE_UDF? | EA_TIME_APPROVAL_ERROR.EATAE_UDF? |
| Keys > EATAE_ID | EA_TIME_APPROVAL_ERROR.EATAE_ID |
| Foreign Keys > EATA_ID | EA_TIME_APPROVAL_ERROR.EATA_ID |
| Foreign Keys > EMP_ID | EA_TIME_APPROVAL_ERROR.EMP_ID |
| Foreign Keys > EATST_ID | EA_TIME_APPROVAL_ERROR.EATST_ID |
Employee Badge
| Metadata model reference | Database reference |
|---|---|
| Badge Number | EMPLOYEE_BADGE.EMPBDG_BADGE_NUM |
| UDFs > EMPBDG_FLAG[1-5] | [EMPLOYEE_BADGE].[EMPBDG_FLAG1-5] |
| UDFs > EMPBDG_UDF[1-5] | [EMPLOYEE_BADGE].[EMPBDG_UDF1-5] |
| Keys > EMPBDG_ID | EMPLOYEE_BADGE.EMPBDG_ID |
| Foreign Keys > EMP_ID | EMPLOYEE_BADGE.EMP_ID |
Employee Default Labor
| Metadata model reference | Database reference |
|---|---|
| Ratio | EMP_DEF_LAB.EDLA_PERCENTAGE |
| Default Labor UDFs > EDLA_FLAG? | EMP_DEF_LAB.EDLA_FLAG? |
| Default Labor UDFs > EDLA_UDF? | EMP_DEF_LAB.EDLA_UDF? |
| Foreign Keys > EMP_ID | EMP_DEF_LAB.EMP_ID |
| Foreign Keys > DEPT_ID | EMP_DEF_LAB.DEPT_ID |
| Foreign Keys > DOCK_ID | EMP_DEF_LAB.DOCK_ID |
| Foreign Keys > JOB_ID | EMP_DEF_LAB.JOB_ID |
| Foreign Keys > PROJ_ID | EMP_DEF_LAB.PROJ_ID |
Employee History
| Metadata model reference | Database reference |
|---|---|
| Employee ID | EMPLOYEE_HISTORY.EMP_NAME |
| Full Name | EMPLOYEE_HISTORY.EMP_FULLNAME |
| First Name | EMPLOYEE_HISTORY.EMP_FIRSTNAME |
| Last Name | EMPLOYEE_HISTORY.EMP_LASTNAME |
| SIN | EMPLOYEE_HISTORY.EMP_SIN |
| Is Full time | EMPLOYEE_HISTORY.EMP_FULLTIME |
| Status | EMPLOYEE_HISTORY.EMP_STATUS |
| Base Rate | EMPLOYEE_HISTORY.EMP_BASE_RATE |
| Birth Rate | EMPLOYEE_HISTORY.EMP_BIRTH_DATE |
| Hire Date | EMPLOYEE_HISTORY.EMP_HIRE_DATE |
| Effective Date | EMPLOYEE_HISTORY.EMP_EFFECTIVE_DATE |
| Termination Date | EMPLOYEE_HISTORY.EMP_TERMINATION_DATE |
| Seniority Date | EMPLOYEE_HISTORY.EMP_SENIORITY_DATE |
| Start Date | EMPLOYEE_HISTORY.EMPHIST_START_DATE |
| End Date | EMPLOYEE_HISTORY.EMPHIST_END_DATE |
| Shift Pattern Offset | EMPLOYEE_HISTORY.EMP_SHFTPAT_OFFSET |
| UDFs > EMP_FLAG? | EMPLOYEE_HISTORY.EMP_FLAG? |
| UDFs > EMP_VAL? | EMPLOYEE_HISTORY.EMP_VAL? |
| Keys > EMP_ID | SEC_EMPLOYEE.EMP_ID |
| Foreign Keys > CALCGRP_ID | EMPLOYEE_HISTORY.CALCGRP_ID |
| Foreign Keys > PAYGRP_ID | EMPLOYEE_HISTORY.PAYGRP_ID |
| Foreign Keys > SHIFTPAT_ID | EMPLOYEE_HISTORY.SHFTPAT_ID |
Employee Job
| Metadata model reference | Database reference |
|---|---|
| Job Name | JOB.JOB_NAME |
| Job Description | JOB.JOB_DESC |
| Tipped | JOB.JOB_TIP |
| Rate Index | EMPLOYEE_JOB.EMPJOB_RATE_INDEX |
| Work Assignment | EMPLOYEE_JOB.EMPJOB_WORKASSIGNMENT |
| Employee Job Rate | EMPLOYEE_JOB.EMPJOB_RATE |
| Job Start Date | EMPLOYEE_JOB.EMPJOB_START_DATE |
| Job End Date | EMPLOYEE_JOB.EMPJOB_END_DATE |
| Job Rank | EMPLOYEE_JOB.EMPJOB_RANK |
| Job Preferred | EMPLOYEE_JOB.EMPJOB_PREFERRED |
| Job UDFs > JOB_FLAG? | JOB.JOB_FLAG? |
| Job UDFs > JOB_REFKEY? | JOB.JOB_REFKEY? |
| Job UDFs > JOB_VAL? | JOB.JOB_VAL? |
| Job UDFs > EMPJOB_FLAG? | EMPLOYEE_JOB.EMPJOB_FLAG? |
| Job UDFs > EMPJOB_UDF? | EMPLOYEE_JOB.EMPJOB_UDF? |
| Foreign Keys > EMP_ID | EMPLOYEE_JOB.EMP_ID |
| Foreign Keys > JOB_ID | EMPLOYEE_JOB.JOB_ID |
Employee Schedule
| Metadata model reference | Database reference |
|---|---|
| Date | EMPLOYEE_SCHEDULE.WORK_DATE |
| Scheduled Hours | See IBM Query Studio for details on the expression. |
| Scheduled Minutes | See IBM Query Studio for details on the expression. |
| Default Start Time | EMPLOYEE_SCHEDULE.EMPSKD_DEF_START_TIME |
| Default End Time | EMPLOYEE_SCHEDULE.EMPSKD_DEF_END_TIME |
| Actual Start Time | EMPLOYEE_SCHEDULE.EMPSKD_ACT_START_TIME |
| Actual End Time | EMPLOYEE_SCHEDULE.EMPSKD_ACT_END_TIME |
| Actual Start Time2 | EMPLOYEE_SCHEDULE.EMPSKD_ACT_START_TIME2 |
| Actual End Time2 | EMPLOYEE_SCHEDULE.EMPSKD_ACT_END_TIME2 |
| Actual Start Time3 | EMPLOYEE_SCHEDULE.EMPSKD_ACT_START_TIME3 |
| Actual End Time3 | EMPLOYEE_SCHEDULE.EMPSKD_ACT_END_TIME3 |
| Actual Start Time4 | EMPLOYEE_SCHEDULE.EMPSKD_ACT_START_TIME4 |
| Actual End Time4 | EMPLOYEE_SCHEDULE.EMPSKD_ACT_END_TIME4 |
| Actual Start Time5 | EMPLOYEE_SCHEDULE.EMPSKD_ACT_START_TIME5 |
| Actual End Time5 | EMPLOYEE_SCHEDULE.EMPSKD_ACT_END_TIME5 |
Employee Scheduled Detail
| 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 / 60.0 |
| 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 |
| 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.OCK_ID |
| Foreign Keys > JA_ID | EMPLOYEE_SCHED_DTL.JA_ID |
| Foreign Keys > JOB_ID | EMPLOYEE_SCHED_DTL.JA_ID |
| Foreign Keys > MODULE_REF | EMPLOYEE_SCHED_DTL.MODULE_REF |
| Foreign Keys > PROJ_ID | EMPLOYEE_SCHED_DTL.PROJ_ID |
| Foreign Keys > STKSL_ID | EMPLOYEE_SCHED_DTL.STKSL_ID |
| Foreign Keys > TCODE_ID | EMPLOYEE_SCHED_DTL.STKSL_ID |
| Foreign Keys > WBT_ID | EMPLOYEE_SCHED_DTL.WBT_ID |
Employee Schedule Settings
| Metadata model reference | Database reference |
|---|---|
| Max Hours per Schedule | SO_EMPLOYEE.SEMP_SKDMAX_HRS |
| Min Hours per Schedule | SO_EMPLOYEE.SEMP_SKDMIN_HRS |
| Max Hours per Day | SO_EMPLOYEE.SEMP_DAYMAX_HRS |
| Min Hours per Shift | SO_EMPLOYEE.SEMP_SHFTMIN_HRS |
| Is Minor | if SO_EMPLOYEE.SEMP_IS_MINOR = 1 then 'Y' else 'N' |
| Is Salary | if SO_EMPLOYEE.SEMP_IS_SALARY = 1 then 'Y' else 'N' |
| Staff Group | SO_EMPLOYEE_GROUP.EMPGRP_ID |
| Keys > EMP_ID | SO_EMPLOYEE.EMP_ID |
| Keys > EMPGRP_ID | SO_EMPLOYEE.EMPGRP_ID |
| Keys > SKDGRP_ID | SO_EMPLOYEE.SKDGRP_ID |
Employee Skill
| Metadata model reference | Database reference |
|---|---|
| Skill Name | ST_SKILL.STSKL_NAME |
| Skill Description | ST_SKILL.STSKL_DESC |
| Skill Start Date | ST_EMP_SKILL.STEMPSKL_START_DATE |
| Skill End Date | ST_EMP_SKILL.STEMPSKL_END_DATE |
| Skill Weight | ST_EMP_SKILL.STEMPSKL_WEIGHT |
| UDFs > STEMPSKL_FLAG? | ST_EMP_SKILL.STEMPSKL_FLAG? |
| UDFs > STEMPSKL_UDF? | ST_EMP_SKILL.STEMPSKL_UDF? |
| UDFs > STSKL_FLAG? | ST_SKILL.STSKL_FLAG? |
| UDFs > STSKL_UDF? | ST_SKILL.STSKL_UDF? |
| Keys > EMP_ID | ST_EMP_SKILL.EMP_ID |
| Keys > STEMPSKL_ID | ST_EMP_SKILL.STEMPSKL_ID |
| Keys > STSKL_ID | ST_SKILL.STSKL_ID |
| Keys > STSKLTYP_ID | ST_SKILL.STSKLTYP_ID |
Employee UDF Data
| Metadata model reference | Database reference |
|---|---|
| Employee Data Name | EMP_UDF_DEF.EMPUDF_NAME |
| Employee Data Description | EMP_UDF_DEF.EMPUDF_DESC |
| Value | EMP_UDF_DATA.EUDFD_VALUE |
| Default Value | EMP_UDF_DEF.EMPUDF_DEFAULT |
| Effective Date | EMP_UDF_DATA.EUDFD_EFF_DATE |
| Keys > EMP_ID | EMP_UDF_DATA.EMP_ID |
Employee Work Type
| Metadata model reference | Database reference |
|---|---|
| Employee Work Type Name | EMPLOYEE_WORK_TYPE.EMPWRKTYP_NAME |
| Employee Work Type Description | EMPLOYEE_WORK_TYPE.EMPWRKTYP_DESC |
| Is Full Time | EMPLOYEE_WORK_TYPE.EMPWRKTYP_FULLTIME |
| Employee Work Type Sort Order | EMPLOYEE_WORK_TYPE.EMPWRKTYP_SORTORDER |
| PBJ Pay Type Code | EMPLOYEE_WORK_TYPE.EMPWRKTYP_PBJ_PAY_TYPE_CODE |
| UDFs > EMPWRKTYP_FLAG1 | EMPLOYEE_WORK_TYPE.EMPWRKTYP_FLAG1 |
| UDFs > EMPWRKTYP_FLAG2 | EMPLOYEE_WORK_TYPE.EMPWRKTYP_FLAG2 |
| UDFs > EMPWRKTYP_FLAG3 | EMPLOYEE_WORK_TYPE.EMPWRKTYP_FLAG3 |
| UDFs > EMPWRKTYP_FLAG4 | EMPLOYEE_WORK_TYPE.EMPWRKTYP_FLAG4 |
| UDFs > EMPWRKTYP_FLAG5 | EMPLOYEE_WORK_TYPE.EMPWRKTYP_FLAG5 |
| UDFs > EMPWRKTYP_UDF1 | EMPLOYEE_WORK_TYPE.EMPWRKTYP_UDF1 |
| UDFs > EMPWRKTYP_UDF2 | EMPLOYEE_WORK_TYPE.EMPWRKTYP_UDF2 |
| UDFs > EMPWRKTYP_UDF3 | EMPLOYEE_WORK_TYPE.EMPWRKTYP_UDF3 |
| UDFs > EMPWRKTYP_UDF4 | EMPLOYEE_WORK_TYPE.EMPWRKTYP_UDF4 |
| UDFs > EMPWRKTYP_UDF5 | EMPLOYEE_WORK_TYPE.EMPWRKTYP_UDF5 |
| Keys > EMPWRKTYP_ID | EMPLOYEE_WORK_TYPE.EMPWRKTYP_ID |
Entitlement
| Metadata model reference | Database reference |
|---|---|
| Entitlement Name | ENT_ENTITLEMENT.ENT_NAME |
| Entitlement Description | ENT_ENTITLEMENT.ENT_DESC |
| Entitlement Start Date | ENT_ENTITLEMENT.ENT_START_DATE |
| Entitlement End Date | ENT_ENTITLEMENT.ENT_END_DATE |
| Apply On Unit | ENT_ENTITLEMENT.ENT_APPLY_ON_UNIT |
| Apply On Value | ENT_ENTITLEMENT.ENT_APPLY_ON_VALUE |
| Policy Entitlement Priority | ENT_POLICY_ENTITLEMENT.ENTPOLENT_PRIORITY |
| Foreign Keys > ENTPOL_ID | ENT_POLICY_ENTITLEMENT.ENTPOL_ID |
| Foreign Keys > ENTPOLENT_ID | ENT_POLICY_ENTITLEMENT.ENTPOLENT_ID |
| Keys > ENT_ID | ENT_POLICY_ENTITLEMENT.ENT_ID |
Entitlement Details
| Metadata model reference | Database reference |
|---|---|
| Priority | ENT_DETAIL.ENTDET_PRIORITY |
| Min Seniority Value | ENT_DETAIL.ENTDET_MIN_SEN_VALUE |
| Min Seniority Units | ENT_DETAIL.ENTDET_MIN_SEN_UNITS |
| Max Seniority Value | ENT_DETAIL.ENTDET_MAX_SEN_VALUE |
| Max Seniority Units | ENT_DETAIL.ENTDET_MAX_SEN_UNITS |
| Min Good Value | ENT_DETAIL.ENTDET_GOOD_MIN |
| Good Units | ENT_DETAIL.ENTDET_GOOD_UNITS |
| Good Time Codes | ENT_DETAIL.ENTDET_GOOD_TCODE_NAME |
| Good Function | ENT_DETAIL.ENTDET_GOOD_FUNCTION |
| Good Hour Type | ENT_DETAIL.ENTDET_GOOD_HTYPE_NAMES |
| Max Bad Value | ENT_DETAIL.ENTDET_BAD_MAX |
| Bad Units | ENT_DETAIL.ENTDET_BAD_UNITS |
| Bad Time Codes | ENT_DETAIL.ENTDET_BAD_TCODE_NAME |
| Bad Function | ENT_DETAIL.ENTDET_BAD_FUNCTION |
| Bad Hour Type | ENT_DETAIL.ENTDET_BAD_HTYPE_NAMES |
| Units to Apply | ENT_DETAIL.ENTDET_UNITS |
| Ratio | ENT_DETAIL.ENTDET_RATIO |
| Condition to Apply | ENT_DETAIL.ENTDET_CONDITION |
| Action to be Taken | ENT_DETAIL.ENTDET_ACTION |
| Max Value | ENT_DETAIL.ENTDET_MAX_BAL_VALUE |
| Action on Max | ENT_DETAIL.ENTDET_ON_MAX_OUT |
| Min Value | ENT_DETAIL.ENTDET_MIN_BAL_VALUE |
| Action on Min | ENT_DETAIL.ENTDET_ON_MIN_OUT |
| Annual Max | ENT_DETAIL.ENTDET_ANNUAL_MAX |
| Year Start | ENT_DETAIL.ENTDET_YEAR_START |
| Annual on Max | ENT_DETAIL.ENTDET_ON_ANNUAL_MAX |
| Entitlement Details UDFs > ENTDET_FLAG? | ENT_DETAIL.ENTDET_FLAG? |
| Entitlement Details UDFs > ENTDET_UDF? | ENT_DETAIL.ENTDET_UDF? |
| Keys > ENT_ID | ENT_DETAIL.ENT_ID |
| Keys > BAL_ID | ENT_DETAIL.BAL_ID |
Errors
| Metadata model reference | Database reference |
|---|---|
| Failures | JOBSKD_ERRORS.Failures |
| Keys > JSTSK_ID | JOBSKD_ERRORS.JSTSK_ID |
Event Definition
| Metadata model reference | Database reference |
|---|---|
| Event Name | AC_EVENT.ACEVT_NAME |
| Event Description | AC_EVENT.ACEVT_DESC |
| Eligible Teams | AC_EVENT.WBT_NAMES |
| Sub team Eligibility | AC_EVENT.ACEVT_APPLY_SUBTM |
| Eligible Employees | AC_EVENT.ACEVT_EMP_NAMES |
| Eligible Calc Groups | AC_EVENT.ACEVT_CALCGRP_NAME |
| Eligible Pay Groups | AC_EVENT.ACEVT_PAYGRP_NAMES |
| Eligible Time Codes | AC_EVENT.ACEVT_TCODE_NAMES |
| Maximum Duration | AC_EVENT.ACEVT_MAX_DUR |
| Minimum Duration | AC_EVENT.ACEVT_MIN_DUR |
| Points | AC_EVENT.ACEVT_POINTS |
| Priority | AC_EVENT.ACEVT_PRIORITY |
| UDFs > ACEVT_EMP_VAL?S | AC_EVENT.ACEVT_EMP_VAL?S |
| UDFs > ACEVT_FLAG? | AC_EVENT.ACEVT_FLAG? |
| UDFs > ACEVT_UDF? | AC_EVENT.ACEVT_UDF? |
| Keys > ACEVT_ID | AC_EVENT.ACEVT_ID |
Event Log Entry
| Metadata model reference | Database reference |
|---|---|
| Event Name | AC_EVENT.ACEVT_NAME |
| Work Date | AC_EVENT_LOG.ACEVTLOG_WORK_DATE |
| User | AC_EVENT_LOG.WBU_NAME |
| Actual User | AC_EVENT_LOG.WBU_NAME_ACTUAL |
| Log Date | AC_EVENT_LOG.ACEVTLOG_DATE |
| Log Points | AC_EVENT_LOG.ACEVTLOG_POINTS |
| Employee Reason | AC_EVENT_LOG.ACEVTLOG_EMP_REAS |
| Authorized By | AC_EVENT_LOG.ACEVTLOG_AUTH_BY |
| Authorization Date | AC_EVENT_LOG.ACEVTLOG_AUTH_DATE |
| Supervisor Notes | AC_EVENT_LOG.ACEVTLOG_SUPER_NT |
| Status | AC_EVENT_LOG.ACEVTLOG_STATUS |
| Calc Group | AC_EVENT_LOG.CALCGRP_NAME |
| Pay Group | AC_EVENT_LOG.PAYGRP_NAME |
| Time Code | AC_EVENT_LOG.TCODE_NAME |
| Keys > ACEVT_ID | AC_EVENT_LOG.ACEVT_ID |
| Keys > ACEVTLOG_ID | AC_EVENT_LOG.ACEVTLOG_ID |
| EMP_ID | AC_EVENT_LOG.EMP_ID |
Event Violation Log
| Metadata model reference | Database reference |
|---|---|
| Keys > ACVIOLOG_ID | AC_VIOEVT_LOG.ACVIOLOG_ID |
| Keys > ACVTLOG_ID | AC_VIOEVT_LOG.ACEVTLOG_ID |
Export Details
| Metadata model reference | Database reference |
|---|---|
| Processed Date | WBINT_EXPORT.WBIEXP_PROC_DATE |
| Record Status | WBINT_EXPORT.WBIEXP_STATUS |
| Record Message | WBINT_EXPORT.WBIEXP_MSG |
| Keys > WBIEXP_ID | WBINT_EXPORT.WBIEXP_ID |
| Keys > WBITRAN_ID | WBINT_EXPORT.WBITRAN_ID |
Facility
| Metadata model reference | Database reference |
|---|---|
| Facility Name | PBJ_FACILITY.PBJFAC_NAME |
| Facility Code | PBJ_FACILITY.PBJFAC_CODE |
| Facility Description | PBJ_FACILITY.PBJFAC_DESC |
| Facility Team Start Date | PBJ_FACILITY_TEAM.PBJFT_START_DATE |
| Facility Team End Date | PBJ_FACILITY_TEAM.PBJFT_END_DATE |
| State Name | STATE.STATE_NAME |
| State Code | STATE.STATE_CODE |
| UDFs > PBJFAC_FLAG1 | PBJ_FACILITY.PBJFAC_FLAG1 |
| UDFs > PBJFAC_FLAG2 | PBJ_FACILITY.PBJFAC_FLAG2 |
| UDFs > PBJFAC_FLAG3 | PBJ_FACILITY.PBJFAC_FLAG3 |
| UDFs > PBJFAC_FLAG4 | PBJ_FACILITY.PBJFAC_FLAG4 |
| UDFs > PBJFAC_FLAG5 | PBJ_FACILITY.PBJFAC_FLAG5 |
| UDFs > PBJFAC_UDF1 | PBJ_FACILITY.PBJFAC_UDF1 |
| UDFs > PBJFAC_UDF2 | PBJ_FACILITY.PBJFAC_UDF2 |
| UDFs > PBJFAC_UDF3 | PBJ_FACILITY.PBJFAC_UDF3 |
| UDFs > PBJFAC_UDF4 | PBJ_FACILITY.PBJFAC_UDF4 |
| UDFs > PBJFAC_UDF5 | PBJ_FACILITY.PBJFAC_UDF5 |
| Facility Team UDFs > PBJFT_FLAG1 | PBJ_FACILITY_TEAM.PBJFT_FLAG1 |
| Facility Team UDFs > PBJFT_FLAG2 | PBJ_FACILITY_TEAM.PBJFT_FLAG2 |
| Facility Team UDFs > PBJFT_FLAG3 | PBJ_FACILITY_TEAM.PBJFT_FLAG3 |
| Facility Team UDFs > PBJFT_FLAG4 | PBJ_FACILITY_TEAM.PBJFT_FLAG4 |
| Facility Team UDFs > PBJFT_FLAG5 | PBJ_FACILITY_TEAM.PBJFT_FLAG5 |
| Facility Team UDFs > PBJFT_UDF1 | PBJ_FACILITY_TEAM.PBJFT_UDF1 |
| Facility Team UDFs > PBJFT_UDF2 | PBJ_FACILITY_TEAM.PBJFT_UDF2 |
| Facility Team UDFs > PBJFT_UDF3 | PBJ_FACILITY_TEAM.PBJFT_UDF3 |
| Facility Team UDFs > PBJFT_UDF4 | PBJ_FACILITY_TEAM.PBJFT_UDF4 |
| Facility Team UDFs > PBJFT_UDF5 | PBJ_FACILITY_TEAM.PBJFT_UDF5 |
| Keys > PBJFAC_ID | PBJ_FACILITY.PBJFAC_ID |
| Foreign Keys > WBT_ID | PBJ_FACILITY_TEAM.WBT_ID |
Forecast
Under . Fact table containing forecasted metrics for example, sales data.
| Metadata model reference | Database reference |
|---|---|
| Forecasted Payroll | if (SO_VOLUME_TYPE.VOLTYP_NAME = 'PAYROLL') then ( FORECAST.CALC_FCAST_VALUE ) else (0) |
| Forecasted Returns | if (SO_VOLUME_TYPE.VOLTYP_NAME = 'RETURNS') then ( FORECAST.CALC_FCAST_VALUE ) else (0) |
| Forecasted Revenue | if (SO_VOLUME_TYPE.VOLTYP_NAME = 'REVENUE') then ( FORECAST.CALC_FCAST_VALUE ) else (0) |
| Forecasted Transactions | if (SO_VOLUME_TYPE.VOLTYP_NAME = 'TRANSACTIONS') then ( FORECAST.CALC_FCAST_VALUE ) else (0) |
| Forecasted Units | if ( SO_VOLUME_TYPE.VOLTYP_NAME = 'UNIT' ) then ( FORECAST.CALC_FCAST_VALUE ) else ( 0 ) |
| Keys > DIST_ID | FORECAST.DIST_ID |
| Keys > FCAST_DATE | FORECAST.FCAST_DATE |
| Keys > FCAST_ID | FORECAST.FCAST_ID |
| Keys > SKDGRP_ID | FORECAST.SKDGRP_ID |
| Keys > VOLTYP_ID | FORECAST.VOLTYP_ID |
Forecasts
| Metadata model reference | Database reference |
|---|---|
| Forecast Name | SO_FCAST.FCAST_NAME |
| Interval Type | SO_FCAST.INVTYP_ID |
| Forecast Date | SO_FCAST_DETAIL.FCAST_DATE |
| Calls | SO_FCAST_DETAIL.FCAST_CALLS |
| Adjusted Type | SO_FCAST_DETAIL.FCAST_ADJTYP |
| Adjusted Value | SO_FCAST_DETAIL.FCAST_ADJVAL |
| Keys > SKDGRP_ID | SO_FCAST.SKDGRP_ID |
Forecast Driver
Permanent filter on the Forecast Driver query subject: SO_SCHEDULE_GROUP.SKDGRP_INTRNL_TYPE = 12
| Metadata model reference | Database reference |
|---|---|
| Forecast Driver 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_VOLUME_TYPE.VOLTYP_LOC_NAME |
| 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 |
Forecast Item
| Metadata model reference | Database reference |
|---|---|
| Sales | FCST_ITEM.FCIT_SALES |
| Sales Per Hour | FCST_ITEM.FCIT_SPH |
| Sales Trend | FCST_ITEM.FCIT_SALES_TRD |
| Sales Trend Source | FCST_ITEM.FCIT_SALES_TRD_SRC |
| Payroll | FCST_ITEM.FCIT_PAYROLL |
| Payroll Percentage | FCST_ITEM.FCIT_PAYROLL_PCT |
| Payroll Trend | FCST_ITEM.FCIT_PYRLL_TRD |
| Payroll Trend Source | FCST_ITEM.FCIT_PYRLL_TRD_SRC |
| Average Hourly Rate | FCST_ITEM.FCIT_AHR |
| Additional Event Hours | FCST_ITEM.FCIT_EVT_HRS |
| Hours | FCST_ITEM.FCIT_HOURS |
| Minimum Hours | FCST_ITEM.FCIT_MIN_HOURS |
| Maximum Hours | FCST_ITEM.FCIT_MAX_HOURS |
| Schedule Hours | FCST_ITEM.FCIT_SCH_HRS |
| Productive Hours | FCST_ITEM.FCIT_PROD_HOURS |
| Staffing Requirements Hours | FCST_ITEM.FCIT_STF_REQ_HRS |
| Volume Driven Hours | FCST_ITEM.FCIT_VOL_DRV_HRS |
| Variable Hours | FCST_ITEM.FCIT_VAR_HRS |
| Vacation Hours | FCST_ITEM.FCIT_VAC_HOURS |
| Holiday Hours | FCST_ITEM.FCIT_HOL_HOURS |
| Other Hours | FCST_ITEM.FCIT_OTHER_HOURS |
| Scheduling Factor | FCST_ITEM.FCIT_SCH_FACTOR |
| Variable Coefficient | FCST_ITEM.FCIT_PR_FACTOR |
| Custom Forecast Items > FCIT_ITEM? | FCST_ITEM.FCIT_ITEM? |
| Keys > FC_ID | FCST_ITEM.FC_ID |
| Keys > FCIT_ID | FCST_ITEM.FCIT_ID |
| Keys > FCLS_ID | FCST_ITEM.FCLS_ID |
| Keys > FCTP_ID | FCST_ITEM.FCTP_ID |
Forecast Location
| Metadata model reference | Database reference |
|---|---|
| Location Type | WFMBurst |
| Location Type Description | FCST_LOC_TYPE.FCLTP_DESC |
| Released on Creation | FCST_LOCATION.FCLOC_FC_INIT_REL |
| Forecast Location UDFs > FCLOC_FLAG? | FCST_LOCATION.FCLOC_FLAG? |
| Forecast Location UDFs > FCLOC_UDF? | FCST_LOCATION.FCLOC_UDF? |
| Keys > SKDGRP_ID | FCST_LOCATION.SKDGRP_ID |
| Foreign Keys > FCLTP_ID | FCST_LOCATION.FCLTP_ID |
Forecast Location Summary
| Metadata model reference | Database reference |
|---|---|
| State | FCST_STATE.FCST_LOC_NAME |
| Forecast Location Summary UDFs > FCLS_FLAG? | FCST_LOC_SUMMARY.FCLS_FLAG? |
| Forecast Location Summary UDFs > FCLS_UDF? | FCST_LOC_SUMMARY.FCLS_UDF? |
| Keys > FC_ID | FCST_LOC_SUMMARY.FC_ID |
| Keys > FCLS_ID | FCST_LOC_SUMMARY.FCLS_ID |
| Keys > FCST_ID | FCST_LOC_SUMMARY.FCST_ID |
| Keys > SKDGRP_ID | FCST_LOC_SUMMARY.SKDGRP_ID |
Forecast Location Type
| Metadata model reference | Database reference |
|---|---|
| Location Type | FCST_LOC_TYPE.FCLTP_NAME |
| Location Description | FCST_LOC_TYPE.FCLTP_DESC |
| Keys > FCLTP_ID | FCST_LOC_TYPE.FCLTP_ID |
| Keys > FCLTP_PARENT_ID | FCST_LOC_TYPE.FCLTP_PARENT_ID |
Forecast Time Period
| Metadata model reference | Database reference |
|---|---|
| Time Period | VL_FCST_TIME_PERIOD.FCTP_LOC_NAME |
| Time Period Description | VL_FCST_TIME_PERIOD.FCTP_LOC_DESC |
| Start Date | VL_FCST_TIME_PERIOD.FCTP_START_DATE |
| End Date | VL_FCST_TIME_PERIOD.FCTP_END_DATE |
| Keys > FCTP_ID | VL_FCST_TIME_PERIOD.FCTP_ID |
| Keys > FCTP_PARENT_ID | VL_FCST_TIME_PERIOD.FCTP_PARENT_ID |
Historical Payroll Cost
| Metadata model reference | Database reference |
|---|---|
| Date | SO_ACTUAL_PAY_COST.ACTPAYCST_DATE |
| Rate | SO_ACTUAL_PAY_COST.ACTPAYCST_RATE |
| Hours | SO_ACTUAL_PAY_COST.ACTPAYCST_HOURS |
| Foreign Keys > EMP_ID | SO_ACTUAL_PAY_COST.EMP_ID |
| Foreign Keys > SKDGRP_ID | SO_ACTUAL_PAY_COST.SKDGRP_ID |
Hour Type
| 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 |
Import Details
| Metadata model reference | Database reference |
|---|---|
| Record Number | WBINT_IMPORT.WBIMP_RECNUM |
| Processed Date | WBINT_IMPORT.WBIMP_PROC_DATE |
| Record Status | WBINT_IMPORT.WBIMP_STATUS |
| Record Message | WBINT_IMPORT.WBIMP_MSG |
| Keys > WBIMP_ID | WBINT_IMPORT.WBIMP_ID |
| Keys > WBITRAN_ID | WBINT_IMPORT.WBITRAN_ID |
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 Title Code | JOB.JOB_PBJ_TITLE_CODE |
| Job UDFs > JOB_REFKEY? | JOB.JOB_REFKEY? |
| Job UDFs > JOB_VAL? | JOB.JOB_VAL? |
| Keys > JOB_ID | JOB.JOB_ID |
Job Rate
| Metadata model reference | Database reference |
|---|---|
| Index | JOB_RATE.JOBRATE_INDEX |
| Effective Date | JOB_RATE.JOBRATE_EFFECTIVE_DATE |
| Rate | JOB_RATE.JOBRATE_RATE |
| Job Rate UDFs > JOBRATE_FLAG? | JOB_RATE.JOBRATE_FLAG? |
| Job Rate UDFs > JOBRATE_VAL? | JOB_RATE.JOBRATE_VAL? |
| Foreign Keys > JOB_ID | JOB_RATE.JOBRATE_ID |
Last Logged
| Metadata model reference | Database reference |
|---|---|
| Last Logged | JOBSKD_LASTLOGGED.LastLogged |
| Keys > JSTSK_ID | JOBSKD_LASTLOGGED.JSTSK_ID |
Latest Published Info
| Metadata model reference | Database reference |
|---|---|
| Published Date | FCST_PUB_FORECAST.FCPUB_DATE |
| Unpublished Date | FCST_PUB_FORECAST.FCPUB_UNPUB_DATE |
| User Name | FCST_PUB_FORECAST.WBU_NAME_ACTUAL |
| Is Active | FCST_PUB_FORECAST.FCPUB_ACTIVE |
| Keys > FC_ID | FCST_PUB_FORECAST.FC_ID |
| Keys > WBU_ID | FCST_PUB_FORECAST.WBU_ID |
Leave Reason
| Metadata model reference | Database reference |
|---|---|
| Leave Reason Name | ES_LEAVE_REASON.ESLVR_NAME |
| Leave Reason Description | ES_LEAVE_REASON.ESLVR_DESC |
| Keys > ESLVR_ID | ES_LEAVE_REASON.ESLVR_ID |
| UDFs > ESLVR_FLAG? | ES_LEAVE_REASON.ESLVR_FLAG? |
| UDFs > ESLVR_UDF? | ES_LEAVE_REASON.ESLVR_UDF? |
Location
WFMBurst Burst Actual Results, Burst Forecasting, Burst Historical Payroll Cost, Burst Labor Budgeting, Burst Schedule Analysis, Burst Scheduling, Burst Staffing, Burst Work
WFMStandard Actual Results, Availability, Employee Information, Historical Payroll Cost, Scheduling, Work
| Metadata model reference | Database reference |
|---|---|
| Location 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_TYPE |
| 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 > WBT_ID | SO_SCHEDULE_GROUP.WBT_ID |
| Keys > VOLTYP_ID | SO_SCHEDULE_GROUP.VOLTYP_ID |
Location
Denormalized conformed location hierarchy, up to the store level.
| Metadata model reference | Database reference |
|---|---|
| Department | VIEW_WBI_LOCATION_DIMENSION.DEPARTMENT_NAME |
| Driver | VIEW_WBI_LOCATION_DIMENSION.DRIVER_NAME |
| Store | VIEW_WBI_LOCATION_DIMENSION.STORE_NAME |
| Keys > SKDGRP_ID | VIEW_WBI_LOCATION_DIMENSION.SKDGRP_ID |
| Keys > WBT_ID | VIEW_WBI_LOCATION_DIMENSION.WBT_ID |
| Keys > STORE_SKDGRP_ID | VIEW_WBI_LOCATION_DIMENSION.STORE_SKDGRP_ID |
| Keys > STORE_WBT_ID | VIEW_WBI_LOCATION_DIMENSION.STORE_WBT_ID |
Location Properties
| Metadata model reference | Database reference |
|---|---|
| Property Name | SO_LOCATION_PROP.PROP_LOC_NAME |
| Property Description | SO_LOCATION_PROP.PROP_LOC_DESC |
| Location Property Description | SO_LOCATION_PROP.LOCPROP_LOC_DESC |
| Location Property Value | SO_LOCATION_PROP.LOCPROP_VALUE |
| Location Property UDFs > LOCPROP_FLAG? | SO_LOCATION_PROP.LOCPROP_FLAG? |
| Location Property UDFs > LOCPROP_UDF? | SO_LOCATION_PROP.LOCPROP_UDF? |
| Keys > LOCPROP_ID | SO_LOCATION_PROP.LOCPROP_ID |
| Keys > PROP_ID | SO_LOCATION_PROP.PROP_ID |
| Keys > SKDGRP_ID | SO_LOCATION_PROP.SKDGRP_ID |
Location Property Workload
| Metadata model reference | Database reference |
|---|---|
| Volume per hour | SO_LOCPROP_WORKLD.PRWRKLD_STDVOL_HR |
| Location Property Workload UDFs > PRWRKLD_FLAG? | SO_LOCPROP_WORKLD.PRWRKLD_FLAG? |
| Location Property Workload UDFs > PRWRKLD_UDF? | SO_LOCPROP_WORKLD.PRWRKLD_UDF? |
| Keys > CSD_ID | SO_LOCPROP_WORKLD.CSD_ID |
| Keys > LOCPROP_ID | SO_LOCPROP_WORKLD.LOCPROP_ID |
| Keys > PRWRKLD_ID | SO_LOCPROP_WORKLD.PRWRKLD_ID |
Machine
| Metadata model reference | Database reference |
|---|---|
| Machine Name | MACHINE.MACH_NAME |
| Machine Description | MACHINE.MACH_DESC |
| Keys > MACH_ID | MACHINE.MACH_ID |
| Foreign Keys > LOC_ID | MACHINE.LOC_ID |
Month Time Period
Query Subject Filter: Days between Start Date and End Date is > 25 and < 35 days
| Metadata model reference | Database reference |
|---|---|
| Month | FCST_TIME_PERIOD.FCTP_LOC_NAME |
| Month Description | FCST_TIME_PERIOD.FCTP_LOC_DESC |
| Start Date | FCST_TIME_PERIOD.FCTP_START_DATE |
| End Date | FCST_TIME_PERIOD.FCTP_END_DATE |
| Keys > FCTP_ID | FCST_TIME_PERIOD.FCTP_ID |
| Keys > FCTP_PARENT_ID | FCST_TIME_PERIOD.FCTP_PARENT_ID |