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

SCD_TOPN_SUP_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 ,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 A.LASTUPDDTTM 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 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.

#	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.