Assessment Fact Extract

Select Schools

Choose one of the following:

• Current School Only – Includes all student records associated with the current school that meet the selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.
• All Schools – Includes all student records on the PowerSchool server that meet the selection criteria.

Select Students

Choose one of the following:

• The Selected [x] Students Only – Run the report for students in the current selection.
• All Students – Run the report for all students in the current school or district.

Submittal Cycle

Choose a reporting period from the pop-up menu:

• 40D
• 80D
• 120D
• EOY
• Summer

Select Start Date

Enter the start date of the report.

Select End Date

Enter the end date of the report.

Report Mode

Choose one of the following:

• Extract – Choose this option to run the extract version this report, which includes only the columns/fields required for submission to the state.
• Audit – Choose this option to run the audit version of this report, which includes only the columns/fields for the purpose of reviewing assessment fact data. Run the audit version of the report to verify data before running the extract version.

Extract records that have been submitted to STARS already?

Choose one of the following:

• No – Choose this option if records that have the “STARS Submitted...” fields populated from a prior report run should be excluded.
• Yes – Choose this option if records that have the “Submitted to STARS” field populated from a prior report run should be included.

Update STARS Submitted Report & STARS Submitted Date for Assessment Fact records?

Choose one of the following:

• No – Choose this option to leave the “STARS Submitted...” fields as-is.
• Yes – Choose this option to update the fields "STARS Submitted Report" and "STARS Submitted Date" on the New/Edit Assessment Fact Record page (Start Page > Student > State/Province – NM > Assessment Fact > Edit/New). The STARS Submitted Report field is updated with the submittal cycle chosen at report runtime (40D, 80D, 120D, or EOY). The STARS Submitted Date field is updated with the date associated with the selected reporting period.

Notes:

• Setting this parameter to 'Yes' will indicate the records have been submitted and should not be pulled again.
• When processed in Audit mode, the report returns all records that have and have not been submitted to STARS.

Choose one of the following:

• No – Choose this option to exclude records that have a 'When Created Date' within the reporting cycle.
• Yes – Choose this option to include records that have a 'When Created Date' within the reporting cycle (regardless of the Test Date value).

1

State Student Number

The state issued student identification number.

[Students]State_StudentNumber

N/A

2

Student Name

The student’s name.

[Students]First_Name

[Students]Middle_Name

[Students]Last_Name

N/A

3

School Number

The school number associated with the student.

[Schools]School_Number

N/A

4

Enroll Status

The student’s current status at the school.

Valid values:

• -1 – Pre-Registered
• 0 – Active
• 1 – Inactive
• 2 – Transferred Out
• 3 – Graduated
• 4 – Imported as Historical

Any other value is considered inactive.

[Students]Enroll_Status

N/A

5

Test Description

A description of the test.

Note: This value will always be “EOC” for End of Course Test records.

[S_NM_STU_AssessmentFact_C]TestDescription

For CCR Records:

[Tests]Name

N/A

6

Assessment School Year Date

This value is automatically extracted as June 30^th. The report determines the year by referencing the Assessment School Year Date field on the eScholar Assessment Fact Record student page.

The value is extracted in the format YYYY-MM-DD.

[S_NM_STU_AssessmentFact_C]AssessmentSchoolYear

For CCR Records:

[Terms]LastDay (year value)

For EOC Records:

[Terms]LastDay (year value)

N/A

7

Item Description

See the STARS Manual Volume 2 document available at https://webnew.ped.state.nm.us/bureaus/information-technology/stars-manual/ for a list of valid values.

[S_NM_STU_AssessmentFact_C]ItemDescription

For CCR Records:

[TestScore]Name

For EOC Records:

[S_NM_CRS_X]EOCTestSub

[StoredGrades]GPA_Custom1

N/A

8

Test Date

This value is extracted from the Test Date field on the eScholar Assessment Fact Record student page.

The value is extracted in the format YYYY-MM-DD.

[S_NM_STU_AssessmentFact_C]TestDate

For CCR Records:

[StudentTest]Test_Date

For EOC Records:

[S_NM_SGR_X]EOCTestDate

N/A

9

Score (Raw Score)

Score of administered test. Need not be a RAW Score.

Note: This will only report for CCR and EOC records.

For CCR Records:

[StudentTestScore]NumScore

For EOC Records:

[StoredGrades]Grade

N/A

10

Standard Achieved Score

Indicates whether the assessment standard was achieved.

See the STARS Manual Volume 2 document available at https://webnew.ped.state.nm.us/bureaus/information-technology/stars-manual/ for a list of valid values.

Note: This will always be blank for CCR and EOC records.

[S_NM_STU_AssessmentFact_C]StandardAchievedCode

N/A

11

Scoring Model Code

The measurement used to determine the outcome of the Early Childhood Assessment.

This field is required if Test Description is Early Childhood or DDA.

Valid values for Early Childhood:

• BRIG – Brigrance
• CC – Creative Curriculum
• WORK – Work Sampling
• PETITION – Petition to NMPED

Valid values for DDA:

• DLDSC = Dual Discrepancy Model Assessment

Other valid values are:

NMPKOA – NM PreK Observational Assessment

Note: This will always be blank for CCR and EOC records.

[S_NM_STU_AssessmentFact_C]ScoringModelCode

N/A

12

STARS Submitted Code

The submittal cycle chosen at report runtime. This is the value updated in the STARS Submitted Report field on the New/Edit eScholar Assessment Fact Record page if “Yes” is chosen for “Submitted STARS.”

Valid values:

• 40D
• 80D
• 120D
• EOY

Note: This will always be blank for CCR and EOC records.

N/A

N/A

12

STARS Submitted Date

The current date. This is the value updated in the STARS Submitted Date field on the New/Edit eScholar Assessment Fact Record page if “Yes” is chosen for “Submitted STARS.”

Note: This will always be blank for CCR and EOC records.

N/A

N/A

1

District Code

PED assigned three-digit district number.

[Prefs]Name=DistrictNumber

[Prefs]Value

1/8

2

Test Description

A description of the test.

Valid Values For Virtual Record Assessment Fact records:

• EARLY CHILDHOOD = Early Childhood Assessment
• HL = Home/Heritage Language (language other than English)

• NMELPAPT = New Mexico English Language Proficiency Assessment Placement Test
• SAT – Student Assistance Team referral

Valid Value for EOC (End of Course) Assessment Fact records: This value will always be “EOC” for End of Course Test records.

Valid Values for CCR (Career College Readiness) Assessment Fact Records:

See Test Set Up and Reporting Career College Readiness Scores for a complete list of valid CCR Test Names.

Virtual Record Assessment Fact Records:

[S_NM_STU_AssessmentFact_C]TestDescription

For EOC (End of Course) Assessment Fact records:

Always “EOC”.

ForCCR (Career College Readiness) Assessment Fact Records

[Tests]Name

9/23

3

Assessment School Year Date

This value is automatically extracted as June 30^th. The report determines the year by referencing the Assessment School Year Date field on the eScholar Assessment Fact Record student page.

The value is extracted in the format YYYY-MM-DD.

[S_NM_STU_AssessmentFact_C]AssessmentSchoolYear

For CCR Records:

[Terms]LastDay (year value)

For EOC Records:

[Terms]LastDay (year value)

24/33

4

Item Description

See the STARS Manual Volume 2 document available at https://webnew.ped.state.nm.us/bureaus/information-technology/stars-manual/ for a list of valid values.

[S_NM_STU_AssessmentFact_C]temDescription

For CCR Records:

[TestScore]Name

For EOC Records:

[S_NM_CRS_X]EOCTestSub

[StoredGrades]GPA_Custom1

34/83

5

Test Date

This value is extracted from the Test Date field on the eScholar Assessment Fact Record student page.

The value is extracted in the format YYYY-MM-DD.

[S_NM_STU_AssessmentFact_C]TestDate

For CCR Records:

[StudentTest]Test_Date

For EOC Records:

[S_NM_SGR_X]EOCTestDate

84/93

6

Student ID

The state assigned student identification number.

[Students]State_StudentNumber

[S_NM_STU_AssessmentFact_C]foreignKey

94/105

7

Location Code

The PED assigned three-digit school number.

The alternate school number field is extracted if populated.

[S_NM_STU_X]LocationCode

or,

[Students]SchoollDor

[ReEnrollments]SchoolIDor

[Schools]Alternate_School_Number

106/111

8

N/A

Not collected.

N/A

112/117

9

N/A

Not collected.

N/A

118/123

10

N/A

Not collected.

N/A

124/131

11

N/A

Not collected.

N/A

132/139

12

N/A

Not collected.

N/A

140/147

13

N/A

Not collected.

N/A

148/155

14

N/A

Not collected.

N/A

156/158

15

N/A

Not collected.

N/A

159/178

16

N/A

Not collected.

N/A

179/182

17

Standard Achieved Code

Indicates whether the assessment standard was achieved.

See the STARS Manual Volume 2 document available at https://webnew.ped.state.nm.us/bureaus/information-technology/stars-manual/ for a list of valid values.

Note: This value will be blank for Early Childhood – Entry Assessment Fact records.

[S_NM_STU_AssessmentFact_C]StandardAchievedCode

183/186

18

N/A

Not collected.

N/A

187/193

19

Score (Raw Score)

Score of administered test. Need not be a RAW Score.

Note: This will only report for CCR and EOC records.

For CCR Records:

[StudentTestScore]NumScore

For EOC Records:

[StoredGrades]Grade

194/201

20

N/A

Not collected.

N/A

202/207

21

N/A

Not collected.

N/A

208/213

22

N/A

Not collected.

N/A

214/219

23

N/A

Not collected.

N/A

220/225

24

N/A

Not collected.

N/A

226/231

25

N/A

Not collected.

N/A

232/237

26

N/A

Not collected.

N/A

238/243

27

N/A

Not collected.

N/A

244/249

28

N/A

Not collected.

N/A

250/255

29

N/A

Not collected.

N/A

256/261

30

N/A

Not collected.

N/A

262/267

31

N/A

Not collected.

N/A

268/273

32

N/A

Not collected.

N/A

274/279

33

N/A

Not collected.

N/A

280/294

34

N/A

Not collected.

N/A

295/304

35

N/A

Not collected.

N/A

305/314

36

N/A

Not collected.

N/A

315/326

37

N/A

Not collected.

N/A

327/366

38

N/A

Not collected.

N/A

367/376

39

N/A

Not collected.

N/A

377/382

40

N/A

Not collected.

N/A

383/384

41

N/A

Not collected.

N/A

385/392

42

N/A

Not collected.

N/A

393/395

43

N/A

Not collected.

N/A

396/398

44

N/A

Not collected.

N/A

399/406

45

Scoring Model Code

The measurement used to determine the outcome of the Early Childhood Assessment.

This field is required if Test Description is Early Childhood or DDA.

Valid values for Early Childhood:

• BRIG – Brigrance
• CC – Creative Curriculum
• WORK – Work Sampling
• PETITION – Petition to NMPED

Valid values for DDA:

• DLDSC = Dual Discrepancy Model Assessment

Other valid values are:

• NMPKOA – NM PreK Observational Assessment

Note: This will always be blank for CCR and EOC records.

[S_NM_STU_AssessmentFact_C]ScoringModelCode

407/418

46

N/A

Not collected.

N/A

419/421

47

N/A

Not collected.

N/A

422/424