SCD_SECTSCR1_VW

(SQL View)
 Index Back

Section scrore trending


SELECT A.SCD_TEMPLATE_ID , F.SCD_TEMPLATE_NAME , A.SCD_VERSION_NBR , A.SCD_EVAL_PD_TYPE , B.SCD_SECTION_ID , E.SCD_SECTION_NAME , A.SCD_EVALUATION_ID , A.SCD_EVAL_NAME , A.SCD_EVALTEE_SETID , A.SCD_EVALUATEE_ID , D.NAME1 AS VENDOR_NAME , A.SCD_CAL_SETID , A.CALENDAR_ID , G.DESCR , A.SCD_EVAL_YEAR , A.SCD_EVAL_PERIOD , C.PERIOD_ABBRV , A.SCD_FROM_DATE , A.SCD_TO_DATE , %Round(B.SCD_WGT_OVER_SCORE,2) AS SCD_WGT_OVER_SCORE , %Round(B.SCD_SCORE, 2) AS SCD_SCORE FROM PS_SCD_BLD_EVAL_HD A INNER JOIN PS_SCD_BLD_SECTS B ON A.SCD_EVALUATION_ID = B.SCD_EVALUATION_ID INNER JOIN ps_vendor D ON D.SETID = A.SCD_EVALTEE_SETID AND D.VENDOR_ID = A.SCD_EVALUATEE_ID INNER JOIN PS_SCD_TEMPL_SECT E ON E.SCD_TEMPLATE_ID = A.SCD_TEMPLATE_ID AND E.SCD_VERSION_NBR = A.SCD_VERSION_NBR AND E.SCD_SECTION_ID = B.SCD_SECTION_ID INNER JOIN PS_SCD_TEMPLATE_HD F ON F.SCD_TEMPLATE_ID = E.SCD_TEMPLATE_ID AND F.scd_version_nbr = e.scd_version_nbr LEFT JOIN PS_CAL_DETP_TBL C ON C.CALENDAR_ID = A.CALENDAR_ID AND C.SETID = A.SCD_CAL_SETID AND C.FISCAL_YEAR = A.SCD_EVAL_YEAR AND C.ACCOUNTING_PERIOD = A.SCD_EVAL_PERIOD LEFT JOIN PS_CAL_DEF_SCD1_VW G ON G.SETID = C.SETID AND G.CALENDAR_ID = C.CALENDAR_ID WHERE A.SCD_EVAL_STATUS='PO' AND D.vendor_status = 'A' AND D.vndr_status_po = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCD_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID
2 SCD_TEMPLATE_NAME Character(30) VARCHAR2(30) NOT NULL Template Name
3 SCD_VERSION_NBR Number(5,0) INTEGER NOT NULL Version Number
4 SCD_EVAL_PD_TYPE Character(2) VARCHAR2(2) NOT NULL Evaluator Period Type
AH=Ad-Hoc
CP=Calendar Period
5 SCD_SECTION_ID Character(10) VARCHAR2(10) NOT NULL Section ID
6 SCD_SECTION_NAME Character(30) VARCHAR2(30) NOT NULL Section Name
7 SCD_EVALUATION_ID Character(10) VARCHAR2(10) NOT NULL Evaluation ID
8 SCD_EVAL_NAME Character(30) VARCHAR2(30) NOT NULL Evaluation Name
9 SCD_EVALTEE_SETID Character(5) VARCHAR2(5) NOT NULL Evaluatee Set ID
10 SCD_EVALUATEE_ID Character(30) VARCHAR2(30) NOT NULL Evaluatee ID
11 VENDOR_NAME Character(30) VARCHAR2(30) NOT NULL Supplier Name
12 SCD_CAL_SETID Character(5) VARCHAR2(5) NOT NULL Calendar Set ID
13 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
14 CALENDAR_NAME Character(50) VARCHAR2(50) NOT NULL Calendar Name
15 SCD_EVAL_YEAR Number(4,0) SMALLINT NOT NULL Evaluation Year
16 SCD_EVAL_PERIOD Number(3,0) SMALLINT NOT NULL Evaluation Period.
17 PERIOD_ABBRV Character(3) VARCHAR2(3) NOT NULL Abbreviation
18 SCD_FROM_DATE Date(10) DATE From Date
19 SCD_TO_DATE Date(10) DATE To Date
20 SCD_WGT_OVER_SCORE Signed Number(11,6) DECIMAL(9,6) NOT NULL Weighted Overall Score
21 SCD_SCORE Signed Number(11,6) DECIMAL(9,6) NOT NULL Scorecarding Score