HPRP Financial Report - v9 USER MANUAL - MSCCOC
Contents
1. Service Unique Client Providers Reporting information Count Count Client Count HPRP Test Provider 1 8560 HPRP Test Provider 2 8561 HPRP Test Provider 2 8562 0 HPRP Test Provider 4 8563 0 0 HPRP Test Provider 5 8570 0 0 2009 Bowman Systems LL C All Right Reserved ServicePoint and the ServicePoint logo are trademarks of Bowman Systems L L C All other brand or product names are trademarks or registered trademarks of their respective holders Bowman Systems Emai ART_Renorts SowmanSystems com httovivww bowmansystems com Diagram 9 Tab H Additional Information Diagram 9 This tab is provided as a reference to the user running the report and lists the parameters specified in the user prompts It also displays the number of service transactions by provider and the total number of clients by provider counted both by Client Uid and by Client Unique Id The Client Unique Id count indicates the de duplicated total Bowman Systems Page 7 of 12 0613 HPRP Financial Report ART Gallery Report v9 TECHNICAL NOTES 1 Inclusion In order for an expenditure to be properly included in this report the expenditure must be properly recorded in HMIS in conjunction for an HPRP Service Transaction including the specified Funding Source either Fund Source 1 or Fund Source 2 and a dollar amount Cost 1 or Cost 2 respectively Additionally most of the work flow elements and report requirements connected2. Funding Source HPRP Source 1 HH Id Client Unique Id Client Uid Service Uid Type of Expenditure StartDate Q GD s 326246 1502035 7n amp o 200 00 300 00 105846 326245 1502837 71608 200 00 300 00 not 040419301610453 338244 1802836 Renta assistance 716000 300 00 300 00 Household Total 900 00 900 00 1500430 Security deposits wano 50 00 60 00 colcoocconeseandoo 330729 1508430 Utiity payments aano 14 85 14 65 1500437 rity deposi aan so 405850 piocoocoomecosoo 320731 haee he ee td tae Rati 1506440 Utlity payments wane 1400 14 06 1508438 Securit m va 50 0 poi ocoocooops2obs00 239730 Secutiy deponis aano saan san 1500441 Utility payments wano 1405 14 65 Household Total 192 96 193 96 Rental assistance n500 sooo 400 00 ncs01022000mi61053 330243 Security deposits anaoa 0 00 180 00 Motel amp hotel vouchers enano 0 00 45 00 Motel amp hote vouchers aaoo 31 00 31 00 an Motel amp hote vouchers agog 31 00 31 00 Households aging 31 00 31 00 euconoosncesaoss10 330732 wong 31 00 31 00 aging 314823 148 23 aaoo 1200 00 1 300 00 aano se1oo 3811 09 Household Total 2 383 32 2 978 32 Grand Total 3 477 28 4 072 28 Diagram 5 Tab D Detail by Household Diagram 5 This tab contains a breakdown of expenditures sorted by the Service Household Id and displays Client Unique Id Client Uid Service Uid Expenditure Type Service Start Date Expenditure amount occurring during the current q
3. 09 Funding Source HPRP Source 1 Expenditure Type Motel amp hotel vouchers Client Uid HHid Serviceld StartDate End Date Provider ass GTD 326243 1506422 e600 6 17 09 HPRP Test Provider 1 8560 0 00 45 00 320732 1506442 aging ar10 09 HPRP Test Provider 1 8560 21 00 31 00 339732 1506443 wana anong HPRP Test Provider 1 8560 31 00 31 00 320732 1506444 wona a009 HPRP Test Provider 1 8560 31 00 31 00 339732 1506445 waa anaoa HPRP Test Provider 1 8560 31 00 31 00 Total for Motel amp hotel vouchers 124 00 169 00 Diagram 8 Tab G Detail by Expenditure Type Diagram 8 This tab contains a breakdown of expenditures sectioned by Type with each type of expenditure starting on a separate page of the sub report In addition to expenditure type the report displays Client Uid Household Uid if any Service Uid Service Start Date Service End Date Service Provider Expenditure amount occurring during the current quarter and Expenditure amount occurring within the date range of the grant to date Homelessness Prevention and Rapid Rehousing Program HPRP Quarterly Progress Report QPR Additional Information Enter Start Date of Quarter 7 109 Enter Start Date of Grant 4 1 08 Enter End Date of Quarter PLUS ONE DAY 10 1 08 Select Funding Source HPRP Source 1 HPRP Test Provider 1 8580 HPRP Test Provider 2 8561 Select Provider s HPRP Test Provider 3 8562 HPRP Test Provider 3 HPRP Test Provider 58570
4. are classified as Homeless Assistance or as Homeless Prevention based on their housing status at program entry there is no need to record the client s new housing status if it should change while the client is enrolled since this does not impact their status at entry 2 Service End Dates This report is designed according to HUD vendor instructions which identify on going services by the absence of a service end date Users should be aware that in some cases these un ended services may be the result of data entry omission errors rather than actual on going services and may therefore inflate the counts contained in this report For this reason un ended services should be monitored on an on going basis so that errors can be identified and corrected by supplying the proper service end dates In no case should the duration of a service transaction ever extend beyond the client s exit date since such a record would be clearly in non compliance with the data standards that require all services to include both a start date and an end date Bowman Systems Page 9 of 12 0613 HPRP Financial Report ART Gallery Report v9 3 Services Spanning Quarters When a single HPRP Financial Assistance service begins in one quarter and ends in another or continues throughout the subsequent quarter without ending the dollars connected with that service are recorded only in the first quarter and are excluded from any subsequent quarters This is necessary to
5. avoid overstating total grant expenditures If users desire to show the expenditures in both quarters the work flow will need involve the recording of a service in each of the quarters and splitting pro rating the connected dollars as appropriate between the two service transactions 4 Expenditure Type In the detail sections of this report HPRP Financial Assistance Activities and HPRP Housing Relocation amp Stabilization Services are combined into a single category referred to throughout the report as expenditure Type 5 Expenditure related data elements The detail sections of this report include several data elements connected with each expenditure Because of space limitations not all elements are included in all breakdowns sub reports These elements include e Expenditure amount e Service Provider e Service Uid e Client Uid e Client Unique Id e Whether the expenditure occurred during the current quarter e Whether the expenditure occurred during the grant e Household Id connected to the Service transaction e Expenditure Type HPRP Financial Assistance Activity or HPRP Housing Relocation amp Stabilization Service e Service Start Date e Service End Date 6 Fund Source Cost calculation This report can be run on only one funding source at a time and if data for multiple funding sources is needed the report must be rerun for each source separately The report combines Fund Source 1 Cost 1 and Fund Source 2 Cost 2 i
6. their housing HUD e Housed and at imminent risk of losing housing HUD e Imminently losing their housing HUD Note these two values are retired values and are no longer in active use but are included to retain historical data Clients with a don t know or refused answer to the housing status question at program entry are not included in the report 5 The client s service transaction must be accompanied by a recorded HPRP Financial Assistance Activity or by an HPRP Housing Relocation amp Stabilization Service 6 The service transaction must also include a fund source and an amount for the record HPRP Financial Assistance Activity or by an HPRP Housing Relocation amp Stabilization Service 1 Homeless Status Requirement Clients are included in the report s Homeless Assistance and or Homelessness Prevention categories based upon their answer to the homeless status question at the time of program entry Those indicated as literally homeless are counted as Homeless Assistance clients while stably housed housed and at risk of losing housing housed and at imminent risk of losing housing imminently losing their housing or unstably housed and at risk of losing their housing are courted as Homelessness Prevention Clients without an answer to the question at time of entry or with an answer of don t know or refused are excluded from the report altogether Since clients
7. with the HPRP QPR ART Gallery Report 610 must be also met These include Requirements when specifying a single provider 1 The client must have a combination of HPRP type program entry exits which indicate they were enrolled in the program of the specified provider during the date range Grant to Date and or Quarter The client must have one or more service transactions which indicate they received one or more services from the specified entry exit provider during the date range Grant to Date and or Quarter At least one of the client s service transactions must also have a start date that falls between their program entry and their program exits The client must have one of four recorded answers to the Housing Status question at the time of program entry These are stably housed housed and at risk of losing housing housed and at imminent risk of losing housing or literally homeless Clients with a don t know or refused answer to the housing status question at program entry are not included in the report The client s service transaction must be accompanied by a recorded HPRP Financial Assistance Activity or by an HPRP Housing Relocation amp Stabilization Service The service transaction must also include a fund source and an amount for the recorded HPRP Financial Assistance Activity or by an HPRP Housing Relocation amp Stabilization Service Requirements when specifying m
8. ART Gallery Report 0613 HPRP Financial Report Funding Report EXECUTIVE SUMMARY This report is designed to extract and present the financial assistance data connected with HPRP grants Expenditures related to client assistance are summarized by e Homeless Assistance vs Homelessness Prevention e Grant to date vs Current quarter e Assistance Type In addition to the summary data six detail sections display the data sorted of grouped by e Client Unique Id e Client Uid e Service Household Id e Service Start Date e Service Provider e Assistance Type AUDIENCE HPRP Grantees and Sub grantees FREQUENCY This report will need to be run quarterly to extract HMIS data for completion of the required HPRP quarterly grant reports This report should be run as needed to check and confirm that the client assistance expenditures being recorded in HMIS are being correctly and completely represented and tie to corresponding program financial records PURPOSE The report can be used for data quality auditing and or documentation of HPRP grant related expenditures Bowman Systems Page 1 of 12 0613 HPRP Financial Report ART Gallery Report v9 INSTRUCTIONS The easiest way to start using this report is to navigate to the automapper This is a folder that has the reports automatically mapped to your site so that you don t have to map them yourself You can navigate to the automapper as shown in Diagram 1 below N Reports
9. Y h All Values p Diagram 1 The five user prompts contained in this report are 1 Select Provider s Click the refresh list icon and wait for the left window to refresh Now select the provider or providers to include by highlighting them in the left window and moving them into the right window using the right selection arrow 2 Enter Start Date of Quarter The user should type in or select from the calendar the first day of the quarter for which the report is being prepared This date should not precede the start date of the grant If the grant began during the quarter the grant start date and the quarter start date should be the same 3 Enter End Date of Quarter PLUS ONE DAY The user should type in or select from the calendar the day immediately following the last day of the quarter for which the report is being prepared For example if the reporting quarter is October 1 2009 December 31 2009 then January 1 2010 should be entered selected 4 Select Fund Source Click the refresh list icon and wait for the left window to refresh Now select the funding source to include by highlighting it in the left window and moving it into the right window using the right selection arrow 5 Enter Start Date of Grant The user should type in or select from the calendar the first day of their HPRP grant contract How to read The report contains eight tabs Each tab is a sub report containing three sections e Repo
10. deposits 50 00 60 00 105850 1500441 wooo anoo Utility payments 514 05 314 85 105850 1506437 w009 anoo Security deposits 60 00 60 00 105650 1506440 wooo anoo Utility payments 514 00 14 08 1806442 aooo anono Mote amp hotel vouchers 31 00 31 00 1506443 9 09 anong Motel amp hotel vouchers 31 00 31 00 1506444 aaoo anong Motel amp hotel vouchers 31 00 31 00 1506445 giging anoo Mote amp hotel vouchers 31 00 31 00 1506448 gene anono Utility payments 148 23 148 23 1506447 9109 anong Rental assistance 1 300 00 1 300 00 1500448 wooo anoo Moving cost assistance 611 00 811 09 Total for HPRP Test Provider 1 8560 3 477 28 4 072 28 Diagram 7 Tab F Detail by Expenditure Provider Diagram 7 This tab contains a breakdown of expenditures sectioned by Service Provider with each provider starting on a separate page of the sub report In addition to expenditure type the report displays Client Uid Household Uid if any Service Uid Service Start Date Service End Date Expenditure Type Expenditure amount occurring during the current quarter and Expenditure amount occurring within the date range of the grant to date Bowman Systems Page 6 of 12 0613 HPRP Financial Report ART Gallery Report v9 Homelessness Prevention and Rapid Rehousing Program HPRP Financial Report Detail by Type of Expenditure Reporting Quarter Q 7 1 09 9 30 09 Grant to Date GTD 4 1 09 9 30
11. gt ART gt Last Viewed Favorites e Advanced Reporting Tool Home ClientPoint New Report pomote ART Browser ShelterPoint m Inbox anPoin Oren Pos a IR ART Documentation Audit access Report z ae Audit Report ig_ ART Report Templates User Information z User Login AHAR Call Record Report x leass Client Served Report R ART 3 x Galery Released e Daily Unit Report gt UB ART 3 x Galery BETA O Duplicate Client Report aapne Pagat 0114 System Growth by Clents v11 05 31 Released 2011 12 31 11 30 ifp EAR 0115 S Growth by Si 11 05 31 Released 2011 12 31 11 34 Needs Report 115 System Growth by Services v11 05 31 Release 2011 12 Outstanding Referrals 0116 System Growth by Provider v11 05 31 Released 2012 01 07 09 04 i OH PATH 0117 System Growth by Program Entries v11 05 31 Released 2012 01 01 04 32 OR e Service Tansaction 0119 System Growth by Program Exits v11 05 31 Released 2012 01 01 04 32 i p SA 0120 Period End Enrollment v11 05 31 Released 2012 01 01 04 32 i g Reportwniter E gt admin Logout Diagram 1 Requests for additional information concerning the report function design should be directed to Bowman Systems Customer Support Specialist CSS staff Before running the report Prior to running the report the user must determined the provider or providers to be included in the report and a date ranges on which to base the results This report can be
12. ity payments Moving cost assuptance 20 Quteach anc engagement o o Housing search anc clacement ol oj oj o oj o Legal servcer o o Q Crede a o pair al o g J 0 pendinures far Housing Relocation and Stabsiration Services Diagram 2 Tab A Program Expenditures Diagram 2 This tab contains expenditure totals for both for the quarter Q and grant to date GTD These counts are further broken down by into Homelessness Prevention and Homeless Assistance components and into the various Stabilization Services and Financial Assistance categories Homelessness Prevention and Rapid Rehousing Program HPRP Financial Report Detail by Client Unique Id Reporting Quarter Q 7 1 09 9 30 09 Grant to Date GTD 4 1 09 9 30 09 Funding Source HPRP Source 1 Client Unique Id Client Uid Service Uid Type of Expenditure StartDate EndDate Q GID 1598428 i v02 OK aia o oat Security deposits aooo 9 10 08 60 00 60 00 1806420 Utility payments awo a100 14 05 14 05 mer oooooo00mic1cess 336240 1502835 Rental assistance 7 16009 7117108 200 00 300 00 helertzzeesmiercess 330245 1502097 Rental assistance 7 16 08 77108 200 00 300 00 helosoetseomietcess 336244 1502836 Rental assistance 7 6108 7708 200 00 300 00 1502864 Rental assistance 15109 enso 0 00 400 00 helO1022000N161c453 336243 1508421 Security deposits 6 1600 6 17 00 0 00 150 00 1908422 Motel amp hotel voucher
13. n its calculation and expenditures recorded in both fields under the same source will be double counted This data entry error can be monitored using Gallery Report 230 HPRP Data Quality REPORT MODIFICATION Because this report is based on HUD standards and HPRP reporting instructions modification is generally not recommended especially with regards to the query variables and formulas that impact the first tab of the report If additional detail is desired in Tabs B G this can be accomplished by adding the desired fields to the query and to the appropriate report table s in Tabs B G Bowman Systems Page 10 of 12 0613 HPRP Financial Report ART Gallery Report v9 OTHER HPRP ART GALLERY REPORTS A variety of other HPRP ART Gallery reports are available or are currently being developed to assist customers in the administration of their HPRP programs These include 230 HPRP QPR Data Quality Part 1 234 HPRP QPR Data Quality Part 2 613 HPRP Financial Assistance Report 615 HPRP QPR with Client Detail DATA MAPPING GUIDE UNIVERSE art3_template_ee_u QUERY NAME OBJECT TYPE FIELD NAME LOCATION Data Result Objects Client Uid Entry Exit Clients folder Service Household Id Entry Exit Service Outer folder Service Uid Entry Exit Service Outer folder Service HPRP Financial Assistance Entry Exit Service Outer folder Type Service HPRP Housing Relocation amp Stabilization Service Provided E
14. ntry Exit Service Outer folder Client Unique Id Entry Exit Clients folder Service Fund Source 1 Entry Exit Service Outer folder Service Fund Source 2 Entry Exit Service Outer folder Service Cost1 Entry Exit Service Outer Service Costs Outer folder Service Cost2 Entry Exit Service Outer Service Costs Outer folder Service Provide Start Date Entry Exit Service Outer folder Service Provide End Date Entry Exit Service Outer folder Service Provide Provider Entry Exit Service Outer folder Entry Exit Uid Entry Exit folder Housing Status Entry Objects folder Filter Objects Entry Exit Provider Id Entry Exit folder Entry Exit Type Entry Exit folder Entry Exit Inactive Entry Exit folder Client Inactive Entry Exit Clients folder Entry Exit Entry Date Entry Exit Exit Date Service Inactive Entry Exit folder Entry Exit folder Entry Exit Service Outer folder Bowman Systems ART Gallery Report Page 11 of 12 0613 HPRP Financial Report v9 0613 Revision History Version Description of Changes V9 09 21 Original version BETA V9 12 03 Revision User Manual clarifications Tech Notes 2 and 3 revised V10 03 10 Revision Correct issue occurring when a financial assistance spans from one quarter into another V10 04 07 Revi
15. rs HPRP Test Provider 1 8560 21 00 31 00 sama Utility payments HPRP Test Provider 1 3560 314823 148 23 sams Rental assistance HPRP Test Provider 1 8560 1 300 00 1 200 00 saos 330732 1500448 Moving cost assistance HPRP Test Provider 1 8560 811 00 811 00 Grand Total 3 477 28 4 072 28 Diagram 6 Tab E Detail by Date Diagram 6 This tab contains a breakdown of expenditures sorted by the Service Start Date and displays Client Uid Service Uid Expenditure Type Service Provider Expenditure amount occurring during the current quarter and Expenditure amount occurring within the date range of the grant to date Homelessness Prevention and Rapid Rehousing Program HPRP Financial Report Detail by Provider Reporting Quarter Q 7 1 09 9 30 09 Grant to Date GTD 4 1 09 9 30 09 Funding Source HPRP Source 1 ClientUid HHid Serviceld Start Date End Date Type of Expenditure as GTDss 338243 1502034 8500 18 09 Rental assistance 0 00 400 00 336243 1506421 anao 6 17 00 Security deposits 0 00 150 00 330243 1500422 eneoo 670o Motel amp hotel vouchers 30 00 46 00 330244 105846 1582036 Tne 71TA Rental assistance 300 00 300 00 105846 1502037 7609 TINT Rental assistance 300 00 300 00 105846 1502035 71608 71709 Rental assistance 300 00 300 00 105850 1500430 w009 anoo Security deposits 50 00 60 00 105850 1506430 w09 anono Utility payments 14 65 14 86 105850 1506438 going anoo Security
16. rt Header The header contains the title of the report and the tab sub report When running the report in modify view the report header is only visible in print page layout mode e Report Footer The report footer contains the title of the report the name of the tab sub report the page number the version number and the date time the report was run printed Like the header the footer is only visible in print mode when the report is run in modify view e Report Body The report body is the main section of the report located between the header and the footer where the reports data is displayed in a variety of different chart formats The data contained in each of the tabs in this report is displayed and described below Bowman Systems Page 3 of 12 0613 HPRP Financial Report ART Gallery Report v9 Homelessness Prevention and Rapid Rehousing Program HPRP Financial Report Program Expenditure Summary Reporting Quarter Q 7 1 09 9 30 09 Grant to Date GTD 4 1 08 9 30 09 Funding Source HPRP Source 1 Program Expenditures 1 Total Expenditures Homelessness Preventon Momeless Assistance TOTAL Expersitures Exendiuves Excerditures Q cto a GTO Q GTO 3 Homelessness Preventan Hameiess Assistance TOTAL Expercitures Expendives Excernditures 2 Total Expenditures by Service Provided a GTO STO a inancial Assistance Renta assestance Speary arc unity senosrs un
17. s anaoa anmo 0 00 45 00 1506437 i 9100 10 I aa 5 ee 5 Security deposits aooo anoo 60 00 60 00 1503440 Utility payments awo anoo 14 68 514 00 1508438 it 9108 10708 I I Security deposits awo ano 60 00 60 00 1508441 Utility payments awo ar00 14 65 14 05 1506442 Motel amp hotel vouchers aaoo 9 10 08 31 00 31 00 1506443 Motel amp hotel vouchers 19102 anoo 31 00 31 00 1506444 Motel amp hotel vouchers owo anoo 31 00 31 00 ttu ooooooootsoots10 330732 1508445 Motel amp hotel vouchers wao anoo 31 00 31 00 1808446 Utility payments 99108 971009 148 23 148 23 1506447 Rental assistance woo anoo 1 200 00 1 300 00 1506448 Moving cost assistance e ano0 81 00 811 09 Total 3 477 28 4 072 28 Diagram 3 Tab B Detail by Unique Client Id Diagram 3 This tab contains a breakdown of expenditures sorted by the Client Unique Id and displays Client Uid Service Uid Expenditure Type Service Start Date Service End Date Expenditure amount occurring in the current quarter and Expenditure amount occurring within the date range of the grant to date Bowman Systems Page 4 of 12 0613 HPRP Financial Report ART Gallery Report v9 Homelessness Prevention and Rapid Rehousing Program HPRP Financial Report Detail by Client Uid Reporting Quarter Q 7 1 09 9 30 09 Grant to Date GTD 4 1 09 9 30 09 Funding Source HPRP Source 1 Client Uid Provider Type of Expenditure Service Uid Star
18. sion Corrects anomaly occurring when multiple entry exits correspond to service dates V10 06 02 Revision Incorporates HUD wording changes to the Housing Status pick list V11 04 13 Revision For SPR5x ART3x compatibility V7 Revision Addresses anomaly occurring when fund source 1 is null and fund source 2 is not null V8 Revision Report Query Speed Optimizations V9 Revision Redesign Report Queries for speed optimizations Bowman Systems Page 12 of 12 0613 HPRP Financial Report ART Gallery Report v9
19. t Date Q GTD S eal Motel amp hotel vouchers 1508422 ona 0 00 45 00 336243 Rental assistance 1502824 6500 0 00 400 00 Security deposits 1506421 sooo 150 00 zasa Rental assistance 1602838 200 00 300 00 336245 Rental assistance 1802807 716108 300 00 300 00 336246 Rental assistance 1502005 Tne 200 00 300 00 om Security deposits 1508426 aano 60 00 60 00 Utility payments 1506439 aaoo 14 05 14 65 ao Security deposits 1508428 wano 50 00 50 00 Usilty payments 1606441 sano 14 65 514 85 n Security deposits 1508437 wano 60 00 60 00 Utility payments 1508440 218 09 314 68 914 66 Motel amp hotel vouchers 1508442 wano 31 00 31 00 Motel amp hotel vouchers 1508443 aaoo 31 00 31 00 1806444 wano 31 00 31 00 339732 1508445 aaoo 31 00 31 00 1806448 wana 811 0 811 09 cs 1506447 eano 1 300 00 1 300 00 Utility payments 1506446 wano 148 23 148 23 Total 3 477 28 4 072 28 Diagram 4 Tab C Detail by Client Uid Diagram 4 This tab contains a breakdown of expenditures sorted by the Client Uid and displays Service Provider Expenditure Type Service Uid Service Start Date Expenditure amount occurring during the current quarter and Expenditure amount occurring within the date range of the grant to date Homelessness Prevention and Rapid Rehousing Program HPRP Financial Report Detail by Household Reporting Quarter Q 7 1 09 9 30 09 Grant to Date GTD 4 1 09 9 30 09
20. uarter and Expenditure amount occurring within the date range of the grant to date Clients without a Service Household Id are considered to be single person households for HPRP reporting purposes These clients are grouped together in the last household section of this sub report Bowman Systems Page 5 of 12 0613 HPRP Financial Report ART Gallery Report v9 Homelessness Prevention and Rapid Rehousing Program HPRP Financial Report Detail by Date Reporting Quarter Q 7 1 09 9 30 09 Grant to Date GTD _ 4 1 09 9 30 09 Funding Source HPRP Source 1 Start Date Client Uid Service Uid Type of Expenditure Provider ass GTD e159 330243 Rental assistance HPRP Test Provider 113560 sooo 400 00 enews 336243 Security deposits sooo 150 00 e1g09 23643 Motel amp hotel vouchers 30 00 45 00 mmeg 230244 Rental assistance 30000 300 00 7Hg09 33045 Rental assistance 300 00 300 00 mmeg 23640 Rental assistance s20000 300 00 saros 230729 Security deposits HPRP Test Provider 1 3560 0 00 360 00 sso 330730 Security deposits HPRP Test Provider 1 3560 50 00 60 00 saos Security deposits HPRP Test Provider 1 8560 50 00 60 00 saos Utility payments 14 65 14 05 saos Utility payments 51405 s1405 sams Utility payments 31486 s1420 saos Motel amp hotel vouchers 31 00 31 00 319103 Motel amp hotel vouchers 31 00 31 00 saos Motel amp hotel vouchers 31 00 31 00 919103 Motel amp hotel vouche
21. ultiple providers Multiple providers may be selected for the report and will be reported as a single entity in that clients will be de duplicated across providers and reported only once in each applicable report category However it is important to note that each provider must record both a program entry exit AND at least one service transaction for the client to be properly counted Work flow models that involve recording an entry exit under one provider and a service transaction under a different provider are not supported by this report 1 2 The client must have a combination of HPRP type program entry exits which indicate they were enrolled in one or more programs of the specified providers during the date range Grant to Date and or Quarter The client must have one or more service transactions which indicate they received one or more services from one or more of the specified providers during the date range Grant to Date and or Quarter Bowman Systems ART Gallery Report Page 8 of 12 0613 HPRP Financial Report v9 3 This service transaction must have a start date that falls during their period of enrollment and must have been provided by the same provider as the enrollment 4 The client must have a one of six recorded answers to the Housing Status question at the time of program entry These are e Stably housed HUD e Housed and at risk of losing housing HUD e Unstably housed and at risk of losing
22. used to extract data for a single grantee program or for multiple providers Multiple providers should be selected when they make up a single grant program and their data needs to be included in a single report or when multi provider data need to be aggregated for reporting or analysis How to run The user input prompts in this report are the same as those in the 610 QPR report Upon opening the report the user will be prompted see Diagram 1 to specify parameters which control the data returned by the report Once the user has provided these parameters by responding to the user prompts a green check mark will appear next to each field to indicate that a selection has been made The user should then single click the Run Query button to generate the report Bowman Systems Page 2 of 12 0613 HPRP Financial Report ART Gallery Report v9 Prompts Select or type the prompt walues for each prompt below Select Provider s Enter Start Date of Quarter Enter End Date of Quarter PLUS ONE DAY Select Fund Source Enter Start Date of Grant gt Refresh List gt Select Provider s Entry Exit Provider Id 1 10th Street Shelter 2055 1 ABC Shelter for Women and Families 1 Care House 095 1 Countywide Electric Company 251 1 EFC Ash Street Safe Haven 3663 1 EFC Cedar Street ReachOut 7768 1 EFC HH Transit for Jobs Program 7842 1 EFC Maple Street THP PTO 7444 1 EEC Manle Strast THD STARI ECAAD
Download Pdf Manuals
Related Search