Versions Compared

Version Old Version 24 New Version 25
Changes made by

Jordan Lamb

Jordan Lamb

Saved on

Key

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

...

Excerpt
nameLASTNAME

A person’s legal surname.

Info

Often populated off CCCApply Application or manual entry by Human Resources.

Info

Allowed null for both persons and non-persons.

...

Excerpt
nameFIRSTNAME

A person’s legal first name.

Info

Often populated off CCCApply Application or manual entry by Human Resources.

Info

Allowed null for both persons and non-persons.

...

Excerpt
nameMIDINIT

A person’s middle name (not just their middle initial).

Info

Often populated off CCCApply Application or manual entry by Human Resources.

Info

Allowed null for both persons and non-persons.

...

Excerpt
nameMARITALSTATUS

A person’s state of being married or not married.

Info

Refer to STVMRTL for current codes.

HISPANIC/LATINO

Excerpt
nameHISPANICLATINO

User’s ethnicity as it relates to Hispanic or Latino. Banner codes are converted to text for ease of use.

Info

Per U.S. Department of Education guidelines, colleges are required to collect this racial and ethnic data.

RACE/ETHNICITY

Excerpt
nameRACEETHNICITY

Ethnicity and ancestry groups that the user identified with. 2 character codes, pipe '|' delimited.

Note

Implementing SB38 (race_ethnic_full) a field length deficiency was discovered.

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

This is PII:

Insert excerpt
Common Definitions
Common Definitions
namePII
nopaneltrue

RACE/ETHNICITY DATAMART GROUPS

Excerpt
nameRACEETHNICITYDATAMART

Intended to locally replicate the Race/Ethnicity groups shown on the CCCCO Data Mart system.

Info

IS_HEADER on https://sequoias.atlassian.net/wiki/spaces/BANNER/pages/1173946389/COS+GEN.CODATAMART+RACE+ETHN+CROSSWALK+table table is an additional column to tell if GORPRAC race code is a header value. On CCCApply, a header value checkbox must be selected to be able to select values underneath that header.

  1. If a student has selected SPBPERS_ETHN_CDE = ‘2’ OR has select a number of races that equates ETHN_CODE to include ‘H’, then that student will be listed as Hispanic.

  2. If a student has selected a number of races WHERE SPBPERS_ETHN_CDE <> ‘2’ AND ETHN_CODE equates to 1 – 2 codes including ‘F’ and potentially ‘A’, AND the races that equate to ETHN_CODE = ‘A’ have IS_HEADER = ‘Y’, the student will be returned Filipino. 

  3. If a student has selected a number of races WHERE SPBPERS_ETHN_CDE <> ‘2’ AND ETHN_CODE equates to 1 -2 codes including ‘A’ and potentially ‘F’, AND the races that equate to ETHN_CODE = ‘A’ have IS_HEADER <> ‘Y’

  4. If a student has selected a number of races that equate to TWO or MORE unique ETHN_CODE values that DOES NOT include ‘H’ OR SPBPERS_ETHN_CODE <> ‘2’, the student will be returned as Multi-Ethnic.

  5. If a student has selected a number of races that equate to ONE ETHN_CODE AND SPBPERS_ETHN_CDE <> ‘2’, the student will be returned as derived ETHN_CODE

  6. Else Unknown

This is distinct from IPEDS. There is no CCCCO Data Mart methodology documented.

RACE/ETHNICITY DATAMART GROUPS DESCRIPTION

Excerpt
nameRACEETHNICITYDATAMARTDESCRIPTION

Race description according to RACE_ETHN_CDE and

/wiki/spaces/BANNER/pages/1173520436

.

Non-Database Definitions

PII

...