Skip to main content
Skip table of contents

Student Fact Template for Career Standards Benchmarks

Contents

Introduction

The Student Fact Template for Career Standards Benchmarks contains data pertaining to Career Education and Work Standards. It extracts data for all students in grade 5, 8, and 11 with the required Yes or No values for the indicator field in the report. The output file matches the standard naming conventions for the Pennsylvania Department of Education: DistrictCode_STUDENT_FACT_YYYYMMDDHHMM.xxx. 

Selection Criteria

Selection criteria determine which database records are used in the report. For the Student Template/Snapshot, student records are selected.

School Selection

The report selects the records from the Schools table, where the school is associated with a student included in the report.

  • The school must not be excluded from state reporting.

Student Selection

The report selects the student records to use based on the following criteria:

  • The student must be enrolled in a school included in the report.
  • The student must not be excluded from state reporting.
  • The student must be in grade level 5, 8, or 11 during the report period.

Report Input

For help with report generation and navigation, see How to Find and Generate a Report.

Field

Description

Select Schools

Indicate which schools to include in the report by selecting from the following options:

If sub-districts are not enabled:

  • Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria.
  • All Schools (default) – Run the report for all schools. Includes all student records on the PowerSchool server that meet the selection criteria

If sub-districts are enabled: 

  • Select Sub-district - Select the sub-district for which you want to run the report.
  • Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria.
  • All Schools in selected sub-district (default) – Run the report for all schools in the selected sub-district. Includes all student records on the PowerSchool server that meet the selection criteria.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Students to Include

Select one of the following:

  • The Selected [number] 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 that meet the selection criteria.

Note: If running the report for a single student, or group of students, select the students prior to running report.

Select School Year

From the pop-up menu, choose the year for which the report should be run.

Field Delimiter

Select the field delimiter for the extract file.

Include Header Labels in output file?

Choose Yes or No to indicate whether to include column headings in the extract file. Including column headers provides a heading for each type of data extracted in the report.

Snapshot DateTo ensure that only active students as of a certain date are included in the report output, enter a snapshot date.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #

Data Element

Description

[Table]FieldName

Field Type

Field Length

1

District Code

The unique, nine-digit Administrative Unit Number assigned by the PDE. This field is extracted from Start Page > District Setup > District Info.

[Prefs]Value where [Prefs]Name=PA_DistrictAUN is populated

Otherwise:

[Prefs]Value where
[Prefs]Name=District_Number

If sub-districts are enabled:

[CST_SubDistricts]Subdistrict_Number

Alpha-numeric

9

2

School Year Date

A single date indicating the whole school year; the June 30 at the end of the standard school year is used to designate a school year. Thus, the 2017-2018 school year would be indicated by 2018-06-30.

Dervied based on the year for which the report is run.

Alpha-numeric

10

3

Student ID

The PAsecureID assigned to the student. This field is extracted from Start Page > Student > State/Province - PA > PA SecureID.

[Students]State_StudentNumber

[ReEnrollments]State_StudentNumber

Alpha-numeric

10

4

Reporting Date

A single date indicating the whole school year; the June 30 at the end of the standard school year is used to designate a school year. Thus, the 2017-2018 school year would be indicated by 2018-06-30.

Dervied based on the year for which the report is run.

Alpha-numeric

10

5

Category Set Code

A static value based on the student's grade level.

Derived

  • For grade 5: 'CSB05'

  • For grade 8: 'CSB08'

  • For grade 11: 'CSB11'

Alpha-numeric

100

6Primary Measure Type

The primary measure type.

'INDICATOR'Alpha20

7

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

8

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

9

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

10

Indicator

Indicates whether the student met the benchmark.

Valid values:

  • YYes
  • N – No

Note: A value of "Y" will be extracted unless "N" has been entered in the student record.

[S_PA_STU_X]Benchmarks_Indicator

[S_PA_REN_X]Benchmarks_Indicator

Alpha-numeric

3

11

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

12

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

13

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.