ADSY | PowerSchool SIS Compliance

Defining ADSY Program

Navigation: Start Page > Student Selection > Special Programs > ADSY

The Additional Days School Year (ADSY) program provides funding for additional instructional days. In PowerSchool SIS, ADSY tracking spans school-level configuration, calendar setup, staff assignment, and student special program enrollments.

1. Student Program Enrollment (Defining ADSY Program)

Student participation in ADSY is recorded as a standard Special Program in PowerSchool SIS. There is no separate student extension table (S_TX_SEN_ADSY_X); all student enrollment data is stored in the core [SpEnrollments] table.

Data Element	Additional Information	[Table] Field Name	Used in Reports / Interchanges
Special Program	Select the state-defined ADSY program. (Internal state program code: `ADSY`)	`[Gen]state_program` (linked via `[SpEnrollments]ProgramID`)	PEIMS Fall (Interchange Student Extension) • Interchange Student Program
Entry Date	Enter the date the student entered the ADSY program. (Required)	`[SpEnrollments]Enter_Date`	Interchange Student Program
Exit Date	Enter the date the student exited or completed the ADSY program.	`[SpEnrollments]Exit_Date`	Interchange Student Program
Comment	Enter any additional comments or internal notes about the student's ADSY enrollment.	`[SpEnrollments]Custom`	Internal / Ad-hoc Reporting
Grade Level	Grade levels EE, PK, and KG are stored numerically in PowerSchool (`-1`, `0`, etc.). The value is mapped automatically for state reporting.	`[Students]Grade_Level`	AAR Campus Summary • TX Interchanges

2. School, Calendar & Staff Setup

ADSY setup requires configuration across Campus settings, Calendar Days, and Staff Responsibilities.

Setup Area	Navigation / Description	Database Table	Field Name / Element	Values / Purpose
School Settings	School > Edit School (Texas State Information) Enables ADSY funding participation for the campus.	`S_TX_SCH_SCHOOLS_X`	`E1671_ADSY_INDICATOR`	`1` = Participating `0` / Blank = Not Participating
School Settings	School > Edit School (Texas State Information) Specifies the default daily operational minutes for ADSY days.	`S_TX_SCH_SCHOOLS_X`	`ADSY_DEFAULT_MINUTES`	Numeric value (e.g., `360`)
Calendar Setup	School > Calendar Setup > Day Details Identifies specific calendar dates designated as ADSY instructional days.	`S_TX_CLD_X`	`ADSY_DAY`	Checkbox / Indicator (`1` = ADSY Day)
Staff Responsibilities	Staff > Texas State Information > Staff Responsibilities Identifies staff members serving as ADSY teachers.	`S_TX_USR_RESP_C`	`E1673_ADSY_TEACHER_IND`	`1` = ADSY Teacher Indicator

3. Data Export Manager (DEM) / Import Reference Guide

When exporting or importing ADSY-related records using the Data Export Manager or Quick Import, use the corresponding table selections below:

Area to Export / Import	Category	Table to Select in DEM	Associated Extension Table	Key Identifiers / Filter Criteria
Student ADSY Enrollments	`PowerSchool Data Sets` / `Standard Tables`	`Special Programs (SpEnrollments)`	None (Core Table `[41]`)	`ProgramID` = ADSY Program ID • `StudentID` • `Enter_Date` • `Exit_Date`
School ADSY Indicators	`PowerSchool Data Sets`	`Schools`	`S_TX_SCH_SCHOOLS_X`	`SchoolID` • `E1671_ADSY_INDICATOR` • `ADSY_DEFAULT_MINUTES`
Calendar ADSY Days	`PowerSchool Data Sets`	`Calendar` / `Calendar_Day`	`S_TX_CLD_X`	`Date` • `SchoolID` • `ADSY_DAY`
Staff ADSY Responsibilities	`PowerSchool Data Sets`	`Users` / `Staff Responsibilities`	`S_TX_USR_RESP_C`	`Users_DCID` / `Staff_ID` • `E1673_ADSY_TEACHER_IND`

Note
If attempting to export student ADSY records, do not look for S_TX_SEN_ADSY_X. Student ADSY records are exported directly from the Special Programs (SpEnrollments) table.