MD_Prosp_AvgReaderRatingAcademic

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.

DW_ReaderRatingComponent

varchar(7)

7

MD_Prosp_AvgReaderRatingPersonal

Average Personal rating across all readers rounded to the nearest integer 1-9. Taken from Recruitment Plus DataStuScor table; corresponds to subscore 2 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 personal 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.

DW_ReaderRatingComponent

varchar(7)

7

MD_Prosp_BestMathVerbalScoreRange

Best Math + Verbal (or Critical Reading) score. Note that this attribute is populated for both two-part and three-part SAT tests. Defaults, in the absence of test information, to 'Unknown'.

DW_SATMathVerbalScoreRange

char(9)

9

MD_Prosp_BestSATMathRange

Best overall math section score for SAT I test, renormalized to fit a set of ranges (i.e., discretized score). Note that we don't store self-reported SAT scores. Defaults (if information is missing) to 'Unknown'.

DW_SATSectionScoreRange

char(7)

7

MD_Prosp_BestSATWritingRange

Best overall writing score for SAT I exam, discretized in the sense of being aggregated into a range of scores, like 750-800. Note that we don't store self-reported scores. Defaults to 'Unknown' (which frequently happens in cases when a given SAT test was administered before the Writing component was introduced).

DW_SATSectionScoreRange

char(7)

7

MD_Prosp_BestTOEFLiBTReadingRange

Discretized TOEFL Internet-Based Test of English as a Foreign Language reading score. I.e., this attribute holds a range (like 27-30) instead of an exact TOEFL iBT reading 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'.

DW_TOEFLiBTSectionScoreRange

varchar(12)

12

MD_Prosp_BestTOEFLiBTSpeakingRange

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

DW_TOEFLiBTSectionScoreRange

varchar(12)

12