SCD_DN_EVSCT_VW(SQL View) |
Index Back |
---|
SELECT A.SCD_EVALUATION_ID , A.SCD_SECTION_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_OVER_SCORE , A.SELECT_FLAG FROM PS_SCD_USREVAL_SCT 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 |
# | 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_EVALUATOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Evaluator ID |
4 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
5 | SCD_SENT_DATE | Date(10) | DATE | Sent Date |
6 | 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 |
7 | SCD_STATUS_DTTM | DateTime(26) | TIMESTAMP | Status Date Time |
8 | SCD_SCORE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Scorecarding Score |
9 | SCD_WGT_OVER_SCORE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Weighted Overall Score |
10 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
N=No Y=Yes |