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

FCLTY_DEBT_RTG

(SQL Table)

Credit Rating on a Facility

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

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 FCLTY_ID Character(12) VARCHAR2(12) NOT NULL A unique key identifier that represents a given counterparty facility.

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 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
Prompt Table: TRX_DT_RATG_VW

5 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	FCLTY_ID	Character(12)	VARCHAR2(12) NOT NULL	A unique key identifier that represents a given counterparty facility.
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	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 Prompt Table: TRX_DT_RATG_VW
5	CR_RATING_VALUE	Number(3,0)	SMALLINT NOT NULL	User defined rating values utilized to assign priorities to a given set of credit ratings.