PowerSchool SIS New Jersey

NJ SLEDS Staff Submission Extract

Introduction

This report is used to generate the staff submission portion of the NJ SLEDS Staff Submission Extract.

Selection Criteria

Selection criteria determine which database records are used in the report.

  • Schools/Teachers who are marked to be excluded from the State Reporting, will not be displayed in the report.

  • This report may be run at the school level or the district level. Running the report for the current school will extract information for the sections taught in the current school.

Report Input

Navigation: Start page > System reports> State tab > NJ SLEDS Staff Submission Extract.

Navigating to Staff > State Reporting - NJ > Staff Submission > New and Edit (Staff Assignments), a pop-up now shows CDS codes(County, District, and School) after clicking on “(codes)“ link.

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Use

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

  • Default – District Wide. Includes all records on the PowerSchool server that meet the 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.

Staff to Include

Indicate which staff to include in the report by selecting one of the following options:

  • The selected [number] staff only – Run the report for staff in the current selection.

  • All staff – Run the report for all staff in the current school or district that meet the selection criteria.


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 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:05 AM.

Start Date and End Date

Enter the beginning and ending dates for the reporting period. 

Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Item # or Position

Data Element

Description

[Table]FieldName

Field Type

Field Length

1

Local Staff Identifier (LSID)

A unique number or alphanumeric code assigned to a staff member.

[S_NJ_USR_X]LocalStaffIdentifier

Alpha-numeric

20

2

Staff Member Identifier (SMID)

A unique number assigned and maintained by the New Jersey Department of Education that is unique for each staff member over time.

[S_NJ_USR_X]StaffMemberIdentifier

Alpha-numeric

20

3

First Name

The first name of the staff

[S_NJ_USR_X]FirstName

Alpha-numeric

11

4

Last Name 

The last name of the staff

[S_NJ_USR_X]Last Name

Alpha-numeric

11

5

Date of Birth


The year, month, and day on which an individual was born.

[S_NJ_USR_X]DateofBirth


Alpha-numeric

1

6

Salary

The current salary of the staff.

[S_NJ_USR_X]SMART_Salary

Numeric

9

7

Language Spoken by the Teacher

The language used by the staff.

[S_NJ_USR_X]SMART_LanguageSpokenByTeacher

Alpha-numeric

1

8

Migrant Education Program Category

The Migrant Education Program Category of the staff

[S_NJ_USR_X]SMART_MigrantEducationProgramStaffCategory

Alpha-numeric

1

9

MEP Session Type

The Migrant Education Program (MEP) session type.

[S_NJ_USR_X]SMART_MEPSessionType

Alpha-numeric

1

10

Title 1 Program Category

The Title 1 Program Category of the staff.

[S_NJ_USR_X]SMART_TitleIProgramStaffCategory

Alpha-numeric

1

11

Highest level of Education

The staff's highest level of education.

[S_NJ_USR_X]SMART_HighestLevelofEducationCompleted

Alpha-numeric

2

12

National Board Award

If the staff has received the National Board Award.

[S_NJ_USR_X]SMART_NationalBoardAward

Alpha-numeric

1

13

SEP Program Contract Category

The category of SEP Program Contract.

[S_NJ_USR_X]SMART_SEProgramContractedServicesCategory

Alpha-numeric

1

14

ELL Instructor Credit Type

The ELL Instructor Credit Type.

[S_NJ_USR_X]SMART_ELLInstructorCredentialType

Alpha-numeric

1

15

Years of Prior Experience

The total number of years of experience.

[S_NJ_USR_X]SMART_YearsOfPriorExperience

Numeric

2

16

Years in NJ

The number of years served in NJ.

[S_NJ_USR_X]SMART_YearsInNJ

Numeric

2

17

Years in LEA

The number of years served in LEA.

[S_NJ_USR_X]SMART_YearsInLEA

Numeric

2

18

Traditional Route Program

If the staff has attended the Traditional Route Program Y/N.

[S_NJ_USR_X]SMART_TraditionalRouteProg

Alpha-numeric

3

19

Alternate Route Program

If the staff has attended the Alternate Route Program Y/N.

[S_NJ_USR_X]SMART_AlternateRouteProg

Alpha-numeric

3

20

County Code Assigned

The County Code to which the staff is assigned.

[S_NJ_USR_X]SMART_CountyCodeAssigned

Alpha-numeric

2

21

District Code Assigned

The District Code to which the staff is assigned.

[S_NJ_USR_X]SMART_DistrictCodeAssigned

Alpha-numeric

4

22

School Code Assigned

The School Code to which the staff is assigned.

[S_NJ_USR_X]SMART_SchoolCodeAssigned

Alpha-numeric

3

23

Full-Time Equivalency

The staff's FTE calculation.

[S_NJ_USR_X]SMART_FullTimeEquivalency


3

24

Job Code

The job code

[S_NJ_USR_X]SMART_JobCode

Alpha-numeric

4

25

Job Code Sub Category

The Job Code Sub Category

[S_NJ_USR_X]SMART_JobCodeSubCat

Alpha-numeric

1

26

Age Group Taught

The Age Group of the students taught by the staff

[S_NJ_USR_X]SMART_AgeGroupTaught

Alpha-numeric

1

27

Credential Type

Staff's Credential Type

[S_NJ_USR_X]SMART_CredentialType1

Alpha-numeric

1

28

Teacher Prep

If the staff has attended the Teacher Prep Program Y/N.

[S_NJ_USR_X]SMART_TeacherPrep

Alpha-numeric

1