Dict-Physical

List of columns of the table MD_Position

MD_Pos_RowStart

DW_RowStart

datetime

MD_Pos_RowEnd

DW_RowEnd

datetime

MD_Pos_RowIsCurrent

DW_BooleanNoDefault

bit

MD_Pos_AuditKey

DW_AuditKey

bigint

MD_Pos_Type1Checksum

DW_Checksum

int

MD_Pos_Type2Checksum

DW_Checksum

int

MD_Pos_Timestamp

<None>

timestamp

MD_Pos_SurrogateKey

<None>

numeric

MD_Pos_SupervisorPositionKey

This field links back to the MD_Pos_SurrogateKey field in this same dimension. It serves to link a position with the supervisor's position.

Because this field is not (as of 2010) well utilized or maintained at Carleton, it should not be exposed (yet) to users.

<None>

numeric

MD_Pos_PositionID

Unique identifier in Colleague for a position. This is the position ID.

DW_ColleaguePositionID

varchar(16)

MD_Pos_IsFullyStaffed

'Yes' if actual FTE associated with a position is >= budgeted FTE.

'No' if actual FTE < budgeted FTE.

Best used in conjunction with MF_PositionFunding, which can be used to tell us things like how much it will cost us if we fully fill positions in one or more areas of college operations.

DW_YesNoOrNotApplicable

varchar(16)

MD_Pos_IsAuthorized

"Yes" if the position in question has been authorized by whoever needs to approve such things (Administrative Council). "No" otherwise.

Basically if the budgeted FTE for a position is > 0 then the position is authorized.

NOTE WELL: Positions are authorized as abstract entities. Multiple people may fill those positions. So make sure not to confuse positions and people in positions. This field applies only to the positions.

DW_YesOrNoNOTNULL

char(3)

MD_Pos_CurrentlyHeldByCount

Count of people currently holding a position. Must be a whole number.

<None>

int

MD_Pos_IsTemporary

"Yes" if the position type is temporary. "No" otherwise.

DW_YesOrNoNOTNULL

char(3)

MD_Pos_IsGrantFunded

DW_YesOrNoNOTNULL

char(3)

MD_Pos_IsCampaignFunded

DW_YesOrNoNOTNULL

char(3)

MD_Pos_IsFaculty

DW_YesOrNoNOTNULL

char(3)

MD_Pos_IsEmeritus

DW_YesOrNoNOTNULL

char(3)

MD_Pos_PayRangeMax

Maximum pay for position. In general, pay range data is not maintained directly in Colleague. As of 2010 it is imported from another hosted system, CompEase.

DW_CodeDescShort

varchar(16)

MD_Pos_PayRangeMid

Midpoint of pay range for position. In general, pay range data is not maintained directly in Colleague. As of 2010 it is imported from another hosted system, CompEase.

DW_CodeDescShort

varchar(16)

MD_Pos_PayRangeMin

Minimum pay for position. In general, pay range data is not maintained directly in Colleague. As of 2010 it is imported from another hosted system, CompEase.

DW_CodeDescShort

varchar(16)

MD_Pos_Grade

Pay grade, as provided to us via CompEase (as of 2010).

DW_CodeDesc

varchar(32)

MD_Pos_IsSalaried

"Yes" if the position is salaried. Otherwise (e.g., if hourly) then "No".

DW_YesOrNoNOTNULL

char(3)

MD_Pos_IsHourly

"Yes" if a given position is hourly (as opposed to salaried). "No" otherwise.

DW_YesOrNoNOTNULL

char(3)

MD_Pos_AuthorizedFTERange

Full-time equivalency budgeted for a given position, discretized: 0 - .49, .50 - .99, 1.00, 1.01 - 2.00, 2.01 - 3.00, 3.01 - 4.00, 4.00 or more. The 'Not Applicable' category applies if the value is zero or NULL (indicating that the position is no[t yet/ longer] authorized).

NOTE WELL: Positions may be filled by more than one person. E.g., a position's FTE range may be 1.0, but two or more people might actually hold the position at a given time (they would, naturally, be part time). This field therefore can't be used to classify by individual employee.

See also MD_Pos_IsAuthorized.

DW_CodeDesc

varchar(32)

MD_Pos_ActualFTERange

DW_CodeDesc

varchar(32)

MD_Pos_ActualWorkloadRange

DW_CodeDesc

varchar(32)

MD_Pos_Rank

Used for faculty only. Indicates level of the instructor (professor, assoc. professor, etc.). This is defined at the 'position level', so each position has a unique rank. Value will be "Not Applicable" for non-faculty. Default is "Unknown."

DW_PositionRank

varchar(32)

MD_Pos_Title

TItle associated with a position. People may have multiple titles; positions have only one.

If no title is associated with a position, then the value will be 'Not Available.'

Titles are set at the position level at Carleton (and since multiple people can hold the same position, multiple people can hold the same title).

Generally titles are problematic in data warehouses. If a user wants them, typically it's because he or she wants to generated a list of some kind, and lists are best generated off of our systems of record, not off the data warehouse. Still, we include the title for completeness' sake.

DW_Title

varchar(64)

MD_Pos_Type

Position type: Temporary, permanent, etc.

Note that these are descriptions/names, not opaque codes.

DW_CodeDesc

varchar(32)

MD_Pos_Class

Position type: Faculty, Exempt non-faculty, Bi-Weekly, etc. Also called "pay class."

DW_CodeDesc

varchar(32)

MD_Pos_Points

This attribute is currently unmaintained. It is envisioned that at some future date HR will assign point rankings to positions, for comparison and equity analysis.

This is not the same as Compease data, which was collected starting in 2009.

<None>

float

MD_Pos_StartDate

Date when a position was created at Carleton. Note that this number is not useful for most positions, which are recorded as starting on January 1st 1930. What you probably want instead is the MD_PerPosition start date, i.e., the date when a particular person started in a particular position.

Note that this is NOT a RowStart date (used internally to timestamp certain types of data in the data warehouse).

<None>

datetime

MD_Pos_StartYear

Year when a position was created. Numbers here are generally not useful, as most positions have been set to start in 1930.

DW_YearAtCarleton

int

MD_Pos_StartAcademicYear

Academic year when a position was created. Generally not useful. What you probably want instead is the MD_PerPosition start academic year, i.e., the academic year when a particular person started in a particular position.

DW_AcademicYear

char(7)

MD_Pos_EndDate

Date when an employee ceased to be employed by Carleton. Current employees who haven't left Carleton will have a nonsense date here of 9999-12-31.

Note that this is NOT a RowEnd date (used internally to timestamp certain types of data in the data warehouse).

<None>

datetime

MD_Pos_EndYear

Year when an employee ceased to be employed by Carleton. Defaults to 9999 (e.g., as in the case of current employees, who have not left).

DW_YearAtCarleton

int

MD_Pos_PrimaryDepartment

Department with which a position is associated. This is the full name of the department, not the code.

This is an organizational department, not the funding department (in the GL sense) or funding division, i.e., the division of the college associated with the primary funding account for a given position.

DW_Department

varchar(64)

MD_Pos_PrimaryFundingDivision

Division of Carleton College from which funding is primarily drawn for a position.

DW_CodeDesc

varchar(32)

MD_Pos_PrimaryFundingDepartment

Name of department corresponding to the primary GL account that funds a given position. Note that the GL department (as here) is not the same as the organizational department.

DW_Department

varchar(64)

MD_Pos_PrimaryFunctionalArea

Functional area of the primary funding GL account for a given position. This field helps us group positions by functional area of college operations.

DW_CodeDesc

varchar(32)

MD_Pos_PrimaryDiscipline

Discipline for primary position.

DW_CodeDescLong

varchar(64)

MD_Pos_IPEDSReportClass

Overall IPEDS position category (more general; cf. the IPEDS category, which is more specific).

DW_CodeDescLong

varchar(64)

MD_Pos_IPEDSReportClassCode

DW_CodeDescShort

varchar(16)

MD_Pos_IPEDSCategory

Specific IPEDS-defined position category. Must be used in conjunction with the IPEDS report class (meaning the overall reporting category).

DW_CodeDescLong

varchar(64)

MD_Pos_IPEDSCategoryCode

Code (abbreviation) corresponding to MD_Pos_IPEDSCategory.

DW_CodeDescShort

varchar(16)

MD_Pos_MercerSurveyClass

See MD_Pos_MercerSurveyCode.

DW_CodeDescLong

varchar(64)

MD_Pos_MercerSurveyClassCode

This field contains the Mercer Compensation Survey code for a given position (used by HR mainly; possibly IRA and others).

DW_CodeDescShort

varchar(16)

MD_Pos_OldMercerSurveyCode

DW_CodeDescShort

varchar(16)

MD_Pos_ALA_APAJobClass

ALA Allied Professional Association (ALA-APA) position classification. (ALA-APA is an association for library employees.)

DW_CodeDescLong

varchar(64)

1 2 3

Home