SFA_LNDR_SS_VW(SQL View) |
Index Back |
|---|---|
Lender Select Detail |
| SELECT A.INSTITUTION ,A.AID_YEAR ,A.LOAN_TYPE ,A.SFA_CR_LNDR_OPEID ,A.SFA_CR_LNDR_BRANCH ,A.SFA_LN_LNDR_SEQ ,B.SFA_CR_ABOUT_LNDR ,A.SFA_CR_GUAR_OPEID ,A.SFA_CR_GUAR_BRANCH ,C.SFA_CR_GUAR_OPEID ,C.SFA_CR_GUAR_BRANCH FROM PS_SFA_LNDR_DTL A , PS_SFA_CRC_DEST_ID B , PS_SFA_LNDR_SEL C WHERE A.SFA_CR_LNDR_OPEID = B.SFA_CR_OPEID AND A.SFA_CR_LNDR_BRANCH = B.SFA_CR_BRANCH_ID AND B.SFA_CR_OPEID_TYPE = 'L' AND A.INSTITUTION = C.INSTITUTION AND A.AID_YEAR = C.AID_YEAR AND A.LOAN_TYPE = C.LOAN_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL |
| 3 | LOAN_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Loan Type Cd
Prompt Table: SFA_LN_TYPE_FVW |
| 4 | SFA_CR_LNDR_OPEID |
Character(8) | VARCHAR2(8) NOT NULL |
Lender OPEID
Prompt Table: SFA_LNDR_DS_VW |
| 5 | SFA_CR_LNDR_BRANCH |
Character(4) | VARCHAR2(4) NOT NULL |
Lender Branch ID
Prompt Table: SFA_LNDR_DS_VW2 |
| 6 | SFA_LN_LNDR_SEQ | Number(3,0) | SMALLINT NOT NULL | Lender Display Sequence |
| 7 | SFA_CR_ABOUT_LNDR | Character(254) | VARCHAR2(254) NOT NULL | Lender Information |
| 8 | SFA_CR_GUAR_OPEID | Character(8) | VARCHAR2(8) NOT NULL |
Guarantor OPEID
Prompt Table: SFA_CRC_GUAR_VW |
| 9 | SFA_CR_GUAR_BRANCH | Character(4) | VARCHAR2(4) NOT NULL |
Guarantor Branch ID
Prompt Table: SFA_CRC_GUAR_V2 |
| 10 | SFA_CR_GUAR_ID_DFT | Character(8) | VARCHAR2(8) NOT NULL | Guarantor OPEID Default |
| 11 | SFA_CR_GUAR_BRCH_D | Character(4) | VARCHAR2(4) NOT NULL | Guarantor Branch ID Default |