Database Definitions

TERM CODE

https://sequoias.atlassian.net/browse/GOVPUB-10

Excerpt

name	TERM_CODE

Common alias for %TERM_CODE. The first 4 digits are determined by the Academic Calendar end year. The last 2 digits refer to the semester/intersession where "10" represents Fall, "20" - Spring, and "30" - Summer.

Sequoias CCD has a preceding Summer Academic Calendar.

Note
7% was used for Community Education

Info

999999 is the STVTERM_TERM_CODE value used to represent “The End of Time” (The “End of Time” has an End Date of 05/15/2999. So, if you are reading this around that time plan accordingly. ⏲)

000000, conversely, represents “The Beginning of Time” (The beginning of time has a Start Date at 01/01/1900. Nothing existed prior to this date. 🙃 )

TERM

Excerpt

name	TERM

Semester YYYY is the typical format for how this description field is populated. (Spring 2022)

BANNER ID

Excerpt

name	STUDENTID

Commonly Referred to as Banner ID. This is a unique ID per person/non-person that begins with the “@” symbol.

This is PII, but widely used as the least bad option where COS Employees have “legitimate educational interest.”

Insert excerpt

	Common Definitions
	Common Definitions
name	PII
nopanel	true

SSN

Excerpt

name	SSN

Social Security numbers are issued by the Social Security Administration to U.S. citizens and other residents.

Code Block
SPBPERS_SSN

Info
This field is allowed to be null.

Note

This is PII:

Insert excerpt

	Common Definitions
	Common Definitions
name	PII
nopanel	true

PIDM

Excerpt

name	PIDM

Personal Identification Master Key is a unique ID number per person/non-person in Banner.

Note
This is PII.

Info
Each person/entity should have only one PIDM. Duplicate PIDMs are resolved in Applications and documented in technical resources.

Is not display on Banner forms and is not normally visible to users.

LAST NAME

Excerpt

name	LASTNAME

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.

FIRST NAME

Excerpt

name	FIRSTNAME

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.

MIDDLE NAME

Excerpt

name	MIDINIT

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.

STUDENT NAME

Excerpt

name	STUDENTNAME

Concatenation of LASTNAME, FIRSTNAME MIDINIT. (Bond, James Herbert)

PHONE

Excerpt

name	PHONE

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

GENDER

Excerpt

name	GENDER

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

BIRTH DATE

Excerpt

name	BIRTHDATE

Legal date of birth. Often populated off CCCApply Application or manual entry by Human Resources.

AGE

Excerpt

name	AGE

Current age of person.

AGE AT TERM

Excerpt

name	AGEATTERM

Person’s age at term.

AGE GROUP AT CENSUS

Excerpt

name	CENSUSAGEGROUP

Description of age group person was in at term census. (Less than 20 years, 20-24 years, 25-29 years, 30-34 years, 35-39 years, 40-49 years, 50-59 years, 60 or more years)

MARITAL STATUS

Excerpt

name	MARITAL_CODE

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

Info
Refer to `STVMRTL` for current codes.

HISPANIC/LATINO

Excerpt

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

name	RACES

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

server	System JIRA
serverId	8b861ae3-ff87-316b-a17e-97c61a7e2fb4
key	AP-224

This is PII:

Insert excerpt

	Common Definitions
	Common Definitions
name	PII
nopanel	true

RACE/ETHNICITY DATAMART GROUPS

Excerpt

name	RACE_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.

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.
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.
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’, the student will be returned Multi-Ethnic.
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.
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
Else Unknown

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

See

Jira Legacy

server	System JIRA
serverId	8b861ae3-ff87-316b-a17e-97c61a7e2fb4
key	AP-231

for the work history.

RACE/ETHNICITY DATAMART GROUPS DESCRIPTION

Excerpt

name	RACE_ETHN_CDE_DESC

Race description according to RACE_ETHN_CDE and

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

HIGH SCHOOL

Excerpt

name	HIGHSCHOOL

Description of High School attended.

Info
Links to STVSBGI validation.

Note
Historical data do not seemingly link to a validation table and thus includes many duplicate spellings and college names.

ENGLISH PLACEMENT

Excerpt

name	ENG251_ELIG

Most recent English (LE) placement score.

Historically meant what test score they received and how that applied to ENGL 251 eligibility.

ENGLISH PLACEMENT DATE

Excerpt

name	ENG_TEST_DATE

Date of ENG251_ELIG.

Historically meant when a student took a test.

MAJOR

Excerpt

name	MAJOR_DESC

An area of study that a student chooses; often times supported by an academic counselor.

EDUCATIONAL GOAL

Excerpt

name	EDUCATIONAL_GOAL

Student’s stated goal for applying. Happens during application process and overwhelmingly without counselor guidance.

PERSONAL EMAIL

Excerpt

name	PERSONAL_EMAIL

Email address provided by the student and not created or supported by the college.

Info
Often populated off CCCApply Application.

CENSUS ENROLLMENT

Excerpt

name	census_enrollment

Number of students enrolled in a section before and on the section Census date.

Census Enroll number is locked after Census date has passed.

Info
Does not restrict count based on student information (i.e. Resident/Non-Resident).

GRADES (differs from Grade Level)

Excerpt

name	grades

All college work is measured in terms of both quantity and quality. Grades (grade symbols) relate to Grade Points and are defined in detail in the COS Catalog.

Treat any grade that begins with “I%” as incomplete. Student Services runs an incomplete grade process one year later at the end of the term. “I” grades at that time turn to F. “I%” grades turn into the second character at that time.

Info
Refer to SHRGRDE validation table or SHAGRDE page in Banner.

CONFIDENTIAL INDICATOR

Excerpt

name	confidential_indicator

Flag representing a person’s desire to retain information confidentially.

Info
Stored on `SPBPERS_CONFID_IND`

Employee Class

Excerpt

name	employee_class

Describes the employee type in a more detail than Employee Group.

Info
Stored on `PEBEMPL_ECLS_CODE`

Naming Convention:

Code	Class
A%	Administrator
B%	Board Members
C%	Classified & Confidential
F%	Faculty
J%	Adjunct Faculty
M%	Miscellaneous
R%	Retiree
S%	Student

Note
SF & SJ break Naming Convention but aren’t in use.

Non-Database Definitions

PII

Excerpt

name	PII

Personal Identifiable Information refers to data that directly, or indirectly, distinguishes an individual’s identity with, or without, the use of other information.

Institutional Code of Ethics (AP 3050) requires employees “actively guard the privacy of individuals.”

DEPRECATED

Excerpt

name	DEPRECATED

Note
No longer being maintained or useful. Likely superseded by another field or solution.

Versions Compared

Old Version 64

New Version 65

Key

Database Definitions

TERM CODE

TERM

BANNER ID

SSN

PIDM

LAST NAME

FIRST NAME

MIDDLE NAME

STUDENT NAME

PHONE

GENDER

BIRTH DATE

AGE

AGE AT TERM

AGE GROUP AT CENSUS

MARITAL STATUS

HISPANIC/LATINO

RACE/ETHNICITY

RACE/ETHNICITY DATAMART GROUPS

RACE/ETHNICITY DATAMART GROUPS DESCRIPTION

HIGH SCHOOL

ENGLISH PLACEMENT

ENGLISH PLACEMENT DATE

MAJOR

EDUCATIONAL GOAL

PERSONAL EMAIL

CENSUS ENROLLMENT

GRADES (differs from Grade Level)

CONFIDENTIAL INDICATOR

Employee Class

Naming Convention:

Non-Database Definitions

PII

DEPRECATED

Page Comparison

Versions Compared

Old Version 64

New Version 65

Key

Database Definitions

TERM CODE

TERM

BANNER ID

SSN

PIDM

LAST NAME

FIRST NAME

MIDDLE NAME

STUDENT NAME

PHONE

GENDER

BIRTH DATE

AGE

AGE AT TERM

AGE GROUP AT CENSUS

MARITAL STATUS

HISPANIC/LATINO

RACE/ETHNICITY

RACE/ETHNICITY DATAMART GROUPS

RACE/ETHNICITY DATAMART GROUPS DESCRIPTION

HIGH SCHOOL

ENGLISH PLACEMENT

ENGLISH PLACEMENT DATE

MAJOR

EDUCATIONAL GOAL

PERSONAL EMAIL

CENSUS ENROLLMENT

GRADES (differs from Grade Level)

CONFIDENTIAL INDICATOR

Employee Class

Naming Convention:

Non-Database Definitions

PII

DEPRECATED