T - Non-traditional Student Credit Attempt File 2019-2020
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, including those students who exit the school. Non-scheduled courses are courses for students where there is not a 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.
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:
Note: 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:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
| School Year | Choose the year for which to run the report. |
Scheduling | Default is Run Now. Select Schedule to run the report on a specific date and time. |
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 | 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. Note: 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. | 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. Note: This field is required for courses taken during the 2011-2012 school year and beyond. | [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. | [S_WA_CRS_X]Desig_IB [S_WA_CRS_X]Desig_CollegeInHS [S_WA_CRS_X]Desig_TechPrep [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]Desig_SciLab [S_WA_CRS_X]Desig_locCrsAssessment | 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:
| [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 |