SCD_EVALUATION_IDSCD_TEMPLATE_IDSCD_RATIN_MODEL_IDOP=Pending and Released
PE=Pending
PO=Posted
RE=Released
WD=Withdrawn
SCD_RMEVUSE_VW(SQL View) |
Index Back |
|---|---|
Models used in evaluationsScoring Models used in evaluations view SELECT A.scd_evaluation_id ,A.scd_template_id ,B.scd_ratin_model_id ,A.scd_eval_status FROM PS_SCD_BLD_EVAL_HD A , PS_SCD_TEMPL_SECT B WHERE A.scd_template_id = B.scd_template_id AND A.scd_eval_status IN('RE','PO') AND A.scd_version_nbr = B.scd_version_nbr |
| SELECT A.scd_evaluation_id ,A.scd_template_id ,B.scd_ratin_model_id ,A.scd_eval_status FROM PS_SCD_BLD_EVAL_HD A , PS_SCD_TEMPL_SECT B WHERE A.scd_template_id = B.scd_template_id AND A.scd_eval_status IN('RE','PO') AND A.scd_version_nbr = B.scd_version_nbr |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCD_EVALUATION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Evaluation ID |
| 2 | SCD_TEMPLATE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Template ID |
| 3 | SCD_RATIN_MODEL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Rating Model ID |
| 4 | SCD_EVAL_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Evaluation Build Status
OP=Pending and Released PE=Pending PO=Posted RE=Released WD=Withdrawn |