{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 15, "name": "Site_Assessment_Reports", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 4, "name": "LARA_SDE.LARA_ADMIN.reports", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "reportid", "composite": false, "catalogID": "{8903ADF1-C86A-4D4D-8FC2-A57E316B36A0}" } ], "isDataVersioned": false, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1722273024000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "facility_no", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "facility_no", "type": "esriFieldTypeString", "alias": "Facility No", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "facility_no" }, { "name": "tank_no", "type": "esriFieldTypeString", "alias": "Tank No.", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "tank_no" }, { "name": "sketchscale", "type": "esriFieldTypeString", "alias": "Sketch Scale", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "sketchscale" }, { "name": "sampleid", "type": "esriFieldTypeString", "alias": "Sample ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "sampleid" }, { "name": "sampledepth", "type": "esriFieldTypeString", "alias": "Sample Depth", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "sampledepth" }, { "name": "sampledepthuom", "type": "esriFieldTypeString", "alias": "Unit of measure", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "sampledepthuom" }, { "name": "samplecollectiondt", "type": "esriFieldTypeDate", "alias": "Sample Collected On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "samplecollectiondt" }, { "name": "samplesubmitteddt", "type": "esriFieldTypeDate", "alias": "Sample Submitted On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "samplesubmitteddt" }, { "name": "sampleholdingtime", "type": "esriFieldTypeSmallInteger", "alias": "Holding Time", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "sampleholdingtime" }, { "name": "samplepreparationdt", "type": "esriFieldTypeDate", "alias": "Sample Preparation Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "samplepreparationdt" }, { "name": "sampleanalyzeddt", "type": "esriFieldTypeDate", "alias": "Sample Analyzed Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "sampleanalyzeddt" }, { "name": "methodology", "type": "esriFieldTypeString", "alias": "Test Methodology", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "methodology" }, { "name": "units", "type": "esriFieldTypeString", "alias": "Units", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "units" }, { "name": "exceedsmdls", "type": "esriFieldTypeString", "alias": "> MDLs", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "exceedsmdls" }, { "name": "preservationmthd", "type": "esriFieldTypeString", "alias": "Preservation Method", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "preservationmthd" }, { "name": "sampleshippedonice", "type": "esriFieldTypeString", "alias": "Samples Shipped on Ice", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "sampleshippedonice" }, { "name": "photosreviewed", "type": "esriFieldTypeString", "alias": "Photos Reviewed", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "photosreviewed" }, { "name": "haulingmanifestreviewed", "type": "esriFieldTypeString", "alias": "Hauling Manifests Reviewed", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "haulingmanifestreviewed" }, { "name": "registrationreviewed", "type": "esriFieldTypeString", "alias": "Registration Form Reviewed", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "registrationreviewed" }, { "name": "reportreviewed", "type": "esriFieldTypeString", "alias": "HMSI Report Reviewed", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "reportreviewed" }, { "name": "determination", "type": "esriFieldTypeString", "alias": "Determination", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "determination" }, { "name": "notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "notes" }, { "name": "recieveddt", "type": "esriFieldTypeDate", "alias": "Received On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "recieveddt" }, { "name": "workerid", "type": "esriFieldTypeGUID", "alias": "Worker ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "workerid" }, { "name": "releaseid", "type": "esriFieldTypeGUID", "alias": "Release Report ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "releaseid" }, { "name": "tankid", "type": "esriFieldTypeGUID", "alias": "Tank ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "tankid" }, { "name": "facilityid", "type": "esriFieldTypeGUID", "alias": "Facility ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "facilityid" }, { "name": "closure_removalid", "type": "esriFieldTypeGUID", "alias": "Closure/Removal Report ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "closure_removalid" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "reporttype", "type": "esriFieldTypeString", "alias": "Report Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "reporttype" }, { "name": "reportid", "type": "esriFieldTypeGUID", "alias": "Report ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "reportid" }, { "name": "report_no", "type": "esriFieldTypeString", "alias": "Report No.", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "report_no" }, { "name": "systemid", "type": "esriFieldTypeGUID", "alias": "System ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "systemid" }, { "name": "last_use_date", "type": "esriFieldTypeDate", "alias": "Last Date Used", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_use_date" }, { "name": "close_fill", "type": "esriFieldTypeString", "alias": "Closure Fill", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "close_fill" }, { "name": "change_service_date", "type": "esriFieldTypeDate", "alias": "Date Service Changed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "change_service_date" }, { "name": "associated_reportid", "type": "esriFieldTypeString", "alias": "Associated Report ID", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "associated_reportid" }, { "name": "removed_from_ground", "type": "esriFieldTypeString", "alias": "Removed From Ground", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "removed_from_ground" }, { "name": "date_closed", "type": "esriFieldTypeDate", "alias": "Date Closed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "date_closed" }, { "name": "accela_ref_id", "type": "esriFieldTypeString", "alias": "Accela Ref ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "accela_ref_id" }, { "name": "parentglobalid", "type": "esriFieldTypeGUID", "alias": "Activity ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "parentglobalid" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" } ], "indexes": [ { "name": "UUID_496", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G11754reportid", "fields": "reportid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_496", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_SITEASSESSMENTREPORTS_associated_reportid", "fields": "associated_reportid,created_date,date_closed,determination", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_SITEASSESSMENTREPORTS_created_date", "fields": "created_date,associated_reportid,date_closed,determination", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_SITEASSESSMENTREPORTS_date_closed", "fields": "date_closed,associated_reportid,created_date,determination", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_SITEASSESSMENTREPORTS_last_use_date", "fields": "last_use_date,associated_reportid,created_date,date_closed", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_SITEASSESSMENTREPORTS_reportid", "fields": "reportid,associated_reportid,created_date,date_closed", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_SITEASSESSMENTREPORTS_reporttype", "fields": "reporttype,associated_reportid,created_date,date_closed", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_SITEASSESSMENTREPORTS_tank_no", "fields": "tank_no,associated_reportid,created_date,date_closed", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Site_Assessment_Reports", "description": "", "prototype": { "attributes": { "parentglobalid": null, "facility_no": null, "tank_no": null, "sketchscale": null, "sampleid": null, "sampledepth": null, "sampledepthuom": null, "samplecollectiondt": null, "samplesubmitteddt": null, "sampleholdingtime": null, "samplepreparationdt": null, "sampleanalyzeddt": null, "methodology": null, "units": null, "exceedsmdls": null, "preservationmthd": null, "sampleshippedonice": null, "photosreviewed": null, "haulingmanifestreviewed": null, "registrationreviewed": null, "reportreviewed": null, "determination": null, "notes": null, "recieveddt": null, "workerid": null, "releaseid": null, "tankid": null, "facilityid": null, "closure_removalid": null, "date_closed": null, "removed_from_ground": null, "associated_reportid": null, "change_service_date": null, "accela_ref_id": null, "reporttype": null, "reportid": null, "report_no": null, "systemid": null, "last_use_date": null, "close_fill": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Create,Update,Uploads,Editing,ChangeTracking", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }