PROR, PRTA, PRAD MSCOA Project Details

Slide Note

This document provides a detailed overview of PROR, PRTA, and PRAD MSCOA project files from October 30, 2017, presented by Elsab Rossouw. It includes information on the status of PROR submissions, schedule of submissions, original budgets, financial years, provinces, and more. Additionally, it presents the status of PROR submissions specifically for Gauteng and segment analysis related to MSCOA projects in the province.

naer611 Follow

Uploaded on Mar 15, 2025 | 0 Views

Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.

Download Presentation

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.

E N D

Presentation Transcript

PROR / PRTA / PRAD mSCOA Project detail files 30 October 2017 Presented by Elsab Rossouw

Status of PROR submissions Status of Schedule of Submissions PROR Project Details Original Budget Financial Year Province Province Code Submitted/ Successfull Submitted/ with Errors Pending Total Submitted/ Successful l 2018 2018 2018 2018 2018 2018 2018 2018 2018 TOTAL 2018 EASTERN CAPE FREE STATE GAUTENG KWAZULU-NATAL KZ LIMPOPO MPUMALANGA NORTH WEST NORTHERN CAPE WESTERN CAPE EC FS GT 18 13 7 51 22 14 11 12 16 164 12 5 2 2 0 3 4 6 5 39 9 5 2 1 5 3 7 39 23 11 54 27 20 22 31 30 257 46.15% 56.52% 63.64% 94.44% 81.48% 70.00% 50.00% 38.71% 53.33% 63.81% LP MP NW NC WC 13 9 54 6 6

Status of PROR submissions for Gauteng Status of Schedule of Submissions Date of Last Submission Successful Submission Demarcation Demarc DescriptionCode Non Financial Data Location Level Selected: Province(s): GT Province : GAUTENG ( GT ) City Of Johannesburg JHB H Financial Submission Year Code Status of Schedule Version of Last SCOA Version CAP Due Date Alert Date 2018 PROR Project Details Original Budget 2017/07/14 2017/03/31 Submitted/Successful 2017/10/24 1 6.1 City Of Tshwane TSH H 2018 PROR Project Details Original Budget 2017/07/14 2017/03/31 Submitted/Successful 2017/09/11 1 6.1 Ekurhuleni Metro EKU H 2018 PROR Project Details Original Budget 2017/07/14 2017/03/31 Submitted/Successful 2017/10/10 1 6.1 Emfuleni GT421 H 2018 PROR Project Details Original Budget 2017/07/14 2017/03/31 Submitted/Successful 2017/09/05 1 6.1 Lesedi GT423 M 2018 PROR Project Details Original Budget 2017/07/14 2017/03/31 Pending 6.1 Merafong CityGT484 H 2018 PROR Project Details Original Budget 2017/07/14 2017/03/31 Submitted/with Errors 2017/08/14 1 6.1 Midvaal GT422 M 2018 PROR Project Details Original Budget 2017/07/14 2017/03/31 Submitted/Successful 2017/09/29 1 6.1 Mogale City GT481 H 2018 PROR Project Details Original Budget 2017/07/14 2017/03/31 Pending 6.1 Rand West City GT485 M 2018 PROR Project Details Original Budget 2017/07/14 2017/03/31 Submitted/Successful 2017/09/29 1 6.1 Sedibeng DC42 M 2018 PROR Project Details Original Budget 2017/07/14 2017/03/31 Submitted/Successful 2017/09/04 1 6.1 West Rand DC48 M 2018 PROR Project Details Original Budget 2017/07/14 2017/03/31 Submitted/with Errors 2017/10/16 1 6.1 SCRSCH02 Page 1 Printed on 27/10/2017 13.39.32 By 1480 7 7

PROR Segment analysis MSCOA - No matching of ProjectCode/Seq no between Financial and IDP data set for Original Budget Demarcation Description Location Level Selected: Province(s): GT Province : GAUTENG ( GT ) Demarc Code CAP No of projects No of IDP lines No of projects MTSF errors IUDF errors City Of Johannesburg City Of Tshwane Ekurhuleni Metro Emfuleni Lesedi Merafong City Midvaal Mogale City Rand West City Sedibeng West Rand JHB TSH EKU GT421 GT423 GT484 GT422 GT481 GT485 DC42 DC48 H H H H M H M H M M M 21204 1057 965 233 164 21204 8793 1012 532 0 16586 7981 17434 3575 569 0 0 1 1 417 280 0 0 164 89 0 0 0 0 89 255 97 40 30 259 0 153 203 0 97 8 0 8 0 0 32 31 0 18 24 0 14 17 0 8 8 8

West Rand DM Projects in ORGB MSCOA - Project finanical data for Original Budget FIN Log ID 8582 DEMARCA TIONCOD E DC48 West Rand 2018 PC001002006001000000000000000000000000 Demarcati on Name FINANCIA LYEAR PROJECTCODE Account Name PROJECT_SEQ Capital:Infrastructure:New:Roads Infrastructure:Roads Capital:Non- infrastructure:Existing:Upgrading:Furniture and Office Equipment Default Transactions 3 PC002002002005000000000000000000000000 1 PD000000000000000000000000000000000000 PO002000000000000000000000000000000000 Operational:Municipal Running Cost PO003001001000000000000000000000000000 Operational:Typical Work Streams:Agricultural:Assistance and Support Operational:Typical Work Streams:AIDS/HIV, Tuberculosis and Cancer:Support and Distribution Programmes:Aids/HIV Operational:Typical Work Streams:Expanded Public Works Programme:Project Operational:Non- infrastructure:Existing:Upgrading:Libraries 1 PO003002002001000000000000000000000000 1 PO003016001000000000000000000000000000 1 PO005002002011000000000000000000000000 1 9 9

West Rand DM PROR Data Upload Log Summary Demarcati on Descriptio n Location Level Selected: Municipality: DC48 Province : GAUTENG( GT) West Rand 8653 Physical Row Count % Valid Date Uploaded Log Entry Status Records Log ID Upload Source File Name Log File Message DC48_2018_PROR_20170731T173818RO N.TXT DC48_2018_PROR_G_20171016T175502 Z_C_NT.TXT 2017/10/11 ABORTED ERR: Wrong File Type (Filename must contain _G_ or _L_) ERR: Some records had errors and were rejected 2017/10/16 SOME 8 87.50% 8832 INVALID 10 10

Rand West City PROR segment analysis MSCOA - Projects without IDP data for Original Budget Fin Log ID 8389IDP Log ID 8390 DEMARCA TIONCOD E Name LYEAR GT485 Rand West City 2018 PC001001001006001000000000000000000000 Demarcation FINANCIA PROJECT _SEQ IDP_LOGI PROJECTCODE D FIN_LOGID ERROR_MSG 0 8389 No IDP data 4 6 0 8389 No IDP data PC001001002005004000000000000000000000 1 0 8389 No IDP data PC001002004008000000000000000000000000 2 0 8389 No IDP data PC001002006001000000000000000000000000 6 0 8389 No IDP data 7 0 8389 No IDP data PD000000000000000000000000000000000000 0 8389 No IDP data PO002000000000000000000000000000000000 0 8389 No IDP data 11 11

MSCOA - MTSF error for Original Budget IDP Log ID 8390 DEMA RCATI ONCO DE AR PROJECTCODE Account Name GT485 2018 PC0010010020050 0400000000000000 0000000 FINAN CIALYE MTSF_SE RVICE_O UTCOME MTSF_DESC 8 Sustainable human settlements and improved quality of household life PROJECT _SEQ 3 MAP_MTS F_CODE MAP_MTSF_DESC 6 An efficient, competitive and responsive economic infrastructure network OWN_STRATEGIC _OBJECTIVES To ensure the provision of basic services to build sustainable and safe communities To ensure the provision of basic services to build sustainable and safe communities To ensure the provision of basic services to build sustainable and safe communities To ensure the provision of basic services to build sustainable and safe communities To promote integrated sustainable development planning for the future INDIVIDUAL_PROJE CTS Outfall Sewers: Rehabilitation of Sewer Networks in Mohlakeng and Toekomsrus Capital:Infrastructure:Existing :Upgrading:Sanitation Infrastructure:Outfall Sewers PC0010010020060 0300000000000000 0000000 Capital:Infrastructure:Existing :Upgrading:Roads Infrastructure:Road Furniture 1 8 Sustainable human settlements and improved quality of household life 6 An efficient, competitive and responsive economic infrastructure network Upgrading and refurbishment street lights: Greater Westonaria PC0010010020070 0200000000000000 0000000 Capital:Infrastructure:Existing :Upgrading:Storm water Infrastructure:Storm water Conveyance 1 8 Sustainable human settlements and improved quality of household life 6 An efficient, competitive and responsive economic infrastructure network Storm water Conveyance: Upgrading of storm water Mohlakeng and Toekonsrus MV Substations: Borwa Substation PC0010020010050 0000000000000000 0000000 Capital:Infrastructure:New:El ectrical Infrastructure:MV Substations 1 8 Sustainable human settlements and improved quality of household life 6 An efficient, competitive and responsive economic infrastructure network PC0010020020010 0000000000000000 0000000 Capital:Infrastructure:New:So lid Waste Infrastructure:Landfill Sites 2 10 Protect and enhance our environmental assets and natural resources 6 An efficient, competitive and responsive economic infrastructure network Landfill Sites: Libanon Landfill Site - Construction of waste processing plant (Phase 2) Pump Station: Glenharvie Alternate Pump Supply pipeline construction PC0010020040040 0000000000000000 0000000 Capital:Infrastructure:New:W ater Supply Infrastructure:Pump Station 1 8 Sustainable human settlements and improved quality of household life 6 An efficient, competitive and responsive economic infrastructure network To ensure the provision of basic services to build sustainable and safe communities 12 12

Layout of the PROR file Text file Pipe separated Contents Demarcation Code Financial Year (END) Budget type (PROR -> ORGB) (PRTA -> TABB) (PRAD -> ADJB) Project guid including extension (all projects including non-broken down) MTSF Service Delivery Outcomes codes (01 14) IUDF Integrated Development Framework codes(01 04) Own Strategic Objective (250) Own Project description (250) Location GPS coordinates Longitude and Latitude in decimals (delimit by pipe) No duplicates (fields 1 4)

PC0010020060020 0000000000000000 0000000 Capital:Infrastructure:New:Ro ads Infrastructure:Road Structures 1 8 Sustainable human settlements and improved quality of household life 6 An efficient, competitive and responsive economic infrastructure network To ensure the provision of basic services to build sustainable and safe communities To provide democratic clean and accountable government for sustainable local communities To ensure the provision of basic services to build sustainable and safe communities New highmast lights: Zuurbekom PC0010020090010 0000000000000000 0000000 Capital:Infrastructure:New:Inf ormation and Communication Infrastructure:Data Centres 3 9 Responsive, accountable, effective and efficient local government 6 An efficient, competitive and responsive economic infrastructure network Data Centres: Installation of security system PC0020020010020 0200200000000000 0000000 Capital:Non- infrastructure:Existing:Rene wal:Community Assets:Sport and Recreation Facilities:Outdoor Facilities 5 12 An efficient, effective and development- oriented public service 2 A long and healthy life for all South Africans Outdoor Facilities: Construction of Toekomsrus Stadium PC0020030020010 1000000000000000 0000000 Capital:Non- infrastructure:New:Communit y Assets:Community Facilities:Libraries 1 8 Sustainable human settlements and improved quality of household life 1 Quality basic education To ensure the Dual purpose Library:Bekkersdal provision of basic services to build sustainable and safe communities To ensure the provision of basic services to build sustainable and safe communities To ensure the provision of basic services to build sustainable and safe communities Conduct SMME Trade investment and Industrial Development PC0020030020010 1100000000000000 0000000 Capital:Non- infrastructure:New:Communit y Assets:Community Facilities:Cemeteries/Cremato ria Capital:Non- infrastructure:New:Communit y Assets:Sport and Recreation Facilities:Outdoor Facilities Capital:Non- infrastructure:New:Other Assets:Operational Buildings:Manufacturing Plant 1 8 Sustainable human settlements and improved quality of household life 13 A comprehensive, responsive and sustainable social protection system Cemeteries/Crematoria: Development of Cemeteries PC0020030020020 0200000000000000 0000000 3 12 An efficient, effective and development- oriented public service 2 A long and healthy life for all South Africans Outdoor Facilities: Construction of Toekomsrus Stadium PC0020030030010 0900000000000000 0000000 1 7 Vibrant, equitable, sustainable rural communities contributing towards food security for all Responsive, accountable, effective and efficient local government 12 An efficient, effective and development- oriented public service Manufacturing Plant: Elandsfontein food production units PO0030170030000 0000000000000000 0000000 Operational:Typical Work Streams:Functions and Events:Events and Organisations 1 9 12 An efficient, effective and development- oriented public service To ensure the provision of basic services to build sustainable and safe communities Events and Organisations: Events 14 14

MSCOA - IUDF error for Original Budget IDP Log ID 8390 DEMA RCATI ONCO DE R CODE GT485 2018 PC0010010 010060010 000000000 000000000 00 FINANC IALYEA PROJECT PROJEC T_SEQ 1 IUDF_DE SC Growth MAP_IUDF _CODE 2 MAP_IUDF _DESC Inclusion and access OWN_STRATEGIC_OB JECTIVES To ensure the provision of basic services to build sustainable and safe communities INDIVIDUAL_PROJEC TS Rehabilitation of Roads in Mohlakeng and Toekomsrus: Phase 4 Account Name Capital:Infrastructure:Existing:Re newal:Roads Infrastructure:Roads IUDF 3 2 3 Growth 2 Inclusion and access To ensure the provision of basic services to build sustainable and safe communities To ensure the provision of basic services to build sustainable and safe communities To ensure the provision of basic services to build sustainable and safe communities Roads: Roads in Zuurbekom (Phase 2) 5 3 Growth 2 Inclusion and access Roads: Westonaria Cemetery Access Road PC0010010 020050040 000000000 000000000 00 PC0010010 020060030 000000000 000000000 00 PC0010010 020070020 000000000 000000000 00 PC0010020 020010000 000000000 000000000 00 Capital:Infrastructure:Existing:Up grading:Sanitation Infrastructure:Outfall Sewers 3 3 Growth 2 Inclusion and access Outfall Sewers: Rehabilitation of Sewer Networks in Mohlakeng and Toekomsrus Capital:Infrastructure:Existing:Up grading:Roads Infrastructure:Road Furniture 1 3 Growth 2 Inclusion and access To ensure the provision of basic services to build sustainable and safe communities Upgrading and refurbishment street lights: Greater Westonaria Capital:Infrastructure:Existing:Up grading:Storm water Infrastructure:Storm water Conveyance 1 3 Growth 2 Inclusion and access To ensure the provision of basic services to build sustainable and safe communities Storm water Conveyance: Upgrading of storm water Mohlakeng and Toekonsrus Landfill Sites: Libanon Landfill Site - Construction of waste processing plant (Phase 2) Capital:Infrastructure:New:Solid Waste Infrastructure:Landfill Sites 2 1 Spatial integration 3 Growth To promote integrated sustainable development planning for the future 15 15

MTSF choices 01 - Quality basic education 02 - A long and healthy life for all South Africans 03 - All people in South Africa are and feel safe 04 - Decent employment through inclusive growth 05 - A skilled and capable workforce to support an inclusive growth path 06 - An efficient, competitive and responsive economic infrastructure network 07 - Vibrant, equitable, sustainable rural communities contributing towards food security for all 08 - Sustainable human settlements and improved quality of household life 09 - Responsive, accountable, effective and efficient local government 10 - Protect and enhance our environmental assets and natural resources 11 - Create a better South Africa and contribute to a better Africa and a better world 12 - An efficient, effective and development-oriented public service 13 - A comprehensive, responsive and sustainable social protection system 14 - A diverse, socially cohesive society with a common national identity

IUDF choices 01 - Spatial integration 02 - Inclusion and access 03 - Growth 04 - Governance

Capital projects - Infrastructure IUDF : 02 Inclusion and access MTSF : 06 An efficient, competitive and responsive economic infrastructure network 18 18