MD_Prosp_HighSchool

High school attended by prospect. If more than one were 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.

DW_CommonName

nvarchar(64)

64

MD_Prosp_HighSchoolCEEBCode

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.'

DW_HighSchoolCEEBCode

varchar(7)

7

MD_Prosp_HighSchoolCountry

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.

DW_Addr_Country

nvarchar(64)

64

MD_Prosp_HighSchoolRPlusGeomarket

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

DW_RPlus_Geomarket

nvarchar(64)

64

MD_Prosp_HighSchoolUSState

Name (not abbreviation) for US state. Should follow Colleague naming conventions.

DW_Addr_USState

varchar(24)

24