STDNT_T_B_VW

(SQL View)
 Index Back

Student Term Bdgt Summary View


SELECT DISTINCT A.EMPLID , A.INSTITUTION , A.AID_YEAR , A.ACAD_CAREER , A.STRM , A.BUDGET_GROUP_CODE , A.RESIDENCY , A.HOUSING_TYPE , A.FED_TERM_COA , A.INST_TERM_COA , A.PELL_TERM_COA , A.SFA_PELTRM_COA_LHT , A.FA_LOAD , A.NSLDS_LOAN_YEAR , A.DEPNDNCY_STAT , A.ACADEMIC_LOAD , A.ACAD_LEVEL_BOT FROM PS_STDNT_TERM_BDGT A WHERE A.EFFDT=( SELECT MAX(EFFDT) FROM PS_STDNT_TERM_BDGT B WHERE A.EMPLID = B.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.AID_YEAR = B.AID_YEAR AND A.ACAD_CAREER = B.ACAD_CAREER AND A.STRM = B.STRM AND B.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_STDNT_TERM_BDGT B1 WHERE A.EMPLID = B1.EMPLID AND A.INSTITUTION = B1.INSTITUTION AND A.AID_YEAR = B1.AID_YEAR AND A.ACAD_CAREER = B1.ACAD_CAREER AND A.STRM = B1.STRM AND A.EFFDT = B1.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

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

Prompt Table: STUDENT_AID

4 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

Prompt Table: STDNT_CAREER

5 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: TERM_TBL

6 BUDGET_GROUP_CODE Character(6) VARCHAR2(6) NOT NULL Budget Group Code

Prompt Table: BUDGET_GRP_VW

7 RESIDENCY Character(5) VARCHAR2(5) NOT NULL Residency
8 HOUSING_TYPE Character(1) VARCHAR2(1) NOT NULL Projected Housing Type
1=On Campus Housing
2=With Parent
2=Off Campus Housing
3=Off Campus
3=Parent's Home
4=Relative's Home
9 FED_TERM_COA Number(9,2) DECIMAL(8,2) NOT NULL Fed Term COA
10 INST_TERM_COA Number(9,2) DECIMAL(8,2) NOT NULL Inst Term COA
11 PELL_TERM_COA Number(9,2) DECIMAL(8,2) NOT NULL Pell Term COA
12 SFA_PELTRM_COA_LHT Number(9,2) DECIMAL(8,2) NOT NULL Field used to calculate Less than Half Time Pell Term COA.
13 FA_LOAD Character(1) VARCHAR2(1) NOT NULL Financial Aid Load
F=Enrolled Full-Time
H=Enrolled Half-Time
L=Less than Half-Time
N=No Unit Load
T=Three Quarter Time
14 NSLDS_LOAN_YEAR Character(1) VARCHAR2(1) NOT NULL NSLDS Loan Year
0=1st Year - Never Attended
1=1st Year - Previously Attended
2=2nd Year
3=3rd Year
4=4th Year
5=5th Year+
A=1st Year Graduate
B=2nd Year Graduate
C=3rd Year Graduate
D=4th or more Graduate
G=Graduate/Professional
15 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
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_BOT Character(3) VARCHAR2(3) NOT NULL Academic Level - Term Start