RAD_CRIT_SEL_VW

(SQL View)
 Index Back

RAD Criteria Select View

This view contains the necessary data elements for a FAA to create selection criteria for the Renewal Application Data Request (RAD).

select a.institution, a.aid_year, a.emplid, a.effdt, a.orig_ssn, a.name_cd, a.owning_school_cd, b.depndncy_stat, c.fed_efc, c.efc_status, d.counselor, e.acad_career, e.strm, e.acad_level_eot, e.withdraw_code, e.academic_load, e.acad_level_proj, e.unt_taken_fa from PS_ISIR_CONTROL a, ps_isir_student b, ps_stdnt_awd_per c, ps_stdnt_aid_atrbt d, ps_stdnt_fa_term e where (a.effdt = (select max(a1.effdt) from PS_ISIR_CONTROL a1 where a.emplid = a1.emplid and a.effdt <= %CurrentDateIn) and a.effseq = (select max(a2.effseq) from PS_ISIR_CONTROL a2 where a.emplid = a2.emplid and a.aid_year = a2.aid_year and a.effdt = a2.effdt)) and (a.emplid = b.emplid and a.aid_year = b.aid_year and a.institution = b.institution and a.effdt = b.effdt and a.effseq = b.effseq) and (a.emplid = c.emplid and a.aid_year = c.aid_year and a.institution = c.institution) and (a.emplid = d.emplid and a.aid_year = d.aid_year and a.institution = d.institution) and (a.emplid = e.emplid and a.institution = e.institution)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Prompt Table: AID_YEAR_TBL

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 ORIG_SSN Character(9) VARCHAR2(9) NOT NULL Original SSN
6 NAME_CD Character(2) VARCHAR2(2) NOT NULL Name Code
7 OWNING_SCHOOL_CD Character(6) VARCHAR2(6) NOT NULL Owning School Cd

Prompt Table: TIV_SCHOOL_TBL

8 DEPNDNCY_STAT Character(1) VARCHAR2(1) NOT NULL Dependency Status
1=Independent
2=Dependent
3=Indepenedent/Pro Judgmnt
D=Dependent
I=Independent
X=Dependent Reject
Y=Independent Reject
Z=Provisional Independent
9 FED_EFC Signed Number(7,0) DECIMAL(6) NOT NULL Federal EFC
10 EFC_STATUS Character(1) VARCHAR2(1) NOT NULL EFC Status Indicator
O=Official
R=Rejected
U=Unofficial
Z=Provisional
11 COUNSELOR Character(11) VARCHAR2(11) NOT NULL Counselor

Prompt Table: PEOPLE_SRCH

12 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
13 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: TERM_VAL_TBL

14 ACAD_LEVEL_EOT Character(3) VARCHAR2(3) NOT NULL Academic Level - Term End

Prompt Table: XL_ACAD_LVL_VW

15 WITHDRAW_CODE Character(3) VARCHAR2(3) NOT NULL Withdrawal \ Cancel
CAN=Cancelled
NWD=
WDR=Withdrew
16 ACADEMIC_LOAD Character(1) VARCHAR2(1) NOT NULL Academic Load
F=Enrolled Full-Time
H=Enrolled Half-Time
L=Less than Half-Time
N=No Unit Load
P=Enrolled Part-Time
T=Three Quarter Time
17 ACAD_LEVEL_PROJ Character(3) VARCHAR2(3) NOT NULL Academic Level - Projected

Prompt Table: XL_ACAD_LVL_VW

18 UNT_TAKEN_FA Number(9,3) DECIMAL(8,3) NOT NULL Fin Aid Progress Units Taken