SFACRCDESSV5LNG

(SQL View)
Index Back

CRC Servicer Destination Id's

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

SELECT A.SFA_CR_OPEID , B.LANGUAGE_CD , A.SFA_CR_BRANCH_ID , B.DESCR FROM PS_SFA_CRC_DEST_ID A , PS_SFACRCDESTIDLNG B WHERE A.SFA_CR_OPEID_TYPE = 'S' AND A.SFA_CR_OPEID = B.SFA_CR_OPEID AND A.SFA_CR_BRANCH_ID = B.SFA_CR_BRANCH_ID AND A.SFA_CR_OPEID_TYPE = B.SFA_CR_OPEID_TYPE

  • Related Language Record for SFA_CRC_DESS_V5
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SFA_CR_OPEID Character(8) VARCHAR2(8) NOT NULL OPEID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 SFA_CR_BRANCH_ID Character(4) VARCHAR2(4) NOT NULL Branch ID

    Default Value: 0000

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