Dict-Physical

View VMF_ReaderRating

Card of view VMF_ReaderRating

Name	VMF_ReaderRating
Comment	See the documentation on MF_ReaderRating. This fact-view is used to ratings issued by Carleton's application readers in their original context. Each row in the VMF_ReaderRating fact-view links to the fact row in the (V)MD_Prospect dimension that was active/current at the time when the activity took place. This is so that we can examine the event in its original context and not after the fact.
Dimensional Type	Fact

SQL query of the view VMF_ReaderRating

SELECT
   MD_PROSP_SURROGATEKEY,
   MD_DATE_DATEINTEGER,
   MD_APPREADER_SURROGATEKEY,
MD_COLLPERS_SURROGATEKEY,
   CONVERT(int, [MF_READRATE_SCORPKID]) AS MF_READRATE_SCORPKID,
   CONVERT(int, [MF_READRATE_ACADEMIC]) AS MF_READRATE_ACADEMIC,
   CONVERT(int, [MF_READRATE_PERSONAL]) AS MF_READRATE_PERSONAL,
   CONVERT(int, [MF_READRATE_OVERALL]) AS MF_READRATE_OVERALL,
   MF_READRATE_COUNT
FROM
   MF_READERRATING

List of outgoing view references of the view VMF_ReaderRating

ViewReference_8

VMD_Prospect

ViewReference_9

VMD_Date

ViewReference_10

VMD_ApplicationReader

ViewReference_51

VMD_DegreeStudentOutcome

List of referenced objects of the view VMF_ReaderRating

MF_ReaderRating

List of diagrams containing the view VMF_ReaderRating

ViewsProspectDiagram

List of permissions of the view VMF_ReaderRating

SELECT,VIEW DEFINITION

ProspectViewReader

List of view columns of the view VMF_ReaderRating

MD_Prosp_SurrogateKey

numeric

MD_Date_DateInteger

int

Integer representation of the date (e.g., 20070101 for 1 Jan 2007). Defaults to 99991231, for situations where a date is required but none is available.

MD_AppReader_SurrogateKey

numeric

MD_CollPers_SurrogateKey

numeric

MF_READRATE_SCORPKID

MF_READRATE_ACADEMIC

MF_READRATE_PERSONAL

MF_READRATE_OVERALL

MF_ReadRate_Count

int

Home