Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Each record describes a student who has applied to graduate or has actually graduated with a degree. There may be multiple student records for the same term since a student can apply for and be awarded more than one degree for a term. An important field in this table is STATUS which contains a 2-letter code: an ‘AW’ means the student graduated with a degree; a ‘CT’ means the student graduated with a certificate; other values for STATUS are described in the table below.

For example, these records show 3 certificates achieved by the student for the same term (not all columns shown):

TERMPIDMSTUDENTNAMESTATUSDEGREE_CODEPROGRAMMAJORMAJOR_DESCAGE_AT_END_TERM

200620101462Rapozo, Kristina KCTCERFCT-PARALEG220Paralegal29

200620101462Rapozo, Kristina KCTCERECT-LAWCLK221Law Office Clerk/Rec29

200620101462Rapozo, Kristina KCTCERECT-LEGDOC222Legal Secretary29

To see a list of only students with the STATUS of ‘AW’ (graduated with a degree), use the view vStudentGradDegree. This view contains all of the same fields as the table StudentGraduates.

Oracle source: ReportsNet.Student_Graduated view

Oracle objects: BANINST1.cos_sv_graduation view (spraddr, spriden, SHRDGMR, STVTERM, SORHSCH, spbpers)

Updated: nightly

Oracle Field/Calc

DW Field

Description or Sample

SHRDGMR.SHRDGMR_TERM_CODE_GRAD

TERM

200710 (Fall = 10, Spring = 20, Summer = 30)

STVTERM.STVTERM_DESC

SEMESTER

SPRIDEN.SPRIDEN_PIDM

PIDM

STVTERM.STVTERM_ACYR_CODE

ACAD_YR

nvl(spriden_last_name, '') || ', ' || nvl(spriden_first_name, '') || ' ' || nvl(spriden_mi, '')

STUDENTNAME

Concatenation of Last, First Middle init (Smith, John A)

SPRIDEN.SPRIDEN_ID

STUDENTID

Banner Id (@12345678)

COS_F_GET_LGPA(SPRIDEN_PIDM,'UG','I')

COS_GPA

GPA for classes taken at COS

SHRDGMR.SHRDGMR_DEGS_CODE

STATUS

Code from STVDEGS:

AW: Graduated with degree

CT: Certificate of Achievement

PN: Pending

SC: Skill Cert CCCCO Aproved

SK: Skill Cert Not CCCCO Aproved

SO: Sought

SHRDGMR.SHRDGMR_DEGC_CODE

DEGREE_CODE

Code

Description

Level

Activity Date

000000

Undeclared

6/24/1991 0:00

AA

Associate of Arts

AS

9/18/2007 0:00

AA-T

AA for Transfer (ADT)

AS

12/17/2018 0:00

AAT

AA for Transfer (Non-ADT)

AS

12/17/2018 0:00

AS

Associate of Science

AS

7/8/2016 0:00

AS-T

AS for Transfer (ADT)

AS

12/17/2018 0:00

AST

AS for Transfer (Non-ADT)

AS

12/17/2018 0:00

BA

Bachelor of Arts

BA

1/4/1995 0:00

BS

Bachelor of Science

BA

1/4/1995 0:00

BSN

BS in Nursing

BA

6/28/1995 0:00

CERB

Certif 12 to 17.9

11/19/2015 0:00

CERE

Certif 6 to 17.9

11/19/2015 0:00

CERF

Certificate, 60+ units

5/15/2002 0:00

CERL

Certificate, 18 to 29.9 units

3/5/2013 0:00

CERM

Certificate, 8 to 15.9 units

1/21/2020 13:58

CERN

Certificate, 16 to 29.9 units

1/21/2020 13:59

CERO

Certificate, under 6 units

9/14/2007 0:00

CERT

Certificate, 30 to 59 units

5/15/2002 0:00

CPR

CPR Certification

LA

5/9/1995 0:00

EDD

Doctor of Education

DR

1/4/1995 0:00

JD

Juris Doctor

DR

1/4/1995 0:00

MA

Master of Arts

MA

1/4/1995 0:00

MBA

Master of Business Admin.

MA

1/4/1995 0:00

MD

Doctor of Medicine

DR

1/4/1995 0:00

MED

Master of Education

MA

1/4/1995 0:00

MFA

Master of Fine Arts

MA

1/4/1995 0:00

MS

Master of Science

MA

1/4/1995 0:00

MSW

Master of Social Work

MA

1/4/1995 0:00

NCRG

Non Credit under 48 hours

5/15/2002 0:00

NCRH

Non Credit 48 to 95 hours

5/15/2002 0:00

NCRI

Non Credit 96 to 143 hours

5/15/2002 0:00

NCRJ

Non Credit 144 to 191 hours

5/15/2002 0:00

NCRK

Non Credit 192 to 287 hours

5/15/2002 0:00

NCRP

Non Credit 288 to 479 hours

5/15/2002 0:00

NCRQ

Non Credit 488 to 959 hours

5/15/2002 0:00

NCRR

Non Credit over 960 hours

5/15/2002 0:00

PHD

Doctor of Philosophy

DR

1/4/1995 0:00/

SHRDGMR.SHRDGMR_PROGRAM

PROGRAM

See Saturn.Smpprle.Smpprle_Program

153 programs.

Example: AA-LIBARTS

SHRDGMR.SHRDGMR_MAJR_CODE_1

MAJOR

Major code from Saturn.STVMAJR.STVMAJR_CODE

197 majors

Substr(f_get_desc_fnc('STVMAJR',SHRDGMR.SHRDGMR_MAJR_CODE_1,30),1,30)

MAJOR_DESC

Description of Major

SUBSTR(BANINST1.COS_GENERAL_RESTR.f_aid_ind_from_stvmajor_code(g.MAJOR, G.TERM_CODE), 1, 1)

FIN_AID_IND_BY_MJR

This indicates whether the major is financial aid eligible. Returns Y or N. ryanwh 12.11.2014

SUBSTR(BANINST1.COS_GENERAL_RESTR.f_cte_ind_from_stvmajor_code(g.MAJOR, G.TERM_CODE), 1, 1)

CTE_IND_BY_MJR

This indicates whether the top code of the major identifies it as a CTE program. Returns Y or N. ryanwh 12.11.2014.

SORHSCH.SORHSCH_SBGI_CODE

HS_CODE

See Saturn.STVSBGI.STVSGBI_CODE

decode(SORHSCH.SORHSCH_SBGI_CODE, null, null,

substr(f_get_desc_fnc('STVSBGI',SORHSCH.SORHSCH_SBGI_CODE,30),1,30) )

HS_DESC

Description of HS_CODE

SORHSCH.SORHSCH_GRADUATION_DATE

HS_GRAD_DATE

Date of graduation from high school

spbpers.SPBPERS_BIRTH_DATE

BIRTHDATE

f_calculate_age(stvterm_end_date,spbpers_birth_date, spbpers_dead_date)

AGE_AT_END_TERM

Age of student at end of term

shrdgmr.SHRDGMR_DEPT_CODE

DEPT

Department of the Major:

From STVDEPT Oracle table. 4-char department code.

decode(shrdgmr.SHRDGMR_DEPT_CODE, null, null,

substr(f_get_desc_fnc('STVDEPT',shrdgmr.SHRDGMR_DEPT_CODE,30),1,30))

DEPT_DESC

Descrition of Dept

PIDM

PIDM

Unique identifier for the student in Banner

stvmajr_cipc_code

CIPC_CODE

CIP code for the Major

stvmajr_tops_code

TOPS_CODE

TOPS code for the Major

Gets data from SPBPERS_SEX AS Gender

GENDER

Gender of student

nvl( decode( spbpers_ethn_code, null, '', substr(f_get_desc_fnc('STVETCT', (substr(f_get_ethn_category(spbpers_ethn_code, 'ETCT'), 1, 1)), 30), 1, 30)), '')

ETHNICITY

40-char description of spbpers_ethn_code, coming from

STVETCT:

1 Black Non-Hispanic

2 Am. Indian or Alaskan Native

3 Asian or Pacific Islander

4 Hispanic

  • No labels