Term Code

From CSUMB Data Glossary
Jump to navigation Jump to search

Term Code is the code identifying a given term in the format MYYT where M = first digit of year (e.g. 2 for 2000), YY = last two digits of year (e.g. 11 for 2011), and T = code of Term (e.g. 1 for Winter, 2 for Spring, 3 for Summer, and 4 for Fall).

Metadata
Where Term Appears
CSUMB Data Warehouse Dashboards:
Other Reports:N/A
Data Custodian
Academic and Centralized Scheduling
Data Source
Source System:CMS - SA
Source Table Name:PS_TERM_TBL
Source Field Name:STRM
Census Process:N
Logical Transformation / Calculation
N/A
OBIEE Folder and Column
Folder Heading:"Term"
Column Heading:"Source Term Code"

Business Rules

Within the defined date ranges of the Term Codes are various Session Codes that can be State or Extended Ed supported.

Examples

Term Code Term
2221 2022 Winter
2222 2022 Spring
2223 2022 Summer
2224 2022 Fall

See Also