Dict-Physical

View VMD_SurveyAdministration

Card of view VMD_SurveyAdministration

Name	VMD_SurveyAdministration
Comment	See documentation on MD_SurveyAdministration. Contains information on a particular administration of a particular survey instrument to a particular subject at a particular time. E.g., one row might refer to the 2008 CIRP Freshman survey, taken online by one of our entering freshmen the first day they arrived on campus.
Dimensional Type	Dimension

SQL query of the view VMD_SurveyAdministration

select
MD_SurvAdm_SurrogateKey,
MD_SurvAdm_Version,
MD_SurvAdm_Institution,
MD_SurvAdm_SubjectID,
MD_SurvAdm_Date,
MD_SurvAdm_Name,
MD_SurvAdm_SurveyYear,
MD_SurvAdm_Organization
from
MD_SurveyAdministration

List of incoming view references of the view VMD_SurveyAdministration

ViewReference_85

VMF_SurveyCellData

ViewReference_91

VMF_AnswerToAdministration

ViewReference_92

VMF_SurveyAdminFact

List of diagrams containing the view VMD_SurveyAdministration

ViewsSurveyDiagram

List of permissions of the view VMD_SurveyAdministration

SELECT,VIEW DEFINITION

SurveyReader

List of view columns of the view VMD_SurveyAdministration

MD_SurvAdm_SurrogateKey

numeric

MD_SurvAdm_Version

nvarchar(64)

Many surveys we administer formally at Carleton (and in fact the only ones truly useful for longitudinal analysis) are revised yearly. That is, each year we administer a new version of the survey. This attribute names the survey version. E.g., "CIRP Freshman Survey 2012" (which would mean "the instance of the yearly CIRP Freshman Survey intended for administration during the 2012 calendar year").

The value here need not be lengthy or "official." It is merely a short identifier we can use to identify a unique instance of a survey.

MD_SurvAdm_Institution

nvarchar(64)

Institution being surveyed. Typically this will be "Carleton." But sometimes we get data from other schools.

THIS VARIABLE DOES NOT NAME THE ORGANIZATION THAT DEVELOPED A GIVEN SURVEY, but rather the institution that developed the survey.

The institution helps uniquely identify a given survey administration instance, because the date, subject ID, and survey instance may not be enough, by themselves - if, for example, the organization that developed the instrument did not ensure that subject IDs were globally unique (but rather, e.g., only ensured that they were unique for a given institution).

MD_SurvAdm_SubjectID

varchar(64)

All surveys should attach a subject ID or some identifier to each unique administration of an instrument. Although this should be rare, the same subject may take a survey more than once. For the purposes of this table, though, we assume they can't take it more than once on the same date.

Because people do typically identify themselves, and because this field may not be available in the raw survey data, something should be dreamt up or generated as a placeholder. Do not use a volatile identifier like a NetID. Use a Colleague ID instead.

MD_SurvAdm_Date

int

Date associated with a given survey instrument being administered to a given subject.

If the instrument was administered over the course of more than one day, the value here is the start date, or the best available approximation (if, e.g., we don't have the exact date when one particular subject responded, but only the start date when the instrument became available to a group of people).

If the exact date is not known, an approximation is used instead (e.g., 1 September of the year in which the survey was administered for CIRP).

MD_SurvAdm_Name

nvarchar(64)

General survey name, like "CIRP Freshman Survey." Typically, surveys we administer for the purposes of assessment require repeated (yearly) administration in order to provide useful longitudinal data. So, although we may administer different versions of it, we are in essence administering the same survey.

This attribute names the survey - not the particular version we use an a givenyear. E.g., it would contain a string like "CIRP Freshman Survey," not "CIRP Freshman Survey, 2009" (cf. MD_SurvInst_Version).

MD_SurvAdm_SurveyYear

int

Year associated with a particular survey version. E.g., each year HERI comes up with a new version of its CIRP survey, which becomes available, typically, in March. We administer that year's survey in the fall to the new freshman class. In this case, this attribute would designate the year in which the CIRP survey was developed. Theoretically the instrument would also be administered that same year, but that is not assumed here.

This attribute is not intended for heavy duty analysis. It's just another way to identify and group surveys (e.g., "Give me all surveys defined for year X.").

Defaults to 9999 (if the survey is a one-off or not associated with a particular year).

MD_SurvAdm_Organization

nvarchar(64)

Organization that maintains a given survey (e.g., HERI, the Higher Education Research Institute) manages the CIRP Freshman Survey. So in that case the value here, in that case, would be "HERI." For surveys developed and maintained by Carleton College, use the value "Carleton."

Short names easily selected in pivot tables or printed in reports are to be preferred over full organization names. Remember that the data here is being used for analysis and reporting, not operational, purposes.

NOTE THAT THIS VARIABLE DOES NOT NAME THE INSTITUTION BEING SURVEYED, but rather the organization that developed the survey.

Home