Renaissance Field | Rethink Field Mapping Points | Logic for Rethink Set Up |
ScaledScore | Scaled Score  | Used in Student View as part of graphs and charts. Scaled scores are different for each grade so graphs need to reflect a starting and ending range that shows the user scaled scores that particular grade and student. (See outside link to Renaissance Benchmark Cut Scores).
Renaissance Field Information: Scaled Score of student’s Star Reading test (0-
1400); this is the Enterprise Scale.
Integer
|
CurrentGrade Grade |  | User CurrentGrade to place student in the correct grade level. Grade can be a back up used for problem solving to identify which grade level assessment was taken. Although Star Reading is given to grades 3 and above, some districts may instead give an older student the Star Early Literacy test because the student’s skills are at that level. Expect some outliers. Given a student has taken the Star Reading, then we will show the Star ELA Tab.
Renaissance Field Information: CurrentGrade Student’s grade enrollment in Renaissance at the
time the extract was run.
Varchar(50)
Grade Grade level of the assessment taken (this may be
adjusted in Renaissance).
Varchar(20)
|
GradeEquivalent | Grade Equivalent  | Renaissance Field Information: Grade Equivalent (GE) value. Grade Equivalent
scores range from 0.0 to 12.9+. They represent
how a student’s test performance compares with
that of other students nationally. A GE score
preceded by a “greater than” sign (>) is a capped
score. GE scores in excess of three grade levels
above the student’s actual grade are capped,
meaning that such GE scores are shown as “>
[student’s actual grade level + 3].” This prevents
the misinterpretation that students with
© 2023 Renaissance Learning, Inc. All rights reserved. | www.renaissance.com R63547.230421 8
Field Description
excessively high GE scores are capable of work
at those higher grades.
Text
|
PercentileRank | Percentile Rank  | Used in several areas including: Student View, Classroom View, Account Settings Percentile Rank (PR) is used to determine the benchmarks categories for Renaissance (At / Above = PR 40, On Watch=PR 25-39, Intervention=PR 10-24, Urgent Intervention=PR below 10) so we are stuck with them for the corresponding text equivalent.
Renaissance Field Information: Percentile rank (PR) value. Norm-referenced
score provides a measure of student’s reading
ability compared to other students in the same
grade nationally; it indicates the percentage of the
students nationally who obtained scores equal to
or lower than the score of the student. Scores
range from 1 to 99.
Integer |
ExtraTime |  | Renaissance Field Information “Yes” if the student was given extra time to complete the test.
varchar(3)
Empty State |
ScreeningWindowStartDate |  | Used to determine the start date for each of the tests: Fall, Winter and Spring. In addition, our settings allow users to change Tier designation BEFORE the testing window begins for Star Early Literacy, Star Literacy and Star Math. (See: Settings) See Star Early Literacy for image in settings.
Renaissance Field Information Start date of screening window (blank if outside of
window).
This will only be populated as long as the school
the assessment is linked to is tied to a screening
window on the site and the assessment taken falls
within that window.
Varchar(max)
|
ScreeningWindowEndDate |
| Used to determine the end date for each of the tests: Fall, Winter and Spring. See Star Early Literacy for example of an empty state in the Student View.
Renaissance Field Information End date of screening window (blank if outside of
window).
This will only be populated as long as the school
the assessment is linked to is tied to a screening
window on the site and the assessment taken falls
within that window.
Varchar(max)
|
ScreeningPeriodWindowName | | We will be combining Star Early Literacy with Star Literacy to show the tier levels in the graph. We need to name each of the seasons for ELA: ELA Fall ELA Winter ELA Spring
Test needs to be given within the testing window in order to count. Field to determine this are: ScreeningWindowStartDate and ScreeningWindowEndDate See: Star Early Literacy for future development example that shows multiple years.
Renaissance Field Information: Name of screening window if test is within the
school’s set screening windows (blank if outside
of screening windows).
This will only be populated as long as the school
the assessment is linked to is tied to a screening
window on the site and the assessment taken falls
within that window.
Varchar(255)
|
SchoolYear |    | Renaissance Field Information Name of the school year in Renaissance.
Varchar(max
|
SchoolYearStartDate | | Important note: We are planning on requiring customers to enter the school year start date and the school year end date in a form when they first start using the product. So we intend to use those user-supplied dates as the “source of truth” for school year start date and school year end date (see Define School Year Settings), not the information supplied by this Renaissance field. This doesn’t show for the user but is used to identify the start of the school year: maybe a useful backup (in case we have trouble getting school year start date from the required form mentioned in the above bullet point) for calculations for Attendance, Incidents--perhaps connect to Powerschool section.
Renaissance Field Information First day of the school year in Renaissance.
Datetime
|
SchoolYearEndDate | | Important note: We are planning on requiring customers to enter the school year start date and the school year end date in a form when they first start using the product. So we intend to use those user-supplied dates as the “source of truth” for school year start date and school year end date (see Define School Year Settings), not the information supplied by this Renaissance field. This doesn’t show for the user but is used to identify the end of the school year: maybe a useful backup (in case we have trouble getting school year end date from the required form mentioned in the above bullet point) for calculations for Attendance, Incidents--perhaps connect to Powerschool section.
Renaissance Field Information Last day of the school year in Renaissance.
Datetime
|
StudentStateID |  | Renaissance Field Information Student’s state ID in Renaissance, blank if not
provided.
Varchar(50)
|
StudentFirstName |  | Renaissance Field Information Student’s first name in Renaissance.
Varchar(50)
|
StudentMiddleName (maybe) | | Renaissance Field Information Student’s middle name in Renaissance.
Varchar(50)
|
StudentLastName | | Renaissance Field Information Student’s last name in Renaissance.
Varchar(50)
|
DistrictSourcedID | | Renaissance Field Information Internal ID for the district used to determine
inserts, updates, and deletes when importing data
from an external source. The mapping of sourced
ID to any specific field may vary by external
source and is only guaranteed for manual
OneRoster imports. CDI populates this field with a
fabricated composite key.
Varchar(max)
|
DistrictStateID | | Renaissance Field Information State ID for the district, blank if not provided by
the district.
Varchar(max)
|
DistrictName |  | Need to make sure the naming conventions are the same as the data we get from the external data sources. Contained in our structuring for District Name in the Admin Reports; map this to existing district name.
Renaissance Field Information Name of the district in Renaissance.
Varchar(max)
|
SchoolName |  | Renaissance Field Information Name of the school where the student tested.
Varchar(max)
|
RenaissanceBenchmarkCategoryName | Category Rating Category names: At / Above, On Watch, Intervention, Urgent Intervention is listed under the Category Rating
 | Renaissance Field Information Renaissance default benchmark categories; these
are standard across all Renaissance customers.
At/Above Benchmark: At/Above 40 PR
Field Description
On Watch: 25 – 39 PR
Intervention: 10 – 24 PR
Urgent Intervention: Below 10 PR
|
GroupOrClassName (We are having trouble finding a field that will match with the Classroom and ensuring that the students are in the proper classroom. GroupOrClassName is the closest we can get. We will most likely need to write something that combines multiple items to ensure that we can map effectively. ) |  | Renaissance Field Information Name of the class or group where the student
tested
|
CompletedDateLocal (Maybe) | Shows in design with the title of the seasons. Contained within each of the tabs for a cumulative view of all the seasons and in column headings. Contained in all dashboards-Admin, Classroom, Student.
 | Renaissance Field Information CompletedDate converted to the time zone
configured for the site where the assessment was
taken. If there is a discrepancy between these two
values, CompletedDate (which is stored as UTC)
is considered authoritative.
Datetime
|
CompletedDate (maybe) | | Renaissance Field Information Date the assessment was completed.
Date and time is reported as UTC (Coordinated
Universal Time); this is the time standard
commonly used across the world.
Datetime
|
CourseSourcedID | | Renaissance Field Information Internal ID for the course used to determine inserts, updates, and
deletes when importing data from an external source. The mapping
of sourced ID to any specific field may vary by external source and
is only guaranteed for manual OneRoster imports. CDI populates
this field with a fabricated composite key.
varchar(max)
|
ClassSourcedID | | Renaissance Field Information Internal ID for the class used to determine inserts, updates, and
deletes when importing data from an external source.
The mapping of sourced ID to any specific field may vary by
external source and is only guaranteed for manual OneRoster
imports. CDI populates this field with a fabricated composite key.
varchar(max)
|
TeacherSourcedID | | Renaissance Field Information Internal ID for the teacher used to determine inserts, updates, and
deletes when importing data from an external source.
The mapping of sourced ID to any specific field may vary by
external source and is only guaranteed for manual OneRoster
imports. CDI populates this field with a human-readable ID.
varchar(max)
|
LaunchDate | | See Settings for ELA and Math. Used to build automation for shutting down the tier customization setting screen once the first launch date has passed. For example, on 7/28/23 district file has a launchdate of 7/28/23, and then logic is built in to recognize the date and turn off the tier customization screen for that district. (date format is “9/19/2022 5:09:45 PM”)
Renaissance Field Information Date the assessment was started.
Date and time is reported as UTC (Coordinated
Universal Time); this is the time standard
commonly used across the world.
Datetime
|
StudentSourcedID | | Renaissance Field Information ID for the student used to determine inserts,
updates, and deletes when importing data from an
external source. The mapping of sourced ID to
any specific field may vary by external source and
is only guaranteed for manual OneRoster imports.
CDI populates this field with a fabricated
composite key, except for users, where it is the
human-readable ID.
This is the “Unique ID” field shown in
Renaissance.
Varchar(max)
|
StudentIdentifier | | Renaissance Field Information Internal student ID. Specified by OneRoster and
intended to contain a human-readable ID. CDI
populates this with the human-readable ID for an
object.
Varchar(max)
|
StudentUserID | | Renaissance Field Information Specified by OneRoster and intended to contain
an optional, machine-readable ID. CDI populates
© 2023 Renaissance Learning, Inc. All rights reserved. | www.renaissance.com R63547.230421 2
Field Description
this with the human-readable ID for an object.
Customers that have imported or manually added
their roster information may not have this value
populated.
Varchar(50)
|
StudentEmail | | Renaissance Field Information Student’s email address in Renaissance.
Varchar(max)
|
Gender BirthDate MultiRace HispanicOrLatino AmericanIndianOrAlaskaNative Asian BlackOrAfericanAmerican NativeHawaiianOrOtherPacificIslander White |  
| We will follow our own records by default and if no demographics is present in our own records, then we will put in what Renaissance has for demographic information. Demographic Information: Need to decide what takes precedence. Renaissance has fields for student demographic information and so do we. Which information do we use for the drop downs filter selection and student profile information? If the demographic information doesn’t match, our users may see different demographic designations for the same student in different places in our platform or even just on MTSS Dashboard.
|
EnrollmentStatus | | Renaissance Field Information Student is either currently Enrolled or Unenrolled.
Varchar(16)
|
DistrictRenaissanceID | | Renaissance Field Information Internal ID for the district created by Renaissance
when the district is first created. Used internally to
link the district to other Renaissance systems.
Varchar(max)
|
DistrictSourcedID | | Renaissance Field Information Internal ID for the district used to determine
inserts, updates, and deletes when importing data
from an external source. The mapping of sourced
ID to any specific field may vary by external
source and is only guaranteed for manual
OneRoster imports. CDI populates this field with a
fabricated composite key.
Varchar(max)
|
SchoolSourcedID | | Renaissance Field Information Internal ID for the school used to determine
inserts, updates, and deletes when importing data
from an external source. The mapping of sourced
ID to any specific field may vary by external
source and is only guaranteed for manual
OneRoster imports. CDI populates this field with a
fabricated composite key.
Varchar(max)
|
CourseCode CourseName | | Renaissance Field Information CourseCode ID of the course where the student tested.
Specified by OneRoster; CDI populates this with
the human-readable ID for an object.
Varchar(max)
CourseName Name of the course where the student tested.
Varchar(max)
|
TeacherEmail TeacherFirstName TeacherLastName | | Renaissance Field Information TeacherEmail Teacher’s email address in Renaissance.
Varchar(max)
TeacherFirstName Teacher’s first name where the student tested.
Varchar(max)
TeacherLastName Teacher’s last name where the student tested.
Varchar(max)
|
RenaissanceBenchmarkCategoryLevel RenaissanceBenchmarkCategoryMinPercentileRank RenaissanceBenchmarkCategoryMaxPercentileRank |  | See also: RenaissanceBenchmarkCategoryName Renaissance Field Information RenaissanceBenchmarkCategoryLevel Number of the benchmark level; the level with the
highest PR, will have the lowest number. For
example, At/Above Benchmark = 1 (uses highest
PR range), On Watch = 2, Intervention = 3, and
Urgent Intervention = 4 (uses lowest PR range).
Varchar(max)
RenaissanceBenchmarkCategoryMinPercentileRank The minimum percentile rank for the benchmark
category level.
Integer
RenaissanceBenchmarkCategoryMaxPercentileRank The maximum percentile rank for the benchmark
category level.
Integer
|
DistrictBenchmarkCategoryName DistrictBenchmarkProficient DistrictBenchmarkCategoryLevel DistrictBenchmarkNumberOfCategoryLevels DistrictBenchmarkMinPercentileRank DistrictBenchmarkMaxPercentileRank | | Renaissance Field Information DistrictBenchmarkCategoryName he benchmark categories used are the
benchmarks defined at the district level in the
Renaissance program.
This score should be considered an individual
level score; the percentile rank for the student’s
assessment is used to determine the benchmark
range the student falls in at the time they took the
assessment.
DistrictBenchmarkProficient Indicates whether the level (and corresponding
assessment) is considered proficient.
Varchar(3)
DistrictBenchmarkCategoryLevel Number of the benchmark level; the level with the
highest PR, will have the lowest number. For
example, At/Above Benchmark = 1 (uses highest
© 2023 Renaissance Learning, Inc. All rights reserved. | www.renaissance.com R63547.230421 15
Field Description
PR range), On Watch = 2, Intervention = 3, and
Urgent Intervention = 4 (uses lowest PR range).
Varchar(max)
DistrictBenchmarkNumberOfCategoryLevels The number of categories that exist, based on
what the district has set as their benchmark
levels. Renaissance allows the district to set this
using 2 to 5 categories. Each category name can
be edited.
Integer
DistrictBenchmarkMinPercentileRank The minimum percentile rank for the benchmark
category level.
Integer
DistrictBenchmarkMaxPercentileRank The maximum percentile rank for the benchmark
category level.
Integer
|
SchoolBenchmarkCategoryName SchoolBenchmarkProficient SchoolBenchmarkCategoryLevel SchoolBenchmarkNumberOfCategoryLevels SchoolBenchmarkMinPercentileRank SchoolBenchmarkMaxPercentileRank | | Renaissance Field Information SchoolBenchmarkCategoryName The benchmark categories used are the
benchmarks defined at the school level in the
Renaissance program.
This score should be considered an individual
level score; the percentile rank for the student’s
assessment is used to determine the benchmark
range the student falls in at the time they took the
assessment
SchoolBenchmarkProficient Indicates whether the level (and corresponding
assessment) is considered proficient.
Varchar(3)
SchoolBenchmarkCategoryLevel Number of the benchmark level; the level with the
highest PR, will have the lowest number. For
example, At/Above Benchmark = 1 (uses highest
PR range), On Watch = 2, Intervention = 3, and
Urgent Intervention = 4 (uses lowest PR range).
Varchar(max)
SchoolBenchmarkNumberOfCategoryLevels The number of categories that exist, based on
what the district has set as their benchmark
levels. Renaissance allows the district to set this
using 2 to 5 categories. Each category name can
be edited.
Integer
SchoolBenchmarkMinPercentileRank The minimum percentile rank for the benchmark
category level.
Integer
SchoolBenchmarkMaxPercentileRank The maximum percentile rank for the benchmark
category level.
Integer
|
| | |