Query subjects A to D
Actions by object
| Metadata model reference | Database reference |
|---|---|
| User Name | COGIPF_USERLOGON.USERNAME |
| Time Stamp | COGIPF_ACTION.TIME STAMP |
| Operation | COGIPF_ACTION.OPERATION |
| Target Type | COGIPF_ACTION.TARGET TYPE |
| Target Path | COGIPF_ACTION.TARGET PATH |
| Status | COGIPF_ACTION.STATUS |
Activity
| Metadata model reference | Database reference |
|---|---|
| Activity Name | SO_ACTIVITY.ACT_NAME |
| Activity Description | SO_ACTIVITY.ACT_DESC |
| Is Paid | SO_ACTIVITY.ACT_PAID |
| Is Working | SO_ACTIVITY.ACT_WORKING |
| Contributes to Cost | SO_ACTIVITY.ACT_CONT_TO_COST |
| Keys > ACT_ID | SO_ACTIVITY.ACT_ID |
| Keys > SKDGRP_ID | SO_ACTIVITY.SKDGRP_ID |
| Keys > TCODE_ID | SO_ACTIVITY.TCODE_ID |
Actual Results
| Metadata model reference | Database reference |
|---|---|
| Result Date | SO_RESULTS_DETAIL.RESDET_DATE |
| Volume | SO_RESULTS_DETAIL.RESDET_VOLUME |
| Volume Type | VL_SO_VOLUME_TYPE.VOLTYP_LOC_NAME |
| Results Detail Generated | SO_RESULTS_DETAIL.RESDET_GENERATED |
| Foreign Keys > SKDGRP_ID | SO_RESULTS_DETAIL.SKDGRP_ID |
Actual 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_COUNT |
| 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? |
Actuals
Fact table containing actual metrics, such as sales data
| Metadata model reference | Database reference |
|---|---|
| Actual Payroll | if (SO_VOLUME_TYPE.VOLTYP_NAME = 'PAYROLL') then ( SO_RESULTS_DETAIL.RESDET_VOLUME ) else ( 0 ) |
| Actual Returns | if (SO_VOLUME_TYPE.VOLTYP_NAME = 'RETURNS') then ( SO_RESULTS_DETAIL.RESDET_VOLUME ) else ( 0 ) |
| Actual Revenue | if (SO_VOLUME_TYPE.VOLTYP_NAME = 'REVENUE') then ( SO_RESULTS_DETAIL.RESDET_VOLUME ) else ( 0 ) |
| Actual Transactions | if (SO_VOLUME_TYPE.VOLTYP_NAME = 'TRANSACTIONS') then ( SO_RESULTS_DETAIL.RESDET_VOLUME ) else ( 0 ) |
| Actual Units | if (SO_VOLUME_TYPE.VOLTYP_NAME = 'UNIT') then ( SO_RESULTS_DETAIL.RESDET_VOLUME ) else ( 0 ) |
| Average Hourly Rate | if (SO_VOLUME_TYPE.VOLTYP_NAME = 'AHR') then ( SO_RESULTS_DETAIL.RESDET_VOLUME ) else ( 0 ) |
| Keys > RESDET_DATE | SO_RESULTS_DETAIL.RESDET_DATE |
| Keys > SKDGRP_ID | SO_RESULTS_DETAIL.SKDGRP_ID |
Approval State
| Metadata model reference | Database reference |
|---|---|
| State | EA_TIME_APPROVAL_STATE.EATST_NAME |
| State Description | EA_TIME_APPROVAL_STATE.EATST_DESC |
| Keys > EATST_ID | EA_TIME_APPROVAL_STATE.EATST_ID |
Approval Status
| Metadata model reference | Database reference |
|---|---|
| Status | EA_TIME_APPROVAL_STATUS.EATSTS_NAME |
| Status Description | EA_TIME_APPROVAL_STATUS.EATSTS_DESC |
| Keys > EATST_ID | EA_TIME_APPROVAL_STATUS.EATSTS_ID |
Associated Parent Job
| Metadata model reference | Database reference |
|---|---|
| Job Name | JOB for ES_JOB_ASSOCIATION.JOB_NAME |
| Job Description | JOB for ES_JOB_ASSOCIATION.JOB_DESC |
| Is Job Tipped | JOB for ES_JOB_ASSOCIATION.JOB_TIP |
| Healthcare Type | JOB for ES_JOB_ASSOCIATION.JOB_RPT_HCTYPE |
| Job Association Rank | ES_JOB_ASSOCIATION.JOBASSOC_RANK |
| UDFs > JOB_FLAG? | JOB for ES_JOB_ASSOCIATION.JOB_FLAG? |
| UDFs > JOB_REFKEY? | JOB for ES_JOB_ASSOCIATION.JOB_REFKEY? |
| UDFs > JOB_VAL? | JOB for ES_JOB_ASSOCIATION.JOB_VAL? |
| UDFs > JOBASSOC_FLAG? | ES_JOB_ASSOCIATION.JOBASSOC_FLAG? |
| UDFs > JOBASSOC_UDF? | ES_JOB_ASSOCIATION.JOBASSOC_UDF? |
| Keys > JOB_ID | JOB for ES_JOB_ASSOCIATION.JOB_ID |
| Keys > JOBASSOC_ID | ES_JOB_ASSOCIATION.JOBASSOC_ID |
| Foreign Keys > JOB_CHILD_ID | ES_JOB_ASSOCIATION.JOB_CHILD_ID |
Audit Log
| Metadata model reference | Database reference |
|---|---|
| User Name | AUDIT_LOG.WBU_NAME |
| Action | AUDIT_LOG.AUDLOG_ACTION |
| Change Date | AUDIT_LOG.CHANGE_DATE |
| Change Time | AUDIT_LOG.CHANGE_DATE |
| Table | AUDIT_LOG.TABLENAME |
| Field | AUDIT_LOG.FIELDNAME |
| Old Value | AUDIT_LOG.OLD_VALUE |
| New Value | AUDIT_LOG.NEW_VALUE |
| Keys > AUDLOG_ID | AUDIT_LOG.AUDLOG_ID |
Availability
| Metadata model reference | Database reference |
|---|---|
| Available Date | AMX_AVAIL_SUMMARY.AMXAVS_DATE |
| Available Hours | AMX_AVAIL_DETAIL.AMXAVD_ACT_MINUTES / 60 |
| Available Start Time | AMX_AVAIL_DETAIL.AMXAVD_ACT_ST_TM |
| Available End Time | AMX_AVAIL_DETAIL.AMXAVD_ACT_END_TM |
| Foreign Keys > EMP_ID | AMX_AVAIL_SUMMARY.EMP_ID |
| Foreign Keys > WBT_ID | AMX_AVAIL_SUMMARY.WBT_ID |
Bad Reason
| Metadata model reference | Database reference |
|---|---|
| Bad Reason Code Name | REASON_CODE.RSNCD_LOC_NAME |
| Bad Reason Code Description | REASON_CODE.RSNCD_LOC_DESC |
| RSNCD_FLAG1 | REASON_CODE.RSNCD_FLAG1 |
| RSNCD_FLAG2 | REASON_CODE.RSNCD_FLAG2 |
| RSNCD_FLAG3 | REASON_CODE.RSNCD_FLAG3 |
| RSNCD_FLAG4 | REASON_CODE.RSNCD_FLAG4 |
| RSNCD_FLAG5 | REASON_CODE.RSNCD_FLAG5 |
| RSNCD_UDF1 | REASON_CODE.RSNCD_UDF1 |
| RSNCD_UDF2 | REASON_CODE.RSNCD_UDF2 |
| RSNCD_UDF3 | REASON_CODE.RSNCD_UDF3 |
| RSNCD_UDF4 | REASON_CODE.RSNCD_UDF4 |
| RSNCD_UDF5 | REASON_CODE.RSNCD_UDF5 |
| RSNCD_ID | REASON_CODE.RSNCD_ID |
Balance
| Metadata model reference | Database reference |
|---|---|
| Balance Name | VL_BALANCE.BAL_LOC_NAME |
| Balance Description | VL_BALANCE.BAL_LOC_DESC |
| Available Value | VL_BALANCE.BAL_MAX - EMPLOYEE_BALANCE.EMPBAL_VALUE |
| Current Balance | EMPLOYEE_BALANCE.EMPBAL_VALUE - EMPLOYEE_BALANCE.FUTURE_BAL |
| Current Value | EMPLOYEE_BALANCE.EMPBAL_VALUE |
| Keys > BAL_ID | EMPLOYEE_BALANCE.BAL_ID |
| Foreign Keys > EMP_ID | EMPLOYEE_BALANCE.EMP_ID |
Balance Transaction
| Metadata model reference | Database reference |
|---|---|
| Date | EMPLOYEE_BALANCE_LOG.WRKS_WORK_DATE |
| Delta | EMPLOYEE_BALANCE_LOG.EBLOG_DELTA |
| Message | EMPLOYEE_BALANCE_LOG.EBLOG_MESSAGE |
| Comment | EMPLOYEE_BALANCE_LOG.EBLOG_COMMENT |
| Foreign Keys > BAL_ID | EMPLOYEE_BALANCE_LOG.BAL_ID |
| Foreign Keys > EMP_ID | EMPLOYEE_BALANCE_LOG.EMP_ID |
Bookoff Comments
| Metadata model reference | Database reference |
|---|---|
| Bookoff Comment | ES_BOOKOFF_COMMENTS.ESBOCMT_COMMENT |
| Keys > ESBOCMT_ID | ES_BOOKOFF_COMMENTS.ESBOCMT_ID |
Budgeting Forecast
| Metadata model reference | Database reference |
|---|---|
| Forecast Name | FORECAST.FC_NAME |
| Forecast Description | FORECAST.FC_DESC |
| Forecast Creation Date | FORECAST.FC_CREATED_DATE |
| Forecast Type | FCST_TYPE.FCTYP_NAME |
| Keys > FC_ID | FORECAST.FC_ID |
| Keys > FC_MASTER_FC_ID | FORECAST.FC_MASTER_FC_ID |
| Foreign Keys > FCRG_ID | FORECAST.FCRG_ID |
| Foreign Keys > FCTP_ID | FORECAST.FCTP_ID |
| Foreign Keys > FCTYP_ID | FORECAST.FCTYP_ID |
| Foreign Keys > FCVER_ID | FORECAST.FCVER_ID |
| Foreign Keys > FCVER_ID | FORECAST.SKDGRP_ID |
| Foreign Keys > WBU_ID | FORECAST.WBU_ID |
Budgeted Hours Per Patient Day
| Metadata model reference | Database reference |
|---|---|
| Budgeted HPPD Start Date | ES_BUDG_HRS_PER_PATIENT_DAY.BHPPD_EFF_START_DATE |
| Budgeted HPPD End Date | ES_BUDG_HRS_PER_PATIENT_DAY.BHPPD_EFF_END_DATE |
| 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 |
Burst Employee
| Metadata model reference | Database reference |
|---|---|
| Employee ID | [EMPLOYEE].[EMP_NAME] |
| Full Name | [EMPLOYEE].[EMP_FULLNAME] |
| Last Name | [EMPLOYEE].[EMP_LASTNAME] |
| 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] |
| 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] |
| System Scheduling Enabled | [EMPLOYEE].[EMP_SYSTEM_SCHEDULING_ENABLED] |
Burst Team
| Metadata model reference | Database reference |
|---|---|
| Team Name | WORKBRAIN_TEAM.WBT_NAME |
| Team Description | WORKBRAIN_TEAM.WBT_DESC |
| Keys > WBU_ID | BURST_SEC_WB_TEAM.WBU_ID |
| Keys > WBT_ID | WORKBRAIN_TEAM.WBT_ID |
| Team UDFs > WBT_FLAG? | WORKBRAIN_TEAM.WBT_FLAG? |
| Team UDFs > WBT_UDF? | WORKBRAIN_TEAM.WBT_UDF? |
Calc Group
| Metadata model reference | Database reference |
|---|---|
| Calc Group Name | VL_CALC_GROUP.CALCGRP_LOC_NAME |
| Calc Group Description | VL_CALC_GROUP.CALCGRP_LOC_DESC |
| Calc Group UDFs > CALCGRP_FLAG? | VL_CALC_GROUP.CALCGRP_FLAG? |
| Calc Group UDFs > CALCGRP_UDF? | VL_CALC_GROUP.CALCGRP_UDF? |
| Keys > CALCGRP_ID | VL_CALC_GROUP.CALCGRP_ID |
Call List
| Metadata model reference | Database reference |
|---|---|
| Call List Name | ES_CALL_LIST.CLIST_NAME |
| Call List Description | ES_CALL_LIST.CLIST_DESCRIPTION |
| Keys > CLIST_ID | ES_CALL_LIST.CLIST_ID |
| UDFs > CLIST_FLAG? | ES_CALL_LIST.CLIST_FLAG? |
| UDFs > CLIST_UDF? | ES_CALL_LIST.CLIST_UDF? |
Call List Employees
| Metadata model reference | Database reference |
|---|---|
| Employee Effective Start Date | ES_CLIST_EMPLOYEE.CLISTEMP_EFF_START_DATE |
| Employee Effective End Date | ES_CLIST_EMPLOYEE.CLISTEMP_EFF_END_DATE |
| UDFs > CLISTEMP_FLAG? | ES_CLIST_EMPLOYEE.CLISTEMP_FLAG4 |
| UDFs > CLISTEMP_UDF? | ES_CLIST_EMPLOYEE.CLISTEMP_UDF? |
| Keys > CLISTEMP_ID | ES_CLIST_EMPLOYEE.CLISTEMP_ID |
| Foreign Keys > EMP_ID | ES_CLIST_EMPLOYEE.EMP_ID |
| Foreign Keys > SHFTTYP_ID | ES_CLIST_EMPLOYEE.SHFTTYP_ID |
| Foreign Keys > JOB_ID | ES_CLIST_EMPLOYEE.JOB_ID |
| Foreign Keys > CLIST_ID | ES_CLIST_EMPLOYEE.CLIST_ID |
Call List Teams
| Metadata model reference | Database reference |
|---|---|
| Team Effective Start Date | ES_CLIST_TEAM.CLISTTM_EFF_START_DATE |
| Team Effective End Date | ES_CLIST_TEAM.CLISTTM_EFF_END_DATE |
| Keys > CLISTTM_ID | ES_CLIST_TEAM.CLISTTM_ID |
| Foreign Keys > CLIST_ID | ES_CLIST_TEAM.CLIST_ID |
| Foreign Keys > WBT_ID | ES_CLIST_TEAM.WBT_ID |
| UDFs > CLISTEMP_FLAG? | ES_CLIST_TEAM.CLISTTM_FLAG1 |
| UDFs > CLISTEMP_UDF? | ES_CLIST_TEAM.CLISTTM_UDF1 |
Call Log
| Metadata model reference | Database reference |
|---|---|
| Call Log Date | ES_CALL_LOG.CLOG_DATE |
| Call Log Action | ES_CALL_LOG.CLOG_ACTION |
| Call Log Comments | ES_CALL_LOG.CLOG_COMMENTS |
| Call Log Compliance Error | ES_CALL_LOG.CLOG_CMPERROR |
| Call Log Phone 1 | ES_CALL_LOG.CLOG_PHONE1 |
| Call Log Phone 2 | ES_CALL_LOG.CLOG_PHONE2 |
| Call Log Phone 3 | ES_CALL_LOG.CLOG_PHONE3 |
| Call Log Scheduler Comments | ES_CALL_LOG.CLOG_SCHEDULER_COMMENTS |
| Call Log Shift Detail Start Time | ES_CALL_LOG.CLOG_SHIFTDTL_START_TIME |
| Call Log Shift Detail End Time | ES_CALL_LOG.CLOG_SHIFTDTL_END_TIME |
| UDFs > CLOG_FLAG? | ES_CALL_LOG.CLOG_FLAG? |
| UDFs > CLOG_UDF? | ES_CALL_LOG.CLOG_UDF? |
| Keys > CLOG_ID | ES_CALL_LOG.CLOG_CLOG_ID |
| Foreign Keys > SHIFTSUM_ID | ES_CALL_LOG.SHIFTSUM_ID |
| Foreign Keys > EMP_ID | ES_CALL_LOG.EMP_ID |
| Foreign Keys > REASON_ID | ES_CALL_LOG.REASON_ID |
| Foreign Keys > WBU_ID | ES_CALL_LOG.WBU_ID |
| Foreign Keys > WBU_ID_ACTUAL | ES_CALL_LOG.WBU_ID_ACTUAL |
Census
| Metadata model reference | Database reference |
|---|---|
| Census | CENSUS_DATA.CENSDT_USAGE |
| Date | CENSUS_DATA.CENSDT_DATE |
| Required | CENSUS_DATA.CENSDT_REQUIRED |
| Census Fields > CENSDT_FIELD? | CENSUS_DATA.CENSDT_FIELD? |
| Keys > CENSDT_ID | CENSUS_DATA.CENSDT_ID |
| Foreign Keys > JOB_ID | CENSUS_DATA.JOB_ID |
| Foreign Keys > DP_ID | CENSUS_DATA.DP_ID |
| Foreign Keys > CENSTM_ID | CENSUS_DATA.CENSTM_ID |
Census Team
| Metadata model reference | Database reference |
|---|---|
| Census Team | CENSUS_TEAM.CENSTM_NAME |
| Census Team Start Date | CENSUS_TEAM.CENSTM_START_DATE |
| Census Team End Date | CENSUS_TEAM.CENSTM_END_DATE |
| Foreign Keys > WBT_ID | CENSUS_TEAM.WBT_ID |
| 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.
| Metadata model reference | Database reference |
|---|---|
| Clock Time | CLOCK_TRAN_REJ_J.Clock_Time |
| Transaction Type Name | CLOCK_TRAN_REJ_J.CTRJ_TYPE |
| Transaction Type Description | |
| Error Message | CLOCK_TRAN_REJ_J.CTRJ_ERR_MESSAGE |
| In Exception | if (CLOCK_TRAN_REJ_J.CTRJ_TYPE = '01' then CLOCK_TRAN_REJ_J.CTRJ_ERR_MESSAGE) else ('--') |
| Out Exception | if (CLOCK_TRAN_REJ_J.CTRJ_TYPE = '02' then CLOCK_TRAN_REJ_J.CTRJ_ERR_MESSAGE) else ('--') |
| 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 ('--') |
| IP Address | CLOCK_TRAN_REJ_J.CTRJ_IP |
| Latitude | CLOCK_TRAN_REJ_J.CTPJ_LAT |
| Longitude | CLOCK_TRAN_REJ_J.CTPJ_LNG |
| Foreign Keys > EMP_ID | CLOCK_TRAN_REJ_J.EMP_ID |
| Foreign Keys > CLOCK_DATE | cast(CLOCK_TRAN_REJ_J.CTRJ_TIME, date) |
Compliance Group
| Metadata model reference | Database reference |
|---|---|
| Compliance Group Name | CMPLNC_GROUP.CMPGRP_NAME |
| Compliance Group Description | CMPLNC_GROUP.CMPGRP_DESC |
| Compliance Effective Start Date | CMPLNC_GROUP.CMPGRP_EFF_START_DATE |
| Compliance Effective End Date | CMPLNC_GROUP.CMPGRP_EFF_END_DATE |
| Is Compliance Enabled | CMPLNC_GROUP.CMPGRP_IS_ENABLED |
| Enforce Calendar Day Cut | CMPLNC_GROUP.CMPGRP_CALENDAR_DAY_CUT |
| UDFs > CMPGRP_FLAG? | CMPLNC_GROUP.CMPGRP_FLAG? |
| UDFs > CMPGRP_UDF? | CMPLNC_GROUP.CMPGRP_UDF? |
| Keys > CMPGRP_ID | CMPLNC_GROUP.CMPGRP_ID |
Compliance Group Rules
| Metadata model reference | Database reference |
|---|---|
| Rule Name | CMPLNC_GROUP_RULE.CMPGRPR_NAME |
| Rule Description | CMPLNC_GROUP_RULE.CMPGRPR_DESC |
| Rule Type | CMPLNC_GROUP_RULE.CMPGRPR_TYPE |
| Violation Message | CMPLNC_GROUP_RULE.CMPGRPR_MESSAGE |
| Group Rule UDFs > CMPGRPR_FLAG? | CMPLNC_GROUP_RULE.CMPGRPR_FLAG? |
| Group Rule UDFs > CMPGRPR_UDF? | CMPLNC_GROUP_RULE.CMPGRPR_UDF2? |
| Keys > CMPGRPR_ID | CMPLNC_GROUP_RULE.CMPGRPR_ID |
| Foreign Keys > CMPRL_ID | CMPLNC_GROUP_RULE.CMPRL_ID |
| Foreign Keys > CMPGRP_ID | CMPLNC_GROUP_RULE.CMPGRP_ID |
Compliance Violations
| Metadata model reference | Database reference |
|---|---|
| Approval Date | CMPLNC_VIOLATION.CMPVIO_APRVL_DATE |
| Approved By | CMPLNC_VIOLATION.WBU_NAME_ACTUAL |
| Is Violation Active | CMPLNC_VIOLATION.CMPVIO_IS_ACTIVE |
| Is Violation Approved | CMPLNC_VIOLATION.CMPVIO_IS_APRVD |
| User Name | CMPLNC_VIOLATION.WBU_NAME |
| Violation Create Date | CMPLNC_VIOLATION.CMPVIO_CREATE_DATE |
| Violation Start Date | CMPLNC_VIOLATION.CMPVIO_START_DATE |
| Violation End Date | CMPLNC_VIOLATION.CMPVIO_END_DATE |
| Violation Message | CMPLNC_VIOLATION.CMPVIO_MESSAGE |
| Violation Value | CMPLNC_VIOLATION.CMPVIO_VALUE |
| Violation UDFs > CMPIO_FLAG? | CMPLNC_VIOLATION.CMPVIO_ID |
| Violation UDFs > CMPIO_UDF? | CMPLNC_VIOLATION.CMPGRPR_ID |
| Keys > CMPVIO_ID | CMPLNC_VIOLATION.EMP_ID |
| Foreign Keys > CMPGRPR_ID | CMPLNC_VIOLATION.CMPVIO_FLAG? |
| Foreign Keys > EMP_ID | CMPLNC_VIOLATION.CMPVIO_UDF? |
Currency
| Metadata model reference | Database reference |
|---|---|
| Currency Name | [CURRENCY].[CUR_NAME] |
| Currency Description | [CURRENCY].[CUR_DESCRIPTION] |
| UDFs > CUR_FLAG[1-5] | [CURRENCY].[CUR_FLAG*] |
| UDFs > CUR_UDF[1-5] | [CURRENCY].[CUR_UDF*] |
| Keys > CUR_ID | [CURRENCY].[CUR_ID] |
Currency (User Locale)
| Metadata model reference | Database reference |
|---|---|
| Currency Name | [WORKBRAIN_LOCALE CURRENCY].[CUR_NAME] |
| Currency Description | [WORKBRAIN_LOCALE CURRENCY].[CUR_DESCRIPTION] |
| UDFs > CUR_FLAG[1-5] | [WORKBRAIN_LOCALE CURRENCY].[CUR_FLAG*] |
| UDFs > CUR_UDF[1-5] | [WORKBRAIN_LOCALE CURRENCY].[CUR_UDF*] |
| Keys > CUR_ID | [WORKBRAIN_LOCALE].[CUR_ID] |
Currency Conversion
| Metadata model reference | Database reference |
|---|---|
| Currency Conversion Start Date | [CURRENCY_CONVERSION].[CURCON_START_DATE] |
| Currency Conversion End Date | [CURRENCY_CONVERSION].[CURCON_END_DATE] |
| Currency Conversion Rate | [CURRENCY_CONVERSION].[CURCON_RATE] |
| UDFs > CURCON_FLAG[1-5] | [CURRENCY_CONVERSION].[CURCON_FLAG*] |
| UDFs > CURCON_UDF[1-5] | [CURRENCY_CONVERSION].[CURCON_UDF*] |
| Keys > CURCON_ID | [CURRENCY_CONVERSION].[CURCON_ID] |
| Foreign Keys > CUR_SOURCE_ID | [CURRENCY_CONVERSION].[CUR_SOURCE_ID] |
| Foreign Keys > CUR_TARGET_ID | [CURRENCY_CONVERSION].[CUR_TARGET_ID] |
| Foreign Keys > CONGR_ID | [CURRENCY_CONVERSION].[CONGR_ID] |
Currency Conversion
Work
| Metadata model reference | Database reference |
|---|---|
| Currency Conversion Start Date | CURRENCY_CONVERSION.CURCON_START_DATE |
| Currency Conversion End Date | CURRENCY_CONVERSION.CURCON_END_DATE |
| Currency Conversion Rate | CURRENCY_CONVERSION.CURCON_RATE |
| UDFs > CURCON_FLAG[1-5] | CURRENCY_CONVERSION.CURCON_FLAG* |
| UDFs > CURCON_UDF[1-5] | CURRENCY_CONVERSION.CURCON_UDF* |
| Keys > CURCON_ID | CURRENCY_CONVERSION.CURCON_ID |
| Foreign Keys > CUR_SOURCE_ID | CURRENCY_CONVERSION.CUR_SOURCE_ID |
| Foreign Keys > CUR_TARGET_ID | CURRENCY_CONVERSION.CUR_TARGET_ID |
| Foreign Keys > CONGR_ID | CURRENCY_CONVERSION.CONGR_ID |
Currency Conversion (Work Day)
| Metadata model reference | Database reference |
|---|---|
| Currency Conversion Start Date | [CURRENCY_CONVERSION].[CURCON_START_DATE] |
| Currency Conversion End Date | [CURRENCY_CONVERSION].[CURCON_END_DATE] |
| Currency Conversion Rate | [CURRENCY_CONVERSION].[CURCON_RATE] |
| UDFs > CURCON_FLAG[1-5] | [CURRENCY_CONVERSION].[CURCON_FLAG*] |
| UDFs > CURCON_UDF[1-5] | [CURRENCY_CONVERSION].[CURCON_UDF*] |
| Keys > CURCON_ID | [CURRENCY_CONVERSION].[CURCON_ID] |
| Foreign Keys > CUR_SOURCE_ID | [CURRENCY_CONVERSION].[CUR_SOURCE_ID] |
| Foreign Keys > CUR_TARGET_ID | [CURRENCY_CONVERSION].[CUR_TARGET_ID] |
| Foreign Keys > CONGR_ID | [CURRENCY_CONVERSION].[CONGR_ID] |
Currency Conversion Group
| Metadata model reference | Database reference |
|---|---|
| Currency Group Name | [CURRENCY_CONVERSION_GROUP].[CONGR_NAME] |
| Currency Group Description | [CURRENCY_CONVERSION_GROUP].[CONGR_DESC] |
| UDFs > CONGR_FLAG[1-5] | [CURRENCY_CONVERSION_GROUP].[CONGR_FLAG*] |
| UDFs > CONGR_UDF[1-5] | [CURRENCY_CONVERSION_GROUP].[CONGR_UDF*] |
| Keys > CONGR_ID | [CURRENCY_CONVERSION_GROUP].[CONGR_ID] |
Date
Denormalized conformed date dimension. Every calendar date 2 years in the past, and 10 years in the future.
| Metadata model reference | Database reference |
|---|---|
| Date | DATE_VALUE.DTVAL_DATE |
| Year | DATE_VALUE.DTVAL_YEAR |
| Quarter | DATE_VALUE.DTVAL_QUARTER |
| Month | DATE_VALUE.DTVAL_MONTH |
| 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 |
| Keys > DTVAL_ID | DATE_VALUE.DTVAL_ID |
Day Part
| Metadata model reference | Database reference |
|---|---|
| Day Part Name | DAY_PART.DP_NAME |
| Day Part Description | DAY_PART.DP_DESC |
| Start Time | DAY_PART.DP_START_TIME |
| End Time | DAY_PART.DP_END_TIME |
| Keys > DP_ID | DAY PART.DP_ID |
Day of Week
| Metadata model reference | Database reference |
|---|---|
| Day Name | DAY_OF_WEEK.DAY_NAME |
| Day Description | DAY_OF_WEEK.DAY_DESC |
| Day Code | DAY_OF_WEEK.DAY_CODE |
| Keys > DAY_ID | DAY_OF_WEEK.DAY_ID |
| UDFs > DAY_FLAG? | DAY_OF_WEEK.DAY_FLAG? |
| UDFs > DAY_UDF? | DAY_OF_WEEK.DAY_UDF? |
Day Part
| Metadata model reference | Database reference |
|---|---|
| Day Part Name | DAY_PART.DP_NAME |
| Day Part Description | DAY_PART.DP_DESC |
| Day Part Short Code | DAY_PART.DP_SHORT_CODE |
| Day Part Start Time | DAY_PART.DP_START_TIME |
| Day Part End Time | DAY_PART.DP_END_TIME |
| Is Day Part Hidden | DAY_PART.DP_HIDE |
| Is First Day Part | DAY_PART.IS_FIRST_DP |
| Keys > DP_ID | DAY_PART.DP_ID |
| UDFs > DP_FLAG? | DAY_PART.DP_FLAG? |
| UDFs > DP_UDF? | DAY_PART.DP_UDF? |
Department
| Metadata model reference | Database reference |
|---|---|
| Department Name | DEPARTMENT.DEPT_NAME |
| Department Description | DEPARTMENT.DEPT_DESC |
| Department Start Date | DEPARTMENT.DEPT_START_DATE |
| Department End Date | DEPARTMENT.DEPT_END_DATE |
| Department UDFs > DEPT_FLAG? | DEPARTMENT.DEPT_FLAG? |
| Department UDFs > DEPT_REFKEY? | DEPARTMENT.DEPT_REFKEY? |
| Department UDFs > DEPT_VAL? | DEPARTMENT.DEPT_VAL? |
| Keys > DEPT_ID | DEPARTMENT.DEPT_ID |
| Foreign Keys > WBT_ID | DEPARTMENT.WBT_ID |
Docket
| Metadata model reference | Database reference |
|---|---|
| Docket Name | DOCKET.DOCK_NAME |
| Docket Description | DOCKET.DOCK_DESC |
| Quantity | DOCKET.DOCK_QTY |
| Standard Quantity | DOCKET.DOCK_STANDARD_QTY |
| Standard Duration | DOCKET.DOCK_STANDARD_DUR |
| Piece Rate | DOCKET.DOCK_PIECE_RATE |
| Start Date | DOCKET.DOCK_START_DATE |
| End Date | DOCKET.DOCK_END_DATE |
| Docket UDFs > DOCK_FLAG? | DOCKET.DOCK_FLAG? |
| Docket UDFs > DOCK_REFKEY? | DOCKET.DOCK_REFKEY? |
| Docket UDFs > DOCK_UDF? | DOCKET.DOCK_UDF? |
| Keys > DOCK_ID | DOCKET.DOCK_ID |
| Foreign Keys > ACTVSET_ID | DOCKET.ACTVSET_ID |
Docket Activities
| Metadata model reference | Database reference |
|---|---|
| Activity Set Name | ACTIVITY_SET.ACTVSET_NAME |
| Activity Set Description | ACTIVITY_SET.ACTVSET_DESC |
| Keys > ACTVSET_ID | ACTIVITY_SELF.ACTVSET_ID |