Standard Jet DBnb` Ugr@?~1y0̝cǟFN7]D^(`T{6߱wCϯ34ay[|*|OJl>`&_Љ$g'DeFx -Set DB d @VCYS YY          2c   ct    j    O        IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtrasetni  Id ParentIdName        :;<=>?@AB C D E FGHIJKLMNOPQLRLSLTLULVLWLXLYL ZL[L\L]L^L_L`LaLbLcLdLeLfLgLhLijklmnopqr s t u v wxyz{|}~  VC S  X   2  ObjectIdSIDACM FInheritablebc ObjectIdcSwitchboard~sq_cCtPtID subform h*@)\\\PDDDDDDB `E-0N@d"/0N@~sq_cSwitchboard~sq_cPatient subform f*@ )]]]QEEEEEEC `E-0N@d"/0N@~sq_cSwitchboard~sq_cPatient subform f*@ )]]]QEEEEEEC `C0@+0N@0@+0N@~sq_cSwitchboard~sq_ctblStore subform@c*@ )^^^RFFFFFFD `BA0N@A0N@~sq_fReasons subformK_*@)MMMA5555553 `C#C@<#C@AllAnswers(#@`@YOCC7++++++) `=*H@*H@0FixQ15andQ16u ~@]@@QEE9------+ `@= /N@= /N@{B9880B5D-B4FB-11D6-9123-444553540000}GGGGGGGGGGE ?= /N@= /N@{B9880B5C-B4FB-11D6-9123-444553540000}GGGGGGGGGGE >= /N@= /N@{B9880B5B-B4FB-11D6-9123-444553540000}GGGGGGGGGGE =i/N@i/N@{B9880B5A-B4FB-11D6-9123-444553540000}GGGGGGGGGGE <i/N@i/N@{B9880B59-B4FB-11D6-9123-444553540000}GGGGGGGGGGE ;/N@/N@{B9880B58-B4FB-11D6-9123-444553540000}GGGGGGGGGGE :/N@/N@{B9880B57-B4FB-11D6-9123-444553540000}GGGGGGGGGGE 9/N@/N@{B9880B56-B4FB-11D6-9123-444553540000}GGGGGGGGGGE 8m/N@m/N@{B9880B55-B4FB-11D6-9123-444553540000}GGGGGGGGGGE 7m/N@m/N@{B9880B54-B4FB-11D6-9123-444553540000}GGGGGGGGGGE 6m/N@m/N@{B9880B53-B4FB-11D6-9123-444553540000}GGGGGGGGGGE 547/N@47/N@{B9880B52-B4FB-11D6-9123-444553540000}GGGGGGGGGGE 447/N@47/N@{B9880B51-B4FB-11D6-9123-444553540000}GGGGGGGGGGE VC?S             ObjectId AttributeOrderName1Name2 ExpressionFlagilnzjtz ObjectIdAttribute  @HHH<000000. `PVj#C@7ܪH@~jI@~*mI@0updatePatientID g@HHH<000000. `PVj#C@7ܪH@@~jI@~*mI@0updatePatientID g@HHH<000000. `P~jI@~*mI@0updatePatientID g@HHH<000000. `P~jI@~*mI@0updatePatientID g@HHH<000000. `P~jI@~*mI@0updatePatientID g@HHH<000000. `PVj#C~jI@~*mI@0updatePatientID g@HHH<000000. `PV~jI@~*mI@0updatePatientID g@HHH<000000. `PV~jI@~*mI@0updatePatientID g@HHH<000000. `PVj~jI@~*mI@0updatePatientID g@HHH<000000. `PV~jI@~*mI@0updatePatientID g@HHH<000000. ~jI@~*mI@0updatePatientID g@HHH<000000. `~jI@~*mI@0updatePatientID g@HHH<000000. `P~jI@~*mI@0updatePatientID g@HHH<000000. `PVj#C@7ܪH@@AppPartFive @j@@iPDD8,,,,,,* `Tu#C@hx#C@@AppPartThreeA  @n@oRFF:......, `y-.$C@=0$C@ DeleteValidReason2 @|@WKK?3333331 `+I@!h0N@DHSValidReasons*m@l@ THH<000000. `VCS             szRelationshipgrbitccolumnicolumnszObjectszColumnszReferencedObjectszReferencedColumn   szObjectszReferencedObjectszRelationship@|@A55)))))))' @1?$C@"A$C@ DelPart3A@|@B66*******( @X=$C@s>$C@ DelPart3@|@A55)))))))' @ }ݣ8$C@:$C@ DelPart1@|@A55)))))))' @|"5$C@ݣ8$C@ DeleteValidReason5 @|@WKK?3333331 `{3$C@"5$C@ DeleteValidReason4@|@K??33333331 @ xX+$C@-.$C@ DeleteValidReason @|@VJJ>2222220 ` vR)$C@X+$C@ DeleteReason`@|@E99-------+ @u|=I@ÊI@ DeletePatientIDValidReasonh@GGG;;;;;;;9 @t#'$C@)$C@ DeletePatient@&|@F::......., @ rX!$C@q$$C@ DeletePartThreeQt@|@I==1111111/ @q$C@X!$C@ DeletePartThreeAQt@|@J>>22222220 @ o $C@so$C@ DeletePartFourQCP`@|@J>>22222220 @nG$C@ $C@ DeletePartFourQ(@@H<<0000000. @lO$C@($C@ Delete Matching Archived Data@@bVVJ>>>>>>< `k$C@O$C@ DelComProvArch@|@G;;///////- @i4 $C@#d $C@ DelAudPat@|@B66*******( @ {qg]SI?5D:C|$(@$>;RPUBJZ BJAB(0 (5%x߽V?88xo{h!Ƈ73F}E**&Ex6}C5NJBJAHd抴/N@m/N@AuditedPatientg;;;///////- @3/N@= /N@ArchivePart4@999-------+ @Q/N@,/N@ArchivedValidreason@@@@44444442 @Ih%C@'k%C@@PartOneLOS@|@C77+++++++) @f%C@&h%C@@PartOneAcuteQ@|@F::......., @N%C@P%C@@PartFourLOS2@|@E99-------+ @y3%C@5%C@@Part4ToArchive@|@G;;///////- @NjI@$ʋI@Num1234Ward,@888,,,,,,,* @0I@I@Num1234Unit,@888,,,,,,,* @#I@>&I@NotValidPI3,@888,,,,,,,* @aR!C@US!C@MSysModules2----------+ _xS!C@xS!C@MSysModules,,,,,,,,,,* Z'C@'C@MSysCmdbars,,,,,,,,,,*  G@ ȅG@MSysAccessObjects22222222220 5k7D@vo7D@@MakeWardScoresh@j@@G;;///////- @]7D@Aj7D@@MakeUnitScoresh@j@@G;;///////- @c]%C@%C@LastQPart1@|@C77+++++++) @$C@'%C@JoinHedPisUnitQrys1@`@K??33333331 @P$C@I@JoinHedPisQrys @@>G;;///////- @$C@>$C@IndUnit(@@@44(((((((& @ը$C@YT$C@IndAdmType@@C77+++++++) @/I@ٷI@HEDPISWard@777+++++++) @I@'bI@HEDPISUnit@777+++++++) @`( BB @co@ ufm`wjrpvijsordxmfv`pv{fuvs`uwgrxubrosurzdfpsjYkrjpifdsjvxpjwtu}v s`uww{r`bxwf xsd`wfs`wjfpwjd@:.a_^^VaZgaZgaWWd\_WXYZZZ[[Y[ZVVVV0B xrosurzxsd`wfbrpwjpxfdabwswjdvxagruof|sruwgruodivirvd`w`irvd`w`vxagruojosruwgruojosruwrmdjpwfup`ms`wjfpws`wjfpws`wjfpwvxagruos`wjfpwXs`wjfpwYuf`vrpvvxagruov{jwbiar`udwamvwrufxpjwvvxagruo z`mjduf`vrpv z`mjduf`vrpvX z`mjduf`vrpvY z`mjduf`vrpvZ z`mjduf`vrpv[{`udvvxagruo{`udvxpjwvbrpgjuobirjbfbuf`wf`xwrgjfmdgjmfv`zfrsfpordxmfWordxmfXordxmfYufm`wjrpvijsordxmfvz`mjduf`vrp`bxwfsfubfpw`zifdsjvvxaufsruw`zifdsjv{`udvxaufsruw`zifsdjvxpjwvxaufsruwbwswjdvxaufsruwirvd`w`vxaufsruwsfubfpwufsruw`dow}sfX ufsruwhsxpjwvxaufsruwufsruwhsxpjwvxaufsruwWufsruwhusWufsruwxpjwXufsruw{`udXwdbvYvxaufsruwwdbvYxpjwvxaufsruwwdbvY{`udvxaufsruwxuf|sruw d`w``bbfvvs`hfvd`w`a`vfvgruov ordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv`dow}sf `dow}sfW `mm`pv{fuv `mmt`pd` ov}v`bfvov}vrakfbwv H@ ufm`wjrpvijsordxmfv`pv{fuvs`uwgrxubrosurzL}dfpsjYkrjpifdsjvxpjwtu}v s`uww{rtxfvwjrpv xsd`wf{`udjdjp`xdjw.a_^^Va[VaZgaWWd\_WXYZZZ[[Y[ZVVVV0 8d`wfbrpwjpxfdabwswjdvxagruof|sruwgruodivirvd`w`irvd`w`vxagruojosruwgruojosruwrmdjpwfup`ms`wjfpws`wjfpws`wjfpwvxagruos`wjfpwXs`wjfpwYuf`vrpvvxagruov{jwbiar`udwamvwrufxpjwvvxagruo z`mjduf`vrpv z`mjduf`vrpvX z`mjduf`vrpvY z`mjduf`vrpvZ z`mjduf`vrpv[{`udvvxagruo{`udvxpjwvbrpgjuobirjbfbuf`wf`xwrgjfmdgjmfv`zfrsfpordxmfWordxmfXordxmfYufm`wjrpvijsordxmfvz`mjduf`vrp`bxwfsfubfpw`zifdsjvvxaufsruw`zifdsjv{`udvxaufsruw`zifsdjvxpjwvxaufsruwbwswjdvxaufsruwirvd`w`vxaufsruwsfubfpwufsruw`dow}sfX ufsruwhsxpjwvxaufsruwufsruwhsxpjwvxaufsruwWufsruwhusWufsruwxpjwXufsruw{`udXwdbvYvxaufsruwwdbvYxpjwvxaufsruwwdbvY{`udvxaufsruwxuf|sruw d`w``bbfvvs`hfvd`w`a`vfvgruov ordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv`dow}sf `mm`pv{fuv `mmt`pd` `mmtxfvwjrpv ov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxwov}vdavxoo`u}jpgrxvfudfgjpfdgsg o@         ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D EFGHIJKLMNOPQRSTUVWX Y Z[\]^_`abcdefghijklmnopq r s t u vwxyz{|}~    !'5AZpz `' o         ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJKLMNOPQLRLSLTLULVLWLXLYL ZL[L\L]L^L_L`LaLbLcLdLeLfLgLhLijklmnopqr s t u v wxyz{|}~   $*06<BRLYL _L eL jL pLvLL fhy {I7% @ @ @ @  @@ @@' 1$@  ((  @%<$3J`4p k #? - -------------$-% -& -' -( -) -* -+ -, -- -. -/ 9 9 9 9 999999 9 9 9 9 9999999999999999999 9!9"9#9$9%9&<<<<<<<<<< < < < < <<<<<< < < <!<!<!<"<"<"<#<#<#<$< $&>&>'>'>'>(>(>(>)> )> )> *> *> *>+>+>+>,>,>,>->->->.>.>.>/>/>/>0>0>0>  >! >" ># >$ >% >& >' ? ? ? ? ? ? ? ??? ? ? ? ? ??????????????????? ?!?"?#?$?%22?&22222222 2 2 2 2 222222---- -- ----!-"-#-#@ @ @ @ @FHK IPJKTMOXQ!W]X(|bho8}   '%%&% './  !  - (!)"*#0'$F,GGGGG G G G G GGHHHHHHHHHHHIIIIII I!I"I#I$IJ%J'J(J)J*JJJJJJ&KKKK K K Kons\.a_^^VaZ[aZgaWWd\_WXYZZZ[[Y[ZVVVV0&.a_^^VaZ\aZgaWWd\_WXYZZZ[[Y[ZVVVV0&.a_^^VaZ]aZgaWWd\_WXYZZZ[[Y[ZVVVV0&.a_^^VaZ^aZgaWWd\_WXYZZZ[[Y[ZVVVV0&.a_^^VaZ_aZgaWWd\_WXYZZZ[[Y[ZVVVV0&.a_^^VaZ`aZgaWWd\_WXYZZZ[[Y[ZVVVV0&.a_^^VaZaaZgaWWd\_WXYZZZ[[Y[ZVVVV0&.a_^^VaZbaZgaWWd\_WXYZZZ[[Y[ZVVVV0&.a_^^VaZdaZgaWWd\_WXYZZZ[[Y[ZVVVV0&.a_^^VaZfaZgaWWd\_WXYZZZ[[Y[ZVVVV0& .a_^^VaZgaZgaWWd\_WXYZZZ[[Y[ZVVVV0& .a_^^Va[VaZgaWWd\_WXYZZZ[[Y[ZVVVV0& .a_^^Va[WaZgaWWd\_WXYZZZ[[Y[ZVVVV0& .a_^^Va[XaZgaWWd\_WXYZZZ[[Y[ZVVVV0& .a_^^Va[YaZgaWWd\_WXYZZZ[[Y[ZVVVV0&.a_^^Va[ZaZgaWWd\_WXYZZZ[[Y[ZVVVV0&.a_^^Va[[aZgaWWd\_WXYZZZ[[Y[ZVVVV0&.a_^^Va[\aZgaWWd\_WXYZZZ[[Y[ZVVVV0&.a_^^Va[]aZgaWWd\_WXYZZZ[[Y[ZVVVV0&.a_^^Va[^aZgaWWd\_WXYZZZ[[Y[ZVVVV0&.a_^^Va[_aZgaWWd\_WXYZZZ[[Y[ZVVVV0,.a_^^Va[`aZgaWWd\_WXYZZZ[[Y[ZVVVV0,.a_^^Va[aaZgaWWd\_WXYZZZ[[Y[ZVVVV0,.a_^^Va[baZgaWWd\_WXYZZZ[[Y[ZVVVV0,.a_^^Va[daZgaWWd\_WXYZZZ[[Y[ZVVVV0,!C@622N@ValidReasons3.........., #!C@622N@ValidReasons2.........., "s!C@02N@ValidReasons----------+ C 1xH@L J@tblStore@}LWF000@SG55))))))' !C@02N@Switchboard,,,,,,,,,,* j!C@02N@Reasons subform0000000000. !C@02N@Patient3))))))))))' o!C@@/2N@Patient2))))))))))' C !C@@/2N@Patient((((((((((& !C@@/2N@InternalPatient0000000000. H@@/2N@ImportOld**********( L      @`pv{fuvs`uwgrxu&`pv{fuvs`uwrpf&`pv{fuvs`uwrpf& `pv{fuvs`uwwiuff&`pv{fuvs`uwwiuff&`pv{fuvs`uww{r&`pv{fuvs`uww{r,`ubibrosurz&`ubijzfdtWXY[& `ubijzfduf`vrpv&`ubijzfdz`mjduf`vrp&`ubijzfs`uwZ,`xdjwfds`wjfpw& `xdjwfds`wjfpw,brosurz&brosurz,s`wjfpw&s`wjfpw,uf`vrpv& uf`vrpv&uf`vrpv&z`mjduf`vrp&z`mjduf`vrp&z`mjduf`vrp&z`mjduf`vrp& ===1111111/ @A{/N@҉/N@AnswersPartOne@;;;///////- @5Ё/N@{/N@AnswersPartFour@<<<0000000. @'Wu/N@g/N@AnswerspartFive@<<<0000000. @!q/N@vt/N@AnswersForReports@>>>22222220 @CIW#C@!#C@@Ans3ToArchive@l@|@RFF:......, `H<#C@W#C@@Ans3AToArchive@}@|@SGG;//////- `CE*#C@g#C@AllQuestions8@`@E99-------+ @CC#C@<#C@AllAnswers@z`@C77+++++++) @lI@c8I@AdmType@z444(((((((& @B3* #C@"#C@Export@3'''''''''% Ag#C@H42N@UR##########! C?"C@#C@TDCS3Unit subreport4@LWF000c@^R@@4444442  C=TI@Ԏk:I@ReportWard2LWF000yVJ88,,,,,,*  C;A"C@H42N@ReportGrp1++++++++++) :P"C@H42N@ReportGpUnit subreport188888888886 9o"C@"C@ReportGpUnit subreport@LWF000) aUCC7777775 d @@ @`pv{fuvs`uwgrxu&`pv{fuvs`uwrpf& `pv{fuvs`uwwiuff&`pv{fuvs`uww{r&`ubibrosurz,`ubijzfds`wjfpw&`ubijzfds`wjfpw&`ubijzfds`wjfpw& `ubijzfds`wjfpw&`xdjwfds`wjfpw&`xdjwfds`wjfpw& `xdjwfds`wjfpw&`xdjwfds`wjfpw&`xdjwfds`wjfpw,brosurz&s`wjfpw&s`wjfpw&s`wjfpw&s`wjfpw&s`wjfpw,tWuf`vrp& xpjwv,xpjwv,{`udv& {`udv&uwrmdjpwfup`ms`wjfpws`wjfpws`wjfpwvxagruos`wjfpwXs`wjfpwYuf`vrpvvxagruov{jwbiar`udwamvwrufxpjwvvxagruo z`mjduf`vrpv z`mjduf`vrpvX z`mjduf`vrpvY z`mjduf`vrpvZ z`mjduf`vrpv[{`udvvxagruo{`udvxpjwvbrpgjuobirjbfbuf`wf`xwrgjfmdgjmfv`zfrsfpordxmfWordxmfXordxmfYufm`wjrpvijsordxmfvz`mjduf`vrp`bxwfsfubfpw`zifdsjvvxaufsruw`zifdsjv{`udvxaufsruw`zifsdjvxpjwvxaufsruwbwswjdvxaufsruwirvd`w`vxaufsruwsfubfpwufsruw`dow}sfX ufsruwhsxpjwvxaufsruwufsruwhsxpjwvxaufsruwWufsruwhusWufsruwxpjwXufsruw{`udXwdbvYvxaufsruwwdbvYxpjwvxaufsruwwdbvY{`udvxaufsruwxud`w``bbfvvs`hfvd`w`a`vfvgruov ordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxwov}vdavxoo`u}jpgrxvfudfgjpfd> QMGZt<h Io-|=@Tp2N@Tp2N@ImportForm))))))))))) d!C@l.2N@ImportForm++++++++++) !C@l.2N@HosData((((((((((& ]!C@l.2N@ExportFormDHS.........., C!C@l.2N@CtPtID subform//////////- 삺H@,2N@ContinueDB++++++++++) B!C@,2N@ComProvUpdate.........., !C@,2N@ComProv((((((((((& o!C@,2N@CommunityProvider22222222220 2ʩ!C@j+2N@AnswersPartTwo subform77777777775  !C@j+2N@AnswersPartThreeA subform::::::::::8  k!C@j+2N@AnswersPartThree subform99999999997  !C@j+2N@AnswersPartOne subform77777777775  9e!C@j+2N@AnswersPartFour subform88888888886  (w!C@d(2N@AnswersPartFive subform88888888886  ]!C@v!C@UserDefined1@/888,,,,,,,* @ !C@xv!C@SummaryInfoj@/888,,,,,,,* @ h_=C@nA0N@AccessLayout*@/@.E99-------+ @]E!C@]E!C@SysRel''''''''''% ]E!C@]E!C@Scripts((((((((((& ]E!C@]E!C@Reports((((((((((& ]E!C@]E!C@Modules((((((((((& !C@!C@Forms&&&&&&&&&&$ ]E!C@]E!C@DataAccessPages0000000000. T< C@T< C@MSysRelationships22222222220 T< C@T< C@MSysQueries,,,,,,,,,,* T< C@T< C@MSysACEs))))))))))' T< C@T< C@MSysObjects,,,,,,,,,,* T< C@T< C@Relationships.........., T< C@T< C@Databases**********( T< C@T< C@Tables''''''''''% !NJG\Ez<Xb^C&njBAAN88[͍I@3I@ReportAdmType2NLWF000OKYM;;//////- 7=R"C@S"C@Percent5@DLWF000wIRF44((((((&  5M."C@P"C@CtPtID subreport@DLWF000@E[O==111111/  3M"C@&"C@AvHEDPISWard subreport@;LWF000@AaUCC7777775 2g!C@M"C@AvHEDPIS subreport@;LWF000@7]Q??3333331 0M!C@H42N@ValidReason,,,,,,,,,,* /H@H42N@RelationshipModules44444444442 .!C@H42N@Module3((((((((((& -!C@tm32N@Module2((((((((((& +!C@tm32N@FileSaveOpen----------+ *e5غH@tm32N@CreateAutoField0000000000. )@!C@tm32N@ConfirmChoice.........., (o !C@tm32N@WardsUnits++++++++++) 'xX!C@K!C@Wards subformz@;LWF000@=XL::......, &!C@622N@ValidReasons5.........., %}!C@622N@ValidReasons4.........., $!C@622N@ValidReasons3.........., #!C@622N@ValidReasons2.........., "s!C@02N@ValidReasons----------+  1xH@L J@tblStore@;LWF000@=SG55))))))' !C@02N@Switchboard,,,,,,,,,,* j!C@02N@Reasons subform0000000000. !C@02N@Patient3))))))))))' o!C@@/2N@Patient2))))))))))'  !C@@/2N@Patient((((((((((& !C@@/2N@InternalPatient0000000000. H@@/2N@ImportOld**********(  GCGFokFC?ED?C@BW A` AbPd{PPVj#C@7ܪH@@AppPartFive@o@@nD88,,,,,,,* @Oh#C@3~j#C@@AppExcPat@o|@nB66*******( @M4tc#C@qe#C@@AppCampDatax@m|@lD88,,,,,,,* @LDa#C@4tc#C@@AppAuditedPatient@m|@lJ>>22222220 @BJ/N@9,/N@AnswersPartTwo@j;;;///////- @<)/N@0Ց/N@AnswersPartThreeA|@i>>>22222220 @6xG/N@/N@AnswersPartThree|@i===1111111/ @*Ё/N@{/N@AnswersPartFour@h<<<0000000. @$Wu/N@g/N@AnswerspartFive@g<<<0000000. @q/N@vt/N@AnswersForReports@g>>>22222220 @J!#C@?$#C@@Ans5ToArchive|@e|@fF::......., @H<#C@W#C@@Ans3AToArchive@e|@dG;;///////- @GK#C@<#C@@Ans2ToArchive{@c|@dF::......., @E*#C@g#C@AllQuestions8@c`@aE99-------+ @Dy#C@+I@AllQandA@b$@aA55)))))))' @lI@c8I@AdmType@/444(((((((& @B3* #C@"#C@Export@73'''''''''% Ag#C@H42N@UR##########! @#C@g#C@TDCS3Ward subreport4@RLWF000#_^R@@4444442  >"C@"C@TDCS3 subreport$@RLWF000T@]ZN<<000000.  <Z5I@t J@ReportUnit2VLWF000SVJ88,,,,,,*  :P"C@H42N@ReportGpUnit subreport188888888886 9o"C@"C@ReportGpUnit subreport@RLWF000) PaUCC7777775 VCGN 2AdmType8Tp2N@Tp2N@ReportAdmType2----------- 7Tp2N@Tp2N@Percent&&&&&&&&&&& 6Tp2N@Tp2N@HosData subreport00000000000 5Tp2N@Tp2N@CtPtID subreport/////////// 4Tp2N@Tp2N@AvHEPDISUnit subreport55555555555 3Tp2N@Tp2N@AvHEDPISWard subreport55555555555 2Tp2N@Tp2N@AvHEDPIS subreport11111111111 1Tp2N@Tp2N@AcutePercent+++++++++++ 0Tp2N@Tp2N@ValidReason*********** /Tp2N@Tp2N@RelationshipModules22222222222 .Tp2N@Tp2N@Module3&&&&&&&&&&& -Tp2N@Tp2N@Module2&&&&&&&&&&& ,Tp2N@Tp2N@Module1&&&&&&&&&&& +Tp2N@Tp2N@FileSaveOpen+++++++++++ *Tp2N@Tp2N@CreateAutoField........... )Tp2N@Tp2N@ConfirmChoice,,,,,,,,,,, (Tp2N@Tp2N@WardsUnits))))))))))) 'Tp2N@Tp2N@Wards subform,,,,,,,,,,, &Tp2N@Tp2N@ValidReasons5,,,,,,,,,,, %Tp2N@Tp2N@ValidReasons4,,,,,,,,,,, $Tp2N@Tp2N@ValidReasons3,,,,,,,,,,, #Tp2N@Tp2N@ValidReasons2,,,,,,,,,,, "Tp2N@Tp2N@ValidReasons+++++++++++ !Tp2N@TpATp2N@Tp2N@UR!!!!!!!!!!! @Tp2N@Tp2N@TDCS3Ward subreport22222222222 ?Tp2N@Tp2N@TDCS3Unit subreport22222222222 >Tp2N@Tp2N@TDCS3 subreport........... =Tp2N@Tp2N@ReportWard2*********** <Tp2N@Tp2N@ReportUnit2*********** ;Tp2N@Tp2N@ReportGrp1))))))))))) :Tp2N@Tp2N@ReportGpUnit subreport166666666666 9Tp2N@Tp2N@ReportGpUnit subreport55555555555 {   @ @@  @  `pv{fuvs`uwgjzfvxagruo`pv{fuvs`uwgrxuvxagruo`pv{fuvs`uwrpfvxagruo`pv{fuvs`uwwiuffvxagruo`pv{fuvs`uwwiuff`vxagruo`pv{fuvs`uww{rvxagruobrooxpjw}surzjdfubrosurzbrosurzxsd`wfbrpwjpxfdabwswjdvxagruof|sruwgruodivirvd`w`irvd`w`vxagruojosruwgruojosruwrmdjpwfup`ms`wjfpws`wjfpws`wjfpwvxagruos`wjfpwXs`wjfpwYuf`vrpvvxagruov{jwbiar`udwamvwrufxpjwvvxagruo z`mjduf`vrpv z`mjduf`vrpvX z`mjduf`vrpvY z`mjduf`vrpvZ z`mjduf`vrpv[{`udvvxagruo{`udvxpjwvbrpgjuobirjbfbuf`wf`xwrgjfmdgjmfv`zfrsfpordxmfWordxmfXordxmfYufm`wjrpvijsordxmfvz`mjduf`vrp`bxwfsfubfpw`zifdsjvvxaufsruw`zifdsjv{`udvxaufsruw`zifsdjvxpjwvxaufsruwbwswjdvxaufsruwirvd`w`vxaufsruwsfubfpwufsruw`dow}sfX ufsruwhsxpjwvxaufsruwufsruwhsxpjwvxaufsruwWufsruwhusWufsruwxpjwXufsruw{`udXwdbvYvxaufsruwwdbvYxpjwvxaufsruwwdbvY{`udvxaufsruwxud`w``bbfvvs`hfvd`w`a`vfvgruov ordxmfv ufm`wjrpvijsvufsru<Hj @ @ @ @ @ @ @ @           ! " # $ % &'()*+,-./012345678 9:;<=>?@AvrpvX z`mjduf`vrpvY z`mjduf`vrpvZ z`mjduf`vrpv[{`udvvxagruo{`udvxpjwvbrpgjuobirjbfbuf`wf`xwrgjfmdgjmfv`zfrsfpordxmfWordxmfXordxmfYufm`wjrpvijsordxmfvz`mjduf`vrp`bxwfsfubfpw`zifdsjvvxaufsruw`zifdsjv{`udvxaufsruw`zifsdjvxpjwvxaufsruwbwswjdvxaufsruwirvd`w`vxaufTp2N@Tp2N@AdmType&&&&&&&&&&& BTp2N@Tp2N@Export%%%%%%%%%%% ATp2N@Tp2N@UR!!!!!!!!!!! @Tp2N@Tp2N@TDCS3Ward subreport22222222222 ?Tp2N@Tp2N@TDCS3Unit subreport22222222222 >Tp2N@Tp2N@TDCS3 subreport........... =Tp2N@Tp2N@ReportWard2*********** <Tp2N@Tp2N@ReportUnit2*********** ;Tp2N@Tp2N@ReportGrp1))))))))))) :Tp2N@Tp2N@ReportGpUnit subreport166666666666 9Tp2N@Tp2N@ReportGpUnit suSubacute Acute2C0 j8b2]4 o:KzgT4!FPatientIDAnswersPartOne.PatientID9 wFAnswerIDAnswersPartOne.AnswerID7 wFAnswersPartOne F GFArchivedQ1235 OF F EX7YZ_____2!@" 7EX7YZ_____1@" 7E GE  GE E D AllAnswers.PatientID, 'D AllQuestions.Indicator. 'Dw@ 'DWardsAuditedPatient$@+ DUnitsAuditedPatient$@+ DAllAnswersAuditedPatient/@0$ DAllAnswersAllQuestions4@." DAuditedPatient.IntroA- gDAuditedPatient.WardID- gD AuditedPatient.UnitID- gD Wards.Ward" gD Units.Unit" gD AllQuestions.GroupIndicator3 gD AuditedPatient.AdmType. gDAuditedPatient.PatientUR0 gDAllAnswers.Valid( gDAllAnswers.Answer) gDAllAnswers.QuestionID- gDAllQuestions.QuestionNumber3 gDAllAnswers.PatientID, gDAllQuestions.Indicator. gDAllAnswers.AnswerID+ gDAuditedPatient DAllQuestions DAllAnswers DUnits DWards D GD GD D CX7YZ_____2SELECT* FROM [AnswersPartFive]A 7CX7YZ_____1@" 7C GC  GC C LVAL`,>xVQ/)r6ArchivedQ1235.PatientID = Compare1.ArchivedPatient.PatientIDCompare1.ArchivedPatient.PatientID(((ArchivePart4.QuestionID) Like "Was this community provider notified at least 2 days prior to discharge?" Or (ArchivePart4.QuestionID) Like "Was this community provider notified at least 1 day prior to discharge?" Or (ArchivePart4.QuestionID) Like "Did the referral meet minimum content criteria?"))ArchComProv.CommunityID=ArchivePart4.CommunityIDCompare1.ArchivedPatient.PatientID=ArchComProv.PatientID(((ArchivedQ1235.QuestionID) Like "Did the discharge summary contain all minimum content criteria?" Or (ArchivedQ1235.QuestionID) Like "Was the discharge summary dispatched within 1 day of discharge?"))ArchivedQ1235.PatientID = Compare1.ArchivedPatient.PatientIDCompare1.ArchivedPatient.PatientID(((Patient.PatientID)=[Forms]![Patient]![PatientID]))ArchComProv.PatientID=Compare1.ArchivedPatient.PatientIDCompare1.ArchivedPatient.PatientID((([Patient].[PatientID])=[Forms]![Patient3]![PatientID]))ArchivedPatient.PatientID=Compare1.ArchivedPatient.PatientIDCompare1.ArchivedPatient.PatientIDSELECT* FROM [PartFiveQuestions]SELECT* FROM [PartOneQuestions] UNION SELECT* FROM [PartTwoQuestions] UNION SELECT* FROM [PartThreeQuestions] UNION SELECT* FROM [PartFourQuestions] (((AllQuestions.Indicator) Is Not Null And (AllQuestions.Indicator)<>"PI 1/PI 2 Link") AND ((AuditedPatient.IntroA)=2))Wards.WardID = AuditedPatient.WardIDUnits.UnitID = AuditedPatient.UnitIDAllAnswers.PatientID = AuditedPatient.PatientIDAllAnswers.QuestionID = AllQuestions.PartOneQuestionSELECT* FROM [AnswersPartOne] UNION SELECT* FROM [AnswersPartTwo] UNION SELECT* FROM [AnswersPartThree] UNION SELECT* FROM [qryAnswersPartFour] x @@@ @`pv{fuvs`uwgjzfvxagruo`pv{fuvs`uwgrxuvxagruo`pv{fuvs`uwrpfvxagruo`pv{fuvs`uwwiuffvxagruo`pv{fuvs`uwwiuff`vxagruo`pv{fuvs`uww{rvxagruobrooxpjw}surzjdfubrosurzbrosurzxsd`wfbrpwjpxfdabwswjdvxagruof|sruwgruodivirvd`w`irvd`w`vxagruojosruwgruojosruwrmdjpwfup`ms`wjfpws`wjfpws`wjfpwvxagruos`wjfpwXs`wjfpwYuf`vrpvvxagruov{jwbiar`udwamvwrufxpjwvvxagruo z`mjduf`vrpv z`mjduf`vrpvX z`mjduf`vrpvY z`mjduf`vrpvZ z`mjduf`vrpv[{`udvvxagruo{`udvxpjwvbrpgjuobirjbfbuf`wf`xwrgjfmdgjmfv`zfrsfpordxmfWordxmfXordxmfYufm`wjrpvijsordxmfvz`mjduf`vrp`bxwfsfubfpw`zifdsjvvxaufsruw`zifdsjv{`udvxaufsruw`zifsdjvxpjwvxaufsruwbwswjdvxaufsruwirvd`w`vxaufsruwsfubfpwufsruw`dow}sfX ufsruwhsxpjwvxaufsruwufsruwhsxpjwvxaufsruwWufsruwhusWufsruwxpjwXufsruw{`udXwdbvYvxaufsruwwdbvYxpjwvxaufsruwwdbvY{`udvxaufsruwxuf|sruw d`w``bbfvvs`hfvd`w`a`vfvgruov ordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv`dow}sf `mm`pv{fuv `mmt`pd` `mmtxfvwjrpv ov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxwov}vdavxoo`u}jpgrxvfudfgjpfd}@ @@@ @ @@  @z`mjduf`vrp`bxwfsfubfpw`zifdsjvvxaufsruw`zifdsjv{`udvxaufsruw`zifsdjvxpjwvxaufsruwbwswjdvxaufsruwirvd`w`vxaufsruwsfubfpwufsruw`dow}sfX ufsruwhsxpjwvxaufsruwufsruwhsxpjwvxaufsruwWufsruwhusWufsruwxpjwXufsruw{`udXwdbvYvxaufsruwwdbvYxpjwvxaufsruwwdbvY{`udvxaufsruwxuf|sruw d`w``bbfvvs`hfvd`w`a`vfvgruov ordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv`dow}sf `mm`pv{fuv `mmt`pd` `mmtxfvwjrpv `pvWwr`ubijzf`pvXwr`ubijzf`pvY`wr`ubijzf`pvYwr`ubijzf`pv[wr`ubijzf`pv{fuvgruufsruwv`pv{fuvs`uwgjzf`pv{fuvs`uwgrxu`pv{fuvs`uwrpf`pv{fuvs`uwwiuff`pv{fuvs`uwwiuff``pv{fuvs`uww{r`ss`ubiswwr`xdjw`ss`xdjwfds`wjfpw`ssb`osd`w``ssbrosurz`ssf|bs`w`sss`uwgjzf`sss`uwgrxuL`sss`uwrpfL`sss`uwwiuffL`sss`uwwiuff`L`sss`uww{rL`ssuf`vrpvL`ssz`muf`vrpL`ubibrosurzL`ubibrosurzjdfuL`ubijzf`xdjwfdL `ubijzfds`wjfpwL `ubijzfdtWXY[L `ubijzfduf`vrpvL `ubijzfdz`mjduf`vrpL `ubijzfs`uwZL`ubijzfz`muf`vrpL`ubis`wgruf|sruwL`ubiuf`vrpvL`xdjwfds`wjfpwL`xdjwfds`wjfpw,burvvw`aLov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxwov}vdavxoo`u}jpgrxvfudfgjpfd C #+LZf,n+n1 u3y=*@ @ JAnswerIDAnswerspartFive.AnswerID8 wJAnswerspartFive J GJArchivedQ1235 OJ J IValid2AnswersPartThree.Valid25 wIValidAnswersPartThree.Valid3 wIAnswerAnswersPartThree.Answer5 wIQuestionIDAnswersPartThree.QuestionID= wIPatientIDAnswersPartThree.PatientID; wIAnswerIDAnswersPartThree.AnswerID9 wIAnswersPartThree I GIArchivedQ1235 OI I HValid2AnswersPartThreeA.Valid26 wHValidAnswersPartThreeA.Valid4 wHAnswerAnswersPartThreeA.Answer6 wHQuestionIDAnswersPartThreeA.QuestionID> wHPatientIDAnswersPartThreeA.PatientID< wHAnswerIDAnswersPartThreeA.AnswerID: wHAnswersPartThreeA H GHArchivedQ1235 OH H GValid2AnswersPartTwo.Valid23 wGValidAnswersPartTwo.Valid1 wGAnswerAnswersPartTwo.Answer3 wGQuestionIDAnswersPartTwo.QuestionID; wGPatientIDAnswersPartTwo.PatientID9 wGAnswerIDAnswersPartTwo.AnswerID7 wGAnswersPartTwo G GGArchivedQ1235 OG G FValid2AnswersPartOne.Valid23 wFValidAnswersPartOne.Valid1 wFAnswerAnswersPartOne.Answer3 wFQuestionIDAnswersPartOne.QuestionID; w-|AdIQxB/g0NQ eNCommunityIDArchComProv.CommunityID: wNCompare1 NArchComProv NComProv ON N MCampus PatientNew.F2+ wMcampName PatientNew.F1- wMPatientNew M GMCampusData OM M L:@  'LIntroA[Patient].[IntroA]0 wLAdmType[Patient].[AdmType]2 wLSepDate[Patient].[SepDate]2 wLAdmDate[Patient].[AdmDate]2 wLWardID[Patient].[WardID]0 wLUnitID[Patient].[UnitID]0 wLPatientUR[Patient].[PatientUR]6 wLPatientID[Patient].[PatientID]6 wLPatient LAuditedPatient OL L KArchivedPatientCompare1<@ /# KPatientID"@! wKIntroAArchivedPatient.IntroA4 wKWardIDArchivedPatient.WardID4 wKUnitIDArchivedPatient.UnitID4 wKAdmTypeArchivedPatient.AdmType6 wKSepDateArchivedPatient.SepDate6 wKAdmDateArchivedPatient.AdmDate6 wKPatientURArchivedPatient.PatientUR: wKCompare1 KArchivedPatient KAuditedPatient OK K JValid2AnswerspartFive.Valid24 wJValidAnswerspartFive.Valid2 wJAnswerAnswerspartFive.Answer4 wJQuestionIDAnswerspartFive.QuestionID< wJPatientIDAnswerspartFive.PatientID: wVC"N      d     AnswersIDNew AnswerIDOld PatientID QuestionIDAnswerValidValid2 P\!/"  #AnswerID PatientID PrimaryKey QuestionID" # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHI ov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxwov}vdavxoo`u}jpgrxvfudfgjpfdgruo,z`mjduf`vrpvYgruo,z`mjduf`vrpvZgruo,z`mjduf`vrpv[ngruo,{`udvxpjwvnordxmfWn ordxmfXnordxmfYnov}vdanufm`wjrpvijsordxmfvKn ufsruw,ufsruwhsxpjwvxaufsruwWnufsruw,ufsruwhusWnufsruw,xunz`mjduf`vrpnFlagMSysQueriesFlag00,!! ExpressionMSysQueriesExpression<<2'' Name2MSysQueriesName222-"" Name1MSysQueriesName122-""AttributeMSysQueriesAttribute::1&&{qgHj1G n+n1 u3y=* @ JAnswerIDAnswerspartFive.AnswerID8 wJAnswerspartFive J GJArchivedQ1235 OJ J IValid2AnswersPartThree.Valid25 wIValidAnswersPartThree.Valid3 wIAnswerAnswersPartThree.Answer5 wIQuestionIDAnswersPartThree.QuestionID= wIPatientIDAnswersPartThree.PatientID; wIAnswerIDAnswersPartThree.AnswerID9 wIAnswersPartThree I GIArchivedQ1235 OI I HValid2AnswersPartThreeA.Valid26 wHValidAnswepvJ\-v2N@ dw2N@Ans5ToArchive,,,,,,,,,,, I\-v2N@\-v2N@@Ans3ToArchive,,,,,,,,,,, H\-v2N@\-v2N@@Ans3AToArchive----------- Gt2N@\-v2N@@Ans2ToArchive,,,,,,,,,,, Ft2N@t2N@@Ans1ToArchive,,,,,,,,,,, E؁s2N@t2N@AllQ           ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJ ahtOFN_ALLOWMULTISELECT( ahtOFN_EXTENSIONDIFFERENT( ahtOFN_PATHMUSTEXIST ( ahtOFN_FILEMUSTEXISTW( ahtOFN_CREATEPROMPTֶ( ahtOFN_SHAREAWARE( ahtOFN_NOREADONLYRETURN5( ahtOFN_NOTESTFILECREATE( ahtOFN_NONETWORKBUTTON.( ahtOFN_NOLONGNAMESC( ahtOFN_EXPLORERW( ahtOFN_NODEREFERENCELINKS[( ahtOFN_LONGNAMES( TestIt ( GetOpenFileq varDirectoryAvarTitleForDialog. varFileName IsMissingTrimNull DefaultExtyFileNamejhwnd/ strFileNameefResult Application* hWndAccessApp vbNullStringstrDescriptiondvarItem vbNullCharYstrItemintPosr( FileSave  Module1b erTHospNamenRegionContactUPhone+W Command149nClickActivate|GotFocusKItemzacSpreadsheetTypeExcel97RecordsetClone8Collect_B_var_Patient subformControlsK_B_var_Switchboard _B_var_HexUopemfActiveConnection dbsNorthwind OpenDatabase` rstEmployeesDdbsǂEffDisgxOption9Label10@Option11dLabel12B Indicator Part2Indicatork PartTwoQID> AfterUpdate CommunityIDK! PartOneQIDOption16dLabel17GOption14dLabel15EBox68Box69Label66ValidID*CommunityID_LabelmPatientID_Label=AnswersPartFour_subform ComProv_Label@Y Command15 Command16 NotInList Command19 Command20ComIDJ AuditedCount IntroAw} Command137G Command146k Command152 HospNum_Label;UHospName_Label) Region_Label Contact_Label Phone_Label CloseAndSaveDlLabel11ALabel13C Command140eBox36h UnitID_LabelN WardID_LabelP AdmDate_LabelS SepDate_LabelPatientUR_LabelD AdmType_Label'Option21eLabel22gOption23eLabel24iReasons_subformReasons_subform_LabelHBox30bIntroQ}Label43Label44 Command51?Label53Label54Label59Label60Box61Label62CurrenteLabel47Label74"Box43Box44Box46AnswersPartOne_subform7AnswersPartTwo_subform!yLabel51Label52 Command54B DeactivatejAnswersPartThree_subform Label56AnswersPartFive_subform Command62eAnswersPartThreeA_subformComman/GrpUnit_GroupIndicatorCountOfGroupIndicatorgSLabel8,PageFooterSectionLine7 ReportFooterR.GroupIndicatorPerfromanceInd#GrpAdmType_GroupIndicatorLabel19ILine17=%YesAnswersGrpAdminType.GroupIndicatorLEYesAnswersGrpAdminType.AdmTypeGrpAdmType.AdmTyperLabel2,Line5Text3~Text4~ _B_var_Set_B_var_dbsEffDis=_B_var_OpenDatabasemCurrentDatabase._B_var_CurrentDatabase_B_var_OpenRecordSetsPAdobe, _B_var_AdobevHosdata_B_var_Hosdata tblHopital tblHospitalw{_B_var_tblHospitallhosdat_hosdat subform_B_var_hosdat subformHosData subformz'_B_var_HosData subform Fa4]_B_var_PatientWE_B_var_Reasons subform_B_var_Label50X_B_var_PatientIDd_B_var_AnswersPartTwo subform_B_var_Patient2_B_var_AnswersPartOne subform_B_var_ValidReasons_B_var_QuestionNumberw_B_var_AnswerID(_B_var_AdmType3_B_var_Patient3_B_var_ComProvR _B_var_AnswersPartThree subform_B_var_AnswersPartFive subformc_B_var_ValidReasons37 _B_var_Text14_B_var_ValidReasons57_B_var_CtPtID subform Form_ContinueDBCommand0_ClickF[Err_Command0_Clickstbutton stbutton1fftblStore subform storeQExit_Command0_Click<"Command3_ClickErr_Command3_ClickzPrintOut.Exit_Command3_ClickacDesign֡ DeleteControlCommand6_ClickiErr_Command6_Clickv1Exit_Command6_Click Form_ImportOld$strQuel RelationBinti\ RelationsSCount0vTable ForeignTableDeletexErr_Command152_Click_ Exit_Command152_Click~Command160_ClicksErr_Command160_ClickExit_Command160_ClickstrSwitchboardiCommand0Command3UnitID_AfterUpdatemWardID_AfterUpdateCommand6_B_var_ValidReasons47_B_var_ValidReasons27 _B_var_AnswersPartThreeA subforma _B_var_CurDirT _B_var_Stringӊ _B_var_LeftQ_B_var_InternalPatient_B_var_AnswersPartFour subform_B_var_Combo73K*_B_var_Combo39)_B_var_Command60_B_var_Command49g_B_var_Combo77O*_B_var_Frame180_B_var_Command53_B_var_PatientUR._B_var_tblStore subform_B_var_CurrentProjectp_B_var_fCreateAutoNumberField]Module4e ErrHandler }fld܎Field3tdfTableDefm TableDefs%i CreateFielddbLong AttributesdbAutoIncrField9Fields7ExitHereP$vbCrLfvbOKOnly vbCritical+} CreateAutoField# _B_var_DAO?tblStore_subformܪ_B_var_ActiveConnection/ stQuery12? stQuery13@ stQuery14A stQuery15B stQuery16C stQuery17D_B_var_stQuery1I#store0 ;%"N#;$&K[m)c  *+3 +'07-94;5=!67A8?9G@A :C DAB;SVCN%%    d   AnswerID PatientID QuestionIDAnswerValidValid2($%&%'%( %)AnswerID PatientID PrimaryKey QuestionIDrU~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~E )*}#qL  f&9y I 9a 1Y{qg!Q  9 i   r)r Qr    !Form_AnswersPartFive subformForm_AnswersPartFour subformForm_AnswersPartOne subformForm_AnswersPartThree subformForm_AnswersPartThreeA subformForm_AnswersPartTwo subformForm_CommunityProvider Form_ComProvForm_ComProvUpdateForm_CtPtID subformForm_ExportFormDHS Form_HosDataForm_ImportFormForm_InternalPatient Form_PatientBox115 Form_Patient2 Form_Patient3Form_Reasons subformForm_SwitchboardForm_Valid@$           ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJ  gtZsC gtZsCgtZsCgtZsC&gtZsC%gtZsC gtZsC)gtZsC(gtZsCgtZsC+gtZsC*gtZsC!'ZsC$'ZsC#'ZsC''ZsC)'ZsC('ZsCa*}#qLc*}#qLb*}#qLf*}#qLh*}#qLg*}#qLk*}#qLm*}#qLl*}#qLn*}#qLp*}#qLo*}#qLq*}#qL}#DEST}#DESTr*}#qLt*}#qLs*}#qLu*}#qLw*}#qLv*}#qLx*}#qLz*}#qLy*}#qL{*}#qL}*}#qL|*}#qL~*}#qL*}#qL*}#qL*}#qL*}#qL*}#qLj*}$#qL*}#qL*}#qL*}#qL*}#qL*}#qL DeleteValidReason*}#qL*}#qL*}#qL*}#qL*}#qL*}#qL*}#qL*}#qL__SRP_14rU~~~~~~~~~~~~~~c     Q   (  9 8  H  X  yh strMessageOFN varDirectoryvarTitleForDialogFlags InitialDirFilter FilterIndex DefaultExtFileName DialogTitlehwndOpenFile strFilterstrDescriptionvarItemstrItem  9;x  <  =CancelNewDataResponse  o MyFormName  y    y FormatCount strTableName strFieldName]$ fĤIx8< ReportWard2Requery WardID 3No Ward audits have been completed REPORT CANCELLED Ans1ToArchive Ans2ToArchive DelPart2 Ans3ToArchive DelPart3 Ans3AToArchive DelPart3A Ans5ToArchive DelPart5 Part4ToArchive DelPart4 ArchiveAudited DelAudPat ArchiveValReason DelValReas Archreasons DelReasons ArchComProvider DelComProvArch DeletePatientA ~Are you sure you wish to Archive data? If OK, please save archived patient Info to Excel file for future importing as requiredConfirm  ,,LL, $,0<HsR#ZsCaht_apiGetOpenFileName comdlg32.dll GetOpenFileNameA I(y(aht_apiGetSaveFileName GetSaveFileNameA I(I)CommDlgExtendedError CommDlgExtendedError I(*0TestIt GetOpenFileahtCommonFileOpenSaveahtAddFilterItemTrimNullFileSave *.xls OpenRecordSet Excel Files (*.xls) = ` * PArchived file not saved to Excel. If you wish to save to Excel rerun the archive ArchPatforExport Archive Complete Cancelled file selection Error No: ; Description: Box36 OpenRecordset hosdat subform hosdata subform HosData&BvZsCˉ&BvZsC5Ìp@\)Pʉ&BvZsCPhoneHospNumHospName CloseAndSaveContactCampusRegionCloseAndSave_Cli$DHS /No audits have been completed. REPORT CANCELLED DeleteScores MakeAdmTypeScores MakeWardScores MakeUnitScoressR#ZsCsR#ZsC PatientLockedSetFocus BackColor AdmType AdmDate SepDate Label46Visible Label45 Combo77 Label41 Label69 Label68sR#ZsCsR#ZsCKÌp@\)PsR#ZsCLC7?Combo77 PatientURUnitIDWardID Command52Combo75 UnitID_Label WardID_LabelPatientUR_Label AdmType_Label[C7?Option21 AdmDate_LabelOption23 SepDate_LabelReasons_subformHC7?Frame18Box30Reasons_subform_LabelIntroQLabel43Label44Label53Label54Label50 Command51Box61Label59Label60Label47Label62Text57Label46Label45Label41Label68Label69Label74 PatientIDSepDateAdmDateAdmDate_AfterUpdateAdmType_AfterUpdateCombo73_AfterUpdate Form_Current Form_OpenFrame18_AfterUpdateCombo39_AfterUpdateCommand49_ClickCommand51_ClickCommand52_ClickPatientUR_AfterUpdateSepDate_AfterUpdateUnitID_NotInListWardID_NotInListCombo75_AfterUpdateCombo77_AfterUpdate V;|? Reasons subform Label50 Command54 Command52\;|?F;|?   [Patient]VCN++    d   AnswerID CommunityID QuestionIDAnswerValidValid2+,+-+. +/AnswerID PatientID PrimaryKey QuestionIDsR#ZsC AnswersPartFive subform ComProvidersR#ZsCsR#ZsCÌp@\)PsR#ZsCFrame6_AfterUpdatesR#ZsCsR#ZsCÌp@\)PsR#ZsCAnswersPartFour_subform Command15 Command13 Command14 Command16 CommunityID ComProviderCommand14_ClickComProvider_AfterUpdateCommand10_ClickComProvider_NotInListCommand12_ClickCommand13_ClickCommand15_ClickCommand16_Click lsR#ZsCsR#ZsCÌp@\)PsR#ZsC ValidReasons3 DeleteValidReason3 Q12 Part2QuestionNum Q10A Q10S Q10Reason Q11A Q11S Q11LOS Q11AAuto Q11SAuto Q11ReasonsR#ZsCsR#ZsCÌp@\)PsR#ZsCPart2IndicatorAnswerOption14Option16 Answer_Click h DelComProv xIsLoaded% GWas the need for a referral to a community service provider identified? ValidReasons5 DeleteValidReason5 Q15 Q14-15Reason Q16 Q16ReasonsR#ZsCsR#ZsCÌp@\)PsR#ZsC Command60Label63 Command71KC7?OtherCommand71_ClickZ;|{qg Valid2 AppAuditedPatient DelAuditedPatient CtPtID subform Combo75 Saved Record SavedForm_ContinueDBForm_ImportOldRelationshipModulesgGZsCpGZsCoGZsC Command152 sGZsCrGZsC Command160Command152_Click zGZsCGZsCGZsC{GZsCGZsCGZsC ValidReasons4 DeleteValidReason4 CommunityProvider Q14 Q13LOS3 Q13LOS2 Q13Reason 0Did this referral meet minimum content criteria?|GZsCGZsCGZsC}GZsCGZsCGZsC~GZsCGZsCGZsCGZsCGZsCGZsC ValidReasons2 PartThreeAcute PartThreeSub DeleteValidreason2 PartThreeLos Q9 Q7 Q7Reason Q8S Q8A Q81Day Command20 Q8Reason .Does this patient have a positive risk screen? @ *           ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJ $@\)PİGZsC Is there a valid reason why not?GZsCǰGZsC՛Ìp@\)PưGZsC TGZsCɰGZsCȰGZsCYGZsC˰GZsCZGZsCʰGZsCCommand6Command0Label2Command0_ClickCommand3_ClickCommand6_Click Command152 Command160 Command155bGZsCvGZsCcGZsCuGZsCCommand3 PrimaryPatientID FixQ15andQ16KillAllRelations AnswersPartFour ReportSetUp AnswersForReports AnswerspartFive AnswersPartThree AnswersPartThreeA AnswersPartTwo ArchComProv ArchivedQ1235 ArchivePart4 ArchivedReasons ArchivedValidreason ArchivedPatient AuditedPatient PartFiveQuestions PartFourQuestions*@ɹ/N@˹/N@PartFourQuestions@>>>22222220 @ N%C@P%C@@PartFourLOS2@|@E99-------+ @Ź/N@4rȹ/N@PartFiveQuestions@>>>22222220 @y3%C@5%C@@Part4ToArchive@@|@SGG;//////- `NjI@$ʋI@Num1234Ward,@888,,,,,,,* @0I@I@Num1234Unit,@888,,,,,,,* @#I@>&I@NotValidPI3,@888,,,,,,,* @xS!C@xS!C@MSysModules,,,,,,,,,,* 'C@'C@MSysCmdbars,,,,,,,,,,*  G@ ȅG@MSysAccessObjects22222222220 5k7D@vo7D@@MakeWardScoresh@@@G;;///////- @]7D@Aj7D@@MakeUnitScoresh@@@G;;///////- @,ù/N@Ĺ/N@ListComProv/@888,,,,,,,* @c]%C@%C@LastQPart1@|@C77+++++++) @'%C@c]%C@JoinHedPisWardQrys@`@ K??33333331 @P$C@I@JoinHedPisQrys @@G;;///////- @>$C@P$C@IndWard(@@ @44(((((((& @ը$C@YT$C@IndAdmType@ @ C77+++++++) @#Ľ/N@{/N@HosData@ 444(((((((& @I@'bI@HEDPISUnit@ 777+++++++) @FI@(I@HEDPISPI3Ward4@:::......., @UϗI@I@HEDPISPI3Unit@:::......., @I@?I@HEDPISs@333'''''''% @*nfoVersionIndex1*@!@@!@@@VCN11    d   AnswerID PatientID QuestionIDAnswerValidValid2Bl121314 15AnswerID PatientID PrimaryKey QuestionID6FB62.J G8Form_SwitchboardNEA51-*6=5Form_Reasons subform7IE951pWForm_Patient3B>2.* EForm_Patient2B>2.*|xForm_PatientA=1-)TkjForm_ImportOlddlC?3/+cbForm_ImportFormdD@40,`^Form_HosDataaA=1-)Q\w9YForm_ExportFormDHS7]GC73/VS>RForm_ContinueDBdTD@40,POForm_ComProvUpdateQGC73/a I7&HForm_ComProvdNA=1-)DF+EForm_CommunityProviderGKG;73C/@Form_AnswersPartTwo subformnDPL@<8=<Form_AnswersPartThreeA subform&?SOC?;74Form_AnswersPartThree subformn8RNB>:130Form_AnswersPartOne subformT3PL@<8+ *Form_AnswersPartFour subform/QMA=9{qg0h @X @HH @`8 @( 0`H"(,.2J@p @` @xP @@ @0 @ @ @ @  @P @8 @ @h @ @ @ @ LX@tME__SRP_1a rU 1 Y) Ai9y1QY 1 0           ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJ $*  "'@.@3@ ;@?@W@I AAAAAAAAAA A A A A AAAAAAAAAAAAAABB B B B B BBBB B B B   !'5AZpz    "'@.@3@ 6@ ;@?@W@0sp(ηA`ͷsp(ηXA`ͷůsp(ηA`ͷsp(ηB`ͷůsp(ηTB`ͷůsp(η@B`ͷůsp(ηAB`ͷůsp(ηBPC`ͷůsp(zη)C`ͷ.sp(η*C`ͷ%sp(η+LD`ͷ((sp(η/D`ͷ00sp(η0D`ͷPP sp(η1HE`ͷ``sp(η3E`ͷhhsp(η4E`ͷ%sp(η7DF`ͷsp(η8F`ͷsp(η<F`ͷ" sp(η=@G`ͷ sp(η?G`ͷ sp(Bη@G`ͷ0`ͷ``$ sp(ηF8I`ͷpp sp(ηGI`ͷxx sp(ηHI`ͷsp(ηI4J`ͷsp(ηJJ`ͷsp(ηNJ`ͷsp(ηO0K`ͷ!sp(ηPK`ͷ  sp(ηQK`ͷ((sp(ηR,L`ͷ@@&sp(ηSL`ͷPPsp(ηTL`ͷXXsp(ηV(M`ͷpp%.sp(ηW|M`ͷ.sp(ηXM`ͷ.sp(ηY$N`ͷsp(η\xN`ͷsp(η]N`ͷsp(η^ O`ͷ"sp(η`tO`ͷs0           ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D EFGHIJKLMNOPQRSTUVWX Y Z[\]^_`abcdefghijklmnopq r s t u vwxyz{|}~    !'5AZpz VCN77    d   AnswerID PatientID QuestionIDAnswerValidValid2[78LL797: w7;AnswerID PatientID PrimaryKey QuestionIDlPart3 o@|@MAA5))))))' `~:$C@X=$C@ DelPart2 j@|@MAA5))))))' ` |"5$C@ݣ8$C@ DeleteValidReason5@|@K??33333331 @{3$C@"5$C@ DeleteValidReason4@|@K??33333331 @ y-.$C@=0$C@ DeleteValidReason2@|@K??33333331 @xX+$C@-.$C@ DeleteValidReason@|@J>>22222220 @w}ZY7D@\Y7D@ DeleteScoresr@@E99-------+ @ u|=I@ÊI@ DeletePatientIDValidReasonh@GGG;;;;;;;9 @t#'$C@)$C@ DeletePatient @z|@RFF:......, ` rX!$C@q$$C@ DeletePartThreeQt@|@I==1111111/ @q$C@X!$C@ DeletePartThreeAQt@|@J>>22222220 @pso$C@$C@ DeletePartOneQp@|@G;;///////- @ nG$C@ $C@ DeletePartFourQ(@@H<<0000000. @m($C@^$C@ DeletePartFiveQp@|@H<<0000000. @k$C@O$C@ DelComProvArch@|@SGG;//////- `j#d $C@$C@ DelComProv@|@C77+++++++) @h$C@4 $C@ DelAuditedPatient @|@J>>22222220 @{qgREEEC^ZDVRCBIrnA*g6D@ Ǯ6D@DataTypeScore@zg6D@ Ǯ6D@DataTypeScore@z@F::......., @fG$C@$C@CtPtID@|@?33'''''''% @ṹ/N@#Ľ/N@ComProv@444(((((((& @dt滊I@I@AvHEDPISWard@999-------+ @cƷI@qI@AvHEDPISUnit*@999-------+ @boI@lI@AvHEDPIS%@555)))))))' @a"#C@W#C@AudPat@|@?33'''''''% @_M#C@sI@AuditedUnit_Crosstab4@@@MAA55555553 @^##C@M#C@AuditedPatientID@|@I==1111111/ @抴/N@m/N@AuditedPatientg;;;///////- @\{#C@#C@@ArchReasons_@@|@PDD8,,,,,,* `[#C@{#C@ArchPatforExport@@I==1111111/ @3/N@= /N@ArchivePart4@999-------+ @Q/N@,/N@ArchivedValidreason@6           ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJ $*0G;;///////- @?%C@}&%C@@PartThreeAcute@|@G;;///////- @̹/N@>Ϲ/N@PartOneQuestions@===1111111/ @P%C@tS%C@@PartFourLOS3orMore@|@K??33333331 @h6%C@Z8%C@@PartFive@|@A55)))))))' @v+%C@-%C@NotValidAnswers@@H<<0000000. @E7D@OI@@MakeAdmTypeScores@@J>>22222220 @$C@'%C@JoinHedPisUnitQrys1@`@ K??33333331 @$C@>$C@IndUnit(@ @ @44(((((((& @/I@ٷI@HEDPISWard@ 777+++++++) @I@MxI@HEDPISPI3@666*******( @{{I@~I@GrpWardq@444(((((((& @nUI@/YI@Find duplicates for YesAnswersGroup@PPPDDDDDDDB @6[M/N@/N@Q8Reasonr@/555)))))))' @֡/N@[M/N@Q7Reasonr@/555)))))))' @J/N@/N@Q3-5Reason@777+++++++) @v*/N@/N@Q2Reason@(555)))))))' @ ~/N@v*/N@Q1Reason0@*555)))))))' @'/N@n/N@Q14-15Reasonq@.999-------+ @E/N@9/N@Q13Reason@.666*******( @1/N@E/N@Q11Reasons@.666*******( @/N@1/N@Q10Reason@.666*******( @y/N@ Or0N@PatientNew@-777+++++++) @"۹/N@)C߹/N@PatientY,444(((((((& @%C@%C@@PartTwoSubLOS@*|@+F::......., @.%C@8d%C@@PartTwoSameDay@*|@)G;;///////- @@׹/N@ ٹ/N@PartTwoQuestions@*===1111111/ @%C@c%C@@PartTwoAcute@(|@)E99-------+ @ D ӹ/N@չ/N@PartThreeQuestions@(???33333331 @l%C@%C@@PartThreeQ6Sub@|@G;;///////- @/Q%C@l%C@@PartThreeQ6Acute@|@I==1111111/ @ Z%C@ݺ%C@@PartThreeLOS@|@E99-------+ @tй/N@ѹ/N@PartThreeAQuestions+@@@@44444442 @ މ%C@?%C@@PartThreeA@|@C77+++++++) @#}%C@ %C@@PartOneSubQ@|@D88,,,,,,,* @ Ih%C@'k%C@@PartOneLOS@|@C77+++++++) @6===1111111/ @ěI@M埌I@YesAnswersAll1234@?>>>22222220 @ܿI@4I@YesAnswersh@@777+++++++) @PI@hI@YesAnswerAdmType^@?===1111111/ @Wh /N@ /N@Wards@>222&&&&&&&$ @?2 /N@h /N@ValidReason'@>888,,,,,,,* @rI@ -uI@0UpdateUnitIDinAudit@>@@@44444442 @~jI@~*mI@0updatePatientIDg@=<<<0000000. @m|bI@'eI@0UpdateIntroAuditn@====1111111/ @yZI@9^I@@TferPatientNew@<;;;///////- @UwRI@` x J@TDCS3Ward@<@@0B66*******( @tJI@L MI@TDCS3Unit@<666*******( @o:I@3=I@TDCS2WardK@;666*******( @#m2I@5I@TDCS2UnitK@;666*******( @j*I@-I@TDCS2@:222&&&&&&&$ @3l H@&H@tblStore@9555)))))))' @.I@QI@ReportWard2:@9888,,,,,,,* @mI@I@ReportWard1@8888,,,,,,,* @{I@I@ReportUnit1H@5888,,,,,,,* @.c/N@/N@ReportSetUp@2888,,,,,,,* @gBI@$I@ReportGrpWard@3:::......., @?I@"I@ReportGrp1k@4777+++++++) @:݋I@I@ReportAdmType2h@3;;;///////- @,ϋI@aӋI@ReportAdmType1@2;;;///////- @'/N@//N@Reasons@1444(((((((& @6I@YesPI1Content@N:::......., @"yI@.{I@YesAnswerWard@N:::......., @gI@ejI@YesAnswersWardGroup@M@@@44444442 @T_I@؏bI@YesAnswersUnitGroup@M@@@44444442 @WI@LZI@YesAnswersPI3WardForFinalB@LFFF:::::::8 @;OI@RI@YesAnswersPI3Group_CrosstabWardQ@LLLL@@@@@@@> @GI@3JI@YesAnswersPI3Group_CrosstabUnit@LLLL@@@@@@@> @7I@˹;I@YesAnswersPI3Group@K???33333331 @6`.I@2I@yesAnswersPI3ForFinalB@JBBB66666664 @]&I@. )I@YesAnswersPI3_CrosstabAdm@JFFF:::::::8 @m$I@I@YesAnswersPI3(2)Ward<@JAAA55555553 @!I@dI@YesAnswersPI3(2)UnitL@IAAA55555553 @ I@I@YesAnswersPI3a@I:::......., @I@ >I@YesAnswersPI124Step2_CrosstabUnit>@G@@ZNNBBBBBBB@ @*lI@II@YesAnswersPI124Step2_CrosstabAdmP@G@@YMMAAAAAAA? @2I@"I@YesAnswersPI124Step2C@FAAA55555553 @0I@uI@YesAnswersPI124Group_CrosstabUnit@E@@ ZNNBBBBBBB@ @fI@I@YesAnswersPI124Group_CrosstabAdmP@EMMMAAAAAAA? @ѝI@NI@YesAnswersPI124Group@D@+MAA55555553 @nAI@#I@YesAnswersGrpAdminType @CCCC77777775 @>I@fꯌI@YesAnswersGroupA<<<0000000. @VCN==    d   AnswerID PatientID QuestionIDAnswerValidValid2q=>=?=@ =AAnswerID PatientID PrimaryKey QuestionID(SLS S6N0{C3D29AEA-708C-11D6-AFEF-40A75CC12950}d)= "*\Rffff*83d62f4ff @` ` 11 ``$@  $P $ $@@(XtME; "   $(PX " ` hp x      $   0   P p      8Xx  {qgxp Please select YES or NoA@h(l @ZZ ValidReasons5'DeleteValidReason5' " B@  B@$ Please select YES or NoA@h   B@&  * , B@( ."0"2!4"6Q15 Table/Query ."8":(< Q14-15Reason ."8":(>hH ."0"2!4"6Q16 Table/Query ."8":(< Q16Reason ."8":(>h ."0"@ ."8)@ ."0"2"6 ."8)B ."0"2"D ."8)Dh 'F'HhXlPH  B@& B@$  B@& B@$pAttribute VB_Name = "Form_AnswersPartFiv@e subf\"D Basf0{C3D29AEA-708C-11D6-AFEF-40A75CC@12950} |CreatablCTrue ]Pre declaId"Expose!Fals @TemplateDer%CustomizD$ Option CompA DUw =licit P/3 Sub Detail_C k() If Fr6a0 Then  MsgBox@ ("Pleselect YES or No"End If > .' 6+_AfterUpdA9Dim stA As Sng Querfy  V alidR%onds5mst D9)t@<           ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJ $*06 H `    @ ( 0@  0H x"  6 R0 *,  H `                       , 0 @ P h "  "   * H ` "x     8 xp Please select YES or N<Patient3' ValidReasons'NPartThreeQ6Acute'PartThreeQ6Sub'f PartFourLOS2'hPartFourLOS3orMore'jPartFive'lDeletePartTwoQ'n PartTwoAcute'p PartTwoSub'rBDeleteValidreason'tDeletePartThreeQ'v PartThreeA'xPartThreeLOSQ6'z Q3-5Reason'| " B@  B@$0If Answer = No, then valid reason form is opened=with Valid reasons row source altered to reflect the question Please select YES or NoA@h 'F'Hhh  BQ6 N * , B@( .""!4"BQ3A .""!4"BQ3S .""!4"BQ5A .""!4"BQ5S .""!4"BQ3LOS .""!4"BQ5LOS Table/Query ."":(< | ."":(>h  .""!4"BQ4 Table/Query ."":(<Q4Reason ."":(>h .""@ .")@ ."""B .")B ."""D .")DhX:If answer = Yes, then delete previous entered Valid reason!if there was one already entered.  BQ6 t B@&h*If answer = No to Question 6 then go to Q7  BQ6 P .""!4%Z(\ .""(^ .""(`h0If answer = Yes to Question 6, then jump to Q10.LFirst delete AnswersPartTwo and AnswersPartThree to be ready for new queries  BQ6 n B@&!Delete AnswersPartTwo v B@&!Delete AnswersPartThree ~B@ARe appends blank que< ."" ."" ."" ."" ."" z B@& r B@& ~B@a@ f B@& r B@& ~B@hh&Appends questions to Answers Part Five l B@& x B@& .""(^ .""(` d .""!4%Z(\  * B@( d ."0"R!4%Z(\ ."0"R(^ ."0"R(` d ."0"R!4"T!4%Z(\ ."0"(^ ."0"(` P ."0"!4%Z(\hX B@$l@8l ZpDeleteValidReason'  B@& B@$ B@$X @Attribute VB_Name = "Form_AnswersPartOne subfX" " Basd0{C3D29AF8-708C-11D6-AFEF-40A75CC1 2950} |Cr@eatablCTrue ]PredeclaId"ExposeFals @TemplateDeriv%CustomizD$ Option CompA DUw =licit P/3 Sub Detail_C k() If Fr6a0 Then  MsgBox@ ("Pleselect YES or No"End If > .' 6+_AfterUpdA9Dim stQuery As Sng  D5teVali$dRon@f DoCmd.SetWarning s BOpenDQ h,HG4Const conColI1676@3803 DisAhz149|46;:G1_NFC  23U456789100RecSourcei=JctlLi5J3trolblnYesNo!Boo Z\ I E= 4s!Patient2![Two兌]:stB:`UV3@T1@D"hWs":rtThreeQ6Ac@!j2 BF LOS2G3L3orMore45Cm<al, !acAd2qP94].!\ !A" Or>_o }bSo{BȈoe5FoO Q5o suF 4o o a*5qs!'#:.Row]TypTt/@ry>ߙ0F36=6BS,-q'a//Q4"0bDra46R) EC[9]![oID]Q$42s!sX?![  A^`;{S1daFDdd previous ejcifqgre wapfPalgdy5.sQ,`[[Z 0{8C? 1 `@m 6rgo Q7cS /e e+6M4o&.T`cJ(0).Back@=s! S+ߟuT|EnusLockޱI " 6#jump10'FirT%l)4bea$- new1riesS$`$Pry5 's  8OpenQuery stp9 'Delete AnswersPartThree  ctlList.Req0@'Re apds blank @stions to wo an"d'deHing on AdmTyptIf Forms![Patient2]![/] = "Acute" Then5DoCmd."6rErIfYsuba[Text14v1 Or234j567PhXi11S 7O kElsH ԓ?"G2['A  FivӴ4410qcsEs sȊ]fw].Enablerd@XFa/LockTruj4!.Sec(0).Bac@kColor`con@Dis", acNalW#E3ComProv]>.& as!$-3![ _+));Four ;k+$ ӧ y@wFPrzm7oACIS@etWarns G Sub VCNCC    d   AnswerID PatientID QuestionIDAnswerValidValid2{`CDCECF CGAnswerID PatientID PrimaryKey QuestionIDf|sruwtWuf`vrpf|sruwz`mjduf`vrpf|sruwz`mjduf`vrp,burvvw`agjp`mufsruwxpjwgjp`mufsruw{`udgjpddxsmjb`wfgru}fv`pv{fuhurxsxpjwgjpddxsmjb`wfgru}fv`pv{fuhurxs{`udgjpddxsmjb`wfvgru}fv`pv{fuvhurxsgj|tW[`pdtW\hspxoxpjwhspxo{`udhus`dow}sfhusxpjwhus{`udifdsjvifdsjvsjYifdsjvsjYxpjwifdsjvsjY{`udifdsjvxpjwifdsjv{`udirvd`w`jpd`dow}sfjpdxpjwjpd{`ud krjpifdsjvtu}v krjpifdsjvxpjwtu}v krjpifdsjv{`udtu}v m`vwts`uwW mjvwbrosurzo`lf`dow}sfvbrufvo`lfxpjwvbrufvo`lf{`udvbrufvov}v`bbfvvrakfbwvov}v`bfvov}vboda`uvov}vordxmfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxwov}vdavxoo`u}jpgrxvfudfgjpfdͬÌp@\)PFormHeaderDetailmPatientIDmQuestionIDkFrame6iOption9d Label10iOption11d Label12m Indicatorm Part2QuestionNumm Validm Valid2m AnswerIDFormFooterAnswerPart2IndicatorPartTwoQID{qg238D9=Bb cW'e ghi6jM+k#MC@SELECT AnswerspartFive.PatientID, AnswerspartFive.QuestionID, AnswerspartFive.Answer, PartFiveQuestions.Part2Indicator, PartFiveQuestions.Part2QuestionNum, PartFiveQuestions.PartTwoQID, AnswerspartFive.Valid, AnswerspartFive.Valid2, AnswerspartFive.AnswerID FROM AnswerspartFive INNER JOIN PartFiveQuestions ON AnswerspartFive.QuestionID=PartFiveQuestions.PartTwoQuestion ORDER BY PartFiveQuestions.PartTwoQID; AnswersPartTwo subformAriald2e12bRcRf5bg237bchbcgh MS Sans Serifi1ghj1ghk1bcl23:bc g[m4bg[n2cd@ B           ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJ $*06<ͬÌp@\)PFormHeaderDetailmPatientIDmQuestionIDkFrame6iOption9d Label10iOption11d Label12m Indicatorm Part2QuestionNumm Validm Valid2m AnswerIDFormFooterCommunityIDAnswerPart2IndicatorPartTwoQIDB#DESTpp p4r8z<t@xD~HLPTX\v`dhL@[LS S6LLLLLLL>`x` t`Rp@TC$ $ $P $J $ $D@`dk @` xN  $B238D9=Bb c&e ghyij1k MC@SELECT AnswersPartFour.CommunityID, AnswersPartFour.QuestionID, AnswersPartFour.Answer, PartFourQuestions.Part2Indicator, PartFourQuestions.Part2QuestionNum, PartFourQuestions.PartTwoQID, AnswersPartFour.Valid, AnswersPartFour.Valid2, AnswersPartFour.AnswerID FROM AnswersPartFour INNER JOIN PartFourQuestions ON AnswersPartFour.QuestionID=PartFourQuestions.PartTwoQuestion ORDER BY PartFourQuestions.PartTwoQID; AnswersPartTwo subformAriald2e12bRcRf5bg237bchbcgh MS Sans Serifi1ghj1ghk1bcl23:bc g[m4bg[n2cdh[o2ej[p5bcr35cd zbcij MS Sans Serif{5bcJ ` FormHeader`vDetail[Event Procedure]m7]`4a(bce PatientID PatientIDLink to Patient tablem47C`a(bce k QuestionID QuestionIDDisplays Questionsk15`abec(iFrame6Answer[Event Procedure][Event Procedure]i2`a*Option9d5`abYcLabel10Yesi2w`a*Option11d5`abcLabel12Nom457UC`b[e&jk IndicatorPart2Indicator Arial Narrowm 457CbcJi jkPart2QuestionNumPart2QuestionNumArialm47;C`a<bckValidValid; ;"Not Valid "[Red]m47;C`Yab^ckValid2Valid2;"Valid "[Blue] m7`akAnswerIDAnswerID` FormFooterB238D9=Bb c&e ghyij1k MC@SELECT AnswersPartFour.CommunityID, AnswersPartFour.QuestionID, AnswersPartFour.Answer, PartFourQuestions.Part2Indicator, PartFourQuestions.Part2QuestionNum, PartFourQuestions.PartTwoQID, AnswersPartFour.Valid, AnswersPartFour.Valid2, AnswersPartFour.AnswerID FROM AnswersPartFour INNER JOIN PartFourQuestions ON AnswersPartFour.QuestionID=PartFourQuestions.PartTwoQuestion ORDER BY PartFourQuestions.PartTwoQID; AnswersPartTwo subformAriald2e12bRcRf5bg237bchbcgh MS Sans Serifi1ghj1ghk1bcl23:bc g[m4bg[n2cdh[o2ej[p5bcr35cd zbcij MS Sans Serif{5bcJ ` FormHeader`vDetail[Event Procedure]m7]`4a(bce PatientID PatientIDLink to Patient tablem47C`a(bce k QuestionID QuestionIDDisplays Questionsk15`abec(iFrame6Answer[Event Procedure][Event Procedure]i2`a*Option9d5`abYcLabel10Yesi2w`a*Option11d5`abcLabel12Nom457UC`b[e&jk IndicatorPart2Indicator Arial Narrowm 457CbcJi jkPart2QuestionNumPart2QuestionNumArialm47;C`a<bckValidValid; ;"Not Valid "[Red]m47;C`Yab^ckValid2Valid2;"Valid "[Blue] m7`akAnswerIDAnswerID` FormFooterI @ @ @ @ @ @ @CCCCCCDDD D D D D DDDDDDDDDD D D D D DDDDD D!D"D #D $DE%E'E(E)E*E&F+F-F.F/F0F1FFFFF,GGGGG G G G G GGHHHHHHHHHHHIIIIII I!I"I#I$IJ%J'J(J)J*JJJJJJ&KKKK K K Kons\HK @ @ @ @ @ @ @F,GGGGG G G G G GGHHHHHHHHHHHIIIIII I!I"I#I$IJ%J'J(J)J*JJJJJJ&KKKK K K K K KKKKKKLLLLLLLLLLLLLM M"M#M$M%M&M!N'N)N*N+N,NJNJNJN(OJOJOJOJOJOJ OJ OJ OJ OJ OJOJOJOJPJPJPJFormFooter/eR? LzG(U-|CoPj({ @R R Q-@ 'QArchComProvArchivePart40@/# QCompare1ArchComProv8@+ QCommunityIDArchivePart4.CommunityID; wQValid2ArchivePart4.Valid21 wQValidArchivePart4.Valid/ wQAnswerArchivePart4.Answer1 wQQuestionIDArchivePart4.QuestionID9 wQArchivePart4 QArchComProv QCompare1 QAnswersPartFour OQ Q P@ 'PArchivedQ1235Compare1<@-! PValid2ArchivedQ1235.Valid22 wPValidArchivedQ1235.Valid0 wPAnswerArchivedQ1235.Answer2 wPQuestionIDArchivedQ1235.QuestionID: wPPatientID"@! wPAnswerIDArchivedQ1235.AnswerID6 wPCompare1 PArchivedQ1235 P GPAnswerspartFive OP P O5@  'OIntroAPatient.IntroA, wOAdmTypePatient.AdmType. wOSepDatePatient.SepDate. wOAdmDatePatient.AdmDate. wOWardIDPatient.WardID, wOUnitIDPatient.UnitID, wOPatientURPatient.PatientUR2 wOPatientIDPatient.PatientID2 wOPatient O GOAuditedPatient OO O NArchComProvCompare18@ + NComProviderArchComProv.ComProvider: wNPatientID"@ ! wIO @ @ @ @ @ @ @KKKKKKLLLLLLLLLLLLLM M"M#M$M%M&M!N'N)N*N+N,NJNJNJN(OJOJOJOJOJOJ OJ OJ OJ OJ OJOJOJOJPJPJPJPJPJPJPJPJPJPJPJPJPJPJQJQJ!QJ"QJ#QJ$QJ%QJ&QJ'QJ(QJ)QJ*QJ+QJ,QJ RJ-RMRMRMRMRMRMRMRMRMRM RM RJ.SM SM SMSMSMSMSMSMSMSMSMSMSM TMTM? YUGFS FdD(C Cb^B62A@hh݈2N@݈2N@ DelAuditedPatient00000000000g6D@ Ǯ6D@DataTypeScore@/@AF::......., @fG$C@$C@CtPtID@|@?33'''''''% @ei#C@ #C@Compare1@@A55)))))))' @dt滊I@I@AvHEDPISWard@999-------+ @cƷI@qI@AvHEDPISUnit*@999-------+ @boI@lI@AvHEDPIS%@555)))))))' @`#C@"#C@AuditedWard_Crosstab4@|@MAA55555553 @_M#C@sI@AuditedUnit_Crosstab4@@@MAA55555553 @]4#C@}X6D@AuditedPatient_Crosstab@@7PDD88888886 @v抴/N@m/N@AuditedPatientg;;;///////- @[#C@{#C@ArchPatforExport@@~I==1111111/ @Z#C@#C@@ArchiveValReason@}|@yI==1111111/ @p3/N@= /N@ArchivePart4@}999-------+ @e%/N@/N@ArchivedReasons@|<<<0000000. @_/N@a/N@ArchivedQ1235@z:::......., @YL/N@m/N@ArchivedPatient{<<<0000000. @Y테#C@7#C@@ArchiveAuditedb@z@yG;;///////- @R /N@= /N@ArchComProv@w888,,,,,,,* @W}#C@$#C@@AppValReason@w@vE99-------+ @Ux#C@C{#C@@AppPartTwo@u@tC77+++++++) @Tu#C@hx#C@@AppPartThreeA @s@tF::......., @ROo#C@=s#C@@AppPartOne@q@rC77+++++++) @Qnm#C@Oo#C@@AppPartFour3@q@pD88,,,,,,,* @-/i(K,m,O0 nF\( t7 @ @ @UAnswerArchivedQ1235.Answer2 wUQuestionIDArchivedQ1235.QuestionID: wUPatientID"@P! wUAnswerIDArchivedQ1235.AnswerID6 wUCompare1 UArchivedQ1235 U GUAnswersPartTwo OU U Tm@P 'TArchivedQ1235Compare1:@N-! TValid2ArchivedQ1235.Valid22 wTValidArchivedQ1235.Valid0 wTAnswerArchivedQ1235.Answer2 wTQuestionIDArchivedQ1235.QuestionID: wTPatientID"@N! wTAnswerIDArchivedQ1235.AnswerID6 wTCompare1 TArchivedQ1235 TAnswersPartThreeA OT T Sw@N 'SArchivedQ1235Compare1<@N-! SValid2ArchivedQ1235.Valid22 wSValidArchivedQ1235.Valid0 wSAnswerArchivedQ1235.Answer2 wSQuestionIDArchivedQ1235.QuestionID: wSPatientID"@N! wSCompare1 SArchivedQ1235 S GSAnswersPartThree OS S R@N 'RArchivedQ1235Compare1<@-! RValid2ArchivedQ1235.Valid22 wRValidArchivedQ1235.Valid0 wRAnswerArchivedQ1235.Answer2 wRQuestionIDArchivedQ1235.QuestionID: wRPatientID"@! wRCompare1 RArchivedQ1235 R GRAnswersPartOne OLVAL. Y7]SI? @ @ @ @ @ @ @ @ @ @KArchivedQ1235.PatientID=Compare1.ArchivedPatient.PatientIDCompare1.ArchivedPatient.PatientID(((ArchivedQ1235.QuestionID) Like "Is there evidence of assessment or referral for additional assessment?" Or (ArchivedQ1235.QuestionID) Like "Is there evidence of this assessment having occurred?" Or (ArchivedQ1235.QuestionID) Like "Was this documented by Day 2 following admission?" Or (ArchivedQ1235.QuestionID) Like "Was this documented by Day 8 following admission?" Or (ArchivedQ1235.QuestionID) Like "Was this documented by day prior to discharge?" Or (ArchivedQ1235.QuestionID) Like "Was this documented by Day 1 following admission?" Or (ArchivedQ1235.QuestionID) Like "Was this documented by Day 7 following admission?"))ArchivedQ1235.PatientID = Compare1.ArchivedPatient.PatientIDCompare1.ArchivedPatient.PatientID(((ArchivedQ1235.QuestionID) Like "Is the predicted discharge date documented?" Or (ArchivedQ1235.QuestionID) Like "Was the predicted discharge date documented by Day 2 following admission?" Or (ArchivedQ1235.QuestionID) Like "Was the predicted discharge date documented by Day 8 following admission?" Or (ArchivedQ1235.QuestionID) Like "Was the predicted discharge date documented by day prior to discharge?" Or (ArchivedQ1235.QuestionID) Like "Is the predicted discharge destination documented?" Or (ArchivedQ1235.QuestionID) Like "Was the predicted discharge destination documented by Day 8 following admission?" Or (ArchivedQ1235.QuestionID) Like "Was the predicted discharge destination documented by Day 2 following admission?" Or (ArchivedQ1235.QuestionID) Like "Was the predicted discharge destination documented by day prior to discharge?" Or (ArchivedQ1235.QuestionID) Like "Is there documented evidence of automatic referral for assessment of post discharge needs?"))KW @ @ @ @ @ @ @PJPJPJPJPJPJPJPJPJPJQJQJ!QJ"QJ#QJ$QJ%QJ&QJ'QJ(QJ)QJ*QJ+QJ,QJ RJ-RMRMRMRMRMRMRMRMRMRM RM RJ.SM SM SMSMSMSMSMSMSMSMSMSMSM TMTMTMTMTMTMTMTM TM!TM"TM#TM$TMUM%UM'UM(UM)UM*UM+UM,UM-UM.UQUQUQUQUM&VQVQVQVQVQ VQ VQ VQ VQ VQWQWQWQWQWQWQWQWQWQWQWQWQXQXQXQXQXQXQLVAL!q5` yV,q; f1|D9@ @ @ @ @PJPJPJP(((ValidReason.PatientID)=[Forms]![Patient2]![PatientID]) AND ((ValidReason.QuestionNumber)=[Forms]![Patient2]![AnswersPartOne subform].[Form]![QuestionNumber]))(((Reasons.PatientID)=[Forms]![Patient]![PatientID]))(((ValidReason.PatientID)=Forms!Patient![PatientID]))(((AnswersPartTwo.PatientID)=Forms!Patient![PatientID]))(((AnswersPartThree.PatientID)=[Forms]![Patient]![PatientID]))(((AnswersPartThreeA.PatientID)=Forms!Patient![PatientID]))(((AnswersPartOne.PatientID)=[Forms]![Patient]![PatientID]))(((ComProv.PatientID)=[Forms]![Patient]![PatientID]))(((ComProv.PatientID)=[Forms]![Patient]![PatientID]))ComProv.CommunityID = AnswersPartFour.CommunityID(((AnswerspartFive.PatientID)=[Forms]![Patient]![PatientID]))ArchivedPatient.PatientID=AuditedPatient.PatientID(((ComProv.PatientID)=[Forms]![Patient3]![PatientID]))(((Patient.PatientID)=[Forms]![Patient3]![PatientID]))Count([AuditedPatient].[PatientID])[Patient].[AdmDate]=[ArchivedPatient].[AdmDate][Patient].[PatientUR]=[ArchivedPatient].[PatientUR](((JoinHedPisWardQrys.GrpWard.WardID)<>0))[JoinHedPisWardQrys].GrpWard.WardID[JoinHedPisWardQrys].GrpWard.WardIDAvg([JoinHedPisWardQrys].[Score])Avg([JoinHedPisUnitQrys].[Score])((([AuditedPatient].[IntroA])=2))((([AuditedPatient].[IntroA])=2))ArchivedValidreason.PatientID=Compare1.ArchivedPatient.PatientIDArchivedValidreason.QuestionNumberCompare1.ArchivedPatient.PatientIDArchivedReasons.PatientID=Compare1.ArchivedPatient.PatientIDCompare1.ArchivedPatient.PatientID(((ArchivedQ1235.QuestionID) Like "*risk screen*"))ArchivedQ1235.PatientID = Compare1.ArchivedPatient.PatientIDCompare1.ArchivedPatient.PatientID(((ArchivedQ1235.QuestionID) Like "Was the need for a referral to a community service provider identified?")).\=*YkE*~Q~kM: mZG%Wk YSepDateAuditedPatient.SepDate5 wYAdmDateAuditedPatient.AdmDate5 wYWardIDAuditedPatient.WardID3 wYUnitIDAuditedPatient.UnitID3 wYPatientURAuditedPatient.PatientUR9 wYPatientIDAuditedPatient.PatientID9 wYHosData YAuditedPatient Y GYArchivedPatient OY Y XComProviderComProv.ComProvider6 wXPatientIDComProv.PatientID2 wXCommunityIDComProv.CommunityID6 wXComProv X GXArchComProv OX X WArchivedValidreasonCompare1@@P3' WOtherArchivedValidreason.Other6 wWValidReasonArchivedValidreason.ValidReasonB wWQuestionNumber"@P& wWPatientID"@P! wWAnswerIDArchivedValidreason.AnswerID< wWValidIDArchivedValidreason.ValidID: wWCompare1 WArchivedValidreason WValidReason OW W VArchivedReasonsCompare1<@P/# VOtherArchivedReasons.Other2 wVReasonArchivedReasons.Reason4 wVPatientID"@P! wVReasonIDArchivedReasons.ReasonID8 wVCompare1 VArchivedReasons VReasons OV V U3@P 'UArchivedQ1235Compare1<@P-! UValid2ArchivedQ1235.Valid22 wUValidArchivedQ1235.Valid0 wVCNSS    2 CommunityID PatientID ComProviderSTSUSV pY.rE&{B9880B53-B4FB-11D6-9123-444553540000} CommunityID PatientID PrimaryKey ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJKLMNOPQLRLSLTLULVL $*06<BntID=Compare1.ArchivedPatient.PatientIDCompare1.ArchivedPatient.PatientID((([Patient].[PatientID])=[Forms]![Patient3]![PatientID]))ArchivedPatient.PatientID=Compare1.ArchivedPatient.PatientIDCompare1.ArchivedPatient.PatientIDSELECT* FROM [PartFiveQuestions]SELECT* FROM [PartOneQuestions] UNION SELECT* FROM [PartTwoQuestions] UNION SELECT* FROM [PartThreeQuestions] UNION SELECT* FROM [PartFourQuestions] (((AllQuestions.Indicator) Is Not Null And (AllQuestions.Indicator)<>"PI 1/PI 2 Link") AND ((AuditedPatient.IntroA)=2))Wards.WardID = Audition<FlagMSysQueriesFlag00,!!ion< ExpressionMSysQueriesExpression<<2''ion< Name2MSysQueriesName222-""ion< Name1MSysQueriesName122-""ion<AttributeMSysQueriesAttribute::1&&S{qgi`YkE*~Q nF\( t7 @ @ @UAnswerArchivedQ1235.Answer2 wUQuestionIDArchivedQ1235.QuestionID: wUPatientID"@P! wUAnswerIDArchivedQ1235.AnswerID6 wUCompare1 UArchivedQ1235 U GUAnswersPartTwo OU U Tm@P 'TArchivedQ1235Compare1:@N-! TValid2ArchivedQ1235.Valid22 wTValidArchivedQ1235.Valid0 wTAnswerArchivedQ1235.Answer2 wTQuestionIDArchivedQ1235.QuestionID: wTPatientID"@N! wTAnswerIDArchivedQ1235.AnswerID6 wTCompare1 TArchivedQ1235 TAnswersPartThreeA WValidReasonArchivedValidreason.ValidReasonB wWQuestionNumber"@P& wWPatientID"@P! wWAnswerIDArchivedValidreason.AnswerID< wWValidIDArchivedValidreason.ValidID: wWCompare1 WArchivedValidreason@ R           ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJKLMNOPQLRLSLTLULVLWL $*06<B u v wxyz{|}~  RPJPJPJPJPJPJPJPJPJPJQJQJ!QJ"QJ#QJ$QJ%QJ&QJ'QJ(QJ)QJ*QJ+QJ,QJ RJ-RMRMRMRMRMRMRMRMRMRM RM RJ.SM SM SMSMSMSMSMSMSMSMSMSMSM TMTMTMTMTMTMTMTM TM!TM"TM#TM$TMUM%UM'UM(UM)UM*UM+UM,UM-UM.UQUQUQUQUM&VQVQVQVQVQ VQ VQ VQ VQ VQWQswerAnswerYes = 1 No = 2[Event Procedure]Ìp@\)Pi2`acOption16Ìp@\)Pd5`abcLabel17NoÌp@\)Pi2`acOption14Ìp@\)Pd5`abYcLabel15YesÌp@\)P` FormFooterÌp@\)PRͬÌp@\)PFormHeaderDetailmPatientIDmQuestionIDmPart2QuestionNummPart2IndicatorkAnsweriOption16d Label17i Option14d  Label15 FormFooter Valid Valid2O| @ @ @ @ @ @ @TMTMTMTMTM TM!TM"TM#TM$TMUM%UM'UM(UM)UM*UM+UM,UM-UM.UQUQUQUQUM&VQVQVQVQVQ VQ VQ VQ VQ VQWQWQWQWQWQWQWQWQWQWQWQWQXQXQXQXQXQXQ XQ!XQYQ"YQ$YQ%YQ&YQ'YQ(YQ)YQ*YQ+YQ,YQ-YXYXY XYQ#ZXZXZXZXZXZX ZX ZX ZX ZX ZX[X[X[X[X[X[X[X[X[X[X[X[X\X\X\X\X\X\X \X!\X"\X]X#]X%]X&]X$0J7$Y_L9&|D|ZG-YF3  N ^ ^ ]  AudPat.IntroA% g] AudPat.AdmType& g]Total Of PatientIDCount(AudPat.PatientID)A o]CountOfPatientIDCount(AudPat.PatientID)? o]AudPat.IntroA In (2), g]AudPat.AdmType& g]AudPat ] G] G] ] \Other Reasons.Other* w\ReasonReasons.Reason, w\PatientIDReasons.PatientID2 w\ReasonIDReasons.ReasonID0 w\Reasons \ G\ArchivedReasons O\ \ [ArchivedPatient.AdmType/ g[ArchivedPatient.SepDate/ g[ArchivedPatient.AdmDate/ g[ArchivedPatient.PatientUR1 g[HosData.Campus& g[HosData.HospNum' g[HosData [ArchivedPatient [ G[ G[ [ ZOtherValidReason.Other. wZValidReasonValidReason.ValidReason: wZQuestionNumberValidReason.QuestionNumber@ wZPatientIDValidReason.PatientID6 wZAnswerIDValidReason.AnswerID4 wZValidIDValidReason.ValidID2 wZValidReason Z GZArchivedValidreason OZ Z Y DateOfOldAuditHosData.DateOfAudit9 wYIntroAAuditedPatient.IntroA3 wYAdmTypeAuditedPatient.AdmType5 wVCN  ZZ   2     2      PatientID PatientURAdmDateSepDateAdmTypeUnitIDWardIDIntroADateOfOldAuditZ[Z\ Z]Z^je_R.rE.rF.rG.rH PatientID PrimaryKeyUnitIDWardID2345678 9:;<=>?@AB C D E FGHIJKLMNOPQLRLSLTLULVLWLXL $*06<BRL$ME  "(8 H "P FlagMSysQueriesFlag00,!! ExpressionMSysQueriesExpression<<2'' Name2MSysQueriesName222-"" Name1MSysQueriesName122-""AttributeMSysQueriesAttribute::1&&{qgi/YkE*~Q~kM: mZG%Wk YSepDateAuditedPatient.SepDate5 wYAdmDateAuditedPatient.AdmDate5 wYWardIDAuditedPatient.WardID3 wYUnitIDAuditedPatient.UnitID3 wYPatientURAuditedPatient.PatientUR9 wYPatientIDAuditedPatient.PatientID9 wYHosData YAuditedPatient Y GYArchivedPatient OY Y XComProviderComProv.ComProvider6 wXPatientIDComProv.PatientID2 wXCommunityIDComProv.CommunityID6 wXComProv X GXArchComProv OX X WArchivedValidreasonCompare1@@P3' WOtherArchivedValidreason.Other6 wWValidReasonArchivedValidreason.ValidReasonB wWQuestionNumber"@P& wWPatientID"@P! wWAnswerIDArchivedValidreason.AnswerID@ Y           ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJKLMNOPQLRLSLTLULVLWLXLYL  $*06<BRL\"0`k` !4`lx`nt`kd9@TC$@@0 $8 $h $(p@@x @Xh @d @T "@D @Y 0238D9=Bb ce gFh ipjH!k[A1@ ValidReasonPatientAriald2e12bRcRf5bg237bchbcgh MS Sans Serifi1ghj1ghk1bcl23:bc g[m4bg[n2cdh[o2ej[p5bcr35cd zbcij MS Sans Serif{5bcJ ` FormHeaderKÌp@\)P`_ DetailLÌp@\)Pe25]`6abHcWBox68MÌp@\)Pe25]`| abHcWBox69NÌp@\)Ph1`abvc: Command65Yes[Event Procedure]OÌp@\)Pd5U7`abuchdeLabel66Add another community provider?PÌp@\)Ph1` abvc:i Command67No[Event Procedure]QÌp@\)P` FormFooterRÌp@\)PY 0238D9=Bb ce gFh ipjH!k[A1@ ValidReasonPatientAriald2e12bRcRf5bg237bchbcgh MS Sans Serifi1ghj1ghk1bcl23:bc g[m4bg[n2cdh[o2ej[p5bcr35cd zbcij MS Sans Serif{5bcJ ` FormHeaderKÌp@\)P`_ DetailLÌp@\)Pe25]`6abHcWBox68MÌp@\)Pe25]`| abHcWBox69NÌp@\)Ph1`abvc: Command65Yes[Event Procedure]OÌp@\)Pd5U7`abuchdeLabel66Add another community provider?PÌp@\)Ph1` abvc:i Command67No[Event Procedure]QÌp@\)P` FormFooterRÌp@\)PYͬÌp@\)PFormHeaderDetaileBox68eBox69h Command65d Label66h Command67FormFooterValidID AnswerID PatientID QuestionNumber ValidReason OtherVC;N``    d   AnswerID PatientID QuestionIDAnswerValidValid2Pit tnRda`aTenIWdtA`b`c `dY&{B9880B50-B4FB-11D6-9123-444553540000}AnswerID PatientID PrimaryKey QuestionID6LLLLLL L?@AB C D E FGHIJKLMNOPQLRLSLTLULVLWLXLYL  $*06<BRLYL ͬÌp@\)PFormHeaderDetailmCommunityIDd CommunityID_LabelmPatientIDd PatientID_LabelpAnswersPartFour_subformAnswersPartFour subformoComProviderd ComProv_Labelh Command13h Command14h Command15h Command16 FormFooter_s7 (SLS S<N0{C3D29B2F-708C-11D6-AFEF-40A75CC12950}xD`@`((`Hx`Jt`Lpxf``@d__/`x`ft`jp`ll`nh`pd`r``t\`vX`x(T`zP`|L@~< `X8`4`0`,` @h`z@`@l$$`Hx`Jt`Lp`@p##`Hx`Jt`Lph`@t((`xF`tZ`ps (*`l'`@x ince`Hxiabl`Jt`Lpes te.$h`@ $B $_ZP\^l @\ L @< @,  @ @ @ @ @ @ ( @ @ @ @ @ Hp0@ T( @ X p @ @ @ X     h X @H @8 @( ($   (p ZP\l @\ L @< @,  @ @ @ @ @ @ ( _ZP\l @\ hL @< @, X @ @ @ @ @ @ X( @ @ @ @ @  8PxH^0h @X (T @D @4 ($  @ `( @ @  @0ZP\l @\ L @< @,  @ @ @ @ @ @ ( @ @ @ @ @ @hHMEVCNff     2ReasonID PatientIDReasonOtherfg afh tmtSDedyfiY&{B9880B48-B4FB-11D6-9123-444553540000} PatientID PrimaryKeyReasonID" ( 0 8 @  0'H .Px 4 B #( 8 3X  h p x $ "+  >u    "  ( 0 8  u@ 8+`   u 8+   u  <+ `  uh 6+    6  6  6  6 ,J(J8(J`(E+ .   "   (08  0'@ .Pp 4 B#  0 3P `h p$x"+>u xpF`Z@ZXZp HRTF Files (*.rtf)*.rtf$N'HB R HT X ZV$P'L- Since you passed in a variable for lngFlags,< the function places the output flags value in the variable.X J$\AsS{qgr SaveFileName L "^(`buF !dCancelled file selectionA@aP Error No: !d; Description:  !A@hblhZZZZZ(Z@ZXZpZZZZDim stDelP As StringZZZZ0ZHNImports data from .xls into a blank table then transfers to main patient tableTferPatientNew' DelPatientNew'f AppPartOne'j AppPartTwo'l AppPartThree'n AppPartThreeA'p AppPartFour'r AppPartFive'tAppArchPtToAudit'v AppComProv'x AppReasons'z AppValReason'|stDelP = "DelPat"Delete Matching Archived Data' Switchboard'updatePatientID' B@$ ^$%Please select an Excel file to importA@a  D PatientNew ^ B@   B@& f  B@& j B@& l B@& n B@& p B@& r B@& t B@& v B@& x B@& z B@& | B@&DoCmd.OpenQuery stDelP  B@&  B@&RTransfer complete.The counter will indicate the number of records ae           ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJKLMNOPQLRLSLTLULVLWLXLYL  $*06<BRLYL _L ͬ"Ìp@\)PFormHeaderDetailmDataFormFooterh Command19h Command20ComIDe#DEST** 4p8r<t@vDxHzL<SLS S6LLLLLL<N0{C3D29B22-708C-11D6-AFEF-40A75CC12950}_c= $*\Rffff*443d63115f*\R1*#8f*\R1*#8e*\R1*#88*\R1*#87*\R1*#85*\R1*#2e*\R1*#1c*\R0*#10*\R0*#16*\R0*#11*\R1*#1 p,@`k8`xk>` 4k$$@8 $*h $ $Xp@2"E@@x h@h @d @` @P @L ,@< @0, +@( @H @` @@ 0He 238D9=BCb ce gh> ij k B>@ ListComProvCommunity Providers Update ListAriald2e12bRcRf5bg237bchbcgh MS Sans Serifi1ghj1ghk1bcl23:bc g[m4bg[n2cdh[o2ej[p5bcr35cd zbcij MS Sans Serif{5bcJ ` FormHeader0%B Mݨ`Detail絊GFFsNm7UF`be6DataDatakʓVJ4y` FormFooterq BVa.h1U`Zaxbc Command19"Delete Selected Community Provider[Event Procedure]NJ(L\EJY8h1U` abdci Command20Close And Save[Event Procedure]ɝv@W9zVCBNkk      2  2  2ValidIDAnswerID PatientIDQuestionNumber ValidReasonOtherPitmtSDeklDaIIrtfdkmkn koY&{B9880B46-B4FB-11D6-9123-444553540000}AnswerID PatientID PrimaryKeyValidID!```x`P``$8PME]  "  (08 @Xp      0 8 "@H  P `h px  "      {qg@ j           ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJKLMNOPQLRLSLTLULVLWLXLYL  $*06<BRLYL _L eL &DHP LaserJet 2100 Series PCL 6HP LaserJet 2100 Series PCL 6LPT1:d2TahomahbcghTahoma`Detailqpb h1U`ab.c@Command0YES[Event Procedure]H Open Formqpb d5U7`ZaibceLabel2jYou have chosen to utilise this database without importing your old data, or you do not have data to import. Once you select this option you will not be able to import your data at a later time. Are you sure you wish to continue. Click YES to Start the audit without importing your old data. Click NO to return to the Main Menu to import your old data. qpb h1U`ab.c@iCommand6NO[Event Procedure]5qpb jͬbZGZsCDetailh Command0d Label2h Command6ji_VBA_MODULElj&BvZsC(Ìp@\)Px93 (SLS S<N0{C3D29B28-708C-11D6-AFEF-40A75CC12950}=(m_Co$Hh $@ $ $to $@(e, $Xth $X` $@ $ $ME xphٰAttribute VB_Name = "Form_CtPtID subf8" " Bas0{C3D29B28-708C-11D6-AFEF-40A75CC1 2950} |Cr@eatablTrue ]PredeclaId"ExposeFals @TemplateDeriv%CustomizD$ Option CompA DUw =licit jͬ(Ìp@\)PFormHeaderDetailmAuditedCountFormFooterIntroAVC=Nqq    mud   AnswerID CommunityID QuestionIDAnswerValidValid2Sqrpqsqt EB8quR&{B9880B5B-B4FB-11D6-9123-444553540000}AnswerID PatientID PrimaryKey QuestionID0289=Bb c e gh&%iKjB'kh؈pC@_SELECT [CtPtID].[AuditedCount], [CtPtID].[IntroA] FROM CtPtID WHERE ((([CtPtID].[IntroA])=2)); CtPtID subformAriald2e12bRcRf5bg237bchbcgh MS Sans Serifi1ghj1ghk1bcl23:bc g[m4bg[n2cdh[o2ej[p5bcr35cd zbcij MS Sans Serif{5bcJ ` FormHeader`,Detailm457UCab AuditedCount AuditedCount` FormFooter{qg p           ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJKLMNOPQLRLSLTLULVLWLXLYL  $*06<BRLYL _L eL jL ͬ/Ìp@\)PFormHeaderd Label48d Label133Detailh Command137mText138h Command143mText144h Command146m Text147m Text150h Command152 FormFooterh Command142h Command149p#DEST4x8|<@DHzLPpTvX~\`rdthlp\@[LS S6 LLLLL<`y;@ Export FormNilMenuAriald2e12bRcRf5bg237bchbcgh MS Sans Serifi1ghj1ghk1bcl23:bc g[m4bg[n2cdh[o2ej[p5bcr35cd w2bc zbcij MS Sans Serif{5bcJ ` FormHeaderd5]7bcdeLabel48"Effective Discharge Audit Databased157`abcdeLabel133 Export Form` Detailh1U`abRcY Command137Save Audit Report To....[Event Procedure]m7U`abckText138h1U`a9bRcYi Command143Save Valid Reasons To...[Event Procedure]m7U`abckText144h1U`ao bRcYi Command146Save DHS Data To ...[Event Procedure]m7U`a bckText147m7U`abckText150h1U`aTbRcYi Command152Save Exclusions To..[Event Procedure]`B FormFooterh1U`abdc Command142 Close Form[Event Procedure]h1U`abchi Command149Export[Event Procedure]p 0238D=Bb ce gh ij "kM>y;@ Export FormNilMenuAriald2e12bRcRf5bg237bchbcgh MS Sans Serifi1ghj1ghk1bcl23:bc g[m4bg[n2cdh[o2ej[p5bcr35cd w2bc zbcij MS Sans Serif{5bcJ ` FormHeaderd5]7bcdeLabel48"Effective Discharge Audit Databased157`abcdeLabel133 Export Form` Detailh1U`abRcY Command137Save Audit Report To....[Event Procedure]m7U`abckText138h1U`a9bRcYi Command143Save Valid Reasons To...[Event Procedure]m7U`abckText144h1U`ao bRcYi Command146Save DHS Data To ...[Event Procedure]m7U`a bckText147m7U`abckText150h1U`aTbRcYi Command152Save Exclusions To..[Event Procedure]`B FormFooterh1U`abdc Command142 Close Form[Event Procedure]h1U`abchi Command149Export[Event Procedure]VCINww   2       2  PatientID PatientURUnitIDWardIDAdmDateSepDateAdmTypeIntroAwx wyYwzw{ AuditedPatientUnitIDAuditedPatientWardID PatientID PrimaryKey&'()*+,-./012345678 9:;<=>?@AB C D E FGHIJKLMNOPQLRLSLTLULVLWLXLYL ZL[L $*06<BRLYL _L eL jL pL$`0 $` $ $ `8hME FlagMSysQueriesFlag00,!! ExpressionMSysQueriesExpression<<2'' Name2MSysQueriesName222-"" Name1MSysQueriesName122-""AttributeMSysQueriesAttribute::1&&{qgi/v:@|D|ZG-( 08 "@ H PX`hpx  T Ph\ReasonReasons.Reason, w\PatientIDReasons.PatientID2 w\ReasonIDReasons.ReasonID0 w\Reasons \ G\ArchivedReasons O\ \ [ArchivedPa\2N@2N@ArchReasons*********** [2N@2N@ArchPatforExport/////////// Z2N@2N@@ArchiveValReason/////////// p2N@2N@ArchivePart4+++++++++++ j2N@2N@ArchivedVv           ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJKLMNOPQLRLSLTLULVLWLXLYL ZL[L\L $*06<BRLYL _L eL jL pL  vTMTMTMTMTM TM!TM"TM#TM$TMUM%UM'UM(UM)UM*UM+UM,UM-UM.UQUQUQUQUM&VQVQVQVQVQ VQ VQ VQ VQ VQWQWQWQWQWQWQWQWQWQWQWQWQXQXQXQXQXQXQ XQ!XQYQ"YQ$YQ%YQ&YQ'YQ(YQ)YQ*YQ+YQ,YQ-YXYXY XYQ#ZXZXZXZXZXZX ZX ZX ZX ZX ZX[X[X[X[X[X[X[X[X[X[X[X[X\XContactd Contact_Labelm Phoned Phone_Labelh CloseAndSavem Auditsd Label11mDateOfAuditd Label12mCampusd Label13FormFooterv#DESTffP 4t8<@DHLPTxXp\r`|d8SLS S6LLLLLL<<<N0{C3D29B35-708C-11D6-AFEF-40A75CC12950}_c= $*\Rffff*473d63115f*\R1*#8f*\R1*#8e*\R1*#88*\R1*#87*\R1*#85*\R1*#2e*\R1*#1c*\R0*#10*\R0*#16*\R0*#11 ,`kh@c$`J $M $ $`x` $ $ $Ph2"x@t @d @` @ \  h@8L @H @8 X@h( @ B@ @ @ @v 0238D9=BCb ce gh ij ki0@HosDataHospital InformationAriald2e12bRcRf5bg237bchbcgh MS Sans Serifi1ghj1ghk1bcl23:bc g[m4bg[n2cdh[o2ej[p5bcr35cd zbcij MS Sans Serif{5bcJ ` FormHeader`Detail m7W``arbceHospNumHospNum"Hospital Number as assigned by DHSd5]`9arbce HospNum_LabelCampus Number:m7U``ab c e kHospNameHospName Hospital Named5U7`<abceHospName_LabelHealth Service: m7U``a b ce kRegionRegion$Region in which the hospital residesd5U` a bce Region_LabelRegion:m7U``a_b ce kContactContact&Contact person for effective discharged5U` a_bce Contact_LabelContact Person:m7U``ab cekPhonePhonePhone number of contact person!\(99") "9900\ 0000;;_d5U` abce Phone_Label Phone Number:h1U2C` a= bUci CloseAndSave&Close and Save[Event Procedure]m7U`az bkAuditsAudits Number of audits to be completedd5Ua bbceLabel11 Number of records to be audited:m7U`ca bzk DateOfAudit DateOfAuditdd/mm/yy Month and year of current audit.d5U`aZ b ceLabel12Date of current Audit:m7U``ab ckCampusCampus Campus Name as obtained from DHSd5Uab6ceLabel13Campus/Hospital:` FormFooterW @ @ @ @ @ @ @XQYQ"YQ$YQ%YQ&YQ'YQ(YQ)YQ*YQ+YQ,YQ-YXYXY XYQ#ZXZXZXZXZXZX ZX ZX ZX ZX ZX[X[X[X[X[X[X[X[X[X[X[X[X\X\X\X\X\X\X \X!\X"\X]X#]X%]X&]X']X(]X)]X*]X+] X,] X-]X$^X.^~^~^~^X/_~_~_~_~_~_~ _~ _~ _~ _~ _~_~_ ~_ ~_ ~_~`~`~`~`~`~`~`~`~` ~` ~`~a~a~ a~!a~"a~#a~$a~%a~&a~'a~(a~)a~b~*b~+}@@ @ @@@@@`pv{fuvs`uwrpf`pv{fuvs`uwwiuff`pv{fuvs`uwwiuff``pv{fuvs`uww{r`ss`ubiswwr`xdjw`ss`xdjwfds`wjfpw`ssb`osd`w``ssbrosurz`ssf|bs`w`sss`uwgjzf`sss`uwgrxuL`sss`uwrpfL`sss`uwwiuffL`sss`uwwiuff`L`sss`uww{rL`ssuf`vrpvL`ssz`muf`vrpL`ubibrosurzL`ubibrosurzjdfuL`ubijzf`xdjwfdL `ubijzfds`wjfpwL `ubijzfdtWXY[L `ubijzfduf`vrpvL `ubijzfdz`mjduf`vrpL `ubijzfs`uwZL`ubijzfz`muf`vrpL`ubis`wgruf|sruwL`ubiuf`vrpvL`xdjwfds`wjfpwL`xdjwfds`wjfpw,burvvw`aL`xdjwfds`wjfpwjdL`xdjwfdxpjw,burvvw`aL`xdjwfd{`ud,burvvw`aL`xds`wL`zifdsjvL`zifdsjvxpjwL`zifdsjv{`udLbros`ufWLbrosurzLbwswjdLd`w`w}sfvbrufLdfm`xdjwfds`wjfpwLdfm`xds`wdfmbrosurzdfmbrosurz`ubidfmfwfo`wbijph`ubijzfdd`w`dfmfwfs`uwgjzftdfmfwfs`uwgrxutdfmfwfs`uwgrxutbsdfmfwfs`uwrpftdfmfwfs`uwwiuff`tdfmfwfs`uwwiufft dfmfwfs`uww{rt dfmfwfs`wjfpw dfmfwfs`wjfpwjdz`mjduf`vrp dfmfwfuf`vrp dfmfwfvbrufvdfmfwfz`mjduf`vrpdfmfwfz`mjduf`vrpXdfmfwfz`mjduf`vrpYdfmfwfz`mjduf`vrpZdfmfwfz`mjduf`vrp[dfms`uwWdfms`uwXdfms`uwYdfms`uwY`dfms`uwZdfms`uw[dfms`wov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxwov}vdavxoo`u}jpgrxvfudfgjpfd4-r_L9 :wK"Z*n>Qo6bJoinHedPisQrys b b a!@ P 'a[AuditedPatient].[IntroA]1 ga[AuditedPatient].[AdmType]2 ga[AuditedPatient].[SepDate]2 ga[AuditedPatient].[AdmDate]2 ga[AuditedPatient].[WardID]1 ga[AuditedPatient].[UnitID]1 ga[AuditedPatient].[PatientUR]4 ga[AuditedPatient].[PatientID]4 gaAuditedPatient a a ` [AudPat].[IntroA]) g` [AudPat].[WardID]) g`((([AudPat].[WardID])<>0))2 '`[AudPat].[IntroA] In (2)0 g`Total Of PatientIDCount([AudPat].[PatientID])E o`[AudPat].[WardID]) g`CountOfPatientIDCount([AudPat].[PatientID])C o`AudPat ` G` ` _  AudPat.IntroA% g_  Units.Unit" g_  AudPat.UnitID% g_(((AudPat.UnitID)<>0)). '_AudPatUnitsAudPat.UnitID = Units.UnitID? _Total Of PatientIDCount(AudPat.PatientID)A o_CountOfPatientIDCount(AudPat.PatientID)? o_AudPat.IntroA In (2), g_ Units.Unit" g_ AudPat.UnitID% g_Units _AudPat _ G_ G_ _ ^!@ P '^[AuditedPatient].[PatientID]4 g^AuditedPatient | @ @ @ @ @ @ @]X)]X*]X+] X,] X-]X$^X.^~^~^~^X/_~_~_~_~_~_~ _~ _~ _~ _~ _~_~_ ~_ ~_ ~_~`~`~`~`~`~`~`~`~` ~` ~`~a~a~ a~!a~"a~#a~$a~%a~&a~'a~(a~)a~b~*b~,bbb b~+ccccc cd d d d d d d eeeeeeeeeeefffff  f !fg"g$g%g&g'g(g#h)h+h,h-h.h/h0h1hhh*#2H5"\I6xeK)~J~]2s`M:xeKhPatient.WardID& ghPatient.UnitID& ghPatient.PatientUR) ghPatient.PatientID) ghPatient h Gh Gh h gJoinHedPisQrys.Score, ggJoinHedPisQrys.AdmType. ggJoinHedPisQrys g Gg Gg g f (((AuditedPatient.IntroA)=2))5 'f [AuditedPatient].[IntroA]1 gf[AuditedPatient].[IntroA]1 gfAuditedCount#@P$ ofAuditedPatient f f ePatientArchivedPatient/@P." ePatientArchivedPatient3@P." e[ArchivedPatient].[PatientID]5 ge[Patient].[PatientID]- geArchAdmDaterchivedPatient].[AdmDate]> oe[Patient].[AdmDate]+ ge[Patient].[PatientUR]- geArchivedPatient ePatient e e d *@P 'd #@P gd#@ P gdAvgOfScore!@ P" odJoinHedPisWardQrys d d c [JoinHedPisUnitQrys].[UnitID]5 gc[JoinHedPisUnitQrys].[UnitID]5 gcAvgOfScore!@ P" ocJoinHedPisUnitQrys c c b [JoinHedPisQrys].[AdmType]2 gb[JoinHedPisQrys].[AdmType]2 gbAvgOfScoreAvg([JoinHedPisQrys].[Score])? o >vI*{hUB(ubO<){hUB mZG%hFlYF, p p o5@P 'o ComProv.*! goComProv.PatientID) goComProv o Go Go o n5@P 'nComProvAnswersPartFour1@P." nAnswersPartFour.*) gnComProv.PatientID) gnAnswersPartFour nComProv n Gn Gn n m=@P 'mAnswerspartFive.PatientID1 gmAnswerspartFive m Gm Gm m lArchivedPatientAuditedPatient2@P5) lArchivedPatient.*) glAuditedPatient lArchivedPatient l Gl l kComProv.ComProvider+ gkComProv.PatientID) gkComProv.CommunityID+ gkComProv k Gk Gk k j6@P 'jComProv.ComProvider+ gjComProv.PatientID) gjComProv.CommunityID+ gjComProv j Gj Gj j iAuditedPatient.*( giAuditedPatient i Gi Gi i h6@P 'hPatient.IntroA& ghPatient.AdmType' ghPatient.SepDate' ghPatient.AdmDate' g@cP=*ta>UL-yfH_@-{hJ y y x@ P 'xValidReason.QuestionNumber2 gxValidReason.PatientID- gxValidReason x Gx Gx x wScores.* gwScores w Gw Gw w v5@P 'vReasons.PatientID) gvReasons v Gv Gv v u5@P 'uValidReason.PatientID- guValidReason u Gu u t Patient.*! gtPatient t Gt Gt t s8@P 'sAnswersPartTwo.Valid2- gsAnswersPartTwo.Valid, gsAnswersPartTwo.Answer- gsAnswersPartTwo.QuestionID1 gsAnswersPartTwo.AnswerID/ gsAnswersPartTwo.PatientID0 gsAnswersPartTwo s Gs s r>@P 'rAnswersPartThree.PatientID2 grAnswersPartThree r Gr Gr r q;@P 'qAnswersPartThreeA.PatientID3 gqAnswersPartThreeA q Gq q p<@P 'pAnswersPartOne.PatientID0 gpAnswersPartOne p Gp GBZ;(dE2 nO<)xYF3  qP!n[H5qA.  AnswerspartFive.*) gAnswerspartFive  G G  AnswersPartFour.*) gAnswersPartFour  G G  AnswersPartThreeA.*+ gAnswersPartThreeA  G G  AnswersPartThree.** gAnswersPartThree  G G  ~AnswersPartTwo.*( g~AnswersPartTwo ~ G~ G~ ~ }AnswersPartOne.*( g}AnswersPartOne } G} G} } |@ '|ValidReason.QuestionNumber2 g|ValidReason.PatientID- g|ValidReason | G| G| | {@ '{ValidReason.QuestionNumber2 g{ValidReason.PatientID- g{ValidReason { G{ G{ { z@ 'zValidReason.QuestionNumber2 gzValidReason.PatientID- gzValidReason z Gz Gz z y@ 'y[ValidReason].[QuestionNumber]6 gy[ValidReason].[PatientID]1 gyValidReason y G+>d0 |iV9 ]1 aN;(i=*i<X   (` (\ 2(^ReportWard2 Wards  G   [ReportUnit2].[Indicator]1 g [Units].[Unit]& g [Units].[UnitID]( gReportUnit2Units'@ ( @ gTotal Of Total Of PatientID'@3'' o[Units].[Unit]& g[Units].[UnitID]( gSumOfTotal Of PatientID'@/## oUnits ReportUnit2  G   ValidReason.*% gValidReason  G G   Reasons.*! gReasons  G G  PatientAuditedPatient*@-!  Patient.*! gAuditedPatient Patient  G   PatientNew.F6% g PatientNew.F5% g PatientNew.F4% g PatientNew.F3% g PatientNew.F2% g PatientNew.F1% gPatientNew  G G   Patient.*! gPatient  G G  PatientAuditedPatient,@-!  Patient.*! gAuditedPatient Patient  G G 3)RyD d-nMq3G4!P!    IndUnit.UnitID& gIndUnit.GroupIndicator. gIndUnit.Indicator) gDENPI3Unit.Valid( gDENPI3Unit.Answer) gDENPI3Unit.UnitID) gDENPI3Unit.CountOfPatientID3 gIndUnit DENPI3Unit     (((AnswersPartThreeA.Answer)=1))8 ' nswersPartThreeA].[Valid]3 g [AnswersPartThreeA].[Answer]4 g [AuditedPatient].[UnitID]1 gAnswersPartThreeAAuditedPatient<@7+ nswersPartThreeA].[Valid]3 g[AnswersPartThreeA].[Answer]4 g[AuditedPatient].[UnitID]1 gCountOfPatientID&@( oAuditedPatient AnswersPartThreeA     (((AnswersPartThreeA.Answer)=1))8 ' AnswersPartThreeA.Valid/ g AnswersPartThreeA.Answer0 g AuditedPatient.AdmType. gAnswersPartThreeAAuditedPatient4@7+ AnswersPartThreeA.Valid/ gAnswersPartThreeA.Answer0 gAuditedPatient.AdmType. gCountOfPatientID"@( oAuditedPatient AnswersPartThreeA     (((AnswersPartThreeA.Answer)=1))8 ' nswersPartThreeA].[Valid]3 g [AnswersPartThreeA].[Answer]4 g [AuditedPatient].[AdmType]2 g .fEi+~_L9\)xeR?%e9~Qq  PI2Timeliness@% oPI2Content@ " oPI1Timeliness@ % oPI1Content@ " oDHSReportDen124.AdmType/ gHosData.Campus& gHosData.Region& gHosData.HospName( gHosData.HospNum' gYesAnswersPI3Group_CrosstabAdm*** YesAnswersPI3_CrosstabAdm%%% YesAnswersPI124Step2_CrosstabAdm,,, YesAnswersPI124Group_CrosstabAdm,,, TDCS3 DHSReportDen3 DHSReportDen124 HosData  G G  ((([DENPI3Ward].[WardID])<>0))6 'IndWardDENPI3Ward(@ ) [IndWard].[WardID]* g[DENPI3Ward].[Valid], g[DENPI3Ward].[Answer]- g[DENPI3Ward].[WardID]- g[DENPI3Ward].[CountOfPatientID]7 gDENPI3Ward IndWard    A@  ' nswersPartThreeA].[Valid]3 g [AnswersPartThreeA].[Answer]4 g [AuditedPatient].[WardID]1 gAnswersPartThreeAAuditedPatient<@7+ nswersPartThreeA].[Valid]3 g[AnswersPartThreeA].[Answer]4 g[AuditedPatient].[WardID]1 gCountOfPatientID&@( oAuditedPatient AnswersPartThreeA   DENPI3UnitIndUnit DENPI3Unit.UnitID=IndUnit.UnitIDI  )V/h#\5}Z7p=\~E xe  [ReportAdmType2].[Indicator]4 g [ReportAdmType2].[AdmType]2 g@ gTotal Of Total Of PatientID*@3'' o[ReportAdmType2].[AdmType]2 gSumOfTotal Of PatientID*@/## oReportAdmType2  G  DHSReportDen124YesAnswersPI124Step2_CrosstabAdmB@G; DHSReportDen124YesAnswersPI3Group_CrosstabAdm@@E9 DHSReportDen124YesAnswersPI3_CrosstabAdm;@@4 DHSReportDen124YesAnswersPI124Group_CrosstabAdmB@G; DHSReportDen124TDCS3'@,  DHSReportDen124DHSReportDen3/@4( !PI4T:@ o PI4C7@  oPI3T3@  oPI3C0@  oPI2T:@  oPI2C7@  oPI1T:@ oPI1C7@ oAvgOfIndScore|@% oPI4GpNumNz([Performance Indicator 4],0)? oPI3GpNum#@  oPI2GpNumNz([Performance Indicator 2],0)? oPI1GpNumNz([Performance Indicator 1],0)? oDHSReportDen3.[PI 3 Content]4 gDenPI124DHSReportDen124.[PI 1 Content]> oTotalDischargeCompliance Score[PercentTDCS]/100*100K** oPI4Score@  oPI3Score@  oPI2Score@  oPI1Score@  o PI4Timeliness@% o PI4Content@" o PI3Timeliness@% o PI3Content@" oVCoN    2 CommunityID PatientID ComProvider{  CommunityID PatientID PrimaryKey ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJKLMNOPQLRLSLTLULVLWLXLYL ZL[L\L]L^L_L`LaLbLcLdL $*06<BRLYL _L eL jL pLvL@ArchivedQ1235,,,,,,,,,,, Y2N@2N@ArchivedPatient........... Ymۀ2N@mۀ2N@@ArchiveAudited----------- Xmۀ2N@mۀ2N@@ArchComProvider........... Rf2N@mۀ2N@ArchComProv*********** Wf2N@f2N@@AppValReason+++++++++++ Vf2N@f2N@@AppReaFlagMSysQuerieS{qgi/v:@DJf @ @ @ @ @ @ @ @ @ @XQYQ"YQ$Yge%i2N@%i2N@Compare1''''''''''' d%i2N@%i2N@AvHEDPISWard+++++++++++ cu22N@%i2N@AvHEDPISUnit+++++++++++ bu22N@u22N@AvHEDPIS''''''''''' au22N@u22N@AudPat%%%%%%%%%%% `u22N@u22N@AuditedWard_Crosstab33333333333 _2N@u22N@AuditedUnit_Crosstab33333333333 ^2N@2N@AuditedPatientID/////////// ]2N@2N@AuditedPatient_Crosstab66666666666 v2N@2N@AuditedPatient----------- \2N@2N@@ArchReasons*********** [2N@2N@ArchPatforExport/////////// Z2N@2N@@ArchiveValReason/////////// p2N@2N@ArchivePart4+++++++++++ j2N@2N@ArchivedValidreason22222222222 e2N@2N@ArchivedReasons........... _2N@2N@ArchivedQ1235,           ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJKLMNOPQLRLSLTLULVLWLXLYL ZL[L\L]L^L_L`LaLbLcLdLeL $*06<BRLYL _L eL jL pLvL  ]X)]X*]X+] X,] X-]X$^X.^~^~^~^X/_~_~_~_~_~_~ _~ _~ _~ _~ _~_~_ ~_ ~_ ~_~`~`~`~`~`~`~`~`~` ~` ~`~a~a~ a~!a~"a~#a~$a~%a~&a~'a~(a~)a~b~*b~,bbb b~+ccccc cd d d d d d d eͬcGZsCDetailh Command0d Label2h Command3#DEST r4v8<t@pDP@SLS S6LL  L*LLL$C@ DelPart3@|@A55)))))))' @ }ݣ8$C@:$C@ DelPart1@|@A55)))))))' @|"5$C@ݣ8$C@ DeleteValidReason5@|@K??33333331 @{3$C@"5$C@ DeleteValidReason4@|@K??33333331 @ y-.$C@=0$C@ DeleteValidReason2@|@K??33333331 @xX+$C@-.$C@ DeleteValidReason@|@J>>22222220 @ vR)$C@X+$C@ DeleteReason`@|@E99-------+ @u|=I@ÊI@ DeletePatientIDValidReasonh@GGG;;;;;;;9 @t#'$C@)$C@ DeletePatient@/|@F::......., @ rX!$C@q$$C@ DeletePartThreeQt@|@I==1111111/ @q$C@X!$C@ DeletePartThreeAQt@|@J>>22222220 @ o $C@so$C@ DeletePartFourQCP`@|@J>>22222220 @nG$C@ $C@ DeletePartFourQ(@@H<<0000000. @lO$C@($C@ Delete Matching Archived Data@@VJJ>>>>>>>< @k$C@O$C@ DelComProvArch@|@G;;///////- @i4 $C@#d $C@ DelAudPat@|@B66*******( @LVALUW+  @ @ @ @ @ @ @ o9o:[ReportWard2].[Indicator] In ("PI 1 Content","PI 1 Timeliness","PI 2 Content","PI 2 Timeliness","PI 3 Content","PI 3 Timeliness","PI 4 Content","PI 4 Timeliness")Sum([ReportWard2].[CountOfPatientID])[ReportUnit2].[UnitID]=[Units].[UnitID][ReportUnit2].[Indicator] In ("PI 1 Content","PI 1 Timeliness","PI 2 Content","PI 2 Timeliness","PI 3 Content","PI 3 Timeliness","PI 4 Content","PI 4 Timeliness")Sum([ReportUnit2].[CountOfPatientID])[Wards].[WardID]=[ReportWard2].[WardID][ReportWard2].[Indicator] In ("PI 1 Content","PI 1 Timeliness","PI 2 Content","PI 2 Timeliness","PI 3 Content","PI 3 Timeliness","PI 4 Content","PI 4 Timeliness")Sum([ReportWard2].[Total Of PatientID])Sum([ReportWard2].[Total Of PatientID])[ReportUnit2].[UnitID]=[Units].[UnitID][ReportUnit2].[Indicator] In ("PI 1 Content","PI 1 Timeliness","PI 2 Content","PI 2 Timeliness","PI 3 Content","PI 3 Timeliness","PI 4 Content","PI 4 Timeliness")Sum([ReportUnit2].[Total Of PatientID])Sum([ReportUnit2].[Total Of PatientID])Patient.PatientID=AuditedPatient.PatientIDPatient.PatientID = AuditedPatient.PatientID(((ValidReason.PatientID)=[Forms]![Patient3]![PatientID]) AND ((ValidReason.QuestionNumber)=[Forms]![Patient3]![AnswersPartFive subform].[Form]![Part2QuestionNum]))(((ValidReason.PatientID)=[Forms]![Patient3]![PatientID]) AND ((ValidReason.QuestionNumber)=[Forms]![Patient3]![ComProv].[Form]![AnswersPartFour subform].[Form]![Part2QuestionNum]))(((ValidReason.PatientID)=[Forms]![Patient3]![PatientID]) AND ((ValidReason.QuestionNumber)=[Forms]![Patient3]![AnswersPartThree subform].[Form]![Part2QuestionNum]))((([ValidReason].[PatientID])=[Forms]![Patient2]![PatientID]) And (([ValidReason].[QuestionNumber])=[Forms]![Patient2]![AnswersPartTwo subform].[Form]![Part2QuestionNum]))y}@@@@   @@  bwswjdLd`w`w}sfvbrufLdfm`xdjwfds`wjfpwLdfm`xds`wdfmbrosurzdfmbrosurz`ubidfmfwfo`wbijph`ubijzfdd`w`dfmfwfs`uwgjzftdfmfwfs`uwgrxutdfmfwfs`uwgrxutbsdfmfwfs`uwrpftdfmfwfs`uwwiuff`tdfmfwfs`uwwiufft dfmfwfs`uww{rt dfmfwfs`wjfpw dfmfwfs`wjfpwjdz`mjduf`vrp dfmfwfuf`vrp dfmfwfvbrufvdfmfwfz`mjduf`vrpdfmfwfz`mjduf`vrpXdfmfwfz`mjduf`vrpYdfmfwfz`mjduf`vrpZdfmfwfz`mjduf`vrp[dfms`uwWdfms`uwXdfms`uwYdfms`uwY`dfms`uwZdfms`uw[dfms`wdfms`wjfpwdfms`wjfpwpf{dfmswbrpgjuodfmuf`vrpvdfmz`muf`vdfpWXZxpjwdfpWXZ{`uddfpYxpjwdfpY{`uddfpsjYdfpsjYWdfpsjYxpjwdfpsjYxpjw`mmdfpsjY{`uddfpsjY{`udv`mm divgjp`mufsruw divufsruwdfpWXZ divufsruwdfpY divufsruwhspxo divufsruwpxoWXYZdivz`mjduf`vrpvf|sruwrwifuf|sruwtWuf`vrpf|sruwz`mjduf`vrpf|sruwz`mjduf`vrp,burvvw`agjp`mufsruwxpjwgjp`mufsruw{`udgjpddxsmjb`wfgru}fv`pv{fuhurxsxpjwgjpddxsmjb`wfgru}fv`pv{fuhurxs{`udgjpddxsmjb`wfvgru}fv`pv{fuvhurxsgj|tW[`pdtW\hspxoxpjwhspxo{`udhus`dow}sfhusxpjwhus{`udifdsjvifdsjvsjYifdsjvsjYxpjwov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxwov}vdavxoo`u}jpgrxvfudfgjpfd  Gp+FVEt*D:C|$Bej$ AUI@?I@HEDPISs@333'''''''% @{{I@~I@GrpWardq@444(((((((& @uI@svI@GrpUnitq@444(((((((& @eI@4iI@GpNumWard@666*******( @]I@~_I@GpNumUnit\@666*******( @=*H@*H@0FixQ15andQ16~@b@@E99-------+ @nUI@/YI@Find duplicates for YesAnswersGroup@PPPDDDDDDDB @KMI@9-QI@Find duplicate for YesAnswerGroup Ward@SSSGGGGGGGE @I@hjNI@FinalReportWard @H<<0000000. @AI@zI@FinalReportUnit@H<<0000000. @$C@i$C@ExportValidReason_Crosstab@|@SGG;;;;;;;9 @$C@5P$C@ExportQ1Reason(@@G;;///////- @$C@$C@ExportOther@|@D88,,,,,,,* @s#I@t&I@DHSReportNum1234@===1111111/ @I@>I@DHSReportGpNum-@;;;///////- @-9I@I@DHSReportDen3@:::......., @QmI@I@DHSReportDen124@<<<0000000. @8hI@I@DenPI3WardsAll@;;;///////- @SOI@I@DENPI3Ward@777+++++++) @wI@ϣI@DenPI3UnitAll@:::......., @I@;JI@DenPI31@444(((((((& @GI@2I@DenPI3@333'''''''% @"EيI@*ފI@Den3Ward<@555)))))))' @FyҊI@֊I@Den3Unit<@555)))))))' @ƊI@vʊI@Den124UnitB@777+++++++) @LVALwU!])R-[#sF @ @ @ @ @ @IIf(Nz([YesAnswersPI124Step2_CrosstabAdm].[PI 4 Content],0)=0 Or Nz([DHSReportDen124].[PI 4 Content],0)=0,0,Nz([YesAnswersPI124Step2_CrosstabAdm].[PI 4 Content],0)/Nz([DHSReportDen124].[PI 4 Content],0))IIf(Nz([DHSReportDen3].[PI 3 Content],0)=0,0,Nz([YesAnswersPI3_CrosstabAdm].[PI 3 Timeliness],0)/Nz([DHSReportDen3].[PI 3 Content],0))IIf(Nz([DHSReportDen3].[PI 3 Content],0)=0,0,Nz([YesAnswersPI3_CrosstabAdm].[PI 3 Content],0)/Nz([DHSReportDen3].[PI 3 Content],0))IIf(Nz([YesAnswersPI124Step2_CrosstabAdm].[PI 2 Timeliness],0)=0 Or Nz([DHSReportDen124].[PI 2 Timeliness],0)=0,0,Nz([YesAnswersPI124Step2_CrosstabAdm].[PI 2 Timeliness],0)/Nz([DHSReportDen124].[PI 2 Timeliness],0))IIf(Nz([YesAnswersPI124Step2_CrosstabAdm].[PI 2 Content],0)=0 Or Nz([DHSReportDen124].[PI 2 Content],0)=0,0,Nz([YesAnswersPI124Step2_CrosstabAdm].[PI 2 Content],0)/Nz([DHSReportDen124].[PI 2 Content],0))IIf(Nz([YesAnswersPI124Step2_CrosstabAdm].[PI 1 Timeliness],0)=0 Or Nz([DHSReportDen124].[PI 1 Timeliness],0)=0,0,Nz([YesAnswersPI124Step2_CrosstabAdm].[PI 1 Timeliness],0)/Nz([DHSReportDen124].[PI 1 Timeliness],0))IIf(Nz([YesAnswersPI124Step2_CrosstabAdm].[PI 1 Content],0)=0 Or Nz([DHSReportDen124].[PI 1 Content],0)=0,0,Nz([YesAnswersPI124Step2_CrosstabAdm].[PI 1 Content],0)/Nz([DHSReportDen124].[PI 1 Content],0))[IndWard].[WardID]=[DENPI3Ward].[WardID](((AuditedPatient.WardID)<>0) AND ((AnswersPartThreeA.Answer)=1))[AnswersPartThreeA].[PatientID]=[AuditedPatient].[PatientID]Count([AnswersPartThreeA].[PatientID])[AnswersPartThreeA].[PatientID]=[AuditedPatient].[PatientID]Count([AnswersPartThreeA].[PatientID])AnswersPartThreeA.PatientID=AuditedPatient.PatientIDCount(AnswersPartThreeA.PatientID)[AnswersPartThreeA].[PatientID]=[AuditedPatient].[PatientID]Count([AnswersPartThreeA].[PatientID])[Wards].[WardID]=[ReportWard2].[WardID]LVAL)HgPn> kD\)xeR?%e9~Qq @ PI2Timeliness@% oPI2Content@ " oPI1Timeliness@ % oPI1CDHSReportDen124.AdmType = YesAnswersPI124Group_CrosstabAdm.AdmTypeDHSReportDen124.AdmType = TDCS3.AdmTypeDHSReportDen124.AdmType = DHSReportDen3.AdmTypeNz([YesAnswersPI124Step2_CrosstabAdm].[PI 4 Timeliness],0)Nz([YesAnswersPI124Step2_CrosstabAdm].[PI 4 Content],0)Nz([yesAnswersPI3_CrosstabAdm].[PI 3 Timeliness],0)Nz([yesAnswersPI3_CrosstabAdm].[PI 3 Content],0)Nz([YesAnswersPI124Step2_CrosstabAdm].[PI 2 Timeliness],0)Nz([YesAnswersPI124Step2_CrosstabAdm].[PI 2 Content],0)Nz([YesAnswersPI124Step2_CrosstabAdm].[PI 1 Timeliness],0)Nz([YesAnswersPI124Step2_CrosstabAdm].[PI 1 Content],0)IIf([DHSReportDen3].[PI 3 Content]=0,(1+[PI1Score]+[PI2Score]+[PI4Score])/4,([PI1score]+[PI2score]+[PI3score]+[PI4score])/4)Nz([CountOfGroupIndicator Field],0)IIf(Nz([YesAnswersPI124Group_CrosstabAdm].[Performance Indicator 4],0)=0 Or Nz([DHSReportDen124].[PI 1 Content],0)=0,0,Nz([YesAnswersPI124Group_CrosstabAdm].[Performance Indicator 4],0)/Nz([DHSReportDen124].[PI 1 Content],0))IIf(Nz([DHSReportDen3].[PI 3 Content],0)=0,0,Nz([YesAnswersPI3Group_CrosstabAdm].[CountOfGroupIndicator Field],0)/Nz([DHSReportDen3].[PI 3 Content],0))IIf(Nz([YesAnswersPI124Group_CrosstabAdm].[Performance Indicator 2],0)=0 Or Nz([DHSReportDen124].[PI 1 Content],0)=0,0,Nz([YesAnswersPI124Group_CrosstabAdm].[Performance Indicator 2],0)/Nz([DHSReportDen124].[PI 1 Content],0))IIf(Nz([YesAnswersPI124Group_CrosstabAdm].[Performance Indicator 1],0)=0 Or Nz([DHSReportDen124].[PI 1 Content],0)=0,0,Nz([YesAnswersPI124Group_CrosstabAdm].[Performance Indicator 1],0)/Nz([DHSReportDen124].[PI 1 Content],0))IIf(Nz([YesAnswersPI124Step2_CrosstabAdm].[PI 4 Timeliness],0)=0 Or Nz([DHSReportDen124].[PI 4 Timeliness],0)=0,0,Nz([YesAnswersPI124Step2_CrosstabAdm].[PI 4 Timeliness],0)/Nz([DHSReportDen124].[PI 4 Timeliness],0))LVALCJ"}T+Yl@ @ @ @ @ @ @ @ IIf(Nz([YesAnswersPI124Step2_CrosstabUnit].[PI 1 Timeliness],0)=0 Or Nz([Den124Unit].[PI 1 Timeliness],0)=0,0,Nz([YesAnswersPI124Step2_CrosstabUnit].[PI 1 Timeliness],0)/Nz([Den124Unit].[PI 1 Timeliness],0))IIf(Nz([YesAnswersPI124Step2_CrosstabUnit].[PI 1 Content],0)=0 Or Nz([Den124Unit].[PI 1 Content],0)=0,0,Nz([YesAnswersPI124Step2_CrosstabUnit].[PI 1 Content],0)/Nz([Den124Unit].[PI 1 Content],0))Count(ExportValidReason.PatientID)Count(ExportValidReason.PatientID)(((ValidReason.ValidReason) Is Not Null))ValidReason.QuestionNumber = AllQuestions.QuestionNumber(((ValidReason.ValidReason)="10") AND ((ValidReason.Other) Is Not Null))(((ValidReason.ValidReason) Is Not Null))ValidReason.PatientID = AuditedPatient.PatientIDValidReason.QuestionNumber = AllQuestions.QuestionNumber[ReportAdmType2].[Indicator] In ("PI 1 Content","PI 1 Timeliness","PI 2 Content","PI 2 Timeliness","PI 3 Content","PI 3 Timeliness","PI 4 Content","PI 4 Timeliness")Sum([ReportAdmType2].[CountOfIndicator])Sum([ReportAdmType2].[CountOfIndicator])[ReportGrp1].GrpAdmType.GroupIndicator[ReportGrp1].GrpAdmType.GroupIndicatorSum([ReportGrp1].[CountOfGroupIndicator])Sum([ReportGrp1].[CountOfGroupIndicator])[ReportAdmType2].[Indicator] In ("PI 1 Content","PI 1 Timeliness","PI 2 Content","PI 2 Timeliness","PI 3 Content","PI 3 Timeliness","PI 4 Content","PI 4 Timeliness")Sum([ReportAdmType2].[CountOfPatientID])[ReportAdmType2].[Indicator] In ("PI 1 Content","PI 1 Timeliness","PI 2 Content","PI 2 Timeliness","PI 3 Content","PI 3 Timeliness","PI 4 Content","PI 4 Timeliness")Sum([ReportAdmType2].[Total Of PatientID])Sum([ReportAdmType2].[Total Of PatientID])DHSReportDen124.AdmType = YesAnswersPI124Step2_CrosstabAdm.AdmTypeDHSReportDen124.AdmType = YesAnswersPI3Group_CrosstabAdm.AdmTypeDHSReportDen124.AdmType = YesAnswersPI3_CrosstabAdm.AdmTypeLVAL =n{7I? @ @ @ @ @ @IIf(Nz([YesAnswersPI124Group_CrosstabUnit].[Performance Indicator 4],0)=0 Or Nz([Den124Unit].[PI 1 Content],0)=0,0,Nz([YesAnswersPI124Group_CrosstabUnit].[Performance Indicator 4],0)/Nz([Den124Unit].[PI 1 Content],0))IIf(Nz([Den3Unit].[PI 1 Content],0)=0,0,Nz([YesAnswersPI3Group_CrosstabUnit].[CountOfGroupIndicator Field],0)/Nz([Den3Unit].[PI 1 Content],0))IIf(Nz([YesAnswersPI124Group_CrosstabUnit].[Performance Indicator 2],0)=0 Or Nz([Den124Unit].[PI 1 Content],0)=0,0,Nz([YesAnswersPI124Group_CrosstabUnit].[Performance Indicator 2],0)/Nz([Den124Unit].[PI 1 Content],0))IIf(Nz([YesAnswersPI124Group_CrosstabUnit].[Performance Indicator 1],0)=0 Or Nz([Den124Unit].[PI 1 Content],0)=0,0,Nz([YesAnswersPI124Group_CrosstabUnit].[Performance Indicator 1],0)/Nz([Den124Unit].[PI 1 Content],0))IIf(Nz([YesAnswersPI124Step2_CrosstabUnit].[PI 4 Timeliness],0)=0 Or Nz([Den124Unit].[PI 4 Timeliness],0)=0,0,Nz([YesAnswersPI124Step2_CrosstabUnit].[PI 4 Timeliness],0)/Nz([Den124Unit].[PI 4 Timeliness],0))IIf(Nz([YesAnswersPI124Step2_CrosstabUnit].[PI 4 Content],0)=0 Or Nz([Den124Unit].[PI 4 Content],0)=0,0,Nz([YesAnswersPI124Step2_CrosstabUnit].[PI 4 Content],0)/Nz([Den124Unit].[PI 4 Content],0))IIf(Nz([Den3Unit].[PI 3 Timeliness],0)=0,0,Nz([yesAnswersPI3ForFinal].[PI 3 Timeliness],0)/Nz([Den3Unit].[PI 3 Timeliness],0))IIf(Nz([Den3Unit].[PI 3 Content],0)=0,0,Nz([yesAnswersPI3ForFinal].[PI 3 Content],0)/Nz([Den3Unit].[PI 3 Content],0))IIf(Nz([YesAnswersPI124Step2_CrosstabUnit].[PI 2 Timeliness],0)=0 Or Nz([Den124Unit].[PI 2 Timeliness],0)=0,0,Nz([YesAnswersPI124Step2_CrosstabUnit].[PI 2 Timeliness],0)/Nz([Den124Unit].[PI 2 Timeliness],0))IIf(Nz([YesAnswersPI124Step2_CrosstabUnit].[PI 2 Content],0)=0 Or Nz([Den124Unit].[PI 2 Content],0)=0,0,Nz([YesAnswersPI124Step2_CrosstabUnit].[PI 2 Content],0)/Nz([Den124Unit].[PI 2 Content],0))LVALf.T%zDNC @ @ @ @ @ @ @IIf(Nz([Den3Ward].[PI 3 Timeliness],0)=0,0,Nz([yesAnswersPI3WardForFinal].[PI 3 Timeliness],0)/Nz([Den3Ward].[PI 3 Timeliness],0))IIf(Nz([Den3Ward].[PI 3 Content],0)=0,0,Nz([yesAnswersPI3WardForFinal].[PI 3 Content],0)/Nz([Den3Ward].[PI 3 Content],0))IIf(Nz([YesAnswersPI124Step2_CrosstabWard].[PI 2 Timeliness],0)=0 Or Nz([Den124Ward].[PI 2 Timeliness],0)=0,0,Nz([YesAnswersPI124Step2_CrosstabWard].[PI 2 Timeliness],0)/Nz([Den124Ward].[PI 2 Timeliness],0))IIf(Nz([YesAnswersPI124Step2_CrosstabWard].[PI 2 Content],0)=0 Or Nz([Den124Ward].[PI 2 Content],0)=0,0,Nz([YesAnswersPI124Step2_CrosstabWard].[PI 2 Content],0)/Nz([Den124Ward].[PI 2 Content],0))IIf(Nz([YesAnswersPI124Step2_CrosstabWard].[PI 1 Timeliness],0)=0 Or Nz([Den124Ward].[PI 1 Timeliness],0)=0,0,Nz([YesAnswersPI124Step2_CrosstabWard].[PI 1 Timeliness],0)/Nz([Den124Ward].[PI 1 Timeliness],0))IIf(Nz([YesAnswersPI124Step2_CrosstabWard].[PI 1 Content],0)=0 Or Nz([Den124Ward].[PI 1 Content],0)=0,0,Nz([YesAnswersPI124Step2_CrosstabWard].[PI 1 Content],0)/Nz([Den124Ward].[PI 1 Content],0))Den124Unit.Unit = YesAnswersPI124Group_CrosstabUnit.UnitDen124Unit.Unit = yesAnswersPI3ForFinal.UnitDen124Unit.Unit = YesAnswersPI3Group_CrosstabUnit.UnitDen124Unit.Unit = YesAnswersPI124Step2_CrosstabUnit.UnitNz([YesAnswersPI124Step2_CrosstabUnit].[PI 4 Timeliness],0)Nz([YesAnswersPI124Step2_CrosstabUnit].[PI 4 Content],0)Nz([yesAnswersPI3ForFinal].[PI 3 Timeliness],0)Nz([yesAnswersPI3ForFinal].[PI 3 Content],0)Nz([YesAnswersPI124Step2_CrosstabUnit].[PI 2 Timeliness],0)Nz([YesAnswersPI124Step2_CrosstabUnit].[PI 2 Content],0)Nz([YesAnswersPI124Step2_CrosstabUnit].[PI 1 Timeliness],0)Nz([YesAnswersPI124Step2_CrosstabUnit].[PI 1 Content],0)IIf([Den3Unit].[PI 3 Content]=0,(1+[PI1Score]+[PI2Score]+[PI4Score])/4,([PI1score]+[PI2score]+[PI3score]+[PI4score])/4)NZ([CountOfGroupIndicator Field],0)LVAL=n.U2Hr:Y0 @ @ @ @ @Nz([YesAnswersPI124Step2_CrosstabWard].[PI 4 Timeliness],0)Nz([YesAnswersPI124Step2_CrosstabWard].[PI 4 Content],0)Nz([yesAnswersPI3WardForFinal].[PI 3 Timeliness],0)Nz([yesAnswersPI3WardForFinal].[PI 3 Content],0)Nz([YesAnswersPI124Step2_CrosstabWard].[PI 2 Timeliness],0)Nz([YesAnswersPI124Step2_CrosstabWard].[PI 2 Content],0)Nz([YesAnswersPI124Step2_CrosstabWard].[PI 1 Timeliness],0)Nz([YesAnswersPI124Step2_CrosstabWard].[PI 1 Content],0)IIf([Den3Ward].[PI 3 Content]=0,(1+[PI1Score]+[PI2Score]+[PI4Score])/4,([PI1score]+[PI2score]+[PI3score]+[PI4score])/4)NZ([CountOfGroupIndicator Field],0)IIf(Nz([YesAnswersPI124Group_CrosstabWard].[Performance Indicator 4],0)=0 Or Nz([Den124Ward].[PI 1 Content],0)=0,0,Nz([YesAnswersPI124Group_CrosstabWard].[Performance Indicator 4],0)/Nz([Den124Ward].[PI 1 Content],0))IIf(Nz([Den3Ward].[PI 1 Content],0)=0,0,Nz([YesAnswersPI3Group_CrosstabWard].[CountOfGroupIndicator Field],0)/Nz([Den3Ward].[PI 1 Content],0))IIf(Nz([YesAnswersPI124Group_CrosstabWard].[Performance Indicator 2],0)=0 Or Nz([Den124Ward].[PI 1 Content],0)=0,0,Nz([YesAnswersPI124Group_CrosstabWard].[Performance Indicator 2],0)/Nz([Den124Ward].[PI 1 Content],0))IIf(Nz([YesAnswersPI124Group_CrosstabWard].[Performance Indicator 1],0)=0 Or Nz([Den124Ward].[PI 1 Content],0)=0,0,Nz([YesAnswersPI124Group_CrosstabWard].[Performance Indicator 1],0)/Nz([Den124Ward].[PI 1 Content],0))IIf(Nz([YesAnswersPI124Step2_CrosstabWard].[PI 4 Timeliness],0)=0 Or Nz([Den124Ward].[PI 4 Timeliness],0)=0,0,Nz([YesAnswersPI124Step2_CrosstabWard].[PI 4 Timeliness],0)/Nz([Den124Ward].[PI 4 Timeliness],0))IIf(Nz([YesAnswersPI124Step2_CrosstabWard].[PI 4 Content],0)=0 Or Nz([Den124Ward].[PI 4 Content],0)=0,0,Nz([YesAnswersPI124Step2_CrosstabWard].[PI 4 Content],0)/Nz([Den124Ward].[PI 4 Content],0))LVALb*SI? Y0Z3 l,jCkH% @ @ @ @ (((Count([AllQandA].[PatientID]))>1) AND ((YesAnswersGroup.AllQandA.GroupIndicator) Like "Performance Indicator 1 - Risk Screening") AND ((Count([AllQandA].[GroupIndicator]))>1)) OR (((Count([AllQandA].[PatientID]))>5) AND ((YesAnswersGroup.AllQandA.GroupIndicator) Like "Performance Indicator 2 - Commencement of the Preparation of a Discharge Plan") AND ((Count([AllQandA].[GroupIndicator]))>5)) OR (((Count([AllQandA].[PatientID]))>1) AND ((YesAnswersGroup.AllQandA.GroupIndicator) Like "Performance Indicator 4 - Provision of a Timely and Informative Discharge") AND ((Count([AllQandA].[GroupIndicator]))>1)) OR (((Count([AllQandA].[PatientID]))=2 Or (Count([AllQandA].[PatientID]))=4 Or (Count([AllQandA].[PatientID]))=6 Or (Count([AllQandA].[PatientID]))=8 Or (Count([AllQandA].[PatientID]))=10 Or (Count([AllQandA].[PatientID]))=12 Or (Count([AllQandA].[PatientID]))=14 Or (Count([AllQandA].[PatientID]))=16 Or (Count([AllQandA].[PatientID]))=18 Or (Count([AllQandA].[PatientID]))=20) AND ((YesAnswersGroup.AllQandA.GroupIndicator) Like "Performance Indicator 3 - Timely Notification of Community Providers") AND ((Count([AllQandA].[GroupIndicator]))=2 Or (Count([AllQandA].[GroupIndicator]))=4 Or (Count([AllQandA].[GroupIndicator]))=6 Or (Count([AllQandA].[GroupIndicator]))=8 Or (Count([AllQandA].[GroupIndicator]))=10 Or (Count([AllQandA].[GroupIndicator]))=12 Or (Count([AllQandA].[GroupIndicator]))=14 Or (Count([AllQandA].[GroupIndicator]))=16 Or (Count([AllQandA].[GroupIndicator]))=18 Or (Count([AllQandA].[GroupIndicator]))=20))[YesAnswersGroup].AllQandA.GroupIndicator[YesAnswersGroup].AllQandA.PatientIDFirst([AllQandA].[GroupIndicator])Den124Ward.Ward = YesAnswersPI124Group_CrosstabWard.WardDen124Ward.Ward = YesAnswersPI124Step2_CrosstabWard.WardDen124Ward.Ward = YesAnswersPI3Group_CrosstabWard.WardDen124Ward.Ward = YesAnswersPI3WardForFinal.WardLVALjF@ @ @ @ @ @ @ @ @ @ @ @ @ValidReason.AnswerID = AnswerspartFive.AnswerID[YesAnswersGroup].AllQandA.GroupIndicator[YesAnswersGroup].AllQandA.PatientIDFirst([AllQandA].[GroupIndicator])(((Count([AllQandA].[PatientID]))>1) AND ((YesAnswersGroup.AllQandA.GroupIndicator) Like "Performance Indicator 1 - Risk Screening") AND ((Count([AllQandA].[GroupIndicator]))>1)) OR (((Count([AllQandA].[PatientID]))>5) AND ((YesAnswersGroup.AllQandA.GroupIndicator) Like "Performance Indicator 2 - Commencement of the Preparation of a Discharge Plan") AND ((Count([AllQandA].[GroupIndicator]))>5)) OR (((Count([AllQandA].[PatientID]))>1) AND ((YesAnswersGroup.AllQandA.GroupIndicator) Like "Performance Indicator 4 - Provision of a Timely and Informative Discharge") AND ((Count([AllQandA].[GroupIndicator]))>1)) OR (((Count([AllQandA].[PatientID]))=2 Or (Count([AllQandA].[PatientID]))=4 Or (Count([AllQandA].[PatientID]))=6 Or (Count([AllQandA].[PatientID]))=8 Or (Count([AllQandA].[PatientID]))=10 Or (Count([AllQandA].[PatientID]))=12 Or (Count([AllQandA].[PatientID]))=14 Or (Count([AllQandA].[PatientID]))=16 Or (Count([AllQandA].[PatientID]))=18 Or (Count([AllQandA].[PatientID]))=20) AND ((YesAnswersGroup.AllQandA.GroupIndicator) Like "Performance Indicator 3 - Timely Notification of Community Providers") AND ((Count([AllQandA].[GroupIndicator]))=2 Or (Count([AllQandA].[GroupIndicator]))=4 Or (Count([AllQandA].[GroupIndicator]))=6 Or (Count([AllQandA].[GroupIndicator]))=8 Or (Count([AllQandA].[GroupIndicator]))=10 Or (Count([AllQandA].[GroupIndicator]))=12 Or (Count([AllQandA].[GroupIndicator]))=14 Or (Count([AllQandA].[GroupIndicator]))=16 Or (Count([AllQandA].[GroupIndicator]))=18 Or (Count([AllQandA].[GroupIndicator]))=20))YesAnswersGroup.AllQandA.GroupIndicatorYesAnswersGroup.AllQandA.PatientIDFirst([AllQandA].[GroupIndicator])LVALE  @ @ @ @ @ @ @ @  Sum([ReportGpUnit].[CountOfAllQandA_GroupIndicator Field])Sum([ReportGpUnit].[CountOfAllQandA_GroupIndicator Field])(((ValidReason.ValidReason) Is Null) AND ((ValidReason.QuestionNumber)="Q16")) OR (((ValidReason.QuestionNumber)="Q15"))(((Count([AllQandA].[PatientID]))>1) AND ((YesAnswersGroup.AllQandA.GroupIndicator) Like "Performance Indicator 1 - Risk Screening") AND ((Count([AllQandA].[GroupIndicator]))>1)) OR (((Count([AllQandA].[PatientID]))>5) AND ((YesAnswersGroup.AllQandA.GroupIndicator) Like "Performance Indicator 2 - Commencement of the Preparation of a Discharge Plan") AND ((Count([AllQandA].[GroupIndicator]))>5)) OR (((Count([AllQandA].[PatientID]))>1) AND ((YesAnswersGroup.AllQandA.GroupIndicator) Like "Performance Indicator 4 - Provision of a Timely and Informative Discharge") AND ((Count([AllQandA].[GroupIndicator]))>1)) OR (((Count([AllQandA].[PatientID]))=2 Or (Count([AllQandA].[PatientID]))=4 Or (Count([AllQandA].[PatientID]))=6 Or (Count([AllQandA].[PatientID]))=8 Or (Count([AllQandA].[PatientID]))=10 Or (Count([AllQandA].[PatientID]))=12 Or (Count([AllQandA].[PatientID]))=14 Or (Count([AllQandA].[PatientID]))=16 Or (Count([AllQandA].[PatientID]))=18 Or (Count([AllQandA].[PatientID]))=20) AND ((YesAnswersGroup.AllQandA.GroupIndicator) Like "Performance Indicator 3 - Timely Notification of Community Providers") AND ((Count([AllQandA].[GroupIndicator]))=2 Or (Count([AllQandA].[GroupIndicator]))=4 Or (Count([AllQandA].[GroupIndicator]))=6 Or (Count([AllQandA].[GroupIndicator]))=8 Or (Count([AllQandA].[GroupIndicator]))=10 Or (Count([AllQandA].[GroupIndicator]))=12 Or (Count([AllQandA].[GroupIndicator]))=14 Or (Count([AllQandA].[GroupIndicator]))=16 Or (Count([AllQandA].[GroupIndicator]))=18 Or (Count([AllQandA].[GroupIndicator]))=20))LVAL zT%lH~R2l0c4c@ @ @ @ @ @ @ @ @    ReportGrpWard.CountOfGroupIndicatorReportGrpWard.YesAnswersWardGroup.WardID((([ReportGpUnit].[GrpUnit].[GroupIndicator]) Like "*3*"))ReportGpUnit.[CountOfAllQandA_GroupIndicator Field]ReportGpUnit.[Find duplicate for YesAnswerGroup Unit].UnitIDReportGpUnit.GrpUnit.UnitID = DENPI3Unit.UnitIDReportGpUnit.GrpUnit.UnitID = AuditedUnit_Crosstab.UnitIDIIf(Nz([CountOfPatientID],0)=0,1,Nz([CountOfAllQandA_GroupIndicator Field]/[CountOfPatientID],0))ReportGpUnit.[CountOfAllQandA_GroupIndicator Field]ReportGpUnit.[Find duplicate for YesAnswerGroup Unit].UnitID(((ReportGrp1.GrpAdmType.GroupIndicator) Like "*3*"))ReportGrp1.GrpAdmType.GroupIndicatorReportGrp1.GrpAdmType.AdmType = DenPI3.AdmTypeReportGrp1.GrpAdmType.AdmType = AuditedPatient_Crosstab.AdmTypeIIf(Nz([CountOfGroupIndicator],0)=0,1,Nz([CountOfGroupIndicator],0)/Nz([CountOfPatientID],0))ReportGrp1.GrpAdmType.GroupIndicator(((ReportGrp1.GrpAdmType.GroupIndicator) Like "*1*" Or (ReportGrp1.GrpAdmType.GroupIndicator) Like "*2*" Or (ReportGrp1.GrpAdmType.GroupIndicator) Like "*4*"))AuditedPatient_Crosstab.[Total Of PatientID]ReportGrp1.GrpAdmType.GroupIndicatorReportGrp1.GrpAdmType.AdmType = AuditedPatient_Crosstab.AdmTypeRound(Nz([CountOfGroupIndicator]/[Total Of PatientID],0),3)AuditedPatient_Crosstab.[Total Of PatientID]ReportGrp1.GrpAdmType.GroupIndicator((([AllQuestions].[GroupIndicator]) Is Not Null))((([AllQuestions].[GroupIndicator]) Is Not Null))((([AllQuestions].[GroupIndicator]) Is Not Null))[ReportGrpWard].GrpWard.GroupIndicator[Wards].[WardID]=[ReportGrpWard].GrpWard.WardID[ReportGrpWard].GrpWard.GroupIndicatorSum([ReportGrpWard].[CountOfGroupIndicator])Sum([ReportGrpWard].[CountOfGroupIndicator])[ReportGpUnit].GrpUnit.UnitID=[Units].[UnitID]!Gh!F3/F}yE&D,r51CYA[WA `Ih%C@'k%C@@PartOneLOS@|@C77+++++++) @f%C@&h%C@@PartOneAcuteQ@|@F::......., @ɹ/N@˹/N@PartFourQuestions@>>>22222220 @N%C@P%C@@PartFourLOS2@|@E99-------+ @yŹ/N@4rȹ/N@PartFiveQuestions@>>>22222220 @y3%C@5%C@@Part4ToArchive@|@G;;///////- @NjI@$ʋI@Num1234Ward,@888,,,,,,,* @0I@I@Num1234Unit,@888,,,,,,,* @#I@>&I@NotValidPI3,@888,,,,,,,* @hp;2N@l2N@MSysModules2----------+ fxS!C@xS!C@MSysModules,,,,,,,,,,* 'C@'C@MSysCmdbars,,,,,,,,,,*  G@ ȅG@MSysAccessObjects22222222220 5k7D@vo7D@@MakeWardScoresh@o@@G;;///////- @]7D@Aj7D@@MakeUnitScoresh@o@@G;;///////- @,ù/N@Ĺ/N@ListComProv/@888,,,,,,,* @c]%C@%C@LastQPart1@|@C77+++++++) @$C@'%C@JoinHedPisUnitQrys1@`@K??33333331 @P$C@I@JoinHedPisQrys @@CG;;///////- @$C@>$C@IndUnit(@@@44(((((((& @ը$C@YT$C@IndAdmType@@C77+++++++) @/I@ٷI@HEDPISWard@777+++++++) @I@'bI@HEDPISUnit@777+++++++) @FI@(I@HEDPISPI3Ward4@:::......., @UϗI@I@HEDPISPI3Unit@:::......., @{@  @ dfpsjYWdfpsjYxpjwdfpsjYxpjw`mmdfpsjY{`uddfpsjY{`udv`mm divgjp`mufsruw divufsruwdfpWXZ divufsruwdfpY divufsruwhspxo divufsruwpxoWXYZdivz`mjduf`vrpvf|sruwrwifuf|sruwtWuf`vrpf|sruwz`mjduf`vrpf|sruwz`mjduf`vrp,burvvw`agjp`mufsruwxpjwgjp`mufsruw{`udgjpddxsmjb`wfgru}fv`pv{fuhurxsxpjwgjpddxsmjb`wfgru}fv`pv{fuhurxs{`udgjpddxsmjb`wfvgru}fv`pv{fuvhurxsgj|tW[`pdtW\hspxoxpjwhspxo{`udhus`dow}sfhusxpjwhus{`udifdsjvifdsjvsjYifdsjvsjYxpjwifdsjvsjY{`udifdsjvxpjwifdsjv{`udirvd`w`jpd`dow}sfjpdxpjwjpd{`udkrjpifdsjvtu}v krjpifdsjvxpjwtu}v krjpifdsjv{`udtu}v m`vwts`uwW mjvwbrosurz o`lf`dow}sfvbrufvo`lfxpjwvbrufvo`lf{`udvbrufvov}v`bbfvvrakfbwvov}v`bfvov}vboda`uvov}vordxmfvov}vordxmfvXov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvprwz`mjd`pv{fuvprwz`mjdsjYpxoWXYZxpjwpxoWXYZ{`uds`uwZwr`ubijzfs`uwgjzfs`uwgjzftxfvwjrpvs`uwgrxumrvXs`uwgrxumrvYruorufs`uwgrxutxfvwjrpvs`uwrpf`bxwfts`uwrpfmrv s`uwrpftxfvwjrpvs`uwrpfvxats`uwwiuff`s`uwwiuff`bxwfs`uwwiuff`txfvwjrpvs`uwwiuffmrvs`uwwiuffmrvt\s`uwwiufft\`bxwf`bbfvvm`}rxwov}vdavxoo`u}jpgrxvfudfgjpfdSPI3((((((((((( LVALP |@ a%HvuD@ @ @ @ @ @ @ @ #%&g((([AllQuestions].[GroupIndicator]) Is Not Null))((([AllQuestions].[GroupIndicator]) Is Not Null))((([AllQuestions].[GroupIndicator]) Is Not Null))(((ReportGrpWard.GrpWard.GroupIndicator) Like "*1*" Or (ReportGrpWard.GrpWard.GroupIndicator) Like "*2*" Or (ReportGrpWard.GrpWard.GroupIndicator) Like "*4*"))AuditedWard_Crosstab.[Total Of PatientID]ReportGrpWard.GrpWard.GroupIndicatorReportGrpWard.CountOfGroupIndicatorReportGrpWard.YesAnswersWardGroup.WardIDAuditedWard_Crosstab.WardID = ReportGrpWard.GrpWard.WardIDRound(Nz([CountOfGroupIndicator]/[Total Of PatientID],0),2)AuditedWard_Crosstab.[Total Of PatientID]ReportGrpWard.GrpWard.GroupIndicatorReportGrpWard.CountOfGroupIndicatorReportGrpWard.YesAnswersWardGroup.WardID((([ReportGpUnit].[GrpUnit].[GroupIndicator]) Like "*1*" Or ([ReportGpUnit].[GrpUnit].[GroupIndicator]) Like "*2*" Or ([ReportGpUnit].[GrpUnit].[GroupIndicator]) Like "*4*"))AuditedUnit_Crosstab.[Total Of PatientID]ReportGpUnit.[CountOfAllQandA_GroupIndicator Field]ReportGpUnit.[Find duplicate for YesAnswerGroup Unit].UnitIDReportGpUnit.GrpUnit.UnitID = AuditedUnit_Crosstab.UnitIDRound(Nz([CountOfAllQandA_GroupIndicator Field]/[Total Of PatientID],0),2)AuditedUnit_Crosstab.[Total Of PatientID]ReportGpUnit.[CountOfAllQandA_GroupIndicator Field]ReportGpUnit.[Find duplicate for YesAnswerGroup Unit].UnitID(((ReportGrpWard.GrpWard.GroupIndicator) Like "*3*"))ReportGrpWard.GrpWard.GroupIndicatorReportGrpWard.CountOfGroupIndicatorReportGrpWard.YesAnswersWardGroup.WardIDReportGrpWard.GrpWard.WardID = DENPI3Ward.WardIDReportGrpWard.GrpWard.WardID = AuditedWard_Crosstab.WardIDIIf(Nz([CountOfPatientID],0)=0,1,Nz([CountOfGroupIndicator]/[CountOfPatientID],0))ReportGrpWard.GrpWard.GroupIndicatorVCN   2  2  2      2HospNumHospNameRegionContactPhoneAudits DateOfAuditCampusPT HospNum PrimaryKey ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJKLMNOPQLRLSLTLULVLWLXLYL ZL[L\L]L^L_L`LaLbLcLdLeLfLgLhLijklmnopqr s t u v wxyz{|}~     FlagMSysQueriesFlag00,!! ExpressionMSysQueriesExpression<<2'' Name2MSysQueriesName222-"" Name1MSysQueriesName122-""AttributeMSysQueriesAttribute::1&&{q|@ a%Hvo5eF kL @ G G   @ ' )@ g ReportGpUnit.GroupIndicator3 g 3@ g <@  gReportGpUnitAuditedUnit_Crosstab9@ 8, ScoreJ@  o)@  gReportGpUnit.GroupIndicator3 g3@  g<AuditedWard_Crosstab.[Total Of PatientID]ReportGrpWard.GrpWard.GroupIndicatorReportGrpWard.CountOfGroupIndicatorReportGrpWard.YesAnswersWardGroup.WardIDAuditedWard_Crosstab.WardID = ReportGrpWard.GrpWard.WardIDRound(Nz([CountOfGroupIndicator]/[Total Of PatientID],0),2)AuditedWard_Crosstab.[Total Of PatientID]ReportGrpWard.GrpWard.GroupIndicatorReportGrpWard.CountOfGroupIndicatorReportGrpWard.YesAnswersWardGroup.WardID((([ReportGpUnit].[GrpUnit].[GroupIndicator]) Like "*1*" Or ([ReportGpUnit].[GrpUnit].[GroupIndicator]) Like "*2*" Or ([ReportGpUnit].[GrpUnit].[GroupIndicator]) Like "*4*"))AuditedUnit_Crosstab.[Total Of PatientID]ReportGpUnit.[CountOfAllQandA_GroupIndicator Field]ReportGpUnit.[Find duplicate for YesAnswerGroup Unit].UnitIDReportGpUnit.GrpUnit.UnitID = AuditedUnit_Crosstab.UnitIDRound(Nz([CountOfAllQandA_GroupIndicator Field]/[Total Of PatientID],0),2)AuditedU           ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJKLMNOPQLRLSLTLULVLWLXLYL ZL[L\L]L^L_L`LaLbLcLdLeLfLgLhLijklmnopqr s t u v wxyz{|}~      $*06<BRLYL _L eL jL pLvLLtblStore subformour subf`x.Section(0).BackColor = conDisabledEnd With"If ms!PatienDt2 wTwo v!@Frame6h2` ThenN E3A EhreeAHSbecus'Enl@Fals?!LockedY Tr [3>]a!IfwText14]&0 Ak $2 $Nf@.rt2QuesNumA"Q9"'jFive9ZJII ZjTZZSK%AOTAhO9# tlA|llAl &_D&/ d rm_#Z#* iderɩo DoCmdtWarning$s C[ E !`xit_ mand70_Cli(ck:wE@ S$ubrrMsgBox Err.Descrip!#Resume>  cd PrivateA %1#()ValidReason"" Othrek" B LVALh31 E2 @@ @ @ @ @ @(((PartOneQuestions.PartOneQID)=1 Or (PartOneQuestions.PartOneQID)=2 Or (PartOneQuestions.PartOneQID)=5 Or (PartOneQuestions.PartOneQID)=7 Or (PartOneQuestions.PartOneQID)=14))(((PartFourQuestions.PartTwoQID)=1 Or (PartFourQuestions.PartTwoQID)=3))PartFourQuestions.PartTwoQuestion[Forms]![Patient3]![ComProv].[Form]![CommunityID]((([PartFourQuestions].[PartTwoQID])=2 Or ([PartFourQuestions].[PartTwoQID])=3))[PartFourQuestions].[PartTwoQuestion][Forms]![Patient3]![ComProv].[Form]![CommunityID][PartFiveQuestions].[PartTwoQuestion][Wards].[WardID]=[ReportWard2].[WardID][ReportWard2].[Indicator] In ("PI 1 Content","PI 1 Timeliness","PI 2 Content","PI 2 Timeliness","PI 3 Content","PI 3 Timeliness","PI 4 Content","PI 4 Timeliness")Sum([ReportWard2].[CountOfIndicator])Sum([ReportWard2].[CountOfIndicator])[Units].[UnitID]=[ReportUnit2].[UnitID][ReportUnit2].[Indicator] In ("PI 1 Content","PI 1 Timeliness","PI 2 Content","PI 2 Timeliness","PI 3 Content","PI 3 Timeliness","PI 4 Content","PI 4 Timeliness")Sum([ReportUnit2].[CountOfIndicator])Sum([ReportUnit2].[CountOfIndicator])((([AllQandA].[Indicator]) Like "PI 3*") And (([AllQandA].[Answer])=2) And (([AllQandA].[Valid])=0))((([AllQuestions].[Indicator]) Is Not Null And ([AllQuestions].[Indicator])<>"PI 1/PI 2 Link") And (([AllAnswers].[Answer])=2) And (([AllAnswers].[Valid])=0))[AllAnswers].[PatientID]=[AuditedPatient].[PatientID][AllAnswers].[QuestionID]=[AllQuestions].[PartOneQuestion]Wards.WardID = JoinHedPisWardQrys.GrpWard.WardIDUnits.UnitID = JoinHedPisUnitQrys.GrpUnit.UnitID(((AnswersPartOne.PatientID)=Forms!Patient![PatientID]) And ((AnswersPartOne.QuestionID) Like "Did this patient have an automatic referral for assessment?"))SELECT GrpAdmType.AdmType, Score From HEDPISPI3Select GrpAdmType.AdmType, Score From HEDPIS VCN   2ComIDDatai ComID PrimaryKey           ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJKLMNOPQLRLSLTLULVLWLXLYL ZL[L\L]L^L_L`LaLbLcLdLeLfLgLhLijklmnopqr s t u v wxyz{|}~   FlagMSysQueriesFlag00,!! ExpressionMSysQueriesExpression<<2'' Name2MSysQueriesName222-"" Name1MSysQueriesName122-""AttributeMSysQueriesAttribute::1&&{qo9D pOmZG(X9&J}TA.~X7YZ_____2SELECT* From HEDPISPI3Unit= 7X7YZ_____1Select * From HEDPISUnit ? 7 G  G  X7YZ_____20@" 7X7YZ_____11@" 7 G  G  1@ '[AllQuestions].[Indicator]2 g[AuditedPatient].[WardID]1 g[AllQuestions].[GroupIndicator]7 gAuditedPatient AllQuestions  G  1@ '[AllQuestions].[Indicator]2 g[AuditedPatient].[UnitID]1 g[AllQuestions].[GroupIndicator]7 gAuditedPatient AllQuestions  G  1@ '[AllQuestions].[Indicator]2 g[AuditedPatient].[AdmTyp+2N@+2N@LastQPart1))))))))))) Ws2N@+2N@JoinHedPisWardQrys11111111111 Ws2N@Ws2N@JoinHedPisUnitQrys11111111111 Ws2N@Ws2N@JoinHed@            ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJKLMNOPQLRLSLTLULVLWLXLYL ZL[L\L]L^L_L`LaLbLcLdLeLfLgLhLijklmnopqr s t u v wxyz{|}~   $*06<BRLYL _L eL jL pLvLL a reason in the OTHER boxA@ax  N 0 B@BhXhPhH2@u8.0 !A@2l`': 'l   ": ":$ ": ":$ ˳Attribute VB_Name = "Form_ValidReasons3"D Bas0{C3D29B7F-708C-11D6-AFEF-40A75CC@12950} |CreatablTrue ]Pre declaId"Expose!Fals @TemplateDeriv%Cust0omizD$ Option CompA DUw =licit 0 P04 Submand54_Ck()Me!List5 1 DoCm0d.Cl_End%5%H060.Visi "!60!On Error GotTo_F A" Dim stfA As SngE1  @Patientst @ IIf IsLoaded(") Then @TAU" OrNull(KASelect C(s!![AnswersPartThr@ee subAB].A rt2QuesANumC&B"Q10A", S11LOFAutoE With +*!OMamc2M!G Pb*g-*_e9D D\ DDd D71{ pVCu Nu u  DataID AOIndex'()"*,-./+023451      !"#$@@'@1$@  @ @ @ @ @ @ @bb b~+ccccc cd d d d d d d eeeeeeeeeeefffff  f !fg"g$g%g&g'g(g#h)h+h,h-h.h/h0h1hhhhhh*iiii i ij j jjjjjjj kkkkkkkkllll l!l"lm#m%m&m'm(m)m$n*n,n-n.n/n0n1n2n3n+o4o6o5BCDNud  @ @ @ @ @ @ @ @ @ @ @ @ @ o9o:o;o5pyyyyyy?zzzz z z z z{ {{{{{{{||||||||}}} }!}"} @ @ @ @ @ @ @~#~%~&~'~(~$)+,-.*/123405789:6;=>?@<A     !"#$ %'()*&+-./012345 6 7 8,9;<=   :    @ @ @ @ @ @ @!"#$ %'()*&+-./012345 6 7 8,9;<=   :         ! " # $%'()*+,-    &          @ @ @ @ @ @ @     ! " # $%'()*+,-    &              !"#$%&'(          @ @ @ @ @ @ @     !"#$%&'(          !"#$%&'()*+, -          ! !"#$% @ @ @ @ @ @ @!"#$%&'()*+, -          ! !"#$% & '(            !"#$%&'()*+,-/0. @ @ @ @ @ @ @(            !"#$%&'()*+,-/0 .       !"# $ %&()*+,-./01'FormFooter @ @ @ @ @ @ @hh*iiii i ij j jjjjjjj kkkkkkkkllll l!l"lm#m%m&m'm(m)m$n*n,n-n.n/n0n1n2n3n+o4o6o7o8o9o:o;o5p+s<b, DetachedLabelm7]`m ak G G  )@ 'ValidReasonAuditedPatient0@1% ValidReasonAllQuestions8@/# ValidReason.Other) gValidReason.ValidReason/ gAllQuestions.PartOneQuestion4 gValidReason.QuestionNumber2 gAuditedPatient.PatientUR0 gValidReason.PatientID- gAuditedPatient AllQuestions ValidReason  G G   [ReportAdmType2].[Indicator]4 g [ReportAdmType2].[AdmType]2 g@ gTotal Of CountOfIndicator(@ 1%% o[ReportAdmType2].[AdmType]2 gSumOfCountOfIndicator(@ -!! oReportAdmType2  G   &@  g [ReportGrp1].GrpAdmType.AdmType7 g&@  gTotal Of CountOfGroupIndicator)@ 6** o[ReportGrp1].GrpAdmType.AdmType7 gSumOfCountOfGroupIndicator)@2&& oReportGrp1  G   [ReportAdmType2].[Indicator]4 g [ReportAdmType2].[AdmType]2 g@ gTotal Of CountOfPatientID(@1%% o[ReportAdmType2].[AdmType]2 gCountOfIndicatorSum(Nz([CountOfPatientID],0))E oReportAdmType2  G (vIqHyR+cjAoL)=mZ Den124UnitYesAnswersPI124Group_CrosstabUnit8@ C7 Den124UnityesAnswersPI3ForFinal,@ 7+ Den124UnitYesAnswersPI3Group_CrosstabUnit6@ A5 Den124UnitTDCS3Unit Den124Unit.Unit = TDCS3Unit.UnitK Den124UnitYesAnswersPI124Step2_CrosstabUnit8@ C7 Den124UnitDen3UnitDen124Unit.Unit = Den3Unit.UnitI !PI4T;@  o PI4C8@ oPI3T/@ oPI3C,@ oPI2T;@ oPI2C8@ oPI1T;@ oPI1C8@ oAvgOfScorew@" oPI4GpNumNZ([Performance Indicator 4],0)? oPI3GpNum#@  oPI2GpNumNZ([Performance Indicator 2],0)? oPI1GpNumNZ([Performance Indicator 1],0)? oDen3Unit.[PI 3 Content]/ gDenPI124Den124Unit.[PI 1 Content]9 oTotalDischargeCompliance Score[PercentTDCS]/100*100K** oPI4Score@  oPI3Score@  oPI2Score@  oPI1Score@  o PI4Timeliness@% o PI4Content@" o PI3Timeliness~@% o PI3Contentu@" o PI2Timeliness@% oPI2Content@" oPI1Timeliness@% oPI1Content@" oDen124Unit.Unit' gHosData.Campus& gHosData.Region& gHosData.HospName( gHosData.HospNum' g3w@x?h8 xeM-[< }jW8n[H)s1@ '[AuditedPatient].[UnitID]1 g[AllQuestions].[GroupIndicator]7 gAuditedPatient AllQuestions  G  1@ '[AuditedPatient].[AdmType]2 g[AllQuestions].[GroupIndicator]7 gAuditedPatient AllQuestions  G   &@ g [Wards].[WardID]( g [Wards].[Ward]& gWardsReportGrpWard/@* &@ gTotal Of CountOfGroupIndicator,@6** o[Wards].[WardID]( g[Wards].[Ward]& gSumOfCountOfGroupIndicator,@2&& oReportGrpWard Wards  G   [ReportGpUnit].[GroupIndicator]7 g [Units].[UnitID]( g [Units].[Unit]& gReportGpUnitUnits.@) [ReportGpUnit].[GroupIndicator]7 gTotal Of CountOfGroupIndicator:@6** o[Units].[UnitID]( g[Units].[Unit]& gSumOfCountOfGroupIndicator:@2&& oUnits ReportGpUnit  G  x@ 'ValidReasonAnswerspartFive/@2& AnswerspartFive.Valid2No0" wAnswerspartFive.ValidNo/! wAnswerspartFive ValidReason  G 5I_ BjWD1`$[lYF3  3@ g<@ gDENPI3Unit AuditedUnit_Crosstab ReportGpUnit  G G   5@ ' DenPI3.CountOfPatientID/ g ReportGrp1.GrpAdmType.AdmType5 g $@ g  ReportGrp1.CountOfGroupIndicator8 gReportGrp1DenPI3.@( ReportGrp1AuditedPatient_Crosstab?@9- Score]@ oDenPI3.CountOfPatientID/ gReportGrp1.GrpAdmType.AdmType5 g$@ g ReportGrp1.CountOfGroupIndicator8 gDenPI3 AuditedPatient_Crosstab### ReportGrp1  G G   @ ' ,@ g ReportGrp1.GrpAdmType.AdmType5 g $@  g  ReportGrp1.CountOfGroupIndicator8 gReportGrp1AuditedPatient_Crosstab?@ 9- Score;@  o,@  gReportGrp1.GrpAdmType.AdmType5 g$@  g ReportGrp1.CountOfGroupIndicator8 gAuditedPatient_Crosstab### ReportGrp1  G G  1@ '[AuditedPatient].[WardID]1 g[AllQuestions].[GroupIndicator]7 gAuditedPatient AllQuestions  G  6{\!`ApOmZG(X9&J}TA.~ X7YZ_____2SELECT* From HEDPISPI3Unit= 7X7YZ_____1Select * From HEDPISUnit ? 7 G  G  X7YZ_____20@" 7X7YZ_____11@" 7 G  G  1@ '[AllQuestions].[Indicator]2 g[AuditedPatient].[WardID]1 g[AllQuestions].[GroupIndicator]7 gAuditedPatient AllQuestions  G  1@ '[AllQuestions].[Indicator]2 g[AuditedPatient].[UnitID]1 g[AllQuestions].[GroupIndicator]7 gAuditedPatient AllQuestions  G  1@ '[AllQuestions].[Indicator]2 g[AuditedPatient].[AdmType]2 g[AllQuestions].[GroupIndicator]7 gAuditedPatient AllQuestions  G   @ ' )@ g ReportGrpWard.GrpWard.WardID4 g $@ g #@ g (@ gAuditedWard_CrosstabReportGrpWard:@9- Score;@ o)@ gReportGrpWard.GrpWard.WardID4 g$@ g#@ g(@ gReportGrpWard AuditedWard_Crosstab 63n*t@!v=*rES^(L    [AuditedPatient].[UnitID]1 g[AuditedPatient].[PatientUR]4 g[AllAnswers].[Valid], g[AllAnswers].[Answer]- g[AllAnswers].[QuestionID]1 g[AllAnswers].[PatientID]0 g[AllQuestions].[Indicator]2 g[AllAnswers].[AnswerID]/ gAuditedPatient AllQuestions AllAnswers   WardsJoinHedPisWardQrys0@/# ScoreJoinHedPisWardQrys.Score5 wType Wards.Ward& wJoinHedPisWardQrys Wards  GScores O  UnitsJoinHedPisUnitQrys0@/# Type Units.Unit& wScoreJoinHedPisUnitQrys.Score5 wUnits JoinHedPisUnitQrys  GScores O  TypeJoinHedPisQrys.AdmType2 wScoreJoinHedPisQrys.Score1 wJoinHedPisQrys  GScores O  @ 'AnswersPartOne.Answer- gAnswersPartOne.QuestionID1 gAnswersPartOne.PatientID0 gAnswersPartOne   X7YZ_____2SELECT* From HEDPISPI3Ward= 7X7YZ_____1Select * From HEDPISWard ? 7 G  G  a{q @ @ FHK IPJKTMOXQ!W]X(|bho8}   '%% !#$%&'()"*,-./+023451    ?@2sC$`4c*U{W|=~c/ yesAnswersPI3ForFinal!!! YesAnswersPI3Group_CrosstabUnit+++ TDCS3Unit YesAnswersPI124Step2_CrosstabUnit--- YesAnswersPI124Group_CrosstabUnit--- Den3Unit Den124Unit HosData  G G   ExportValidReason.ValidReason5 g  ExportValidReason.QuestionNumber8 gTotal Of PatientID"@* oCountOfPatientID"@( oExportValidReason.ValidReason5 g ExportValidReason.QuestionNumber8 gExportValidReason  G G   ValidReason.QuestionNumber2 ')@ 'ValidReasonAllQuestions8@/# ValidReason.Other) gAllQuestions.PartOneQuestion4 gValidReason.PatientID- gValidReason.ValidReason/ gValidReason.QuestionNumber2 gAllQuestions ValidReason  G G  Q1ReasonReasonsQ1Reason.ID=Reasons.ReasonA  Reasons.Other% gQ1Reason.Q1Reason) gReasons Q1Reason    ValidReason.QuestionNumber2 'H@ 'ValidReason.Other) gValidReason.ValidReason/ gValidReason.QuestionNumber2 gValidReason -uY%e6 Y0Z3 l,jCkH%lDen124WardDen3WardDen124Ward.Ward = Den3Ward.WardI !PI4T;@ o PI4C8@ oPI3T3@  oPI3C0@  oPI2T;@  oPI2C8@  oPI1T;@  oPI1C8@ oAvgOfScorew@" oPI4GpNumNZ([Performance Indicator 4],0)? oPI3GpNum#@  oPI2GpNumNZ([Performance Indicator 2],0)? oPI1GpNumNZ([Performance Indicator 1],0)? oDen3Ward.[PI 3 Content]/ gDenPI124Den124Ward.[PI 1 Content]9 oTotalDischargeCompliance Score[PercentTDCS]/100*100K** oPI4Score@  oPI3Score@  oPI2Score@  oPI1Score@  o PI4Timeliness@% o PI4Content@" o PI3Timeliness@% o PI3Contenty@" o PI2Timeliness@% oPI2Content@" oPI1Timeliness@% oPI1Content@" oDen124Ward.Ward' gHosData.Campus& gHosData.Region& gHosData.HospName( gHosData.HospNum' gYesAnswersPI124Step2_CrosstabWard--- YesAnswersPI3Group_CrosstabWard+++ YesAnswersPI3WardForFinal%%% YesAnswersPI124Group_CrosstabWard--- TDCS3Ward Den3Ward Den124Ward HosData  G G  +l$}jHp7{hU3[&nLt:}j G    @ ' )@ g $@ g esAnswersGroup].[AdmType]3 gesAnswersGroup].[AdmType]3 gNumberOfDupsCount([AllQandA].[PatientID])A oAllQandA_GroupIndicator Field"@5)) oAllQandA_PatientID FieldFirst([AllQandA].[PatientID])M$$ oYesAnswersGroup     @ ' '@ g "@ g YesAnswersGroup.WardID. gYesAnswersGroup.WardID. gNumberOfDupsCount([AllQandA].[PatientID])A oAllQandA_GroupIndicator Field"@5)) oAllQandA_PatientID FieldFirst([AllQandA].[PatientID])M$$ oYesAnswersGroup  G G    @ ' )@ g $@ g [YesAnswersGroup].[UnitID]2 g[YesAnswersGroup].[UnitID]2 gNumberOfDupsCount([AllQandA].[PatientID])A oAllQandA_GroupIndicator Field"@5)) oAllQandA_PatientID FieldFirst([AllQandA].[PatientID])M$$ oYesAnswersGroup   Den124WardYesAnswersPI124Group_CrosstabWard8@C7 Den124WardYesAnswersPI124Step2_CrosstabWard8@C7 Den124WardYesAnswersPI3Group_CrosstabWard6@A5 Den124WardYesAnswersPI3WardForFinal0@;/ Den124WardTDCS3Ward Den124Ward.Ward = TDCS3Ward.WardK 4h)|B#sT5}=o5eF kL  G G   @ ' )@ g ReportGpUnit.GroupIndicator3 g 3@ g <@  gReportGpUnitAuditedUnit_Crosstab9@ 8, ScoreJ@  o)@  gReportGpUnit.GroupIndicator3 g3@  g<@ gAuditedUnit_Crosstab ReportGpUnit  G G   5@ ' DENPI3Ward.CountOfPatientID3 g ReportGrpWard.GrpWard.WardID4 g $@ g #@ g (@ gReportGrpWardDENPI3Ward0@/# ReportGrpWardAuditedWard_Crosstab:@9- ScoreR@ oDENPI3Ward.CountOfPatientID3 gReportGrpWard.GrpWard.WardID4 g$@ g#@ g(@ gDENPI3Ward AuditedWard_Crosstab ReportGrpWard  G G   :@ ' DENPI3Unit.CountOfPatientID3 g ReportGpUnit.GroupIndicator3 g 3@ g <@ gReportGpUnitDENPI3Unit/@." ReportGpUnitAuditedUnit_Crosstab9@8, Scorea@ oDENPI3Unit.CountOfPatientID3 gReportGpUnit.GroupIndicator3 g $*0:{W! <W!  !"#$ Forms i{W!p^~W!Reportsrstuvwxyz{Root Entry{W!oPropData68B9:;<=>?@ARWDEFGHIJKLMNOP|STUVX_YZ[\]^kpabcdefghijlmno~ 1" !#'$%&(,)*+-0./27Q345ࡱ>  YP}O}y5x d3wv ; 0n kn  $*0MI:+'` {W!kW!Blob CustomGroups {W!{W!Databases {W!kW!0 {W!TW!Cmdbars{W!kW!DataAccessPages {W!kW!ScriptsV{W!kW!VBA cgh MS Sans Serifi1ghj1ghk1bcl23:bc g[m4bg[n2cdh[o2ej[p5bModules @ܜSELECT HosData.HospNum, HosData.HospName, HosData.Region, HosData.Contact, HosData.Phone, HosData.Audits, HosData.DateOfAudit, HosData.Campus FROM HosData; HosData subformAriald2e12bRcRfbg237bchb cdefghijklmnopqrstuvwxyz{}~ij08=Bb cIe ghiXjkDzLC '()*+,-./0123456789:<=@ABCDEFGHIJLOPQRSTUVWXZ]^_`ab $*0VBA_MODULE)Pd5U`9atbc Contact_LabelContact PersonÌp@\)Pm7UF`abcekPhonePhonePhone number of contact personÌp@\)Pd5U`9abc Phone_Label Phone NumberÌp@\)Pm7UF`a bceb ce kRegionRegion$Region in which the hospital residesÌp@\)Pd5U`9abc Region_LabelRegionÌp@\)Pm7UF`atb ce kContactContact&Contact person for effective dischargeÌp@\SÌp@\)Pd5U`9arbc HospNum_LabelHospital NumberÌp@\)Pm7UF`ab ce kHospNameHospName Hospital NameÌp@\)Pd5U`9abcHospName_Label Hospital NameÌp@\)Pm7UF`a&cr35cd zbcij MS Sans Serif{5bcJ ` FormHeaderÌp@\)P` DetailÌp@\)Pm7UF`arbceHospNumHospNum"Hospital Number as assigned by DH%1~W!~W!Blob ypeInfoPropData0(~W!~W!Blob T {W!{W!VBAProjectk:|W!k:|W!0 $*0.[UnitID] DESC , [Patient].[WardID] DESC; Patient subformAriald2e12bRcRf5bg237bchbcgh MS Sans Serifi1ghj1ghk1bcl23:bc g[m4bg[n2cdh[~W!~W!Blob ?] FROM Patient ORDER BY [Patient].[PatientUR] DESC , [Patient];PropData>208=Bb c_e ghf!ij+kD}qC@ܫSELECT [Patient].[PatientUR], [Patient].[UnitID], [Patient].[WardIDTypeInfoPhone_Labelm Auditsd Audits_LabelmDateOfAuditd DateOfAudit_LabelmCampusFormFooterX2B$\k(FormHeaderDetailmHospNumd HospNum_LabelmHospNamed HospName_LabelmRegiond Region_LabelmContactd Contact_Labelm Phoned Pd5U`9avbcDateOfAudit_Label DateOfAuditÌp@\)Pm7UF`_ aikCampusCampus Campus Name as obtained from DHSÌp@\)P` FormFooterœÌp@\)Pbel Hospital NameÌp@\)PmͬkAuditsAudits Number of audits to be completedÌp@\)Pd5U`9a bc Audits_LabelAuditsÌp@\)Pm7UF`avbcek DateOfAudit DateOfAuditmmm-yyyy Month and year of current audit.Ìp@\)  @ @ @ @ @ @ @ @ @ @ @ @ @       !"#$%&'() *!+,              !"# $ % & '(*)           ! " $*0NT [Units].[Unit] FROM Units; Units subformAriald2e12bRcRf5bg237bchbcgh MS Sans Serifi1ghj1ghk1bcl23:bc g'M3aB ~W!B ~W!Blob &jkme0@"SELECTypeInfoKzPropData%DetailmPatientURoUnitIDd Label2oWardIDd Label3FormFooter].[UnitID], [Patient]o8D=Bb c*e ghi $ard] FROM Wards; ";"Wards";"";"WardID";"Ward";"PrimaryKey"d5`a,bcLabel3Ward:5RC%~{Kw=s` FormFooter̜Ìp@\)Pi1ghj1ghk1bcl23:ͬ @F2냳FormHeader#d5`a<bcLabel2Unit:M urLNXo5w`bc d,n"";"";"";"";"10";"100"(Ov\b WardIDWardID Table/Query4SELECT [Wards].[WardID], [Wards].[Ward] FROM Wards; 0;1440^"SELECT [Wards].[WardID], [Wards].[W"c3 d<n"";"";"";"";"10";"100"l FL^AcUnitIDUnitID Table/Query4SELECT [Units].[UnitID], [Units].[Unit] FROM Units; 0;1440^"SELECT [Units].[UnitID], [Units].[Unit] FROM Units; ";"Units";"";"UnitID";"Unit";"PrimaryKey"!o2ej[p5bcr35cd zbcij MS Sans Serif{5bcJ ` FormHeaderɜÌp@\)P`DetailʜÌp@\)Pm7]`9a9b ce PatientUR PatientUR˜Ìp@\)Po5`b  $*0ter Wards Here DetachedLabelSCBĪk`qDetailx gLg|k(m7U`9a9bKce WardWard"List the wards within the hospitalF(dHK<)N` FormFootert.|[b/AW<(M.[PatientUR] DESC ,/k1bcl23:bc g[m4bg[n2cdh[o2ej[p5bcr35cd zbcij MS Sans Serif{5bcJ `b FormHeader/cph O 3ed5U7`9a9b c Ward_LabelEn. (~W!Blob \e12bRcRf5bg237bchbcgh MS Sans Serifi1ghj1gh-PropData[0!B ~W!,8D=Bb cce ghi j-k[f0@"SELECT [Wards].[Ward] FROM Wards; Wards subformAriald2TypeInfoYz+~W!~W!ͬ4fNN{FormHeaderd Unit_LabelDetailmUnitFormFooterient ORDER BY [Patient].[PatientUR] DESC ,*etachedLabelq 74LM}=`qDetailՁN~v;0z(m7U`9a9bKce UnitUnit@List the units within the hospital i.e. ENT, General Surgery etc5BIù4Bg` FormFooterͨ0{LnJc*e ghi )[m4bg[n2cdh[o2ej[p5bcr35cd zbcij MS Sans Serif{5bcJ `b FormHeaderpHz~,d5U7`9a9b c Unit_LabelEnter Units/Division Here D( $*0VBA_MODULE9a9bc,QuestionID_Label QuestionID DetachedLabel.WJ-d7`Aa9b<c,Total Of PatientID_LabelTotal Of PatientID DetachedLabelTotal_Of_PatientID_LabelNw@,vaH_md7`a9b;c,DenP1P2P4_Label DenP1P2P47lbc g[m5Cbg[Arialn=cdh[Arialo3Aej[Arialp4bcrcd ` ReportHeaderɎdAA-&d2`9a9bcdLabel8 AcutePercentJυT`PageHeaderSectionYK9J]#Bkd`6 d(Untitled),L&DHP LaserJet 2100 Series PCL 6HP LaserJet 2100 Series PCL 6LPT1:d278d eTimes New Romane24bRcRfbg37bcjgh5, ttghjil 4&% (~W! (~W!Blob 3|PropData 12Z$98@ AcutePICont AcutePercentArial8n#hHP LaserJet 2100 Series PCL 6 TypeInfo1ͬh WJ7 BFormHeaderd Ward_LabelDetailmWardFormFootere37bchbcgh MS Sans Serif08:<=Bb cn#e g hiXjz+k%0 $*0 Percent PageFooterSectionmText9mText10fLine12ReportFooter08?ailm QuestionIDm Total_Of_PatientIDTotal Of PatientIDm DenP1P2P4m>=_PatientID_LabelTotal Of PatientID_LabeldDenP1P2P4_LabeldPercent_LabelfLine11Det<asL:dmF`Aa9b<ce9kTotal Of PatientIDTotal Of PatientIDTotal_Of_PatientIDb$mF;lemF`a9b;cek DenP1P2P4 DenP1P2P4 S6PD_Q-mF`*a9b ckPercentPercentPercentʓ%㣡B2̊;8`P9 DetachedLabel lKCo1d7`*a9b c, Percent_LabelPercent DetachedLabelȽ8T&Dc24gf2`9aeb"Line11J)M$H`DetailsSAuEohmF`9a9bce= QuestionID QuestionID[x͂sN@8le @ /Oo`a b -c Md !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!    !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~                                         B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~        !!!!!!!!""""""""########$$$$$$$$%%%%%%%%&&&&&&&&''''''''(((((((())))))))********++++++++,,,,,,,,--------........///!!!!!!""""""""########$$$$$$$$%%%%%%%%&&&&&&&&''''''''((((B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!/////0000 0 0 0 0 1111111122222222333 3!3"3#3$3%4&4'4(4)4*4+4,4-5.5/505152535455666768696:6;6<6=7>7?7@7A7B7C7D7E8F8G8H8I8J8K8L8M9N9O9P9Q9R9S9T9U:V:W:X:Y:Z:[:\:];^;_;`;a;b;c;d;e<f<g<h<i<j<k<l<m=n=o=p=q=r=s=t=u>v>w>x>y>z>{>|>}?~???????@@@@@@@@AAAAAAAABBBBBBBBCCCCCCCCDDDDDDDDEEEEEEEEFFFFFFFFGGGGGGGGHHHHHHHHIIIIIIIIJJJJJJJJKKKKKKKKLLLLLLLLMMMMMMMMNNNNNNNNOOOAAAAAAABBBBBBBBCCCCCCCCDDDDDDDDEEEEEEEEFFFFFFFFGGGGGGGGHHH B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!OOOOOPPPP P P P PQQQQQQQQRRRRRRRRSS S!S"S#S$S%S&T'T(T)T*T+T,T-T.U/U0U1U2U3U4U5U6V7V8V9V:V;V<V=V>W?W@WAWBWCWDWEWFXGXHXIXJXKXLXMXNYOYPYQYRYSYTYUYVZWZXZYZZZ[Z\Z]Z^[_[`[a[b[c[d[e[f\g\h\i\j\k\l\m\n]o]p]q]r]s]t]u]v^w^x^y^z^{^|^}^~________````````aaaaaaaabbbbbbbbccccccccddddddddeeeeeeeeffffffffgggggggghhhhhhhhiiiiiiiijjjjjjjjkkkkkkkkllllllllmmmmmmmmnnnnnnnnooaaaaaaabbbbbbbbccccccccddddddddeeeeeeeeffffffffgggggggghhhB!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!ooooooppp p p p p pqqqqqqqqrrrrrrrrss s!s"s#s$s%s&t't(t)t*t+t,t-t.u/u0u1u2u3u4u5u6v7v8v9v:v;v<v=v>w?w@wAwBwCwDwEwFxGxHxIxJxKxLxMxNyOyPyQyRySyTyUyVzWzXzYzZz[z\z]z^{_{`{a{b{c{d{e{f|g|h|i|j|k|l|m|n}o}p}q}r}s}t}u}v~y~z~{~|~}~~~~ `B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~VCN   GrptbcdTbName_ TbIndexS{qgLVAL           ! " # $ % &'()*+,-./012345678 9:;<=>?@AB C D E FGHIJKLMNOPQLRLSLTLULVLWLXLYL ZL[L\L]L^L_L`LaLbLcLdLeLfLgLhLijklmnopqr s t u v wxyz{|}~ Report,gr-jr `!9 ExportToWordFileSave( p(sCNilMenu 12Y $*0cdLabel6>Total Hospital Effective Discharge Performance Indicator ScoreMÌp@\)Pd`gaYb c,deLabel7>Total Hospital Effective Discharge Performance Indicator ScoreNÌp@\)P`PageFooterSectionOÌpG`PageHeaderSectionHÌp@\)Pf2bLine4IÌp@\)P` DetailJÌp@\)PmF`pahbVc AvgOfScore AvgOfScorePercentKÌp@\)PmF`]aKbckAdmTypeAdmTypeLÌp@\)PdabF278d eTimes New Romane2bRcRfbg37bcjghlbc g[m5<Cbg[Times New Romann7=cdh[Times New Romano3:Aej[Times New Romanp4bcrcd ` ReportHeaderGÌp@\)PE d(Untitled),L&DHP LaserJet 2100 Series PCL 6HP LaserJet 2100 Series PCL 6LPT1:dD2100 Series PCL 6W dXA4, ttghjil C) (~W! +~W!Blob HP LaserJet BPropData#$2A:<=Bb ce ghiXj<kgV1 MC@