{ "layers": [ { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 0, "name": "Count of login", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 104, 127, 45, 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": 5332477.148816562, "ymin": 3317227.51457659, "xmax": 5387892.75943794, "ymax": 3425334.14491903, "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": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "english_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "customer_number", "type": "esriFieldTypeInteger", "alias": "customer_number", "domain": null }, { "name": "account_manager", "type": "esriFieldTypeString", "alias": "account_manager", "length": 1073741822, "domain": null }, { "name": "client", "type": "esriFieldTypeString", "alias": "client", "length": 1073741822, "domain": null }, { "name": "product_type", "type": "esriFieldTypeString", "alias": "product_type", "length": 1073741822, "domain": null }, { "name": "english_name", "type": "esriFieldTypeString", "alias": "english_name", "length": 1073741822, "domain": null }, { "name": "license_start", "type": "esriFieldTypeDateOnly", "alias": "license_start", "domain": null }, { "name": "license_end", "type": "esriFieldTypeDateOnly", "alias": "license_end", "domain": null }, { "name": "arabic_name", "type": "esriFieldTypeString", "alias": "arabic_name", "length": 1073741822, "domain": null }, { "name": "link", "type": "esriFieldTypeString", "alias": "link", "length": 1073741822, "domain": null }, { "name": "opportunity", "type": "esriFieldTypeString", "alias": "opportunity", "length": 1073741822, "domain": null }, { "name": "status", "type": "esriFieldTypeString", "alias": "status", "length": 1073741822, "domain": null }, { "name": "x", "type": "esriFieldTypeDouble", "alias": "x", "domain": null }, { "name": "y", "type": "esriFieldTypeDouble", "alias": "y", "domain": null }, { "name": "license_status", "type": "esriFieldTypeString", "alias": "license_status", "length": 1073741822, "domain": null }, { "name": "renewal_expected_date", "type": "esriFieldTypeString", "alias": "renewal_expected_date", "length": 1073741822, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "comments", "length": 1073741822, "domain": null }, { "name": "application", "type": "esriFieldTypeString", "alias": "application", "length": 1073741822, "domain": null }, { "name": "proposed_application", "type": "esriFieldTypeString", "alias": "proposed_application", "length": 1073741822, "domain": null }, { "name": "application_link", "type": "esriFieldTypeString", "alias": "application_link", "length": 1073741822, "domain": null }, { "name": "customer_id", "type": "esriFieldTypeInteger", "alias": "customer_id", "domain": null }, { "name": "contract_type", "type": "esriFieldTypeString", "alias": "contract_type", "length": 1073741822, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "GDB_GEOMATTR_DATA", "type": "esriFieldTypeBlob", "alias": "GDB_GEOMATTR_DATA", "domain": null }, { "name": "TotalPresent", "type": "esriFieldTypeInteger", "alias": "TotalPresent", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": null, "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": 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, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "82387e65ab4d48dfb37627d03bdd6483" } ], "tables": [ { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 1, "name": "PSADMIN.Attendance", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "punch_in", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ID", "type": "esriFieldTypeInteger", "alias": "ID", "domain": null }, { "name": "fingerprint_id", "type": "esriFieldTypeInteger", "alias": "Fingerprint ID", "domain": null }, { "name": "customer_id", "type": "esriFieldTypeInteger", "alias": "Customer ID", "domain": null }, { "name": "date", "type": "esriFieldTypeDateOnly", "alias": "Date", "domain": null }, { "name": "punch_in", "type": "esriFieldTypeString", "alias": "Punch In", "length": 8, "domain": null }, { "name": "punch_out", "type": "esriFieldTypeString", "alias": "Punch Out", "length": 8, "domain": null }, { "name": "late_in", "type": "esriFieldTypeInteger", "alias": "Late In", "domain": null }, { "name": "late_out", "type": "esriFieldTypeInteger", "alias": "Late Out", "domain": null }, { "name": "worked_hours", "type": "esriFieldTypeString", "alias": "Worked Hours", "length": 50, "domain": null }, { "name": "status", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": null }, { "name": "leave_id", "type": "esriFieldTypeInteger", "alias": "Leae ID", "domain": null }, { "name": "exception_id", "type": "esriFieldTypeInteger", "alias": "Exception ID", "domain": null }, { "name": "shift_start", "type": "esriFieldTypeString", "alias": "Shift Start", "length": 8, "domain": null }, { "name": "shift_end", "type": "esriFieldTypeString", "alias": "Shift End", "length": 8, "domain": null }, { "name": "worktime_id", "type": "esriFieldTypeInteger", "alias": "WorkTime ID", "domain": null }, { "name": "created_at", "type": "esriFieldTypeDateOnly", "alias": "Created At", "domain": null }, { "name": "updated_at", "type": "esriFieldTypeDateOnly", "alias": "Updated At", "domain": null }, { "name": "deleted_at", "type": "esriFieldTypeDateOnly", "alias": "Deleted At", "domain": null }, { "name": "is_deleted", "type": "esriFieldTypeSmallInteger", "alias": "Is Deleted", "domain": null } ], "indexes": [ { "name": "PK_ATTENDANCE", "fields": "ID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_8_CustomerID", "fields": "customer_id", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R16_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_8_fingerprin", "fields": "fingerprint_id", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "PSADMIN.Employees", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "fingerprint_id", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8A9B85CA-A7A4-4537-890B-23EFF16B4854}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "82387e65ab4d48dfb37627d03bdd6483" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 2, "name": "PSADMIN.Employees", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "name_ar", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "fingerprint_id", "type": "esriFieldTypeInteger", "alias": "Fingerprint ID", "domain": null }, { "name": "name_ar", "type": "esriFieldTypeString", "alias": "Arabic Name", "length": 255, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 255, "domain": null }, { "name": "department_id", "type": "esriFieldTypeInteger", "alias": "Department ID", "domain": null }, { "name": "name_en", "type": "esriFieldTypeString", "alias": "English Name", "length": 255, "domain": null }, { "name": "country_id", "type": "esriFieldTypeInteger", "alias": "Country ID", "domain": null }, { "name": "birthdate", "type": "esriFieldTypeDate", "alias": "Birthdate", "length": 8, "domain": null }, { "name": "email", "type": "esriFieldTypeString", "alias": "Email", "length": 255, "domain": null }, { "name": "phone", "type": "esriFieldTypeString", "alias": "Phone", "length": 50, "domain": null }, { "name": "passport_num", "type": "esriFieldTypeString", "alias": "Passport Number", "length": 255, "domain": null }, { "name": "job_title_id", "type": "esriFieldTypeInteger", "alias": "Job Title ID", "domain": null }, { "name": "end_date", "type": "esriFieldTypeDate", "alias": "End Date", "length": 8, "domain": null }, { "name": "created_at", "type": "esriFieldTypeDate", "alias": "created_at", "length": 8, "domain": null }, { "name": "updated_at", "type": "esriFieldTypeDate", "alias": "updated_at", "length": 8, "domain": null }, { "name": "deleted_at", "type": "esriFieldTypeDate", "alias": "deleted_at", "length": 8, "domain": null }, { "name": "contract_type_id", "type": "esriFieldTypeInteger", "alias": "contract_type_id", "domain": null }, { "name": "start_date", "type": "esriFieldTypeDate", "alias": "Start Date", "length": 8, "domain": null }, { "name": "created_by", "type": "esriFieldTypeInteger", "alias": "Created By", "domain": null }, { "name": "updated_by", "type": "esriFieldTypeInteger", "alias": "Updated By", "domain": null }, { "name": "deleted_by", "type": "esriFieldTypeInteger", "alias": "Deleted By", "domain": null }, { "name": "emp_photo", "type": "esriFieldTypeBlob", "alias": "Employee Photo", "domain": null }, { "name": "is_deleted", "type": "esriFieldTypeSmallInteger", "alias": "Is Deleted", "domain": null }, { "name": "worktime_id", "type": "esriFieldTypeInteger", "alias": "Worktime ID", "domain": null }, { "name": "reporting_to_id", "type": "esriFieldTypeInteger", "alias": "Reporting To ID", "domain": null }, { "name": "applicable_for_attendance", "type": "esriFieldTypeSmallInteger", "alias": "Applicable For Attendance", "domain": null } ], "indexes": [ { "name": "PK_EMPLOYEES", "fields": "fingerprint_id", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R20_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "PSADMIN.Attendance", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "fingerprint_id", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8A9B85CA-A7A4-4537-890B-23EFF16B4854}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "82387e65ab4d48dfb37627d03bdd6483" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 3, "name": "PSADMIN.Departments", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "name_en", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "id", "type": "esriFieldTypeInteger", "alias": "id", "domain": null }, { "name": "Department_Code", "type": "esriFieldTypeString", "alias": "Department Code", "length": 5, "domain": null }, { "name": "name_en", "type": "esriFieldTypeString", "alias": "Name English", "length": 255, "domain": null }, { "name": "name_ar", "type": "esriFieldTypeString", "alias": "Name Arabic", "length": 255, "domain": null }, { "name": "manager_id", "type": "esriFieldTypeInteger", "alias": "manager_id", "domain": null }, { "name": "is_deleted", "type": "esriFieldTypeSmallInteger", "alias": "Is Deleted", "domain": null } ], "indexes": [ { "name": "PK_DEPARTMENTS", "fields": "id", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UQ_DEPARTMENTS_UNIQUE", "fields": "Department_Code", "isAscending": true, "isUnique": true, "description": "" }, { "name": "Index_DEPARTMENTS_1", "fields": "Department_Code", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R19_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "82387e65ab4d48dfb37627d03bdd6483" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 4, "name": "PSADMIN.signatures", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "time", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "id", "type": "esriFieldTypeInteger", "alias": "id", "domain": null }, { "name": "fingerprint_id", "type": "esriFieldTypeInteger", "alias": "Fingerprint ID", "domain": null }, { "name": "customer_id", "type": "esriFieldTypeInteger", "alias": "Customer ID", "domain": null }, { "name": "date", "type": "esriFieldTypeDateOnly", "alias": "Date", "domain": null }, { "name": "time", "type": "esriFieldTypeString", "alias": "Time", "length": 8, "domain": null }, { "name": "device_id", "type": "esriFieldTypeInteger", "alias": "Device ID", "domain": null }, { "name": "mode", "type": "esriFieldTypeInteger", "alias": "Mode", "domain": null }, { "name": "source", "type": "esriFieldTypeInteger", "alias": "source", "domain": null }, { "name": "X", "type": "esriFieldTypeDouble", "alias": "X", "domain": null }, { "name": "Y", "type": "esriFieldTypeDouble", "alias": "Y", "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "is_inside_location", "type": "esriFieldTypeSmallInteger", "alias": "Is Inside Location", "domain": null }, { "name": "created_at", "type": "esriFieldTypeDate", "alias": "Created At", "length": 8, "precision": 1, "domain": null }, { "name": "updated_at", "type": "esriFieldTypeDate", "alias": "Updated At", "length": 8, "precision": 1, "domain": null }, { "name": "deleted_at", "type": "esriFieldTypeDate", "alias": "Deleted At", "length": 8, "precision": 1, "domain": null }, { "name": "is_deleted", "type": "esriFieldTypeSmallInteger", "alias": "Is Deleted", "domain": null } ], "indexes": [ { "name": "PK_SIGNATURES", "fields": "id", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R32_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "82387e65ab4d48dfb37627d03bdd6483" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 5, "name": "PSADMIN.JOB_TITLE", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "name_en", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "id", "type": "esriFieldTypeInteger", "alias": "id", "domain": null }, { "name": "name_en", "type": "esriFieldTypeString", "alias": "name_en", "length": 255, "domain": null }, { "name": "name_ar", "type": "esriFieldTypeString", "alias": "name_ar", "length": 255, "domain": null }, { "name": "is_deleted", "type": "esriFieldTypeSmallInteger", "alias": "is_deleted", "domain": null } ], "indexes": [ { "name": "PK_JOB_TITLE", "fields": "id", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R23_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "82387e65ab4d48dfb37627d03bdd6483" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 6, "name": "PSADMIN.Leaves", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "id", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "id", "type": "esriFieldTypeInteger", "alias": "ID", "domain": null }, { "name": "fingerprint_id", "type": "esriFieldTypeInteger", "alias": "fingerprint_id", "domain": null }, { "name": "from_date", "type": "esriFieldTypeDate", "alias": "From Date", "length": 8, "domain": null }, { "name": "to_date", "type": "esriFieldTypeDate", "alias": "To Date", "length": 8, "domain": null }, { "name": "notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 250, "domain": null }, { "name": "type_id", "type": "esriFieldTypeInteger", "alias": "type_id", "domain": null }, { "name": "status", "type": "esriFieldTypeInteger", "alias": "status", "domain": null }, { "name": "created_at", "type": "esriFieldTypeDate", "alias": "Created At", "length": 8, "domain": null }, { "name": "is_deleted", "type": "esriFieldTypeSmallInteger", "alias": "is_deleted", "domain": null } ], "indexes": [ { "name": "PK_LEAVES", "fields": "id", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R25_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "82387e65ab4d48dfb37627d03bdd6483" } ] }