...

The import file supplied by the third-party software must conform to a specific format. It must be a comma delimited or a comma separated values (CSV) file. There are certain fields that are required and the data must be in a certain format/order.

The Attendance/Absence Import option has the ability to import records into both Attendance and CURRENT/FUTURE.  A specific Expenditure Account can be specified to be charged for the CURRENT/FUTURE record.

There is no limit to the number of records on the CSV import.

Image Removed

...

...

Image Added

• Attendance Import File- can import file supplied by a third-party software.    Must be a comma delimited or a comma separated values (CSV).
• Location Code - prompt is used to determine the job number to post the transaction to if a job number is not supplied. The location code may contain either a Building IRN or Building/Department code (from Position). If you are using the location code field, enter one of the following codes: 
  •  Building IRN
  •  Building/Department Code
  •  None
• Post to Payroll Processing Options offers the following options:
  •  Post to Payroll Processing Future
  •  Post to Payroll Processing Current
  •  None - No Payroll Processing Current/Future posting will take place. The "Calc gross" parameter from the CSV file is ignored as well
• Combine Attendance Entries
  • Check if AT if AT entries charged to CURRENTto CURRENT/FUTURE will be combined for an employee. In order to combine entries in CURRENTin CURRENT/FUTURE, the EMPID, job number, pay type, unit, unit amount, tax option, retirement flag, expenditure account, leave projection flag, and the BRDDIS Employer Distribution flag must match (This will combine those entries on the employees Pay Stub, not on the Pay Report)

  • Leave unchecked if AT entries will not be combined when posted to CURRENT/FUTURE 

• Allow Negative Leave Balance prompt offers the following options: 

  • Check if AB entries for Sick, Vacation and Personal Leave will be allowed to go negative.  It will appear as a WARNING on the report.

  • Leave uncheck if AB entries for Sick, Vacation and Personal Leave will NOT go negative. It will appear as a FATAL Error on the report

    • **NOTE** Even if the Rule is set to False, Image Addedstill need to check this option to allow negative balances.
• Payroll Account to Charge prompt offers the following options:
  • Defined Payroll Account for Position -Pay account defined in Payroll Account for the job will be use 
  • Sub for SSN -the regular employee's pay account(s) will be charged.

USPS Attendance/Absence Import SPECS

...

• •  
    • If the pay account to charge prompt is set to 'Sub for SSN', the attend option will allow for specific object codes to be entered when charging substitutes pay. Enter the appropriate object code in the Certified object, and/or Classified object, fields. The object codes are only available when the sub for SSN option is used.   
      • Enter Certified Object
      • Enter Classified Object

Image Added

USPS Attendance/Absence Import SPECS

Attendance/Absence Specific Record Format

...

Example of USPIMPORT.CSV:

Image RemovedImage Added

Opened in Notepad:

Image AddedImage Removed

Overtime

Important Attendance Import Misc Information:

If the unit amount is specified in the csv file for an "OT" (overtime) pay type, then the amount (rate) from the csv file will override the unit amount in Compensation.  If no unit amount is specified in the csv file for an "OT" pay type,
then the unit amount will be the Compensation rate * 1.5.

ATTERR

All errors will be displayed in the error report file (ATTERR.CSV) that is generated when running the Attendance Import AND on the Attendance/Absence Import screen. When    When a record is not valid it will be added to the error report as a CSV line with a ' I ' character at the end.  Everything after this is the error message:

...

• Attendance for the day cannot total more than 1 day.
  •  If the tracking unit is "D" (daily) and the transaction length is greater than 1 or less than -1.
• Attendance for the day cannot total more than 24 hours
  •  If the tracking unit is "H" (hourly) and the transaction length is greater than 24 or less than -24.
• An Attendance entry cannot be posted to a position for which the job status is deceased.
  • An ATTENDANCE entry cannot be posted to a position for which the Job Status is deceased in POSITIONS
• An Attendance entry cannot be posted to a position for which the job status is terminated.
  • An ATTENDANCE entry cannot be posted to a position for which the Job Status is terminated in POSITIONS
  Appropriation account does not exist for budget account
  • Budget account to be charged does not have a corresponding appropriation account. ATDSCN record and UPDCAL records are not written.Status is terminated in POSITIONS
• Appropriation account does not exist for budget account
  • Budget account to be charged does not have a corresponding appropriation account. ATDSCN record and UPDCAL records are not written.
• Balance for Sick (Employee#: XXXXXXXXX) is negative.  Negative leave balances are not allowed
  • Check Leave balance for employee.
  • Check System/Rules:
    • Rule to prevent Sick Leave Balance from going negative
  • If district uses Advance Sick Leave, check the 'Allow Negative Leave Balances' in Attendance/Absence Import
• Board distribution flag must be Y, N or blank.  If not specified, the default is Y
• Can not Cannot determine compensation for posting transaction to payroll.  More than 1 active non-contract compensation.
• Compensation is advanced.  New earnings (REG) may not be added to the compensation.
• Date of transaction is not in YYYYMMDD format or is invalid based on the month and the number of days in the month (ie. 19990231 would be invalid since February does not have 31 days.)
  • Correct date formatting on the csv file would be YYYYMMDD.
• Days worked = work days workdays in contract.
  • The days worked cannot equal work days workdays in the contract
• Days worked exceeds work days workdays in contract.
  • The days worked cannot exceed the work days workdays in the contract.
• District not set up to use XREF XREF codes.
  • XREF code has been supplied in the CSV record but the district's USAS configuration information indicates the district does not utilize XREF codes. The record is not written to ATDSCN or UPDCAL.
•  Invalid Activity Date. 
  • Date must be in YYYYMMDD format.  Date on the csv file is blank.
• Invalid (insert budget account related item here)
  • For example, invalid function per the current Blue Book standards. Budget account to be charged is invalid. Record is not written to ATDSCN or UPDCAL.
• Invalid Effective Date
  • Effective Date must be in YYYYMMDD format.
• Invalid job number
  • If posting to UPDCAL and the job number is zero or not found, or a job number was supplied in the CSV file, but there is no corresponding JOBSCN record on file for the Employee ID and job number.
• Invalid pay type
  • Posting to UPDCAL and an invalid pay type (other than spaces) is found.
• Invalid special cost center
  • Special cost center in budget account to be charged is not valid. Record not written to ATDSCN or UPDCAL.
• Invalid transaction category
  • If an AT transaction type, the category must be either AT or SB. If an AB transaction type, the category must be one of the following: CA, DO, HO, JD, MI, OT, PL, PR, SI, UN, VA.
• Invalid transaction date
  • Transaction date is prior to 1970/01/01. Date of transaction is not in YYYYMMDD format or is invalid based on the month and the number of days in the month (ie. 19990231 would be invalid since  February February does not have 31 days.)
• Invalid transaction type
  • Transaction type must be either AB or AT.
• Invalid record indicator on record:
  • The record number specified does not contain a record indicator of AA.  Verify the information listed on the CSV file.
• Irregular pay type affects contract amount paid for advanced compensation, can not cannot be used.
• No Active compensations found for posting transaction to payroll
  • Employee's compensation is archived.
• No Employee found for Employee #: XXXXXXXX
  • There was no match found in the employee master file for the Employee ID supplied in the CSV file. 
• No position number provided or determined for payroll posting
  • A position number is not defined on the csv file for the related record.
• The Appointment Type in the CSV file must match the Appointment Type on Position View. Employee #: XXXXXXXX
  •  The appointment type in the csv file must match the appointment type in POSITION screen.
• The value supplied in the CSV file for the calculate gross option was invalid.  This field is optional.  If supplied it must be either Y, N OR Space.
• This Position / Employee is not eligible for personal leave
  • According to CORE/POSITION, the job/employee is not eligible for personal leave.
• This Position / Employee is not eligible for sick leave
  • According to CORE/POSITION, the job/employee is not eligible for sick leave.
• This Position / Employee is not eligible for vacation leave
  • According to CORE/POSITION, the job/employee is not eligible for vacation leave.
• Leave Projection flag must be Y, N or blank.  If not specified, the default is Y. 
• Leaves records do not exist for Employee #: XXXXXXXXX
  • There is no CORE/LEAVES record on file for the Employee ID. This record must be present to post an absence for sick, vacation, or personal leave.
• No acct code , but has BRDDIS/LEVPRO.
  • Account code is needed if BRDDIS or LEVPRO flags are specified.
• Pays paid = number of pays.
  • Pays paid cannot equal number of pays.
• Position number could not be determined for payroll posting.
  •  Position number must be specified for this type of transaction.
• String index out of range: XX
  • Account code needs to equal 28 digits
• Too large. The unit amount on the csv file cannot be greater than 9999.999.
• Tracking unit not equal to benefit unit
  • The tracking unit supplied in the CSV file (hours/days) does not match the tracking unit defined on the employee's USPSCN/BENSCN record.
• Transaction length cannot equal zero 
• Unable to write ABSDET record
  • An error occurred while trying to write the ABSDET record. This generally means there is already a record on file with the same key values.
• XREF code not found
  • XREF code supplied on CSV record could not be found on the district's XREF file. Record not written to ATDSCN or UPDCAL.

...