Client Transition Outcomes - v1 USER MANUAL - MSCCOC
Contents
1. 1 ABC Shaha for vores and Farr SS25 1 AP Faih Firat Rescue 500 1 1 AP Grace Hou ESTE 1 AF Mercy Street Seston P5005 1 AP Serenity Services 1574 1 Core Hana 7005 1 Countyaide Electric Company 1251 1 BRC Ash Street Sade Howes 05 1 BPC Gedar Sireet ReachOnal7 76s 1 BRC HH DIGAS 1 BRC HH Trama for Jobs Program HA 1 EFC Maple Street THF PTOWT444 1 EFC Maple Street THF STABLET 442 1 BPC Maple Street Transitional Housing Program 3374 1 EFC Oak Street Housing 7245 1 EFC gk Street Housing SAHT 1 EFC Oak Street Housing Taipo 1 Exvengreen Forest bormu ih 1 ECA Bae Sires Program 7004 1 PCA Pike Street Emesgenoy Lodgeng Propan 1 ECA gt Waleye Street Emergency Rem Assistance Prgm 71531 1 HPAP Cranberry Care Stasjon iipit 1 HPAP Fig Forty CentenB trai 1 HFRP Lemon Lane Loipen biiy 1 HPRP Mango Moroi 2603 1HPRP Pear Place S682 1 HPRP Rasbery House ae 1 HFRP Saber Satoni Tat 1 Old Towne Sheher 143 tr 1075 Emengeny Shelter 51H 1 OTS Transsonal Living Program iia 1 O2 ECHA4 Don s RAF ESHT 3001 1 OZ2 ECHA Doris Fem Assistance Propam 7 385 1 1 OC Emeraid City Housing Author 7323 Select Providers Col Code Corning Fro miona F Salect Program Types Coming Fron Emergency Shatter HUD Set Providers Garg Te Sec Providerg Col Code Gorg Ta Select Program Types Gorg To Emesrgenos Shelter IDS Ho 2 Prowidera Reporting Iinformatioa in thie Report Chent Count Decuanrenctes T2. No Service 5 Frequency within Outcome Service Types Provided and Outcome Ho Transition Transition Total Alcoholism Counseling 2 o 2 Basic Needs 5 o 5 ahs ARANA PExpenseta mediante A HE rji Ho Service 5 o 5 Information summary 100 00 2 of 2 100 alcoholism counseling have no transition 0 O of 2 0 alcoholism counseling have a transition y ay 0 0 of 5 0 no service have a transition Whether or not a client has a service type is calculated and therefore no occurrences are missing due to missing services e On Tab G clients may have multiple service types which will be counted in each of the service type categories so the sum of service types may be higher than the total number of occurrences See highlighted totals above e On Tab l clients may have multiple income sources These will be counted in each of the income source categories so the sum may be higher than the total number of occurrences See highlighted totals above 3 1 H J K Number of Services Income Sources and Monthly Income These tabs report on aggregate count of number of services income sources or monthly income Null values are reflected on the reports as zero services zero income sources or missing income See Diagram 3 1 B K for example of layout e Tab H will show the number of service per occurrence e TabJshows the number of income sources per occurrence e Tab K shows monthly income per occurrence Bowman System
3. 917 308 938 282 741 292 743 283 240 7 You can then add a filter or a column for each of the other counts Note that the Income and Service objects must be displayed by themselves to prevent FDATASYNC errors from incompatibl e queries Common elements can be used by all tables All EEs Entry Exit Uid Svs Code EE Trans Table Specific elements objects that must be separate to avoid DATASYNC issues Bowman Systems ART Gallery Report Page 15 of 22 0556 Client Transition Outcomes v1 a HUD Profile Elements Adj Gender Adj Race Adj Vet Age Group Diagram 7 3 A HUD Elements Table Entry Exit Uid Svs Code EE Trans lad Gender Adj Race Adj Vet Age Group 283 429 309 107 Male White No f 20 24 283 529 208 829 Female an or Alaska Native No f 20 24 289 906 24 199 Male an or Alaska Native No h 30 34 290 558 174 706 Male or African American No i 35 39 291 668 272 450 Male White No m 55 59 291 920 131 523 Female White No f 20 24 b Income Elements Income Catagories Income in EE Adj Source Diagram 7 3 A Income Elements Table 283 429 309 107 m 1000 1099 1 068 Earned Income 283 429 309 107 m 1000 1099 1 068 Sol 283 529 208 829 m 1000 1099 1 040 Earned Income 289 906 24 199 a Missing Income Missing Value 290 558 174 706 b No Income 0 OQinancial Resources 291 668 272 450 w 52000 2 185 SSDI c Service Elements Services Service Uid Adj Svs Cod
4. 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 2 1 below Bowman Systems Page 3 of 22 0556 Client Transition Outcomes ART Gallery Report v1 Diagram 2 1 Location of Automapped Reports Q Re po rts gt ART Type here for Global Search gt Last Viewed Favorites Advanced Reporting Tool Home New Report ClientPoint ResourcePoint ART Browser ShelterPoint gt Pjinbox ActivityPoint gt ii Favorites Qro IL Available Reports and Templates SkanPoint Bowman Systems Resources Audit Access Report Audit Report User Information User Login AHAR Call Record Report Client Served Report Daily Unit Report Duplicate Client Report Entry Exit Report HUD 40118 APR Needs Report Outstanding Referrals PATH Service Transaction ReportWriter ART Gallery Report Manuals E Dashboard Reports 4 ART Gallery Index Scheduled Reports Name Interval Start Date Last Warehouse Build June 1 2012 03 46 31 PM Admin Logout Requests for additional information concerning the report function design should be directed to Bowman Systems Customer Support Specialist CSS staff How to run Upon opening the report the User will be prompted see Diagram 2 2 below to specify parameters which control the data returned by the report Once the User has provided these para
5. 4 Add a new tab by right clicking one of the tabs at the bottom of the report and select Insert Report Diagram 7 3 A Insert Report Menu Rename Report Insert Report Duplicate Report Delete Report Move Report Drill Show Chan ges Save to my computer as Document Properties 5 Add a vertical table to the new tab and add the each object listed in the calculation above 3 in into columns In this example Entry Exit Uid is from the All EE Query and the Svs Code EE and Trans objects are from the custom variable folder Bowman Systems Page 14 of 22 0556 Client Transition Outcomes ART Gallery Report v1 269 906 290 558 291 668 Diagram 7 3 A Client Table Entry Exit Uid Svs Code EE 2831429 283 529 309 107 T 208 829 T 24 199 T 174 706T 272 450 T 6 You can click on the Trans column and sort to see all of the transitions by either using the Sort icon under Edit Report or right clicking and choosing Sort Diagram 7 3 A Sorting a ki B E View Structu fx m Cf Trans fni T Report Filters Applied to Block1 To apply a filter to Block1 select the object to filter in th HF 283 429 283 529 289 906 290 558 291 668 291 920 293 334 294 366 296 057 297 738 297 751 300 113 282 723 282 739 178 835 307 906 307 911 307
6. ART Gallery Report 0556 Client Transition Outcomes Outcomes and Analytics Contents le ANTRODUCTO Nao 3 2 REPORT INSTRUCTIONS AND PROMPT S causan ini 3 3 DESCMPTON AND LA OU rre rrn E N N E ETE am mnieversa eos 6 Sale Information Common to Multiple TaDSivinrianoinino ibi ii 6 3 1 B K Gender Family Race Age and Veteran ccccccseccccsececcnssencneseecncssecscseeusseneuessecueseeeuceseuaseneueseneuess 6 3 1 G I Service Type and INCOME SOUFCES cccccccnnnnncncnnnnnnnnnnananncnnoncnnonononononnnnnnnnanancnnnnnnnnnnnnnnnnn nono nnnnnarcnnnananans 8 3 1 H J K Number of Services Income Sources and Monthly INCOME ooooccccccccnnnnnoncccnnnnnnnononananonananonononos 8 3 2 Tab Specitic IMPOl MATION ss ll 9 A CONN esesince sa oeaecesan E E E E N ES 9 SPA aE ne o E A T 9 5 E E scene oueeeuces sce snesscunenecssaetues eecamaessentsesuruereorssecaocseecees 9 AO LS A oo A en ee ene eee 9 e WA A o En o e 9 A nn e A E A A E A EES 9 PAE m SONICS 1 e E E E EE EEE T O 9 2 Number SEVICE in 10 A E E Ee A nee 10 SIND Orcos OUECES ia E N 10 A A e e In 10 3 2 L Additional e no 10 A INPUT CONTROL A E 11 Se ALERTER eraa N E E E E E E EEE A EE E O E aaa saeseoneens 11 5 DIMENSONSUSED rios 11 6 1 Information COMMON to All TabS cccccccncoooonncnnnnnnnconnnoncnnnnnnnonnnannnnnnnnnnnonnnrrnnnnnnnonnnnnnrnnnnnnnnnnnancrnnnnnnns 11 6 2 Tabsspecific MODO tanto dr atea 11 A A ecm soceseetuneneuetureeaeesunes 11 SH 0 co Sane ee
7. Entry Exit Uid Where Not sHNull Svs Code EE Where 4 Create a blank column in the table Click on the empty body cell 1 and open your formula editor 2 Diagram 7 3 B Adding the Formula Svs Code EE 309 107 T Bowman Systems Page 17 of 22 0556 Client Transition Outcomes ART Gallery Report v1 5 Paste your formula in and add the following items in pink if before the open parenthesis y X before the LAST closing parenthesis This will show that particular family count with an X li IfAsNull Entry Exit Group Id And Client Age at Entry lt 18 SC If Not IsNull Entry Exit Group Id If Count EE Trans Entry Exit Uid Where Client Age at Entry lt 18 In Entry Exit Group Id gt 1 MC If Count EE Trans Entry Exit Uid Where Client Age at Entry lt 18 In Entry Exit Group Id 1 SC nC nC MC And f sNull Entry Exit Group Id And Client Age at Entry gt 17 SA If NotUsNull Entry Exit Group Id If Count EE Trans Entry Exit Uid Where Client Age at Entry gt 17 In Entry Exit Group Id gt 1 MA If Count EE Trans Entry Exit Uid Where Client Age at Entry gt 17 In Entry Exit Group Id 1 SA nA nA nA And If sNull Entry Exit Group Id And IsNull Client Date of Birth M If Not isNull Entry Exit Group Id And IsNull Client Date of Birth M In Entry Exit Group Id lt gt M 58 NOTE To use the above formu
8. JECTS 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 Virtual field names for ASSESSMENT objects appear in parenthesis below their corresponding field names QUERY NAME OBJECT TYPE FIELD NAME LOCATION Result Client Uid Clients folder Objects Client Unique Id Clients folder Entry Exit Uid Clients Entry Exit Outer folder Case Worker Name Clients Case Workers folder Case Worker Date Started Clients Case Workers folder Case Worker Date Ended Clients Case Workers folder Filter Objects Case Worker Uid Clients Case Workers folder All EE Entry Exit Exit Date Clients Entry Exit Outer folder Universe _u Client Universa Entry Exit Entry Date Clients Entry Exit Outer folder Client Inactive Clients folder Entry Exit Inactive Clients Entry Exit Outer folder Entry Exit Provider Id Clients Entry Exit Outer folder Clients Entry Exit Outer Entry Exit Entry Exit provider COC Code Provider Id folder Entry Exit Provider Program Clients Entry Exit Outer Entry Exit Type Code Provider Id folder Result Objects e ara Universe ee u z Entry Exit Universe i U S Military Veteran E ts fold VETERAN ntry Objects folder Filter Objects Entry Exit inactive Entry Exit folder Entry Exit Provider COC Code Entry Exit Entry Exit Provider Id folder Entry Exit Provider Program l l En
9. Number Services Additional Service Uid from Services query Dimensions 6 2 1 Income Source Additional Source of Income from Income query Dimensions Bowman Systems Page 11 of 22 0556 Client Transition Outcomes ART Gallery Report v1 6 2 J Number of Income Souces Additional Source of Income Recordset ID from Income query Dimensions 6 2 K Monthly Income Additional Last 30 day income from Income query Dimensions 6 2 L Additional Information Additional Entry Exit Provider Id from EE trans query Dimensions 7 TECHNICAL INFORMATION 7 1 How Data Is Pulled 7 1 A All EEs This is the main query that pulls all the entry exits for active clients with active entry exits The qualifying entry exits must overlap a specific time frame There are three optional prompts to pull providers by providers by CoC code or by program type code These optional prompt are part of an AND clause and when multiple optional prompts are populated the result set must contain all criteria Case Worker optional prompt The report is designed to allow a run for a single case worker The chart below shows how clients with Entry Exits are included in the report Diagram 7 1 A Entry Exits Included in Report Report Report End Date Start Date PLUS 1 Day ee Client has both an Entry and an Exit Oe Client has an Entry but no Exit The report includes all clients who had Entries into the specified coming from provide
10. ai E 2 Je Bz7U A 2 Data Templates Map Properties Input Cont Data g 0556 Client Transition Outcomes vl BETA 5 All EEs demo_art_sp5_staging_u Case Worker Date Ended Case Worker Date Started Case Worker Name A Client Uid 4 ie i a i gt 2 Click on Tab A Outcome and click on the calculation for the Transitions to destination program s in the Occurrences column Bowman Systems Page 13 of 22 0556 Client Transition Outcomes ART Gallery Report v1 Diagram 7 3 A Formula F Report Filters Applied to Block1 To apply a filter to Block1 select the object to filter in the Data tab and drop it here Client Transition Outcomes Basic Occurrence and Outcome Information Date Range 1 1 09 6 30 09 Outcomes Occurrences No transition to destination program s 434 Transitions to destination program s L z Total number of occurrences 446 3 Make not note of the objects used in the calculation by looking at the formula in the formula editor Count All EEs Entry Exit Uid Where Not IsNull Svs Code EE Where Trans T OBJECT EXPLANATION The Entry Exit Uid object is used to count each occurrence per Entry Exit record The Svs Code EE object is actually an associated dimension for the Client Uid and displays the Client Uid in tables The Trans object identifies if the Entry Exit Uid record transitioned to a destination program
11. amsir 1 ABC Teher for Women and Fares 1325 1 FEA Pike Sia Emene Lodgpng Program 2504 4 3 1 OTS Emsan Sheller 2134 330 343 31 12 gD Parameters specified in the user prompts See Section 2 for descriptions of prompts 2 An overview by provider of number of clients in the report number of occurrences and transition status of clients Bowman Systems Page 10 of 22 0556 Client Transition Outcomes ART Gallery Report v1 4 INPUT CONTROLS This report contains no input controls 5 ALERTERS This report contains no informational alerters 6 DIMENSIONS USED 6 1 Information Common to All Tabs Dimensions Entry Exit Uid Client Uid from All EEs query Entry Exit Entry Date Entry Exit Used Exit Date from EE Trans query Client Unique Id merge 6 2 Tab Specific Information 6 2 A Outcome This tab only uses the common dimensions shown in 6 1 6 2 B Gender Additional Client Gender from EE Trans query Dimensions 6 2 C Family Additional Entry Exit Group ld Client Age at Entry Client Date of Birth Dimensions from EE Trans query 6 2 D Race Additional Client Primary Race Client Secondary Race from EE Trans Dimensions query 6 2 E Age Additional Client Age at Entry from EE Trans query Dimensions 6 2 F Veteran Additional U S Military Veteran from EE Trans query Dimensions 6 2 G Service Type Additional Service Code Description from Services query Dimensions 6 2 H
12. cluded in the crosstabulation 99 71 349 of 350 99 71 occurrences have both a designated gender and a calculable outcome and are therefore included in the crosstabulation 1 The first table in the body of the report shows a count of occurrences Entry Exits sorted by the defining dimension Examples include gender household type race age veteran status and income e Entry Exits with null values in the defining dimension are reported as missing value 2 The second table in the body of the report shows total numbers of Entry Exits in each category of the defining dimension who have and don t have transitions e A transition is marked when there is a going to Entry after the last coming from Entry e Entry Exits with null values in the defining dimension are filtered out of the second table on tabs B through F The third table provides a narrative summary of the information on the first and second tables e By saving the report as PDF or Excel the user can copy the narrative into various communication vehicles Bowman Systems Page 7 of 22 0556 Client Transition Outcomes ART Gallery Report v1 3 1 G I Service Type and Income Sources These tabs may have total frequencies higher than the number of occurrences Diagram 3 1 G Service Type Frequency within Service Types Provided Occurrences Alcoholism Counseling Subst nte Abuse Counsel LID a eee 4 Transportation Expense Assistance 201
13. e Diagram 7 3 A Service Elements Table Entry Exit Uid Svs Code EE Service Uid Adj Svs Code 283 429 309 107 1 334 461 Emergency Shelter 283 529 208 829 1 335 035 Emergency Shelter 283 529 208 829 1357 466 xpense Assistance 209 906 247199 1 418 961 Emergency Shelter 290 558 174 706 11427 149 Emergency Shelter 291 668 212 450 1 441 333 Emergency Shelter 7 3 B Creating a Family Detail Table 1 Create a new vertical table on a new tab using the All EEs Entry Exit Uid Svs Code EE and Trans objects Diagram 7 3 B Client Detail Table Entry Exit Uid Svs Code EE 283 429 309 107 T 283 529 208 829 T 209 906 24199 T 290 558 174 067 291 668 272 450 1 2 To display family counts based on Entry Exits you have to open each of the variables for the family counts These are located in the Variables folder Bowman Systems Page 16 of 22 0556 Client Transition Outcomes ART Gallery Report v1 Diagram 7 3 B Household Variables E E Variables 10 Fam Child Only HH w Fam Missing DOB w Fam Multi Adult no Child ae Fam Multi Adult with Child w Fam Single Adult no Child we Fam Single Adult with Child we Farm Single Children 3 For example open Fam Child Only HH Copy from the open after the Where to the very last closing parenthesis in the yellow below Diagram 7 3 B Children Only Formula Variable Definition Name Fam Child Only HH Formula Count EE Trans
14. e ane ree me ere EEE TOTO PES a eer een re rene ee en ee eee eer ere 11 A a AAA e AA nn A ee ee 11 SA A A AA o E E A E E E E 11 EA E e E AA EEO AE EEE E A EE A A N E A E E A E EEEE EE A E EEEE 11 BowmanSystems Pagelof22 0556 Client Transition Outcomes ART Gallery Report v1 02 FN eto a Mi a a a 11 6 20 SEVICE TV 0G tnanon anr a e A e a ace eal eee ene eee ieee 11 A A a a T savicohce nauensaledccmh dons ove bau cone 11 bz INE O MIC SOUNC Cas i aiehacanscett a obat test be Neaneated oes alaca aah savin E A 11 6 2 J NUMDEHOr INCOME SOUTO Sica NNN 12 52 K MOntTIVINCO Menear tordo tidad 12 oA AGG HORNO AMO 12 7 TVECHNICALINFORMA TON sins 12 Tal HOW Data Are Pull a E iadCatat E le hatetedintnasveguhidateteenenien aes 12 TEA AEE PO A RR nae 12 ABE PAINS seat eiii eaieewenly 13 Ti NC SENICE atole 13 A pects ura ceec E E 13 Z2 TECHNIC AWINOVES daa 13 3 WOGITICSTION OPD S tada iia 13 T3A Creating a Client Detal Tale SA 13 TS B Creating a FIM DS atl Tablon a o a aos da 16 Se MAPPING OBJECTS sana dd 20 de REVISION A STO ria 22 Bowman Systems Page2of22 0556 Client Transition Outcomes ART Gallery Report v1 1 INTRODUCTION Where do clients go after they leave The purpose of this report is to find after clients start out in a program program type or CoC where they end up This widely applicable report uses program entries to show the client transitions from originating programs program typ
15. es or CoC s into any destination programs program types or CoCs Or any combination of those things You can measure how many clients were successfully housed how many have entered the CoC how many go from shelter to permanent housing how many were permanently housed after a substance abuse treatment program or shelter to shelter recidivism You can also see the various structural and demographic characteristics of clients who end up in the destination programs or program types of interest compared with those who do NOT end up in the destination programs or program types of interest The applications of the 0556 are very broad among others this report can be run by case managers to see how their clients fare for program staff to chart program success and for executive directors to use in funding applications The implementation level can see movement between entire CoC s if desired The report should be run any time data are needed regarding outcomes If desired the report date prompts may be used to modify the date range for the current funding cycle Prerequisites and workflow requirements this report requires the use of entry exits for the programs included in the report Depending on the openness of your implementation some stakeholders may be limited in their view of the destination data 2 REPORT INSTRUCTIONS AND PROMPTS The easiest way to start using this report is to navigate to the automapper This is a folder that has the
16. esignated into the report NOTE This is an optional prompt leaving it blank will cause the report to ignore this field and pull in all data regardless of CoC code Select Program Types Going To Optional Select the program type code to pull all providers with that code designated into the report NOTE This is an optional prompt leaving it blank will cause the report to ignore this field and pull in all data regardless of program type code 3 DESCRIPTION AND LAYOUT The report contains 12 tabs A through L 3 1 Information Common to Multiple Tabs 3 1 B K Gender Family Race Age and Veteran These tabs are sub reports each containing three sections See Diagram 3 1 B K Tabs B through K are identical in format and report data from the perspective of their various defining dimensions gender family race age veteran status Bowman Systems Page 6 of 22 0556 Client Transition Outcomes ART Gallery Report v1 Diagram 3 1 B K Gender Family Race Age and Veteran Female Male Missing Value Total 2 Gender and Outcome Occurrences No Transition Transition 84 3 253 9 330 12 Information Summary 95 59 84 of 87 96 55 female occurrences have no transition 3 45 3 0187 3 45 female occurrences have transition 96 56 253 of 262 96 56 male occurrences have no transition 3 44 9 of 262 3 44 male occurrences have transition 20 57 1 of 350 0 29 occurrences have no associated gender and are therefore not in
17. it folder Inactive Subassessment Entry Objects Monthly Income folder MONTHLYINCOME Bowman Systems Page 21 of 22 0556 Client Transition Outcomes ART Gallery Report v1 9 REVISION HISTORY Description of Changes AA Bowman Systems Page 22 of 22 0556 Client Transition Outcomes ART Gallery Report v1
18. la copy and paste it into Notepad then copy it from Notepad and paste it into ART This will avoid issues involving Word applying special characters to the quotations 6 The table will display an X for any Client record Entry Exit record that meets the families variable calculation In the example above the Fam Child Only HH will shows clients whose Entry Exit records indicate there are not adults present and it is either a group of children or b a single child Diagram 7 3 B Resulting Table ATA 283 429 309 107 T 283 529 208 829 T 289 906 24 199 T 290 558 174 706T 291 668 272 450 T 291 920 131 523T Family Status Occurrences 293 334 71 865T Single Children 2 294 366 80 228 T o pa 297 738 159 686T Single Adults without Children gt ET 297 751 329 758 T single Adults with Children 300 113 16 747T 369 TO Multiple Adults without Children 2 Multiple Adults with Children 0 One or more Missing Date of Birth 0 446 Total 282 723 178 835 NOTE The original un modified version of this report is a template and is retained in ART Gallery Templates folder structure These template folders are read only and any reports must be copied to a location in the user s site Favorites or Public Folders then mapped to the site s data Bowman Systems Page 18 of 22 0556 Client Transition Outcomes ART Gallery Report v1 Bowman Systems Page 19 of 22 0556 Client Transition Outcomes ART Gallery Report v1 8 MAPPING OB
19. m providers to include by highlighting them in the left window and moving them into the right window using the right selection arrow NOTE This is an optional prompt leaving it blank will cause the report to ignore this field and pull in all data regardless of provider 6 Select Providers CoC Code Coming From Optional Select the provider CoC code to pull all providers with that code designated into the report NOTE This is an optional prompt leaving it blank will cause the report to ignore this field and pull in all data regardless of CoC code 7 Select Program Types Coming From Optional Select the program type code to pull all providers with that code designated into the report NOTE This is an optional prompt leaving it Bowman Systems Page 5 of 22 0556 Client Transition Outcomes ART Gallery Report v1 10 blank will cause the report to ignore this field and pull in all data regardless of program type code Select Providers Going To Optional Click the refresh list icon and wait for the left window to refresh Now select the going to providers to include by highlighting them in the left window and moving them into the right window using the right selection arrow NOTE This is an optional prompt leaving it blank will cause the report to ignore this field and pull in all data regardless of provider Select Providers CoC Code Going To Optional Select the provider CoC code to pull all providers with that code d
20. meters by responding to the user prompts a green check mark will appear next to each field to indicate that a selection has been made The User should then single click the Run Query button to generate the report Bowman Systems Page 4 of 22 ART Gallery Report Le Custom Reports gt Al o 1 06 u 2012 06 21 Showing 1 4 of 4D AS First Previous Next Last End Date Type Status Refresh eo 0556 Client Transition Outcomes v1 Diagram 2 2 Report Prompts Prompts Reply to prompts before running the query EDA Provider Default Provider Enter Start Date 01 01 2009 00 00 00 Enter End Date PLUS 1 Day 01 07 2009 00 00 00 Select Case Worker Name optional This filter will be ignored because no value has been selected EDA Provider Default Provider Select Providers Coming From optional none selected 1 10th Street Shelter 27055 1 ABC Sh EDA Provider Default Provider Select Providers CoC Code Coming From optional This fitter will be ignored because no value has been selected EDA Provider Default Provider Select Program Types Coming From optional Emergency Shelter HUD EDA Provider Default Provider Select Providers Going To optional This filter will be ignored because no value has been selected EDA Provider Default Provider Select Providers CoC Code Going To optional This fiter will be ignored because no value has been selec
21. nsition outcomes as related to race 3 2 E Age Tab Eshows transition outcomes as related to age e Client age at entry is calculated based on date of birth e Clients who do not have a date of birth recorded are over 105 years of age or who have a date of birth after date of program entry will be reported as possible errors 3 2 F Veteran Tab F shows transition outcomes as related to veteran status 3 2 G Service Type Tab G shows transition outcomes as related to service types as described in 3 1 G I Bowman Systems Page 9 of 22 0556 Client Transition Outcomes ART Gallery Report v1 3 2 H Number Services Tab H shows transition outcomes as related to number of different service types received as described in 3 1 H J K 3 2 1 Income Source Tab shows transition outcomes as related to income sources as described in 3 1 G l 3 2 J Number of Income Sources Tab J shows transition outcomes as related to number of income sources as described in 3 1 H J K 3 2 K Monthly Income Tab K shows transition outcomes as related to amount of monthly income as described in 3 1 H J K 3 2 L Additional Information Tab Lis provided as a reference to the user running the report Figure 3 2 L Additional Information User Promp Field User Prompl Field Enter Stan Daix 14123006 Ender End Date PLUS 1 Day 1723000 Solent Cate Worker Narra nal E Sagel Previdert Coming Frems fur Gace 1105 Sres Shafer 2025
22. rs on or after the Report Start Date but before Report End Date PLUS 1 Day Bowman Systems Page 12 of 22 0556 Client Transition Outcomes ART Gallery Report v1 7 1 B EE Trans This query pulls all of the corresponding Entry Exit and client demographic information the coming from data and determines which are the going to Entry Exits the transitions 7 1 C Services This query pulls the active service information for the going to Entry Exits 7 1 D Income This query pulls the active income information for the going to Entry Exits 7 2 Technical Notes 1 Atransition is determined when the maximum going to entry is after the minimum coming from Entry 2 The minimum coming from is determined from the first Entry for each Client Unique Id among the providers selected in the optional coming from prompts Select Providers Coming From Select Providers CoC Code Coming From Select Program Types Coming From 3 The maximum going to is determined from the last Entry for each Client Unique ld among the providers selected in the optional going to prompts Select Providers Going To Select Providers CoC Code Going To Select Program Types Going To 7 3 Modification Options 7 3 A Creating a Entry Exit Detail Table 1 Toggle on the formula editor and filter pane Diagram 7 3 A Formula Editor and Filter Pane Ba 5 E 6 Edit Query 5 Edit Report s
23. s Page 8 of 22 0556 Client Transition Outcomes ART Gallery Report v1 3 2 Tab Specific Information 3 2 A Outcome Tab A presents a summary of Entry Exits who have and have not made transitions see Technical Note 1 page 12 from coming from to going to providers e If there is no Exit Date or if the Exit Date is after the end of the reporting period the transition is marked as incomplete e If there is an Exit within the reporting period the transition is marked complete 3 2 B Gender Tab B shows transition outcomes as related to gender 3 2 C Family Tab C shows the transition outcome as related to household makeup based on group id e Adults are clients 18 years of age or older as of the reporting period e Children are clients under 18 years of age e lf the date of birth is null for a client the report will be unable to determine whether the client is an adult or a child and will not be able to determine household makeup Household makeup is determined as follows Table 3 2 C Household Makeup As Determined by Clients in Group ID Household Type Children under 18 Adults 18 or Older Single Children One None Child Households Without Adults More Than One None Single Adults Without Children None One Single Adults With Children One or More One Multiple Adults Without Children None More than One Multiple Adults with Children One or More More than One 3 2 D Race Tab D shows tra
24. ted EDA Provider Default Provider Select Program Types Going To optional Emergency Shelter HUD EDA Provider Default Provider Refresh Values Eg EDA Provider To see the content of the list please click the Refresh values button gt Default Provider Enter your search pattern here 7 More Information Select or type the values you want to return to reports for each prompt displayed here The user prompts contained in this report are 1 EDA Provider The user should select the EDA provider to run the report as or leave it as the default Default Provider if EDA mode is not desired 2 Enter Start Date The user should type in or select from the calendar the first day of the reporting period year 3 Enter End Date PLUS 1 Day The user should 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 4 Select Case Worker Name Optional Select the case worker name to include only clients assigned to that case worker in the report NOTE This is an optional prompt leaving the prompt blank will cause the report to ignore this field and pull in all data regardless of caseworker assigned 5 Select Providers Coming From Optional Click the refresh list icon and wait for the left window to refresh Now select the coming fro
25. try Exit Entry Exit P der Id fold Type Code ntry Exit Entry Exit Provider Id folder Services Result Entry Exit Client Uid Entry Exit folder Universe ee_u Objects Entry Exit Uid Entry Exit folder Entry Exit Client Unique Id Entry Exit Clients folder Bowman Systems Page 20 of 22 0556 Client Transition Outcomes ART Gallery Report v1 Filter Objects Entry Exit Provider Program l i Entry Exit Entry Exit P der Id fold Type Code ntry Exit Entry Exit Provider Id folder Result Objects Recordset ID Universe Entry Exit Services Outer folder Entry Exit Services Outer folder Subassessment Entry Objects Monthly Income folder MONTHLYINCOME Source of Income SOURCEOFINCOME Entry Objects Monthly Income folder Entry Objects Monthly Income folder Entry Objects Monthly Income folder Entry Objects Monthly Income folder Income Last 30 Day income j E Monthly fol Universe ee_u AMOUNTMONTHLYINCOME ntry Objects Monthly Income folder Income received from any source in past 30 days Entry Exit Universe SVP_ANYSOURCE3ODAYINC Entry Objects folder OME Filter Objects Entry Exit inactive Entry Exit folder Entry Exit Provider Id Entry Exit folder Entry Exit Provider COC Code Entry Exit Entry Exit Provider Id folder Entry Exit Provider Program l l l Entry Exit Entry Exit P der Id fold Type Code ntry Exit Entry Exit Provider Id folder Entry Exit Entry Date Entry Ex
Download Pdf Manuals
Related Search