SFA_LN_LNDR_OPEIDPrompt Table: SFA_LNDR_DS_VW
SFA_LN_LNDR_BRANCHPrompt Table: SFA_LNDR_DS_VW2
SFA_LNDR_DS_VW3(SQL View) |
Index Back |
|---|---|
CRC Destination Id'sList of Servicer, Lenders, and Guarantors used in CommonLine Loan Processing |
| SELECT SFA_CR_OPEID , SFA_CR_BRANCH_ID , DESCR , DESCRSHORT , PREF_LENDER FROM PS_SFA_CRC_DEST_ID WHERE SFA_CR_OPEID_TYPE = 'L' AND SFA_CR_OPEID_STAT = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SFA_LN_LNDR_OPEID |
Character(8) | VARCHAR2(8) NOT NULL |
Lender OPEID
Prompt Table: SFA_LNDR_DS_VW |
| 2 | SFA_LN_LNDR_BRANCH |
Character(4) | VARCHAR2(4) NOT NULL |
Lender Branch ID
Prompt Table: SFA_LNDR_DS_VW2 |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | PREF_LENDER | Character(1) | VARCHAR2(1) NOT NULL | Preferred Lender |