{ "currentVersion": 10.81, "id": 1, "name": "GISDB2.sde.GetTSskillLevelLicense_GIS_as_skilled", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Org1UnitName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "No_skilled", "type": "esriFieldTypeInteger", "alias": "No_skilled", "domain": null }, { "name": "ID", "type": "esriFieldTypeInteger", "alias": "ID", "domain": null }, { "name": "IsHandCap", "type": "esriFieldTypeSmallInteger", "alias": "IsHandCap", "domain": null }, { "name": "UserType", "type": "esriFieldTypeInteger", "alias": "UserType", "domain": null }, { "name": "Org1Code", "type": "esriFieldTypeInteger", "alias": "Org1Code", "domain": null }, { "name": "Org1UnitName", "type": "esriFieldTypeString", "alias": "Org1UnitName", "length": 50, "domain": null }, { "name": "Org2Code", "type": "esriFieldTypeInteger", "alias": "Org2Code", "domain": null }, { "name": "Org2UnitName", "type": "esriFieldTypeString", "alias": "Org2UnitName", "length": 50, "domain": null }, { "name": "Org3Code", "type": "esriFieldTypeInteger", "alias": "Org3Code", "domain": null }, { "name": "Org3UnitName", "type": "esriFieldTypeString", "alias": "Org3UnitName", "length": 50, "domain": null }, { "name": "AcademicSpecialistId", "type": "esriFieldTypeDouble", "alias": "AcademicSpecialistId", "domain": null }, { "name": "AcademicSpecialistName", "type": "esriFieldTypeString", "alias": "AcademicSpecialistName", "length": 300, "domain": null }, { "name": "AcademicQualificationId", "type": "esriFieldTypeInteger", "alias": "AcademicQualificationId", "domain": null }, { "name": "AcademicQualificationName", "type": "esriFieldTypeString", "alias": "AcademicQualificationName", "length": 200, "domain": null }, { "name": "AcademicDegreeId", "type": "esriFieldTypeInteger", "alias": "AcademicDegreeId", "domain": null }, { "name": "AcademicDegreeName", "type": "esriFieldTypeString", "alias": "AcademicDegreeName", "length": 200, "domain": null }, { "name": "LicenseStartDate", "type": "esriFieldTypeDate", "alias": "LicenseStartDate", "length": 8, "domain": null }, { "name": "LicenseEndDate", "type": "esriFieldTypeDate", "alias": "LicenseEndDate", "length": 8, "domain": null }, { "name": "JobName", "type": "esriFieldTypeString", "alias": "JobName", "length": 2147483647, "domain": null }, { "name": "JobCode", "type": "esriFieldTypeInteger", "alias": "JobCode", "domain": null }, { "name": "SkillLevelName", "type": "esriFieldTypeString", "alias": "SkillLevelName", "length": 50, "domain": null }, { "name": "CompanyID", "type": "esriFieldTypeString", "alias": "CompanyID", "length": 250, "domain": null }, { "name": "Company", "type": "esriFieldTypeInteger", "alias": "Company", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "serviceItemId": "efc6ae11d4c44f1c9639defa754d30d8" }