Versions Compared

Old Version 63

changes.mady.by.user Jordan Lamb

Saved on

compared with

New Version 64

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

...

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

...