Variable Outline | Full Variable Name | Description |
time
|
[time] |
This is the Unix Timestamp of the clock attempt. Convert this with the utcdate function. |
ip
|
[ip] |
This is the IP address of the clock attempt. |
user
|
[user] |
This variables itself has no value to expressions. It serves as the starting point for multi-dimensional variables that contain more information about this employee. |
usersID
|
[user][usersID] |
This is the unique database ID assigned to this employee by TimeIPS. This will always be unique among all employees in the system. |
nameFirst
|
[user][nameFirst] |
The employee's first name |
nameLast
|
[user][nameLast] |
The employee's last name |
nameMid
|
[user][nameMid] |
The employee's middle name if provided. |
namePref
|
[user][namePref] |
The employee's preferred name if provided |
HID
|
[user][HID] |
The employee's badge number |
type
|
[user][type] |
Starting point for information about the employee's payroll type. |
typeID
|
[user][type][typeID] |
A unique database ID assigned to this payroll type. |
name
|
[user][type][name] |
The name of the employee's payroll type. |
timing_frame
|
[user][type][timing_frame] |
An indicator about the payroll frequency of this payroll type. Possible values are 'week', 'biweek', 'month', 'bimonth', and '4-4-5' |
code
|
[user][type][code] |
An arbitrary payroll code associated with this payroll type. |
orgUnit
|
[user][orgUnit] |
Starting point for the employee's organizational unit |
organizationalUnitID
|
[user][orgUnit][organizationalUnitID] |
A unique database ID for this unit |
name
|
[user][orgUnit][name] |
The name of this unit |
code
|
[user][orgUnit][code] |
An arbitrary code associated with this unit |
scheduleGroup
|
[user][scheduleGroup] |
Starting point for this employee's schedule group |
schedGroupID
|
[user][scheduleGroup][schedGroupID] |
Unique database ID. |
name
|
[user][scheduleGroup][name] |
The name of this schedule group |
defaultDepartment
|
[user][defaultDepartment] |
Starting point for information about this employee's default department |
departmentID
|
[user][defaultDepartment][departmentID] |
A unique database ID |
name
|
[user][defaultDepartment][name] |
The name of this employee's default department |
shortName
|
[user][defaultDepartment][shortName] |
The abbreviated name of this department |
ctrlNum
|
[user][defaultDepartment][ctrlNum] |
An arbirtrary control number for this department |
code
|
[user][defaultDepartment][code] |
The code for this department. This is the code employees might type at the clock |
subCode
|
[user][defaultDepartment][subCode] |
An optional subcode for this department |
glNum
|
[user][defaultDepartment][glNum] |
An optional G.L. Number for this department. |
altNum
|
[user][defaultDepartment][altNum] |
An optional alternate number used by this department |
trackTime
|
[user][defaultDepartment][trackTime] |
Either a 1 or 0 if this department is tracked against worked time |
trackBenefits
|
[user][defaultDepartment][trackBenefits] |
Either a 1 or 0 if this department is tracked against benefits |
trackHolidays
|
[user][defaultDepartment][trackHolidays] |
Either a 1 or 0 if this department is tracked against holidays |
trackPiecework
|
[user][defaultDepartment][trackPiecework] |
Either a 1 or 0 if this department is tracked against piecework |
defaultWorkOrder
|
[user][defaultWorkOrder] |
Starting point for information about the employee's default work order |
workOrderID
|
[user][defaultworkOrder][workOrderID] |
A unique database ID about this work order |
name
|
[user][defaultworkOrder][name] |
The name of this work order |
lcdName
|
[user][defaultworkOrder][lcdName] |
The abbreviated name of this work order |
code
|
[user][defaultworkOrder][code] |
The code to identify the work order |
poNum
|
[user][defaultworkOrder][poNum] |
A P.O. number associated with the work order |
dateStart
|
[user][defaultworkOrder][dateStart] |
The date work on this work order is intended to begin |
dateDue
|
[user][defaultworkOrder][dateDue] |
The due date of this work order |
note
|
[user][defaultworkOrder][note] |
A note associated with this work order |
customer
|
[user][defaultworkOrder][customer] |
A starting point for information about the customer on this work order |
custID
|
[user][defaultworkOrder][customer][custID] |
This customer's unique database ID |
name
|
[user][defaultworkOrder][customer][name] |
The name of this customer |
addr1
|
[user][defaultworkOrder][customer][addr1] |
The first line in this customer's address |
addr2
|
[user][defaultworkOrder][customer][addr2] |
The second line in this customer's address |
city
|
[user][defaultworkOrder][customer][city] |
The city for this customer's address |
state
|
[user][defaultworkOrder][customer][state] |
The state for this customer's address |
zip
|
[user][defaultworkOrder][customer][zip] |
The zip code for this customer's address |
phone
|
[user][defaultworkOrder][customer][phone] |
The phone number on this customer |
fax
|
[user][defaultworkOrder][customer][fax] |
The fax number on this customer |
defaultJob
|
[user][defaultJob] |
Starting point for information about this customer's default job |
jobID
|
[user][defaultJob][jobID] |
The unique database ID associated with his job |
lcdName
|
[user][defaultJob][lcdName] |
The shortened name of this job |
code
|
[user][defaultJob][code] |
The job code used to clock in to this job |
name
|
[user][defaultJob][name] |
The name of the job |
ctrlNum
|
[user][defaultJob][ctrlNum] |
A control number associated with the job |
billingRate
|
[user][defaultJob][billingRate] |
A billing rate associated with the job |
glNum
|
[user][defaultJob][glNum] |
A G.L. number for the job |
description
|
[user][defaultJob][description] |
Any description provided about the job |
subCode
|
[user][defaultJob][subCode] |
An arbitrary sub code identifier for the job |
altNum
|
[user][defaultJob][altNum] |
The job's alternate number |
customer
|
[user][defaultworkOrder][customer] |
A starting point for information about the customer on this work order |
custID
|
[user][defaultworkOrder][customer][custID] |
This customer's unique database ID |
name
|
[user][defaultworkOrder][customer][name] |
The name of this customer |
addr1
|
[user][defaultworkOrder][customer][addr1] |
The first line in this customer's address |
addr2
|
[user][defaultworkOrder][customer][addr2] |
The second line in this customer's address |
city
|
[user][defaultworkOrder][customer][city] |
The city for this customer's address |
state
|
[user][defaultworkOrder][customer][state] |
The state for this customer's address |
zip
|
[user][defaultworkOrder][customer][zip] |
The zip code for this customer's address |
phone
|
[user][defaultworkOrder][customer][phone] |
The phone number on this customer |
fax
|
[user][defaultworkOrder][customer][fax] |
The fax number on this customer |
category
|
[user][defaultJob][category] |
Starting point for information about this job's category |
catID
|
[user][defaultJob][category][catID] |
A unique database ID for this category |
name
|
[user][defaultJob][category][name] |
The name of the category |
descr
|
[user][defaultJob][category][descr] |
A description about this job category |
code
|
[user][defaultJob][category][code] |
A code associated with this job category |
manager
|
[user][manager] *? |
This is the employee's manager. There is another complete set of variables for the manager starting where this list startes with 'user'. For example to get this employee's manager's name you could use [user][manager][nameFirst] If the manager has a manager above them then they will also have a manager entry at [user][manager][manager] and so on. |