Trimble · Schema
data_automatic_earnings_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 ID |
| Employee | integer | Employee ID |
| EarnCode | integer | Earning or Deduction Code |
| Seq | integer | Sequence |
| PaySeq | integernull | Pay Sequence |
| PRDept | stringnull | Payroll Department |
| InsCode | stringnull | Insurance Code |
| Craft | stringnull | Craft |
| Class | stringnull | Class |
| JCCo | integernull | Job Cost Company ID |
| Job | stringnull | Job ID |
| PhaseGroup | integernull | Phase Group |
| Phase | stringnull | Phase |
| GLCo | integernull | GL Company ID |
| EMCo | integernull | Equipment Management Company ID |
| Equipment | stringnull | Equipment ID |
| EMGroup | integernull | Equipment Management Group |
| RevCode | stringnull | Revenue Code |
| UsageUnits | stringnull | Usage Units |
| StdHours | string | Standard Hours Flag |
| Hours | stringnull | Hours |
| RateAmt | string | Rate Amount |
| LimitOvrAmt | string | Limit Override Amount |
| Frequency | string | Frequency |
| Notes | stringnull | Notes |
| OvrStdLimitYN | string | Override Standard Limit Y/N |
| UniqueAttchID | stringnull | Unique Attachment ID |
| MechanicsCC | stringnull | Mechanics Cost Code |
| EquipMechOpt | string | Equipment Mechanic Option |
| KeyID | integer | Key ID - likely a surrogate key |
| UseRegRate | string | Use Regular Rate Y/N |
| __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-automatic-earnings-with-keys-schema.json",
"title": "data_automatic_earnings_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_automatic_earnings_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_automatic_earnings"
}
],
"$defs": {
"data_automatic_earnings": {
"title": "Automatic Earnings Cache Record Schema",
"required": [
"PRCo",
"Employee",
"EarnCode",
"Seq",
"StdHours",
"RateAmt",
"LimitOvrAmt",
"Frequency",
"OvrStdLimitYN",
"EquipMechOpt",
"KeyID",
"UseRegRate"
],
"type": "object",
"properties": {
"PRCo": {
"maximum": 255,
"minimum": 0,
"type": "integer",
"description": "Payroll Company ID"
},
"Employee": {
"type": "integer",
"description": "Employee ID"
},
"EarnCode": {
"type": "integer",
"description": "Earning or Deduction Code"
},
"Seq": {
"maximum": 255,
"minimum": 0,
"type": "integer",
"description": "Sequence"
},
"PaySeq": {
"maximum": 255,
"minimum": 0,
"type": [
"integer",
"null"
],
"description": "Pay Sequence"
},
"PRDept": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": "Payroll Department"
},
"InsCode": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": "Insurance Code"
},
"Craft": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": "Craft"
},
"Class": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": "Class"
},
"JCCo": {
"maximum": 255,
"minimum": 0,
"type": [
"integer",
"null"
],
"description": "Job Cost Company ID"
},
"Job": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": "Job ID"
},
"PhaseGroup": {
"maximum": 255,
"minimum": 0,
"type": [
"integer",
"null"
],
"description": "Phase Group"
},
"Phase": {
"maxLength": 20,
"type": [
"string",
"null"
],
"description": "Phase"
},
"GLCo": {
"maximum": 255,
"minimum": 0,
"type": [
"integer",
"null"
],
"description": "GL Company ID"
},
"EMCo": {
"maximum": 255,
"minimum": 0,
"type": [
"integer",
"null"
],
"description": "Equipment Management Company ID"
},
"Equipment": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": "Equipment ID"
},
"EMGroup": {
"maximum": 255,
"minimum": 0,
"type": [
"integer",
"null"
],
"description": "Equipment Management Group"
},
"RevCode": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": "Revenue Code"
},
"UsageUnits": {
"pattern": "^[-+]?[0-9]{1,8}(?:.[0-9]{0,2})?$",
"type": [
"string",
"null"
],
"description": "Usage Units"
},
"StdHours": {
"enum": [
"Y",
"N"
],
"type": "string",
"description": "Standard Hours Flag"
},
"Hours": {
"pattern": "^[-+]?[0-9]{1,8}(?:.[0-9]{0,2})?$",
"type": [
"string",
"null"
],
"description": "Hours"
},
"RateAmt": {
"pattern": "^[-+]?[0-9]{1,11}(?:.[0-9]{0,5})?$",
"type": "string",
"description": "Rate Amount"
},
"LimitOvrAmt": {
"pattern": "^[-+]?[0-9]{1,10}(?:.[0-9]{0,2})?$",
"type": "string",
"description": "Limit Override Amount"
},
"Frequency": {
"maxLength": 10,
"type": "string",
"description": "Frequency"
},
"Notes": {
"type": [
"string",
"null"
],
"description": "Notes"
},
"OvrStdLimitYN": {
"enum": [
"Y",
"N"
],
"type": "string",
"description": "Override Standard Limit 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": "Unique Attachment ID"
},
"MechanicsCC": {
"maxLength": 10,
"type": [
"string",
"null"
],
"description": "Mechanics Cost Code"
},
"EquipMechOpt": {
"maxLength": 1,
"type": "string",
"description": "Equipment Mechanic Option"
},
"KeyID": {
"type": "integer",
"description": "Key ID - likely a surrogate key"
},
"UseRegRate": {
"enum": [
"Y",
"N"
],
"type": "string",
"description": "Use Regular Rate Y/N"
},
"__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": "Schema for a single record from the dbo.PRAE table, intended for cache validation."
}
}
}
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-automatic-earnings-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.