{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 4,
"name": "Crews View",
"type": "Table",
"description": null,
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "title",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "activity",
"type": "esriFieldTypeString",
"alias": "activity",
"length": 60000,
"domain": null
},
{
"name": "asset_id",
"type": "esriFieldTypeInteger",
"alias": "asset_id",
"domain": null
},
{
"name": "business_unit",
"type": "esriFieldTypeString",
"alias": "business_unit",
"length": 60000,
"domain": null
},
{
"name": "computed_status",
"type": "esriFieldTypeString",
"alias": "computed_status",
"length": 60000,
"domain": null
},
{
"name": "crew_id",
"type": "esriFieldTypeInteger",
"alias": "crew_id",
"domain": null
},
{
"name": "crew_people_id",
"type": "esriFieldTypeOID",
"alias": "crew_people_id",
"domain": null
},
{
"name": "crew_subtype",
"type": "esriFieldTypeString",
"alias": "crew_subtype",
"length": 60000,
"domain": null
},
{
"name": "crew_type",
"type": "esriFieldTypeString",
"alias": "crew_type",
"length": 60000,
"domain": null
},
{
"name": "department",
"type": "esriFieldTypeString",
"alias": "department",
"length": 60000,
"domain": null
},
{
"name": "division",
"type": "esriFieldTypeString",
"alias": "division",
"length": 60000,
"domain": null
},
{
"name": "employee_id",
"type": "esriFieldTypeString",
"alias": "employee_id",
"length": 60000,
"domain": null
},
{
"name": "employee_status",
"type": "esriFieldTypeString",
"alias": "employee_status",
"length": 60000,
"domain": null
},
{
"name": "end_datetime",
"type": "esriFieldTypeDate",
"alias": "end_datetime",
"length": 8,
"domain": null
},
{
"name": "external_id",
"type": "esriFieldTypeString",
"alias": "external_id",
"length": 60000,
"domain": null
},
{
"name": "first_name",
"type": "esriFieldTypeString",
"alias": "first_name",
"length": 60000,
"domain": null
},
{
"name": "full_time_equivalent",
"type": "esriFieldTypeSingle",
"alias": "full_time_equivalent",
"domain": null
},
{
"name": "hours",
"type": "esriFieldTypeInteger",
"alias": "hours",
"domain": null
},
{
"name": "inserted_at",
"type": "esriFieldTypeDate",
"alias": "inserted_at",
"length": 8,
"domain": null
},
{
"name": "last_name",
"type": "esriFieldTypeString",
"alias": "last_name",
"length": 60000,
"domain": null
},
{
"name": "last_synced_from_trakster_at",
"type": "esriFieldTypeDate",
"alias": "last_synced_from_trakster_at",
"length": 8,
"domain": null
},
{
"name": "organization_id",
"type": "esriFieldTypeSmallInteger",
"alias": "organization_id",
"domain": null
},
{
"name": "overtime_equivalent",
"type": "esriFieldTypeSingle",
"alias": "overtime_equivalent",
"domain": null
},
{
"name": "overtime_hours",
"type": "esriFieldTypeInteger",
"alias": "overtime_hours",
"domain": null
},
{
"name": "person_id",
"type": "esriFieldTypeInteger",
"alias": "person_id",
"domain": null
},
{
"name": "phone",
"type": "esriFieldTypeString",
"alias": "phone",
"length": 60000,
"domain": null
},
{
"name": "section",
"type": "esriFieldTypeString",
"alias": "section",
"length": 60000,
"domain": null
},
{
"name": "source_app_id",
"type": "esriFieldTypeSmallInteger",
"alias": "source_app_id",
"domain": null
},
{
"name": "start_datetime",
"type": "esriFieldTypeDate",
"alias": "start_datetime",
"length": 8,
"domain": null
},
{
"name": "status",
"type": "esriFieldTypeString",
"alias": "status",
"length": 60000,
"domain": null
},
{
"name": "status_category",
"type": "esriFieldTypeString",
"alias": "status_category",
"length": 60000,
"domain": null
},
{
"name": "title",
"type": "esriFieldTypeString",
"alias": "title",
"length": 60000,
"domain": null
},
{
"name": "total_hours",
"type": "esriFieldTypeInteger",
"alias": "total_hours",
"domain": null
},
{
"name": "updated_at",
"type": "esriFieldTypeDate",
"alias": "updated_at",
"length": 8,
"domain": null
},
{
"name": "license_plate",
"type": "esriFieldTypeString",
"alias": "license_plate",
"length": 60000,
"domain": null
},
{
"name": "faster_id",
"type": "esriFieldTypeString",
"alias": "faster_id",
"length": 60000,
"domain": null
}
],
"indexes": null,
"subtypes": [],
"relationships": [],
"capabilities": "Data,Map,Query",
"maxRecordCount": 1000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, PBF",
"isDataVersioned": false,
"useStandardizedQueries": true,
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsPagination": true,
"supportsTrueCurve": false,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsSqlFormat": false,
"supportsQueryAnalytic": true,
"supportsCurrentUserQueries": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": false
},
"dateFieldsTimeReference": null,
"preferredTimeReference": null,
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
}
}