Versions Compared

Version Old Version 1 New Version 2
Changes made by

Jordan Lamb

Jordan Lamb

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Code Block
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

Code Block
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

Code Block
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 2nd 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.

Code Block
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.

Existing values:

NULL

2

A

B

H

N

P

W

X