User Manual - nh
Contents
1. Bowman Systems Page 4 of 17 0621 Pulse Quarterly PIT ART Gallery Report v5 Pulse Quarterly PIT HMIS Bed Coverage Quarterly PIT Date 3 24 10 _ CoC 123456 B HMIS Bed Coverage Summary Overflow wees ai aga puiu Emergency Shelter for Households without Children Emergency Shelter for Households with Children Transitional Housing for Households without Children Transitional Housing for Households with Children Total Beds Bowman Systems Page 1 of 1 0621 Pulse Quarterly PIT Tab 8 HMIS Bed Coverage Diagram 3 Tab B HMIS Bed Coverage Diagram 3 This tab reports HMIS bed capacity based on the providers bed inventory data as recorded in the Provider Admin section of Service Point This bed capacity is then used in Tab C to calculate bed utilization rates See the technical notes below for further guidance concerning Pulse bed capacity Data to be transferred into the HDX reporting system is displayed on a white background Cells that automatically calculated on the HDX input screen are shown on a gray background Bowman Systems Page 5 of 17 0621 Pulse Quarterly PIT ART Gallery Report v5 Pulse Quarterly PIT Quarterly PIT Date 3 24 10 CoC 123456 C Quarterly Point In Time Count of All Sheltered Clients Persons in Households with at least one Adult and one Child Emergency Transitiona Number of Households Adults in Families Children in Families2. Missing this Information Number of Persons Adults and Children HMIS Beds Bed Utilization Rate Persons in Households with Only Children Emergency Transitiona Number of Households Unaccompanied Youth Children in Households with Only Children Missing this Information Number of Persons Age 17 and Under Persons in Households without Children Number of Households Individual Adult Males Individual Adult Females Missing this Informatioin Number of Persons Age 17 and Over HMIS Beds Bed Utilization Rate Sheltered Total Households and Persons Emergency Transitiona Total Households Total Persons Bowman Systems 0621 Pulse Quarterly PIT Tab C Client Counts Page 1 of 1 v10 09 08 Printed 9 3 10 4 24 46 PM Diagram 4 Tab C Quarterly PIT Counts Diagram 4 This tab reports the Quarterly PIT counts needed to complete Tab C of the Pulse reporting module and is laid out to match the Tab C HDX input screen Data to be transferred into the HDX reporting system is displayed on a white background Cells that automatically calculated on the HDX input screen are shown on a gray background Bowman Systems Page 6 of 17 0621 Pulse Quarterly PIT ART Gallery Report v5 Pulse Quarterly PIT Client Detail CoC 123456 Reporting Quarter 10 1 09 to 12 31 09 Quarter PIT Date 12 8 09 2548 fowf10191950f405 525 c 50 Female 6 19 09 na SH 8456 krjf05232002k650b632
3. Tab E Household Detail Diagram 6 Like Tab D this tab contains PIT count detail but sorted by household rather than by client The listing is sectioned by household type with the first column indicating the household grouping as indexed by the Entry Exit or Service Group Id see tech note 4 As in Tab D the Last column indicates whether the client s inclusion in the PIT count is based on an Entry Exit E a Shelter Service Transaction Svc or a ShelterPoint Shelter Stay SH The Start Date Column and the End Date column indicate the Entry Exit or Service Dates related to the client s enrollment When na appears in the End Date column it indicates that the client was still actively enrolled at the end of the reporting period Bowman Systems Page 8 of 17 0621 Pulse Quarterly PIT ART Gallery Report v5 Pulse Quarterly PIT Data Additional Information User Prompt Field Value s Selected Enter Effective Date 3 25 09 Enter Quarterly PIT Date 3 24 10 Enter Quarterly PIT Date PLUS 1 Day 3 25 08 Enter Start of Quarter 1 1 08 Enter End of Quarter PLUS 1 Day 4 1 09 Select CoC Code 123456 1 10th Street Shelter 2055 1 ABC Shelter for Women and Families 8325 1 EFC Maple Street THP PTO 7444 1 EFC Maple Street THP STABLE 7442 1 EFC Maple Street Transitional Housing Program 3334 1 EFC Oak Street Housing 7443 1 EFC Oak Street Housing SRO 7445 1 EFC Oak Street Housing Trail 7860 1 FCA Pike Stre
4. a Shelter Service Transaction Svc or a ShelterPoint Shelter Stay SH The Start Date Column and the End Date column indicate the Entry Exit or Service Dates related to the client s enrollment When na appears in the End Date column it indicates that the client was still actively enrolled at the end of the reporting period Bowman Systems Page 7 of 17 0621 Pulse Quarterly PIT ART Gallery Report v5 Pulse Quarterly PIT Household Detail Coc 123456 Reporting Quarter 10 1 09 to 12 31 09 Quarterly PIT Date 12 8 09 Group A Households Consisting of Adults and Children 271753 147799 tebf0928 1985t520p600 24 Female 9 20 08 nia EE 271753 266963 appf06222006a500r300 3 Female 9 20 08 nla EE 290327 303542 mnk00061980m420n622 29 Female 3 10 08 nia EE 290327 303543 npvm0707 1999n200w231 10 Male 3 10 08 nla EE 290327 303544 vxdm04282004v450w231 5 Male 3 10 08 nla EE 2940280 240122 difft 1261979d540r200 30 Female 4 15 09 nla EE 294080 324180 klimm060620064520s322 3 Male 4 15 08 nia 3004280 317794 acof08201981a420p340 28 Female 6 15 09 nla EE 300480 317799 jvff02082006j520p340 3 Female 6 15 09 nla EE 300480 317805 furm0807200 17653a645 8 Male 6 15 08 nla EE 301948 328942 ulgf03041989u522r120 20 Female 6 24 02 nia EE 301948 328943 hbp 00000000h 150j250 null nui 6 24 09 nla EE 301948 326944 jho 00000000 150j250 null nw 6 24 08 nla EE 301948 328940 jyr 00000000j000j250 null nu 6 24 02 nla EE 301948 336122 jncf05252009 400j
5. 1510771 A 7 Female 5 7 08 na SH 13051 kerxm1205 1998k 150b632 1510771 A 11 Mae 5 709 na SH 15604 jfdm 1008 1984j210s363 c 25 Mas 6 29 09 na SH 22427 kigf8201882k530b632 1510771 A 27 Female 5 7 08 nla SH 31988 dtxm0614 1979 d540b640 c 30 Mae 5 18 00 na SH 32645 pjum0305 1959p400d500 c 50 Mae 6 14 09 nia SH 35170 orgm02121961c642r200 c 48 Mae 6 25 08 na SH 38120 roxf0708 1965r2400415 c ae Female 6 18 08 na SH 30841 jrmf01121949j520w630 c 60 Female 6 8 08 nia SH 39908 ehmft0191947e225j525 c 62 Female 5 4 09 na SH 40022 dssm021119740400h630 c 35 Maie 6 15 09 nia SH 40310 ayqf0806 19533420620 c 56 Female 6 17 08 na SH 54450 cqpf07 11 1960c6401460 c 49 Female 6 25 08 nia SH 57520 shif09051984s100j520 1564776 A 25 Female 6 11 08 nia SH 57670 jmum1 1222001j200m632 1564776 A 8 Mas 6 11 00 nla SH 57707 vim 1 121999 6 15m632 1564776 A 10 Male 6 11 09 na SH 58597 mhff08121956m645w535 c 53 Female 6 7 09 na SH 65716 moym02191963m240s363 c 46 Mae 6 3 09 nia SH 66810 tndm08031961t520w630 c 48 Male 6 8 09 na SH 71294 gssf082019559460w630 c 54 Female 121100 nia SH 71483 mert0507 1952m615 262 c 56 ndered Female 6 12 09 nia EE 78929 rvef01091954r150f620 c 55 Female 8 14 08 nla Svs 81902 bdim0724 1958b634s552 c 50 Mae 6 16 09 na SH 94708 dhxm02141956d 130s254 c 53 Mas 6 26 08 nia SH 99028 pfim07221970p362b626 c 39 Mae 9 5 08 nia EE 28067 clsf03241963c653s530 c 46 Female 4 20 08 na SH 102210 jkwrn 1008 1956 500r150 c 53 Mae 4 17 09 na EE 103083 jvtm0427 1961 520t200 c
6. 48 Male 6 14 09 nia SH 104058 arom09301963a450e152 c 46 Mae 6 10 09 na SH 105102 aeim1027 198043562120 c 29 Mae 13 08 nia SH 106821 nwit08 t 1 1974n240w121 c 35 ndered Maleto 3 14 08 nia EE 107922 msim10091960m615s530 c 49 Mae 6 13 09 nia SH 112018 rsem09191968r163k620 c 41 Mae 10 21 08 nla SH 114880 apff032219493420y520 c 60 Female 6 1 09 na SH 115888 faof0t 101955 500m324 c 54 Female 3 14 08 nia EE 120488 ajjf04 1519763500632 c 33 Female 1 23 08 nia EE 120895 bbem03151953b650s530 c 56 Mae 6 28 08 nia SH 121370 tkym0523 1956r543r400 c 53 Male 6 20 09 nia SH 125748 jahm0821197 1j5200416 c 38 Mae 6 13 00 Wa SH 126407 ghfm0 125197 19600a425 c 38 Male 6 29 08 nia SH 126408 jedm04291973 100a450 c 36 Mas 6 29 08 na SH 126813 skaf06151956s536r524 c 53 Female 9 2 08 na Svs 131340 nxxf09101983n400r162 c 26 Female 6 3 09 na SH 133877 kfvn0923 196443009530 c 45 Mae 6 28 09 na SH 134778 fgbf11131968r120c320 c 41 Female 6 2 09 na EE Bowman Systems Page 1 of 6 v10 11 01 0621 Pulse Quarterly PIT Printed 11 1 10 Tab D Client Detail 1 31 57 PM Diagram 5 Tab D Client Detail Diagram 5 This tab contains a listing of all clients included in the quarterly PIT count This listing includes various pertinent fields and is sorted by Client Uid Should the client be missing any Pulse required data such null values will be displayed Null in red font The Last column indicates whether the client s inclusion in the PIT count is based on an Entry Exit E
7. Field Service Inactive Use Query Filter Location Clients Services Outer Type System Field Service Shelter Item Use Query Filter Location Clients Services Outer Type System Field Service Code Description Use Query Filter Bowman Systems ART Gallery Report Page 16 of 17 0621 Pulse Quarterly PIT v5 0621 Revision History Version Description of Changes v10 09 08 Original version v10 10 13 The query order was reversed to correct an identified issue The report was also modified to exclude clients exiting shelter on the day of the quarterly PIT count This change results in a more accurate PIT count and reflects HUD guidance and best practice related to PIT methodology Minor revisions were also made to the User Manual to reflect these changes and to clarify the required Pulse workflow v11 04 13 Changes for HUD compliance Individual Adult Male and Individual Adult Female counts were expanded to include ALL adults and not just single adults v11 04 25 Revised to resolve known issues Clients who exited the program on the day of the Quarterly PIT Count before spending the night are being included in the count and should be excluded In Tab B overflow beds were being counted incorrectly by being included in the total bed column and excluded from the Overflow Voucher column v5 Resolved an issue for Total Beds column on Tab B Total Beds count was only co
8. The tables blow list the detail variables found in the reports along with their proper associated dimensions e Detail variable CoC Code Associated dimension Merge Provider e Detail variable Type Code Associated dimension Merge Provide Bowman Systems Page 12 of 17 0621 Pulse Quarterly PIT ART Gallery Report v5 REPORT MODIFICATION Because this report is based on HUD established Pulse reporting instructions modification is generally not recommended especially with regards to the queries variables and formulas that impact the HDX data Bowman Systems Page 13 of 17 0621 Pulse Quarterly PIT ART Gallery Report v5 MAPPING OBJECTS UNIVERSE template_u template_provider_u This report is mapped to the client universe template_u and provider universe template_provider_u and should be copied to your Public or Favorite folder then mapped to the equivalent event universes for your site ex yoursite_u Mapping for the client universe can be done from the first query PIT Mapping for the provider universe can be done from the second query Beds QUERY NAME FIELD NAME LOCATION TYPE USE Location Providers Type System Field Providers Provider Merge Id Use Result Object Location Providers Type System Field Providers COC Code Use Result Object Location Providers Providers Type System Field Providers Program Type Code Use Result Object Lo
9. Use of a standard HUD Workflow by participating providers e Proper recording of CoC code Program Type Code and Shelter Service Code in each provider s Admin Provider Configuration e Up to date and accurate Bed and Unit Inventory Information recorded in each provider s Bed and Unit Inventory subassessment including adjusting the overflow and voucher bed counts to correspond with the number used on the day of the Quarterly Count Bowman Systems Page 1 of 17 0621 Pulse Quarterly PIT ART Gallery Report v5 INSTRUCTIONS Instructions are outlined below concerning how to retrieve copy run and read this report Requests for additional information concerning the report function design should be directed to Bowman Systems staff via email ART Reports BowmanSystems com E Folders How to retrieve and copy Detailed step by step instructions GeSSaex concerning how to retrieve save a copy and map this ART Reportto a your site can be found in the Bowman Systems Published Documents Bag ania folder under ART Documentations in the Public Folders section Business Objects Published Documents How to install The original version of the report is a template and must be copied from the ART Gallery Templates folder into another folder on your site and mapped to your data before it can be used Detailed instructions for installing report templates are provided in the Bowman Documentation folder on your ART site Before running
10. on the day of the Quarterly PIT count Bowman Systems Page 9 of 17 0621 Pulse Quarterly PIT ART Gallery Report v5 TECHNICAL NOTES 1 De duplication This report de duplicates client counts according to HUD specifications using ServicePoint s Client Unique ld field 2 Inclusion In order for a client household to be included in the quarterly PIT count in this report the client must have been serve on count day as evidenced by one or more of the following a An Emergency Shelter or Transitional Housing type service by a specified provider with a start date on or before count day and an end date that was after count day or null b Enrollment in a specified Emergency Shelter or Transitional Housing type program with an entry date on or before count day and an exit date that was after count day or null c AShelterPoint shelter stay by a specified Emergency Shelter or Transitional Housing type program on count day beginning on or before count day and ending after count day or not ending 3 Bed Inventory Data The bed count numbers displayed in Tab B of this report are extracted from the Bed and Units Inventory subassessment in each provider s ServicePoint Admin Provider configuration This data then also used to determine the number of HMIS beds and subsequent utilization rates in Tab C Users should note the following in conjunction with this Tab B C data a All providers included in the report must have complete and accur
11. the report Prior to running the report the user must determined e Acomplete list of the CoC s participating Emergency Shelter and Transitional Housing providers e The proper CoC code for the CoC being reported e Date range of the reporting quarter e Date of the Quarterly PIT Count How to run 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 fa Prompts Select or type the prompt values for each prompt below Enter Quarterly PIT Date 3 24 2010 12 00 00 AM Enter Quarterly PIT Date PLUS 1Day 3 25 2009 12 00 00 AM Select COC Code 123456 Select Provider s 1 10th Street Shelter 2055 1 ABC Shelter for Women ai Enter Start of Quarter 1 1 2009 12 00 00 AM Enter End of Quarter PLUS 1 Day 4 1 2009 12 00 00 AM eee eeeQ a v Select a custom date M d yyyy 3 25 2009 12 00 00 AM A l Refresh Data Cancel Diagram 1 Bowman Systems Page 2 of 17 0621 Pulse Quarterly PIT ART Gallery Report v5 There are seven user prompts connected with this report 1 Enter effective date The user should type in or select from the calendar the day immediately following
12. 250 0 Female 6 24 08 nla EE 305701 288190 jeq 00000000 500d000 null nui 8 25 07 nla EE 305701 288192 jvx 0508200 1 500v620 8 nui 8 25 07 nla EE 305701 288193 jna 00000000 500d000 null nui 8 25 07 nla EE 1177824 147799 tebf0928 1985t520p600 24 Female 9 20 08 nia Svs 1177824 266963 appf06222006a500r300 3 Female 9 20 08 nla Svs 1423841 303542 mnkf006 1980m420h622 22 Female 3 10 08 nla Svs 1423841 303543 npwm0707 1999n200w231 10 Male 3 10 08 nla Svs 1423841 303544 vxdm04282004v450w231 5 Male 3 10 08 nla Svs 1476543 323902 psw 02021969p640s000 40 Female 2 17 08 nla SH 1476543 323907 zppm012319932260s000 16 Male 2 17 08 nla SH 1478742 240122 diff 1261979d540r200 30 Female 4115 09 nla Svs 1478742 324180 klim060620064520s322 3 Male 4 15 02 nls Svs 1510771 8456 krjf05232002k650b632 7 Female 5 7109 nla SH 1510771 13051 knem12051008k150b632 11 Male 5 7109 nla SH 1510771 22427 kigf08301982k530b032 27 Female 5 7109 nla SH 1510771 219625 aiyf08092003a260b632 6 Female 5 7109 nla SH 1510771 219626 aguf10272005a200b650 4 Female 5 7 09 nla SH 1528343 320015 mieft 1031959m520a260 50 Female 5 10 09 nla SH 1528343 322016 oanf090919920243b200 17 Female 5 19 08 nla SH 1537831 327299 mwvhf09151983m240w623 26 Female 5 8 09 nla SH 1537831 327300 kqwft2272008k540m632 0 Female 5 8109 nla SH 1539059 154479 clwf10181877c236p620 32 Female 5 12 08 nla SH Bowman Systems Page 1 of 7 v10 11 01 0621 Pulse Quarterly PIT Printed 11 1 10 Tab E Household Detail 1 31 57 PM Diagram 6
13. ART Gallery Report 0621 Pulse Quarterly PIT EXECUTIVE SUMMARY This report has been created to provide the client and household data needed to complete tabs B and C of the quarterly HUD Pulse Report This information relates to clients being served in an Emergency Shelter or a Transitional Housing Program during the quarterly point in time PIT count as compared to the shelter capacity on that day This report also provides the client and household level detail to assist in documentation and data quality processes NOTE The New Client data needed to complete Pulse reporting Tabs D F is provided in ART Gallery report 609 Pulse New Client Counts Data require for completion of Tab A should be taken from the CoC s annual Housing Inventory Chart AUDIENCE CoCs participating in Pulse reporting or others needing information concerning data about persons and household which are homeless for the first time FREQUENCY Pulse participation requires quarterly reporting however this report should be run as needed to check and confirm that the report includes correct and complete data or whenever Pulse related detail is needed PURPOSE The report can be used to extract the Pulse data from ServicePoint for reporting through HDX to monitor data quality related to Pulse for data cleaning purposes for auditing or documenting the Pulse data reported or to extract new client data for analysis PREREQUISITES AND WORK FLOW REQUIREMENTS e
14. ate Bed and Unit Inventory data recorded in ServicePoint in order for this portion of the report to calculate accurately Changes in the bed inventory since the annual Bed Inventory should be included by editing the inventory data so that it is accurate as of each quarterly count day This update must also include adjusting the overflow and voucher bed counts to correspond with the number used on the day of the quarterly count b Inthe event that the bed inventory data recorded in ServicePoint is determined to be incomplete or inaccurate the Tab C PIT counts should not be affected except for the auto calculated bed count s and utilization rates Some implementations may choose to collect their quarterly bed counts by a different method and utilize this report for the PIT count only 4 Household Type Determination a Only aclient s entry service connected with their PIT count is considered in the determination of household type Previous or subsequent entries services within the quarter are not considered even though they may include a different household makeup b Inthe event a multi person household is served in separate groups households are calculated based on group id content For example consider this single mother with 3 children Mother receives shelter on count day and is counted as a single Later in the quarter the mother is joined in the shelter by her children The mother is still considered a single in the count since her child
15. cation Providers Type System Field Providers Inactive Use Query Filters Location Providers Type System Field Providers Date Added Use Query Filters QUERY NAME FIELD NAME LOCATION TYPE USE Location Providers Type System Field Providers Provider Merge Id Use Result Object Location Providers Type System Field Providers COC Code Use Result Object Location Bedlist Inventory Type System Field Bedlist Inventory Uid Use Result Object Location Bedlist Inventory Beds Type System Field Bedlist Inventory Name Use Result Object Location Bedlist Inventory Bedlist Inventory HMIS Participating Type System Field Beds Use Result Object Location Bedlist Inventory Bedlist Inventory HMIS Participating Type System Field Start Date Use Result Object Location Bedlist Inventory Bedlist Inventory HMIS Participating Type System Field End Date Use Result Object Bowman Systems ART Gallery Report Page 14 of 17 0621 Pulse Quarterly PIT v5 Location Bedlist Inventory Type System Field Bedlist Inventory Bed Type Use Result Object Location Bedlist Inventory Type System Field Bedlist Inventory Availability Use Result Object Location Bedlist Inventory Type System Field Bedlist Inventory Bed Inventory Use Result Object Location Providers Type System Field Providers Program Type Code Use Result Object Location Bedlist Inventory Type System Field Bedlist Inven
16. et Emergency Lodging Program 2804 1 FCA Walleye Street Emergency Rent Assistance Prgm 7193 1 FCA Walleye Street ERAP HODAP 7787 1 OTS Emergency Shelter 5134 1 OTS Transitional Living Program 7092 1 The Greater Green Bay Community Services 2543 1 The Greater Green Bay Shelter Program 8122 1 The Greater Green Bay Social Services Program 7859 1 Tower Men s Shelter 6938 1 WS CAA Supportive Housing Prgm Beta 7107 2 Blue Roof Shelter 2799 2 Red Roof Shelter 2080 2 Yellow Roof Shelter 7 130 Providers Reporting Information in theis Report Client PIT Count Bed Count Select Providers 1 ABC Shelter for Women and Families 8325 4 null 1 EFC Maple Street THP PTO 7444 10 null 1 EFC Maple Street THP STABLE 7442 7 null 1 OTS Emergency Shelter 5124 3 null 1 OTS Transitional Living Program 7092 5 45 1 Tower Men s Shelter 6938 1 65 2 Yellow Roof Shelter 7 130 8 60 Total 38 170 Bowman Systems Pagel o 0621 Pulse Quarterly PIT Printed 9 3 10 Tab F Additional Information 4 24 46 PM Diagram 7 Tab G Additional Information Diagram 7 This tab is provided as a reference to the user running the report and lists the parameters specified in the user prompts as well as client counts by provider e Client PIT Count represents the number of clients served in the day of the count e Bed Count is the number of ES and TH shelter beds reported by the provider as available
17. ing them in the left window and moving them into the right window using the right selection arrow Important NOTE All selected providers must be either an Emergency Shelter Program or a Transitional Housing Program as indicated by their Program Type Code Selected Providers with a missing or different Program Type Code will NOT be included in the report results All selected providers must also have the specified CoC Code Selected Providers with a missing or conflicting CoC Code will NOT be included in the report results How to read This report contains six data tabs Each tab is a sub report containing three sections Report Header The header contains the title of the report and the tab subreport When running the report in modify view the report header is only visible in print page layout mode 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 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 17 0621 Pulse Quarterly PIT ART Gallery Report v5 P
18. mmunity No Wrong CoC Code Services 2543 Nu Null No Wrong Prog Type NIA Homelessness Prevention 1 The Greater Green Bay Shelter Program 8122 123456 and Rapid Re Housing HUD No Wrong Prog Type NIA 1 The Greater Green Bay Social Services Program 7859 www Emergency Shelter HUD No Wrong CoC Code NWA 1 Tower Men s Shelter 6928 123456 Emergency Shelter HUD Yes 1 1 WS CAA Supportive Housing Prgm Beta 7107 Nu Transitional housing HUD No Wrong CoC Code NA 2 Blue Roof Shelter 2729 123456 Transitional housing HUD Yes 2 Red Roof Shelter 2080 123456 Emergency Shelter HUD Yes 2 Yellow Roof Shelter 7 130 122456 Transitional housing HUD Yes 8 2 ES 5 TH 34 7 Prog 38 Bowman Systems Page 1 of 1 v10 09 08 0621 Pulse Quarterly PIT Printed 9 3 10 Tab A Provider Summary 4 24 46 PM Diagram 2 Tab A Provider Summary Diagram 2 This tab contains unduplicated PIT counts of clients by provider Total counts and breakdown by program type is also included As noted above all providers must be either an Emergency Shelter Program or a Transitional Housing Program as indicated by their Program Type Code and must have the specified CoC Code If a provider has been selected that does NOT meet these conditions the provider will be shown in the listing but column 5 will display N A in red font to indicate that their data has been excluded from the report and their missing of conflicting provider designations will also be highlighted in red font
19. nd totals from one screen shot therefore should not be expected to relate to numbers or totals in another screen shot since different parameters may have been used in producing the screen shots Stripped Associated Dimensions This report utilizes two detail type variables that are each associated with a particular merged dimension In the installation process a mapping malfunction may be encountered which results in the associated dimension being stripped from the variable When this occurs the report will return multivalve errors messages and or erroneous count values Bowman Systems is working with Business Objects to determine and correct the root cause of this malfunction meanwhile customers using this version of the report are encouraged to verify that the detail variables in the report are properly displaying an Associated Dimension In cases where the Associated Dimension has been stripped during installation the Associated Dimension designation will appear blank When this occurs the user will need to edit the variable specify the proper dimension save the variable and re save the report prior to use To insure that these reports are returning the proper results it is very important that these associations be checked verified following installation and prior to running the report Further instructions on how to identify and correct this issue will be added to the user manual technical notes
20. ndling description of household grouping examples A adult C child null DOB count as q person w o dob entering alone e cl or c2 or c3 based on gender person w o dob entering w 1 or more 2 childiren amp no adults 270 2 2 C C C 2 2 C C al person w o dob entering w 1 or more 3 adult s amp no child ren 2 A A A A 2 2 A A 50 a2 person w o dob entering w 1 or more of 4 both adultis and child ren 2 A C 2 2 A C 3 2 A A C 2 2 2 A C C a3 person w o dob entering w 1 or more 5 lothers w o dob no adults an no children 2 2 5 2 2 2 2 2 27 a3 KEY A HUD Family ai Adults in Families a2 Children in Families a3 Missing this Information B Children Only b1 Unaccompanied Youth b2 Child only HH b3 Missing this Information C Adults Only c1 Individual Adult Males c2 Individual Adult Females c3 Missing this Information Diagrams 5 Household Groupings The household grouping number displayed in Tab C and used for counting households throughout this report is an index number that has been constructed using the Entry Exit Group Id Service Group Id Entry Exit Id or Service Id as described below Bowman Systems Page 11 of 17 0621 Pulse Quarterly PIT ART Gallery Report v5 6 7 8 a If the client s count day housing event is a service or a ShelterPoint shelter stay and the Service Group Id is no
21. ren were not with her at that point in time Bowman Systems Page 10 of 17 0621 Pulse Quarterly PIT ART Gallery Report v5 c Household type is determined by the number and ages of clients entering or being served as a household group on count day Clients sharing a single entry exit group id or a single service group id Households in this report are divided into the three distinct types as defined in the Pulse reporting requirements These types include 1 Households which include both adults and children aka HUD Family In this type of household at least one person in the household must be under the age of 18 on count day and at least one person in the household must be above the age of 17 on count day 2 Households which include children only This may be an unaccompanied individual under the age of 18 on count day or multiple household members all of whom must be under the age of 18 on count day 3 Households which include adults only This may be an unaccompanied individual over the age of 17 on count day or multiple household members all of whom must be over the age of 17 on the day of the count d In the event that the household type cannot be determined because the age of a household member is unknown null date of birth value then the type of household is determined by a set of null handling instructions provided by HUD to the software vendors producing the report see Diagram 8 below Pulse report null DOB ha
22. t null indicating a shared service then the Service Group Id number is used as the index number b If the client s count day housing event is a program entry into an Emergency Shelter or Transitional Housing program and the Entry Exit Group Id is not null indicating a shared entry then the Entry Exit Group Id number is used as the index number c Ifthe client s count day housing event is a program entry and the Entry Exit Group Id connected with that entry is null indicating a unshared entry then the Entry Exit Id number is used as the index number d If the client s count day housing event is a housing service or shelter stay and the Service Group Id connected with that entry is null indicating a unshared entry then the Service Id number is used as the index number Query Design It should be noted that report uses a union type of combine query in which service and shelter stay events from query 2 are combined with and folded into the entry exit events from query 1 however the results objects from this combine query retain the field labels from query 1 For example the results object labeled entry exit entry date contains both entry dates and service start dates Screen Shots It should be noted that screen shots provided in this user manual have been selected from multiple instances of the report to display certain features or to fit a single page and do not necessarily correspond to one another Numbers a
23. ter Type System Field Entry Exit Group Id Use Result Object Location Clients Entry Exit Outer Type System Field Entry Exit Provider Id Use Result Object Location Clients Entry Exit Outer Entry Exit Provider Id Type System Field Entry Exit Provider COC Code Use Result Object Location Clients Entry Exit Outer Entry Exit Provider Id Type System Field Entry Exit Provider Program Type Code Use Result Object Location Clients Type System Field Client Inactive Use Query Filter Location Clients Entry Exit Outer Entry Exit Provider Id Type System Field Entry Exit Inactive Use Query Filter Location Clients Services Outer Type System Field Service Uid Use Result Object Location Clients Services Outer Type System Field Service Provide Start Date Use Result Object Location Clients Services Outer Type System Field Service Provide End Date Use Result Object Location Clients Services Outer Type System Field Service Group Id Use Result Object Location Clients Services Outer PIT Type System Field Service Provide Provider Use Result Object Location Clients Services Outer Service Provide Provider Type System Field Service Provide Provider COC Code Use Result Object Location Clients Services Outer Service Provide Provider Service Provide Provider Program Type Type System Field Code Use Result Object Location Clients Services Outer Type System
24. the day of the quarterly PIT count For example if the reporting quarterly PIT is October 24 2009 then October 25 2009 should be entered selected Enter the Date of the Quarterly PIT Count The user should type in or select from the calendar the exact day of the quarterly PIT count Enter the Date of the Quarterly PIT Count PLUS 1 Day The user should type in or select from the calendar the day immediately following the day of the quarterly PIT count For example if the reporting quarterly PIT is October 24 2009 then October 25 2009 should be entered selected Enter Start Date for the Quarter The user should type in or select from the calendar the first day of the quarter for which the report is being prepared Enter End Date for the 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 Select CoC Code Click the refresh list icon and wait for the left window to refresh Now select the desired CoC on which to base the report by highlighting it in the left window and moving it into the right window using the right selection arrow 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 highlight
25. tory Household Type Use Result Object Location Bedlist Inventory Type System Field Bedlist Inventory Target Population B Use Result Object Location Bedlist Inventory Type System Field Bedlist Inventory Start Date Use Result Object Location Bedlist Inventory Type System Field Bedlist Inventory End Date Use Result Object Location Providers Type System Field Providers Inactive Use Query Filters Location Bedlist Inventory Type System Field Bedlist Inventory Inactive Use Query Filters QUERY NAME FIELD NAME LOCATION TYPE USE Location Clients Type System Field Client Uid Use Result Object Location Clients Type System Field Client Unique Id Use Result Object Location Clients Assessments Additional Profile Information Type Assessment Question PIT Age Calculated Use Result Object Location Clients Assessments Additional Profile Information Type Assessment Question Gender 894 Use Result Object Location Clients Entry Exit Outer Type System Field Entry Exit Uid Use Result Object Location Clients Entry Exit Outer Type System Field Entry Exit Entry Date Use Result Object Bowman Systems ART Gallery Report Page 15 of 17 0621 Pulse Quarterly PIT v5 Location Clients Entry Exit Outer Type System Field Entry Exit Exit Date Use Result Object Location Clients Entry Exit Ou
26. ulse Quarterly PIT Data Provider Summa Coc 123456 Reporting Quarter 1 1 09 to 3 31 09 Quarterly Point In Time Date 3 24 10 uane Program Type Included in Counts No Wrong CoC Code 1 10th Street Shelter 2055 Null Safe Haven HUD No Wrong Prog Type NIA 1 ABC Shelter for Women and Families 8325 123456 Transitional housing HUD Yes 2 1 EFC Maple Street THP PTO 7444 122456 Transitional housing HUD Yes 10 1 EFC Maple Street THP STABLE 7442 122456 Transitional housing HUD Yes 7 1 EFC Maple Street Transitional Housing Program 3324 Qesg Transitional housing HUD No Wrong CoC Code NWA Permanent supportive No Wrong CoC Code 1 EFC Oak Street Housing 7443 Ucen housing HUD No Wrong Prog Type NA Permanent supportive No Wrong CoC Code 1 EFC Oak Street Housing SRO 7445 Nnos housing HUD No Wrong Prog Type NWA Permanent supportive 1 EFC Oak Street Housing Trail 7860 123456 housing HUD No Wrong Prog Type NWA 1 FCA Pike Street Emergency Lodging Program 2804 123456 Emergency Shelter HUD Yes 1 FCA Walleye Street Emergency Rent Assistance Homelessness Prevention No Wrong CoC Code Prgm 7 193 Nu and Rapid Re Housing HUD No Wrong Prog Type NA Homelessness Prevention 1 FCA Walleye Street ERAP HODAP 7787 122456 and Rapid Re Housing HUD No Wrong Prog Type NIA 1 OTS Emergency Shelter 5134 123456 Emergency Shelter HUD Yes 3 1 OTS Transitional Living Program 7092 122456 Transitional housing HUD Yes 5 1 The Greater Green Bay Co
27. unting beds from providers who had a Bedlist HMIS Participation Start Date set Bowman Systems ART Gallery Report Page 17 of 17 0621 Pulse Quarterly PIT v5
Download Pdf Manuals
Related Search