Versions Compared

Version Old Version 11 New Version 12
Changes made by

Jordan Lamb

Jordan Lamb

Saved on

Key

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

...

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)

CalcDW Field or

DW Field

Oracle Field/

Calculation

Description

(Sample)

TERM

SZRCCAP_TERM_CODETERM

Insert excerpt
Common Definitions
Common Definitions
nameTERM
nopaneltrue

SEQNO

SZRCCAP_SEQNOSEQNO

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

Insert excerpt
Common Definitions
Common Definitions
namePIDM
Up to 10-digit unique Banner id for student
nopaneltrue

STUDENTID

SZRCCAP_ID

SZRCCAP_CAMP_CODE
Insert excerpt
Common Definitions
Common Definitions
nameSTUDENTID

Banner ID (@12345678)

nopaneltrue

CAMPUS_CODEsee Campus Code in Appendix

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

MAJR_CODE_1

SZRCCAP_MAJR_CODE_1

MAJR_CODE_1

Major code from Saturn.STVMAJR.STVMAJR_CODE

197 majors

SZRCCAP_

Saturn.STVMAJR.STVMAJR_CODE

Unique code for

Insert excerpt
Common Definitions
Common Definitions
nameMAJOR_DESC
nopaneltrue

EGOL_CODE

SZRCCAP_EGOL_CODE

See Educational Goal in Appendix

LASTNAME

SZRCCAP_LAST_NAME

LASTNAMENAME_SUFFIX

SZRCCAP_NAME_SUFFIXNAME_SUFFIX

FIRSTNAME

SZRCCAP_FIRST_NAMEFIRSTNAME

SZRCCAP_NO_FIRST_IND

SZRCCAP_NO_FIRST_IND

Indicator of no first name: 1 or null

MIDINIT

SZRCCAP_MIMIDINIT

SZRCCAP_OTHER_LAST_NAME

SZRCCAP_OTHER_LAST_NAMESZRCCAP

_OTHER_FIRST_NAME

SZRCCAP_OTHER_FIRST_NAME

SZRCCAP_SSN_SOURCE

SZRCCAP_SSN_SOURCE

SSN as entered

SSN

SZRCCAP_SSN

SSN

SZRCCAP_NO_SSN_IND

SZRCCAP_NO_SSN_IND

Indicator of no SSN: 1 or null

BIRTHDATE

SZRCCAP_BIRTH_DATE

BIRTHDATE

SZRCCAP_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

SZRCCAP_PARENT_LASTSZRCCAP_

PARENT_FIRST

SZRCCAP_PARENT_FIRST

SZRCCAP_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_AREANUMBER

SZRCCAP_PHONE_NUMBER

PHONE_NUMBEREXT

SZRCCAP_PHONE_EXTPHONE

EMAIL_EXTADDRESS

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_1SZRCCAP

_TO_DATE_COLL_1

SZRCCAP_TO_DATE_COLL_1

SZRCCAP_NAME_COLL_2

SZRCCAP_NAME_COLL_2SZRCCAP

_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_2SZRCCAP

_TO_DATE_COLL_2

SZRCCAP_TO_DATE_COLL_2SZRCCAP_NAME_COLL_32

NAME_COLL_3

SZRCCAP_CITYNAME_COLL_3

CITY_COLL_3

SZRCCAP_STAT_CODECITY_COLL_3

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_3SZRCCAP

_TO_DATE_COLL_3

SZRCCAP_TO_DATE_COLL_3

SZRCCAP_NAME_COLL_4

SZRCCAP_NAME_COLL_4SZRCCAP

_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_4SZRCCAP

_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_DATESZRCCAP

_VISA_EXPIRE_DATE

SZRCCAP_VISA_EXPIRE_DATE

SZRCCAP_VISA_NO_EXP_DATE

SZRCCAP_VISA_NO_EXP_DATE

1 or null

SZRCCAP_MILI_STATUS

SZRCCAP_MILI_STATUS

Refer to COS_GEN.STVMILI_STATUS

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

SZRCCAP_MILI_HOME_RECORD

SZRCCAP_MILI_HOME_RECORDSZRCCAP

_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_MASPBPERS

ERR_SPRADDR_MA

SZRCCAP_ERR_SPRADDR_PRMA

ERR_SPRADDR_PR

SZRCCAP_ERR_SPRTELESPRADDR_PR

ERR_SPRTELE

SZRCCAP_ERR_SPRINTLSPRTELE

ERR_SPRINTL

SZRCCAP_ERR_SORFOLKSPRINTL

ERR_SORFOLK

SZRCCAP_ERR_SARADAPSORFOLK

ERR_SARADAP

SZRCCAP_ERR_SGBSTDNSARADAP

ERR_SGBSTDN

SZRCCAP_ERR_SORHSCHSGBSTDN

ERR_SORHSCH

SZRCCAP_ERR_SORPCOL_1SORHSCH

ERR_SORPCOL_1

SZRCCAP_ERR_SORPCOL_21

ERR_SORPCOL_2

SZRCCAP_ERR_SORPCOL_32

ERR_SORPCOL_3

SZRCCAP_ERR_SORPCOL_43

ERR_SORPCOL_4

SZRCCAP_ERR_SORPCOL_GOREMAL4

ERR_GOREMAL

SZRCCAP_ERR_GOBTPACGOREMAL

ERR_GOBTPAC

SZRCCAP_ERR_GOBTPAC

DISPLACED_HOM

SZRCCAP_DISPLACED_HOM

Null, 1

CALWORKS

SZRCCAP_CALWORKS

CALWORKS

Null, 1

SSI

SZRCCAP_SSISSI

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_PHONESZRCCAP_

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_LEVELSZRCCAP

_HIGHER_ED_LEVEL

SZRCCAP_HIGHER_ED_LEVELSZRCCAP

_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_AREASZRCCAP

_PHONE_2_NUMBER

SZRCCAP_PHONE_2_NUMBERSZRCCAP

_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_TYPESZRCCAP

_COLL_2_DEGR_DATE

SZRCCAP_COLL_2_DEGR_DATE

SZRCCAP_COLL_3_DEGR_TYPE

SZRCCAP_COLL_3_DEGR_TYPESZRCCAP

_COLL_3_DEGR_DATE

SZRCCAP_COLL_3_DEGR_DATE

SZRCCAP_COLL_4_DEGR_TYPE

SZRCCAP_COLL_4_DEGR_TYPESZRCCAP

_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_CDENEW_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
...