School Information

Introduction

The following data elements are required for Alabama State Reporting setup at School level.

Start Page > District Setup > Schools/School Info

On the Start Page, click the School link at the top of the page. The school list appears.
Choose District Office. The district start page appears.
Click District. The District Setup page appears.
Click Schools/School Info under District Information category. The Schools/School Info appears.
Click on a School Name. The Edit School page appears.
Scroll down to Alabama State Reporting Information category.

Note: For Non-ALSDE AL districts, the process of creating a new school will follow the same procedures used by PowerSchool in other states, instead of relying on the school list from the U_AL_SCHOOLS table.

School Information

Data Element

Description

[Table]FieldName

Length

School County Name

Value will load from Valid School File and is READ ONLY

[U_AL_SCHOOLS]COUNTYNAME

79

School County Number

Value will load from Valid School File and is READ ONLY

[U_AL_SCHOOLS]COUNTYNBR

79

AL School Number

Alabama specific school number.

Pulls values from u_al_schools table with same set of validations as of core school number field.

[S_AL_SCH_X]AL Specific School Number

Alabama State Reporting Information

Data Element	Description	[Table]FieldName	Length
School Status	School is Active(open) or Inactive(closed) - READ ONLY field - No default value - Populated from Valid School File - If School Number is not found in Valid School File, set School Status = “Inactive” - If School Number is found in Valid School file, with “SiteOpenClosedStatus” value of “O”, set School Status = “Active” - If School Number is found in Valid School file, with “SiteOpenClosedStatus” value of “P”, set School Status = “Pending”	[S_SCH_X]SCHOOLSTATUS	1
Allow Enrollment	Data Collection identifies if the State allows enrollment for this school. Read Only - Value is determined from Valid School File. Where "ALLOWENROLLMENT = 1 for selected school, checkbox should be checked, Else = 0 (unchecked).	[U_AL_SCHOOLS]ALLOWENROLLMENT	1
Site Type	The Site Type of the District - READ ONLY field	[U_AL_SCHOOLS]Type
School Type	School Type - READ ONLY field - Default Value to be set to '02 - Public'	[S_SCH_X]SCHOOLTYPE	2
School PreK Programs	Click here to view School PreK Programs table
School PreK Fund	Click here to view School PreK Fund table
Regular InService Center	'After import, Regular Inservice Center for the school will be cecked if applicable for the school. Will load from Valid School File and is READ ONLY	[U_AL_SCHOOLS]REGULAR_INSERVICE_CENTER	50
AL State Board District	After import, AL State Board for the school will display Will load from Valid School File and is READ ONLY	[U_AL_SCHOOLS]AL_STATE_BOARD_DISTRICT	50
Access Support Center	After import, Access Support Center for the school will display Will load from Valid School File and is READ ONLY	[U_AL_SCHOOLS]ACCESS_SUPPORT_CENTER	50
Career Tech Region	After import, Career Tech Region for the school will display Will load from Valid School File and is READ ONLY	[U_AL_SCHOOLS]CAREER_TECH_REGION	50
Title I	School Title I is set by ALSDE with the options of "No Assistance, School Wide Program, and Target Assistance" via Valid School File - Will load from Valid School File. - READ ONLY. - If Valid School File value = "T" display "Targeted Assistance" - If Valid School File value = "S" display "School Wide" - If Valid School File value = "N' display "No Assistance" - If School Number is not found in Valid School File, set Title I = 'Blank’ - If Title 1 = "Targeted Assistance" disable Add/Edit button on 'Student Support: Title 1 Programs' section on Federal tab of State/Province - AL page	[U_AL_SCHOOLS]TITLEI	50
NCES ID	- Will load from Valid School File from "NCESID" where 'School SchNum' not equal to "0000" and corresponds to the correct district instance. - Value will not be stored in DB - READ ONLY	[U_AL_SCHOOLS]NCESID	31
USAC Entity #	- Will load from Valid School File from "USACEntityNumber" where 'School SchNum' not equal to "0000" and corresponds to the correct district instance. - Value will not be stored in DB - READ ONLY	[U_AL_SCHOOLS]USAC_ENTITY_NUMBER	19
McKenny Vento	Selected if the school is part of McKinney-Vento Homeless Assistance program (Read Only)	[U_AL_SCHOOLS]MCKENNYVENTO	1
N or D	Selected if Negligent or Delinquent (Read Only)	[U_AL_SCHOOLS]N_D	1
Migrant	Selected if Migrant (Read Only)	[U_AL_SCHOOLS]Migrant	1

School PreK Programs

Data Element	Description	[Table]FieldName	Length
Local Pre K	Select if the school provides a local PreK program.	[S_AL_SCH_X]PKProgram_LocalPREK_TF	1
OSR 1st Class	Select if the school is an OSR 1st Class site.	[S_AL_SCH_X]PKProgram_OSRFirstClass_TF	1
Headstart	Select if the school provides a Headstart program.	[S_AL_SCH_X]PKProgram_Headstart_TF	1

School PreK Fund

Data Element	Description	[Table]FieldName	Length
State	Select if the school's PreK is funded by the state.	[S_AL_SCH_X]PKFund_State_TF	1
Title I	Select if the school receives funds for PreK Title I.	[S_AL_SCH_X]PKFund_TitleI_TF	1
Local	Select if the school's PreK is funded locally.	[S_AL_SCH_X]PKFund_Local_TF	1
Headstart Grant	Select if the school receives the Headstart Grant.	[S_AL_SCH_X]PKFund_HeadstartGrant_TF	1