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