Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Overview
Provides access to Workbench Timesheet data.
Endpoints
The resources available in this module.
TimesheetListApi
Provides API access to the Daily Desktop Timesheets (#/Timesheets/List.aspx) Web Workbench screen.
/api/TimesheetListApi | ||||
---|---|---|---|---|
Method | Performed As | Request Query | Request Body | Response |
POST | GridRequestParametersApi.IntValue, if specified; otherwise Logged in User. | - |
TimesheetDetailApi
Note: In order to create a Timesheet Line, please use POST with {Workbench.Mvc4.Areas.Api.Controllers.TimesheetDefaultsApiController} TimesheetDefaultsApi.Provides API access to the Daily Timesheet Detail (#/Timesheets/Daily.aspx) Web Workbench screen.
/api/TimesheetDetailApi | |||||||
---|---|---|---|---|---|---|---|
Operation | Logged in User | Parameters | Method | Performed As | Request Query | Request Body | Response |
GET | Admin User | - | |||||
POST |
TimesheetDefaultsApi
[Description]TimesheetApiModel.Form.Key.PersonId | - |
TimesheetDefaultsApi
Provides API access to the default line logic on the Daily Timesheet Detail (#/Timesheets/Daily.aspx) Web Workbench screen.
[Description]/api/TimesheetDefaultsApi | |||||||
---|---|---|---|---|---|---|---|
Operation | Logged in User | Parameters | Method | Performed As | Request Query | Request Body | Response |
GET | jobTranId |
TimesheetAttendanceApi
a given line key. | Admin User | - |
TimesheetAttendanceApi
Provides readonly API access to the Attendance Dialog on the Daily Desktop Timesheets (#/Timesheets/List.aspx) Web Workbench screen.
/api/TimesheetAttendanceApi | |||||||
---|---|---|---|---|---|---|---|
Operation | Logged in User | Parameters | Method | Performed As | Request Query | Request Body | Response |
POST Retrieve the attendance data a specific Timesheet. | Admin User | - | GridRequestParametersApi (IntValue and DateValue are required: they are the Person ID and Timesheet Date of the Timesheet respectively) |
Models
The definitions of models specific to endpoints in this module.
TimesheetKey
Property | Data Type | Description |
---|---|---|
PersonId | Integer | The ID of the Person this Timesheet is for. |
TimesheetDate | DateTime | The Timesheet Date. |
⬆️ Back to top
TimesheetLine
Property | Data Type | Description |
---|---|---|
Key | The unique key for the line. | |
PersonName | The Person this Timesheet if for. | |
TimesheetDate | String | The Timesheet Date, formatted. |
Entered | The total hours entered on the Timesheet. | |
Standard | The number of hours expected on the Timesheet. | |
Variance | The difference between Entered and Standard. | |
Completed | Boolean | The Completed flag on the Timesheet. |
Approved | Boolean | The Approved flag on the Timesheet. |
UpdatedDate | DateTime | The date the Timesheet was last modified. |
⬆️ Back to top
TimesheetApiModel
Property | Data Type | Description | Day1CompleteBoolean | Day2Complete | Boolean | Day3Complete | Boolean | Day4Complete | Boolean | Day5Complete | Boolean | Day6Complete | Boolean | Day7Complete | Boolean | AttendanceFields | Form | Rows | Array [TimesheetsDailyDetailLine] | ReadonlyMessages | Array [Tuple_String] | ValidationErrors | Array [MvcValidationError] | WarningMessage | String | SuccessMessage | String | ErrorMessage | String |
---|
⬆️ Back to top
TimesheetsAttendanceKey
Property
Data Type
Description
Action
String
= ['FirstIn', 'FirstOut', 'SecondIn', 'SecondOut']
PersonId
Integer
Person id.
TimesheetDate
String
Timesheet date.
⬆️ Back to top
TimesheetApiAttendanceFields
Property
Data Type
Description
Rows
GridResult_TimesheetsAttendanceLine
⬆️ Back to top
TimesheetsAttendanceKey
Property
Data Type
Description
Action
String
=['FirstIn', 'FirstOut', 'SecondIn', 'SecondOut']
PersonId
Integer
TimesheetDate
String
⬆️ Back to top
TimesheetsAttendanceLine
Property
Data Type
Description
LineNo
String
Line number.
ShiftNo
String
Shift number.
Shift
String
Shift work.
Day1
Day 1 in the week.
Day2
Day 2 in the week.
Day3
Day 3 in the week.
Day4
Day 4 in the week.
Day5
Day 5 in the week.
Day6
Day 6 in the week.
Day7
Day 7 in the week.
ReadonlyFlag
Integer
Read Only status.
ReadonlyMessage
String
Read Only message.
OriginalKey
CurrentKey
Key
Index
Integer
⬆️ Back to top
TimesheetsDetailDefaultsForm | The general data associated withe the Timesheet. | |
Rows | Array<TimesheetDetailLine> | The Timesheet Lines. |
AttendanceFields.Rows | Array<TimesheetAttendanceLine> | The Timesheet Attendance Lines. |
Day1Complete | Boolean | A flag to indicate if the first day of the Timesheet is complete. |
Day2Complete | Boolean | A flag to indicate if the second day of the Timesheet is complete. |
Day3Complete | Boolean | A flag to indicate if the third day of the Timesheet is complete. |
Day4Complete | Boolean | A flag to indicate if the fourth day of the Timesheet is complete. |
Day5Complete | Boolean | A flag to indicate if the fifth day of the Timesheet is complete. |
Day6Complete | Boolean | A flag to indicate if the sixth day of the Timesheet is complete. |
Day7Complete | Boolean | A flag to indicate if the seventh day of the Timesheet is complete. |
SuccessMessage | String | A message indicating the update was successful. |
WarningMessage | String | A warning message about the Timesheet. |
ValidationErrors | Array<MvcValidationError> | A list of specific validation errors if the save was unsuccessful. |
⬆️ Back to top
TimesheetForm
⬆️ Back to top
TimesheetsDetailDefaultsKey
Property
Data Type
Description
FinCoCode
String
Financial company code.
ActivityCode
Activity code.
ActivityType
String
Activity type.
ActivitySubType
String
Activity sub type.
CostRate
Number
Cost rate.
CostType
String
Cost type.
GstRate
Number
Tax rate.
WorkCentreCode
Work Centre code.
TimeCode
TimesheetDate
String
Timesheet date.
EmployeeClass
String
The unique key for the line. | ||
ApprovalOnHoldField | BoolViewData | The Approval On Hold flag on the Timesheet. |
ApprovedField | BoolViewData | The Approved flag on the Timesheet. |
CompletedField | BoolViewData | The Completed flag on the Timesheet. |
VarianceNotes | StringViewData | The Variance notes on the Timesheet. |
ToilJobBalance | DecimalViewData | The User’s Time Off In Lieu balance. |
⬆️ Back to top
TimesheetsDetailKeyTimesheetDetailKey
Property | Data Type | Description | ||
---|---|---|---|---|
JobTranId | Integer | The unique ID of the Timesheet Line. | ||
PersonId | Integer | The Person idID. | ||
FinCoCode | String | The Financial company codeCompany Code. | ||
JobCode | String | The Job codeCode. | ||
ActivityCode | String | The Activity code Code. | ||
WorkCentreCode | String | The Work Centre code Code. | ||
ActivityType | String | The Activity type Type. | ||
ActivitySubType | String | The Activity sub type Sub Type. | ||
TimeCode | String | The Time codeCode. | ||
CostType | String | Cost type. | ||
CostRate | Number | Cost rate | ||
GstRate | Number | Tax rate. | ||
ProfileId | Integer | User profile id. | ||
StatusFlag | Integer | Status. | ||
TranDate | String | EmployeeClass | String | Employee classThe Cost Type of the Activity and Time Code. |
⬆️ Back to top
TimesheetsDailyDetailLineTimesheetDetailLine
Property | Data Type | Description | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Key | The unique key for the line. | ||||||||||||||
TranDate | String | The transaction date. | |||||||||||||
FinCoCode | String | Code of financial company. | |||||||||||||
FileAttachment | File attachment. | ||||||||||||||
The Financial Company Code on the transaction. | |||||||||||||||
JobCode | The Job codeon the transaction. | ||||||||||||||
Action | The Action on the transaction. | ||||||||||||||
LogHeader | The Log headeron the transaction. | ||||||||||||||
WorkCentreCodeActivityCode | CellDataWork Centre code | The Activity on the transaction. | |||||||||||||
ProfileActivityType | ActivityCode | Activity codeString | The Type of Activity. | ||||||||||||
AllowanceTimeCode | AllowanceThe Time Code on the transaction. | ||||||||||||||
ActivityTypeWorkCentreCode | String | The Work Centre on the transaction. | |||||||||||||
TimeCodeProfile | The Employee Profile on the transaction | ||||||||||||||
StartTime | The Start timeTime on the transaction. | ||||||||||||||
EndTime | The End timeTime on the transaction. | ||||||||||||||
Breaks | The Breaks value on the transaction. | ||||||||||||||
Quantity | Quantity of hoursThe hours Quantity, and Notes, on the transaction. | ||||||||||||||
QuantityOnly | The hours Quantity on the transaction. | ||||||||||||||
NoteOnly | Details | String | Duplicate | Delete | |||||||||||
PlantIssues | Plant issue if applied. | ||||||||||||||
Payroll | JobManagerApproved | Boolean | PlantIssuesCount | Integer | StockIssuesCount | Integer | SourceID | Integer | SourceIDSpecified | Boolean | TimesheetRef1 | TimesheetRef2 | CellDataThe Notes on the transaction. | ||
JobManagerApproved | Boolean | The flag to indicate if the transaction has been approved. | |||||||||||||
PlantIssuesCount | Integer | The number of Plant Issues on the transaction. | |||||||||||||
PlantIssuesData.data | Array<PlantIssueLine> | The Plant Issues on the transaction. | |||||||||||||
StockIssuesCount | Integer | The number of Stock transactions on the transaction. | |||||||||||||
SourceID | Integer | The Source ID on the transaction. | |||||||||||||
SourceIDSpecified | Boolean | The flag to indicate if the transaction has a source. | |||||||||||||
TimesheetRef1 | The TimesheetRef1 details on the transaction. | ||||||||||||||
TimesheetRef2 | The TimesheetRef2 details on the transaction. | ||||||||||||||
EmployeeClass | String | The Employee classClass on the transaction. | |||||||||||||
EmployeeClassValue | The Employee class. | ||||||||||||||
PlantIssuesData | WebGridDataModel_TimesheetsPlantIssueKey | ||||||||||||||
Status | String | Status. | |||||||||||||
ReadonlyFlag | Integer | Read Only status. | |||||||||||||
ReadonlyMessage | String | Read Only message. | |||||||||||||
OriginalKey | CurrentKey | Key | Index | Integer | Class on the transaction. |
⬆️ Back to top
TimesheetsPlantIssueKeyPlantIssueKey
Property | Data Type | Description | |||
---|---|---|---|---|---|
JobTranID | Integer | The unique ID of the Plant Issue. | |||
ItemId | Integer | The ID of the Plant Item id. | |||
JobCode | String | The Job codeCode. | |||
WorkCentreCode | String | The Work Centre code Code. | |||
RateCodeActivityCode | String | Rate codeThe Activity Code. | |||
TranDateRateCode | String | NewRow | String | PlantCodeThe Plant Rate Code. | |
TranDate | String | Plant code | TimeWorkCentreCode | String | The Date of the Plant Issue. |
⬆️ Back to top
TimesheetsPlantIssuesLinePlantIssueLine
Property | Data Type | Description | |||||
---|---|---|---|---|---|---|---|
Key | The unique key for the line. | ||||||
Selected | A flag to indicate the Plant Issue is being edited. | ||||||
PlantCode | The Plant Item on the Plant codeIssue. | ||||||
RateCode | Rate codeThe Plant Rate on the Plant Issue. | ||||||
UnitCode | The Unit codeon the Plant Issue. | ||||||
ActivityCode | The Activity code on the Plant Issue. | ||||||
WorkCentreCode | The Work Centre code on the Plant Issue. | ||||||
DefaultQuantity | The Default Quantity on the Plant Issue. | ||||||
ActualQuantity | The Actual Quantity on the Plant Issue. | ||||||
Note | The Note on the Plant Issue. | ||||||
Delete | |||||||
Status | String | Status. | |||||
ReadonlyFlag | Integer | Read Only status. | |||||
ReadonlyMessage | String | Read Only message. | |||||
OriginalKey | CurrentKey | Key | Index | IntegerA flag to indicate the Plant Issue is being deleted. | |||
Status | String | Either "from-database" if pre-existing, or "generated-line" if pre-populated by default. |
⬆️ Back to top
TimesheetDefaultLineApiModel
Property | Data Type | Description |
---|---|---|
keys | The default values for the Timesheet Line. |
⬆️ Back to top
TimesheetsTimesheetFormResultTimesheetDefaultLine
Property | Data Type | Description |
---|
Key
TimesheetsKey
ApprovalOnHoldField
BoolViewData
ApprovedField
BoolViewData
Value of Approval field.
CompletedField
BoolViewData
Value of Completed field.
NoEditMessage
String
TimesheetDate
String
Timesheet date,
TimesheetNew
Boolean
VarianceNotes
StringViewData
The difference between total and standard hours.
ToilJobBalance
DecimalViewData
FinCoCode | String | The default Financial Company Code. |
ActivityCode | The default Activity. | |
ActivityType | String | The Type of the Activity. |
ActivitySubType | String | The Sub Type of the Activity. |
CostRate | Number | The Cost Rate of the Activity. |
CostType | String | The Cost Type of the Activity. |
GstRate | Number | The GST Rate of the Activity. |
WorkCentreCode | The default Work Centre. | |
TimeCode | The default Time Code. | |
TimesheetDate | String | the default Timesheet Date. |
⬆️ Back to top
WebGridDataModel_TimesheetsPlantIssueKeyAttendanceKey
⬆️ Back to top
Example
V
title | Click to view |
---|
Request
language | json |
---|
Response
language | json |
---|
Response sample
language | json |
---|
Action | String | Must be one of the following: 'FirstIn' (start of first shift), 'FirstOut' (end of first shift), 'SecondIn' (start of second shift), 'SecondOut' (end of second shift). |
PersonId | Integer | The Person ID on the Timesheet. |
TimesheetDate | String | The Timesheet Date. |
⬆️ Back to top
AttendanceLine
Property | Data Type | Description |
---|---|---|
Key | The unique key for the line. | |
LineNo | String | The integer representation of the Action ('0' for ‘FirstIn’, ‘1' for ‘’, ‘2' for ‘SecondIn’, ‘3’ for 'SecondOut’). |
ShiftNo | String | The shift number: either ‘1' for first shift, or '2’ for second shift. |
Shift | String | Either ‘Start’ or ‘End’. |
Day1 | Day 1 Attendance time. | |
Day2 | Day 2 Attendance time. | |
Day3 | Day 3 Attendance time. | |
Day4 | Day 4 Attendance time. | |
Day5 | Day 5 Attendance time. | |
Day6 | Day 6 Attendance time. | |
Day7 | Day 7 Attendance time. |
⬆️ Back to top
Table of Contents | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|