CREDIT_RTG_TBL(SQL Table) |
Index Back |
---|---|
Credit RatingsUser defined Credit ratings child table to CREDIT_RTG_DEFN |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.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 Prompt Table: CREDIT_RTG_DEFN |
3 | CR_RATING_VALUE | Number(3,0) | SMALLINT NOT NULL | User defined rating values utilized to assign priorities to a given set of credit ratings. |
4 | CR_RATING | Character(5) | VARCHAR2(5) NOT NULL | The market credit rating associated wth a given bank/counterparty. |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |