{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 0, "name": "XTREME_DTE.Timesheet", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 168, 69, 53, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -9247548.8666, "ymin": 0, "xmax": 0, "ymax": 5464578.383299999, "zmin": 0, "zmax": 334.5301000000036, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "work_date", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "minute_log_required", "type": "esriFieldTypeString", "alias": "Crew Member Minutes", "length": 255, "domain": null }, { "name": "crew_number", "type": "esriFieldTypeString", "alias": "Crew Number", "length": 255, "domain": null }, { "name": "yard", "type": "esriFieldTypeString", "alias": "Yard", "length": 255, "domain": { "type": "codedValue", "name": "yard_list", "description": "", "codedValues": [ { "name": "ARM", "code": "ARM" }, { "name": "CAN", "code": "CAN" }, { "name": "MAR", "code": "MAR" }, { "name": "MTC", "code": "MTC" }, { "name": "VAN", "code": "VAN" }, { "name": "WAR", "code": "WAR" }, { "name": "WWS", "code": "WWS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "work_date", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 1000, "domain": null }, { "name": "day_of_week", "type": "esriFieldTypeString", "alias": "Day", "length": 10, "domain": null }, { "name": "job_info_html_rows", "type": "esriFieldTypeString", "alias": "job_info_html_rows", "length": 2000, "domain": null }, { "name": "day_breakdown_html_rows", "type": "esriFieldTypeString", "alias": "day_breakdown_html_rows", "length": 255, "domain": null }, { "name": "day_breakdown_html_table", "type": "esriFieldTypeString", "alias": "Day Breakdown", "length": 255, "domain": null }, { "name": "cmm_html_rows", "type": "esriFieldTypeString", "alias": "cmm_html_rows", "length": 2000, "domain": null }, { "name": "cmm_html_table", "type": "esriFieldTypeString", "alias": "cmm_html_table", "length": 2000, "domain": null }, { "name": "crew_foreman_date", "type": "esriFieldTypeDate", "alias": "Crew Foreman Date", "length": 8, "domain": null }, { "name": "sign_off_date", "type": "esriFieldTypeDate", "alias": "Sign Off Date", "length": 8, "domain": null }, { "name": "job_info_html_table_summary", "type": "esriFieldTypeString", "alias": "Job Info", "length": 255, "domain": null }, { "name": "employee_html_table_summary", "type": "esriFieldTypeString", "alias": "Employee Hours", "length": 255, "domain": null }, { "name": "day_breakdown_html_table_sum", "type": "esriFieldTypeString", "alias": "Day Breakdown", "length": 255, "domain": null }, { "name": "xpc_rep_summary", "type": "esriFieldTypeString", "alias": "XPC Representative", "length": 255, "domain": null }, { "name": "dte_rep_summary", "type": "esriFieldTypeString", "alias": "Utility Representative", "length": 255, "domain": null }, { "name": "sign_off_date_summary", "type": "esriFieldTypeString", "alias": "Date", "length": 255, "domain": null }, { "name": "survey_review", "type": "esriFieldTypeString", "alias": "Summary Reviewed", "length": 255, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "employee_html_rows", "type": "esriFieldTypeString", "alias": "employee_html_rows", "length": 2000, "domain": null }, { "name": "employee_html_table", "type": "esriFieldTypeString", "alias": "employee_html_table", "length": 2000, "domain": null }, { "name": "exported", "type": "esriFieldTypeString", "alias": "Exported", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes / No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "exported_date", "type": "esriFieldTypeDate", "alias": "Exported Date", "length": 8, "domain": null }, { "name": "approved", "type": "esriFieldTypeString", "alias": "Approved", "length": 255, "domain": { "type": "codedValue", "name": "Approval", "description": "", "codedValues": [ { "name": "Not Approved", "code": "Not Approved" }, { "name": "Approved", "code": "Approved" }, { "name": "Rejected", "code": "Rejected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "approved_by", "type": "esriFieldTypeString", "alias": "Approved By", "length": 255, "domain": null }, { "name": "approved_date", "type": "esriFieldTypeDate", "alias": "Approved Date", "length": 8, "domain": null }, { "name": "cmm_table_summary", "type": "esriFieldTypeString", "alias": "Crew Member Minutes", "length": 255, "domain": null }, { "name": "equip_html_rows", "type": "esriFieldTypeString", "alias": "equip_html_rows", "length": 255, "domain": null }, { "name": "equip_html_table", "type": "esriFieldTypeString", "alias": "equip_html_table", "length": 255, "domain": null }, { "name": "equip_html_table_summary", "type": "esriFieldTypeString", "alias": "Equipment Hours", "length": 255, "domain": null }, { "name": "job_info_html_table", "type": "esriFieldTypeString", "alias": "job_info_html_table", "length": 255, "domain": null }, { "name": "submitted_by", "type": "esriFieldTypeString", "alias": "Submitted By", "length": 255, "domain": null }, { "name": "billing_review", "type": "esriFieldTypeString", "alias": "Billing Review", "length": 255, "domain": { "type": "codedValue", "name": "Approval", "description": "", "codedValues": [ { "name": "Not Approved", "code": "Not Approved" }, { "name": "Approved", "code": "Approved" }, { "name": "Rejected", "code": "Rejected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "billing_review_by", "type": "esriFieldTypeString", "alias": "Billing Review By", "length": 255, "domain": null }, { "name": "billing_review_date", "type": "esriFieldTypeDate", "alias": "Billing Review Date", "length": 8, "domain": null }, { "name": "exported_by", "type": "esriFieldTypeString", "alias": "Exported By", "length": 255, "domain": null }, { "name": "bill_exported", "type": "esriFieldTypeString", "alias": "Bill Exported", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes / No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "bill_exported_date", "type": "esriFieldTypeDate", "alias": "Bill Exported Date", "length": 8, "domain": null }, { "name": "bill_exported_by", "type": "esriFieldTypeString", "alias": "Bill Exported By", "length": 255, "domain": null }, { "name": "equip_exported", "type": "esriFieldTypeString", "alias": "Equip Exported", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes / No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "equip_exported_date", "type": "esriFieldTypeDate", "alias": "Equip Exported Date", "length": 8, "domain": null }, { "name": "equip_exported_by", "type": "esriFieldTypeString", "alias": "Equip Exported By", "length": 255, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "UUID_61", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_61", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S19_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "XTREME_DTE.job_info", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{2837A1C2-C669-4361-9E06-5BC5180EAE4C}" }, { "id": 0, "name": "XTREME_DTE.employee_hours", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{385BB42E-4B63-4C4B-B11C-7497EDDBBB26}" }, { "id": 2, "name": "XTREME_DTE.minute_daily_log", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{05AA7CC2-22F9-4819-93FA-AC05623DAD0E}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "maxSelectionCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1752770563000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "3a716ccf2cee4b08992ff08be0d2f3b1" }