Versions Compared

Version Old Version 13 New Version Current
Changes made by

Jordan Lamb

Jordan Lamb

Saved on

Key

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

...

This table holds records for applications entered via CCCApply 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)._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)

...

DW Field

Oracle Field/Calculation

Description (Sample)

TERM

SZRCCAP_TERM_CODE

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

SEQNO

SZRCCAP_SEQNO

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

DUPE_OK

SZRCCAP_DUPE_OK

Processing flag

CCCAPPLY_LOADED

SZRCCAP_CCCAPPLY_LOADED

When record was downloaded from CCCApply

BANNER_UPDATED

SZRCCAP_BANNER_UPDATED

When processing completed

MAJR_CODE_1

SZRCCAP_MAJR_CODE_1

Saturn.STVMAJR.STVMAJR_CODE

Unique code for :MAJOR

EGOL_CODE

SZRCCAP_EGOL_CODE

See Educational Goal in Appendix

Insert excerpt
BF:Common Definitions
BF:Common Definitions
nameMAJOREDUCATIONAL_DESCGOAL

EGOL_CODE

SZRCCAP_EGOL_CODE

nopaneltrue

LASTNAME

SZRCCAP_LAST_NAME

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

NAME_SUFFIX

SZRCCAP_NAME_SUFFIX

FIRSTNAME

SZRCCAP_FIRST_NAME

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

MIDINIT

SZRCCAP_MIMI

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

OTHER_LAST_NAME

SZRCCAP_OTHER_LAST_NAME

OTHER_FIRST_NAME

SZRCCAP_OTHER_FIRST_NAME

SSN_SOURCE

SZRCCAP_SSN_SOURCE

SSN as entered

SSN

SZRCCAP_SSN

Insert excerpt
BF:Common Definitions
BF:Common Definitions
nameSSN
nopaneltrue

NO_SSN_IND

SZRCCAP_NO_SSN_INDIndicator

of no SSN: 1 or nullApplicant has no social security number or taxpayer identification number or declines to provide it at time of application.

BIRTHDATE

SZRCCAP_BIRTH_DATE

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

SEX_SOURCE

SZRCCAP_SEX_SOURCESex as entered

SEX

SZRCCAP_SEX

ETHN_CODE_SOURCE

SZRCCAP_ETHN_CODE_SOURCE

Ethnicity code as entered (no longer used)

ETHN_CODE

SZRCCAP_ETHN_CODE

See Ethnicity code in Appendix (no longer used)

STREET_LINE1_MA

SZRCCAP_STREET_LINE1_MA

Mailing address (all MA fields)

CITY_MA

SZRCCAP_CITY_MA

STAT_CODE_MA

SZRCCAP_STAT_CODE_MA

State code (see Appendix)

ZIP_MA

SZRCCAP_ZIP_MA

NATN_CODE_MA

SZRCCAP_NATN_CODE_MA

2 letter nation code. See STVNATN table in Banner

INTL_CODE_MA

SZRCCAP_INTL_CODE_MA

Not in use

PARENT_LAST

SZRCCAP_PARENT_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

PR_SAME_AS_MA

SZRCCAP_PR_SAME_AS_MA

Primary address same as Mailing address

STREET_LINE1_PR

SZRCCAP_STREET_LINE1_PR

Primary address info (all PR fields)

CITY_PR

SZRCCAP_CITY_PR

STAT_CODE_PR

SZRCCAP_STAT_CODE_PR

State code (see Appendix)

ZIP_PR

SZRCCAP_ZIP_PR

NATN_CODE_PR

SZRCCAP_NATN_CODE_PR

2 letter nation code. See STVNATN table in Banner

INTL_CODE_PR

SZRCCAP_INTL_CODE_PR

Not in use

PHONE_SOURCE

SZRCCAP_PHONE_SOURCE

Phone as entered

PHONE_AREA

SZRCCAP_PHONE_AREA

PHONE_NUMBER

SZRCCAP_PHONE_NUMBER

PHONE_EXT

SZRCCAP_PHONE_EXT

EMAIL_ADDRESS

SZRCCAP_EMAIL_ADDRESS

STYP_CODE_SOURCE

SZRCCAP_STYP_CODE_SOURCE

Student Type Code as entered.

STYP_CODE

SZRCCAP_STYP_CODE

See Student Type Code in Appendix.

EDLV_CODE_SOURCE

SZRCCAP_EDLV_CODE_SOURCE

Educational Level as entered

EDLV_YEAR

SZRCCAP_EDLV_YEAR

Year Educational Level achieved

EDLV_CODE

SZRCCAP_EDLV_CODE

See Educational Level in Appendix

NAME_HSCH

SZRCCAP_NAME_HSCH

Name of High School

NO_HSCH_ATTEND

SZRCCAP_NO_HSCH_ATTEND

No high School attended: 1 or null

CITY_HSCH

SZRCCAP_CITY_HSCH

STAT_CODE_HSCH

SZRCCAP_STAT_CODE_HSCH

State code (see Appendix)

NATN_CODE_HSCH

SZRCCAP_NATN_CODE_HSCH

2 letter nation code. See STVNATN table in Banner

SBGI_CODE_HSCH

SZRCCAP_SBGI_CODE_HSCH

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

CEEB_CODE_HSCH

SZRCCAP_CEEB_CODE_HSCH

College Entrance Examination Board code

NAME_COLL_1

SZRCCAP_NAME_COLL_1

Name of previous college attended

CITY_COLL_1

SZRCCAP_CITY_COLL_1

STAT_CODE_COLL_1

SZRCCAP_STAT_CODE_COLL_1

State code (see Appendix)

NATN_CODE_COLL_1

SZRCCAP_NATN_CODE_COLL_1

2 letter nation code. See STVNATN table in Banner

SBGI_CODE_COLL_1

SZRCCAP_SBGI_CODE_COLL_1

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

CEEB_CODE_COLL_1

SZRCCAP_CEEB_CODE_COLL_1

College Entrance Examination Board code (not in use)

FROM_DATE_COLL_1

SZRCCAP_FROM_DATE_COLL_1

TO_DATE_COLL_1

SZRCCAP_TO_DATE_COLL_1

NAME_COLL_2

SZRCCAP_NAME_COLL_2

CITY_COLL_2

SZRCCAP_CITY_COLL_2

STAT_CODE_COLL_2

SZRCCAP_STAT_CODE_COLL_2

State code (see Appendix)

NATN_CODE_COLL_2

SZRCCAP_NATN_CODE_COLL_2

2 letter nation code. See STVNATN table in Banner

SBGI_CODE_COLL_2

SZRCCAP_SBGI_CODE_COLL_2

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

CEEB_CODE_COLL_2

SZRCCAP_CEEB_CODE_COLL_2

College Entrance Examination Board code

FROM_DATE_COLL_2

SZRCCAP_FROM_DATE_COLL_2

TO_DATE_COLL_2

SZRCCAP_TO_DATE_COLL_2

NAME_COLL_3

SZRCCAP_NAME_COLL_3

CITY_COLL_3

SZRCCAP_CITY_COLL_3

STAT_CODE_COLL_3

Note

Not populated for a paper application.

SZRCCAP_STAT_CODE_COLL_3

State code (see Appendix)

NATN_CODE_COLL_3

SZRCCAP_NATN_CODE_COLL_3

2 letter nation code. See STVNATN table in Banner

SBGI_CODE_COLL_3

SZRCCAP_SBGI_CODE_COLL_3

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

CEEB_CODE_COLL_3

SZRCCAP_CEEB_CODE_COLL_3

College Entrance Examination Board code (not in use)

FROM_DATE_COLL_3

SZRCCAP_FROM_DATE_COLL_3

TO_DATE_COLL_3

SZRCCAP_TO_DATE_COLL_3

NAME_COLL_4

SZRCCAP_NAME_COLL_4

CITY_COLL_4

SZRCCAP_CITY_COLL_4

STAT_CODE_COLL_4

SZRCCAP_STAT_CODE_COLL_4

State code (see Appendix)

NATN_CODE_COLL_4

SZRCCAP_NATN_CODE_COLL_4

2 letter nation code. See STVNATN table in Banner

SBGI_CODE_COLL_4

SZRCCAP_SBGI_CODE_COLL_4

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

CEEB_CODE_COLL_4

SZRCCAP_CEEB_CODE_COLL_4

College Entrance Examination Board code

FROM_DATE_COLL_4

SZRCCAP_FROM_DATE_COLL_4

TO_DATE_COLL_4

SZRCCAP_TO_DATE_COLL_4

MORE_COLL_IND

SZRCCAP_MORE_COLL_IND

Attended more than 4 other colleges: 1 or null

INELIG_IND

SZRCCAP_INELIG_IND

? 0, 1, 2 or null

CITZ_CODE

SZRCCAP_CITZ_CODE

See Citizen Code in Appendix

VISA_NUMBER

SZRCCAP_VISA_NUMBER

VTYP_CODE_SOURCE

SZRCCAP_VTYP_CODE_SOURCE

VISA type code as entered

VTYP_CODE_CURRENT

SZRCCAP_VTYP_CODE_CURRENT

see VISA type code in Appendix

VISA_ISSUE_DATE

SZRCCAP_VISA_ISSUE_DATE

VISA_EXPIRE_DATE

SZRCCAP_VISA_EXPIRE_DATE

VISA_NO_EXP_DATE

SZRCCAP_VISA_NO_EXP_DATE

1 or null

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

MILI_HOME_NATN

SZRCCAP_MILI_HOME_NATN

MILI_IN_CA

SZRCCAP_MILI_IN_CA

MILI_IN_CA_ED

SZRCCAP_MILI_IN_CA_ED

OVER_19_OR_MARR

SZRCCAP_OVER_19_OR_MARR

Age 19 or married: 0, 1, null

CA_RES_2_YEARS

SZRCCAP_CA_RES_2_YEARS

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

CA_RES_DATE

SZRCCAP_CA_RES_DATE

NOT_CA_RES

SZRCCAP_NOT_CA_RES

1 or null

INTEND_PR_CA_RES

SZRCCAP_INTEND_PR_CA_RES

0, 1, null

CCC_EMP_DEPEND

SZRCCAP_CCC_EMP_DEPEND

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

PUB_SCH_CRED_EMP

SZRCCAP_PUB_SCH_CRED_EMP

Public School Credential Employee: 0, 1, null

SEAS_AGR_EMP_DEP

SZRCCAP_SEAS_AGR_EMP_DEP

Seasonal Agricultural Employee Dependent: 0, 1, null

CA_NONRES_TAX

SZRCCAP_CA_NONRES_TAX

0, 1, null

REG_VOTE_NON_CA

SZRCCAP_REG_VOTE_NON_CA

0, 1, null

RES_STD_NON_CA

SZRCCAP_RES_STD_NON_CA

0, 1, null

LAWSUIT_NON_CA

SZRCCAP_LAWSUIT_NON_CA

0, 1, null

RESD_CODE_SOURCE

SZRCCAP_RESD_CODE_SOURCE

Residency code as entered

RESD_CODE

SZRCCAP_RESD_CODE

See Residency code in Appendix

RESD_STAT_CHANGE

SZRCCAP_RESD_STAT_CHANGE

Residency Status Change: Null

PREV_RESD_DATE

SZRCCAP_PREV_RESD_DATE

Previous Residency Date: Null

LANG_CODE_SOURCE

SZRCCAP_LANG_CODE_SOURCE

Language code as entered

LANG_CODE

SZRCCAP_LANG_CODE

Language code:

E: English

N: NOT English

X: Unknown

FIN_AID_INFO

SZRCCAP_FIN_AID_INFO

Null, 1

TANF_SSI_GENASST

SZRCCAP_TANF_SSI_GENASST

Welfare flag: Null, 1

INT_ACAD_COUNS

SZRCCAP_INT_ACAD_COUNS

Interested in academic counseling: Null, 1

INT_ATHLETICS

SZRCCAP_INT_ATHLETICS

Null, 1

INT_BASIC_SKILLS

SZRCCAP_INT_BASIC_SKILLS

Null, 1

INT_CALWORKS

SZRCCAP_INT_CALWORKS

Null, 1

INT_CAREER_PLNG

SZRCCAP_INT_CAREER_PLNG

Null, 1

INT_CHILD_CARE

SZRCCAP_INT_CHILD_CARE

Null, 1

INT_COUNS_PERS

SZRCCAP_INT_COUNS_PERS

Null, 1

INT_DSPS

SZRCCAP_INT_DSPS

Disable Student Services: Null, 1

INT_EOPS

SZRCCAP_INT_EOPS

Null, 1

INT_ESL

SZRCCAP_INT_ESL

Null, 1

INT_HEALTH_SVCS

SZRCCAP_INT_HEALTH_SVCS

Null, 1

INT_HOUSING

SZRCCAP_INT_HOUSING

Null, 1

INT_JOB_PLCMNT

SZRCCAP_INT_JOB_PLCMNT

Null, 1

INT_ONLINE_CLS

SZRCCAP_INT_ONLINE_CLS

Null, 1

INT_RE_ENTRY

SZRCCAP_INT_RE_ENTRY

Null, 1

INT_SCHOLARSHIPS

SZRCCAP_INT_SCHOLARSHIPS

Null, 1

INT_STUDENT_GOVT

SZRCCAP_INT_STUDENT_GOVT

Null, 1

INT_TESTING

SZRCCAP_INT_TESTING

Null, 1

INT_TRANSFER

SZRCCAP_INT_TRANSFER

Null, 1

INT_TUTORING

SZRCCAP_INT_TUTORING

Null, 1

INT_VET_SVCS

SZRCCAP_INT_VET_SVCS

Veteran Services: Null, 1

FIN_AID_REFER

SZRCCAP_FIN_AID_REFER

Financial aid referral: Null, 1

CONSENT_IND

SZRCCAP_CONSENT_IND

Null, 0 ,1

CITZ_RESD_OVER

SZRCCAP_CITZ_RESD_OVER

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

MORE_DATA_IND

SZRCCAP_MORE_DATA_IND

More data indicator: N, Y, null

MORE_EMAIL_SENT

SZRCCAP_MORE_EMAIL_SENT

Y, null

PROC_EMAIL_SENT

SZRCCAP_PROC_EMAIL_SENT

Old flag: not used

REVIEW_IND

SZRCCAP_REVIEW_IND

N, Y

ERR_SPRIDEN

SZRCCAP_ERR_SPRIDEN

Errors / Statuses in processing. Codes come from GTVSDAX.

ERR_SPBPERS

SZRCCAP_ERR_SPBPERS

ERR_SPRADDR_MA

SZRCCAP_ERR_SPRADDR_MA

ERR_SPRADDR_PR

SZRCCAP_ERR_SPRADDR_PR

ERR_SPRTELE

SZRCCAP_ERR_SPRTELE

ERR_SPRINTL

SZRCCAP_ERR_SPRINTL

ERR_SORFOLK

SZRCCAP_ERR_SORFOLK

ERR_SARADAP

SZRCCAP_ERR_SARADAP

ERR_SGBSTDN

SZRCCAP_ERR_SGBSTDN

ERR_SORHSCH

SZRCCAP_ERR_SORHSCH

ERR_SORPCOL_1

SZRCCAP_ERR_SORPCOL_1

ERR_SORPCOL_2

SZRCCAP_ERR_SORPCOL_2

ERR_SORPCOL_3

SZRCCAP_ERR_SORPCOL_3

ERR_SORPCOL_4

SZRCCAP_ERR_SORPCOL_4

ERR_GOREMAL

SZRCCAP_ERR_GOREMAL

ERR_GOBTPAC

SZRCCAP_ERR_GOBTPAC

DISPLACED_HOM

SZRCCAP_DISPLACED_HOM

Null, 1

CALWORKS

SZRCCAP_CALWORKS

Null, 1

SSI

SZRCCAP_SSI

Null, 1

GEN_ASSIST

SZRCCAP_GEN_ASSIST

Null, 1

SINGLE_PARENT

SZRCCAP_SINGLE_PARENT

Null, 1

WORK_AREA_CODE

SZRCCAP_WORK_AREA_CODE

WORK_PHONE

SZRCCAP_WORK_PHONE

WORK_EXT

SZRCCAP_WORK_EXT

FOREST_SER

SZRCCAP_FOREST_SER

Null, 0, 1

LIVE_FOREST

SZRCCAP_LIVE_FOREST

Null, 0, 1

FULL_TIME

SZRCCAP_FULL_TIME

Attending Full-time: Null, 0, 1

GRAD_CA_HS

SZRCCAP_GRAD_CA_HS

Null, 0, 1

ATTEND_CA_HS

SZRCCAP_ATTEND_CA_HS

Null, 0, 1

HS_GRAD_DATE

SZRCCAP_HS_GRAD_DATE

AB540_ELIG

SZRCCAP_AB540_ELIG

Null, 0, 1

MARITAL_STAT

SZRCCAP_MARITAL_STAT

I:

M: married

U: unmarried

X:

Null

ORA_ERR_NUM

SZRCCAP_ORA_ERR_NUM

Oracle error

ORA_ERR_MESG

SZRCCAP_ORA_ERR_MESG

Oracle error

ORA_ERR_LOC

SZRCCAP_ORA_ERR_LOC

Oracle error

HS_ED_LEVEL

SZRCCAP_HS_ED_LEVEL

HIGHER_ED_LEVEL

SZRCCAP_HIGHER_ED_LEVEL

HIGHER_ED_DATE

SZRCCAP_HIGHER_ED_DATE

PHONE_2_SOURCE

SZRCCAP_PHONE_2_SOURCE

Phone number as entered

PHONE_2_AREA

SZRCCAP_PHONE_2_AREA

PHONE_2_NUMBER

SZRCCAP_PHONE_2_NUMBER

PHONE_2_EXT

SZRCCAP_PHONE_2_EXT

MA_NON_US_ST

SZRCCAP_MA_NON_US_ST

Mailing non-U.S. State

MA_INTL_CODE

SZRCCAP_MA_INTL_CODE

PR_NON_US_ST

SZRCCAP_PR_NON_US_ST

Primary non-U.S. State

PR_INTL_CODE

SZRCCAP_PR_INTL_CODE

CONFIRM_NUMBER

SZRCCAP_CONFIRM_NUMBER

Number given to applicant for applying using CCCApply

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

COLL_1_DEGR_DATE

SZRCCAP_COLL_1_DEGR_DATE

First college degree date

COLL_2_DEGR_TYPE

SZRCCAP_COLL_2_DEGR_TYPE

COLL_2_DEGR_DATE

SZRCCAP_COLL_2_DEGR_DATE

COLL_3_DEGR_TYPE

SZRCCAP_COLL_3_DEGR_TYPE

COLL_3_DEGR_DATE

SZRCCAP_COLL_3_DEGR_DATE

COLL_4_DEGR_TYPE

SZRCCAP_COLL_4_DEGR_TYPE

COLL_4_DEGR_DATE

SZRCCAP_COLL_4_DEGR_DATE

ENROLL_STATUS

SZRCCAP_ENROLL_STATUS

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)

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

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.

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

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'

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

...