Time Clock In/Out

This domain allows you to build a report based on Clock In/Out data.

The domains consists of the following columns (NOTE: Column names could be renamed so you might see different names based on your side configuration, so the following names are the base names of the system)

Important Note: When building a report based on this domain, Time Zone must be selected as a filter parameter

Column ID	Column Name (From DBLabels.properties)	Data Type	Description

Column ID	Column Name (From DBLabels.properties)	Data Type	Description
CONVERTTIMEZONE	Time Zone	String	Indicates the Time Zone to which the data should be converted to when displaying the clock in details.
EMP_ACTIVE	Active Employee	String	Employee Active Yes or No
EMPLY_ID	Employee ID	String	Employee Id
HOME_FUNC_CODE	Home Function Code	String	Home Function Code
HOME_DEPT_CODE	Home Department Code	String	Home Department Code
HOME_DEPT_NAME	Home Department	String	Home Department Name
HOME_FUNC_NAME	Home Function	String	Home Function Name
HOME_LOC_CODE	Home Location Code	String	Home Location Code
HOME_LOC_NAME	Home Location	String	Home Location Name
HOME_OPT_CODE	Home Operating Unit Code	String	Home Operating Unit Code
HOME_OPT_NAME	Home Operating Unit	String	Home Operating Unit Name
LAST_FIRST	Full Name (Last, First)	String	Employee/User Last Name, First Name
OTHER_EMPLY_ID1	Other Employee ID1	String	Employee Other id1 that is mapped to OTHER_EMPLY_ID1 in the employee table
OTHER_EMPLY_ID2	Other Employee ID2	String	Employee Other id2
SSN	SSN	String	Employee Other id that is mapped to SSN field.
VENDOR_ID	Vendor ID	String	Vendor ID
VENDOR_NAME	Vendor	String	Vendor Name
EMPLY_TYPE	Employee Type Code	String	Employee Type ID
EMPLY_TYPE_NAME	Employee Type	String	Employee Type Name
FIRST_LAST	Full Name (First Last)	String	Employee/User First Name Last Name
REPORTING_TYPE	Reporting Type	String	Reporting Period Type
FULL_PART	Full/Part Time	String	Full or Part Time
Clocked In	Clocked In	DateTime	Clocked In Date Time Stamp
ClockedInLatitude	ClockedInLatitude	Decimal/Long	Clocked In Latitude
ClockedInLongitude	ClockedInLongitude	Decimal/Long	Clocked In Longitude
ClockedOut	ClockedOut	DateTime	Clocked Out Date Time Stamp
EnteredBy	EnteredBy	String
EventDate	EventDate	Date	Date of time entered
IPAddressIn	IPAddressIn	String	IP Address of Clock In
IPAddressOut	IPAddressOut	String	IP Address of Clock Out
LineID	LineID	Integer
OutsideArea	OutsideArea	String
PeriodEnd	PeriodEnd	Date	Timesheet Period End Date
Status	Status	String	Timesheet status: On Hold Open Released Closed In Approval Status Rejected Approved
ClockedOutNote	ClockedOutNote	String	Clocked Out Notes Entered
WORK_DEPT_CODE	Worked Department Code	String	Worked Department Code
WORK_DEPT_NAME	Worked Department	String	Worded Department Name
WORK_FUNC_CODE	Worked Function Code	String	Worked Function Code
WORK_FUNC_NAME	Worked Function	String	Worked Function Name
LEVEL1_CODE	Level1 Code	String	WBS Level1 Code
LEVEL1_NAME	Level 1	String	WBS Level1 Name
LEVEL2_CODE	Level2 Code	String	WBS Level2 Code
LEVEL2_NAME	Level 2	String	WBS Level2 Name
LEVEL3_CODE	Level3 Code	String	WBS Level3 Code
LEVEL3_NAME	Level 3	String	WBS Level3 Name
LEVEL4_CODE	Level4 Code	String	WBS Level4 Code
LEVEL4_NAME	Level 4	String	WBS Level4 Name
WORK_LOC_CODE	Worked Location Code	String	Work Location Code
WORK_LOC_NAME	Worked Location	String	Worked Location Name
NOTES	Note	String	Timesheet Notes
WORK_OPT_CODE	Worked Operating Unit Code	String	Worked Operating Unit Code
WORK_OPT_NAME	Worked Operating Unit	String	Worked Operating Unit Name
TC_CODE	Time Code	String	Time Code
TC_NAME	Time Code Name	String	Time Code Name
InternalID	InternalID	Decimal/Long
Hours	Hours	Decimal/Long	Hours