Student Setup - AzEDS

Entering General Demographics

Demographics

Name (Last, First Middle Suffix)

Enter the preferred student’s name.

Format: LastName, FirstName MiddleName Suffix

[Students]LastFirst

[Students]Last_Name

[Students]First_Name

[Students]Middle_Name

[S_AZ_STU_X]Suffix

Student Needs Extract

Community College Extract

Early Childhood Extract

AzEDS:Student

Legal Name (Last, First Middle Suffix)

Enter the student's legal name. If the student's legal name matches the student's preferred name, click Copy to populate the legal name fields. If the student's legal name does not match the student's preferred name, enter the student's legal name.

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_Last_Name

[StudentCoreFields]PSCore_Legal_First_Name

[StudentCoreFields]PSCore_Legal_Middle_Name

[StudentCoreFields]PSCore_Legal_Suffix

Preferred Name Type

Choose the type of name of the student's preferred name.

Valid values:

• Alias

• Nickname (default)

• Other Name

• Previous Legal Name

[S_AZ_STU_X]PrefNameType

Home Address

Enter the student’s home address.

[Students]Street

[Students]City

[Students]State

[Students]Zip

AzEDS:

Student

Mailing Address

If applicable, enter the student’s mailing address.

[Students]MailingStreet

[Students]MailingCity

[Students]MailingState

[Students]MailingZip

AzEDS:

Student

Home Phone

Enter the student’s home phone number.

[Students]Home_Phone

AzEDS:

Student

DOB

Enter the student’s date of birth.

[Students]DOB

Student Needs Extract

Community College Extract

Early Childhood Extract

AzEDS:

Student

Federal Ethnicity and Race: Ethnicity

Choose Yes or No to indicate if the student is Hispanic or Latino.

If you set up the option to allow the student to decline to specify ethnicity (District level setting), then select this value, if appropriate.

[Students]Fedethnicity

Valid Values:

• -1 – Default, no value

• 0 – No, not Hispanic or Latino

• 1 – Yes, Hispanic or Latino

• 2 – Decline to specify

AzEDS:

Student

Federal Ethnicity and Race: Race

Select the checkbox for the appropriate federal race category.

If you set up the option to allow the student to decline to specify race then select this value, if appropriate.

[StudentRace]Racecd

[Students]Fedracedecline

AzEDS:

Student

Scheduling/Reporting Ethnicity

Choose the student’s ethnicity, to be used in PowerSchool reports.

[Students]Ethnicity

Student Needs Extract

Community College Extract

Early Childhood Extract

AzEDS:

Student

Gender

Choose either female or male.

Valid values:

• F – Female

• M – Male

[Students]Gender

Student Needs Extract

Community College Extract

Early Childhood Extract

AzEDS:

Student

SSN

Enter the student’s social security number.

[Students]SSN

AzEDS:

Student

Student Number

Enter the locally assigned student number.

[Students]Student_Number

Student Needs Extract

Community College Extract

Early Childhood Extract

AzEDS:

Student

Entering Student Email

Student Email

Email Address

Enter the student’s email address.

[PSM_StudentContactType]email

AzEDS:

Student

Defining Arizona State Information

Entering State Enrollment Information

State/Province – AZ > State Enrollment Information

SAIS Student Number

Enter the student’s SAIS ID.

The value for State_EnrollFlag is updated to 1 (True) if a SAIS ID is entered and the page is submitted. The default value is 0 (False). This field indicates that the student is enrolled in SAIS.

The State_EnrollFlag field is also automatically updated when importing SAIS IDs using the Import SAIS Student IDs function from the SAIS Menu (Start Page > Special Functions > Interfaces to Other Systems > SAIS).

When importing SAIS IDs using the Quick Import function, include the State_EnrollFlag field with a value of 1 for each student.

[Students]State_StudentNumber

[Students]State_EnrollFlag

AzEDS Pubishing

Student Needs Extract

Community College Extract

Early Childhood Extract

Previous District School ID

Enter the school ID of the student's previous school.

(Start typing the school name of an Arizona school.)

Used when requesting a new UniqueID (state student number) for students.

[S_AZ_STU_X]PrvDistSchEntity

AzEDS: Get UniqueID

School Student Number

The student’s locally assigned identifier entered on the Demographics page.

[Students]Student_Number

Student Needs Extract

Community College Extract

Early Childhood Extract

Grade Level Code

The student’s grade level entered on the Transfer Info > Edit Enrollment page.

Displays as:

• PS = PK4, PK3, PK2

• KG = KG

• UE = Grade KG with the Ungraded Elementary field box checked.

[Students]Grade_Level

AzEDS Publishing

Entry Date

The student’s entry date entered on the Transfer Info > Edit Enrollment page.

[Students]EntryDate

Student Needs Extract

Community College Extract

Early Childhood Extract

Entry Code

The student’s entry code entered on the Transfer Info > Edit Enrollment page.

[Students]EntryCode

AzEDS Publishing

Track

The student’s track entered on the Transfer Info > Edit Enrollment page.

[Students]Track

AzEDS Publishing

District of Residence

The student’s district of residence entered on the Transfer Info > Edit Enrollment page.

[Students]DistrictOfResidence

AzEDS Publishing

Full-Time Equivalency

The student’s FTE entered on the Transfer Info > Edit Enrollment page.

[Students]FTEID

Tuition Payer

The student’s tuition payer status entered on the Transfer Info > Edit Enrollment page.

Valid values:

• 1 – State Funded

• 2 – Privately Paid or No Tuition

• 3 – Foreign Exchange Student

• 4 – NSE Students in Residential Treatment Centers

• 5 – JTED/Non-Resident Charter (concurrent)

• 6 – ISEP Student

• 7 – Other State Funded Formula

• 9 - Grade not fundable for a CTED
  
  

  

  For students in Gade Level 9, the Tuition Payer code defaults to 9:

  • if the student’s School Type is CTED Central Campus and CTED Community College
    OR

  • if the student is enrolled in any other school type and the JTED Student Indicator is set to Yes

  
  

[Students]TuitionPayer

Required Setup

Special Enrollment Code

The student’s special enrollment code entered on the Transfer Info > Edit Enrollment page.

Valid values:

• 1 – CECA

• 2 – CECB

• 3 – Open Enrollment

[Students]EnrollmentCode

Required Setup

Enrollment Type

The student’s Enrollment (Membership) Type Codes, entered on the Transfer Info > Edit Enrollment page.

Note: The T (Online) option is only available if the School Type field is set to AOI School.

[Students]EnrollmentType

Required Setup

Exclude Student From State Reporting

Check the box to exclude the student from State Reporting.

If the box is checked, the student will be excluded from AzEDS and SAIS, as well as from all reports on the State Reporting tab on the System Reports page.

Valid values:

• 1 = excluded

• blank (null) = not excluded

[Students]State_ExcludeFromReporting

AzEDS

SAIS

All State Reporting Tab reports.

Concurrent School CTDS

Enter the ID of the school the student attends concurrently with (at the same time as) the current school.

[S_AZ_STU_X]ConcurrentSchoolID

Required Setup

Concurrent School Student Number

Enter the ID assigned to the student by the concurrent school.

[S_AZ_STU_X]ConcurrentStudentID

Required Setup

Previous School State

Choose the state in which the student previously attended school, if applicable.

[S_AZ_STU_X]PreviousStateCode

Required Setup

Previous School CTDS

Enter the CTDS of the school the student previously attended, if applicable.

[S_AZ_STU_X]PreviousSchoolID

Required Setup

Previous School Student Number

Enter the student’s identifier, assigned by their previous school, if applicable.

[S_AZ_STU_X]PreviousStudentID

Required Setup

Normal Graduation Year

Enter the student’s expected year of graduation.

[S_AZ_STU_X]NormalGraduationYear

Required Setup

Initial Enrollment in Arizona School/Preschool

Enter the date of the student's initial enrollment in an Arizona school or preschool.

[S_AZ_STU_X]FirstAZSchooling

Immunization Record Card

Entering State Demographic Information

State/Province – AZ > State Demographics

Name (last, first MI)

Enter the student’s preferred last, first, and middle names.

Note: The values are populated from the Demographics page.

[Students]Last_Name

[Students]First_Name

[Students]Middle_Name

Student Needs Extract

Community College Extract

Early Childhood Extract

Legal Name (Last, First Middle Suffix)

Enter the student's legal name. If the student's legal name matches the student's preferred name, click Copy to populate the legal name fields. If the student's legal name does not match the student's preferred name, enter the student's legal name.

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_Last_Name

[StudentCoreFields]PSCore_Legal_First_Name

[StudentCoreFields]PSCore_Legal_Middle_Name

Preferred Name Type

Enter the preferred name type entered in the Name field.

[S_AZ_STU_X]PrefNameType

AzEDS:

Student Demographics

Last name goes by

The field is obsolete as of the 2019-20 school year.

Enter the last name used to by the student, if applicable.

[S_AZ_STU_X]LastNameBirth

N/A

Tribal Name (Obsolete)

Enter the student’s tribal name, if applicable.

[S_AZ_STU_X]TribalName

AzEDS:

Student

Tribal Affiliation

Search and choose the student's tribal affiliation.

If the option selected in the tribal affiliation field is Other, the Enter Tribal Affiliation field appears.

[ S_AZ_STU_X] TribalAffiliation

AzEDS:

Student Demographics

Enrolled Tribe

Select the student's enrolled tribe.

• This field is not mandatory.

• If the Tribal Affiliation field has a single selection, this field automatically reflects the selection. If the Tribal Affiliation field has multiple selections, choose the applicable option for this field.

[ S_AZ_STU_X]Oth TribalAffiliation

AzEDS:

Student Demographics

Gender

Choose the student’s gender.

Note: This value is populated from the Demographics page.

[Students]Gender

Student Needs Extract

Community College Extract

Early Childhood Extract

Ethnicity

Choose Yes or No to indicate if the student is Hispanic or Latino.

[Students]Fedethnicity

Valid Values:

• -1 – Default, no value

• 0 – No, not Hispanic or Latino

• 1 – Yes, Hispanic or Latino

Student Needs Extract

Community College Extract

Early Childhood Extract

Race

Select the checkbox for the appropriate federal race category.

[StudentRace]Racecd

AzEDS:

Student Demographics

Scheduling/Reporting Ethnicity

Choose the student’s ethnicity, to be used in PowerSchool reports.

[Students]Ethnicity

No Longer Used

Tribal Affiliation

Choose the student's tribal affiliation.

Note: If the option selected in the tribal affiliation field is Other, the Other Tribal Affiliation field appears.

[ S_AZ_STU_X] TribalAffiliation

AzEDS:

Student Demographics

Other Tribal Affiliation

Enter the student's tribal affiliation.

[ S_AZ_STU_X]Oth TribalAffiliation

AzEDS:

Student Demographics

1/4 or More Degree Indian Blood

No longer collected.

[S_AZ_STU_X]DegreeIndianBlood

No Longer Used

Date of Birth

Enter the student’s date of birth.

Note: This value is populated from the Demographics page.

[Students]DOB

Student Needs Extract

Community College Extract

Early Childhood Extract

Country of Birth

Choose the student’s country of birth.

[S_AZ_STU_X]CountryBirthCode

Required Setup

State of Birth

Choose the student’s state of birth.

[S_AZ_STU_X]StateBirthCode

Required Setup

Mother Name

Enter the name of the student’s mother in the format last, first.

Note: This value is populated from the Demographics page.

[Students]Mother

Required Setup

Father Name

Enter the name of the student’s father in the format last, first.

Note: This value is populated from the Demographics page.

[Students]Father

Required Setup

Home Language

Choose the student’s home language.

[S_AZ_STU_X]HomeLanguageCode

AzEDS:

Student Demographics

Spoken Language

Enter the language most often spoken by the student.

[S_AZ_STU_X]SpokenLanguage

AzEDS:

Student Demographics

First Acquired Language

Enter the language the student first aquired.

[S_AZ_STU_X]FirstAcquiredLanguage

AzEDS:

Student Demographics

Parent in Military

Choose Yes or No to indicate if the student’s parent is active in the military.

[S_AZ_STU_X]ParentMilitaryStatus

AzEDS:

Student

Street, Apt/Suite, City

Enter the student's home address street and city.

[Students]Street

[Students]City

Home Address State

Enter the name of the student’s home address state.

Note: This value is populated from the Demographics page.

[Students]State

AzEDS:

Student

Home Address Zip Code

Enter the name of the student’s home address zip code.

Note: This value is populated from the Demographics page.

[Students]Zip

AzEDS:

Student

Single Parent

Choose Yes if the student is a single parent.

[S_STU_X]SingleParent

AzEDS:

Student Demographics

Defining Year-End Status

State/Province – AZ > Year-End Status

Next School

Choose the next school the student is scheduled to attend.

Note: Set up Next School values via Start Page > School Setup > Next School.

[Students]Next_School

Next Year Grade Level

Enter the student’s scheduled grade level for the upcoming school year.

[Students]Sched_NextYearGrade

Exit Date

Enter the date the student is scheduled to exit school for this school year.

[Students]ExitDate

Exit Code

Choose the exit code scheduled for the student’s school enrollment for this school year.

[Students]ExitCode

Changing the Student's School Enrollment

State/Province – AZ > Change Enrollment

Grade Level

Enter the student’s grade level for the new school enrollment.

[Students]Grade_Level

Ungraded Elementary

Displays when grade level KG is selected.

Check the box if applicable:

• Per A.R.S. § 15-901(A)(5)(a)(i): Student must be 5 years old but less than 6 by September 1st and must have a Group B SPED service for each day of UE membership (A, EDP, HI, MD, MDSSI, MOID, OI, PSD, SID, and VI).

[S_AZ_STU_X]UngradedElementary

AzEDS:

Student School Association

District of Residence

Choose the student’s district of residence for the new school enrollment.

The district of residence is used as the District of Funding for Arizona. Funding is provided to the district for each student whose school enrollment is associated with the district. The district of residence must be a nine-digit value that does not include dashes.

See http://azed.gov/ for a list of the district of residence numbers.

[Students]DistrictOfResidence

Full-Time Equivalency

Choose the student’s FTE for the new school enrollment.

[Students]FTEID

[Students]MembershipShare

Required Setup

Tuition Payer

Choose the student’s tuition payer status.

Valid values:

• 1 – State Funded

• 2 – Privately Paid or No Tuition

• 3 – Foreign Exchange Student

• 4 – NSE Students in Residential Treatment Centers

• 5 – JTED/Non-Resident Charter (concurrent)

• 6 – ISEP Student

• 7 – Other State Funded Formula

[Students]TuitionPayer

Required Setup

Special Enrollment Code

The student’s special enrollment code entered on the Transfer Info > Edit Enrollment page.

Valid values:

• 1 – CECA

• 2 – CECB

• 3 – Open Enrollment

[Students]EnrollmentCode

Required Setup

Comment

Enter a comment regarding the enrollment change.

[Students]Comment

Not Required

Career and Technical Educational District (CTED)

CTED Student Indicator

Choose Yes to include the student in JTED reports.

Choosing Yes indicates that the student attends an alternate enrollment scenario – the student attends career and technical education courses offered at another campus.

[S_AZ_STU_X]JTED_Indicator

[S_AZ_REN_X]JTED_Indicator

Student Information

Student Attendance Information

Attendance Audit Information

AzEDS:

Student Enrollment

Student Attendance

CTED Satellite Tuition Payer

Enter the JTED Satellite Tuition Payer

[S_AZ_STU_X]JTED_Satellite_Tuition_Payer

[S_AZ_REN_X]JTED_Satellite_Tuition_Payer

Student Information

AzEDS:

Student Enrollment

Student Attendance

CTED School CTDS/Entity ID

Enter the County Code-Type Code-District Code-Site Number (CTDS) of the student’s school.

If reporting JTED Enrollments through AzEDS, enter the JTED school EntityID (not CTDS).

[S_AZ_STU_X]JTED_School_CTDS

[S_AZ_REN_X]JTED_School_CTDS

Student Information

AzEDS:

Student Enrollment

Student Attendance

CTED Concurrent CTDS

Enter the JTED Concurrent CTDS.

[S_AZ_STU_X]JTED_Concurrent_CTDS

[S_AZ_REN_X]JTED_Concurrent_CTDS

Student Information

AzEDS:

Student Enrollment

Student Attendance

CTE Student Type

Select the CTE Student Type:

1 CTE participating public school/charter school
2 Homeschool (non-ESA recipient)
3 Non-CTE participating public school/charter school
4 Private school/private charter school
5 Empowerment Scholarship Account (ESA) recipient (only displays for SchoolType = CTED Main)

6 Continuation of Services/13th Year students

CTE Enrollment Report defaults to 1 if blank.

[S_AZ_STU_X]CTE_Student_Type

[S_AZ_REN_X]CTE_Student_Type

Student Information

AzEDS:

Student Enrollment

Student Attendance

CTE Enrollment Report

CTE School of Residence CTDS

Enter the CTE School of Residence CTDS

[S_AZ_STU_X]CTE_Shool_Residence_CTDS

[S_AZ_REN_X]CTE_Shool_Residence_CTDS

Student Information

AzEDS:

Student Enrollment

Student Attendance

CTE Enrollment Report

Effective Date of Change

Enter the date that the change in enrollment becomes effective.

[Students]EffectiveDate

Required Setup

Defining SAIS Student Needs

Entering Student Needs Not Associated with a Program (011)

State/Province – AZ > Student Needs > New/Edit 011 – Student Needs

A SAIS “Need” is a term used to indicate that a student requires special support, either within or beyond regular norms, to enhance their capabilities. Need types include language, special education (SPED), giftedness, economic, behavioral, health, and academic. Needs submitted to SAIS are valid for one fiscal year.

From the ADE’s ‘Transaction Requirements: Needs’ document: While this transaction may be used to report a need from any need group, it's only necessary for reporting a Need for a student who is not also receiving a Program or Service for that Need. For the needs associated with a program or service the student is receiving, it's far more efficient to simply use the 014 SPED Service Participation, the 013 Language Program Participation, or the 015 Support Program Participation transactions to add the need to SAIS.

When the Need record is saved, the School field automatically displays based on the value entered in [ S_AZ_STU_SupportProgram_C ] SchoolID.

Note: Students who participate in programs or services related to Needs require a SAIS ID. With the exception of Needs-only students, students must be enrolled in school and be included in SAIS Membership.

Need Code

Choose the appropriate Need Code, if applicable.

Notes:

• When you click Submit, this field becomes read-only. To edit the selection, delete the record and create a new record.

• A student should not have an Immigrant Need in three or more fiscal years.

[S_AZ_STU_StudentNeed_C]NeedCode

Student Needs Extract

Need Entry Date

Enter the day the student enrolled in the Need program. The entry date must fall within the current year term dates.

Note: SAIS uses entry dates as record keys. After you click Submit, this field is read-only. To edit the date, you must delete the record and create a new record.

[S_AZ_STU_StudentNeed_C]EntryDate

Student Needs Extract

Need Exit Date

If applicable, enter the day after the student’s last day in the Need program. The exit date must occur within the year term dates and after the entry date.

Note: It is recommended to leave Exit Date blank or 0/0/0 until the student actually exits the Need. A student is automatically exited from Needs when transferred out of school and by the SAIS End of Year Function.

[S_AZ_STU_StudentNeed_C]ExitDate

Student Needs Extract

Primary Nighttime Residence

If the Need Code is Homeless, choose the appropriate code.

Valid values:

• 1 – Sheltered

• 2 – Doubled Up

• 3 – Unsheltered

• 4 – Hotel/Motel

Note: Primary Nighttime Residence is required for a need code of Homeless.

[S_AZ_STU_StudentNeed_C] PrimaryNighttimeResidence

Student Needs Extract

Defining Student Assessment Needs (012)

State/Province – AZ > SAIS Needs > New/Edit 012 – Student Assessment

When the Need record is saved, the School field automatically displays based on the value entered in [S_AZ_STU_SupportProgram_C]SchoolID.

Note: Student Assessment data can be entered for any school year, however as of fiscal year 2008-2009, 012 transactions are not generated for SAIS.

Oral – Assessment Date

Enter the date of the oral assessment.

Note: To change the selection, you must delete the existing record and create a new record.

[S_AZ_STU_ELLASSESSMENTFY06_C] OralAssessmentDate

Student Needs Extract

Oral – Assessment Score

Enter the oral assessment score.

[S_AZ_STU_ELLASSESSMENTFY06_C ] OralAssessmentScore

Student Needs Extract

Oral – Proficiency Level

Choose the appropriate oral proficiency level.

Valid values:

• PE – Pre-Emergent

• E – Emergent

• B – Basic

• I – Intermediate

• P – Proficient

[S_AZ_STU_ELLASSESSMENTFY06_C ] OralProficiencyLevel

Student Needs Extract

Reading – Assessment Date

Enter the date of the reading assessment.

Note: To change the selection, you must delete the existing record and create a new record.

[S_AZ_STU_ELLASSESSMENTFY06_C ] ReadingAssessmentDate

Student Needs Extract

Reading – Assessment Score

Enter the reading assessment score.

[S_AZ_STU_ELLASSESSMENTFY06_C ] ReadingAssessmentScore

Student Needs Extract

Reading – Proficiency Level

Choose the appropriate reading proficiency level.

Valid values:

• PE – Pre-Emergent

• E – Emergent

• B – Basic

• I – Intermediate

• P – Proficient

[S_AZ_STU_ELLASSESSMENTFY06_C ] ReadingProficiencyLevel

Student Needs Extract

Writing – Assessment Date

Enter the date of the writing assessment.

Note: To change the selection, you must delete the existing record and create a new record.

[S_AZ_STU_ELLASSESSMENTFY06_C ] WritingAssessmentDate

Student Needs Extract

Writing – Assessment Score

Enter the writing assessment score.

[S_AZ_STU_ELLASSESSMENTFY06_C ] WritingAssessmentScore

Student Needs Extract

Writing – Proficiency Level

Choose the appropriate writing proficiency level.

Valid values:

• PE – Pre-Emergent

• E – Emergent

• B – Basic

• I – Intermediate

• P – Proficient

[S_AZ_STU_ELLASSESSMENTFY06_C ] WritingProficiencyLevel

Student Needs Extract

Overall Assessment Result

Choose the overall assessment result.

Valid values:

• 3 – Reclassified Fluent English Proficient

• 4 – Initial Fluent English Proficient

• 5 – ELL After Reclassification

• 6 – Continuing Fluent English Proficient

• 7 – English Language Learner

[S_AZ_STU_ELLASSESSMENTFY06_C ] OverallAssessmentResult

Student Needs Extract

Overall Total Composite Scaled Score

Enter the overall total composite score.

[S_AZ_STU_ELLASSESSMENTFY06_C ] OverallTotComposScaledScore

Student Needs Extract

Overall Proficiency Level

Choose the appropriate overall proficiency level.

Valid values:

• PE – Pre-Emergent

• E – Emergent

• B – Basic

• I – Intermediate

• P – Proficient

[S_AZ_STU_ELLASSESSMENTFY06_C ] OverallProficiencyLevel

Student Needs Extract

Defining Language Program Participation (013)

State/Province – AZ > SAIS Needs > New/Edit 013 – Student Language Program Participation

When the Need record is saved, the School field automatically displays based on the value entered in [S_AZ_STU_SupportProgram_C]SchoolID.

Note: All students who participate in programs or services related to Needs require a SAIS ID. With the exception of Needs-only students, all students must be enrolled in school and be included in SAIS Membership.

Program Need Code

Choose English Language Learner, if applicable.

Note: To change the selection, you must delete the existing record and create a new record.

[S_AZ_STU_LanguageProgram_C ] ProgramNeedCode

Student Needs Extract

Program Code

Choose the appropriate program code, if applicable.

Note: To change the selection, you must delete the existing record and create a new record.

[S_AZ_STU_LanguageProgram_C ]ProgramCode

Student Needs Extract

Program Entry Date

Enter the day the student entered the language program.

Note: To change the selection, you must delete the existing record and create a new record.

[S_AZ_STU_LanguageProgram_C ]EntryDate

Student Needs Extract

Program Exit Date

If applicable, enter the day after the student’s last day in the Need program. The exit date must occur within the year term dates and after the entry date.

Note: It is recommended to leave Exit Date blank or 0/0/0 until the student actually exits the Need. A student is automatically exited from Needs when transferred out of school and by the SAIS End of Year Function.

[S_AZ_STU_LanguageProgram_C ]ExitDate

Student Needs Extract

Program Exit Reason Code

Choose the appropriate exit reason, if applicable.

[S_AZ_STU_LanguageProgram_C ]ExitReason

Student Needs Extract

Defining Special Education Service Participation (014)

State/Province – AZ > SAIS Needs > New/Edit 014 – Student SPED Service Participation

When the Need record is saved, the School field automatically displays based on the value entered in [S_AZ_STU_SupportProgram_C]SchoolID.

Note: All students who participate in programs or services related to Needs require a SAIS ID. With the exception of Needs-only students, all students must be enrolled in school and be included in SAIS Membership.

SPED Need Code

Choose the appropriate Need Code .

Note: To change the selection, you must delete the existing record and create a new record.

[S_AZ_STU_SPED_Service_C ]NeedCode

Student Needs Extract

SPED Service Code

Choose the appropriate service code.

Note: To change the selection, you must delete the existing record and create a new record.

[S_AZ_STU_SPED_Service_C ]ServiceCode

Student Needs Extract

SPED Service Entry Date

Enter the day the student entered the SPED Service.

Note: To change the selection, you must delete the existing record and create a new record.

[S_AZ_STU_SPED_Service_C ]EntryDate

Student Needs Extract

SPED Service Exit Date

If applicable, enter the day after the student’s last day in the SPED Service. The exit date must occur within the year term dates and after the entry date.

Note: PowerSchool recommends leaving the Exit Date blank or 0/0/0 until the student actually exits the Need. A student is automatically exited from Needs when transferred out of school and by the SAIS End of Year Function.

[S_AZ_STU_SPED_Service_C ]ExitDate

Student Needs Extract

SPED Exit Reason Code

Choose the appropriate SPED Exit Reason, if applicable.

[S_AZ_STU_SPED_Service_C ]ExitReason

Student Needs Extract

Federal Primary Need Indicator

Choose Yes or No.

Note: The student can only have one current “True” Federal Primary Need Indicator for all of their Student SPED Service Participation records for a particular date range.

[S_AZ_STU_SPED_Service_C ] FederalPrimaryNeedIndicator

Student Needs Extract

SPED School Concurrency

Choose the appropriate value if the student has two concurrent SPED Service Participation records during the same school year.

Valid values:

• P – Primary

• S – Secondary

[S_AZ_STU_SPED_Service_C ] ConcurrencyType

Defining Support Program Participation (015)

State/Province – AZ > SAIS Needs > New/Edit 015 – Student Support Program Participation

When the Need record is saved, the School field automatically displays based on the value entered in [S_AZ_STU_SupportProgram_C]SchoolID.

Note: All students who participate in programs or services related to Needs require a SAIS ID. With the exception of Needs-only students, all students must be enrolled in school and be included in SAIS Membership.

Support Need Code

Choose the appropriate Need Code.

If one of the following support program codes is selected, this field defaults to (NOND) No Need: Cont-Yr2, Cont-Yr3, Cont-Yr4, Cont-Yr5, Cycle14, CE-RE, CE-MA, CE-BE, or CE-OT.

Notes:

• To change the selection, you must delete the existing record and create a new record.

• A student should not have an Immigrant Need in three or more fiscal years.

[S_AZ_STU_SupportProgram_C ] SupportNeedCode

Student Needs Extract

Support Program Code

Choose the appropriate Support Program Code.

Note: To change the selection, you must delete the existing record and create a new record.

[S_AZ_STU_SupportProgram_C ] SupportProgramCode

Student Needs Extract

Support Entry Date

Enter the day the student entered the support program.

Note: To change the selection, you must delete the existing record and create a new record.

[S_AZ_STU_SupportProgram_C ]EntryDate

Student Needs Extract

Support Exit Date

If applicable, enter the day after the student’s last day in the support program. The exit date must occur within the year term dates and after the entry date.

Note: It is recommended to leave Exit Date blank or 0/0/0 until the student actually exits the Need. A student is automatically exited from Needs when transferred out of school and by the SAIS End of Year Function.

[S_AZ_STU_SupportProgram_C ]ExitDate

Student Needs Extract

Exit Reason

This field is only available if the Support Program Code is set to a 21st Century program. Choose the reason the student left the support program.

Valid values:

• [Blank] - N/A

• CCLC01 - Reached 30 days of attendance and services no longer needed

• CCLC02 - Dropped from program due to lack of attendance

[ S_AZ_STU_SupportProgram_C ] ExitReason

Receiving CTDS

Enter the receiving school CTDS. This field is required when reporting a transportation/school choice support program.

[S_AZ_STU_SupportProgram_C ] Receiving_CTDS

Student Needs Extract

Defining SAIS Lunch Programs

Defining Lunch Program Eligibility (011)

State/Province – AZ > SAIS Needs – Lunch > New/Edit 011 – Student Needs

From the ADE’s ‘Transaction Requirements: Needs’ document: While this transaction may be used to report a need from any need group, it's only necessary for reporting a Need for a student who is not also receiving a Program or Service for that Need. For the needs associated with a program or service the student is receiving, it's far more efficient to simply use the 014 SPED Service Participation, the 013 Language Program Participation, or the 015 Support Program Participation transactions to add the need to SAIS.

When the Need record is saved, the School field automatically displays based on the value entered in [ S_AZ_STU_SupportProgram_C ] SchoolID.

Note: All students who participate in programs or services related to Needs require a SAIS ID. With the exception of Needs-only students, all students must be enrolled in school and be included in SAIS Membership.

Need Code

Choose the appropriate Need code.

Note: To change the selection, you must delete the existing record and create a new record.

Valid values:

• 28 – Income Eligibility 1 (Free Lunch)

• 29 – Income Eligibility 2 (Reduced Lunch)

[S_AZ_STU_StudentNeed_C ]NeedCode

Student Needs Extract

Need Entry Date

Enter the day the student entered the support program.

Note: To change the selection, you must delete the existing record and create a new record.

[S_AZ_STU_StudentNeed_C ]EntryDate

Student Needs Extract

Need Exit Date

If applicable, enter the day after the student’s last day in the Need program. The exit date must occur within the year term dates and after the entry date.

Note: It is recommended to leave Exit Date blank or 0/0/0 until the student actually exits the Need. A student is automatically exited from Needs when transferred out of school and by the SAIS End of Year Function.

[S_AZ_STU_StudentNeed_C ]ExitDate

Student Needs Extract

Defining Lunch Support Program Participation (015)

State/Province – AZ > SAIS Needs – Lunch > New/Edit 015 – Student Support Program Participation

When the Need record is saved, the School field automatically displays based on the value entered in [S_AZ_STU_SupportProgram_C]SchoolID.

Note: All students who participate in programs or services related to Needs require a SAIS ID. With the exception of Needs-only students, all students must be enrolled in school and be included in SAIS Membership.

The same records appear on the SAIS Needs and SAIS Needs – Lunch page. The SAIS Needs – Lunch page can be made accessible to lunch personnel.

Support Need Code

Choose the appropriate Support Need code.

Note: To change the selection, you must delete the existing record and create a new record.

Valid values:

• 28 – Income Eligibility 1 (Free Lunch)

• 29 – Income Eligibility 2 (Reduced Lunch)

[S_AZ_STU_SupportProgram_C ] SupportNeedCode

Student Needs Extract

Support Program Code

Choose the appropriate Support Program Code.

Note: To change the selection, you must delete the existing record and create a new record.

[S_AZ_STU_SupportProgram_C ] SupportProgramCode

Student Needs Extract

Support Entry Date

Enter the day the student entered the support program.

Note: To change the selection, you must delete the existing record and create a new record.

[S_AZ_STU_SupportProgram_C ]EntryDate

Student Needs Extract

Support Exit Date

If applicable, enter the day after the student’s last day in the Need program. The exit date must occur within the year term dates and after the entry date.

Note: It is recommended to leave Exit Date blank or 0/0/0 until the student actually exits the Need. A student is automatically exited from Needs when transferred out of school and by the SAIS End of Year Function.

[S_AZ_STU_SupportProgram_C ]ExitDate

Student Needs Extract

Receiving CTDS

Enter the receiving school CTDS. This field is required when reporting a transportation/school choice support program.

[S_AZ_STU_SupportProgram_C ] Receiving_CTDS

Student Needs Extract

Entering Community College Records

State/Province – AZ > Community College

Note: Community college records are not associated with a school enrollment, although the Resend Enrollment option on the SAIS page resends community college records as well as school enrollment records.

School Name

Choose the school supporting the student’s community college enrollment.

Note: To change the selection, you must delete the existing record and create a new record.

[S_AZ_STU_CommunityCollege_C]SchoolID

[Schools]Name

Community College Extract

College Entity ID

Enter the Community College Entity ID.

Note: To change the selection, you must delete the existing record and create a new record.

[S_AZ_STU_CommunityCollege_C ] CollegeEntityID

Community College Extract

College Entry Date

Enter the date the student began attending the community college (for the given fiscal year). For community college, the entry date may be outside of the current school year term dates.

Note: To change the selection, you must delete the existing record and create a new record.

[S_AZ_STU_CommunityCollege_C ]EntryDate

Community College Extract

College Exit Date

Enter the date the student quit attending the community college (for the given fiscal year). For community college, the exit date may be outside of the current school year term dates. This field is not required.

[S_AZ_STU_CommunityCollege_C ]ExitDate

Community College Extract

College Classes (Number)

Enter the number of classes the student is attending.

[S_AZ_STU_CommunityCollege_C ] NumberOfClasses

Community College Extract

Defining AIM Group Participation

State/Province – AZ > Aims Labels > New/Edit AIMS Labels

Group Name

Enter the student’s group name for Arizona’s Instrument to Measure Standards (AIMS) labels. Typically, this is the teacher’s name or room number.

The testing group, if provided, is used to sort the test labels within the grade level.

See http://www.azed.gov/assessment/aims/ for more information.

[S_AZ_STU_AIMS_Labels_C ]GroupName

Entering Early Childhood Education Information

Defining Early Childhood Education Participation (023)

State/Province – AZ > Early Childhood > 023 – Early Childhood Participation

Note: All students who participate in programs or services related to Early Childhood require a SAIS ID.

Preschool Program Type

Choose the student’s preschool program type.

Valid values:

• 1 – Early Childhood Block Grant

• 2 – State Family Literacy

• 3 – Title I Even Start

• 4 – Migrant Education Even Start

• 5 – Title I Preschool

• 6 – Tuition-Based Preschool or Early Childhood

• 7 – Other Preschool or Early Childhood Program

[S_AZ_STU_EC_Participation_C ] PreschoolProgramType

Early Childhood Extract

Program Entry Date

Enter the date the student entered the early childhood program for the given fiscal year.

[S_AZ_STU_EC_Participation_C ] ProgramEntryDate

Early Childhood Extract

Program Exit Date

Enter the date the student exited the early childhood program for the given fiscal year.

Note: This field is not required.

[S_AZ_STU_EC_Participation_C ] ProgramExitDate

Early Childhood Extract

Program Partner ID

Enter the CTDS number of the school where the program is provided.

[S_AZ_STU_EC_Participation_C ] ProgramPartnerID

Early Childhood Extract

Family Income Indicator

Choose Yes or No to indicate whether the student’s family is at or below the poverty level.

Note: This field is required for the Title I Even Start program and State Family Literacy program.

[S_AZ_STU_EC_Participation_C ] FamilyIncomeIndicator

Early Childhood Extract

Living in Household Indicator

Choose a value to indicate which parents live in the student’s household.

Valid values:

• Mother

• Father

• Both

• Neither

Note: This field is required for the Early Childhood Block Grant program.

[S_AZ_STU_EC_Participation_C ] LivingInHouseholdIndicator

Early Childhood Extract

Mother Employment Status

Choose Yes or No to indicate the mother’s employment status.

Note: This field is required if the Living in Household Indicator is Mother or Both.

[S_AZ_STU_EC_Participation_C ] MotherEmploymentStatus

Early Childhood Extract

Father Employment Status

Choose Yes or No to indicate the father’s employment status.

Note: This field is required if the Living in Household Indicator is Father or Both.

[S_AZ_STU_EC_Participation_C ] FatherEmploymentStatus

Early Childhood Extract

Adult Education ID

Enter the ADE-generated Adult Education identifier.

Note: This field is required if Preschool Program Type is Title I Even Start (3) or State Family Literacy (2).

[S_AZ_STU_EC_Participation_C ] AdultEducationID

Early Childhood Extract

Exempt from PPVT III or PALS-PreK

Choose the reason the student is exempt from taking PPVT III or PALS-PreK assessments, if applicable.

Valid values:

• 1 – Hearing Impairment

• 2 – Vision Impairment

• 3 – Language Barrier

• 4 – Age Exemption

• 5 – Less than 6 Months of Instruction

[S_AZ_STU_EC_Participation_C ]ExemptPPVT

Early Childhood Extract

Entering Preschool Assessment Information

State/Province – AZ > Early Childhood > 024 – Early Childhood Preschool Assessment

Note: In order to create a 024 – Early Childhood Preschool Assessment record, the student must have a current 014 or 023 record.

Preschool Assessment Type

Choose the appropriate preschool assessment type.

Valid values:

• Work Sampling

• Creative Curriculum

• Child Observation Record (COR)

• Galileo Plus

• Peabody Picture Vocabulary Test-III (PPVT-III)

• Phonological Awareness Literacy Screening Pre-K (PALS Pre-K)

[S_AZ_STU_EC_Assessment_C ] PreschoolAssessmentType

Early Childhood Extract

Preschool Assessment Date

Enter the date the student took the assessment.

[S_AZ_STU_EC_Assessment_C ] PreschoolAssessmentDate

Early Childhood Extract

Responsible Entity ID

Enter the Responsible District or Charter Holder CTD Number.

[S_AZ_STU_EC_Assessment_C ] ResponsibleEntityID

Early Childhood Extract

Test Score 1

Enter the test score.

Note: The number of Test Scores required by SAIS depends on the Assessment Type.

[S_AZ_STU_EC_Assessment_C ]TestScore1

Early Childhood Extract

Test Score 2

Enter the test score.

[S_AZ_STU_EC_Assessment_C ]TestScore2

Early Childhood Extract

Test Score 3

Enter the test score.

[S_AZ_STU_EC_Assessment_C ]TestScore3

Early Childhood Extract

Test Score 4

Enter the test score.

[S_AZ_STU_EC_Assessment_C ]TestScore4

Early Childhood Extract

Test Score 5

Enter the test score.

[S_AZ_STU_EC_Assessment_C ]TestScore5

Early Childhood Extract

Test Score 6

Enter the test score.

[S_AZ_STU_EC_Assessment_C ]TestScore6

Early Childhood Extract

Test Score 7

Enter the test score.

[S_AZ_STU_EC_Assessment_C ]TestScore7

Early Childhood Extract

Test Score 8

Enter the test score.

[S_AZ_STU_EC_Assessment_C ]TestScore8

Early Childhood Extract

Test Score 9

Enter the test score.

[S_AZ_STU_EC_Assessment_C ]TestScore9

Early Childhood Extract

Test Score 10

Enter the test score.

[S_AZ_STU_EC_Assessment_C ]TestScore10

Early Childhood Extract

Test Score 11

Enter the test score.

[S_AZ_STU_EC_Assessment_C ]TestScore11

Early Childhood Extract

Test Score 12

Enter the test score.

[S_AZ_STU_EC_Assessment_C ]TestScore12

Early Childhood Extract

Defining Grand Canyon Diploma Enrollment

State/Province – AZ > Grand Canyon Diploma

Click New to create a Grand Canyon Program enrollment.

Program Code

Defaults to Grand Canyon Diploma (GCD).

[S_AZ_STU_GCD_C]ProgramCode

AzEDS:

Student Program

Program School

Select the school where the student is participating in the Program.

Defaults to current school.

[S_AZ_STU_GCD_C]SchoolID

AzEDS:

Student Program

Program Entry Date

Enter the day the student entered the GCD Program.

[S_AZ_STU_GCD_C]EntryDate

AzEDS:

Student Program

Program Exit Date

If applicable, enter the day after the student’s last day in the GCD Program. The exit date must occur within the year term dates and after the entry date.

Note: It is recommended to leave Exit Date blank or 0/0/0 until the student actually exits the Program. A student is automatically exited from Needs and Programs when transferred out of school and by the SAIS End of Year Function.

[S_AZ_STU_GCD_C]ExitDate

AzEDS:

Student Program

ExitReason

Choose the appropriate exit reason, if applicable.

[S_AZ_STU_GCD_C]ExitReasonCode

AzEDS:

Student Program

Defining Dropout Recovery Program Enrollment

State/Province – AZ > Dropout Recovery Program

Click New Dropout Recovery Program to create a Dropout Recovery Program enrollment.

Program Code

Defaults to Dropout Recovery Program (DRP).

[S_AZ_STU_DRP_C]ProgramCode

AzEDS:

Student Program

Program School

Select the school where the student is participating in the Program.

Defaults to the current school.

[S_AZ_STU_DRP_C]SchoolID

AzEDS:

Student Program

Program Entry Date

Enter the day the student entered the DRP Program.

[S_AZ_STU_DRP_C]EntryDate

AzEDS:

Student Program

Approved Written Learning Plan Date

The date the Written Learning Plan was approved.

[S_AZ_STU_DRP_C]ApprWrLrnPlanDt

AzEDS:

Student Program

Student Program Associations

Program Exit Date

If applicable, enter the day after the student’s last day in the DRP Program. The exit date must occur within the year term dates and after the entry date.

Note: It is recommended to leave Exit Date blank or 0/0/0 until the student actually exits the Program. A student is automatically exited from Needs and Programs when transferred out of school and by the SAIS End of Year Function.

[S_AZ_STU_DRP_C]ExitDate

AzEDS:

Student Program

Exit Reason

Choose the appropriate Dropout Recovery Program Exit Reason, if applicable.

[S_AZ_STU_DRP_C]ExitReasonCode

AzEDS:

Student Program

State/Province – AZ > Dropout Recovery Program

After a Dropout Recovery Program enrollment is created, click Add Progress Record from the Dropout Recovery Program list page to create a Dropout Recovery Program Progress Record enrollment.

Note: A new progress record will need to be created for each month a student is participating in the DRP program.

Learning Plan Date

Initial or Modified Learning Plan Date.

If the student is given a new written learning plan, enter the new date, otherwise the initial learning plan date is displayed.

Note: A new Written Learning Plan date indicating preparation of a new plan must be submitted each academic (fiscal) year.

[S_AZ_DRP_Progress_C]PlanDate

AzEDS:

Student Program

Month

The month in which the LEA is reporting student enrollment in the DRP.

This transaction must be submitted each month that the student is enrolled in the DRP regardless of the student’s progress.

[S_AZ_DRP_Progress_C]Month

AzEDS:

Student Program

Satisfactory Progress

Indicates whether student maintained satisfactory progress during the month prior to this transaction (“Y” or “N”).

[S_AZ_DRP_Progress_C] SatisfactoryProgress

AzEDS:

Student Program

Defining Student Contacts

Contacts

The Student Contacts page is used to associate a student with a Contact. Student Contacts are used to collect and report Responsible Party information to AzEDS in the Parent and StudentParentAssociation interchanges. Contacts are managed using the Contacts tab on the Start Page, and are associated with students from either the Contacts > Edit Contact screen or the Contacts Student screen.

Note: Functionality has been added to automatically create contact records for students that don't already have at least one contact record defined. This functionality will be invoked each time a school or district uses the AzEDS dashboard to publish student contacts (Schedule > Publish All or Publish Missing).

The logic will automatically parse the mother and father fields defined in the Students table and create separate contact records for each, but only when a student doesn't already have at least one student contact and relationship defined. If the field cannot be successfully parsed, then no contact record will be created automatically and the district/school will have to manually create a contact record as needed. For more information about the automatic creation of Student Contacts, see AzEDS Reference.

Click Add Contact Relationship to associate a student with a contact.

Contact

Enter the name of the contact to associate with the student.

Contact Name associated with the student is displayed, but the value stored in the field is the contact’s ID.

* Required for AzEDS reporting.

[S_CONTACT_RELATIONSHIP_C] S_Contacts_SID

AzEDS:

StudentParentAssociation

Relationship

Enter the contact’s relationship to the student.

* Optional for AzEDS reporting.

[S_CONTACT_RELATIONSHIP_C] Relationship

AzEDS:

StudentParentAssociation

Primary Contact

Indicates whether the associated contact is the primary contact.

* Optional for AzEDS reporting.

[S_CONTACT_RELATIONSHIP_C] Primary_Contact

AzEDS:

StudentParentAssociation

Verifying Attendance Records

Attendance

Attendance

Verify that attendance data is entered for the student.

PowerSchool tracks absence attendance records for students (one record maximum per day). If the student is associated with a Homebound SAIS Need, PowerSchool tracks all attendance for that student.

Note: Beginning in fiscal year 2007, students cannot have a full day absence on the first or last day of a school enrollment unless the absence falls on the first day of the calendar track to which the student is assigned. The student must attend school during the first ten days of the calendar track.

Note: As of the 2008-2009 school year, SAIS only accepts Time-to-Day attendance conversions for PK and homebound students.

[Attendance]

AzEDS:

StudentSchoolAttendanceEvent

StudentSectionAttendanceEvent

Entering Clock In/Clock Out Times

Attendance > Meeting > Clock In / Clock Out

Meeting Clock In / Clock out times are used to designate partial period attendance for a section. When a student is either clocked in or clocked out within the time frame of a particular section, the student will receive the appropriate number of minutes attended for just the section in which the Clock-in or Clock-out occurred. If there is no clock in or clock out time within the time frame of a section enrollment, the attendance code for the class will determine absence / presence status.

When using Clock In / Clock Out functionality, attendance should be taken for each class in the bell schedule to ensure accurate attendance reporting. Clock In / Clock Out records do not determine presence/absence status for a class. They are used to determine how many minutes of a class the student attended if the Clock In or Clock out time-stamp bisects a class.

For instance, when clocking a student out of school at 10:30am, the student would need to be given an absence mark in each of his remaining classes for the day.

Meeting Clock In / Clock Out times will be used in the following Arizona-specific attendance methods:

• Percent of Day Present (K-8 schools)

• Method 2: Minutes Attended (High schools)

• Minutes of Attendance (Alternative schools)

Student

The student's name is displayed.

[Students]LastFirst

N/A

Attendance Date

The date of attendance is displayed.

[S_STU_Attendance_MeetingTime_C]Att_Date

AzEDS:

StudentSchoolAttendanceEvent

Clock In and Clock Out Times

Click the green Plus icon to generate a new Clock In / Clock Out line.

Enter the desired clock in or clock out time. (blank values will default to the start or end of the student's day).

Save.

Notes:

• The red minus icon is used to remove a Clock In / Clock Out line.

• The Clock In / Clock Out time considers sections that take attendance once across multiple periods to be one block of time. Any overlapping Clock In / Clock Out time span affects the Present Minute calculations of the whole section.

[S_Stu_Attendance_MeetingTime_C]Start_Time

[S_STU_Attendance_MeetingTime_C]End_Time

Note: Start_Time and End_Time are stored as 'seconds after midnight' in the database.

AzEDS:

StudentSchoolAttendanceEvent

Comments

In the Clock In / Clock Out entry box, click the speech bubble icon next to the clock in/clock out time.

A row for comment-entry appears beneath the times. If applicable, enter/edit any clock in / clock out comments.

Save.

A blue icon indicates comments are currently present. A gray icon indicates no comments are currently present.

[S_STU_Attendance_MeetingTime_C] ClockInComment

[S_ STU _Attendance_MeetingTime_C] ClockOutComment

Edit Clock In / Clock Out Comments

To edit comments after initial time submission, on the Edit Meeting Attendance page, click the speach bubble icon next to the clock in / clock out time. The Edit Clock In / Clock Out Comments box appears.

Enter/edit any clock in / clock out comments.

Save.

[S_STU_Attendance_MeetingTime_C] ClockInComment

[S_STU_Attendance_MeetingTime_C] ClockOutComment

Viewing Meeting Minutes Summary

Attendance > Meeting > Clock In / Clock Out > Meeting Time Summary

Note: This field is read-only and is only visible when per-minute meeting attendance is enabled at the school level. Enable at [Select School] > School > Attendance Preferences.

Period

The period number.

[Period]Period_Number

Course Name

The name of the course.

[Courses]Course_Name

Section Number

The section number.

[Sections]Section_Number

Present Minutes

The total minutes the student was present during the given period.

Calculated based on:

[S_AZ_PRESENTMINUTES_S]Start_Time

[ S_AZ_PRESENTMINUTES_S ]End_Time

Potential Minutes

The total minutes in the period.

ADA Calculated

Indicates whether or not the record is ADA calculated.

JTED Exclusion

Indicates whether or not the record is a JTED exclusion.

Verifying AOI Attendance

Attendance > AOI Attendance

For information on how to import AOI attendance, see the Student AOI Import.

Attendance Code

The attendance code associated with the record. – Not required

[S_AZ_STU_AOIATT_C]att_code

Ed-Fi: Student Attendance

Student SDADMS72 Audit

Attendance Minutes

The amount of instructional minutes in the reported session – Required

[S_AZ_STU_AOIATT_C]minutes

Ed-Fi: Student Attendance

Student SDADMS72 Audit

Start Time

The start time of the instructional period. – Not Required

[S_AZ_STU_AOIATT_C]start_time

Ed-Fi: Student Attendance

Student SDADMS72 Audit

End Time

The end time of the instructional period. – Not required

[S_AZ_STU_AOIATT_C]end_time

Ed-Fi: Student Attendance

Student SDADMS72 Audit

LMS Id

The unique ID of the attendance record from the Learning Management System (LMS) where the attendance was recorded. – Not required

[S_AZ_STU_AOIATT_C]LMSId

Ed-Fi: Student Attendance

Student SDADMS72 Audit

Section Id

The PowerSchool sectionid of the instructional minutes (if collected). – Not required

[S_AZ_STU_AOIATT_C]SectionId

Ed-Fi: Student Attendance

Student SDADMS72 Audit

Transferring the Student Out

Functions > Transfer Out of School

When a student is Transferred Out of School using this function, the student is automatically exited from any open 011, 013, 014, or 015 Needs. An open Need is a Need record with an exit date greater than the Date of Transfer or 0/0/0). SPED students (14 Needs) are exited with a SPED exit reason corresponding to the withdrawal reason selected (according to the state's SPED Exit Validation Matrix).

If the student has any open Concurrent School enrollments, the records will be listed. Check the box next to the open Concurrent Enrollment to exit the student from the Concurrent School also. The exit date, exit code, and withdrawal reason selected will be applied to the Concurrent Enrollment.

Transfer comment

Enter a comment for the student transfer.

[Students]ExitComment

[S_AZ_STU_CONENR_C]ExitComment

Not Required

Date of transfer

Enter the date of the transfer, the exit date for the enrollment. Enter the day after the student’s last day of school enrollment, even if that day occurs during a weekend.

For example, if the student’s last day at the school is 4/23/2010, enter 4/24/2010 as the exit date. This logic is required because PowerSchool does not calculate attendance for the exit date, so do not enter a date on which the student could potentially have attended school.

For no-show students, enter the same day as the entry date.

[Students]ExitDate

[S_AZ_STU_CONENR_C]ExitDate

Arizona Enrollment and Attendance Reports

AzEDS: StudentSchoolAssociation

Student Needs Extract

Community College Extract

Exit Code

Choose the exit code for the school enrollment.

NS is a PowerSchool-specific exit code used to exit no-show students (a student who enrolled but never showed up at the school). A delete enrollment transaction is created instead of an add withdrawal transaction when the NS exit code is selected.

W7 applies only to grade levels 11 and 12 for fiscal year 2007 and forward.

“S” exit codes are used for summer school withdrawals.

The PS exit code would not be used in this case because PS is only used to track a change to a school enrollment, not to transfer the student to another school.

[Students]ExitCode

[S_AZ_STU_CONENR_C]ExitCode

Arizona Enrollment and Attendance Reports

AzEDS: StudentSchoolAssociation

Also transfer out of select programs

If the student is currently enrolled in any special programs, select the checkboxes for the programs that the student is exiting.

[SpEnrollments]Exit_Date

Not Required

Withdrawal Reason

Choose a withdrawal reason code for regular withdrawals (W exit code) and summer withdrawals (S exit code).

This code does not apply to students who withdraw from school prior to the last day of the school year.

Valid values:

• School Labeled Underperforming

• School Labeled persistently dangerous

• Individual Transfer Option (victim of a violent crime or criminal act)

• Pregnancy/Biological Parent of a Child

[Students]Withdrawal_Reason_Code

[ReEnrollments]Withdrawal_ReasonCode

[S_AZ_STU_CONENR_C]WithdrawalReason

AzEDS: StudentSchoolAssociation

Also transfer out of selected concurrent schools:

If the student is currently enrolled in any concurrent schools, select the checkboxes for the schools that the student is exiting.

Note: This field only displays if the student has open (exit date in the future) concurrent enrollments.

[S_AZ_STU_CONENR_C]Schoolid

[S_AZ_STU_CONENR_C]EntryDate

[S_AZ_STU_CONENR_C]ExitDate

Arizona Enrollment and Attendance Reports

AzEDS: StudentSchoolAssociation

Intention to enroll next year

Select the checkbox to save scheduling information for the student if they intend to enroll in school next year.

N/A

Not Required

Re-Enrolling the Student in School

Functions > Re-Enroll in School

Note: This function allows for re-enrolling a student in Needs when Re-Enrolling in School. Needs records are listed for re-enrollment where the Need Exit Date equals the student’s previous school enrollment Exit Date.

Date of re-enrollment

Enter the entry date for the school enrollment.

Note: The date is the first day of school enrollment.

[Students]EntryDate

Student Needs Extract

Community College Extract

Entry Code

Choose the entry code for the school enrollment.

Each student should have only one E (entry) code per school, per school year.

An R (re-enrollment) entry code should be used for each readmission into a school for a given year, unless the new enrollment is to document a track change.

The R code must match the W (withdrawal) code from the previous enrollment for the current year.

The PS exit code is used to track a change to a school enrollment that does not require an R entry code. For example, if the student is promoted from 3^rd to 4^th grade, a new school enrollment must be created to track the grade level change. The PS code triggers PowerSchool to include the old enrollment with an update (end) transaction (PS exit code) and the new enrollment with an add transaction (PS entry code) in the next SAIS upload file.

[Students]EntryCode

Full-Time Equivalency

Choose the full-time equivalency for the school enrollment.

[Students]FTEID

[Students]MembershipShare

Required Setup

Grade Level

Choose the grade level for the school enrollment.

• PK3 = PS

• PK4 = PS

• KG = KG

[Students]Grade_Level

Ungraded Elementary

Displays when grade level KG is selected.

Check the box if applicable:

• Per A.R.S. § 15-901(A)(5)(a)(i): Student must be 5 years old but less than 6 by September 1st and must have a Group B SPED service for each day of UE membership (A, EDP, HI, MD, MDSSI, MOID, OI, PSD, SID, and VI).

[S_AZ_STU_X]UngradedElementary

AzEDS:

Student School Association

Track

Choose the track for the school enrollment.

[Students]Track

Not Required

District of Residence

Choose the district of residence for the school enrollment.

The district of residence is used as the District of Funding. Funding is provided to the district for each student whose school enrollment is associated with the district. The district of residence must be a nine-digit value that does not include dashes.

[Students]DistrictOfResidence

Restore Class Enrollments?

Choose Yes or No to indicate whether to re-enroll the student in their previous class enrollments at the school.

N/A

N/A

Tuition Payer

Choose the student’s tuition payer status.

Valid values:

• 1 – State Funded

• 2 – Privately Paid or No Tuition

• 3 – Foreign Exchange Student

• 4 – NSE Students in Residential Treatment Centers

• 5 – JTED/Non-Resident Charter (concurrent)

• 6 – ISEP Student

• 7 – Other State Funded Formula

[Students]TuitionPayer

Special Enrollment Code

The student’s special enrollment code.

Valid values:

• 1 – CECA

• 2 – CECB

• 3 – Open Enrollment

• 4 – 976-State Assistance (AzEDS Only)

• 5 – 823-Interstate Compact (AzEDS Only)

[Students]EnrollmentCode

Enrollment Type

The student’s Enrollment (Membership) Type Codes, entered on the Transfer Info > Edit Enrollment page.

The T enrollment type should be used with all AOI (Online) school enrollments.

The P enrollment type is used for Needs Only (program only) students. This code is only applicable to AzEDS reporting.

• For Program Only students, ADE is expecting a School Enrollment (StudentSchoolAssociation) with entry and exit dates covering the dates of the program, with an enrollment type of P.

[Students]EnrollmentType

School Entity ID Override

Use this field to populate a School Entity ID for Tuitioned Out students.

To be used only with Tuitioned-Out students at a Tuitioned-Out School.

A Tuitioned-Out School is a PowerSchool School with an EntityID = 00000 on the Edit School page at the District Office (Schools/School Info screen).

[S_AZ_STU_X]EntityID_Ovr

AzEDS:

All interchanges reporting EntityID.

Student Needs

A list of Student Needs records where the Need Exit Date equals the student’s previous school enrollment Exit Date is displayed.

Check the box to re-enroll the student in the Need when re-enrolling in school.

[S_AZ_STU_StudentNeed_C]NeedCode

Student Language Program Participation

A list of Student Language Program Participation records where the Need Exit Date equals the student’s previous school enrollment Exit Date is displayed.

Check the box to re-enroll the student in the Need when re-enrolling in school.

[S_AZ_STU_LanguageProgram_C] ProgramNeedCode

[S_AZ_STU_LanguageProgram_C] ProgramCode

Student SPED Service Participation

A list of Student SPED Service Participation records where the Need Exit Date equals the student’s previous school enrollment Exit Date is displayed.

Check the box to re-enroll the student in the Need when re-enrolling in school.

[S_AZ_STU_SPED_Service_C]NeedCode

[S_AZ_STU_SPED_Service_C]ServiceCode

Student Support Program Participation

A list of Student Support Program Participation records where the Need Exit Date equals the student’s previous school enrollment Exit Date is displayed.

Check the box to re-enroll the student in the Need when re-enrolling in school.

[S_AZ_STU_SupportProgram_C] SupportNeedCode

[S_AZ_STU_SupportProgram_C] SupportProgramCode

Grand Canyon Diploma Participation

A list of Grand Canyon Program Participation records where the Program Exit Date equals the student’s previous school enrollment Exit Date is displayed.

Check the box to re-enroll the student in the Program when re-enrolling in school.

Note: The student’s previous GCD enrollments dates are displayed.

[S_AZ_STU_GCD_C]EntryDate

[S_AZ_STU_GCD_C]ExitDate

Creating a New Concurrent Enrollment

Functions > Create New Concurrent Enrollment

This function allows for creating concurrent school enrollments for state reporting purposes. Records created using this function are reported through AzEDS publishing and are included in State Reporting Enrollment and Attendance reports (System Reports link), but are NOT included in SAIS reporting. Enrollment records created using this function are stored in the S_AZ_STU_CONENR_C table.

When creating a new Concurrent Enrollment record, the term at the top of the page must match the term year for the enrollment dates.

If importing into the S_AZ_STU_CONENR_C table, it is recommended to create one concurrent enrollment record manually, then export the data using the Page and Data Management > Data Export Manager function, then use the exported data as a template for importing additional enrollments. Please note that FTEID is specific to a school and term year.

Note: To enroll students in classes at the concurrently enrolled school, use the Functions > Enroll In A Class At Another School function.

Important: Due to a limitation with Time Attendance, a student cannot be concurrently enrolled in two AOI schools at the same time.

Concurrent School

Select the school for the concurrent enrollment.

Note: The list includes all schools not excluded from state reporting.

[S_AZ_STU_CONENR_C]SCHOOLID

Arizona Enrollment and Attendance Reports

AzEDS: StudentSchoolAssociation

Entry Date

Enter the entry date for the concurrent enrollment.

Note: Defaults to today’s date.

[S_AZ_STU_CONENR_C]ENTRYDATE

Arizona Enrollment and Attendance Reports

AzEDS: StudentSchoolAssociation

Entry Code

Choose the entry code for the school enrollment.

Each student should have only one E (entry) code per school, per school year.

An R (re-enrollment) entry code should be used for each readmission into a school for a given year.

The R code must match the W (withdrawal) code from the previous enrollment for the current year.

See below for details regarding use of the PS entry and exit codes.

[S_AZ_STU_CONENR_C]ENTRYCODE

Arizona Enrollment and Attendance Reports

AzEDS: StudentSchoolAssociation

The PS entry and exit codes are used to track a change to a school enrollment that does not require the student to be withdrawn and enrolled. For example, if the student is promoted from 3^rd to 4^th grade.

To track these types of changes, exit the student from his current enrollment with an exit date the day after his enrollment change (day after his last day in 3^rd grade for example) and an exit code of PS. Then create a new Concurrent Enrollment record with an entry date equal to the first day of his enrollment change (the first day in 4^th grade) and an entry code of PS.

Use PS codes to track changes to the following:

• Grade Level

• District of Residence

• Full-Time Equivalency

• Tuition Payer

• Special Enrollment Code

Entry Comment

Enter an entry comment.

[S_AZ_STU_CONENR_C]ENTRYCOMMENT

NA

Exit Date

Enter the exit date for the school enrollment. Enter the day after the student’s last day of school enrollment, even if that day occurs during a weekend.

For example, if the student’s last day at the school is 4/23/2010, enter 4/24/2010 as the exit date. This logic is required because PowerSchool does not calculate attendance for the exit date, so do not enter a date on which the student could potentially have attended school.

For no-show students, enter the same day as the entry date.

[S_AZ_STU_CONENR_C]EXITDATE

Arizona Enrollment and Attendance Reports

AzEDS: StudentSchoolAssociation

Exit Code

Choose the exit code for the school enrollment.

NS is a PowerSchool-specific exit code used to exit no-show students (a student who enrolled but never showed up at the school).

See above for information regarding use of the PS exit code.

[S_AZ_STU_CONENR_C]EXITCODE

Arizona Enrollment and Attendance Reports

AzEDS: StudentSchoolAssociation

Exit Comment

Enter an exit comment.

[S_AZ_STU_CONENR_C]EXITCOMMENT

Full-Time Equivalency

Choose the full-time equivalency for the concurrent school enrollment.

Note: The values displayed are determined by the School selected and the Entry Date entered.

[S_AZ_STU_CONENR_C]FTEID

[Students]MembershipShare

Arizona Enrollment and Attendance Reports

AzEDS: StudentSchoolAssociation

Grade Level

Choose the grade level for the school enrollment.

• PK3 = PS

• PK4 = PS

• KG = KG

[S_AZ_STU_CONENR_C]GRADE_LEVEL

Arizona Enrollment and Attendance Reports

AzEDS: StudentSchoolAssociation

Ungraded Elementary

Displays when grade level KG is selected.

Check the box if applicable:

• Per A.R.S. § 15-901(A)(5)(a)(i): Student must be 5 years old but less than 6 by September 1st and must have a Group B SPED service for each day of UE membership (A, EDP, HI, MD, MDSSI, MOID, OI, PSD, SID, and VI).

[S_AZ_STU_CONENR_C]UngradedElementary

AzEDS:

Student School Association

Track

Choose the track for the school enrollment.

[S_AZ_STU_CONENR_C]TRACK

Arizona Enrollment and Attendance Reports

AzEDS: StudentSchoolAssociation

District of Residence

Choose the district of residence for the school enrollment.

District of residence (DOR) receives funding for the student’s membership.

[S_AZ_STU_CONENR_C] DISTRICTOFRESIDENCE

Arizona Enrollment and Attendance Reports

AzEDS: StudentSchoolAssociation

Tuition Payer

Choose the student’s tuition payer status.

Valid values:

• 1 – State Funded

• 2 – Privately Paid or No Tuition

• 3 – Foreign Exchange Student

• 4 – NSE Students in Residential Treatment Centers

• 5 – JTED/Non-Resident Charter (concurrent)

• 6 – ISEP Student

• 7 – Other State Funded Formula

[S_AZ_STU_CONENR_C]TUITIONPAYER

Arizona Enrollment and Attendance Reports

AzEDS: StudentSchoolAssociation

Special Enrollment Code

The student’s special enrollment code.

Valid values:

• 1 – CECA

• 2 – CECB

• 3 – Open Enrollment

• 4 – 976-State Assistance (AzEDS Only)

• 5 – 823-Interstate Compact (AzEDS Only)

[S_AZ_STU_CONENR_C]ENROLLMENTCODE

Arizona Enrollment and Attendance Reports

AzEDS: StudentSchoolAssociation

Enrollment Type

The student’s Enrollment (Membership) Type Codes, entered on the Transfer Info > Edit Enrollment page.

The T enrollment type should be used with all AOI (Online) school enrollments.

The P enrollment type is used for Needs Only (program only) students. This code is only applicable to AzEDS reporting.

For Program Only students, ADE is expecting a School Enrollment (StudentSchoolAssociation) with entry and exit dates covering the dates of the program, with an enrollment type of P.

[S_AZ_STU_CONENR_C]ENROLLMENTTYPE

Arizona Enrollment and Attendance Reports

AzEDS: StudentSchoolAssociation

Withdrawal Reason

Choose a withdrawal reason code for regular withdrawals (W exit code) and summer withdrawals (S exit code).

This code does not apply to students who withdraw from school prior to the last day of the school year.

Valid values:

• School Labeled Underperforming

• School Labeled persistently dangerous

• Individual Transfer Option (victim of a violent crime or criminal act)

• Pregnancy/Biological Parent of a Child

[S_AZ_STU_CONENR_C] WITHDRAWALREASON

Arizona Enrollment and Attendance Reports

AzEDS: StudentSchoolAssociation

Previous LEA

Enter the name of the district or Charter School the student attended in the previous school year OR the ISEP / Non-ISEP data if applicable.

Note: If a student completed the school year in your district the previous school year, there is no need to enter a Previous LEA. The report will pull a student’s previous school automatically.

Populate either ISEP or Non-ISEP for each student if your Charter School is receiving Indian School Equalization Program (ISEP) funds.

Use the Student Field Value function to mass populate ISEP / Non-ISEP values for all students.

Valid Values:

• ISEP

• Non-ISEP

[S_AZ_STU_CONENR_C]PREVIOUSLEA

Charter Estimated Counts

School Entity ID Override

Use this field to populate a School Entity ID for Tuitioned Out students.

To be used only with Tuitioned-Out students at a Tuitioned-Out School.

A Tuitioned-Out School is a PowerSchool School with an EntityID = 00000 on the Edit School page at the District Office (Schools/School Info screen).

[S_AZ_STU_CONENR_C]EntityID_Ovr

AzEDS:

All interchanges reporting EntityID.

JTED Student Indicator

Choose Yes to include the student in JTED reports.

Choosing Yes indicates that the student attends an alternate enrollment scenario – the student is concurrently enrolled in a career and technical education courses offered at another campus.

[S_AZ_STU_CONENR_C]JTED_Indicator

AzEDS:

StudentSchoolAssociations

StudentSchoolAssociationMembershipFTEs

StudentSchoolAssociationLocal
EducationAgencies

StudentSchoolAttendanceEvent

JTED Satellite Tuition Payer

Choose the student’s tuition payer status.

Valid values:

• 1 – State Funded

• 2 – Privately Paid or No Tuition

Note: If blank, a default value will be published to AzEDS based on the student's non-JTED Tuition Payer code.

[S_AZ_STU_CONENR_C]JTED_TuitionPayer

AzEDS:

StudentSchoolAssociations

JTED School CTDS

Enter the County Code-Type Code-District Code-Site Number (CTDS) of the student’s school.

[S_AZ_STU_CONENR_C]JTED_School_CTDS

AzEDS:

StudentSchoolAssociations

StudentSchoolAssociationMembershipFTEs

StudentSchoolAssociationLocal
EducationAgencies

StudentSchoolAttendanceEvent

JTED Concurrent CTDS

Enter the CTDS of the student’s concurrent school, i.e. the school that the student attends during the same time period as the current school.

[S_AZ_STU_CONENR_C] JTED_Concurrent_CTDS

AzEDS:

StudentSchoolAssociations

StudentSchoolAssociationMembershipFTEs

StudentSchoolAssociationLocal
EducationAgencies

StudentSchoolAttendanceEvent

Editing a Current/Previous Enrollment

Transfer Information > Edit/New

Entry Date

Enter the entry date for the school enrollment.

Note: The date is the first day of school enrollment.

[Students]EntryDate

[ReEnrollments]EntryDate

[S_AZ_STU_CONENR_C]ENTRYDATE

Student Needs Extract

Community College Extract

AzEDS: StudentSchoolAssociation

Entry Code

Choose the entry code for the school enrollment.

Each student should have only one E (entry) code per school, per school year.

An R (re-enrollment) entry code should be used for each readmission into a school for a given year, unless the new enrollment is to document a track change.

The R code must match the W (withdrawal) code from the previous enrollment for the current year.

The PS exit code is used to track a change to a school enrollment that does not require the student to be withdrawn and enrolled. For example, if the student is promoted from 3^rd to 4^th grade, a new school enrollment must be created to track the grade level change. The PS code triggers PowerSchool to include the old enrollment with an update (end) transaction (PS exit code) and the new enrollment with an add transaction (PS entry code) in the next SAIS upload file. Use PS codes to track changes to the following:

• Grade Level

• District of Residence

• Full-Time Equivalency

• Tuition Payer

• Special Enrollment Code

Enter changes to these elements via Start Page > Student > State/Province – AZ > Change Enrollment.

The new enrollment will appear on the Transfer Info page, where you can enter the appropriate entry code.

[Students]EntryCode

[ReEnrollments]EntryCode

[S_AZ_STU_CONENR_C]ENTRYCODE

AzEDS:
StudentSchoolAssociation

Exit Date

Enter the exit date for the school enrollment. Enter the day after the student’s last day of school enrollment, even if that day occurs during a weekend.

For example, if the student’s last day at the school is 4/23/2010, enter 4/24/2010 as the exit date. This logic is required because PowerSchool does not calculate attendance for the exit date, so do not enter a date on which the student could potentially have attended school.

For no-show students, enter the same day as the entry date.

[Students]ExitDate

[ReEnrollments]ExitDate

[S_AZ_STU_CONENR_C]EXITDATE

Student Needs Extract

Community College Extract

AzEDS:
StudentSchoolAssociation

Exit Code

Choose the exit code for the school enrollment.

Note: You must choose an exit code for school enrollments where the exit date is in the past.

NS is a PowerSchool-specific exit code used to exit no-show students (a student who enrolled but never showed up at the school).
A delete enrollment transaction is created instead of an add withdrawal transaction when the NS exit code is selected.

W7 applies only to grade levels 11 and 12 for fiscal year 2007 and forward.

The PS exit code is used to track a change to a school enrollment that does not require the student to be withdrawn and reenrolled. For example, if the student is promoted from 3^rd to 4^th grade, a new school enrollment must be created to track the grade level change. The PS code triggers PowerSchool to include the old enrollment with an update (end) transaction (PS exit code) and the new enrollment with an add transaction (PS entry code) in the next SAIS upload file. Use PS codes to track changes to the following:

• Grade Level

• District of Residence

• Full-Time Equivalency

• Tuition Payer

• Special Enrollment Code

[Students]ExitCode

[ReEnrollments]ExitCode

[S_AZ_STU_CONENR_C]EXITCODE

AzEDS:
StudentSchoolAssociation

Full-Time Equivalency

Choose the full-time equivalency for the school enrollment.

[Students]FTEID

[ReEnrollments]FTEID

[S_AZ_STU_CONENR_C]FTEID

[Students]MembershipShare

Required Setup

Grade Level

Choose the grade level for the school enrollment.

• PK3 = PS

• PK4 = PS

• KG = KG

[Students]Grade_Level

[ReEnrollments]Grade_Level

[S_AZ_STU_CONENR_C]GRADE_LEVEL

AzEDS:
StudentSchoolAssociation

Ungraded Elementary

Displays when grade level KG is selected.

Check the box if applicable:

• Per A.R.S. § 15-901(A)(5)(a)(i): Student must be 5 years old but less than 6 by September 1st and must have a Group B SPED service for each day of UE membership (A, EDP, HI, MD, MDSSI, MOID, OI, PSD, SID, and VI).

[S_AZ_STU_X]UngradedElementary

[S_AZ_REN_X]UngradedElementary

[S_AZ_STU_CONENR_C]UngradedElementary

AzEDS:

Student School Association

Track

Choose the track for the school enrollment.

[Students]Track

[ReEnrollments]Track

[S_AZ_STU_CONENR_C]TRACK

AzEDS:
Required Setup if applicable

District of Residence

Choose the district of residence for the school enrollment.

District of residence (DOR) receives funding for the student’s membership.

[Students]DistrictOfResidence

[ReEnrollments]DistrictOfResidence

[S_AZ_STU_CONENR_C] DISTRICTOFRESIDENCE

AzEDS:

StudentEducationOrganizationAssociation

Tuition Payer

Choose the student’s tuition payer status.

Valid values:

• 1 – State Funded

• 2 – Privately Paid or No Tuition

• 3 – Foreign Exchange Student

• 4 – NSE Students in Residential Treatment Centers

• 5 – JTED/Non-Resident Charter (concurrent)

• 6 – ISEP Student

• 7 – Other State Funded Formula

[Students]TuitionPayer

[ReEnrollments]TuitionPayer

[S_AZ_STU_CONENR_C]TUITIONPAYER

Required Setup

Special Enrollment Code

The student’s special enrollment code.

Valid values:

• 1 – CECA

• 2 – CECB

• 3 – Open Enrollment

• 4 – 976-State Assistance (AzEDS Only)

• 5 – 823-Interstate Compact (AzEDS Only)

[Students]EnrollmentCode

[ReEnrollments]EnrollmentCode

[S_AZ_STU_CONENR_C]ENROLLMENTCODE

Required Setup

Enrollment Type

Choose the student’s Enrollment (Membership) Type Codes.

The T enrollment type should be used with all AOI (Online) school enrollments.

The P enrollment type is used for Needs Only (program only) students. This code is only applicable to AzEDS reporting.

• For Program Only students, ADE is expecting a School Enrollment (StudentSchoolAssociation) with entry and exit dates covering the dates of the program, with an enrollment type of P.

[Students]EnrollmentType

[ReEnrollments]EnrollmentType

[S_AZ_STU_CONENR_C]ENROLLMENTTYPE

Required Setup

Withdrawal Reason

Choose a withdrawal reason code for regular withdrawals (W exit code) and summer withdrawals (S exit code).

This code does not apply to students who withdraw from school prior to the last day of the school year.

Valid values:

• School Labeled Underperforming

• School Labeled persistently dangerous

• Individual Transfer Option (victim of a violent crime or criminal act)

• Pregnancy/Biological Parent of a Child

[Students]Withdrawal_Reason_Code

[ReEnrollments]Withdrawal_ReasonCode

[S_AZ_STU_CONENR_C] WITHDRAWALREASON

Required, if applicable

Previous LEA

Enter the name of the district or Charter School the student attended in the previous school year OR the ISEP / Non-ISEP data if applicable.

Note: If a student completed the school year in your district the previous school year, there is no need to enter a Previous LEA. The report will pull a student’s previous school automatically.

Populate either ISEP or Non-ISEP for each student if your Charter School is receiving Indian School Equalization Program (ISEP) funds.

Use the Student Field Value function to mass populate ISEP / Non-ISEP values for all students.

Valid Values:

• ISEP

• Non-ISEP

[S_AZ_STU_X]PreviousLEA

[S_AZ_REN_X]PreviousLEA

[S_AZ_STU_CONENR_C]PREVIOUSLEA

Charter Estimated Counts

School Entity ID Override

Use this field to populate a School Entity ID for Tuitioned Out students.

To be used only with Tuitioned-Out students at a Tuitioned-Out School.

A Tuitioned-Out School is a PowerSchool School with an EntityID = 00000 on the Edit School page at the District Office (Schools/School Info screen).

[S_AZ_STU_X]EntityID_Ovr

[S_AZ_REN_X]EntityID_Ovr

[S_AZ_STU_CONENR_C]EntityID_Ovr

AzEDS:

All interchanges reporting EntityID.

Career and Technical Educational District Information (CTED)

CTED Student Indicator

Choose Yes to include the student in JTED reports.

Note: The JTED Student Indicator value is set to No for all active students during the PowerSchool End of Year process.

Use the ‘SAIS and JTED FTE Validation Tool’ Function to set JTED Student Indicators en masse for the upcoming school year.

For More information about this Function, see the SAIS and JTED FTE Validation Tool.

[S_AZ_STU_X]JTED_Indicator

[S_AZ_REN_X]JTED_Indicator

Student Information

Student Attendance Information

Attendance Audit Information

AzEDS:

Student Enrollment

Student Attendance

CTED Satellite Tuition Payer

Choose the student’s tuition payer status.

Valid values:

• 1 – State Funded

• 2 – Privately Paid or No Tuition

Note: If blank, a default value will be published to AzEDS based on the student's non-JTED Tuition Payer code.

[S_AZ_STU_X]JTED_TuitionPayer

[S_AZ_REN_X]JTED_TuitionPayer

AzEDS:

StudentSchoolAssociations

CTED School CTDS

Enter the County Code-Type Code-District Code-Site Number (CTDS) of the student’s school.

If reporting JTED Enrollments through AzEDS, enter the JTED school EntityID (not CTDS).

Note: The JTED Concurrent CTDS field is not used in AzEDS Reporting.

[S_AZ_STU_X]JTED_School_CTDS

[S_AZ_REN_X]JTED_School_CTDS

Student Information

AzEDS:

Student Enrollment

Student Attendance

Editing Stored Grade Records

Historical Grades > Edit/New Stored Grade

School Name

Enter or view the school at which the course was completed.

[StoredGrades]SchoolName

AzEDS:
CourseTranscript

School year (Term)

Enter the TermID associated with this historical grade.

[StoredGrades]TermID

AzEDS:
CourseTranscript
Grade
GradingPeriodReference
ReportCard
StudentAcademicRecord

Store Code

Store Code of the historical grade must match the Store Code value entered on the Student Course Enrollment / Final Grade Mapping screen on the School Setup screen at the District Office.

[StoredGrades]StoreCode

AzEDS: CourseTranscript
Grade
GradingPeriodReference
ReportCard
StudentAcademicRecord

Historical Grade Level

Enter or view the grade level the student was enrolled in when the grade was awarded.

[StoredGrades]Grade_Level

AzEDS:
StudentAcademicRecord
CourseTranscript

Associated Section (Edit Stored Grade page)

View the section associated with the stored grade.

Historical grade must be associated with a PowerSchool section.

[StoredGrades]SectionID

AzEDS:
Required Setup

Course number – Section number (New Stored Grade page)

Enter or view the course and section number associated with the stored grade.

[StoredGrades]Course_Number

[StoredGrades]Section_Number

AzEDS:
StudentAcademicRecord
CourseTranscript

Course Number (Edit Stored Grade page)

Enter or view the course number associated with the stored grade.

[StoredGrades]Course_Number

AzEDS:
StudentAcademicRecord
CourseTranscript

Course Name

Enter or view the name of the course associated with the stored grade.

[StoredGrades]Course_Name

AzEDS:
CourseTranscript

Grade

Enter the grade awarded for this historical grade.

[StoredGrades]Grade

AzEDS:
CourseTranscript
Grade
ReportCard

GPA Points

Enter or view the grade points.

[StoredGrades]GPA_Points

AzEDS:
StudentAcademicRecord

Percent

Enter or view the numeric grade.

[StoredGrades]Percent

AzEDS:
CourseTranscript
Grade
ReportCard

Earned Credit Hours

Enter the earned credit hours awarded for this historical grade.

[StoredGrades]EarnedCrHrs

AzEDS:
CourseTranscript
StudentAcademicRecord

Potential Credit Hours

Enter or view the number of credits available to be awarded for the course.

[StoredGrades]PotentialCrHrs

AzEDS:
CourseTranscript
StudentAcademicRecord

GPA Calculation

Select or view the option to include in or exclude from GPA calculations.

[StoredGrades]ExcludeFromGPA

AzEDS:
StudentAcademicRecord

Class Rank Calculation

Select or view the option to include in or exclude from class rank calculations.

[StoredGrades]ExcludeFromClassRank

AzEDS:
StudentAcademicRecord

Honor Roll Calculation

Select or view the option to include in or exclude from honor roll calculations.

[StoredGrades]ExcludeFromHonorRoll

AzEDS:

StudentAcademicRecord

Graduation Calculation

Select or view the option to include in or exclude from graduation calculations.

[StoredGrades]ExcludeFromGraduation

AzEDS:

Graduation Plan

Display on Transcript

Select or view the option to include in or exclude from the transcript.

[StoredGrades]ExcludeFromTranscripts

AzEDS:

CourseTranscript
StudentAcademicRecord

Teacher Comment

Enter or view the teacher comment.

[StoredGrades]Comment_Value

AzEDS:
Grade

Verifying Enrollment Records

All Enrollments > Edit Enrollment Record

Course

Information about the class of enrollment.

Format: CourseName (CourseNumber.SectionNumber)

[Courses]Course_Name

[CC]Course_Number

[Sections]Section_Number

AzEDS:

StudentSectionAssociation
StudentSectionAssociationReference

Enroll Date

Date the student enrolled in the section.

[CC]DateEnrolled

AzEDS:

StudentSectionAssociation

Exit Date

Date the student exited the section.

[CC]DateLeft

AzEDS:

StudentSectionAssociationReference

Course Entry Type

Enter a Course Entry Type override value if applicable.

* Leave blank to let the report calculate Course Entry Type.

[S_AZ_CC_X]EntryType

Course Exit Type

Enter a Course Exit Type override value if applicable.

* Leave blank to let the report calculate Course Exit Type.

[S_AZ_CC_X ]ExitType

Earning Dual Credits

Indicate if this student is earning Dual Credit in a Dual Credit course.

Note: Populate “N” if a student is enrolled in a Dual Credit class, but is not earning dual credit.

[S_AZ_CC_X ]DualCredit

Concurrently Enrolled

Indicate if the student is concurrently enrolled in a course that offers concurrent enrollment.

Note: Use “N” when the course does not offer concurrent enrollment.

[S_AZ_CC_X ]ConcurrentlyEnrolled

Notes

Enter any clarifying information for this course section.

[S_AZ_CC_X ]Notes

Standards Grades Identifier

(Populate if using Standards instead of Traditional grades for course)

Enter Standard Identifier if using Standards instead of Traditional grades for course.

Ex: LA.11.3.12

Note: Defaults to Section level setting if blank, then to course level if CC and Section are blank.

If no value is present in any Standards Grades Identifier field, Traditional grades are reported (StoredGrades).

[S_AZ_CC_X ]StandardID

Exclude from AZ Student-Teacher –Course Connection Reports

Click the checkmark to exclude From AZ Student-Teacher-Course Connection Reports.

Note: Defaults to section, then course level setting if blank.

[S_AZ_CC_X ]ExcludeSTC

CTE Federal/State Indicator

Choose a CTE Federal/State Indicator code.

Valid values:

• Blank (If blank, State will be reported)

• (F) Federal

• (S) State

[ S_AZ_CC_X ] CTEIndicator