Database Definitions
TERM
| Excerpt | ||||
|---|---|---|---|---|
| ||||
Common alias for Sequoias CCD has a preceding Summer Academic Calendar.
|
SEMESTER
| Excerpt | ||
|---|---|---|
| ||
Semester YYYY is the typical format for how this description field is populated. (Spring 2022) |
...
BANNER ID
| Excerpt | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
Commonly Referred to as Banner ID. This is a unique ID per user 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
| Excerpt | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
Social Security numbers are issued by the Social Security Administration to U.S. citizens and other residents.
|
PIDM
| Excerpt | ||||
|---|---|---|---|---|
| ||||
Personal Identification Master Key is a unique ID number per person/non-person in Banner.
|
LAST NAME
| Excerpt | ||
|---|---|---|
| ||
A person’s legal surname. Often populated off CCCApply Application or manual entry by Human Resources.
|
FIRST NAME
| Excerpt | ||
|---|---|---|
| ||
A person’s legal first name. Often populated off CCCApply Application or manual entry by Human Resources.
|
MIDDLE NAME
| Excerpt | ||
|---|---|---|
| ||
A person’s middle name (not just their middle initial). Often populated off CCCApply Application or manual entry by Human Resources.
|
STUDENT NAME
| Excerpt | ||
|---|---|---|
| ||
Concatenation of |
PHONE
| Excerpt | ||
|---|---|---|
| ||
Current phone number. Concatenation of Area Code and Phone Number ((559) 8675309) |
LEGAL SEX
| Excerpt | ||
|---|---|---|
| ||
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). |
BIRTH DATE
| Excerpt | ||
|---|---|---|
| ||
Legal date of birth. Often populated off CCCApply Application or manual entry by Human Resources. |
AGE
| Excerpt | ||
|---|---|---|
| ||
Current age of person. |
AGE AT TERM
| Excerpt | ||
|---|---|---|
| ||
Person’s age at term. |
AGE GROUP AT CENSUS
| Excerpt | ||
|---|---|---|
| ||
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 | ||
|---|---|---|
| ||
A person’s state of being married or not married.
|
Non-Database Definitions
PII
| Excerpt | ||
|---|---|---|
| ||
Personal Identifiable Information refers to data that directly, or indirectly, distinguish 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 | ||
|---|---|---|
| ||
No longer being maintained or useful. Likely superseded by another field or solution. |