SCD_SCRSTAT1_VW

(SQL View)
 Index Back

Section Statistic

Section Statistic

SELECT H.SCD_EVALUATION_ID , H.SCD_TEMPLATE_ID , S.SCD_SECTION_ID , TS.SCD_SEQ_NBR , TS.SCD_SECTION_NAME , H2.SCD_FROM_DATE , H.SCD_TO_DATE , H.SCD_EVALTEE_SETID , H.SCD_EVALUATEE_ID , S.SCD_SCORE , H2.SCD_VERSION_NBR FROM PS_SCD_TMPPST_STAT H INNER JOIN PS_SCD_BLD_EVAL_HD H2 ON H.SCD_EVALUATION_ID = H2.SCD_EVALUATION_ID INNER JOIN PS_SCD_BLD_SECTS S ON H.SCD_EVALUATION_ID = S.SCD_EVALUATION_ID INNER JOIN PS_SCD_TEMPL_SECT TS ON S.SCD_TEMPLATE_ID = TS.SCD_TEMPLATE_ID AND S.SCD_VERSION_NBR = TS.SCD_VERSION_NBR AND S.SCD_SECTION_ID = TS.SCD_SECTION_ID UNION ALL SELECT A.SCD_EVALUATION_ID , A.SCD_TEMPLATE_ID , '$OVERALL$' AS SCD_SECTION_ID , 99999999 AS SCD_SEQ_NBR , 'OVERALL' AS SCD_SECTION_NAME , B.SCD_FROM_DATE , B.SCD_TO_DATE , A.SCD_EVALTEE_SETID , A.SCD_EVALUATEE_ID , A.SCD_SCORE , B.SCD_VERSION_NBR FROM PS_SCD_TMPPST_STAT A INNER JOIN PS_SCD_BLD_EVAL_HD B ON A.SCD_EVALUATION_ID = B.SCD_EVALUATION_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_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID
3 SCD_SECTION_ID Character(10) VARCHAR2(10) NOT NULL Section ID
4 SCD_SEQ_NBR Number(5,0) INTEGER NOT NULL Sequence Number
5 SCD_SECTION_NAME Character(30) VARCHAR2(30) NOT NULL Section Name
6 SCD_FROM_DATE Date(10) DATE From Date
7 SCD_TO_DATE Date(10) DATE To Date
8 SCD_EVALTEE_SETID Character(5) VARCHAR2(5) NOT NULL Evaluatee Set ID
9 SCD_EVALUATEE_ID Character(30) VARCHAR2(30) NOT NULL Evaluatee ID
10 SCD_SCORE Signed Number(11,6) DECIMAL(9,6) NOT NULL Scorecarding Score
11 SCD_VERSION_NBR Number(5,0) INTEGER NOT NULL Version Number