NJ SMART Course Roster Submission – Staff Course File Layout
For the NJ SMART Course Roster submission's Staff Course file, the following table shows the STATE field numbers, field names, the eSchoolPlus Tables and Columns, and database sources.
Position in file/ NJ DOE Number | Field Name | Where in eSchoolPlus | Notes/Issues |
---|---|---|---|
1/118 | Local Staff Identifier (LSID) | Scheduling > Courses > Course Sections > Master Schedule > click link for Primary or Secondary Staff: Staff field (schd_ms_staff_date.staff_id) Or, Administration > Registration Setup > Building > Staff > General Information panel: Financials Employee Number field (reg_staff.fms_empl_number) | Required This needs to be the same LSID that is already being submitted to the state for this staff member. |
2/119 | Staff Member Identifier (SMID) | Administration > Registration Setup > Building > Staff > General Information panel: Staff State Id field (reg_staff.staff_state_id) | Required |
3/122 | First Name | Administration > Registration Setup > Building > Staff: First Name field (reg_staff.first_name) | Required Periods are not allowed. The file does accept apostrophes and hyphens. |
4/124 | Last Name | Administration > Registration Setup > Building > Staff: Last Name field (reg_staff.last_name) | Required Periods are not allowed. The file does accept apostrophes and hyphens. |
5/128 | Date of Birth | Administration > Registration Setup > Building > Staff > General Information panel: Birth Date field (reg_staff.birthdate) | Required YYYYMMDD format |
6/157 | County Code Assigned | Administration > Registration Setup > Building > Building Definition: County (reg_building.county_code where schd_ms.building = reg_building.building) | Required |
7/158 | District Code Assigned | Administration > General Setup > District > District > Preferences panel: State Equivalency Code field (reg_district.state_code_equiv) | Required |
8/159 | School Code Assigned | Administration > Registration Setup > Building > Building Definition > Preferences panel: State Equivalency Code field (reg_building.state_code_equiv where schd_ms.building = reg_building.building) | Required |
9/175 | Section Entry Date | Scheduling > Courses > Course Sections > Master Schedule > click link for Primary or Secondary Staff: Start Date field (schd_ms_staff_date.start_date) | Required YYYYMMDD format If the staff member has more than one start/end date vector for the course, use the most recent start date. |
10/176 | Section Exit Date | Scheduling > Courses > Course Sections > Master Schedule > click link for Primary or Secondary Staff: End Date field (schd_ms_staff_date.end_date) | YYYYMMDD format If the staff member has more than one start/end date vector for the course, take the end date associated with the most recent start date. The Exit Date can be blank. |
11/177 | Subject Area | Administration > Mark Reporting Setup > Calculation Setup > Course Equivalency Definitions: State ID field; first 2 characters (mr_crsequ_det.state_id where schd_ms.school_year = mr_crsequ_det.school_year and schd_ms.building = mr_crsequ_det.building and schd_ms.course = mr_crsequ_det.course) | Required First 2 characters of the course's State ID. |
12/178 | Course Identifier | Administration > Mark Reporting Setup > Calculation Setup > Course Equivalency Definitions: State ID field; last 3 characters (mr_crsequ_det.state_id where schd_ms.school_year = mr_crsequ_det.school_year and schd_ms.building = mr_crsequ_det.building and schd_ms.course = mr_crsequ_det.course) | Required |
13/179 | Course Level | Scheduling > Courses > Course Sections > NJ SMART Course Information: Course Level (njtb_course_level.state_code_equiv where schd_ms_user.field_value = njtb_course_level.code for schd_ms_user.screen_number = 990 and field_number = 1) | Required |
14/180 | Grade Span | Scheduling > Courses > Course Sections > Master Schedule: Grade Restriction field (reg_grade.state_code_equiv where schd_ms_grade.restrict_grade = reg_grade.code) | Required for Subject Areas > 50 Optional for Subject Areas < 50, though do send Grade data if you have it.
|
15/181 | Available Credit | Scheduling > Courses > Course Sections > Master Schedule: Master Schedule Session Information section: Credit field (schd_ms_session.credit) | Required for Subject Areas < 50. This is a required field in eSchoolPlus. Sum of credit for all sessions associated with the course-section. Format is ##.###
|
16/182 | Course Sequence | System-calculated based on Marking Periods when the course meets (Master Schedule Session Information section – schd_ms_mp) and Marking Periods set up with a State Code Equiv value in Administration > Registration Setup > Calendars > Marking Periods > Weeks section: State Code Equivalent field (reg_mp_weeks.state_code_equiv) | Required The system looks at when the course meets, and it then looks for State Code Equivalent values in reg_mp_weeks to determine how many times the course issues marks for the Student Course file. Example 1: The course meets M1, M2, M3, and M4. You need marks sent on a semester basis (M2 and M4). In the Marking Periods setup's Weeks section, assign a State Code Equivalent for M2 and M4. The state code equivalent can be the same as the Marking Period code. In this case, the Course Sequence in the Teacher Course file would be 22. Example 2: The course meets M1 and M2. You need marks sent at the end of the course (M2). In the Marking Periods setup's Weeks section, assign a State Code Equivalent for M2. The state code equivalent can be the same as the Marking Period code. In this case, the Course Sequence in the Teacher Course file would be 11. |
17/183 | Local Course Title | Scheduling > Courses > Course Sections > Master Schedule: Description field (schd_ms.description) | Required |
18/184 | Local Course Code | Scheduling > Courses > Course Sections > Master Schedule: Course field (schd_ms.course) | Required |
19/185 | Local Section Code | Scheduling > Courses > Course Sections > Master Schedule: Course Section field (schd_ms.course_section) | Required |