SCD_LOW_SCR_VW(SQL View) |
Index Back |
---|---|
Suppliers ordered by post dateSuppliers ordered by lastest post date |
SELECT ROWNUM AS ROWNBR ,T.SCD_EVALTEE_SETID ,T.SCD_EVALUATEE_ID ,T.SCD_SCORE ,T.LASTUPDDTTM FROM ( SELECT A.SCD_EVALTEE_SETID ,A.SCD_EVALUATEE_ID ,B.SCD_SCORE ,A.LASTUPDDTTM FROM PS_SCD_EVLPST_STAT A INNER JOIN PS_SCD_BLD_EVAL_HD B ON A.SCD_LST_POST_EVLID = B.SCD_EVALUATION_ID WHERE A.LASTUPDDTTM BETWEEN ( SELECT SYSDATE - SCD_VNDSEL_TM_FRM FROM PS_INSTALLATION_SC) AND SYSDATE ORDER BY B.SCD_SCORE ) T |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ROWNBR | Number(7,0) | INTEGER NOT NULL | Row number |
2 | SCD_EVALTEE_SETID | Character(5) | VARCHAR2(5) NOT NULL | Evaluatee Set ID |
3 | SCD_EVALUATEE_ID | Character(30) | VARCHAR2(30) NOT NULL | Evaluatee ID |
4 | SCD_SCORE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Scorecarding Score |
5 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |