Page Comparison

3

Required: 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.

Location Code

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.

E

Valid values are: AB = absence AT = attendance

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

Length of absence or attendance

(+/-)99999.999

(+/-)9999.999

Appointment type

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

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.

Sub category

Optional: User defined. May be used to further define the transaction category. Multiple entries can be entered in the description field by comma's - Example: test, description. Import will allow quotes or no quotes to be used around fields-Example: "5/8/22, 5/10,22"

Budget account or XREF code

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

Budget code:

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.

Info

• If 0 is entered - will result in 0 in retire hours of future pay and hours worked of current pay
• If no value is entered - will pull retire hours from retire hours on the assigned compensation (assigned from compensation label in import file).  If no retire hours are on compensation, then the hours in day will be used.  (with exception of the pay types listed in the NOTE below)
• If negative value is entered - will pull retire hours from retire hours on the assigned compensation (assigned from compensation label in import file).  If no retire hours are on compensation, then the hours in day will be used. 
• If positive value is entered - value will show in retire hours of future and hours worked of current

NOTE:  If you provide no value for retire hours and the pay type is Miscellaneous, Dock, Shift Premium, Irregular, Retro, or Termination, then the retire hours will be set to 0 in future and current, and not defaulted to the values from the compensation. 

Optional: 

REG (cannot be used if employee is in advance)

MIS

OT

DCK

SHP

IRR (cannot be used if employee is in advance)

BCK

TRM

POF

NC1

NC2

NC3

If left blank in csv file:

•  If POSITION Supplemental Type = SUP1, then 1 is automatically assigned (Apply Annuities to Regular)

•  If POSITION Supplemental Type = SUP3, then 3 is automatically assigned (Apply Annuities to Supplemental)

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

If not specified, it defaults to none.

Optional: Y, N or space
Y or Space = Yes
N = No

Optional 

Multiple entries can be entered in the description field by comma's - Example: test, description. Import will allow quotes or no quotes to be used around fields-Example: "5/8/22, 5/10,22"

Y or Space = Yes

N = No

Y or Space = Yes

N = NO

Y or Space = Yes

N = No