SPS - Sponsor Site System

Use

If run at the district level, choose one of the following from the pop-up menu:

• Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria.
• Current School Only – Includes all records associated with the current school that meet the selection criteria.
• District Wide – Includes all records on the PowerSchool server that meet the selection criteria.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Select District

(Optional) If this option appears, select the District for which to run the report.

Destination

Choose one of the following from the pop-up menu:

• Browser – View the report results in a browser.
• Save as Local File (Default) – Save the report results as a text file to your computer and view the results using a text editor.

1

System Indicator

Always extracted as “SPS.”

N/A

3

2

Session Year

The school year selected at report runtime. To change this value, click Term at the top of the page, choose the correct term and re-run the report.

[Terms]FirstDay

[Terms]LastDay

4

3

Sponsor Code

The sponsor code, extracted as the first three digits of the school’s site code.

[S_LA_SCH_X]SiteCode

3

4

Site Code

The school’s site code.

[S_LA_SCH_X]SiteCode

6

5

Record Type

Always extracted as “01.”

“01”

2

6

Site Name

The name of the school.

[Schools]Name

46

7

Street Address

The mailing street address of the school. If the “Street Address” field is blank under Louisiana State Information on the Edit School page, then this value is extracted from the “School Address” field.

[S_LA_SCH_X]MailingAddress

[Schools]SchoolAddress

35

8

City

The school’s mailing city. If the “City” field is blank under Louisiana State Information on the Edit School page, then this value is extracted from the “School City” field.

[S_LA_SCH_X]MailingCity

[Schools]SchoolCity

25

9

Zip Code

The school’s mailing zip code. If the “Zip Code” field is blank under Louisiana State Information on the Edit School page, then this value is extracted from “School Postal/Zip Code.”

[S_LA_SCH_X]MailingZipFive

[Schools]SchoolZip

5

10

Zip Code Extension

The five-digit zip code extension for the school. If the “Zip Code” field is blank under Louisiana State Information on the Edit School page, then this value is extracted from “School Postal/Zip Code.”

[S_LA_SCH_X]MailingZipPlusFour

[Schools]SchoolZip

4

11

State

The school’s mailing state, entered on the Edit School page.

[Schools]SchoolState

2

12

Phone Area Code

The school’s area code, entered on the Edit School page.

[Schools]SchoolPhone

3

13

Phone Number

The school’s phone number, entered on the Edit School page.

[Schools]SchoolPhone

3, 4

14

Phone Extension

The school’s phone extension, entered on the Edit School page under Louisiana State Information.

[S_LA_SCH_X]PhoneExtension

4

15

Fax Number

The school’s fax number, entered on the Edit School page.

[Schools]SchoolFax

3

16

Site Final Close Date

The school’s final close date. This field is extracted as blank if not populated on the Edit School page.

[S_LA_SCH_X]CloseDate

8

17

Parish/City Code

The school’s county number.

[Schools]CountyNbr

2

18

Institution Control

The institution that controls the site.

Valid values:

• 1 – LEA/Local
• 2 – State
• 3 – Federal
• 4 – Other

[S_LA_SCH_X]InstitutionControlCode

1

19

Institution Funding

The institution that funds the site.

Valid values:

• 1 – Public/MFP
• 2 – Public/Other
• 3 – Nonpublic
• 4 – Federal

[S_LA_SCH_X]InstitutionFundingCode

1

20

Tuition

Indicates if tuition is required for the school.

[S_LA_SCH_X]TuitionChargedInd_TF

1

21

Religious Affiliation

Indicates the school’s religious affiliation.

Valid values:

• 0 – None
• 02 – Assembly of God
• 03 – Baptist
• 04 – Catholic
• 05 – Church of Christ
• 06 – Church of God
• 07 – Episcopal
• 08 – Inter-Denomination
• 09 – Jewish
• 10 – Lutheran
• 11 – Methodist
• 12 – Mormon
• 13 – Pentecostal
• 14 – Presbyterian
• 15 – Seventh-Day Adventist
• 16 – Islam
• 17 – Other

[S_LA_SCH_X]ReligiousAffiliationCode

2

22

Congressional District

The school’s congressional district.

Valid values:

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9

[S_LA_SCH_X]CongressionalDistrictCode

1

23

Institution Type

The institution type of the site.

Valid values:

• 01 – School
• 02 – Administrative Office
• 04 – Child and Adult Nutrition Site (only)
• 05 – Adult Education (only)
• 06 – Postsecondary
• 07 –Non-educational Site
• 08 – In-Home Schooling
• 09 – Preschool
• 10 – Education Site (Not a school)

[S_LA_SCH_X]InstitutionTypeCode

2

24

School Business Partnership Count

The count of school business partnerships.

Valid values: 1-99

[S_LA_SCH_X]BusinessPartnershipCountCode

2

25

City Limits

Indicates if the site is within the city limits.

[S_LA_SCH_X]InsideCityLimits_TF

1

26

Filler

N/A

N/A

51

Site Grade Data

27

System Indicator

Always extracted as “SPS.”

“SPS”

3

28

Session Year

The school year selected at report runtime. To change this value, click Term at the top of the page, choose the correct term and re-run the report.

[Terms]FirstDay

[Terms]LastDay

4

29

Sponsor Code

The sponsor code, extracted as the first three digits of the school’s site code.

[S_LA_SCH_X]SiteCode

3

30

Site Code

The school’s site code.

[S_LA_SCH_X]SiteCode

6

31

Record Type

Always extracted as “02.”

“02”

2

32

Grade 1

Indicates if the site offers classes/services for grade level 1 students.

[S_LA_SCH_SPSGrades_X]SPSGrade1_TF

2

33

Grade 2

Indicates if the site offers classes/services for grade level 2 students.

[S_LA_SCH_SPSGrades_X]SPSGrade2_TF

2

34

Grade 3

Indicates if the site offers classes/services for grade level 3 students.

[S_LA_SCH_SPSGrades_X]SPSGrade3_TF

2

35

Grade 4

Indicates if the site offers classes/services for grade level 4 students.

[S_LA_SCH_SPSGrades_X]SPSGrade4_TF

2

36

Grade 5

Indicates if the site offers classes/services for grade level 5 students.

[S_LA_SCH_SPSGrades_X]SPSGrade5_TF

2

37

Grade 6

Indicates if the site offers classes/services for grade level 6 students.

[S_LA_SCH_SPSGrades_X]SPSGrade6_TF

2

38

Grade 7

Indicates if the site offers classes/services for grade level 7 students.

[S_LA_SCH_SPSGrades_X]SPSGrade7_TF

2

39

Grade 8

Indicates if the site offers classes/services for grade level 8 students.

[S_LA_SCH_SPSGrades_X]SPSGrade8_TF

2

40

Grade 9

Indicates if the site offers classes/services for grade level 9 students.

[S_LA_SCH_SPSGrades_X]SPSGrade9_TF

2

41

Grade 10

Indicates if the site offers classes/services for grade level 10 students.

[S_LA_SCH_SPSGrades_X]SPSGrade10_TF

2

42

Grade 11

Indicates if the site offers classes/services for grade level 11 students.

[S_LA_SCH_SPSGrades_X]SPSGrade11_TF

2

43

Grade 12

Indicates if the site offers classes/services for grade level 12 students.

[S_LA_SCH_SPSGrades_X]SPSGrade12_TF

2

44

Grade 13

Not collected.

N/A

2

45

Grade 14

Not collected.

N/A

2

46

Infant

Indicates if the site offers classes/services for grade level infants.

[S_LA_SCH_SPSGrades_X]SPSGrade15_TF

2

47

Preschool (SPED only)

Indicates if the site offers classes/services for special education preschool students.

[S_LA_SCH_SPSGrades_X]SPSGrade20_TF

2

48

Prekindergarten

Indicates if the site offers classes/services for pre-kindergarten students.

[S_LA_SCH_SPSGrades_X]SPSGrade24_TF

2

49

Kindergarten

Indicates if the site offers classes/services for kindergarten students.

[S_LA_SCH_SPSGrades_X]SPSGrade25_TF

2

50

Grade 40

Indicates if the site offers classes/services for community college students.

[S_LA_SCH_SPSGrades_X]SPSGrade40_TF

2

51

Nongraded

Not collected.

N/A

2

52

Organization Pattern Code

The site’s organization pattern code.

Valid values:

• 1 – Self-Contained
• 2 – Semi-Departmentalized
• Departmentalized
• 4 – Other/Child Care

[S_LA_SCH_X]OrganizationalPatternCode

1

53

Filler

N/A

N/A

241

Site Facility Data

54

System Indicator

Always extracted as “SPS.”

N/A

3

55

Session Year

The school year selected at report runtime. To change this value, click Term at the top of the page, choose the correct term and re-run the report.

[Terms]FirstDay

[Terms]LastDay

4

56

Sponsor Code

The sponsor code, extracted as the first three digits of the school’s site code.

[S_LA_SCH_X]SiteCode

3

57

Site Code

The school’s site code.

[S_LA_SCH_X]SiteCode

6

58

Record Type

Always extracted as “03.”

“03”

2

59

Facility Type Code

The type of facilities offered by the site. The report lists each facility checked via Start Page > District Setup > Schools/School Info > Edit School > Click HERE to edit Facility Type Codes > Louisiana Facility Code Information.

[S_LA_SCH_FacilityType_X]FacilityType1_TF

[S_LA_SCH_FacilityType_X]FacilityType2_TF

[S_LA_SCH_FacilityType_X]FacilityType3_TF

[S_LA_SCH_FacilityType_X]FacilityType4_TF

[S_LA_SCH_FacilityType_X]FacilityType5_TF

[S_LA_SCH_FacilityType_X]FacilityType6_TF

[S_LA_SCH_FacilityType_X]FacilityType7_TF

[S_LA_SCH_FacilityType_X]FacilityType8_TF

[S_LA_SCH_FacilityType_X]FacilityType9_TF

[S_LA_SCH_FacilityType_X]FacilityType10_TF

[S_LA_SCH_FacilityType_X]FacilityType11_TF

[S_LA_SCH_FacilityType_X]FacilityType12_TF

[S_LA_SCH_FacilityType_X]FacilityType13_TF

[S_LA_SCH_FacilityType_X]FacilityType14_TF

[S_LA_SCH_FacilityType_X]FacilityType15_TF

[S_LA_SCH_FacilityType_X]FacilityType16_TF

[S_LA_SCH_FacilityType_X]FacilityType17_TF

[S_LA_SCH_FacilityType_X]FacilityType18_TF

[S_LA_SCH_FacilityType_X]FacilityType19_TF

[S_LA_SCH_FacilityType_X]FacilityType20_TF

[S_LA_SCH_FacilityType_X]FacilityType21_TF

[S_LA_SCH_FacilityType_X]FacilityType22_TF

[S_LA_SCH_FacilityType_X]FacilityType23_TF

[S_LA_SCH_FacilityType_X]FacilityType24_TF

[S_LA_SCH_FacilityType_X]FacilityType25_TF

[S_LA_SCH_FacilityType_X]FacilityType26_TF

[S_LA_SCH_FacilityType_X]FacilityType27_TF

[S_LA_SCH_FacilityType_X]FacilityType28_TF

[S_LA_SCH_FacilityType_X]FacilityType29_TF

[S_LA_SCH_FacilityType_X]FacilityType30_TF

40

60

Filler

N/A

N/A

242

Site Program Data

61

System Indicator

Always extracted as “SPS.”

N/A

3

62

Session Year

The school year selected at report runtime. To change this value, click Term at the top of the page, choose the correct term and re-run the report.

[Terms]FirstDay

[Terms]LastDay

4

63

Sponsor Code

The sponsor code, extracted as the first three digits of the school’s site code.

[S_LA_SCH_X]SiteCode

3

64

Site Code

The school’s site code.

[S_LA_SCH_X]SiteCode

6

65

Record Type

Always extracted as “04.”

“04”

2

66

Program Code

The programs offered by the site. The report lists each facility checked via Start Page > District Setup > Schools/School Info > Edit School > Click HERE to edit Program Codes > Louisiana Program Code Information.

[S_LA_SCH_ProgramCodes_X]ProgramCode1_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode2_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode3_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode4_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode5_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode6_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode7_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode8_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode9_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode10_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode11_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode12_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode13_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode14_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode15_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode16_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode17_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode18_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode19_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode20_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode21_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode22_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode23_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode24_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode25_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode26_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode27_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode28_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode29_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode30_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode31_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode32_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode33_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode34_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode35_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode36_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode37_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode38_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode39_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode40_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode41_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode42_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode43_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode44_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode45_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode46_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode47_TF

[S_LA_SCH_ProgramCodes_X]ProgramCode99_TF

80

67

Filler

N/A

N/A

202

Site E-Mail Data

68

System Indicator

Always extracted as “SPS.”

N/A

3

69

Session Year

The school year selected at report runtime. To change this value, click Term at the top of the page, choose the correct term and re-run the report.

[Terms]FirstDay

[Terms]LastDay

4

70

Sponsor Code

The sponsor code, extracted as the first three digits of the school’s site code.

[S_LA_SCH_X]SiteCode

3

71

Site Code

The school’s site code.

[S_LA_SCH_X]SiteCode

6

72

Record Type

Always extracted as “05.”

“05”

2

73

Principals Email

The email address of the principal.

[Schools]PrincipalEmail

100

74

Filler

N/A

N/A

182