Versions Compared

Version Old Version 2 New Version Current
Changes made by

Jordan Lamb

Jordan Lamb

Saved on

Key

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

Each record holds the data entered on a student application. Some data is “looked-up” by the Banner system when the application is processed and placed in this table. If the term code in the source table (SZRCCAP) SZRCCAP_TERM_CODE is a combined Summer and Fall application (term ends in 00), an application record is created in the Data Warehouse table for the summer and fall terms (with the appropriate terms of 30 and 10)Summer and Fall terms.

This table holds records for applications entered via CCCApply as well as by paper (and manually entered into Banner). The paper application does not have as many questions/fields as the CCCApply application, so some fields in this table will not be populated for a paper application. Also, some paper application questions are not entered into Banner (such as Military MILI_%, CA residence for 2 years) – fields not populated for a paper application are denoted with a * in the DW Field column._RES_2_YEARS).

Info

CCCApply has their https://cccnext.jira.com/wiki/spaces/PD/pages/67043586/Data+Dictionaries that describes valid codes for their system.

Oracle source: REPORTSNET.Applicant_CCCApply view (from Banner’s SZRCCAP table)

...

Updated: nightly (All terms >= 200800 loaded into temp table; all <> 200800 loaded into Applicant; left-overs loaded into Applicant with term of 200730 and again with term 200810)

DW Field

Oracle Field/

Calc

Calculation

DW Field

Description

or

(Sample)

TERM

SZRCCAP_TERM_CODE

TERM

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

Insert excerpt
BF:Common Definitions
BF:Common Definitions
nameTERM
nopaneltrue

SEQNO

SZRCCAP_SEQNO

SEQNO

SZRCCAP_ID

STUDENTID

Banner Id (@12345678)

SZRCCAP_CAMP_CODE

CAMPUS_CODE

see Campus Code in Appendix

SZRCCAP_

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

PIDM

SZRCCAP_PIDM

PIDM

Up to 10-digit unique Banner id for student

Insert excerpt
BF:Common Definitions
BF:Common Definitions
namePIDM
nopaneltrue

STUDENTID

SZRCCAP_ID

Insert excerpt
BF:Common Definitions
BF:Common Definitions
nameSTUDENTID
nopaneltrue

CAMPUS_CODE

SZRCCAP_CAMP_CODE

FIRST_PASS_IND

SZRCCAP_FIRST_PASS_IND

Processing flag

SZRCCAP_

DUPE_OK

SZRCCAP_DUPE_OK

Processing flag

SZRCCAP_

CCCAPPLY_LOADED

SZRCCAP_CCCAPPLY_LOADED

When record was downloaded from CCCApply

SZRCCAP_

BANNER_UPDATED

SZRCCAP_BANNER_UPDATED

When processing completed

SZRCCAP_

MAJR_CODE_1

SZRCCAP_MAJR_CODE_1

Major code from SZRCCAP_

Saturn.STVMAJR.STVMAJR_CODE

197 majors

SZRCCAP_LAST_NAME

LASTNAME

SZRCCAP_

Unique code for MAJOR

EGOL_CODE

SZRCCAP_EGOL_CODE

See Educational Goal in Appendix

Insert excerpt
BF:Common Definitions
BF:Common Definitions
nameEDUCATIONAL_GOAL
nopaneltrue

LASTNAME

SZRCCAP_LAST_NAME

Insert excerpt
BF:Common Definitions
BF:Common Definitions
nameLASTNAME
nopaneltrue

NAME_SUFFIX

SZRCCAP_NAME_SUFFIX

FIRSTNAME

SZRCCAP_FIRST_NAME

FIRSTNAME

SZRCCAP_

Insert excerpt
BF:Common Definitions
BF:Common Definitions
nameLASTNAME
nopaneltrue

NO_FIRST_IND

SZRCCAP_NO_FIRST_IND

Indicator of no first name: 1 or

null

SZRCCAP_MI

MIDINIT

SZRCCAP_

null

MIDINIT

SZRCCAP_MI

Insert excerpt
BF:Common Definitions
BF:Common Definitions
nameMIDINIT
nopaneltrue

OTHER_LAST_NAME

SZRCCAP_OTHER_LAST_NAME

SZRCCAP_

OTHER_FIRST_NAME

SZRCCAP_OTHER_FIRST_NAME

SZRCCAP_

SSN_SOURCE

SZRCCAP_SSN_SOURCE

SSN as entered

SSN

SZRCCAP_SSN

Insert excerpt

SSN

SZRCCAP_

BF:Common Definitions
BF:Common Definitions
nameSSN
nopaneltrue

NO_SSN_IND

SZRCCAP_NO_SSN_IND

Indicator of no SSN: 1 or null

Applicant has no social security number or taxpayer identification number or declines to provide it at time of application.

BIRTHDATE

SZRCCAP_BIRTH_DATE

BIRTHDATE

SZRCCAP_

Insert excerpt
BF:Common Definitions
BF:Common Definitions
namebirthdate
nopaneltrue

SEX_SOURCE

SZRCCAP_SEX_SOURCE

Sex as entered

SEX

SZRCCAP_SEX

SEX

SZRCCAP_

ETHN_CODE_SOURCE

SZRCCAP_ETHN_CODE_SOURCE

Ethnicity code as entered (no longer used)

SZRCCAP_

ETHN_CODE

SZRCCAP_ETHN_CODE

See Ethnicity code in Appendix (no longer used)

SZRCCAP_

STREET_LINE1_MA

SZRCCAP_STREET_LINE1_MA

Mailing address (all MA fields)

SZRCCAP_

CITY_MA

SZRCCAP_CITY_MA

SZRCCAP_

STAT_CODE_MA

SZRCCAP_STAT_CODE_MA

State code (see Appendix)

SZRCCAP_

ZIP_MA

SZRCCAP_ZIP_MA

SZRCCAP_

NATN_CODE_MA

SZRCCAP_NATN_CODE_MA

2 letter nation code. See STVNATN table in Banner

SZRCCAP_

INTL_CODE_MA

SZRCCAP_INTL_CODE_MA

Not in use

SZRCCAP_PARENT_LAST

PARENT_LAST

SZRCCAP_PARENT_

FIRST

LAST

PARENT_FIRST

SZRCCAP_PARENT_FIRST

RELT_CODE

SZRCCAP_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

SZRCCAP_PR_SAME_AS_MA

Primary address same as Mailing address

SZRCCAP_

STREET_LINE1_PR

SZRCCAP_STREET_LINE1_PR

Primary address info (all PR fields)

SZRCCAP_

CITY_PR

SZRCCAP_CITY_PR

SZRCCAP_

STAT_CODE_PR

SZRCCAP_STAT_CODE_PR

State code (see Appendix)

SZRCCAP_

ZIP_PR

SZRCCAP_ZIP_PR

SZRCCAP_

NATN_CODE_PR

SZRCCAP_NATN_CODE_PR

2 letter nation code. See STVNATN table in Banner

SZRCCAP_

INTL_CODE_PR

SZRCCAP_INTL_CODE_PR

Not in use

SZRCCAP_

PHONE_SOURCE

SZRCCAP_PHONE_SOURCE

Phone as entered

PHONE_AREA

SZRCCAP_PHONE_AREA

PHONE_

AREA

NUMBER

SZRCCAP_PHONE_NUMBER

PHONE_

NUMBER

EXT

SZRCCAP_PHONE_EXT

PHONE

EMAIL_

EXT

ADDRESS

SZRCCAP

_EMAIL

_

ADDRESS

EMAIL_ADDRESS

SZRCCAP_

STYP_CODE_SOURCE

SZRCCAP_STYP_CODE_SOURCE

Student Type Code as entered.

SZRCCAP_

STYP_CODE

SZRCCAP_STYP_CODE

See Student Type Code in Appendix.

SZRCCAP_

EDLV_CODE_SOURCE

SZRCCAP_EDLV_CODE_SOURCE

Educational Level as entered

SZRCCAP_

EDLV_YEAR

SZRCCAP_EDLV_YEAR

Year Educational Level achieved

SZRCCAP_

EDLV_CODE

SZRCCAP_EDLV_CODE

See Educational Level in Appendix

SZRCCAP_

NAME_HSCH

SZRCCAP_NAME_HSCH

Name of High School

SZRCCAP_

NO_HSCH_ATTEND

SZRCCAP_NO_HSCH_ATTEND

No high School attended: 1 or null

SZRCCAP_

CITY_HSCH

SZRCCAP_CITY_HSCH

SZRCCAP_

STAT_CODE_HSCH

SZRCCAP_STAT_CODE_HSCH

State code (see Appendix)

SZRCCAP_

NATN_CODE_HSCH

SZRCCAP_NATN_CODE_HSCH

2 letter nation code. See STVNATN table in Banner

SZRCCAP_

SBGI_CODE_HSCH

SZRCCAP_SBGI_CODE_HSCH

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

SZRCCAP_

CEEB_CODE_HSCH

SZRCCAP_CEEB_CODE_HSCH

College Entrance Examination Board code

SZRCCAP_

NAME_COLL_1

SZRCCAP_NAME_COLL_1

Name of previous college attended

SZRCCAP_

CITY_COLL_1

SZRCCAP_CITY_COLL_1

SZRCCAP_

STAT_CODE_COLL_1

SZRCCAP_STAT_CODE_COLL_1

State code (see Appendix)

SZRCCAP_

NATN_CODE_COLL_1

SZRCCAP_NATN_CODE_COLL_1

2 letter nation code. See STVNATN table in Banner

SZRCCAP_

SBGI_CODE_COLL_1

SZRCCAP_SBGI_CODE_COLL_1

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

SZRCCAP_

CEEB_CODE_COLL_1

SZRCCAP_CEEB_CODE_COLL_1

College Entrance Examination Board code (not in use)

SZRCCAP_

FROM_DATE_COLL_1

SZRCCAP_FROM_DATE_COLL_1

SZRCCAP_

TO_DATE_COLL_1

SZRCCAP_TO_DATE_COLL_1

SZRCCAP_

NAME_COLL_2

SZRCCAP_NAME_COLL_2

SZRCCAP_

CITY_COLL_2

SZRCCAP_CITY_COLL_2

SZRCCAP_

STAT_CODE_COLL_2

SZRCCAP_STAT_CODE_COLL_2

State code (see Appendix)

SZRCCAP_

NATN_CODE_COLL_2

SZRCCAP_NATN_CODE_COLL_2

2 letter nation code. See STVNATN table in Banner

SZRCCAP_

SBGI_CODE_COLL_2

SZRCCAP_SBGI_CODE_COLL_2

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

SZRCCAP_

CEEB_CODE_COLL_2

SZRCCAP_CEEB_CODE_COLL_2

College Entrance Examination Board code

SZRCCAP_

FROM_DATE_COLL_2

SZRCCAP_FROM_DATE_COLL_2

SZRCCAP_

TO_DATE_COLL_2

SZRCCAP_TO_DATE_COLL_2

SZRCCAP_

NAME_COLL_3

SZRCCAP_NAME_COLL_3

SZRCCAP_

CITY_COLL_3

SZRCCAP_CITY_COLL_3

SZRCCAP_

STAT_CODE_COLL_3

*
Note

Not populated for a paper application.

SZRCCAP_STAT_CODE_COLL_3

State code (see Appendix)

SZRCCAP_

NATN_CODE_COLL_3

SZRCCAP_NATN_CODE_COLL_3

2 letter nation code. See STVNATN table in Banner

SZRCCAP_

SBGI_CODE_COLL_3

SZRCCAP_SBGI_CODE_COLL_3

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

SZRCCAP_

CEEB_CODE_COLL_3

SZRCCAP_CEEB_CODE_COLL_3

College Entrance Examination Board code (not in use)

SZRCCAP_

FROM_DATE_COLL_3

SZRCCAP_FROM_DATE_COLL_3

SZRCCAP_

TO_DATE_COLL_3

SZRCCAP_TO_DATE_COLL_3

SZRCCAP_

NAME_COLL_4

SZRCCAP_NAME_COLL_4

SZRCCAP_

CITY_COLL_4

SZRCCAP_CITY_COLL_4

SZRCCAP_

STAT_CODE_COLL_4

SZRCCAP_STAT_CODE_COLL_4

State code (see Appendix)

SZRCCAP_

NATN_CODE_COLL_4

SZRCCAP_NATN_CODE_COLL_4

2 letter nation code. See STVNATN table in Banner

SZRCCAP_

SBGI_CODE_COLL_4

SZRCCAP_SBGI_CODE_COLL_4

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

SZRCCAP_

CEEB_CODE_COLL_4

SZRCCAP_CEEB_CODE_COLL_4

College Entrance Examination Board code

SZRCCAP_

FROM_DATE_COLL_4

SZRCCAP_FROM_DATE_COLL_4

SZRCCAP_

TO_DATE_COLL_4

SZRCCAP_TO_DATE_COLL_4

SZRCCAP_

MORE_COLL_IND

SZRCCAP_MORE_COLL_IND

Attended more than 4 other colleges: 1 or null

SZRCCAP_

INELIG_IND

SZRCCAP_INELIG_IND

? 0, 1, 2 or null

SZRCCAP_

CITZ_CODE

SZRCCAP_CITZ_CODE

See Citizen Code in Appendix

SZRCCAP_

VISA_NUMBER

SZRCCAP_VISA_NUMBER

SZRCCAP_

VTYP_CODE_SOURCE

SZRCCAP_VTYP_CODE_SOURCE

VISA type code as entered

SZRCCAP_

VTYP_CODE_CURRENT

SZRCCAP_VTYP_CODE_CURRENT

see VISA type code in Appendix

SZRCCAP_

VISA_ISSUE_DATE

SZRCCAP_VISA_ISSUE_DATE

SZRCCAP_

VISA_EXPIRE_DATE

SZRCCAP_VISA_EXPIRE_DATE

SZRCCAP_

VISA_NO_EXP_DATE

SZRCCAP_VISA_NO_EXP_DATE

1 or null

SZRCCAP_MILI_STATUS

MILI_STATUS

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

SZRCCAP_

MILI_STATUS

SZRCCAP_MILI_STATUS

Refer to COS_GEN.STVMILI_STATUS

Jira Legacy
serverSystem JIRA
serverId8b861ae3-ff87-316b-a17e-97c61a7e2fb4
keyAP-186

MILI_HOME_RECORD

SZRCCAP_MILI_HOME_RECORD

SZRCCAP_

MILI_HOME_NATN

SZRCCAP_MILI_HOME_NATN

SZRCCAP_

MILI_IN_CA

SZRCCAP_MILI_IN_CA

SZRCCAP_

MILI_IN_CA_ED

SZRCCAP_MILI_IN_CA_ED

SZRCCAP_

OVER_19_OR_MARR

SZRCCAP_OVER_19_OR_MARR

Age 19 or married: 0, 1, null

SZRCCAP_

CA_RES_2_YEARS

SZRCCAP_CA_RES_2_YEARS

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

SZRCCAP_

CA_RES_DATE

SZRCCAP_CA_RES_DATE

SZRCCAP_

NOT_CA_RES

SZRCCAP_NOT_CA_RES

1 or null

SZRCCAP_

INTEND_PR_CA_RES

SZRCCAP_INTEND_PR_CA_RES

0, 1, null

SZRCCAP_

CCC_EMP_DEPEND

SZRCCAP_CCC_EMP_DEPEND

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

SZRCCAP_

PUB_SCH_CRED_EMP

SZRCCAP_PUB_SCH_CRED_EMP

Public School Credential Employee: 0, 1, null

SZRCCAP_

SEAS_AGR_EMP_DEP

SZRCCAP_SEAS_AGR_EMP_DEP

Seasonal Agricultural Employee Dependent: 0, 1, null

SZRCCAP_

CA_NONRES_TAX

SZRCCAP_CA_NONRES_TAX

0, 1, null

SZRCCAP_

REG_VOTE_NON_CA

SZRCCAP_REG_VOTE_NON_CA

0, 1, null

SZRCCAP_

RES_STD_NON_CA

SZRCCAP_RES_STD_NON_CA

0, 1, null

SZRCCAP_

LAWSUIT_NON_CA

SZRCCAP_LAWSUIT_NON_CA

0, 1, null

SZRCCAP_

RESD_CODE_SOURCE

SZRCCAP_RESD_CODE_SOURCE

Residency code as entered

SZRCCAP_

RESD_CODE

SZRCCAP_RESD_CODE

See Residency code in Appendix

SZRCCAP_

RESD_STAT_CHANGE

SZRCCAP_RESD_STAT_CHANGE

Residency Status Change: Null

SZRCCAP_

PREV_RESD_DATE

SZRCCAP_PREV_RESD_DATE

Previous Residency Date: Null

SZRCCAP_

LANG_CODE_SOURCE

SZRCCAP_LANG_CODE_SOURCE

Language code as entered

SZRCCAP_

LANG_CODE

SZRCCAP_LANG_CODE

Language code:

E: English

N: NOT English

X: Unknown

SZRCCAP_

FIN_AID_INFO

SZRCCAP_FIN_AID_INFO

Null, 1

SZRCCAP_

TANF_SSI_GENASST

SZRCCAP_TANF_SSI_GENASST

Welfare flag: Null, 1

SZRCCAP_

INT_ACAD_COUNS

SZRCCAP_INT_ACAD_COUNS

Interested in academic counseling: Null, 1

SZRCCAP_

INT_ATHLETICS

SZRCCAP_INT_ATHLETICS

Null, 1

SZRCCAP_

INT_BASIC_SKILLS

SZRCCAP_INT_BASIC_SKILLS

Null, 1

SZRCCAP_

INT_CALWORKS

SZRCCAP_INT_CALWORKS

Null, 1

SZRCCAP_

INT_CAREER_PLNG

SZRCCAP_INT_CAREER_PLNG

Null, 1

SZRCCAP_

INT_CHILD_CARE

SZRCCAP_INT_CHILD_CARE

Null, 1

SZRCCAP_

INT_COUNS_PERS

SZRCCAP_INT_COUNS_PERS

Null, 1

SZRCCAP_

INT_DSPS

SZRCCAP_INT_DSPS

Disable Student Services: Null, 1

SZRCCAP_

INT_EOPS

SZRCCAP_INT_EOPS

Null, 1

SZRCCAP_

INT_ESL

SZRCCAP_INT_ESL

Null, 1

SZRCCAP_

INT_HEALTH_SVCS

SZRCCAP_INT_HEALTH_SVCS

Null, 1

SZRCCAP_

INT_HOUSING

SZRCCAP_INT_HOUSING

Null, 1

SZRCCAP_

INT_JOB_PLCMNT

SZRCCAP_INT_JOB_PLCMNT

Null, 1

SZRCCAP_

INT_ONLINE_CLS

SZRCCAP_INT_ONLINE_CLS

Null, 1

SZRCCAP_

INT_RE_ENTRY

SZRCCAP_INT_RE_ENTRY

Null, 1

SZRCCAP_

INT_SCHOLARSHIPS

SZRCCAP_INT_SCHOLARSHIPS

Null, 1

SZRCCAP_

INT_STUDENT_GOVT

SZRCCAP_INT_STUDENT_GOVT

Null, 1

SZRCCAP_

INT_TESTING

SZRCCAP_INT_TESTING

Null, 1

SZRCCAP_

INT_TRANSFER

SZRCCAP_INT_TRANSFER

Null, 1

SZRCCAP_

INT_TUTORING

SZRCCAP_INT_TUTORING

Null, 1

SZRCCAP_

INT_VET_SVCS

SZRCCAP_INT_VET_SVCS

Veteran Services: Null, 1

SZRCCAP_

FIN_AID_REFER

SZRCCAP_FIN_AID_REFER

Financial aid referral: Null, 1

SZRCCAP_

CONSENT_IND

SZRCCAP_CONSENT_IND

Null, 0 ,1

SZRCCAP_

CITZ_RESD_OVER

SZRCCAP_CITZ_RESD_OVER

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

SZRCCAP_

MORE_DATA_IND

SZRCCAP_MORE_DATA_IND

More data indicator: N, Y, null

SZRCCAP_

MORE_EMAIL_SENT

SZRCCAP_MORE_EMAIL_SENT

Y, null

SZRCCAP_

PROC_EMAIL_SENT

SZRCCAP_PROC_EMAIL_SENT

Old flag: not used

SZRCCAP_

REVIEW_IND

SZRCCAP_REVIEW_IND

N, Y

SZRCCAP_

ERR_SPRIDEN

SZRCCAP_ERR_SPRIDEN

Errors / Statuses in processing. Codes come from GTVSDAX.

SZRCCAP_

ERR_SPBPERS

ERR_SPBPERS

SZRCCAP_ERR_

SPRADDR_MA

SPBPERS

ERR_SPRADDR_MA

SZRCCAP_ERR_SPRADDR_

PR

MA

ERR_SPRADDR_PR

SZRCCAP_ERR_

SPRTELE

SPRADDR_PR

ERR_SPRTELE

SZRCCAP_ERR_

SPRINTL

SPRTELE

ERR_SPRINTL

SZRCCAP_ERR_

SORFOLK

SPRINTL

ERR_SORFOLK

SZRCCAP_ERR_

SARADAP

SORFOLK

ERR_SARADAP

SZRCCAP_ERR_

SGBSTDN

SARADAP

ERR_SGBSTDN

SZRCCAP_ERR_

SORHSCH

SGBSTDN

ERR_SORHSCH

SZRCCAP_ERR_

SORPCOL_1

SORHSCH

ERR_SORPCOL_1

SZRCCAP_ERR_SORPCOL_

2

1

ERR_SORPCOL_2

SZRCCAP_ERR_SORPCOL_

3

2

ERR_SORPCOL_3

SZRCCAP_ERR_SORPCOL_

4

3

ERR_SORPCOL_4

SZRCCAP_ERR_

GOREMAL

SORPCOL_4

ERR_GOREMAL

SZRCCAP_ERR_

GOBTPAC

GOREMAL

ERR_GOBTPAC

SZRCCAP_ERR_GOBTPAC

DISPLACED_HOM

SZRCCAP_DISPLACED_HOM

Null, 1

CALWORKS

SZRCCAP_CALWORKS

CALWORKS

Null, 1

SSI

SZRCCAP_SSI

SSI

Null, 1

SZRCCAP_

GEN_ASSIST

SZRCCAP_GEN_ASSIST

Null, 1

SZRCCAP_

SINGLE_PARENT

SZRCCAP_SINGLE_PARENT

Null, 1

SZRCCAP_

WORK_AREA_CODE

SZRCCAP_WORK_AREA_CODE

SZRCCAP_

WORK_PHONE

SZRCCAP_WORK_PHONE

SZRCCAP_

WORK_EXT

SZRCCAP_WORK_EXT

SZRCCAP_

FOREST_SER

SZRCCAP_FOREST_SER

Null, 0, 1

SZRCCAP_

LIVE_FOREST

SZRCCAP_LIVE_FOREST

Null, 0, 1

SZRCCAP_

FULL_TIME

SZRCCAP_FULL_TIME

Attending Full-time: Null, 0, 1

SZRCCAP_

GRAD_CA_HS

SZRCCAP_GRAD_CA_HS

Null, 0, 1

SZRCCAP_

ATTEND_CA_HS

SZRCCAP_ATTEND_CA_HS

Null, 0, 1

SZRCCAP_

HS_GRAD_DATE

SZRCCAP_HS_GRAD_DATE

SZRCCAP_

AB540_ELIG

SZRCCAP_AB540_ELIG

Null, 0, 1

SZRCCAP_

MARITAL_STAT

SZRCCAP_MARITAL_STAT

I:

M: married

U: unmarried

X:

Null

SZRCCAP_

ORA_ERR_NUM

SZRCCAP_ORA_ERR_NUM

Oracle error

SZRCCAP_

ORA_ERR_MESG

SZRCCAP_ORA_ERR_MESG

Oracle error

SZRCCAP_

ORA_ERR_LOC

SZRCCAP_ORA_ERR_LOC

Oracle error

SZRCCAP_

HS_ED_LEVEL

SZRCCAP_HS_ED_LEVEL

SZRCCAP_

HIGHER_ED_LEVEL

SZRCCAP_HIGHER_ED_LEVEL

SZRCCAP_

HIGHER_ED_DATE

SZRCCAP_HIGHER_ED_DATE

SZRCCAP_

PHONE_2_SOURCE

SZRCCAP_PHONE_2_SOURCE

Phone number as entered

SZRCCAP_

PHONE_2_AREA

SZRCCAP_PHONE_2_AREA

SZRCCAP_

PHONE_2_NUMBER

SZRCCAP_PHONE_2_NUMBER

SZRCCAP_

PHONE_2_EXT

SZRCCAP_PHONE_2_EXT

SZRCCAP_

MA_NON_US_ST

SZRCCAP_MA_NON_US_ST

Mailing non-U.S. State

SZRCCAP_

MA_INTL_CODE

SZRCCAP_MA_INTL_CODE

SZRCCAP_

PR_NON_US_ST

SZRCCAP_PR_NON_US_ST

Primary non-U.S. State

SZRCCAP_

PR_INTL_CODE

SZRCCAP_PR_INTL_CODE

SZRCCAP_

CONFIRM_NUMBER

SZRCCAP_CONFIRM_NUMBER

Number given to applicant for applying using CCCApply

SZRCCAP_

COLL_1_DEGR_TYPE

SZRCCAP_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

SZRCCAP_COLL_1_DEGR_DATE

First college degree date

SZRCCAP_

COLL_2_DEGR_TYPE

SZRCCAP_COLL_2_DEGR_TYPE

SZRCCAP_

COLL_2_DEGR_DATE

SZRCCAP_COLL_2_DEGR_DATE

SZRCCAP_

COLL_3_DEGR_TYPE

SZRCCAP_COLL_3_DEGR_TYPE

SZRCCAP_

COLL_3_DEGR_DATE

SZRCCAP_COLL_3_DEGR_DATE

SZRCCAP_

COLL_4_DEGR_TYPE

SZRCCAP_COLL_4_DEGR_TYPE

SZRCCAP_

COLL_4_DEGR_DATE

SZRCCAP_COLL_4_DEGR_DATE

SZRCCAP_

ENROLL_STATUS

SZRCCAP_ENROLL_STATUS

SZRCCAP_

INTEGRITY_FLAGS

SZRCCAP_INTEGRITY_FLAGS

Processing flags that CCCApply uses

PAPERAPP_FLAG

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

APDC_CODE

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

ETHNICITY

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

NEW_ETHNICITY

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’

RACES

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)

RACES_DESC

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.

CALC_RACE_ETHN

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.

CALC_RACE_ETHN_CDE

.

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