Page Comparison

Oracle Field/Calc

DW Field

Description (Sample)

Data Type

Field Length

SUBSTR (REPORTSNET.F_GET_TEST_SCORE_AP (spriden_pidm, 'CLAB'),1,1)

AP_CALCAB_SCORE

AP test score on CALC AB Exam

SUBSTR (REPORTSNET.F_GET_TEST_SCORE_AP (spriden_pidm, 'CLBC'),1,1)

AP_CALCBC_SCORE

AP test score on CALC BC Exam

SUBSTR (REPORTSNET.F_GET_TEST_SCORE_AP (spriden_pidm, 'STAT'),1,1)

AP_STATS_SCORE

AP test score on STATS Exam

SUBSTR (REPORTSNET.F_GET_TEST_SCORE_AP (spriden_pidm, 'ELNG'),1,1)

AP_LANGCOMP_SCORE

AP test score on LANG & COMP Exam

SUBSTR (REPORTSNET.F_GET_TEST_SCORE_AP (spriden_pidm, 'ELIT'),1,1)

AP_LITCOMP_SCORE

AP test score on LIT & COMP Exam

REPORTSNET.F_GET_STUDENT_IS_FOSTER_YOUTH (

SPRIDEN_PIDM, SFBETRM_TERM_CODE)

FOSTER_YOUTH

For Term < 201330, from SZRCCAP_FOSTER_YOUTH column, which is Yes/No for Foster Youth Residency:

‘Y’: student is foster youth

‘N’: student is not foster youth

Null: unknown

For Term >= 201330, from BANNER SVBSFYS table which is based on the Foster Youth Status question on the Application (value 0 to 5) (this can be updated in BANNER so is more ‘correct’ but we only started capturing this in Feb 2013):

‘Y’: value > 0 selected

‘N’: other or none selected

REPORTSNET.F_GET_STUDENT_IS_BASIC_SKILLS (in_pidm, in_term)

BASIC_SKILLS

‘Y’: Basic Skills

‘N’: Not Basic Skills

A Non Basic Skills student is defined as

Completed MATH 360 or higher

OR has MATH placement score > 3.0

AND

Completed ENGL 360 or higher

OR has ENGL placement score > 3.0

All other students are considered “Basic Skills”

CALC_RACE_ETHN

COMPUTED (Tim Garner rules for a single race/ethnicity given many factors):

when [NEW_ETHNICITY] is null
and [RACES] is null
and[ETHNICITY] is null
then 'Unknown'
when [VISA_TYPE] = 'F1' then 'Non-res. alien'
when [NEW_ETHNICITY] is null
and first character of [RACES] is 'H'
then 'H'
when [NEW_ETHNICITY] is null
and [RACES] contains a pipe
then 'Two or more'
when [NEW_ETHNICITY] is null
and [RACES] is not null
then first character of [RACES]
when [NEW_ETHNICITY] is null
and [RACES] is null
and [ETHNICITY]='Other'
then 'Unknown'
when [NEW_ETHNICITY] is null
and [RACES] is null
and [ETHNICITY]='Am. Indian or Alaskan Native' then 'N'
when [NEW_ETHNICITY] is null
and [RACES] is null
and [ETHNICITY]='Asian or Pacific Islander'
then 'Unknown'
when [NEW_ETHNICITY] is null
and [RACES] is null
then first character of [ETHNICITY]
when [NEW_ETHNICITY]='Hispanic' then 'H'
when [NEW_ETHNICITY]='Not Hispanic'
and [RACES] is nul
and [ETHNICITY]='Other'
then 'Unknown'
when [NEW_ETHNICITY]='Not Hispanic'
and [RACES] is null
and [ETHNICITY]='Am. Indian or Alaskan Native' then 'Unknown'
when [NEW_ETHNICITY]='Not Hispanic'
and [RACES] is null
and [ETHNICITY]='Asian or Pacific Islander'
then 'Unknown'
when [NEW_ETHNICITY]='Not Hispanic'
and [RACES] is null
then first character of [ETHNICITY]
when [NEW_ETHNICITY]='Not Hispanic'
and [RACES] contains a pipe
then 'Two or more'
when [NEW_ETHNICITY]='Not Hispanic'
then first character of [RACES]
else 'Unknown'

EOPS_CARE

Possible 3 characters. The first character is either a ‘Y’ or ‘N’.

If ‘Y’, the student is in the EOPS CARE program for the term of the record.

If ‘N’, the student is not in the EOPS CARE program for the term of the record and characters 2 and 3 will contain the exit code:

CE: Chose not to be EOPS

CL: Exit CARE - No longer EOPS

CM: Exit CARE - Married or not SHH

CR: Exit CARE - Did not Recertify

CT: Exit CARE - Not TANF

CX: Exit CARE - Termination

SUBSTR(

COS_PIN_REG.cos_is_hs(spriden_pidm, sfbetrm_term_code)

, 1, 15)

HS_STATUS

Values returned:

UPHS - UPHS student for that term

VTEC - VTEC student for that term

Y - other concurrent student

Null - not a concurrent student

SUBSTR(baninst1.COS_GENERAL_RESTR.f_is_CareerAdvAcademyPart(SPRIDEN_PIDM, sfbetrm.sfbetrm_term_code), 1, 1)

CAREER_ADVACAD

Y/N – If Student is in CAA (Career Advancement Academy Participant)

SUBSTR(BANINST1.cos_general.f_is_on_deans_or_pres_list(spriden.spriden_pidm, SFBETRM.SFBETRM_TERM_CODE), 1, 1)

DEAN_PRES_CODE

D/P/NULL – if a student is on the President’s or Dean’s List for a term

SUBSTR(CASE BANINST1.cos_general.f_is_on_deans_or_pres_list(spriden.spriden_pidm, SFBETRM.SFBETRM_TERM_CODE) --ryanwh 1.16.2015 added Dean's and President's list by term.

WHEN NULL

THEN NULL

ELSE f_get_desc_fnc('STVASTD', BANINST1.cos_general.f_is_on_deans_or_pres_list(spriden.spriden_pidm, SFBETRM.SFBETRM_TERM_CODE), 30)

END, 1, 30)

DEANS_PRES_DESC

If null, it doesn’t put a description. If P or D, it will return the description listed in Banner on the STVASTD table

SGBSTDN.SGBSTDN_RESD_CODE

RESD_CODE

Residency code from the student’s SGBSTDN record by term

STVRESD.STVRESD_DESC

RESD_DESC

Residency description for the student’s residency code

SVBSCAA.SVBSCAA_CAA_IND

CAA

Indicates if a student is a part of the CAA (Career Advancement Academy), which returns a Y or null.

,SUBSTR(baninst1.cos_general.f_trio_code(spriden.spriden_pidm, SFBETRM.SFBETRM_TERM_CODE), 1, 10)

TRIO_CODE

Indicates if a student is a part of the TRIO program. One of two codes will be listed, TRIOSSS (TRIO Student Support Services) or TRIOUBMS (TRIO Upward Bound Math/Science)

SUBSTR(cos_f_get_tele_plain(spriden_pidm, 'CL'), 1, 21) AS CELL_PHONE

CELL_PHONE

The cell phone of the student added for SSO purposes.

COS_STU_EMAIL.STUDENT_PASSWORD AS ENCRYPTED_PASSWORD

ENCRYPTED_PASSWORD

Students encrypted password for SSO purposes.

SUBSTR (SZRCCAP_PARENT_EDLV_1, 1, 1) PARENT_EDLV_1_CODE

PARENT_EDLV_1_CODE

Parent educational level code valid options based on MIS values as of 3/18/2015 per Research Office request.

NOTE: The description from the CCCApply application do not match the description from MIS.

MIS Values and description:

Code - Description

1 - Grade 9 or less

2 - Grade 10, 11, or 12 but did not graduate

3 - High school graduate

4 - Some college but no degree

5 - AA/AS degree

6 - BA/BS degree

7 - Graduate or professional degree beyond a BA/BS

X - Unknown / Unreported

Y - Not applicable, no noted guardian/parent

CCCApply application:

1 - Grade 9 or less

2 - Some high school; did not graduate

3 - High school graduate (diploma, GED, or equivalent)

4 - Some college credit; no degree

5 - Associate’s degree (for example: AA, AS)

6 - Bachelor’s degree (for example: BA, BS)

7 - Graduate degree (Master’s, Ph.D., or professional degree beyond Bachelor’s)

X - Unknown

Y - No parent or guardian raised me

SUBSTR(BANINST1.COS_GENERAL_CROSSWALK.F_GET_PARENT_ED_LVL_DESC (ccap.SZRCCAP_PARENT_EDLV_1), 1, 60) PARENT_EDLV_1_DESC

PARENT_EDLV_1_DESC

Description above with code.

SUBSTR (SZRCCAP_PARENT_EDLV_2, 1,1) PARENT_EDLV_2_CODE

PARENT_EDLV_2_CODE

Description above with code.

SUBSTR (BANINST1.COS_GENERAL_CROSSWALK.F_GET_PARENT_ED_LVL_DESC (ccap.SZRCCAP_PARENT_EDLV_2), 1, 60) PARENT_EDLV_2_DESC,

PARENT_EDLV_2_DESC

Description above with code.

SVBSFYS_HOME_CODE

Homeless_Status

Homeless status as determined by the student’s application

BANINST1.SV_MIS_SB_STU.f_get_sexual_orientation