Dict-Physical

View VMD_SnapshotDate

Card of view VMD_SnapshotDate

Name	VMD_SnapshotDate
Comment	Cut-down version of MD_Date (q.v.). Used with VMF_AwardAmountSnapshot. This is what they call a "role-playing" dimension in the sense that it's really just another projection of the standard date dimension. Typically one would not access this dimension directly, but would, instead, access it via the AidSnapshot MS Analysis Services cube developed for Student Financial Services.
Dimensional Type	Dimension

SQL query of the view VMD_SnapshotDate

SELECT
   CONVERT(INT, MD_Date_DateInteger) AS MD_SNAPDATE_DATEINTEGER,
   MD_Date_SQLDate AS MD_SNAPDATE_SQLDATE,
   MD_Date_DDMONYYYY AS MD_SNAPDATE_DDMONYYYY,
   MD_Date_Year AS MD_SNAPDATE_YEAR,
   MD_DATE_FiscalYear AS MD_SNAPDATE_FISCALYEAR,
MD_DATE_MonthOfFiscalYear AS MD_SNAPDATE_MONTHOFFISCALYEAR,
   MD_Date_MonthNum AS MD_SNAPDATE_MONTHNUM,
   CONVERT(VARCHAR(9), MD_Date_MonthName) AS MD_SNAPDATE_MONTHNAME,
   MD_Date_DayOfMonth AS MD_SNAPDATE_DAYOFMONTH
FROM
MD_Date
WHERE
MD_DATE_DATEINTEGER >= 20090601
AND MD_DATE_SQLDATE <= DATEADD(yyyy, 2, GETDATE())

List of incoming view references of the view VMD_SnapshotDate

ViewReference_22

VMF_AwardAmountSnapshot

List of diagrams containing the view VMD_SnapshotDate

ViewsFinancialAidDiagram

List of permissions of the view VMD_SnapshotDate

SELECT,VIEW DEFINITION

FinancialAidReader

List of view columns of the view VMD_SnapshotDate

MD_SNAPDATE_DATEINTEGER

MD_Date_SQLDate

datetime

SQL date - defaults to the max possible date, 12 Dec 9999 (which should be treated as equivalent to "Unknown" or "not specified").

MD_Date_DDMonYYYY

char(11)

Date formatted like "31 Dec 2008"

MD_Date_Year

int

Year as an integer (i.e., a number, not a string of characters, e.g., "00" or "2008"). The year 9999 indicates a default ("Unknown") date.

MD_Date_FiscalYear

int

Integer fiscal year (2008, 2009, etc.). Note that at Carleton, the fiscal year extending from 1 July 2008 to 30 June 2009 is fiscal year 2009. This contrasts with academic years, which are traditionally designated using a YYYY-YY format (e.g., 2008-09). Fiscal year of 9999 should be taken as "Unknown."

Note that the fiscal year doubles also as the financial aid year, and may also be used for certain official academic-year reporting that needs to include a summer term and that groups this term with the following academic year (as opposed to grouping it with the previous academic year, which matches the usual informal concept of an academic year).

MD_Date_MonthOfFiscalYear

int

Ordinal number of month, starting from the beginning of the fiscal year (July). E.g., September would be 3.

Note that the fiscal year doubles also as the financial aid year, and may also be used for certain official academic-year reporting that needs to include a summer term and that groups this term with the following academic year (as opposed to grouping it with the previous academic year, which matches the usual informal concept of an academic year).

MD_Date_MonthNum

int

Ordinal number of month in year. E.g., March would be 3.

MD_SNAPDATE_MONTHNAME

MD_Date_DayOfMonth

int

Home