DISCOVE RE R Re porting Syste m DI SCOVE RE R F AQ s Wha t - PowerPoint PPT Presentation

DISCOVE RE R Re porting Syste m

DI SCOVE RE R F AQ’ s • Wha t I s DI SCOVE RE R? • Who c a n use it? • Whe re c a n I a c c e ss it? • Whe n c a n I use it? • Why use it? 2

Wha t is Disc o ve re r? • I t is Ora c le re po rting so ftwa re tha t g ive s info rma tio n a b o ut wha t is in OWCMS. I f it is no t in OWCMS, Disc o ve re r c a nno t re po rt it • T he re a re pre -de sig ne d (c a nne d) re po rts tha t ha ve a lre a dy b e e n pre pa re d b y the sta te . T ho se re po rts c a n b e run a s is o r c a n b e mo difie d b y sta ff • Disc o ve re r a lso ha s the c a pa b ility to re po rt da ta tha t the use r re q ue sts fro m sc ra tc h (a d-ho c ) 3

Wha t info rma tio n c a n b e re po rte d b y Disc o ve re r? • Disc o ve re r re po rts info rma tio n o n pa rtic ipa nts tha t is e nte re d into OWCMS • T his da ta c a n b e vie we d a t the pa rtic ipa nt, c a se ma na g e r, lo c a l o ffic e , WI B o r sta te le ve l 4

Who c a n a c c e ss Disc o ve re r? • Anyo ne who ha s a ro le in OWCMS ha s a c c e ss to Disc o ve re r • T he Disc o ve re r Que ry o r Re po rt le ve l a c c e ss is no lo ng e r de te rmine d b y the ro le o f the OWCMS use r • Disc o ve re r Re po rts c a n b e sha re d b e twe e n diffe re nt use r ro le s 5

Whe re c a n I find Disc o ve re r? • Disc o ve re r re po rts c a n b e a c c e sse d within OWCMS unde r the re po rts me nu ite m. T his is the sug g e ste d wa y tha t yo u a c c e ss the se re po rts • Disc o ve re r L E o r WI A Ad-ho c Re po rt ta ke s yo u to the ‘ PL US’ pa rt o f Disc o ve re r http:/ / disc o ve re r.o wdsa .o hio .g o v/ disc o ve re r/ a pp/ c o nne c tio n? e ve nt=displa yCo nne c tio ns&c lie ntT ype =plus • Yo ur lo g -in is c o mpute r spe c ific – if yo u g o to a diffe re nt c o mpute r yo u ha ve to c re a te lo g -in o n tha t c o mpute r 6

Whe re do e s the Disc o ve re r info rma tio n c o me fro m? • I f it is no t in OWCMS, Disc o ve re r c a nno t re po rt it “I f it is no t in OWCMS, it didn’ t ha ppe n!” • Disc o ve re r info rma tio n c o me s fro m the OWCMS re po rting da ta b a se • T he re po rting da ta b a se is a se pa ra te da ta b a se fro m the “live ” pro duc tio n da ta b a se . I f the da ta wa s “live it wo uld slo w do wn the e ntire syste m. 7

Whe n is the da ta a va ila b le fo r re po rts? • Da ta tha t is e nte re d in OWCMS will b e se e n the fo llo wing da y in Disc o ve re r re po rts • T he da ta is upda te d nig htly whe n the re po rting da ta b a se is re fre she d fro m the pro duc tio n da ta • T he re fre sh is usua lly c o mple te b y 8:00 AM o f the b e g inning o f the b usine ss da y 8

Why Use Disc o ve re r? • Disc o ve re r c a n b e use d to ma na g e yo ur c a se lo a d • Disc o ve re r c a n g ive yo u the sta tus o f individua ls • Disc o ve re r c a n upda te yo u o n the ir o utc o me s • Disc o ve re r c a n te ll yo u wha t wa s do ne a nd whe n • Disc o ve re r info rma tio n c a n b e fo rma tte d into re po rts a nd e xpo rte d • Disc o ve re r pro vide s info rma tio n o n pe rfo rma nc e • Allo ws yo u to wo rk sma rte r no t ha rde r 9

DI SCOVE RE R Glo ssa ry T e rms Pa g e 6 • He lps to unde rsta nd DI SCOVE RE R T e rmino lo g y • Sc a n thro ug h the list • Be ing fa milia r will he lp in the ‘ Cre a te a Re po rt’ pa rt o f tra ining 10

WI A Disc o ve re r Re po rts Glo ssa ry • Ad-ho c Re po rt: I n the OWCMS re po rt me nu the Ad-ho c re po rt me nu ite m lo a ds the Disc o ve re r so ftwa re fo r OWCMS re po rting • Busine ss Are a s: re pre se nt ho w re la te d info rma tio n is g ro upe d Disc o ve re r ha s 2 b usine ss a re a s: WI A a nd L E • Co nditio ns: Are sta tic , de fine d c irc umsta nc e s tha t limit the info rma tio n re q ue ste d fro m the re po rting da ta b a se tha t o pe ra te the sa me wa y e ve ry time a q ue ry is ra n • Co nne c tio n: Cre a ting a link fro m the c o mpute r yo u a re o n to yo ur da ta a nd file s in Disc o ve re r • E xpo rt: T o se nd the wo rkshe e t o ut to a diffe re nt pro g ra m, suc h a s Mic ro so ft E xc e l fo r ma nipula tio n in tha t pro g ra m 11

WI A Disc o ve re r Re po rts Glo ssa ry F o lde rs: I nfo rma tio n fro m e a c h b usine ss a re a is the n sto re d in fo lde rs. Curre ntly, tho se fo lde rs re pre se nt ta b le s in the re po rting da ta b a se . I te ms: Re pre se nts spe c ific line s o f info rma tio n in a fo lde r L E o r WI A ‘ Ad-ho c Re po rts: Cre a te yo ur o wn re po rts b a se d o n ite ms yo u se le c t. L E o r WI A ‘ Ca nne d Re po rts: Re po rts tha t ha ve a lre a dy b e e n c re a te d b ut c a n b e mo difie d o r run a s is fo r yo ur ne e ds. Pa g e I te ms: An e a sy wa y to filte r wo rkshe e ts witho ut filte ring b y c o nditio ns. 12

WI A Disc o ve re r Re po rts Glo ssa ry Que rie s: T his the re q ue st yo u ma ke o f Disc o ve re r whe n a sking fo r spe c ific info rma tio n. T a b le : Ho w da ta is displa ye d in Disc o ve re r. Co lumns with he a ding s a c ro ss the to p o f the pa g e de fine wha t da ta is displa ye d T he da ta is o rg a nize d like a spre a dshe e t. Wo rkb o o k: is a sing le wo rkshe e t o r a c o lle c tio n o f wo rkshe e ts who se fo rma t is sa ve d to the re po rting da ta b a se . Wo rkshe e t: is the da ta tha t is g e ne ra te d whe n a q ue ry is run. I t c o nta ins info rma tio n re trie ve d fro m the re po rting da ta b a se o n ite ms in the q ue ry. 13

Ho w is the da ta in Disc o ve re r o rg a nize d? • Disc o ve re r da ta is sto re d in ta b le s b e hind the sc e ne s • T a b le s a re c urre ntly displa ye d a s fo lde rs in the Disc o ve re r whe n se le c ting da ta fo r re po rts • I f a da ta ite m is linke d to a diffe re nt da ta ite m in a diffe re nt ta b le the ite ms in tha t o the r ta b le c a n b e displa ye d a s pa rt o f the sa me re po rt 14

Ho w is the da ta in Disc o ve re r o rg a nize d? • No t a ll ta b le s o r da ta b a se s a re linke d to g e the r • Se pa ra te Da ta b a se s – I f se le c t da ta o ut o f o ne the se da ta b a se s yo u will no t b e a b le to se le c t da ta o ut o f a ny o the r da ta b a se s • WI A se e ke r Re la te d • Mini-I nc umb e nt Wo rke r • Mini-Se e ke r • Ra pid Re spo nse • Jo b -I n 15

Ho w is Disc o ve re r da ta displa ye d in re po rts? • Da ta is displa ye d in the re po rts in a spre a dshe e t fo rma t • Da ta is o rg a nize d b y c o lumns a c ro ss the to p a nd da ta o n e a c h individua l is displa ye d in ro ws • T his da ta is ve ry e a sily e xpo rte d into a n E xc e l spre a dshe e t due to this fo rma t. 16

Pla n yo ur re po rt b e fo re yo u sta rt it! • K no w wha t yo u wa nt b e fo re yo u sta rt – At a minimum c o nside r the fo llo wing q ue stio ns b e fo re c re a ting yo ur re po rt • Who a re yo u trying to g e t info rma tio n a b o ut? • Wha t do yo u wa nt to kno w a b o ut the m? • Wha t time pe rio d do yo u wa nt fo r yo ur da ta ? • I s lo c a tio n impo rta nt? L o c a l Are a – Offic e • I s the re o the r limita tio ns tha t yo u wa nt? 17

Simple r is b e tte r! • Yo ur re po rts will b e mo re a c c ura te if yo u try to a nswe r o ne o r two q ue stio ns with the da ta in yo ur re po rt! • I t is b e tte r to ha ve mo re re po rts tha t g ive b e tte r da ta ! • As yo u a dd mo re da ta ite ms to the re po rt yo u ma y re duc e the numb e r o f ro ws o f da ta tha t ma tc h a ll o f the re q uire me nts yo u a re re q ue sting – Whe n yo u c ro ss ma jo r ta b le s tha t ta b le ma y re stric t the numb e r o f ro ws in yo ur re po rt to the ite ms tha t a re mo st re stric tive in the ta b le 18

Who – Ca se Ma na g e me nt & Re po rting Da ta b a se – I ndividua ls – Na me , Se e ke r I D, SSN – Se e ke r I D – WI A Pro g ra m – Adult, DW, Olde r Yo uth, Yo ung e r Yo uth, a nd mo re , mo re , mo re – Co unting pe o ple o r c o unting se rvic e s – Ve ts – Ve t Sta tus vs Ve ts De ta ils – Ra pid Re spo nse – Se lf-Se rvic e – Mini Se e ke r a nd L imits – Da te o f I nitia l Se rvic e vs Se rvic e Da te – I nc umb e nt Wo rke r – T ra de – inc lude d in WI A – Cla ima nt Sta tus – Curre nt Cla ima nt Sta tus vs UI Sta tus a t I nta ke – Spe c ia l Pro g ra ms – Spe c ia l Gra nt Offic e vs WI A Pro g ra m 19

Wha t da ta will b e in yo ur re po rt • a . Co re , I nte nsive , T ra ining , Yo uth – Se rvic e T ype vs Se rvic e De sc riptio n • b . De mo g ra phic s • i. Ge nde r • ii. Ag e – to da y – a t inta ke • iii. Disa b le d • iv. Ra c e – Se e ke r Ra c e - Multi-Ra c e • v. E duc a tio n L e ve l • vi. E duc a tio n Sta tus • vii. Offe nde r • c . Pa rtic ipa nts – who is a pa rtic ipa nt/ e nro lle e • d. Se e ke r Sta tus – Pro g ra m Sta tus ( Clo se d, Co mple te d, De nie d, E lig ib le , E nro lle d, E xpire d) vs Se e ke r Sta tus (Ac tive , Ope n, E xite d) 20