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 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata