Page Comparison

DW Field

Data TypeHIGHSCHOOL

Field Length

decode(f_get_hsch_code(sfbetrm.sfbetrm_pidm), null, null,substr(f_get_desc_fnc('STVSBGI',f_get_hsch_code(sfbetrm.sfbetrm_pidm),30),1,30))

ENG251_ELIG

f_test_score_fnc (spriden.spriden_pidm,'LE','HIGH',null)

ENG251_ELIG

Score on most recent English 251 placement test. 0 to 6.0.

SELECT MAX Student’s highest LE score.

ENG_TEST_DATE

ENG_TEST_DATE

Test  Date of most recent LE score. Does not necessarily relate to ENG251_ELIG.

 MATHPLACE

f_test_score_fnc (spriden_pidm,'LM','HIGH',null)

MATHPLACE

Score on most Student’s highest LM score. Math placement score that does not include AM (Any Math) placement scores.

 MATH_TEST_DATE

MATH_TEST_DATE

Test date of Date of most recent LM score. Does not necessarily relate to MATHPLACE.

READ_LEVEL

f_test_score_fnc (spriden_pidm,'LR','HIGH',null)

READ_LEVEL

Score Student’s highest LR score.

READ_TEST_DATE

Date of most recent LR score. Does not necessarily relate to READ_TEST_DATETest LEVEL.

 CELSA_ESL

f_test_score_fnc (spriden_pidm,'ESL1','HIGH',null)

Highest score on CELSA _ ESL test

Score on CELSA ESL test

SELECT MAX ESL_TEST_DATE

Test date of most recent ESL test

 ESL_PLACEMENT

f_test_score_fnc (spriden.spriden_pidm, 'LESL', 'HIGH', NULL)

ESL_PLACEMENT

ESL Placement Level

 Highest LESL Placement score.

OVERALL_GPA

baninst1.cos_f_get_lgpa(spriden_pidm, 'UG','O')

OVERALL_GPA

Float – from all terms attended. Updated during semester Includes transfer courses.

 OVERALL_HRS_EARNED

baninst1.cos_f_get_lhrs_ern(spriden_pidm, 'UG','O')OVERALL_HRS_EARNED

Float – Units earned with grades A to D, P, or CR. This includes transferred units into COS and units earned at COS.

 OVERALL_HRS_PASSED

baninst1.cos_f_get_lhrs_gpa(spriden_pidm, 'UG','O')

OVERALL_HRS_PASSED

Float – Units earned with grades A to F. This includes transferred units into COS and units earned at COS. Used for GPA calculation.

 TRANSFER_IN_UNITS

baninst1.cos_f_get_lhrs_ern(spriden_pidm, 'UG','T')TRANSFER_IN_UNITS

Units transferred from outside institution

 TRANSFER_IN_GPA

baninst1.cos_f_get_lgpa(spriden_pidm, 'UG','T')TRANSFER_IN_GPA

GPA of units transferred from outside institution

 TERM_GPA

baninst1.cos_f_get_tgpa(spriden_pidm, sfbetrm_term_code, 'UG','O') as term_gpa,TERM_GPA

Float – GPA for this term. Includes transfer units.

 TERM_HOURS

baninst1.cos_f_get_tenrl(spriden_pidm, sfbetrm_term_code)TERM_HOURS

Float – Hours enrolled for this term (R% registration). Same as units.

[Note: used in StudentFundType view]

 TERM_PASSED

baninst1.cos_f_get_tpass(spriden_pidm, sfbetrm_term_code)

TERM_PASSED

Float – Units passed for this term.

Changed to look at current grade in Academic History instead of initial grade in registration.

Includes but not limited to (has numbers too but excluded them here):

A, A+, A-, B, B+, B-, C, C+, CR, D, D+, D-, P

NOTE: There is no C-, we do not give out this grade at this time.

See following internal sql (oracle) – maybe mod term_passed_abc to use this instead:

SELECT DISTINCT shrgrde_code

FROM shrgrde

WHERE shrgrde_passed_ind = 'Y' and regexp_like(shrgrde_code, '\D')

ORDER BY 1; 

TERM_PASSED_ABC

baninst1.cos_f_get_tpass_abc(spriden_pidm, sfbetrm_term_code)TERM_PASSED_ABC

Float – Units passed for courses taken this term with grade of A, B, or C (including + and – grades)

 TERM_ACCUM_UNITS_ATT

F_GET_ACCUM_TUNITS_ATT (spriden_pidm,'000000',

sfbetrm_term_code, 'UG')

TERM_ACCUM_UNITS_ATT

Accumulative units attempted from the earliest term available in Banner to the term of this record. Same as Units Attempted on SWIASTD screen (except this is an accumulation for each term). This includes both Institutional and Transfer.

Transfer.

TERM_ACCUM_UNITS_PASSED

F_GET_ACCUM_TUNITS_PASSED (spriden_pidm,'000000',

sfbetrm_term_code, 'UG')TERM_ACCUM_UNITS_PASSED

Accumulative units passed from the earliest term available in Banner to the term of this record. Same as Units Attempted on SWIASTD screen (except this is an accumulation for each term). This includes both Institutional and Transfer.

 TERM_ACCUM_GPA

reportsnet.F_GET_ACCUM_TGPA (spriden_pidm,

'000000', sfbetrm_term_code, 'UG', 'I')TERM_ACCUM_GPA

Accumulative GPA from the earliest term available in Banner to the term of this record.

 COS_DEGREE_UNITS_ATT

reportsnet.f_get_univ_units (spriden_pidm,

'DA', sfbetrm_term_code)

COS_DEGREE_UNITS_ATT

Units attempted for degree for the term on this record at COS. This does NOT include Credit/No Credit courses.

 COS_DEGREE_PTS

reportsnet.f_get_univ_qual_pts (spriden_pidm,

'DA', sfbetrm_term_code)

COS_DEGREE_PTS

Grade points for degree for the term on this record at COS

 COS_DEGREE_UNITS_PASSED

reportsnet.f_get_univ_units_passed (spriden_pidm, 'DA', sfbetrm_term_code)COS_DEGREE_UNITS_PASSED_code)

Units passed for degree for the term on this record at COS. This does include Credit/No Credit courses.

 COS_DEGREE_GPA

reportsnet.f_get_univ_qual_pts (spriden_pidm, 'DA', sfbetrm_term_code)

/ reportsnet.f_get_univ_units (spriden_pidm, 'DA',sfbetrm_term_code)

COS_DEGREE_GPA

Grade Point Average for degree for the term on this record at COS

 TERM_ACCUM_COS_DEGREE_GPA

reportsnet.f_get_accum_univ_qual_pts (spriden_pidm, 'DA', '000000', sfbetrm_term_code)

/ reportsnet.f_get_accum_univ_units (spriden_pidm, 'DA', '000000', sfbetrm_term_code)TERM_ACCUM_COS_DEGREE_GPA

Accumulative GPA for degree at COS from the earliest term available in Banner to the term of this record

 CSU_DEGREE_UNITS_ATT

reportsnet.f_get_univ_units (spriden_pidm, 'TCSU', sfbetrm_term_code)CSU_DEGREE_UNITS_ATT

Units attempted for degree for the term on this record transferable to a California State University

 CSU_DEGREE_PTS

reportsnet.f_get_univ_qual_pts (spriden_pidm, 'TCSU', sfbetrm_term_code)

CSU_DEGREE_PTS

Grade points for degree for the term on this record transferable to a California State University

University

CSU_DEGREE_UNITS_PASSED

reportsnet.f_get_univ_units_passed (spriden_pidm,'TCSU',sfbetrm_term_code)CSU_DEGREE_UNITS_PASSED

Units passed for degree for the term on this record transferable to a California State University 

TERM_ACCUM_CSU_DEGREE_

UNITS_PASSED

reportsnet.f_get_accum_univ_units (spriden_pidm, 'TCSU',

'000000', sfbetrm_term_code)TERM_ACCUM_CSU_DEGREE_

UNITS_PASSED

Accumulative units passed for degree from the earliest term available in Banner to the term of this record transferable to a California State University

 CSU_DEGREE_GPA

reportsnet.f_get_univ_qual_pts (spriden_pidm, 'TCSU', sfbetrm_term_code)

/ reportsnet.f_get_univ_units (spriden_pidm, 'TCSU', sfbetrm_term_code)

CSU_DEGREE_GPA

Grade Point Average for degree for the term on this record transferable to a California State University

 TERM_ACCUM_CSU_DEGREE_GPA

reportsnet.f_get_accum_univ_qual_pts (spriden_pidm,'TCSU', '000000', sfbetrm_term_code)

/ reportsnet.f_get_accum_univ_units (spriden_pidm, 'TCSU', '000000', sfbetrm_term_code)TERM_ACCUM_CSU_DEGREE_GPA)

Accumulative GPA for a CSU degree from the earliest term available in Banner to the term of this record

 UC_DEGREE_UNITS_ATT

reportsnet.f_get_univ_units (spriden_pidm, 'TUC',

sfbetrm_term_code)UC_DEGREE_UNITS_ATT

Units attempted for degree for the term on this record transferable to a University of California

 UC_DEGREE_PTS

reportsnet.f_get_univ_qual_pts (spriden_pidm, 'TUC',

sfbetrm_term_code)UC_DEGREE_PTS

Grade points for degree for the term on this record transferable to a University of California

 UC_DEGREE_UNITS_PASSED

reportsnet.f_get_univ_units_passed (spriden_pidm, 'TUC',

sfbetrm_term_code)UC_DEGREE_UNITS_PASSED

Units passed for degree for the term on this record transferable to a University of California

 TERM_ACCUM_UC_DEGREE_UNITS_PASSED

reportsnet.f_get_accum_univ_units (spriden_pidm, 'TUC',

'000000', sfbetrm_term_code)

TERM_ACCUM_UC_DEGREE_

UNITS_PASSED)

Accumulative units passed for degree from the earliest term available in Banner to the term of this record transferable to a University of California

 UC_DEGREE_GPA

reportsnet.f_get_univ_qual_pts (spriden_pidm, 'TUC',

sfbetrm_term_code)

/ reportsnet.f_get_univ_units_passed (spriden_pidm,

'TUC', sfbetrm_term_code)UC_DEGREE_GPA

Grade Point Average for degree for the term on this record transferable to a University of California

 TERM_ACCUM_UC_DEGREE_GPA

reportsnet.f_get_accum_univ_qual_pts (spriden_pidm,

'TUC', '000000', sfbetrm_term_code)

/ reportsnet.f_get_accum_univ_units (spriden_pidm,

'TUC', '000000', sfbetrm_term_code)TERM_ACCUM_UC_DEGREE_GPA

Accumulative GPA for a UC degree from the earliest term available in Banner to the term of this record

 OVERALL_COS_DEGREE_UNITS_ATT

baninst1.cos_f_univ_units(spriden.spriden_pidm, 'DA')OVERALL_COS_DEGREE_

UNITS_ATT

Total units attempted for degree (for all terms including terms older than those in the warehouse) at COS. This does NOT include Credit/No Credit courses.

 OVERALL_COS_DEGREE_PTS

baninst1.cos_f_univ_qual_pts(spriden.spriden_pidm, 'DA')OVERALL_COS_DEGREE_PTS')

Total grade points for degree (for all terms including terms older than those in the warehouse) at COS 

OVERALL_COS_DEGREE_

UNITS_PASSED

baninst1.cos_f_univ_passed(spriden.spriden_pidm, 'DA')OVERALL_COS_DEGREE_

UNITS_PASSED

Total units passed for degree (for all terms including terms older than those in the warehouse) at COS. This does include Credit/No Credit courses. 

OVERALL_COS_DEGREE_

GPA

to_char(baninst1.cos_f_univ_qual_pts(spriden.spriden_pidm, 'DA') / nullif(baninst1.cos_f_univ_units(spriden.spriden_pidm, 'DA'),0),'99.99')

OVERALL_COS_DEGREE_

GPA

Grade Point Average for degree (for all terms including terms older than those in the warehouse)at COS 

OVERALL_CSU_DEGREE_

UNITS_ATT

baninst1.cos_f_univ_units(spriden.spriden_pidm, 'TCSU')

OVERALL_CSU_DEGREE_

UNITS_ATTspriden_pidm, 'TCSU')

Total units attempted for degree (for all terms including terms older than those in the warehouse) transferable to a California State University

 OVERALL_CSU_DEGREE_PTS

baninst1.cos_f_univ_qual_pts(spriden.spriden_pidm, 'TCSU')OVERALL_CSU_DEGREE_PTS

Total grade points for degree (for all terms including terms older than those in the warehouse)transferable to a California State University

 OVERALL_CSU_DEGREE_UNITS_PASSED

baninst1.cos_f_univ_passed(spriden.spriden_pidm, 'TCSU')

OVERALL_CSU_DEGREE_

UNITS_PASSED

Total units passed for degree (for all terms including terms older than those in the warehouse) transferable to a California State University

 OVERALL_CSU_DEGREE_GPA

to_char(baninst1.cos_f_univ_qual_pts(spriden.spriden_pidm, 'TCSU') / nullif(baninst1.cos_f_univ_units(spriden.spriden_pidm, 'TCSU'),0),'99.99')

OVERALL_CSU_DEGREE_GPA

Grade Point Average for degree (for all terms including terms older than those in the warehouse) transferable to a California State University

State University

OVERALL_UC_DEGREE_UNITS_ATT

baninst1.cos_f_univ_units(spriden.spriden_pidm, 'TUC')

OVERALL_UC_DEGREE_

UNITS_ATT

Total units attempted for degree (for all terms including terms older than those in the warehouse) transferable to a University of California

 OVERALL_UC_DEGREE_PTS

baninst1.cos_f_univ_qual_pts(spriden.spriden_pidm, 'TUC')OVERALL_UC_DEGREE_PTS

Total grade points for degree (for all terms including terms older than those in the warehouse) transferable to a University of California

 OVERALL_UC_DEGREE_UNITS_PASSED

baninst1.cos_f_univ_passed(spriden.spriden_pidm, 'TUC')OVERALL_UC_DEGREE_

UNITS_PASSED

Total units passed for degree (for all terms including terms older than those in the warehouse) transferable to a University of California

 OVERALL_UC_DEGREE_GPA

baninst1.cos_f_univ_qual_pts (spriden_pidm, 'TUC')

/ baninst1.cos_f_univ_units (spriden_pidm, 'TUC')OVERALL_UC_DEGREE_GPA)

Grade Point Average for degree (for all terms including terms older than those in the warehouse) transferable to a University of California

 EOPS

sgbeops.SGBEOPS_EOPS_CODE

EOPS

Code From STVEOPS (EOPS program). The ‘E’ value means the Student is part of the EOPS program during the term on this record. At the end of the term, the code may change to something other than C. So, they are in EOPS if this code is not null and not ‘C%’.

E: EOPS-Elig next term

G: EOPS-Successfully Comp. Goal

P: EOPS-failed Cont/CARE-New CARE

C: EOPS-Chosen EOPS/CARE-w/oWaiv

CE: Chose not to be in EOPS

S: EOPS-Completed 6 Sem.

U: EOPS-Comp 70 Units, end elig.

X: EOPS-Unknown/Unreported

B: CARE-waiver CalWORKS/TANF/AFDC

N: CARE-not served by CARE pgm

L: CARE-Obsolete Code/Do Not Use 

DRC

substr(f_get_student_is_disa(spriden.SPRIDEN_PIDM, sfbetrm.SFBETRM_TERM_CODE),1,1)

DRC

Student is disabled Student has a disability (Y). This value can only be determined once Sandy Gaither AAC has entered this student as a DRC student in Banner.

 DRC_CODES

substr(f_get_disa_codes(spriden.SPRIDEN_PIDM, sfbetrm.SFBETRM_TERM_CODE),1,10)

DRC_CODES

List of disability codes (1 character each, no delimiter, up to 10 codes)

 VATEA

SGBUSER.SGBUSER_SUDA_CODEVATEA

Vocational And Technological Education Act (A/N)

A: student in vocational program

N: in vocational course, but not vocational major

 PUENTE

SUBSTR(COS_GENERAL_RESTR.F_IS_PUENTE_BY_PIDM(spriden.SPRIDEN_PIDM), 1, 1)

PUENTE

Student is part of Puente program (Y or null). BANNER does not store this information per term. The nightly job updates this column for all rows in Student to the current Puente status.

 COHORT_CODES

substr(f_get_cohort_codes(spriden.SPRIDEN_PIDM, sfbetrm.SFBETRM_TERM_CODE),1,10)

COHORT_CODES

Currently limited to codes A through E

 REGISTERED_CLASSES

select count(sfrstcr.SFRSTCR_CRN) from sfrstcr

where sfrstcr.sfrstcr_term_code = sfbetrm.SFBETRM_TERM_CODE

AND sfrstcr.sfrstcr_pidm = SFBETRM.SFBETRM_PIDM

AND sfrstcr.SFRSTCR_RSTS_CODE like 'R%'

GROUP BY sfrstcr.SFRSTCR_PIDM

REGISTERED_CLASSES

Number of classes for which the student has registered

 CAMPUSES

f_get_campuses (spriden.spriden_pidm, sfbetrm.sfbetrm_term_code), 1, 100)CAMPUSES

Pipe delimited string of 3-char campus codes for all campuses at which the student is enrolled in courses.

 ACTIVITY_DATE

nvl(greatest(sfbetrm.sfbetrm_activity_date, spraddr.spraddr_activity_date, spriden.spriden_activity_date, sprtele.sprtele_activity_date, spbpers.spbpers_activity_date), sfbetrm.sfbetrm_activity_date) as activity_date

ACTIVITY_DATE

Datetime – most recent activity date from all tables involved (sfbterm, spraddr, spriden, sprtele, spbpers, sfbetrm). Essentially this is the last time that any information about the student was changed.

 CAST_CODE

substr(f_get_cast_code(spriden.spriden_pidm),1,2) as CAST_CODE,_cast_code

CAST_CODE

Combined Academic Standing Code for the tern of this record. Note that this code will not be correct until grades have been entered at the end of the term:

00: Good Standing

03: Progress Probation

04: Academic Probation

05: Both Prog & Acad Probation

06: Progress Dismissal

07: Academic Dismissal

08: Both Acad & Prog Dismiss

 EMAIL

substr(BANINST1.cos_f_get_email(spriden.SPRIDEN_PIDM),1,90) as EMAIL EMAIL

The Student’s email address

 VISA_TYPE

substr(f_get_visa_type(spriden.SPRIDEN_PIDM, stvterm.STVTERM_START_DATE, stvterm.STVTERM_END_DATE),1,2)

VISA_TYPE

see VISA type code in Appendix

 CALWORKS

substr(f_get_calworks_code(spriden.SPRIDEN_ID, sfbetrm.sfbetrm_term_code),1,1)

CALWORKS

2: CALWORKS self referral participation

3: CALWORKS county referral participation

Null if not participating in CALWORKS

 VETERAN

substr(f_get_veteran_status(spriden.SPRIDEN_PIDM, sfbetrm.sfbetrm_term_code),1,1)

VETERAN

‘Y’ if the student was a veteran for the term of this record. Null otherwise.

 REGIS_APPT

cast(cosbwckrgtm.cos_f_calc_reg_appt(

SPRIDEN.SPRIDEN_PIDM, cos_f_get_next_term()) as date)

REGIS_APPT

The date of the student’s next registration appointment

 ATHLETE

select s.SGRSPRT_SPST_CODE from sgrsprt s where s.sgrsprt_term_code = term and s.SGRSPRT_PIDM = pidm

and s.SGRSPRT_SPST_CODE = 'A';ATHLETE

‘Y’ if the student is an athlete for the term of this record (at least one record in SGRSPRT where SGRSPRT_SPST_CODE = ‘A’)

 FIRST_YR_EXPERIENCE

‘Y’ if the student is in First Year Experience for the term of this record.

 SECOND_YR_EXPERIENCE

select 'Y' from sfrsrpo s where s.sfrsrpo_term_code = term

and s.SFRSRPO_PIDM = pidm

and s.SFRSRPO_ROVR_CODE = 'SYE'SECOND_YR_EXPERIENCE

‘Y’ if the student is in Second Year Experience for the term of this record.

 WIA

select decode (s.sgrsact_actc_code, 'wia', 'y', 'n')

from saturn.sgrsact s

where s.sgrsact_term_code = sfbetrm_term_code

and s.sgrsact_actc_code = 'wia'

and s.sgrsact_pidm = spriden.spriden_pidmWIA

‘Y’ if the student is WIA (Workforce Investment Act) for the term of this record.

 PELL

decode(FINANCIAL_AID1_NON_BOGG.AWARD_PAID_TERM, null, 'N', 0, 'N', 'Y')

PELL

‘Y” if the Student was awarded PELL for the term of this record. ‘N’ otherwise.

 DEPENDENT

RCRAPP2_MODEL_CDE when RCRAPP2_INFC_CODE = 'EDE'

 DEPENDENT

Dependency status from the FAFSA, if the student submitted a FAFSA. This is the status for the aid year in which this record’s term falls (example: 200810 is in the 0708 aid year, so this value will be the same for 200810, 200820, 200830):

I: Independent

D: Dependent

Null: student did not submit a FAFSA OR they did not supply a dependency status

 ED_PLAN_DATE

(BANINST1.COS_GENERAL.F_MAX_SIGNED_EDPLAN_DATE (s.SPRIDEN_PIDM, f.sfbetrm_term_code)) AS Ed_Plan_DateED_PLAN_DATE

Date that the student met with a counselor to create an educational plan. If null, no meeting took place and no plan was created.

NOTE: This does NOT show the most recent date just that a meeting took place at one time. This is also looking at an older table so the data is inaccurate.

 ED_LEVEL_CODE

SGBSTDN.SGBSTDN_EDLV_CODE

ED_LEVEL_CODE

A three position alphanumeric field which indicate the highest level of the education that the student completed

 FIRST_GEN

SUBSTR (REPORTSNET.F_GET_STUDENT_IS_FIRST_GEN (SPRIDEN.SPRIDEN_PIDM, sfbetrm.sfbetrm_term_code), 1, 1 )

FIRST_GEN

‘Y’ / ‘N’ if Student is a first-generation college student (based on 2 Parent Education Level questions on CCCApply).

 ORIENTATION

REPORTSNET.F_GET_STUDENT_ORIENTATION_DATE

(SPRIDEN.SPRIDEN_PIDM)ORIENTATION

The date the student attended orientation. If null, we have no record of the student attending orientation.