Layers:

Layer: GeoAttendance (0)

Name: GeoAttendance

Display Field: English_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3ba2314d22a34dbcafcb51842be0e2ec

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 5332477.149300002
YMin: 3317227.5151000023
XMax: 5387892.759399999
YMax: 3425334.1445000023
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• GDB_GEOMATTR_DATA ( type: esriFieldTypeBlob, alias: GDB_GEOMATTR_DATA )
• GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, length: 38 )
• CUSTOMER_Number ( type: esriFieldTypeInteger, alias: CUSTOMER_Number )
• AccountManager ( type: esriFieldTypeString, alias: AccountManager, length: 255 )
• CLIENT ( type: esriFieldTypeString, alias: CLIENT, length: 255 )
• ContractType ( type: esriFieldTypeSmallInteger, alias: ContractType )
• PRODUCT_Type ( type: esriFieldTypeString, alias: PRODUCT_Type, length: 255 )
• English_Name ( type: esriFieldTypeString, alias: English_Name, length: 255 )
• LICENSE_Start ( type: esriFieldTypeDate, alias: LICENSE_Start, length: 8, precision: 1 )
• LICENSE_End ( type: esriFieldTypeDate, alias: LICENSE_End, length: 8, precision: 1 )
• Arabic_Name ( type: esriFieldTypeString, alias: Arabic_Name, length: 255 )
• Link ( type: esriFieldTypeString, alias: Link, length: 255 )
• Opportinity ( type: esriFieldTypeString, alias: Opportinity, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 255 )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• Contract_Type ( type: esriFieldTypeString, alias: Contract_Type, length: 255 )
• License_Status ( type: esriFieldTypeString, alias: License_Status, length: 255 )
• Renewal_ExpectedDate ( type: esriFieldTypeDate, alias: Renewal_ExpectedDate, length: 8, precision: 1 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Application ( type: esriFieldTypeString, alias: Application, length: 256 )
• ProposedApplication ( type: esriFieldTypeString, alias: ProposedApplication, length: 255 )
• ApplicationLink ( type: esriFieldTypeString, alias: ApplicationLink, length: 255 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8, precision: 1 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8, precision: 1 )
• CustomerID ( type: esriFieldTypeInteger, alias: CustomerID )
• TotalPresent ( type: esriFieldTypeInteger, alias: TotalPresent )

Relationships:

• SDE.signatures (0) -- Related To: signatures (1)
• SDE.Attendance (1) -- Related To: Attendance (2)

Layer: HeatMap (3)

Name: HeatMap

Display Field: English_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3ba2314d22a34dbcafcb51842be0e2ec

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 5332477.149300002
YMin: 3317227.5151000023
XMax: 5387892.759399999
YMax: 3425334.1445000023
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Unsupported Renderer: heatmap

Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• GDB_GEOMATTR_DATA ( type: esriFieldTypeBlob, alias: GDB_GEOMATTR_DATA )
• GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, length: 38 )
• CUSTOMER_Number ( type: esriFieldTypeInteger, alias: CUSTOMER_Number )
• AccountManager ( type: esriFieldTypeString, alias: AccountManager, length: 255 )
• CLIENT ( type: esriFieldTypeString, alias: CLIENT, length: 255 )
• ContractType ( type: esriFieldTypeSmallInteger, alias: ContractType )
• PRODUCT_Type ( type: esriFieldTypeString, alias: PRODUCT_Type, length: 255 )
• English_Name ( type: esriFieldTypeString, alias: English_Name, length: 255 )
• LICENSE_Start ( type: esriFieldTypeDate, alias: LICENSE_Start, length: 8, precision: 1 )
• LICENSE_End ( type: esriFieldTypeDate, alias: LICENSE_End, length: 8, precision: 1 )
• Arabic_Name ( type: esriFieldTypeString, alias: Arabic_Name, length: 255 )
• Link ( type: esriFieldTypeString, alias: Link, length: 255 )
• Opportinity ( type: esriFieldTypeString, alias: Opportinity, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 255 )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• Contract_Type ( type: esriFieldTypeString, alias: Contract_Type, length: 255 )
• License_Status ( type: esriFieldTypeString, alias: License_Status, length: 255 )
• Renewal_ExpectedDate ( type: esriFieldTypeDate, alias: Renewal_ExpectedDate, length: 8, precision: 1 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Application ( type: esriFieldTypeString, alias: Application, length: 256 )
• ProposedApplication ( type: esriFieldTypeString, alias: ProposedApplication, length: 255 )
• ApplicationLink ( type: esriFieldTypeString, alias: ApplicationLink, length: 255 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8, precision: 1 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8, precision: 1 )
• CustomerID ( type: esriFieldTypeInteger, alias: CustomerID )
• TotalPresent ( type: esriFieldTypeInteger, alias: TotalPresent )

Tables:

Table: signatures (1)

Name: signatures

Display Field: time

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3ba2314d22a34dbcafcb51842be0e2ec

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• id ( type: esriFieldTypeOID, alias: id )
• fingerprint_id ( type: esriFieldTypeInteger, alias: fingerprint_id )
• date ( type: esriFieldTypeDateOnly, alias: date )
• time ( type: esriFieldTypeString, alias: time, length: 8 )
• device_id ( type: esriFieldTypeInteger, alias: device_id )
• matching_type ( type: esriFieldTypeInteger, alias: matching_type )
• result ( type: esriFieldTypeInteger, alias: result )
• mode ( type: esriFieldTypeInteger, alias: mode )
• created_at ( type: esriFieldTypeDate, alias: created_at, length: 8, precision: 1 )
• updated_at ( type: esriFieldTypeDate, alias: updated_at, length: 8, precision: 1 )
• deleted_at ( type: esriFieldTypeDate, alias: deleted_at, length: 8, precision: 1 )
• source ( type: esriFieldTypeInteger, alias: source )
• IsCommittee ( type: esriFieldTypeInteger, alias: IsCommittee )
• Isdeleted ( type: esriFieldTypeSmallInteger, alias: Isdeleted )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• Accuracy ( type: esriFieldTypeDouble, alias: Accuracy )
• IsInsideWorkingLocation ( type: esriFieldTypeSmallInteger, alias: IsInsideWorkingLocation )
• WorkingLocationID ( type: esriFieldTypeInteger, alias: WorkingLocationID )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude )
• EmpNo ( type: esriFieldTypeInteger, alias: EmpNo )

Relationships:

• DBO.%GeoAttendance_2 (0) -- Related To: GeoAttendance (0)

Table: Attendance (2)

Name: Attendance

Display Field: worked_hours

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3ba2314d22a34dbcafcb51842be0e2ec

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• ID ( type: esriFieldTypeInteger, alias: ID )
• worked_hours ( type: esriFieldTypeString, alias: worked_hours, length: 50 )
• Isdeleted ( type: esriFieldTypeSmallInteger, alias: Isdeleted )
• fingerprint_id ( type: esriFieldTypeInteger, alias: fingerprint_id )
• date ( type: esriFieldTypeDateOnly, alias: date )
• punch_in ( type: esriFieldTypeString, alias: punch_in, length: 8 )
• punch_out ( type: esriFieldTypeString, alias: punch_out, length: 8 )
• late_in ( type: esriFieldTypeInteger, alias: late_in )
• late_out ( type: esriFieldTypeInteger, alias: late_out )
• overtime ( type: esriFieldTypeInteger, alias: overtime )
• overtime_in ( type: esriFieldTypeString, alias: overtime_in, length: 8 )
• overtime_out ( type: esriFieldTypeString, alias: overtime_out, length: 8 )
• status ( type: esriFieldTypeString, alias: status, length: 255 )
• leave_id ( type: esriFieldTypeInteger, alias: leave_id )
• exception_id ( type: esriFieldTypeInteger, alias: exception_id )
• allowance_id ( type: esriFieldTypeInteger, alias: allowance_id )
• shift_start ( type: esriFieldTypeString, alias: shift_start, length: 8 )
• shift_end ( type: esriFieldTypeString, alias: shift_end, length: 8 )
• worktime_id ( type: esriFieldTypeInteger, alias: worktime_id )
• created_at ( type: esriFieldTypeDateOnly, alias: created_at )
• updated_at ( type: esriFieldTypeDateOnly, alias: updated_at )
• deleted_at ( type: esriFieldTypeDateOnly, alias: deleted_at )
• EmpNo ( type: esriFieldTypeInteger, alias: EmpNo )
• WorkingLocationID ( type: esriFieldTypeInteger, alias: WorkingLocationID )

Relationships:

• DBO.%GeoAttendance_2 (1) -- Related To: GeoAttendance (0)