Versions Compared

Old Version 58

changes.mady.by.user Jordan Lamb

Saved on

compared with

New Version Current

changes.mady.by.user Jordan Lamb

Saved on

Key

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

Database Definitions

TERM CODE

...

Excerpt
nameTERM_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. 🙃 )

...

Excerpt
nameGENDER

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

CCCApply nulls can equal Non-binary, Decline to state, No selection

BIRTH DATE

Excerpt
nameBIRTHDATE

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

...

Excerpt
nameRACE_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. Values underneath headers do not have to be selected.

  1. If a student has selected SPBPERS_ETHN_CDE = ‘2’ OR has select a number of races that equates CODATAMART_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  AND CODATAMART_ETHN_CODE CODE equates to 1 – 2 codes including ‘F’ and  and potentially ‘A’, AND the races that equate to CODATAMART_ETHN_CODE 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 CODATAMART_ETHN_CODE CODE equates to 1 -2 codes including ‘A’ and potentially ‘F’, AND the races that equate to CODATAMART_ETHN_CODE CODE = ‘A’ have IS_HEADER <> ‘Y’, the student will be returned Multi-Ethnic Asian.

  4. If a student has selected a number of races that equate to TWO or MORE unique CODATAMART_ETHN_CODECODE 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 CODATAMART_ETHN_CODECODE 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.

See

Jira Legacy
serverSystem JIRA
serverId8b861ae3-ff87-316b-a17e-97c61a7e2fb4
keyAP-231
for the work history.

...

Excerpt
namecensus_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
namegrades

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
nameconfidential_indicator

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

Info

Stored on SPBPERS_CONFID_IND

Employee Class

Excerpt
nameemployee_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.

Employee Group

Excerpt
nameEmployee Group

A broader classification of employees than “Employee Class.”

Info

Stored on PEBEMPL_EGRP_CODE

Has a linkage to MIS reporting.

...

Non-Database Definitions

PII

Excerpt
namePII

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

...