SFA_CRC_DESG_V3

(SQL View)
 Index Back

CRC Guarantor Destination Id's

List of Servicer, Lenders, and Guarantors used in CommonLine Loan Processing. No status in SQL. OPEID is the only key.

SELECT SFA_CR_OPEID , SFA_CR_BRANCH_ID , DESCR FROM PS_SFA_CRC_DEST_ID WHERE SFA_CR_OPEID_TYPE = 'G'

  • Related Language Record: SFACRCDESGV3LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SFA_CR_OPEID Character(8) VARCHAR2(8) NOT NULL OPEID
    2 SFA_CR_BRANCH_ID Character(4) VARCHAR2(4) NOT NULL Branch ID

    Default Value: 0000

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