After the data and map processing activities, the Provincial Focal Person and his/her alternates should validate the works of the data and map data processors. This section discusses the validation checks to be done by the data processing supervisors.
7.1 Generation of Error List in the DPS for the CBMS Form 2
After receiving the data files processed by the DPs in the DPS, the PFP or his/her alternates should perform a validation check by generating the error list using the DPS. The following are the step-by-step procedures in generating the error list:
- Log in to the CBMS Data Processing System using the provided credentials.
- Go to the Data Validation module on the left-hand side of your screen. Click the Consistency Check tab.
- Right-click on the EA you want to generate the error list from. Then, click the Validate Form 2/HPQ from the select list.
- A prompt will appear asking to “Confirm Self Assignment?”. Click Yes.
- CSEntry app will open. A prompt will appear saying, “Running Data Validation Program. Please wait.”. Press F8 to clear.
- Wait for the 2nd prompt saying, “Reading error list completed!”. Then, press F8 again to clear.
- The error list will appear.
Check the error list, if there are justifications and assess if they are acceptable or not. If there are still too many inconsistencies, reassign to the data processor. Otherwise, PFP to address inconsistencies if there are only a few. - Click the maximize (+) button to see additional details.
- Click the specific error listed that you want to check or edit. You will be redirected to the specific data item to validate.
- Press F12 and click Yes to save your edits by data item. Always save after every edit.
- The CSentry will close. Repeat steps 2 to 10 until all errors are addressed.
Evaluate the items in the error list. Refer to the justifications provided by the assigned DP. If there are items that still need to be addressed, return the workload to the DP together with the feedback/observations noted. Otherwise, proceed to generate the After-Edits List of Cases with Inconsistencies for the CBMS Form 2 and Form 3.
7.2 Generation of the After-Edits List of Cases with Inconsistencies for the CBMS Form 2 and Form 3
- Launch the RCBMS app.
- Click ⚙️ (Settings) and then toggle ON the Run after-edit checks button. Make sure that the After-edit data folder is not empty, which located at:
C:\PSA SYSTEMS\FOLDER\CBMS-ROLLOUT\HPQ\EDITED. - You may load the justification file (discussed in the previous chapter) and toggle ON the Include justifications button. Make sure to save the justification file (Excel) in the specified directory at C:\rcbms\references and rename it to justification.xlsx. You may also modify the default path from the configuration settings if you prefer.
- Click on the Load Data (Data Loaded) action button to extract the data files from the DPS.
You will be prompted with a confirmation message if you have previously loaded the data files. Just click Proceed to continue. - Click the Generate Cases with Inconsistencies action button.
Check if the remaining inconsistencies are justified using the excel file submitted by the DPs. If there are items that still need to be addressed, return the workload to the DP together with the feedback/observations noted. Otherwise, proceed to generate the after-edits marginal, consistency and output tables for the CBMS Form 2.
7.3 Generation of After-Edits Marginals, Consistency and Output Tables for the CBMS Form 2
After the data files have been processed by the DPs and MDPs, the PFP shall generate after-edit marginal, consistency, and output tables, and check if the previously noted observations and inconsistencies are addressed.
The procedures in generating these tables can be found in Chapter 4 of this manual, specifically Section 4.5.2.
7.4 Generating and Analyzing Marginal Tables for Form 4
Since the Form 4s were administered via CAWI, the approach in generating marginal tables for Form 4 differs from that of generating marginal tables for Form 2. In generating marginal tables for Form 4, the PFP shall make use of his/her CBMS MIS account. ISA/SS II may assist the PFP in this specific step in the process. The RFP can simultaneously generate and analyze the marginal tables for Form 4, and give feedback to the PFP on his/her findings.
- RFP/PFP is to log in using his/her credentials in the CBMS MIS account at https://cbms.psa.gov.ph/MIS.
- On the menu, select REPORTS. Click the BPQ REPORT tab.
- Select region, province, city/municipality, and barangay. Click the GENERATE MARGINAL REPORT button.
- An excel file will automatically be downloaded.
- Prepare a PSA desktop PC1. Create a new folder. For brevity, we will call this the 2022 CBMS – Form 4 (Marginal Tables).
- Save the downloaded Excel file in the 2022 CBMS – Form 4 (Marginal Tables) folder. Follow this naming convention:
CBMS Form 4 Marginal Tables <space> <city/mun name>,<space> <province name><space>(DD MMM YY)
e.g., CBMS Form 4 Marginal Tables Samal, Bataan (11 Nov 22) - Open the Excel file [e.g., CBMS Form 4 Marginal Tables Samal, Bataan (11 Nov 22)]. The file should appear somewhat like this.
- Study the marginal tables. Check the total number of frequencies. The box should contain the total number of barangays in the city/municipality.
- Check the frequency of the answer categories. Some may have questionable data. Some information can be accepted.
- Check Out of Range, Blank, Undefined, and Others, Specify. Check the number indicated in the box. In the After edit column, these categories should indicate “0”, unless reason/justification are provided by the DP.
- Check/evaluate the marginal tables. This can be found by clicking the next sheets of the file.
RFPs/PFPs are requested to use their strong intuition and analytic skills to evaluate the tables being generated. Save the file after evaluating the marginal tables. Existing information and statistics at the provincial level can be used as a basis in detecting unusual findings.
Information available in the PSO/RSSO such as the barangay profile of the city/municipality based on census results can be used for this purpose.
If RFP has findings, the RFP shall provide his/her observations to PFP via email, copy furnished the RD, CSS of Statistical Operations and Coordination Division, and the CSS of PSO. The PFP shall then consolidate the gathered observations and provide instructions to ISA/SA/SS/DP who are assigned to assist him/her.
7.5 Consolidation of Justifications
The PFP and his/her alternates should consolidate the justifications submitted by the processors by city/municipality. This is to be submitted to the CSS of the PSO for his/her reference in certifying the clean data files and eventually be uploaded in the MIS.
Prepare an excel file for every city/municipality. This file shall contain three sheets namely: Summary, Cases with Inconsistencies, and Error List Justification.
- Summary - reflects information on remaining cases with inconsistencies such as the total number of inconsistencies and the distribution by section, priority level and type of inconsistency
- Cases with Inconsistencies - lists down the cases with inconsistencies with their statuses and justifications
- Error List Justification - displays the remaining items in the error list with their justifications