Dict-Physical

List of view columns of the view VMD_Section

MD_Sect_IsFormalStatReasoning

char(3)

"Yes" if a section fulfills the Formal Statistical Reasoning distribution requirement. "No" otherwise.

This is post-2009/10 curriculum requirement.

MD_Sect_IsSocialInquiry

char(3)

"Yes" if a section fulfills the Social Inquiry distribution requirement. "No" otherwise.

This is a post-2009/10 curriculum requirement.

MD_Sect_IsArtsPractice

char(3)

"Yes" if a section fulfills the Arts Practice distribution requirement. "No" otherwise.

This is a post-2009/10 curriculum requirement.

MD_Sect_IsHumanisticInquiry

char(3)

"Yes" if a section fulfills the Humanistic Inquiry distribution requirement. "No" otherwise.

This is a post-2009/10 curriculum requirement.

MD_Sect_IsLitOrArtsAnalysis

char(3)

"Yes" if a section fulfills the Literary or Artistic Analysis distribution requirement. "No" otherwise.

This is a post-2009/10 curriculum requirement.

MD_Sect_IsArgumentAndInquiry

char(3)

"Yes" if a section fulfills the Argument and Inquiry (ANI) distribution requirement. "No" otherwise. This is a required freshman seminar in the post-2009/10 curriculum. It also fulfills the first part of the two-part writing requirement (WR1). A second writing course is needed (see WR2, or Writing Requirement 2).

MD_Sect_IsWritingRequirement

char(3)

"Yes" if a section fulfills the writing distribution overlay requirement. "No" otherwise. The writing requirement is two-part. The first part is fulfilled by the Argument and Inquiry freshman seminar. The second must be fulfilled by another course marked as MD_Sect_IsWritingRequirement2 = Yes. A writing portfolio is also required, beyond these classes.

This attribute does double duty for both the new and old (pre-2010) requirement system. It existed in both places, that is, although in the 2010 and later system, it has three parts (ANI, portfolio, and a writing course).

The 2010 and later system also has a WR2 (Writing Requirement 2) requirement, in addition to this one.

MD_Sect_IsWritingRequirement2

char(3)

"Yes" if a section fulfills the "Writing Requirement 2" distro requirement, which only exists in the post-2009/10 curriculum. "No" otherwise.

MD_Sect_IsQuantitativelyRich

char(3)

"Yes" if a section fulfills the Quantitiatively Rich Encounters (QRE) distribution overlay requirement. "No" otherwise.

This is a post-2009/10 curriculum requirement.

MD_Sect_IsInternationalStudies

char(3)

"Yes" if a section fulfills the International Studies (IS) distribution overlay requirement. "No" otherwise.

This is a post-2009/10 curriculum requirement.

MD_Sect_IsInterculturalDomestic

char(3)

"Yes" if a section fulfills the Intercultural Domestic Studies (IDS) distribution overlay requirement. "No" otherwise.

This is a post-2009/10 curriculum requirement.

MD_Sect_IsPhysicalEducation

char(3)

"Yes" for physical education courses; "No" otherwise.

This information is taken from a section-type file in Colleague distinct from the main course/section files.

This requirement is the same in the new as in the old (pre-2010) requirements system, and so the same attribute is used for both.

MD_Sect_IsPEIntercollegiate

char(3)

"Yes" if a given section is an intercolleguate sport (like "Men's Baseball"). "No" otherwise.

This section type exists in both old (pre-2010) and new curriculums.

MD_Sect_IsPEClubCourse

char(3)

"Yes" if a given section is PE club course. "No" otherwise.

This section type exists in both old (pre-2010) and new curriculums.

MD_Sect_IsIntegrativeExercise

char(3)

Integrative Exercise is what's commonly known as "Comps" at Carleton—a senior paper/project (or, in some cases, alternatively, a major examination). The value of this attribute will be "Yes" if a given section is a comps section; otherwise, "No".

This section type exists in both old (pre-2010) and new curriculums.

MD_Sect_IsLanguageProficiency

char(3)

"Yes" if a section counts towards fulfillment of the language requirement (non-English). "No" otherwise.

This distribution requirement exists in both old (pre-2010) and new (2010 and later) systems.

This information is taken from a section-type file in Colleague distinct from the main course/section files.

MD_Sect_IsOLDArtsAndLiterature

char(3)

"Yes" if a section counts towards fulfillment of the Arts and Literature distribution requirement. "No" otherwise.

This information is taken from a section-type file in Colleague distinct from the main course/section files.

This is an old (pre-2010/11) curricular requirement.

MD_Sect_IsOLDHumanities

char(3)

"Yes" if a section counts towards fulfillment of the Humanities distribution requirement. "No" otherwise. "Humanities" is one of the types that can be assigned to a section, like "Social Sciences" and "Physical Education."

This information is taken from a section-type file in Colleague distinct from the main course/section files.

This is an old (pre-2010/11) curricular requirement.

MD_Sect_IsOLDSocialScience

char(3)

"Yes" if a section counts towards fulfillment of the Social Sciences distribution requirement. "No" otherwise.

This information is taken from a section-type file in Colleague distinct from the main course/section files.

This is an old (pre-2010/11) curricular requirement.

MD_Sect_IsOLDNoDistributionCredit

char(3)

"No distribution credit" is one of the types that can be assigned to a section, like "Humanities" and "Social Sciences."

This information is taken from a section-type file in Colleague distinct from the main course/section files.

This is a post-2009/10 curriculum requirement. The new equivalent is MD_Sect_IsNoExploration.

MD_Sect_IsOLDMathAndScience

char(3)

"Yes" if a section counts towards fulfillment of the Mathematics and Natural Sciences distribution requirement. "No" otherwise.

This information is taken from a section-type file in Colleague distinct from the main course/section files.

This is an old (pre-2010/11) curricular requirement.

MD_Sect_IsOLDRecognitionOfDifference

char(3)

"Yes" if a section counts towards fulfillment of the Recognition and Affirmation of Difference (RAD) distribution requirement. "No" otherwise. This attribute is one of the "types" that may be assigned to a section.

This information is taken from a section-type file in Colleague distinct from the main course/section files.

This attribute pertains to the pre-2010/11 distribution requirements. RAD was replaced by a dual International Studies and Intercultural Domenstic Studies requirement.

MD_Sect_IsOLDCultureOrLinguistics

char(3)

"Yes" if a section fulfills the Culture or Linguistics distribution requirement. "No" otherwise.

This is an old (pre-2010/11) curricular requirement.

MD_Sect_IsOLDWritingRich

char(3)

"Yes" if a section fulfills the "Writing Rich" distro requirement. "No" otherwise.

This is an old (pre-2010/11) curricular requirement.

MD_Sect_Types

varchar(512)

This field contains a list of all applicable "types" to which a section belongs, e.g.:

PE Club Course
Integrative Exercise
Math & Natural Sciences
Arts & Literature
Social Sciences
Recogn & Affirm of Diffs
Language Proficiency
Etc.

Because this is essentially a collapsed multi-valued field, it should not generally be exposed to users.

Note that there are also a number of Yes/No attributes (e.g., MD_Sect_IsArtsAndLiterature) that should generally be used instead of this field, if you want to group sections by type.

The default here is an empty string.

MD_Sect_IsOCS

char(3)

"Yes" if the course is an Off-Campus Studies course. "No" otherwise.

The information in this field is NOT taken from the separate course section types file that Colleague has, from which we take information like whether a course is a "Humanities" or a "Math and Natural Sciences" course.

MD_Sect_IsOWB

char(3)

"Yes" if a section is an OWB or "On Winter Break" course. "No" otherwise.

The information in this field is NOT taken from the separate course section types file that Colleague has, from which we take information like whether a course is a "Humanities" or a "Math and Natural Sciences" course.

MD_Sect_IsOWBOrOCS

MD_Sect_IsStOlaf

char(3)

MD_Sect_IsCarletonPlacement

char(3)

"Yes" if a section reflects a placement, rather than a "real" course. Taken from COURSE.SECTIONS->SEC.CREDIT.TYPE in Colleague.

1 2

Home