Insights on mSCOA Stress Test and Data Formatting Issues
The presented content delves into the mSCOA Stress Test results and data string formatting challenges. Learn about the successful data submission process, errors encountered, and guidelines for reporting transactions. Additionally, find details on additional formatting requirements for project segments. Explore the importance of adhering to set guidelines and avoiding common format issues. Gain valuable insights for efficient data handling.
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.
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
mSCOA Data Strings Presented by : Trevor Chetty
mSCOA Stress Test LgPortal Stress Test Participants were invited to submit datastrings. 53 files uploaded in two hours 27 files progressed from the portal to the LgDatabase after successful validation Response emails were sent out an reached municipalities within 5 minutes The platform was stable and the infrastructure capacity was sufficient Errors: Upper Case Guids Mismatch of Financial periods Mismatch of file Types Mismatch of Demarcation Codes 2 2
mSCOA Additional Format Project Segment The projects that require further breakdown must be reported as follows: Parent Guid_Municipal specific sequential project number Eg. 63348e37-464e-4ac0-a13a-e577838ff961_00001 The sequential number has to be a five digit number 3 3
mSCOA Data String Important Data String Format Issues: No Headings allowed No Decimals allowed Guids: Lower case Period must include: ITY1 ITY2 TABB TM01 TM02 TM03 TM04 TM05 TM06 TM07 TM08 TM09 TM10 TM11 4 4
mSCOA DataString Verification of Transactions: No reporting allowed on levels lower than breakdown required level for segments other than the project segment. You are required to roll up to the breakdown required level for these segments. If lower levels are submitted for any segment other that the project segment the file WILL BE REJECTED 5 5
Questions 6 6