View VMF_SurveyAdminFact

Card of view VMF_SurveyAdminFact

Name

VMF_SurveyAdminFact

Comment

See documentation on VMD_SurveyAdminFact in the StarsSurvey package.

Dimensional Type

Fact


SQL query of the view VMF_SurveyAdminFact

select
MD_SurvAdm_SurrogateKey,
MD_Prosp_SurrogateKey,
MD_DevPers_SurrogateKey,
MD_CollPers_SurrogateKeyEmp,
MD_CollPers_SurrogateKeyDStu,
MF_SAdmin_RespondentReaderRating,
MF_SAdmin_RespondentGPA,
MF_SAdmin_RespondentSATComposite,
MF_SAdmin_RespondentSATMathVerbal,
MF_SAdmin_TermsWithNorthfieldOption,
MF_SAdmin_TermsAsVarsityAthlete,
MF_SAdmin_TermsAsStudentWorker,
MF_SAdmin_TermsInOCS,
MF_SAdmin_PreMatricCredits,
MF_SAdmin_ParentAGI
from
MF_SurveyAdminFact


List of outgoing view references of the view VMF_SurveyAdminFact

Name

Parent Table/View

ViewReference_92

VMD_SurveyAdministration

ViewReference_93

VMD_Employee (Shortcut)

ViewReference_94

VMD_DegreeStudent (Shortcut)

ViewReference_95

VMD_Prospect (Shortcut)


List of diagrams containing the view VMF_SurveyAdminFact

Name

ViewsSurveyDiagram


List of permissions of the view VMF_SurveyAdminFact

Grant

User

SELECT,VIEW DEFINITION

SurveyReader


List of view columns of the view VMF_SurveyAdminFact

Name

Data Type

Comment

Length

MD_SurvAdm_SurrogateKey

numeric

 

 

MD_Prosp_SurrogateKey

numeric

 

 

MD_DevPers_SurrogateKey

numeric

 

 

MD_CollPers_SurrogateKeyEmp

numeric

 

 

MD_CollPers_SurrogateKeyDStu

numeric

 

 

MF_SAdmin_RespondentReaderRating

int

 

 

MF_SAdmin_RespondentGPA

float

 

 

MF_SAdmin_RespondentSATComposite

int

 

 

MF_SAdmin_RespondentSATMathVerbal

int

 

 

MF_SAdmin_TermsWithNorthfieldOption

int

Number of terms respondent was living off-campus in Northfield - "Northfield Option" housing. MAY BE NULL, e.g., if the respondent is/was not a student.

 

MF_SAdmin_TermsAsVarsityAthlete

int

Number of terms a respondent was in a varsity-sport course. MAY BE NULL, e.g., if the respondent is/was not a student.

 

MF_SAdmin_TermsAsStudentWorker

int

Number of terms a respondent served as a student worker. MAY BE NULL, e.g., if the respondent is/was not a student.

 

MF_SAdmin_TermsInOCS

int

Number of terms a respondent was in an off-campus studies program. MAY BE NULL, e.g., if the respondent is/was not a student.

 

MF_SAdmin_PreMatricCredits

int

Number of pre-matriculation credits a given respondent came into Carleton with (pre-matric credits are credits granted up front for things like AP classes). MAY BE NULL, e.g., if the respondent is/was not a student.

 

MF_SAdmin_ParentAGI

money