SCD_DN_EVQST_VW(SQL View) |
Index Back |
|---|
| SELECT A.SCD_EVALUATION_ID , A.SCD_SECTION_ID , A.SCD_QUESTION_ID , A.SCD_EVALUATOR_ID , B.OPRDEFNDESC , C.SCD_SENT_DATE , C.SCD_RESP_STATUS , C.SCD_STATUS_DTTM , A.SCD_SCORE , A.SCD_WGT_SECT_SCORE , A.SCD_WGT_OVER_SCORE , D.SELECT_FLAG FROM PS_SCD_USREVAL_QST A INNER JOIN PSOPRDEFN B ON A.SCD_EVALUATOR_ID = B.OPRID INNER JOIN PS_sCD_USR_EVAL_HD C ON A.SCD_EVALUATION_ID=C.SCD_EVALUATION_ID AND A.SCD_EVALUATOR_ID=C.Scd_Evaluator_Id INNER JOIN PS_SCD_USREVAL_SCT D ON A.SCD_EVALUATION_ID=D.SCD_EVALUATION_ID AND D.SCD_SECTION_ID=A.SCD_SECTION_ID AND d.scd_evaluator_id=a.scd_evaluator_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCD_EVALUATION_ID | Character(10) | VARCHAR2(10) NOT NULL | Evaluation ID |
| 2 | SCD_SECTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Section ID |
| 3 | SCD_QUESTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Question ID |
| 4 | SCD_EVALUATOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Evaluator ID |
| 5 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 6 | SCD_SENT_DATE | Date(10) | DATE | Sent Date |
| 7 | SCD_RESP_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Evaluation Build Status
AL=All DE=Declined IP=In Process NE=New OM=Omitted PE=Pending SU=Submitted |
| 8 | SCD_STATUS_DTTM | DateTime(26) | TIMESTAMP | Status Date Time |
| 9 | SCD_SCORE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Scorecarding Score |
| 10 | SCD_WGT_SECT_SCORE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Weighted Section Score |
| 11 | SCD_WGT_OVER_SCORE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Weighted Overall Score |
| 12 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
N=No Y=Yes |