|
Name |
Comment |
Domain |
Data Type |
Length |
|
MD_Prosp_RatingRange |
Admissions rating (not ReaderRating). It's the sum of points assigned to various activities by Admissions, discretized into ranges, 0-5, 6-12, 13-20, etc. More points mean that a student has completed more steps and done more things. |
DW_AdmissionsRatingRange |
varchar(8) |
8 |
|
MD_Prosp_PrefSchoolSize |
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.' |
DW_CodeDescLong |
varchar(64) |
64 |
|
MD_Prosp_PrefSchoolSetting |
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.' |
DW_CodeDescLong |
varchar(64) |
64 |
|
MD_Prosp_PrefHowFarFromHome |
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.' |
DW_CodeDescLong |
varchar(64) |
64 |
|
MD_Prosp_Pref1stCriterion |
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.' |
DW_CodeDescLong |
varchar(64) |
64 |
|
MD_Prosp_PrefHowDidYouHear |
How the prospective student heard about Carleton (taken from the Recruitment Plus DataStuCust table). Defaults to 'Unknown.' |
DW_CodeDescLong |
varchar(64) |
64 |
|
|
|