| Boolean Values |
|
WFMStandard |
Report Helper Objects > Aggregation Tables |
Auto Prompt Generation Helper > Boolean Values >
Include Sub Teams (Y/N) |
select 'Y' as BOOL_VALS from WB_DUMMY UNION ALL select 'N'
as BOOL_VALS from WB_DUMMY |
|
|
|
|
|
|
| Calendar Date |
|
WFMBurst |
Burst Work Schedule Aggregation |
Calendar Date > Date |
DATE_VALUE.DTVAL_DATE |
|
|
|
Report Helper Objects |
Calendar Date > Month |
DATE_VALUE.DTVAL_MONTH |
|
|
WFMStandard |
Report Helper Objects > Aggregation Tables |
Calendar Date > Quarter |
DATE_VALUE.DTVAL_QUARTER |
|
|
|
|
Calendar Date > Year |
DATE_VALUE.DTVAL_YEAR |
|
|
|
|
Calendar Date > Day In Month |
DATE_VALUE.DTVAL_DAY_IN_MTH |
|
|
|
|
Calendar Date > Day In Quarter |
DATE_VALUE.DTVAL_DAY_IN_QTR |
|
|
|
|
Calendar Date > Day In Year |
DATE_VALUE.DTVAL_DAY_IN_YR |
|
|
|
|
Calendar Date > Week In Month |
DATE_VALUE.DTVAL_WK_IN_MTH |
|
|
|
|
Calendar Date > Week In Quarter |
DATE_VALUE.DTVAL_WK_IN_QTR |
|
|
|
|
Calendar Date > Week In Year |
DATE_VALUE.DTVAL_WK_IN_YR |
|
|
|
|
Calendar Date > Month In Quarter |
DATE_VALUE.DTVAL_MTH_IN_QTR |
|
|
|
|
Calendar Date > Calendar Date UDFs > DTVAL_FLAG?
|
DATE_VALUE.DTVAL_FLAG? |
|
|
|
|
Calendar Date > Calendar Date UDFs > DTVAL_UDF?
|
DATE_VALUE.DTVAL_UDF? |
|
|
|
|
|
|
| Day Week Starts |
Query Filter: Registry Name = 'DAY_WEEK_STARTS' |
WFMBurst |
Report Helper Objects |
Helper Objects > Day Week Starts > Registry Name
|
Registry and Overrides.Registry Name |
|
|
WFMStandard |
Report Helper Objects |
Helper Objects > Day Week Starts > Registry Value
|
Registry and Overrides.Registry Value |
|
|
|
|
|
|
| Display User Name |
Query Filter: WBU_ID = currently logged in user |
WFMStandard |
Report Helper Objects |
Display User Name > User Name |
WORKBRAIN_USER.WBU_NAME |
|
|
|
|
|
|
| LFSO Fiscal Year |
|
WFMStandard |
Report Helper Objects |
LFSO Fiscal Year > Fiscal Year |
SO_FISCAL_YEAR.FISCYR_YEAR |
|
|
|
LFSO Fiscal Year > Start Date |
SO_FISCAL_YEAR.START_DATE |
LFSO Fiscal Year > Start Date |
|
|
|
LFSO Fiscal Year > End Date |
SO_FISCAL_YEAR.END_DATE |
LFSO Fiscal Year > End Date |
|
|
|
LFSO Fiscal Year > Keys > SKDGRP_ID |
SO_FISCAL_YEAR.SKDGRP_ID |
LFSO Fiscal Year > Keys > SKDGRP_ID
|
|
|
|
|
|
|
| Localized Messages |
|
WFMStandard |
Report Helper Objects |
Localized Messages > WB Message Field
|
WORKBRAIN_MSG_LODA.WBMLDT_NAME |
|
|
|
|
Localized Messages > Localized Text |
WORKBRAIN_MSG_LODA.WBMLDT_TEXT |
|
|
|
|
|
|
| Location Hierarchy |
|
WFMStandard |
Report Helper Objects |
Location Hierarchy > Location Name |
SO_SCHEDULE_GROUP.SKDGRP_NAME (of child location)
|
|
|
|
|
Location Hierarchy > Internal Type |
SO_SCHEDULE_GROUP.SKDGRP_INTRNL_TYPE (of child location
|
|
|
|
|
Location Hierarchy > Level |
WORKBRAIN_TEAM.WBT_LEVEL (of child team)
|
|
|
|
|
Location Hierarchy > Keys > SKDGRP_ID
|
SO_SCHEDULE_GROUP.SKDGRP_ID (of child location)
|
|
|
|
|
Location Hierarchy > Keys > DISPLAY_ORDER
|
WORKBRAIN_TEAM.WBT_LFT (of child team) |
|
|
|
|
Location Hierarchy > Keys > SKDGRP_PARENT_ID
|
SO_SCHEDULE_GROUP.SKDGRP_ID (of parent location)
|
|
|
|
|
Location Hierarchy > Keys > WBT_ID
|
WORKBRAIN_TEAM.WBT_ID (of child team) |
|
|
|
|
|
|
| SecureEmployee |
|
WFMStandard |
Report Helper Objects |
SecureEmployee > Employee ID |
EMPLOYEE.EMP_NAME |
|
|
|
|
SecureEmployee > Full Name |
EMPLOYEE.EMP_FULLNAME |
|
|
|
|
SecureEmployee > Last Name |
EMPLOYEE.EMP_LASTNAME |
|
|
|
|
SecureEmployee > First Name |
EMPLOYEE.EMP_FIRSTNAME |
|
|
|
|
SecureEmployee > Birth Date |
EMPLOYEE.EMP_BIRTH_DATE |
|
|
|
|
SecureEmployee > Effective Date |
EMPLOYEE.EMP_EFFECTIVE_DATE |
|
|
|
|
SecureEmployee > FTE |
[EMPLOYEE].[EMP_FTE] |
|
|
|
|
SecureEmployee > Hire Date |
EMPLOYEE.EMP_HIRE_DATE |
|
|
|
|
SecureEmployee > Seniority Date |
EMPLOYEE.EMP_SENIORITY_DATE |
|
|
|
|
SecureEmployee > System Scheduling
Enabled |
EMPLOYEE.EMP_SYSTEM_SCHEDULING_ENABLED |
|
|
|
|
SecureEmployee > Termination Date |
EMPLOYEE.EMP_TERMINATION_DATE |
|
|
|
|
SecureEmployee > Default Minutes |
EMPLOYEE.EMP_DEF_MINUTES |
|
|
|
|
SecureEmployee > Shift Pattern Offset
|
EMPLOYEE.EMP_SHFTPAT_OFFSET |
|
|
|
|
SecureEmployee > SIN |
EMPLOYEE.EMP_SIN |
|
|
|
|
SecureEmployee > Status |
EMPLOYEE.EMP_STATUS |
|
|
|
|
SecureEmployee > Is Full Time |
EMPLOYEE.EMP_FULLTIME |
|
|
|
|
SecureEmployee > Base Rate |
EMPLOYEE.EMP_BASE_RATE |
|
|
|
|
SecureEmployee > Is Home Team |
WBI_SEC_EMP_BY_TEAM.EMPT_HOME_TEAM |
|
|
|
|
SecureEmployee > Employee UDFs > EMP_FLAG?
|
EMPLOYEE.EMP_FLAG? |
|
|
|
|
SecureEmployee > Employee UDFs > EMP_VAL?
|
EMPLOYEE.EMP_VAL? |
|
|
|
|
SecureEmployee > Keys > EMP_ID |
EMPLOYEE.EMP_ID |
|
|
|
|
SecureEmployee > Keys > WBT_ID |
WBI_SEC_EMP_BY_TEAM.WBT_ID |
|
|
|
|
SecureEmployee > Keys > TEAM_START_DATE
|
WBI_SEC_EMP_BY_TEAM.START_DATE |
|
|
|
|
SecureEmployee > Keys > TEAM_END_DATE
|
WBI_SEC_EMP_BY_TEAM.END_DATE |
|
|
|
|
SecureEmployee > Foreign Keys > SHFTPAT_ID
|
EMPLOYEE.SHFTPAT_ID |
|
|
|
|
SecureEmployee > Foreign Keys > CALCGRP_ID
|
EMPLOYEE.CALCGRP_ID |
|
|
|
|
SecureEmployee > Foreign Keys > PAYGRP_ID
|
EMPLOYEE.PAYGRP_ID |
|
|
|
|
|
|
| User Report Execution |
|
WFMRetail |
Report Helper Objects |
User Report Execution > WBU_ID |
WBI_USER_EXECUTION.WBU_ID |
|
|
|
|
User Report Execution > WBT_ID |
WBI_USER_EXECUTION.WBT_ID |
|
|
|
|
User Report Execution > EMP_ID |
WBI_USER_EXECUTION.EMP_ID |
|
|
|
|
User Report Execution > CGMAP_ID |
WBI_USER_EXECUTION.CGCRT_ID |
|
|
|
|
User Report Execution > CGCRT_ID |
WBI_USER_EXECUTION.CGMAP_ID |
|
|
|
|
User Report Execution > WUE_CAMPASSPRT_ID
|
WBI_USER_EXECUTION.WUE_CAMPASSPRT_ID |
|
|
|
|
User Report Execution > WBLL_ID |
WORKBRAIN_USER.WBLL_ID |
|
|
|
|
|
|
| Workbrain Group |
|
WFMRetail |
Report Helper Objects |
Workbrain Group > Group Name |
WORKBRAIN_GROUP.WBG_NAME |
|
|
|
|
Workbrain Group > Keys > WBG_ID |
WORKBRAIN_GROUP.WBG_ID |
|
|
|
|
|
|
| Workbrain User |
|
WFMRetail |
Report Helper Objects |
Workbrain User > User Name |
WORKBRAIN_USER.WBU_NAME |
|
|
|
|
Workbrain User > Ming.le Identifier |
WORKBRAIN_USER.WBU_IDENTITY2 |
|
|
|
|
Workbrain User > Keys > WBU_ID |
WORKBRAIN_USER.WBU_ID |
|
|
|
|
Workbrain User > Keys > WBG_ID |
WORKBRAIN_USER.WBG_ID |