PATH: WA State Reporting > Student Programs (I)

The Student Program File (I) reports information regarding student program participation from Flags, FRAM Eligibility, WA Sped (tab), Graduation (State Seal), LAP PLP, and Behavior (Truancy Referral) .

Student Programs File Editor

Note the following:

Information for the State Transitional Bilingual Instruction Program is not included in this file, but is reported in the Student Bilingual Programs File (J).
Information for the Special Education Programs is not included in this file, but is reported separately in the Student Special Education Programs File (K).

Report Logic

Students must be actively enrolled on or between the calendar start date and the As-of Date selected on the extract editor.
A Program (active range or single date) must be active on or between the calendar start date and the As-of Date selected on the extract editor.
A record will not report If the student's enrollment is State Excluded or flagged No Show, or the student's grade level maps to a State Grade Level Code that is State Excluded, or the Calendar of enrollment is State Excluded.

Flags Logic

A record reports from Flags for each actively enrolled student who has a state reported program active at least one day on or between the calendar Start Date and the extract As of Date (reporting window).
- If the student exits and reenters the same program during the reporting window, two records report.
- To report, the program must be flagged as State Reported.
- Should a student have a reportable service, eligibility, or attribute entered in Campus AND a state reported Flag of the same state code, duplicate records may report.

FRAM Logic

A record reports for each actively enrolled student who has a FRAM Eligibility record active at least one day during the reporting window.
- State Code View on the Eligibility must contain a value to report.
- Should a student have multiple active FRAM eligibility records, the most recent is reported.

WA BIE Sped Logic

A record reports for each active Disability entered on the WA BIE Sped tab.
- Students identified with a disability report regardless of special education status.

Graduation: State Seal of Biliteracy Earned/Proficient Logic

A record reports per WA State Seal of Biliteracy record entered for a student on their Graduation tab.
- Either Date Earned and/or Date Proficient must fall on/between the reporting range (calendar state date and the Effective Date entered on the extract editor).

LAP PLP: LAP (Learning Assistance Program) Participation Logic

A record reports per LAP PLP that is active at least one day on or between the reporting range (calendar start date and the Effective Date entered on the extract editor).
- Only LAP PLPs are reported.
- If multiple LAP Student Growth Plans are active, multiple records are reported.
- Records are reported from LAP PLPs only (System Administration > PLP > Plan Types > Print Format = LAP (current)
- An active plan is determined by the Student Information > PLP > General > Documents > Learning Assistance Program Plan > Education Plan > Start Date & End Date

Behavior Management: Truancy Action Logic

A record reports per student offender / per Behavior Resolution mapped to one of the following Resolution State Codes:
- 50: Truancy Petition filed with Juvenile Court
- 51: Referral to a Community Truancy Board
- 52: Truancy - Other Coordinated Means of Intervention
- 53: Truancy - A Hearing in the Juvenile Court
- 54: Truancy - Other Less Restrictive Disposition
- 55: Truancy - Detention for Failure to Comply with Court Order
  - A Behavior Incident must be entered for the student in Campus with an Behavior Event, a Participant and a Behavior Resolution assigned where:
    - The Resolution StartDate must fall on/between calendar start date and the effective date entered on the extract editor.
    - If the Resolution Start Date is null, no record is reported.
  - Mapped State Resolution Codes of 50, 51, 52, 53, 54, and 55; do not report in Student Discipline File P.

See the Program Codes table for a list of codes that will report records.

Generating the Report

Enter the As of Date in mmddyyyy format or by clicking the calendar icon and selecting a date.
Select which students will be included in the report:
1. Grade - Select which grades will be reported.
2. Ad Hoc Filter - Select an Ad hoc filter to further narrow report results.
Select the appropriate Format. Options are CSV, HTML and Tab Delimited (State Format).
Select the Calendar(s) that should be included in the report.
Click Generate Extract to generate the report in the indicated format or Submit to Batch to schedule when the report will generate.

Users have the option of submitting report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process will allow larger reports to generate in the background, without disrupting the use of Campus. The generated extract is available in the Process Inbox For more information about submitting a report to the batch queue, see the Batch Queue article.

Student Programs File - HTML Format

Report Layout

Data Element	Description	Type, Format and Length	Campus Database	Campus Application
School Year	The ending year of the current school year for the school where the student participates or receives services for the program. For the school year 2008-09, 2009 reports.	Numeric, 4 digits	Calendar.endYear	System Administration > Calendar > Calendar > Calendar Info > End Date
Serving Country District Code	The county-district code for the district where the student participates or receives services for the program. Reports Serving District from the student's active enrollment if populated, else reports State District Number. Logic is as follows: If the number of active enrollments is greater than 1, use the primary enrollment. If there are multiple primary enrollments, the enrollment with the highest CalendarID is used. If no enrollments are primary, the partial enrollment with the highest CalendarID is used.	Numeric, 5 digits	Enrollment.servingDistrict District.number	Student Information > General > Enrollment > Serving District Code System Administration > Resources > County System Administration > Resources > District Info > State District Number
District Student ID	Identifies the locally-assigned student identification number.	Numeric, 50 digits	Person. studentNumber	Census > People > Demographics > Person Identifiers > Student Number
SSID	Identifies the state-assigned student identification number.	Numeric, 10 digits	Person.stateID	Census > People > Demographics > Person Identifier > State Student ID
Location ID	Identifies the school number where student participates or receives services for the program. Reports State School Number based on the student's active enrollment on the As of Date or the program end date, whichever comes first.	Numeric, 4 digits	School.number	System Administration > Resources > Resources > School > State School Number
Program Code	Identifies the state-assigned code of the program in which the student is receiving services at any point during the current school year. Flags: This field reports the student's state reported Flag Code. FRAM: This field reports a value of 19 for all FRAM records. WA BIE Special Ed: This field reports a value of 36 for all WA Sped records. Graduation: Reports as 41 from Seal of record only if State Seal = WA State Seal of Biliteracy and the Date Earned is not null. Reports as 42 if State Seal = WA State Seal of Biliteracy and Date Proficient is not null. LAP PLP: Reports as follows: Reports as 37 if LAP PLP has a Program Code = 37: LAP English Language Arts Reports as 38 if LAP PLP has a Program Code = 38: LAP Behavior Reports as 11 if LAP PLP has a Program Code = 11: LAP Extended Learning Opportunities (Grad 11-12, Transition 8) Reports as 7 if LAP PLP has a Program Code = 7: LAP Academic Readiness (K-12) Reports as 6 if LAP PLP has a Program Code = 6: LAP Math Repots as 44 if LAP PLP has a Program Code = 44: WA Reading Corps Literary Support Behavior: Reports the State Code selected (codes 50-55): Reports as 50 if student offender/resolution has a Program Code = 50: Truancy Petition filed with Juvenile Court Reports as 51 if student offender/resolution has a Program Code = 51: Referral to a Community Truancy Board Reports as 52 if student offender/resolution has a Program Code = 52: Truancy - Other Coordinated Means of Intervention Reports as 53 if student offender/resolution has a Program Code = 53: Truancy - A Hearing in the Juvenile Court Reports as 54 if student offender/resolution has a Program Code = 54: Truancy - Other Less Restrictive Disposition Reports as 55 if student offender/resolution has a Program Code = 55: Truancy - Detention for Failure to Comply with Court Order See the Program Codes table for values.	Numeric, 2 digits	Program.code The rest are hard coded.	Student Information > General > Flags System Administration > Programs > Flags > Programs Detail > State Reported System Administration > FRAM > Eligibility > Eligibility Status F or R Student Information > Special Ed > WA BIE Sped (tab) Student Information > General > Graduation > State Seal, Date Earned, and Date Proficient Student Information > PLP > General > Documents > Learning Assistance Program
Start Date	Identifies the date the student attends or receives services, enrolled in the program, or is identified with a disability. Flags: The program Start Date is reported. FRAM: The Eligibility Start Date is reported. Logic looks for the FRAM eligibility that is active on the As-of Date entered on the extract editor. If multiple are active, logic reports from the eligibility with the most recent start date. WA BIE Special Ed: The SPED Start Date on the WA Sped tab is reported. If SPED Start Date does not contain a value, either the first instructional day in the calendar or the value contained in Start Date reports, whichever is most recent. Graduation: If the State Seal = 41, the Date Earned is reported. If State Seal = 42, the Date Proficient is reported. LAP PLP: Reports the Start Date of the LAP PLP. Behavior: Reports the State Date of the Behavior Resolution.	Date field, 10 characters MM/DD/YYYY	Program.startDate Eligibility.startDate BIEWASped. spedStartDate	Student Information > General > Flags > Student Detail > Start Date FRAM > Eligibility > Start Date Student Information > Special Ed > WA BIE Sped tab > Start Date Student Information > General > Graduation (State Seal) > Date Earned Student Information > General > Graduation (State Seal) > Date Proficient Student Info > PLP > General > Documents > Learning Assistance Program Behavior Management: Resolution > Start Date
Exit Date	Identifies the date the student exits a program, ceases to receive services, or is no longer identified with a disability. An end date must fall on or after the calendar start date, and on or before the effective date selected on the extract editor to report. Flags: The program End Date is reported. Logic looks for the FRAM eligibility that is active on the As-of Date entered on the extract editor. If multiple are active, logic reports from the eligibility with the most recent start date. Logic reports the Eligibility End Date only if the end date is on or after the calendar start date and on or before the As-of Date on the extract editor. FRAM: The Eligibility End Date is reported. WA BIE Special Ed: The SPED End Date on the WA Sped tab is reported. Graduation: If the State Seal = 41, the Date Earned is reported. If State Seal = 42, the Date Proficient is reported. LAP PLP: Reports the End Date of the LAP PLP if it falls on or after the calendar State Date and on or before the As-of-Date entered on the extract editor. Behavior: Reports null for all records.	Date field, 10 characters MM/DD/YYYY	Program.ExitDate Eligibility.endDate BIEWASped. spedEndDate	Student Information > General > Flags > Student Detail > End Date FRAM > Eligibility > End Date Student Information > Special Ed > WA BIE Sped tab > Start Date
Exit Reason Code	Identifies the reason the student exited. Reports as long as an Exit Date reports for this record and/or a value is selected. Flags: Reports the Exit Reason from the student's Flag record (as long as the Exit Date is within the reporting range). FRAM: See the Exit Reason Options for available choices. Logic looks at records populated from the FRAM eligibility that is active as of the As-of Date entered on the extract editor. If multiple eligibility records are active, logic reports from the eligibility with the most recent start date. If the Exit Date field on the extract is not null, logic looks to see if the student's primary enrollment record on the Eligibility Exit Date is active: If it is not active, a value is reported based on the enrollment End Status: A value of B is reported if End Status = GO or GA A value of C is reported of End Status = Anything other than GO or GA If the student primary enrollment is active on the Eligibility End Date: A value of D is reported if the Eligibility of record's Certified Type = Declined A value of C is reported if the Eligibility of record's Certified Type is not Declined and either a new Eligibility record has not been entered for this student at any time in the remaining school year (i.e., after the As-of Date) OR a new Eligibility record for this student exists at any time in the remaining school year (i.e., after the As-of Date) with an Eligibility value that is not Paid. A value of A is reported if the Eligibility of record's Certified Type is not Declined and a new Eligibility record has been entered for this student at any time in the remaining school year (i.e., after the As-of Date) where the next Eligibility record entered contains an Eligibility value of Paid. WA BIE Special Ed: Reports NULL for all records. Graduation: Reports the State Seal Information > Method selected. LAP PLP: Reports the Exit Reason selected on the LAP PLP. Behavior: Reports null for all records.	Alphanumeric, 1 character	Program.exitReason BIEWASped. spedExitReason	Student Information > General > Flags > Student Detail > Exit Reason FRAM > Eligibility > End Date, Certified Type, Type (P) Student Information > General > Enrollment > Exit Reason LAP (current) > Enrollment Editor > Exit Reason
Qualification Code	Indicates the reason the student qualifies for program services. Flags: Reports the Qualification Code selected from the Flag record. If Qualification Code is null, the first 60 characters from the Description field is reported. FRAM: The State Eligibility Code from the FRAM record is reported. Logic looks at the FRAM eligibility that is active on the As-of Date. If multiple Eligibility records are active, logic reports from the eligibility record with the most recent start date. WA BIE Special Ed: The Disability code is reported. Graduation: Reports the Language Code entered on the State Seal record. LAP PLP: Records null for all records. Behavior: Reports blank/null for all records.. See the Qualification Code Options for available choices.	Alphanumeric, 60 characters	Program Participation.need Program. description Eligibility. mealstatus BIEWASped. disability ProgramParticipation. language	Student Information > General > Flags > Student Flag Detail > Qualification Code Student Information > General > Flags > Student Detail > Description System Administration > Resources > School > School History > USDA Programs > Provision FRAM > Eligibility > State Qualification Override, else State Code View Student Information > Special Ed > WA BIE Sped tab > Disability

Exit Reason Options

Exit Reason Codes report based on the type of record reported. State reported Flags records must have a Program Exit Date selected that falls in the reporting range. FRAM records must have an Eligibility End Date that falls in the reporting range. For both Flags and FRAM reporting types, if the student exited their enrollment during the reporting range, Exit Reason reports based on the enrollment end status selected.

Code	Description	Reporting Logic
A	Program no longer needed	A new FRAM Eligibility of Paid exists after a reportable Eligibility record.
B	Graduated	An enrollment End Status of GO or GA.
C	No longer enrolled	A new FRAM Eligibility other than Paid is entered after reportable Eligibility record. An enrollment End Status Other than GO or GA. A sequential School History record with no Provision status.
D	Opted out of program	Eligibility Certified Type is Declined.
F	Other	N/A

Qualification Code Options

From Flags:

This dictionary is unlocked; state codes and descriptions may be edited via System Administration > Custom > Attribute Dictionary > Campus Attributes/Dictionary Editor > ProgramParticipation > Exit Reason > Exit Reason Dictionary Detail.

Code	Description
A	Pregnant secondary school student
B	Father-to-be secondary school student
C	Parenting secondary school student

Code	Description	USDA Programs
15	Non-base year students attending Provision 2 schools	National School Lunch Program (NSLP), Provision, Provision Base Year

From FRAM > Eligibility > State Code View:

Code	Description	Derived from FRAM Eligibility
1	Free via household income/family size application	Free, Non-Direct, with Certified Type of Income
3	Directly Certified - Free via migrant student status list	Free, Direct, with Certified Type of Migrant
4	Directly Certified - Free via homeless liaison's list	Free, Direct, with Certified Type of Homeless
5	Directly Certified - Free via runaway status list	Free, Direct, with Certified Type of Runaway
7	Directly Certified - Free via Head Start list	Free, Direct, with Certified Type of Head Start
8	Free via foster child household application	Free, Non-Direct, with Certified Type of Foster
11	Reduced-price (via household application)	Reduced, Non-Direct, with Certified Type of Income or Categorical
14	Directly Certified - Free via Early Childhood Ed and Assistance Prog. (ECEAP) list	*State Qualification Override*
16	Free via household application with Basic Food case number	*State Qualification Override*
17	Free via enrollment in a Residential Child Care Institution (RCCI)	Free, Non-Direct, with Certified Type of RCCI
18	Directly Certified - Free via Tribal TANF/FDPIR list	*State Qualification Override*
19	Directly Certified - Free via Department of Social and Health Services (DSHS) Basic Food List	Free, Direct, with Certified Type of SNAP
20	Directly Certified - Free via DSHS TANF list	Free, Direct, with Certified Type of TANF
21	Free via household application with (TANF)	Free, Non-Direct, with Certified Type of Categorical
22	Free Via household application with TANF case number	*State Qualification Override*
23	Free via household application with FDPIR case number	*State Qualification Override*
24	Directly Certified – Free via FDPIR list	Free, Direct, with Certified Type of FDPIR
25	Survey: Income comparable Free	*State Qualification Override*
26	Survey: Income comparable Reduced	*State Qualification Override*

Program Codes

A Program record reports for participating students when State Reported is flagged for the Flag (System Administration > Programs > Flags > Flag Editor > Program).

Program codes are not stored. Records return solely based on the flagged State Reported check box. The Codes as listed below were active on the date of publication. Please refer to CEDARS documentation for a current list of valid state codes.

Additional set up in Flags may cause duplicate record return for those programs pulled from other areas of the product (FRAM, LAP PLP, WA SPED tab, Behavior Resolution, and Graduation State Seal).

Code	Description
1	21st Century Community Learning Program
6	LAP Math
7	LAP Academic Readiness
9	Title I Targeted Assistance Language Arts
10	Title I Targeted Assistance Math
11	LAP Extended Learning Opportunities Program (Graduation Assistance grades 11,12 & Transition services grade 8)
12	Title I Targeted Assistance Science
16	504 Plan
19	Free/Reduced Meals Participation /Eligibility
23	Title VII Indian Education Supplemental Services
24	Unaccompanied Youth
30	GRADS Program (Graduation, Reality and Dual-Role Skills)
31	Title I Part A – Services Provided to Local Neglected School Students
32	Gifted – services or programs provided in the general education classroom
33	Gifted – services or programs provided in a unique highly capable program
34	Gifted – services or programs provided through acceleration
35	Gifted – services or programs provided outside the traditional school setting
36	Student Identified With a Disability
37	LAP English Language Arts – Reading Writing and Communication
38	LAP Behavior
39	Readiness to Learn (RTL)
40	Reengagement
41	Washington State Seal of Biliteracy Earned
42	Washington State Seal of Biliteracy Proficient
44	Washington Reading Corps (WRC) Literacy Support
45	Recruiting Washington Teachers
47	Title I Targeted Assistance Career Technical Education
48	Title I Targeted Assistance Other
49	Title I Targeted Assistance Social Sciences
50	Truancy Petition Filed in Juvenile Court
51	Referral to a Community Truancy Board
52	Truancy - Other Coordinated means of intervention
53	Truancy - A Hearing in the Juvenile Court
54	Truancy - Other Less Restrictive Disposition
55	Truancy - Detention for Failure to Comply with Court Order

Student Programs File (I) (Washington)