Dict-Physical

View VMD_CarletonDepartment

Card of view VMD_CarletonDepartment

Name	VMD_CarletonDepartment
Comment	See documentation on MD_CarletonDepartment in the DimsOrganization package.
Dimensional Type	Dimension

SQL query of the view VMD_CarletonDepartment

select
MD_CarlDept_SurrogateKey,
MD_CarlDept_Abbreviation,
MD_CarlDept_Name,
MD_CarlDept_College,
MD_CarlDept_CIPCode,
MD_CarlDept_Division,
MD_CarlDept_IsAcademic,
MD_CarlDept_Status
from
MD_CarletonDepartment

List of incoming view references of the view VMD_CarletonDepartment

ViewReference_83

VMF_PerPosition

ViewReference_103

VMF_IssueTrackingTicket

ViewReference_119

VMF_IssueTrackingAssetValue

ViewReference_144

VMF_Room

ViewReference_228

VMF_KeyedComputerEvent

ViewReference_240

VMF_KeyedComputerInUse

ViewReference_245

VMF_KeyedComputerInUseWithRoomUtilization

List of shortcuts of the view VMD_CarletonDepartment

VMD_CarletonDepartment

VMD_CARLETONDEPARTMENT

View

ViewsEmployee

VMD_CarletonDepartment

VMD_CARLETONDEPARTMENT

View

ViewsEmployee

VMD_CarletonDepartment

VMD_CARLETONDEPARTMENT

View

ViewsEmployee

List of diagrams containing the view VMD_CarletonDepartment

ViewsEmployeeDiagram

List of permissions of the view VMD_CarletonDepartment

SELECT,VIEW DEFINITION

EmployeeReader

SELECT,VIEW DEFINITION

EnergyReader

SELECT,VIEW DEFINITION

IssueTrackingReader

SELECT,VIEW DEFINITION

SpaceReader

List of view columns of the view VMD_CarletonDepartment

MD_CarlDept_SurrogateKey

numeric

MD_CarlDept_Abbreviation

char(5)

All-CAP Colleague department code (most are 4-char, but a few are 5). This is the business key for the department dimension. Use this attribute if you are looking more at financial/account-based organizational units. If you're looking more at what we think of as departments, use the full department name (inconvenient as it might be on a graph label). Note that the department abbreviation or code is the primary key in Colleague, from which the data is derived.

MD_CarlDept_Name

varchar(64)

Full name ('description' in Colleague) of department. Business practice at Carleton dictates that some department abbreviations or 'codes' will correspond to a single department name, as in the case of Information Technology Services - a single department name that corresponds to multiple department abbreviations or 'codes' (ACS, ACNS).

MD_CarlDept_College

varchar(64)

Technically, departments (in Colleague) are leaf nodes in a hierarchy whose members are: division, college, and department. The college level is not currently used at Carleton.

MD_CarlDept_CIPCode

varchar(12)

MD_CarlDept_Division

varchar(64)

Technically, departments (in Colleague) are leaf nodes in a hierarchy whose members are: division, college, and department. The college level is not currently used at Carleton. Divisions only just started being maintained as of 2010.

Note that the divisions also do not necessarily correspond to AAUP or HEDS division definitions (1=Fine Arts; 2=Humanities; 3=Social Sciences; 4=Natural Science; 5=Psychology; 6=Foreign Language; 7=Engineering; 8=Business and Law; 9=Education; 10=Medical (Nursing); 99=Unknown or unreported). They are, rather, internal Carleton constructs.

MD_CarlDept_IsAcademic

varchar(7)

"Yes" if a department is considered academic. "No" if it is considered administrative. Otherwise, "Unknown" (should generally not occur, in practice).

This field is based on a complex query ("virtual field") in Colleague set up by Julie Latham, and may not, in every case, give exactly the anticipated result, due to the often arbitrary and fluctuating nature of organizational units at Carleton.

It is not altogether clear how useful this field actually is, or will be - although virtually everyone at Carleton appears convinced that it needs to be here.

MD_CarlDept_Status

varchar(16)

Current acceptable values for this field are: Active, Inactive. The default is "Unknown" but this in practice should not occur. Active departments are ones that exist as current, functioning units. Inactive ones are historical only.

Home