Tables:

Table: SDE.signatures (0)

Name: SDE.signatures

Display Field: time

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 69e47e47243d48299540485889f168d5

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 )

Table: Employees (1)

Name: Employees

Display Field: Emp_Name_Ar

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 69e47e47243d48299540485889f168d5

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:
• Emp_No ( type: esriFieldTypeInteger, alias: Emp_No )
• Emp_Name_Ar ( type: esriFieldTypeString, alias: Emp_Name_Ar, length: 255 )
• Address ( type: esriFieldTypeString, alias: Address, length: 255 )
• Dept_ID ( type: esriFieldTypeInteger, alias: Dept_ID )
• Emp_Name_En ( type: esriFieldTypeString, alias: Emp_Name_En, length: 255 )
• Gender ( type: esriFieldTypeSmallInteger, alias: Gender )
• civil_id ( type: esriFieldTypeString, alias: civil_id, length: 255 )
• civil_expire_date ( type: esriFieldTypeDate, alias: civil_expire_date, length: 8 )
• country_id ( type: esriFieldTypeSmallInteger, alias: country_id )
• birthdate ( type: esriFieldTypeDate, alias: birthdate, length: 8 )
• region_id ( type: esriFieldTypeSmallInteger, alias: region_id )
• city_id ( type: esriFieldTypeSmallInteger, alias: city_id )
• building_number ( type: esriFieldTypeString, alias: building_number, length: 255 )
• street ( type: esriFieldTypeString, alias: street, length: 255 )
• residency_id ( type: esriFieldTypeSmallInteger, alias: residency_id )
• email ( type: esriFieldTypeString, alias: email, length: 255 )
• phone ( type: esriFieldTypeString, alias: phone, length: 50 )
• education_level_id ( type: esriFieldTypeSmallInteger, alias: education_level_id )
• marital_status_id ( type: esriFieldTypeSmallInteger, alias: marital_status_id )
• fingerprint_id ( type: esriFieldTypeInteger, alias: fingerprint_id )
• bank_id ( type: esriFieldTypeSmallInteger, alias: bank_id )
• bank_account ( type: esriFieldTypeString, alias: bank_account, length: 255 )
• children_count ( type: esriFieldTypeSmallInteger, alias: children_count )
• passport_num ( type: esriFieldTypeString, alias: passport_num, length: 255 )
• passport_expire_date ( type: esriFieldTypeDate, alias: passport_expire_date, length: 8 )
• passport_type_id ( type: esriFieldTypeSmallInteger, alias: passport_type_id )
• passport_issue_date ( type: esriFieldTypeDate, alias: passport_issue_date, length: 8 )
• job_id ( type: esriFieldTypeInteger, alias: job_id )
• job_id_contract ( type: esriFieldTypeSmallInteger, alias: job_id_contract )
• end_date ( type: esriFieldTypeDate, alias: end_date, length: 8 )
• salary ( type: esriFieldTypeDouble, alias: salary )
• salary_contract ( type: esriFieldTypeDouble, alias: salary_contract )
• overtime_policy_id ( type: esriFieldTypeSmallInteger, alias: overtime_policy_id )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• updated_date ( type: esriFieldTypeDate, alias: updated_date, length: 8 )
• deleted_date ( type: esriFieldTypeDate, alias: deleted_date, length: 8 )
• supervisor_id ( type: esriFieldTypeSmallInteger, alias: supervisor_id )
• contract_id ( type: esriFieldTypeSmallInteger, alias: contract_id )
• religion_id ( type: esriFieldTypeSmallInteger, alias: religion_id )
• start_date ( type: esriFieldTypeDate, alias: start_date, length: 8 )
• create_user ( type: esriFieldTypeString, alias: create_user, length: 255 )
• update_user ( type: esriFieldTypeString, alias: update_user, length: 255 )
• delete_user ( type: esriFieldTypeString, alias: delete_user, length: 255 )
• emp_photo ( type: esriFieldTypeBlob, alias: emp_photo )
• Isdeleted ( type: esriFieldTypeSmallInteger, alias: Isdeleted )
• worktime_id ( type: esriFieldTypeInteger, alias: worktime_id )
• parent_id ( type: esriFieldTypeInteger, alias: parent_id )
• applicable_for_attendance ( type: esriFieldTypeSmallInteger, alias: applicable_for_attendance )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Table: Attendance (2)

Name: Attendance

Display Field: worked_hours

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 69e47e47243d48299540485889f168d5

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 )