SCD_HDRSCR1_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 , 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(A.SCD_SCORE, 2) AS SCD_SCORE FROM PS_SCD_BLD_EVAL_HD A INNER JOIN ps_vendor D ON D.SETID = A.SCD_EVALTEE_SETID AND D.VENDOR_ID = A.SCD_EVALUATEE_ID INNER JOIN PS_SCD_TEMPLATE_HD F ON F.SCD_TEMPLATE_ID = A.SCD_TEMPLATE_ID AND F.scd_version_nbr = A.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_EVALUATION_ID | Character(10) | VARCHAR2(10) NOT NULL | Evaluation ID |
| 6 | SCD_EVAL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Evaluation Name |
| 7 | SCD_EVALTEE_SETID | Character(5) | VARCHAR2(5) NOT NULL | Evaluatee Set ID |
| 8 | SCD_EVALUATEE_ID | Character(30) | VARCHAR2(30) NOT NULL | Evaluatee ID |
| 9 | VENDOR_NAME | Character(30) | VARCHAR2(30) NOT NULL | Supplier Name |
| 10 | SCD_CAL_SETID | Character(5) | VARCHAR2(5) NOT NULL | Calendar Set ID |
| 11 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 12 | CALENDAR_NAME | Character(50) | VARCHAR2(50) NOT NULL | Calendar Name |
| 13 | SCD_EVAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Evaluation Year |
| 14 | SCD_EVAL_PERIOD | Number(3,0) | SMALLINT NOT NULL | Evaluation Period. |
| 15 | PERIOD_ABBRV | Character(3) | VARCHAR2(3) NOT NULL | Abbreviation |
| 16 | SCD_FROM_DATE | Date(10) | DATE | From Date |
| 17 | SCD_TO_DATE | Date(10) | DATE | To Date |
| 18 | SCD_SCORE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Scorecarding Score |