Dict-Physical

Table MD_CarlTerm

Card of table MD_CarlTerm

Name	MD_CarlTerm
Dimensional Type	Dimension
Comment	Dimension for Carleton terms. For each term, it also records the term's calendar year, academic year, aid/fiscal year, start date, and end date. Contains not only things we'd normally think of as terms (like 08/FA), but also things like spring breaks (08/SB) and whole academic years (e.g., 08/AY). This is really a sort of time dimension. The typical use case is if one wants to know the start date of a term, or one wants to model/analyze a process whose granularity is at the term level (e.g., registration). Generated via its own Colleague view -> ETL feed via the ODS X_TERM table.

Check constraint name of the table MD_CarlTerm

CKT_MD_CARLTERM

List of incoming references of the table MD_CarlTerm

Relationship_20

MF_AwardAmount

MD_CarlTerm_SurrogateKey

Relationship_25

MF_Yield

MD_CarlTerm_SurrogateKey

Relationship_40

MF_FacultyNonTeachingAssignment

MD_CarlTerm_SurrogateKey

Relationship_41

MF_CommitteeParticipation

MD_CarlTerm_SurrogateKey

Relationship_47

MF_SectionEnrollmentByTerm

MD_CarlTerm_SurrogateKey

Relationship_54

MF_SectionSeatsByTerm

MD_CarlTerm_SurrogateKey

Relationship_57

MF_SectionGradeByTerm

MD_CarlTerm_SurrogateKey

Relationship_59

MF_DistroGroup

MD_CarlTerm_SurrogateKey

Relationship_74

MF_TeachSection

MD_CarlTerm_SurrogateKey

Relationship_155

MF_SectionEnrollment

MD_CarlTerm_SurrogateKey

Relationship_156

MF_SectionSeats

MD_CarlTerm_SurrogateKey

Relationship_161

MF_SectionGrade

MD_CarlTerm_SurrogateKey

List of referencing views of the table MD_CarlTerm

VMD_CarlTerm

VMD_CARLTERM

VW_GradesByInstructorWithDynamicSecurity

VW_GRADESBYINSTRUCTORWITHDYNAMICSECURITY

List of diagrams containing the table MD_CarlTerm

DimsTimeDiagram

List of columns of the table MD_CarlTerm

MD_CarlTerm_SurrogateKey

<None>

numeric

MD_CarlTerm_ShortName

Term name, like 07/FA, 08/WI, 08/SP, 08/SU, etc. Colleague naming conventions apply. Others should be converted to this format.

DW_TermShortName

char(7)

MD_CarlTerm_FullName

DW_TermFullName

varchar(35)

MD_CarlTerm_StartDate

Start date of term. Note that term start dates and course start dates may not always coincide.

<None>

datetime

MD_CarlTerm_EndDate

Official end date of term. Note that a course end date may not always coincide with a term end date.

<None>

datetime

MD_CarlTerm_RegistrarCensusDate

Date when a lot of reporting on students, courses, etc. must be done 'as of.' Normally the census date is calculated as ten days from the start of a given term. There is a field in Colleague, though, where one can manually enter a census date for a given term. If such a date is entered, it is reflected here, in this attribute. Otherwise, this attribute will be calculated as StartDate + 10 days.

Note that although it is theoretically available for all terms (some of which span multiple simple/atomic terms), the census date only really makes sense for the simple/atomic FA/WI/SP/SU terms (e.g., 08/FA, WI/10).

<None>

datetime

MD_CarlTerm_Year

DW_YearAtCarleton

int

MD_CarlTerm_FiscalOrAidYear

Fiscal/financial aid year (the so-called INSTANCE in Colleague financial aid files). The year here is in YYYY-YY format. Defaults to 'Unknown'.

Note that although the financial aid year begins in July, the academic year begins in either July or September, depending on what report you are generating. Traditionally, fall is seen as the start of the academic year at Carleton. Also all 'AY' (academic year) terms in Colleague begin in September. Also, most students, professors, and regular folk all think of the fall term as term 1.

Choose whether to use the AidYear or the AcademicYear, depending on what you are reporting on and who your audience is.

DW_AcademicYear

char(7)

MD_CarlTerm_AcademicYear

Academic year in format YYYY-YY (e.g., 2010-11). Defaults to 'Unknown'.

Note well: In Colleague, academic years (AY terms) are defined as beginning in September, and ending in July. HOWEVER, fiscally speaking (and also from a financial aid, and often a credit standpoint) summer term goes with the following academic year. Realistically, though, because Fall is traditionally the start of the academic year at Carleton, and because most students, professors, and regular folk all think of the fall term as term 1, we lump the summer quarter here in with the previous academic year. If you would like to use summer term as the start of the academic year, use the FiscalOrAidYear attribute.

DW_AcademicYear

char(7)

MD_CarlTerm_AuditKey

DW_AuditKey

bigint

MD_CarlTerm_Timestamp

<None>

timestamp