Date printed: 03-23-2018   Last updated: 04-02-2009

To view our complete support knowledge base and most current version of this article visit

Applies to versions: 1.6, 1.8

Expression Variables for Custom Report / Custom Payroll Export

Variables available for expressions in "Columns" tab

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"

Length of payroll event in seconds


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

Name of the report preset


The name of the shift worked, when a shift differential apllies


The name of the shift differential, it it applies


The code of the shift differential, if it applies

division_code The payroll code set for the division



Variables available for expressions in the "Preamble" and "Footer" tabs:

rowcount Rows in the report
comment Report Comment
reportStart Timestamp of report start
reportEnd Timestamp of report end
totalPay (grand total pay for the report)
total-# (i.e. total-1 for total of column 1)

©2004-2017 TimeIPS, Inc. All Rights Reserved - TimeIPS and the TimeIPS logo are registered trademarks of TimeIPS, Inc.
"Intelligent Personnel System" "Run your Business. We'll watch the clock." are trademarks of TimeIPS, Inc.
TimeIPS is protected by one or more patents. Patent No. US 7,114.684 B2.