FCLTY_RTG_VW (SQL View)	Index Back
Current Credit Ratings Current Credit Ratings used as lookup for FCLTY_DEBT_RTG on Commercial Paper facilities

FCLTY_RTG_VW

(SQL View)

Current Credit Ratings

Current Credit Ratings used as lookup for FCLTY_DEBT_RTG on Commercial Paper facilities

SELECT A.SETID , A.CR_RATING_TYPE ,A.EFFDT , A.CR_RATING_VALUE , B.CR_RATING , B.DESCR FROM PS_TRX_DEBT_RATING A , PS_CREDIT_RTG_TBL B WHERE A.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_TRX_DEBT_RATING E WHERE E.SETID= A.SETID AND E.CR_RATING_TYPE = A.CR_RATING_TYPE AND E.EFF_STATUS = 'A' AND E.EFFDT<= %CurrentDateIn) AND B.CR_RATING_TYPE = A.CR_RATING_TYPE AND B.CR_RATING_VALUE = A.CR_RATING_VALUE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 CR_RATING_TYPE Character(8) VARCHAR2(8) NOT NULL The market credit agency associated wth a given group of credit ratings.
I=IBCA
M=Moody's
S=Standard && Poors

3 EFFDT_FROM Date(10) DATE Effective Date From

4 CR_RATING_VALUE Number(3,0) SMALLINT NOT NULL User defined rating values utilized to assign priorities to a given set of credit ratings.

5 CR_RATING Character(5) VARCHAR2(5) NOT NULL The market credit rating associated wth a given bank/counterparty.

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CR_RATING_TYPE	Character(8)	VARCHAR2(8) NOT NULL	The market credit agency associated wth a given group of credit ratings. I=IBCA M=Moody's S=Standard && Poors
3	EFFDT_FROM	Date(10)	DATE	Effective Date From
4	CR_RATING_VALUE	Number(3,0)	SMALLINT NOT NULL	User defined rating values utilized to assign priorities to a given set of credit ratings.
5	CR_RATING	Character(5)	VARCHAR2(5) NOT NULL	The market credit rating associated wth a given bank/counterparty.
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description