SFA_LNDR_DS_VW

(SQL View)
 Index Back

CRC Destination Id's

List of Servicer, Lenders, and Guarantors used in CommonLine Loan Processing

SELECT SFA_CR_OPEID , SFA_CR_BRANCH_ID , DESCR , PREF_LENDER FROM PS_SFA_CRC_DEST_ID WHERE SFA_CR_OPEID_TYPE = 'L' AND SFA_CR_OPEID_STAT = 'Y'

  • Related Language Record: SFACRCDESLVWLNG

    • # 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