Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field NameSpreadsheet ColumnCSV Position  DescriptionFormatMax. Size 
Record IndicatorA1Literal record indicator must contain "AA" to indicate Absence/AttendanceLiteral XXXX
Employee ID or SSNB2NumberEmployXXXXXXXXX
Position NumberC

3

Optional: Compensation number. Either the job number or a location code must be provided to permit posting into CURRENT or FUTURE. This job number would be matched directly to the COMPENSATION record for the employee.Option

99

Location Code

D4

Optional: Buidling IRN or Building/Department code. If a job number is not provided, the location code may be used to determine which job the record is to be posted to.

XXXXXX
Date

E

5Transaction posting dateYYYYMMDD
Transaction TypeF6

Valid values are: AB = absence AT = attendance

XX
Transaction CategoryG7

Valid values for type AT: AT = Attendance SB = Substituting Valid values for type AB: CA = calamity DO = dock HO = holiday JD = jury duty MI = military OT = other PL = personal leave PR = professional leave SI = sick UN = unknown VA = vacation

XX
Length/HoursLengH8

Length of absence or attendance

(+/-)99999.999

10 
Tracking UnitI9Valid values for unit of attendance or absence: H = hourly D = dailyValidXX
Unit amountJ10Optional: If supplied, this rate will be used for paying the job.  If not supplied, the job will be paid using the unit amount from the POSITION record same location code.Optional

(+/-)9999.999

Appointment type

K11

Optional: Valid values for appointment type: Space = not defined 1 = Certified 2 = Classified

XX
Sub for IDL12

Optional: Employee ID Number for absent employee. ID of employee whose position the sub is filling in for. May be used to determine pay account charging.

XXXXXXXXX

Sub category

M13

Optional: User defined. May be used to further define the transaction category.

XX

Budget account or XREF code

N14

Optional: Budget account to charge during payroll. An XREF code may be used rather than the full budget account code.

Alphanumeric28 
  

Budget code:

   
  FundXXX  
  FunctionXXXX  
  ObjectXXX  
  Special Cost CenterXXXX  
  SubjectXXXXXX   
  Operational UnitXXX   
  Instructional LevelXX   
  Job Assignment XXX   
   XREF codeXXXXXX   
Calculate gross15 Optional: Valid values for gross flag are: Y = yes N = no space = user defined at run time The user will be asked at run time, "Post to Current, Future, or None?" If none, this flag is ignored and no transactions will be posted to Payroll Payments - Current or Future. If the user answers Current or Future, the space and "Y" will provide the same result. The transaction will be posted to Payroll Payments - Current or Future. If "N", the transaction will not be posted to Payroll Payments - Current or Future. X
Retire hours16 Optional: Retirement hours will be imported to CURRENT or FUTURE, depending on what the user chooses. If retirement hours are not specified for a REG or OT pay type, the COMPENSATION Hours In Day fields (if populated) will be used to automatically calculate a value. (+/-)999.999
Pay Type17 Optional:  REG, MIS, OT, DCK, SHP, IRR, BCK, TRM, POF, NC1, NC2, NC3XXX 
Tax Option18 Optional: 1, 2, 3 or space

If left blank in csv file:

•  If POSITION Supplemental Type = SUP1, then 1 is automatically assigned

•  If POSITION Supplemental Type = SUP3, then 3 is automatically asssigned

•  If POSITION Supplemental Type not SUP1 or SUP3, then 2 is automatically assigned

 X
Retirement option19 Optional: Y, N or space
Y or Space = Yes
N = No
Pay Amount Description20 Optional Alphanumeric 25 
Attendance posting Flag 21 Optional: Y, N or space

Y or Space = Yes

N = No

 X
Board Distribution Flag22 Optional: Y, N or space

Y or Space = Yes

N = NO

Leave Projection Flag23 Optional: Y, N or space

Y or Space = Yes

N = No

Effective Date24 Optional: The effective date only applies to FUTURE entries. This date must be a vaild date in the format of YYYYMMDD and should be in the future. CURRENT entries will always contain zeroes since it is for the current payroll.YYYYMMDD 
LabelY25Optional: The Label Required for Posting a compensation record can be defined.Payroll Payment: Must match the label field on the compensation you want the payroll payment to be posted for. This field is optional if you are only posting attendance.Alphanumeric 

 

ATTERR

All errors will be displayed in the error report file (ATTERR.CSV) that is generated when running the Attendance Import. 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:

...