Dayname

From CSUMB Data Glossary
Jump to navigation Jump to search

Dayname represents the name of the day of the week that a class meeting is scheduled to take place ordered sequentially as the days occur throughout a week starting with Monday (e.g. 1-Monday, 2-Tuesday, 3-Wednesday, 4-Thursday, etc.)

Metadata
Data Custodian
Academic and Centralized Scheduling
Data Source
Source System:CMS - SA
Source Table Name:N/A
Source Field Name:N/A
Census Process:N/A
Logical Transformation / Calculation
select '1-Monday' dayname from class timeblocks smtl where monday = "Y"...
Dataset Folder and Field Name
Dataset Folder:Class Meeting Pattern
Field Name:Dayname

Business Rules

When a day of the week flag is "Y," indicating that a class meeting pattern includes meetings on that day of the week, the Dayname value is assigned to that meeting for the appropriate day of the week.

Classes with multiple meeting days according to their standard meeting pattern, will have a Dayname assignment for each one of the class meetings (e.g. a class with a MW standard meeting pattern would have one meeting record for 1-Monday and one meeting record for 3-Wednesday).

Examples

  • 1-Monday
  • 2-Tuesday
  • 3-Wednesday
  • 4-Thursday
  • 5-Friday
  • 6-Saturday
  • 7-Sunday

See Also

Definition Source

"Section Meet Days. An abbreviation which denotes the day(s) of the week on which a given resource segment activity is scheduled to meet."[1]

References

  1. CSU. APDB Data Element Dictionary. Transaction Data Elements. Retrieved from: https://csyou.calstate.edu/Tools/academic-affairs/apdb/Pages/APDB-Data-Element-Dictionary.aspx (Requires login).