{ "tables": [ { "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "infoInEstimates": [ "extent", "count" ], "ownershipBasedAccessControlForFeatures": { "allowOthersToUpdate": true, "allowOthersToQuery": true, "allowOthersToDelete": true }, "type": "Table", "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "parentrowid", "role": "esriRelRoleDestination", "composite": true, "name": "Infrastructure_Projects_Assessment_Tool_front_facing", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "front_facing", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parentrowid", "length": 38, "alias": "ParentRowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": true, "supportsTruncate": false, "indexes": [ { "name": "r1503_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_1503", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": true, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Sync,Uploads", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "propagateVisibleFields": true, "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "supportsLayerOverrides": true } ], "layers": [ { "extent": { "ymin": -90, "xmin": -180, "ymax": 90, "xmax": 180, "spatialReference": {"wkid": 4326}, "type": "extent" }, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "infoInEstimates": [ "extent", "count" ], "ownershipBasedAccessControlForFeatures": { "allowOthersToUpdate": true, "allowOthersToQuery": true, "allowOthersToDelete": true }, "type": "Feature Layer", "hasStaticData": false, "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "uniquerowid", "role": "esriRelRoleOrigin", "composite": true, "name": "Infrastructure_Projects_Assessment_Tool_front_facing", "relatedTableId": 1, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "New Feature", "description": "", "prototype": { "attributes": {} } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Infrastructure_Projects_Assessment_Tool", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniquerowid", "length": 38, "alias": "RowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_name1", "length": 255, "alias": "Project Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_number", "length": 255, "alias": "Project Number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_id", "length": 255, "alias": "Project ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_type", "length": 255, "alias": "Project Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "physical_address", "length": 255, "alias": "Physical Address", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "latitude", "alias": "GPS Coordinates Latitude", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "longitude", "alias": "GPS Coordinates Longitude", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sector", "length": 255, "alias": "Sector", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dept", "length": 255, "alias": "Department", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_district_municipality", "type": "codedValue", "codedValues": [ { "code": "Amajuba", "name": "Amajuba" }, { "code": "Ethekwini", "name": "Ethekwini" }, { "code": "Harry Gwala", "name": "Harry Gwala" }, { "code": "iLembe", "name": "iLembe" }, { "code": "King Cetshwayo", "name": "King Cetshwayo" }, { "code": "Ugu", "name": "Ugu" }, { "code": "Umgungundlovu", "name": "Umgungundlovu" }, { "code": "Umkhanyakude", "name": "Umkhanyakude" }, { "code": "Umzinyathi", "name": "Umzinyathi" }, { "code": "Uthukela", "name": "Uthukela" }, { "code": "Zululand", "name": "Zululand" } ] }, "name": "district_municipality", "length": 255, "alias": "District Municipality", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "local_municipality", "length": 255, "alias": "Local Municipality", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ward_no", "length": 255, "alias": "Ward No", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_sponsor", "length": 255, "alias": "Project Sponsor", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_manager", "length": 255, "alias": "Project Manager", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contact_number", "length": 255, "alias": "Contact Numbers", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "email_add", "length": 255, "alias": "Email", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_project_idms_gate", "type": "codedValue", "codedValues": [ { "code": "Stage 1 Initiation/ Pre-feasibility", "name": "Stage 1 Initiation/ Pre-feasibility" }, { "code": "Stage 2 Concept/ Feasibility", "name": "Stage 2 Concept/ Feasibility" }, { "code": "Stage 3 Design Development", "name": "Stage 3 Design Development" }, { "code": "Stage 4 Design Documentation", "name": "Stage 4 Design Documentation" }, { "code": "Stage 5 Works", "name": "Stage 5 Works" }, { "code": "Stage 6 Handover", "name": "Stage 6 Handover" }, { "code": "Stage 6a Design documentation (Production information)", "name": "Stage 6a Design documentation (Production information)" }, { "code": "Stage 7 Close out", "name": "Stage 7 Close out" }, { "code": "Packaged Programme", "name": "Packaged Programme" }, { "code": "Other- Programme / Project Administration", "name": "Other- Programme / Project Administration" } ] }, "name": "project_idms_gate", "length": 255, "alias": "Please verify if the Project IDMS Gate is correctProject IDMS Gate", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_status", "length": 255, "alias": "Please verify if the Project Status is correctProject Status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "emoji", "length": 255, "alias": "emoji", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_idms_index", "length": 255, "alias": "project_idms_index", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_status_index", "length": 255, "alias": "project_status_index", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "completion_pstate", "length": 255, "alias": "Project Percentage Stage of Completion", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "estimated_budget", "length": 255, "alias": "Estimated Project Budget", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "expenditure_to_date", "alias": "Project Expenditure to date", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "variation_to_date", "length": 255, "alias": "Project Variation to date", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "pstart_date", "length": 29, "alias": "Project Start Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "ecompletion_date", "length": 29, "alias": "Estimated Completion Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_cost", "length": 255, "alias": "Total Project Cost", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subconstraint", "length": 255, "alias": "subconstraint", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "warn_sign", "length": 255, "alias": "The Project Status not aligned with IDMS gate", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_jobs", "alias": "Number of jobs created (all combined)", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "youth_employed", "alias": "Number of youth employed", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "women_employed", "alias": "Number of women employed", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pwds_employed", "alias": "Number of Person With Disabilities employed", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "employment_period", "length": 255, "alias": "Average employment period", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "minimum_wage", "length": 255, "alias": "Minimum wage", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "trained_peoples", "alias": "Number of people trained (skills)", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "trained_people_hiv_aids", "alias": "Number of people trained (HIV/AIDS)", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "assesment_date", "length": 29, "alias": "Date of Assessment", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assesment_completd_by", "length": 255, "alias": "Assessment Completed By", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pn", "length": 255, "alias": "Project Names", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pawlmdm", "length": 255, "alias": "Project Details", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status1", "length": 255, "alias": "status1", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_no", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "Updated IAMP approved. Strategic Programme Briefs not updated" }, { "code": "major", "name": "IAMP and Strategic Programme Briefs not updated" }, { "code": "critical", "name": "IAMP and Strategic Programme Briefs not updated and approved" } ] }, "name": "rel_choice_no", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "coment_spb", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_idont", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "I am not the Project Manager" }, { "code": "major", "name": "I am the Project Manager, I'm not sure" }, { "code": "critical", "name": "I am the Project Manager. I don't have the project history." } ] }, "name": "rel_choice_idont", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "coment_spb_idont", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gate_changed", "length": 255, "alias": "gate_changed", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status_quest2", "length": 255, "alias": "status_quest2", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_nopsdf", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "The project, not IAMP, aligns with the PSDF" }, { "code": "major", "name": "The IAMP does not align with the PSDF" }, { "code": "critical", "name": "The project does not align with the IAMP and PSDF" } ] }, "name": "rel_choice_nopsdf", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_psdf", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_i_dont_know", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "I am not the Project Manager" }, { "code": "major", "name": "I am the Project Manager, I'm not sure" }, { "code": "critical", "name": "I am the Project Manager. I don't have the project history." } ] }, "name": "rel_choice_i_dont_know", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_psdf_idont", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status_quest3", "length": 255, "alias": "status_quest3", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_noips", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "Submission to Provincial Treasury is late" }, { "code": "major", "name": "Approved IPMP and IPS not updated" }, { "code": "critical", "name": "IPMP and IPS not updated and approved" } ] }, "name": "rel_choice_noips", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_ips", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_idont_ips", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "I am not the Project Manager" }, { "code": "major", "name": "I am the Project Manager, I'm not sure" }, { "code": "critical", "name": "I am the Project Manager. I don't have the project history." } ] }, "name": "rel_choice_idont_ips", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_idont_know_ips", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status_4", "length": 255, "alias": "4. Does the infrastructure project has an approved Project Charter?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_nopc", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "Project has an approved Project Charter; however, IPMP and IPS submission to Provincial Treasury is late" }, { "code": "major", "name": "Project has an approved Project Charter which is not informed by an approved and updated IPMP and IPS" }, { "code": "critical", "name": "Project does not have an approved Project Charter" } ] }, "name": "rel_choice_nopc", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_pc", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_idont_pc", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "I am not the Project Manager" }, { "code": "major", "name": "I am the Project Manager, I'm not sure" }, { "code": "critical", "name": "I am the Project Manager. I don't have the project history." } ] }, "name": "rel_choice_idont_pc", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_idont_know_pc", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status_5", "length": 255, "alias": "5. Does the infrastructure project has an approved Project Plan detailing the plan for project implementation and governance arrangements (including planned social impact and capacitation indicators)?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_nopi", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "Project has an approved Project plan; however, IPMP and IPS submission to Provincial Treasury is late" }, { "code": "major", "name": "Project has an approved Project plan which is not informed by an approved and updated IPMP and IPS" }, { "code": "critical", "name": "Project does not have an approved Project plan" } ] }, "name": "rel_choice_nopi", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_pi", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_idont_pi", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "I am not the Project Manager" }, { "code": "major", "name": "I am the Project Manager, I'm not sure" }, { "code": "critical", "name": "I am the Project Manager. I don't have the project history." } ] }, "name": "rel_choice_idont_pi", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_idont_know_pi", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status_6", "length": 255, "alias": "6. Was the Stage 2 Gateway Review conducted for the project and approved report prepared and issued. (Evidence that the Gateway Review Team was constituted as required is on file)?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_nogrt", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "The Stage 2 Gateway Review was conducted, and Gateway Review Team was properly constituted but approved report not issued" }, { "code": "major", "name": "The Stage 2 Gateway Review was conducted but Gateway Review Team is not constituted in terms of National Treasury IN3 of 2019/20" }, { "code": "critical", "name": "The Stage 2 Gateway Review was conducted but a Gateway Review Team was not appointed or constituted" } ] }, "name": "rel_choice_nogrt", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_grt", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_idont_grt", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "I am not the Project Manager" }, { "code": "major", "name": "I am the Project Manager, I'm not sure" }, { "code": "critical", "name": "I am the Project Manager. I don't have the project history." } ] }, "name": "rel_choice_idont_grt", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_idont_know_grt", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status_7", "length": 255, "alias": "7. For Major capital projects: Was a Gateway Review Team constituted and comprises of not less than three independent persons who are not involved in the infrastructure project, associated with the work covered, and are familiar with various aspects of the subject matter?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_nocfr", "type": "codedValue", "codedValues": [ { "code": "critical", "name": "The Gateway Review Team was constituted in accordance with the requirement of the FIDPM for major capital projects." } ] }, "name": "rel_choice_nocfr", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_cfr", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_idont_cfr", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "I am not the Project Manager" }, { "code": "major", "name": "I am the Project Manager, I'm not sure" }, { "code": "critical", "name": "I am the Project Manager. I don't have the project history." } ] }, "name": "rel_choice_idont_cfr", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_idont_know_cfr", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status_8", "length": 255, "alias": "status_8", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_nomcp", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "The concept or feasibility report is approved, and major and critical gateway review findings were cleared and addressed i.e. only minor review findings remain in the report." }, { "code": "major", "name": "The concept or feasibility report is approved, and critical gateway review findings addressed i.e. minor and major review findings remain in the report." }, { "code": "critical", "name": "The concept or feasibility report is not approved" } ] }, "name": "rel_choice_nomcp", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_mcp", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_idont_mcp", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "I am not the Project Manager" }, { "code": "major", "name": "I am the Project Manager, I'm not sure" }, { "code": "critical", "name": "I am the Project Manager. I don't have the project history." } ] }, "name": "rel_choice_idont_mcp", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_idont_know_mcp", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_no_irm", "type": "codedValue", "codedValues": [ { "code": "major", "name": "The infrastructure project Design Documentation Report is approved but the project plan is not updated" }, { "code": "critical", "name": "The infrastructure project Design Development Report is not approved" } ] }, "name": "rel_choice_no_irm", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_irm", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_idont_irm", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "I am not the Project Manager" }, { "code": "major", "name": "I am the Project Manager, I'm not sure" }, { "code": "critical", "name": "I am the Project Manager. I don't have the project history." } ] }, "name": "rel_choice_idont_irm", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_idont_know_irm", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "statusplaceholder", "length": 255, "alias": "statusplaceholder", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_no_idmsa", "type": "codedValue", "codedValues": [ { "code": "critical", "name": "The infrastructure project IRM project status does not reconcile to the IRM IDMS Gate" } ] }, "name": "rel_choice_no_idmsa", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_idmsa", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_idont_know_idmsa", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "statusplaceholder11", "length": 255, "alias": "statusplaceholder11", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_no_irm_ps", "type": "codedValue", "codedValues": [ { "code": "critical", "name": "The IDMS Gate for the infrastructure project is not correct as recorded and reported on IRM" } ] }, "name": "rel_choice_no_irm_ps", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_irm_ps", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "statusplaceholder12", "length": 255, "alias": "statusplaceholder12", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_no_irm_ps_ipa", "type": "codedValue", "codedValues": [ { "code": "critical", "name": "The infrastructure project IRM project status does not align and reconcile to the IRM IDMS Gate" } ] }, "name": "rel_choice_no_irm_ps_ipa", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_irm_ps_ipa", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_no_sign_off", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "The project percentage stage of completion in terms of deliverables or milestones is ahead of schedule in terms of the planned performance per approved and updated project plan." }, { "code": "major", "name": "The project percentage stage of completion in terms of deliverables or milestones deviates by 15% - 20% of planned performance per approved and updated project plan. [ACB]" }, { "code": "critical", "name": "The project percentage stage of completion in terms of deliverables or milestones deviates by greater than 20% of planned performance per approved and updated project plan." } ] }, "name": "rel_choice_no_sign_off", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_sign_off", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_idont_sign_off", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "I am not the Project Manager" }, { "code": "major", "name": "I am the Project Manager, I'm not sure" }, { "code": "critical", "name": "I am the Project Manager. I don't have the project history." } ] }, "name": "rel_choice_idont_sign_off", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_idont_know_sign_off", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_no_upp", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "The project timelines to date deviate from planned project timelines by 1% - 15% of project time." }, { "code": "major", "name": "The project timelines to date deviate from planned project timelines by 15% - 20% of project time." }, { "code": "critical", "name": "The project timelines to date deviate from planned project timelines by greater than 20% of project time." } ] }, "name": "rel_choice_no_upp", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_upp", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_idont_upp", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "I am not the Project Manager" }, { "code": "major", "name": "I am the Project Manager, I'm not sure" }, { "code": "critical", "name": "I am the Project Manager. I don't have the project history." } ] }, "name": "rel_choice_idont_upp", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_idont_know_upp", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_no_rec_exp", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "The project expenditure to date reflects cost savings/underspending in relation to the planned project budget." }, { "code": "major", "name": "The project expenditure to date deviates from planned expenditure by 15% - 20%; and the project will not be finalised within the 15% - 20% cost deviation" }, { "code": "critical", "name": "The project expenditure to date deviates from planned expenditure by greater than 20% of contract cost or R20 million (whichever is lesser) and the project will not be finalised within the 20% of contract cost or R20 million variation limit." } ] }, "name": "rel_choice_no_rec_exp", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_exp", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_idont_rec_exp", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "I am not the Project Manager" }, { "code": "major", "name": "I am the Project Manager, I'm not sure" }, { "code": "critical", "name": "I am the Project Manager. I don't have the project history." } ] }, "name": "rel_choice_idont_rec_exp", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_idont_know_exp", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_no_agsa", "type": "codedValue", "codedValues": [ { "code": "critical", "name": "For infrastructure projects where contracts were expanded or varied by more than 20% or R20million (including all applicable taxes), the AO did not submit a monthly report including the reasons for the expansion or variation, to the relevant treasury and the AGSA, in a format determined by National Treasury." } ] }, "name": "rel_choice_no_agsa", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_agsa", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_idont_agsa", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "I am not the Project Manager" }, { "code": "major", "name": "I am the Project Manager, I'm not sure" }, { "code": "critical", "name": "I am the Project Manager. I don't have the project history." } ] }, "name": "rel_choice_idont_agsa", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_idont_know_agsa", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_no_agsa_annual", "type": "codedValue", "codedValues": [ { "code": "critical", "name": "For infrastructure projects where contracts were expanded or varied by more than 20% or R20million (including all applicable taxes), whichever is the lesser, the AO did not record expansions or variations reported to the relevant treasury and the AGSA in the annual report." } ] }, "name": "rel_choice_no_agsa_annual", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_agsa_annual", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_idont_agsa_annual", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "I am not the Project Manager" }, { "code": "major", "name": "I am the Project Manager, I'm not sure" }, { "code": "critical", "name": "I am the Project Manager. I don't have the project history." } ] }, "name": "rel_choice_idont_agsa_annual", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_idont_know_agsa_annual", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_no_psi", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "The planned social impact indicators, for the infrastructure project have not been achieved to date but are on target to be achieved at the end of the reporting period" }, { "code": "major", "name": "The planned social impact indicators have not been achieved to date and are not on target to be achieved at the end of the reporting period." }, { "code": "critical", "name": "Social impact indicators and targets are not planned for the project" } ] }, "name": "rel_choice_no_psi", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_psi", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_idont_psi", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "I am not the Project Manager" }, { "code": "major", "name": "I am the Project Manager, I'm not sure" }, { "code": "critical", "name": "I am the Project Manager. I don't have the project history." } ] }, "name": "rel_choice_idont_psi", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_idont_know_psi", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_capacit", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "The planned capacitation targets have not been achieved to date but are on target to be achieved at the end of the reporting period" }, { "code": "major", "name": "The planned social impact indicators have not been achieved to date and are not on target to be achieved at the end of the reporting period." }, { "code": "critical", "name": "Planned indicators and targets for the capacitation for SMMEs are not planned for the project" } ] }, "name": "rel_choice_capacit", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_capacit", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_idont_capacit", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "I am not the Project Manager" }, { "code": "major", "name": "I am the Project Manager, I'm not sure" }, { "code": "critical", "name": "I am the Project Manager. I don't have the project history." } ] }, "name": "rel_choice_idont_capacit", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_idont_know_capacit", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_gate_review", "type": "codedValue", "codedValues": [ { "code": "major", "name": "A Stage 5 Gateway Review at 50% construction was not conducted." } ] }, "name": "rel_choice_gate_review", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_review", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_idont_gate_review", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "I am not the Project Manager" }, { "code": "major", "name": "I am the Project Manager, I'm not sure" }, { "code": "critical", "name": "I am the Project Manager. I don't have the project history." } ] }, "name": "rel_choice_idont_gate_review", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_idont_know_review", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_gate_review100", "type": "codedValue", "codedValues": [ { "code": "critical", "name": "A Stage 5 Gateway Review at 99% construction was not conducted." } ] }, "name": "rel_choice_gate_review100", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_review100", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_rel_choice_idont_gate_review100", "type": "codedValue", "codedValues": [ { "code": "minor", "name": "I am not the Project Manager" }, { "code": "major", "name": "I am the Project Manager, I'm not sure" }, { "code": "critical", "name": "I am the Project Manager. I don't have the project history." } ] }, "name": "rel_choice_idont_gate_review100", "length": 255, "alias": "Select an applicable reason", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_idont_know_review100", "length": 255, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_idms_finding_status", "type": "codedValue", "codedValues": [ { "code": "Stage 1 Initiation/ Pre-feasibility", "name": "Stage 1 Initiation/ Pre-feasibility" }, { "code": "Stage 2 Concept/ Feasibility", "name": "Stage 2 Concept/ Feasibility" }, { "code": "Stage 3 Design Development", "name": "Stage 3 Design Development" }, { "code": "Stage 4 Design Documentation", "name": "Stage 4 Design Documentation" }, { "code": "Stage 5 Works", "name": "Stage 5 Works" }, { "code": "Stage 6 Handover", "name": "Stage 6 Handover" }, { "code": "Stage 6a Design documentation (Production information)", "name": "Stage 6a Design documentation (Production information)" }, { "code": "Stage 7 Close out", "name": "Stage 7 Close out" }, { "code": "Packaged Programme", "name": "Packaged Programme" }, { "code": "Other- Programme / Project Administration", "name": "Other- Programme / Project Administration" } ] }, "name": "idms_finding_status", "length": 255, "alias": "IDMS gate Status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "outcome", "length": 255, "alias": "Outcome", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "overall_scoring", "alias": "Scoring", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assesment_outcome", "length": 255, "alias": "Assesment Outcome", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assessment_status", "length": 255, "alias": "Assessment Status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "assessment_date", "length": 29, "alias": "Assessment Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assessment_location", "length": 255, "alias": "Assessment Location", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_ad3cf5325e984287b36d9a8d0c0a0074_cvd_term_onhold_1_1", "type": "codedValue", "codedValues": [ { "code": "in_progress", "name": "In Progress" }, { "code": "terminated", "name": "Terminated" }, { "code": "on_hold", "name": "On Hold" }, { "code": "completed", "name": "Completed" } ] }, "name": "term_onhold", "length": 255, "alias": "Is the project:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_statuso", "length": 255, "alias": "Reason for the project to be", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": true, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": false, "indexes": [ { "name": "a1151_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true }, { "name": "r1501_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_1501", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "GUIDFormat": "O", "minScale": 0, "hasAttachments": true, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "allowUpdateWithoutMValues": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Sync,Uploads", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "propagateVisibleFields": true, "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 255, 255, 0, 255 ], "width": 1 }, "color": [ 255, 0, 0, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "description": "Survey Data Locations", "label": "Infrastructure Projects Assessment Tool", "type": "simple" }, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true } ] }