Manage Staff Data - Menu in WISEstaff Portal
Click the links below to navigate to different sections of this page:
Manage Staff Data: Overview Certify Data Copy Staff Files
Enter Aggregate Staff FTE Licensing Download Staff Download
Validate Staff Data Validate Staff "Navigator"
Upload Staff Data Which Upload Option is Best View Upload Results
Manage Staff: Overview
The Manage Staff Data menu groups the screens related to uploading and managing staff contract and assignment data. A complete list of all the available WISEstaff reports and validations, including descriptions, if provided here.
Certify Data
(Previously called Sign off or Certification): This step is required to attest (certify) that all required staff data for your agency has been submitted and validated to be error-free in preparation for the preliminary and final audits conducted by DPI. Managing the accuracy and quality of data benefits the submitting agency and DPI and will be reflected in subsequent staff data reporting.
Copy Staff Files
(Previously called Manage Staff Data, or Copy Forward Files): Copy Staff Files is an OPTIONAL step, used by districts that do not generate fresh Contract and Assignment files from their staffing system vendor tool each year. Instead, they copy the data reported to DPI in previous years as their current year starting point. Files from previous school years may be copied to ensure data consistency. Use Copy Staff Files to begin working on the next school year's data.
- Find the Copy Staff FIles screen on the WISEstaff Manage Staff Data menu.
- Click Download Current Year Contracts to select and download the contract file for the appropriate school year.
- NOTE: Years of Experience and School Year will automatically increase by 1.
- Click Download Current Year Assignment to select and download the assignment file for the appropriate school year.
- Make changes to the downloaded files for the school year (adding or deleting staff, adjusting FTE, salary adjustments, assignment changes, etc).
- Save files to your desired location.
- Upload files to populate the new school year's data collection.
Once you have your newly updated files ready, you can also delete all of the existing assignments &/or contracts stored in WISEstaff by clicking the desired red button. This will allow you to start over with fresh data when you upload the new file. Upload information is in the Upload Staff Data section, further down this page.
Enter Aggregate Staff FTE
In the WISEstaff application, you will find the Enter Aggregate Staff FTE option under the Manage Staff Data menu. Clicking Enter Aggregate Staff FTE will open a screen where you can enter FTE information about your subcontracted employees.
Users may come to this screen on WISEstaff when completing step 3d (Enter Aggregate Assignments - if applicable) on the Staff Collection Checklist when preparing for the final certification of the annual staff audit.
As the Hiring Agency, you will be able to enter assignment data for subcontractors for whom you aren't otherwise able to obtain personal information, such as birth dates, to create WISEids for these employees. Note, if you are able to obtain the demographic information needed to create a WISEid, use that data to create a WISEid and enter the staff member in the standard method. The aggregate method should ONLY be used when you do not know the demographic data to report the employee as traditional staff.
Enter your subcontracted staff for whom you are unable to obtain demographic data necessary for creating individual WISEid records for each staff person. This option to enter aggregate staff is available only for the 'Other Support Staff' position with a bus driver, plant maintenance / operations personnel, or cafeteria worker assignment. The FTE for each assignment should be calculated based on 1 FTE = one full time staff person in that assignment rather than indicating a percentage of an assignment.
To enter subcontracted assignment data:
- Select the Working LEA from the drop-down menu under the Subcontracted Assignment section.
- Then select the Working School.
- If you want to enter the assignment FTE for the whole district, choose '0000 - District-wide' from the drop-down menu.
- Select the Position.
- At this time, the only option is 98 - Other Support Staff.
- Choose the appropriate assignment Area from the drop-down menu.
- The aggregate area options include: Bus Driver - Special Education, Bus Driver, Plant Maintenance and Operation, and Cafeteria Worker.
- The Contracting Agency Name field is free text where you can enter a specific contracting agency's name if you wish.
- Enter the FTE total on the right side under the Details section.
When your FTE data has been added, return to the Staff Collection Checklist by clicking the WISEstaff Home menu, then clicking on Staff Collection Checklist to move on to step 3e.
Licensing Download
This optional tool can be used to review licensing details for all staff or a selected group based on a list of Entity IDs or WISEids. The download includes details like license type, stage, position/subject, renewal guidelines, and expiration date. An additional feature allows you to filter the download to include only licenses expiring during a selected date range, to help keep track of staff who will need to renew or update their licenses during or before the next school year.
Staff Download
(Previously called Staff Download by Local Person ID): Use this link to generate a download of all staff with a Local Person ID assigned to your agency. The .csv file will appear at the bottom of the WISEstaff page once complete. Download includes data from each person's WISEid record: Local Person ID, WISEid, name, demographic data, Entity ID, email address, and WISEsecure role, if assigned.
Upload Staff Data
(Previously called Upload): Here you can upload a file containing assignment or contract data for your staff using the designated file format. Detailed file format specifications can be found on the File Layout and Templates page. When uploading a file, you can choose to update only the records that are included in the file, or have the upload replace all existing data, which would delete all records for the current year and insert only the records contained in the uploaded file.
Staff Collection Checklist: Steps 2a/2b - '+Add Assignments / Contracts'
Use the dropdown menu to select your File Upload Type, Contract or Assignment. Note that with each selection, WISEstaff provides you with a bank of tips and a sample template that you may download to ensure your upload is following the specified requirements.
You may also copy and forward last year’s Contracts and Assignments. To do this, click the Copy Staff Files tab in the WISEstaff Manage Staff Data menu.
Clicking the ‘Download Contracts’ or ‘Download Assignments’ buttons will generate a ‘.csv’ file with information from that year’s staff - and - this file automatically updates various columns to reflect for the current year, such as “School Year,” “LEA Experience,” and “Total Years.” You should also make any manual updates needed (salary, for example) to this downloaded file. When the file is accurate and complete, save it so that you can upload it. You can also download this information from your HR system, if applicable.
Which Upload Option Should I Use?
Before clicking the blue ‘Upload’ button, select the radio button that best matches the file you want to upload:
Update Existing Data for Matching Records (Option 1)
This option looks for matching elements and update any assignment with matching items (same person, the same exact working school, hiring school, hiring agency, working school assignment code, etc.).If there is not a match - it will create a new row for that person/assignment. This could create potential duplicates.
Another reason to select this option is if you have you have done manual edits on the ‘Edit Staff” screen in WISEstaff and you don't want to lose those updates. In this scenario, then the “Update existing” option would be the better option.
NOTE: This upload option does not delete rows or records of data. If you are deleting contracts from the file, and there is existing data in WISEstaff for that contract that was previously uploaded, this option does not remove the contract from WISEstaff which you removed from the file. This may cause a discrepancy in the number of records and result in a warning or error.
As such, this upload option is best used only when there are minor changes reflected in the upload, especially where new/updated data is being added in and no data is being removed/deleted.
Delete All Data and Replace with New Upload (Option 2)
This option is the preferred method for the majority of uploading scenarios. As long as your file has full and complete and accurate data. Especially if you download your file from a staff system vendor tool. This option deletes everything you have in WISEstaff for the current school year and replaces it with whatever you have in the file. This option is recommended most of the time
Choose the ‘.csv’ file you want to upload and click the blue ‘Upload’ button.
Staff contract and assignment data can also be entered manually. This might be an option if you work in a smaller district or if there are very few staff changes from the previous year. To do this, go to the Person Search menu in WISEstaff, and use the Person Search/Edit tab.
For specific details on adding Contracts and Assignments, please visit the Add Contracts and Add Assignments sections of this User Guide.
Validate Staff Data
The Validate Staff Data process typically runs each morning throughout the data collection period or you can run it as needed by clicking the Refresh Validation button. The validation process will review all of your agency's assignment and contract data for the current school year and generate errors, warnings, or informational messages for anything that doesn't meet DPI requirements. All errors must be corrected and all warnings must be corrected or acknowledged before your agency can certify your staff data for the collection year.
For Step 2c on the Staff Collection Checklist, as part of the annual staff preliminary audit, all errors and warnings need to be resolved, ideally, prior to certification. If errors and warnings are not resolved by the preliminary certifcation deadline, this will affect your Adutir results, and they may be tricker to resolve for the final certification. For Step 2c, the red circle on the right will indicate only the unacknowledged warnings.
For Step 2e on the Staff Collection Checklist, the count on the right will show in orange if the Entity ID warning has been acknowledged.
When all errors and warnings are resolved, this will be reflected as a green zero in the Count number on the right side of the Staff Collection Checklist. If you have acknowledged warnings (and added comments if comments are required), the red circle will be replaced by a green checkmark.
There are three types of validations:
Errors - Most severe, must be resolved in order for certification to be completed.
Warning - Have to be addressed, either through resolving the problem or they can be acknowledged. Some acknowledgements also require a comment to explain why the warning isn’t being resolved before you can click the blank box in the “Ackn” column.
Informational - Nothing needs to be resolved, but the information provided here may be helpful.
Clicking the hyperlink in the resolve column for each error or warning will direct you to the page where the validation exists (for example, Edit Staff or Staff List) so that you can view that data and rectify it. Errors and warnings will all be linked to a knowledge base article (KBA), which appears as a four-digit code in the Code column. The KBA will provide you with more details on the validation, and will also provide example scenarios, business logic behind the validation dn steps on how to resolve it. All errors and warnings will be resolved, ideally, prior to certification. This will be reflected as a green zero in the Count number on the right side of the Staff Collection Checklist.
If you have a warning associated to a staff member based on an Entity ID, you should check on the status of this staff member's licensure. If the staff member has applied for the license, but it has not been awarded yet, they should have an Entity ID assigned to them. Please enter this information into the comments and then Acknowledge the warning.
Once you’ve resolved all of your validations, you can:
Reviewing the “Navigator” Tool in WISEstaff as part of the Validate Staff Data Screen
The Navigator is a good tool to use if you are fixing information on Staff records as part of the Staff certification process. This tool allows you to step through your staff validations and correct assignments one at a time.
Alternatively to correcting these items in WISEstaff, you could also fix these errors in your HR system and then re-upload the assignment file to WISEstaff, clearing the errors.
View Upload Results
Previously called 'Results,' this screen is where you can review the status and validation results of your uploaded data files. The results queue indicates the status of each file during and after the upload process. Once the file is finished processing, you will see the number of records processed, the number of changes made to existing data, and the number of potential duplicate WISEid records, if applicable.
Return to WISEstaff Info and Help page
- This number must be rounded to the nearest hundredths place.
-
“Update existing data for matching records” - This option is best if you’ve already uploaded your staff data, but you have some changes from last year to this year. This option will update changes reflected in your file.
-
“Delete all data and replace with a new upload” - This option wipes out all existing contract/assignment data and replaces those contracts/assignments with only the information of the file you’re uploading.
- Move on to Step 2d of the Staff Collection Checklist for Preliminary Certification
- Move on to Step 3e of the Staff Collection Checklist for Final Agency Certification
- From the ‘Validate Staff Data’ screen click the “Go to Navigator” button to launch the tool.
- There will be a table showing all of the errors. We strongly recommend that you right click to open each record in a new tab.
- Review the content on the error and address the specific content that needs to be changed to resolve the error.
- Once the data is corrected, you have two options: you can either save or you run the validation.
- Running the validation takes longer, but then you can be 100% sure that the problem has been resolved.
- You can go to the next button and go step through your entire list one error at a time.
- NOTE: If you click the “Next” button without clicking 'Save', your changes will not be saved!!
-