{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 12, "name": "WAJ.wClearanceInfo", "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": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "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": "WELLGISID", "type": "esriFieldTypeInteger", "alias": "المفتاح الرئيسي للبئر", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WellGISID" }, { "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": "WELLCODE", "type": "esriFieldTypeString", "alias": "رمز البئر", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "WellCode" }, { "name": "NOCONSUMPTIONBILLS", "type": "esriFieldTypeInteger", "alias": "لا يوجد أثمان مياه مترصدة", "domain": { "type": "codedValue", "name": "YesNoLongInt", "description": "", "codedValues": [ { "name": "نعم", "code": 1 }, { "name": "لا", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 2, "modelName": "NoConsumptionBills" }, { "name": "NOVIOLATEDWELLS", "type": "esriFieldTypeInteger", "alias": "لا يوجد ابار مخالفة", "domain": { "type": "codedValue", "name": "YesNoLongInt", "description": "", "codedValues": [ { "name": "نعم", "code": 1 }, { "name": "لا", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 2, "modelName": "NoViolatedWells" }, { "name": "NOVIOLATIONS", "type": "esriFieldTypeInteger", "alias": "لا يوجد مخالفات", "domain": { "type": "codedValue", "name": "YesNoLongInt", "description": "", "codedValues": [ { "name": "نعم", "code": 1 }, { "name": "لا", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 2, "modelName": "NoViolations" }, { "name": "NOFINANCIALCOMMITMENTS", "type": "esriFieldTypeInteger", "alias": "لا يوجد التزامات مالية", "domain": { "type": "codedValue", "name": "YesNoLongInt", "description": "", "codedValues": [ { "name": "نعم", "code": 1 }, { "name": "لا", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 2, "modelName": "NoFinancialCommitments" }, { "name": "NOINSTALLMENTS", "type": "esriFieldTypeInteger", "alias": "لا يوجد تقسيط", "domain": { "type": "codedValue", "name": "YesNoLongInt", "description": "", "codedValues": [ { "name": "نعم", "code": 1 }, { "name": "لا", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 2, "modelName": "NoInstallments" }, { "name": "OWNERID", "type": "esriFieldTypeInteger", "alias": "رمز المالك", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OwnerID" }, { "name": "PARTNERINOTHERWELL", "type": "esriFieldTypeInteger", "alias": "هل المالك شريك في بئر اخر", "domain": { "type": "codedValue", "name": "YesNoLongInt", "description": "", "codedValues": [ { "name": "نعم", "code": 1 }, { "name": "لا", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 2, "modelName": "PartnerinOtherWell" }, { "name": "ABSTRACTFEESPAID", "type": "esriFieldTypeInteger", "alias": "رسوم رخص الاستخراج مدفوعة", "domain": { "type": "codedValue", "name": "YesNoLongInt", "description": "", "codedValues": [ { "name": "نعم", "code": 1 }, { "name": "لا", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AbstractFeesPaid" }, { "name": "CLEARANCETYPE", "type": "esriFieldTypeInteger", "alias": "نوع براءة الذمة", "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" }, { "name": "CLEARANCEDATE", "type": "esriFieldTypeDate", "alias": "تاريخ بداية العمل", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ClearanceDate" }, { "name": "ISCLEARED", "type": "esriFieldTypeInteger", "alias": "هل هو بريء الذمة", "domain": { "type": "codedValue", "name": "YesNoLongInt", "description": "", "codedValues": [ { "name": "نعم", "code": 1 }, { "name": "لا", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsCleared" }, { "name": "OWNERNME", "type": "esriFieldTypeString", "alias": "اسم المالك", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OwnerNME" }, { "name": "CLEARANCELETTERNO", "type": "esriFieldTypeString", "alias": "رقم كتاب براءة الذمة", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ClearanceLetterNo" }, { "name": "CLEARANCELETTERDATE", "type": "esriFieldTypeDate", "alias": "تاريخ كتاب براءة الذمة", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ClearanceLetterDate" }, { "name": "NOBILLSCOMMENT", "type": "esriFieldTypeString", "alias": "أثمان مياه مترصدة - شروحات", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "NOBILLSCOMMENT" }, { "name": "NOVIOLATEDWELLSCOMMENT", "type": "esriFieldTypeString", "alias": "ابار مخالفة - شروحات", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "NOVIOLATEDWELLSCOMMENT" }, { "name": "NOVIOLATIONSCOMMENT", "type": "esriFieldTypeString", "alias": "ضبوطات - شروحات", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "NOVIOLATIONSCOMMENT" }, { "name": "NOFINANCIALCOMMENT", "type": "esriFieldTypeString", "alias": "التزامات مالية - شروحات", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "NOFINANCIALCOMMENT" }, { "name": "NOINSTALLMENTSCOMMENT", "type": "esriFieldTypeString", "alias": "تقسيط - شروحات", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "NOINSTALLMENTSCOMMENT" }, { "name": "NOMETERSCOST", "type": "esriFieldTypeInteger", "alias": "لا يوجد أثمان عدادات", "domain": { "type": "codedValue", "name": "YesNoLongInt", "description": "", "codedValues": [ { "name": "نعم", "code": 1 }, { "name": "لا", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NOMETERSCOST" }, { "name": "NOMETERSCOSTCOMMENT", "type": "esriFieldTypeString", "alias": "أثمان عدادات - شروحات", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "NOMETERSCOSTCOMMENT" }, { "name": "SERVICECODE", "type": "esriFieldTypeInteger", "alias": "كود الخدمة", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SERVICECODE" }, { "name": "CLEARANCEDATE_EXPIRE", "type": "esriFieldTypeDate", "alias": "CLEARANCEDATE_EXPIRE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CLEARANCEDATE_EXPIRE" }, { "name": "STATUS", "type": "esriFieldTypeSmallInteger", "alias": "STATUS", "domain": { "type": "codedValue", "name": "STATUS_CleatanceInfo", "description": "", "codedValues": [ { "name": "بريء الذمة", "code": 0 }, { "name": "غير بريء الذمة", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STATUS" }, { "name": "EXPIRATIONDATE", "type": "esriFieldTypeDate", "alias": "ExpirationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ExpirationDate" }, { "name": "CLEARAMCEDATE", "type": "esriFieldTypeDate", "alias": "ClearamceDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ClearamceDate" } ], "indexes": [ { "name": "APPLICATIONID", "fields": "APPLICATIONID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R419_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "WAJ.wClearanceInfo", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Uploads,Editing,Extract", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "b2a01ab60feb48808403b9bc8b619be1" }