Database Definitions
TERM
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.
7% was used for Community Education
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. 🙃 )
SEMESTER
Semester YYYY is the typical format for how this description field is populated. (Spring 2022)BANNER ID
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.”
SSN
Social Security numbers are issued by the Social Security Administration to U.S. citizens and other residents.
This field is allowed to be null.
This is PII:
PIDM
Personal Identification Master Key is a unique ID number per person/non-person in Banner.
This is PII:
Each person/entity should have only one PIDM. Duplicate PIDMs are resolved in Applications and documented in technical resources.
LAST NAME
A person’s legal surname. Often populated off CCCApply Application or manual entry by Human Resources.
Allowed null for both persons and non-persons.
FIRST NAME
A person’s legal first name. Often populated off CCCApply Application or manual entry by Human Resources.
Allowed null for both persons and non-persons.
MIDDLE NAME
A person’s middle name (not just their middle initial). Often populated off CCCApply Application or manual entry by Human Resources.
Allowed null for both persons and non-persons.
STUDENT NAME
Concatenation ofLASTNAME, FIRSTNAME MIDINIT. (Bond, James Herbert)PHONE
Current phone number. Concatenation of Area Code and Phone Number ((559) 8675309)LEGAL SEX
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).
Often populated off CCCApply Application or manual entry by Student Services (or Human Resources for employees).
BIRTH DATE
Legal date of birth. Often populated off CCCApply Application or manual entry by Human Resources.AGE
Current age of person.AGE AT TERM
Person’s age at term.AGE GROUP AT CENSUS
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
A person’s state of being married or not married.
Refer to STVMRTL for current codes.
Non-Database Definitions
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
No longer being maintained or useful. Likely superseded by another field or solution.
Add Comment