Staff Assignments Migration

Introduction

This report can be used to migrate staff Position Code and FTE data, which was previously stored in the SchoolStaff record, to a new table off the Users record. Once this report has been run, IT CANNOT BE RUN AGAIN.

NOTE - READ THIS BEFORE RUNNING THE MIGRATION REPORT

There are two ways to run the migration report (for staff members for multiple School Staff Records):

If the staff assignment data has all been entered on the master SchoolStaff record – Select the “Validate Master Flagged Staff” option. This will go through the SchoolStaff records and verify that only one is flagged as the master record. When you run it in this mode, the report will not migrate any data until all validation errors within the current selection have been corrected.

For example: Teacher A teachers at schools 1, 2, and 3 but school 1 is flagged as being the “primary” (S_NM_SSF_X.MasterRecord_YN). All of teacher A’s staff assignment data has been entered on the school 1 SchoolStaff record.

If you are utilizing this option, do NOT change your staff selection after you have run the report in validation mode.

2. If staff assignment data has been entered across multiple SchoolStaff records - Select the “Ignore Master - Migrate all Staff Assignment data”. This option will not validate the master flag, but will scan all SchoolStaff records for a given user and migrate any found staff assignment data.

For example: Teacher A teachers at schools 1, 2, and 3 but school 1 is flagged as being the “primary” (S_NM_SSF_X.MasterRecord_YN). Teacher A has pertinent assignment data entered on the SchoolStaff records for school 1, 2 and 3.

Report Input

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

Field

Description

Run for:

Select to run the migration report for:

The currently selected staff
All staff

Note: Whichever option is chosen, only active staff will be processed.

Mode

Choose the desired mode:

1) Validate Master Flagged Teachers

2) Ignore Master - Migrate all Staff Assignment data

Back to Top

Report Output

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

Item #	Data Element	Description	[Table]FieldName	Begin / End Position
1	UsersDCID	The DCID of the Users record	[Users]DCID	N/A
2	Teacher	The vehicle ID (bus number) of the vehicle.	[Users]LastFirst	N/A
3	SchoolID	The school id of the schoolstaff record.	[SchoolStaff]SchoolID	N/A
4	AssignmentNumber	The assignment number of the migrated staff assignment record.	Auto generated	N/A
5	PositionCode	The position code of the migrated staff assignment record.	[S_NM_USR_Assignments_C]PositionCode [S_NM_USR_Assignments_C]PositionCode2 [S_NM_USR_Assignments_C]PositionCode3 [S_NM_USR_Assignments_C]PositionCode4	N/A
6	FTE	The FTE of the assignment.	[S_NM_USR_Assignments_C]FTE [S_NM_USR_Assignments_C]FTE2 [S_NM_USR_Assignments_C]FTE3 [S_NM_USR_Assignments_C]FTE4	N/A
7	StartDate	The start date of the assignment.	Derived from the years and terms of the school the SchoolStaff record is tied to.	N/A
8	Location	The location that the assignment will be reported under.	[SchoolStaff]SchoolID	N/A

Back to Top

Validation Errors

Below are the validation errors the end user may see if they are running the migration report and opting to Validate Master Flagged Teachers:

No Master Record Flag Set
- A staff member is associated with more than one school (has multiple SchoolStaff records) but none are marked as the master record.
Multiple Master Record Flags Set
- A staff member is associated with more than one school (has multiple SchoolStaff records) and more than one are marked as the master record.

Back to Top