Versions Compared

Version Old Version 28 New Version 29
Changes made by

Jordan Lamb

Jordan Lamb

Saved on

Key

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

...

Excerpt
namePHONE

Current phone number. Concatenation of Area Code and Phone Number ((559) 8675309)

LEGAL SEX

Excerpt
nameLEGALSEXGENDER

Erroneously aliased as “GENDER” on many tables/views. This field is the legal sex of the person. Allowed values of Male, Female, and Not Available (defaults to null).

Info

Often populated off CCCApply Application or manual entry by Student Services (or Human Resources for employees).

...

MARITAL STATUS

Excerpt
nameMARITALSTATUSMARITAL_CODE

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

Info

Refer to STVMRTL for current codes.

HISPANIC/LATINO

Excerpt
nameHISPANICLATINONEW_ETHNICITY

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
nameRACEETHNICITYRACES

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

Info

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

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
nameRACEETHNICITYDATAMARTRACE_ETHN_CDE

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
nameRACEETHNICITYDATAMARTDESCRIPTIONRACE_ETHN_CDE_DESC

Race description according to RACE_ETHN_CDE and

https://sequoias.atlassian.net/wiki/spaces/BANNER/pages/1173520436

.

...