Report helper objects
This topic lists all report helper objects in the WFMBurst, WFMRetail, WFMStandard, and WFMStandard packages. These queries are found under .
Boolean Values
| Metadata Model Reference | Database Reference |
|---|---|
| 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
| Metadata Model Reference | Database Reference |
|---|---|
| Date | DATE_VALUE.DTVAL_DATE |
| Month | DATE_VALUE.DTVAL_MONTH |
| Quarter | DATE_VALUE.DTVAL_QUARTER |
| Year | DATE_VALUE.DTVAL_YEAR |
| Day In Month | DATE_VALUE.DTVAL_DAY_IN_MTH |
| Day In Quarter | DATE_VALUE.DTVAL_DAY_IN_QTR |
| Day In Year | DATE_VALUE.DTVAL_DAY_IN_YR |
| Week In Month | DATE_VALUE.DTVAL_WK_IN_MTH |
| Week In Quarter | DATE_VALUE.DTVAL_WK_IN_QTR |
| Week In Year | DATE_VALUE.DTVAL_WK_IN_YR |
| Month In Quarter | DATE_VALUE.DTVAL_MTH_IN_QTR |
| Calendar Date UDFs > DTVAL_FLAG? | DATE_VALUE.DTVAL_FLAG? |
| Calendar Date UDFs > DTVAL_UDF? | DATE_VALUE.DTVAL_UDF? |
Day Week Starts
Query Filter: Registry Name = 'DAY_WEEK_STARTS'
| Metadata Model Reference | Database Reference |
|---|---|
| Registry Name | Registry and Overrides.Registry Name |
| Registry Value | Registry and Overrides.Registry Value |
Display User Name
Query Filter: WBU_ID = currently logged in user
| Metadata Model Reference | Database Reference |
|---|---|
| User Name | WORKBRAIN_USER.WBU_NAME |
LFSO Fiscal Year
| Metadata Model Reference | Database Reference |
|---|---|
| Fiscal Year | SO_FISCAL_YEAR.FISCYR_YEAR |
| Start Date | SO_FISCAL_YEAR.START_DATE |
| End Date | SO_FISCAL_YEAR.END_DATE |
| Keys > SKDGRP_ID | SO_FISCAL_YEAR.SKDGRP_ID |
Localized Messages
| Metadata Model Reference | Database Reference |
|---|---|
| WB Message Field | WORKBRAIN_MSG_LODA.WBMLDT_NAME |
| Localized Text | WORKBRAIN_MSG_LODA.WBMLDT_TEXT |
Location Hierarchy
| Metadata Model Reference | Database Reference |
|---|---|
| Location Name | SO_SCHEDULE_GROUP.SKDGRP_NAME (of child location) |
| Internal Type | SO_SCHEDULE_GROUP.SKDGRP_INTRNL_TYPE (of child location |
| Level | WORKBRAIN_TEAM.WBT_LEVEL (of child team) |
| Keys > SKDGRP_ID | SO_SCHEDULE_GROUP.SKDGRP_ID (of child location) |
| Keys > DISPLAY_ORDER | WORKBRAIN_TEAM.WBT_LFT (of child team) |
| Keys > SKDGRP_PARENT_ID | SO_SCHEDULE_GROUP.SKDGRP_ID (of parent location) |
| Keys > WBT_ID | WORKBRAIN_TEAM.WBT_ID (of child team) |
SecureEmployee
| Metadata Model Reference | Database Reference |
|---|---|
| Employee ID | EMPLOYEE.EMP_NAME |
| Full Name | EMPLOYEE.EMP_FULLNAME |
| Last Name | EMPLOYEE.EMP_LASTNAME |
| First Name | EMPLOYEE.EMP_FIRSTNAME |
| Birth Date | EMPLOYEE.EMP_BIRTH_DATE |
| Effective Date | EMPLOYEE.EMP_EFFECTIVE_DATE |
| FTE | [EMPLOYEE].[EMP_FTE] |
| Hire Date | EMPLOYEE.EMP_HIRE_DATE |
| Seniority Date | EMPLOYEE.EMP_SENIORITY_DATE |
| System Scheduling Enabled | EMPLOYEE.EMP_SYSTEM_SCHEDULING_ENABLED |
| Termination Date | EMPLOYEE.EMP_TERMINATION_DATE |
| Default Minutes | EMPLOYEE.EMP_DEF_MINUTES |
| Shift Pattern Offset | EMPLOYEE.EMP_SHFTPAT_OFFSET |
| SIN | EMPLOYEE.EMP_SIN |
| Status | EMPLOYEE.EMP_STATUS |
| Is Full Time | EMPLOYEE.EMP_FULLTIME |
| Base Rate | EMPLOYEE.EMP_BASE_RATE |
| Is Home Team | WBI_SEC_EMP_BY_TEAM.EMPT_HOME_TEAM |
| Employee UDFs > EMP_FLAG? | EMPLOYEE.EMP_FLAG? |
| Employee UDFs > EMP_VAL? | EMPLOYEE.EMP_VAL? |
| Keys > EMP_ID | EMPLOYEE.EMP_ID |
| Keys > WBT_ID | WBI_SEC_EMP_BY_TEAM.WBT_ID |
| Keys > TEAM_START_DATE | WBI_SEC_EMP_BY_TEAM.START_DATE |
| Keys > TEAM_END_DATE | WBI_SEC_EMP_BY_TEAM.END_DATE |
| Foreign Keys > SHFTPAT_ID | EMPLOYEE.SHFTPAT_ID |
| Foreign Keys > CALCGRP_ID | EMPLOYEE.CALCGRP_ID |
| Foreign Keys > PAYGRP_ID | EMPLOYEE.PAYGRP_ID |
User Report Execution
| Metadata Model Reference | Database Reference |
|---|---|
| WBU_ID | WBI_USER_EXECUTION.WBU_ID |
| WBT_ID | WBI_USER_EXECUTION.WBT_ID |
| EMP_ID | WBI_USER_EXECUTION.EMP_ID |
| CGMAP_ID | WBI_USER_EXECUTION.CGCRT_ID |
| CGCRT_ID | WBI_USER_EXECUTION.CGMAP_ID |
| WUE_CAMPASSPRT_ID | WBI_USER_EXECUTION.WUE_CAMPASSPRT_ID |
| WBLL_ID | WORKBRAIN_USER.WBLL_ID |
Workbrain Group
| Metadata Model Reference | Database Reference |
|---|---|
| Group Name | WORKBRAIN_GROUP.WBG_NAME |
| Keys > WBG_ID | WORKBRAIN_GROUP.WBG_ID |
Workbrain User
| Metadata Model Reference | Database Reference |
|---|---|
| User Name | WORKBRAIN_USER.WBU_NAME |
| Ming.le Identifier | WORKBRAIN_USER.WBU_IDENTITY2 |
| Keys > WBU_ID | WORKBRAIN_USER.WBU_ID |
| Keys > WBG_ID | WORKBRAIN_USER.WBG_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.
| Metadata model reference | Database reference |
|---|---|
| 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' )# ) ) |