LN_DEST_NBRDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table: AID_YEAR_TBL
A=Alternative
D=Direct Lending
F=FFELP
H=Health Professions
P=Perkins
S=State
U=University
LN_EDI_DEST_VW(SQL View) |
Index Back |
|---|---|
Loan EDI Destination VwTo construct profile information |
| select a.ln_dest_nbr, a.institution, a.aid_year, a.loan_program, a.descr from PS_LN_DESTPROF_TBL a |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LN_DEST_NBR |
Number(3,0) | SMALLINT NOT NULL | Loan Destination Num |
| 2 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 3 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL |
| 4 | LOAN_PROGRAM | Character(1) | VARCHAR2(1) NOT NULL |
Loan Program
A=Alternative D=Direct Lending F=FFELP H=Health Professions P=Perkins S=State U=University |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |