StudentNet.dbo.Applicant table

Oracle Field/Calc

DW Field

Description or Sample

SZRCCAP_TERM_CODE

TERM

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

SZRCCAP_SEQNO

SEQNO

Unique number for the application. In the case of term 200800 where 2 records are created, both records have the same SEQNO

SZRCCAP_PIDM

PIDM

Up to 10-digit unique Banner id for student

SZRCCAP_ID

STUDENTID

Banner Id (@12345678)

SZRCCAP_CAMP_CODE

• CAMPUS_CODE

see Campus Code in Appendix

SZRCCAP_FIRST_PASS_IND

• FIRST_PASS_IND

Processing flag

SZRCCAP_DUPE_OK

• DUPE_OK

Processing flag

SZRCCAP_CCCAPPLY_LOADED

• CCCAPPLY_LOADED

When downloaded from CCCApply

SZRCCAP_BANNER_UPDATED

BANNER_UPDATED

When processing completed

SZRCCAP_MAJR_CODE_1

MAJR_CODE_1

Major code from Saturn.STVMAJR.STVMAJR_CODE

197 majors

SZRCCAP_EGOL_CODE

EGOL_CODE

See Educational Goal in Appendix

SZRCCAP_LAST_NAME

LASTNAME

SZRCCAP_NAME_SUFFIX

• NAME_SUFFIX

SZRCCAP_FIRST_NAME

FIRSTNAME

SZRCCAP_NO_FIRST_IND

NO_FIRST_IND

Indicator of no first name: 1 or null

SZRCCAP_MI

MIDINIT

SZRCCAP_OTHER_LAST_NAME

• OTHER_LAST_NAME

SZRCCAP_OTHER_FIRST_NAME

• OTHER_FIRST_NAME

SZRCCAP_SSN_SOURCE

• SSN_SOURCE

SSN as entered

SZRCCAP_SSN

SSN

SZRCCAP_NO_SSN_IND

NO_SSN_IND

Indicator of no SSN: 1 or null

SZRCCAP_BIRTH_DATE

BIRTHDATE

SZRCCAP_SEX_SOURCE

• SEX_SOURCE

Sex as entered

SZRCCAP_SEX

SEX

SZRCCAP_ETHN_CODE_SOURCE

• ETHN_CODE_SOURCE

Ethnicity code as entered (no longer used)

SZRCCAP_ETHN_CODE

ETHN_CODE

See Ethnicity code in Appendix (no longer used)

SZRCCAP_STREET_LINE1_MA

STREET_LINE1_MA

Mailing address (all MA fields)

SZRCCAP_CITY_MA

CITY_MA

SZRCCAP_STAT_CODE_MA

STAT_CODE_MA

State code (see Appendix)

SZRCCAP_ZIP_MA

ZIP_MA

SZRCCAP_NATN_CODE_MA

NATN_CODE_MA

2 letter nation code. See STVNATN table in Banner

SZRCCAP_INTL_CODE_MA

• INTL_CODE_MA

Not in use

SZRCCAP_PARENT_LAST

• PARENT_LAST

SZRCCAP_PARENT_FIRST

• PARENT_FIRST

SZRCCAP_RELT_CODE

• RELT_CODE

Relationship to Parent:

A: An Ex-spouse

B: Brother

C: Child

D: Doctor

E: Employer

F: Father

G: Grandparent

M: Mother

N: Neighbor

O: Relative

P: Spouse

R: Friend

S: Sister

U: Guardian

W: Domestic Partner

X: Significant Other

SZRCCAP_PR_SAME_AS_MA

• PR_SAME_AS_MA

Primary address same as Mailing address

SZRCCAP_STREET_LINE1_PR

STREET_LINE1_PR

Primary address info (all PR fields)

SZRCCAP_CITY_PR

CITY_PR

SZRCCAP_STAT_CODE_PR

STAT_CODE_PR

State code (see Appendix)

SZRCCAP_ZIP_PR

ZIP_PR

SZRCCAP_NATN_CODE_PR

NATN_CODE_PR

2 letter nation code. See STVNATN table in Banner

SZRCCAP_INTL_CODE_PR

• INTL_CODE_PR

Not in use

SZRCCAP_PHONE_SOURCE

• PHONE_SOURCE

Phone as entered

SZRCCAP_PHONE_AREA

PHONE_AREA

SZRCCAP_PHONE_NUMBER

PHONE_NUMBER

SZRCCAP_PHONE_EXT

• PHONE_EXT

SZRCCAP_EMAIL_ADDRESS

• EMAIL_ADDRESS

SZRCCAP_STYP_CODE_SOURCE

• STYP_CODE_SOURCE

Student Type Code as entered.

SZRCCAP_STYP_CODE

STYP_CODE

See Student Type Code in Appendix.

SZRCCAP_EDLV_CODE_SOURCE

• EDLV_CODE_SOURCE

Educational Level as entered

SZRCCAP_EDLV_YEAR

• EDLV_YEAR

Year Educational Level achieved

SZRCCAP_EDLV_CODE

EDLV_CODE

See Educational Level in Appendix

SZRCCAP_NAME_HSCH

NAME_HSCH

Name of High School

SZRCCAP_NO_HSCH_ATTEND

• NO_HSCH_ATTEND

No high School attended: 1 or null

SZRCCAP_CITY_HSCH

CITY_HSCH

SZRCCAP_STAT_CODE_HSCH

STAT_CODE_HSCH

State code (see Appendix)

SZRCCAP_NATN_CODE_HSCH

NATN_CODE_HSCH

2 letter nation code. See STVNATN table in Banner

SZRCCAP_SBGI_CODE_HSCH

SBGI_CODE_HSCH

Source Background Institution Code for High School. See STVSBGI table in Banner.

SZRCCAP_CEEB_CODE_HSCH

• CEEB_CODE_HSCH

College Entrance Examination Board code

SZRCCAP_NAME_COLL_1

NAME_COLL_1

Name of previous college attended

SZRCCAP_CITY_COLL_1

• CITY_COLL_1

SZRCCAP_STAT_CODE_COLL_1

• STAT_CODE_COLL_1

State code (see Appendix)

SZRCCAP_NATN_CODE_COLL_1

• NATN_CODE_COLL_1

2 letter nation code. See STVNATN table in Banner

SZRCCAP_SBGI_CODE_COLL_1

SBGI_CODE_COLL_1

Source Background Institution Code for High School. See STVSBGI table in Banner.

SZRCCAP_CEEB_CODE_COLL_1

• CEEB_CODE_COLL_1

College Entrance Examination Board code (not in use)

SZRCCAP_FROM_DATE_COLL_1

• FROM_DATE_COLL_1

SZRCCAP_TO_DATE_COLL_1

• TO_DATE_COLL_1

SZRCCAP_NAME_COLL_2

NAME_COLL_2

SZRCCAP_CITY_COLL_2

• CITY_COLL_2

SZRCCAP_STAT_CODE_COLL_2

• STAT_CODE_COLL_2

State code (see Appendix)

SZRCCAP_NATN_CODE_COLL_2

• NATN_CODE_COLL_2

2 letter nation code. See STVNATN table in Banner

SZRCCAP_SBGI_CODE_COLL_2

SBGI_CODE_COLL_2

Source Background Institution Code for High School. See STVSBGI table in Banner.

SZRCCAP_CEEB_CODE_COLL_2

• CEEB_CODE_COLL_2

College Entrance Examination Board code

SZRCCAP_FROM_DATE_COLL_2

• FROM_DATE_COLL_2

SZRCCAP_TO_DATE_COLL_2

• TO_DATE_COLL_2

SZRCCAP_NAME_COLL_3

NAME_COLL_3

SZRCCAP_CITY_COLL_3

• CITY_COLL_3

SZRCCAP_STAT_CODE_COLL_3

*STAT_CODE_COLL_3

State code (see Appendix)

SZRCCAP_NATN_CODE_COLL_3

• NATN_CODE_COLL_3

2 letter nation code. See STVNATN table in Banner

SZRCCAP_SBGI_CODE_COLL_3

SBGI_CODE_COLL_3

Source Background Institution Code for High School. See STVSBGI table in Banner.

SZRCCAP_CEEB_CODE_COLL_3

• CEEB_CODE_COLL_3

College Entrance Examination Board code (not in use)

SZRCCAP_FROM_DATE_COLL_3

• FROM_DATE_COLL_3

SZRCCAP_TO_DATE_COLL_3

• TO_DATE_COLL_3

SZRCCAP_NAME_COLL_4

NAME_COLL_4

SZRCCAP_CITY_COLL_4

• CITY_COLL_4

SZRCCAP_STAT_CODE_COLL_4

• STAT_CODE_COLL_4

State code (see Appendix)

SZRCCAP_NATN_CODE_COLL_4

• NATN_CODE_COLL_4

2 letter nation code. See STVNATN table in Banner

SZRCCAP_SBGI_CODE_COLL_4

SBGI_CODE_COLL_4

Source Background Institution Code for High School. See STVSBGI table in Banner.

SZRCCAP_CEEB_CODE_COLL_4

• CEEB_CODE_COLL_4

College Entrance Examination Board code

SZRCCAP_FROM_DATE_COLL_4

• FROM_DATE_COLL_4

SZRCCAP_TO_DATE_COLL_4

• TO_DATE_COLL_4

SZRCCAP_MORE_COLL_IND

• MORE_COLL_IND

Attended more than 4 other colleges: 1 or null

SZRCCAP_INELIG_IND

• INELIG_IND

? 0, 1, 2 or null

SZRCCAP_CITZ_CODE

CITZ_CODE

See Citizen Code in Appendix

SZRCCAP_VISA_NUMBER

VISA_NUMBER

SZRCCAP_VTYP_CODE_SOURCE

• VTYP_CODE_SOURCE

VISA type code as entered

SZRCCAP_VTYP_CODE_CURRENT

VTYP_CODE_CURRENT

see VISA type code in Appendix

SZRCCAP_VISA_ISSUE_DATE

• VISA_ISSUE_DATE

SZRCCAP_VISA_EXPIRE_DATE

• VISA_EXPIRE_DATE

SZRCCAP_VISA_NO_EXP_DATE

• VISA_NO_EXP_DATE

1 or null

SZRCCAP_MILI_STATUS

• MILI_STATUS

Military Status: 1, 2, 3, 4, 5, null

SZRCCAP_MILI_HOME_RECORD

• MILI_HOME_RECORD

SZRCCAP_MILI_HOME_NATN

• MILI_HOME_NATN

SZRCCAP_MILI_IN_CA

• MILI_IN_CA

SZRCCAP_MILI_IN_CA_ED

• MILI_IN_CA_ED

SZRCCAP_OVER_19_OR_MARR

• OVER_19_OR_MARR

Age 19 or married: 0, 1, null

SZRCCAP_CA_RES_2_YEARS

• CA_RES_2_YEARS

California resident for 2 or more years: 0, 1, null

SZRCCAP_CA_RES_DATE

• CA_RES_DATE

SZRCCAP_NOT_CA_RES

• NOT_CA_RES

1 or null

SZRCCAP_INTEND_PR_CA_RES

• INTEND_PR_CA_RES

0, 1, null

SZRCCAP_CCC_EMP_DEPEND

• CCC_EMP_DEPEND

Dependent of California Community College employee: 0, 1, null

SZRCCAP_PUB_SCH_CRED_EMP

• PUB_SCH_CRED_EMP

Public School Credential Employee: 0, 1, null

SZRCCAP_SEAS_AGR_EMP_DEP

• SEAS_AGR_EMP_DEP

Seasonal Agricultural Employee Dependent: 0, 1, null

SZRCCAP_CA_NONRES_TAX

• CA_NONRES_TAX

0, 1, null

SZRCCAP_REG_VOTE_NON_CA

• REG_VOTE_NON_CA

0, 1, null

SZRCCAP_RES_STD_NON_CA

• RES_STD_NON_CA

0, 1, null

SZRCCAP_LAWSUIT_NON_CA

• LAWSUIT_NON_CA

0, 1, null

SZRCCAP_RESD_CODE_SOURCE

• RESD_CODE_SOURCE

Residency code as entered

SZRCCAP_RESD_CODE

RESD_CODE

See Residency code in Appendix

SZRCCAP_RESD_STAT_CHANGE

• RESD_STAT_CHANGE

Residency Status Change: Null

SZRCCAP_PREV_RESD_DATE

• PREV_RESD_DATE

Previous Residency Date: Null

SZRCCAP_LANG_CODE_SOURCE

• LANG_CODE_SOURCE

Language code as entered

SZRCCAP_LANG_CODE

• LANG_CODE

Language code:

E: English

N: NOT English

X:Unknown

SZRCCAP_FIN_AID_INFO

• FIN_AID_INFO

Null, 1

SZRCCAP_TANF_SSI_GENASST

• TANF_SSI_GENASST

Welfare flag: Null, 1

SZRCCAP_INT_ACAD_COUNS

• INT_ACAD_COUNS

Interested in academic counseling: Null, 1

SZRCCAP_INT_ATHLETICS

• INT_ATHLETICS

Null, 1

SZRCCAP_INT_BASIC_SKILLS

• INT_BASIC_SKILLS

Null, 1

SZRCCAP_INT_CALWORKS

• INT_CALWORKS

Null, 1

SZRCCAP_INT_CAREER_PLNG

• INT_CAREER_PLNG

Null, 1

SZRCCAP_INT_CHILD_CARE

• INT_CHILD_CARE

Null, 1

SZRCCAP_INT_COUNS_PERS

• INT_COUNS_PERS

Null, 1

SZRCCAP_INT_DSPS

• INT_DSPS

Disable Student Services: Null, 1

SZRCCAP_INT_EOPS

• INT_EOPS

Null, 1

SZRCCAP_INT_ESL

• INT_ESL

Null, 1

SZRCCAP_INT_HEALTH_SVCS

• INT_HEALTH_SVCS

Null, 1

SZRCCAP_INT_HOUSING

• INT_HOUSING

Null, 1

SZRCCAP_INT_JOB_PLCMNT

• INT_JOB_PLCMNT

Null, 1

SZRCCAP_INT_ONLINE_CLS

• INT_ONLINE_CLS

Null, 1

SZRCCAP_INT_RE_ENTRY

• INT_RE_ENTRY

Null, 1

SZRCCAP_INT_SCHOLARSHIPS

• INT_SCHOLARSHIPS

Null, 1

SZRCCAP_INT_STUDENT_GOVT

• INT_STUDENT_GOVT

Null, 1

SZRCCAP_INT_TESTING

• INT_TESTING

Null, 1

SZRCCAP_INT_TRANSFER

• INT_TRANSFER

Null, 1

SZRCCAP_INT_TUTORING

• INT_TUTORING

Null, 1

SZRCCAP_INT_VET_SVCS

• INT_VET_SVCS

Veteran Services: Null, 1

SZRCCAP_FIN_AID_REFER

• FIN_AID_REFER

Financial aid referral: Null, 1

SZRCCAP_CONSENT_IND

• CONSENT_IND

Null, 0 ,1

SZRCCAP_CITZ_RESD_OVER

• CITZ_RESD_OVER

Citizen Residence Override (processing flag): Null, Y, N

SZRCCAP_MORE_DATA_IND

• MORE_DATA_IND

More data indicator: N, Y, null

SZRCCAP_MORE_EMAIL_SENT

• MORE_EMAIL_SENT

Y, null

SZRCCAP_PROC_EMAIL_SENT

• PROC_EMAIL_SENT

Old flag: not used

SZRCCAP_REVIEW_IND

• REVIEW_IND

N, Y

SZRCCAP_ERR_SPRIDEN

• ERR_SPRIDEN

Errors / Statuses in processing. Codes come from GTVSDAX.

SZRCCAP_ERR_SPBPERS

• ERR_SPBPERS

SZRCCAP_ERR_SPRADDR_MA

• ERR_SPRADDR_MA

SZRCCAP_ERR_SPRADDR_PR

• ERR_SPRADDR_PR

SZRCCAP_ERR_SPRTELE

• ERR_SPRTELE

SZRCCAP_ERR_SPRINTL

• ERR_SPRINTL

SZRCCAP_ERR_SORFOLK

• ERR_SORFOLK

SZRCCAP_ERR_SARADAP

• ERR_SARADAP

SZRCCAP_ERR_SGBSTDN

• ERR_SGBSTDN

SZRCCAP_ERR_SORHSCH

• ERR_SORHSCH

SZRCCAP_ERR_SORPCOL_1

• ERR_SORPCOL_1

SZRCCAP_ERR_SORPCOL_2

• ERR_SORPCOL_2

SZRCCAP_ERR_SORPCOL_3

• ERR_SORPCOL_3

SZRCCAP_ERR_SORPCOL_4

• ERR_SORPCOL_4

SZRCCAP_ERR_GOREMAL

• ERR_GOREMAL

SZRCCAP_ERR_GOBTPAC

• ERR_GOBTPAC

SZRCCAP_DISPLACED_HOM

• DISPLACED_HOM

Null, 1

SZRCCAP_CALWORKS

• CALWORKS

Null, 1

SZRCCAP_SSI

• SSI

Null, 1

SZRCCAP_GEN_ASSIST

• GEN_ASSIST

Null, 1

SZRCCAP_SINGLE_PARENT

• SINGLE_PARENT

Null, 1

SZRCCAP_WORK_AREA_CODE

WORK_AREA_CODE

SZRCCAP_WORK_PHONE

WORK_PHONE

SZRCCAP_WORK_EXT

• WORK_EXT

SZRCCAP_FOREST_SER

• FOREST_SER

Null, 0, 1

SZRCCAP_LIVE_FOREST

• LIVE_FOREST

Null, 0, 1

SZRCCAP_FULL_TIME

• FULL_TIME

Attending Full-time: Null, 0, 1

SZRCCAP_GRAD_CA_HS

• GRAD_CA_HS

Null, 0, 1

SZRCCAP_ATTEND_CA_HS

• ATTEND_CA_HS

Null, 0, 1

SZRCCAP_HS_GRAD_DATE

• HS_GRAD_DATE

SZRCCAP_AB540_ELIG

• AB540_ELIG

Null, 0, 1

SZRCCAP_MARITAL_STAT

• MARITAL_STAT

I:

M: married

U: unmarried

X:

Null

SZRCCAP_ORA_ERR_NUM

• ORA_ERR_NUM

Oracle error

SZRCCAP_ORA_ERR_MESG

• ORA_ERR_MESG

Oracle error

SZRCCAP_ORA_ERR_LOC

• ORA_ERR_LOC

Oracle error

SZRCCAP_HS_ED_LEVEL

• HS_ED_LEVEL

SZRCCAP_HIGHER_ED_LEVEL

• HIGHER_ED_LEVEL

SZRCCAP_HIGHER_ED_DATE

• HIGHER_ED_DATE

SZRCCAP_PHONE_2_SOURCE

• PHONE_2_SOURCE

Phone number as entered

SZRCCAP_PHONE_2_AREA

• PHONE_2_AREA

SZRCCAP_PHONE_2_NUMBER

• PHONE_2_NUMBER

SZRCCAP_PHONE_2_EXT

• PHONE_2_EXT

SZRCCAP_MA_NON_US_ST

• MA_NON_US_ST

Mailing non-U.S. State

SZRCCAP_MA_INTL_CODE

• MA_INTL_CODE

SZRCCAP_PR_NON_US_ST

• PR_NON_US_ST

Primary non-U.S. State

SZRCCAP_PR_INTL_CODE

• PR_INTL_CODE

SZRCCAP_CONFIRM_NUMBER

• CONFIRM_NUMBER

Number given to applicant for applying using CCCApply

SZRCCAP_COLL_1_DEGR_TYPE

• COLL_1_DEGR_TYPE

First college degree type:A: Associates Degree (AA or AS)

B: Bachelor’s Degree or higher (this includes BA, BS, Masters, Doctorates)C: Certificate

SZRCCAP_COLL_1_DEGR_DATE

• COLL_1_DEGR_DATE

First college degree date

SZRCCAP_COLL_2_DEGR_TYPE

• COLL_2_DEGR_TYPE

SZRCCAP_COLL_2_DEGR_DATE

• COLL_2_DEGR_DATE

SZRCCAP_COLL_3_DEGR_TYPE

• COLL_3_DEGR_TYPE

SZRCCAP_COLL_3_DEGR_DATE

• COLL_3_DEGR_DATE

SZRCCAP_COLL_4_DEGR_TYPE

• COLL_4_DEGR_TYPE

SZRCCAP_COLL_4_DEGR_DATE

• COLL_4_DEGR_DATE

SZRCCAP_ENROLL_STATUS

• ENROLL_STATUS

SZRCCAP_INTEGRITY_FLAGS

• INTEGRITY_FLAGS

Processing flags that CCCApply uses

PAPERAPP_FLAG

True if this is a paper application, null for a CCCApply application

substr(baninst1.cos_fv_get_apdc_code(szrccap.SZRCCAP_PIDM, szrccap.SZRCCAP_TERM_CODE),1,2)

APDC_CODE

Application Decision Code:

AA: Applicant Acceptance

AR: Application Rejected

NM: Non-matriculated

QE: Quick Entry

DECODE(szrccap_pidm, 99999999, '', SUBSTR ( f_get_desc_fnc ('STVETCT', (SUBSTR(

f_get_ethn_category(REPORTSNET.f_get_ethnicity(SZRCCAP_PIDM), 'ETCT'), 1, 1)), 30), 1, 30) )

ETHNICITY

Ethnicity description (old)

40 character description of SPBPERS_ETHN_CODE coming from STVETCT_DESC

SUBSTR(REPORTSNET.f_get_new_ethnicity_desc(

SZRCCAP_PIDM),1, 20)

References SPBPERS_ETHN_CDE

NEW_ETHNICITY

Ethnicity description using new values established in 2009. ‘Hispanic or Latino’, ‘Not Hispanic or Latino’, or ‘None’

SUBSTR(f_get_races (SZRCCAP_PIDM), 1, 60)

F_get_races takes in the PIDM and searches both GORPRAC and GORRACE and returns the race codes inside of those tables for the PIDM.

RACES

20 possible race codes, each separated by a pipe (|). Each code is up to 2 characters in length, with a period (.) being used as the 2^nd character when the code has only one character (like W. for White)

SUBSTR (f_get_races_desc (spriden_pidm), 1, 1200)

f_get_races_desc takes in the PIDM returns the race description found in GORPRAC and GORRACE

RACES_DESC

Descriptions of the codes in the RACES field. Again, separated by a pipe.

SUBSTR (REPORTSNET.f_get_Garner_RaceEthnCode (SZRCCAP_PIDM), 1, 15)

(computed in the data warehouse)

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 null

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'

CALC_RACE_ETHN

An ethnicity derived from Ethnicity, New Ethnicity, Visa Type, and Race information of the student. This is a calculation provided by Tim Garner and Ryan Barry-Souza of the Research department.

Corresponding code that was calculated for CALC_RACE_ETHN_CDE.

Existing values:

NULL

2

A

B

H

N

P

W

X

CALC_RACE_ETHN_CDE

The Result of the above logic. The first letter of the result.