View In:   ArcGIS Online Map Viewer

Name: Infrastructure_Projects_Assessment_Tool

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 70401fc9f9d94f22aaba4967b2ad2616

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [255, 0, 0, 255]
Size: 8.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[255, 255, 0, 255] Width: 1
Label: Infrastructure Projects Assessment Tool
Description: Survey Data Locations
Transparency: 0
Labeling Info:

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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• uniquerowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: RowID, type: esriFieldTypeGUID )
• project_name1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Name, type: esriFieldTypeString )
• project_number ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Number, type: esriFieldTypeString )
• project_id ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project ID, type: esriFieldTypeString )
• project_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Type, type: esriFieldTypeString )
• physical_address ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Physical Address, type: esriFieldTypeString )
• latitude ( nullable: true, editable: true, defaultValue: null, alias: GPS Coordinates Latitude, type: esriFieldTypeDouble )
• longitude ( nullable: true, editable: true, defaultValue: null, alias: GPS Coordinates Longitude, type: esriFieldTypeDouble )
• sector ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Sector, type: esriFieldTypeString )
• dept ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Department, type: esriFieldTypeString )
• district_municipality ( nullable: true, editable: true, defaultValue: null, length: 255, alias: District Municipality, type: esriFieldTypeString , Coded Values: [Amajuba: Amajuba] , [Ethekwini: Ethekwini] , [Harry Gwala: Harry Gwala] , ...8 more... )
• local_municipality ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Local Municipality, type: esriFieldTypeString )
• ward_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Ward No, type: esriFieldTypeString )
• project_sponsor ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Sponsor, type: esriFieldTypeString )
• project_manager ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Manager, type: esriFieldTypeString )
• contact_number ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Contact Numbers, type: esriFieldTypeString )
• email_add ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Email, type: esriFieldTypeString )
• project_idms_gate ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Please verify if the Project IDMS Gate is correctProject IDMS Gate, type: esriFieldTypeString , Coded Values: [Stage 1 Initiation/ Pre-feasibility: Stage 1 Initiation/ Pre-feasibility] , [Stage 2 Concept/ Feasibility: Stage 2 Concept/ Feasibility] , [Stage 3 Design Development: Stage 3 Design Development] , ...7 more... )
• project_status ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Please verify if the Project Status is correctProject Status, type: esriFieldTypeString )
• emoji ( nullable: true, editable: true, defaultValue: null, length: 255, alias: emoji, type: esriFieldTypeString )
• project_idms_index ( nullable: true, editable: true, defaultValue: null, length: 255, alias: project_idms_index, type: esriFieldTypeString )
• project_status_index ( nullable: true, editable: true, defaultValue: null, length: 255, alias: project_status_index, type: esriFieldTypeString )
• completion_pstate ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Percentage Stage of Completion, type: esriFieldTypeString )
• estimated_budget ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Estimated Project Budget, type: esriFieldTypeString )
• expenditure_to_date ( nullable: true, editable: true, defaultValue: null, alias: Project Expenditure to date, type: esriFieldTypeInteger )
• variation_to_date ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Variation to date, type: esriFieldTypeString )
• pstart_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Project Start Date, type: esriFieldTypeDate )
• ecompletion_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Estimated Completion Date, type: esriFieldTypeDate )
• total_cost ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Total Project Cost, type: esriFieldTypeString )
• subconstraint ( nullable: true, editable: true, defaultValue: null, length: 255, alias: subconstraint, type: esriFieldTypeString )
• warn_sign ( nullable: true, editable: true, defaultValue: null, length: 255, alias: The Project Status not aligned with IDMS gate, type: esriFieldTypeString )
• created_jobs ( nullable: true, editable: true, defaultValue: null, alias: Number of jobs created (all combined), type: esriFieldTypeInteger )
• youth_employed ( nullable: true, editable: true, defaultValue: null, alias: Number of youth employed, type: esriFieldTypeInteger )
• women_employed ( nullable: true, editable: true, defaultValue: null, alias: Number of women employed, type: esriFieldTypeInteger )
• pwds_employed ( nullable: true, editable: true, defaultValue: null, alias: Number of Person With Disabilities employed, type: esriFieldTypeInteger )
• employment_period ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Average employment period, type: esriFieldTypeString )
• minimum_wage ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Minimum wage, type: esriFieldTypeString )
• trained_peoples ( nullable: true, editable: true, defaultValue: null, alias: Number of people trained (skills), type: esriFieldTypeInteger )
• trained_people_hiv_aids ( nullable: true, editable: true, defaultValue: null, alias: Number of people trained (HIV/AIDS), type: esriFieldTypeInteger )
• assesment_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date of Assessment, type: esriFieldTypeDate )
• assesment_completd_by ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Assessment Completed By, type: esriFieldTypeString )
• pn ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Names, type: esriFieldTypeString )
• pawlmdm ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Details, type: esriFieldTypeString )
• status1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: status1, type: esriFieldTypeString )
• rel_choice_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: Updated IAMP approved. Strategic Programme Briefs not updated] , [major: IAMP and Strategic Programme Briefs not updated] , [critical: IAMP and Strategic Programme Briefs not updated and approved] )
• coment_spb ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_idont ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: I am not the Project Manager] , [major: I am the Project Manager, I'm not sure] , [critical: I am the Project Manager. I don't have the project history.] )
• coment_spb_idont ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• gate_changed ( nullable: true, editable: true, defaultValue: null, length: 255, alias: gate_changed, type: esriFieldTypeString )
• status_quest2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: status_quest2, type: esriFieldTypeString )
• rel_choice_nopsdf ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: The project, not IAMP, aligns with the PSDF] , [major: The IAMP does not align with the PSDF] , [critical: The project does not align with the IAMP and PSDF] )
• comment_psdf ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_i_dont_know ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: I am not the Project Manager] , [major: I am the Project Manager, I'm not sure] , [critical: I am the Project Manager. I don't have the project history.] )
• comment_psdf_idont ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• status_quest3 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: status_quest3, type: esriFieldTypeString )
• rel_choice_noips ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: Submission to Provincial Treasury is late] , [major: Approved IPMP and IPS not updated] , [critical: IPMP and IPS not updated and approved] )
• comment_ips ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_idont_ips ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: I am not the Project Manager] , [major: I am the Project Manager, I'm not sure] , [critical: I am the Project Manager. I don't have the project history.] )
• comment_idont_know_ips ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• status_4 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 4. Does the infrastructure project has an approved Project Charter?, type: esriFieldTypeString )
• rel_choice_nopc ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: Project has an approved Project Charter; however, IPMP and IPS submission to Provincial Treasury is late] , [major: Project has an approved Project Charter which is not informed by an approved and updated IPMP and IPS] , [critical: Project does not have an approved Project Charter] )
• comment_pc ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_idont_pc ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: I am not the Project Manager] , [major: I am the Project Manager, I'm not sure] , [critical: I am the Project Manager. I don't have the project history.] )
• comment_idont_know_pc ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• status_5 ( nullable: true, editable: true, defaultValue: null, 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 )
• rel_choice_nopi ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: Project has an approved Project plan; however, IPMP and IPS submission to Provincial Treasury is late] , [major: Project has an approved Project plan which is not informed by an approved and updated IPMP and IPS] , [critical: Project does not have an approved Project plan] )
• comment_pi ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_idont_pi ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: I am not the Project Manager] , [major: I am the Project Manager, I'm not sure] , [critical: I am the Project Manager. I don't have the project history.] )
• comment_idont_know_pi ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• status_6 ( nullable: true, editable: true, defaultValue: null, 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 )
• rel_choice_nogrt ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: The Stage 2 Gateway Review was conducted, and Gateway Review Team was properly constituted but approved report not issued] , [major: The Stage 2 Gateway Review was conducted but Gateway Review Team is not constituted in terms of National Treasury IN3 of 2019/20] , [critical: The Stage 2 Gateway Review was conducted but a Gateway Review Team was not appointed or constituted] )
• comment_grt ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_idont_grt ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: I am not the Project Manager] , [major: I am the Project Manager, I'm not sure] , [critical: I am the Project Manager. I don't have the project history.] )
• comment_idont_know_grt ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• status_7 ( nullable: true, editable: true, defaultValue: null, 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 )
• rel_choice_nocfr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [critical: The Gateway Review Team was constituted in accordance with the requirement of the FIDPM for major capital projects.] )
• comment_cfr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_idont_cfr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: I am not the Project Manager] , [major: I am the Project Manager, I'm not sure] , [critical: I am the Project Manager. I don't have the project history.] )
• comment_idont_know_cfr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• status_8 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: status_8, type: esriFieldTypeString )
• rel_choice_nomcp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: 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.] , [major: The concept or feasibility report is approved, and critical gateway review findings addressed i.e. minor and major review findings remain in the report.] , [critical: The concept or feasibility report is not approved] )
• comment_mcp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_idont_mcp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: I am not the Project Manager] , [major: I am the Project Manager, I'm not sure] , [critical: I am the Project Manager. I don't have the project history.] )
• comment_idont_know_mcp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_no_irm ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [major: The infrastructure project Design Documentation Report is approved but the project plan is not updated] , [critical: The infrastructure project Design Development Report is not approved] )
• comment_irm ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_idont_irm ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: I am not the Project Manager] , [major: I am the Project Manager, I'm not sure] , [critical: I am the Project Manager. I don't have the project history.] )
• comment_idont_know_irm ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• statusplaceholder ( nullable: true, editable: true, defaultValue: null, length: 255, alias: statusplaceholder, type: esriFieldTypeString )
• rel_choice_no_idmsa ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [critical: The infrastructure project IRM project status does not reconcile to the IRM IDMS Gate] )
• comment_idmsa ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• comment_idont_know_idmsa ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• statusplaceholder11 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: statusplaceholder11, type: esriFieldTypeString )
• rel_choice_no_irm_ps ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [critical: The IDMS Gate for the infrastructure project is not correct as recorded and reported on IRM] )
• comment_irm_ps ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• statusplaceholder12 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: statusplaceholder12, type: esriFieldTypeString )
• rel_choice_no_irm_ps_ipa ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [critical: The infrastructure project IRM project status does not align and reconcile to the IRM IDMS Gate] )
• comment_irm_ps_ipa ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_no_sign_off ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: 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.] , [major: 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]] , [critical: 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.] )
• comment_sign_off ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_idont_sign_off ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: I am not the Project Manager] , [major: I am the Project Manager, I'm not sure] , [critical: I am the Project Manager. I don't have the project history.] )
• comment_idont_know_sign_off ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_no_upp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: The project timelines to date deviate from planned project timelines by 1% - 15% of project time.] , [major: The project timelines to date deviate from planned project timelines by 15% - 20% of project time.] , [critical: The project timelines to date deviate from planned project timelines by greater than 20% of project time.] )
• comment_upp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_idont_upp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: I am not the Project Manager] , [major: I am the Project Manager, I'm not sure] , [critical: I am the Project Manager. I don't have the project history.] )
• comment_idont_know_upp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_no_rec_exp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: The project expenditure to date reflects cost savings/underspending in relation to the planned project budget.] , [major: 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] , [critical: 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.] )
• comment_exp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_idont_rec_exp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: I am not the Project Manager] , [major: I am the Project Manager, I'm not sure] , [critical: I am the Project Manager. I don't have the project history.] )
• comment_idont_know_exp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_no_agsa ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [critical: 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.] )
• comment_agsa ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_idont_agsa ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: I am not the Project Manager] , [major: I am the Project Manager, I'm not sure] , [critical: I am the Project Manager. I don't have the project history.] )
• comment_idont_know_agsa ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_no_agsa_annual ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [critical: 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.] )
• comment_agsa_annual ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_idont_agsa_annual ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: I am not the Project Manager] , [major: I am the Project Manager, I'm not sure] , [critical: I am the Project Manager. I don't have the project history.] )
• comment_idont_know_agsa_annual ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_no_psi ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: 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] , [major: 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.] , [critical: Social impact indicators and targets are not planned for the project] )
• comment_psi ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_idont_psi ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: I am not the Project Manager] , [major: I am the Project Manager, I'm not sure] , [critical: I am the Project Manager. I don't have the project history.] )
• comment_idont_know_psi ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_capacit ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: The planned capacitation targets have not been achieved to date but are on target to be achieved at the end of the reporting period] , [major: 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.] , [critical: Planned indicators and targets for the capacitation for SMMEs are not planned for the project] )
• comment_capacit ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_idont_capacit ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: I am not the Project Manager] , [major: I am the Project Manager, I'm not sure] , [critical: I am the Project Manager. I don't have the project history.] )
• comment_idont_know_capacit ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_gate_review ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [major: A Stage 5 Gateway Review at 50% construction was not conducted.] )
• comment_review ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_idont_gate_review ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: I am not the Project Manager] , [major: I am the Project Manager, I'm not sure] , [critical: I am the Project Manager. I don't have the project history.] )
• comment_idont_know_review ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_gate_review100 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [critical: A Stage 5 Gateway Review at 99% construction was not conducted.] )
• comment_review100 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• rel_choice_idont_gate_review100 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select an applicable reason, type: esriFieldTypeString , Coded Values: [minor: I am not the Project Manager] , [major: I am the Project Manager, I'm not sure] , [critical: I am the Project Manager. I don't have the project history.] )
• comment_idont_know_review100 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
• idms_finding_status ( nullable: true, editable: true, defaultValue: null, length: 255, alias: IDMS gate Status, type: esriFieldTypeString , Coded Values: [Stage 1 Initiation/ Pre-feasibility: Stage 1 Initiation/ Pre-feasibility] , [Stage 2 Concept/ Feasibility: Stage 2 Concept/ Feasibility] , [Stage 3 Design Development: Stage 3 Design Development] , ...7 more... )
• outcome ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Outcome, type: esriFieldTypeString )
• overall_scoring ( nullable: true, editable: true, defaultValue: null, alias: Scoring, type: esriFieldTypeInteger )
• assesment_outcome ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Assesment Outcome, type: esriFieldTypeString )
• assessment_status ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Assessment Status, type: esriFieldTypeString )
• assessment_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Assessment Date, type: esriFieldTypeDate )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• assessment_location ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Assessment Location, type: esriFieldTypeString )
• term_onhold ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Is the project:, type: esriFieldTypeString , Coded Values: [in_progress: In Progress] , [terminated: Terminated] , [on_hold: On Hold] , ...1 more... )
• comment_statuso ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Reason for the project to be, type: esriFieldTypeString )

Templates:

• Name: New Feature
  Description:
  Prototype:
  Drawing Tool: N/A

Relationships:

• Infrastructure_Projects_Assessment_Tool_front_facing (0) -- Related To: front_facing (1)

Capabilities: Create,Editing,Sync,Uploads

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Ownership Based Access Control:

• Allow Others to Update: true
• Allow Others to Delete: true
• Allow Others to Query: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Apply Edits   Add Features   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata