LN_DESTDIR_VW(SQL View) |
Index Back |
|---|---|
Loan Direct Profile Tbl VwTo construct profile information |
| select a.institution, a.aid_year, a.loan_program, a.ln_dest_nbr, a.serv_unq_id, d.descrshort, a.phys_dest_ind, a.contact_predisb, a.contact_disb, a.contact_postdisb from ps_ln_destprof_tbl a, PS_SERVICER_TBL d where a.serv_unq_id = d.serv_unq_id and a.loan_program = 'D' |
| # | 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_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 |
| 4 | LN_DEST_NBR |
Number(3,0) | SMALLINT NOT NULL | Loan Destination Num |
| 5 | SERV_UNQ_ID | Number(3,0) | SMALLINT NOT NULL |
Servicer ID
Prompt Table: SERVICER_TBL |
| 6 | SERV_DESCR | Character(15) | VARCHAR2(15) NOT NULL | Servicer Description |
| 7 | PHYS_DEST_IND | Character(1) | VARCHAR2(1) NOT NULL |
Physical Destination
G=Guarantor L=Lender S=Servicer Default Value: S |
| 8 | CONTACT_PREDISB | Character(1) | VARCHAR2(1) NOT NULL |
Pre-Disb Contact
G=Guarantor L=Lender S=Servicer Default Value: S |
| 9 | CONTACT_DISB | Character(1) | VARCHAR2(1) NOT NULL |
Disb Contact
G=Guarantor L=Lender S=Servicer Default Value: S |
| 10 | CONTACT_POSTDISB | Character(1) | VARCHAR2(1) NOT NULL |
Post Disb Contact
G=Guarantor L=Lender S=Servicer Default Value: S |