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

SFA_CRC_DESG_V2

(SQL View)

CRC Guarantor Destination Id's

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

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

Related Language Record: SFACRCDESGV2LNG

# 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

#	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