Dict-Physical

View VMD_CarlTerm

Card of view VMD_CarlTerm

Name	VMD_CarlTerm
Comment	See MD_CarlTerm
Dimensional Type	Dimension

SQL query of the view VMD_CarlTerm

select
MD_CARLTERM_SURROGATEKEY,
MD_CARLTERM_SHORTNAME,
MD_CARLTERM_FULLNAME,
MD_CARLTERM_YEAR,
MD_CARLTERM_FISCALORAIDYEAR,
SUBSTRING(MD_CARLTERM_SHORTNAME, 4, 2) AS VMD_CARLTERM_SEASON,
CASE SUBSTRING(MD_CARLTERM_SHORTNAME, 4, 2)
WHEN '' THEN 0
WHEN 'SU' THEN 5
WHEN 'SG' THEN 1
WHEN 'AY' THEN 10
WHEN 'FA' THEN 15
WHEN 'FW' THEN 20
WHEN 'WB' THEN 25
WHEN 'WI' THEN 30
WHEN 'WS' THEN 35
WHEN 'SB' THEN 40
WHEN 'SP' THEN 45
WHEN 'SR' THEN 50
WHEN 'SF' THEN 55
WHEN 'SW' THEN 60
WHEN 'SS' THEN 65
ELSE 100
END AS VMD_CARLTERM_ORDINAL,
CAST(SUBSTRING(MD_CARLTERM_FISCALORAIDYEAR, 1, 4) AS INT) AS MD_CARLTERM_AIDINSTANCE,
MD_CARLTERM_ACADEMICYEAR,
MD_CARLTERM_STARTDATE
from
MD_CARLTERM

List of incoming view references of the view VMD_CarlTerm

ViewReference_23

VMF_AwardAmountSnapshot

ViewReference_24

VMF_AwardAmountCurrent

ViewReference_27

VMF_FacultyNonTeachingAssignment

ViewReference_29

VMF_SectionSeatsByTerm

ViewReference_35

VMF_Yield

ViewReference_57

VMF_SectionEnrollmentByTerm

ViewReference_66

VMF_DistroGroup

ViewReference_72

VMF_TeachSection

ViewReference_99

VMF_FacultyWorkloadActivity

ViewReference_161

VMF_SectionEnrollment

ViewReference_162

VMF_SectionSeats

List of referenced objects of the view VMD_CarlTerm

MD_CarlTerm

List of shortcuts of the view VMD_CarlTerm

View

View

View

List of diagrams containing the view VMD_CarlTerm

ViewsFinancialAidDiagram

List of permissions of the view VMD_CarlTerm

SELECT,VIEW DEFINITION

AcadRecordReader

SELECT,VIEW DEFINITION

FacultyReader

SELECT,VIEW DEFINITION

FinancialAidReader

SELECT,VIEW DEFINITION

ProspectViewReader

List of view columns of the view VMD_CarlTerm

MD_CarlTerm_SurrogateKey

numeric

MD_CarlTerm_ShortName

char(7)

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

MD_CarlTerm_FullName

varchar(35)

MD_CarlTerm_Year

int

MD_CarlTerm_FiscalOrAidYear

char(7)

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.

VMD_CARLTERM_SEASON

VMD_CARLTERM_ORDINAL

MD_CARLTERM_AIDINSTANCE

MD_CarlTerm_AcademicYear

char(7)

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.

MD_CarlTerm_StartDate

datetime

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

Home