SSF_STD_CAR_VW

(SQL View)
 Index Back

Student Career Term View

This view contains student information by Academic Career, Institution and Term. To have an entry in this table, the student must have at least one entry in the Academic Program table.

SELECT A.EMPLID , A.ACAD_CAREER , A.INSTITUTION , A.STRM , A.REG_CARD_DATE , A.WITHDRAW_CODE , A.WITHDRAW_REASON , A.WITHDRAW_DATE , A.LAST_DATE_ATTENDED , A.STDNT_CAR_NBR , A.ACAD_PROG_PRIMARY , A.ACAD_LOAD_APPR , A.ACADEMIC_LOAD , A.FA_LOAD , A.ACAD_LEVEL_PROJ , A.ACAD_LEVEL_BOT , A.ACAD_LEVEL_EOT , A.NSLDS_LOAN_YEAR , A.OVRD_ACAD_LVL_PROJ , A.OVRD_ACAD_LVL_ALL , A.ELIG_TO_ENROLL , A.OVRD_MAX_UNITS , A.MAX_TOTAL_UNIT , A.MAX_NOGPA_UNIT , A.MAX_AUDIT_UNIT , A.MAX_WAIT_UNIT , A.MIN_TOTAL_UNIT , A.OVRD_BILL_UNITS , A.PROJ_BILL_UNT , A.UNT_TAKEN_PRGRSS , A.UNT_PASSD_PRGRSS , A.UNT_TAKEN_GPA , A.UNT_PASSD_GPA , A.UNT_TAKEN_NOGPA , A.UNT_PASSD_NOGPA , A.UNT_INPROG_GPA , A.UNT_INPROG_NOGPA , A.GRADE_POINTS , A.UNT_AUDIT , A.UNT_TRNSFR , A.TRF_TAKEN_GPA , A.TRF_TAKEN_NOGPA , A.TRF_PASSED_GPA , A.TRF_PASSED_NOGPA , A.TRF_GRADE_POINTS , A.UNT_TEST_CREDIT , A.UNT_OTHER , A.UNT_TAKEN_FA , A.UNT_PASSD_FA , A.UNT_TAKEN_FA_GPA , A.GRADE_POINTS_FA , A.UNT_TERM_TOT , A.RESET_CUM_STATS , A.TOT_TAKEN_PRGRSS , A.TOT_PASSD_PRGRSS , A.TOT_TAKEN_GPA , A.TOT_PASSD_GPA , A.TOT_TAKEN_NOGPA , A.TOT_PASSD_NOGPA , A.TOT_INPROG_GPA , A.TOT_INPROG_NOGPA , A.TOT_AUDIT , A.TOT_TRNSFR , A.TOT_TEST_CREDIT , A.TOT_OTHER , A.TOT_CUMULATIVE , A.TOT_GRADE_POINTS , A.TOT_TAKEN_FA , A.TOT_PASSD_FA , A.TOT_TAKEN_FA_GPA , A.TOT_GRD_POINTS_FA , A.FORM_OF_STUDY , A.TERM_TYPE , A.CLASS_RANK_NBR , A.CLASS_RANK_TOT , A.SEL_GROUP , A.TUIT_CALC_REQ , A.TUIT_CALC_DTTM , A.FA_STATS_CALC_REQ , A.FA_STATS_CALC_DTTM , A.FA_ELIGIBILITY , A.BILLING_CAREER , A.UNIT_MULTIPLIER , A.ACAD_YEAR , A.ACAD_GROUP_ADVIS , A.CUR_RESIDENT_TERMS , A.TRF_RESIDENT_TERMS , A.CUM_RESIDENT_TERMS , A.REFUND_PCT , A.REFUND_SCHEME , A.PRO_RATA_ELIGIBLE , A.FULLY_ENRL_DT , A.ENRL_ON_TRANS_DT , A.STATS_ON_TRANS_DT , A.FULLY_GRADED_DT , B.TERM_BEGIN_DT , B.TERM_END_DT , D.FA_PRIMACY_NBR , C.FA_PRIMACY_NBR , C.GRADING_SCHEME , A.EXT_ORG_ID , A.COUNTRY , A.STUDY_AGREEMENT , A.START_DATE , A.END_DATE , C.LEVEL_LOAD_RULE , B.TERM_CATEGORY , C.ACAD_CALENDAR_ID , A.TC_UNITS_ADJUST FROM PS_STDNT_CAR_TERM A , PS_TERM_TBL B , PS_ACAD_PROG_TBL C , PS_ACAD_CAR_TBL D WHERE B.INSTITUTION = A.INSTITUTION AND B.ACAD_CAREER = A.ACAD_CAREER AND B.STRM = A.STRM AND C.INSTITUTION = A.INSTITUTION AND C.ACAD_PROG = A.ACAD_PROG_PRIMARY AND C.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_ACAD_PROG_TBL C_ED WHERE C.INSTITUTION = C_ED.INSTITUTION AND C.ACAD_PROG = C_ED.ACAD_PROG AND C_ED.EFFDT <= B.TERM_BEGIN_DT) AND C.ACAD_CAREER = A.ACAD_CAREER AND D.INSTITUTION = A.INSTITUTION AND D.ACAD_CAREER = A.ACAD_CAREER AND D.EFFDT = ( SELECT MAX(D_ED.EFFDT) FROM PS_ACAD_CAR_TBL D_ED WHERE D.INSTITUTION = D_ED.INSTITUTION AND D.ACAD_CAREER = D_ED.ACAD_CAREER AND D_ED.EFFDT <= B.TERM_BEGIN_DT) AND D.EFF_STATUS = '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

Prompt Table: STDNT_CAREER

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

Prompt Table: TERM_TBL

5 REG_CARD_DATE Date(10) DATE Registration Card Date
6 WITHDRAW_CODE Character(3) VARCHAR2(3) NOT NULL Withdrawal \ Cancel
CAN=Cancelled
NWD=
WDR=Withdrew

Default Value: NWD

7 WITHDRAW_REASON Character(4) VARCHAR2(4) NOT NULL Withdrawal \ Cancel Reason
MEDI=Medical
NPAY=Non-Payment of Fees
RETR=Retroactive
8 WITHDRAW_DATE Date(10) DATE Withdrawal \ Cancel Date
9 LAST_DATE_ATTENDED Date(10) DATE Last Date of Attendance
10 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr

Prompt Table: %EDITTABLE

11 ACAD_PROG_PRIMARY Character(5) VARCHAR2(5) NOT NULL Primary Academic Program
12 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

Default Value: F

13 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

Default Value: N

Prompt Table: ACAD_LOAD_TBL

14 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
15 ACAD_LEVEL_PROJ Character(3) VARCHAR2(3) NOT NULL Academic Level - Projected

Prompt Table: ACAD_LEVEL_TBL

16 ACAD_LEVEL_BOT Character(3) VARCHAR2(3) NOT NULL Academic Level - Term Start

Prompt Table: ACAD_LEVEL_TBL

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

Prompt Table: ACAD_LEVEL_TBL

18 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
19 OVRD_ACAD_LVL_PROJ Character(1) VARCHAR2(1) NOT NULL Override Projected Level

Y/N Table Edit

Default Value: N

20 OVRD_ACAD_LVL_ALL Character(1) VARCHAR2(1) NOT NULL Override All Academic Levels

Y/N Table Edit

Default Value: N

21 ELIG_TO_ENROLL Character(1) VARCHAR2(1) NOT NULL Eligible to Enroll

Y/N Table Edit

Default Value: Y

22 OVRD_MAX_UNITS Character(1) VARCHAR2(1) NOT NULL Override Maximum Units

Y/N Table Edit

Default Value: N

23 MAX_TOTAL_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Max Total Units
24 MAX_NOGPA_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Max No GPA Units
25 MAX_AUDIT_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Max Audit Units
26 MAX_WAIT_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Max Wait List Units
27 MIN_TOTAL_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Min Total Units
28 OVRD_BILL_UNITS Character(1) VARCHAR2(1) NOT NULL Override Billing Units

Y/N Table Edit

Default Value: N

29 PROJ_BILL_UNT Number(3,0) SMALLINT NOT NULL Projected Bill Units
30 UNT_TAKEN_PRGRSS Number(9,3) DECIMAL(8,3) NOT NULL Units Taken for Progress
31 UNT_PASSD_PRGRSS Number(9,3) DECIMAL(8,3) NOT NULL Units Passed for Progress
32 UNT_TAKEN_GPA Number(9,3) DECIMAL(8,3) NOT NULL Units Taken Toward GPA
33 UNT_PASSD_GPA Number(9,3) DECIMAL(8,3) NOT NULL Units Passed Toward GPA
34 UNT_TAKEN_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Units Taken Not Toward GPA
35 UNT_PASSD_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Units Passed Not Toward GPA
36 UNT_INPROG_GPA Number(9,3) DECIMAL(8,3) NOT NULL Units In Progress - GPA
37 UNT_INPROG_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Unit In Progress - Not for GPA
38 GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Grade Points
39 UNT_AUDIT Number(9,3) DECIMAL(8,3) NOT NULL Units Audited
40 UNT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Units Transferred
41 TRF_TAKEN_GPA Number(9,3) DECIMAL(8,3) NOT NULL Term Units for GPA of Transfer Credits
42 TRF_TAKEN_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Taken Not for GPA
43 TRF_PASSED_GPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed for GPA
44 TRF_PASSED_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed Not for GPA
45 TRF_GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Term Grade Points of Transfer Credits.
46 UNT_TEST_CREDIT Number(9,3) DECIMAL(8,3) NOT NULL Units from Test Credit
47 UNT_OTHER Number(9,3) DECIMAL(8,3) NOT NULL Units from Other Credit
48 UNT_TAKEN_FA Number(9,3) DECIMAL(8,3) NOT NULL Fin Aid Progress Units Taken
49 UNT_PASSD_FA Number(9,3) DECIMAL(8,3) NOT NULL Fin Aid Progress Units Passed
50 UNT_TAKEN_FA_GPA Number(9,3) DECIMAL(8,3) NOT NULL FA Units Taken Toward GPA
51 GRADE_POINTS_FA Number(10,3) DECIMAL(9,3) NOT NULL Financial Aid Grade Points
52 UNT_TERM_TOT Number(9,3) DECIMAL(8,3) NOT NULL Total Term Units
53 RESET_CUM_STATS Character(1) VARCHAR2(1) NOT NULL Reset Cum Stats at Term Start

Y/N Table Edit

Default Value: N

54 TOT_TAKEN_PRGRSS Number(9,3) DECIMAL(8,3) NOT NULL Total Taken for Progress
55 TOT_PASSD_PRGRSS Number(9,3) DECIMAL(8,3) NOT NULL Total Passed for Progress
56 TOT_TAKEN_GPA Number(9,3) DECIMAL(8,3) NOT NULL Cumulative Units for GPA of Enrollments and Transfer Credits
57 TOT_PASSD_GPA Number(9,3) DECIMAL(8,3) NOT NULL Total Passed Toward GPA
58 TOT_TAKEN_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Total Taken Not Toward GPA
59 TOT_PASSD_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Total Passed Not Toward GPA
60 TOT_INPROG_GPA Number(9,3) DECIMAL(8,3) NOT NULL Total In Progress - GPA
61 TOT_INPROG_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Total In Progress -Not for GPA
62 TOT_AUDIT Number(9,3) DECIMAL(8,3) NOT NULL Total Audited
63 TOT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Total Transferred
64 TOT_TEST_CREDIT Number(9,3) DECIMAL(8,3) NOT NULL Total From Test Credit
65 TOT_OTHER Number(9,3) DECIMAL(8,3) NOT NULL Total from Other Credit
66 TOT_CUMULATIVE Number(9,3) DECIMAL(8,3) NOT NULL Total Cumulative Units
67 TOT_GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Cumulative Grade Points of Enrollment and Transfer Credits
68 TOT_TAKEN_FA Number(9,3) DECIMAL(8,3) NOT NULL Total Fin Aid Units Taken
69 TOT_PASSD_FA Number(9,3) DECIMAL(8,3) NOT NULL Total Fin Aid Units Passed
70 TOT_TAKEN_FA_GPA Number(9,3) DECIMAL(8,3) NOT NULL Total Fin Aid Taken Toward GPA
71 TOT_GRD_POINTS_FA Number(10,3) DECIMAL(9,3) NOT NULL Total Fin Aid Grade Points
72 FORM_OF_STUDY Character(4) VARCHAR2(4) NOT NULL Form of Study
ABRD=Study Abroad
CAND=Advanced to Candidacy
DTCH=Detached Study
ENRL=Class Enrollment

Default Value: ENRL

73 TERM_TYPE Character(1) VARCHAR2(1) NOT NULL Term Unit Type
C=Clock Hours
E=Continuing Education Units
Q=Quarter Hours
S=Semester Hours
T=Trimester Hours
U=Units

Default Value: ACAD_CAR_TBL.TERM_TYPE

Prompt Table: TERM_TYPE_TBL

74 CLASS_RANK_NBR Number(5,0) INTEGER NOT NULL Class Rank Nbr
75 CLASS_RANK_TOT Number(5,0) INTEGER NOT NULL Class Rank Total
76 SEL_GROUP Character(10) VARCHAR2(10) NOT NULL Tuition Group

Prompt Table: SEL_GROUP_VW

77 TUIT_CALC_REQ Character(1) VARCHAR2(1) NOT NULL Tuition Calc Required

Y/N Table Edit

Default Value: N

78 TUIT_CALC_DTTM DateTime(26) TIMESTAMP Tuit Calc Date Time
79 FA_STATS_CALC_REQ Character(1) VARCHAR2(1) NOT NULL FA Stats Calculation Required

Default Value: N

80 FA_STATS_CALC_DTTM DateTime(26) TIMESTAMP FA Stats Calc Date Time
81 FA_ELIGIBILITY Character(1) VARCHAR2(1) NOT NULL Program Eligibility Flag

Default Value: ACAD_PROG_TBL.FA_ELIGIBILITY

82 BILLING_CAREER Character(4) VARCHAR2(4) NOT NULL Billing Career

Default Value: STDNT_CAR_TERM.ACAD_CAREER

Prompt Table: STDNT_CARBT_VW

83 UNIT_MULTIPLIER Number(9,4) DECIMAL(8,4) NOT NULL Unit Multiplier
84 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year

Default Value: TERM_TBL.ACAD_YEAR

85 ACAD_GROUP_ADVIS Character(5) VARCHAR2(5) NOT NULL Academic Group of Advisor

Prompt Table: ACAD_GROUP_TBL

86 CUR_RESIDENT_TERMS Number(7,3) DECIMAL(6,3) NOT NULL Current In Residence Terms
87 TRF_RESIDENT_TERMS Number(7,3) DECIMAL(6,3) NOT NULL Transfer In Residence Terms
88 CUM_RESIDENT_TERMS Number(7,3) DECIMAL(6,3) NOT NULL Cumulative In Residence Terms
89 REFUND_PCT Number(6,2) DECIMAL(5,2) NOT NULL Refund Percentage
90 REFUND_SCHEME Character(8) VARCHAR2(8) NOT NULL Refund Scheme
91 PRO_RATA_ELIGIBLE Character(1) VARCHAR2(1) NOT NULL Pro-Rata Eligible

Y/N Table Edit

Default Value: N

92 FULLY_ENRL_DT Date(10) DATE NOT NULL Fully Enrolled Date
93 ENRL_ON_TRANS_DT Date(10) DATE NOT NULL Show Enrollment on Transcript
94 STATS_ON_TRANS_DT Date(10) DATE NOT NULL Show Statistics on Transcript
95 FULLY_GRADED_DT Date(10) DATE NOT NULL Fully Graded Date
96 TERM_BEGIN_DT Date(10) DATE NOT NULL Term Begin Date
97 TERM_END_DT Date(10) DATE NOT NULL Term Ending Date
98 FA_CAREER_PRIMACY Number(3,0) SMALLINT NOT NULL Career Primacy Nbr
99 FA_PROGRAM_PRIMACY Number(3,0) SMALLINT NOT NULL Program Primacy Nbr
100 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme

Prompt Table: GRADESCHEME_TBL

101 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

Prompt Table: EXT_ORG_TBL

102 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

103 STUDY_AGREEMENT Character(10) VARCHAR2(10) NOT NULL Study Agreement

Prompt Table: STUDY_AGRM_TBL

104 START_DATE Date(10) DATE Start Date for Gen Standing PO
105 END_DATE Date(10) DATE End Date
106 LEVEL_LOAD_RULE Character(5) VARCHAR2(5) NOT NULL Academic Level Rule

Prompt Table: LVL_LD_RULE_TBL

107 TERM_CATEGORY Character(1) VARCHAR2(1) NOT NULL Term Category
0=Full Year
1=1st Semester
2=2nd Semester
3=Summer Session AUS
4=Winter Session AUS
C=Medical Clinical
I=Intersession Term
M=Medical Level 1
R=Regular Term
S=Summer Term
W=Winter Term

Default Value: R

108 ACAD_CALENDAR_ID Character(4) VARCHAR2(4) NOT NULL Academic Calendar

Prompt Table: ACAD_CAL_TABLE

109 TC_UNITS_ADJUST Number(9,3) DECIMAL(8,3) NOT NULL Transfer Credits Units Adjustment