LN_DESTPROF_VW

(SQL View)
 Index Back

Loan Dest Profiles Tbl Vw

To construct profile information

select a.institution, a.aid_year, a.loan_program, a.ln_dest_nbr, a.lend_unq_id, b.descrshort, a.guar_unq_id, c.descrshort, 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_lender_tbl b, ps_guarantor_tbl c, PS_SERVICER_TBL d where a.lend_unq_id = b.lend_unq_id and a.guar_unq_id = c.guar_unq_id and a.serv_unq_id = d.serv_unq_id

# 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 LEND_UNQ_ID Number(3,0) SMALLINT NOT NULL Lender ID

Prompt Table: LENDER_TBL

6 LEND_DESCR Character(15) VARCHAR2(15) NOT NULL Lender Description
7 GUAR_UNQ_ID Number(3,0) SMALLINT NOT NULL Guarantor ID

Default Value: LENDER_TBL.GUAR_UNQ_ID

Prompt Table: GUARANTOR_TBL

8 GUAR_DESCR Character(15) VARCHAR2(15) NOT NULL Guarantor Description
9 SERV_UNQ_ID Number(3,0) SMALLINT NOT NULL Servicer ID

Prompt Table: SERVICER_TBL

10 SERV_DESCR Character(15) VARCHAR2(15) NOT NULL Servicer Description
11 PHYS_DEST_IND Character(1) VARCHAR2(1) NOT NULL Physical Destination
G=Guarantor
L=Lender
S=Servicer

Default Value: S

12 CONTACT_PREDISB Character(1) VARCHAR2(1) NOT NULL Pre-Disb Contact
G=Guarantor
L=Lender
S=Servicer

Default Value: S

13 CONTACT_DISB Character(1) VARCHAR2(1) NOT NULL Disb Contact
G=Guarantor
L=Lender
S=Servicer

Default Value: S

14 CONTACT_POSTDISB Character(1) VARCHAR2(1) NOT NULL Post Disb Contact
G=Guarantor
L=Lender
S=Servicer

Default Value: S