SFA_CRC_DESL_V2 (SQL View)	Index Back
CRC Lender Destination Id's List of Servicer, Lenders, and Guarantors used in CommonLine Loan Processing. Both OPEEID and Branch ID are keys. Used as &EDITTABLE prompt on page LN_AGENCY_DFLT.

SFA_CRC_DESL_V2

(SQL View)

CRC Lender Destination Id's

List of Servicer, Lenders, and Guarantors used in CommonLine Loan Processing. Both OPEEID and Branch ID are keys. Used as &EDITTABLE prompt on page LN_AGENCY_DFLT.

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: SFACRCDESLV2LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SFA_CR_OPEID_NEW Character(8) VARCHAR2(8) NOT NULL New CRC OPE ID, used on Agency Default Setup.

2 SFA_CR_BRANCH_NEW Character(4) VARCHAR2(4) NOT NULL New OPE Branch Code used on Agency Default Setup.
Default Value: 0000

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

4 PREF_LENDER Character(1) VARCHAR2(1) NOT NULL Preferred Lender

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SFA_CR_OPEID_NEW	Character(8)	VARCHAR2(8) NOT NULL	New CRC OPE ID, used on Agency Default Setup.
2	SFA_CR_BRANCH_NEW	Character(4)	VARCHAR2(4) NOT NULL	New OPE Branch Code used on Agency Default Setup. Default Value: 0000
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	PREF_LENDER	Character(1)	VARCHAR2(1) NOT NULL	Preferred Lender