2011 LSC GAR Module
From PikaDocs
Pika Software has developed a module that adds the features needed to comply with the reporting requirement changes in LSC Grant Activity Reports (GAR). The GAR module is available in patch form to allow LSC-funded programs to update their existing Pika CMS sites in place. The GAR module is also incorporated into the current release of Pika CMS for the convenience of LSC-funded programs.
| Table of contents |
Executive Summary
What changes will I see on my Pika CMS screens?
New Form G-2 Report
Add a new Pika report titled "LSC Form G-2” which tallies the number of Persons in Households Served and the number of LSC funded cases that have the Domestic Violence checkbox checked.
Age Race Report
Update the LSC Age Race report to include the count of Veteran and Non-Veteran cases according to the new revisions.
Other Matters Report
Remove Tables 1b, 1c, 2b, 3b, 4, 5 and 6a-c from the LSC Other Matters report.
Other Matters codes 131-159 will be deleted from the Other Matters menu, since they have been removed from the LSC reporting requirements. Additionally, the report and data entry screens will be renamed from "LSC Other Matters" to "LSC Other Services”.
Eligibility tab on the Case Screen
Add a “Domestic Violence?” and "Veteran in Household?" field to the Eligibility Case Tab screen.
LSC Other Services data entry screen
Remove the Media Printings/Airings and Problem Code field from the LSC Other Services entry screen, since the information in these fields is no longer included in the report.
For IT Staff
Database Schema Change
The database table “menu_lsc_other_matters” is renamed to “menu_lsc_other_services” by the GAR patch. If your program is using the “menu_lsc_other_matters” table in a third party app like MS Access or Crystal Reports, your reports will need to be modified to point at the new table name.
The "om_code" column on the "activities" table was *not* renamed to "os_code" because the "activities" table is heavily used when running third party report tools. We decided it was not worth the disruption to users and left the column name as is.
Patch Installation Instructions
- Make a backup of your Pika CMS. Verify the the backup ran correctly, in case you need to roll things back to their previous state.
- Download the 2011 GAR module from http://pikasoftware.com/files/releases/lsc_2011_gar_module.zip
- Right click on the downloaded file and select "Extract All.." to unzip its contents. It'll extract to a folder named "lsc_2011_gar_module".
- Open the "2011_lsc_gar_module".
- Copy the "lsc_household" and "lsc_services" folders in the "reports" folder to the "reports" folder on your Pika site.
- Copy the file "report.php" in the "lsc_ar" folder to the "reports/lsc_ar" folder on your Pika site. This will overwrite an existing file.
- Copy the three files in the "subtemplates" folder to the "subtemplates" folder on your Pika site. This will overwrite three existing files. Additionally, if you have customized any of the three template files that have changed, you'll need to manually merge the changes into your custom template files in "sitename-custom/subtemplates".
- Log into MySQL.
- Run the file in the "sql" folder on the database that houses your Pika CMS data. This operation may take 10 or 20 minutes to run if you have a very large (100,000+ records) cases table.
- The installation is now complete!
