{ "currentVersion": 10.61, "id": 4, "name": "dptc.DPTC.LUT_PROVINCE_REGION", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SUB_PRJ_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "SUB_PRJ_ID", "type": "esriFieldTypeOID", "alias": "SUB_PRJ_ID", "domain": null }, { "name": "SUB_PRJ_NAME", "type": "esriFieldTypeString", "alias": "SUB_PRJ_NAME", "length": 250, "domain": null }, { "name": "PRJ_ID", "type": "esriFieldTypeInteger", "alias": "PRJ_ID", "domain": null }, { "name": "ACTIVITY_ID", "type": "esriFieldTypeInteger", "alias": "ACTIVITY_ID", "domain": null }, { "name": "ACTIVITY_SUB_ID", "type": "esriFieldTypeInteger", "alias": "ACTIVITY_SUB_ID", "domain": null }, { "name": "ACTIVITY_MINOR_ID", "type": "esriFieldTypeInteger", "alias": "ACTIVITY_MINOR_ID", "domain": null }, { "name": "AVG_PROGRESS", "type": "esriFieldTypeInteger", "alias": "AVG_PROGRESS", "domain": null }, { "name": "BUDGET_USED", "type": "esriFieldTypeDouble", "alias": "BUDGET_USED", "domain": null }, { "name": "BUDGET_CODE", "type": "esriFieldTypeString", "alias": "BUDGET_CODE", "length": 16, "domain": null }, { "name": "BUDGET_AMOUNT", "type": "esriFieldTypeDouble", "alias": "BUDGET_AMOUNT", "domain": null }, { "name": "OBJECTIVE", "type": "esriFieldTypeString", "alias": "OBJECTIVE", "length": 500, "domain": null }, { "name": "RESULT", "type": "esriFieldTypeString", "alias": "RESULT", "length": 500, "domain": null }, { "name": "DEPT_ID", "type": "esriFieldTypeInteger", "alias": "DEPT_ID", "domain": null }, { "name": "ASSIGN_ID", "type": "esriFieldTypeInteger", "alias": "ASSIGN_ID", "domain": null }, { "name": "PLANNER_FLAG", "type": "esriFieldTypeString", "alias": "PLANNER_FLAG", "length": 10, "domain": null }, { "name": "PLAN_TYPE", "type": "esriFieldTypeString", "alias": "PLAN_TYPE", "length": 10, "domain": null }, { "name": "PLAN_ID", "type": "esriFieldTypeString", "alias": "PLAN_ID", "length": 10, "domain": null }, { "name": "PLAN_NAME", "type": "esriFieldTypeString", "alias": "PLAN_NAME", "length": 250, "domain": null }, { "name": "PLAN_CODE", "type": "esriFieldTypeString", "alias": "PLAN_CODE", "length": 250, "domain": null }, { "name": "START_DATE", "type": "esriFieldTypeDate", "alias": "START_DATE", "length": 8, "domain": null }, { "name": "END_DATE", "type": "esriFieldTypeDate", "alias": "END_DATE", "length": 8, "domain": null }, { "name": "CONTRACT_NO", "type": "esriFieldTypeString", "alias": "CONTRACT_NO", "length": 250, "domain": null }, { "name": "SIGNED_DATE", "type": "esriFieldTypeDate", "alias": "SIGNED_DATE", "length": 8, "domain": null }, { "name": "MAIN_PLAN_FLAG", "type": "esriFieldTypeString", "alias": "MAIN_PLAN_FLAG", "length": 10, "domain": null }, { "name": "CREATE_DATE", "type": "esriFieldTypeDate", "alias": "CREATE_DATE", "length": 8, "domain": null }, { "name": "CREATE_BY", "type": "esriFieldTypeString", "alias": "CREATE_BY", "length": 10, "domain": null }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "EDIT_DATE", "length": 8, "domain": null }, { "name": "EDIT_BY", "type": "esriFieldTypeString", "alias": "EDIT_BY", "length": 10, "domain": null }, { "name": "BUDGET_TYPE", "type": "esriFieldTypeString", "alias": "BUDGET_TYPE", "length": 10, "domain": null }, { "name": "START_FISCAL_YEAR", "type": "esriFieldTypeString", "alias": "START_FISCAL_YEAR", "length": 4, "domain": null }, { "name": "END_FISCAL_YEAR", "type": "esriFieldTypeString", "alias": "END_FISCAL_YEAR", "length": 4, "domain": null }, { "name": "ASSIGN_NAME", "type": "esriFieldTypeString", "alias": "ASSIGN_NAME", "length": 250, "domain": null }, { "name": "AVG_PROGRESS_2", "type": "esriFieldTypeInteger", "alias": "AVG_PROGRESS_2", "domain": null }, { "name": "PROGRESS_RANGE_CODE", "type": "esriFieldTypeInteger", "alias": "PROGRESS_RANGE_CODE", "domain": null }, { "name": "SUB_PRJ_TYPE", "type": "esriFieldTypeInteger", "alias": "SUB_PRJ_TYPE", "domain": null }, { "name": "COMP_NAME", "type": "esriFieldTypeString", "alias": "COMP_NAME", "length": 250, "domain": null }, { "name": "PROCEED_BY", "type": "esriFieldTypeInteger", "alias": "PROCEED_BY", "domain": null } ], "indexes": [ { "name": "PK__SUB_PROJ__35C6EF98E541B5C3", "fields": "SUB_PRJ_ID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "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 }