Table MF_PerYearCarletonStats

Card of table MF_PerYearCarletonStats

Name

MF_PerYearCarletonStats

Dimensional Type

Fact

Comment

Institutional statistics like fall FTE student enrollment as reported to IPEDS, total fall student headcount, annual operating expenses. These stats are all reported at the academic/fiscal year level (these being close to the same thing). Consumer Price Index-based normalization values are also provided here, which allow financial and other figures to be reported using constant dollars, adjusted for inflation.

These stats are used in various key performance indicators and metrics. For example, the fall FTE student enrollment as reported to IPEDS is used as a divisor in NACUBO financial comparisons (per-student numbers are better for cross-institutional comparison than raw numbers).

Most of the data in this table will need to be hand entered because generating official numbers at Carleton as of 2012 is often more of an art than a science, requiring special cross-department coordination and hand spreadsheet work. This is unfortunate, and should be changed, but in practice will not change unless there is significant impetus to do so. Fortunately there aren't a lot of such numbers to enter. Also, it's possible to have ETL jobs automatically fill in data that isn't already present with at least rough default values (which has been done as of Jan 2012).

Because of the hand entry, and because of timing issues, ALL FACTS IN THIS TABLE MAY, POTENTIALLY, BE NULL.

Note also that fiscal years are typically named after the second year in the two-year span covered by each fiscal year. So, e.g., fiscal 2010-11 = 2011. Aid years, by way of contrast, are typically named according to the first of the two years. So, e.g., fiscal 2011 = aid year 2010. This table uses fiscal years. Be mindful of the difference!

Finally, note that this table (unlike most of the tables in the data warehouse) is writable by a small group of users, who may want to update figures like fall student enrollments and operating budget figures.


Check constraint name of the table MF_PerYearCarletonStats

CKT_MF_PERYEARCARLETONSTATS


List of diagrams containing the table MF_PerYearCarletonStats

Name

DimsOtherDiagrams


List of permissions of the table MF_PerYearCarletonStats

Grant

User

SELECT,INSERT,UPDATE,REFERENCES,VIEW DEFINITION

BusinessReader

SELECT,INSERT,UPDATE,REFERENCES,VIEW DEFINITION

BusinessReader


List of columns of the table MF_PerYearCarletonStats

Name

Comment

Domain

Data Type

Length

MF_CarlYrStats_FiscalYear

This is the date/integer format for the fiscal year. Recall that the fiscal year is named after the second of the two calendars years that each fiscal year spans. That is, fiscal 2010-11 is recorded here as 2011.

Note that the aid year is typically referred to by the starting year. So, e.g., fiscal 2011 = aid year 2010.

DW_YearAtCarleton

int

 

MF_CarlYrStats_CpiUYrAvg1983Dollars

The US Consumer Price Index for all urban consumers (CPI-U), as published by the U.S. Department Of Labor, Bureau of Labor Statistics. This is the US city average for all items, scaled so that the value for 1982-1984 = 1.00 (the actual CPI-U has 100; the figure here is divided by 100 to make for easy calculations). See ftp://ftp.bls.gov/pub/special.requests/cpi/cpiai.txt

The figure presented here is the average value for the CALENDAR year forming the first component of the fiscal year. For example, for fiscal year 2011, the value stored here will be the CPI-U average (divided by 100) for calendar 2010. There is another attribute for the fiscal-year average. There is also another attribute for December's average (in this case, it would be for Dec 2010, mid-way through the fiscal year).

The 1983 scaling is what the Department of Labor publishes. Also available is scaling based on the current year.

<None>

float

 

MF_CarlYrStats_CpiUFYAvg1983Dollars

Like MF_CarlYrStats_CpiUCurYrAvg, except that it reflects the average CPI-U for the fiscal year (July - June). For the current fiscal year, averages are naturally incomplete.

<None>

float

 

MF_CarlYrStats_CpiUDec1983Dollars

The US Consumer Price Index for all urban consumers (CPI-U), as published by the U.S. Department Of Labor, Bureau of Labor Statistics. This is the US city average for all items, scaled so that the value for 1982-1984 = 1.00 (the actual CPI-U has 100; the figure here is divided by 100 to make for easy calculations). See ftp://ftp.bls.gov/pub/special.requests/cpi/cpiai.txt

The figure presented here is the December value, i.e., for the December that fell in the middle of the applicable fiscal year. The average for the year is also available, as is the average for the fiscal year. If we are not yet to December in the fiscal year, the most recent available month's CPI-U value is substituted.

The 1983 scaling is what the Department of Labor publishes. Also available is scaling based on the current year.

<None>

float

 

MF_CarlYrStats_CpiUYrAvgCurrentDollars

The US Consumer Price Index for all urban consumers (CPI-U), as published by the U.S. Department Of Labor, Bureau of Labor Statistics, NORMALIZED USING CURRENT DOLLARS, RATHER THAN THE 1983-DOLLAR DEFAULT USED BY THE Dept of Labor. By "current dollars" we mean the average CPI-U for as much of the year as is available.

The CPI-U is the US city average for all items, scaled so that the value for the current fiscal year = 1.00 (the actual CPI-U has 100; the figure here is divided by 100 to make for easy calculations). See ftp://ftp.bls.gov/pub/special.requests/cpi/cpiai.txt

The figure offered here is the average for the year that ends in the middle of the fiscal year. That is, if it is fiscal year 2012 (2011-12, that is), the figure here is for calendar year 2011. If it is, say, November, the average here for the calendar year ending in December will naturally be incomplete.

<None>

float

 

MF_CarlYrStats_CpiUFYAvgCurrentDollars

Like MF_CarlYrStats_CpiUYrAvgCurrentDollars, except that it reflects the average for the current fiscal year (July - June), and in fact matches the grain of this fact table (which goes by fiscal years).

Naturally, we can only use as much of the current fiscal year as is actually available.

<None>

float

 

MF_CarlYrStats_CpiUDecCurrentDollars

The US Consumer Price Index for all urban consumers (CPI-U) for December of the fiscal year (or the most recent month available, if the fiscal year is the current one and we're not yet to December), as published by the U.S. Department Of Labor, Bureau of Labor Statistics, NORMALIZED USING CURRENT DOLLARS, RATHER THAN THE 1983-DOLLAR DEFAULT USED BY THE Dept of Labor.

The CPI-U is the US city average for all items, scaled so that the value for the current fiscal year = 1.00 (the actual CPI-U has 100; the figure here is divided by 100 to make for easy calculations). See ftp://ftp.bls.gov/pub/special.requests/cpi/cpiai.txt

The figure offered here is the December value for the year that ends in the middle of the fiscal year. That is, if it is fiscal year 2012 (2011-12, that is), the figure here is for December of calendar year 2011. If we are not yet to December in the current fiscal year, then the figure given here will be for the most recent available month.

<None>

float

 

MF_CarlYrStats_OperatingExpenses

Operating expenses for a given fiscal year. This really isn't a "budget" figure, except for the current fiscal year (when it should contain the approved operating budget). The figure given here otherwise is actual expenses for the fiscal year. This is a good, audited number that we publish yearly, and that normally lags behind the operating budget by just a few percentage points.

Figures are taken from auditors' reports published at http://apps.carleton.edu/campus/treasurer/statements/. Budget figures for the current year is taken from http://apps.carleton.edu/campus/economy/documents/.

<None>

money

 

MF_CarlYrStats_FallDStuEnroll

Fall degree-seeking student enrollment as reported to IPEDS as of census date. This figure, as of 2011, has always been a simple integer, even though the data type of this field is a floating point number, to allow for fractions.

Used by organizations such as NACUBO as a divisor in cross-institutional financial and other comparisons (where per-student numbers are of greater value than raw values).

Because Carleton tends to have lower enrollments in the fall, because of off-campus programs and other such activities, our Office of the Treasurer typically substitutes the average enrollment across all three terms for this value. That average is not typically used in reporting, however, and for most purposes the fall figure is best (and also largest).

This figure is not, as of 2012, calculated. Rather, it is entered here manually, based on Institutional Research and Assessment reports. If fall census date has passed an no figure is available here, a rough approximation (which is calculated) will be added. This approximation should be replaced (along with the value for MF_CarlYrStats_FallEnrollment) with official figures.

<None>

float

 

MF_CarlYrStats_DStuEnrollAvg

Average full-time degree seeking student enrollment count across all three terms, fall, winter, and spring, for a given academic year. Normally this figure is around 2000.

This figure is not what's typically utilized to normalize financial figures, e.g., by organizations like NACUBO, but because we tend to have lower enrollments at Carleton in the fall, due to off-campus programs and other such activities, our Office of the Treasurer uses this figure instead of the fall enrollment to normalize figures they release.

<None>

float

 

MF_CarlYrStats_FallEnrollment

This is the total number of enrolled undergraduates. Informally we refer to this as a headcount.

Cf MF_CarlYrStats_FallDStuEnroll, which counts only degree-seeking students.

This figure is not, as of 2012, calculated. Rather, it is entered here manually, based on Institutional Research and Assessment reports. If fall census date has passed an no figure is available here, data warehouse ETL scripts will send a warning message to dw-admin.

<None>

float

 

MF_CarlYrStats_EnrollmentAvg

Like the MF_CarlYrStats_FallEnrollment, but averaged across all three major terms. This is a student headcount, and includes non-degree students.

<None>

float

 

MF_CarlYrStats_AuditKey

 

DW_AuditKey

bigint

 

MF_CarlYrStats_Timestamp

 

<None>

timestamp

 

MF_CarlYrStats_FiscalYear

This is the date/integer format for the fiscal year. Recall that the fiscal year is named after the second of the two calendars years that each fiscal year spans. That is, fiscal 2010-11 is recorded here as 2011.

Note that the aid year is typically referred to by the starting year. So, e.g., fiscal 2011 = aid year 2010.

DW_YearAtCarleton

int

 

MF_CarlYrStats_CpiUYrAvg1983Dollars

The US Consumer Price Index for all urban consumers (CPI-U), as published by the U.S. Department Of Labor, Bureau of Labor Statistics. This is the US city average for all items, scaled so that the value for 1982-1984 = 1.00 (the actual CPI-U has 100; the figure here is divided by 100 to make for easy calculations). See ftp://ftp.bls.gov/pub/special.requests/cpi/cpiai.txt

The figure presented here is the average value for the CALENDAR year forming the first component of the fiscal year. For example, for fiscal year 2011, the value stored here will be the CPI-U average (divided by 100) for calendar 2010. There is another attribute for the fiscal-year average. There is also another attribute for December's average (in this case, it would be for Dec 2010, mid-way through the fiscal year).

The 1983 scaling is what the Department of Labor publishes. Also available is scaling based on the current year.

<None>

float

 

MF_CarlYrStats_CpiUFYAvg1983Dollars

Like MF_CarlYrStats_CpiUCurYrAvg, except that it reflects the average CPI-U for the fiscal year (July - June). For the current fiscal year, averages are naturally incomplete.

<None>

float

 

MF_CarlYrStats_CpiUDec1983Dollars

The US Consumer Price Index for all urban consumers (CPI-U), as published by the U.S. Department Of Labor, Bureau of Labor Statistics. This is the US city average for all items, scaled so that the value for 1982-1984 = 1.00 (the actual CPI-U has 100; the figure here is divided by 100 to make for easy calculations). See ftp://ftp.bls.gov/pub/special.requests/cpi/cpiai.txt

The figure presented here is the December value, i.e., for the December that fell in the middle of the applicable fiscal year. The average for the year is also available, as is the average for the fiscal year. If we are not yet to December in the fiscal year, the most recent available month's CPI-U value is substituted.

The 1983 scaling is what the Department of Labor publishes. Also available is scaling based on the current year.

<None>

float

 

MF_CarlYrStats_CpiUYrAvgCurrentDollars

The US Consumer Price Index for all urban consumers (CPI-U), as published by the U.S. Department Of Labor, Bureau of Labor Statistics, NORMALIZED USING CURRENT DOLLARS, RATHER THAN THE 1983-DOLLAR DEFAULT USED BY THE Dept of Labor. By "current dollars" we mean the average CPI-U for as much of the year as is available.

The CPI-U is the US city average for all items, scaled so that the value for the current fiscal year = 1.00 (the actual CPI-U has 100; the figure here is divided by 100 to make for easy calculations). See ftp://ftp.bls.gov/pub/special.requests/cpi/cpiai.txt

The figure offered here is the average for the year that ends in the middle of the fiscal year. That is, if it is fiscal year 2012 (2011-12, that is), the figure here is for calendar year 2011. If it is, say, November, the average here for the calendar year ending in December will naturally be incomplete.

<None>

float

 

MF_CarlYrStats_CpiUFYAvgCurrentDollars

Like MF_CarlYrStats_CpiUYrAvgCurrentDollars, except that it reflects the average for the current fiscal year (July - June), and in fact matches the grain of this fact table (which goes by fiscal years).

Naturally, we can only use as much of the current fiscal year as is actually available.

<None>

float

 

MF_CarlYrStats_CpiUDecCurrentDollars

The US Consumer Price Index for all urban consumers (CPI-U) for December of the fiscal year (or the most recent month available, if the fiscal year is the current one and we're not yet to December), as published by the U.S. Department Of Labor, Bureau of Labor Statistics, NORMALIZED USING CURRENT DOLLARS, RATHER THAN THE 1983-DOLLAR DEFAULT USED BY THE Dept of Labor.

The CPI-U is the US city average for all items, scaled so that the value for the current fiscal year = 1.00 (the actual CPI-U has 100; the figure here is divided by 100 to make for easy calculations). See ftp://ftp.bls.gov/pub/special.requests/cpi/cpiai.txt

The figure offered here is the December value for the year that ends in the middle of the fiscal year. That is, if it is fiscal year 2012 (2011-12, that is), the figure here is for December of calendar year 2011. If we are not yet to December in the current fiscal year, then the figure given here will be for the most recent available month.

<None>

float

 

MF_CarlYrStats_OperatingExpenses

Operating expenses for a given fiscal year. This really isn't a "budget" figure, except for the current fiscal year (when it should contain the approved operating budget). The figure given here otherwise is actual expenses for the fiscal year. This is a good, audited number that we publish yearly, and that normally lags behind the operating budget by just a few percentage points.

Figures are taken from auditors' reports published at http://apps.carleton.edu/campus/treasurer/statements/. Budget figures for the current year is taken from http://apps.carleton.edu/campus/economy/documents/.

<None>

money

 

MF_CarlYrStats_FallDStuEnroll

Fall degree-seeking student enrollment as reported to IPEDS as of census date. This figure, as of 2011, has always been a simple integer, even though the data type of this field is a floating point number, to allow for fractions.

Used by organizations such as NACUBO as a divisor in cross-institutional financial and other comparisons (where per-student numbers are of greater value than raw values).

Because Carleton tends to have lower enrollments in the fall, because of off-campus programs and other such activities, our Office of the Treasurer typically substitutes the average enrollment across all three terms for this value. That average is not typically used in reporting, however, and for most purposes the fall figure is best (and also largest).

This figure is not, as of 2012, calculated. Rather, it is entered here manually, based on Institutional Research and Assessment reports. If fall census date has passed an no figure is available here, a rough approximation (which is calculated) will be added. This approximation should be replaced (along with the value for MF_CarlYrStats_FallEnrollment) with official figures.

<None>

float

 

MF_CarlYrStats_DStuEnrollAvg

Average full-time degree seeking student enrollment count across all three terms, fall, winter, and spring, for a given academic year. Normally this figure is around 2000.

This figure is not what's typically utilized to normalize financial figures, e.g., by organizations like NACUBO, but because we tend to have lower enrollments at Carleton in the fall, due to off-campus programs and other such activities, our Office of the Treasurer uses this figure instead of the fall enrollment to normalize figures they release.

<None>

float

 

MF_CarlYrStats_FallEnrollment

This is the total number of enrolled undergraduates. Informally we refer to this as a headcount.

Cf MF_CarlYrStats_FallDStuEnroll, which counts only degree-seeking students.

This figure is not, as of 2012, calculated. Rather, it is entered here manually, based on Institutional Research and Assessment reports. If fall census date has passed an no figure is available here, data warehouse ETL scripts will send a warning message to dw-admin.

<None>

float

 

MF_CarlYrStats_EnrollmentAvg

Like the MF_CarlYrStats_FallEnrollment, but averaged across all three major terms. This is a student headcount, and includes non-degree students.

<None>

float

 

MF_CarlYrStats_AuditKey

 

DW_AuditKey

bigint

 

MF_CarlYrStats_Timestamp

 

<None>

timestamp

 


List of indexes of the table MF_PerYearCarletonStats

Name

Unique

Cluster

Primary

Foreign Key

Alternate Key

Table

MF_PERYEARCARLETONSTATS_PK

TRUE

TRUE

TRUE

FALSE

FALSE

MF_PerYearCarletonStats

MF_PERYEARCARLETONSTATS_PK

TRUE

TRUE

TRUE

FALSE

FALSE

MF_PerYearCarletonStats


List of keys of the table MF_PerYearCarletonStats

Name

Identifier_1

Identifier_1


Previous
Home
Next