MD_Prosp_BestTOEFLiBTSpeakingRange

varchar(12)

Discretized TOEFL Internet-Based Test of English as a Foreign Language speaking component score. I.e., this attribute holds a range (like 27-30) instead of an exact TOEFL iBT speaking score (e.g., 28). Ranges are easier to use than raw scores as labels on graphs or reports. Defaults, if no TOEFL information is available, to 'Unknown'.

MD_Prosp_HighSchoolCluster

varchar(7)

High School cluster assigned by the College Board. Not used at Carleton as of 2008, but we expect this to change.

Used to provide aggregate stats on similar (grouped) schools. To get these groupings, one must buy Descriptor PLUS from the College Board. The College Board allocates 5 characters max for the cluster; we allocate 7 so we can include "Unknown."

MD_Prosp_HighSchoolCEEBCode

varchar(7)

College Board unique identifier for prospect's high school. If more than one was attended, we take the one marked 'Active' by Admissions. If multiple are marked Active, we take the one from which a diploma was received. If diplomas were received from more than one HS (or no diploma was received), take the most recent of these. Otherwise, pick randomly (this actually should not happen; typically there is one Active High School). Taken from the DataStuHschOrg view in Recruitment Plus.

If the CEEB code is unknown, it is marked as 'Unknown.'

MD_Prosp_HighSchool5DigitUSZip

char(5)

MD_Prosp_HighSchoolCountry

nvarchar(64)

Full name (not code) for country. Uses Colleague country naming conventions. 'Unknown' if the country is not available.

Note that country data for high schools of prospective students, especially ones who are only 'suspects' (early in the admissions cycle - not applicants or admits) may not be wholly reliable, because we obtain their addresses from third parties who don't consistently mark the country. This will be true especially for high schools not in the US.

MD_Prosp_HighSchoolRPlusGeomarket

nvarchar(64)

Full name of geomarket in which prospective student's high school is located. Not the code.

MD_Prosp_ApplicationRequirementRule

varchar(32)

Specifies what set of requirements are applied to the application. Example values: Regular Decision, Transfer, Winter Early Decision.

MD_Prosp_HasFinancialAidNeedNextYear

varchar(7)

"Yes" if a student has financial aid need for the next academic year (for the upcoming fall, if before October 1; otherwise, for the academic year beginning the next fall). "No" if not. "Unknown" if we don't know (yet). It is typically used when generating statistics in the spring and early summer on students whose projected entry term is the upcoming fall. Use it for other purposes at your own peril.

By "next year" (in HasFinancialAidNextYear) we mean the upcoming academic year, beginning in September.

This attribute is populated with information received from the federal government, College Board, etc.

This attribute gets updated continuously with a "Yes" or "No" value, even after a student has matriculated—although it is only typically used for incoming students during the spring before their projected entry term in the fall (applicants, matriculants, etc.). Its value will revert to "Unknown" when the applicant is no longer in the applicant file in Colleague (or was never there in the first place), or his/her applicant information is no longer pushed from Colleague to the ODS.

This attribute was only added to the data warehouse on May 10, 2009. All rows added to the warehouse before this date will be "Unknown."

To look more closely at need numbers for given students across various terms and years, do not use this attribute. Use the Student Financial Services cubes/data marts.

MD_Prosp_PrimaryRecruitedSport

varchar(32)

Name of main/primary sport for which a prospective student was recruited, i.e., the sport for which a prospective student received the highest PEAR ranking, if that ranking is higher than 3 (we don't consider prospects rated 3 or lower to have been actively recruited for a given sport). If the highest rating was received for more than one sport, we pick one of the sports randomly. This is the definition of "recruited athlete" we also use for the College Sports Project study.

The sport is taken from DataStuIntr in Recruitment Plus, specifically the 'Interest' field (where InterestCat = 'Athletics'). The rating is taken from the first digit of the IntrComment field in the DataStuIntr view in Recruitment Plus (again, where InterestCat = 'Athletics'). Coaches sometimes give out '+' and "range" ratings (e.g., 1+ or 2-3), but we take here only the first digit for simplicity's sake.

For reporting to NCAA, CSP, etc., the sport names will need to be converted to NCAA codes. The sport listed here may or may not correspond to a Carleton varsity sport, although it usually will.

MD_Prosp_AvgReaderRatingAcademic

varchar(7)

Average Academic rating across all readers rounded to the nearest integer 1-9. Taken from Recruitment Plus DataStuScor table; corresponds to subscore 1 for Reader Rating. If nobody has read the prospective student's application, then the value here will be "Unknown." Note that this attribute is meant to be used as a label on a graph, or as a way of classifying students into groups (those with a reader academic rating of X, those with a rating of Y, etc.). For exact summing and averaging, consult Recruitment Plus directly or ask the data warehouse team if an appropriate fact table is available.

MD_Prosp_AvgReaderRatingOverall

varchar(12)

Total/aggregate reader rating score. Calculated from Academic and Personal score. Averaged across all total Reader Rating scores, across all readers (0 to 3 readers), then discretized into ranges, 1-2, 3-4, etc. If nobody has read the prospective student's application, then the value here will be "Unknown." Note that this attribute is meant to be used as a label on a graph, or as a way of classifying students into groups (those with a rating of X, those with a rating of Y, etc.). For exact summing and averaging, consult Recruitment Plus directly or ask the data warehouse team if an appropriate fact table is available.

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_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_RowStart

datetime

MD_Prosp_RowIsCurrent

bit