Variable | Description |
usersID |
Employee's internal ID number (use with utcdate function to format time into the Employee's time zone) |
nameFirst |
Employee's first name |
nameMid |
Employee's middle name |
nameLast |
Employee's last name |
HID |
Employee's badge number |
empNum |
Employee's Alternate number |
mgrNameFirst |
Employee's manger's first name |
mgrNameMid |
Employee's manager's middle name |
mgrNameLast |
Employee's manager's last name |
addr1 |
Employee's Address line 1 |
addr2 |
Employee's Address line 2 |
city |
Employee's city |
state |
Employee's state |
zip |
Employee's zip code |
phoneExt |
Employee's phone extension |
homePhone |
Employee's home phone |
cellPhone |
Employee's cell phone |
startDate |
Employee's hire date |
birthDay |
Employee's birthday |
username |
Employee's login username |
title |
Employee's title |
SSN |
Employee's SSN or Gov ID |
status |
0=inactive, 1=active |
gender |
Employee's gender: M/F/null |
email1 |
Employee's first email address |
email2 |
Employee's second email address |
email3 |
Employee's third email address |
dept |
Employee's department |
dept_code |
Employee's department's code |
e1Name |
Employee's emergency 1 Name |
e1Addr1 |
Employee's emergency 1 Address 1 |
e1Addr2 |
Employee's emergency 1 Address 2 |
e1City |
Employee's emergency 1 City |
e1State |
Employee's emergency 1 State |
e1Zip |
Employee's emergency 1 Zip |
e1Phone |
Employee's emergency 1 Phone |
e1Public |
Employee's emergency 1 Public viewable flag |
e2Name |
Employee's emergency 2 Name |
e2Addr1 |
Employee's emergency 2 Address 1 |
e2Addr2 |
Employee's emergency 2 Address 2 |
e2City |
Employee's emergency 2 City |
e2State |
Employee's emergency 2 State |
e2Zip |
Employee's emergency 2 Zip |
e2Phone |
Employee's emergency 2 Phone |
e2Public |
Employee's emergency 2 Public viewable flag |
week_starts_time |
Employee's schedule week starts time |
week_starts_day |
Employee's schedule week starts day |
scheduled_hours_per_week |
Employee's scheduled hours per week |
flagIn |
Error on in, i.e. double punch |
flagOut |
Error on out |
clockNote |
Clock in note |
clockNoteOut |
Clock out note |
clock_in_out_note |
Clock in and clock out note together |
clientIn |
Name of clock where clock-in took place |
clientOut |
Name of clock where clock-out took place |
remoteIpIn |
IP address of computer used to clock-in (remote clock only) |
remoteIpOut |
IP address of computer used to clock-out (remote clock only) |
cidInNumber |
Caller ID of phone used to clock-in (telephone clock only) |
cidOutNumber |
Caller ID of phone used to clock-out (telephone clock only) |
cidInName |
Caller ID name of phone used to clock-in (telephone clock only) |
cidOutName |
Caller ID name of phone used to clock-out (telephone clock only) |
payableOnHoliday |
"Yes" if time occurs within a holiday, otherwise null |
siteLocationIn |
Clock location, including site name |
locationIn |
Clock location, without site name |
siteLocationOut |
Clock location of clock-out |
locationOut |
Clock location of clock-out, without site name |
payrollEventType |
Type of pay, i.e. Standardtime, Overtime, Sick, Paid Time Off, etc. |
payrollEventType_code_name |
Type of pay codename, i.e. standardtime, sick, paidtimeoff, etc. |
job_shortname |
Job short name |
job_longname |
Job long name |
job_description |
Job description |
job_ctrlNum |
Job control number |
job_glNum |
Job GL number |
job_code |
Job code |
job_subCode |
Job subcode |
job_altNum |
Job alternate number |
job_rate |
Job billing rate |
job_overrideHourlyRate |
Job override Hourly Rate |
job_overrideMultiplier |
Job override Multiplier |
job_overrideDifferential |
Job override Differential |
job_category |
Job category |
customer_name |
Customer name of job (not work order) |
defaultJob_shortname |
Employee's default job short name |
defaultJob_longname |
Employee's default job long name |
defaultJob_description |
Employee's default job description |
defaultJob_ctrlNum |
Employee's default job control number |
defaultJob_glNum |
Employee's default job GL number |
defaultJob_code |
Employee's default job code |
defaultJob_subCode |
Employee's default job subcode |
defaultJob_altNum |
Employee's default job alternate number |
defaultJob_rate |
Employee's default job billing rate |
defaultJjob_category |
Employee's default job category |
defaultJ_customer_name |
Customer name of employee's default job (not work order) |
workorder_name |
Workorder name |
workorder_code |
Workorder code |
workorder_poNum |
Workorder po number |
workorder_dateStart |
Workorder start date |
workorder_dateDue |
Workorder due date |
workorder_detail |
Workorder detail |
workorder_completion |
Workorder completion |
workorder_customer |
Workorder customer |
adjTimeIn |
Paid time start (timestamp) - includes all edits, rounding, snapping, etc. |
adjTimeOut |
Paid time end (timestamp) - includes all edits, rounding, snapping, etc. |
timeIn |
Time in creation time (timestamp) - time the clock-in was actuall created |
timeOut |
Time out creation time (timestamp) - time the clock-out was actually created |
realTimeIn |
Real time in (timestamp) - clockin time without edits, rounding or snapping |
realTimeOut |
Real time out (timestamp) - clockin time without edits, rounding or snapping |
occurs |
Payable time start (timestamp) - includes splits for day, type of pay change, etc.
|
endoccurs |
Payable time end (timestamp) - includes splits for day, type of pay change, etc. |
empType |
Payroll type |
paid_hourly_rate |
Regular rate as calculated for event |
ww_start |
Workweek start timestamp |
ww_end |
Workweek end timestamp |
paid |
0 for unpaid benefit types, otherwise 1 |
payroll_occurred |
Date marked as "payrolled" |
code_name |
Same as payrollEventType_code_name |
isHourly |
"Yes" if employee has an hourly rate, otherwise "No" |
flsa_exempt |
"Yes" or "No" |
duration |
Length of payroll event in seconds
|
sumDuration |
All worked time in seconds
|
benefitRequestNote |
Note attached to a benefit request |
benefitRequestDate |
Date of the creation for a benefit request |
benefitName |
Benifit type name ie "Sick", "Vacation", etc |
benefitSubclassName |
Benifit Subclass name |
benefitSubclassCode |
Benifit Subclass code |
benefitSubclassGlnum |
Benifit Subclass GL number |
benefitSubclassDescription |
Benifit Subclass Description |
endTimestamp |
payroll report range end timestamp |
begTimestamp |
payroll report range beginning timestamp |
reg_hourly_rate |
Payable Hourly Rate (base, no modifiers) - Employee's Base Hourly Rate without any kind of differentials, overrides, overtime, etc. applied. |
payRate |
Payable Hourly Rate (diff/override) - Employee's Base Hourly Rate, plus any differentials or overrides, but no OT/DT/PT. |
pay_per_hour |
Payable Hourly Rate (diff/override and OT/DT/PT) - Employee's Base Hourly Rate plus any differentials or overrides, multiplied by OT/DT/PT multipliers, if applicable. For FLSA compliance, when in OT/DT/PT, this amount is at least the Payable FLSA Weekly Base Hourly Rate times the OT/DT/PT multiplier. |
base_rate |
Payable FLSA Weekly Base Hourly Rate - FLSA Weekly Base Hourly Rate used to figure OT/DT minimums for the entire week. |
net_pay |
Total net dollar amount pay for event |
hourly_rate |
Override rate (can be null) |
hourly_differential |
Override differential (can be null) |
rate_multiplier |
Override rate multiplier (can be null) |
payroll_event_type_name |
Override pay type name, i.e. Overtime, Sick, etc. (can be null) |
counts_toward_overtime |
Override counts-toward-overtime (can be null) |
event_note |
Payroll engine notes on splits, benefits and misc (can be null) |
event_note_pay |
Payroll engine notes on pay and overtime (can be null) |
holiday_name |
Holiday Name, only set for actual holiday hours (can be null) |
holidayPaycode |
Holiday Paycode, set per holiday and only set for holiday hours (can be null) |
holidayWorkedPaycode |
Holiday Worked Paycode, set if the worked time occurs during a holiday observance (can be null) |
holiday_day_name |
Holiday Name, set for holiday hours and any work on holiday (can be null) |
payCode |
Pay code from pay codes table |
presetName |
Name of the report preset
|
shift_name |
The name of the shift worked, when a shift differential apllies
|
shiftDifferential_name |
The name of the shift differential, it it applies
|
shiftDifferential_code |
The code of the shift differential, if it applies
|
division_code |
The payroll code set for the division |