SFA_CRC_DSS_VW2

(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 FROM PS_SFA_CRC_DEST_ID WHERE SFA_CR_OPEID_TYPE = 'S' AND SFA_CR_OPEID_STAT = 'Y'

  • Related Language Record: SFACRCDSSVW2LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SFA_CR_SVR_OPEID Character(8) VARCHAR2(8) NOT NULL Servicer OPEID

    Prompt Table: SFA_CRC_DESS_VW

    2 SFA_CR_SVR_BRANCH Character(4) VARCHAR2(4) NOT NULL Servicer Branch Code

    Prompt Table: SFA_CRC_DSS_VW2

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