List of view columns of the view VMD_Prospect

Name

Data Type

Comment

Length

MD_Prosp_PrefSchoolSize

varchar(64)

Prospective student's college preference, with respect to school setting; e.g., (taken from the Recruitment Plus DataStuCust table, the 'Proximity to Home' field). Values include 'Less than 2000 students,' 'More than 5000 students,' etc. Defaults to 'Unknown.'

 

MD_Prosp_PrefSchoolSetting

varchar(64)

Prospective student's college preference, with respect to school setting; e.g., (taken from the Recruitment Plus DataStuCust table, the 'Proximity to Home' field). Values include 'In or near a major city,' 'In small college town,' etc. Defaults to 'Unknown.'

 

MD_Prosp_PrefHowFarFromHome

varchar(64)

Prospective student's college preference, with respect to distance from home (taken from the Recruitment Plus DataStuCust table, the 'Proximity to Home' field). Values include 'Minimum 3 hours by car,' 'Out of state,' 'Undecided/No preference,' etc. Defaults to 'Unknown.'

 

MD_Prosp_Pref1stCriterion

varchar(64)

Prospective student's most important criterion for determining what college to attend (taken from the Recruitment Plus DataStuCust table, the '1st Important' field). Values include 'Career preparation,' 'Class size,' 'Cost,' etc. Defaults to 'Unknown.'

 

MD_Prosp_PrefHowDidYouHear

varchar(64)

How the prospective student heard about Carleton (taken from the Recruitment Plus DataStuCust table). Defaults to 'Unknown.'

 

MD_Prosp_RowStart

datetime

 

 

MD_Prosp_RowEnd

datetime

 

 

MD_Prosp_RowIsCurrent

bit

 

 


1  2  3  4