Dict-Physical

Table MD_AcademicProgram

Card of table MD_AcademicProgram

Name	MD_AcademicProgram
Dimensional Type	Dimension
Comment	Programs provide a level of abstraction above courses and sections, and provide a basis for things like degree audit. Programs constitute an independent dimension, however, and not just an aggregation level above courses, because a course may be associated with multiple programs, or no program. And a program may be associated with multiple courses.

Check constraint name of the table MD_AcademicProgram

CKT_MD_ACADEMICPROGRAM

List of incoming references of the table MD_AcademicProgram

Relationship_237

MF_Advisement

MD_Program_SurrogateKey

List of diagrams containing the table MD_AcademicProgram

DimsAcademicRecordDiagram

List of columns of the table MD_AcademicProgram

MD_Program_SurrogateKey

<None>

numeric

MD_Program_ID

Unique identifier, in Colleague, associated with every program.

This identifier currently contains no more than twenty characters, and is more or less human readable - and may therefore reasonably be used in reports and pivot tables. There is nothing, however, to stop Datatel from changing this to an opaque identifier, so YMMV.

DW_CodeDesc

varchar(32)

MD_Program_Name

Full title of an academic program. See also MD_Program_ID.

Can be very long, and may not fit well into a report or especially a pivot table. This is one case where a 'code' (MD_Program_ID) may be more appropriate in some instances.

DW_CodeDescLong

varchar(64)

MD_Program_CurrentStatus

Currently (July 2009) one of two values: Active or Cancelled. Defaults to "Unknown" although this value should not in practice be seen (except in the case of a generic "Unknown" program used to make all joins possible to a fact table). Might be other values, thought, at some point.

Note that this is a "description" (i.e., a human-readable word) not a code.

DW_CodeDescShort

varchar(16)

MD_Program_AcadLevel

One of: Non-Degree, Undergraduate, Summer Graduate. Note that we use human-readable values here, not "codes."

Defaults to "Unknown," although in practice this value should never be seen.

DW_CodeDesc

varchar(32)

MD_Program_Degree

Degree with which a program is associated. Typically this is "BA," but may also (as of July 2009) be "Unknown" - which corresponds to NULL in Colleague, and which is also the default.

DW_CodeDescShort

varchar(16)

MD_Program_Department1

Primary department with which an academic program is affiliated.

DW_Department

varchar(64)

MD_Program_Department2

Second department with which an academic program is affiliated.

DW_Department

varchar(64)

MD_Program_Department3

Not currently populated; will always be "Unknown" as of July 2009.

DW_Department

varchar(64)

MD_Program_BeginYear

Start year of program.

DW_YearAtCarleton

int

MD_Program_EndYear

End year of program.

DW_YearAtCarleton

int

MD_Program_YearsRunningRange

How many years an academic program ran (has run) for, discretized/banded as a set of ranges, 0-3, 4-7, etc. Defaults to 'Unknown', although this value should not normally be encountered except in the case of a generic Unknown program used to make all joins possible to some fact table.

DW_CodeDescShort

varchar(16)

MD_Program_AuditKey

DW_AuditKey

bigint

MD_Program_Timestamp

<None>

timestamp