SCD_TRHI_SCR_VW (SQL View)	Index Back
Suppliers ordered by post date Suppliers ordered by lastest post date

SCD_TRHI_SCR_VW

(SQL View)

Suppliers ordered by post date

Suppliers ordered by lastest post date

SELECT ROWNUM AS ROWNBR ,T.SCD_EVALTEE_SETID ,T.SCD_EVALUATEE_ID ,T.SCD_SCORE_TREND , T.LASTUPDDTTM FROM ( SELECT A.SCD_EVALTEE_SETID ,A.SCD_EVALUATEE_ID ,(B.SCD_SCORE-C.SCD_SCORE) SCD_SCORE_TREND , 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 INNER JOIN PS_SCD_BLD_EVAL_HD C ON A.SCD_PRE_POST_EVLID = C.SCD_EVALUATION_ID WHERE A.LASTUPDDTTM BETWEEN ( SELECT SYSDATE - SCD_VNDSEL_TM_FRM FROM PS_INSTALLATION_SC) AND SYSDATE ORDER BY SCD_SCORE_TREND DESC ) 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_TREND Number(10,6) DECIMAL(9,6) NOT NULL Score Trend

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.

#	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_TREND	Number(10,6)	DECIMAL(9,6) NOT NULL	Score Trend
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.