FCLTY_DBTRTG_VW (SQL View)	Index Back
Credit Rating on a Facility Used to associate ratings by independent agency to a commercial paper program

FCLTY_DBTRTG_VW

(SQL View)

Credit Rating on a Facility

Used to associate ratings by independent agency to a commercial paper program

SELECT SETID , CR_RATING_TYPE , EFFDT , CR_RATING_VALUE FROM PS_TRX_DEBT_RATING

Parent record: FCLTY_DFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

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 Date(10) DATE Effective Date
Default Value: %date

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
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	Date(10)	DATE	Effective Date Default Value: %date
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.