1. Tables and Views for HCM
  2. HWP_PRED_PERF_RESULTS_V

HWP_PRED_PERF_RESULTS_V

Details

  • Schema: FUSION

  • Object owner: HWP

  • Object type: VIEW

Columns

Name

ENTERPRISE_ID

PROCESS_ID

PERSON_ID

ASSIGNMENT_ID

WORKER_PRED_PERF

Query

SQL_Statement

SELECT hdmr.enterprise_id, hdmr.process_id,

hdmr.person_id, hdmr.assignment_id,

least(hdmr.pred_value * nvl(hmb.correction_value,1),1) worker_pred_perf

FROM hwp_data_mining_process hdmp,

hwp_data_mining_results hdmr,

hwp_models_b hmb

WHERE hdmp.model_code = 'HWP_PERF_MODEL'

AND hdmr.process_id = hdmp.process_id

AND hdmp.model_code = hmb.model_code