WFMStandard, WFMSystem and WFMBurst

Activity

WFMStandard

Scheduling

Activity > Activity Name

SO_ACTIVITY.ACT_NAME

Scheduling MVS > Shift Definition

Activity > Activity Description

SO_ACTIVITY.ACT_DESC

Activity > Is Paid

SO_ACTIVITY.ACT_PAID

Activity > Is Working

SO_ACTIVITY.ACT_WORKING

Activity > Contributes to Cost

SO_ACTIVITY.ACT_CONT_TO_COST

Activity > Keys > ACT_ID

SO_ACTIVITY.ACT_ID

Activity > Keys > SKDGRP_ID

SO_ACTIVITY.SKDGRP_ID

Activity > Keys > TCODE_ID

SO_ACTIVITY.TCODE_ID

Actual Results

WFMBurst

Burst Actual Results

Actual Results > Result Date

SO_RESULTS_DETAIL.RESDET_DATE

WFMStandard

Actual Results

Actual Results > Volume

SO_RESULTS_DETAIL.RESDET_VOLUME

Actual Results > Volume Type

VL_SO_VOLUME_TYPE.VOLTYP_LOC_NAME

Actual Results > Results Detail Generated

SO_RESULTS_DETAIL.RESDET_GENERATED

Actual Results > Foreign Keys > SKDGRP_ID

SO_RESULTS_DETAIL.SKDGRP_ID

Actual User

WFMStandard

Scheduling MVS > Scheduled Shifts > Call Logs

Actual User > User Name

WORKBRAIN_USER.WBU_NAME

Scheduling MVS > Scheduled Shifts > Shift Offers

Actual User > Email

WORKBRAIN_USER.WBU_EMAIL

Scheduling MVS > Rotations > Rotation Publish Tasks

Actual User > Is Active

WORKBRAIN_USER.WBU_ACTIVE

Actual User > Bad Login Count

WORKBRAIN_USER.WBU_BAD_LOGIN_COUNT

Actual User > Language

WORKBRAIN_LANGUAGE.WBL_NAME

Actual User > Locale

WORKBRAIN_LANGUAGE.WBL_LOCALE

Actual User > Ming.le Identifier

WORKBRAIN_USER.WBU_IDENTITY2

Actual User > Keys > EMP_ID

WORKBRAIN_USER.EMP_ID

Actual User > Keys >WBU_ID

WORKBRAIN_USER.WBU_ID

Actual User > UDFs > WBU_FLAG?

WORKBRAIN_USER.WBU_FLAG?

Actual User > UDFs > WBU_UDF?

WORKBRAIN_USER.WBU_UDF?

Approval State

WFMStandard

Work

Approval State > State

EA_TIME_APPROVAL_STATE.EATST_NAME

Approval State > State Description

EA_TIME_APPROVAL_STATE.EATST_DESC

Approval State > Keys > EATST_ID

EA_TIME_APPROVAL_STATE.EATST_ID

Approval Status

WFMStandard

Work

Approval Status > Status

EA_TIME_APPROVAL_STATUS.EATSTS_NAME

Approval Status > Status Description

EA_TIME_APPROVAL_STATUS.EATSTS_DESC

Approval Status > Keys > EATST_ID

EA_TIME_APPROVAL_STATUS.EATSTS_ID

Associated Parent Job

WFMStandard

Scheduling MVS > Call List

Associated Parent Job > Job Name

JOB for ES_JOB_ASSOCIATION.JOB_NAME

Scheduling MVS > Rotations > Row Labor Metrics

Associated Parent Job > Job Description

JOB for ES_JOB_ASSOCIATION.JOB_DESC

Scheduling MVS > Scheduled Detail

Associated Parent Job > Is Job Tipped

JOB for ES_JOB_ASSOCIATION.JOB_TIP

Scheduling MVS > Schedule Templates > Shift Requirement Template

Associated Parent Job > Healthcare Type

JOB for ES_JOB_ASSOCIATION.JOB_RPT_HCTYPE

Scheduling MVS > Schedule Template > Staffing Requirement Template

Associated Parent Job > Job Association Rank

ES_JOB_ASSOCIATION.JOBASSOC_RANK

Scheduling MVS > Workload > Workload Requirement

Associated Parent Job > UDFs > JOB_FLAG?

JOB for ES_JOB_ASSOCIATION.JOB_FLAG?

Associated Parent Job > UDFs > JOB_REFKEY?

JOB for ES_JOB_ASSOCIATION.JOB_REFKEY?

Associated Parent Job > UDFs > JOB_VAL?

JOB for ES_JOB_ASSOCIATION.JOB_VAL?

Associated Parent Job > UDFs > JOBASSOC_FLAG?

ES_JOB_ASSOCIATION.JOBASSOC_FLAG?

Associated Parent Job > UDFs > JOBASSOC_UDF?

ES_JOB_ASSOCIATION.JOBASSOC_UDF?

Associated Parent Job > Keys > JOB_ID

JOB for ES_JOB_ASSOCIATION.JOB_ID

Associated Parent Job > Keys > JOBASSOC_ID

ES_JOB_ASSOCIATION.JOBASSOC_ID

Associated Parent Job > Foreign Keys > JOB_CHILD_ID

ES_JOB_ASSOCIATION.JOB_CHILD_ID

Audit Log

WFMSystem

System Information > Audit Tracking

Audit Log > User Name

AUDIT_LOG.WBU_NAME

Audit Log > Action

AUDIT_LOG.AUDLOG_ACTION

Audit Log > Change Date

AUDIT_LOG.CHANGE_DATE

Audit Log > Change Time

AUDIT_LOG.CHANGE_DATE

Audit Log > Table

AUDIT_LOG.TABLENAME

Audit Log > Field

AUDIT_LOG.FIELDNAME

Audit Log > Old Value

AUDIT_LOG.OLD_VALUE

Audit Log > New Value

AUDIT_LOG.NEW_VALUE

Audit Log > Keys > AUDLOG_ID

AUDIT_LOG.AUDLOG_ID

Availability

WFMStandard

Availability

Availability > Available Date

AMX_AVAIL_SUMMARY.AMXAVS_DATE

Scheduling

AMX_AVAIL_DETAIL.AMXAVD_ACT_MINUTES / 60

Availability > Available Start Time Availability > Available Hours

AMX_AVAIL_DETAIL.AMXAVD_ACT_ST_TM

Availability > Available End Time

AMX_AVAIL_DETAIL.AMXAVD_ACT_END_TM

Availability > Foreign Keys > EMP_ID

AMX_AVAIL_SUMMARY.EMP_ID

Availability > Foreign Keys > WBT_ID

AMX_AVAIL_SUMMARY.WBT_ID

Bad Reason

WFMStandard

Bad Reason

Bad Reason > Bad Reason Code Name

[REASON_CODE].[RSNCD_LOC_NAME]

Bad Reason > Bad Reason Code Description

REASON_CODE].[RSNCD_LOC_DESC]

Bad Reason > RSNCD_FLAG1

[REASON_CODE].[RSNCD_FLAG1]

Bad Reason > RSNCD_FLAG2

[REASON_CODE].[RSNCD_FLAG2]

Bad Reason > RSNCD_FLAG3

[REASON_CODE].[RSNCD_FLAG3]

Bad Reason > RSNCD_FLAG4

[REASON_CODE].[RSNCD_FLAG4]

Bad Reason > RSNCD_FLAG5

[REASON_CODE].[RSNCD_FLAG5]

Bad Reason > RSNCD_UDF1

[REASON_CODE].[RSNCD_UDF1]

Bad Reason > RSNCD_UDF2

[REASON_CODE].[RSNCD_UDF2]

Bad Reason > RSNCD_UDF3

[REASON_CODE].[RSNCD_UDF3]

Bad Reason > RSNCD_UDF4

[REASON_CODE].[RSNCD_UDF4]

Bad Reason > RSNCD_UDF5

[REASON_CODE].[RSNCD_UDF5]

Bad Reason > RSNCD_ID

REASON_CODE].[RSNCD_ID]

Balance

WFMStandard

Employee Balances

Balance > Balance Name

VL_BALANCE.BAL_LOC_NAME

Balance > Balance Description

VL_BALANCE.BAL_LOC_DESC

Balance > Available Value

VL_BALANCE.BAL_MAX - EMPLOYEE_BALANCE.EMPBAL_VALUE

Balance > Current Balance

EMPLOYEE_BALANCE.EMPBAL_VALUE - EMPLOYEE_BALANCE.FUTURE_BAL

Balance > Current Value

EMPLOYEE_BALANCE.EMPBAL_VALUE

Balance > Keys > BAL_ID

EMPLOYEE_BALANCE.BAL_ID

Balance > Foreign Keys > EMP_ID

EMPLOYEE_BALANCE.EMP_ID

Balance Transaction

WFMStandard

Employee Balances

Balance Transaction > Date

EMPLOYEE_BALANCE_LOG.WRKS_WORK_DATE

Balance Transaction > Delta

EMPLOYEE_BALANCE_LOG.EBLOG_DELTA

Balance Transaction > Message

EMPLOYEE_BALANCE_LOG.EBLOG_MESSAGE

Balance Transaction > Comment

EMPLOYEE_BALANCE_LOG.EBLOG_COMMENT

Balance Transaction > Foreign Keys > BAL_ID

EMPLOYEE_BALANCE_LOG.BAL_ID

Balance Transaction > Foreign Keys > EMP_ID

EMPLOYEE_BALANCE_LOG.EMP_ID

Bookoff Comments

WFMStandard

Scheduling MVS > Scheduled Shifts

Book Comments > Bookoff Comment

ES_BOOKOFF_COMMENTS.ESBOCMT_COMMENT

Book Comments > Keys > ESBOCMT_ID

ES_BOOKOFF_COMMENTS.ESBOCMT_ID

Budgeted Hours Per Patient Day

WFMStandard

Workload > Budgeted Hours Per Patient Day

Budgeted HPPD > Budgeted HPPD Start Date

ES_BUDG_HRS_PER_PATIENT_DAY.BHPPD_EFF_START_DATE

Budgeted HPPD > Budgeted HPPD End Date

ES_BUDG_HRS_PER_PATIENT_DAY.BHPPD_EFF_END_DATE

Budgeted HPPD > Budgeted HPPD Hours

ES_BUDG_HRS_PER_PATIENT_DAY.BHPPD_HOURS

UDFs > BHPPD_FLAG1~5

ES_BUDG_HRS_PER_PATIENT_DAY.BHPPD_FLAG1~5

UDFs > BHPPD_UDF1~5

ES_BUDG_HRS_PER_PATIENT_DAY.BHPPD_UDF1~5

Keys > BHPPD_ID

ES_BUDG_HRS_PER_PATIENT_DAY.BHPPD_ID

Foreign Keys > WBT_ID

ES_BUDG_HRS_PER_PATIENT_DAY.WBT_ID

Budgeting Forecast

WFMBurst

Burst Labor Budgeting

Budgeting Forecast > Forecast Name

FORECAST.FC_NAME

WFMStandard

Scheduling

Budgeting Forecast > Forecast Description

FORECAST.FC_DESC

Budgeting Forecast > Forecast Creation Date

FORECAST.FC_CREATED_DATE

Budgeting Forecast > Forecast Type

FCST_TYPE.FCTYP_NAME

Budgeting Forecast > Keys > FC_ID

FORECAST.FC_ID

Budgeting Forecast > Keys > FC_MASTER_FC_ID

FORECAST.FC_MASTER_FC_ID

Budgeting Forecast > Foreign Keys > FCRG_ID

FORECAST.FCRG_ID

Budgeting Forecast > Foreign Keys > FCTP_ID

FORECAST.FCTP_ID

Budgeting Forecast > Foreign Keys > FCTYP_ID

FORECAST.FCTYP_ID

Budgeting Forecast > Foreign Keys > FCVER_ID

FORECAST.FCVER_ID

Budgeting Forecast > Foreign Keys > FCVER_ID

FORECAST.SKDGRP_ID

Budgeting Forecast > Foreign Keys > WBU_ID

FORECAST.WBU_ID

Burst Employee

WFMBurst

Burst Employee Information

Burst Employee > Employee ID

[EMPLOYEE].[EMP_NAME]

Burst Employee > Full Name

[EMPLOYEE].[EMP_FULLNAME]

Burst Employee > Last Name

[EMPLOYEE].[EMP_LASTNAME]

Burst Employee > Birth Date

[EMPLOYEE].[EMP_BIRTH_DATE]

Burst Employee > Effective Date

[EMPLOYEE].[EMP_EFFECTIVE_DATE]

Burst Employee > FTE

[EMPLOYEE].[EMP_FTE]

Burst Employee > Hire Date

[EMPLOYEE].[EMP_HIRE_DATE]

Burst Employee > Seniority Date

[EMPLOYEE].[EMP_SENIORITY_DATE]

Burst Employee > Termination Date

[EMPLOYEE].[EMP_TERMINATION_DATE]

Burst Employee > Default Minutes

[EMPLOYEE].[EMP_DEF_MINUTES]

Burst Employee > Shift Pattern Offset

[EMPLOYEE].[EMP_SHFTPAT_OFFSET]

Burst Employee > SIN

[EMPLOYEE].[EMP_SIN]

Burst Employee > Status

[EMPLOYEE].[EMP_STATUS]

Burst Employee > Is Full time

[EMPLOYEE].[EMP_FULLTIME]

Burst Employee > Base Rate

[EMPLOYEE].[EMP_BASE_RATE]

Burst Employee > System Scheduling Enabled

[EMPLOYEE].[EMP_SYSTEM_SCHEDULING_ENABLED]

Burst Team

WFMBurst

Burst Actual Results

Burst Team > Team Name

WORKBRAIN_TEAM.WBT_NAME

Burst Census

Burst Team > Team Description

WORKBRAIN_TEAM.WBT_DESC

Burst Forecasting

Burst Team > Keys > WBU_ID

BURST_SEC_WB_TEAM.WBU_ID

Burst Historical Payroll Cost

Burst Team > Keys > WBT_ID

WORKBRAIN_TEAM.WBT_ID

Burst Labor Budgeting

Burst Team > Team UDFs > WBT_FLAG?

WORKBRAIN_TEAM.WBT_FLAG?

Burst Schedule Analysis

Burst Team > Team UDFs > WBT_UDF?

WORKBRAIN_TEAM.WBT_UDF?

Burst Scheduling

Burst Staffing

Burst Work

Call List

WFMStandard

Scheduling MVS > Call List

Call List > Call List Name

ES_CALL_LIST.CLIST_NAME

Call List > Call List Description

ES_CALL_LIST.CLIST_DESCRIPTION

Call List > Keys > CLIST_ID

ES_CALL_LIST.CLIST_ID

Call List > UDFs > CLIST_FLAG?

ES_CALL_LIST.CLIST_FLAG?

Call List > UDFs > CLIST_UDF?

ES_CALL_LIST.CLIST_UDF?

Call List Employees

WFMStandard

Scheduling MVS > Call List

Call List Employees > Employee Effective Start Date

ES_CLIST_EMPLOYEE.CLISTEMP_EFF_START_DATE

Call List Employees > Employee Effective End Date

ES_CLIST_EMPLOYEE.CLISTEMP_EFF_END_DATE

Call List Employees > UDFs > CLISTEMP_FLAG?

ES_CLIST_EMPLOYEE.CLISTEMP_FLAG4

Call List Employees > UDFs > CLISTEMP_UDF?

ES_CLIST_EMPLOYEE.CLISTEMP_UDF?

Call List Employees > Keys > CLISTEMP_ID

ES_CLIST_EMPLOYEE.CLISTEMP_ID

Call List Employees > Foreign Keys > EMP_ID

ES_CLIST_EMPLOYEE.EMP_ID

Call List Employees > Foreign Keys > SHFTTYP_ID

[ES_CLIST_EMPLOYEE].[SHFTTYP_ID]

Call List Employees > Foreign Keys > JOB_ID

ES_CLIST_EMPLOYEE.JOB_ID

Call List Employees > Foreign Keys > CLIST_ID

ES_CLIST_EMPLOYEE.CLIST_ID

Call List Teams

WFMStandard

Scheduling MVS > Call List

Call List Teams > Team Effective Start Date

ES_CLIST_TEAM.CLISTTM_EFF_START_DATE

Call List Teams > Team Effective End Date

ES_CLIST_TEAM.CLISTTM_EFF_END_DATE

Call List Teams > Keys > CLISTTM_ID

ES_CLIST_TEAM.CLISTTM_ID

Call List Teams > Foreign Keys > CLIST_ID

ES_CLIST_TEAM.CLIST_ID

Call List Teams > Foreign Keys > WBT_ID

ES_CLIST_TEAM.WBT_ID

Call List Teams > UDFs > CLISTEMP_FLAG?

ES_CLIST_TEAM.CLISTTM_FLAG1

Call List Teams > UDFs > CLISTEMP_UDF?

ES_CLIST_TEAM.CLISTTM_UDF1

Call Log

WFMStandard

Scheduling MVS > Scheduled Shifts > Call Logs

Call Log > Call Log Date

ES_CALL_LOG.CLOG_DATE

Call Log > Call Log Action

ES_CALL_LOG.CLOG_ACTION

Call Log > Call Log Comments

ES_CALL_LOG.CLOG_COMMENTS

Call Log > Call Log Coomplaince Error

ES_CALL_LOG.CLOG_CMPERROR

Call Log > Call Log Phone 1

ES_CALL_LOG.CLOG_PHONE1

Call Log > Call Log Phone 2

ES_CALL_LOG.CLOG_PHONE2

Call Log > Call Log Phone 3

ES_CALL_LOG.CLOG_PHONE3

Call Log > Call Log Scheduler Comments

ES_CALL_LOG.CLOG_SCHEDULER_COMMENTS

Call Log > Call Log Shift Detail Start Time

ES_CALL_LOG.CLOG_SHIFTDTL_START_TIME

Call Log > Call Log Shift Detail End Time

ES_CALL_LOG.CLOG_SHIFTDTL_END_TIME

Call List > UDFs > CLOG_FLAG?

ES_CALL_LOG.CLOG_FLAG?

Call List > UDFs > CLOG_UDF?

ES_CALL_LOG.CLOG_UDF?

Call Log > Keys > CLOG_ID

ES_CALL_LOG.CLOG_CLOG_ID

Call Log > Foreign Keys > SHIFTSUM_ID

ES_CALL_LOG.SHIFTSUM_ID

Call Log > Foreign Keys > EMP_ID

ES_CALL_LOG.EMP_ID

Call Log > Foreign Keys > REASON_ID

ES_CALL_LOG.REASON_ID

Call Log > Foreign Keys > WBU_ID

ES_CALL_LOG.WBU_ID

Call Log > Foreign Keys > WBU_ID_ACTUAL

ES_CALL_LOG.WBU_ID_ACTUAL

Calc Group

WFMBurst

Burst Census

Calc Group > Calc Group Name

VL_CALC_GROUP.CALCGRP_LOC_NAME

Burst Employee Information

Calc Group > Calc Group Description

VL_CALC_GROUP.CALCGRP_LOC_DESC

Burst Work

Calc Group > Calc Group UDFs > CALCGRP_FLAG?

VL_CALC_GROUP.CALCGRP_FLAG?

Burst Work Schedule Aggregration

Calc Group > Calc Group UDFs > CALCGRP_UDF?

VL_CALC_GROUP.CALCGRP_UDF?

WFMStandard

Employee Information

Calc Group > Keys > CALCGRP_ID

VL_CALC_GROUP.CALCGRP_ID

Work

WFMSystem

System Information > Errors and Exceptions

Census

WFMBurst

Burst Census

Census > Census

CENSUS_DATA.CENSDT_USAGE

Census > Date

CENSUS_DATA.CENSDT_DATE

Census > Required

CENSUS_DATA.CENSDT_REQUIRED

Census > Census Fields > CENSDT_FIELD?

CENSUS_DATA.CENSDT_FIELD?

Census > Keys > CENSDT_ID

CENSUS_DATA.CENSDT_ID

Census > Foreign Keys > JOB_ID

CENSUS_DATA.JOB_ID

Census > Foreign Keys > DP_ID

CENSUS_DATA.DP_ID

Census > Foreign Keys > CENSTM_ID

CENSUS_DATA.CENSTM_ID

Census Team

WFMBurst

Burst Census

Census Team > Census Team

CENSUS_TEAM.CENSTM_NAME

Census Team > Census Team Start Date

CENSUS_TEAM.CENSTM_START_DATE

Census Team > Census Team End Date

CENSUS_TEAM.CENSTM_END_DATE

Census Team > Foreign Keys > WBT_ID

CENSUS_TEAM.WBT_ID

Census Team > Foreign Keys > CENSTM_ID

CENSUS_TEAM.CENSTM_ID

Clock Data

The Clock Time data item uses a database function to parse the CLOCK_TRAN_REJ_J.CTRJ_TIME string to return a datetime value.

WFMSystem

System Information > Errors and Exceptions

Clock Data > Clock Time

CLOCK_TRAN_REJ_J.Clock_Time

Clock Data > Transaction Type Name

CLOCK_TRAN_REJ_J.CTRJ_TYPE

Clock Data > Transaction Type Description

Availability Clock Data > Error Message

CLOCK_TRAN_REJ_J.CTRJ_ERR_MESSAGE

Clock Data > In Exception

if (CLOCK_TRAN_REJ_J.CTRJ_TYPE = '01' then CLOCK_TRAN_REJ_J.CTRJ_ERR_MESSAGE) else ('--')

Clock Data > Out Exception

if (CLOCK_TRAN_REJ_J.CTRJ_TYPE = '02' then CLOCK_TRAN_REJ_J.CTRJ_ERR_MESSAGE) else ('--')

Clock Data > Other Exception

if (CLOCK_TRAN_REJ_J.CTRJ_TYPE <> '01' and CLOCK_TRAN_REJ_J.CTRJ_TYPE <> '02') then (CLOCK_TRAN_REJ_J.CTRJ_ERR_MESSAGE) else ('--')

Clock Data > IP Address

CLOCK_TRAN_REJ_J.CTRJ_IP

Clock Data > Latitude

CLOCK_TRAN_REJ_J.CTPJ_LAT

Clock Data > Longitude

CLOCK_TRAN_REJ_J.CTPJ_LNG

Clock Data > Foreign Keys > EMP_ID

CLOCK_TRAN_REJ_J.EMP_ID

Clock Data > Foreign Keys > CLOCK_DATE

cast(CLOCK_TRAN_REJ_J.CTRJ_TIME, date)

Compliance Group Rules

WFMStandard

Scheduling

Compliance Group Rules > Rule Name

CMPLNC_GROUP_RULE.CMPGRPR_NAME

Compliance Group Rules > Rule Description

CMPLNC_GROUP_RULE.CMPGRPR_DESC

Compliance Group Rules > Rule Type

CMPLNC_GROUP_RULE.CMPGRPR_TYPE

Compliance Group Rules > Violation Message

CMPLNC_GROUP_RULE.CMPGRPR_MESSAGE

Compliance Group Rules > Group Rule UDFs > CMPGRPR_FLAG?

CMPLNC_GROUP_RULE.CMPGRPR_FLAG?

Compliance Group Rules > Group Rule UDFs > CMPGRPR_UDF?

CMPLNC_GROUP_RULE.CMPGRPR_UDF2?

Compliance Group Rules > Keys > CMPGRPR_ID

CMPLNC_GROUP_RULE.CMPGRPR_ID

Compliance Group Rules > Foreign Keys > CMPRL_ID

CMPLNC_GROUP_RULE.CMPRL_ID

Compliance Group Rules > Foreign Keys > CMPGRP_ID

CMPLNC_GROUP_RULE.CMPGRP_ID

Compliance Group

WFMStandard

Scheduling MVS > Rotations > Row Labour Metrics

Compliance Group > Compliance Group Name

CMPLNC_GROUP.CMPGRP_NAME

Compliance Group > Compliance Group Description

CMPLNC_GROUP.CMPGRP_DESC

Compliance Group > Compliance Effective Start Date

CMPLNC_GROUP.CMPGRP_EFF_START_DATE

Compliance Group > Compliance Effective End Date

CMPLNC_GROUP.CMPGRP_EFF_END_DATE

Compliance Group > Is Compliance Enabled

CMPLNC_GROUP.CMPGRP_IS_ENABLED

Compliance Group > Enforce Calendar Day Cut

CMPLNC_GROUP.CMPGRP_CALENDAR_DAY_CUT

Compliance Group > UDFs > CMPGRP_FLAG?

CMPLNC_GROUP.CMPGRP_FLAG?

Compliance Group > UDFs > CMPGRP_UDF?

CMPLNC_GROUP.CMPGRP_UDF?

Compliance Group > Keys > CMPGRP_ID

CMPLNC_GROUP.CMPGRP_ID

Compliance Violations

WFMStandard

Scheduling

Compliance Violations > Approval Date

CMPLNC_VIOLATION.CMPVIO_APRVL_DATE

Scheduling MVS > Rotations > Row Shifts

Compliance Violations > Approved By

CMPLNC_VIOLATION.WBU_NAME_ACTUAL

Compliance Violations > Is Violation Active

CMPLNC_VIOLATION.CMPVIO_IS_ACTIVE

Compliance Violations > Is Violation Approved

CMPLNC_VIOLATION.CMPVIO_IS_APRVD

Compliance Violations > User Name

CMPLNC_VIOLATION.WBU_NAME

Compliance Violations > Violation Create Date

CMPLNC_VIOLATION.CMPVIO_CREATE_DATE

Compliance Violations > Violation Start Date

CMPLNC_VIOLATION.CMPVIO_START_DATE

Compliance Violations > Violation End Date

CMPLNC_VIOLATION.CMPVIO_END_DATE

Compliance Violations > Violation Message

CMPLNC_VIOLATION.CMPVIO_MESSAGE

Compliance Violations > Violation Value

CMPLNC_VIOLATION.CMPVIO_VALUE

Compliance Violations > Violation UDFs > CMPIO_FLAG?

CMPLNC_VIOLATION.CMPVIO_ID

Compliance Violations > Violation UDFs > CMPIO_UDF?

CMPLNC_VIOLATION.CMPGRPR_ID

Compliance Violations > Keys > CMPVIO_ID

CMPLNC_VIOLATION.EMP_ID

Compliance Violations > Foreign Keys > CMPGRPR_ID

CMPLNC_VIOLATION.CMPVIO_FLAG?

Compliance Violations > Foreign Keys > EMP_ID

CMPLNC_VIOLATION.CMPVIO_UDF?

Currency

WFMStandard, WFMBurst

Work, Employee Information, Burst Work, Burst Employee Information

Currency > Currency Name

[CURRENCY].[CUR_NAME]

Currency > Currency Description

[CURRENCY].[CUR_DESCRIPTION]

Currency > UDFs > CUR_FLAG[1-5]

[CURRENCY].[CUR_FLAG*]

Currency > UDFs > CUR_UDF[1-5]

[CURRENCY].[CUR_UDF*]

Currency > Keys > CUR_ID

[CURRENCY].[CUR_ID]

Currency (User Locale)

WFMStandard, WFMBurst

Work, Employee Information, Burst Work, Burst Employee Information

Currency (User Locale) > Currency Name

[WORKBRAIN_LOCALE CURRENCY].[CUR_NAME]

Currency (User Locale) > Currency Description

[WORKBRAIN_LOCALE CURRENCY].[CUR_DESCRIPTION]

Currency (User Locale) > UDFs > CUR_FLAG[1-5]

[WORKBRAIN_LOCALE CURRENCY].[CUR_FLAG*]

Currency (User Locale) > UDFs > CUR_UDF[1-5]

[WORKBRAIN_LOCALE CURRENCY].[CUR_UDF*]

Currency (User Locale) > Keys > CUR_ID

[WORKBRAIN_LOCALE].[CUR_ID]

Currency Conversion Group

WFMStandard, WFMBurst

Work, Employee Information, Burst Work, Burst Employee Information

Currency Conversion Group > Currency Group Name

[CURRENCY_CONVERSION_GROUP].[CONGR_NAME]

Currency Conversion Group > Currency Group Description

[CURRENCY_CONVERSION_GROUP].[CONGR_DESC]

Currency Conversion Group > UDFs > CONGR_FLAG[1-5]

[CURRENCY_CONVERSION_GROUP].[CONGR_FLAG*]

Currency Conversion Group > UDFs > CONGR_UDF[1-5]

[CURRENCY_CONVERSION_GROUP].[CONGR_UDF*]

Currency Conversion Group > Keys > CONGR_ID

[CURRENCY_CONVERSION_GROUP].[CONGR_ID]

Currency Conversion (Work Day)

WFMStandard, WFMBurst

Work, Burst Work

Curency Conversion (Work Day) > Currency Conversion Start Date

[CURRENCY_CONVERSION].[CURCON_START_DATE]

Curency Conversion (Work Day) > Currency Conversion End Date

[CURRENCY_CONVERSION].[CURCON_END_DATE]

Curency Conversion (Work Day) > Currency Conversion Rate

[CURRENCY_CONVERSION].[CURCON_RATE]

Curency Conversion (Work Day) > UDFs > CURCON_FLAG[1-5]

[CURRENCY_CONVERSION].[CURCON_FLAG*]

Curency Conversion (Work Day) > UDFs > CURCON_UDF[1-5]

[CURRENCY_CONVERSION].[CURCON_UDF*]

Curency Conversion (Work Day) > Keys > CURCON_ID

[CURRENCY_CONVERSION].[CURCON_ID]

Curency Conversion (Work Day) > Foreign Keys > CUR_SOURCE_ID

[CURRENCY_CONVERSION].[CUR_SOURCE_ID]

Curency Conversion (Work Day) > Foreign Keys > CUR_TARGET_ID

[CURRENCY_CONVERSION].[CUR_TARGET_ID]

Curency Conversion (Work Day) > Foreign Keys > CONGR_ID

[CURRENCY_CONVERSION].[CONGR_ID]

Currency Conversion (Work Adjustments)

WFMStandard

Work

Curency Conversion (Work Day) > Currency Conversion Start Date

CURRENCY_CONVERSION].[CURCON_START_DATE]

Curency Conversion (Work Day) > Currency Conversion End Date

[CURRENCY_CONVERSION].[CURCON_END_DATE]

Curency Conversion (Work Day) > Currency Conversion Rate

[CURRENCY_CONVERSION].[CURCON_RATE]

Curency Conversion (Work Day) > UDFs > CURCON_FLAG[1-5]

[CURRENCY_CONVERSION].[CURCON_FLAG*]

Curency Conversion (Work Day) > UDFs > CURCON_UDF[1-5]

[CURRENCY_CONVERSION].[CURCON_UDF*]

Curency Conversion (Work Day) > Keys > CURCON_ID

[CURRENCY_CONVERSION].[CURCON_ID]

Curency Conversion (Work Day) > Foreign Keys > CUR_SOURCE_ID

[CURRENCY_CONVERSION].[CUR_SOURCE_ID]

Curency Conversion (Work Day) > Foreign Keys > CUR_TARGET_ID

[CURRENCY_CONVERSION].[CUR_TARGET_ID]

Curency Conversion (Work Day) > Foreign Keys > CONGR_ID

[CURRENCY_CONVERSION].[CONGR_ID]

Currency Conversion

WFMStandard, WFMBurst

Employee Information, Burst Employee Information

Curency Conversion > Currency Conversion Start Date

[CURRENCY_CONVERSION].[CURCON_START_DATE]

Curency Conversion > Currency Conversion End Date

[CURRENCY_CONVERSION].[CURCON_END_DATE]

Curency Conversion > Currency Conversion Rate

[CURRENCY_CONVERSION].[CURCON_RATE]

Curency Conversion > UDFs > CURCON_FLAG[1-5]

[CURRENCY_CONVERSION].[CURCON_FLAG*]

Curency Conversion > UDFs > CURCON_UDF[1-5]

[CURRENCY_CONVERSION].[CURCON_UDF*]

Curency Conversion > Keys > CURCON_ID

[CURRENCY_CONVERSION].[CURCON_ID]

Curency Conversion > Foreign Keys > CUR_SOURCE_ID

[CURRENCY_CONVERSION].[CUR_SOURCE_ID]

Curency Conversion > Foreign Keys > CUR_TARGET_ID

[CURRENCY_CONVERSION].[CUR_TARGET_ID]

Curency Conversion > Foreign Keys > CONGR_ID

[CURRENCY_CONVERSION].[CONGR_ID]

Day of Week

WFMStandard

Scheduling MVS > Shift Preferences > Shift Preference

Day of Week > Day Name

DAY_OF_WEEK.DAY_NAME

Scheduling MVS > Shift Preferences > Shift Preference History

Day of Week > Day Description

DAY_OF_WEEK.DAY_DESC

Day of Week > Day Code

DAY_OF_WEEK.DAY_CODE

Day of Week > Keys > DAY_ID

DAY_OF_WEEK.DAY_ID

Day of Week > UDFs > DAY_FLAG?

DAY_OF_WEEK.DAY_FLAG?

Day of Week > UDFs > DAY_UDF?

DAY_OF_WEEK.DAY_UDF?

Day Part

WFMBurst

Burst Census

Day Part > Day Part Name

DAY_PART.DP_NAME

Day Part > Day Part Description

DAY_PART.DP_DESC

Day Part > Start Time

DAY_PART.DP_START_TIME

Day Part > End Time

DAY_PART.DP_END_TIME

Day Part > Keys > DP_ID

DAY PART.DP_ID

Day Part

WFMStandard

Scheduling MVS > Schedule Templates > Shift Requirement Template

Day Part > Day Part Name

DAY_PART.DP_NAME

Scheduling MVS > Schedule Templates > Staffing Requirement Template

Day Part > Day Part Description

DAY_PART.DP_DESC

Scheduling MVS > Shift Preferences > Shift Preference

Day Part > Day Part Short Code

DAY_PART.DP_SHORT_CODE

Scheduling MVS > Shift Preferences > Shift Preference History

Day Part > Day Part Start Time

DAY_PART.DP_START_TIME

Day Part > Day Part End Time

DAY_PART.DP_END_TIME

Day Part > Is Day Part Hidden

DAY_PART.DP_HIDE

Day Part > Is First Day Part

DAY_PART.IS_FIRST_DP

Day Part > Keys > DP_ID

DAY_PART.DP_ID

Day Part > UDFs > DP_FLAG?

DAY_PART.DP_FLAG?

Day Part > UDFs > DP_UDF?

DAY_PART.DP_UDF?

Department

WFMBurst

Burst Employee Information > Default Labor

Department > Department Name

DEPARTMENT.DEPT_NAME

Burst Work

Department > Department Description

DEPARTMENT.DEPT_DESC

WFMStandard

Employee Information > Default Labor

Department > Department Start Date

DEPARTMENT.DEPT_START_DATE

Scheduling

Department > Department End Date

DEPARTMENT.DEPT_END_DATE

Work

Department > Department UDFs > DEPT_FLAG?

DEPARTMENT.DEPT_FLAG?

Department > Department UDFs > DEPT_REFKEY?

DEPARTMENT.DEPT_REFKEY?

Department > Department UDFs > DEPT_VAL?

DEPARTMENT.DEPT_VAL?

Department > Keys > DEPT_ID

DEPARTMENT.DEPT_ID

Department > Foreign Keys > WBT_ID

DEPARTMENT.WBT_ID

Docket

WFMBurst

Burst Employee Information > Default Labor

Docket > Docket Name

DOCKET.DOCK_NAME

Burst Work

Docket > Docket Description

DOCKET.DOCK_DESC

Burst Work Schedule Aggregation

Docket > Quantity

DOCKET.DOCK_QTY

WFMStandard

Employee Information

Docket > Standard Quantity

DOCKET.DOCK_STANDARD_QTY

Scheduling

Docket > Standard Duration

DOCKET.DOCK_STANDARD_DUR

Work

Docket > Piece Rate

DOCKET.DOCK_PIECE_RATE

Scheduling MVS > Rotations > Rotation Row Conflicts

Docket > Start Date

DOCKET.DOCK_START_DATE

Scheduling MVS > Rotations > Row Labor Metrics

Docket > End Date

DOCKET.DOCK_END_DATE

Docket > Docket UDFs > DOCK_FLAG?

DOCKET.DOCK_FLAG?

Docket > Docket UDFs > DOCK_REFKEY?

DOCKET.DOCK_REFKEY?

Docket > Docket UDFs > DOCK_UDF?

DOCKET.DOCK_UDF?

Docket > Keys > DOCK_ID

DOCKET.DOCK_ID

Docket > Foreign Keys > ACTVSET_ID

DOCKET.ACTVSET_ID

Docket Activities

WFMBurst

Burst Employee Information > Default Labor

Docket Activities > Activity Set Name

ACTIVITY_SET.ACTVSET_NAME

Burst Work

Docket Activities > Activity Set Description

ACTIVITY_SET.ACTVSET_DESC

WFMStandard

Employee Information > Default Labor

Docket Activities > Keys > ACTVSET_ID

ACTIVITY_SELF.ACTVSET_ID

Work

Employee

WFMBurst

Burst Census

Employee > Employee ID

EMPLOYEE.EMP_NAME

Burst Historical Payroll Cost

Employee > Full Name

EMPLOYEE.EMP_FULLNAME

Burst Scheduling

Employee > First Name

EMPLOYEE.EMP_FIRSTNAME

Burst Work

Employee > Last Name

EMPLOYEE.EMP_LASTNAME

Burst Work Schedule Aggregration

Employee > Is Full Time

EMPLOYEE.EMP_FULLTIME

WFMStandard

Attendance Control

Employee > Status

EMPLOYEE.EMP_STATUS

Auditing

Employee > Is Home Team

SEC_EMPLOYEE.EMPT_HOME_TEAM

All name spaces

Employee > System Scheduling Enabled

EMPLOYEE.EMP_SYSTEM_SCHEDULING_ENABLED

Availability

Employee > Base Rate

EMPLOYEE.EMP_BASE_RATE

Employee Balances

Employee > Birth Date

EMPLOYEE.EMP_BIRTH_DATE

Employee Information

Employee > Employee ID

[EMPLOYEE].[EMP_NAME]

Employee > Full Name

[EMPLOYEE].[EMP_FULLNAME]

Employee > First Name

[EMPLOYEE].[EMP_FIRSTNAME]

Employee > Last Name

[EMPLOYEE].[EMP_LASTNAME]

Employee > Is Full time

[EMPLOYEE].[EMP_FULLTIME]

Employee > Status

[EMPLOYEE].[EMP_STATUS]

Employee > Is Home Team

[SEC_EMPLOYEE].[EMPT_HOME_TEAM]

Employee > Base Rate

[EMPLOYEE].[EMP_BASE_RATE]

Employee > Hire Date

[EMPLOYEE].[EMP_HIRE_DATE]

Employee > Effective Date

[EMPLOYEE].[EMP_EFFECTIVE_DATE]

Employee > FTE

[EMPLOYEE].[EMP_FTE]

Employee > Termination Date

[EMPLOYEE].[EMP_TERMINATION_DATE]

Employee > Seniority Date

[EMPLOYEE].[EMP_SENIORITY_DATE]

Employee > Birth Date

[EMPLOYEE].[EMP_BIRTH_DATE]

Employee > SIN

EMPLOYEE.EMP_SIN

Employee > Seniority

[EMPLOYEE].[EMP_SENIORITY_NUMBER]

Employee > Shift Pattern Offset

[EMPLOYEE].[EMP_SHFTPAT_OFFSET]

Employee > Default Minutes

[EMPLOYEE].[EMP_DEF_MINUTES]

Employee > System Scheduling Enabled

[EMPLOYEE].[EMP_SYSTEM_SCHEDULING_ENABLED]

Historical Payroll Cost

Employee > Hire Date

EMPLOYEE.EMP_HIRE_DATE

Leave Management Policies

Employee > Effective Date

EMPLOYEE.EMP_EFFECTIVE_DATE

Overtime Equalization

Employee > Termination Date

EMPLOYEE.EMP_TERMINIATION_DATE

RTSS

Employee > Seniority Date

EMPLOYEE.EMP_SENIORITY_DATE

Scheduling

Employee > Seniority

EMPLOYEE.EMP_SENIORITY_NUMBER

Scheduling MVS > Call List

Employee > Default Minutes

EMPLOYEE.EMP_DEF_MINUTES

Scheduling MVS > Scheduled Shifts > Call Logs

Employee > Shift Pattern Offset

EMPLOYEE.EMP_SHFTPAT_OFFSET

Scheduling MVS > Rotation Row Assignments

Employee > Employee UDFs > EMP_FLAG?

EMPLOYEE.EMP_FLAG?

Scheduling MVS > Rotation Row Conflicts

Employee > Employee UDFs > EMP_VAL?

EMPLOYEE.EMP_VAL?

Scheduling MVS > Shift Preferences > Shift Prefrence

Employee > Keys > EMP_ID

EMPLOYEE.EMP_ID

Scheduling MVS > Shift Preferences > Shift Prefrence History

Employee > Keys > WBT_ID

SEC_EMPLOYEE.WBT_ID

Work

Employee > Keys > Team Start Date

SEC_EMPLOYEE.START_DATE

WFMSystem

System Information > Errors Exceptions

Employee > Keys > Team End Date

SEC_EMPLOYEE.END_DATE

System Information > User Session

Employee > Foreign Keys > CALCGRP_ID

EMPLOYEE.CALCGRP_ID

Employee > Foreign Keys > PAYGRP_ID

EMPLOYEE.PAYGRP_ID

Employee > Foreign Keys > SHFTPAT_ID

EMPLOYEE.SHFTPAT_ID

Audit Tracking

Employee > Employee ID

[EMPLOYEE].[EMP_NAME]

Employee > Full Name

[EMPLOYEE].[EMP_FULLNAME]

Employee > First Name

[EMPLOYEE].[EMP_FIRSTNAME]

Employee > Last Name

[EMPLOYEE].[EMP_LASTNAME]

Employee > Is Full time

[EMPLOYEE].[EMP_FULLTIME]

Employee > Status

[EMPLOYEE].[EMP_STATUS]

Employee > Is Home Team

[SEC_EMPLOYEE].[EMPT_HOME_TEAM]

Employee > Base Rate

[EMPLOYEE].[EMP_BASE_RATE]

Employee > Hire Date

[EMPLOYEE].[EMP_HIRE_DATE]

Employee > Effective Date

[EMPLOYEE].[EMP_EFFECTIVE_DATE]

Employee > FTE

[EMPLOYEE].[EMP_FTE]

Employee > Termination Date

[EMPLOYEE].[EMP_TERMINATION_DATE]

Employee > Seniority Date

[EMPLOYEE].[EMP_SENIORITY_DATE]

Employee > Birth Date

[EMPLOYEE].[EMP_BIRTH_DATE]

Employee > SIN

[EMPLOYEE].[EMP_SIN]

Employee > Seniority

[EMPLOYEE].[EMP_SENIORITY_NUMBER]

Employee > Shift Pattern Offset

[EMPLOYEE].[EMP_SHFTPAT_OFFSET]

Employee > Default Minutes

[EMPLOYEE].[EMP_DEF_MINUTES]

Employee > System Scheduling Enabled

[EMPLOYEE].[EMP_SYSTEM_SCHEDULING_ENABLED]

Employee > EMP_FLAG1

[EMPLOYEE].[EMP_FLAG1]

Employee > EMP_FLAG2

[EMPLOYEE].[EMP_FLAG2]

Employee > EMP_FLAG3

[EMPLOYEE].[EMP_FLAG3]

Employee > EMP_FLAG4

[EMPLOYEE].[EMP_FLAG4]

Employee > EMP_FLAG5

[EMPLOYEE].[EMP_FLAG5]

Employee > EMP_FLAG6

[EMPLOYEE].[EMP_FLAG6]

Employee > EMP_FLAG7

[EMPLOYEE].[EMP_FLAG7]

Employee > EMP_FLAG8

[EMPLOYEE].[EMP_FLAG8]

Employee > EMP_FLAG9

[EMPLOYEE].[EMP_FLAG9]

Employee > EMP_FLAG10

[EMPLOYEE].[EMP_FLAG10]

Employee > EMP_FLAG11

[EMPLOYEE].[EMP_FLAG11]

Employee > EMP_FLAG12

[EMPLOYEE].[EMP_FLAG12]

Employee > EMP_FLAG13

[EMPLOYEE].[EMP_FLAG13]

Employee > EMP_FLAG14

[EMPLOYEE].[EMP_FLAG14]

Employee > EMP_FLAG15

[EMPLOYEE].[EMP_FLAG15]

Employee > EMP_FLAG16

[EMPLOYEE].[EMP_FLAG16]

Employee > EMP_FLAG17

[EMPLOYEE].[EMP_FLAG17]

Employee > EMP_FLAG18

[EMPLOYEE].[EMP_FLAG18]

Employee > EMP_FLAG19

[EMPLOYEE].[EMP_FLAG19]

Employee > EMP_FLAG20

[EMPLOYEE].[EMP_FLAG20]

Employee > EMP_VAL1

[EMPLOYEE].[EMP_VAL1]

Employee > EMP_VAL2

[EMPLOYEE].[EMP_VAL2]

Employee > EMP_VAL3

[EMPLOYEE].[EMP_VAL3]

Employee > EMP_VAL4

[EMPLOYEE].[EMP_VAL4]

Employee > EMP_VAL5

[EMPLOYEE].[EMP_VAL5]

Employee > EMP_VAL6

[EMPLOYEE].[EMP_VAL6]

Employee > EMP_VAL7

[EMPLOYEE].[EMP_VAL7]

Employee > EMP_VAL8

[EMPLOYEE].[EMP_VAL8]

Employee > EMP_VAL9

[EMPLOYEE].[EMP_VAL9]

Employee > EMP_VAL10

[EMPLOYEE].[EMP_VAL10]

Employee > EMP_VAL11

[EMPLOYEE].[EMP_VAL11]

Employee > EMP_VAL12

[EMPLOYEE].[EMP_VAL12]

Employee > EMP_VAL13

[EMPLOYEE].[EMP_VAL13]

Employee > EMP_VAL14

[EMPLOYEE].[EMP_VAL14]

Employee > EMP_VAL15

[EMPLOYEE].[EMP_VAL15]

Employee > EMP_VAL16

[EMPLOYEE].[EMP_VAL16]

Employee > EMP_VAL17

[EMPLOYEE].[EMP_VAL17]

Employee > EMP_VAL18

[EMPLOYEE].[EMP_VAL18]

Employee > EMP_VAL19

[EMPLOYEE].[EMP_VAL19]

Employee > EMP_VAL20

[EMPLOYEE].[EMP_VAL20]

Employee > EMP_ID

[EMPLOYEE].[EMP_ID]

Employee > WBT_ID

[SEC_EMPLOYEE].[WBT_ID]

Employee > TEAM_START_DATE

[SEC_EMPLOYEE].[START_DATE]

Employee > TEAM_END_DATE

[SEC_EMPLOYEE].[END_DATE]

Employee Approval

WFMStandard

Work

Employee Approval > Start Date

EA_TIME_APPROVAL.EATA_START_WORK_DATE

Employee Approval > End Date

EA_TIME_APPROVAL.EATA_END_WORK_DATE

Employee Approval > Create Time

EA_TIME_APPROVAL.EATA_CREATE_TIME

Employee Approval > Update Time

EA_TIME_APPROVAL.EATA_UPDATE_TIME

Employee Approval > Approval Minutes

EA_TIME_APPROVAL.EATA_WORK_MIN

Employee Approval > Inactive Revision

EA_TIME_APPROVAL.EATA_INACTIVE_REVISION

Employee Approval > Clock Device

EA_TIME_APPROVAL.EATA_DEVICE

Employee Approval > Keys > EATA_ID

EA_TIME_APPROVAL.EATA_ID

Employee Approval > Foreign Keys > EMP_ID

EA_TIME_APPROVAL.EMP_ID

Employee Approval > Foreign Keys > EATST_ID

EA_TIME_APPROVAL.EATST_ID

Employee Approval > UDFs > EATA_UDF?

EA_TIME_APPROVAL.EATA_UDF?

Employee Approval Error

WFMStandard

Work

Employee Approval Error >Error Message

EA_TIME_APPROVAL_ERROR.EATAE_ERROR_MESSAGE

Employee Approval Error > Start Date

EA_TIME_APPROVAL_ERROR.EATAE_START_WORK_DATE

Employee Approval Error > End Date

EA_TIME_APPROVAL_ERROR.EATAE_END_WORK_DATE

Employee Approval Error > Create Time

EA_TIME_APPROVAL_ERROR.EATAE_CREATE_TIME

Employee Approval Error > Update Time

EA_TIME_APPROVAL_ERROR.EATAE_UPDATE_TIME

Employee Approval Error > Approval Minutes

EA_TIME_APPROVAL_ERROR.EATAE_WORK_MIN

Employee Approval Error > Inactive Revision

EA_TIME_APPROVAL_ERROR.EATAE_INACTIVE_REVISION

Employee Approval Error > Clock Device

EA_TIME_APPROVAL_ERROR.EATAE_DEVICE

Employee Approval Error > UDFs > EATAE_UDF?

EA_TIME_APPROVAL_ERROR.EATAE_UDF?

Employee Approval Error > Keys > EATAE_ID

EA_TIME_APPROVAL_ERROR.EATAE_ID

Employee Approval Error > Foreign Keys > EATA_ID

EA_TIME_APPROVAL_ERROR.EATA_ID

Employee Approval Error > Foreign Keys > EMP_ID

EA_TIME_APPROVAL_ERROR.EMP_ID

Employee Approval Error > Foreign Keys > EATST_ID

EA_TIME_APPROVAL_ERROR.EATST_ID

Employee Schedule

WFMStandard

Work

Employee Schedule > Date

EMPLOYEE_SCHEDULE.WORK_DATE

Employee Schedule > Scheduled Hours

See IBM Query Studio for details on the expression.

Employee Schedule > Scheduled Minutes

See IBM Query Studio for details on the expression.

Employee Schedule > Default Start Time

EMPLOYEE_SCHEDULE.EMPSKD_DEF_START_TIME

Employee Schedule > Default End Time

EMPLOYEE_SCHEDULE.EMPSKD_DEF_END_TIME

Employee Schedule > Actual Start Time

EMPLOYEE_SCHEDULE.EMPSKD_ACT_START_TIME

Employee Schedule > Actual End Time

EMPLOYEE_SCHEDULE.EMPSKD_ACT_END_TIME

Employee Schedule > Actual Start Time2

EMPLOYEE_SCHEDULE.EMPSKD_ACT_START_TIME2

Employee Schedule > Actual End Time2

EMPLOYEE_SCHEDULE.EMPSKD_ACT_END_TIME2

Employee Schedule > Actual Start Time3

EMPLOYEE_SCHEDULE.EMPSKD_ACT_START_TIME3

Employee Schedule > Actual End Time3

EMPLOYEE_SCHEDULE.EMPSKD_ACT_END_TIME3

Employee Schedule > Actual Start Time4

EMPLOYEE_SCHEDULE.EMPSKD_ACT_START_TIME4

Employee Schedule > Actual End Time4

EMPLOYEE_SCHEDULE.EMPSKD_ACT_END_TIME4

Employee Schedule > Actual Start Time5

EMPLOYEE_SCHEDULE.EMPSKD_ACT_START_TIME5

Employee Schedule > Actual End Time5

EMPLOYEE_SCHEDULE.EMPSKD_ACT_END_TIME5

Employee Badge

WFMBurst

Burst Employee Information

Employee Badge > Badge Number

EMPLOYEE_BADGE.EMPBDG_BADGE_NUM

WFMStandard

Employee Information

UDFs > EMPBDG_FLAG[1-5]

[EMPLOYEE_BADGE].[EMPBDG_FLAG1-5]

UDFs > EMPBDG_UDF[1-5]

[EMPLOYEE_BADGE].[EMPBDG_UDF1-5]

Employee Badge > Keys > EMPBDG_ID

EMPLOYEE_BADGE.EMPBDG_ID

Employee Badge > Foreign Keys > EMP_ID

EMPLOYEE_BADGE.EMP_ID

Employee Default Labor

WFMBurst

Burst Employee Information > Employee Default Labor

Employee Default Labor > Ratio

EMP_DEF_LAB.EDLA_PERCENTAGE

WFMStandard

Employee Information > Employee Default Labor

Employee Default Labor > Default Labor UDFs > EDLA_FLAG?

EMP_DEF_LAB.EDLA_FLAG?

Employee Default Labor > Default Labor UDFs > EDLA_UDF?

EMP_DEF_LAB.EDLA_UDF?

Employee Default Labor > Foreign Keys > EMP_ID

EMP_DEF_LAB.EMP_ID

Employee Default Labor > Foreign Keys > DEPT_ID

EMP_DEF_LAB.DEPT_ID

Employee Default Labor > Foreign Keys > DOCK_ID

EMP_DEF_LAB.DOCK_ID

Employee Default Labor > Foreign Keys > JOB_ID

EMP_DEF_LAB.JOB_ID

Employee Default Labor > Foreign Keys > PROJ_ID

EMP_DEF_LAB.PROJ_ID

Employee History

WFMStandard

Auditing

Employee History > Start Date

EMPLOYEE_HISTORY.EMPHIST_START_DATE

Employee History > End Date

EMPLOYEE_HISTORY.EMPHIST_END_DATE

Employee History > Employee ID

EMPLOYEE_HISTORY.EMP_ID

Employee History > Full Name

EMPLOYEE_HISTORY.EMP_FULLNAME

Employee History > Last Name

EMPLOYEE_HISTORY.EMP_LASTNAME

Employee History > First Name

EMPLOYEE_HISTORY.EMP_FIRSTNAME

Employee History > Base Rate

EMPLOYEE_HISTORY.EMP_BASE_RATE

Employee History > Effective Date

EMPLOYEE_HISTORY.EMP_EFFECTIVE_DATE

Employee History > Hire Date

EMPLOYEE_HISTORY.EMP_HIRE_DATE

Employee History > Seniority Date

EMPLOYEE_HISTORY.EMP_SENIORITY_DATE

Employee History > Birth Date

EMPLOYEE_HISTORY.EMP_BIRTH_DATE

Employee History > Termination Date

EMPLOYEE_HISTORY.EMP_TERMINATION_DATE

Employee History > Shift Pattern Offset

EMPLOYEE_HISTORY.EMP_SHFTPAT_OFFSET

Employee History > SIN

EMPLOYEE_HISTORY.EMP_SIN

Employee History > Status

EMPLOYEE_HISTORY.EMP_STATUS

Employee History > Is Full Time

EMPLOYEE_HISTORY.EMP_FULLTIME

Employee History > Employee History UDFs > EMP_VAL?

EMPLOYEE_HISTORY.EMP_VAL?

Employee History > Employee History UDFs > EMP_FLAG?

EMPLOYEE_HISTORY.EMP_FLAG?

Employee History > Keys > EMP_ID

SEC_EMPLOYEE.EMP_ID

Employee History

WFMStandard

Auditing

Employee History > Employee ID

EMPLOYEE_HISTORY.EMP_NAME

Employee History > Full Name

EMPLOYEE_HISTORY.EMP_FULLNAME

Employee History > First Name

EMPLOYEE_HISTORY.EMP_FIRSTNAME

Employee History > Last Name

EMPLOYEE_HISTORY.EMP_LASTNAME

Employee History > SIN

EMPLOYEE_HISTORY.EMP_SIN

Employee History > Is Full time

EMPLOYEE_HISTORY.EMP_FULLTIME

Employee History > Status

EMPLOYEE_HISTORY.EMP_STATUS

Employee History > Base Rate

EMPLOYEE_HISTORY.EMP_BASE_RATE

Employee History > Birth Rate

EMPLOYEE_HISTORY.EMP_BIRTH_DATE

Employee History > Hire Date

EMPLOYEE_HISTORY.EMP_HIRE_DATE

Employee History > Effective Date

EMPLOYEE_HISTORY.EMP_EFFECTIVE_DATE

Employee History > Termination Date

EMPLOYEE_HISTORY.EMP_TERMINATION_DATE

Employee History > Seniority Date

EMPLOYEE_HISTORY.EMP_SENIORITY_DATE

Employee History > Start Date

EMPLOYEE_HISTORY.EMPHIST_START_DATE

Employee History > End Date

EMPLOYEE_HISTORY.EMPHIST_END_DATE

Employee History > Shift Pattern Offset

EMPLOYEE_HISTORY.EMP_SHFTPAT_OFFSET

Employee History > Employee History UDFs > EMP_FLAG?

EMPLOYEE_HISTORY.EMP_FLAG?

Employee History > Employee History UDFs > EMP_VAL?

EMPLOYEE_HISTORY.EMP_VAL?

Employee History > Keys > EMP_ID

SEC_EMPLOYEE.EMP_ID

Employee History > Foreign Keys > CALCGRP_ID

EMPLOYEE_HISTORY.CALCGRP_ID

Employee History > Foreign Keys > PAYGRP_ID

EMPLOYEE_HISTORY.PAYGRP_ID

Employee History > Foreign Keys > SHIFTPAT_ID

EMPLOYEE_HISTORY.SHFTPAT_ID

Employee Job

WFMBurst

Burst Employee Information

Employee Job > Job Name

JOB.JOB_NAME

WFMStandard

Employee Information

Employee Job > Job Description

JOB.JOB_DESC

Employee Job > Tipped

JOB.JOB_TIP

Employee Job > Rate Index

EMPLOYEE_JOB.EMPJOB_RATE_INDEX

Employee Job > Work Assignment

EMPLOYEE_JOB.EMPJOB_WORKASSIGNMENT

Employee Job > Employee Job Rate

EMPLOYEE_JOB.EMPJOB_RATE

Employee Job > Job Start Date

EMPLOYEE_JOB.EMPJOB_START_DATE

Employee Job > Job End Date

EMPLOYEE_JOB.EMPJOB_END_DATE

Employee Job > Job Rank

EMPLOYEE_JOB.EMPJOB_RANK

Employee Job > Job Preferred

EMPLOYEE_JOB.EMPJOB_PREFERRED

Employee Job > Job UDFs > JOB_FLAG?

JOB.JOB_FLAG?

Employee Job > Job UDFs > JOB_REFKEY?

JOB.JOB_REFKEY?

Employee Job > Job UDFs > JOB_VAL?

JOB.JOB_VAL?

Employee Job > Job UDFs > EMPJOB_FLAG?

EMPLOYEE_JOB.EMPJOB_FLAG?

Employee Job > Job UDFs > EMPJOB_UDF?

EMPLOYEE_JOB.EMPJOB_UDF?

Employee Job > Foreign Keys > EMP_ID

EMPLOYEE_JOB.EMP_ID

Employee Job > Foreign Keys > JOB_ID

EMPLOYEE_JOB.JOB_ID

Employee Schedule Settings

WFMBurst

Burst Scheduling

Employee Schedule Settings > Max Hours per Schedule

SO_EMPLOYEE.SEMP_SKDMAX_HRS

WFMStandard

Scheduling

Employee Schedule Settings > Min Hours per Schedule

SO_EMPLOYEE.SEMP_SKDMIN_HRS

Employee Schedule Settings > Max Hours per Day

SO_EMPLOYEE.SEMP_DAYMAX_HRS

Employee Schedule Settings > Min Hours per Shift

SO_EMPLOYEE.SEMP_SHFTMIN_HRS

Employee Schedule Settings > Is Minor

if SO_EMPLOYEE.SEMP_IS_MINOR = 1 then 'Y' else 'N'

Employee Schedule Settings > Is Salary

if SO_EMPLOYEE.SEMP_IS_SALARY = 1 then 'Y' else 'N'

Employee Schedule Settings > Staff Group

SO_EMPLOYEE_GROUP.EMPGRP_ID

Employee Schedule Settings > Keys > EMP_ID

SO_EMPLOYEE.EMP_ID

Employee Schedule Settings > Keys > EMPGRP_ID

SO_EMPLOYEE.EMPGRP_ID

Employee Schedule Settings > Keys > SKDGRP_ID

SO_EMPLOYEE.SKDGRP_ID

Employee Skill

WFMStandard

Employee Information

Employee Skill > Skill Name

ST_SKILL.STSKL_NAME

Employee Skill > Skill Description

ST_SKILL.STSKL_DESC

Employee Skill > Skill Start Date

ST_EMP_SKILL.STEMPSKL_START_DATE

Employee Skill > Skill End Date

ST_EMP_SKILL.STEMPSKL_END_DATE

Employee Skill > Skill Weight

ST_EMP_SKILL.STEMPSKL_WEIGHT

Employee Skill > Employee Skill UDFs > STEMPSKL_FLAG?

ST_EMP_SKILL.STEMPSKL_FLAG?

Employee Skill > Employee Skill UDFs > STEMPSKL_UDF?

ST_EMP_SKILL.STEMPSKL_UDF?

Employee Skill > Employee Skill UDFs > STSKL_FLAG?

ST_SKILL.STSKL_FLAG?

Employee Skill > Employee Skill UDFs > STSKL_UDF?

ST_SKILL.STSKL_UDF?

Employee Skill > Keys > EMP_ID

ST_EMP_SKILL.EMP_ID

Employee Skill > Keys > STEMPSKL_ID

ST_EMP_SKILL.STEMPSKL_ID

Employee Skill > Keys > STSKL_ID

ST_SKILL.STSKL_ID

Employee Skill > Keys > STSKLTYP_ID

ST_SKILL.STSKLTYP_ID

Employee UDF Data

WFMStandard

Employee Information > UDF Data

Employee UDF Data > Employee Data Name

EMP_UDF_DEF.EMPUDF_NAME

WFMBurst

Burst Employee Information > UDF Data

Employee UDF Data > Employee Data Description

EMP_UDF_DEF.EMPUDF_DESC

Employee UDF Data > Value

EMP_UDF_DATA.EUDFD_VALUE

Employee UDF Data > Default Value

EMP_UDF_DEF.EMPUDF_DEFAULT

Employee UDF Data > Effective Date

EMP_UDF_DATA.EUDFD_EFF_DATE

Employee UDF Data > Keys > EMP_ID

EMP_UDF_DATA.EMP_ID

Employee Work Type

WFMStandard

Employee Information

Employee Work Type > Employee Work Type Name

EMPLOYEE_WORK_TYPE.EMPWRKTYP_NAME

Employee Work Type > Employee Work Type Description

EMPLOYEE_WORK_TYPE.EMPWRKTYP_DESC

Employee Work Type > Is Full Time

EMPLOYEE_WORK_TYPE.EMPWRKTYP_FULLTIME

Employee Work Type > Employee Work Type Sort Order

EMPLOYEE_WORK_TYPE.EMPWRKTYP_SORTORDER

Employee Work Type > PBJ Pay Type Code

EMPLOYEE_WORK_TYPE.EMPWRKTYP_PBJ_PAY_TYPE_CODE

Employee Work Type > UDFs > EMPWRKTYP_FLAG1

EMPLOYEE_WORK_TYPE.EMPWRKTYP_FLAG1

Employee Work Type > UDFs > EMPWRKTYP_FLAG2

EMPLOYEE_WORK_TYPE.EMPWRKTYP_FLAG2

Employee Work Type > UDFs > EMPWRKTYP_FLAG3

EMPLOYEE_WORK_TYPE.EMPWRKTYP_FLAG3

Employee Work Type > UDFs > EMPWRKTYP_FLAG4

EMPLOYEE_WORK_TYPE.EMPWRKTYP_FLAG4

Employee Work Type > UDFs > EMPWRKTYP_FLAG5

EMPLOYEE_WORK_TYPE.EMPWRKTYP_FLAG5

Employee Work Type > UDFs > EMPWRKTYP_UDF1

EMPLOYEE_WORK_TYPE.EMPWRKTYP_UDF1

Employee Work Type > UDFs > EMPWRKTYP_UDF2

EMPLOYEE_WORK_TYPE.EMPWRKTYP_UDF2

Employee Work Type > UDFs > EMPWRKTYP_UDF3

EMPLOYEE_WORK_TYPE.EMPWRKTYP_UDF3

Employee Work Type > UDFs > EMPWRKTYP_UDF4

EMPLOYEE_WORK_TYPE.EMPWRKTYP_UDF4

Employee Work Type > UDFs > EMPWRKTYP_UDF5

EMPLOYEE_WORK_TYPE.EMPWRKTYP_UDF5

Employee Work Type > Keys > EMPWRKTYP_ID

EMPLOYEE_WORK_TYPE.EMPWRKTYP_ID

Entitlement

WFMStandard

Leave Management Policies

Entitlement > Entitlement Name

ENT_ENTITLEMENT.ENT_NAME

Entitlement > Entitlement Description

ENT_ENTITLEMENT.ENT_DESC

Entitlement > Entitlement Start Date

ENT_ENTITLEMENT.ENT_START_DATE

Entitlement > Entitlement End Date

ENT_ENTITLEMENT.ENT_END_DATE

Entitlement > Apply On Unit

ENT_ENTITLEMENT.ENT_APPLY_ON_UNIT

Entitlement > Apply On Value

ENT_ENTITLEMENT.ENT_APPLY_ON_VALUE

Entitlement > Policy Entitlement Priority

ENT_POLICY_ENTITLEMENT.ENTPOLENT_PRIORITY

Entitlement > Foreign Keys > ENTPOL_ID

ENT_POLICY_ENTITLEMENT.ENTPOL_ID

Entitlement > Foreign Keys > ENTPOLENT_ID

ENT_POLICY_ENTITLEMENT.ENTPOLENT_ID

Entitlement > Keys > ENT_ID

ENT_POLICY_ENTITLEMENT.ENT_ID

Entitlement Details

WFMStandard

Leave Management Policies

Entitlement Details > Priority

ENT_DETAIL.ENTDET_PRIORITY

Entitlement Details > Min Seniority Value

ENT_DETAIL.ENTDET_MIN_SEN_VALUE

Entitlement Details > Min Seniority Units

ENT_DETAIL.ENTDET_MIN_SEN_UNITS

Entitlement Details > Max Seniority Value

ENT_DETAIL.ENTDET_MAX_SEN_VALUE

Entitlement Details > Max Seniority Units

ENT_DETAIL.ENTDET_MAX_SEN_UNITS

Entitlement Details > Min Good Value

ENT_DETAIL.ENTDET_GOOD_MIN

Entitlement Details > Good Units

ENT_DETAIL.ENTDET_GOOD_UNITS

Entitlement Details > Good Time Codes

ENT_DETAIL.ENTDET_GOOD_TCODE_NAME

Entitlement Details > Good Function

ENT_DETAIL.ENTDET_GOOD_FUNCTION

Entitlement Details > Good Hour Type

ENT_DETAIL.ENTDET_GOOD_HTYPE_NAMES

Entitlement Details > Max Bad Value

ENT_DETAIL.ENTDET_BAD_MAX

Entitlement Details > Bad Units

ENT_DETAIL.ENTDET_BAD_UNITS

Entitlement Details > Bad Time Codes

ENT_DETAIL.ENTDET_BAD_TCODE_NAME

Entitlement Details > Bad Function

ENT_DETAIL.ENTDET_BAD_FUNCTION

Entitlement Details > Bad Hour Type

ENT_DETAIL.ENTDET_BAD_HTYPE_NAMES

Entitlement Details > Units to Apply

ENT_DETAIL.ENTDET_UNITS

Entitlement Details > Ratio

ENT_DETAIL.ENTDET_RATIO

Entitlement Details > Condition to Apply

ENT_DETAIL.ENTDET_CONDITION

Entitlement Details > Action to be Taken

ENT_DETAIL.ENTDET_ACTION

Entitlement Details > Max Value

ENT_DETAIL.ENTDET_MAX_BAL_VALUE

Entitlement Details > Action on Max

ENT_DETAIL.ENTDET_ON_MAX_OUT

Entitlement Details > Min Value

ENT_DETAIL.ENTDET_MIN_BAL_VALUE

Entitlement Details > Action on Min

ENT_DETAIL.ENTDET_ON_MIN_OUT

Entitlement Details > Annual Max

ENT_DETAIL.ENTDET_ANNUAL_MAX

Entitlement Details > Year Start

ENT_DETAIL.ENTDET_YEAR_START

Entitlement Details > Annual on Max

ENT_DETAIL.ENTDET_ON_ANNUAL_MAX

Entitlement Details > Entitlement Details UDFs > ENTDET_FLAG?

ENT_DETAIL.ENTDET_FLAG?

Entitlement Details > Entitlement Details UDFs > ENTDET_UDF?

ENT_DETAIL.ENTDET_UDF?

Entitlement Details > Keys > ENT_ID

ENT_DETAIL.ENT_ID

Entitlement Details > Keys > BAL_ID

ENT_DETAIL.BAL_ID

Errors

WFMSystem

System Information > Job Scheduler

Errors > Failures

JOBSKD_ERRORS.Failures

Errors > Keys > JSTSK_ID

JOBSKD_ERRORS.JSTSK_ID

Event Definition

WFMStandard

Attendance Control

Event Definition > Event Name

AC_EVENT.ACEVT_NAME

Event Definition > Event Description

AC_EVENT.ACEVT_DESC

Event Definition > Eligible Teams

AC_EVENT.WBT_NAMES

Event Definition > Sub team Eligibility

AC_EVENT.ACEVT_APPLY_SUBTM

Event Definition > Eligible Employees

AC_EVENT.ACEVT_EMP_NAMES

Event Definition > Eligible Calc Groups

AC_EVENT.ACEVT_CALCGRP_NAME

Event Definition > Eligible Pay Groups

AC_EVENT.ACEVT_PAYGRP_NAMES

Event Definition > Eligible Time Codes

AC_EVENT.ACEVT_TCODE_NAMES

Event Definition > Maximum Duration

AC_EVENT.ACEVT_MAX_DUR

Event Definition > Minimum Duration

AC_EVENT.ACEVT_MIN_DUR

Event Definition > Points

AC_EVENT.ACEVT_POINTS

Event Definition > Priority

AC_EVENT.ACEVT_PRIORITY

Event Definition > Event Definition UDFs > ACEVT_EMP_VAL?S

AC_EVENT.ACEVT_EMP_VAL?S

Event Definition > Event Definition UDFs > ACEVT_FLAG?

AC_EVENT.ACEVT_FLAG?

Event Definition > Event Definition UDFs > ACEVT_UDF?

AC_EVENT.ACEVT_UDF?

Event Definition > Keys > ACEVT_ID

AC_EVENT.ACEVT_ID

Event Log Entry

WFMStandard

Attendance Control

Event Log Entry > Event Name

AC_EVENT.ACEVT_NAME

Event Log Entry > Work Date

AC_EVENT_LOG.ACEVTLOG_WORK_DATE

Event Log Entry > User

AC_EVENT_LOG.WBU_NAME

Event Log Entry > Actual User

AC_EVENT_LOG.WBU_NAME_ACTUAL

Event Log Entry > Log Date

AC_EVENT_LOG.ACEVTLOG_DATE

Event Log Entry > Log Points

AC_EVENT_LOG.ACEVTLOG_POINTS

Event Log Entry > Employee Reason

AC_EVENT_LOG.ACEVTLOG_EMP_REAS

Event Log Entry > Authorized By

AC_EVENT_LOG.ACEVTLOG_AUTH_BY

Event Log Entry > Authorization Date

AC_EVENT_LOG.ACEVTLOG_AUTH_DATE

Event Log Entry > Supervisor Notes

AC_EVENT_LOG.ACEVTLOG_SUPER_NT

Event Log Entry > Status

AC_EVENT_LOG.ACEVTLOG_STATUS

Event Log Entry > Calc Group

AC_EVENT_LOG.CALCGRP_NAME

Event Log Entry > Pay Group

AC_EVENT_LOG.PAYGRP_NAME

Event Log Entry > Time Code

AC_EVENT_LOG.TCODE_NAME

Event Log Entry > Keys > ACEVT_ID

AC_EVENT_LOG.ACEVT_ID

Event Log Entry > Keys > ACEVTLOG_ID

AC_EVENT_LOG.ACEVTLOG_ID

Event Log Entry > EMP_ID

AC_EVENT_LOG.EMP_ID

Event Violation Log

WFMStandard

Attendance Control

Event Violation Log > Keys > ACVIOLOG_ID

AC_VIOEVT_LOG.ACVIOLOG_ID

Event Violation Log > Keys > ACVTLOG_ID

AC_VIOEVT_LOG.ACEVTLOG_ID

Export Details

WFMSystem

System Information > Interfaces

Export Details > Processed Date

WBINT_EXPORT.WBIEXP_PROC_DATE

Export Details > Record Status

WBINT_EXPORT.WBIEXP_STATUS

Export Details > Record Message

WBINT_EXPORT.WBIEXP_MSG

Export Details > Keys > WBIEXP_ID

WBINT_EXPORT.WBIEXP_ID

Export Details > Keys > WBITRAN_ID

WBINT_EXPORT.WBITRAN_ID

Facility

WFMStandard

Work

Facility > Facility Name

PBJ_FACILITY.PBJFAC_NAME

Facility > Facility Code

PBJ_FACILITY.PBJFAC_CODE

Facility > Facility Description

PBJ_FACILITY.PBJFAC_DESC

Facility > Facility Team Start Date

PBJ_FACILITY_TEAM.PBJFT_START_DATE

Facility > Facility Team End Date

PBJ_FACILITY_TEAM.PBJFT_END_DATE

Facility > State Name

STATE.STATE_NAME

Facility > State Code

STATE.STATE_CODE

Facility UDFs > PBJFAC_FLAG1

PBJ_FACILITY.PBJFAC_FLAG1

Facility UDFs > PBJFAC_FLAG2

PBJ_FACILITY.PBJFAC_FLAG2

Facility UDFs > PBJFAC_FLAG3

PBJ_FACILITY.PBJFAC_FLAG3

Facility UDFs > PBJFAC_FLAG4

PBJ_FACILITY.PBJFAC_FLAG4

Facility UDFs > PBJFAC_FLAG5

PBJ_FACILITY.PBJFAC_FLAG5

Facility UDFs > PBJFAC_UDF1

PBJ_FACILITY.PBJFAC_UDF1

Facility UDFs > PBJFAC_UDF2

PBJ_FACILITY.PBJFAC_UDF2

Facility UDFs > PBJFAC_UDF3

PBJ_FACILITY.PBJFAC_UDF3

Facility UDFs > PBJFAC_UDF4

PBJ_FACILITY.PBJFAC_UDF4

Facility 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

Forecasts

WFMBurst

Scheduling

Forecasts > Forecast Name

SO_FCAST.FCAST_NAME

WFMStandard

Burst Forecasting

Forecasts > Interval Type

SO_FCAST.INVTYP_ID

Forecasts > Forecast Date

SO_FCAST_DETAIL.FCAST_DATE

Forecasts > Calls

SO_FCAST_DETAIL.FCAST_CALLS

Forecasts > Adjusted Type

SO_FCAST_DETAIL.FCAST_ADJTYP

Forecasts > Adjusted Value

SO_FCAST_DETAIL.FCAST_ADJVAL

Forecasts > Keys > SKDGRP_ID

SO_FCAST.SKDGRP_ID

Forecast Driver

Permanent filter on the Forecast Driver query subject: SO_SCHEDULE_GROUP.SKDGRP_INTRNL_TYPE = 12

WFMBurst

Burst Acutal Results

Forecast Driver > Forecast Driver Name

SO_SCHEDULE_GROUP.SKDGRP_NAME

Burst Forecasting

Forecast Driver > Staffing Standard

SO_SCHEDULE_GROUP.SKDGRP_STAFF_STD

WFMStandard

Actual Results

Forecast Driver > Forecast Method

SO_SCHEDULE_GROUP.SKDGRP_FCAST_MTD

Scheduling

Forecast Driver > Forecast Interval

SO_SCHEDULE_GROUP.SKDGRP_FCAST_INT

Forecast Driver > Start of Week

SO_SCHEDULE_GROUP.SKDGRP_STARTDOW

Forecast Driver > Internal Type

SO_SCHEDULE_GROUP.SKDGRP_INTRNL_TYPE

Forecast Driver > Volume Type

SO_VOLUME_TYPE.VOLTYP_LOC_NAME

Forecast Driver > Budget Type

SO_VOLUME_TYPE.VOLTYP_LOC_NAME

Forecast Driver > Budget Value 1

SO_SCHEDULE_GROUP.SKDGRP_BUDG_VAL1

Forecast Driver > Budget Value 2

SO_SCHEDULE_GROUP.SKDGRP_BUDG_VAL2

Forecast Driver > Variable Staffing Calculation

SO_SCHEDULE_GROUP.SKDGRP_CALCVARSTF

Forecast Driver > Sales Based

SO_SCHEDULE_GROUP.SKDGRP_SALES_BASED

Forecast Driver > Client Key

SO_SCHEDULE_GROUP.SKDGRP_CLIENTKEY

Forecast Driver > Keys > SKDGRP_ID

SO_SCHEDULE_GROUP.SKDGRP_ID

Forecast Driver > Keys > SKDGRP_PARENT_ID

SO_SCHEDULE_GROUP.SKDGRP_PARENT_ID

Forecast Driver > Keys > VOLTYP_ID

SO_SCHEDULE_GROUP.VOLTYP_ID

Forecast Driver > Keys > WBT_ID

SO_SCHEDULE_GROUP.WBT_ID

Forecast Item

WFMBurst

Burst Labor Budgeting

Forecast Item > Sales

FCST_ITEM.FCIT_SALES

WFMStandard

Scheduling

Forecast Item > Sales Per Hour

FCST_ITEM.FCIT_SPH

Forecast Item > Sales Trend

FCST_ITEM.FCIT_SALES_TRD

Forecast Item > Sales Trend Source

FCST_ITEM.FCIT_SALES_TRD_SRC

Forecast Item > Payroll

FCST_ITEM.FCIT_PAYROLL

Forecast Item > Payroll Percentage

FCST_ITEM.FCIT_PAYROLL_PCT

Forecast Item > Payroll Trend

FCST_ITEM.FCIT_PYRLL_TRD

Forecast Item > Payroll Trend Source

FCST_ITEM.FCIT_PYRLL_TRD_SRC

Forecast Item > Average Hourly Rate

FCST_ITEM.FCIT_AHR

Forecast Item > Additional Event Hours

FCST_ITEM.FCIT_EVT_HRS

Forecast Item > Hours

FCST_ITEM.FCIT_HOURS

Forecast Item > Minimum Hours

FCST_ITEM.FCIT_MIN_HOURS

Forecast Item > Maximum Hours

FCST_ITEM.FCIT_MAX_HOURS

Forecast Item > Schedule Hours

FCST_ITEM.FCIT_SCH_HRS

Forecast Item > Productive Hours

FCST_ITEM.FCIT_PROD_HOURS

Forecast Item > Staffing Requirements Hours

FCST_ITEM.FCIT_STF_REQ_HRS

Forecast Item > Volume Driven Hours

FCST_ITEM.FCIT_VOL_DRV_HRS

Forecast Item > Variable Hours

FCST_ITEM.FCIT_VAR_HRS

Forecast Item > Vacation Hours

FCST_ITEM.FCIT_VAC_HOURS

Forecast Item > Holiday Hours

FCST_ITEM.FCIT_HOL_HOURS

Forecast Item > Other Hours

FCST_ITEM.FCIT_OTHER_HOURS

Forecast Item > Scheduling Factor

FCST_ITEM.FCIT_SCH_FACTOR

Forecast Item > Variable Coefficient

FCST_ITEM.FCIT_PR_FACTOR

Forecast Item > Custom Forecast Items > FCIT_ITEM?

FCST_ITEM.FCIT_ITEM?

Forecast Item > Keys > FC_ID

FCST_ITEM.FC_ID

Forecast Item > Keys > FCIT_ID

FCST_ITEM.FCIT_ID

Forecast Item > Keys > FCLS_ID

FCST_ITEM.FCLS_ID

Forecast Item > Keys > FCTP_ID

FCST_ITEM.FCTP_ID

Forecast Location

WFMBurst

Burst Labor Budgeting

Forecast Location > Location Type

WFMBurst

Budgeting Folder

WFMStandard

Scheduling

Forecast Location > Location Type Description

FCST_LOC_TYPE.FCLTP_DESC

Forecast Location > Released on Creation

FCST_LOCATION.FCLOC_FC_INIT_REL

Forecast Location > Forecast Location UDFs > FCLOC_FLAG?

FCST_LOCATION.FCLOC_FLAG?

Forecast Location > Forecast Location UDFs > FCLOC_UDF?

FCST_LOCATION.FCLOC_UDF?

Forecast Location > Keys > SKDGRP_ID

FCST_LOCATION.SKDGRP_ID

Forecast Location > Foreign Keys > FCLTP_ID

FCST_LOCATION.FCLTP_ID

Forcast Location Summary

WFMBurst

Burst Labor Budgeting

Forecast Location Summary > State

FCST_STATE.FCST_LOC_NAME

WFMStandard

Scheduling

Forecast Location Summary > Forecast Location Summary UDFs > FCLS_FLAG?

FCST_LOC_SUMMARY.FCLS_FLAG?

Forecast Location Summary > Forecast Location Summary UDFs > FCLS_UDF?

FCST_LOC_SUMMARY.FCLS_UDF?

Forecast Location Summary > Keys > FC_ID

FCST_LOC_SUMMARY.FC_ID

Forecast Location Summary > Keys > FCLS_ID

FCST_LOC_SUMMARY.FCLS_ID

Forecast Location Summary > Keys > FCST_ID

FCST_LOC_SUMMARY.FCST_ID

Forecast Location Summary > Keys > SKDGRP_ID

FCST_LOC_SUMMARY.SKDGRP_ID

Forecast Location Type

WFMBurst

Burst Labor Budgeting

Forecast Location Type > Location Type

FCST_LOC_TYPE.FCLTP_NAME

WFMStandard

Scheduling

Forecast Location Type > Location Description

FCST_LOC_TYPE.FCLTP_DESC

Forecast Location Type > Keys > FCLTP_ID

FCST_LOC_TYPE.FCLTP_ID

Forecast Location Type > Keys > FCLTP_PARENT_ID

FCST_LOC_TYPE.FCLTP_PARENT_ID

Forecast Time Period

WFMBurst

Burst Labor Budgeting

Forecast Time Period > Time Period

VL_FCST_TIME_PERIOD.FCTP_LOC_NAME

WFMStandard

Scheduling

Forecast Time Period > Time Period Description

VL_FCST_TIME_PERIOD.FCTP_LOC_DESC

Forecast Time Period > Start Date

VL_FCST_TIME_PERIOD.FCTP_START_DATE

Forecast Time Period > End Date

VL_FCST_TIME_PERIOD.FCTP_END_DATE

Forecast Time Period > Keys > FCTP_ID

VL_FCST_TIME_PERIOD.FCTP_ID

Forecast Time Period > Keys > FCTP_PARENT_ID

VL_FCST_TIME_PERIOD.FCTP_PARENT_ID

Historical Payroll Cost

WFMBurst

Burst Historical Payroll Cost

Historical Payroll Cost > Date

SO_ACTUAL_PAY_COST.ACTPAYCST_DATE

WFMStandard

Historical Payroll Cost

Historical Payroll Cost > Rate

SO_ACTUAL_PAY_COST.ACTPAYCST_RATE

Historical Payroll Cost > Hours

SO_ACTUAL_PAY_COST.ACTPAYCST_HOURS

Historical Payroll Cost > Foreign Keys > EMP_ID

SO_ACTUAL_PAY_COST.EMP_ID

Historical Payroll Cost > Foreign Keys > SKDGRP_ID

SO_ACTUAL_PAY_COST.SKDGRP_ID

Hour Type

WFMBurst

Burst Work

Hour Type > Hour Type

HOUR_TYPE.HTYPE_LOC_NAME

Burst Work Schedule Aggregation

Hour Type > Hour Type Description

HOUR_TYPE.HTYPE_LOC_DESC

WFMStandard

Scheduling

Hour Type > Hour Type YAG

HOUR_TYPE.HTYPE_YAG

Work

Hour Type > Hour Type Multiple

HOUR_TYPE.HTYPE_MULITPLE

Hour Type > Is Overtime

HOUR_TYPE.HTYPE_RPT_ISOT

Hour Type > Hour Type UDFs > HTYPE_FLAG?

HOUR_TYPE.HTYPE_FLAG?

Hour Type > Hour Type UDFs > HTYPE_UDF?

HOUR_TYPE.HTYPE_UDF?

Hour Type > Keys > HTYPE_ID

HOUR_TYPE.HTYPE_ID

Hour Type > Keys > Htype Name

HOUR_TYPE.HTYPE_NAME

Import Details

WFMSystem

System Information > Interfaces

Import Details > Record Number

WBINT_IMPORT.WBIMP_RECNUM

Import Details > Processed Date

WBINT_IMPORT.WBIMP_PROC_DATE

Import Details > Record Status

WBINT_IMPORT.WBIMP_STATUS

Import Details > Record Message

WBINT_IMPORT.WBIMP_MSG

Import Details > Keys > WBIMP_ID

WBINT_IMPORT.WBIMP_ID

Import Details > Keys > WBITRAN_ID

WBINT_IMPORT.WBITRAN_ID

Job

WFMBurst

Burst Employee Information

Job > Job Name

JOB.JOB_NAME

Burst Work

Job > Job Description

JOB.JOB_DESC

WFMStandard

Employee Information > Default Labor

Job > Tipped

JOB.JOB_TIP

Scheduling

Job > Healthcare Type

JOB.JOB_RPT_HCTYPE

Work

Job > Job UDFs > JOB_FLAG?

JOB.JOB_FLAG?

Job > Job Title Code

JOB.JOB_PBJ_TITLE_CODE

Scheduling MVS > Call List

Job > Job UDFs > JOB_REFKEY?

JOB.JOB_REFKEY?

Scheduling MVS > Rotation Row Conflicts

Job > Job UDFs > JOB_VAL?

JOB.JOB_VAL?

Scheduling MVS > Row Labor Metrics

Job > Keys > JOB_ID

JOB.JOB_ID

Scheduling MVS > Schedule Templates > Shift Requirement Template

Scheduling MVS > Workload Requirement

Job Rate

WFMStandard

Scheduling

Job Rate > Index

JOB_RATE.JOBRATE_INDEX

Job Rate > Effective Date

JOB_RATE.JOBRATE_EFFECTIVE_DATE

Job Rate > Rate

JOB_RATE.JOBRATE_RATE

Job Rate > Job Rate UDFs > JOBRATE_FLAG?

JOB_RATE.JOBRATE_FLAG?

Job Rate > Job Rate UDFs > JOBRATE_VAL?

JOB_RATE.JOBRATE_VAL?

Job Rate > Foreign Keys > JOB_ID

JOB_RATE.JOBRATE_ID

Last Logged

WFMSystem

System Information > Last Logged

Last Logged > Last Logged

JOBSKD_LASTLOGGED.LastLogged

Last Logged > Keys > JSTSK_ID

JOBSKD_LASTLOGGED.JSTSK_ID

Latest Published Info

WFMBurst

Burst Labor Budgeting

Latest Published Info > Published Date

FCST_PUB_FORECAST.FCPUB_DATE

WFMStandard

Scheduling

Latest Published Info > Unpublished Date

FCST_PUB_FORECAST.FCPUB_UNPUB_DATE

Latest Published Info > User Name

FCST_PUB_FORECAST.WBU_NAME_ACTUAL

Latest Published Info > Is Active

FCST_PUB_FORECAST.FCPUB_ACTIVE

Latest Published Info > Keys > FC_ID

FCST_PUB_FORECAST.FC_ID

Latest Published Info > Keys > WBU_ID

FCST_PUB_FORECAST.WBU_ID

Leave Reason

WFMStandard

Scheduling MVS > Scheduled Shifts > Leave Reason

Leave Reason > Leave Reason Name

ES_LEAVE_REASON.ESLVR_NAME

Leave Reason > Leave Reason Description

ES_LEAVE_REASON.ESLVR_DESC

Leave Reason > Keys > ESLVR_ID

ES_LEAVE_REASON.ESLVR_ID

Leave Reason > UDFs > ESLVR_FLAG?

ES_LEAVE_REASON.ESLVR_FLAG?

Leave Reason > UDFs > ESLVR_UDF?

ES_LEAVE_REASON.ESLVR_UDF?

Location

WFMBurst

Burst Actual Results

Location > Location Name

SO_SCHEDULE_GROUP.SKDGRP_NAME

Burst Forecasting

Location > Staffing Standard

SO_SCHEDULE_GROUP.SKDGRP_STAFF_STD

Burst Historical Payroll Cost

Location > Forecast Method

SO_SCHEDULE_GROUP.SKDGRP_FCAST_MTD

Burst Labor Budgeting

Location > Forecast Interval

SO_SCHEDULE_GROUP.SKDGRP_FCAST_INT

Burst Schedule Analysis

Location > Start of Week

SO_SCHEDULE_GROUP.SKDGRP_STARTDOW

Burst Scheduling

Location > Internal Type

SO_SCHEDULE_GROUP.SKDGRP_INTRNL_TYPE

Burst Staffing

Location > Volume Type

SO_VOLUME_TYPE.VOLTYP_LOC_NAME

Burst Work

Location > Budget Type

SO_SCHEDULE_GROUP.SKDGRP_BUDG_TYPE

WFMStandard

Actual Results

Location > Budget Value 1

SO_SCHEDULE_GROUP.SKDGRP_BUDG_VAL1

Availability

Location > Budget Value 2

SO_SCHEDULE_GROUP.SKDGRP_BUDG_VAL2

Employee Information

Location > Variable Staffing Calculation

SO_SCHEDULE_GROUP.SKDGRP_CALCVARSTF

Historical Payroll Cost

Location > Sales Based

SO_SCHEDULE_GROUP.SKDGRP_SALES_BASED

Scheduling

Location > Client Key

SO_SCHEDULE_GROUP.SKDGRP_CLIENTKEY

Work

Location > Keys > SKDGRP_ID

SO_SCHEDULE_GROUP.SKDGRP_ID

Location > Keys > SKDGRP_Parent_ID

SO_SCHEDULE_GROUP.SKDGRP_PARENT_ID

Location > Keys > WBT_ID

SO_SCHEDULE_GROUP.WBT_ID

Location > Keys > VOLTYP_ID

SO_SCHEDULE_GROUP.VOLTYP_ID

Location Properties

WFMStandard

Scheduling

Location Properties > Property Name

SO_LOCATION_PROP.PROP_LOC_NAME

Location Properties > Property Description

SO_LOCATION_PROP.PROP_LOC_DESC

Location Properties > Location Property Description

SO_LOCATION_PROP.LOCPROP_LOC_DESC

Location Properties > Location Property Value

SO_LOCATION_PROP.LOCPROP_VALUE

Location Properties > Location Property UDFs > LOCPROP_FLAG?

SO_LOCATION_PROP.LOCPROP_FLAG?

Location Properties > Location Property UDFs > LOCPROP_UDF?

SO_LOCATION_PROP.LOCPROP_UDF?

Location Properties > Keys > LOCPROP_ID

SO_LOCATION_PROP.LOCPROP_ID

Location Properties > Keys > PROP_ID

SO_LOCATION_PROP.PROP_ID

Location Properties > Keys > SKDGRP_ID

SO_LOCATION_PROP.SKDGRP_ID

Location Property Workload

WFMStandard

Scheduling

Location Property Workload > Volume per hour

SO_LOCPROP_WORKLD.PRWRKLD_STDVOL_HR

Location Property Workload > Location Property Workload UDFs > PRWRKLD_FLAG?

SO_LOCPROP_WORKLD.PRWRKLD_FLAG?

Location Property Workload > Location Property Workload UDFs > PRWRKLD_UDF?

SO_LOCPROP_WORKLD.PRWRKLD_UDF?

Location Property Workload > Keys > CSD_ID

SO_LOCPROP_WORKLD.CSD_ID

Location Property Workload > Keys > LOCPROP_ID

SO_LOCPROP_WORKLD.LOCPROP_ID

Location Property Workload > Keys > PRWRKLD_ID

SO_LOCPROP_WORKLD.PRWRKLD_ID

Machine

WFMStandard

Scheduling MVS > Production Plans

Machine > Machine Name

MACHINE.MACH_NAME

Scheduling MVS > Schedule Templates > Production Template

Machine > Machine Description

MACHINE.MACH_DESC

Machine > Keys > MACH_ID

MACHINE.MACH_ID

Machine > 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

WFMBurst

Burst Labor Budgeting

Month Time Period > Month

FCST_TIME_PERIOD.FCTP_LOC_NAME

WFMStandard

Scheduling

Month Time Period > Month Description

FCST_TIME_PERIOD.FCTP_LOC_DESC

Month Time Period > Start Date

FCST_TIME_PERIOD.FCTP_START_DATE

Month Time Period > End Date

FCST_TIME_PERIOD.FCTP_END_DATE

Month Time Period > Keys > FCTP_ID

FCST_TIME_PERIOD.FCTP_ID

Month Time Period > Keys > FCTP_PARENT_ID

FCST_TIME_PERIOD.FCTP_PARENT_ID

Original Employee

WFMStandard

Scheduling MVS > Rotations > Rotatation Row Assignments

Employee > Employee ID

EMPLOYEE.EMP_NAME

Employee > Full Name

EMPLOYEE.EMP_FULLNAME

Employee > First Name

EMPLOYEE.EMP_FIRSTNAME

Employee > Last Name

EMPLOYEE.EMP_LASTNAME

Employee > Is Full Time

EMPLOYEE.EMP_FULLTIME

Employee > Status

EMPLOYEE.EMP_STATUS

Employee > Is Home Team

SEC_EMPLOYEE.EMPT_HOME_TEAM

Employee > Base Rate

EMPLOYEE.EMP_BASE_RATE

Employee > Hire Date

EMPLOYEE.EMP_HIRE_DATE

Employee > Effective Date

EMPLOYEE.EMP_EFFECTIVE_DATE

Employee > Termination Date

EMPLOYEE.EMP_TERMINIATION_DATE

Employee > Seniority Date

EMPLOYEE.EMP_SENIORITY_DATE

Employee > Birth Date

EMPLOYEE.EMP_BIRTH_DATE

Employee > SIN

EMPLOYEE.EMP_SIN

Employee > Seniority

EMPLOYEE.EMP_SENIORITY_NUMBER

Employee > Shift Pattern Offset

EMPLOYEE.EMP_SHFTPAT_OFFSET

Employee > Default Minutes

EMPLOYEE.EMP_DEF_MINUTES

Employee > Full Time Equivalent

EMPLOYEE.EMP_FTE

Employee > Employee UDFs > EMP_FLAG?

EMPLOYEE.EMP_FLAG?

Employee > Employee UDFs > EMP_VAL?

EMPLOYEE.EMP_VAL?

Employee > Keys > EMP_ID

EMPLOYEE.EMP_ID

Employee > Keys > WBT_ID

SEC_EMPLOYEE.WBT_ID

Employee > Keys > TEAM_START_DATE

SEC_EMPLOYEE.START_DATE

Employee > Keys > TEAM_END_DATE

SEC_EMPLOYEE.END_DATE

Employee > UDFs > EMP_FLAG?

EMPLOYEE.EMP_FLAG?

Employee > UDFs > EMP_VAL?

EMPLOYEE.EMP_VAL?

Employee > Work Type > Work Type Name

EMPLOYEE_WORK_TYPE.EMPWRKTYP_NAME

Employee > Work Type > Work Type Description

EMPLOYEE_WORK_TYPE.EMPWRKTYP_DESC

Employee > Work Type > Work Type Full Time

EMPLOYEE_WORK_TYPE.EMPWRKTYP_FULLTIME

Employee > Work Type > Work Type Sort Order

EMPLOYEE_WORK_TYPE.EMPWRKTYP_SORTORDER

Employee > Work Type > Work Type UDFs > EMPWRKTYP_FLAG?

EMPLOYEE_WORK_TYPE.EMPWRKTYP_FLAG?

Employee > Work Type > Work Type UDFs > EMPWRKTYP_UDF?

EMPLOYEE_WORK_TYPE.EMPWRKTYP_UDF?

Employee > Employment Type > Employment Type Name

EMPLOYMENT_TYPE.EMPTYP_NAME

Employee > Employment Type > Employment Type Description

EMPLOYMENT_TYPE.EMPTYP_DESC

Employee > Employment Type > Employment Type Sort Order

EMPLOYMENT_TYPE.EMPTYP_SORTORDER

Employee > Employment Type > Employment Type UDFs > EMPTYPE_FLAG?

EMPLOYMENT_TYPE.EMPTYP_FLAG?

Employee > Employment Type > Employment Type UDFs > EMPTYPE_UDF?

EMPLOYMENT_TYPE.EMPTYP_UDF?

Employee > System Scheduling Enabled

EMPLOYEE.EMP_SYSTEM_SCHEDULING_ENABLED

OTE Employee Points

WFMStandard

Overtime Equalization

OTE Employee Points > Current OTE Points

OTE_GROUP_EMPLOYEE.OTEGE_POINTS

OTE Employee Points > Foreign Keys > EMP_ID

OTE_GROUP_EMPLOYEE.EMP_ID

OTE Group

WFMStandard

Overtime Equalization

OTE Group > OTE Group Name

OTE_GROUP.OTEGRP_NAME

OTE Group > OTE Group Description

OTE_GROUP.OTEGRP_DESCRIPTION

OTE Group > Keys > OTEGRP_ID

OTE_GROUP.OTEGRP_ID

OTE Offers

WFMStandard

Overtime Equalization

OTE Offers > Offer Description

OTE_OFFER.OTEOFF_DESC

OTE Offers > Date of Offer

OTE_OFFER.OTEOFF_CREATE_DATE

OTE Offers > Date of Offered Work

OTE_OFFER.OTEOFF_OFFER_DATE

OTE Offers > Time of Offered Work

OTE_OFFER.OTEOFF_OFFR_STTM

OTE Offers > Duration

OTE_OFFER.OTEOFFER_HOURS

OTE Offers > Keys > OTEOFF_ID

OTE_OFFER.OTEOFFER_ID

OTE Offers > Keys > OTEOFF_GROUPS_OFFR

OTE_OFFER.OTEOFF_GROUPS_OFFR

OTE Responses

WFMStandard

Overtime Equalization

OTE Responses > Responses Date

OTE_RESPONSE.OTERESP_RESPONS_DT

OTE Responses > Response

OTE_RESPONSE.OTERESP_RESPONSE

OTE Responses > Hours Accepted

OTE_RESPONSE.OTERESP_HOURS_ACP

OTE Responses > Points Charged

OTE_RESPONSE.OTERESP_PTS_CHRG

OTE Responses > Points to Date

OTE_RESPONSE.OTERESP_PTS_TODT

OTE Responses > Keys > OTERESP_ID

OTE_RESPONSE.OTERESP_ID

OTE Responses > Foreign Keys > EMP_ID

OTE_RESPONSE.EMP_ID

OTE Responses > Foreign Keys > OTEOFF_ID

OTE_RESPONSE.OTEOFF_ID

Override

WFMStandard

Auditing

Override > Created By

VIEW_OVERRIDE.WBU_NAME

Override > Create By (Actual)

VIEW_OVERRIDE.WBU_NAME_ACTUAL

Override > Creation Date

VIEW_OVERRIDE.OVR_CREATE_DATE

Override > Type

VIEW_OVERRIDE.OVRTYP_NAME

Override > Start Date

VIEW_OVERRIDE.OVR_START_DATE

Override > End Date

VIEW_OVERRIDE.OVR_END_DATE

Override > Start Time

VIEW_OVERRIDE.OVR_START_TIME

Override > End Time

VIEW_OVERRIDE.OVR_END_TIME

Override > Old Value

VIEW_OVERRIDE.OVR_OLD_VALUE

Override > New Value

VIEW_OVERRIDE.OVR_NEW_VALUE

Override > Status

VIEW_OVERRIDE.OVR_STATUS

Override > Comment

VIEW_OVERRIDE.OVR_COMMENT

Override > Message

VIEW_OVERRIDE.OVR_MESSAGE

Override > Cancelled by Actual

[OVERRIDE].[OVR_CANCELLED_BY_A]

Override > Cancelled By

VIEW_OVERRIDE.OVR_CANCELLED_BY

Override > Cancelled Date

VIEW_OVERRIDE.OVR_CANCELLED_DATE

Override > Override UDFs > OVR_FLAG?

VIEW_OVERRIDE.OVR_FLAG?

Override > Override UDFs > OVR_UDF?

VIEW_OVERRIDE.OVR_UDF?

Override > Keys > OVR_ID

VIEW_OVERRIDE.EMP_ID

Override > Foreign Keys > EMP_ID

VIEW_OVERRIDE.OVRTYP_ID

Override > Foreign Keys > OVRTYP_ID

VIEW_OVERRIDE.OVR_ID

Parent Staffing Requirement Template

WFMStandard

Scheduling MVS > Schedule Templates

Parent Staffing Requirement Template > Template Name

ES_SCHEDULE_TEMPLATE.TMPL_NAME

Parent Staffing Requirement Template > Template Description

ES_SCHEDULE_TEMPLATE.TMPL_DESC

Parent Staffing Requirement Template > Template Length

ES_SCHEDULE_TEMPLATE.TMPL_LENGTH

Parent Staffing Requirement Template > Template Create Date

ES_SCHEDULE_TEMPLATE.TMPL_CREATE_DATE

Parent Staffing Requirement Template > Template Start Date

ES_SCHEDULE_TEMPLATE.TMPL_START_DATE

Parent Staffing Requirement Template > Template End Date

ES_SCHEDULE_TEMPLATE.TMPL_END_DATE

Parent Staffing Requirement Template > Is Template Active

ES_SCHEDULE_TEMPLATE.TMPL_ACTIVE

Parent Staffing Requirement Template > UDFs > TMPL_FLAG?

ES_SCHEDULE_TEMPLATE.TMPL_FLAG?

Parent Staffing Requirement Template > UDFs > TMPL_UDF?

ES_SCHEDULE_TEMPLATE.TMPL_UDF?

Parent Staffing Requirement Template > Keys > TMPL_ID

ES_SCHEDULE_TEMPLATE.TMPL_ID

Parent Staffing Requirement Template > Foreign Keys > WBT_ID

ES_SCHEDULE_TEMPLATE.WBT_ID

Parent Staffing Requirement Template > Foreign Keys > TMPLTYP_ID

ES_SCHEDULE_TEMPLATE.TMPLTYP_ID

Parent Staffing Requirement Template > Foreign Keys > TMPL_PARENT_ID

ES_SCHEDULE_TEMPLATE.TMPL_PARENT_ID

Parsed Override Token

WFMStandard

Auditing

Parsed Override Token > Token Name

WBI_OVERRIDE_VALUE.WOV_TOKEN_LOC_NAME

Parsed Override Token > Token Value

WBI_OVERRIDE_VALUE.WOV_TOKEN_VALUE

Parsed Override Token > Data As Of Date

WBI_OVERRIDE_VALUE.WOV_DATA_ASOF

Parsed Override Token > Keys > CAMPASSPORT_ID

WBI_OVERRIDE_VALUE.WOV_CAMPASSPRT_ID

Parsed Override Token > Keys > CGCRT_ID

WBI_OVERRIDE_VALUE.CGCRT_ID

Parsed Override Token > Keys > CGMAP_ID

WBI_OVERRIDE_VALUE.CGMAP_ID

Parsed Override Token > Keys > WBU_ID

WBI_OVERRIDE_VALUE.WBU_ID

Parsed Override Token > Keys > WOV_ID

WBI_OVERRIDE_VALUE.WOV_ID

Parsed Override Token > Foreign Keys > OVR_ID

WBI_OVERRIDE_VALUE.OVR_ID

Pay Group

WFMBurst

Burst Census

Pay Group > Pay Group Name

PAY_GROUP.PAYGRP_NAME

Burst Work Schedule Aggregration

Pay Group > End Date

PAY_GROUP.PAYGRP_END_DATE

WFMStandard, WFMBurst

Work, Employee Information, Burst Work, Burst Employee Information

Pay Group > Pay Group Name

[PAY_GROUP].[PAYGRP_LOC_NAME]

Pay Group > Pay Group Description

[PAY_GROUP].[PAYGRP_LOC_DESC]

Pay Group > Start Date

[PAY_GROUP].[PAYGRP_START_DATE]

Pay Group > End Date

[PAY_GROUP].[PAYGRP_END_DATE]

Pay Group > Day Start Time

[PAY_GROUP].[PAYGRP_DAY_START_TIME]

Pay Group > Hands Off Date

[PAY_GROUP].[PAYGRP_HANDS_OFF_DATE]

Pay Group > Supervisor Date

[PAY_GROUP].[PAYGRP_SUPERVISOR_DATE]

Pay Group > Year First Date

[PAY_GROUP].[PAYGRP_YEAR_FIRST_DATE]

Pay Group > Adjust Date

[PAY_GROUP].[PAYGRP_ADJUST_DATE]

Pay Group > Adjustment Offset

[PAY_GROUP].[PAYGRP_OFFSET]

Pay Group > Pay Group UDFs > PAYGRP_FLAG[1-10]

[PAY_GROUP].[PAYGRP_FLAG*]

Pay Group > Pay Group UDFs > PAYGRP_UDF[1-10]

[PAY_GROUP].[PAYGRP_UDF*]

Pay Group > Keys > PAYGRP_ID

[PAY_GROUP].[PAYGRP_ID]

Pay Group > Foreign Keys > CUR_ID

[PAY_GROUP].[CUR_ID]

Pay Group > Foreign Keys > CONGR_ID

[PAY_GROUP].[CONGR_ID]

WFMSystem

System Information > Errors and Exceptions

Pay Group > Supervisor Date

PAY_GROUP.PAYGRP_SUPERVISOR_DATE

Pay Group > Year First Date

PAY_GROUP.PAYGRP_YEAR_FIRST_DATE

Pay Group > Adjust Date

PAY_GROUP.PAYGRP_ADJUST_DATE

Pay Group > Adjustment Offset

PAY_GROUP.PAYGRP_OFFSET

Pay Group > Pay Group UDFs > PAYGRP_FLAG?

PAY_GROUP.PAYGRP_FLAG?

Pay Group > Pay Group UDFs > PAYGRP_UDF?

PAY_GROUP.PAYGRP_UDF?

Pay Group > Keys > PAYGRP_ID

PAY_GROUP.PAYGRP_ID

Policy

WFMStandard

Leave Management Policies

Policy > Policy Name

ENT_POLICY.ENTPOL_NAME

Policy > Policy Description

ENT_POLICY.ENTPOL_DESC

Policy > Policy Start Date

ENT_POLICY.ENTPOL_START_DATE

Policy > Policy End Date

ENT_POLICY.ENTPOL_END_DATE

Policy > Priority

ENT_EMP_POLICY.ENTEMPPOL_PRIORITY

Policy > Employee Start Date

ENT_EMP_POLICY.ENTEMPPOL_START_DT

Policy > Employee End Date

ENT_EMP_POLICY.ENTEMPPOL_END_DATE

Policy > Employee Enabled

ENT_EMP_POLICY.ENTEMPPOL_ENABLED

Policy > Policy UDFs > ENTPOL_FLAG?

ENT_POLICY.ENTPOL_FLAG?

Policy > Policy UDFs > ENTPOL_UDF?

ENT_POLICY.ENTPOL_UDF?

Policy > Policy UDFs > ENTEMPPOL_FLAG?

ENT_EMP_POLICY.ENTPOL_FLAG?

Policy > Policy UDFs > ENTEMPPOL_UDF?

ENT_ EMP_POLICY.ENTPOL_UDF?

Policy > Keys > ENTPOL_ID

ENT_EMP_POLICY.ENTPOL_ID

Policy > Foreign Keys > EMP_ID

ENT_EMP_POLICY.EMP_ID

Product

WFMStandard

Scheduling MVS > Production Plans

Product > Product Name

PRODUCT.PROD_LOC_NAME

Scheduling MVS > Schedule Template > Production Template

Product > Product Description

PRODUCT.PROD_LOC_DESC

Product > Keys > PROD_ID

PRODUCT.PROD_ID

Production Plan

WFMStandard

Scheduling MVS > Production Plans

Production Plan > Action

ES_PROD_MACH_PLAN.PRODPLAN_IS_REMOVE

Production Plan > Production Plan Start Date

ES_PROD_MACH_PLAN.PRODPLAN_START_DATE

Production Plan > Production Plan End Date

ES_PROD_MACH_PLAN.PRODPLAN_END_DATE

Production Plan > UDFs > PROD_PLANFLAG?

ES_PROD_MACH_PLAN.PRODPLAN_FLAG?

Production Plan > Keys > PRODPLAN_ID

ES_PROD_MACH_PLAN.PRODPLAN_ID

Production Plan > Foreign Keys > MACH_ID

ES_PROD_MACH_PLAN.MACH_ID

Production Plan > Foreign Keys > PLANSTAT_ID

ES_PROD_MACH_PLAN.PLANSTAT_ID

Production Plan Shift

WFMStandard

Scheduling MVS > Production Plans

Production Plan Shift > Keys > PLSHIDFT_ID

ES_PROD_MACH_PLAN_SHIFT.PLSHIFT_ID

Production Plan Shift > Foreign Keys > PRODPLAN_ID

ES_PROD_MACH_PLAN_SHIFT.PRODPLAN_ID

Production Plan Shift > Foreign Keys > SHIFTSUM_ID

ES_PROD_MACH_PLAN_SHIFT.SHIFTSUM_ID

Production Plan Status

WFMStandard

Scheduling MVS > Production Plans

Production Plan Status > Production Plan Status Name

ES_PROD_MACH_PLAN_STATUS.PLANSTAT_NAME

Production Plan Status > Production Plan Status Description

ES_PROD_MACH_PLAN_STATUS.PLANSTAT_DESC

Production Plan Status > Keys > PLANSTAT_ID

ES_PROD_MACH_PLAN_STATUS.PLANSTAT_ID

Production Plan Status > Keys > PLANSTAT_ID

ES_PROD_MACH_PLAN_STATUS.PLANSTAT_ID

Production Machine Template

WFMStandard

Scheduling MVS > Schedule Templates > Production Template

Production Machine Template > UDFs > PMTMPL_FLAG?

ES_PROD_MACH_TEMPLATE.PMTMPL_FLAG?

Production Machine Template > UDFs > PMTMPL_UDF?

ES_PROD_MACH_TEMPLATE.PMTMPL_UDF?

Production Machine Template > Foreign Keys > MACH_ID

ES_PROD_MACH_TEMPLATE.MACH_ID

Production Machine Template > Foreign Keys > PROD_ID

ES_PROD_MACH_TEMPLATE.PROD_ID

Production Machine Template > Foreign Keys > TMPL_ID

ES_PROD_MACH_TEMPLATE.TMPL_ID

Project

WFMBurst

Burst Employee Information

Project > Project Name

PROJECT.PROJ_LOC_NAME

Burst Work

Project > Project Description

PROJECT.PROJ_LOC_DESC

Burst Work Schedule Aggregation

Project > Keys > PROJ_ID

PROJECT.PROJ_ID

WFMStandard

Employee Information

Scheduling

Work

Scheduling MVS > Rotations > Rotation Row Conflict

Scheduling MVS > Row Labor Metrics

Quarter Time Period

Query Subject Filter: Days between Start Date and End Date is > 80 and < 100 days

WFMBurst

Burst Labor Budgeting

Quarter Time Period > Quarter

FCST_TIME_PERIOD.FCTP_LOC_NAME

WFMStandard

Scheduling > Default Time Periods

Quarter Time Period > Quarter Description

FCST_TIME_PERIOD.FCTP_LOC_DESC

Quarter Time Period > Start Date

FCST_TIME_PERIOD.FCTP_START_DATE

Quarter Time Period > End Date

FCST_TIME_PERIOD.FCTP_END_DATE

Quarter Time Period > Keys > FCTP_ID

FCST_TIME_PERIOD.FCTP_ID

Quarter Time Period > Keys > FCTP_PARENT_ID

FCST_TIME_PERIOD.FCTP_PARENT_ID

Reason

WFMStandard

Scheduling MVS > Scheduled Shifts > Call Logs > Reason

Reason > Reason Name

ES_REASON.REASON_LOC_NAME

Reason > Reason Description

ES_REASON.REASON_LOC_DESC

Reason > Reason Sort Order

ES_REASON.REASON_SORT_ORDER

Reason > Is Default Reject

ES_REASON.REASON_DEF_REJECT

Reason > Reject Due to Compliance

ES_REASON.REASON_DEF_REJECT_SKDCOMP

Reason > Reject Due to Availability

ES_REASON.REASON_DEF_AVAIL

Reason > Keys > REASON_ID

ES_REASON.REASON_ID

Reason > UDFs > REASON_FLAG?

ES_REASON.REASON_FLAG?

Reason > UDFs > REASON_UDF?

ES_REASON.REASON_UDF?

Relief Block

WFMStandard

Scheduling MVS > Scheduled Shifts > Relief Block

Relief Block > Relief Block Create Date

ES_RELIEF_BLOCK.RELBLK_CREATE_DATE

Relief Block > Relief Block Action Date

ES_RELIEF_BLOCK.RELBLK_ACTION_DATE

Relief Block > Relief Block Start Date

ES_RELIEF_BLOCK.RELBLK_START_DATE

Relief Block > Relief Block End Date

ES_RELIEF_BLOCK.RELBLK_END_DATE

Relief Block > Keys > RELBLK_ID

ES_RELIEF_BLOCK.RELBLK_ID

Relief Block > Foreign Keys > EMP_ID

ES_RELIEF_BLOCK.EMP_ID

Relief Block > UDFs > RELBLK_FLAG?

ES_RELIEF_BLOCK.RELBLK_FLAG?

Relief Block > UDFs > RELBLK_UDF?

ES_RELIEF_BLOCK.RELBLK_UDF?

Relief Block Employee

WFMStandard

Scheduling MVS > Scheduled Shifts > Relief Block Employee

Relief Block Employee > Employee ID

EMPLOYEE.EMP_NAME

Relief Block Employee > Full Name

EMPLOYEE.EMP_FULLNAME

Relief Block Employee > First Name

EMPLOYEE.EMP_FIRSTNAME

Relief Block Employee > Last Name

EMPLOYEE.EMP_LASTNAME

Relief Block Employee > Is Full Time

EMPLOYEE.EMP_FULLTIME

Relief Block Employee > Status

EMPLOYEE.EMP_STATUS

Relief Block Employee > Is Home Team

SEC_EMPLOYEE.EMPT_HOME_TEAM

Relief Block Employee > Base Rate

EMPLOYEE.EMP_BASE_RATE

Relief Block Employee > Hire Date

EMPLOYEE.EMP_HIRE_DATE

Relief Block Employee > Effective Date

EMPLOYEE.EMP_EFFECTIVE_DATE

Relief Block Employee > Termination Date

EMPLOYEE.EMP_TERMINATION_DATE

Relief Block Employee > Seniority Date

EMPLOYEE.EMP_SENIORITY_DATE

Relief Block Employee > Birth Date

EMPLOYEE.EMP_BIRTH_DATE

Relief Block Employee > SIN

EMPLOYEE.EMP_SIN

Relief Block Employee > Seniority

EMPLOYEE.EMP_SENIORITY_NUMBER

Relief Block Employee > Shift Pattern Offset

EMPLOYEE.EMP_SHFTPAT_OFFSET

Relief Block Employee > Default Minutes

EMPLOYEE.EMP_DEF_MINUTES

Relief Block Employee > Full Time Equivalent

EMPLOYEE.EMP_FTE

Relief Block Employee > System Scheduling Enabled

EMPLOYEE.EMP_SYSTEM_SCHEDULING_ENABLED

Relief Block Employee > Keys > EMP_ID

EMPLOYEE.EMP_ID

Relief Block Employee > Keys > WBT_ID

SEC_EMPLOYEE.WBT_ID

Relief Block Employee > Keys > TEAM_START_DATE

SEC_EMPLOYEE.START_DATE

Relief Block Employee > Keys > TEAM_END_DATE

SEC_EMPLOYEE.END_DATE

Relief Block Employee > Work Type > Work Type Name

EMPLOYEE_WORK_TYPE.EMPWRKTYP_NAME

Relief Block Employee > Work Type > Work Type Description

EMPLOYEE_WORK_TYPE.EMPWRKTYP_DESC

Relief Block Employee > Work Type > Work Type Full Time

EMPLOYEE_WORK_TYPE.EMPWRKTYP_FULLTIME

Relief Block Employee > Work Type > Work Type Sort Order

EMPLOYEE_WORK_TYPE.EMPWRKTYP_SORTORDER

Relief Block Employee > Work Type > Work Type UDFs > EMPWRKTYP_FLAG?

EMPLOYEE_WORK_TYPE.EMPWRKTYP_FLAG?

Relief Block Employee > Work Type > Work Type UDFs > EMPWRKTYP_UDF?

EMPLOYEE_WORK_TYPE.EMPWRKTYP_UDF?

Relief Block Employee > Employment Type > Employment Type Name

EMPLOYMENT_TYPE.EMPTYP_NAME

Relief Block Employee > Employment Type > Employment Type Description

EMPLOYMENT_TYPE.EMPTYP_DESC

Relief Block Employee > Employment Type > Employment Type Sort Order

EMPLOYMENT_TYPE.EMPTYP_SORTORDER

Relief Block Employee > Employment Type > Employment Type UDFs > EMPTYP_FLAG?

EMPLOYMENT_TYPE.EMPTYP_FLAG?

Relief Block Employee > Employment Type > Employment Type UDFs > EMPTYP_UDF?

EMPLOYMENT_TYPE.EMPTYP_UDF?

Relief Block Employee > UDFs > EMP_FLAG?

EMPLOYEE.EMP_FLAG?

Relief Block Employee > UDFs > EMP_VAL?

EMPLOYEE.EMP_VAL?

Required Job

Definition of Required Job is the same as Job query subject.

WFMBurst

Burst Staffing

Job > Job Name

JOB.JOB_NAME

Job > Job Description

JOB.JOB_DESC

Job > Tipped

JOB.JOB_TIP

Job > Healthcare Type

JOB.JOB_RPT_HCTYPE

Job > Job UDFs > JOB_FLAG?

JOB.JOB_FLAG?

Job > Job UDFs > JOB_REFKEY?

JOB.JOB_REFKEY?

Job > Job UDFs > JOB_VAL?

JOB.JOB_VAL?

Job > Keys > JOB_ID

JOB.JOB_ID

Required Job Rate

Definition of Required Job Rate is the same as Job Rate query subject.

WFMBurst

Burst Staffing

Job Rate > Index

JOB_RATE.JOBRATE_INDEX

Job Rate > Effective Date

JOB_RATE.JOBRATE_EFFECTIVE_DATE

Job Rate > Rate

JOB_RATE.JOBRATE_RATE

Job Rate > Job Rate UDFs > JOBRATE_FLAG?

JOB_RATE.JOBRATE_FLAG?

Job Rate > Job Rate UDFs > JOBRATE_VAL?

JOB_RATE.JOBRATE_VAL?

Job Rate > Foreign Keys > JOB_ID

JOB_RATE.JOBRATE_ID

Rotation

WFMStandard

Scheduling MVS > Rotations

Rotation > Rotation Name

ES_ROTATION.ROT_NAME

Rotation > Rotation Description

ES_ROTATION.ROT_DESC

Rotation > Rotation Length

ES_ROTATION.ROT_LENGTH

Rotation > Rotation Start Date

ES_ROTATION.ROT_START_DATE

Rotation > Rotation Create Date

ES_ROTATION.ROT_CREATE_DATE

Rotation > Default Rows

ES_ROTATION.ROT_DEFAULT_ROWS

Rotation > Rotation Publish Status

ES_ROTATION.ROT_PUBLISH_STATUS

Rotation > Rotation Active Status

ES_ROTATION.ROT_ACTIVE_STATUS

Rotation > One-Time Schedule Start Date

ES_ROTATION.OTS_START_DATE

Rotation > One-Time Schedule End Date

ES_ROTATION.OTS_END_DATE

Rotation > UDFs > ROT_FLAG?

ES_ROTATION.ROT_FLAG?

Rotation > UDFs > ROT_UDF?

ES_ROTATION.ROT_UDF?

Rotation > Keys > ROT_ID

ES_ROTATION.ROT_ID

Rotation > Foreign Keys > ROTYP_ID

ES_ROTATION.ROTYP_ID

Rotation > Foreign Keys > WBT_ID

ES_ROTATION.WBT_ID

Rotation > Foreign Keys > TEMPLATE_ID

ES_ROTATION.TEMPLATE_ID

Rotation Publish Task

WFMStandard

Scheduling MVS > Rotations > Rotation Publish Tasks

Rotation Publish Task > Rotation Publish Task Type

ES_ROTATION_PUBLISH_TASK.ROTPUBTSK_TYPE

Rotation Publish Task > Rotation Publish Task Status

ES_ROTATION_PUBLISH_TASK.ROTPUBTSK_STATUS

Rotation Publish Task > Rotation Publish Task Create Date

ES_ROTATION_PUBLISH_TASK.ROTPUBTSK_CREATE_DATE

Rotation Publish Task > Rotation Publish Task Scheduled Date

ES_ROTATION_PUBLISH_TASK.ROTPUBTSK_SCHEDULED_DATE

Rotation Publish Task > Rotation Publish Task Processed Date

ES_ROTATION_PUBLISH_TASK.ROTPUBTSK_PROCESSED_DATE

Rotation Publish Task > Rotation Publish Task > UDFs > ROTPUBTSK_FLAG?

ES_ROTATION_PUBLISH_TASK.ROTPUBTSK_FLAG?

Rotation Publish Task > Rotation Publish Task > UDFs > ROTPUBTSK_UDF?

ES_ROTATION_PUBLISH_TASK.ROTPUBTSK_UDF?

Rotation Publish Task > Rotation Publish Task > Keys > ROTPUBTSK_ID

ES_ROTATION_PUBLISH_TASK.ROTPUBTSK_ID

Rotation Publish Task > Rotation Publish Task > Foreign Keys > ROT_ID

ES_ROTATION_PUBLISH_TASK.ROT_ID

Rotation Publish Task > Rotation Publish Task > Foreign Keys > WBU_ID

ES_ROTATION_PUBLISH_TASK.WBU_ID

Rotation Publish Task > Rotation Publish Task > Foreign Keys > WBU_ID_ACTUAL

ES_ROTATION_PUBLISH_TASK.WBU_ID_ACTUAL

Rotation Row

WFMStandard

Scheduling MVS > Rotations

Rotation Row > Is Rotation Row Method

ES_ROTATION_ROW.ROTROW_IS_OTSROW

Rotation Row > Is One-Time Schedule Row

ES_ROTATION_ROW.ROTROW_IS_LOCKED

Rotation Row > Is Rotation Row Locked

ES_ROTATION_ROW.ROTROW_IS_MODIFIED

Rotation Row > UDFs > WBT_FLAG?

ES_ROTATION_ROW.ROTROW_FLAG?

Rotation Row > UDFs > WBT_UDF?

ES_ROTATION_ROW.ROTROW_UDF?

Rotation Row > Keys > ROTROW_ID

ES_ROTATION_ROW.ROTROW_ID

Rotation Row > Foreign Keys > ROT_ID

ES_ROTATION_ROW.ROT_ID

Rotation Row > Foreign Keys > ROTROW_TEMPLATEROW_ID

ES_ROTATION_ROW.ROTROW_TEMPLATEROW_ID

Rotation Row Assignment

WFMStandard

Scheduling MVS > Rotations > Rotation Row Assignments

Rotation Row Assignments > Assignment Start Date

ES_ROTROW_ASGMT.RRASSN_EFF_START_DATE

Rotation Row Assignments > Assignment End Date

ES_ROTROW_ASGMT.RRASSN_EFF_END_DATE

Rotation Row Assignments > Assignment Employee Status

ES_ROTROW_ASGMT.RRASSN_STATUS

Rotation Row Assignments > Assignment Comment

ES_ROTROW_ASGMT.RRASSN_COMMENT

Rotation Row Assignments > Is Override LM

ES_ROTROW_ASGMT.RRASSN_LMOVERRIDE

Rotation Row Assignments > LAT Status

ES_ROTROW_ASGMT.RRASSN_LTA

Rotation Row Assignments > RRASSN_TEMP_UNASSIGN

ES_ROTROW_ASGMT.RRASSN_TEMP_UNASSIGN

Rotation Row Assignments > UDFs > RRASSN_FLAG?

ES_ROTROW_ASGMT.RRASSN_FLAG?

Rotation Row Assignments > UDFs > RRASSN_UDF?

ES_ROTROW_ASGMT.RRASSN_UDF?

Rotation Row Assignments > Keys > RRASSN_ID

ES_ROTROW_ASGMT.RRASSN_ID

Rotation Row Assignments > Foreign Keys > ACT_ID

ES_ROTROW_ASGMT.ACT_ID

Rotation Row Assignments > Foreign Keys > EMP_ID

ES_ROTROW_ASGMT.EMP_ID

Rotation Row Assignments > Foreign Keys > EMP_ORIG_ID

ES_ROTROW_ASGMT.EMP_ORIG_ID

Rotation Row Assignments > Foreign Keys > ROTROW_ID

ES_ROTROW_ASGMT.ROTROW_ID

Rotation Row Conflict

WFMStandard

Scheduling MVS > Rotations > Rotation Row Conflicts

Rotation Row Conflict > Work Date

ES_ROTROW_CONFLICTS.WORK_DATE

Rotation Row Conflict > Conflict Action

ES_ROTROW_CONFLICTS.RRCONFL_ACTION

Rotation Row Conflict > Conflict Create Date

ES_ROTROW_CONFLICTS.RRCONFL_CREATE_DATE

Rotation Row Conflict > Conflict Process Date

ES_ROTROW_CONFLICTS.RRCONFL_PROCESS_DATE

Rotation Row Conflict > Conflict Status

ES_ROTROW_CONFLICTS.RRCONFL_STATUS

Rotation Row Conflict > Keys > RRCONFL_ID

ES_ROTROW_CONFLICTS.RRCONFL_ID

Rotation Row Conflict > Keys > ACT_ID

[ES_ROTROW_CONFLICTS].[ACT_ID]

Rotation Row Conflict > Foreign Keys > DEPT_ID

ES_ROTROW_CONFLICTS.DEPT_ID

Rotation Row Conflict > Foreign Keys > DOCK_ID

ES_ROTROW_CONFLICTS.DOCK_ID

Rotation Row Conflict > Foreign Keys > EMP_ID

ES_ROTROW_CONFLICTS.EMP_ID

Rotation Row Conflict > Foreign Keys > JOB_ID

ES_ROTROW_CONFLICTS.JOB_ID

Rotation Row Conflict > Foreign Keys > PROJ_ID

ES_ROTROW_CONFLICTS.PROJ_ID

Rotation Row Conflict > Foreign Keys > ROT_ID

ES_ROTROW_CONFLICTS.ROT_ID

Rotation Row Conflict > Foreign Keys > ROTROW_ID

ES_ROTROW_CONFLICTS.ROTROW_ID

Rotation Row Conflict > Foreign Keys > SHIFTSUM_ID

ES_ROTROW_CONFLICTS.SHIFTSUM_ID

Rotation Row Version

WFM Standard

Scheduling MVS > Rotations

Rotation Row Version > Row Version

ES_RRVER_STATUS.RRVS_NAME

Row Shift

WFMStandard

Scheduling MVS > Rotations > Row Shifts

Row Shifts > ROWSHIFT_ID

ES_ROW_SHIFTS.ROWSHIFT_ID

Row Shifts > RROTROW_ID

ES_ROW_SHIFTS.ROTROW_ID

Row Shifts > Row Shift Sequence

ES_ROW_SHIFTS.ROWSHIFT_SEQ

Row Shifts > RRVER_ID

ES_ROW_SHIFTS.RRVER_ID

Row Shifts > RSSHIFT_ID

ES_ROW_SHIFTS.ESSHIFT_ID

Row Shift Rotation Version

WFMStandard

Scheduling MVS > Rotations > Row Shifts

Row Shift Rotation Version > Rotation Version Name

ES_ROTATION_VERSION.ROTVR_NAME

Row Shift Rotation Version > Rotation Version Description

ES_ROTATION_VERSION.ROTVR_DESC

Row Shift Rotation Version > Rotation Version Create Date

ES_ROTATION_VERSION.ROTVR_CREATE_DATE

Row Shift Rotation Version > Effective Start Date

ES_ROTATION_VERSION.ROTVR_EFF_START_DATE

Row Shift Rotation Version > Effective End Date

ES_ROTATION_VERSION.ROTVR_EFF_END_DATE

Row Shift Rotation Version > Rotation Version Status

ES_ROTATION_VERSION.ROTVR_STATUS

Row Shift Rotation Version > Keys > ROTVR_ID

ES_ROTATION_VERSION.ROTVR_ID

Row Shift Rotation Version > Foreign Keys > ROT_ID

ES_ROTATION_VERSION.ROT_ID

Row Shift Rotation Version > UDFs > ROTVR_FLAG?

ES_ROTATION_VERSION.ROTVR_FLAG?

Row Shift Rotation Version > UDFs > ROTVR_UDF?

ES_ROTATION_VERSION.ROTVR_UDF?

Row Shift Violation

WFMStandard

Scheduling MVS > Rotations > Row Shifts

Row Shift Violation > Violation Value

ES_VIOLATION_SHIFT VIOLATION.Violation Value

Row Shift Violation > User Name

ES_VIOLATION_SHIFT VIOLATION.User Name

Row Shift Violation > Actual User Name

ES_VIOLATION_VIOLATION.Actual User Name

Row Shift Violation > Keys > ROWSHIFT_ID

ES_VIOLATION_VIOLATION.ROWSHIFT_ID

Row Shift Violation > Keys > VIO_ID

ES_VIOLATION_VIOLATION.VIO_ID

Row Shift Violation > Keys > CMPGRPR_ID

ES_VIOLATION_VIOLATION.CMPGRPR_ID

Row Shift Violation > UDFs > VIO_FLAG?

ES_VIOLATION_VIOLATION.VIO_FLAG?

Row Shift Violation > UDFs > VIO_UDF?

ES_VIOLATION_VIOLATION.VIO_UDF?

Rotation Team

WFMStandard

Scheduling MVS > Rotations

Rotation Team > Team Name

ES_TEAM_ROTATION TEAM.Team Name

Rotation Team > Team Description

ES_TEAM_ROTATION TEAM.Team Description

Rotation Team > Team Level

ES_TEAM_ROTATION TEAM.Team Level

Rotation Team > UDFs > WBT_FLAG?

ES_UDFS_TEAM.WBT_FLAG?

Rotation Team > UDFs > WBT_UDF?

ES_UDFS_TEAM.WBT_UDF?

Rotation Team > Keys > WBT_ID

ES_KEYS_TEAM.WBT_ID

Rotation Team > Keys > WBT_PARENT_ID

ES_KEYS_KEYS.WBT_PARENT_ID

Rotation Team > Keys > WBT_LFT

ES_KEYS_TEAM.WBT_LFT

Rotation Team > Keys > WBT_RGT

ES_KEYS_TEAM.WBT_RGT

Rotation Type

WFMStandard

Scheduling MVS > Rotations

Rotation Type > Rotation Type Name

ES_ROTATION_TYPE.Rotation Type Name

Rotation Type > Rotation Type Description

ES_ROTATION_TYPE.Rotation Type Description

Rotation Type > UDFs > ROTYP_FLAGS?

ES_UDFS_TYPE.ROTYP_FLAGS?

Rotation Type > UDFs > ROTYP_UDF?

ES_UDFS_TYPE.ROTYP_UDF?

Rotation Type > Keys > ROTYP_ID

ES_KEYS_TYPE.ROTYP_ID

Rotation Type > Create Published Shifts

[ES_ROTATION_TYPE].[ROTYP_USE_PUBLISHED_STATE]

Rotation Version

WFMStandard

Scheduling MVS > Rotations

Rotation Version > Rotation Version Name

ES_ROTATION_VERSION.Rotation Version Name

Rotation Version > Rotation Version Description

ES_ROTATION_VERSION.Rotation Version Description

Rotation Version > Effective Start Date

ES_EFFECTIVE_VERSION.Effective Start Date

Rotation Version > Effective End Date

ES_EFFECTIVE_VERSION.Effective End Date

Rotation Version > Rotation Version Status

ES_ROTATION_VERSION.Rotation Version Status

Rotation Version > Rotation Version Create Date

ES_ROTATION_ROTATION.Rotation Version Create Date

Rotation Version > UDFs > ROTVR_FLAG?

ES_UDFS_VERSION.ROTVR_FLAG?

Rotation Version > UDFs > ROTVR_UDF?

ES_UDFS_VERSION.ROTVR_UDF?

Rotation Version > Keys > ROTVR_ID

ES_KEYS_VERSION.ROTVR_ID

Rotation Version > Foreign Keys > ROT_ID

ES_FOREIGN_FOREIGN.ROT_ID

Row Labor Metric

WFMStandard

Scheduling MVS > Row Labor Metrics

Row Labor Metric > Labor Metric Row Name

ES_METRIC_LABOR.Labor Metric Row Name

Row Labor Metric > Labor Metric Order

ES_METRIC_METRIC.Labor Metric Order

Row Labor Metric > Labor Metric Split Row

ES_METRIC_LABOR.Labor Metric Split Row

Row Labor Metric > Labor Metric Planned FTE

ES_METRIC_LABOR.Labor Metric Planned FTE

Row Labor Metric > Is Labor Metric Modified

ES_METRIC_IS.Is Labor Metric Modified

Row Labor Metric > Override Shift Labor Metric

ES_METRIC_OVERRIDE.Override Shift Labor Metric

Row Labor Metric > Keys > ROWLM_ID

ES_METRIC_METRIC.ROWLM_ID

Row Labor Metric > Foreign Keys > CALCGRP_ID

ES_METRIC_FOREIGN.CALCGRP_ID

Row Labor Metric > Foreign Keys > CMGRP_ID

ES_METRIC_FOREIGN.CMGRP_ID

Row Labor Metric > Foreign Keys > DEPT_ID

ES_METRIC_FOREIGN.DEPT_ID

Row Labor Metric > Foreign Keys > DOCK_ID

ES_METRIC_FOREIGN.DOCK_ID

Row Labor Metric > Foreign Keys > JOB_ID

ES_METRIC_FOREIGN.JOB_ID

Row Labor Metric > Foreign Keys > PROJ_ID

ES_METRIC_FOREIGN.PROJ_ID

Row Labor Metric > Foreign Keys > ROTROW_ID

ES_METRIC_FOREIGN.ROTROW_ID

Row Labor Metric > Foreign Keys > ROTVR_ID

ES_METRIC_FOREIGN.ROTVR_ID

Row Labor Metric > Foreign Keys > ROWLM_TEMPLT_ID

ES_METRIC_KEYS.ROWLM_TEMPLT_ID

Row Labor Metric > Foreign Keys > RRVER_ID

ES_ROW_LM.RRVER_ID

RTSS Process

WFMStandard

RTSS

RTSS Process > Process Name

RTSS_PROCESS.RTSSP_NAME

RTSS Process > Process Description

RTSS_PROCESS.RTSSP_DESC

RTSS Process > Process Start Date

RTSS_PROCESS.RTSSP_START_DATE

RTSS Process > Process End Date

RTSS_PROCESS.RTSSP_END_DATE

RTSS Process > Process Status

RTSS_PROCESS.RTSSP_STATUS

RTSS Process > UDFs > RTSSP_FLAG?

RTSS_PROCESS.RTSSP_FLAG?

RTSS Process > UDFs > RTSSP_UDF?

RTSS_PROCESS.RTSSP_UDF?

RTSS Process > Keys > RTSSP_ID

RTSS_PROCESS.RTSSP_ID

RTSS Process > Foreign Keys > WBT_ID

RTSS_PROCESS.WBT_ID

RTSS Process > Foreign Keys > RTSSPS_ID

RTSS_PROCESS.RTSSPS_ID

RTSS Process Status

WFMStandard

RTSS

RTSS Process Status > Process Status Name

RTSS_PROCESS_STAT.RTSSPS_NAME

RTSS Process Status > Process Status Description

RTSS_PROCESS_STAT.RTSSPS_DESC

RTSS Process Status > UDF's > RTSSPS_FLAG?

RTSS_PROCESS_STAT.RTSSPS_FLAG?

RTSS Process Status > UDF's > RTSSPS_UDF?

RTSS_PROCESS_STAT.RTSSPS_UDF?

RTSS Process Status > Keys > RTSSPS_ID

RTSS_PROCESS_STAT.RTSSPS_ID

RTSS Rule

WFMStandard

RTSS

RTSS Rule > Rule Name

RTSS_RULE.RTSSR_NAME

RTSS Rule > Rule Description

RTSS_RULE.RTSSR_DESC

RTSS Rule > UDFs > RTSSR_FLAG?

RTSS_RULE.RTSSR_FLAG?

RTSS Rule > UDFs > RTSSR_UDF?

RTSS_RULE.RTSSR_UDF?

RTSS Rule > Keys > RTSSR_ID

RTSS_RULE.RTSSR_ID

RTSS Rule Enforcement Level

WFMStandard

RTSS

RTSS Rule Enforcement Level > Rule Enforcement Level Name

RTSS_RUL_ENF_LEVEL.RTSSREL_NAME

RTSS Rule Enforcement Level > Rule Enforcement Level Description

RTSS_RUL_ENF_LEVEL.RTSSREL_DESC

RTSS Rule Enforcement Level > UDFs > RTSSREL_FLAG?

RTSS_RUL_ENF_LEVEL.RTSSREL_FLAG?

RTSS Rule Enforcement Level > UDFs > RTSSREL_UDF?

RTSS_RUL_ENF_LEVEL.RTSSREL_UDF?

RTSS Rule Enforcement Level > Keys > RTSSREL_ID

RTSS_RUL_ENF_LEVEL.RTSSREL_ID

RTSS Rule Error Log

WFMStandard

RTSS

RTSS Rule Error Log > Rule Error Start Date

RTSS_RULE_ERR_LOG.RTSSRLG_START_DATE

RTSS Rule Error Log > Rule Error End Date

RTSS_RULE_ERR_LOG.RTSSRLG_END_DATE

RTSS Rule Error Log > Rule Error Message

RTSS_RULE_ERR_LOG.RTSSRLG_ERROR_MSG

RTSS Rule Error Log > UDFs > RTSSRLG_FLAG?

RTSS_RULE_ERR_LOG.RTSSRLG_FLAG?

RTSS Rule Error Log > UDF's > RTSSRLG_UDF?

RTSS_RULE_ERR_LOG.RTSSRLG_UDF?

RTSS Rule Error Log > Keys > RTSSRLG_ID

RTSS_RULE_ERR_LOG.RTSSRLG_ID

RTSS Rule Error Log > Foreign Keys > EMP_ID

RTSS_RULE_ERR_LOG.EMP_ID

RTSS Rule Error Log > Foreign Keys > RTSSP_ID

RTSS_RULE_ERR_LOG.RTSSP_ID

RTSS Rule Error Log > Foreign Keys > RTSSR_ID

RTSS_RULE_ERR_LOG.RTSSR_ID

RTSS Rule Error Log > Foreign Keys > RTSSREL_ID

RTSS_RULE_ERR_LOG.RTSSREL_ID

Schedule

WFMBurst

Burst Schedule Analysis

Schedule > Schedule Name

SO_SCHEDULE.SKD_NAME

WFMStandard

Scheduling

Schedule > Schedule Description

SO_SCHEDULE.SKD_DESC

Schedule > From Date

SO_SCHEDULE.SKD_from_DATE

Schedule > To Date

SO_SCHEDULE.SKD_TO_DATE

Schedule > Keys > SKD_ID

SO_SCHEDULE.SKD_ID

Schedule > Foreign Keys > SKDGRP_ID

SO_SCHEDULE.SKDGRP_ID

Schedule Budget

WFMStandard

Scheduling

Schedule Budget > Date

SO_BUDGETING.BUDGET_DATE

Schedule Budget > Sales

SO_BUDGETING.SALES

Schedule Budget > Hours

SO_BUDGETING.HOURS

Schedule Budget > Payroll

SO_BUDGETING.PAYROLL

Schedule Budget > Foreign Keys > SKDGRP_ID

SO_BUDGETING.SKDGRP_ID

Schedule Cost

WFMBurst

Burst Schedule Analysis

Schedule Cost > Date

SO_SCHEDULE_COST.SKDCOST_DATE

WFMStandard

Scheduling

Schedule Cost > Cost

SO_SCHEDULE_COST.SKDCOST_COST

Schedule Cost > Foreign Keys > SKD_ID

SO_SCHEDULE_COST.SKD_ID

Schedule Cost Detail

WFMStandard

Scheduling

Schedule Cost Detail > Work Date

SCHED_COST_DETAIL.SCD_WORK_DATE

Schedule Cost Detail > Minutes

SCHED_COST_DETAIL.SCD_MINUTES

Schedule Cost Detail > Rate

SCHED_COST_DETAIL.SCD_RATE

Schedule Cost Detail > Schedule Cost Detail UDFs > SCD_FLAG?

SCHED_COST_DETAIL.SCD_FLAG?

Schedule Cost Detail > Schedule Cost Detail UDFs > SCD_UDF?

SCHED_COST_DETAIL.SCD_UDF?

Schedule Cost Detail > Keys > SCD_ID

SCHED_COST_DETAIL.SCD_ID

Schedule Cost Detail > Foreign Keys > DEPT_ID

SCHED_COST_DETAIL.DEPT_ID

Schedule Cost Detail > Foreign Keys > DOCK_ID

SCHED_COST_DETAIL.DOCK_ID

Schedule Cost Detail > Foreign Keys > EMP_ID

SCHED_COST_DETAIL.EMP_ID

Schedule Cost Detail > Foreign Keys > HTYPE_ID

SCHED_COST_DETAIL.HTYPE_ID

Schedule Cost Detail > Foreign Keys > JOB_ID

SCHED_COST_DETAIL.JOB_ID

Schedule Cost Detail > Foreign Keys > PROJ_ID

SCHED_COST_DETAIL.PROJ_ID

Schedule Cost Detail > Foreign Keys > SKDGRP_ID

SCHED_COST_DETAIL.SKDGRP_ID

Schedule Cost Detail > Foreign Keys > TCODE_ID

SCHED_COST_DETAIL.TCODE_ID

Schedule Period Definition

WFMStandard

Scheduling MVS > Team Schedule Period

Schedule Period Definition > Schedule Period Name

SCHEDULE_PERIOD.SCPR_NAME

Schedule Period Definition > Schedule Period Duration

SCHEDULE_PERIOD.SCPR_DURATION

Schedule Period Definition > Schedule Period Start Date

SCHEDULE_PERIOD.SCPR_START_DATE

Schedule Period Definition > Keys > SCPR_ID

SCHEDULE_PERIOD.SCPR_ID

Schedule Period Definition > UDFs > SCPR_FLAG?

SCHEDULE_PERIOD.SCPR_FLAG?

Schedule Period Definition > UDFs > SCPR_UDF?

SCHEDULE_PERIOD.SCPR_UDF?

Schedule Score

WFMBurst

Burst Schedule Analysis

Schedule Score > Budget

SO_SCHEDULE_SCORE.SKDSCORE_BUDGET

WFMStandard

Scheduling

Schedule Score > Service

SO_SCHEDULE_SCORE.SKDSCORE_SERVICE

Schedule Score > Efficiency

SO_SCHEDULE_SCORE.SKDSCORE_EFFICNCY

Schedule Score > Foreign Keys > SKD_ID

SO_SCHEDULE_SCORE.SKD_ID

Scheduled Shift

WFMBurst

Burst Scheduling

Scheduled Shift > Date

EMPLOYEE_SCHED_DTL.ESCHD_WORK_DATE

WFMStandard

Scheduling

Scheduled Shift > Shift Start Time

EMPLOYEE_SCHED_DTL.ESCHD_START_TIME

Work

Scheduled Shift > Shift End Time

EMPLOYEE_SCHED_DTL.ESCHD_END_TIME

Scheduled Shift > Scheduled Hours

EMPLOYEE_SCHED_DTL.ESCHD_MINUTES

Scheduled Shift > Scheduled Minutes

EMPLOYEE_SCHED_DTL.ESCHD_MINUTES

Scheduled Shift > Scheduled Type

EMPLOYEE_SCHED_DTL.ESCHD_TYPE

Scheduled Shift > Rate

EMPLOYEE_SCHED_DTL.ESCHD_RATE

Scheduled Shift > Quantity

EMPLOYEE_SCHED_DTL.ESCHD_QUANTITY

Scheduled Shift > Status

EMPLOYEE_SCHED_DTL.ESCHD_STATUS

Scheduled Shift > Keys > EMP_ID

EMPLOYEE_SCHED_DTL.EMP_ID

Scheduled Shift > Foreign Keys > ACT_ID

EMPLOYEE_SCHED_DTL.ACT_ID

Scheduled Shift > Foreign Keys > DEPT_ID

EMPLOYEE_SCHED_DTL.DEPT_ID

Scheduled Shift > Foreign Keys > DOCK_ID

EMPLOYEE_SCHED_DTL.DOCK_ID

Scheduled Shift > Foreign Keys > HTYPE_ID

EMPLOYEE_SCHED_DTL.HTYPE_ID

Scheduled Shift > Foreign Keys > JOB_ID

EMPLOYEE_SCHED_DTL.JOB_ID

Scheduled Shift > Foreign Keys > PROJ_ID

EMPLOYEE_SCHED_DTL.PROJ_ID

Scheduled Shift > Foreign Keys > STSKL_ID

EMPLOYEE_SCHED_DTL.STSKL_ID

Scheduled Shift > Foreign Keys > TCODE_ID

EMPLOYEE_SCHED_DTL.TCODE_ID

Scheduled Shift > Foreign Keys > WBT_ID

EMPLOYEE_SCHED_DTL.WBT_ID

Schedule Template

WFMStandard

Scheduling MVS > Schedule Templates

Schedule Template > Template Name

ES_SCHEDULE_TEMPLATE.TMPL_NAME

Schedule Template > Template Description

ES_SCHEDULE_TEMPLATE.TMPL_DESC

Schedule Template > Template Length

ES_SCHEDULE_TEMPLATE.TMPL_LENGTH

Schedule Template > Template Create Date

ES_SCHEDULE_TEMPLATE.TMPL_CREATE_DATE

Schedule Template > Template Start Date

ES_SCHEDULE_TEMPLATE.TMPL_START_DATE

Schedule Template > Template End Date

ES_SCHEDULE_TEMPLATE.TMPL_END_DATE

Schedule Template > Is Template Active

ES_SCHEDULE_TEMPLATE.TMPL_ACTIVE

Schedule Template > UDFs > TMPL_FLAG?

ES_SCHEDULE_TEMPLATE.TMPL_FLAG?

Schedule Template > UDFs > TMPL_UDF?

ES_SCHEDULE_TEMPLATE.TMPL_UDF?

Schedule Template > Keys > TMPL_ID

ES_SCHEDULE_TEMPLATE.TMPL_ID

Schedule Template > Foreign Keys > TMPL_PARENT_ID

ES_SCHEDULE_TEMPLATE.TMPL_PARENT_ID

Schedule Template > Foreign Keys > TMPLTYP_ID

ES_SCHEDULE_TEMPLATE.TMPLTYP_ID

Schedule Template > UDFs > TMPL_UDF?

ES_SCHEDULE_TEMPLATE.TMPL_UDF?

Scheduled Task

WFMSystem

System Information > Job Scheduler

Scheduled Task > Job Name

JOBSKD_TASK.JSTSK_DESC

Scheduled Task > Java Class

JOBSKD_TASK.JSTSK_CLASS_NAME

Scheduled Task > Active

JOBSKD_TASK.JSTSK_ACTIVE

Scheduled Task > Last Run Time

JOBSKD_TASK.JSTSK_LST_STRT_TM

See Notes in the Database Reference column.

Scheduled Task > 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.

See Notes in the Database Reference column.

Scheduled Task > Schedule

Notes: The Schedule query item will return different values based on these different scheduled periods: • Daily • Weekly • Monthly • Once

Scheduled Task > Keys > JSTSK_ID

JOBSKD_TASK.JSTSK_ID

Shift

WFMBurst

Burst Work

Shift > Shift Name

SHifT.SHFT_LOC_NAME

WFMStandard

Scheduling

Shift > Shift Description

SHifT.SHFT_LOC_DESC

Work

Shift > Start Time

SHifT.SHFT_START_TIME

Shift > End Time

SHifT.SHFT_END_TIME

Shift > Shift UDFs > SHFT_UDF?

SHifT.SHFT_UDF?

Shift > Shift UDFs > SHFT_VAL?

SHifT.SHFT_VAL?

Shift > Shift UDFs > SHFT_FLAG?

SHifT.SHFT_FLAG?

Shift > Keys > SHFT_ID

SHifT.SHFT_ID

Shift > Foreign Keys > SHFTGRP_ID

SHifT.SHFTGRP_ID

Shift

WFMStandard

Scheduling MVS > Shift Definition

Shift > Shift Display Label

ES_SHIFT_DISP_LABEL.ESSHIFTLAB_LABEL

Shift > Shift Description

ES_SHIFT.ESSHIFT_DESC

Shift > Shift Effective Start Date

ES_SHIFT_ATTRIBUTE.ESSHIFTATTR_EFF_START_DATE

Shift > Shift Effective End Date

ES_SHIFT_ATTRIBUTE.ESSHIFTATTR_EFF_END_DATE

Shift > Shift Start Time

ES_SHIFT_ATTRIBUTE.ESSHIFTATTR_START_TIME

Shift > Shift End Time

ES_SHIFT_ATTRIBUTE.ESSHIFTATTR_END_TIME

Shift > Apply to Sub Teams

ES_SHIFT.ESSHIFT_APPLYTO_SUB_TEAMS

Shift > Keys > ESSHIFT_ID

ES_SHIFT.ESSHIFT_ID

Shift > Keys > ESSHIFT_NAME

ES_SHIFT.ESSHIFT_NAME

Shift > Foreign Keys > ACT_ID

ES_SHIFT_ATTRIBUTE.ACT_ID

Shift > Foreign Keys > COLR_FONT_ID

ES_SHIFT_ATTRIBUTE.COLR_FONT_ID

Shift > Foreign Keys > ESSHIFTATTR_ID

ES_SHIFT_ATTRIBUTE.ESSHIFTATTR_ID

Shift > Foreign Keys > ESSHIFTLAB_ID

ES_SHIFT.ESSHIFTLAB_ID

Shift > Foreign Keys > SHFTYP_ID

ES_SHIFT_ATTRIBUTE.SHFTYP_ID

Shift > Foreign Keys > WBT_ID

ES_SHIFT.WBT_ID

Shift > Shift Attribute UDFs > ESSHIFTATTR_FLAG?

ES_SHIFT_ATTRIBUTE.ESSHIFTATTR_FLAG?

Shift > Shift Attribute UDFs > ESSHIFTATTR_UDF?

ES_SHIFT_ATTRIBUTE.ESSHIFTATTR_UDF?

Shift > UDFs > Shift Display Label UDFS > ESSHIFTLAB_FLAG?

ES_SHIFT_DISP_LABEL.ESSHIFTLAB_FLAG?

Shift > UDFs > Shift Display Label UDFS > ESSHIFTLAB_UDF?

ES_SHIFT_DISP_LABEL.ESSHIFTLAB_UDF?

Shift Activity

WFMStandard

Scheduling MVS > Shift Definition

Shift Activity > Activity Name

SO_ACTIVITY.ACT_LOC_NAME

Shift Activity > Activity Description

SO_ACTIVITY.ACT_LOC_DESC

Shift Activity > Activity Type Name

ES_ACT_TYPE.ESACTTYPE_LOC_NAME

Shift Activity > Activity Type Comments Required

ES_ACT_TYPE_MAP.ESACTTYPE_COMMENTS_REQUIRED

Shift Activity > Activity Type Reason Required

ES_ACT_TYPE_MAP.ESACTTYPE_REASON_REQUIRED

Shift Activity > Contributes to Cost

if (SO_ACTIVITY.ACT_CONT_TO_COST=1) then ('Y') else ('N')

Shift Activity > Is Paid

if ( SO_ACTIVITY.ACT_PAID is null or SO_ACTIVITY.ACT_PAID = 0 ) then ( 'N' ) else ( 'Y' )

Shift Activity > 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' )

Shift Activity > Keys > ACT_ID

SO_ACTIVITY.ACT_ID

Shift Activity > Keys > SKDGRP_ID

SO_ACTIVITY.SKDGRP_ID

Shift Activity > Keys > TCODE_ID

SO_ACTIVITY.TCODE_ID

Shift Break

WFMStandard

Scheduling MVS > Shift Definition

Shift Break > Start Time

ES_SHIFT_BREAK.ESSHIFTBRK_START_TIME

Shift Break > End Time

ES_SHIFT_BREAK.ESSHIFTBRK_END_TIME

Shift Break > Keys > ESSHIFTBRK_ID

ES_SHIFT_BREAK.ESSHIFTBRK_ID

Shift Break > Foreign Keys > ACT_ID

ES_SHIFT_BREAK.ACT_ID

Shift Break > Foreign Keys > ESSHIFTATTR_ID

ES_SHIFT_BREAK.ESSHIFTATTR_ID

Shift Break > UDFs > ESSHIFTBRK_FLAG?

ES_SHIFT_BREAK.ESSHIFTBRK_FLAG?

Shift Break > UDFs > ESSHIFTBRK_UDF?

ES_SHIFT_BREAK.ESSHIFTBRK_UDF?

Shift Day Part

WFMStandard

Scheduling MVS > Shift Definition

Shift Day Part > Day Part Name

ES_SHIFT_DAY_PART.DP_NAME

Shift Day Part > Day Part Description

ES_SHIFT_DAY_PART.DP_DESC

Shift Day Part > Day Part Short Code

ES_SHIFT_DAY_PART.DP_SHORT_CODE

Shift Day Part > Day Part Start Time

ES_SHIFT_DAY_PART.DP_START_TIME

Shift Day Part > Day Part End Time

ES_SHIFT_DAY_PART.DP_END_TIME

Shift Day Part > Is Day Part Hidden

ES_SHIFT_DAY_PART.DP_HIDE

Shift Day Part > Is First Day Part

ES_SHIFT_DAY_PART.IS_FIRST_DP

Shift Day Part > UDFs > DP_FLAG?

ES_SHIFT_DAY_PART.DP_FLAG?

Shift Day Part > UDFs > DP_UDF?

ES_SHIFT_DAY_PART.DP_UDF?

Shift Day Part > Keys > ESSHIFTDP_ID

ES_SHIFT_DAY_PART.ESSHIFTDP_ID

Shift Day Part > Keys > DP_ID

ES_SHIFT_DAY_PART.DP_ID

Shift Day Part > Foreign Keys > ESSHIFTATTR_ID

ES_SHIFT_DAY_PART.ESSHIFTATTR_ID

Shift Detail

WFMStandard

Scheduling MVS > Scheduled Shifts > Shift Detail

Shift Detail > Shift Detail Start Time

ES_SHIFT_DETAIL_LAYER.SDL_START_TIME

Shift Detail > Shift Detail End Time

ES_SHIFT_DETAIL_LAYER.SDL_END_TIME

Shift Detail > Shift Detail Hours

Calculated from ES_SHIFT_DETAIL_LAYER.SDL_START_TIMEand ES_SHIFT_DETAIL_LAYER.SDL_END_TIME

Shift Detail > Keys > SDL_ID

ES_SHIFT_DETAIL_LAYER.SDL_ID

Shift Detail > Foreign Keys > ACT_ID

ES_SHIFT_DETAIL_LAYER.ACT_ID

Shift Detail > Foreign Keys > DEPT_ID

ES_SHIFT_DETAIL_LAYER.DEPT_ID

Shift Detail > Foreign Keys > DOCK_ID

ES_SHIFT_DETAIL_LAYER.DOCK_ID

Shift Detail > Foreign Keys > ESLVR_ID

ES_SHIFT_DETAIL_LAYER.ESLVR_ID

Shift Detail > Foreign Keys > JOB_ID

ES_SHIFT_DETAIL_LAYER.JOB_ID

Shift Detail > Foreign Keys > PROJ_ID

ES_SHIFT_DETAIL_LAYER.PROJ_ID

Shift Detail > Foreign Keys > SDLTYPE_ID

ES_SHIFT_DETAIL_LAYER.SDLTYPE_ID

Shift Detail > Foreign Keys > SHIFTLINK_ID

ES_SHIFT_DETAIL_LAYER.SHIFTLINK_ID

Shift Detail > Foreign Keys > SHIFTSTAT_ID

ES_SHIFT_DETAIL_LAYER.SHIFTSTAT_ID

Shift Detail > Foreign Keys > SHIFTSUM_ID

ES_SHIFT_DETAIL_LAYER.SHIFTSUM_ID

Shift Detail > UDFs > SHIFTDTL_FLAG?

ES_SHIFT_DETAIL_LAYER.SHIFTDTL_FLAG?

Shift Detail > UDFs > SHIFTDTL_UDF?

ES_SHIFT_DETAIL_LAYER.SHIFTDTL_UDF?

Shift Detail Associated Parent Job

WFMStandard

Scheduling MVS > Scheduled Shifts

Shift Detail Associated Parent Job > Job Name

JOB for ES_JOB_ASSOCIATION.JOB_NAME

Shift Detail Associated Parent Job > Job Description

JOB for ES_JOB_ASSOCIATION.JOB_DESC

Shift Detail Associated Parent Job > Is Job Tipped

JOB for ES_JOB_ASSOCIATION.JOB_TIP

Shift Detail Associated Parent Job > Healthcare Type

JOB for ES_JOB_ASSOCIATION.JOB_RPT_HCTYPE

Shift Detail Associated Parent Job > Job Association Rank

ES_JOB_ASSOCIATION.JOBASSOC_RANK

Shift Detail Associated Parent Job > UDFs > JOB_FLAG?

JOB for ES_JOB_ASSOCIATION.JOB_FLAG?

Shift Detail Associated Parent Job > UDFs > JOB_REFKEY?

JOB for ES_JOB_ASSOCIATION.JOB_REFKEY?

Shift Detail Associated Parent Job > UDFs > JOB_VAL?

JOB for ES_JOB_ASSOCIATION.JOB_VAL?

Shift Detail Associated Parent Job > UDFs > JOB_ASSOC_FLAG?

ES_JOB_ASSOCIATION.JOBASSOC_FLAG?

Shift Detail Associated Parent Job > UDFs > JOB_ASSOC_UDF?

ES_JOB_ASSOCIATION.JOBASSOC_UDF?

Shift Detail Associated Parent Job > Keys > JOB_ID

JOB for ES_JOB_ASSOCIATION.JOB_ID

Shift Detail Associated Parent Job > Keys > JOBASSOC_ID

ES_JOB_ASSOCIATION.JOBASSOC_ID

Shift Detail Associated Parent Job > Foreign Keys > JOB_CHILD_ID

ES_JOB_ASSOCIATION.JOB_CHILD_ID

Shift Detail Layer Type

WFMStandard

Scheduling MVS > Scheduled Shifts > Shift Detail Layer Type

Shift Detail Layer Type > Shift Detail Type Name

ES_SHIFT_DETAIL_LAYER_TYPE.SDLTYPE_NAME

Shift Detail Layer Type > Shift Detail Type Description

ES_SHIFT_DETAIL_LAYER_TYPE.SDLTYPE_DESC

Shift Detail Layer Type > Keys > SDLTYPE_ID

ES_SHIFT_DETAIL_LAYER_TYPE.SDLTYPE_ID

Shift Detail Activity

WFMStandard

Scheduling MVS > Scheduled Shifts

Shift Detail Activity > Activity Name

SO_ACTIVITY.ACT_LOC_NAME

Shift Detail Activity > Activity Description

SO_ACTIVITY.ACT_LOC_DESC

Shift Detail Activity > Activity Type Name

ES_ACT_TYPE.ESACTTYPE_LOC_NAME

Shift Detail Activity > Activity Type Comments Required

ES_ACT_TYPE_MAP.ESACTTYPE_COMMENTS_REQUIRED

Shift Detail Activity > Activity Type Reason Required

ES_ACT_TYPE_MAP.ESACTTYPE_REASON_REQUIRED

Shift Detail Activity > Contributes to Cost

if (SO_ACTIVITY.ACT_CONT_TO_COST=1) then ('Y') else ('N')

Shift Detail Activity > Is Paid

if ( SO_ACTIVITY.ACT_PAID is null or SO_ACTIVITY.ACT_PAID = 0 ) then ( 'N' ) else ( 'Y' )

Shift Detail Activity > 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' )

Shift Detail Activity > Keys > ACT_ID

SO_ACTIVITY.ACT_ID

Shift Detail Activity > Keys > SKDGRP_ID

SO_ACTIVITY.SKDGRP_ID

Shift Detail Activity > Keys > TCODE_ID

SO_ACTIVITY.TCODE_ID

Shift Detail Department

WFMStandard

Scheduling MVS > Scheduled Shifts

Shift Detail Department > Department Name

DEPARTMENT.DEPT_NAME

Shift Detail Department > Department Description

DEPARTMENT.DEPT_DESC

Shift Detail Department > Department Start Date

DEPARTMENT.DEPT_START_DATE

Shift Detail Department > Department End Date

DEPARTMENT.DEPT_END_DATE

Shift Detail Department > UDFs > DEPT_FLAG?

DEPARTMENT.DEPT_FLAG?

Shift Detail Department > UDFs > DEPT_REFKEY?

DEPARTMENT.DEPT_REFKEY?

Shift Detail Department > UDFs > DEPT_VAL?

DEPARTMENT.DEPT_VAL?

Shift Detail Department > Keys > DEPT_ID

DEPARTMENT.DEPT_ID

Department > Foreign Keys > WBT_ID

DEPARTMENT.WBT_ID

Shift Detail Docket

WFMStandard

Scheduling MVS > Scheduled Shifts

Shift Detail Docket > Docket Name

DOCKET.DOCK_NAME

Shift Detail Docket > Docket Description

DOCKET.DOCK_DESC

Shift Detail Docket > Start Date

DOCKET.DOCK_QTY

Shift Detail Docket > End Date

DOCKET.DOCK_STANDARD_QTY

Shift Detail Docket > Quantity

DOCKET.DOCK_STANDARD_DUR

Shift Detail Docket > Standard Duration

DOCKET.DOCK_PIECE_RATE

Shift Detail Docket > Standard Quantity

DOCKET.DOCK_START_DATE

Shift Detail Docket > Piece Rate

DOCKET.DOCK_END_DATE

Shift Detail Docket > UDFs > DOCK_FLAG?

DOCKET.DOCK_FLAG?

Shift Detail Docket > UDFs > DOCK_REFKEY?

DOCKET.DOCK_REFKEY?

Shift Detail Docket > UDFs > DOCK_UDF?

DOCKET.DOCK_UDF?

Shift Detail Docket > Keys > DOCK_ID

DOCKET.DOCK_ID

Docket > Foreign Keys > ACTVSET_ID

DOCKET.ACTVSET_ID

Shift Detail Employee

WFMStandard

Scheduling MVS > Scheduled Shifts

Shift Detail Employee > Employee ID

EMPLOYEE.EMP_NAME

Shift Detail Employee > Full Name

EMPLOYEE.EMP_FULLNAME

Shift Detail Employee > First Name

EMPLOYEE.EMP_FIRSTNAME

Shift Detail Employee > Last Name

EMPLOYEE.EMP_LASTNAME

Shift Detail Employee > Is Full Time

EMPLOYEE.EMP_FULLTIME

Shift Detail Employee > Status

EMPLOYEE.EMP_STATUS

Shift Detail Employee > Is Home Team

SEC_EMPLOYEE.EMPT_HOME_TEAM

Shift Detail Employee > Base Rate

EMPLOYEE.EMP_BASE_RATE

Shift Detail Employee > Hire Rate

EMPLOYEE.EMP_HIRE_DATE

Shift Detail Employee > Effective Date

EMPLOYEE.EMP_EFFECTIVE_DATE

Shift Detail Employee > Termination Date

EMPLOYEE.EMP_TERMINIATION_DATE

Shift Detail Employee > Seniority Date

EMPLOYEE.EMP_SENIORITY_DATE

Shift Detail Employee > Birth Date

EMPLOYEE.EMP_BIRTH_DATE

Shift Detail Employee > SIN

EMPLOYEE.EMP_SIN

Shift Detail Employee > Shift Pattern Offset

EMPLOYEE.EMP_SHFTPAT_OFFSET

Shift Detail Employee > Default Minutes

EMPLOYEE.EMP_DEF_MINUTES

Shift Detail Employee > Full Time Equivalent

EMPLOYEE.EMP_FTE

Shift Detail Employee > Keys > EMP_ID

EMPLOYEE.EMP_ID

Shift Detail Employee > Keys > WBT_ID

SEC_EMPLOYEE.WBT_ID

Shift Detail Employee > Keys > TEAM_START_DATE

SEC_EMPLOYEE.START_DATE

Shift Detail Employee > Keys > TEAM_END_DATE

SEC_EMPLOYEE.END_DATE

Shift Detail Employee > UDFs > EMP_FLAG?

EMPLOYEE.EMP_FLAG?

Shift Detail Employee > UDFs > EMP_VAL?

EMPLOYEE.EMP_VAL?

Shift Detail Employee > Work Type > Work Type Name

EMPLOYEE_WORK_TYPE.EMPWRKTYP_NAME

Shift Detail Employee > Work Type > Work Type Description

EMPLOYEE_WORK_TYPE.EMPWRKTYP_DESC

Shift Detail Employee > Work Type > Work Type Full Time

EMPLOYEE_WORK_TYPE.EMPWRKTYP_FULLTIME

Shift Detail Employee > Work Type > Work Type Sort Order

EMPLOYEE_WORK_TYPE.EMPWRKTYP_SORTORDER

Shift Detail Employee > Work Type > Work Type UDFs > EMPWRKTYP_FLAG?

EMPLOYEE_WORK_TYPE.EMPWRKTYP_FLAG?

Shift Detail Employee > Work Type > Work Type UDFs > EMPWRKTYP_UDF?

EMPLOYEE_WORK_TYPE.EMPWRKTYP_UDF?

Shift Detail Employee > Employment Type > Employment Type Name

EMPLOYMENT_TYPE.EMPTYP_NAME

Shift Detail Employee > Employment Type > Employment Type Description

EMPLOYMENT_TYPE.EMPTYP_DESC

Shift Detail Employee > Employment Type > Employment Type Sort Order

EMPLOYMENT_TYPE.EMPTYP_SORTORDER

Shift Detail Employee > Employment Type > Employment Type UDFs > EMPTYPE_FLAG?

EMPLOYMENT_TYPE.EMPTYP_FLAG?

Shift Detail Employee > Employment Type > Employment Type UDFs > EMPTYPE_UDF?

EMPLOYMENT_TYPE.EMPTYP_UDF?

Shift Detail Employee Team

WFMStandard

Scheduling MVS > Scheduled Shifts

Shift Detail Employee Team > Team Name

WORKBRAIN_TEAM.WBT_NAME

Shift Detail Employee Team > Team Description

WORKBRAIN_TEAM.WBT_DESC

WORKBRAIN_TEAM.WBT_NAME

Shift Detail Employee Team > Team Level

WORKBRAIN_TEAM.WBT_LEVEL

WORKBRAIN_TEAM.WBT_DESC

Shift Detail Emplpyee Team > Keys > WBT_ID

WORKBRAIN_TEAM.WBT_ID

WORKBRAIN_TEAM.WBT_LEVEL

Shift Detail Emplpyee Team > Keys > WBT_PARENT_ID

WORKBRAIN_TEAM.WBT_PARENT_ID

WORKBRAIN_TEAM.WBT_ID

Shift Detail Emplpyee Team > Keys > WBT_START_DATE

SEC_WORKBRAIN_TEAM.WBUT_START_DATE

WORKBRAIN_TEAM.WBT_PARENT_ID

Shift Detail Emplpyee Team > Keys > WBT_END_DATE

SEC_WORKBRAIN_TEAM.WBUT_END_DATE

SEC_WORKBRAIN_TEAM.WBUT_START_DATE

Team > Foreign Keys > CURRENT_TIMESTAMP

CURRENT_TIMESTAMP

SEC_WORKBRAIN_TEAM.WBUT_END_DATE

Shift Detail Employee Team > UDFs > WBT_FLAG?

WORKBRAIN_TEAM.WBT_FLAG?

CURRENT_TIMESTAMP

Shift Detail Emplpyee Team > UDFs > WBT_UDF?

WORKBRAIN_TEAM.WBT_UDF?

WORKBRAIN_TEAM.WBT_FLAG?

Shift Detail Hour Type

WFMStandard

WORKBRAIN_TEAM.WBT_UDF?

Shift Detail Hour Type > Hour Type

HOUR_TYPE.HTYPE_LOC_NAME

Shift Detail Hour Type > Hour Type Description

HOUR_TYPE.HTYPE_LOC_DESC

Shift Detail Hour Type > Hour Type YAG

HOUR_TYPE.HTYPE_YAG

Shift Detail Hour Type > Hour Type Multiple

HOUR_TYPE.HTYPE_MULITPLE

Shift Detail Hour Type > Is Overtime

HOUR_TYPE.HTYPE_RPT_ISOT

Shift Detail Hour Type > Hour Type UDFs > HTYPE_FLAG?

HOUR_TYPE.HTYPE_FLAG?

Shift Detail Hour Type > Hour Type UDFs > HTYPE_UDF?

HOUR_TYPE.HTYPE_UDF?

Shift Detail Hour Type > Keys > HTYPE_ID

HOUR_TYPE.HTYPE_ID

Shift Detail Hour Type > Keys > Htype Name

HOUR_TYPE.HTYPE_NAME

Shift Detail Job

WFMStandard

Scheduling MVS > Scheduled Shifts

Shift Detail Job > Job Name

JOB.JOB_NAME

Shift Detail Job > Job Description

JOB.JOB_DESC

Shift DetailJ ob > Tipped

JOB.JOB_TIP

Shift Detail Job > Healthcare Type

JOB.JOB_RPT_HCTYPE

Shift Detail Job > Job UDFs > JOB_FLAG?

JOB.JOB_FLAG?

Shift Detail Job > Job UDFs > JOB_REFKEY?

JOB.JOB_REFKEY?

Shift Detail Job > Job UDFs > JOB_VAL?

JOB.JOB_VAL?

Shift Detail Job > Keys > JOB_ID

JOB.JOB_ID

Shift Detail Project

WFMStandard

Scheduling MVS > Scheduled Shifts

Shift Detail Project > Project Name

PROJECT.PROJ_NAME

Shift Detail Project > Project Description

PROJECT.PROJ_DESC

Shift Detail Project > Keys > PROJ_ID

PROJECT.PROJ_ID

Shift Link

WFMStandard

Scheduling MVS > Scheduled Shifts > Shift Link

Shift Link > Shift Link Comment

ES_SHIFT_LINK.SHIFTLINK_COMMENT

Shift Link > Shift Link Name

ES_LINK_TYPE.LINKTYPE_NAME

Shift Link > Keys > SHIFTLINK_ID

ES_SHIFT_LINK.SHIFTLINK_ID

Shift Label Color

WFMStandard

Scheduling MVS > Shift Definition

Shift Label Color > Color Name

COLOUR.COLR_NAME

Shift Label Color > Color Description

COLOUR.COLR_DESC

Shift Label Color > Color Value

COLOUR.COLR_VALUE

Shift Label Color > Keys > COLR_ID

COLOUR.COLR_ID

Shift Preference Detail

WFMStandard

Scheduling MVS > Shift Preferences > Shift Preference

Shift Preference Detail > Shift Preference Date

ES_SHIFTPREF_DETAIL.SPD_DATE

Shift Preference Detail > Keys > SPD_ID

ES_SHIFTPREF_DETAIL.SPD_ID

Shift Preference Detail > Foreign Keys > DAY_ID

ES_SHIFTPREF_DETAIL.DAY_ID

Shift Preference Detail > Foreign Keys > DP_ID

ES_SHIFTPREF_DETAIL.DP_ID

Shift Preference Detail > Foreign Keys > SHFTTYP_ID

ES_SHIFTPREF_DETAIL.SHFTTYP_ID

Shift Preference Detail > Foreign Keys > SHIFTPREFTYP_ID

ES_SHIFTPREF_DETAIL.SHIFTPREFTYP_ID

Shift Preference Detail > Foreign Keys > SPS_ID

ES_SHIFTPREF_DETAIL.SPS_ID

Shift Preference Detail > UDFs > SPD_FLAG?

ES_SHIFTPREF_DETAIL.SPD_FLAG?

Shift Preference Detail > UDFs > SPD_UDF?

ES_SHIFTPREF_DETAIL.SPD_UDF?

Shift Preference Detail (History)

WFMStandard

Scheduling MVS > Shift Preferences > Shift Preference History

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

WFMStandard

Scheduling MVS > Shift Preferences > Shift Preference

Shift Preference Input Type > Shift Preference Input Type Name

ES_SHIFTPREF_TYPE.SPTYP_NAME

Scheduling MVS > Shift Preferences > Shift Preference History

Shift Preference Input Type > Shift Preference Input Type Description

ES_SHIFTPREF_TYPE.SPTYP_DESC

Shift Preference Input Type > Keys > SPTYP_ID

ES_SHIFTPREF_TYPE.SPTYP_ID

Shift Preference Input Type > UDFs > SPTYP_FLAG?

ES_SHIFTPREF_TYPE.SPTYP_FLAG?

Shift Preference Input Type > UDFs > SPTYP_UDF?

ES_SHIFTPREF_TYPE.SPTYP_UDF?

Shift Preference Summary

WFMStandard

Scheduling MVS > Shift Preferences > Shift Preference

Shift Preference Summary > Shift Preference Comment

ES_SHIFTPREF_SUMMARY.SPS_COMMENT

Shift Preference Summary > Shift Preference Start Date

ES_SHIFTPREF_SUMMARY.SPS_START_DATE

Shift Preference Summary > Shift Preference End Date

ES_SHIFTPREF_SUMMARY.SPS_END_DATE

Shift Preference Summary > Shift Preference Created Date

ES_SHIFTPREF_SUMMARY.SPS_CREATED_DATE

Shift Preference Summary > Shift Preference Active Date

ES_SHIFTPREF_SUMMARY.SPS_ACTIVE_DATE

Shift Preference Summary > Is Shift Preference Active

ES_SHIFTPREF_SUMMARY.SPS_ACTIVE

Shift Preference Summary > Is Shift Preference Submitted Late

ES_SHIFTPREF_SUMMARY.SPS_SUBMITTED_LATE

Shift Preference Summary > Keys > SPS_ID

ES_SHIFTPREF_SUMMARY.SPS_ID

Shift Preference Summary > Foreign Keys > EMP_ID

ES_SHIFTPREF_SUMMARY.EMP_ID

Shift Preference Summary > Foreign Keys > SPS_PARENT_ID

ES_SHIFTPREF_SUMMARY.SPS_PARENT_ID

Shift Preference Summary > Foreign Keys > SPTYP_ID

ES_SHIFTPREF_SUMMARY.SPTYP_ID

Shift Preference Summary > Foreign Keys > WBT_ID

ES_SHIFTPREF_SUMMARY.WBT_ID

Shift Preference Summary > Foreign Keys > WBU_ID_ACTUAL_APPROVER

ES_SHIFTPREF_SUMMARY.WBU_ID_ACTUAL_APPROVER

Shift Preference Summary > Foreign Keys > WBU_ID_ACTUAL_SUBMITTER

ES_SHIFTPREF_SUMMARY.WBU_ID_ACTUAL_SUBMITTER

Shift Preference Summary > Foreign Keys > WBU_ID_APPROVER

ES_SHIFTPREF_SUMMARY.WBU_ID_APPROVER

Shift Preference Summary > Foreign Keys > WBU_ID_SUBMITTER

ES_SHIFTPREF_SUMMARY.WBU_ID_SUBMITTER

Shift Preference Summary > UDFs > SPS_FLAG?

ES_SHIFTPREF_SUMMARY.SPS_FLAG?

Shift Preference Summary > UDFs > SPS_UDF?

ES_SHIFTPREF_SUMMARY.SPS_UDF?

Shift Preference Type

WFMStandard

Scheduling MVS > Shift Preferences > Shift Preference

Shift Preference Type > Shift Preference Type Name

ES_SHIFTPREF_PREF_TYPE.SHIFTPREFTYP_NAME

Scheduling MVS > Shift Preferences > Shift Preference History

Shift Preference Type > Shift Preference Type Description

ES_SHIFTPREF_PREF_TYPE.SHIFTPREFTYP_DESC

Shift Preference Type > Shift Preference Type Short Code

ES_SHIFTPREF_PREF_TYPE.SHIFTPREFTYP_SHORT_CODE

Shift Preference Type > Keys > SHIFTPREFTYP_ID

ES_SHIFTPREF_PREF_TYPE.SHIFTPREFTYP_ID

Shift Preference Summary (History)

WFMStandard

Scheduling MVS > Shift Preferences > Shift Preference History

Shift Preference Summary > Shift Preference Comment

ES_SHIFTPREF_SUMMARY.SPS_COMMENT

Shift Preference Summary > Shift Preference Start Date

ES_SHIFTPREF_SUMMARY.SPS_START_DATE

Shift Preference Summary > Shift Preference End Date

ES_SHIFTPREF_SUMMARY.SPS_END_DATE

Shift Preference Summary > Shift Preference Created Date

ES_SHIFTPREF_SUMMARY.SPS_CREATED_DATE

Shift Preference Summary > Shift Preference Active Date

ES_SHIFTPREF_SUMMARY.SPS_ACTIVE_DATE

Shift Preference Summary > Is Shift Preference Active

ES_SHIFTPREF_SUMMARY.SPS_ACTIVE

Shift Preference Summary > Is Shift Preference Submitted Late

ES_SHIFTPREF_SUMMARY.SPS_SUBMITTED_LATE

Shift Preference Summary > Keys > SPS_ID

ES_SHIFTPREF_SUMMARY.SPS_ID

Shift Preference Summary > Foreign Keys > EMP_ID

ES_SHIFTPREF_SUMMARY.EMP_ID

Shift Preference Summary > Foreign Keys > SPS_PARENT_ID

ES_SHIFTPREF_SUMMARY.SPS_PARENT_ID

Shift Preference Summary > Foreign Keys > SPTYP_ID

ES_SHIFTPREF_SUMMARY.SPTYP_ID

Shift Preference Summary > Foreign Keys > WBT_ID

ES_SHIFTPREF_SUMMARY.WBT_ID

Shift Preference Summary > Foreign Keys > WBU_ID_ACTUAL_APPROVER

ES_SHIFTPREF_SUMMARY.WBU_ID_ACTUAL_APPROVER

Shift Preference Summary > Foreign Keys > WBU_ID_ACTUAL_SUBMITTER

ES_SHIFTPREF_SUMMARY.WBU_ID_ACTUAL_SUBMITTER

Shift Preference Summary > Foreign Keys > WBU_ID_APPROVER

ES_SHIFTPREF_SUMMARY.WBU_ID_APPROVER

Shift Preference Summary > Foreign Keys > WBU_ID_SUBMITTER

ES_SHIFTPREF_SUMMARY.WBU_ID_SUBMITTER

Shift Preference Summary > UDFs > SPS_FLAG?

ES_SHIFTPREF_SUMMARY.SPS_FLAG?

Shift Preference Summary > UDFs > SPS_UDF?

ES_SHIFTPREF_SUMMARY.SPS_UDF?

Shift Property

WFMStandard

Scheduling MVS > Shift Definition

Shift Property > Shift Property Name

ES_SHIFT_PROP_DEF.ESSHIFTPROP_NAME

Shift Property > Shift Property Description

ES_SHIFT_PROP_DEF.ESSHIFTPROP_DESC

Shift Property > Shift Property Value

ES_SHIFT_PROP_DATA.ESSHIFTPROPD_VALUE

Shift Property > Keys > ESSHIFTPROP_ID

ES_SHIFT_PROP_DATA.ESSHIFTPROP_ID

Shift Property > Foreign Keys > ESSSHIFTATTR_ID

ES_SHIFT_PROP_DATA.ESSHIFTATTR_ID

Shift Property > Foreign Keys > PARMTYP_ID

ES_SHIFT_PROP_DEF.PARMTYP_ID

Shift Property > UDFs > ESSHIFTPROP_FLAG?

ES_SHIFT_PROP_DEF.ESSHIFTPROP_FLAG?

Shift Property > UDFs > ESSHIFTPROP_UDF?

ES_SHIFT_PROP_DEF.ESSHIFTPROP_UDF?

Shift Offer

WFMStandard

Scheduling MVS > Scheduled Shifts > Shift Offers

Shift Offer > Is Auto Approve Compliance Warning

ES_SHIFT_OFFER.ESSO_AUTOAPR_CMPLWRN

Shift Offer > Shift Offer Date Time

ES_SHIFT_OFFER.ESSO_DATETIME

Shift Offer > Shift Offer Duration

ES_SHIFT_OFFER.ESSO_DURATION

Shift Offer > Keys > ESSO_ID

ES_SHIFT_OFFER.ESSO_ID

Shift Offer > Foreign Keys > WBU_ID

ES_SHIFT_OFFER.WBU_ID

Shift Offer > Foreign Keys > WBU_ID_ACTUAL

ES_SHIFT_OFFER.WBU_ID_ACTUAL

Shift Offer > UDFs > ESSO_FLAG?

ES_SHIFT_OFFER.ESSO_FLAG?

Shift Offer > UDFs > ESSO_UDF?

ES_SHIFT_OFFER.ESSO_UDF?

Shift Offer Shift Summary

WFMStandard

Scheduling MVS > Scheduled Shifts > Shift Offers

Shift Offer Shift Summary > Shift Offer Shift Summary Ext Code

ES_SHIFT_OFFER_SHIFTSUM.ESOSHFTSUM_EXT_CODE

Shift Offer Shift Summary > Is Shift Offer Shift Summary Cancelled

ES_SHIFT_OFFER_SHIFTSUM.ESOSHFTSUM_CANCELLED

Shift Offer Shift Summary > Shift Offer Shift Summary Cancelled Date Time

ES_SHIFT_OFFER_SHIFTSUM.ESOSHFTSUM_CANCELLED_DATETIME

Shift Offer Shift Summary > Keys > ESOSHFTSUM_ID

ES_SHIFT_OFFER_SHIFTSUM.ESOSHFTSUM_ID

Shift Offer Shift Summary > Foreign Keys > ESSO_ID

ES_SHIFT_OFFER_SHIFTSUM.ESSO_ID

Shift Offer Shift Summary > Foreign Keys > SHIFTSUM_ID

ES_SHIFT_OFFER_SHIFTSUM.SHIFTSUM_ID

Shift Offer Shift Summary > Foreign Keys > WBU_ID

ES_SHIFT_OFFER_SHIFTSUM.WBU_ID

Shift Offer Shift Summary > Foreign Keys > WBU_ID_ACTUAL

ES_SHIFT_OFFER_SHIFTSUM.WBU_ID_ACTUAL

Shift Offer Shift Summary > UDFs > ESOSHFTSUM_FLAG?

ES_SHIFT_OFFER_SHIFTSUM.ESOSHFTSUM_FLAG?

Shift Offer Shift Summary > UDFs > ESOSHFTSUM_UDF?

ES_SHIFT_OFFER_SHIFTSUM.ESOSHFTSUM_UDF?

Shift Offer Employee Shift

WFMStandard

Scheduling MVS > Scheduled Shifts > Shift Offers

Shift Offer Employee Shift > Shift Offer Employee Shift Rank

ES_SHIFT_OFFER_EMP_SHIFT.ESOESHFT_EMP_RANK

Shift Offer Employee Shift > Keys > ESOESHFT_ID

ES_SHIFT_OFFER_EMP_SHIFT.ESOESHFT_ID

Shift Offer Employee Shift > Foreign Keys > ESOSHFTSUM_ID

ES_SHIFT_OFFER_EMP_SHIFT.ESOSHFTSUM_ID

Shift Offer Employee Shift > Foreign Keys > EMP_ID

ES_SHIFT_OFFER_EMP_SHIFT.EMP_ID

Shift Offer Employee Shift > Foreign Keys > SSOFRSTAT_ID

ES_SHIFT_OFFER_EMP_SHIFT.SSOFRSTAT_ID

Shift Offer Employee Shift > Foreign Keys > SSOFRREJRSN_ID

ES_SHIFT_OFFER_EMP_SHIFT.SSOFRREJRSN_ID

Shift Offer Employee Shift > Foreign Keys > SSOFRCHNL_ID

ES_SHIFT_OFFER_EMP_SHIFT.SSOFRCHNL_ID

Shift Offer Employee Shift > UDFs > ESOESHFT_FLAG?

ES_SHIFT_OFFER_EMP_SHIFT.ESOESHFT_FLAG?

Shift Offer Employee Shift > UDFs > ESOESHFT_UDF?

ES_SHIFT_OFFER_EMP_SHIFT.ESOESHFT_UDF?

Shift Status

WFMStandard

Scheduling MVS > Scheduled Shifts

Shift Status > Shift Status Name

ES_SHIFT_STATUS.SHIFTSTAT_LOC_NAME

Shift Status > Shift Status Description

ES_SHIFT_STATUS.SHIFTSTAT_LOC_DESC

Shift Status > Shift Status Enabled

ES_SHIFT_STATUS.SHIFTSTAT_ENABLE

Shift Status > Keys > SHIFTSTAT_ID

ES_SHIFT_STATUS.SHIFTSTAT_ID

Shift Status > Foreign Keys > COLR_ID

ES_SHIFT_STATUS.COLR_ID

Shift Status > SHIFTSTAT_FLAG?

ES_SHIFT_STATUS.SHIFTSTAT_FLAG?

Shift Status > SHIFTSTAT_UDF?

ES_SHIFT_STATUS.SHIFTSTAT_UDF?

Shift Status Color

WFMStandard

Scheduling MVS > Scheduled Shifts

Shift Status Color > Color Name

COLOUR.COLR_NAME

Shift Status Color > Color Description

COLOUR.COLR_DESC

Shift Status Color > Color Value

COLOUR.COLR_VALUE

Shift Status Color > Keys > COLR_ID

COLOUR.COLR_ID

Shift Summary

WFMStandard

Scheduling MVS > Scheduled Shifts > Shift Summary

Shift Summary > Shift Summary Create Date

ES_SHIFT_SUMMARY.SHIFTSUM_CREATE_DATE

Shift Summary > Shift Summary Is Adhoc

ES_SHIFT_SUMMARY.SHIFTSUM_IS_ADHOC

Shift Summary > Shift Summary Is Modified

ES_SHIFT_SUMMARY.SHIFTSUM_IS_MODIFIED

Shift Summary > Shift Summary Status

ES_SHIFT_SUMMARY.SHIFTSUM_STATUS

Shift Summary > Shift Summary Row Number

ES_SHIFT_SUMMARY.SHIFTSUM_ROWLM_ROWNAME

Shift Summary > Shift Summary Work Date

ES_SHIFT_SUMMARY.SHIFTSUM_WORK_DATE

Shift Summary > Keys > SHIFTSUM_ID

ES_SHIFT_SUMMARY.SHIFTSUM_ID

Shift Summary > Foreign Keys > EMP_ID

ES_SHIFT_SUMMARY.EMP_ID

Shift Summary > Foreign Keys > ESSHIFT_ID

ES_SHIFT_SUMMARY.ESSHIFT_ID

Shift Summary > Foreign Keys > RELBLK_ID

ES_SHIFT_SUMMARY.RELBLK_ID

Shift Summary > Foreign Keys > RELTYPE_ID

ES_SHIFT_SUMMARY.RELTYPE_ID

Shift Summary > Foreign Keys > ROT_ID

ES_SHIFT_SUMMARY.ROT_ID

Shift Summary > Foreign Keys > ROTROW_ID

ES_SHIFT_SUMMARY.ROTROW_ID

Shift Summary > Foreign Keys > ROWSHIFT_ID

ES_SHIFT_SUMMARY.ROWSHIFT_ID

Shift Summary > Foreign Keys > SHIFTLINK_ID

ES_SHIFT_SUMMARY.SHIFTLINK_ID

Shift Summary > Foreign Keys > SHIFTSUM_PARENT_ID

ES_SHIFT_SUMMARY.SHIFTSUM_PARENT_ID

Shift Summary > Foreign Keys > SHIFTSUM_SWAP_ID

ES_SHIFT_SUMMARY.SHIFTSUM_SWAP_ID

Shift Summary > Foreign Keys > TMPL_ID

ES_SHIFT_SUMMARY.TMPL_ID

Shift Summary > Foreign Keys > TMPLSCHD_ID

ES_SHIFT_SUMMARY.TMPLSCHD_ID

Shift Summary > Foreign Keys > WBT_ID

ES_SHIFT_SUMMARY.WBT_ID

Shift Summary > SHIFTSUM_FLAG?

ES_SHIFT_SUMMARY.SHIFTSUM_FLAG?

Shift Summary > SHIFTSUM_UDF?

ES_SHIFT_SUMMARY.SHIFTSUM_UDF?

Shift Summary Employee

WFMStandard

Scheduling MVS > Scheduled Shifts

Shift Summary Employee > Employee ID

EMPLOYEE.EMP_NAME

Shift Summary Employee > Full Name

EMPLOYEE.EMP_FULLNAME

Shift Summary Employee > First Name

EMPLOYEE.EMP_FIRSTNAME

Shift Summary Employee > Last Name

EMPLOYEE.EMP_LASTNAME

Shift Summary Employee > Is Full Time

EMPLOYEE.EMP_FULLTIME

Shift Summary Employee > Status

EMPLOYEE.EMP_STATUS

Shift Summary Employee > Is Home Team

SEC_EMPLOYEE.EMPT_HOME_TEAM

Shift Summary Employee > Base Rate

EMPLOYEE.EMP_BASE_RATE

Shift Summary Employee > Hire Rate

EMPLOYEE.EMP_HIRE_DATE

Shift Summary Employee > Effective Date

EMPLOYEE.EMP_EFFECTIVE_DATE

Shift Summary Employee > Termination Date

EMPLOYEE.EMP_TERMINIATION_DATE

Shift Summary Employee > Seniority Date

EMPLOYEE.EMP_SENIORITY_DATE

Shift Summary Employee > Birth Date

EMPLOYEE.EMP_BIRTH_DATE

Shift Summary Employee > SIN

EMPLOYEE.EMP_SIN

Shift Summary Employee > Shift Pattern Offset

EMPLOYEE.EMP_SHFTPAT_OFFSET

Shift Summary Employee > Default Minutes

EMPLOYEE.EMP_DEF_MINUTES

Shift Summary Employee > Full Time Equivalent

EMPLOYEE.EMP_FTE

Shift Summary Employee > Keys > EMP_ID

EMPLOYEE.EMP_ID

Shift Summary Employee > Keys > WBT_ID

SEC_EMPLOYEE.WBT_ID

Shift Summary Employee > Keys > TEAM_START_DATE

SEC_EMPLOYEE.START_DATE

Shift Summary Employee > Keys > TEAM_END_DATE

SEC_EMPLOYEE.END_DATE

Shift Summary Employee > Work Type > Work Type Name

EMPLOYEE_WORK_TYPE.EMPWRKTYP_NAME

Shift Summary Employee > Work Type > Work Type Description

EMPLOYEE_WORK_TYPE.EMPWRKTYP_DESC

Shift Summary Employee > Work Type > Work Type Full Time

EMPLOYEE_WORK_TYPE.EMPWRKTYP_FULLTIME

Shift Summary Employee > Work Type > Work Type Sort Order

EMPLOYEE_WORK_TYPE.EMPWRKTYP_SORTORDER

Shift Summary Employee > Work Type > Work Type UDFs > EMPWRKTYP_FLAG?

EMPLOYEE_WORK_TYPE.EMPWRKTYP_FLAG?

Shift Summary Employee > Work Type > Work Type UDFs > EMPWRKTYP_UDF?

EMPLOYEE_WORK_TYPE.EMPWRKTYP_UDF?

Shift Summary Employee > Employment Type > Employment Type Name

EMPLOYMENT_TYPE.EMPTYP_NAME

Shift Summary Employee > Employment Type > Employment Type Description

EMPLOYMENT_TYPE.EMPTYP_DESC

Shift Summary Employee > Employment Type > Employment Type Sort Order

EMPLOYMENT_TYPE.EMPTYP_SORTORDER

Shift Summary Employee > Employment Type > Employment Type UDFs > EMPTYPE_FLAG?

EMPLOYMENT_TYPE.EMPTYP_FLAG?

Shift Summary Employee > Employment Type > Employment Type UDFs > EMPTYPE_UDF?

EMPLOYMENT_TYPE.EMPTYP_UDF?

Shift Summary Employee > UDFs > EMP_FLAG?

EMPLOYEE.EMP_FLAG?

Shift Summary Employee > UDFs > EMP_VAL?

EMPLOYEE.EMP_VAL?

Shift Summary Employee Team

WFMStandard

Scheduling MVS > Scheduled Shifts

Shift Summary Employee Team > Team Name

WORKBRAIN_TEAM.WBT_NAME

Shift Summary Employee Team > Team Description

WORKBRAIN_TEAM.WBT_DESC

Shift Summary Employee Team > Team Level

WORKBRAIN_TEAM.WBT_LEVEL

Shift Summary Employee Team > Keys > WBT_ID

WORKBRAIN_TEAM.WBT_ID

Shift Summary Employee Team > Keys > WBT_PARENT_ID

WORKBRAIN_TEAM.WBT_PARENT_ID

Shift Summary Employee Team > Keys > WBT_START_DATE

SEC_WORKBRAIN_TEAM.WBUT_START_DATE

Shift Summary Employee Team > Keys > WBT_END_DATE

SEC_WORKBRAIN_TEAM.WBUT_END_DATE

Shift Summary Employee Team > Foreign Keys > Current_Timestamp

CURRENT_TIMESTAMP

Shift Summary Employee Team > UDFs > WBT_FLAG?

WORKBRAIN_TEAM.WBT_FLAG?

Shift Summary Employee Team > UDFs > WBT_UDF?

WORKBRAIN_TEAM.WBT_UDF?

Shift Summary Shift Link

WFMStandard

Scheduling MVS > Scheduled Shifts > Shift Summary Shift Link

Shift Summary Shift Link > SHIFT_LINK_COMMENT

ES_SHIFT_LINK.SHIFTLINK_COMMENT

Shift Summary Shift Link > LINKTYPE_NAME

ES_LINK_TYPE.LINKTYPE_NAME

Shift Summary Shift Link > Keys > SHIFTLINK_ID

ES_SHIFT_LINK.SHIFTLINK_ID

Scheduled Detail

WFMStandard

Scheduling MVS > Scheduled Shifts > Scheduled Detail > Employee Scheduled Detail

Scheduled Detail > Employee Scheduled Detail > Date

EMPLOYEE_SCHED_DTL.ESCHD_WORK_DATE

Scheduled Detail > Employee Scheduled Detail > Shift Start Time

EMPLOYEE_SCHED_DTL.ESCHD_START_TIME

Scheduled Detail > Employee Scheduled Detail > Shift End Time

EMPLOYEE_SCHED_DTL.ESCHD_END_TIME

Scheduled Detail > Employee Scheduled Detail > Scheduled Hours

EMPLOYEE_SCHED_DTL.ESCHD_MINUTES / 60.0

Scheduled Detail > Employee Scheduled Detail > Scheduled Minutes

EMPLOYEE_SCHED_DTL.ESCHD_MINUTES

Scheduled Detail > Employee Scheduled Detail > Scheduled Type

EMPLOYEE_SCHED_DTL.ESCHD_TYPE

Scheduled Detail > Employee Scheduled Detail > Rate

EMPLOYEE_SCHED_DTL.ESCHD_RATE

Scheduled Detail > Employee Scheduled Detail > Quantity

EMPLOYEE_SCHED_DTL.ESCHD_QUANTITY

Scheduled Detail > Employee Scheduled Detail > Status

EMPLOYEE_SCHED_DTL.ESCHD_STATUS

Scheduled Detail > Employee Scheduled Detail > Keys > EMP_ID

EMPLOYEE_SCHED_DTL.EMP_ID

Scheduled Detail > Employee Scheduled Detail > Foreign Keys > ACT_ID

EMPLOYEE_SCHED_DTL.ACT_ID

Scheduled Detail > Employee Scheduled Detail > Foreign Keys > DEPT_ID

EMPLOYEE_SCHED_DTL.DEPT_ID

Scheduled Detail > Employee Scheduled Detail > Foreign Keys > DOCK_ID

EMPLOYEE_SCHED_DTL.DOCK_ID

Scheduled Detail > Employee Scheduled Detail > Foreign Keys > HTYPE_ID

EMPLOYEE_SCHED_DTL.OCK_ID

Scheduled Detail > Employee Scheduled Detail > Foreign Keys > JA_ID

EMPLOYEE_SCHED_DTL.JA_ID

Scheduled Detail > Employee Scheduled Detail > Foreign Keys > JOB_ID

EMPLOYEE_SCHED_DTL.JA_ID

Scheduled Detail > Employee Scheduled Detail > Foreign Keys > MODULE_REF

EMPLOYEE_SCHED_DTL.MODULE_REF

Scheduled Detail > Employee Scheduled Detail > Foreign Keys > PROJ_ID

EMPLOYEE_SCHED_DTL.PROJ_ID

Scheduled Detail > Employee Scheduled Detail > Foreign Keys > STKSL_ID

EMPLOYEE_SCHED_DTL.STKSL_ID

Scheduled Detail > Employee Scheduled Detail > Foreign Keys > TCODE_ID

EMPLOYEE_SCHED_DTL.STKSL_ID

Scheduled Detail > Employee Scheduled Detail > Foreign Keys > WBT_ID

EMPLOYEE_SCHED_DTL.WBT_ID

Shift Summary Shift Skills

WFMStandard

Scheduling MVS > Scheduled Shifts

Shift Summary Shift Skills > Skill Name

ST_SKILL.STSKL_NAME

Shift Summary Shift Skills > Skill Description

ST_SKILL.STSKL_DESC

Shift Summary Shift Skills > Is Schedule Related

ST_SKILL.STSKL_SCHED_RELATED

Shift Summary Shift Skills > UDFs > STSKL_FLAG?

ST_SKILL.STSKL_FLAG?

Shift Summary Shift SKills > UDFs > STSKL_UDF?

ST_SKILL.STSKL_UDF?

Shift Summary Shift Skills > Keys > STSKL_ID

ST_SKILL.STSKL_ID

Shift Summary Shift Skills > Foreign Keys > STSKLTYP_ID

ST_SKILL.STSKLTYP_ID

Shift Summary Skill

WFMStandard

Scheduling MVS > Scheduled Shifts

Shift Summary Skill > Is Skill Required

ES_SHIFT_SUMMARY_SKILL.SHIFTSUMSKL_REQ

Shift Summary Skill > Shift Summary Skill Level

ES_SHIFT_SUMMARY_SKILL.SHIFTSUMSKL_LEVEL

Shift Summary Skill > UDFs > SHIFTSUMSKL_FLAG?

ES_SHIFT_SUMMARY_SKILL.SHIFTSUMSKL_FLAG?

Shift Summary Skill > UDFs > SHIFTSUMSKL_UDF?

ES_SHIFT_SUMMARY_SKILL.SHIFTSUMSKL_UDF?

Shift Summary Skill > Keys > SHIFTSUMSKL_ID

ES_SHIFT_SUMMARY_SKILL.SHIFTSUMSKL_ID

Shift Summary Skill > Foreign Keys > SHIFTSUM_ID

ES_SHIFT_SUMMARY_SKILL.SHIFTSUM_ID

Shift Summary Skill > Foreign Keys > STSKL_ID

ES_SHIFT_SUMMARY_SKILL.STSKL_ID

Shift Team

WFMStandard

Scheduling MVS > Scheduled Shifts

Shift Team > Team Name

WORKBRAIN_TEAM.WBT_LOC_NAME

Scheduling MVS > Shift Definition

Shift Team > Team Description

WORKBRAIN_TEAM.WBT_LOC_DESC

Shift Team > Team Level

WORKBRAIN_TEAM.WBT_LEVEL

Shift Team > Keys > WBT_ID

WORKBRAIN_TEAM.WBT_ID

Shift Team > Keys > WBT_PARENT_ID

WORKBRAIN_TEAM.WBT_PARENT_ID

Shift Team > Keys > WBT_LFT

WORKBRAIN_TEAM.WBT_LFT

Shift Team > Keys > WBT_RGT

WORKBRAIN_TEAM.WBT_RGT

Shift Team > UDFs > WBT_FLAG?

WORKBRAIN_TEAM.WBT_FLAG?

Shift Team > UDFs > WBT_UDF?

WORKBRAIN_TEAM.WBT_UDF?

Shift Team (with optional Sub Teams)

Shift Team (with optional Sub Teams) > Team Name

WORKBRAIN_TEAM_PROMPT.WBT_NAME

Shift Team (with optional Sub Teams) > Team Description

WORKBRAIN_TEAM_PROMPT.WBT_DESC

Shift Team (with optional Sub Teams) > Team Level

WORKBRAIN_TEAM_PROMPT.WBT_LEVEL

Shift Team (with optional Sub Teams) > Keys > WBT_ID

WORKBRAIN_TEAM_PROMPT.WBT_ID

Shift Team (with optional Sub Teams) > Keys > WBT_PARENT_ID

WORKBRAIN_TEAM_PROMPT.WBT_PARENT_ID

Shift Team (with optional Sub Teams) > Keys > WBT_LFT

WORKBRAIN_TEAM_PROMPT.WBT_LFT

Shift Team (with optional Sub Teams) > Keys > WBT_RGT

WORKBRAIN_TEAM_PROMPT.WBT_RGT

Shift Team (with optional Sub Teams) > UDFs > WBT_FLAG?

WORKBRAIN_TEAM_PROMPT.WBT_FLAG?

Shift Team (with optional Sub Teams) > UDFs > WBT_UDF?

WORKBRAIN_TEAM_PROMPT.WBT_UDF?

Shift Type

WFMStandard

Scheduling MVS > Shift Definition > Shift Type

Shift Type > Shift Type Name

ES_SHIFT_TYPE.SHFTTYP_LOC_NAME

Scheduling MVS > Shift Preferences > Shift Preference

Shift Type > Shift Type Description

ES_SHIFT_TYPE.SHFTTYP_LOC_DESC

Scheduling MVS > Shift Preferences > Shift Preference History

Shift Type > Keys > SHFTTYP_ID

ES_SHIFT_TYPE.SHFTTYP_ID

Scheduling MVS > Call List

Shifts

WFMStandard

Scheduling MVS > Schedule Templates >Shift Requirement Template

Shifts > Shift Name

ES_SHIFT.ESSHIFT_NAME

Shifts > Shift Description

ES_SHIFT.ESSHIFT_DESC

Shifts > Is Shift Applied to Sub Team

ES_SHIFT.ESSHIFT_APPLYTO_SUB_TEAMS

Shifts > Keys > ESSHIFT_ID

ES_SHIFT.ESSHIFT_ID

Shifts > Foreign Keys > ESSHIFTLAB_ID

ES_SHIFT.ESSHIFTLAB_ID

Shifts > Foreign Keys > WBT_ID

ES_SHIFT.WBT_ID

Shifts > UDFs > ESSHIFT_FLAG?

ES_SHIFT.ESSHIFT_FLAG?

Shifts > UDFs > ESSHIFT_UDF?

ES_SHIFT.ESSHIFT_UDF?

Shift Group

WFMStandard

Scheduling

Shift Group > Shift Group Name

SHifT_GROUP.SHFTGRP_NAME

Shift Group > Shift Group Description

SHifT_GROUP.SHFTGRP_DESC

Shift Group > Keys > SHFTGRP_ID

SHifT_GROUP.SHFTGRP_ID

Shift Pattern

WFMBurst

Burst Census

Shift Pattern > Shift Pattern Name

SHifT_PATTERN.SHFTPAT_LOC_NAME

Burst Employee Information

Shift Pattern > Shift Pattern Description

SHifT_PATTERN.SHFTPAT_LOC_DESC

Burst Scheduling

Shift Pattern > Start Date

SHifT_PATTERN.SHFTPAT_START_DATE

Burst Work

Shift Pattern > Shift Pattern UDFs > SHFTPAT_UDF?

SHifT_PATTERN.SHFTPAT_UDF?

WFMStandard

Employee Information

Shift Pattern > Shift Pattern UDFs > SHFTPAT_VAL?

SHifT_PATTERN.SHFTPAT_VAL?

Scheduling

Shift Pattern > Shift Pattern UDFs > SHFTPAT_FLAG?

SHifT_PATTERN.SHFTPAT_FLAG?

Work

Shift Pattern > Keys > SHFTPAT_ID

SHifT_PATTERN.SHFTPAT_ID

WFMSystem

System Information > Errors and Exceptions

Shift Pattern > Foreign Keys > SHFTGRP_ID

SHifT_PATTERN.SHFTGRP_ID

Shift Pattern Shifts

WFMStandard

Work

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 Requirement Skills

WFMStandard

Scheduling MVS > Schedule Templates > Shift Requirement Template

Shift Requirement Skills > Is Skills Mandatory

ES_TMPL_SHIFT_REQ_SHIFT_SKL.ETSHRSSKL_MANDATORY

Shift Requirement Skills > Skill Weight

ES_TMPL_SHIFT_REQ_SHIFT_SKL.ETSHRSSKL_REQ_SKILL_WEIGHT

Shift Requirement Skills > Keys > ETSHRSSKL_ID

ES_TMPL_SHIFT_REQ_SHIFT_SKL.ETSHRSSKL_ID

Shift Requirement Skills > Foreign Keys > ETSHRS_ID

ES_TMPL_SHIFT_REQ_SHIFT_SKL.ETSHRS_ID

Shift Requirement Skills > Foreign Keys > STSKL_ID

ES_TMPL_SHIFT_REQ_SHIFT_SKL.STSKL_ID

Shift Requirements

WFMStandard

Scheduling MVS > Schedule Templates > Shift Requirement Template

Shift Requirements > Shift Requirement Priority

ES_SHIFT.WBT_ID

Shift Requirements > Shift Requirement Day

ES_TMPL_SHIFT_REQ_SHIFT_DAY.ETSHRSD_DAY

Shift Requirements > Shift Requirement Target

ES_TMPL_SHIFT_REQ_SHIFT_DAY.ETSHRSD_TARGET

Shift Requirements > Keys > ETSHR_ID

ES_TMPL_SHIFT_REQ.ETSHR_ID

Shift Requirements > Foreign Keys > DP_ID

ES_TMPL_SHIFT_REQ.DP_ID

Shift Requirements > Foreign Keys > ESSHIFT_ID

ES_TMPL_SHIFT_REQ_SHIFT.ESSHIFT_ID

Shift Requirements > Foreign Keys > JOB_ID

ES_TMPL_SHIFT_REQ.JOB_ID

Shift Requirements > Foreign Keys > TMPL_ID

ES_TMPL_SHIFT_REQ.TMPL_ID

Skill (also Required Skill)

WFMStandard

Scheduling

Skill > Skill Name

ST_SKILL.STSKL_NAME

Skill > Skill Description

ST_SKILL.STSKL_DESC

Skill > Keys > STSKL_ID

ST_SKILL.STSKL_ID

Skills

WFMStandard

Scheduling MVS > Schedule Templates > Shift Requirement Template

Skills > Skill Name

ST_SKILL.STSKL_NAME

Scheduling MVS > Schedule Templates > Staffing Requirement Template

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 Definition

WFMStandard

Scheduling

Staffing Definition > Volume Per Hour

SO_CLIENT_STFDEF.WRKLD_STDVOL_HOUR

Staffing Definition > Foreign Keys > ACT_ID

SO_CLIENT_STFDEF.ACT_ID

Staffing Definition > Foreign Keys > JOB_ID

SO_CLIENT_STFDEF.JOB_ID

Staffing Definition > Foreign Keys > SKDGRP_ID

SO_CLIENT_STFDEF.SKDGRP_ID

Staffing Definition > Foreign Keys > STSKL_ID

SO_CLIENT_STFDEF.STSKL_ID

Staffing Requirements

WFMStandard

Scheduling MVS > Schedule Templates > Staffing Requirement Template

Staffing Requirements > Staff Requirement Priority

ES_TMPL_STAFF_REQ.ETSR_PRIORITY

Staffing Requirements > Keys > ETSR_ID

ES_TMPL_STAFF_REQ.ETSR_ID

Staffing Requirements > Foreign Keys > DP_ID

ES_TMPL_STAFF_REQ.DP_ID

Staffing Requirements > Foreign Keys > JOB_ID

ES_TMPL_STAFF_REQ.JOB_ID

Staffing Requirements > Foreign Keys > TMPL_ID

ES_TMPL_STAFF_REQ.TMPL_ID

Staffing Requirement (SO)

WFMBurst

Burst Staffing

Staffing Requirement (SO) > Staffing Date

SO_INTERVAL_REQ.INTREQ_DATE

Staffing Requirement (SO) > Raw Interval Requirement

[Staffing Requirement (SO)].[Raw Interval Requirement]

WFMStandard

Scheduling

Staffing Requirement (SO) > Interval Type

SO_INTERVAL_TYPE.INVTYP_LOC_NAME

Staffing Requirement (SO) > Is Peak

SO_INTERVAL_REQ.INTREQ_PEAK_TIME_INTERVAL

Staffing Requirement (SO) > Start Time

SO_INTERVAL_REQ.INTREQ_TIME

Staffing Requirement (SO) > 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 )

Staffing Requirement (SO) > Number Required

SO_INTERVAL_REQ.INTREQ_TOTAL_REQ

Staffing Requirement (SO) > Minimum Required

SO_INTERVAL_REQ.INTREQ_MINTOTL_REQ

Staffing Requirement (SO) > Original Number Required (BAW)

SO_INTERVAL_REQ.INTREQ_TOTAL_REQ_HIST

Staffing Requirement (SO) > Raw Interval Requirement

[Staffing Requirement (SO)].[Raw Interval Requirement]

Staffing Requirement (SO) > Foreign Keys > ACT_ID

SO_INTERVAL_REQ.ACT_ID

Staffing Requirement (SO) > Foreign Keys > JOB_ID

SO_INTERVAL_REQ.JOB_ID

Staffing Requirement (SO) > Foreign Keys > SKDGRP_ID

SO_INTERVAL_REQ.SKDGRP_ID

Staffing Requirement (SO) > Foreign Keys > STSKL_ID

SO_INTERVAL_REQ.STSKL_ID

Staffing Requirement Day

WFMStandard

Scheduling MVS > Schedule Templates > Staffing Requirement Template

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

Staffing Requirements > Keys > ETSRD_ID

ES_TMPL_STAFF_REQ_DAY.ETSRD_ID

Staffing Requirements > Foreign Keys > ETSR_ID

ES_TMPL_STAFF_REQ_DAY.ETSR_ID

Staffing Requirement Skill

WFMStandard

Scheduling MVS > Schedule Templates > Staffing Requirement Template

Staffing Requirement Skill > Skill Requirement Weight

ES_TMPL_STAFF_REQ_SKILL.ETSRS_REQ_SKILL_WEIGHT

Staffing Requirement Skill > Is Skill Requirement Mandatory

ES_TMPL_STAFF_REQ_SKILL.ETSRS_MANDATORY

Staffing Requirement Skill > Keys ETSRS_ID

ES_TMPL_STAFF_REQ_SKILL.ETSRS_ID

Staffing Requirement Skill > Foreign Keys > ETSR_ID

ES_TMPL_STAFF_REQ_SKILL.ETSR_ID

Staffing Requirement Skill > Foreign Keys > STSKL_ID

ES_TMPL_STAFF_REQ_SKILL.STSKL_ID

Staffing Requirement Skill Day

WFMStandard

Scheduling MVS > Schedule Templates > Staffing Requirement Template

Staffing Requirement Skill Day > Skill Day

ES_TMPL_STAFF_REQ_SKILL_DAY.ETSRSD_DAY

Staffing Requirement Skill Day > Staff Requirement Per Day

ES_TMPL_STAFF_REQ_SKILL_DAY.ETSRSD_REQ

Staffing Requirement Skill Day > Keys > ETSRSD_ID

ES_TMPL_STAFF_REQ_SKILL_DAY.ETSRSD_ID

Staffing Requirement Skill Day > Foreign Keys > ETSRS_ID

ES_TMPL_STAFF_REQ_SKILL_DAY.ETSRS_ID

Store

WFMBurst

Burst Actual Results

Store > Name

SO_SCHEDULE_GROUP.SKDGRP_NAME

Burst Forecasting

Store > Staffing Standard

SO_SCHEDULE_GROUP.SKDGRP_STAFF_STD

Burst Historical Payroll Cost

Store > Forecast Method

SO_SCHEDULE_GROUP.SKDGRP_FCAST_MTD

Burst Schedule Analysis

Store > Forecast Interval

SO_SCHEDULE_GROUP.SKDGRP_FCAST_INT

Burst Scheduling

Store > Start of Week

SO_SCHEDULE_GROUP.SKDGRP_STARTDOW

Burst Staffing

Store > Internal Type

SO_SCHEDULE_GROUP.SKDGRP_INTRNL_TYPE

Burst Work

Store > Volume Type

SO_VOLUME_TYPE.VOLTYP_LOC_NAME

WFMStandard

Actual Results

Store > Budget Type

SO_SCHEDULE_GROUP.SKDGRP_BUDG_TYP

Availability

Store > Budget Value 1

SO_SCHEDULE_GROUP.SKDGRP_BUDG_VAL1

Employee Information

Store > Budget Value 2

SO_SCHEDULE_GROUP.SKDGRP_BUDG_VAL2

Historical Payroll Cost

Store > Variable Staffing Calculation

SO_SCHEDULE_GROUP.SKDGRP_CALCVARSTF

Scheduling

Store > Sales Based

SO_SCHEDULE_GROUP.SKDGRP_SALES_BASED

Work

Store > Client Key

SO_SCHEDULE_GROUP.SKDGRP_CLIENTKEY

Store > Keys > SKDGRP_ID

SO_SCHEDULE_GROUP.SKDGRP_ID

Store > Keys > SKDGRP_PARENT_ID

SO_SCHEDULE_GROUP.SKDGRP_PARENT_ID

Store > Keys > VOLTYP_ID

SO_SCHEDULE_GROUP.VOLTYP_ID

Store > Keys > WBT_ID

SO_SCHEDULE_GROUP.WBT_ID

Team / Subteam Selector

The #$account.parameters.WBL_ID# reference in the database reference SQL obtains the language ID of the current application session. The #promptmany('Team', 'integer', 'ROOT_TEAMS.WBT_ID')# reference in the database reference SQL allows the user to be prompted for one or more teams.

WFMBurst

Report Helper Object

Team / Subteam SelectorTeam Name Team / Subteam SelectorKeys > WBT_ID

select DISTINCT SUB_TEAMS.WBT_ID AS WBT_ID, SUB_TEAMS.WBT_LOC_NAME AS WBT_NAME from VL_WORKBRAIN_TEAM ROOT_TEAMS, VL_WORKBRAIN_TEAM SUB_TEAMS where ( SUB_TEAMS.VL_WBL_ID IS NULL OR SUB_TEAMS.VL_WBL_ID = #$account.parameters.WBL_ID# ) AND ( ROOT_TEAMS.VL_WBL_ID IS NULL OR ROOT_TEAMS.VL_WBL_ID = #$account.parameters.WBL_ID# ) AND ( SUB_TEAMS.WBT_LFT BETWEEN ROOT_TEAMS.WBT_LFT AND ROOT_TEAMS.WBT_RGT ) AND ( SUB_TEAMS.WBT_RGT BETWEEN ROOT_TEAMS.WBT_LFT AND ROOT_TEAMS.WBT_RGT ) AND ( ROOT_TEAMS.WBT_ID in ( #promptmany( 'Team', 'integer', 'ROOT_TEAMS.WBT_ID' )# ) )

Team

WFMBurst

Burst Employee Information

Team > Team Name

WORKBRAIN_TEAM.WBT_NAME

Team > Day Start Time

[WORKBRAIN_TEAM].[WBT_DAY_START_TIME]

Burst Work

Team > Team Description

WORKBRAIN_TEAM.WBT_DESC

Burst Work Schedule Aggregation

Team > Team Level

WORKBRAIN_TEAM.WBT_LEVEL

Team > Day Start Time

[WORKBRAIN_TEAM].[WBT_DAY_START_TIME]

WFMStandard

Employee Information

Team > Team UDFs > WBT_FLAG?

WORKBRAIN_TEAM.WBT_FLAG?

Team > Day Start Time

[WORKBRAIN_TEAM].[WBT_DAY_START_TIME]

Actual Results

Team > Day Start Time

[WORKBRAIN_TEAM].[WBT_DAY_START_TIME]

Attendance Control

Team > Day Start Time

[WORKBRAIN_TEAM].[WBT_DAY_START_TIME]

Auditing

Team > Day Start Time

[WORKBRAIN_TEAM].[WBT_DAY_START_TIME]

Availability

Team > Day Start Time

[WORKBRAIN_TEAM].[WBT_DAY_START_TIME]

Historical Payroll Cost

Team > Team UDFs > WBT_UDF?

WORKBRAIN_TEAM.WBT_UDF?

Team > Day Start Time

[WORKBRAIN_TEAM].[WBT_DAY_START_TIME]

RTSS

Team > Keys > WBT_ID

WORKBRAIN_TEAM.WBT_ID

Scheduling

Team > Keys > WBT_PARENT_ID

WORKBRAIN_TEAM.WBT_PARENT_ID

Team > Day Start Time

[WORKBRAIN_TEAM].[WBT_DAY_START_TIME]

Work

Team > Keys > WBUT_START_DATE

SEC_WORKBRAIN_TEAM.WBUT_START_DATE

Team > Day Start Time

[WORKBRAIN_TEAM].[WBT_DAY_START_TIME]

Scheduling MVS > Call List

Team > Keys > WBUT_END_DATE

SEC_WORKBRAIN_TEAM.WBUT_END_DATE

Team > Day Start Time

[WORKBRAIN_TEAM].[WBT_DAY_START_TIME]

Scheduling MVS > Shift Preferences > Shift Preference

Team > Foreign Keys > CURRENT_TIMESTAMP

CURRENT_TIMESTAMP

Scheduling MVS > Shift Preferences > Shift Preference (History)

Scheduling MVS > Schedule Templates

Scheduling MVS > Shift Preferences > Shift Preference

Scheduling MVS > Shift Preferences > Shift Preference (History)

Scheduling MVS > Team Schedule Period

Scheduling MVS > Workload > Workload Census

Scheduling MVS > Workload > Workload Requirement

Scheduling MVS > Workload > Budgeted Hours Per Patient Day

Scheduling MVS > Schedule Templates

Team > Day Start Time

[WORKBRAIN_TEAM].[WBT_DAY_START_TIME]

Scheduling MVS > Team Schedule Period

Team > Day Start Time

[WORKBRAIN_TEAM].[WBT_DAY_START_TIME]

WFMSystem

System Information > Errors and Exception

Team > Day Start Time

[WORKBRAIN_TEAM].[WBT_DAY_START_TIME]

System Information > User Session

Team > Day Start Time

[WORKBRAIN_TEAM].[WBT_DAY_START_TIME]

Team (with optional Sub Teams)

The Team with Sub Team option Query Subject refers to the same tables and views as the Team Query Subject. There are additional parameters built into the WFM application to handle the Sub Team option.

WFMBurst

Burst Employee Information

Team (with optional Sub Teams) > Team Name

SEC_WB_TEAM_PROMPT.WBT_NAME

Team (with optional Sub Teams) > Day Start Time

[SEC_WB_TEAM_PROMPT].[WBT_DAY_START_TIME

WFMStandard

Actual Results

Team (with optional Sub Teams) > Team Description

SEC_WB_TEAM_PROMPT.WBT_DESC

Team (with optional Sub Teams) > Day Start Time

[SEC_WB_TEAM_PROMPT].[WBT_DAY_START_TIME]

Attendance Control

Team (with optional Sub Teams) > Team Level

SEC_WB_TEAM_PROMPT.WBT_LEVEL

Team (with optional Sub Teams) > Day Start Time

[WORKBRAIN_TEAM_PROMPT].[WBT_DAY_START_TIME]

Auditing

Team (with optional Sub Teams) > Team UDFs > WBT_FLAG?

SEC_WB_TEAM_PROMPT.WBT_FLAG?

Team (with optional Sub Teams) > Day Start Time

[SEC_WB_TEAM_PROMPT].[WBT_DAY_START_TIME]

Availability

Team (with optional Sub Teams) > Team UDFs > WBT_UDF?

SEC_WB_TEAM_PROMPT.WBT_UDF?

Team (with optional Sub Teams) > Day Start Time

[SEC_WB_TEAM_PROMPT].[WBT_DAY_START_TIME]

Employee Information

Team (with optional Sub Teams) > Keys > WBT_ID

SEC_WB_TEAM_PROMPT.WBT_ID

Team (with optional Sub Teams) > Day Start Time

[WORKBRAIN_TEAM_PROMPT].[WBT_DAY_START_TIME]

Historical Payroll Cost

Team (with optional Sub Teams) > Keys > WBUT_START_DATE

SEC_WB_TEAM_PROMPT.WBUT_START_DATE

Team (with optional Sub Teams) > Day Start Time

[SEC_WB_TEAM_PROMPT].[WBT_DAY_START_TIME]

Scheduling

Team (with optional Sub Teams) > Keys > WBUT_END_DATE

SEC_WB_TEAM_PROMPT.WBUT_END_DATE

Team (with optional Sub Teams) > Day Start Time

[WORKBRAIN_TEAM_PROMPT].[WBT_DAY_START_TIME]

Work

Team (with optional Sub Teams) > Foreign Keys > Current_Timestamp

current_timestamp

Team (with optional Sub Teams) > Day Start Time

[WORKBRAIN_TEAM_PROMPT].[WBT_DAY_START_TIME]

Scheduling MVS > Team Schedule Period

Team (with optional Sub Teams) > Day Start Time

[WORKBRAIN_TEAM_PROMPT].[WBT_DAY_START_TIME]

WFMSystem

System Information > Errors and Excecptions

Team (with optional Sub Teams) > Day Start Time

[WORKBRAIN_TEAM_PROMPT].[WBT_DAY_START_TIME]

Team (with optional Sub Teams) > Foreign Keys > WBTT_ID

SEC_WB_TEAM_PROMPT.WBTT_ID

System Information > User Session

Team (with optional Sub Teams) > Day Start Time

[SEC_WB_TEAM_PROMPT].[WBT_DAY_START_TIME]

Team Schedule Period

WFMStandard

Scheduling MVS > Team Schedule Period > Team Schedule Period

Team Schedule Period > Apply to Sub Team

TEAM_SCHPRD.TMSCPR_APL_SUBTM

Team Schedule Period > Shift Team Schedule Period Editable

TEAM_SCHPRD.TMSCPR_EDITABLE

Team Schedule Period > Keys > TMSCPR_ID

TEAM_SCHPRD.TMSCPR_ID

Team Schedule Period > Foreign Keys > SCPR_ID

TEAM_SCHPRD.SCPR_ID

Team Schedule Period > Foreign Keys > WBT_ID

TEAM_SCHPRD.WBT_ID

Team Schedule Period > UDFs > TMSCPR_FLAG?

TEAM_SCHPRD.TMSCPR_FLAG?

Team Schedule Period > UDFs > TMSCPR_UDF?

TEAM_SCHPRD.TMSCPR_UDF?

Teams with Inherited Shifts

WFMStandard

Scheduling MVS > Shift Definition

Teams with Inherited Shifts > Subscription Team Name

WORKBRAIN_TEAM for ES_SHIFT_TEAM.WBT_NAME

Teams with Inherited Shifts > Subscription Team Description

WORKBRAIN_TEAM for ES_SHIFT_TEAM.WBT_DESC

Teams with Inherited Shifts > Subscription Start Date

ES_SHIFT_TEAM.ESSHTM_EFF_START_DATE

Teams with Inherited Shifts > Subscription End Date

ES_SHIFT_TEAM.ESSHTM_EFF_END_DATE

Teams with Inherited Shifts > Keys > ESSHTM_ID

ES_SHIFT_TEAM.ESSHTM_ID

Teams with Inherited Shifts > Foreign Keys > ESSHIFT_ID

ES_SHIFT_TEAM.ESSHIFT_ID

Teams with Inherited Shifts > Foreign Keys > WBT_ID

ES_SHIFT_TEAM.WBT_ID

Template Schedule

WFMStandard

Scheduling MVS > Schedule Templates

Schedule Template > Template Name

ES_SCHEDULE_TEMPLATE.TMPL_NAME

Schedule Template > Template Description

ES_SCHEDULE_TEMPLATE.TMPL_DESC

Schedule Template > Template Length

ES_SCHEDULE_TEMPLATE.TMPL_LENGTH

Schedule Template > Template Create Date

ES_SCHEDULE_TEMPLATE.TMPL_CREATE_DATE

Schedule Template > Template Start Date

ES_SCHEDULE_TEMPLATE.TMPL_START_DATE

Schedule Template > Template End Date

ES_SCHEDULE_TEMPLATE.TMPL_END_DATE

Schedule Template > Is Template Active

ES_SCHEDULE_TEMPLATE.TMPL_ACTIVE

Schedule Template > UDFs > TMPL_FLAG?

ES_SCHEDULE_TEMPLATE.TMPL_FLAG?

Schedule Template > UDFs > TMPL_UDF?

ES_SCHEDULE_TEMPLATE.TMPL_UDF?

Schedule Template > Keys > TMPL_ID

ES_SCHEDULE_TEMPLATE.TMPL_ID

Schedule Template > Foreign Keys > WBT_ID

ES_SCHEDULE_TEMPLATE.WBT_ID

Schedule Template > Foreign Keys > TMPLTYP_ID

ES_SCHEDULE_TEMPLATE.TMPLTYP_ID

Schedule Template > Foreign Keys > TMPL_PARENT_ID

ES_SCHEDULE_TEMPLATE.TMPL_PARENT_ID

Template Type

WFMStandard

Template Type > Template Type Name

ES_TMPL_TYPE.TMPLTYP_NAME

Scheduling MVS > Schedule Templates

Template Type > Template Type Description

ES_TMPL_TYPE.TMPLTYP_DESC

Template Type > UDFs > TMPLTYP_FLAG?

ES_TMPL_TYPE.TMPLTYP_FLAG?

Template Type > UDFs > TMPLTYP_UDF?

ES_TMPL_TYPE.TMPLTYP_UDF?

Template Type > Keys > TMPLTYP_ID

ES_TMPL_TYPE.TMPLTYP_ID

Time Code

WFMBurst

Burst Work

Time Code > Time Code Name

TIME_CODE.TCODE_LOC_NAME

WFMStandard

Scheduling

Time Code > Time Code Description

TIME_CODE.TCODE_LOC_DESC

Work

Time Code > Time Code YAG

TIME_CODE.TCODE_YAG

Time Code > Is Break

TIME_CODE.TCODE_IS_BRK

Time Code > Is Irregular

if (TIME_CODE.TCODE_IRREGULAR is null) then ('N') else TIME_CODE.TCODE_IRREGULAR)

Time Code > Is Productive

TIME_CODE.TCODE_RPT_ISPRDCTV

Time Code > Exclude from Total Hours

TIME_CODE.TCODE_IS_EXCLD_TTL

Time Code > Is LTA

TIME_CODE.TCODE_IS_LTA

Time Code > Is Controllable Absence

TIME_CODE_CONTROLLABLE.IS_CONTROLLABLE

Time Code > Is Uncontrollable Absence

TIME_CODE_UNCONTROLLABLE.IS_UNCONTROLLABLE

Time Code > Time Code Flags > TCODE_FLAG?

TIME_CODE.TCODE_FLAG?

Time Code > Time Code UDFs > TCODE_UDF?

TIME_CODE.TCODE_UDF?

Time Code > Keys > TCODE_ID

TIME_CODE.TCODE_ID

Time Code > Keys > TCODE_NAME

TIME_CODE.TCODE_NAME

Time Code Controllable

WFM Standard

Work

Time Code Controllable > Is Controllable Absence

case when TIME_CODE_DATA.TCDATA_VALUE = 'Y' then 'Y' else 'N' end TCDATA_VALUE

Time Code Controllable > TCODE_ID

TIME_CODE_DATA.TCODE_ID

Time Code Uncontrollable

WFM Standard

Work

Time Code Uncontrollable > Is Uncontrollable Absence

case when TIME_CODE_DATA.TCDATA_VALUE = 'Y' then 'Y' else 'N' end TCDATA_VALUE

Time Code Uncontrollable > TCODE_ID

TIME_CODE_DATA.TCODE_ID

Transactions

WFMSystem

System Information > Interfaces

Transactions > Interface Name

WBINT_TRANSACTION.WBITYP_NAME

Transactions > Filename

WBINT_TRANSACTION.WBITRAN_FILENAME

Transactions > Transaction Type

WBINT_TYPE.WBITYP_TYPE

Transactions > Create Date/Time

WBINT_TRANSACTION.WBITRAN_CREATE_DT

Transactions > Start Date/Time

WBINT_TRANSACTION.WBITRAN_START_DATE

Transactions > End Date/Time

WBINT_TRANSACTION.WBITRAN_END_DATE

Transactions > Status

WBINT_TRANSACTION.WBITRAN_STATUS

Transactions > Keys > WBITRAN_ID

WBINT_TRANSACTION.WBITRAN_ID

User

WFMBurst

Burst Actual Results

User > User Name

WORKBRAIN_USER.WBU_NAME

Burst Census

User > Email

WORKBRAIN_USER.WBU_EMAIL

Burst Employee Information

User > Is Active

WORKBRAIN_USER.WBU_ACTIVE

Burst Forecasting

User > Bad Login Count

WORKBRAIN_USER.WBU_BAD_LOGIN_COUN

Burst Historical Payroll Cost

User > Language

WORKBRAIN_LANGUAGE.WBL_NAME

Burst Labor Budgeting

User > Locale

WORKBRAIN_LANGUAGE.WBL_LOCALE

Burst Schedule Analysis

User > Ming.le Identifier

WORKBRAIN_USER.WBU_IDENTITY2

Burst Scheduling

User > Workbrain User UDFs > WBU_FLAG?

WORKBRAIN_USER.WBU_FLAG?

Burst Staffing

User > Workbrain User UDFs > WBU_UDF?

WORKBRAIN_USER.WBU_UDF?

Burst Work

User > Keys > EMP_ID

WORKBRAIN_USER.EMP_ID

Burst Work Schedule Aggregation

User > Keys > WBU_ID

WORKBRAIN_USER.WBU_ID

User > Foreign Keys > WBG_ID

WORKBRAIN_USER.WBG_ID

WFMStandard

Auditing

Employee Information

Scheduling MVS > Scheduled Shifts > Call Logs

Scheduling MVS > Scheduled Shifts > Shift Offers

Scheduling MVS > Rotations > Rotation Publish Task

WFMSystem

System Information > Audit Tracking

System Information > User Session

User (Actual Approver)

WFMStandard

Scheduling MVS > Shift Preferences > Shift Preference

User (Actual Approver) > User Name

WORKBRAIN_USER.WBU_NAME

Scheduling MVS > Shift Preferences > Shift Preference (History)

User (Actual Approver) > Email

WORKBRAIN_USER.WBU_EMAIL

User (Actual Approver) > Is Active

WORKBRAIN_USER.WBU_ACTIVE

User (Actual Approver) > Bad Login Count

WORKBRAIN_USER.WBU_BAD_LOGIN_COUN

User (Actual Approver) > Language

WORKBRAIN_LANGUAGE.WBL_NAME

User (Actual Approver) > Locale

WORKBRAIN_LANGUAGE.WBL_LOCALE

User (Actual Approver) > Ming.le Identifier

WORKBRAIN_USER.WBU_IDENTITY2

User (Actual Approver) > Keys > EMP_ID

WORKBRAIN_USER.EMP_ID

User (Actual Approver) > Keys > WBU_ID

WORKBRAIN_USER.WBU_ID

User (Actual Approver) > UDFs > WBU_FLAG?

WORKBRAIN_USER.WBU_FLAG?

User (Actual Approver) > UDFs > WBU_UDF?

WORKBRAIN_USER.WBU_UDF?

User (Actual Submitter)

WFMStandard

Scheduling MVS > Shift Preferences > Shift Preference

User (Actual Submitter) > User Name

WORKBRAIN_USER.WBU_NAME

Scheduling MVS > Shift Preferences > Shift Preference (History)

User (Actual Submitter) > Email

WORKBRAIN_USER.WBU_EMAIL

User (Actual Submitter) > Is Active

WORKBRAIN_USER.WBU_ACTIVE

User (Actual Submitter) > Bad Login Count

WORKBRAIN_USER.WBU_BAD_LOGIN_COUN

User (Actual Submitter) > Language

WORKBRAIN_LANGUAGE.WBL_NAME

User (Actual Submitter) > Locale

WORKBRAIN_LANGUAGE.WBL_LOCALE

User (Actual Submitter) > Ming.le Identifier

WORKBRAIN_USER.WBU_IDENTITY2

User (Actual Submitter) > Keys > EMP_ID

WORKBRAIN_USER.EMP_ID

User (Actual Submitter) > Keys > WBU_ID

WORKBRAIN_USER.WBU_ID

User (Actual Submitter) > UDFs > WBU_FLAG?

WORKBRAIN_USER.WBU_FLAG?

User (Actual Submitter) > UDFs > WBU_UDF?

WORKBRAIN_USER.WBU_UDF?

User (Approver)

WFMStandard

Scheduling MVS > Shift Preferences > Shift Preference

User (Approver) > User Name

WORKBRAIN_USER.WBU_NAME

Scheduling MVS > Shift Preferences > Shift Preference (History)

User (Approver) > Email

WORKBRAIN_USER.WBU_EMAIL

User (Approver) > Is Active

WORKBRAIN_USER.WBU_ACTIVE

User (Approver) > Bad Login Count

WORKBRAIN_USER.WBU_BAD_LOGIN_COUN

User (Approver) > Language

WORKBRAIN_LANGUAGE.WBL_NAME

User (Approver) > Locale

WORKBRAIN_LANGUAGE.WBL_LOCALE

User (Approver) > Ming.le Identifier

WORKBRAIN_USER.WBU_IDENTITY2

User (Approver) > Keys > EMP_ID

WORKBRAIN_USER.EMP_ID

User (Approver) > Keys > WBU_ID

WORKBRAIN_USER.WBU_ID

User (Approver) > UDFs > WBU_FLAG?

WORKBRAIN_USER.WBU_FLAG?

User (Approver) > UDFs > WBU_UDF?

WORKBRAIN_USER.WBU_UDF?

User (Submitter)

WFMStandard

Scheduling MVS > Shift Preferences > Shift Preference

User (Submitter) > User Name

WORKBRAIN_USER.WBU_NAME

Scheduling MVS > Shift Preferences > Shift Preference (History)

User (Submitter) > Email

WORKBRAIN_USER.WBU_EMAIL

User (Submitter) > Is Active

WORKBRAIN_USER.WBU_ACTIVE

User (Submitter) > Bad Login Count

WORKBRAIN_USER.WBU_BAD_LOGIN_COUN

User (Submitter) > Language

WORKBRAIN_LANGUAGE.WBL_NAME

User (Submitter) > Locale

WORKBRAIN_LANGUAGE.WBL_LOCALE

User (Submitter) > Ming.le Identifier

WORKBRAIN_USER.WBU_IDENTITY2

User (Submitter) > Keys > EMP_ID

WORKBRAIN_USER.EMP_ID

User (Submitter) > Keys > WBU_ID

WORKBRAIN_USER.WBU_ID

User (Submitter) > UDFs > WBU_FLAG?

WORKBRAIN_USER.WBU_FLAG?

User (Submitter) > UDFs > WBU_UDF?

WORKBRAIN_USER.WBU_UDF?

User Aggregated Work

WFMBurst

Burst Work Schedule Aggregation

User Aggregated Work > Date

AGG_USER_WORK.AGUSR_WRK_DATE

WFMStandard

Report Helper Objects > Aggregration Tables

User Aggregated Work > Scheduled Minutes

AGG_USER_WORK.AGUSR_SD_MIN

User Aggregated Work > Scheduled REG Minutes

AGG_USER_WORK.AGUSR_SD_REG_MIN

User Aggregated Work > Scheduled OT Minutes

AGG_USER_WORK.AGUSR_SD_OT_MIN

User Aggregated Work > Scheduled Productive Minutes

AGG_USER_WORK.AGUSR_SD_PRDTV_MIN

User Aggregated Work > Scheduled Absent Minutes

AGG_USER_WORK.AGUSR_SD_ABS_MIN

User Aggregated Work > Scheduled Exception Minutes

AGG_USER_WORK.AGUSR_SD_EXPT_MIN

User Aggregated Work > Scheduled Rate

AGG_USER_WORK.AGUSR_SD_RATE

User Aggregated Work > Worked Minutes

AGG_USER_WORK.AGUSR_WD_MIN

User Aggregated Work > Worked REG Minutes

AGG_USER_WORK.AGUSR_WD_REG_MIN

User Aggregated Work > Worked OT Minutes

AGG_USER_WORK.AGUSR_WD_OT_MIN

User Aggregated Work > Worked Productive Minutes

AGG_USER_WORK.AGUSR_WD_PRDTV_MIN

User Aggregated Work > Worked Absent Minutes

AGG_USER_WORK.AGUSR_WD_ABS_MIN

User Aggregated Work > Worked Exception Minutes

AGG_USER_WORK.AGUSR_WD_EXPT_MIN

User Aggregated Work > Worked Rate

AGG_USER_WORK.AGUSR_WD_RATE

User Aggregated Work > Data Aggregation Date

AGG_USER_WORK.AGUSR_DATA_ASOF

User Aggregated Work > User Aggregated Work Custom Facts > AGUSR_FACT?

AGG_USER_WORK.AGUSR_FACT?

User Aggregated Work > User Aggregated Work Custom Facts > AGUSR_UDF?

AGG_USER_WORK.AGUSR_UDF?

User Aggregated Work > Keys > AGUSR_CAMPASSPRT_ID

AGG_USER_WORK.AGUSR_CAMPASSPRT_ID

User Aggregated Work > Keys > CGCRT_ID

AGG_USER_WORK.CGCRT_ID

User Aggregated Work > Keys > CGMAP_ID

AGG_USER_WORK.CGMAP_ID

User Aggregated Work > Keys > WBU_ID

AGG_USER_WORK.WBU_ID

User Aggregated Work > Foreign Keys > CALCGRP_ID

AGG_USER_WORK.CALCGRP_ID

User Aggregated Work > Foreign Keys > DEPT_ID

AGG_USER_WORK.DEPT_ID

User Aggregated Work > Foreign Keys > DOCK_ID

AGG_USER_WORK.DOCK_ID

User Aggregated Work > Foreign Keys > EMP_ID

AGG_USER_WORK.EMP_ID

User Aggregated Work > Foreign Keys > HTYPE_ID

AGG_USER_WORK.HTYPE_ID

User Aggregated Work > Foreign Keys > JOB_ID

AGG_USER_WORK.JOB_ID

User Aggregated Work > Foreign Keys > PAYGRP_ID

AGG_USER_WORK.PAYGRP_ID

User Aggregated Work > Foreign Keys > PROJ_ID

AGG_USER_WORK.PROJ_ID

User Aggregated Work > Foreign Keys > TCODE_ID

AGG_USER_WORK.TCODE_ID

User Aggregated Work > Foreign Keys > WBT_ID

AGG_USER_WORK.WBT_ID

User Session

WFMSystem

System Information > User Session

User Session > Session Date

WORKBRAIN_USRSESN.WBUS_DATE

User Session > Login Date

WORKBRAIN_USRSESN.WBUS_LOGIN_AT_DATE

User Session > Logout Date

WORKBRAIN_USRSESN.WBUS_LOGOUT_AT_DT

User Session > IP Address

WORKBRAIN_USRSESN.WBUS_IP

User Session > Status

WORKBRAIN_USRSESN.WBUS_STATUS

User Session > Keys > WBUS_ID

WORKBRAIN_USRSESN.WBUS_ID

User Session > Keys > WBU_NAME

WORKBRAIN_USRSESN.WBU_NAME

User Session > Foreign Keys > WBUSDN_ID

WORKBRAIN_USRSESN.WBUSDN_ID

User Session Domain

WFMSystem

System Information > User Session

User Session Domain > Domain Name

WORKBRAIN_USER_SESSION_DOMAIN.WBUSDN_NAME

User Session Domain > Domain Description

WORKBRAIN_USER_SESSION_DOMAIN.WBUSDN_DESC

User Session Domain > Keys > WBUSDN_ID

WORKBRAIN_USER_SESSION_DOMAIN.WBUSDN_ID

Violation Definition

WFMStandard

Attendance Control

Violation Definition > Violation Name

AC_VIOLATION.ACVIOL_NAME

Violation Definition > Violation Description

AC_VIOLATION.ACVIOL_DESC

Violation Definition > Eligible Event Names

AC_VIOLATION.ACVIOL_ACEVT_NAMES

Violation Definition > Elgible Teams

AC_VIOLATION.WBT_NAMES

Violation Definition > Sub team Eligibility

AC_VIOLATION.ACVIOL_APPLY_SUBTM

Violation Definition > Eligible Employees

AC_VIOLATION.ACVIOL_EMP_NAMES

Violation Definition > Eligible Calc Groups

AC_VIOLATION.ACVIOL_CALCGRP_NAMES

Violation Definition > Eligible Pay Groups

AC_VIOLATION.ACVIOL_PAYGRP_NAMES

Violation Definition > Period Type Name

AC_PERIOD_TYPE.ACPERTYP_NAME

Violation Definition > Period Type Description

AC_PERIOD_TYPE.ACPERTYP_DESC

Violation Definition > Threshold Points

AC_VIOLATION.ACVIOL_THRESHOLD_POINTS

Violation Definition > Exclude Counted Events

AC_VIOLATION.ACVIOL_EXCLUDE

Violation Definition > Ignore Authorized

AC_VIOLATION.ACVIOL_IGNORE

Violation Definition > Violation Definition UDFs > ACVIOL_EMP_VAL?S

AC_VIOLATION.ACVIOL_EMP_VAL?S

Violation Definition > Violation Definition UDFs > ACVIOL_FLAG?

AC_VIOLATION.ACVIOL_FLAG?

Violation Definition > Violation Definition UDFs > ACVIOL_UDF1?

AC_VIOLATION.ACVIOL_UDF?

Violation Definition > Keys > ACVIOL_ID

AC_VIOLATION.ACVIOL_ID

Violation Definition > Keys > ACPERTYP_ID

AC_VIOLATION.ACPERTYP_ID

Violation Log Entry

WFMStandard

Attendance Control

Violation Log Entry > Violation Name

AC_VIOLATION.ACVIOL_NAME

Violation Log Entry > Work Date

AC_VIOLATION_LOG.ACVIOLOG_WORK_DATE

Violation Log Entry > User

AC_VIOLATION_LOG.WBU_NAME

Violation Log Entry > Actual User

AC_VIOLATION_LOG.WBU_NAME_ACTUAL

Violation Log Entry > Log Date

AC_VIOLATION_LOG.ACVIOLOG_DATE

Violation Log Entry > Employee Reason

AC_VIOLATION_LOG.ACVIOLOG_EMP_REASON

Violation Log Entry > Notified By

AC_VIOLATION_LOG.ACVIOLOG_NOTifIED_BY

Violation Log Entry > Notification Date

AC_VIOLATION_LOG.ACVIOLOG_NOTifIED_DATE

Violation Log Entry > Authorized By

AC_VIOLATION_LOG.ACVIOLOG_AUTH_BY

Violation Log Entry > Authorization Date

AC_VIOLATION_LOG.ACVIOLOG_AUTH_DATE

Violation Log Entry > Supervisor Notes

AC_VIOLATION_LOG.ACVIOLOG_SUPER_NOTES

Violation Log Entry > Status

AC_VIOLATION_LOG.ACVIOLOG_STATUS

Violation Log Entry > Comments

AC_VIOLATION_LOG.ACVIOLOG_COMMENTS

Violation Log Entry > Keys > ACVIOLOG_ID

AC_VIOLATION_LOG.ACVIOLOG_ID

Violation Log Entry > Foreign Keys > ACVIOL_ID

AC_VIOLATION_LOG.ACVIOL_ID

Violation Log Entry > Foreign Keys > EMP_ID

AC_VIOLATION_LOG.EMP_ID

Volume Workload

WFMStandard

Scheduling

Volume Workload > Volume Per Hour

SO_VOLUME_WORKLOAD.WRKLD_STDVOL_HOUR

Volume Workload > Keys > SKDGRP_ID

SO_VOLUME_WORKLOAD.SKDGRP_ID

Week Time Period

Query Subject Filter: Days between Start Date and End Date is > 5 and < 9 days.

WFMBurst

Burst Labor Budgeting > Default Time Periods

Week Time Period > Week

FCST_TIME_PERIOD.FCTP_LOC_NAME

WFMStandard

Scheduling > Default Time Periods

Week Time Period > Week Description

FCST_TIME_PERIOD.FCTP_LOC_DESC

Week Time Period > Start Date

FCST_TIME_PERIOD.FCTP_START_DATE

Week Time Period > End Date

FCST_TIME_PERIOD.FCTP_END_DATE

Week Time Period > Keys > FCTP_ID

FCST_TIME_PERIOD.FCTP_ID

Week Time Period > Keys > FCTP_PARENT_ID

FCST_TIME_PERIOD.FCTP_PARENT_ID

Work

WFMBurst

Work

Work > Work Date

WORK_DETAIL.WRKD_WORK_DATE

WFMStandard

Work

Work > Time Code

TIME_CODE.TCODE_LOC_NAME

Work > Bad Quantity

WORK_DETAIL.WRKD_BAD_QUANTITY

Work > WRKD_BAD_QTY_RSNCD_ID

WORK_DETAIL.WRKD_BAD_QTY_RSNCD_ID

WFMSystem

System Information > Errors and Exceptions

Work > Hour Type

HOUR_TYPE.HTYPE_LOC_NAME

Work > Start Time

WORK_DETAIL.WRKD_START_TIME

Work > End Time

WORK_DETAIL.WRKD_END_TIME

Work > Work Detail Type

WORK_DETAIL.WRKD_TYPE

Work > Cost

(WORK_DETAIL.WRKD_MINUTES /60) * WORK_DETAIL.WRKD_RATE

Work > Rate

WORK_DETAIL.WRKD_RATE

Work > Minutes

WORK_DETAIL.WRKD_MINUTES

Work > Hours

WORK_DETAIL.WRKD_MINUTES / 60

Work > Quantity

if ( WORK_DETAIL.WRKD_QUANTITY=-1000 ) then ( 0 ) else ( WORK_DETAIL.WRKD_QUANTITY )

Work > Overtime Minutes

if ( HOUR_TYPE.HTYPE_RPT_ISOT ='Y' ) then ( WORK_DETAIL.WRKD_MINUTES ) else ( 0 )

Work > Overtime Hours

if ( HOUR_TYPE.HTYPE_RPT_ISOT ='Y' ) then ( WORK_DETAIL.WRKD_MINUTES /60 ) else ( 0 )

Work > Exception Minutes

if (TIME_CODE.TCODE_IRREGULAR = 'Y') then ( WORK_DETAIL.WRKD_MINUTES ) else ( 0 )

Work > Exception Hours

if (TIME_CODE.TCODE_IRREGULAR = 'Y') then ( WORK_DETAIL.WRKD_MINUTES / 60 ) else ( 0 )

Work > Productive Minutes

if ( TIME_CODE.TCODE_RPT_ISPRDCTV ='Y' ) then ( WORK_DETAIL.WRKD_MINUTES ) else ( 0 )

Work > Productive Hours

if ( TIME_CODE.TCODE_RPT_ISPRDCTV ='Y' ) then ( WORK_DETAIL.WRKD_MINUTES /60 ) else ( 0 )

Work > Absent Minutes

if (TIME_CODE.TCODE_IS_LTA = 'Y' ) then ( WORK_DETAIL.WRKD_MINUTES ) else ( 0 )

Work > Absent Hours

if ( TIME_CODE.TCODE_IS_LTA = 'Y' ) then ( WORK_DETAIL.WRKD_MINUTES / 60 ) else ( 0 )

Work > Controlled Absent Minutes

if ( TIME_CODE.TCODE_NAME = 'LATE' ) then ( WORK_DETAIL.WRKD_MINUTES ) else if (TIME_CODE.TCODE_NAME = 'LE ') then ( WORK_DETAIL.WRKD_MINUTES ) else if (TIME_CODE.TCODE_NAME = 'ABS ) then ( WORK_DETAIL.WRKD_MINUTES ) else if ( TIME_CODE.TCODE_NAME = 'LL' ) then ( WORK_DETAIL.WRKD_MINUTES ) else if ( TIME_CODE.TCODE_NAME = 'LTA' ) then ( WORK_DETAIL.WRKD_MINUTES ) else if ( TIME_CODE.TCODE_NAME = 'TRN' ) then ( WORK_DETAIL.WRKD_MINUTES ) else if ( TIME_CODE.TCODE_NAME = 'LATE' ) then ( WORK_DETAIL.WRKD_MINUTES ) else if ( TIME_CODE_CONTROLLABLE.IS_CONTROLLABLE='Y' ) then ( WORK_DETAIL.WRKD_MINUTES ) else (0)

Work > Uncontrolled Absent Minutes

if ( TIME_CODE.TCODE_NAME = 'SICK' ) then ( WORK_DETAIL.WRKD_MINUTES ) else if (TIME_CODE.TCODE_NAME = 'SCK' ) then ( WORK_DETAIL.WRKD_MINUTES ) else if (TIME_CODE.TCODE_NAME = 'VAC' ) then ( WORK_DETAIL.WRKD_MINUTES ) else if (TIME_CODE.TCODE_NAME = 'JURY' ) then ( WORK_DETAIL.WRKD_MINUTES ) else if (TIME_CODE.TCODE_NAME = 'HOL' ) then ( WORK_DETAIL.WRKD_MINUTES ) else if (TIME_CODE.TCODE_NAME = 'PD' ) then ( WORK_DETAIL.WRKD_MINUTES ) else if (TIME_CODE.TCODE_NAME = 'WRKCOMP' ) then ( WORK_DETAIL.WRKD_MINUTES ) else if (TIME_CODE.TCODE_NAME = 'INJ' ) then ( WORK_DETAIL.WRKD_MINUTES ) else if ( TIME_CODE_UNCONTROLLABLE.IS_UNCONTROLLABLE='Y' ) then ( WORK_DETAIL.WRKD_MINUTES ) else ( 0 )

Work > Is Authorized

WORK_DETAIL.WRKD_AUTH

Work > Authorized By

WORK_DETAIL.WRKD_AUTH_BY

Work > Authorization Date

WORK_DETAIL.WRKD_AUTH_DATE

Work > Comments

WORK_DETAIL.WRKD_COMMENTS

Work > Work Detail UDFs > WRKD_UDF?

WORK_DETAIL.WRKD_UDF?

Work > Work Detail UDFs > WRKD_FLAG?

WORK_DETAIL.WRKD_FLAG?

Work > Keys > WRKD_ID

WORK_DETAIL.WRKD_ID

Work > Foreign Keys > DEPT_ID

WORK_DETAIL.DEPT_ID

Work > Foreign Keys > DOCK_ID

WORK_DETAIL.DOCK_ID

Work > Foreign Keys > HTYPE_ID

WORK_DETAIL.HTYPE_ID

Work > Foreign Keys > JOB_ID

WORK_DETAIL.JOB_ID

Work > Foreign Keys > PROJ_ID

WORK_DETAIL.PROJ_ID

Work > Foreign Keys > TCODE_ID

WORK_DETAIL.TCODE_ID

Work > Foreign Keys > WBT_ID

WORK_DETAIL.WBT_ID

Work > Foreign Keys > WRKS_ID

WORK_DETAIL.WRKS_ID

Work Adjustments

WFMStandard

Work

Work Adjustments > Adjustment Date

WORK_DETAIL_ADJUST.WRKDA_ADJUST_DATE

Work Adjustments > Work Date

WORK_DETAIL_ADJUST.WRKDA_WORK_DATE

Work Adjustments > Start Time

WORK_DETAIL_ADJUST.WRKDA_START_TIME

Work Adjustments > End Time

WORK_DETAIL_ADJUST.WRKDA_END_TIME

Work Adjustments > Minutes

WORK-DETAIL_ADJUST.WRKDA_MINUTES

Work Adjustments > Rate

WORK_DETAIL_ADJUST.WRKDA_RATE

Work Adjustments > Is Authorized

WORK_DETAIL_ADJUST.WRKSA_WRKD_AUTH

Work Adjustments > Work Summary Is Authorized

WORK_DETAIL_ADJUST.WRKSA_AUTHORIZED

Work Adjustments > Work Adjustments UDFs > WRKDA_FLAG?

WORK_DETAIL_ADJUST.WRKDA_FLAG?

Work Adjustments > Work Adjustments UDFs > WRKDA_UDF?

WORK_DETAIL_ADJUST.WRKDA_UDF?

Work Adjustments > Work Adjustments UDFs > WRKSA_FLAG?

WORK_DETAIL_ADJUST.WRKSA_FLAG?

Work Adjustments > Work Adjustments UDFs > WRKSA_UDF?

WORK_DETAIL_ADJUST.WRKSA_UDF?

Work Adjustments > Keys > WRKDA_ID

WORK_DETAIL_ADJUST.WRKDA_ID

Work Adjustments > Foreign Keys > CALCGRP_ID

WORK_DETAIL_ADJUST.CALCGRP_ID

Work Adjustments > Foreign Keys > DEPT_ID

WORK_DETAIL_ADJUST.DEPT_ID

Work Adjustments > Foreign Keys > DOCK_ID

WORK_DETAIL_ADJUST.DOCK_ID

Work Adjustments > Foreign Keys > EMP_ID

WORK_DETAIL_ADJUST.EMP_ID

Work Adjustments > Foreign Keys > HTYPE_ID

WORK_DETAIL_ADJUST.HTYPE_ID

Work Adjustments > Foreign Keys > JOB_ID

WORK_DETAIL_ADJUST.JOB_ID

Work Adjustments > Foreign Keys > PAYGRP_ID

WORK_DETAIL_ADJUST.PAYGRP_ID

Work Adjustments > Foreign Keys > PETYP_ID

WORK_DETAIL_ADJUST.PETYP_ID

Work Adjustments > Foreign Keys > PROJ_ID

WORK_DETAIL_ADJUST.PROJ_ID

Work Adjustments > Foreign Keys > SHFT_ID

WORK_DETAIL_ADJUST.SHFT_ID

Work Adjustments > Foreign Keys > TCODE_ID

WORK_DETAIL_ADJUST.TCODE_ID

Work Adjustments > Foreign Keys > WBT_ID

WORK_DETAIL_ADJUST.WBT_ID

Work Adjustments (Retro)

WFMStandard

Work

Work Adjustments > Work Date

VIEW_PAYEXP_ADJUSTMENT.WRKD_WORK_DATE

Work Adjustments > Adjustment Date

VIEW_PAYEXP_ADJUSTMENT.WRKDA_ADJUST_DATE

Work Adjustments > Start Time

VIEW_PAYEXP_ADJUSTMENT.WRKD_START_TIME

Work Adjustments > End Time

VIEW_PAYEXP_ADJUSTMENT.WRKD_END_TIME

Work Adjustments > Is Authorized

VIEW_PAYEXP_ADJUSTMENT.WRKS_AUTHORIZED

Work Adjustments > Minutes

VIEW_PAYEXP_ADJUSTMENT.WRKD_MINUTES

Work Adjustments > Hours

VIEW_PAYEXP_ADJUSTMENT.WRKD_MINUTES / 60

Work Adjustments > Rate

VIEW_PAYEXP_ADJUSTMENT.WRKD_RATE

Work Adjustments > Cost

VIEW_PAYEXP_ADJUSTMENT.WRKD_MINUTES / 60 * VIEW_PAYEXP_ADJUSTMENT.WRKD_RATE

Work Adjustments > Foreign Keys > CALCGRP_ID

VIEW_PAYEXP_ADJUSTMENT.CALCGRP_ID

Work Adjustments > Foreign Keys > DEPT_ID

VIEW_PAYEXP_ADJUSTMENT.DEPT_ID

Work Adjustments > Foreign Keys > DOCK_ID

VIEW_PAYEXP_ADJUSTMENT.DOCK_ID

Work Adjustments > Foreign Keys > EMP_ID

VIEW_PAYEXP_ADJUSTMENT.EMP_ID

Work Adjustments > Foreign Keys > HTYPE_ID

VIEW_PAYEXP_ADJUSTMENT.HTYPE_ID

Work Adjustments > Foreign Keys > JOB_ID

VIEW_PAYEXP_ADJUSTMENT.JOB_ID

Work Adjustments > Foreign Keys > PAYGRP_ID

VIEW_PAYEXP_ADJUSTMENT.PAYGRP_ID

Work Adjustments > Foreign Keys > PETYP_ID

VIEW_PAYEXP_ADJUSTMENT.PETYP_ID

Work Adjustments > Foreign Keys > PROJ_ID

VIEW_PAYEXP_ADJUSTMENT.PROJ_ID

Work Adjustments > Foreign Keys > SHFT_ID

VIEW_PAYEXP_ADJUSTMENT.SHFT_ID

Work Adjustments > Foreign Keys > TCODE_ID

VIEW_PAYEXP_ADJUSTMENT.TCODE_ID

Work Adjustments > Foreign Keys > WBT_ID

VIEW_PAYEXP_ADJUSTMENT.WBT_ID

Work Day

WFMBurst

Burst Work

Work Day > Work Date

WORK_SUMMARY.WRKS_WORK_DATE

WFMStandard

Work

Work Day > Is Day Authorized

WORK_SUMMARY.WRKS_AUTHORIZED

Work Day > Is Worked Through Break

WORK_SUMMARY.WRKS_FLAG_BRK

WFMSystem

System Information > Errors and Exceptions

Work Day > Authorized By

WORK_SUMMARY.WRKS_AUTH_BY

Work Day > Authorized Date

WORK_SUMMARY.WRKS_AUTH_DATE

Work Day > Original Clock

WORK_SUMMARY.WRKS_ORIG_CLOCKS

Work Day > Clock

WORK_SUMMARY.WRKS_CLOCKS

Work Day > Comments

WORK_SUMMARY.WRKS_COMMENTS

Work Day > Hour Type Summary

WORK_SUMMARY.WRKS_HTYPE_SUM

Work Day > Time Code Summary

WORK_SUMMARY.WRKS_TCODE_SUM

Work Day > Work Summary UDFs > WRKS_FLAG?

WORK_SUMMARY.WRKS_FLAG?

Work Day > Work Summary UDFs > WRKS_UDF?

WORK_SUMMARY.WRKS_UDF?

Work Day > Keys > WRKS_ID

WORK_SUMMARY.WRKS_ID

Work Day > Foreign Keys > CALCGRP_ID

WORK_SUMMARY.CALCGRP_ID

Work Day > Foreign Keys > EATSTS_ID

WORK_SUMMARY.EATSTS_ID

Work Day > Foreign Keys > EMP_ID

WORK_SUMMARY.EMP_ID

Work Day > Foreign Keys > PAYGRP_ID

WORK_SUMMARY.PAYGRP_ID

Work Day > Foreign Keys > PETYP_ID

WORK_SUMMARY.PETYP_ID

Work Day > Foreign Keys > SHFT_ID

WORK_SUMMARY.SHFT_ID

Work Day with Clock Data

WFMStandard

Work

Work Day with Clock Data > Work Date

VIEW_PARSE_CLOCKS_MOD2.WRKS_WORK_DATE

Work Day with Clock Data > Clock Display Order

VIEW_PARSE_CLOCKS_MOD2.CLOCKS_ORDER

Work Day with Clock Data > Punch Type

VIEW_PARSE_CLOCKS_MOD2.CLKTRANTYPE_LOC_NM

Work Day with Clock Data > Punch Time

VIEW_PARSE_CLOCKS_MOD2.CLOCK_TIME

Work Day with Clock Data > Punch Data

VIEW_PARSE_CLOCKS_MOD2.CLOCK_DATA

Work Day with Clock Data > Is Day Authorized

VIEW_PARSE_CLOCKS_MOD2.WRKS_AUTHORIZED

Work Day with Clock Data > Time Code Summary

VIEW_PARSE_CLOCKS_MOD2.WRKS_TCODE_SUM

Work Day with Clock Data > Hour Type Summary

VIEW_PARSE_CLOCKS_MOD2.WRKS_HTYPE_SUM

Work Day with Clock Data > Work Summary UDFs > WRKS_FLAG?

VIEW_PARSE_CLOCKS_MOD2.WRKS_FLAG1?

Work Day with Clock Data > Work Summary UDFs > WRKS_UDF?

VIEW_PARSE_CLOCKS_MOD2.WRKS_UDF?

Work Day with Clock Data > Keys > WRKS_ID

VIEW_PARSE_CLOCKS_MOD2.WRKS_ID

Work Day with Clock Data > Foreign Keys > CALCGRP_ID

VIEW_PARSE_CLOCKS_MOD2.CALCGRP_ID

Work Day with Clock Data > Foreign Keys > EMP_ID

VIEW_PARSE_CLOCKS_MOD2.EMP_ID

Work Day with Clock Data > Foreign Keys > PAYGRP_ID

VIEW_PARSE_CLOCKS_MOD2.PAYGRP_ID

Work Day with Clock Data > Foreign Keys > SHFT_ID

VIEW_PARSE_CLOCKS_MOD2.SHFT_ID

Workbrain Group

WFMBurst

Burst Actual Results

Workbrain Group > Group Name

WORKBRAIN_GROUP.WBG_NAME

Burst Census

Workbrain Group > Keys > WBG_ID

WORKBRAIN_GROUP.WBG_ID

Burst Employee Information

Burst Forecasting

Burst Historical Payroll Cost

Burst Labor Budgeting

Burst Schedule Analysis

Burst Scheduling

Burst Staffing

Burst Work

Burst Work Schedule Aggregation

Workload Census

WFMStandard

Workload > Workload Census

Workload Census > Workload Census

ES_WORKLOAD_CENSUS.WLC_CENSUS

Workload Census > Workload Assessed

ES_WORKLOAD_CENSUS.WLC_PATIENT_COUNT

Workoad Census > Workload Census Date

ES_WORKLOAD_CENSUS.WLC_DATE

Workoad Census > Workload Census Last Updated Date

ES_WORKLOAD_CENSUS.WLC_LAST_UPDATED

Workload Census > Keys > WLC_ID

ES_WORKLOAD_CENSUS.WLC_ID

Workload Census > Foreign Keys > DP_ID

ES_WORKLOAD_CENSUS.DP_ID

Workload Census > Foreign Keys > WBT_ID

ES_WORKLOAD_CENSUS.WBT_ID

Workload Census > UDFs > WLC_FLAG?

ES_WORKLOAD_CENSUS.WLC_FLAG?

Workload Census > UDFs > WLC_UDF?

ES_WORKLOAD_CENSUS.WLC_UDF?

Workload Requirement

WFMStandard

Workload Requirement > Workload Requirement

Workload Requirement > Workload Requirement Date

ES_WORKLOAD_REQ.WLR_DATE

Workload Requirement > Workload Requirement in Minutes

ES_WORKLOAD_REQ.WLR_REQ

Workload Requirement > Workload Requirement Last Updated Date

ES_WORKLOAD_REQ.WLR_LAST_UPDATED

Workload Requirement > Keys > WLR_ID

ES_WORKLOAD_REQ.WLR_ID

Workload Requirement > Foreign Keys > DP_ID

ES_WORKLOAD_REQ.DP_ID

Workload Requirement > Foreign Keys > JOB_ID

ES_WORKLOAD_REQ.JOB_ID

Workload Requirement > Foreign Keys > WBT_ID

ES_WORKLOAD_REQ.WBT_ID

Workload Requirement > Foreign Keys > WRKLS_ID

ES_WORKLOAD_REQ.WRKLS_ID

Workload Requirement > UDFs > WLR_FLAG?

ES_WORKLOAD_REQ.WLR_FLAG?

Workload Requirement > UDFs > WLR_UDF?

ES_WORKLOAD_REQ.WLR_UDF?

Workload Source

WFMStandard

Workload Requirement > Workload Requirement

Workload Source > Workload Source Name

ES_WORKLOAD_SOURCE.WRKLS_NAME

Workload Source > Workload Source Description

ES_WORKLOAD_SOURCE.WRKLS_DESC

Workload Source > Keys > WRKLS_ID

ES_WORKLOAD_SOURCE.WRKLS_ID

Workload Source > UDFs > WRKLS_FLAG?

ES_WORKLOAD_SOURCE.WRKLS_FLAG?

Workload Source > UDFs > WRKLS_UDF?

ES_WORKLOAD_SOURCE.WRKLS_UDF?

Year Time Period

Query Subject Filter: Days between Start Date and End Date is > 300 days.

WFMBurst

Burst Labor Budgeting > Default Time Periods

Budgeting > Default Time Periods > Year Time Period > Year

FCST_TIME_PERIOD.FCTP_LOC_NAME

WFMStandard

Scheduling > Default Time Periods

Budgeting > Default Time Periods > Year Time Period > Year Description

FCST_TIME_PERIOD.FCTP_LOC_DESC

Budgeting > Default Time Periods > Year Time Period > Start Date

FCST_TIME_PERIOD.FCTP_START_DATE

Budgeting > Default Time Periods > Year Time Period > End Date

FCST_TIME_PERIOD.FCTP_END_DATE

Budgeting > Default Time Periods > Year Time Period > Keys > FCTP_ID

FCST_TIME_PERIOD.FCTP_ID

Budgeting > Default Time Periods > Year Time Period > Keys > FCTP_PARENT_ID

FCST_TIME_PERIOD.FCTP_PARENT_ID