Versions Compared

Old Version 53

changes.mady.by.user Jordan Lamb

Saved on

compared with

New Version 54

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

...

TERM

Excerpt
nameSEMESTER

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

...