Obsolete - Class Level Membership Report

0100 Art

1006 Other Foreign Languages

1604 General Science

0400 Dance

1007 Multiple Language Course

1605 Geology

0500 Drama/Theater

1008 Arabic

1606 Physical Science

0702 Kindergarten

1009 Chinese

1605 Geology

0703 Elementary Education

1010 Italian

1606 Physical Science

0801 English

1011 Japanese

1607 Physics

0803 Reading

1012 Portuguese

1608 Environmental Science

0900 ESOL

1013 Turkish

1701 Economics

1001 French

1200 Mathematics

1702 Geography

1002 German

1300 Music

1703 History

1003 Latin

1601 Biology

1704 Political Science

1004 Russian

1602 Chemistry

1706 Social Studies

1005 Spanish

1603 Earth/Science

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.

Processing Options

Choose a time to run the report from the pop-up menu:

• In Background Now (Recommended) – Execute the report immediately in the background.
• ASAP – Execute the report in the order it is received in the Report Queue.
• At Night – Execute the report during the next evening.
• On Weekend – Execute the report during the next weekend.

On Specific Time – Execute the report on the date and time specified.

Specific Date/Time

Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry.

Use the pop-up menus to schedule the report to be run at a specific hour and minute.

Example: 7/29/2008 @ 10 AM : 05.

Report Start Date

Type the first date in the range of dates for the terms to be included in the extract.

Report End Date

Type the last date in the range of dates for the terms to be included in the extract.

Use Federal Ethnicity to Calculate Teacher Ethnicity/Race

Click Yes to use the federal ethnicity/race fields to calculate the teacher’s ethnicity/race. Click No to use the custom state ethnicity/race fields to calculate the teacher’s ethnicity/race.

Use Federal Ethnicity to Calculate Student Ethnicity/Race

Click Yes to use the federal ethnicity/race fields to calculate the student’s ethnicity/race. Click No to use the custom state ethnicity/race fields to calculate the student’s ethnicity/race.

Run From Extract Viewer

Select Yes to create an extract file from the records in the Extract viewer. The default is No.

If No is selected, the records that currently exist in the Extract Viewer are replaced.

1

LEA

This field contains the two-digit identification code of the local education agency (LEA). This field is extracted from the Edit District Information page, Start Page > District Setup > District Information.

[Prefs]MD_DistrictLEA

Alpha-numeric

2

1–2

2

School Number

This field contains the four-digit code assigned to the school building. This field is extracted from the Edit School page, Start Page > District Setup > Schools/School Info > Edit School.

[Sections]SchoolID

[Schools]School_Number

Alpha-numeric

4

3–6

3

Unique State Identifier

This field contains the unique number assigned to this teacher by the state of Maryland. This field is extracted from the Edit Staff Information page, Start Page > Staff > Select A Staff Member > Edit Information.

[Teachers]MD_StateIdentifier

Alpha-numeric

10

7–16

4

Local Employee Number

This field contains the number that identifies this employee. This field is extracted from the Edit Staff Information page, Start Page > Staff > Select A Staff Member > Edit Information.

[Teachers]MD_Local_Employee_Number

Alpha-numeric

10

17–26

5

Last Name

This field contains the teacher’s last name. This field is extracted from the Edit Staff Information page, Start Page > Staff > Select A Staff Member > Edit Information.

[Teachers]Last_Name

Alpha-numeric

25

27–51

6

First Name

This field contains the teacher’s first name. This field is extracted from the Edit Staff Information page, Start Page > Staff > Select A Staff Member > Edit Information.

[Teachers]First_Name

Alpha-numeric

15

52–66

7

Middle Name

This field contains the teacher’s middle name. This field is extracted from the Edit Staff Information page, Start Page > Staff > Select A Staff Member > Edit Information.

[Teachers]Middle_Name

Alpha-numeric

15

67–81

8

Generational Suffix

This field contains the suffix appended to the teacher’s name, if applicable. This field is extracted from the Edit Staff Information page, Start Page > Staff > Select A Staff Member > Edit Information.

[Teachers]MD_Suffix

Alpha-numeric

3

82–84

9

BC – Maiden Last Name

This field contains the teacher’s maiden name, if applicable. This field is extracted from the Edit Staff Information page, Start Page > Staff > Select A Staff Member > Edit Information.

Note: BC is an abbreviation for Birth Certificate.

[Teachers]MD_Maiden_Name

Alpha-numeric

25

85–109

10

Birth Date

This field contains the teacher’s date of birth. This field is extracted from the Edit Staff Information page, Start Page > Staff > Select A Staff Member > Edit Information.

Format: YYYYMMDD

[Teachers]DOB

Alpha-numeric

8

110–117

11

Gender

A value of 1 identifies this teacher as male and a value of 2 identifies this teacher as female. This field is extracted from the Edit Staff Information page, Start Page > Staff > Select A Staff Member > Edit Information.

[Teachers]Gender

Alpha-numeric

1

118

12

Ethnicity - Hispanic / Latino

A Y in this field identifies the teacher’s ethnicity as Hispanic or Latino. Start Page > Staff > Select A Staff Member > Edit Information.

[Teachers]FedEthnicity

OR

[Teachers]MD_Hispan_Lat

Alpha-numeric

1

119

13

New Race Code

This field contains the staff member’s race. This field is calculated by concatenating the following fields entered on the Start Page > Staff > Select A Staff Member > Edit Information.

• Ethnicity
• Race Codes 1–5

[TeacherRace]RaceCode

OR

[Teachers]MD_Eth_Amer_Ind

[Teachers]MD_Eth_Asian

[Teachers]MD_Eth_Black

[Teachers]MD_Eth_Hawaiian

[Teachers]MD_Eth_White

Alpha-numeric

5

120

121

122

123

124

14

Teacher SSN

This field contains the social security number of the teacher who was responsible for teaching the course section. For a regular teacher, this field is extracted from the Edit Staff Information page, Start Page > Staff > Select a Staff Member > Edit Information.

For a substitute teacher, this field is extracted from the Edit Sections page, Start Page > School Setup > Sections

[Sections]MD_Long_Term_Sub

OR

[Teachers]SSN

Numeric

9

125–133

15

Filler

This field is not currently used.

N/A

Alpha-numeric

1

134

16

Long Term Substitute

A value of Y (Yes) indicates that a long-term substitute is identified as the teacher-of-record for this course section. Otherwise, this field contains an N (No).

[Sections]MD_Long_Sub

Alpha-numeric

5

135–139

17

Time of Year

This field contains the code identifying time of year this course was offered. This value is extracted from the Edit Sections page, Start Page > School Setup > Sections.

If the field is blank on the Edit Sections page, this value is extracted from the Edit Course District Information page, District Setup > Courses > Edit Course District Information.

[Sections]MD_Time_Of_Year

OR

Courses]MD_Time_Of_Year

Alpha-numeric

1

140

18

Class Number

This field contains the class identifier for the course section. It is calculated by incrementing a variable for each teacher and reporting a number for each class.

N/A

Numeric

2

141–142

19

Grade Level

This field contains the grade level at which the course section is taught. This field is extracted from the Edit Section page, Start Page > School Setup > Sections.

Calculated from

[Students]Grade_Level

OR

[Reenrollments]Grade_Level

Alpha-numeric

2

143–144

20

Subject Code

This field contains a subject code if the course section is a Core Academic Subject (CAS). This field is extracted from the Edit Course page, Start Page > School Setup > Courses.

[Courses]MD_Course_Subject

Numeric

4

145–148

Student Counts: New Race Codes

If your district is using the Federal Ethnicity/Race Codes, the students’ ethnicity and race values used to calculate the student counts are extracted from the Demographics page, Student Selection > Demographics.

If your district is not using the Federal Ethnicity/Race Codes, the students’ ethnicity and race values used to calculate the student counts are extracted from the Maryland State Reporting page, Student Selection > State/Province – Maryland.

21

Hispanic/Latino = Y and any race – Male Students

This field is calculated. It shows the number of male students with a Hispanic or Latino ethnicity in each course section.

Calculated from

[Students] FedEthnicity OR [Students]MD_Hispan_Lat

AND

[Students]Gender

Numeric

4

149–153

22

Hispanic/Latino = Y and any race – Female Students

This field is calculated. It shows the number of female students with a Hispanic or Latino ethnicity in each course section.

Calculated from

[Students] FedEthnicity OR [Students]MD_Hispan_Lat

AND

[Students]Gender

Numeric

4

153–156

23

Hispanic/Latino = N and American Indian or Alaskan Native – Male Students

This field is calculated. It shows the number of non-Hispanic/Latino American Indian/Alaskan Native male students in each course section.

Calculated from

[Students]FedEthnicity
OR [Students]MD_Hispan_lat

AND

[StudentRace]RaceCd
OR [Students]MD_Eth_Amer_Ind

AND

[Students]Gender

Numeric

4

157–160

24

Hispanic/Latino = N and American Indian or Alaskan Native – Female Students

This field is calculated. It shows the number of non-Hispanic/Latino American Indian/Alaskan Native female students in each course section.

Calculated from

[Students]FedEthnicity
OR [Students]MD_Hispan_lat

AND

[StudentRace]RaceCd
OR [Students]MD_Eth_Amer_Ind

AND

[Students]Gender

Numeric

4

161–164

25

Hispanic/Latino = N and Asian – Male Students

This field is calculated. It shows the number of non-Hispanic/Latino Asian/Pacific Islander male students enrolled in each course section.

Calculated from

[Students]FedEthnicity
OR [Students]MD_Hispan_lat

AND

[StudentRace]RaceCd
OR [Students]MD_Eth_Asian

AND

[Students]Gender

Numeric

4

165–168

26

Hispanic/Latino = N and Asian – Female Students

This field is calculated. It shows the number of non-Hispanic/Latino Asian/Pacific Islander female students enrolled in each course section.

Calculated from

[Students]FedEthnicity
OR [Students]MD_Hispan_lat

AND

[StudentRace]RaceCd
OR [Students]MD_Eth_Asian

AND

[Students]Gender

Numeric

4

169–172

27

Hispanic/Latino = N and Black or African American – Male Students

This field is calculated. It shows the number of non-Hispanic/Latino Black male students enrolled in each course section.

Calculated from

[Students]FedEthnicity OR [Students]MD_Hispan_lat

AND

[StudentRace]RaceCd
OR [Students]MD_Eth_Black

AND

[Students]Gender

Numeric

4

173–176

28

Hispanic/Latino = N and Black or African American – Female Students

This field is calculated. It shows the number of non-Hispanic/Latino Black female students enrolled in each course section.

Calculated from

[Students]FedEthnicity
OR [Students]MD_Hispan_lat

AND

[StudentRace]RaceCd
OR [Students]MD_Eth_Black

AND

[Students]Gender

Numeric

4

177–180

29

Hispanic/Latino = N and Native Hawaiian or Other Pacific Islander – Male Students

This field is calculated. It shows the number of non-Hispanic/Latino Native Hawaiian or Other Pacific Islander male students enrolled in each course section.

Calculated from

[Students]FedEthnicity
OR [Students]MD_Hispan_lat

AND

[StudentRace]RaceCd
OR [Students]MD_Eth_Hawaiian

AND

[Students]Gender

Numeric

4

181–184

30

Hispanic/Latino = N and Native Hawaiian or Other Pacific Islander – Female Students

This field is calculated. It shows the number of non-Hispanic/Latino Native Hawaiian or Other Pacific Islander female students enrolled in each course section.

Calculated from

[Students]FedEthnicity
OR [Students]MD_Hispan_lat

AND

[StudentRace]RaceCd
OR [Students]MD_Eth_Hawaiian

AND

[Students]Gender

Numeric

4

185–188

31

Hispanic/Latino = N and White – Male Students

This field is calculated. It shows the number of Non-Hispanic/Latino White male students enrolled in each course section.

Calculated from

[Students]FedEthnicity
OR [Students]MD_Hispan_lat

AND

[StudentRace]RaceCd
OR [Students]MD_Eth_White

AND

[Students]Gender

Numeric

4

189–192

32

Hispanic/Latino = N and White – Female Students

This field is calculated. It shows the number of Non-Hispanic/Latino White female students enrolled in each course section.

Calculated from

[Students]FedEthnicity
OR [Students]MD_Hispan_lat

AND

[StudentRace]RaceCd
OR [Students]MD_Eth_White

AND

[Students]Gender

Numeric

4

193–196

33

Hispanic/Latino = N and Tow or More Races – Male Students

This field is calculated. It shows the number of Non-Hispanic/Latino multiracial male students enrolled in each course section.

Calculated from

[Students]FedEthnicity
OR [Students]MD_Hispan_lat

AND

[StudentRace]RaceCd
OR [Students]MD_Eth_Amer_Ind
[Students]MD_Eth_Asian
[Students]MD_Eth_Black
[Students]MD_Eth_Hawaiian
[Students]MD_Eth_White

AND

[Students]Gender

Numeric

4

197–200

35

Hispanic/Latino = N and Tow or More Races – Female Students

This field is calculated. It shows the number of Non-Hispanic/Latino multiracial female students enrolled in each course section.

Calculated from

[Students]FedEthnicity
OR [Students]MD_Hispan_lat

AND

[StudentRace]RaceCd
OR [Students]MD_Eth_Amer_Ind
[Students]MD_Eth_Asian
[Students]MD_Eth_Black
[Students]MD_Eth_Hawaiian
[Students]MD_Eth_White

AND

[Students]Gender

Numeric

4

200–203

33

Title I

This field is calculated. It shows the number of Title I students enrolled in each class section.

Calculated from

[Students]MD_TitleOne

Numeric

4

204–207

34

Students Eligible for Free or Reduced Price Meals

This field is calculated based on each student’s lunch status. It shows the number of students that are eligible for the free or reduced price meals program enrolled in each class section.

Calculated from

[Students]LunchStatus

Numeric

4

208–211

35

Students with Disabilities

This field is calculated. It shows the number of students with 504 plans enrolled in each class section.

Calculated from

[Students]ST_SPED

Numeric

4

212–215

36

Students with 504 Plans

This field is calculated. It shows the number of students with 504 plans enrolled in each class section.

Calculated from

[Students]504_PLAN

Numeric

4

216–219

37

Students with Limited English Proficiency

This field is calculated based on each student’s English Language Learner (ELL) status. It shows the number of students eligible to participate in a limited English proficiency program enrolled in each class section.

Calculated from

[Students]MD_ELL

Numeric

4

220–223

38

Filler

This field is currently not used. It is reserved for future development.

N/A

Alpha-numeric

20

204–223