STDNT_BGT_HSEVW

(SQL View)
 Index Back

Student's Inst House Prf View

This view is used by the budget process to collect housing preference information

select distinct a.emplid, a.institution, a.aid_year, b.award_period, a.app_source_code, a.housing_code from PS_INST_SCHOOL_PRF a, ps_fa_app_src_rank b, ps_stdnt_cr_term c where a.institution = b.institution and a.institution = c.institution and a.aid_year = b.aid_year and a.aid_year = c.aid_year and a.emplid = c.emplid and c.award_period = b.award_period and b.source_rank_type = 'B' and b.information_source = 'I' and a.app_source_code = b.inst_app_source and b.effdt = (select max(effdt) from ps_fa_app_src_rank b1 where b1.institution = b.institution and b1.aid_year = b.aid_year and b1.award_period = b.award_period and b1.information_source = b.information_source and b1.inst_app_source = b.inst_app_source and b1.effdt <= %currentdatein)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
4 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
A=Academic
N=Non Standard
5 APP_SOURCE_CODE Character(1) VARCHAR2(1) NOT NULL Application Source Code
0=Need Access
0=Need Access
1=Electronic Initial Application
2=Electronic Renewal Aplication
3=Electronic Correction
4=FAFSA Express
5=ACT
6=I-NET
7=NCS
8=Profile
9=Institutional Application
O=FT Canada Student Loan
P=PT Canada Student Loan
6 HOUSING_CODE Character(1) VARCHAR2(1) NOT NULL Housing Code
1=Campus Housing
2=Off-Campus Housing
3=With Parents
4=With Relatives