Skip to main content
Skip table of contents

T - Non-traditional Student Credit Attempt File 2023-2024

Introduction

This file contains all non-scheduled courses and other non-course credit activities where high school credit was attempted while the student was enrolled at any school in the district during the current school year, or the preceding summer school term, including those students who exit the school. Non-scheduled courses are courses for students where there is no corresponding record in the Course Catalog File (D) or the Student Schedule File (E). Only activities from the current school year should be included.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis of report results when the report does not return the correct records.

Student Selection

The report selects records from the [StoredGrades] table based on the following criteria:

  • The school where the grade was awarded must not offer grade levels below 9 or above 12.

  • The grade awarded must offer credit; i.e. potential credit must be greater than zero.

  • The student's school Entry Date must be on or before the last day of the current school year.

  • The student's school Exit Date must be on or after the first day of the current school year.

  • The student must not be a no-show; i.e. the school Exit Date must occur after the school Entry Date

  • The grade awarded is not associated with a section and section enrollment for the current school year.

  • The grade does not have a Location ID = 9999

Report Input

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

Field

Description

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 selection criteria.

The All Schools option is only available when running the report from the District Office.

Current Selection Students

Indicate which students to include in the report by selecting one of the following options:

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

If you are running the report for a single student, or a group of students, select the students before running the report.


School Year

Choose the year for which to run the report.

Scheduling

Select Schedule to run the report on a specific date and time. The default is 'Run Now'.


Report Output

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

Item

Data Element

Description

[Table]FieldName

Reqd

Field Type

Length

T01

School Year

The four-digit year in which the school year ends.

[Terms]LastDay

Yes

Char

4

T02

Serving County District Code

The county district code for the district providing service to the student. Use leading zeroes where necessary.

All grades from outside serving districts should be 9999.


[Prefs]Value

[Prefs]Name=districtnumber

Yes

Char

5

T03

District Student ID

The locally assigned student identifier.

[Students]Student_Number

Yes

VarChar

50

T04

State Student ID (SSID)

The identifier assigned to each WA public school student by OSPI.

Rule: This field is not required if the student has not yet been assigned an SSID.

[Students]State_StudentNumber

Con

Char

10

T05

Location ID

The Location ID for the school where the student is enrolled when participating in the non - traditional credit attempt.

Note: Grades with a Location ID = 9999 are not included. ([S_WA_SGR_X]AlternateLocationID)

location ID from stored grades, if blank

[Schools]AlternateSchoolNumber

[Schools]School_Number

Yes

VarChar

4

T06

Attempt ID

The ID used by the district or school to represent the unique non-traditional credit attempt.

StoredGrades.ID

Yes

VarChar

20

T07

Course ID

The unique course number assigned by the district. Grades without an associated course will use the school-level or district-level default course numbers.

[StoredGrades]Course_Number

[S_WA_SCH_X]TransferCrsNumber

[Pref]WA_TransferCrsNumber

Yes

VarChar

20

T08

Course Title

Course name assigned by the school and district.

[StoredGrades]Course_Name

Yes

VarChar

50

T09

Content Area Code

Primary content area.

[S_WA_SEC_X]ContentAreaCd

[S_WA_CRS_X]ContentAreaCd

Con

VarChar

3

T10

Course Designation Code

Course designation code outlined in WAC 392-415-070. Include this field for grades 7–12 for all courses that receive high school credit.

A single course can have multiple designation codes. Refer to OSPI rules regarding which can go together. The report output does not display the concatenated value of codes.

If the user selects only the B course designation code, the report output displays B.

If the user selects only J or selects J along with other codes, then the report output displays only J.

If the user selects only J and B or selects J and B along with other codes, the report output displays only J B.

If the user selects other codes but does not select J and B, the report output displays only the other selected codes. For example, if the user selects the newly code Paid Work Experience (F) along with Science Lab (S) and Internation Baccalaureate (I), the report will display the value as “FSI”.

[S_WA_CRS_X]Desig_IB

[S_WA_CRS_X]Desig_CollegeInHS

[S_WA_CRS_X]Desig_TestPrep

[S_WA_CRS_X]Desig_Honors

[S_WA_CRS_X]Desig_AP

[S_WA_CRS_X]Desig_RunningStart

[S_WA_CRS_X]Desig_CADR

[S_WA_CRS_X]Desig_Online

[S_WA_CRS_X]Desig_Cambridge

[S_WA_CRS_X]Desig_LocalTest

[S_WA_CRS_X]Desig_NationalTest

[S_WA_CRS_X]Desig_Quantitative

[S_WA_CRS_X]Desig_SciLab

[S_WA_CRS_X]crsDesig_NonInstructional

[S_WA_CRS_X]Desig_YouthReengagement

[S_WA_CRS_X]Desig_DistrictOrLocal

[S_WA_CRS_X]Desig_locTransition

[S_WA_CRS_X]Desig_CTE_CP_Adv_Manuf

[S_WA_CRS_X]Desig_CTE_CP_Maritime

[S_WA_CRS_X]Desig_CTE_CP_Aerospace

[S_WA_CRS_X]Desig_CTE_CP_Constr

[S_WA_CRS_X]Desig_TechPrep

Con

VarChar

10

T11

State Course Code

Unique course code assigned by the state.

[S_WA_SEC_X]StateCourseCd

[S_WA_CRS_X]StateCourseCd

Con

Char

6

T12

ALE Course Type

Indicates whether the student is receiving ALE-funded instruction for the course being reported.

Valid Values:

  • N – No, the Course was not taught through ALE

  • O – Online

  • R – Remote

  • T – Site Based – written student learning plan requires regular, weekly in-person instructional contact time

  • U – Site Based – written student learning plan requires less than weekly in-person instructional contact time

  • Y – Yes (Only applicable for school years prior to 2014-2015)

[S_WA_SGR_X]ALEFunded

[S_WA_SEC_X]ALEFunded

[S_WA_CRS_X]ALEFunded

Con

Char

1

T13

Approved Online Provider

Identifies the online provider offering the course reported in Element T07 – Course ID.

[S_WA_CRS_X]ApprovedOnlineProvider

[S_WA_SEC_X]ApprovedOnlineProvider

Con

VarChar

2

T14

Approved Online Program

Identifies the online program offering the course reported in Element T07 – Course ID.

[S_WA_CRS_X]ApprovedOnlineProgram

[S_WA_SEC_X]ApprovedOnlineProgram

Con

VarChar

3

T15

Letter Grade

The letter grade awarded for the course.

[StoredGrades]Grade

Yes

VarChar

2

T16

Credits Attempted

The number of credits the student could have earned for the course.

Valid range: 00.00 to 99.99

[StoredGrades]PotentialCrHrs

Yes

Numeric

4,2

T17

Credits Earned

The number of credits awarded to the student upon completion of the course.

Valid range: 00.00 to 99.99

[StoredGrades]EarnedCrHrs

Yes

Numeric

4,2

T18

Course Level

Add a new field to the Course/Sections/Historical Grades new/edit screens under State Course Code, allowing users to select a course's Course Level. Valid Values:

  • Blank

  • B – Basic or remedial

  • G – General or regular

  • E – Enriched or Advanced

  • H – Honors

  • C – College

  • X – No specified level of rigor

[S_WA_CRS_X]CourseLevel

Yes

VarChar

2,1

T19

Course Sequence

Identifies where a course lies when it is part of a consecutive sequence of courses

[S_WA_CRS_X]CrsSequence

Yes

Int

2,0

T20

Sequence Group

Identifies the sequence grouping of the course sequence reported in Element T19

[S_WA_CRS_X]CrsSequenceGroup

Yes

VarChar

2,20


JavaScript errors detected

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

If this problem persists, please contact our support.