CREDIT_RTG_TBL

(SQL Table)
Index Back

Credit Ratings

User defined Credit ratings child table to CREDIT_RTG_DEFN

  • Related Language Record: CRED_RT_TBL_LNG
  • Parent record: 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