Staff Attendance Import (Massachusetts)

Tool Search: Staff Attendance Import

The Staff Attendance Import allows you to mass import staff actual and expected attendance data generated from the Staff Attendance Extract or a compiled CSV file matching all import file format requirements.

Screenshot of Staff Attendance Import Editor.Staff Attendance Import Editor

Importing a File

  1. Click Browse to select a file to be imported. The file MUST match the column order defined in the Upload Layout table below and cannot include any additional columns. 
  2. Once a file is chosen, click Upload to import the file. A report will generate indicating how many records were successfully imported and any errors which occurred based on incorrect or null data.

Validations/Errors

If data cannot be uploaded properly, the import file generates an error report describing why each record could not be uploaded. Expand the table below to view each possible validation/error.

Click here to expand...

Type

Name

Description

Condition

ValidationIncorrect File type (Use CSV)Indicates to user to upload only CSV fileUser uploads file type that is not CSV format
ErrorNo matching PersonID or AssignmentIDIndicate rows and PersonID's/AssignmentID's in the file that do not match personID's or assignmentID's in the database.Column 1 (PersonID)  and/or Column 7 (AssignmentID) does not match anything in DB
ErrorNo matching PersonID or AssignmentIDIndicate rows and PersonID's/AssignmentID's in the file that do not match personID's or assignmentID's in the database.Column 1  (PersonID) does not match anything in the database.
ErrorNo matching PersonID or AssignmentIDIndicate rows and PersonID's/AssignmentID's in the file that do not match personID's or assignmentID's in the databaseColumn 7 (AssignmentID) does not match anything in the database.
ErrorPersonID/AssignmentID do not match each otherWhile the ID's match in the database, they do not tie to the same person/assignmentColumn 1 (PersonID)  and/or Column 7(AssignmentID) do not link up with each other
ErrorExpected Attendance NullIndicate rows and PersonID's in the file where no expected attendance was importedColumn 8 (StaffExpectedAttendance) is null
ErrorActual Attendance NullIndicate rows and PersonID's in the file where no expected attendance was importedColumn 9 (StaffActualAttendnace) is null
ErrorExpected Attendance has a decimal
Indicate rows and PersonID's in the file where expected attendance was a decimal
Column 8 (StaffExpectedAttendance) has a decimal
ErrorActual Attendance has a decimal
Indicate rows and PersonID's in the file where actual attendance was a decimal
Column 9 (StaffActualAttendance) has a decimal

Upload Layout

ElementDescriptionType,
Format, and
Length 
Campus UI and Database Location
PersonIDInternal database identifier

Value must match for import to occur, otherwise an error is generated.
NumericDemographics  > Person ID

Person.personID
StaffStateIDIndicates MEPID given by stateAlphanumericDemographics > Staff State ID

Person.staffStateID
LocalStaffIDIndicates local ID given by districtAlphanumericDemographics > Local Staff Number

Person.staffNumber
LastNameThe staff member's last name.Alphanumeric, 50 charactersCensus > People > Demographics > Person Information > Last Name

Identity.lastName
MiddleNameThe staff member's middle name.Alphanumeric, 50 charactersDemographics  > Middle Name

Identity.middleName
FirstNameThe staff member's first name.Alphanumeric, 50 charactersDemographics > First Name

Identity.firstName
EmploymentIDInternal database Identifier.
Value must match for import to occur.
NumericDistrict Assignments > Primary District Assignment

HR:
Human Resources > Personnel > Personnel Master > Work Assignments

EmploymentAssignment.
assignmentID
StaffExpected
Attendance 

Indicates staff person's expected attendance for the school year.


If null, receive error


If value is a decimal, receive error

NumericDistrict Assignments > Staff Expected Attendance

HR:
Human Resources > Personnel > Personnel Master > Work Assignments > Work Assignment Editor > Work Assignment Detail > Payroll Information > Expected Attendance

Employment.
expectedAttendance
StaffActual
Attendance
Indicates staff person's actual attendance for the school year.

If null, receive error


If value is a decimal, receive error


Numeric

District Assignments > Staff Actual Attendance


HR:
Human Resources > Personnel > Personnel Master > Work Assignments > Work Assignment Editor > Work Assignment Detail >Payroll Information > Actual Attendance


Employment.
actualAttendance


HR:

EmploymentAssignment.
actualAttendance