Query subjects T to Z
Team
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.
| Metadata model reference | Database reference |
|---|---|
| Team Name | WORKBRAIN_TEAM.WBT_NAME |
| Day Start Time | [WORKBRAIN_TEAM].[WBT_DAY_START_TIME] |
| Team Description | WORKBRAIN_TEAM.WBT_DESC |
| Team Level | WORKBRAIN_TEAM.WBT_LEVEL |
| Day Start Time | [WORKBRAIN_TEAM].[WBT_DAY_START_TIME] |
| Team UDFs > WBT_FLAG? | WORKBRAIN_TEAM.WBT_FLAG? |
| Day Start Time | [WORKBRAIN_TEAM].[WBT_DAY_START_TIME] |
| Day Start Time | [WORKBRAIN_TEAM].[WBT_DAY_START_TIME] |
| Day Start Time | [WORKBRAIN_TEAM].[WBT_DAY_START_TIME] |
| Day Start Time | [WORKBRAIN_TEAM].[WBT_DAY_START_TIME] |
| Day Start Time | [WORKBRAIN_TEAM].[WBT_DAY_START_TIME] |
| Team UDFs > WBT_UDF? | WORKBRAIN_TEAM.WBT_UDF? |
| Day Start Time | [WORKBRAIN_TEAM].[WBT_DAY_START_TIME] |
| Keys > WBT_ID | WORKBRAIN_TEAM.WBT_ID |
| Keys > WBT_PARENT_ID | WORKBRAIN_TEAM.WBT_PARENT_ID |
| Day Start Time | [WORKBRAIN_TEAM].[WBT_DAY_START_TIME] |
| Keys > WBUT_START_DATE | SEC_WORKBRAIN_TEAM.WBUT_START_DATE |
| Day Start Time | [WORKBRAIN_TEAM].[WBT_DAY_START_TIME] |
| Keys > WBUT_END_DATE | SEC_WORKBRAIN_TEAM.WBUT_END_DATE |
| Day Start Time | [WORKBRAIN_TEAM].[WBT_DAY_START_TIME] |
| Foreign Keys > CURRENT_TIMESTAMP | CURRENT_TIMESTAMP |
| Day Start Time | [WORKBRAIN_TEAM].[WBT_DAY_START_TIME] |
| Day Start Time | [WORKBRAIN_TEAM].[WBT_DAY_START_TIME] |
| Day Start Time | [WORKBRAIN_TEAM].[WBT_DAY_START_TIME] |
| 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.
| Metadata model reference | Database reference |
|---|---|
| Team Name | SEC_WB_TEAM_PROMPT.WBT_NAME |
| Day Start Time | [SEC_WB_TEAM_PROMPT].[WBT_DAY_START_TIME |
| Team Description | SEC_WB_TEAM_PROMPT.WBT_DESC |
| Day Start Time | [SEC_WB_TEAM_PROMPT].[WBT_DAY_START_TIME] |
| Team Level | SEC_WB_TEAM_PROMPT.WBT_LEVEL |
| Day Start Time | [WORKBRAIN_TEAM_PROMPT].[WBT_DAY_START_TIME] |
| Team UDFs > WBT_FLAG? | SEC_WB_TEAM_PROMPT.WBT_FLAG? |
| Day Start Time | [SEC_WB_TEAM_PROMPT].[WBT_DAY_START_TIME] |
| Team UDFs > WBT_UDF? | SEC_WB_TEAM_PROMPT.WBT_UDF? |
| Day Start Time | [SEC_WB_TEAM_PROMPT].[WBT_DAY_START_TIME] |
| Keys > WBT_ID | SEC_WB_TEAM_PROMPT.WBT_ID |
| Day Start Time | [WORKBRAIN_TEAM_PROMPT].[WBT_DAY_START_TIME] |
| Keys > WBUT_START_DATE | SEC_WB_TEAM_PROMPT.WBUT_START_DATE |
| Day Start Time | [SEC_WB_TEAM_PROMPT].[WBT_DAY_START_TIME] |
| Keys > WBUT_END_DATE | SEC_WB_TEAM_PROMPT.WBUT_END_DATE |
| Day Start Time | [WORKBRAIN_TEAM_PROMPT].[WBT_DAY_START_TIME] |
| Foreign Keys > Current_Timestamp | current_timestamp |
| Day Start Time | [WORKBRAIN_TEAM_PROMPT].[WBT_DAY_START_TIME] |
| Day Start Time | [WORKBRAIN_TEAM_PROMPT].[WBT_DAY_START_TIME] |
| Day Start Time | [WORKBRAIN_TEAM_PROMPT].[WBT_DAY_START_TIME] |
| Foreign Keys > WBTT_ID | SEC_WB_TEAM_PROMPT.WBTT_ID |
| Day Start Time | [SEC_WB_TEAM_PROMPT].[WBT_DAY_START_TIME] |
Team Schedule Period
| Metadata model reference | Database reference |
|---|---|
| Apply to Sub Team | TEAM_SCHPRD.TMSCPR_APL_SUBTM |
| Shift Team Schedule Period Editable | TEAM_SCHPRD.TMSCPR_EDITABLE |
| Keys > TMSCPR_ID | TEAM_SCHPRD.TMSCPR_ID |
| Foreign Keys > SCPR_ID | TEAM_SCHPRD.SCPR_ID |
| Foreign Keys > WBT_ID | TEAM_SCHPRD.WBT_ID |
| UDFs > TMSCPR_FLAG? | TEAM_SCHPRD.TMSCPR_FLAG? |
| UDFs > TMSCPR_UDF? | TEAM_SCHPRD.TMSCPR_UDF? |
Teams with Inherited Shifts
| Metadata model reference | Database reference |
|---|---|
| Subscription Team Name | WORKBRAIN_TEAM for ES_SHIFT_TEAM.WBT_NAME |
| Subscription Team Description | WORKBRAIN_TEAM for ES_SHIFT_TEAM.WBT_DESC |
| Subscription Start Date | ES_SHIFT_TEAM.ESSHTM_EFF_START_DATE |
| Subscription End Date | ES_SHIFT_TEAM.ESSHTM_EFF_END_DATE |
| Keys > ESSHTM_ID | ES_SHIFT_TEAM.ESSHTM_ID |
| Foreign Keys > ESSHIFT_ID | ES_SHIFT_TEAM.ESSHIFT_ID |
| Foreign Keys > WBT_ID | ES_SHIFT_TEAM.WBT_ID |
Template Schedule
| Metadata model reference | Database reference |
|---|---|
| Template Schedule Start Date | ES_TMPL_SCHEDULE_GEN.TMPLSCHD_START_DATE |
| Template Schedule End Date | ES_TMPL_SCHEDULE_GEN.TMPLSCHD_END_DATE |
| Is Publish Assigned | ES_TMPL_SCHEDULE_GEN.TMPLSCHD_PUBLISH_ASSN |
| Is To Relief Queue | ES_TMPL_SCHEDULE_GEN.TMPLSCHD_TO_RELIEFQUEUE |
| Is To Self-Schedule Engine | ES_TMPL_SCHEDULE_GEN.TMPLSCHD_TO_SELF_SCHEDULE |
| Is Publish Unassigned | ES_TMPL_SCHEDULE_GEN.TMPLSCHD_PUBLISH_UNASSN |
| Template Schedule Workload | ES_TMPL_SCHEDULE_GEN.TMPLSCHD_GEN_WORKLOAD |
| Keys > TMPLSCHD_ID | ES_TMPL_SCHEDULE_GEN.TMPLSCHD_ID |
| Foreign Keys > TMPL_ID | ES_TMPL_SCHDGEN_TEMPLATE.TMPL_ID |
Template Type
| Metadata model reference | Database reference |
|---|---|
| Template Type Name | ES_TMPL_TYPE.TMPLTYP_NAME |
| Template Type Description | ES_TMPL_TYPE.TMPLTYP_DESC |
| UDFs > TMPLTYP_FLAG? | ES_TMPL_TYPE.TMPLTYP_FLAG? |
| UDFs > TMPLTYP_UDF? | ES_TMPL_TYPE.TMPLTYP_UDF? |
| Keys > TMPLTYP_ID | ES_TMPL_TYPE.TMPLTYP_ID |
Time Code
| Metadata model reference | Database reference |
|---|---|
| Time Code Name | TIME_CODE.TCODE_LOC_NAME |
| Time Code Description | TIME_CODE.TCODE_LOC_DESC |
| Time Code YAG | TIME_CODE.TCODE_YAG |
| Is Break | TIME_CODE.TCODE_IS_BRK |
| Is Irregular | if (TIME_CODE.TCODE_IRREGULAR is null) then ('N') else TIME_CODE.TCODE_IRREGULAR) |
| Is Productive | TIME_CODE.TCODE_RPT_ISPRDCTV |
| Exclude from Total Hours | TIME_CODE.TCODE_IS_EXCLD_TTL |
| Is LTA | TIME_CODE.TCODE_IS_LTA |
| Is Controllable Absence | TIME_CODE_CONTROLLABLE.IS_CONTROLLABLE |
| Is Uncontrollable Absence | TIME_CODE_UNCONTROLLABLE.IS_UNCONTROLLABLE |
| Time Code Flags > TCODE_FLAG? | TIME_CODE.TCODE_FLAG? |
| Time Code UDFs > TCODE_UDF? | TIME_CODE.TCODE_UDF? |
| Keys > TCODE_ID | TIME_CODE.TCODE_ID |
| Keys > TCODE_NAME | TIME_CODE.TCODE_NAME |
Time Code Controllable
| Metadata model reference | Database reference |
|---|---|
| Is Controllable Absence | case when TIME_CODE_DATA.TCDATA_VALUE = 'Y' then 'Y' else 'N' end TCDATA_VALUE |
| TCODE_ID | TIME_CODE_DATA.TCODE_ID |
Time Code Uncontrollable
| Metadata model reference | Database reference |
|---|---|
| Is Uncontrollable Absence | case when TIME_CODE_DATA.TCDATA_VALUE = 'Y' then 'Y' else 'N' end TCDATA_VALUE |
| TCODE_ID | TIME_CODE_DATA.TCODE_ID |
Transactions
| Metadata model reference | Database reference |
|---|---|
| Interface Name | WBINT_TRANSACTION.WBITYP_NAME |
| Filename | WBINT_TRANSACTION.WBITRAN_FILENAME |
| Transaction Type | WBINT_TYPE.WBITYP_TYPE |
| Create Date/Time | WBINT_TRANSACTION.WBITRAN_CREATE_DT |
| Start Date/Time | WBINT_TRANSACTION.WBITRAN_START_DATE |
| End Date/Time | WBINT_TRANSACTION.WBITRAN_END_DATE |
| Status | WBINT_TRANSACTION.WBITRAN_STATUS |
| Keys > WBITRAN_ID | WBINT_TRANSACTION.WBITRAN_ID |
User
| Metadata model reference | Database reference |
|---|---|
| User Name | WORKBRAIN_USER.WBU_NAME |
| WORKBRAIN_USER.WBU_EMAIL | |
| Is Active | WORKBRAIN_USER.WBU_ACTIVE |
| Bad Login Count | WORKBRAIN_USER.WBU_BAD_LOGIN_COUN |
| Language | WORKBRAIN_LANGUAGE.WBL_NAME |
| Locale | WORKBRAIN_LANGUAGE.WBL_LOCALE |
| Ming.le Identifier | WORKBRAIN_USER.WBU_IDENTITY2 |
| Workbrain User UDFs > WBU_FLAG? | WORKBRAIN_USER.WBU_FLAG? |
| Workbrain User UDFs > WBU_UDF? | WORKBRAIN_USER.WBU_UDF? |
| Keys > EMP_ID | WORKBRAIN_USER.EMP_ID |
| Keys > WBU_ID | WORKBRAIN_USER.WBU_ID |
| Foreign Keys > WBG_ID | WORKBRAIN_USER.WBG_ID |
User (Actual Submitter)
| Metadata model reference | Database reference |
|---|---|
| User Name | WORKBRAIN_USER.WBU_NAME |
| WORKBRAIN_USER.WBU_EMAIL | |
| Is Active | WORKBRAIN_USER.WBU_ACTIVE |
| Bad Login Count | WORKBRAIN_USER.WBU_BAD_LOGIN_COUN |
| Language | WORKBRAIN_LANGUAGE.WBL_NAME |
| Locale | WORKBRAIN_LANGUAGE.WBL_LOCALE |
| Ming.le Identifier | WORKBRAIN_USER.WBU_IDENTITY2 |
| Keys > EMP_ID | WORKBRAIN_USER.EMP_ID |
| Keys > WBU_ID | WORKBRAIN_USER.WBU_ID |
| UDFs > WBU_FLAG? | WORKBRAIN_USER.WBU_FLAG? |
| UDFs > WBU_UDF? | WORKBRAIN_USER.WBU_UDF? |
User (Approver)
| Metadata model reference | Database reference |
|---|---|
| User Name | WORKBRAIN_USER.WBU_NAME |
| WORKBRAIN_USER.WBU_EMAIL | |
| Is Active | WORKBRAIN_USER.WBU_ACTIVE |
| Bad Login Count | WORKBRAIN_USER.WBU_BAD_LOGIN_COUN |
| Language | WORKBRAIN_LANGUAGE.WBL_NAME |
| Locale | WORKBRAIN_LANGUAGE.WBL_LOCALE |
| Ming.le Identifier | WORKBRAIN_USER.WBU_IDENTITY2 |
| Keys > EMP_ID | WORKBRAIN_USER.EMP_ID |
| Keys > WBU_ID | WORKBRAIN_USER.WBU_ID |
| UDFs > WBU_FLAG? | WORKBRAIN_USER.WBU_FLAG? |
| UDFs > WBU_UDF? | WORKBRAIN_USER.WBU_UDF? |
User (Submitter)
| Metadata model reference | Database reference |
|---|---|
| User Name | WORKBRAIN_USER.WBU_NAME |
| WORKBRAIN_USER.WBU_EMAIL | |
| Is Active | WORKBRAIN_USER.WBU_ACTIVE |
| Bad Login Count | WORKBRAIN_USER.WBU_BAD_LOGIN_COUN |
| Language | WORKBRAIN_LANGUAGE.WBL_NAME |
| Locale | WORKBRAIN_LANGUAGE.WBL_LOCALE |
| Ming.le Identifier | WORKBRAIN_USER.WBU_IDENTITY2 |
| Keys > EMP_ID | WORKBRAIN_USER.EMP_ID |
| Keys > WBU_ID | WORKBRAIN_USER.WBU_ID |
| UDFs > WBU_FLAG? | WORKBRAIN_USER.WBU_FLAG? |
| UDFs > WBU_UDF? | WORKBRAIN_USER.WBU_UDF? |
User Aggregated Work
| Metadata model reference | Database reference |
|---|---|
| Date | AGG_USER_WORK.AGUSR_WRK_DATE |
| Scheduled Minutes | AGG_USER_WORK.AGUSR_SD_MIN |
| Scheduled REG Minutes | AGG_USER_WORK.AGUSR_SD_REG_MIN |
| Scheduled OT Minutes | AGG_USER_WORK.AGUSR_SD_OT_MIN |
| Scheduled Productive Minutes | AGG_USER_WORK.AGUSR_SD_PRDTV_MIN |
| Scheduled Absent Minutes | AGG_USER_WORK.AGUSR_SD_ABS_MIN |
| Scheduled Exception Minutes | AGG_USER_WORK.AGUSR_SD_EXPT_MIN |
| Scheduled Rate | AGG_USER_WORK.AGUSR_SD_RATE |
| Worked Minutes | AGG_USER_WORK.AGUSR_WD_MIN |
| Worked REG Minutes | AGG_USER_WORK.AGUSR_WD_REG_MIN |
| Worked OT Minutes | AGG_USER_WORK.AGUSR_WD_OT_MIN |
| Worked Productive Minutes | AGG_USER_WORK.AGUSR_WD_PRDTV_MIN |
| Worked Absent Minutes | AGG_USER_WORK.AGUSR_WD_ABS_MIN |
| Worked Exception Minutes | AGG_USER_WORK.AGUSR_WD_EXPT_MIN |
| Worked Rate | AGG_USER_WORK.AGUSR_WD_RATE |
| Data Aggregation Date | AGG_USER_WORK.AGUSR_DATA_ASOF |
| User Aggregated Work Custom Facts > AGUSR_FACT? | AGG_USER_WORK.AGUSR_FACT? |
| User Aggregated Work Custom Facts > AGUSR_UDF? | AGG_USER_WORK.AGUSR_UDF? |
| Keys > AGUSR_CAMPASSPRT_ID | AGG_USER_WORK.AGUSR_CAMPASSPRT_ID |
| Keys > CGCRT_ID | AGG_USER_WORK.CGCRT_ID |
| Keys > CGMAP_ID | AGG_USER_WORK.CGMAP_ID |
| Keys > WBU_ID | AGG_USER_WORK.WBU_ID |
| Foreign Keys > CALCGRP_ID | AGG_USER_WORK.CALCGRP_ID |
| Foreign Keys > DEPT_ID | AGG_USER_WORK.DEPT_ID |
| Foreign Keys > DOCK_ID | AGG_USER_WORK.DOCK_ID |
| Foreign Keys > EMP_ID | AGG_USER_WORK.EMP_ID |
| Foreign Keys > HTYPE_ID | AGG_USER_WORK.HTYPE_ID |
| Foreign Keys > JOB_ID | AGG_USER_WORK.JOB_ID |
| Foreign Keys > PAYGRP_ID | AGG_USER_WORK.PAYGRP_ID |
| Foreign Keys > PROJ_ID | AGG_USER_WORK.PROJ_ID |
| Foreign Keys > TCODE_ID | AGG_USER_WORK.TCODE_ID |
| Foreign Keys > WBT_ID | AGG_USER_WORK.WBT_ID |
User Logins
| Metadata model reference | Database reference |
|---|---|
| User Name | COGIPF_USERLOGON.USERNAME |
| Logon Time | COGIPF_USERLOGON.TIME STAMP |
| Session ID | COGIPF_USERLOGON.SESSION ID |
| Logoff Operation | COGIPF_USERLOGOFF.LOGOFF OPERATION |
| Logoff Time | COGIPF_USERLOGOFF.TIME STAMP |
| Session Duration | User Logins.Logoff Time - User Logins.Logon Time |
User Session
| Metadata model reference | Database reference |
|---|---|
| Session Date | WORKBRAIN_USRSESN.WBUS_DATE |
| Login Date | WORKBRAIN_USRSESN.WBUS_LOGIN_AT_DATE |
| Logout Date | WORKBRAIN_USRSESN.WBUS_LOGOUT_AT_DT |
| IP Address | WORKBRAIN_USRSESN.WBUS_IP |
| Status | WORKBRAIN_USRSESN.WBUS_STATUS |
| Keys > WBUS_ID | WORKBRAIN_USRSESN.WBUS_ID |
| Keys > WBU_NAME | WORKBRAIN_USRSESN.WBU_NAME |
| Foreign Keys > WBUSDN_ID | WORKBRAIN_USRSESN.WBUSDN_ID |
User Session Domain
| Metadata model reference | Database reference |
|---|---|
| Domain Name | WORKBRAIN_USER_SESSION_DOMAIN.WBUSDN_NAME |
| Domain Description | WORKBRAIN_USER_SESSION_DOMAIN.WBUSDN_DESC |
| Keys > WBUSDN_ID | WORKBRAIN_USER_SESSION_DOMAIN.WBUSDN_ID |
View Reports
| Metadata model reference | Database reference |
|---|---|
| User Name | COGIPF_USERLOGON.USERNAME |
| Report Name | "if (COGIPF_VIEWREPORT.REPORT PATH = 'null' ) then ('Unsaved report') else if (COGIPF_VIEWREPORT.REPORT PATH = '') then ('Unsaved report') else if ( position('/report', COGIPF_VIEWREPORT.REPORT PATH)>0) then (substring (COGIPF_VIEWREPORT.REPORT PATH, position('/report', COGIPF_VIEWREPORT.REPORT PATH)+15, position('', substring (COGIPF_VIEWREPORT.REPORT PATH, position('/report', COGIPF_VIEWREPORT.REPORT PATH)+15)) -2)) else if ( position('/interactiveReport', COGIPF_VIEWREPORT.REPORT PATH)>0) then (substring (COGIPF_VIEWREPORT.REPORT PATH, position('/interactiveReport', COGIPF_VIEWREPORT.REPORT PATH)+26, position('', substring (COGIPF_VIEWREPORT.REPORT PATH, position('/interactiveReport', COGIPF_VIEWREPORT.REPORT PATH)+26)) -2)) else ('Unsaved report')" |
| Report Type | upper(substring (COGIPF_VIEWREPORT.TARGET TYPE , 1, 1) )+ lower(substring(COGIPF_VIEWREPORT.TARGET TYPE , 2, character_length(COGIPF_VIEWREPORT.TARGET TYPE ) - 1)) |
| Report Format | if (COGIPF_VIEWREPORT.REPORT FORMAT = 'SearchResult for COGIPF_REPORTFORMAT') then ('Format unspecified') else (COGIPF_VIEWREPORT.REPORT FORMAT ) |
| Report Search Path | trim (COGIPF_VIEWREPORT.REPORT PATH) |
| Time Stamp | COGIPF_VIEWREPORT.TIME STAMP |
| Error Details | COGIPF_VIEWREPORT.ERROR DETAILS |
| Package | "if (COGIPF_VIEWREPORT.PACKAGE = 'null') then (' ') else if (COGIPF_VIEWREPORT.PACKAGE = '' ) then (' ') else if(position('/package', COGIPF_VIEWREPORT.PACKAGE)>0) then(substring (COGIPF_VIEWREPORT.PACKAGE, position('/package', COGIPF_VIEWREPORT.PACKAGE)+16, position('', substring (COGIPF_VIEWREPORT.PACKAGE, position('/package', COGIPF_VIEWREPORT.PACKAGE)+16))-2) ) else (substring (COGIPF_VIEWREPORT.PACKAGE , 1, character_length( COGIPF_VIEWREPORT.PACKAGE)))" |
| Status | upper(substring (COGIPF_VIEWREPORT.STATUS , 1, 1) )+ lower(substring(COGIPF_VIEWREPORT.STATUS , 2, character_length(COGIPF_VIEWREPORT.STATUS ) - 1)) |
Violation Definition
| Metadata model reference | Database reference |
|---|---|
| Violation Name | AC_VIOLATION.ACVIOL_NAME |
| Violation Description | AC_VIOLATION.ACVIOL_DESC |
| Eligible Event Names | AC_VIOLATION.ACVIOL_ACEVT_NAMES |
| Elgible Teams | AC_VIOLATION.WBT_NAMES |
| Sub team Eligibility | AC_VIOLATION.ACVIOL_APPLY_SUBTM |
| Eligible Employees | AC_VIOLATION.ACVIOL_EMP_NAMES |
| Eligible Calc Groups | AC_VIOLATION.ACVIOL_CALCGRP_NAMES |
| Eligible Pay Groups | AC_VIOLATION.ACVIOL_PAYGRP_NAMES |
| Period Type Name | AC_PERIOD_TYPE.ACPERTYP_NAME |
| Period Type Description | AC_PERIOD_TYPE.ACPERTYP_DESC |
| Threshold Points | AC_VIOLATION.ACVIOL_THRESHOLD_POINTS |
| Exclude Counted Events | AC_VIOLATION.ACVIOL_EXCLUDE |
| Ignore Authorized | AC_VIOLATION.ACVIOL_IGNORE |
| Violation Definition UDFs > ACVIOL_EMP_VAL?S | AC_VIOLATION.ACVIOL_EMP_VAL?S |
| Violation Definition UDFs > ACVIOL_FLAG? | AC_VIOLATION.ACVIOL_FLAG? |
| Violation Definition UDFs > ACVIOL_UDF1? | AC_VIOLATION.ACVIOL_UDF? |
| Keys > ACVIOL_ID | AC_VIOLATION.ACVIOL_ID |
| Keys > ACPERTYP_ID | AC_VIOLATION.ACPERTYP_ID |
Violation Log Entry
| Metadata model reference | Database reference |
|---|---|
| Violation Name | AC_VIOLATION.ACVIOL_NAME |
| Work Date | AC_VIOLATION_LOG.ACVIOLOG_WORK_DATE |
| User | AC_VIOLATION_LOG.WBU_NAME |
| Actual User | AC_VIOLATION_LOG.WBU_NAME_ACTUAL |
| Log Date | AC_VIOLATION_LOG.ACVIOLOG_DATE |
| Employee Reason | AC_VIOLATION_LOG.ACVIOLOG_EMP_REASON |
| Notified By | AC_VIOLATION_LOG.ACVIOLOG_NOTifIED_BY |
| Notification Date | AC_VIOLATION_LOG.ACVIOLOG_NOTifIED_DATE |
| Authorized By | AC_VIOLATION_LOG.ACVIOLOG_AUTH_BY |
| Authorization Date | AC_VIOLATION_LOG.ACVIOLOG_AUTH_DATE |
| Supervisor Notes | AC_VIOLATION_LOG.ACVIOLOG_SUPER_NOTES |
| Status | AC_VIOLATION_LOG.ACVIOLOG_STATUS |
| Comments | AC_VIOLATION_LOG.ACVIOLOG_COMMENTS |
| Keys > ACVIOLOG_ID | AC_VIOLATION_LOG.ACVIOLOG_ID |
| Foreign Keys > ACVIOL_ID | AC_VIOLATION_LOG.ACVIOL_ID |
| Foreign Keys > EMP_ID | AC_VIOLATION_LOG.EMP_ID |
Volume Workload
| Metadata model reference | Database reference |
|---|---|
| Volume Per Hour | SO_VOLUME_WORKLOAD.WRKLD_STDVOL_HOUR |
| Keys > SKDGRP_ID | SO_VOLUME_WORKLOAD.SKDGRP_ID |
Week Time Period
| Metadata model reference | Database reference |
|---|---|
| Week | FCST_TIME_PERIOD.FCTP_LOC_NAME |
| Week Description | FCST_TIME_PERIOD.FCTP_LOC_DESC |
| Start Date | FCST_TIME_PERIOD.FCTP_START_DATE |
| End Date | FCST_TIME_PERIOD.FCTP_END_DATE |
| Keys > FCTP_ID | FCST_TIME_PERIOD.FCTP_ID |
| Keys > FCTP_PARENT_ID | FCST_TIME_PERIOD.FCTP_PARENT_ID |
Work
Under . Fact table containing work metrics.
| Metadata model reference | Database reference |
|---|---|
| Break Hours | WORK_DETAIL.BREAK_MINUTES / 60 |
| Estimated Payroll Cost | WORK_DETAIL.AVG_HOURLY_RATE * WORK_DETAIL.TOTAL_MINUTES / 60 |
| Overtime Work Hours | WORK_DETAIL.OT_MINUTES / 60 |
| Paid Hours | WORK_DETAIL.PAID_MINUTES / 60 |
| Paid Time Off Hours | WORK_DETAIL.PAID_TIME_OFF_MINUTES / 60 |
| Productive Work Hours | WORK_DETAIL.PRDCTV_MINUTES / 60 |
| Total Work Hours | WORK_DETAIL.TOTAL_MINUTES / 60 |
| Keys > EMP_ID | WORK_SUMMARY.EMP_ID |
| Keys > WBT_ID | WORK_DETAIL.WBT_ID |
| Keys > WRKS_WORK_DATE | WORK_DETAIL.WRKS_WORK_DATE |
Work
WFMBurst Work
WFMStandard Work
WFMSystem System Information > Errors and Exceptions
| Metadata model reference | Database reference |
|---|---|
| Work Date | WORK_DETAIL.WRKD_WORK_DATE |
| Time Code | TIME_CODE.TCODE_LOC_NAME |
| Bad Quantity | WORK_DETAIL.WRKD_BAD_QUANTITY |
| WRKD_BAD_QTY_RSNCD_ID | WORK_DETAIL.WRKD_BAD_QTY_RSNCD_ID |
| Hour Type | HOUR_TYPE.HTYPE_LOC_NAME |
| Start Time | WORK_DETAIL.WRKD_START_TIME |
| End Time | WORK_DETAIL.WRKD_END_TIME |
| Work Detail Type | WORK_DETAIL.WRKD_TYPE |
| Cost | (WORK_DETAIL.WRKD_MINUTES /60) * WORK_DETAIL.WRKD_RATE |
| Rate | WORK_DETAIL.WRKD_RATE |
| Minutes | WORK_DETAIL.WRKD_MINUTES |
| Hours | WORK_DETAIL.WRKD_MINUTES / 60 |
| Quantity | if ( WORK_DETAIL.WRKD_QUANTITY=-1000 ) then ( 0 ) else ( WORK_DETAIL.WRKD_QUANTITY ) |
| Overtime Minutes | if ( HOUR_TYPE.HTYPE_RPT_ISOT ='Y' ) then ( WORK_DETAIL.WRKD_MINUTES ) else ( 0 ) |
| Overtime Hours | if ( HOUR_TYPE.HTYPE_RPT_ISOT ='Y' ) then ( WORK_DETAIL.WRKD_MINUTES /60 ) else ( 0 ) |
| Exception Minutes | if (TIME_CODE.TCODE_IRREGULAR = 'Y') then ( WORK_DETAIL.WRKD_MINUTES ) else ( 0 ) |
| Exception Hours | if (TIME_CODE.TCODE_IRREGULAR = 'Y') then ( WORK_DETAIL.WRKD_MINUTES / 60 ) else ( 0 ) |
| Productive Minutes | if ( TIME_CODE.TCODE_RPT_ISPRDCTV ='Y' ) then ( WORK_DETAIL.WRKD_MINUTES ) else ( 0 ) |
| Productive Hours | if ( TIME_CODE.TCODE_RPT_ISPRDCTV ='Y' ) then ( WORK_DETAIL.WRKD_MINUTES /60 ) else ( 0 ) |
| Absent Minutes | if (TIME_CODE.TCODE_IS_LTA = 'Y' ) then ( WORK_DETAIL.WRKD_MINUTES ) else ( 0 ) |
| Absent Hours | if ( TIME_CODE.TCODE_IS_LTA = 'Y' ) then ( WORK_DETAIL.WRKD_MINUTES / 60 ) else ( 0 ) |
| 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) |
| 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 ) |
| Is Authorized | WORK_DETAIL.WRKD_AUTH |
| Authorized By | WORK_DETAIL.WRKD_AUTH_BY |
| Authorization Date | WORK_DETAIL.WRKD_AUTH_DATE |
| Comments | WORK_DETAIL.WRKD_COMMENTS |
| Work Detail UDFs > WRKD_UDF? | WORK_DETAIL.WRKD_UDF? |
| Work Detail UDFs > WRKD_FLAG? | WORK_DETAIL.WRKD_FLAG? |
| Keys > WRKD_ID | WORK_DETAIL.WRKD_ID |
| Foreign Keys > DEPT_ID | WORK_DETAIL.DEPT_ID |
| Foreign Keys > DOCK_ID | WORK_DETAIL.DOCK_ID |
| Foreign Keys > HTYPE_ID | WORK_DETAIL.HTYPE_ID |
| Foreign Keys > JOB_ID | WORK_DETAIL.JOB_ID |
| Foreign Keys > PROJ_ID | WORK_DETAIL.PROJ_ID |
| Foreign Keys > TCODE_ID | WORK_DETAIL.TCODE_ID |
| Foreign Keys > WBT_ID | WORK_DETAIL.WBT_ID |
| Foreign Keys > WRKS_ID | WORK_DETAIL.WRKS_ID |
Work Adjustments
| Metadata model reference | Database reference |
|---|---|
| Adjustment Date | WORK_DETAIL_ADJUST.WRKDA_ADJUST_DATE |
| Work Date | WORK_DETAIL_ADJUST.WRKDA_WORK_DATE |
| Start Time | WORK_DETAIL_ADJUST.WRKDA_START_TIME |
| End Time | WORK_DETAIL_ADJUST.WRKDA_END_TIME |
| Minutes | WORK-DETAIL_ADJUST.WRKDA_MINUTES |
| Rate | WORK_DETAIL_ADJUST.WRKDA_RATE |
| Is Authorized | WORK_DETAIL_ADJUST.WRKSA_WRKD_AUTH |
| Work Summary Is Authorized | WORK_DETAIL_ADJUST.WRKSA_AUTHORIZED |
| UDFs > WRKDA_FLAG? | WORK_DETAIL_ADJUST.WRKDA_FLAG? |
| UDFs > WRKDA_UDF? | WORK_DETAIL_ADJUST.WRKDA_UDF? |
| UDFs > WRKSA_FLAG? | WORK_DETAIL_ADJUST.WRKSA_FLAG? |
| UDFs > WRKSA_UDF? | WORK_DETAIL_ADJUST.WRKSA_UDF? |
| Keys > WRKDA_ID | WORK_DETAIL_ADJUST.WRKDA_ID |
| Foreign Keys > CALCGRP_ID | WORK_DETAIL_ADJUST.CALCGRP_ID |
| Foreign Keys > DEPT_ID | WORK_DETAIL_ADJUST.DEPT_ID |
| Foreign Keys > DOCK_ID | WORK_DETAIL_ADJUST.DOCK_ID |
| Foreign Keys > EMP_ID | WORK_DETAIL_ADJUST.EMP_ID |
| Foreign Keys > HTYPE_ID | WORK_DETAIL_ADJUST.HTYPE_ID |
| Foreign Keys > JOB_ID | WORK_DETAIL_ADJUST.JOB_ID |
| Foreign Keys > PAYGRP_ID | WORK_DETAIL_ADJUST.PAYGRP_ID |
| Foreign Keys > PETYP_ID | WORK_DETAIL_ADJUST.PETYP_ID |
| Foreign Keys > PROJ_ID | WORK_DETAIL_ADJUST.PROJ_ID |
| Foreign Keys > SHFT_ID | WORK_DETAIL_ADJUST.SHFT_ID |
| Foreign Keys > TCODE_ID | WORK_DETAIL_ADJUST.TCODE_ID |
| Foreign Keys > WBT_ID | WORK_DETAIL_ADJUST.WBT_ID |
Work Adjustments (Retro)
| Metadata model reference | Database reference |
|---|---|
| Work Date | VIEW_PAYEXP_ADJUSTMENT.WRKD_WORK_DATE |
| Adjustment Date | VIEW_PAYEXP_ADJUSTMENT.WRKDA_ADJUST_DATE |
| Start Time | VIEW_PAYEXP_ADJUSTMENT.WRKD_START_TIME |
| End Time | VIEW_PAYEXP_ADJUSTMENT.WRKD_END_TIME |
| Is Authorized | VIEW_PAYEXP_ADJUSTMENT.WRKS_AUTHORIZED |
| Minutes | VIEW_PAYEXP_ADJUSTMENT.WRKD_MINUTES |
| Hours | VIEW_PAYEXP_ADJUSTMENT.WRKD_MINUTES / 60 |
| Rate | VIEW_PAYEXP_ADJUSTMENT.WRKD_RATE |
| Cost | VIEW_PAYEXP_ADJUSTMENT.WRKD_MINUTES / 60 * VIEW_PAYEXP_ADJUSTMENT.WRKD_RATE |
| Foreign Keys > CALCGRP_ID | VIEW_PAYEXP_ADJUSTMENT.CALCGRP_ID |
| Foreign Keys > DEPT_ID | VIEW_PAYEXP_ADJUSTMENT.DEPT_ID |
| Foreign Keys > DOCK_ID | VIEW_PAYEXP_ADJUSTMENT.DOCK_ID |
| Foreign Keys > EMP_ID | VIEW_PAYEXP_ADJUSTMENT.EMP_ID |
| Foreign Keys > HTYPE_ID | VIEW_PAYEXP_ADJUSTMENT.HTYPE_ID |
| Foreign Keys > JOB_ID | VIEW_PAYEXP_ADJUSTMENT.JOB_ID |
| Foreign Keys > PAYGRP_ID | VIEW_PAYEXP_ADJUSTMENT.PAYGRP_ID |
| Foreign Keys > PETYP_ID | VIEW_PAYEXP_ADJUSTMENT.PETYP_ID |
| Foreign Keys > PROJ_ID | VIEW_PAYEXP_ADJUSTMENT.PROJ_ID |
| Foreign Keys > SHFT_ID | VIEW_PAYEXP_ADJUSTMENT.SHFT_ID |
| Foreign Keys > TCODE_ID | VIEW_PAYEXP_ADJUSTMENT.TCODE_ID |
| Foreign Keys > WBT_ID | VIEW_PAYEXP_ADJUSTMENT.WBT_ID |
Work Day
| Metadata model reference | Database reference |
|---|---|
| Work Date | WORK_SUMMARY.WRKS_WORK_DATE |
| Is Day Authorized | WORK_SUMMARY.WRKS_AUTHORIZED |
| Is Worked Through Break | WORK_SUMMARY.WRKS_FLAG_BRK |
| Authorized By | WORK_SUMMARY.WRKS_AUTH_BY |
| Authorized Date | WORK_SUMMARY.WRKS_AUTH_DATE |
| Original Clock | WORK_SUMMARY.WRKS_ORIG_CLOCKS |
| Clock | WORK_SUMMARY.WRKS_CLOCKS |
| Comments | WORK_SUMMARY.WRKS_COMMENTS |
| Hour Type Summary | WORK_SUMMARY.WRKS_HTYPE_SUM |
| Time Code Summary | WORK_SUMMARY.WRKS_TCODE_SUM |
| Work Summary UDFs > WRKS_FLAG? | WORK_SUMMARY.WRKS_FLAG? |
| Work Summary UDFs > WRKS_UDF? | WORK_SUMMARY.WRKS_UDF? |
| Keys > WRKS_ID | WORK_SUMMARY.WRKS_ID |
| Foreign Keys > CALCGRP_ID | WORK_SUMMARY.CALCGRP_ID |
| Foreign Keys > EATSTS_ID | WORK_SUMMARY.EATSTS_ID |
| Foreign Keys > EMP_ID | WORK_SUMMARY.EMP_ID |
| Foreign Keys > PAYGRP_ID | WORK_SUMMARY.PAYGRP_ID |
| Foreign Keys > PETYP_ID | WORK_SUMMARY.PETYP_ID |
| Foreign Keys > SHFT_ID | WORK_SUMMARY.SHFT_ID |
Work Day with Clock Data
| Metadata model reference | Database reference |
|---|---|
| Work Date | VIEW_PARSE_CLOCKS_MOD2.WRKS_WORK_DATE |
| Clock Display Order | VIEW_PARSE_CLOCKS_MOD2.CLOCKS_ORDER |
| Punch Type | VIEW_PARSE_CLOCKS_MOD2.CLKTRANTYPE_LOC_NM |
| Punch Time | VIEW_PARSE_CLOCKS_MOD2.CLOCK_TIME |
| Punch Data | VIEW_PARSE_CLOCKS_MOD2.CLOCK_DATA |
| Is Day Authorized | VIEW_PARSE_CLOCKS_MOD2.WRKS_AUTHORIZED |
| Time Code Summary | VIEW_PARSE_CLOCKS_MOD2.WRKS_TCODE_SUM |
| Hour Type Summary | VIEW_PARSE_CLOCKS_MOD2.WRKS_HTYPE_SUM |
| Work Summary UDFs > WRKS_FLAG? | VIEW_PARSE_CLOCKS_MOD2.WRKS_FLAG1? |
| Work Summary UDFs > WRKS_UDF? | VIEW_PARSE_CLOCKS_MOD2.WRKS_UDF? |
| Keys > WRKS_ID | VIEW_PARSE_CLOCKS_MOD2.WRKS_ID |
| Foreign Keys > CALCGRP_ID | VIEW_PARSE_CLOCKS_MOD2.CALCGRP_ID |
| Foreign Keys > EMP_ID | VIEW_PARSE_CLOCKS_MOD2.EMP_ID |
| Foreign Keys > PAYGRP_ID | VIEW_PARSE_CLOCKS_MOD2.PAYGRP_ID |
| Foreign Keys > SHFT_ID | VIEW_PARSE_CLOCKS_MOD2.SHFT_ID |
Workbrain Group
| Metadata model reference | Database reference |
|---|---|
| Group Name | WORKBRAIN_GROUP.WBG_NAME |
| Keys > WBG_ID | WORKBRAIN_GROUP.WBG_ID |
Workload Census
| Metadata model reference | Database reference |
|---|---|
| Workload Census | ES_WORKLOAD_CENSUS.WLC_CENSUS |
| Workload Assessed | ES_WORKLOAD_CENSUS.WLC_PATIENT_COUNT |
| Workload Census Date | ES_WORKLOAD_CENSUS.WLC_DATE |
| Workload Census Last Updated Date | ES_WORKLOAD_CENSUS.WLC_LAST_UPDATED |
| Keys > WLC_ID | ES_WORKLOAD_CENSUS.WLC_ID |
| Foreign Keys > DP_ID | ES_WORKLOAD_CENSUS.DP_ID |
| Foreign Keys > WBT_ID | ES_WORKLOAD_CENSUS.WBT_ID |
| UDFs > WLC_FLAG? | ES_WORKLOAD_CENSUS.WLC_FLAG? |
| UDFs > WLC_UDF? | ES_WORKLOAD_CENSUS.WLC_UDF? |
Workload Requirement
| Metadata model reference | Database reference |
|---|---|
| Workload Requirement Date | ES_WORKLOAD_REQ.WLR_DATE |
| Workload Requirement in Minutes | ES_WORKLOAD_REQ.WLR_REQ |
| Workload Requirement Last Updated Date | ES_WORKLOAD_REQ.WLR_LAST_UPDATED |
| Keys > WLR_ID | ES_WORKLOAD_REQ.WLR_ID |
| Foreign Keys > DP_ID | ES_WORKLOAD_REQ.DP_ID |
| Foreign Keys > JOB_ID | ES_WORKLOAD_REQ.JOB_ID |
| Foreign Keys > WBT_ID | ES_WORKLOAD_REQ.WBT_ID |
| Foreign Keys > WRKLS_ID | ES_WORKLOAD_REQ.WRKLS_ID |
| UDFs > WLR_FLAG? | ES_WORKLOAD_REQ.WLR_FLAG? |
| UDFs > WLR_UDF? | ES_WORKLOAD_REQ.WLR_UDF? |
Workload Source
| Metadata model reference | Database reference |
|---|---|
| Workload Source Name | ES_WORKLOAD_SOURCE.WRKLS_NAME |
| Workload Source Description | ES_WORKLOAD_SOURCE.WRKLS_DESC |
| Keys > WRKLS_ID | ES_WORKLOAD_SOURCE.WRKLS_ID |
| UDFs > WRKLS_FLAG? | ES_WORKLOAD_SOURCE.WRKLS_FLAG? |
| UDFs > WRKLS_UDF? | ES_WORKLOAD_SOURCE.WRKLS_UDF? |
Workload Type
| Metadata model reference | Database reference |
|---|---|
| Workload Name | ES_WORKLOAD_TYPE.WLT_LOC_NAME |
| Workload Description | ES_WORKLOAD_TYPE.WLT_LOC_DESC |
| Keys > WLT_ID | ES_WORKLOAD_TYPE.WLT_ID |
Year Time Period
Query Subject Filter: Days between Start Date and End Date is > 300 days.
| Metadata model reference | Database reference |
|---|---|
| Year | FCST_TIME_PERIOD.FCTP_LOC_NAME |
| Year Description | FCST_TIME_PERIOD.FCTP_LOC_DESC |
| Start Date | FCST_TIME_PERIOD.FCTP_START_DATE |
| End Date | FCST_TIME_PERIOD.FCTP_END_DATE |
| Keys > FCTP_ID | FCST_TIME_PERIOD.FCTP_ID |
| Keys > FCTP_PARENT_ID | FCST_TIME_PERIOD.FCTP_PARENT_ID |