SFA_CRC_DESL_V3

(SQL View)
 Index Back

CRC Lender 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 , PREF_LENDER FROM PS_SFA_CRC_DEST_ID WHERE SFA_CR_OPEID_TYPE = 'L'

  • Related Language Record: SFACRCDESLV3LNG

    • # 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
    4 PREF_LENDER Character(1) VARCHAR2(1) NOT NULL Preferred Lender