# Columns can be in any order unless specified.
# Columns are optional unless specified.
# Column names are not case sensitive.
# For text fields, any text is allowed unless specified.
# Column values should be comma separated. Encapsulate in quotes if a comma is needed in the field.
## Punch ##
!Punch (header type identifier, required for header, must be first field)
Punch (row type identifier, required for row, must be first field)
EmployeeId (required)
Timestamp (required)
PunchType (Auto, In, Out, Switch, LunchLeave, LunchReturn, BreakLeave, BreakReturn, NewShift)
PayRate
OT1Rate
OT2Rate
TrackingLevel1
TrackingLevel2
TrackingLevel3
TrackingLevel4
TrackingLevel5
TrackingLevel6
TrackingLevel7
TrackingLevel8
TrackingLevel.'Name of Tracking Level'
Note
## Pto ##
!Pto (header type identifier, required for header, must be first field)
Pto (row type identifier, required for row, must be first field)
EmployeeId (required)
Date (required)
PtoType (required, discriminator or name)
Hours (decimal - 8.5, timespan - 8:30, ISO8601 - PT8H30M)
PayRate
OT1Rate
OT2Rate
TrackingLevel1
TrackingLevel2
TrackingLevel3
TrackingLevel4
TrackingLevel5
TrackingLevel6
TrackingLevel7
TrackingLevel8
TrackingLevel.'Name of Tracking Level'
Note
## Monetary ##
!Monetary (header type identifier, required for header, must be first field)
Monetary (row type identifier, required for row, must be first field)
EmployeeId (required)
Date (required)
MonetaryType (required, discriminator or name)
Amount
TrackingLevel1
TrackingLevel2
TrackingLevel3
TrackingLevel4
TrackingLevel5
TrackingLevel6
TrackingLevel7
TrackingLevel8
TrackingLevel.'Name of Tracking Level'
Note