SS_STDNT_TRM_VW

(SQL View)
 Index Back

Collects students statistics

This view presents the data for the SS_STDNT_TRM_PNL panel that displays the students academic statistical information such as GPA, credits and progress.

Select a.emplid, a.acad_career, a.institution, a.strm, a.acad_prog_primary, a.unt_audit, a.grade_points, a.cur_gpa, a.unt_trnsfr, a.unt_test_credit, a.unt_other, a.unt_term_tot, a.unt_inprog_gpa, a.unt_taken_gpa, a.unt_passd_gpa, a.unt_inprog_nogpa, a.unt_taken_nogpa, a.unt_passd_nogpa, a.unt_taken_prgrss, a.unt_passd_prgrss, a.acad_load_appr, a.cum_gpa, a.tot_passd_gpa, a.tot_taken_gpa, a.tot_grade_points from PS_STDNT_CAR_TERM a

# 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 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

Default Value: OPR_DEF_TBL_CS.ACAD_CAREER

Prompt Table: SS_STDNT_CAR_VW

3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

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

Default Value: OPR_DEF_TBL_CS.STRM

Prompt Table: TERM_TBL

5 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
6 UNT_AUDIT Number(9,3) DECIMAL(8,3) NOT NULL Units Audited
7 GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Grade Points
8 CUR_GPA Number(9,3) DECIMAL(8,3) NOT NULL Current GPA
9 UNT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Units Transferred
10 UNT_TEST_CREDIT Number(9,3) DECIMAL(8,3) NOT NULL Units from Test Credit
11 UNT_OTHER Number(9,3) DECIMAL(8,3) NOT NULL Units from Other Credit
12 UNT_TERM_TOT Number(9,3) DECIMAL(8,3) NOT NULL Total Term Units
13 UNT_INPROG_GPA Number(9,3) DECIMAL(8,3) NOT NULL Units In Progress - GPA
14 UNT_TAKEN_GPA Number(9,3) DECIMAL(8,3) NOT NULL Units Taken Toward GPA
15 UNT_PASSD_GPA Number(9,3) DECIMAL(8,3) NOT NULL Units Passed Toward GPA
16 UNT_INPROG_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Unit In Progress - Not for GPA
17 UNT_TAKEN_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Units Taken Not Toward GPA
18 UNT_PASSD_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Units Passed Not Toward GPA
19 UNT_TAKEN_PRGRSS Number(9,3) DECIMAL(8,3) NOT NULL Units Taken for Progress
20 UNT_PASSD_PRGRSS Number(9,3) DECIMAL(8,3) NOT NULL Units Passed for Progress
21 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
B=Vocational Coaching (NLD)
D=Dual (NLD)
E=Part-time Vocational Tr (NLD)
F=Full-Time
O=Vocational Training (NLD)
P=Part-Time
22 CUM_GPA Number(9,3) DECIMAL(8,3) NOT NULL Cumulative GPA
23 TOT_PASSD_GPA Number(9,3) DECIMAL(8,3) NOT NULL Total Passed Toward GPA
24 TOT_TAKEN_GPA Number(9,3) DECIMAL(8,3) NOT NULL Cumulative Units for GPA of Enrollments and Transfer Credits
25 TOT_GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Cumulative Grade Points of Enrollment and Transfer Credits