{
 "layers": [
  {
   "currentVersion": 11.2,
   "cimVersion": "3.2.0",
   "id": 0,
   "name": "GeoAttendance",
   "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": -100000,
    "mUnits": 10000
   },
   "copyrightText": "",
   "parentLayer": null,
   "subLayers": [],
   "minScale": 0,
   "maxScale": 0,
   "referenceScale": 0.0,
   "drawingInfo": {
    "renderer": {
     "type": "simple",
     "symbol": {
      "type": "esriPMS",
      "url": "ecd764640839e4d47a2b699b5e10f06d",
      "imageData": "iVBORw0KGgoAAAANSUhEUgAAABIAAAAcCAYAAABsxO8nAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABmklEQVQ4jbWUwY3CMBBFv0apgBt7TgeIGriwoxypIDTBYZFoglSBDFUkSgkcF7oYrSbEVuI4iVntfglBHPvx53vsBH+k5F9BWZatROQTwLYd+gBQA3gAOBpjHrMgZs5F5AvA0nu1bb9zZt4bY4pREDOfdWJEJWdmXhlj9gNQW04MxCrPsqy4XC51DyQi6uYtici1ze8Fat2s/ImbzQaLxQJlWeJ+v4dYS12rrhpQCHI4HLBer5vfu90OVVXhdDqFXOnaF8ja6zqxECt91o8CPTUmrKOaiNwbLSekNE1DoKcDJUnyEBH3RjPRcnyVZTkYI6KrA2lYzPy0TajB6j93y6uqKhR4Pdh+ANrNrgU0WAWlaTq1a667HUhbXo+HDc+6qIaZODfdY9I7IiJyJCIzttKf233ugW6325WZteZBX3mqde7cNcIAvjEhInKHdRSkdw0za+1jB7iwOzXnSGH7NnhfCuhlE3PVqv2zN1aEbsdJUKAdav9WjHXULEYHNDVxDnS0oRNR8WtQZwcR2ql3HM06iQbNOYkGxeoHTRbBJVODcj4AAAAASUVORK5CYII=",
      "contentType": "image/png",
      "width": 13,
      "height": 21,
      "angle": 0,
      "xoffset": 0,
      "yoffset": 0
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": 5332477.149300002,
    "ymin": 3317227.5151000023,
    "xmax": 5387892.759399999,
    "ymax": 3425334.1445000023,
    "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": "Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    },
    {
     "name": "GDB_GEOMATTR_DATA",
     "type": "esriFieldTypeBlob",
     "alias": "GDB_GEOMATTR_DATA",
     "domain": null
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGUID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    },
    {
     "name": "CUSTOMER_Number",
     "type": "esriFieldTypeInteger",
     "alias": "CUSTOMER_Number",
     "domain": null
    },
    {
     "name": "AccountManager",
     "type": "esriFieldTypeString",
     "alias": "AccountManager",
     "length": 255,
     "domain": null
    },
    {
     "name": "CLIENT",
     "type": "esriFieldTypeString",
     "alias": "CLIENT",
     "length": 255,
     "domain": null
    },
    {
     "name": "ContractType",
     "type": "esriFieldTypeSmallInteger",
     "alias": "ContractType",
     "domain": null
    },
    {
     "name": "PRODUCT_Type",
     "type": "esriFieldTypeString",
     "alias": "PRODUCT_Type",
     "length": 255,
     "domain": null
    },
    {
     "name": "English_Name",
     "type": "esriFieldTypeString",
     "alias": "English_Name",
     "length": 255,
     "domain": null
    },
    {
     "name": "LICENSE_Start",
     "type": "esriFieldTypeDate",
     "alias": "LICENSE_Start",
     "length": 8,
     "precision": 1,
     "domain": null
    },
    {
     "name": "LICENSE_End",
     "type": "esriFieldTypeDate",
     "alias": "LICENSE_End",
     "length": 8,
     "precision": 1,
     "domain": null
    },
    {
     "name": "Arabic_Name",
     "type": "esriFieldTypeString",
     "alias": "Arabic_Name",
     "length": 255,
     "domain": null
    },
    {
     "name": "Link",
     "type": "esriFieldTypeString",
     "alias": "Link",
     "length": 255,
     "domain": null
    },
    {
     "name": "Opportinity",
     "type": "esriFieldTypeString",
     "alias": "Opportinity",
     "length": 255,
     "domain": null
    },
    {
     "name": "Status",
     "type": "esriFieldTypeString",
     "alias": "Status",
     "length": 255,
     "domain": null
    },
    {
     "name": "X",
     "type": "esriFieldTypeDouble",
     "alias": "X",
     "domain": null
    },
    {
     "name": "Y",
     "type": "esriFieldTypeDouble",
     "alias": "Y",
     "domain": null
    },
    {
     "name": "Contract_Type",
     "type": "esriFieldTypeString",
     "alias": "Contract_Type",
     "length": 255,
     "domain": null
    },
    {
     "name": "License_Status",
     "type": "esriFieldTypeString",
     "alias": "License_Status",
     "length": 255,
     "domain": null
    },
    {
     "name": "Renewal_ExpectedDate",
     "type": "esriFieldTypeDate",
     "alias": "Renewal_ExpectedDate",
     "length": 8,
     "precision": 1,
     "domain": null
    },
    {
     "name": "Comments",
     "type": "esriFieldTypeString",
     "alias": "Comments",
     "length": 255,
     "domain": null
    },
    {
     "name": "Application",
     "type": "esriFieldTypeString",
     "alias": "Application",
     "length": 256,
     "domain": null
    },
    {
     "name": "ProposedApplication",
     "type": "esriFieldTypeString",
     "alias": "ProposedApplication",
     "length": 255,
     "domain": null
    },
    {
     "name": "ApplicationLink",
     "type": "esriFieldTypeString",
     "alias": "ApplicationLink",
     "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,
     "precision": 1,
     "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,
     "precision": 1,
     "domain": null
    },
    {
     "name": "CustomerID",
     "type": "esriFieldTypeInteger",
     "alias": "CustomerID",
     "domain": null
    },
    {
     "name": "TotalPresent",
     "type": "esriFieldTypeInteger",
     "alias": "TotalPresent",
     "domain": null
    }
   ],
   "geometryField": {
    "name": "Shape",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape"
   },
   "indexes": null,
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "SDE.signatures",
     "relatedTableId": 1,
     "role": "esriRelRoleOrigin",
     "keyField": "CustomerID",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    },
    {
     "id": 1,
     "name": "SDE.Attendance",
     "relatedTableId": 2,
     "role": "esriRelRoleOrigin",
     "keyField": "CustomerID",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    }
   ],
   "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": "3ba2314d22a34dbcafcb51842be0e2ec"
  },
  {
   "currentVersion": 11.2,
   "cimVersion": "3.2.0",
   "id": 3,
   "name": "HeatMap",
   "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": -100000,
    "mUnits": 10000
   },
   "copyrightText": "",
   "parentLayer": null,
   "subLayers": [],
   "minScale": 0,
   "maxScale": 0,
   "referenceScale": 0.0,
   "drawingInfo": {
    "renderer": {
     "type": "heatmap",
     "field": "TotalPresent",
     "legendOptions": {
      "title": "TotalPresent",
      "minLabel": "Sparse",
      "maxLabel": "Dense"
     },
     "colorStops": [
      {
       "ratio": 0,
       "color": [
        133,
        193,
        200,
        0
       ]
      },
      {
       "ratio": 0.01,
       "color": [
        133,
        193,
        200,
        0
       ]
      },
      {
       "ratio": 0.01,
       "color": [
        133,
        193,
        200,
        255
       ]
      },
      {
       "ratio": 0.01,
       "color": [
        133,
        193,
        200,
        255
       ]
      },
      {
       "ratio": 0.08333333,
       "color": [
        144,
        161,
        190,
        255
       ]
      },
      {
       "ratio": 0.16666667,
       "color": [
        156,
        129,
        132,
        255
       ]
      },
      {
       "ratio": 0.25,
       "color": [
        167,
        97,
        170,
        255
       ]
      },
      {
       "ratio": 0.33333333,
       "color": [
        175,
        73,
        128,
        255
       ]
      },
      {
       "ratio": 0.41666667,
       "color": [
        184,
        48,
        85,
        255
       ]
      },
      {
       "ratio": 0.5,
       "color": [
        192,
        24,
        42,
        255
       ]
      },
      {
       "ratio": 0.58333333,
       "color": [
        200,
        0,
        0,
        255
       ]
      },
      {
       "ratio": 0.66666667,
       "color": [
        211,
        51,
        0,
        255
       ]
      },
      {
       "ratio": 0.75,
       "color": [
        222,
        102,
        0,
        255
       ]
      },
      {
       "ratio": 0.83333333,
       "color": [
        233,
        153,
        0,
        255
       ]
      },
      {
       "ratio": 0.91666667,
       "color": [
        244,
        204,
        0,
        255
       ]
      },
      {
       "ratio": 1.0,
       "color": [
        255,
        255,
        0,
        255
       ]
      }
     ],
     "radius": 25,
     "minDensity": 0,
     "maxDensity": 0.00297060007943469
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": 5332477.149300002,
    "ymin": 3317227.5151000023,
    "xmax": 5387892.759399999,
    "ymax": 3425334.1445000023,
    "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": "Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    },
    {
     "name": "GDB_GEOMATTR_DATA",
     "type": "esriFieldTypeBlob",
     "alias": "GDB_GEOMATTR_DATA",
     "domain": null
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGUID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    },
    {
     "name": "CUSTOMER_Number",
     "type": "esriFieldTypeInteger",
     "alias": "CUSTOMER_Number",
     "domain": null
    },
    {
     "name": "AccountManager",
     "type": "esriFieldTypeString",
     "alias": "AccountManager",
     "length": 255,
     "domain": null
    },
    {
     "name": "CLIENT",
     "type": "esriFieldTypeString",
     "alias": "CLIENT",
     "length": 255,
     "domain": null
    },
    {
     "name": "ContractType",
     "type": "esriFieldTypeSmallInteger",
     "alias": "ContractType",
     "domain": null
    },
    {
     "name": "PRODUCT_Type",
     "type": "esriFieldTypeString",
     "alias": "PRODUCT_Type",
     "length": 255,
     "domain": null
    },
    {
     "name": "English_Name",
     "type": "esriFieldTypeString",
     "alias": "English_Name",
     "length": 255,
     "domain": null
    },
    {
     "name": "LICENSE_Start",
     "type": "esriFieldTypeDate",
     "alias": "LICENSE_Start",
     "length": 8,
     "precision": 1,
     "domain": null
    },
    {
     "name": "LICENSE_End",
     "type": "esriFieldTypeDate",
     "alias": "LICENSE_End",
     "length": 8,
     "precision": 1,
     "domain": null
    },
    {
     "name": "Arabic_Name",
     "type": "esriFieldTypeString",
     "alias": "Arabic_Name",
     "length": 255,
     "domain": null
    },
    {
     "name": "Link",
     "type": "esriFieldTypeString",
     "alias": "Link",
     "length": 255,
     "domain": null
    },
    {
     "name": "Opportinity",
     "type": "esriFieldTypeString",
     "alias": "Opportinity",
     "length": 255,
     "domain": null
    },
    {
     "name": "Status",
     "type": "esriFieldTypeString",
     "alias": "Status",
     "length": 255,
     "domain": null
    },
    {
     "name": "X",
     "type": "esriFieldTypeDouble",
     "alias": "X",
     "domain": null
    },
    {
     "name": "Y",
     "type": "esriFieldTypeDouble",
     "alias": "Y",
     "domain": null
    },
    {
     "name": "Contract_Type",
     "type": "esriFieldTypeString",
     "alias": "Contract_Type",
     "length": 255,
     "domain": null
    },
    {
     "name": "License_Status",
     "type": "esriFieldTypeString",
     "alias": "License_Status",
     "length": 255,
     "domain": null
    },
    {
     "name": "Renewal_ExpectedDate",
     "type": "esriFieldTypeDate",
     "alias": "Renewal_ExpectedDate",
     "length": 8,
     "precision": 1,
     "domain": null
    },
    {
     "name": "Comments",
     "type": "esriFieldTypeString",
     "alias": "Comments",
     "length": 255,
     "domain": null
    },
    {
     "name": "Application",
     "type": "esriFieldTypeString",
     "alias": "Application",
     "length": 256,
     "domain": null
    },
    {
     "name": "ProposedApplication",
     "type": "esriFieldTypeString",
     "alias": "ProposedApplication",
     "length": 255,
     "domain": null
    },
    {
     "name": "ApplicationLink",
     "type": "esriFieldTypeString",
     "alias": "ApplicationLink",
     "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,
     "precision": 1,
     "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,
     "precision": 1,
     "domain": null
    },
    {
     "name": "CustomerID",
     "type": "esriFieldTypeInteger",
     "alias": "CustomerID",
     "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": false,
   "serviceItemId": "3ba2314d22a34dbcafcb51842be0e2ec"
  }
 ],
 "tables": [
  {
   "currentVersion": 11.2,
   "cimVersion": "3.2.0",
   "id": 1,
   "name": "signatures",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "time",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "id",
     "type": "esriFieldTypeOID",
     "alias": "id",
     "domain": null
    },
    {
     "name": "fingerprint_id",
     "type": "esriFieldTypeInteger",
     "alias": "fingerprint_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": "matching_type",
     "type": "esriFieldTypeInteger",
     "alias": "matching_type",
     "domain": null
    },
    {
     "name": "result",
     "type": "esriFieldTypeInteger",
     "alias": "result",
     "domain": null
    },
    {
     "name": "mode",
     "type": "esriFieldTypeInteger",
     "alias": "mode",
     "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": "source",
     "type": "esriFieldTypeInteger",
     "alias": "source",
     "domain": null
    },
    {
     "name": "IsCommittee",
     "type": "esriFieldTypeInteger",
     "alias": "IsCommittee",
     "domain": null
    },
    {
     "name": "Isdeleted",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Isdeleted",
     "domain": null
    },
    {
     "name": "X",
     "type": "esriFieldTypeDouble",
     "alias": "X",
     "domain": null
    },
    {
     "name": "Y",
     "type": "esriFieldTypeDouble",
     "alias": "Y",
     "domain": null
    },
    {
     "name": "Accuracy",
     "type": "esriFieldTypeDouble",
     "alias": "Accuracy",
     "domain": null
    },
    {
     "name": "IsInsideWorkingLocation",
     "type": "esriFieldTypeSmallInteger",
     "alias": "IsInsideWorkingLocation",
     "domain": null
    },
    {
     "name": "WorkingLocationID",
     "type": "esriFieldTypeInteger",
     "alias": "WorkingLocationID",
     "domain": null
    },
    {
     "name": "Latitude",
     "type": "esriFieldTypeDouble",
     "alias": "Latitude",
     "domain": null
    },
    {
     "name": "Longitude",
     "type": "esriFieldTypeDouble",
     "alias": "Longitude",
     "domain": null
    },
    {
     "name": "EmpNo",
     "type": "esriFieldTypeInteger",
     "alias": "EmpNo",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "PK_SIGNATURES",
     "fields": "id",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "R53_SDE_ROWID_UK",
     "fields": "id",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "fingerprint_id",
     "fields": "fingerprint_id",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "DBO.%GeoAttendance_2",
     "relatedTableId": 0,
     "role": "esriRelRoleDestination",
     "keyField": "WorkingLocationID",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    }
   ],
   "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": "3ba2314d22a34dbcafcb51842be0e2ec"
  },
  {
   "currentVersion": 11.2,
   "cimVersion": "3.2.0",
   "id": 2,
   "name": "Attendance",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "worked_hours",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "ID",
     "type": "esriFieldTypeInteger",
     "alias": "ID",
     "domain": null
    },
    {
     "name": "worked_hours",
     "type": "esriFieldTypeString",
     "alias": "worked_hours",
     "length": 50,
     "domain": null
    },
    {
     "name": "Isdeleted",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Isdeleted",
     "domain": null
    },
    {
     "name": "fingerprint_id",
     "type": "esriFieldTypeInteger",
     "alias": "fingerprint_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": "overtime",
     "type": "esriFieldTypeInteger",
     "alias": "overtime",
     "domain": null
    },
    {
     "name": "overtime_in",
     "type": "esriFieldTypeString",
     "alias": "overtime_in",
     "length": 8,
     "domain": null
    },
    {
     "name": "overtime_out",
     "type": "esriFieldTypeString",
     "alias": "overtime_out",
     "length": 8,
     "domain": null
    },
    {
     "name": "status",
     "type": "esriFieldTypeString",
     "alias": "status",
     "length": 255,
     "domain": null
    },
    {
     "name": "leave_id",
     "type": "esriFieldTypeInteger",
     "alias": "leave_id",
     "domain": null
    },
    {
     "name": "exception_id",
     "type": "esriFieldTypeInteger",
     "alias": "exception_id",
     "domain": null
    },
    {
     "name": "allowance_id",
     "type": "esriFieldTypeInteger",
     "alias": "allowance_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": "EmpNo",
     "type": "esriFieldTypeInteger",
     "alias": "EmpNo",
     "domain": null
    },
    {
     "name": "WorkingLocationID",
     "type": "esriFieldTypeInteger",
     "alias": "WorkingLocationID",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "PK_ATTENDANCE",
     "fields": "ID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 1,
     "name": "DBO.%GeoAttendance_2",
     "relatedTableId": 0,
     "role": "esriRelRoleDestination",
     "keyField": "WorkingLocationID",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    }
   ],
   "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": "3ba2314d22a34dbcafcb51842be0e2ec"
  }
 ]
}