Query subjects N to R
OTE Employee Points
| Metadata model reference | Database reference |
|---|---|
| Current OTE Points | OTE_GROUP_EMPLOYEE.OTEGE_POINTS |
| Foreign Keys > EMP_ID | OTE_GROUP_EMPLOYEE.EMP_ID |
OTE Group
| Metadata model reference | Database reference |
|---|---|
| OTE Group Name | OTE_GROUP.OTEGRP_NAME |
| OTE Group Description | OTE_GROUP.OTEGRP_DESCRIPTION |
| Keys > OTEGRP_ID | OTE_GROUP.OTEGRP_ID |
OTE Offers
| Metadata model reference | Database reference |
|---|---|
| Offer Description | OTE_OFFER.OTEOFF_DESC |
| Date of Offer | OTE_OFFER.OTEOFF_CREATE_DATE |
| Date of Offered Work | OTE_OFFER.OTEOFF_OFFER_DATE |
| Time of Offered Work | OTE_OFFER.OTEOFF_OFFR_STTM |
| Duration | OTE_OFFER.OTEOFFER_HOURS |
| Keys > OTEOFF_ID | OTE_OFFER.OTEOFFER_ID |
| Keys > OTEOFF_GROUPS_OFFR | OTE_OFFER.OTEOFF_GROUPS_OFFR |
OTE Responses
| Metadata model reference | Database reference |
|---|---|
| Responses Date | OTE_RESPONSE.OTERESP_RESPONS_DT |
| Response | OTE_RESPONSE.OTERESP_RESPONSE |
| Hours Accepted | OTE_RESPONSE.OTERESP_HOURS_ACP |
| Points Charged | OTE_RESPONSE.OTERESP_PTS_CHRG |
| Points to Date | OTE_RESPONSE.OTERESP_PTS_TODT |
| Keys > OTERESP_ID | OTE_RESPONSE.OTERESP_ID |
| Foreign Keys > EMP_ID | OTE_RESPONSE.EMP_ID |
| Foreign Keys > OTEOFF_ID | OTE_RESPONSE.OTEOFF_ID |
Override
| Metadata model reference | Database reference |
|---|---|
| Created By | VIEW_OVERRIDE.WBU_NAME |
| Create By (Actual) | VIEW_OVERRIDE.WBU_NAME_ACTUAL |
| Creation Date | VIEW_OVERRIDE.OVR_CREATE_DATE |
| Type | VIEW_OVERRIDE.OVRTYP_NAME |
| Start Date | VIEW_OVERRIDE.OVR_START_DATE |
| End Date | VIEW_OVERRIDE.OVR_END_DATE |
| Start Time | VIEW_OVERRIDE.OVR_START_TIME |
| End Time | VIEW_OVERRIDE.OVR_END_TIME |
| Old Value | VIEW_OVERRIDE.OVR_OLD_VALUE |
| New Value | VIEW_OVERRIDE.OVR_NEW_VALUE |
| Status | VIEW_OVERRIDE.OVR_STATUS |
| Comment | VIEW_OVERRIDE.OVR_COMMENT |
| Message | VIEW_OVERRIDE.OVR_MESSAGE |
| Cancelled by Actual | OVERRIDE.OVR_CANCELLED_BY_A |
| Cancelled By | VIEW_OVERRIDE.OVR_CANCELLED_BY |
| Cancelled Date | VIEW_OVERRIDE.OVR_CANCELLED_DATE |
| Override UDFs > OVR_FLAG? | VIEW_OVERRIDE.OVR_FLAG? |
| Override UDFs > OVR_UDF? | VIEW_OVERRIDE.OVR_UDF? |
| Keys > OVR_ID | VIEW_OVERRIDE.EMP_ID |
| Foreign Keys > EMP_ID | VIEW_OVERRIDE.OVRTYP_ID |
| Foreign Keys > OVRTYP_ID | VIEW_OVERRIDE.OVR_ID |
Parent Staffing Requirement Template
| Metadata model reference | Database reference |
|---|---|
| Template Name | ES_SCHEDULE_TEMPLATE.TMPL_NAME |
| Template Description | ES_SCHEDULE_TEMPLATE.TMPL_DESC |
| Template Length | ES_SCHEDULE_TEMPLATE.TMPL_LENGTH |
| Template Create Date | ES_SCHEDULE_TEMPLATE.TMPL_CREATE_DATE |
| Template Start Date | ES_SCHEDULE_TEMPLATE.TMPL_START_DATE |
| Template End Date | ES_SCHEDULE_TEMPLATE.TMPL_END_DATE |
| Is Template Active | ES_SCHEDULE_TEMPLATE.TMPL_ACTIVE |
| UDFs > TMPL_FLAG? | ES_SCHEDULE_TEMPLATE.TMPL_FLAG? |
| UDFs > TMPL_UDF? | ES_SCHEDULE_TEMPLATE.TMPL_UDF? |
| Keys > TMPL_ID | ES_SCHEDULE_TEMPLATE.TMPL_ID |
| Foreign Keys > WBT_ID | ES_SCHEDULE_TEMPLATE.WBT_ID |
| Foreign Keys > TMPLTYP_ID | ES_SCHEDULE_TEMPLATE.TMPLTYP_ID |
| Foreign Keys > TMPL_PARENT_ID | ES_SCHEDULE_TEMPLATE.TMPL_PARENT_ID |
Parsed Override Token
| Metadata model reference | Database reference |
|---|---|
| Token Name | WBI_OVERRIDE_VALUE.WOV_TOKEN_LOC_NAME |
| Token Value | WBI_OVERRIDE_VALUE.WOV_TOKEN_VALUE |
| Data As Of Date | WBI_OVERRIDE_VALUE.WOV_DATA_ASOF |
| Keys > CAMPASSPORT_ID | WBI_OVERRIDE_VALUE.WOV_CAMPASSPRT_ID |
| Keys > CGCRT_ID | WBI_OVERRIDE_VALUE.CGCRT_ID |
| Keys > CGMAP_ID | WBI_OVERRIDE_VALUE.CGMAP_ID |
| Keys > WBU_ID | WBI_OVERRIDE_VALUE.WBU_ID |
| Keys > WOV_ID | WBI_OVERRIDE_VALUE.WOV_ID |
| Foreign Keys > OVR_ID | WBI_OVERRIDE_VALUE.OVR_ID |
Pay Group
| Metadata model reference | Database reference |
|---|---|
| Pay Group Name | PAY_GROUP.PAYGRP_NAME |
| End Date | PAY_GROUP.PAYGRP_END_DATE |
| Pay Group Name | [PAY_GROUP].[PAYGRP_LOC_NAME] |
| Pay Group Description | [PAY_GROUP].[PAYGRP_LOC_DESC] |
| Start Date | [PAY_GROUP].[PAYGRP_START_DATE] |
| End Date | [PAY_GROUP].[PAYGRP_END_DATE] |
| Day Start Time | [PAY_GROUP].[PAYGRP_DAY_START_TIME] |
| Hands Off Date | [PAY_GROUP].[PAYGRP_HANDS_OFF_DATE] |
| Supervisor Date | [PAY_GROUP].[PAYGRP_SUPERVISOR_DATE] |
| Year First Date | [PAY_GROUP].[PAYGRP_YEAR_FIRST_DATE] |
| Adjust Date | [PAY_GROUP].[PAYGRP_ADJUST_DATE] |
| Adjustment Offset | [PAY_GROUP].[PAYGRP_OFFSET] |
| Pay Group UDFs > PAYGRP_FLAG[1-10] | [PAY_GROUP].[PAYGRP_FLAG*] |
| Pay Group UDFs > PAYGRP_UDF[1-10] | [PAY_GROUP].[PAYGRP_UDF*] |
| Keys > PAYGRP_ID | [PAY_GROUP].[PAYGRP_ID] |
| Foreign Keys > CUR_ID | [PAY_GROUP].[CUR_ID] |
| Foreign Keys > CONGR_ID | [PAY_GROUP].[CONGR_ID] |
| Supervisor Date | PAY_GROUP.PAYGRP_SUPERVISOR_DATE |
| Year First Date | PAY_GROUP.PAYGRP_YEAR_FIRST_DATE |
| Adjust Date | PAY_GROUP.PAYGRP_ADJUST_DATE |
| Adjustment Offset | PAY_GROUP.PAYGRP_OFFSET |
| Pay Group UDFs > PAYGRP_FLAG? | PAY_GROUP.PAYGRP_FLAG? |
| Pay Group UDFs > PAYGRP_UDF? | PAY_GROUP.PAYGRP_UDF? |
| Keys > PAYGRP_ID | PAY_GROUP.PAYGRP_ID |
Policy
| Metadata model reference | Database reference |
|---|---|
| Policy Name | ENT_POLICY.ENTPOL_NAME |
| Policy Description | ENT_POLICY.ENTPOL_DESC |
| Policy Start Date | ENT_POLICY.ENTPOL_START_DATE |
| Policy End Date | ENT_POLICY.ENTPOL_END_DATE |
| Priority | ENT_EMP_POLICY.ENTEMPPOL_PRIORITY |
| Employee Start Date | ENT_EMP_POLICY.ENTEMPPOL_START_DT |
| Employee End Date | ENT_EMP_POLICY.ENTEMPPOL_END_DATE |
| Employee Enabled | ENT_EMP_POLICY.ENTEMPPOL_ENABLED |
| Policy UDFs > ENTPOL_FLAG? | ENT_POLICY.ENTPOL_FLAG? |
| Policy UDFs > ENTPOL_UDF? | ENT_POLICY.ENTPOL_UDF? |
| Policy UDFs > ENTEMPPOL_FLAG? | ENT_EMP_POLICY.ENTPOL_FLAG? |
| Policy UDFs > ENTEMPPOL_UDF? | ENT_ EMP_POLICY.ENTPOL_UDF? |
| Keys > ENTPOL_ID | ENT_EMP_POLICY.ENTPOL_ID |
| Foreign Keys > EMP_ID | ENT_EMP_POLICY.EMP_ID |
Product
| Metadata model reference | Database reference |
|---|---|
| Product Name | PRODUCT.PROD_LOC_NAME |
| Product Description | PRODUCT.PROD_LOC_DESC |
| Keys > PROD_ID | PRODUCT.PROD_ID |
Production Machine Template
| Metadata model reference | Database reference |
|---|---|
| UDFs > PMTMPL_FLAG? | ES_PROD_MACH_TEMPLATE.PMTMPL_FLAG? |
| UDFs > PMTMPL_UDF? | ES_PROD_MACH_TEMPLATE.PMTMPL_UDF? |
| Foreign Keys > MACH_ID | ES_PROD_MACH_TEMPLATE.MACH_ID |
| Foreign Keys > PROD_ID | ES_PROD_MACH_TEMPLATE.PROD_ID |
| Foreign Keys > TMPL_ID | ES_PROD_MACH_TEMPLATE.TMPL_ID |
Production Plan
| Metadata model reference | Database reference |
|---|---|
| Action | ES_PROD_MACH_PLAN.PRODPLAN_IS_REMOVE |
| Production Plan Start Date | ES_PROD_MACH_PLAN.PRODPLAN_START_DATE |
| Production Plan End Date | ES_PROD_MACH_PLAN.PRODPLAN_END_DATE |
| UDFs > PROD_PLANFLAG? | ES_PROD_MACH_PLAN.PRODPLAN_FLAG? |
| Keys > PRODPLAN_ID | ES_PROD_MACH_PLAN.PRODPLAN_ID |
| Foreign Keys > MACH_ID | ES_PROD_MACH_PLAN.MACH_ID |
| Foreign Keys > PLANSTAT_ID | ES_PROD_MACH_PLAN.PLANSTAT_ID |
Production Plan Shift
| Metadata model reference | Database reference |
|---|---|
| Keys > PLSHIDFT_ID | ES_PROD_MACH_PLAN_SHIFT.PLSHIFT_ID |
| Foreign Keys > PRODPLAN_ID | ES_PROD_MACH_PLAN_SHIFT.PRODPLAN_ID |
| Foreign Keys > SHIFTSUM_ID | ES_PROD_MACH_PLAN_SHIFT.SHIFTSUM_ID |
Production Plan Status
| Metadata model reference | Database reference |
|---|---|
| Production Plan Status Name | ES_PROD_MACH_PLAN_STATUS.PLANSTAT_NAME |
| Production Plan Status Description | ES_PROD_MACH_PLAN_STATUS.PLANSTAT_DESC |
| Keys > PLANSTAT_ID | ES_PROD_MACH_PLAN_STATUS.PLANSTAT_ID |
| Keys > PLANSTAT_ID | ES_PROD_MACH_PLAN_STATUS.PLANSTAT_ID |
Project
| Metadata model reference | Database reference |
|---|---|
| Project Name | PROJECT.PROJ_LOC_NAME |
| Project Description | PROJECT.PROJ_LOC_DESC |
| Keys > PROJ_ID | PROJECT.PROJ_ID |
Quarter Time Period
Query Subject Filter: Days between Start Date and End Date is > 80 and < 100 days
| Metadata model reference | Database reference |
|---|---|
| Quarter | FCST_TIME_PERIOD.FCTP_LOC_NAME |
| Quarter 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 |
Reason
| Metadata model reference | Database reference |
|---|---|
| Reason Name | ES_REASON.REASON_LOC_NAME |
| Reason Description | ES_REASON.REASON_LOC_DESC |
| Reason Sort Order | ES_REASON.REASON_SORT_ORDER |
| Is Default Reject | ES_REASON.REASON_DEF_REJECT |
| Reject Due to Compliance | ES_REASON.REASON_DEF_REJECT_SKDCOMP |
| Reject Due to Availability | ES_REASON.REASON_DEF_AVAIL |
| Keys > REASON_ID | ES_REASON.REASON_ID |
| UDFs > REASON_FLAG? | ES_REASON.REASON_FLAG? |
| UDFs > REASON_UDF? | ES_REASON.REASON_UDF? |
Relief Block
| Metadata model reference | Database reference |
|---|---|
| Relief Block Create Date | ES_RELIEF_BLOCK.RELBLK_CREATE_DATE |
| Relief Block Action Date | ES_RELIEF_BLOCK.RELBLK_ACTION_DATE |
| Relief Block Start Date | ES_RELIEF_BLOCK.RELBLK_START_DATE |
| Relief Block End Date | ES_RELIEF_BLOCK.RELBLK_END_DATE |
| Keys > RELBLK_ID | ES_RELIEF_BLOCK.RELBLK_ID |
| Foreign Keys > EMP_ID | ES_RELIEF_BLOCK.EMP_ID |
| UDFs > RELBLK_FLAG? | ES_RELIEF_BLOCK.RELBLK_FLAG? |
| UDFs > RELBLK_UDF? | ES_RELIEF_BLOCK.RELBLK_UDF? |
Relief Block Employee
| Metadata model reference | Database reference |
|---|---|
| Employee ID | EMPLOYEE.EMP_NAME |
| Full Name | EMPLOYEE.EMP_FULLNAME |
| First Name | EMPLOYEE.EMP_FIRSTNAME |
| Last Name | EMPLOYEE.EMP_LASTNAME |
| Is Full Time | EMPLOYEE.EMP_FULLTIME |
| Status | EMPLOYEE.EMP_STATUS |
| Is Home Team | SEC_EMPLOYEE.EMPT_HOME_TEAM |
| Base Rate | EMPLOYEE.EMP_BASE_RATE |
| Hire Date | EMPLOYEE.EMP_HIRE_DATE |
| Effective Date | EMPLOYEE.EMP_EFFECTIVE_DATE |
| Termination Date | EMPLOYEE.EMP_TERMINATION_DATE |
| Seniority Date | EMPLOYEE.EMP_SENIORITY_DATE |
| Birth Date | EMPLOYEE.EMP_BIRTH_DATE |
| SIN | EMPLOYEE.EMP_SIN |
| Seniority | EMPLOYEE.EMP_SENIORITY_NUMBER |
| Shift Pattern Offset | EMPLOYEE.EMP_SHFTPAT_OFFSET |
| Default Minutes | EMPLOYEE.EMP_DEF_MINUTES |
| Full Time Equivalent | EMPLOYEE.EMP_FTE |
| System Scheduling Enabled | EMPLOYEE.EMP_SYSTEM_SCHEDULING_ENABLED |
| Keys > EMP_ID | EMPLOYEE.EMP_ID |
| Keys > WBT_ID | SEC_EMPLOYEE.WBT_ID |
| Keys > TEAM_START_DATE | SEC_EMPLOYEE.START_DATE |
| Keys > TEAM_END_DATE | SEC_EMPLOYEE.END_DATE |
| Work Type > Work Type Name | EMPLOYEE_WORK_TYPE.EMPWRKTYP_NAME |
| Work Type > Work Type Description | EMPLOYEE_WORK_TYPE.EMPWRKTYP_DESC |
| Work Type > Work Type Full Time | EMPLOYEE_WORK_TYPE.EMPWRKTYP_FULLTIME |
| Work Type > Work Type Sort Order | EMPLOYEE_WORK_TYPE.EMPWRKTYP_SORTORDER |
| Work Type > Work Type UDFs > EMPWRKTYP_FLAG? | EMPLOYEE_WORK_TYPE.EMPWRKTYP_FLAG? |
| Work Type > Work Type UDFs > EMPWRKTYP_UDF? | EMPLOYEE_WORK_TYPE.EMPWRKTYP_UDF? |
| Employment Type > Employment Type Name | EMPLOYMENT_TYPE.EMPTYP_NAME |
| Employment Type > Employment Type Description | EMPLOYMENT_TYPE.EMPTYP_DESC |
| Employment Type > Employment Type Sort Order | EMPLOYMENT_TYPE.EMPTYP_SORTORDER |
| Employment Type > Employment Type UDFs > EMPTYP_FLAG? | EMPLOYMENT_TYPE.EMPTYP_FLAG? |
| Employment Type > Employment Type UDFs > EMPTYP_UDF? | EMPLOYMENT_TYPE.EMPTYP_UDF? |
| UDFs > EMP_FLAG? | EMPLOYEE.EMP_FLAG? |
| UDFs > EMP_VAL? | EMPLOYEE.EMP_VAL? |
Required Job
Burst Staffing
Definition of Required Job is the same as Job query subject.
| Metadata model reference | Database reference |
|---|---|
| Job Name | JOB.JOB_NAME |
| Job Description | JOB.JOB_DESC |
| Tipped | JOB.JOB_TIP |
| Healthcare Type | JOB.JOB_RPT_HCTYPE |
| Job UDFs > JOB_FLAG? | JOB.JOB_FLAG? |
| Job UDFs > JOB_REFKEY? | JOB.JOB_REFKEY? |
| Job UDFs > JOB_VAL? | JOB.JOB_VAL? |
| Keys > JOB_ID | JOB.JOB_ID |
Required Job Rate
Burst Staffing
Definition of Required Job Rate is the same as Job Rate query subject.
| Metadata model reference | Database reference |
|---|---|
| Index | JOB_RATE.JOBRATE_INDEX |
| Effective Date | JOB_RATE.JOBRATE_EFFECTIVE_DATE |
| Rate | JOB_RATE.JOBRATE_RATE |
| Job Rate UDFs > JOBRATE_FLAG? | JOB_RATE.JOBRATE_FLAG? |
| Job Rate UDFs > JOBRATE_VAL? | JOB_RATE.JOBRATE_VAL? |
| Foreign Keys > JOB_ID | JOB_RATE.JOBRATE_ID |
Rotation
| Metadata model reference | Database reference |
|---|---|
| Rotation Name | ES_ROTATION.ROT_NAME |
| Rotation Description | ES_ROTATION.ROT_DESC |
| Rotation Length | ES_ROTATION.ROT_LENGTH |
| Rotation Start Date | ES_ROTATION.ROT_START_DATE |
| Rotation Create Date | ES_ROTATION.ROT_CREATE_DATE |
| Default Rows | ES_ROTATION.ROT_DEFAULT_ROWS |
| Rotation Publish Status | ES_ROTATION.ROT_PUBLISH_STATUS |
| Rotation Active Status | ES_ROTATION.ROT_ACTIVE_STATUS |
| One-Time Schedule Start Date | ES_ROTATION.OTS_START_DATE |
| One-Time Schedule End Date | ES_ROTATION.OTS_END_DATE |
| UDFs > ROT_FLAG? | ES_ROTATION.ROT_FLAG? |
| UDFs > ROT_UDF? | ES_ROTATION.ROT_UDF? |
| Keys > ROT_ID | ES_ROTATION.ROT_ID |
| Foreign Keys > ROTYP_ID | ES_ROTATION.ROTYP_ID |
| Foreign Keys > WBT_ID | ES_ROTATION.WBT_ID |
| Foreign Keys > TEMPLATE_ID | ES_ROTATION.TEMPLATE_ID |
Rotation Publish Task
| Metadata model reference | Database reference |
|---|---|
| Rotation Publish Task Type | ES_ROTATION_PUBLISH_TASK.ROTPUBTSK_TYPE |
| Rotation Publish Task Status | ES_ROTATION_PUBLISH_TASK.ROTPUBTSK_STATUS |
| Rotation Publish Task Create Date | ES_ROTATION_PUBLISH_TASK.ROTPUBTSK_CREATE_DATE |
| Rotation Publish Task Scheduled Date | ES_ROTATION_PUBLISH_TASK.ROTPUBTSK_SCHEDULED_DATE |
| Rotation Publish Task Processed Date | ES_ROTATION_PUBLISH_TASK.ROTPUBTSK_PROCESSED_DATE |
| UDFs > ROTPUBTSK_FLAG? | ES_ROTATION_PUBLISH_TASK.ROTPUBTSK_FLAG? |
| UDFs > ROTPUBTSK_UDF? | ES_ROTATION_PUBLISH_TASK.ROTPUBTSK_UDF? |
| Keys > ROTPUBTSK_ID | ES_ROTATION_PUBLISH_TASK.ROTPUBTSK_ID |
| Foreign Keys > ROT_ID | ES_ROTATION_PUBLISH_TASK.ROT_ID |
| Foreign Keys > WBU_ID | ES_ROTATION_PUBLISH_TASK.WBU_ID |
| Foreign Keys > WBU_ID_ACTUAL | ES_ROTATION_PUBLISH_TASK.WBU_ID_ACTUAL |
Rotation Row
| Metadata model reference | Database reference |
|---|---|
| Is Rotation Row Method | ES_ROTATION_ROW.ROTROW_IS_OTSROW |
| Is One-Time Schedule Row | ES_ROTATION_ROW.ROTROW_IS_LOCKED |
| Is Rotation Row Locked | ES_ROTATION_ROW.ROTROW_IS_MODIFIED |
| UDFs > WBT_FLAG? | ES_ROTATION_ROW.ROTROW_FLAG? |
| UDFs > WBT_UDF? | ES_ROTATION_ROW.ROTROW_UDF? |
| Keys > ROTROW_ID | ES_ROTATION_ROW.ROTROW_ID |
| Foreign Keys > ROT_ID | ES_ROTATION_ROW.ROT_ID |
| Foreign Keys > ROTROW_TEMPLATEROW_ID | ES_ROTATION_ROW.ROTROW_TEMPLATEROW_ID |
Rotation Row Assignment
| Metadata model reference | Database reference |
|---|---|
| Assignment Start Date | ES_ROTROW_ASGMT.RRASSN_EFF_START_DATE |
| Assignment End Date | ES_ROTROW_ASGMT.RRASSN_EFF_END_DATE |
| Assignment Employee Status | ES_ROTROW_ASGMT.RRASSN_STATUS |
| Assignment Comment | ES_ROTROW_ASGMT.RRASSN_COMMENT |
| Is Override LM | ES_ROTROW_ASGMT.RRASSN_LMOVERRIDE |
| LAT Status | ES_ROTROW_ASGMT.RRASSN_LTA |
| RRASSN_TEMP_UNASSIGN | ES_ROTROW_ASGMT.RRASSN_TEMP_UNASSIGN |
| UDFs > RRASSN_FLAG? | ES_ROTROW_ASGMT.RRASSN_FLAG? |
| UDFs > RRASSN_UDF? | ES_ROTROW_ASGMT.RRASSN_UDF? |
| Keys > RRASSN_ID | ES_ROTROW_ASGMT.RRASSN_ID |
| Foreign Keys > ACT_ID | ES_ROTROW_ASGMT.ACT_ID |
| Foreign Keys > EMP_ID | ES_ROTROW_ASGMT.EMP_ID |
| Foreign Keys > EMP_ORIG_ID | ES_ROTROW_ASGMT.EMP_ORIG_ID |
| Foreign Keys > ROTROW_ID | ES_ROTROW_ASGMT.ROTROW_ID |
Rotation Row Conflict
| Metadata model reference | Database reference |
|---|---|
| Work Date | ES_ROTROW_CONFLICTS.WORK_DATE |
| Conflict Action | ES_ROTROW_CONFLICTS.RRCONFL_ACTION |
| Conflict Create Date | ES_ROTROW_CONFLICTS.RRCONFL_CREATE_DATE |
| Conflict Process Date | ES_ROTROW_CONFLICTS.RRCONFL_PROCESS_DATE |
| Conflict Status | ES_ROTROW_CONFLICTS.RRCONFL_STATUS |
| Keys > RRCONFL_ID | ES_ROTROW_CONFLICTS.RRCONFL_ID |
| Keys > ACT_ID | ES_ROTROW_CONFLICTS.ACT_ID |
| Foreign Keys > DEPT_ID | ES_ROTROW_CONFLICTS.DEPT_ID |
| Foreign Keys > DOCK_ID | ES_ROTROW_CONFLICTS.DOCK_ID |
| Foreign Keys > EMP_ID | ES_ROTROW_CONFLICTS.EMP_ID |
| Foreign Keys > JOB_ID | ES_ROTROW_CONFLICTS.JOB_ID |
| Foreign Keys > PROJ_ID | ES_ROTROW_CONFLICTS.PROJ_ID |
| Foreign Keys > ROT_ID | ES_ROTROW_CONFLICTS.ROT_ID |
| Foreign Keys > ROTROW_ID | ES_ROTROW_CONFLICTS.ROTROW_ID |
| Foreign Keys > SHIFTSUM_ID | ES_ROTROW_CONFLICTS.SHIFTSUM_ID |
Rotation Row Version
| Metadata model reference | Database reference |
|---|---|
| Row Version | ES_RRVER_STATUS.RRVS_NAME |
Rotation Team
| Metadata model reference | Database reference |
|---|---|
| Team Name | ES_TEAM_ROTATION TEAM.Team Name |
| Team Description | ES_TEAM_ROTATION TEAM.Team Description |
| Team Level | ES_TEAM_ROTATION TEAM.Team Level |
| UDFs > WBT_FLAG? | ES_UDFS_TEAM.WBT_FLAG? |
| UDFs > WBT_UDF? | ES_UDFS_TEAM.WBT_UDF? |
| Keys > WBT_ID | ES_KEYS_TEAM.WBT_ID |
| Keys > WBT_PARENT_ID | ES_KEYS_KEYS.WBT_PARENT_ID |
| Keys > WBT_LFT | ES_KEYS_TEAM.WBT_LFT |
| Keys > WBT_RGT | ES_KEYS_TEAM.WBT_RGT |
Rotation Type
| Metadata model reference | Database reference |
|---|---|
| Rotation Type Name | ES_ROTATION_TYPE.Rotation Type Name |
| Rotation Type Description | ES_ROTATION_TYPE.Rotation Type Description |
| UDFs > ROTYP_FLAGS? | ES_UDFS_TYPE.ROTYP_FLAGS? |
| UDFs > ROTYP_UDF? | ES_UDFS_TYPE.ROTYP_UDF? |
| Keys > ROTYP_ID | ES_KEYS_TYPE.ROTYP_ID |
| Create Published Shifts | ES_ROTATION_TYPE.ROTYP_USE_PUBLISHED_STATE |
Rotation Version
| Metadata model reference | Database reference |
|---|---|
| Rotation Version Name | ES_ROTATION_VERSION.Rotation Version Name |
| Rotation Version Description | ES_ROTATION_VERSION.Rotation Version Description |
| Effective Start Date | ES_EFFECTIVE_VERSION.Effective Start Date |
| Effective End Date | ES_EFFECTIVE_VERSION.Effective End Date |
| Rotation Version Status | ES_ROTATION_VERSION.Rotation Version Status |
| Rotation Version Create Date | ES_ROTATION_ROTATION.Rotation Version Create Date |
| UDFs > ROTVR_FLAG? | ES_UDFS_VERSION.ROTVR_FLAG? |
| UDFs > ROTVR_UDF? | ES_UDFS_VERSION.ROTVR_UDF? |
| Keys > ROTVR_ID | ES_KEYS_VERSION.ROTVR_ID |
| Foreign Keys > ROT_ID | ES_FOREIGN_FOREIGN.ROT_ID |
Row Labor Metric
| Metadata model reference | Database reference |
|---|---|
| Labor Metric Row Name | ES_METRIC_LABOR.Labor Metric Row Name |
| Labor Metric Order | ES_METRIC_METRIC.Labor Metric Order |
| Labor Metric Split Row | ES_METRIC_LABOR.Labor Metric Split Row |
| Labor Metric Planned FTE | ES_METRIC_LABOR.Labor Metric Planned FTE |
| Is Labor Metric Modified | ES_METRIC_IS.Is Labor Metric Modified |
| Override Shift Labor Metric | ES_METRIC_OVERRIDE.Override Shift Labor Metric |
| Keys > ROWLM_ID | ES_METRIC_METRIC.ROWLM_ID |
| Foreign Keys > CALCGRP_ID | ES_METRIC_FOREIGN.CALCGRP_ID |
| Foreign Keys > CMGRP_ID | ES_METRIC_FOREIGN.CMGRP_ID |
| Foreign Keys > DEPT_ID | ES_METRIC_FOREIGN.DEPT_ID |
| Foreign Keys > DOCK_ID | ES_METRIC_FOREIGN.DOCK_ID |
| Foreign Keys > JOB_ID | ES_METRIC_FOREIGN.JOB_ID |
| Foreign Keys > PROJ_ID | ES_METRIC_FOREIGN.PROJ_ID |
| Foreign Keys > ROTROW_ID | ES_METRIC_FOREIGN.ROTROW_ID |
| Foreign Keys > ROTVR_ID | ES_METRIC_FOREIGN.ROTVR_ID |
| Foreign Keys > ROWLM_TEMPLT_ID | ES_METRIC_KEYS.ROWLM_TEMPLT_ID |
| Foreign Keys > RRVER_ID | ES_ROW_LM.RRVER_ID |
Row Shift
| Metadata model reference | Database reference |
|---|---|
| ROWSHIFT_ID | ES_ROW_SHIFTS.ROWSHIFT_ID |
| RROTROW_ID | ES_ROW_SHIFTS.ROTROW_ID |
| Row Shift Sequence | ES_ROW_SHIFTS.ROWSHIFT_SEQ |
| RRVER_ID | ES_ROW_SHIFTS.RRVER_ID |
| RSSHIFT_ID | ES_ROW_SHIFTS.ESSHIFT_ID |
Row Shift Rotation Version
| Metadata model reference | Database reference |
|---|---|
| Rotation Version Name | ES_ROTATION_VERSION.ROTVR_NAME |
| Rotation Version Description | ES_ROTATION_VERSION.ROTVR_DESC |
| Rotation Version Create Date | ES_ROTATION_VERSION.ROTVR_CREATE_DATE |
| Effective Start Date | ES_ROTATION_VERSION.ROTVR_EFF_START_DATE |
| Effective End Date | ES_ROTATION_VERSION.ROTVR_EFF_END_DATE |
| Rotation Version Status | ES_ROTATION_VERSION.ROTVR_STATUS |
| Keys > ROTVR_ID | ES_ROTATION_VERSION.ROTVR_ID |
| Foreign Keys > ROT_ID | ES_ROTATION_VERSION.ROT_ID |
| UDFs > ROTVR_FLAG? | ES_ROTATION_VERSION.ROTVR_FLAG? |
| UDFs > ROTVR_UDF? | ES_ROTATION_VERSION.ROTVR_UDF? |
Row Shift Violation
| Metadata model reference | Database reference |
|---|---|
| Violation Value | ES_VIOLATION_SHIFT VIOLATION.Violation Value |
| User Name | ES_VIOLATION_SHIFT VIOLATION.User Name |
| Actual User Name | ES_VIOLATION_VIOLATION.Actual User Name |
| Keys > ROWSHIFT_ID | ES_VIOLATION_VIOLATION.ROWSHIFT_ID |
| Keys > VIO_ID | ES_VIOLATION_VIOLATION.VIO_ID |
| Keys > CMPGRPR_ID | ES_VIOLATION_VIOLATION.CMPGRPR_ID |
| UDFs > VIO_FLAG? | ES_VIOLATION_VIOLATION.VIO_FLAG? |
| UDFs > VIO_UDF? | ES_VIOLATION_VIOLATION.VIO_UDF? |
RTSS Process
| Metadata model reference | Database reference |
|---|---|
| Process Name | RTSS_PROCESS.RTSSP_NAME |
| Process Description | RTSS_PROCESS.RTSSP_DESC |
| Process Start Date | RTSS_PROCESS.RTSSP_START_DATE |
| Process End Date | RTSS_PROCESS.RTSSP_END_DATE |
| Process Status | RTSS_PROCESS.RTSSP_STATUS |
| UDFs > RTSSP_FLAG? | RTSS_PROCESS.RTSSP_FLAG? |
| UDFs > RTSSP_UDF? | RTSS_PROCESS.RTSSP_UDF? |
| Keys > RTSSP_ID | RTSS_PROCESS.RTSSP_ID |
| Foreign Keys > WBT_ID | RTSS_PROCESS.WBT_ID |
| Foreign Keys > RTSSPS_ID | RTSS_PROCESS.RTSSPS_ID |
RTSS Process Status
| Metadata model reference | Database reference |
|---|---|
| Process Status Name | RTSS_PROCESS_STAT.RTSSPS_NAME |
| Process Status Description | RTSS_PROCESS_STAT.RTSSPS_DESC |
| UDF's > RTSSPS_FLAG? | RTSS_PROCESS_STAT.RTSSPS_FLAG? |
| UDF's > RTSSPS_UDF? | RTSS_PROCESS_STAT.RTSSPS_UDF? |
| Keys > RTSSPS_ID | RTSS_PROCESS_STAT.RTSSPS_ID |
RTSS Rule
| Metadata model reference | Database reference |
|---|---|
| Rule Name | RTSS_RULE.RTSSR_NAME |
| Rule Description | RTSS_RULE.RTSSR_DESC |
| UDFs > RTSSR_FLAG? | RTSS_RULE.RTSSR_FLAG? |
| UDFs > RTSSR_UDF? | RTSS_RULE.RTSSR_UDF? |
| Keys > RTSSR_ID | RTSS_RULE.RTSSR_ID |
RTSS Rule Enforcement Level
| Metadata model reference | Database reference |
|---|---|
| Rule Enforcement Level Name | RTSS_RUL_ENF_LEVEL.RTSSREL_NAME |
| Rule Enforcement Level Description | RTSS_RUL_ENF_LEVEL.RTSSREL_DESC |
| UDFs > RTSSREL_FLAG? | RTSS_RUL_ENF_LEVEL.RTSSREL_FLAG? |
| UDFs > RTSSREL_UDF? | RTSS_RUL_ENF_LEVEL.RTSSREL_UDF? |
| Keys > RTSSREL_ID | RTSS_RUL_ENF_LEVEL.RTSSREL_ID |
RTSS Rule Error Log
| Metadata model reference | Database reference |
|---|---|
| Rule Error Start Date | RTSS_RULE_ERR_LOG.RTSSRLG_START_DATE |
| Rule Error End Date | RTSS_RULE_ERR_LOG.RTSSRLG_END_DATE |
| Rule Error Message | RTSS_RULE_ERR_LOG.RTSSRLG_ERROR_MSG |
| UDFs > RTSSRLG_FLAG? | RTSS_RULE_ERR_LOG.RTSSRLG_FLAG? |
| UDF's > RTSSRLG_UDF? | RTSS_RULE_ERR_LOG.RTSSRLG_UDF? |
| Keys > RTSSRLG_ID | RTSS_RULE_ERR_LOG.RTSSRLG_ID |
| Foreign Keys > EMP_ID | RTSS_RULE_ERR_LOG.EMP_ID |
| Foreign Keys > RTSSP_ID | RTSS_RULE_ERR_LOG.RTSSP_ID |
| Foreign Keys > RTSSR_ID | RTSS_RULE_ERR_LOG.RTSSR_ID |
| Foreign Keys > RTSSREL_ID | RTSS_RULE_ERR_LOG.RTSSREL_ID |
Run Reports
| Metadata model reference | Database reference |
|---|---|
| User Name | COGIPF_USERLOGON.USERNAME |
| Report Name | COGIPF_RUNREPORT.REPORT NAME |
| Report Type | COGIPF_RUNREPORT.TARGET TYPE |
| Report Search Path | COGIPF_RUNREPORT.REPORT PATH |
| Session ID | COGIPF_RUNREPORT.SESSION ID |
| Request ID | COGIPF_RUNREPORT.REQUEST ID |
| Execution Time | COGIPF_RUNREPORT.RUN TIME |
| Time Stamp | COGIPF_RUNREPORT.TIME STAMP |
| Package | COGIPF_RUNREPORT.PACKAGE |
| Status | COGIPF_RUNREPORT.STATUS |
| Error Details | COGIPF_RUNREPORT.ERROR DETAILS |