Tool Search: SMART Extracts
The Staff Course Data Extract reports a record for each staff member who is responsible for the roster in a course that is active during the reporting start and end dates. If this staff member enters, exits and then re-enters the same course section, information is reported from the most recent record.
SMART Staff Course Data
Report Logic
The extract will first look for a Primary Teacher, Teacher or Staff listed as the Teacher of Record on the Staff History tool. If no Primary Teacher is assigned, the report will look for a Teacher assignment. If no Primary Teacher or Teacher assignment exists, the report then looks for a Staff Member assignment.
If a course section does not have any students scheduled into it, that section is not included in the report.
Report Editor
Field | Description |
|---|---|
Extract Type | Selection determines which extract generates. |
Reporting Period Start Date | Entered date determines the time frame of the extract, reporting only that student data as of that date. Dates are entered in mmddyy format or can be chosen by using the calendar icon. |
Reporting Period End Date | Entered date determines the time frame of the extract, reporting only that student data as of that date. Dates are entered in mmddyy format or can be chosen by using the calendar icon. The end date field is auto-populated with the current date. |
Students without state IDs | When marked, students who are not assigned a state ID will be returned, in addition to those students who do have a state ID. |
Ad hoc Filter | When selected, only those students in the filter will be included on the selected SMART extract. |
Format | SMART Extracts generate in either HTML format or in CSV format (state format). |
Calendar Selection | Selection indicates from where the data is pulled. |
| Report Generation | Use the Generate Extract button to display the results of the extract immediately. |
Generate the Extract
- Select SMART Staff Course Data from the Extract Type dropdown list.
- Enter a Reporting Period Start Date.
- Enter a Reporting Period End Date.
- Mark the Student w/o stateIDs if those students should not appear in the report.
- Select ad Ad hoc Filter, if desired.
- Indicate the Format in which in which the report should generate.
- Click the Generate Extract button to generate the report in the desired format.
Staff Course Data Extract - State Format (CSV)
Staff Course Data Extract - HTML Format
Report Layout
Data Element | Description | Location |
|---|---|---|
Local Staff Identifier | A unique number or alphanumeric code assigned to a staff member by the district. Alphanumeric, 20 characters. | Census > People > Demographics > Person Identifiers > Local Staff Number Person.staffNumber |
Staff Member Identifier | A unique number assigned and maintained by the New Jersey Department of Education that is unique for each staff member. Numeric, 8 digits | Census > People > Demographics > Person Identifiers > Staff State ID Person.staffStateID |
First Name | The staff person's legal first name. Alphanumeric, 30 characters | Census > People > Demographics > Person Information > First Name Identity.firstName |
Last Name | The staff person's legal last name. Alphanumeric, 50 characters | Census > People > Demographics > Person Information > Last Name Identity.lastName |
Date of Birth | Staff person's date of birth. Date field, 8 characters (YYYYMMDD) | Census > People > Demographics > Person Information > Birth Date Identity.birthDate |
County Code Assigned | Indicates the New Jersey county in which the staff member is employed during the course start and end date. Numeric, 2 digits | Census > People > District Employment > Employment Information Counties.number |
District Code Assigned | Indicates the local education agency in which the staff member is employed during the course start and end date. Numeric, 4 digits | Census > People > District Employment > Employment Information District.Number |
School Code Assigned | Indicates the school in which the staff member is employed during the course start and end date. Numeric, 3 digits | Census > People > District Employment > Employment Information School.Number |
Section Entry Date | The most recent date the staff member was assigned to the specific section of the course. Date field, 8 characters (YYYYMMDD) | Scheduling > Courses > Course > Section > Staff History > Start Date StaffHistory.startDate |
Section Exit Date | The last date the staff member was assigned to the specific section of the course. Date field, 8 characters (YYYYMMDD) | Scheduling > Courses > Course > Section > Staff History > End Date StaffHistory.endDate |
Subject Area | The general content code per the NCES SCED code listing. Numeric, 2 digits | Scheduling > Courses > Course > NCES Data > SCED Subject Area Course.scedCourseID |
Course Identifier | NCES-assigned course code. Numeric, 3 digits | Scheduling > Courses > Course > NCES Data > SCED Course Identifier Course.scedCourseID |
Course Level | Indicates the level of rigor for the course. Alphanumeric, 1 character | Scheduling > Courses > Course > NCES Data > SCED Course Level Course.scedCourseLevel |
Grade Span | Identifies the intended grade span for a prior-to-secondary course. Alphanumeric, 4 characters | Scheduling > Courses > Course > NCES Data > SCED Lowest Grade, SCED Highest Grade Course.scedLowestGrade |
Available Credit | Identifies the amount of credits available toward graduation to a student who successfully meets the objectives of the course. Numeric, 6 digits | Scheduling > Courses > Course > NCES Data > SCED Available Credit Course.scedAvailableCredit |
Course Sequence | Indicates the course's consecutive sequence, interpreted as Part N of M and is reported as NM. Numeric, 2 digits | Scheduling > Courses > Course > NCES Data > SCED Sequence Course.scedSequenceNum |
Local Course Title | District's local name for the course. Alphanumeric, 50 characters | Scheduling > Courses > Course > Name Course.name |
Local Course Code | District's local number for the course. Alphanumeric, 15 characters | Scheduling > Courses > Course > Number Course.number |
Local Section Code | District's local section number of the course. Alphanumeric, 10 characters | Scheduling > Courses > Course > Section > Section Number Section.number |
