0625 - HUD CoC APR - v14 USER MANUAL - MSCCOC
Contents
1. 21 Veteran Status Veteran Status Number of Adults in Households Total Without Children With ee nae ines Veteran 136 134 2 o Not a Veteran 1 085 242 142 1 Don t Know Refused 10 6 4 o Information Missing 3 3 oO 0 Total 1 234 1 085 148 1 22a1 Physical and Mental Health Condition Types at Exit Leavers Known Physical and Mental Health Conditions Leavers Total Number by Type All Persons Adults Children Unknown Mental lliness 392 301 1 o Alcohol Abuse 302 301 1 o Drug Abuse 265 265 o o Chronic Health Condition o o o 0 HIV AIDS and Related Diseases 5 4 1 o Developmental Disability 18 15 3 o Physical Disability 307 305 2 o 22a2 Known Physical and Mental Health Condition at Exit Leavers Number of Known Conditions Leavers Total Number by Type All Persons Adults Children Unknown None 399 244 155 o 1 Condition 222 216 e o 2 Conditions 216 215 1 o 3 Conditions 244 240 1 o Condition Unknown 13 10 3 o Don t Know Refused 10 3 7 oO Information Missing 2 1 1 o TOTAL 1 103 929 174 o Diagram 9 22b1 Physical and Mental Health Condition Types at Exit Stayers Known Physical and Mental Health Conditions Stayers Total Number by Type All Persons Adults Children Unknown Mental lliness 146 145 1 o Alcohol Abuse 106 106 0 o Drug Abuse 64 64 o 0 Chronic Health Condition 0 o oO 0 HIV AIDS and Related Diseases 0 0 0 o Developmental Disability 16 12 4 o Physical Disability 105 101 4 o 22b2 Known Physical and Mental Health2. Inc Source NC Exit Merge Last EE Id IncYN Entry Merge Last EE Id IncYN Exit Merge Last EE Id Prior Residence Merge Last EE Id RaceP Merge Last EE Id RaceS Merge Last EE Id Service Entry Merge Last EE Id Service Exit Merge Last EE Id Veteran Merge Last EE Id ZipCode Merge Last EE Id Zip Quality Merge Last EE Id Bowman Systems ART Gallery Report Page 27 of 37 0625 HUD CoC APR v14 REPORT MODIFICATION Because this report is based on established HUD Specifications modification is generally not recommended especially with regards to the queries variables and formulas that impact the e SNAPSdata Bowman Systems Page 28 of 37 0625 HUD CoC APR ART Gallery Report v14 MAPPING OBJECTS A listing of the report objects and their source universe and source folder is provided below Objects are arranged by query and by object type Query Name BISData Universe hud_coc_apr_u Result Objects e Entry Exit Id e Client Unique Id e Last Entry Exit Id e Last Client Id e Client Date of Birth e Client Date of Birth Type e Last Episode e Age at Last Entry e Adult Child e Client Household Type e Client Household Count e Unaccompanied Youth e Master Household Id e Master Household Type e Length of Stay e Length of Stay Total Per Client e Leaver or Stayer e Client Id e COC Household Type e Master Household Size e Length of Oper
3. Receiving Income Source sub assessment question in their data entry workflow for HUD Please see Technical Note 14 for more information on how this prompt answer is used in the report 11 Is using the Receiving Benefit field part of your workflow for HUD reporting The user should select the appropriate Yes or No value based upon if they use the Receiving Benefit sub assessment question in their data entry workflow for HUD Please see Technical Note 17 for more information on how this prompt answer is used in the report How to read This report contains fifteen data tabs Each tab is a sub report containing three sections e Report Header The header contains the title of the report and the tab sub report 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 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 Bowman Systems Page 4 of 37 0625 HUD CoC APR ART Gallery Report v14 7 HMIS or Comparable Database Data Quality Total number of records for All Clients 1 556 Total number of records for Adults Only 1 234 Total number of records f
4. System Growth by Servi V11 05 31 Release 2011 12 31 1 Outstanding Referrals 0116 System Growth by Provi v11 05 31 Released 2012 01 07 09 04 PATH 0117 System Growth by Program Entries v11 05 31 Released 2012 01 01 04 32 Sevier 0119 System Growth by Program Exits v11 05 31 Released Report Writer 0120 Period End Exgollpent v11 05 31 Released gt Admin Logout Requests for additional information concerning the report function design should be directed to Bowman Systems Customer Support Specialist CSS staff IMPORTANT KNOWN INSTALLATION ISSUE This report utilizes several detail type variables that are each associated with a particular dimension In testing the installation process with this report a mapping malfunction was sporadically encountered which resulted the associated dimension being stripped from the variable during the installation process 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 and will publish an updated version if needed Meanwhile customers using this version of the report are strongly encouraged to verify that each of the detail variables in this report is properly displaying an Associated Dimension as shown in the Technical Note 18 below In cases where the Associated Dimension has been stripped duri
5. Client Unique Id Ethnicity Client Household Type EE Adult Child Block filter Dimensions used as the basis for Question 17b Client Unique Id Primary Race Secondary Race Client Household Type EE Adult Child Block filter Bowman Systems Page 9 of 37 0625 HUD CoC APR ART Gallery Report v14 18a Physical and Mental Health Types of Conditions at Entry Known Physical and Mental Health Conditions Number of Persons in Households Tia Without With Children With Only Unknown Children and Adults Children HH Type Mental Iliness 525 514 1 o o Alcohol Abuse 404 400 4 o o Drug Abuse 325 322 3 o o Chronic Health Condition o o o o o HIV AIDS and Related Diseases 5 4 1 o o Developmental Disability 32 25 6 1 0 Physical Disability 404 387 17 o o 18b Physical and Mental Health Known Conditions at Entry Number of Known Conditions Number of Persons Total Without With Children With Only Unknown Children and Adults Children HH Type None 587 183 384 10 o 1 Condition 297 270 26 1 o 2 Conditions 291 279 12 oO o 3 Conditions 309 306 3 oO oO Condition Unknown 39 32 7 oO oO Don t Know Refused 18 1 16 0 1 Information Missing 15 4 6 4 1 TOTAL 1 556 1 085 454 15 2 19a Victims of Domestic Violence Past Domestic Violence Experience Number of Adults and Unaccompanied Children in Households EF Without With Children With Only Unknown Children and Adults Children HH Type Yes 130 74 55 1 o No 1 067 999 ee 2
6. ServicePoint currently collects income and disability type data by means of a sub assessment rather than as a series of individual questions See Technical Note 12 Technical Note 14 and Technical Note 17 for an explanation of how sub assessment data is interpreted relative to the Tab A data Dimensions used as the basis for Question 7a Client Unique Id Adult Child Unaccompanied Youth Leaver or Stayer Last Episode Dimensions used as the basis for Question 7b Client Unique Id Client Last Name Client First Name Client Soc Sec No Dashed Client SSN Data Quality Client Date of Birth Type Client Date of Birth RaceP RaceS Eth Gender Client Gender Adult Child Veteran Disabling Condition PriorResidence Zip Code Zip Quality Unaccompanied Youth Housing Status Entry IncYN Entry Last 30 Day Income EE Leave or Stay IncNCYN Entry IncSourceNC Entry Disability determination Disability Type Disab Condition HUD Disab Entry DV EE Destination Last Episode Block filter Bowman Systems Page 5 of 37 0625 HUD CoC APR ART Gallery Report v14 8 Persons Served During the Operating Year by Type Number of Persons in Households Served During the Operating Year Taa Without With Children With Only Unknown Children and Adults Children HH Type Adults 1 234 1 085 148 o 1 Children 321 o 206 15 o Don t Know Refused 1 o 0 o 1 Missing Information 0 o 0 o o Totar ES 1 085 454 15 2 Average Number of persons Served
7. flow requirements listed below must be met Note this filtering is accomplished on the universe level so these criteria are not viewable or editable within the query design view e An Entry Exit by one or more of the selected providers with an entry date that is on or before the last day of the reporting period e A corresponding program exit date that is either null because the client has not yet exited or falls on or after the first day of the reporting period 7 Non HUD values Several sections of this report contain breakdowns of clients based on recorded assessment sub assessment answers It should be noted that only the HUD defined pick list values are recognized as valid responses These items are all followed by a HUD designation on the pick list All non HUD values are treated as null values and are generally excluded from the counts with the exception of missing values where applicable Bowman Systems Page 21 of 37 0625 HUD CoC APR ART Gallery Report v14 8 Hidden data columns User should be aware that this report may include hidden columns in some of the tables These hidden columns contain data fields that are essential to the calculation of correct results and must not be removed 9 Client Profile information Throughout this report as in nearly all ServicePoint reports static client profile data including Name Gender date of birth DOB Race Ethnicity and Social Secutiry Number SS is determined
8. 5 o o o Don t know Refused 21 a 12 o o information Missing 108 56 48 2 o subtotat 23 14 15 0 o Diagram 14 Tab M Question 29a1 Diagram 14 This tab provides the information needed to complete question 29a1 of the CoC APR Question 29a1 reports on Exit Destination by household type and considers only clients who have left the program after an enrollment period of more than 90 days Dimensions used as the basis for Question 29a1 Client Unique Id EE Destination Client Household Type EE Last Episode Block filter EE Leave or Stay Block filter Length of Stay Block filter Bowman Systems ART Gallery Report Page 17 of 37 0625 HUD CoC APR v14 36a Permanent Housing Programs Exhibit 2 Exhibit 2 Actual of Difference Target of Target of person in the Actual of Actual of between personswho personswho programfor personswho persons who Exhibit 2 Pestecmenee essa were expected were expected whom the accomplished accomplished Target and to accomplish to accomplish measure is this measure this measure Actual this measure tis measure appropriate Performance 1 Housing Stability Measure 181 140 77 35 2a Total Income Measure 160 140 87 50 2b Eamed Income Measure 50 55 93 22 36b Transitional Housing Programs Exhibit 2 Exhibit 2 Actual of Difference Target of Target of person in the Actual of Actual of between persons who persons who program for
9. Client folder Entry Objects folder Entry Objects folder Entry Objects folder Entry Objects folder Entry Objects folder Entry Objects folder Exit Objects folder Entry Objects folder Entry Objects folder Exit Exit folder Bowman Systems ART Gallery Report Page 30 of 37 0625 HUD CoC APR v14 Filter Objects e Entry Exit Uid Results from another query Last Entry Exit Id Query Name Inc Entry Universe ee_ cutoff_u Result Objects Virtual field names for ASSESSMENT objects appear in parenthesis below their corresponding field names e Entry Exit Uid e Client Unique Id e Entry Exit Client Id e Income received from any source in past 30 days SVP_ANYSOURCE30DAYINCOME e Recordset ID e Source of Income SOURCEOFINCOME e Start Date MONTHLYINCOMESTART e End Date MONTHLYINCOMEEND e Last 30 Day Income AMOUNTMONTHLYINCOME e Total Monthly Income HUD_TOTALMONTHLYINCOME e Receiving Income Source SVP_RECEIVINGINCOMESOURCE Filter Objects e Entry Exit Uid Results from another query Last Entry Exit Id from Entry Exit folder from Entry Exit Client folder from Entry Exit Client folder from Entry Objects folder from Entry Objects Monthly Income sub assessment folder from Entry Objects Monthly Income sub assessment folder from Entry Objects Monthly Income sub assessment folder from Entry Objects Monthly Income sub assessment folder from Entry Objects Monthly Inco
10. Condition at Exit Stayers Number of Known Conditions Stayers Total Number by Type All Persons Adults Children Unknown None 205 74 131 0 1 Condition 66 59 7 o 2 Conditions 7 74 3 o 3 Conditions 84 84 0 oO Condition Unknown 10 10 o o Don t Know Refused 8 2 5 1 Information Missing 3 2 1 o TOTAL 453 305 147 1 Diagram 9a Tab H Questions 21 22 Diagram 9 and 9a This tab provides the information needed to complete questions 21 and 22 of the CoC APR Question 21 reports on veteran status and displays client counts by household type Question 22 reports on disabling conditions Questions 22a1 and 22a2 focus on the reported condition at time of exit considering only program leavers Questions 22b1 and 22b2 focus on the reported condition at time of entry considering only program stayers Dimensions used as the basis for Question 21 Client Unique Id Veteran Client HH Type Adult Child Block filter Dimensions used as the basis for Question 22a1 21a2 Client Unique Id Disability Type Disability determination EE AdultChild EE Last Episode Block filter Dimensions used as the basis for Question 22b1 21b2 Client Unique Id Disability Type Disability determination EE AdultChild EE Last Episode Block filter Leave or Stay Block filter Bowman Systems Page 12 of 37 0625 HUD CoC APR ART Gallery Report v14 23 Client Monthly Cash Income Amount Adult Leavers Client Monthly Cash Income Amount
11. Each Night Taa Without With Children With Only Unknown Children and Adults Children HH Type Average Number of Persons 436 89 241 38 186 94 7 88 o7 Point in Time Count of Persons on the Last Wednesday in Taa Without With Children With Only Unknown Children and Adults Children HH Type January 404 248 151 7 o April 383 218 161 4 o July 453 257 187 9 o October 500 269 223 6 2 9 Households Served During the Operating Year Number of Households Served During the Operating Year Total Without With Children With Only Unknown Children and Adults Children HH Type Households 1 227 1 076 136 14 1 Point in Time Count of Households Served on the Last Wednesday in Total Without With Children With Only Unknown Children and Adults Children HH Type January 295 242 47 6 0 April 267 216 47 4 July 316 253 56 7 o October 338 265 65 7 1 Diagram 3 Tab B see Diagram 3 This tab provides the information needed to complete questions 8 and 9 of the CoC APR Question 8 focuses on number and type of individuals served while Question 9 focuses on number and type of households served Question 8 includes three tables The first table shows counts of individuals served by household type The second table focuses on daily averages and the third on quarterly PIT counts Question 9 includes two tables The first table shows counts of households served by household type The second table focuses household counts rel
12. by the last recorded value in the client s record as opposed to a value recorded for an individual entry exit or service event Because this value would typically represent the most accurate information concerning the client it is applied retroactively to each of the client s entry exit and service records even though it may have in some cases actually been recorded after the event itself or may be different when compared to the value that was recorded in conjunction with the event itself 10 Closed Security Income Sub assessments This report assumes the sharing of client data between sub grantees as this is the common practice in most HUD workflows In situations where visibility of the income sub assessment data is not being shared between the sub grantees there is the potential for overstating client income amounts since two or more providers may be entering the same data without the knowledge that it has already been recorded 11 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 and 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 12 Disability Sub assessment Data Handling The Classifying clie
13. how counts in this tab are calculated Dimensions used as the basis for Question 12a b Client Unique Id Outreach Contact Count A Outreach First Location B Dimensions used as the basis for Question 12c Client Unique Id Outreach Contact Count B Outreach First Location B Bowman Systems Page 7 of 37 0625 HUD CoC APR ART Gallery Report v14 15a Gender Adults Gender of Adults Number of Adults in Households Total Without Children aa perez Male 786 763 23 0 Female 448 322 125 1 Transgendered 0 o o oO Other 0 o o oO Don t Know Refused 0 0 o oO Information Missing o 0 o oO Subtotal 1 234 1 085 148 1 15b Gender Children Gender of Children Number of Children in Households Total With Children With Only Unknown and Adults Children HH Type Male 179 171 8 o Female 142 135 7 oO Transgendered o 0 o o Other o o o oO Don t Know Refused 0 0 o oO information Missing 0 o o oO Subtotal 321 306 15 0 15c Gender Missing Age Gender of Persons Missing Age Information Number of Persons in Households Without With Children With Only Unknown Children and Adults Children HH Type o 0 oO o 1 oO o oO 1 o oO o e o 0 oO o o o Don t Know Refused o oO o o o Information Missing 0 o o 0 o Subtotal 1 0 0 0 1 Diagram 5 Tab D Question 15 Diagram 5 This tab provides the information needed to complete question 15 of the CoC APR which reports on client gender Question 15 i
14. persons who persons who Exhibit 2 Fah on ena were expected were expected whom the accomplished accomplished Target and to accomplish to accomplish measure is this measure this measure Actual this measure tis measure appropriate Performance 1 Housing Stability Measure 353 240 67 99 2a Total Income Measure 179 143 79 89 2b Earned Income Measure 76 68 89 47 36c Street Outreach Programs Exhibit 2 Exhibit 2 Actual of Difference Target of Target of person in the Actual of Actual of between persons who persons who program for persons who persons who Exhibit 2 khaaa Samar were expected were expected whom the accomplished accomplished Target and to accomplish to accomplish measure is this measure this measure Actual this measure tis measure appropriate Performance 1 Housing Stability Measure 26 42 31 2a Physical Disability 3 o 0 00 2b Developmental Disability 1 1 100 00 2c Chronic Health 0 0 0 00 2d HIV AIDS 1 1 100 00 2e Mental Health 10 1 10 00 2f Substance Abuse 1 20 00 36d Supportive Services Only SSO Programs Exhibit 2 Exhibit 2 Actual of Difference Target of Target of person in the Actual of Actual of between persons who persons who program for persons who persons who Exhibit 2 aera were expected were expected whomthe accomplished accomplished Target and to accomplish to accomplish measure is this measure this measure Actual this measure tis measure appr
15. type in or select from the calendar the day immediately following the last day of the reporting period For example if the reporting period is July 1 2009 September 30 2010 then October 1 2010 should be entered selected 5 Select Entry Type Click the refresh list icon and wait for the left window to refresh Now select the Entry Types to include by highlighting them in the left window and moving them into the right window using the right selection arrow 6 Enter Adult Age Enter 18 in the input window 7 EDA Provider The user should select the EDA provider to run the report as or leave it at the default Default Provider if EDA mode is not desired Bowman Systems Page 3 of 37 0625 HUD CoC APR ART Gallery Report v14 8 Enter effective date The user should type in or select from the calendar the day immediately following the last day of the reporting period 9 Is using the Disability Determination field part of your workflow for HUD reporting The user should select the appropriate Yes or No value based upon if they use the Disability Determination sub assessment question in their data entry workflow for HUD Please see Technical Note 12 for more information on how this prompt answer is used in the report 10 Is using the Receiving Income Source field part of your workflow for HUD reporting The user should select the appropriate Yes or No value based upon if they use the
16. ART Gallery Report 0625 HUD Continuum of Care Annual Performance Report CoC APR EXECUTIVE SUMMARY This ART Gallery report has been created to facilitate the extraction of data from ServicePoint for the completion of the CoC APR The layout of the report is patterned after the e SNAPS data input screens to facilitate on line reporting A companion ART Gallery Report 0631 provides the related data detail and data quality information needed by the user to insuring that the data to be reported is complete and accurate AUDIENCE HUD Grantees and Sub grantees FREQUENCY The CoC APR is submitted to HUD annually but this ART Gallery report should be run periodically to confirm that complete and accurate data is being properly recorded in ServicePoint PURPOSE Required reporting and program monitoring COMPATIBILITY AND SYSTEM REQUIREMENTS This version of the report requires ServicePoint 5x and ART 3x PREREQUISITES AND WORK FLOW REQUIREMENTS This report assumes adherence to the prescribed HUD workflow found in the APR Workflow PowerPoint file located in CollaboranGo including the proper collection and recording of the HUD universal and program specific data elements Clients are included in the report if they have e A program Entry by one or more of the selected Providers with an entry date that is on or before the last day of the reporting period e A corresponding program Exit date that is either null because the Client has n
17. Client Id from Entry Exit Client folder e Recordset from Entry Objects Disability sub assessment folder e Disability Type from Entry Objects Disability sub assessment folder DISABILITYTYPE e Start Date from Entry Objects Disability sub assessment folder DISABILITIES_1START e End Date from Entry Objects Disability sub assessment folder DISABILITIES_1END e Disability Determination from Entry Objects Disability sub assessment folder DISABILITYDETERMINE e If yes Currently receiving services or treatment from DISABILITYTREATMENT Do you have a disability of long term duration from HUD_DISABLINGCONDITION Entry Objects Disability sub assessment folder Entry Objects Bowman Systems Page 33 of 37 0625 HUD CoC APR ART Gallery Report v14 Filter Objects e Entry Exit Uid from Entry Exit folder Results from another query Last Entry Exit Id from HUD COC APR folder Bowman Systems Page 34 of 37 0625 HUD CoC APR ART Gallery Report v14 Query Name Disab Exit Universe ee_cutoff_u Result Objects Virtual field names for ASSESSMENT objects appear in parenthesis below their corresponding field names e Entry Exit Uid from Entry Exit Client folder e Client Unique Id from Entry Exit Client folder e Entry Exit Client Id from Entry Exit Client folder e Recordset Id from Exit Objects Disability sub assessment folder Disability Type from Exit Objects Disability sub assessment folder DI
18. Entry Exit folder from HUD COC APR folder Virtual field names for ASSESSMENT objects appear in parenthesis below their corresponding field names e Entry Exit Uid e Client Unique Id e Entry Exit Client Id e Non cash benefit received in past 30 days from Entry Exit Client folder from Entry Exit Client folder from Entry Exit Client folder from Entry Objects folder Bowman Systems ART Gallery Report Page 32 of 37 0625 HUD CoC APR v14 SVP_ANYSOURCE30DAYNONCASH Source of Non Cash Benefit from Entry Objects Non Cash Benefits SVP_NONCASHBENEFITSSOURCE sub assessment folder Receiving Benefit from Entry Objects Non Cash Benefits SVP_RECEIVINGBENEFIT Non cash benefit sub assessment folder received in past 30 days from Exit Objects folder SVP_ANYSOURCE30DAYNONCASH Source of Non Cash Benefit from Exit Objects Non Cash Benefits SVP_NONCASHBENEFITSSOURCE sub assessment folder Receiving Benefit from Entry Objects Non Cash Benefits SVP_RECEIVINGBENEFIT sub assessment folder Filter Objects e Entry Exit Uid from Entry Exit folder Results from another query Last Entry Exit Id from HUD COC APR folder Query Name Disab Entry Universe ee_cutoff_u Result Objects Virtual field names for ASSESSMENT objects appear in parenthesis below their corresponding field names e Entry Exit Uid from Entry Exit Client folder e Client Unique Id from Entry Exit Client folder e Entry Exit
19. Non Cash Benefit Types by Exit Status Leavers Non Cash Benefits Non Cash Benefits by Number of Persons Leavers Total Adults Children Age Unknown Supplemental Nutritional Assistance Program 392 382 10 o MEDICAID Health Insurance 48 43 5 o MEDICARE Health Insurance 17 17 o 0 State Children s Health Insurance 35 20 15 o wIc 1 1 0 o VA Medical Services 12 12 0 o TANF Child Care Services 1 1 o o TANF Transportation Services 0 oO o o Other TANF Funded Services 0 oO 0 o Temporary Rental Assistance o o o o Section 8 Public Housing Rental Assistance 2 2 o o Other Source 2 2 o 0 TOTAL 510 480 30 0 26a2 Non Cash Benefits by Exit Status Leavers Client Non Cash Benefits by Exit Status Number of Non Cash Benefits by Number of Persons Leavers Total Adults Children Age Unknown No Sources 214 1 Source s 435 Don t Know Refused 10 IMissing this Information 444 1 103 196 18 2 1 o Diagram 12 Tab K Question 26 Diagram 12 This tab provides the information needed to complete question 26 of the CoC APR Question 26 Tab K mirrors Question 25 Tab L but reports on sources of non cash benefits rather than cash income sources Like Question 25 Tab L Question 26 Tab K reports only on leavers and breaks down the data by Adult Child status Dimensions used as the basis for Question 26a1 Client Unique Id IncSourceNC Exit EE AdultChild EE Last Episode Block filter EE Leave Stay Bloc
20. Number of Adult Leavers Average Fae a aren sone Less Same More Unknown Change Program Entry Entry oa Incomeat Income at Income at Income Monthly Exit Exit Exit Change Income per Adult No Income 346 20 ss 77 24 292 32 51 150 12 7 o e 6 o 646 35 151 250 12 o 8 4 o 301 23 251 500 32 27 o 2 2 1 156 95 501 750 110 126 5 88 13 4 9 82 751 1 000 83 103 1 74 8 o 63 08 I 1 001 1 250 52 59 2 42 8 o 35 12 51 251 1 500 50 71 3 42 2 3 357 52 1 501 1 750 39 75 2 3 o 15 95 I 1 751 2 000 16 22 o 16 0 o 0 00 52 001 31 39 6 2 3 o 5404 68 Don t Know Refused 2 2 2 IMissing No Follow up 144 120 a A Total 929 929 19 599 133 178 138 05 24 Client Monthly Cash Income Amount by Entry and Latest Status Client Monthly Cash income Amount by Entry and Latest Status Number of Adult Stayers Average Waisai Follow up Less Same More Unknown Change Program Entry Entry Total Income at Income at Income at Income Monthly Follow up Follow up Follow up Change Income per Adult No Income 68 62 aes 61 7 0 103 26 1 150 2 o o 0 o 2 o 5151 250 5 4 o 4 1 o 272 60 251 500 16 18 o 12 4 o 119 52 501 750 55 49 2 43 2 1 92 75 5751 1 000 40 46 0 33 7 o 165 68 I 1 001 1 250 27 28 3 23 1 o 58 06 I 1 251 1 500 32 34 2 26 4 o 44 77 1 501 1 750 13 15 o 10 2 1 97 66 I 1 751 2 000 10 11 1 1 o 133 71 2 001 10 18 o 10 0 o 0 00 Don t Know Refused o o MissingNo Follow
21. SABILITYTYPE e Start Date from Exit Objects Disability sub assessment folder DISABILITIES_1START e End Date from Exit Objects Disability sub assessment folder DISABILITIES_1END e Disability Determination from Exit Objects Disability sub assessment folder DISABILITYDETERMINE e If yes Currently receiving services or treatment from Exit Objects Disability sub assessment folder DISABILITYTREATMENT Do you have a disability of long term duration from Exit Objects HUD_DISABLINGCONDITION Filter Objects e Entry Exit Uid from Entry Exit folder Results from another query Last Entry Exit Id from HUD COC APR folder Bowman Systems Page 35 of 37 0625 HUD CoC APR ART Gallery Report v14 0625 Revision History Version Description of Changes V11 05 11 Original version BETA V11 06 28 Revised version BETA e Income logic adjusted to consider total monthly income in Q7 Q23 and Q24 e Missing section of Q22 added 22b1 and 22b2 e Filter error corrected in Q19b e Mapping Guide error corrected and updated for logic changes e Input control Technical Note added to user manual e Cosmetic changes V3 Revised version BETA Revised Q23 and Q 24 to remove duplicate Total Monthly Income values Removed Unused variables Corrected associated dimensions in mapping guide Mapping Guide includes virtual field name for assessment questions V4 Revised version BETA Changed Q22 columns to fo
22. Use Total Monthly null null Income as entered Sum amounts of sub assessments 0 00 or null ARY a Or JARY eo gt 0 00 for individual sources to get total monthly income 0 00 or null No Null Any amount or null 0 00 A lecti t 0 00 or null No Ny Sclectiontiie Null 0 00 null 0 00 Yes or null Null Any amount or null 0 00 0 00 or null Don t Know or Any selection not Null rkn wi Refused null Don t Know or 0 00 or null Refused Null Any amount or null Unknown Null Yes or null Null Any amount or null NULL A lecti t 0 00 or null Yes or null ny a Null NULL Do not include any sub assessments that do not have a corresponding Income Source in the sum of sub assessment Income Diagram 18 Bowman Systems ART Gallery Report Page 24 of 37 0625 HUD CoC APR v14 15 Entry of data into HUD e SNAPS It should be noted that not all sections of this report are applicable to all HUD programs and since the e SNAPSdisplays only the applicable data entry screens there may be portions of this report that have no corresponding e SNAPS screens due to their inapplicability 16 Question 7 Income Logic In considering whether a client s monthly income information has been recorded both the Income sub assessment and the Total Monthly Income assessment question are considered If the user answers the Is using the Receiving Income Source field part of your workflow for HUD reporting prompt Yes then it will
23. ating Stay e PIT January e PIT April e PIT July e PIT October e Outreach First Location A e Outreach Contact Count A e Outreach First Location B e Outreach Contact Count B Filters Objects from from from from from from from from from from from from from from from from from from from from from from from from from from from from from e none Prompts hard coded in universe design HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder HUD COC APR folder Bowman Systems ART Gallery Report Page 29 of 37 0625 HUD CoC APR v14 Query Name EE Data Universe ee_ cutoff_u Result Objects Virtual field names for ASSESSMENT objects appear in parenthesis below their corresponding field names e Entry Exit Uid e Entry Exit Destination e Entry Exit Entry Date e Entry Exit Exit Date e Entry Exit Provider Id e Entry Exit Reason Leaving e Entry Exit Type e Entry Exit Tenure e Entry Exit Subs
24. ative to the quarterly PIT counts All Tab B calculations are based on the HUD vendor specifications for this reports as explained in Technical Note 3 In question 8 the Client Household Type methodology is used in the counting of households however in question 9 the Master Household methodology is used See Technical Note 4 for additional information regarding Household count methodologies It should be noted that for some grants that begin mid year the quarterly PIT counts will not display in chronological order For example grants beginning on October 1 will have their first quarter PIT data displayed on the fourth row labeled October rather than on the first row labeled January Note Question 8 Average Number of persons Served Each Night calculates the average number of persons served each night during the operating year by dividing the total number of nights of service among all persons served by the total number of nights during the operating year Household type for this field is determined by the household type on the last relevant stay in the operating year The total number of nights of service can be calculated using the program entry and exit dates for each stay a person has in the program For example if a person enters a unit on January 7 and exits during the day on January 10 the person has been provided three nights of service January 7 January 8 and January 9 Nights of service provided before the
25. ce 2 1 1 o Retirement Social Security 2 2 o o Veteran s Pension 7 7 0 0 Pension from Former Job 2 2 0 0 Child Support 14 13 1 0 Alimony Spousal Support 0 o o o Other Source 5 5 0 0 TOTAL 608 602 6 0 25a2 Cash Income by Exit Status Leavers Cash Income Sources Number of Cash Income Sources by Number of Persons Leavers Total Adults Children Age Unknown No Sources 186 152 Kad 0 1 Source s 692 637 55 Don t Know Refused 3 2 1 0 Missing this Information 201 125 76 o TOTAL 1 103 929 174 0 Diagram 11 Tab J Question25 Diagram 11 This tab provides the information needed to complete question 25 of the CoC APR Question 25 considers only clients who have exited the program leavers and reports on their sources of cash income at time of exit 25a1 shows the data detailed by income source while 25a2 summarizes the data into four categories No Sources 1 Source s Don t Know Refused and Missing this Information Both portions further breakdown the data by Adult Child status Dimensions used as the basis for Question 25a1 Merge Unique Id IncSource Exit EE Adult Child IncAmt Exit EE Last Episode Block filter EE Leave or Stay Block filter Dimensions used as the basis for Question 25a2 Client Unique Id Last 30 Day Income IncYN Exit EE AdultChild IncAmt Exit EE Last Episode Block filter EE Leave or Stay Block filter Bowman Systems Page 14 of 37 0625 HUD CoC APR ART Gallery Report v14 26a1
26. come Questions 36 b amp d count adults between the ages of 18 and 61 that increased their Earned Income Bowman Systems Page 18 of 37 0625 HUD CoC APR ART Gallery Report v14 Disability Measures a f Question 36c only counts clients that have a specific HUD disability recorded in the sub assessment as shown below in Diagram 15 If the user answers Yes to the Is using the Disability Determination field part of your workflow for HUD reporting prompt then it will also check to see if the corresponding Disability determination question is answered Yes or null If any other value is selected for the Disability determination the record will be excluded If the user answers No to the Is using the Disability Determination field part of your workflow for HUD reporting prompt then it will count all clients with a specific HUD disability recorded in the sub assessment as shown below in Diagram 15 Note If there are multiple disability records the record closest to the entry for stayers or exit for leavers is the one used for the calculation Measure HUD Disability 2a Physical Disability Physical Medical HUD 40118 or Physical HUD 40118 2b Developmental Disability Developmental HUD 40118 2c Chronic Health Disability Chronic Health Condition 2d HIV AIDS Disability HIV AIDS HUD 40118 2e Mental Health Disability Mental Health Proble
27. count all Income Sub assessment record sets where the Receiving Income Source is Yes or null and where the Income Source is a HUD valid value If the user answers the Is using the Receiving Income Source field part of your workflow for HUD reporting prompt No then it will count all Income Sub assessment record sets where the Income Source is a HUD valid value 17 Questions 7 and 26 Non Cash Benefits Logic The 0625 report uses the following logic for the Non Cash Benefits section of Q7 and Q26 If the user answers the Is using the Receiving Benefit field part of your workflow for HUD reporting prompt Yes then it will count all Non Cash Benefits Sub assessment record sets where the Receiving Benefit is Yes or null and where the Income Source is a HUD valid value If the user answers the Is using the Receiving Benefit field part of your workflow for HUD reporting prompt No then it will count all Non Cash Benefits Sub assessment record sets where the Non Cash Benefits is a HUD valid value Bowman Systems Page 25 of 37 0625 HUD CoC APR ART Gallery Report v14 18 IMPORTANT Known Installation Issue As stated above this report utilizes several detail type variables that are each associated with a particular dimension In testing the installation process with this report a mapping malfunction was sporadically encountered which resulted in the assoc
28. d Youth in Households Total Without With Children With Only Unknown Children and Adults Children HH Type PSH for Homeless persons 1 1 o o o Owned by Client no Subsidy 16 14 2 o o Owned by Client with Subsidy o o o o o Rental by Client no subsidy 75 64 9 2 o Rental by Client with VASH Subsidy o o o 0 o Rental by Client with other ongoing Subsidy 2 1 1 o o Hotel Motel Paid by Client 83 7 6 o o Staying or Living with Family 184 171 12 1 0 Staying or Living with Friend s 259 255 3 o 1 Other 15 12 3 o o Don t Know Refused 3 2 1 o 0 Information Missing so 30 26 3 o TOTAL 697 627 63 6 1 Diagram 8 Tab G Questions 20 Diagram 8 This tab provides the information needed to complete question 20 of the CoC APR Question 20 reports on the client s residence prior to program entry Question 20 again displays client counts by household type using the Client Household Type methodology See Technical Note 4 The prior living arrangement of the client is further broken down into 3 categories Homeless Situations Institutional Settings and Other Locations sections 20a1 20a2 and 20a3 respectively Dimensions used as the basis for Question 20a1 20a2 20a3 Client Unique Id Prior Residence Client HH Type Adult Child Block filter Unaccompanied Youth Block filter Last Episode Block Filter Bowman Systems ART Gallery Report Page 11 of 37 0625 HUD CoC APR v14
29. four income change columns the client is counted These questions involve the determination of a client s monthly income In cases where client s Total Monthly Income assessment question is populated that amount is used regardless of the sum of the sub assessment If the user answers the Is using the Receiving Income Source field part of your workflow for HUD reporting prompt Yes then it will count all Income Sub assessment record sets where the Receiving Income Source is Yes or null and where the Income Source is a HUD valid value If the user answers the Is using the Receiving Income Source field part of your workflow for HUD reporting prompt No then it will count all Income Sub assessment record sets where the Income Source is a HUD valid value NOTE A client must have a valid income amount 0 or more at both entry and at exit to be included in the Average Change calculation that is clients whose income is unknown at exit those counted in column 7 are excluded from the average change calculation Bowman Systems Page 23 of 37 0625 HUD CoC APR ART Gallery Report v14 Total Monthly Income Last 30 ineonecseurces Last 30 Day Income Income Yes No Mame Amount within the sub nes Income Category assessment assessment aemet within the sub question question assessment gt 0 00 Any selection or Any selection or Aamounternali
30. iated dimension being stripped from the variable during the installation process 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 and will publish an updated version if needed Meanwhile customers using this version of the report are strongly encouraged to verify that each of the detail variables in this report is properly displaying an Associated Dimension as shown E Variable Editor Variable Definition Name IEE Destination Qualification Detail i Associated dimension Type Formula Entry Exit Destination In cases where the Associated Dimension has been stripped during installation the Associated Dimension will appear blank E Variable Editor Variable Definition Name Qualification Detail Associated dimension Formula Entry Exit Destination When this has occurred the user will need to edit the variable specify the proper dimension save the variable and resave the report prior to use Variable Definition Name Gender Qualification P Detail Associated dimension All Ch Type is Objects and Variable Formula Ef client Gender Available Objects and Variable E 0623 HUD HPRP APH Age at Last Entry Client Date of Birt Z Client Date of Fi Bowman System
31. idy e Entry Exit Client Id e Client Unique Id e Client First Name e Client Last Name e Client Middle Name e Client Soc Sec No Dashed e Client SSN Data Quality e Client Gender e Client Primary Race e Client Secondary Race e Client Ethnicity e Is Client U S Military Veteran VETERAN e Zip Code of Last Permanent Address HUD_ZIPCODELASTPERMADDR e Zip data quality HUD_ZIPDATAQUALITY e Type of Living Situation TYPEOFLIVINGSITUATION e Date of Birth Type SVPPROFDOBTYPE e Housing Status HOUSINGSTATUS e Housing Status HOUSINGSTATUS e Domestic Violence victim survivor DOMESTICVIOLENCEVICTIM e Extent of Domestic Violence HUD_EXTENTOFDV e Entry Exit Provider Program Type from from from from from from from from from from from from from from from from from from from from from from from from from from from from from from Entry Exit folder Entry Exit folder Entry Exit folder Entry Exit folder Entry Exit folder Entry Exit folder Entry Exit folder Entry Exit folder Entry Exit folder Entry Exit Client folder Entry Exit Client folder Entry Exit Client Client Unique Id folder Entry Exit Client Client Unique Id folder Entry Exit Client Client Unique Id folder Entry Exit Client Client Unique Id folder Entry Exit Client Client Unique Id folder Entry Exit Client folder Entry Exit Client folder Entry Exit Client folder Entry Exit
32. is for Question 19a Client Unique Id DV Client HH Type Adult Child Block filter Unaccompanied Youth Block filter Dimensions used as the basis for Question 19b Client Unique Id DV Ext Client HH Type Adult Child Block filter Unaccompanied Youth Block filter Bowman Systems Page 10 of 37 0625 HUD CoC APR ART Gallery Report v14 20a1 Residence Prior to Program Entry Homeless Situations Residence Prior to Program Entry Homeless Situations Number of Persons in Households Total Without With Children With Only Unknown Children and Adults Children HH Type Emergency Shelter 245 175 69 1 o Transitional housing for homeless persons 63 50 12 1 o Place not meant for habitation 140 137 3 o o Safe Haven o 0 o o o TOTAL 448 362 84 2 o 20a2 Residence Prior to Program Entry Institutional Settings Residence Prior to Program Entry Institutional Settings Number of Persons in Households Hii Without With Children With Only Unknown Children and Adults Children HH Type Psychiatric hospital or other psychiatric facility 12 12 o o o Substance abuse treatment facility or detox center 26 26 0 o 9 Hospital Non psychiatric 14 14 0 o o Jail prison or juvenile detention facility 39 38 1 o o Foster Care 6 6 o o o TOTAL 97 96 1 o 0 20a3 Residence Prior to Program Entry Other Locations Residence Prior to Program Entry Other Locations Number of Adults and Unaccompanie
33. k filter Dimensions used as the basis for Question 26a2 Client Unique Id IncSourceNC Exit EE AdultChild IncNCYN Exit EE Last Episode Block filter EE Leave Stay Block filter Bowman Systems Page 15 of 37 ART Gallery Report 0625 HUD CoC APR v14 27 Length of Participation by Exit Status Length of Participation by Exit Status Number of Persons Total Leavers Stayers Less than 30 days 614 567 47 31 to 60 days 229 186 43 61 to 180 days 328 104 134 181 to 365 days 150 70 80 366 to 730 days 1 2 Yrs 130 63 67 731 to 1095 days 2 3 Yrs 41 13 28 10906 to 1460 days 3 4 Yrs 25 5 20 1461 to 1825 days 4 5 Yrs 10 1 9 More than 1825 Days gt 5 Yrs 29 4 25 Information Missing o o o Total 1 556 1 103 453 Average and Median Length of Participation in Days Average Length Leavers 106 Stayers 524 Median Length 30 184 Diagram 13 Tab L Question27 Diagram 13 This tab provides the information needed to complete question 27 of the CoC APR Question 27 reports Length of program participation by exit status that is whether the client is a leaver or a stayer The top table breaks down length or stay LOS by duration while the bottom table reports the average mean and the median LOS TIP If the mean LOS is higher than the median LOS then it means that some clients have really long stays relative to the rest of the clients and are driving up the average Dimensi
34. llow HUD guidelines Adults Children Unknown Updated Q25 to count Income Sources without amounts Updated Q25 to count non HUD Income Sources as Other Updated Q26 to count non HUD Benefit Sources as Other V5 Revised version BETA Updated report description to reference HUD CoC APR instead of HUD HPRP Updated Mapping Guide with clarification on Source of Non Cash Benefit location Updated Q7 to count Residence Prior to Entry for adults and unaccompanied youth only Same as Q20 Updated Q23 and Q24 to correct count No Income for Same Income at Exit column V6 Revised version BETA Resolved issue with reporting on data entered after the reporting period V7 Revised version Updated Q23 24 with new HUD logic to count Total Monthly Income where present regardless of sum of income in subassessment Reference updated income table for details Updated Q25 with updated HUD guidelines on counting Income Sources Added EDA Provider to Prompt Summary V8 Revised version BETA Updated Q23 and Q24 to properly calculate Unknown Income Change Updated Q23 and Q24 to count income between 0 01 and 0 99 Updated Q23 and Q24 to mark clients with Total Monthly Income 0 00 Income Last 30 Days null and No Income Source specified as No Income instead of Missing Updated Technical Note 14 v9 Corrected header for Q26b2 V10 Revised version BETA Updated logic for counting disabilities conditions on Tab F and H Added Que
35. m HUD 40118 2f Substance Abuse Alcohol Abuse HUD 40118 or Drug Abuse HUD 40118 or Both alcohol and drug abuse HUD 40118 Diagram 15 Actual of persons in the program for whom the measure is appropriate At entry the If yes Currently receiving services or treatment question must be answered No or left blank Actual of persons who accomplished this measure Counts all clients where the If yes Currently receiving services or treatment question was answered No or was left blank as of entry and there is another record of the same disability category with the If yes Currently receiving services or treatment question answered Yes as of exit Note Users should only edit disability sub assessment records to enter an End Date or make a correction To show a value has changed over time the user should enter an End Date in the previous record and create a new disability record with the new values Dimensions used as the basis for Question 36a b d e f Client Unique Id EE Destination Client Household Type EE Last Episode Block filter EE Leave or Stay Block filter EE Program Type EE AdultChild EE Age Entry IncSource Exit Income Change Dimensions used as the basis for Question 36c Client Unique Id EE Destination Client Household Type EE Last Episode Block filter EE Leave or Stay EE Program Type Block filter Disab 36c Group Entry Disab36c Group Exit Service Entry Se
36. me sub assessment folder from Entry Objects from Entry Objects Monthly Income sub assessment folder from Entry Exit folder from HUD COC APR folder Bowman Systems ART Gallery Report Page 31 of 37 0625 HUD CoC APR v14 Query Name Inc Exit Universe ee_ cutoff_u Result Objects Virtual field names for ASSESSMENT objects appear in parenthesis below their corresponding field names e Entry Exit Uid e Client Unique Id e Entry Exit Client Id e Income received from any source in past 30 days SVP_ANYSOURCE30DAYINCOME e Recordset ID e Source of Income SOURCEOFINCOME e Start Date MONTHLYINCOMESTART e End Date MONTHLYINCOMEEND e Last 30 Day Income AMOUNTMONTHLYINCOME e Total Monthly Income HUD_TOTALMONTHLYINCOME e Receiving Income Source SVP_RECEIVINGINCOMESOURCE Filter Objects e Entry Exit Uid Results from another query Last Entry Exit Id Query Name Non Cash Universe ee_ cutoff_u Result Objects from Entry Exit folder from Entry Exit Client folder from Entry Exit Client folder from Exit Objects folder from Exit Objects Monthly Income sub assessment folder from Exit Objects Monthly Income sub assessment folder from Exit Objects Monthly Income sub assessment folder from Exit Objects Monthly Income sub assessment folder from Exit Objects Monthly Income sub assessment folder from Exit Objects from Exit Objects Monthly Income sub assessment folder from
37. mple 501 750 will now shows clients with 501 00 750 99 Added additional detail to manual for question 8 V14 Revision Disability Determination not included in 2 variables Disab 36c Group Entry and Disab 36c Group Exit Corrected this error V14 Doc Only ART universe updated to allow for more than one Entry Exit type to be selected in the same report run User Manual updated to indicate the implications of this change Changed Query 1 name from Data to BlSData Bowman Systems Page 37 of 37 0625 HUD CoC APR ART Gallery Report v14
38. n 2 non housing at housing place was pod service site location missing Once 72 0 0 0 72 2 5 Times 1 0 0 1 0 6 2 Times o o 0 o o 10 Times o o oO o 0 TOTAL 73 0 o 1 72 Number of Persons Engaged by Number of Contacts During the Operating Year S a First contacted First contacted First contact Total Riad forhoman 3tnon housing at housing place was ices service site location missing 1 Contact 63 o 0 o 63 2 5 Contacts 1 o 1 0 l 9 Contacts o o o o o 10 Contacts o o o o o TOTAL 64 o o 1 63 Rate of Engagement 87 67 o o 100 00 87 50 Diagram 4 Tab C Question 12 Diagram 4 This tab provides the information related to Street Outreach contacts and engagements that is needed to complete question 12 of the CoC APR Question 12 Tab C contains 3 tables The top table crosstabs the outreach counts by frequency of contact and the location of the first contact The second table is a subset of the population counted in the first table limited to only those who were engaged as a result of the contacts The third simply shows the overall engagement rate and breaks it down by the location of first contact Note that question 12 uses the Outreach sub assessment and the Date of Engagement assessment question In order for data to be properly transferred to the data universe the Outreach sub assessment needs to be marked as reportable added to an assessment and published to the appropriate provider s See Technical Note 13 for more information concerning
39. n 17 7 10 a o American Indian or Alaska Native 97 70 24 3 o Native Hawaiian or Other Pacific Islander 1 o o Multiple Races 42 16 24 2 o Don t Know Refused 9 1 8 a o Information Missing 44 17 27 o o Total 1 556 1 085 454 15 2 Diagram 6 Tab E Questions 16 17 Diagram 6 This tab provides the information needed to complete questions 16 and 17 of the CoC APR Question 16 reports on client age and displays client and household counts by age category Grayed out cells indicate non applicable age household type categories It should be noted that clients whose reported date of birth indicates that they are less than zero or greater than 100 year of age are considered to be data entry errors and are reported on in a separate row labeled Age Error Negative Age or 100 This Row is NOT included in the HUD e SNAPS and theses clients are not included in any of the other age categories so it is important that their dates of birth DOBs be corrected to allow them to be properly reported Question 17 focuses on Ethnicity 17a and Race 17b displaying client and household counts by category Non HUD values are placed in the Information Missing category Questions 16 and 17 both utilize the Client Household Type of household counting See Technical Note 4 Dimensions used as the basis for Question 16 Client Unique Id Age at Last Entry Client Household Type EE Adult Child Block filter Dimensions used as the basis for Question 17a
40. ng installation the Associated Dimension will appear blank When this has occurred the user will need to edit the variable specify the proper dimension save the variable and resave the report prior to use The table in Technical Note 18 below lists the detail variables in this report along with their proper associated dimension To insure that this report is returning the proper results it is very important that these associations be checked verified following installation and prior to running the report Before running the report Prior to running the report the user must have access to the list of ServicePoint providers included in the grant and the starting ending dates for the current reporting period Bowman Systems Page 2 of 37 0625 HUD CoC APR ART Gallery Report v14 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 Refresh Data button to generate the report Prompts s gt Select or type the prompt values for each prompt below 1 Select Provider Group s EMPTY_VALUE EDA Provider Default Provider lt 4 m Select Provider s 1 10th Street Shelter 2055 EDA Provider Defaul
41. nning the report and lists the parameters specified in the user prompts as well as client counts by provider Client Count represents the number of clients in the dataset that is the number served during the grant Note in most cases this will be a greater number than those served during the reporting period e Unique Clients is the Client Count de duplicates the client count using the Client Unique Id algorithm Dimensions used as the basis for Additional Information Tab Client Unique Id Entry Exit Client Id Bowman Systems ART Gallery Report Page 20 of 37 0625 HUD CoC APR v14 TECHNICAL NOTES 1 Special data universe It should be noted that this report utilizes a special single purpose data universe created specifically for this report This universe incorporates the unique logic of the CoC APR and when used in conjunction with the entry exit universe allows the proper counting and classification of households as laid out in the HUD report specifications This special universe is not designed or intended for general customer use and is not supported beyond the scope of this report and other related Gallery reports which may utilize it 2 Special Query Design This report utilizes an ART 3 x feature that allows a query filter to select records based on the results of another query In this report the first query which is based on the special data universe produces listings of Entry Exit Uids as result
42. nt disability categories table below Diagram 17 shows how clients are included in Q7 Q18a Q18b Q22a2 and Q22b2 of the CoC APR as specified by v1 9 of the document entitled HUD Annual Performance Report APR Programming Specifications The first column displays the Do you have a disability of long duration question the second column is the count of HUD Disability Types and the last Result column shows the classification for the CoC APR The three fields used in classifying disabilities for the CoC APR are the Disability determination field on the Disability Sub assessment the Disability Type field on the Disability Sub assessment and the Do you have a disability of long duration Assessment question Classifying client disability categories If the user answers the Is using the Disability Determination field part of your workflow for HUD reporting prompt Yes then it will count all Disability Sub assessment record sets where the Disability determination is Yes or null and the Disability type is HUD valid value If Disability Type is Both alcohol and drug abuse HUD 40118 count as two disabilities If the user answers the Is using the Disability Determination field part of your workflow for HUD reporting prompt No then it will count all Disability Sub assessment record sets where Bowman Systems Page 22 of 37 0625 HUD CoC APR ART Gallery Rep
43. o Don t Know Refused 8 1 7 o o Information Missing a7 1 20 5 1 TOTAL 1 242 1 085 148 8 1 19b When Past Domestic Violence Experience Occurred Number of Adults and Unaccompanied Children in Households Total Without With Children With Only Unknown Children and Adults Children HH Type Less than 3 Months 2 1 1 oO o 3 to 6 Months Ago o o 0 oO oO 6 to 12 Months Ago o o o 0 o More tha a year Ago o o o oO o Don t Know Refused o oO i 0 oO Information Missing 128 73 54 1 o TOTAL 130 74 55 1 o Diagram 7 Tab F Questions 18 19 Diagram 7 This tab provides the information needed to complete questions 18 and 19 of the CoC APR Question 18 reports on disabling conditions at time of entry and displays client counts by household category Question 19 reports on domestic violence conditions and also displays client counts by household type Questions 18 and 19 both utilize the Client Household Type of household classification See Technical Note 4 Dimensions used as the basis for Question 18a Client Unique Id Disability Type Disability determination EE Client Household Type Recordset Id from the Disability subassessment EE Last Episode Block filter Dimensions used as the basis for Question 18b Client Unique Id Disability Type Disability determination EE Client Household Type Disab Condition Recordset Id from the Disability subassessment EE Last Episode Block filter Dimensions used as the bas
44. ons used as the basis for Question 27a b Client Unique Id Length of Stay Leaver or Stayer Last Episode Block filter Bowman Systems ART Gallery Report Page 16 of 37 0625 HUD CoC APR v14 29a1 Destination by Household Type and Length of Stay All Leavers who Stayed More tha 90 Days Permanent Destinations Number of Leavers in Households Teta Without With Children With Only Unknown Children and Adults Children HH Type lowned by Client no Ongoing Subsidy 3 oO 3 0 o Owned by Client with Ongoing Subsidy o o o o o Rental by Client no Ongoing subsidy 40 12 28 o 0 Rental by Client with VASH Subsidy 2 1 1 o o Rental by Client with other Ongoing Subsidy 21 3 18 o o PSH for Homeless Persons 3 3 o o o Living with Family Permanent Tenure 3 3 o o o Living with Friends Permanent Tenure 3 3 o o o Subtotal 75 25 50 o o Temporary Destinations Emergency Shelter 2 2 o o o ITH for Homeless Persons 7 7 0 0 o Staying with Family Temporary Tenure 12 3 9 o o Staying with Friends Temporary Tenure 12 9 3 o o Place Not Meant for Human Habitation 2 2 o o o Safe Haven o o o o o Hotel or Motel Paid by Client 3 3 o o o Subtotal 38 26 12 o o Institutional Settings Foster Care 0 o o o o Psychiatric Facility 1 1 o o o Substance Abuse or Detox Facility 2 2 o o o Hospital non Psychiatric 1 1 0 0 o Jait or Prison 1 1 o o o Subtotal 5 5 o o o Other Destinations Deceased 3 o 3 0 o other 5
45. opriate Performance 1 Housing Stability Measure 9 5 55 56 2a Total Income Measure 4 4 100 00 2b Eamed Income Measure 3 3 100 00 36e Safe Haven Programs Exhibit 2 Exhibit 2 Actual of Difference Target of Target of person in the Actual of Actual of between persons who persons who program for persons who persons who Exhibit 2 Paa Maseans were expected were expected whom the accomplished accomplished Target and to accomplish to accomplish measure is this measure this measure Actual this measure tis measure appropriate Performance 1 Housing Stability Measure 51 17 33 33 ka Total Income Measure 51 42 82 35 Diagram 14 Tab N Question 36 Diagram 14 This tab provides the information needed to complete question 36 of the CoC APR Question 36 reports on performance measures by program type Housing Stability Measure Questions 36a amp 36e count stayers who maintained housing stability or leavers who exited with a specific exit destination Questions 36b 36c amp 36d counts on leavers only Total Income Measure Includes both stayers and leavers Questions 36 a amp e count adults that either maintained or increased their income Questions 36 b amp d count adults that increased their income Earned Income Measure Includes both stayers and leavers Question 36 a count adults between the ages of 18 and 61 that either maintained or increased their Earned In
46. or Unaccompanied Youth 8 Total number of records for Leavers 1 103 Data Element Missing Data First Name o o Last Name o o ISSN oO o Date of Birth 1 o Race e 44 Ethnicity 9 1 Gender oO o Veteran Status 10 3 Disabling Condition 20 19 Residence Prior to Entry 3 59 Zip of Last Permanent Address 65 13 Housing Status at entry 18 1 076 Income at entry 11 350 Income at exit 9 213 Non Cash Benefits at entry 16 814 Non Cash Benefits at exit 12 444 Physical Disability at entry 6 54 Developmental Disability at entry 1 54 Chronic Health Condition at entry o 54 HIV AIDS at entry 0 54 Mental Health at entry 4 54 Substance Abuse at entry 8 54 Domestic Violence at entry 8 37 Destination 70 309 Diagram 2 Tab A Question 7 Diagram 2 This tab provides the information needed to complete Question 7 of the CoC APR Question 7 focuses on data completeness The upper table of Tab A displays the total number of client records included in the report the number of adults the number of unaccompanied youth and the number of leavers The bottom table of Tab A displays the number of total clients with a unknown values for the various data elements with column two reporting those with Don t Know or Refused answers and column three reporting those with missing values All Tab A calculations are based on the HUD vendor specifications for this reports as explained in Technical Note 3 It should be noted however
47. ort v14 the Disability type is HUD valid value If Disability Type is Both alcohol and drug abuse HUD 40118 count as two disabilities Do you have a disability of long duration Disability Type Count No HUD pf None i O Yes HUD Condition Unknown Don t Know HUD Refused HUD P Don t Know Refused null or any other Non HUD value Missing Information any value including null 1 2 3 Condition s Diagram 17 13 Street Outreach Contacts and Engagements It is important to note that question 12 uses the Outreach sub assessment and the Date of Engagement assessment question In order for this data to be properly transferred to the data universe the Outreach sub assessment needs to be marked as reportable added to an assessment and published to the appropriate provider s It should be noted that while alternative workflows methods for collecting street outreach contacts and engagements are possible using ServicePoint and may be in keeping with the HUD HMIS Data Standards they are not currently supported by this report so implementations using such alternatives will need to substitute alternative own data for the Tab C data when transferring the information into the e SNAPS 14 Question 23 24 Logic The chart below Diagram 18 represents the logic error handling used in determining the client s income category at entry The same logic is used in determining the client s income at exit and subsequently in which of the
48. ot yet exited or falls on or after the first day of the reporting period IMPORTANT Question 12 of the CoC APR On Tab C extracts information for reporting on Street Outreach programs and uses the Outreach sub assessment and the Date of Engagement assessment question In order for this report to function properly and data to be transferred to Bowman Systems Page 1 of 37 0625 HUD CoC APR ART Gallery Report v14 the data universe the Outreach sub assessment needs to be marked as reportable added to an assessment and published to the appropriate Provider s This step is necessary even if these questions are not being utilized 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 5 tg Reports gt ART gt Last Viewed Favorites x Advanced Reporting Tool Home ClientPoint New Report net ART Browser ShelterPoint gt UB Inbox gt MB Favontes Ore gt EB ART Documentation gt ART Report Templates Call Record Report ART 3 x Gallery Rele Client Served Report gt Uy ART 3 x Galery Released Daily Unit Report gt ig ART 3 x Gallery BETA Duplicate Client Report bait bra pa 0114 System Growth by Chents v11 05 31 Released AR 5 S Gi th by Si 05 Rel d 2011 12 31 21 34 Needs Report 0115
49. rvice Exit Disab Date Entry Disab Date Exit Bowman Systems Page 19 of 37 0625 HUD CoC APR ART Gallery Report v14 HUD CoC APR Annual Performance Report Additional Information User Prompt Field Value s Selected 1 Select Provider Group s 1 Select Provider s 1 10th Street Shelter 2055 2 Enter Start Date 1 1 2009 3 Enter End Date PLUS 1 Day 1 1 2010 4 Select Entry Type HUD 5 Enter Adult Age 18 EDA Provider Default Provider Enter Effective Date 1 1 2010 Is using the Disability Determination field part of your Yes workflow for HUD reporting Is using the Receiving Income Source field part of your Yes workflow for HUD reporting Is using the Receiving Benefit field part of your workflow Yes for HUD reporting Client Count Unduplicated Provider Reporting Information Based on Uid Count 1 10th Street Shelter 2055 96 96 Additional Information 2012 Bowman Systems L L 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 333 Texas Street 300 Shreveport LA 71107 Toll Free 888 580 3831 Direct 318 213 8780 Fax 318 213 8784 htip www bowmansystems com Diagram 16 Tab O Additional Information Diagram 16 Tab O data is NOT entered into the HUD e SNAPS but rather is provided as a reference to the user ru
50. s Page 26 of 37 0625 HUD CoC APR ART Gallery Report v14 The table below lists the detail variables in this report along with their proper associated dimension To insure that this report is returning the proper results it is very important that these associations be checked verified following installation and prior to running the report Detail Variable Associated Dimension Disab 36c Group Entry Merge Last EE Id Disab 36c Group Exit Merge Last EE Id Disab Condition Entry Merge Last EE Id Disab Condition Exit Merge Last EE Id Disab Date Entry Merge Last EE Id Disab Date Exit Merge Last EE Id DV Merge Last EE Id DV Ext Merge Last EE Id EE Adult Child Merge Last EE Id EE Age at Entry Merge Last EE Id Ee Client HH Type Merge Last EE Id EE Destination Merge Last EE Id EE Last Episode Merge Last EE Id EE Leave Stay Merge Last EE Id EE Program Type Merge Last EE Id Eth Merge Last EE Id Gender Merge Last EE Id Housing Status Entry Merge Last EE Id Housing Status Exit Merge Last EE Id Inc 36 Earned Income Merge Unique Id Inc Amt Entry Merge Last EE Id Inc Amt Exit Merge Last EE Id Inc NCYN Entry Merge Last EE Id Inc NCYN Exit Merge Last EE Id Inc Source Entry Merge Recordset Id Inc Source Exit Merge Recordset Id Inc Source NC Entry Merge Last EE Id
51. s divided into 3 parts with 15a focusing on adults 15b on children and 15c on those of unknown age In this section of the report household types are determined by the Client Household Type method See Technical Notes 3 and 4 below Dimensions used as the basis for Question 15 a b and c Client Unique Id Gender Client Household Type Adult Child Block filter Bowman Systems ART Gallery Report Page 8 of 37 0625 HUD CoC APR v14 16 Age Age Number of Persons in Households Total Without With Children With Only Unknown Children and Adults Children HH Type Under 5 144 Bsa 139 5 o 5 12 139 M 129 10 o 13 17 38 ee ee 38 o o 18 24 188 153 4 O 1 25 34 280 204 76 o 325 44 278 253 25 E o 45 54 339 327 1 a o 55 61 109 109 o o 82 40 30 1 E eee o Don t Know Refused 1 o o o 1 Information Missing o o o o o Age Error Negative Age or 100 0 oO o o o Total 1 556 1 085 454 15 2 17a Ethnicity Ethnicity Number of Persons in Households T Without With Children With Only Unknown Children and Adults Children HH Type Non Hispanic Non Latino 1 461 1 027 419 15 o Hispanic Latino 85 87 28 o Don t Know Refused a o 7 o 2 Information Missing 1 1 o o o Total 1 556 1 085 454 15 2 17b Race Race Number of Persons in Households ad Without With Children With Only Unknown Children and Adults Children HH Type White 067 711 250 4 2 Black or African American 379 262 111 6 o Asia
52. s objects and the other queries then use these listings as query filter criteria 3 Report Specifications HUD specifications for this report are lengthy and complex and this user manual does not attempt to cover all of the various programming logic and nuances involved Complete specifications for this report are contained in the HUD CoC APR Programming Specification document available on the HUD HRE website CoC APR Programming Specifications 4 Household counting and classification HUD specifications for this report involve two variations on the manner in which households are classified and counted These methods are described in much greater detail in the CoC APR Programming Specifications a Master Household method This is anew HUD methodology for counting and classifying households used only in question 9 It is relatively complex in that it is based on the client s past history of entries rather than on a single entry b Client Household Type method This is a more traditional method based the number and ages of clients sharing the program entry of the clients last program stay This methodology is used in questions 8 15 16 17 18 19 20 21 22 and 29 5 De duplication This report de duplicates various parts of the report according to HUD specifications using ServicePoint s Client Unique Id field 6 Inclusion In order for a client or household to be properly included in this report the work
53. start of the operating year or after the end of the operating year are excluded If you have clients with multiple stays in the program run the APR for multiple providers or include more than one entry exit type where the client has stays in different providers all of the stays will be summed together and this can result in a higher average served per night Bowman Systems Page 6 of 37 0625 HUD CoC APR ART Gallery Report v14 than total clients served For example if client A has a stay of 365 nights with one provider and a stay of 365 nights with another provider this will come out to an average of 2 persons served per night even though this is the same client Dimensions used as the basis for Question 8a Client Unique Id Adult Child Client Household Type Date of Birth Type Dimensions used as the basis for Question 8b Length of Operating Stay Client Household Type Dimensions used as the basis for Question 8c Client Unique Id PIT January PIT April PIT July PIT October Client Household Type Dimensions used as the basis for Question 9a Master Household Id Master Household Type Dimensions used as the basis for Question 9b Master Household Id Master Household Type PIT January PIT April PIT July PIT October 12 Client Contacts and Engagements Number of Persons Contacted Rates During the Operating Year First contacted First contacted First contacted First contact Total aa a forhuma
54. stion 36 Updated manual and screen shots V11 Revised version BETA Altered wording in Q25 26 to match information in e SNAPS Tabs A I J N Altered income information to use Receiving Income Source sub assessment question based upon answer to prompt question Tabs A and K Altered non cash information to use Receiving Benefit sub assessment question based upon answer to prompt question Tabs A F H N Altered disability information to use Disability Determination sub assessment question based upon answer to prompt question Tab N Q36B D 1 2a 2b Altered to count leavers only 2a 2b Altered to count only clients that increased their income Updated User Manual with hyperlink between technical note references and the actual technical note Bowman Systems ART Gallery Report Page 36 of 37 0625 HUD CoC APR v14 V12 Revised version BETA Altered calculation for Q36b amp d Earned Income per HUD clarification to count only leavers Changed HDX references to e SNAPS on pages 1 9 20 23 25 28 V13 Revision Modified Tab A to count anonymous clients as missing for First Name and Last Name Resolved issue on Tab J where if there were 2 or more No Financial Resources HUD records with conflicting answers to the Income Received question the records will be counted as No Income Resolved issue on Tab J where cents between categories weren t accounted for For exa
55. t Provider m lt N Enter Start Date 1 1 2009 Enter End Date PLUS 1 Day 1 1 2010 lt w lt 4 e Select Entry Type HUD EDA Provider Default Provider 5 Enter Adult Age 18 EDA Provider Default Provider Enter effective date 1 1 2010 12 00 00 AM if EEE Is using the Disability Determination field part of your workflow for HUD reporting Yes EDA Provider Default Provider lt 4 Is using the Receiving Income Source field part of your workflow for HUD reporting Yes EDA Provider Default Provider m vV Is using the Receiving Benefit field part of your workflow for HUD reporting Yes EDA Provider Default Provider Select a custom date 1 1 2010 Diagram 1 The eleven user prompts contained in this report are 1 Select Provider Group s Click the refresh list icon and wait for the left window to refresh Now select the provider groups to include by highlighting them in the left window and moving them into the right window using the right selection arrow 2 Select Provider s Click the refresh list icon and wait for the left window to refresh Now select the providers to include by highlighting them in the left window and moving them into the right window using the right selection arrow 3 Enter Start Date The user should type in or select from the calendar the first day of the reporting period year 4 Enter End Date PLUS 1 DAY The user should
56. up 27 Te ee 7 Total 305 305 8 230 36 34 78 95 Diagram 10 Tab l Questions 23 24 Diagram 9 This tab provides the information needed to complete questions 23 and 24 of the CoC APR Question 23 considers only clients who have exited the program leavers and reports on changes in income between date of entry and date of exit Question 24 like Question 23 reports on income change but considers only clients who have not yet exited the program stayers and the comparison is between income at entry and income at time of most recent follow up Grayed out cells indicate non applicable incalculable combinations See Technical Note 14 for an explanation of how a clients monthly income is determined Dimensions used as the basis for Question 23 24 Client Unique Id Last 30 Day Income Inc YN Entry No Income to Zero Unknown Exit Income Leave or Stay Block filter Adult Child Block filter Last Episode Block filter Bowman Systems Page 13 of 37 0625 HUD CoC APR ART Gallery Report v14 25a1 Cash Income Types by Exit Status Leavers Cash Income Sources Type of Cash income Sources by Number of Persons Leavers Total Adults Children Age Unknown Earned Income 325 323 2 o Unemployment Insurance 54 54 oO 0 ssi 120 119 1 i ISSDI 69 69 0 0 Veteran s Disability 3 3 0 0 Private Disability Insurance 1 1 0 0 Worker s Compensation 1 1 0 0 TANF or Equivalent 3 2 1 o General Assistan
Download Pdf Manuals
Related Search