{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 8, "name": "WAJ.wLicenseRenewal", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CREATEWHEN", "creatorField": "CREATEWHO", "editDateField": "UPDATEWHEN", "editorField": "UPDATEWHO" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "CREATEWHO", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CREATEWHO", "type": "esriFieldTypeString", "alias": "إسم مدخل البيانات", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CreateWho" }, { "name": "CREATEWHEN", "type": "esriFieldTypeDate", "alias": "تاريخ الإدخال", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CreateDate" }, { "name": "UPDATEWHO", "type": "esriFieldTypeString", "alias": "إسم أخر محدث للبيانات", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "UpdateWho" }, { "name": "UPDATEWHEN", "type": "esriFieldTypeDate", "alias": "تاريخ التحديث", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "UpdateDate" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "ملاحظات", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Comments" }, { "name": "RENEWSD", "type": "esriFieldTypeDate", "alias": "تاريخ بداية تجديد الترخيص", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RenewSD" }, { "name": "RENEWED", "type": "esriFieldTypeDate", "alias": "تاريخ إنتهاء تجديد الترخيص", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RenewED" }, { "name": "WELLGISID", "type": "esriFieldTypeInteger", "alias": "المفتاح الرئيسي للبئر", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GISID" }, { "name": "APPLICATIONID", "type": "esriFieldTypeInteger", "alias": "رقم الطلب", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ApplicationID" }, { "name": "LICENSENO", "type": "esriFieldTypeInteger", "alias": "رقم الرخصة", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LicenseNo" }, { "name": "LICENSETYPE", "type": "esriFieldTypeInteger", "alias": "نوع الرخصة", "domain": { "type": "codedValue", "name": "LicenseTypeRenewalDomain", "description": "Type of License to be Renewed", "codedValues": [ { "name": "رخصة عمل بئر", "code": 1 }, { "name": "رخصة إستخراج", "code": 3 }, { "name": "إجازة إستخراج", "code": 2 }, { "name": "كتب ومخاطبات", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LicenseType" }, { "name": "SERVICECODE", "type": "esriFieldTypeInteger", "alias": "كود الخدمة", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceCode" }, { "name": "LICPERIOD", "type": "esriFieldTypeInteger", "alias": "مدة الرخصة", "domain": { "type": "codedValue", "name": "wellLicensePeriod", "description": "", "codedValues": [ { "name": "شهر", "code": 1 }, { "name": "ثلاثة شهور", "code": 2 }, { "name": "ستة شهور", "code": 3 }, { "name": "سنة", "code": 4 }, { "name": "ثلاث سنوات", "code": 5 }, { "name": "مدى الحياة", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LICPERIOD" }, { "name": "ISSUEBOOKNO", "type": "esriFieldTypeString", "alias": "ISSUEBOOKNO", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ISSUEBOOKNO" }, { "name": "CLEARANCETYPE", "type": "esriFieldTypeInteger", "alias": "CLEARANCETYPE", "domain": { "type": "codedValue", "name": "WellClearanceTypeDomain", "description": "Clearance Types", "codedValues": [ { "name": "براءة الذمة لوزارة العمل (كتاب براءة الذمة +ربط الكتروني)", "code": 3 }, { "name": "براءة ذمة لغايات الإقراض الزراعي", "code": 4 }, { "name": "براءة ذمة لوزارة الزراعة", "code": 5 }, { "name": "براءة ذمة لدائرة الأراضي والمساحة", "code": 6 }, { "name": "براءة ذمة للجمعية العلمية الملكية", "code": 7 }, { "name": "براءة ذمة لغايات اصدار رخصة استخراج المياه", "code": 1 }, { "name": "براءة ذمة لغايات تجديد رخصة استخراج المياه", "code": 2 }, { "name": "براءة ذمة لغايات اصدار إجازة استخراج", "code": 8 }, { "name": "براءة ذمة لغايات تجديد إجازة استخراج", "code": 9 }, { "name": "براءة ذمة لغاية انجاز معاملة", "code": 10 }, { "name": "ايصال تيار كهربائي", "code": 11 }, { "name": "براءة ذمة لشركات المياه و ادارات المياه", "code": 12 }, { "name": "براءة الذمة", "code": 13 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CLEARANCETYPE" } ], "indexes": [ { "name": "R423_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "WAJ.wLicenseRenewal", "description": "", "prototype": { "attributes": { "ISSUEBOOKNO": null, "CLEARANCETYPE": null, "LICPERIOD": null, "SERVICECODE": null, "LICENSETYPE": null, "LICENSENO": null, "COMMENTS": null, "RENEWSD": null, "RENEWED": null, "WELLGISID": null, "APPLICATIONID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "d91d44a4b66144729ea14b12250ba0fc" }