Trimble · Schema
data_crew_timesheets_withKeys
ConstructionTransportationGeospatialGPSMappingBIMFleet ManagementCollaborationAgriculture
Properties
| Name | Type | Description |
|---|---|---|
| __ryvitKeys | array | Array of key paths that can be used to retrieve this object. |
| __modifiedUTC | string | UTC timestamp of when this object was last modified in the cache. |
| PRCo | integer | Payroll company. Parent crews(PRCo, Crew) must exist. |
| Crew | string | Crew identifier. Key to pr/crews(PRCo, Crew). |
| PostDate | string | Sheet post date (bPRRH.PostDate). |
| SheetNum | integer | Sheet number within crew and post date (bPRRH.SheetNum). Sheet 1 holds standard phases from PR Crews. |
| PRGroup | integernull | Payroll group. |
| JCCo | integer | Job Cost company on the sheet header. |
| Job | string | Job on the sheet header. |
| Shift | integer | Shift. |
| PhaseGroup | integer | Phase group. |
| Phase1 | stringnull | |
| Phase1Units | stringnull | Decimal value as string. |
| Phase1CostType | integernull | |
| Phase2 | stringnull | |
| Phase2Units | stringnull | Decimal value as string. |
| Phase2CostType | integernull | |
| Phase3 | stringnull | |
| Phase3Units | stringnull | Decimal value as string. |
| Phase3CostType | integernull | |
| Phase4 | stringnull | |
| Phase4Units | stringnull | Decimal value as string. |
| Phase4CostType | integernull | |
| Phase5 | stringnull | |
| Phase5Units | stringnull | Decimal value as string. |
| Phase5CostType | integernull | |
| Phase6 | stringnull | |
| Phase6Units | stringnull | Decimal value as string. |
| Phase6CostType | integernull | |
| Phase7 | stringnull | |
| Phase7Units | stringnull | Decimal value as string. |
| Phase7CostType | integernull | |
| Phase8 | stringnull | |
| Phase8Units | stringnull | Decimal value as string. |
| Phase8CostType | integernull | |
| CreatedOn | string | Created timestamp. |
| CreatedBy | string | |
| ApprovedBy | stringnull | |
| Status | integer | Timesheet workflow status (bPRRH.Status). 0=Initialized, 1=AwaitingApproval, 2=ReadyToSend, 3=SendInProgress, 4=SendComplete. |
| SendSeq | integernull | |
| PRBatchMth | stringnull | PR batch month when sent. |
| PRBatchId | integernull | PR batch id when sent. |
| Notes | stringnull | |
| UniqueAttchID | stringnull | |
| KeyID | integer | Surrogate KeyID. |
| EmployeeHours | array | Employee Hours tab (PRRE). Present when the sheet has employee hours. |
| EquipmentUsage | array | Equipment Usage tab (PRRQ). Present when the sheet has equipment usage. |
| NonJobEarnings | array | Non-Job Earnings tab (PRRN). Present when the sheet has non-job earnings. |
| OtherJobEarnings | array | Other Job Earnings tab (PRRO). Present when the sheet has other job earnings. |
| __custom_fields | object | This property will be added if there are any custom fields defined for this object in Vista. Each custom field will be a property of this object. |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "https://artifacts.apis.io/trimble/json-schema/trimble-data-crew-timesheets-with-keys-schema.json",
"title": "data_crew_timesheets_withKeys",
"x-generated": "2026-11-11",
"x-method": "derived",
"x-generator": "derive-json-schema.py",
"x-source": "openapi/trimble-vista-pr-openapi.yml#/components/schemas/data_crew_timesheets_withKeys",
"allOf": [
{
"type": "object",
"properties": {
"__ryvitKeys": {
"type": "array",
"items": {
"type": "string"
},
"description": "Array of key paths that can be used to retrieve this object."
},
"__modifiedUTC": {
"type": "string",
"description": "UTC timestamp of when this object was last modified in the cache."
}
}
},
{
"$ref": "#/$defs/data_crew_timesheets"
}
],
"$defs": {
"data_crew_timesheets": {
"required": [
"PRCo",
"Crew",
"PostDate",
"SheetNum",
"JCCo",
"Job",
"Shift",
"PhaseGroup",
"Status",
"KeyID"
],
"type": "object",
"properties": {
"PRCo": {
"type": "integer",
"description": "Payroll company. Parent crews(PRCo, Crew) must exist."
},
"Crew": {
"maxLength": 10,
"type": "string",
"description": "Crew identifier. Key to pr/crews(PRCo, Crew)."
},
"PostDate": {
"type": "string",
"description": "Sheet post date (bPRRH.PostDate).",
"format": "datetime"
},
"SheetNum": {
"type": "integer",
"description": "Sheet number within crew and post date (bPRRH.SheetNum). Sheet 1 holds standard phases from PR Crews."
},
"PRGroup": {
"type": [
"integer",
"null"
],
"description": "Payroll group."
},
"JCCo": {
"type": "integer",
"description": "Job Cost company on the sheet header."
},
"Job": {
"maxLength": 10,
"type": "string",
"description": "Job on the sheet header."
},
"Shift": {
"type": "integer",
"description": "Shift."
},
"PhaseGroup": {
"type": "integer",
"description": "Phase group."
},
"Phase1": {
"maxLength": 20,
"type": [
"string",
"null"
],
"description": ""
},
"Phase1Units": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase1CostType": {
"type": [
"integer",
"null"
],
"description": ""
},
"Phase2": {
"maxLength": 20,
"type": [
"string",
"null"
],
"description": ""
},
"Phase2Units": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase2CostType": {
"type": [
"integer",
"null"
],
"description": ""
},
"Phase3": {
"maxLength": 20,
"type": [
"string",
"null"
],
"description": ""
},
"Phase3Units": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase3CostType": {
"type": [
"integer",
"null"
],
"description": ""
},
"Phase4": {
"maxLength": 20,
"type": [
"string",
"null"
],
"description": ""
},
"Phase4Units": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase4CostType": {
"type": [
"integer",
"null"
],
"description": ""
},
"Phase5": {
"maxLength": 20,
"type": [
"string",
"null"
],
"description": ""
},
"Phase5Units": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase5CostType": {
"type": [
"integer",
"null"
],
"description": ""
},
"Phase6": {
"maxLength": 20,
"type": [
"string",
"null"
],
"description": ""
},
"Phase6Units": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase6CostType": {
"type": [
"integer",
"null"
],
"description": ""
},
"Phase7": {
"maxLength": 20,
"type": [
"string",
"null"
],
"description": ""
},
"Phase7Units": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase7CostType": {
"type": [
"integer",
"null"
],
"description": ""
},
"Phase8": {
"maxLength": 20,
"type": [
"string",
"null"
],
"description": ""
},
"Phase8Units": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase8CostType": {
"type": [
"integer",
"null"
],
"description": ""
},
"CreatedOn": {
"type": "string",
"description": "Created timestamp.",
"format": "datetime"
},
"CreatedBy": {
"maxLength": 128,
"type": "string",
"description": ""
},
"ApprovedBy": {
"maxLength": 128,
"type": [
"string",
"null"
],
"description": ""
},
"Status": {
"maximum": 4,
"minimum": 0,
"type": "integer",
"description": "Timesheet workflow status (bPRRH.Status). 0=Initialized, 1=AwaitingApproval, 2=ReadyToSend, 3=SendInProgress, 4=SendComplete."
},
"SendSeq": {
"type": [
"integer",
"null"
],
"description": ""
},
"PRBatchMth": {
"type": [
"string",
"null"
],
"description": "PR batch month when sent.",
"format": "datetime"
},
"PRBatchId": {
"type": [
"integer",
"null"
],
"description": "PR batch id when sent."
},
"Notes": {
"type": [
"string",
"null"
],
"description": ""
},
"UniqueAttchID": {
"maxLength": 36,
"minLength": 36,
"pattern": "[0-9a-fA-F]{8}\\-[0-9a-fA-F]{4}\\-[0-9a-fA-F]{4}\\-[0-9a-fA-F]{4}\\-[0-9a-fA-F]{12}",
"type": [
"string",
"null"
],
"description": ""
},
"KeyID": {
"type": "integer",
"description": "Surrogate KeyID."
},
"EmployeeHours": {
"type": "array",
"items": {
"required": [
"Employee",
"LineSeq",
"KeyID"
],
"type": "object",
"properties": {
"Employee": {
"type": "integer",
"description": "Employee number."
},
"LineSeq": {
"type": "integer",
"description": "Line sequence within sheet/employee."
},
"Craft": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": ""
},
"Class": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": ""
},
"Phase1RegHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase1OTHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase1DblHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase2RegHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase2OTHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase2DblHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase3RegHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase3OTHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase3DblHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase4RegHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase4OTHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase4DblHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase5RegHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase5OTHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase5DblHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase6RegHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase6OTHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase6DblHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase7RegHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase7OTHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase7DblHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase8RegHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase8OTHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase8DblHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"RegRate": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"OTRate": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"DblRate": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"TotalHrs": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"UniqueAttchID": {
"maxLength": 36,
"minLength": 36,
"pattern": "[0-9a-fA-F]{8}\\-[0-9a-fA-F]{4}\\-[0-9a-fA-F]{4}\\-[0-9a-fA-F]{4}\\-[0-9a-fA-F]{12}",
"type": [
"string",
"null"
],
"description": ""
},
"KeyID": {
"type": "integer",
"description": "Surrogate KeyID."
},
"__custom_fields": {
"type": "object",
"description": "This property will be added if there are any custom fields defined for this object in Vista. Each custom field will be a property of this object."
}
},
"description": "Employee Hours tab row (PRRE)."
},
"description": "Employee Hours tab (PRRE). Present when the sheet has employee hours."
},
"EquipmentUsage": {
"type": "array",
"items": {
"required": [
"EMCo",
"EMGroup",
"Equipment",
"LineSeq",
"KeyID"
],
"type": "object",
"properties": {
"EMCo": {
"type": "integer",
"description": ""
},
"EMGroup": {
"type": "integer",
"description": ""
},
"Equipment": {
"maxLength": 10,
"type": "string",
"description": ""
},
"Employee": {
"type": [
"integer",
"null"
],
"description": "Employee number."
},
"Phase1Usage": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase1CType": {
"type": [
"integer",
"null"
],
"description": ""
},
"Phase1Rev": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": ""
},
"Phase2Usage": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase2CType": {
"type": [
"integer",
"null"
],
"description": ""
},
"Phase2Rev": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": ""
},
"Phase3Usage": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase3CType": {
"type": [
"integer",
"null"
],
"description": ""
},
"Phase3Rev": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": ""
},
"Phase4Usage": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase4CType": {
"type": [
"integer",
"null"
],
"description": ""
},
"Phase4Rev": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": ""
},
"Phase5Usage": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase5CType": {
"type": [
"integer",
"null"
],
"description": ""
},
"Phase5Rev": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": ""
},
"Phase6Usage": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase6CType": {
"type": [
"integer",
"null"
],
"description": ""
},
"Phase6Rev": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": ""
},
"Phase7Usage": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase7CType": {
"type": [
"integer",
"null"
],
"description": ""
},
"Phase7Rev": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": ""
},
"Phase8Usage": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase8CType": {
"type": [
"integer",
"null"
],
"description": ""
},
"Phase8Rev": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": ""
},
"LineSeq": {
"type": "integer",
"description": "Line sequence within sheet/employee."
},
"TotalUsage": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"UniqueAttchID": {
"maxLength": 36,
"minLength": 36,
"pattern": "[0-9a-fA-F]{8}\\-[0-9a-fA-F]{4}\\-[0-9a-fA-F]{4}\\-[0-9a-fA-F]{4}\\-[0-9a-fA-F]{12}",
"type": [
"string",
"null"
],
"description": ""
},
"KeyID": {
"type": "integer",
"description": "Surrogate KeyID."
},
"__custom_fields": {
"type": "object",
"description": "This property will be added if there are any custom fields defined for this object in Vista. Each custom field will be a property of this object."
}
},
"description": "Equipment Usage tab row (PRRQ)."
},
"description": "Equipment Usage tab (PRRQ). Present when the sheet has equipment usage."
},
"NonJobEarnings": {
"type": "array",
"items": {
"required": [
"Employee",
"LineSeq",
"EarnCode",
"Hours",
"StdPayRate",
"KeyID"
],
"type": "object",
"properties": {
"Employee": {
"type": "integer",
"description": "Employee number."
},
"LineSeq": {
"type": "integer",
"description": "Line sequence within sheet/employee."
},
"Craft": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": ""
},
"Class": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": ""
},
"EarnCode": {
"type": "integer",
"description": "Earn code."
},
"Hours": {
"type": "string",
"description": "Decimal value as string."
},
"StdPayRate": {
"maxLength": 1,
"enum": [
"Y",
"N"
],
"type": "string",
"description": "Use standard pay rate (Y/N)."
},
"UniqueAttchID": {
"maxLength": 36,
"minLength": 36,
"pattern": "[0-9a-fA-F]{8}\\-[0-9a-fA-F]{4}\\-[0-9a-fA-F]{4}\\-[0-9a-fA-F]{4}\\-[0-9a-fA-F]{12}",
"type": [
"string",
"null"
],
"description": ""
},
"KeyID": {
"type": "integer",
"description": "Surrogate KeyID."
},
"__custom_fields": {
"type": "object",
"description": "This property will be added if there are any custom fields defined for this object in Vista. Each custom field will be a property of this object."
}
},
"description": "Non-Job Earnings tab row (PRRN)."
},
"description": "Non-Job Earnings tab (PRRN). Present when the sheet has non-job earnings."
},
"OtherJobEarnings": {
"type": "array",
"items": {
"required": [
"Employee",
"LineSeq",
"EarnCode",
"KeyID"
],
"type": "object",
"properties": {
"Employee": {
"type": "integer",
"description": "Employee number."
},
"LineSeq": {
"type": "integer",
"description": "Line sequence within sheet/employee."
},
"Craft": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": ""
},
"Class": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": ""
},
"EarnCode": {
"type": "integer",
"description": "Earn code."
},
"Phase1Value": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase2Value": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase3Value": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase4Value": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase5Value": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase6Value": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase7Value": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"Phase8Value": {
"type": [
"string",
"null"
],
"description": "Decimal value as string."
},
"UniqueAttchID": {
"maxLength": 36,
"minLength": 36,
"pattern": "[0-9a-fA-F]{8}\\-[0-9a-fA-F]{4}\\-[0-9a-fA-F]{4}\\-[0-9a-fA-F]{4}\\-[0-9a-fA-F]{12}",
"type": [
"string",
"null"
],
"description": ""
},
"KeyID": {
"type": "integer",
"description": "Surrogate KeyID."
},
"__custom_fields": {
"type": "object",
"description": "This property will be added if there are any custom fields defined for this object in Vista. Each custom field will be a property of this object."
}
},
"description": "Other Job Earnings tab row (PRRO). Phase values are hours/amounts against header phases."
},
"description": "Other Job Earnings tab (PRRO). Present when the sheet has other job earnings."
},
"__custom_fields": {
"type": "object",
"description": "This property will be added if there are any custom fields defined for this object in Vista. Each custom field will be a property of this object."
}
}
}
}
}
Work with this as data
Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for schemas
4 MCP tools reach this
find_json_schemasBrowse and filter every JSON Schema in the catalog.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/trimble-data-crew-timesheets-with-keys"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"
Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.