Import Application Details

Application Name

Extra Duty Non TRS

Description

This will import extra duty pay on the Non TRS tab. The file will be imported from the district's FTP site and should be in it's own folder. All files in the FTP folder will be processed allowing for multiple extra duty sheets to be imported. Headers are not necessary, but columns need to be in the correct order.

File Name(s)

ExtraDutyNonTRS.csv

Number of Columns

21

Column Names

Staff ID	6-Digit ID
Hours	2 Decimals
Amount	No $, Numbers only
Pay Date	YYYYMMDD
Actual Date	YYYYMMDD
Description	50 characters
User	Username of person entering
Use 457	Y/N
Workers Comp	1 character
Payment Code	1 character, Y/N or blank
Payment Type	1 character, 1, 2 or 3 usually per district specs
Taxable	Y/N
Fund	3-digit code
Func	2-digit code
Obj	4-digit code
Sobj	2-digit code
Org	3-digit code
Fscl Yr	1-digit code
Pgm	2-digit code
Ed Span	1-digit code
Proj Dtl	2-digit code