Home

Financial and Residential Activity Collection (FRAC) DSS

1. a FRAC Finance Statement Prev Year B3 Reference Tables RUDI Actual d tiis d Actual 1 H User Defaults Current Date 04 D8 2010 12 18 56 PM Actual Var ES Pathology Statement 1 24 121 172 21 585 840 2 534 232 ES User Options _ Labour Related Expenditure 17 414 984 15 629 833 1 785 152 E3 Public Reports p Payroll Expenditure 14 381 323 13 278 208 1 103 115 Labour Expend Ext AgengyContr 1 652 892 1 093 584 559 308 Ex Gratia Payments To Staff Superannuation 1 361 223 1 238 773 122 450 Payroll amp Fringe Benefit Taxes 19 546 19 267 279 E Non Labour Related Expenditure 8 705 187 5 857 107 749 081 Food Supplies 149 143 128 831 20 311 Other Food Supplies 149 143 128 831 20 311 Precooked Frozen Foods E Drug Expenses 1 945 860 1 017 340 71 480 Clinical Supplies And Services 1 859 222 1 722 987 136 235 Non Dispasable Inst amp App 41 030 48 212 7 182 Disposables 496 020 430 769 65 251 Dressings l Prosthetics 20 418 15 248 5 171 Other Clinical Requisites 148 943 290 753 141 810 i Home Medical Aids Medical Gases 35 845 18 808 15 935 Other Clinical Support Req 2 280 2 912 632 External Clin Services Other 335 543 220 979 114 564 External Clin Sery Pathology 779 143 694 204 84938 Inventory WWOf Clin Supplies aci Iu 4 amp Applet Applet3010 started w Local intranet 1 To scroll down
2. gas S pas ES Account Code and Description Actual Budget PITE YTD Actual YTD Budget WE EM Descriplinn Varia Variance 893828 Hal HitHalwyn Centre 400020 Cwlh State Disability Agreement Nursing 134 960 118 473 16 487 134 960 118 473 15 487 430090 Commission Other 143 143 143 143 443630 Daily Maintenance Charge Long Stay B5 523 66 257 734 65 523 66 257 734 450230 Ser Ctv Gold Phone g 8 8 8 50001 0 Salwag Manager And Clerical 13 717 14 744 1 027 13 717 14 744 1 027 500030 Salwag Nursing 241 237 296 026 54 789 241 237 296 026 54 789 500040 Salwag Operation Service 45 381 53 742 8 361 45 381 53 742 8 361 500060 Salwag Visiting Medical Officer 4819 4161 B58 4 819 4 161 658 501030 Overtm Nursing 56 898 6 899 6 899 6 899 501040 Overtm Operation Service g1 91 91 91 502030 Penalt Nursing 56 475 i 72 3685 15 890 56 475 72 365 15 890 502040 Penalt Operation Service 9830 10 872 1 042 9 830 10 872 1 042 02330 Mealal Nursing 293 SE 293 293 293 502340 Mealal Operation Service 59 59 59 59 502430 Laundry Allowance Nursing Hr Payroll 3 3 3 3 502510 Rdo Expense Managerial And Clerical 564 564 564 564 502530 Rdo Expense Nursing 8 069 58 069 8 069 6 069 502540 Rdo Expense Operations 1 998 1 998 1 998 1 998 02930 Othall Nursing 891 891 891 881 503010 Annual Leave Manager amp Clerical 2179 228 1 953 2178 226
3. Select your District e g E Division QH ALT 2 EH All Divisions 3 Division Mat Defined Iri Rollup EHE ald Health Area Health Services mold Health Districts HES cairns And Hinterland Hsd ES cape York Hsu EH ES Central Gueensland Hed EE Central West Hsd E ES Children s Health Service EHE Darling Downs vest Moreton HEI Gold Coast Hed EHE Mackay Had P3 Mater Hospital Hsd ES Metro North District ES Metro South District Pa Wtlsa Hsd HE Southwest Hed Po Sunshine Caast vvide Bay Hsd E ES Tarres Hsd BH SI Townsville Hed HES cid Health Shared Service Initiative E ES aid Health Statewide Services D other F I i I Issued August 2012 by the Data Collections Unit Page 22 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j E Division QH ALT 2 All Diversions E ES Division Mot Defined In Rollup E iald Health Area Health services EME aid Health Districts EYES cairns And Hinterland Hsd ES cape York Hsu E ES Central Queensland Had EE central West Hsi EES children s Health Service B3 Darling Downs vest Moreton EYES Gold Coast Hsd EE Mackay Hed EES Mater Hospital Hed ES Metro North District HES Metro South District EHE Mt Isa Hed EYES southwest Hsd ESI Sunshine Coast Wide Bay Hed EYES Torres Hsd BHES Townsville Had EH ES ald Health Shared Service Initiative E ES Gud Health statewide Services GO other Search Ok
4. otal Issued August 2012 by the Data Collections Unit Page 8 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 2 Statement 2 Total Average FTE Total Average FTE alaried Medical Officers 164 2804 egistered Nurses 290 7585 nrolled Nurses 55 7821 udent Nurses rainee Pupil Nurses her Personal Care Staff 23 3444 iagnostic and Health Professionals 69 5236 dministrative and Clerical Staff 113 0396 omestic and Other Staff 166 9476 isiting Medical Officers otal Issued August 2012 by the Data Collections Unit Page 9 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j Statement 3 When you open Statement 3 on MAC Online you can either View All to view all sections on the statement or you can click on the individual Sections of the Statement e g Statement 3 Revenue View All View All rivate and Shared Day Benefit Band 1 rivate and Shared Day Benefit Band 2 rivate and Shared Day Benefit Band 3 rivate and Shared Day Benefit Band 4 her Inpatient Bed Charges rivate and Shared Nursing Home Type ublic Nursing Home Type orkCover Queensland orkers Compensation Other A A AA A A AF AF AF AF en eteran
5. E Eg Oral Health Services Er E Building amp Engineering Service HES Commerical services amp OT Fune Et Emergency Medical Services E ES Health Maintenance Services EF SI Population Health Services ES Residerices General Cancel zi Ensure that the whole financial year is selected eg 2012 Check as DSS may default to the current period if required change and click to year FS Fiscal x Lp emm zu EF S 2010 EH S 2011 Mis F O qu 2014 Io Aug 2011 H sen 2011 I O oct 2711 F O wow 2011 Dec 2011 H Jan 2012 H Feb 2012 HI O war 2012 I O anr2012 HI O May 2012 O Jun 2012 la oos ES 2014 HES other Searc OK Cancel 3 Issued August 2012 by the Data Collections Unit Page 24 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 2011 2012 E Decision Support System Microsoft Internet Explorer provided by Queensland Health Ele Edit view Favorites Tools Help e Back lag x E f JJ Search Sy Favorites ex e fw Address EX http ighdss health qld gov au dss pages tab asp Go Links DSS Decision Support System Navigation Tree Welcome Michelle Anhurtanhurm ly All Dashboard ES HR Payroll SAP Finance Dollars _ Classic DSS Corporate Reports B 5 Basic Reports 5 Internal Order Tax Reports m BS Funding Percentages E FRAC Atherton Hospital Funding Hierarchy 2010 Operating Surplu
6. EJ Fiscal H E 2009 BYES 2010 EH S 2011 OE HES Jul 2011 HEA aug 2011 HEA Sep 2011 HES oct 2011 SHES Now 2011 EH S pec 2011 HE Jan 2012 HES Feb 2012 GES Mar 2012 HES Apr 2012 HES May 2012 HES Jun 2012 HES 2013 EYES other LI searc CK Issued August 2012 by the Data Collections Unit Page 54 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j F Decision Supporti System Microsall internet Feplorot provided by Quearsland Health Tie Td We Frote Took Heb 2 e x Q O Zan Pam frm O SSE 03 scene RE ras Hecho Pets ci cero maf bos pes jos v v ae uw ERAN Geshbeerd DSS Decision Suppart System All Dashbeow cfr Payroll sap 2 J Class DSS LJ Pay vew J Pay Sig Poy Posted TY Fey weeked Por Run Od Huaki District Documeri Tepe Cash v Actual Adrastroert Posting States Control Latour a BS tudast 7E Funding erarcty Reference Proredure Onder Tyne Hierarc ey Payooint Paii penny Tepe Pierarztiy FTE Tyne e mr Analysis Saw Of Labour General Advestan Hosp oF V E payrol Pp reac PRAL Payroll Statement 2 E neterence Tables m E workforce naher 3 Tz Extrait LL user Dipit uw Eglinanes Gellar b FS Asher Based Foreching Eun Opin a an p b ecd Sahir Fache Daio ions 3 map raa Cimer Daa amna 3 41 4r T8 k Amini E aj FRAG Papet 17451 17 851 181 78 fr 1 3 Bulimed medical vicari 418 aIr UREE 2803 E ETE IS r4 3 Emme nura 2571 34857
7. 38 4 560 wd c Manual 8910 dac Mi J Panorama Movavie Ed Microsoft Excel 3 Decision Support Syst Issued August 2012 by the Data Collections Unit Page 44 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 2 Close Select Edit Search for the Not Assigned description or account code Select Members in Account Code and Description Select by members Filter and Sort select members by moving them from lett to right You can also change their order by dragging only if allayy drill is unchecked You can also select their descendants by clicking the right button on members All Aecounts oe 10U0000 Bank Expenditure Account TOO01O Expd Uncleared Cheques 4 00020 Expd Uneleared Bank Dep 1O0098 Bank Suspense dised Onl 4001 00 Bank Collections Account i 100110 Defante Force Bank Acct 2 10 1148 Central Pharmacy Collectie 100121 Co oktewr Collections Sub 19n122 Mossrmiar Collections Sub 9 100124 Teen Dental Plan Coll Sub Sree 4001 27 Cunnamulla Collections s1 E Allow drill down on selected members Cancel Til til Issued August 2012 by the Data Collections Unit Page 45 of 71 Ly Queensland severe DCU Instructions for FRAC 2011 2012 Queensland Health E Search Account Code and Description First search for members by typing either their names or using patt
8. 6 Queensland Government Queensland Health DATA COLLECTIONS UNIT INSTRUCTIONS FOR DSS FINANCIAL AND RESIDENTIAL ACTIVITY COLLECTION FRAC 2011 2012 Instructions and information for Completing FRAC Statements for Reporting to the Data Collections Unit DOCUMENT INFORMATION ISSUE PUBLISHED BY APPROVED BY DATE Version Release A Data Collections Unit Health Statistics Centre Queensland Health GPO Box 48 Brisbane Q 4001 Ph 07 3234 1886 Fax 07 3234 0279 Rod Leeuwendal Manager Data Collections Unit August 2012 DISTRIBUTED TO All contacts for the Financial and Residential Activity Collection in public facilities RELEASE HISTORY Date Release Pages Details Aug 2012 Initial Release Initial release of instructions Ly Queensland Government Gisersland Wealth DCU Instructions for FRAC 2011 2012 TABLE OF CONTENTS Section Page DOCUMENT INFORMATION ieieasovis orae nete vA C HDI VAENC EN etcetera ee 2 FALLE OF CONTENTS S cien E E A A RAT 3 EP icu meer 4 1 1 2011 2012 FRAC Canes scnis einean ea Oa EaR eE EPA N Aane aK a S E a RAAS A 2 ON LINE STATEMENT NAVIGATION 6sisssicisictiscvivsisisvdiee i lositistndieeniiaia ee Retains 5 5Dtatement Te 3 iii eet ssauase ce vassuunicececseneiad annseuacecusanacectcvessscuaiadsunsvenaescssouadececsescerveuseouscsvasine 5 VICIS HITS L1 BP NRI 8 Statement S mr E
9. rofessio nals C1 9 Ad ministra tive and 926 1811 970 5549 clerical staff cC1 9 Do mestic _ and 882 6624 908 3238 other From gqhasvbk dca022 dctuat health gld gov au 487 560 4 707 125 45 248 Ill 14 6567 2 685 029 045 421 445 3 905 730 7668 776 3666 437 730 1 517 116 19 230 076 116 1 903 515 2 030 452 085 1 818 672 28 828 4 wje 2 untitled Issued August 2012 by the Data Collections Unit Page 37 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j 6 Further analysis and necessary adjustments can be undertaken before transferring these figures to the FRAC statements Note ensure that the correct fiscal period has been selected NB e Not Assigned Expenditure Node Within the account hierarchy of QH FRAS there are nodes for Not Assigned Expenditure and Not Assigned Revenue In the main suspense and clearing accounts have been mapped to these nodes As mentioned in Section 3 6 balances that appear against the Not Assigned nodes may be due to the fact that balancing ledger entries are in cost centres outside of the facility s cost centre hierarchy To investigate further you may need to drill down in the Not Assigned nodes on the report Refer to DSS Helpful Hint 2 DSS Helpful Hint 2 To ascertain further information about a Not Assigned F Decision Support System Microsoft Interne
10. 1 361 223 1 238 773 122 450 Payroll amp Fringe Benefit Taxes 18 548 19 257 279 i Non Labour Related Expenditure 6 706 187 5 857 107 749 081 Food Supplies 149 143 128 831 20 311 Other Food Supplies 149 143 128 831 20 311 Precooked Frozen Foods i j Drug Expenses 945 880 1 017 340 71 480 Clinical Supplies And Services 1 859 222 1 722 987 136 235 Non Disposable Inst amp App 41 030 48 212 7 182 Disposables 496 020 430 769 65 251 Dressings Prosthetics 20 418 15 248 5 171 Other Clinical Requisites 148 943 290 753 141 810 Home Medical Aids i Medical Gases 36 845 19909 15 935 Other Clinical Support Req 2 280 2 912 632 External Clin Services Other 395 643 220 979 114 564 External Clin Ser Pathology 779 143 694 204 84 938 Inventor AWO Clin Supplies gt Applet Applet3010 started X Local intranet 2 On the Tool Bar Click on Report Mode Issued August 2012 by the Data Collections Unit Page 26 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j 2i Decision Support System Microsoft Internet Explorer provided by Queensland Health File Edit View Favorites Tools Help e pack gt amp J ix i2 f J Search IF Favorites en x e fwri lud 3 Address EX http ighdss health qld gov au dss pages tab asp Navigation Tree DSS Decision Support System ly All Dashboard BS HR Payroll SAP EPS Finance Dollars W
11. 1 953 503030 Annual Leave Nursing 43 762 45190 1 428 43 762 45 190 1 428 503040 Annual Leave Operation Service 7291 7 609 318 7 291 7 609 318 503060 Annual Leave Visiting Med Officer 474 497 23 AT4 497 23 503310 Lsleav Manager And Clerical 304 314 1 304 314 1 J Local intranet Links a Issued August 2012 by the Data Collections Unit Page 40 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j 2 Decision Support System Microsoft Internet Explorer provided by Queensland Health File Edit View Favorites Tools Help ew o Back gt x E f JJ Search sip Favorites gA t X e hw nal xs Address http qhdss health qld gov au dss pages tab asp v SE Links M a DSS Decision Support System lj All Dashboard E BHR Payroll SAP A amp Finance Dollars E classic ss E Corporate Reports s amp Basic Reports L Account Report Cost Centre Report Welcome Michelle Anhur arhurm Division QH ALT 2 Operating Surplus Deficit Jul 2010 E Cost Centre Account Repo _ Transaction List E Transaction List Detailed B3 Internal Order Tax Reports ERS eer 20 Account Code and Descriptian Actual Budget a th YTD Actual YTD Budget Teas ES Funding Percentages 893828 Hal HitHalwyn Centre 400020 Cwlh Stat
12. 392 666 499 929 107 261 Wea p Shared Day 110 Band 1 67 071 58 329 1 258 Pri vate amp Shared ae and 2 15814 22 138 5225 wate amp Shared Day 112B Band 3 57 910 54 205 3 705 Pri vate amp Shared Day 113 Band 4 4 209 1 004 3 205 Ot ha P M gt sheet 1 1 zi p i e Draw AutoShapess w OO ES iE os 2 Lal O 4 A HEBesa Ready Sum 3192886 92 NUM E3 Microsoft Excel Measures 20by 20Account 20QH _FRAS 20 20Current 20as 20at 2004 20A pr96 20 200 9 1 xls File Edit View Insert Format Tools Data Window Help Tyneaquesticniterhaly we X GREAT SBP Brera WAS og Arial x 10 B TF U EE 95 s ag gop em Mv A ht 2G 8H gel mecs cae A2 fe es A B t D EPE aT aes ST g ae gw m meto Sm EN ea 6j Paw ad wes SIP Ree T 1 M by Account QH FRAS Curent as at 04 Apr 2008 2 ral Ge rr vaca 3 Statementa ee 1 506 043 1531324 85 920 4 __ Patient Payments _ Tw id 5 Accommodation Charges Pall E 86 Private Single s5443 15241 20302 i 7 Private Sha 302 060 409 829 1071264 il 8 m zhat Dar Bandi eror eeszo i258 i 9 Priv ste amp Shared Day Band 40 Private amp SI grad Day B amis 57 510 54205 3 705 11 Private amp Shared Day Band 4 42 Dither In T Mm ERIT lia 13 Private amp Shared Nursing Home 14 ___ Public Nursing Home Type _ 15 a gom 1 Qid 3 4
13. amp 75881 794 33 10 314 07 E UNDEF Undef 35 228 923 89 22144 gt A VMO Vimo 96 999 096 30 307 53 E all FRAC Paypoint 5 518 325 513 80 59 607 63 NOTE This will automatically default to QH_ALT_2 Select your District amp Facility E Division QH ALT 2 FH all Divisions EHE Division Mat Defined In Rollup HES alg Health Area Health Services EHES ld Health Shared Service Initiative EHES alg Health Statewide Services O other Cmm Joe JL cael Issued August 2012 by the Data Collections Unit Page 52 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j Division QH ALT 2 EH ali Divisions E ES Division Mot Defined In Rollup EHE ald Health Area Health Services EH SRESEETUEES EUIS E ES ld Health Shared Service Initiative EH ES ald Health Statewide Services O other E Division QH ALT 2 EH All Divisions EE 3I Division Not Defined In Rollup E ald Health Area Health Services EME aid Health Districts airs And Hinterland Hsd E ES Central Queensland Hed H E Central West Hsi EE Cape York Hsd H S P hildran z Hoalth omire F Division QH ALT 2 EH ali Divisions E ES Division Mot Defined In Rollup EHE ald Health Area Health Services EXE aid Health Districts EH Cairns And Hinterland Hsd HE Atherton Hospital GES Bapinda Hospital pi E3 Cairns Hospital i th Cen CO cm Select your Fa
14. c and health p rofessio nals c13 Ad 14 667 2 6295 harm your computer If you do not trust the source do not open or save this file What s the risk 029 045 421 4455 3 905 While files from the Internet can be useful some files can potentially 730 7668 776 3666 437 730 1 517 116 19 230 ministra tive and 926 1511 970 5549 clerical staff c1 93 Do mestic and S82 5624 908 8238 4 452 085 1 813 672 28 32s 076 116 1 903 515 3 030 untitled EA Microsoft Excel Measutes 20by 20Account 200H_FRASS 20 20C urrent 20as 20at 2004 20Apr 202009 1 xis 1 File Edit Wiew Insert Format Tools Data Window Help T A EMEA l A EE eh MA BU v amp Measures Account QH_FRAS E as at 04 Apr 2009 m E ii Measures p Account cr FRAS Current as at 04 Apr 2008 m att mann ame 2mm et 24 121 172 21 586 840 2 534232 Related sente 4 p 414 984 15 629 833 1 785 152 yr dard 5 fe 14 381 323 13 276 208 1 103 115 1 652 892 1 093 584 On Excel f ate 8 Me 1 361 223 1238773 roll A Fri ringe Benefit 9 Taxes 19 546 19 267 Non Labour Related pare m 706 187 m 957 107 Meu 081 od Supplies d 143 me ga 20 Bs s iS anew 149 143 128 831 20 311 Kx I shoot ij Drawy AutoShapes _ O iB A4 Ek dii aj ed Dr x A te Issued August 2012 by the Data Collections Unit Page 29 of 71 Ly Queensland Government Queensland Health DCU Instructions
15. m Eg eubhc kepam nua ERM Let le Va Poed Dale 248872011 HETEN noun Fai FRAG Payee ozs 4s 408 07 Gunoer unde 026 Wesas r Eramal a neraSenices 9 00 50000 Extamai Unaerinest mam amnarny Replace member Exberral Undefined Bess Eas e FRAC Peeper 3i Decitinn Support Stem Microsoft Internet Explorer provided by Queensland Health De dt Mem Ppob Tools Hein Q O Wi Jm groom O G a iieri AE Mts ani heat ak qo suldesbagesiab ase Sates Uum DSS Decision Support System Sf all fathead 2 PHF Payroll SAP jl Classic 055 Pay View g Par Slip Pay Peitai L8 Pag Worked Pay Run aj Eg neiger rre m RAFTE An lisis a E Easrall reat _ FRAC Payroll Statement 4 EE Relerenes Tables A LI Cowl Haanes dba imari CHA bina inire Documem Tena Cathy Arria Anjusmnart Pnualing Status Canig Lain Ereferemcy Pire guru P rseron Hospital One Tne Haare UNDEF Unda Pimi Higrarctny um of Labour Gne Papini Paid v Uinpohd Eretini Type Hieranim FTE Typo a B3 Workforce Management OTE Patract 3user Defauts a ES finance Dollars EB astvity Based Funding B usar Ophens ES Public Reports Fay Posted TDI ELS UNT Sm Enyce Crap zemsrdu 1 Puran Cate 2009 2011 248 52 PM GH FTE Gal EBAC Peon E pi DUGE Dr WpmarGenera ems Los SURE Ut Edpral Undefined 1k Cisk Eef amim akimi xm OdErnmai Genaral Sar raz nog 8005 07 E umDEF Ledai 49 500 00 amis External Genial Eendces D MCE External na
16. which leaves out any incompatible features click Yes To preserve the features click No Then save a copy in the latest Excel Format To see what might be lost click Help 5 Further analysis and necessary adjustments can be undertaken before transferring these figures to the FRAC statements Issued August 2012 by the Data Collections Unit Page 30 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j F3 Microsoft Excel Atherton FRACO910 Finance xls File Edit view Insert Format Tools Data Window Help GE Gay BY o 4 zi dallo D Arial gt 10 B 7 U matt abal c ha a m g Statement 1 Expenditure Lt HERENNIUM Ooo ee e O Ooo S S 20 418 15 248 54171 148 843 290 753 141810 qp qp Jj p eee i i Hardware And Crocker Laundry Materials ee REED Cleaning Materials Other Domestic Cans amp Charges Contract Laundry Services EC Te ee Contract Cleaning Services Other Contract Domestic Serv Uniforms Minor Non Clin Equi Repairs And Maintenance Building And Plant General Office Equipment ical Equipment Minor New Works 1 90158 90458 43 Grounds And Gardens de 44 Motor Vehicles 45 Other Repairs And Maintenance 48 Fuel Oil 1223 1223 Other Energy Expenditure Patient Transport Patient Transit Scheme pro doc Patient Transfers Other Patient Transfer Costs Lud Administration Expenses Dhs Expe
17. 0814 m CLE Gane personal eae iin iHi 1m 322 48 B es T Diagnose aed hia pmipan sealr 3479 1683 78055 iciBAdminikubee ahdrencw aM yaru 4091786 IB 61 g Demect and eim i dta 4020 1280818347 E LIHTIEF Liter n3a smsnsar uua vna 04a Tea Tot aa Add FRAC Class Select Dimensions Select Dimensions my EH SI account EHES Adjustment EE ashy Accrual EYES cost Centre EH SI Division aH ALT 2 EYES Division aH ALT 7 EH SI Division iH HLTH mE Document Type HES Employ Type EH S Employee EYES FTE Type EH SI internal Order Measures EYES Paypnint EH S Period EYES Position EEA Posting Status EYES Reference Procedure Issued August 2012 by the Data Collections Unit Page 55 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 2 A Select Dimensions la All Dimensions l a nee a st gt Fg EH S account EES Adjustment EE Cash Accrual EYES cast Centre EH SI Division GH ALT 2 EES Division aH ALT 7 EES Division HLTH EHE Document Type EES Employ Type EHE Employee EYES FTE Type EH SI internal Order Z Measures EH Paynnint da FRAG Class FRAC Paypolnt E Government Report aa Pavpoint Paypoint Code a Paypoint Code and Description lt Clase UE riers a ee ee ee Issued August 2012 by the Data Collections Unit Page 56 of 71 Queensland Government Queensland Health DCU Instructions
18. 10 Statement 7 4 ooi redeo E Tii D HET MIU I PI IRI MI MEME 12 elbirgittac i eU CPU TU 14 J NAVIGATION OF DSS FRAC REPORTS AND HANDY HINTS eee eere eene 16 3 1 STATEMENT 1 TOTAL EXPENDITURE ccccccssosssccccesscoossccccesscoosssoccesessosssoceessssssssscees 16 3 2 STATEMENT 2 FTE AND LABOUR EXPENSES BY STAFFING CATEGORY 49 3 3 STATEMENT 3 TOTAL REVENUE iiiter er a a Ya oer aada aaa eo Eie Eres 63 Jd DSS RODOFIHP 52i REGI DEN ien i Dit Ge us MI anes 71 Issued August 2012 by the Data Collections Unit Page 3 of 71 Ly Queensland Government serian Health DCU Instructions for FRAC 2011 2012 1 Introduction 1 1 2011 2012 FRAC Changes The Data Collections Unit DCU Health Statistics Centre implemented a web enabled application called MAC Online in July 2010 which is currently being used by Hospitals and Health Services to report their monthly activity data This same functionality has been enhanced to enable Hospital and Health Services staff to report their Financial and Residential Activity Collection FRAC data for 2011 2012 onwards It is envisaged that the new FRAC collection methodology will greatly assist facilities with reporting Improvements to FRAC include Access via an online application Improved security and user access controls Transparent version control of submitted statements On line validations and comments at time of submission Statements 1 2
19. 3 625 3 000 60 95 30 30 30 YTD Actual YTD Budget 1 329 3 625 3 000 60 95 30 30 30 839 490 3 625 3 000 60 95 30 30 30 To ascertain this information you are required to firstly identify the account code and description This can be done by Go to Basic Reports Cost Centre Account Report Issued August 2012 by the Data Collections Unit Page 39 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 2011 2012 Decision Support System Microsoft Internet Explorer provided by Queensland Health File Edit View Favorites Tools Help o Back x E f ps Search sip Favorites R M e wi ld 5 Address EX http ghdss health gld gov au dss pages tab asp DSS Decision Support System Navigation Tree y All Dashboard E E HR Payroll SAP gr Finance Dollars E classic ss E Corporate Reports ee Basic Reports L Account Report E Cost Centre Report E Cost Centre Account Repo _ Transaction List Ln Transaction List Detailed E E Internal Order Tax Reports E Funding Percentages B3 FRAC E Reference Tables i _ User Defaults m ge Pathology BS User Options m E93 Public Reports s i 4 amp Applet Applet3030 started Division QH ALT 2 Operating Surplus Deficit Jul 2010 Welcome Michelle Arthur Carthi rrr ant E
20. Corporate Reports i Pa Basic Reports E31 Internal Order Tax Reports K 25 Funding Percentages B E FRAC O FRAC Finance Statement EN Prev Year Prev Year 4 RUN i AA m Reference Tables _ pnt PE Lr Statement _ User Defaults 4 B3 Pathology Labour Related Ex 5 user Options penditure E3 Public Reports Payroll Expendi ture Labour Expend Ext Age nay Con tr Ex Gratia P ayments To Staff Supera nnuatio n lis 56 457 56 457 Payroll amp Fringe Benefit Taxes Non Labour Related Ex penditure Food S upplies Othe 56 457 56 457 r Food Sup plies Prec ooke d Fro zen Food Applet Applet3010 started J Local intranet B R EEE RR E D y L Click on the Excel Export button Issued August 2012 by the Data Collections Unit Page 66 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j F Decision Support System Microsoft Internet Explorer provided by Queensland Health File Edi few Favorite nals talp 3 a D A Y Oo Back x E f Search Sr Favorites Gays fi imi xs Address http qhdss health qld gov aujdss pages tab asp v Go Links Navigation Tree s x DSS
21. D pun 951 DO1 Athe Tmt Ward Medical 577480 Intradept Shared District Services EEI 939 p 1 329 839 490 951002 Athe Tmt Ward Surgical 577460 Intradept Shared District Services 3 625 3 625 3 625 3 625 961 004 Athe Eme Emergency Medicine Outpatients 577460 Intradept Shared District Services 3 000 3 000 3 000 3 000 951205 Athe All Occupational Therapy 577460 Intradept Shared District Services 60 60 60 60 351215 Tbl Blg Management And Support Services 577460 Intradept Shared District Services gs 95 95 95 951503 Athe Mgr Medical Clinical Administration 577460 Intradept Shared District Services 490 190 190 190 851505 Athe Sup Medical Records 577450 Intradept Shared District Services 30 30 30 30 957251 Athe Orl Dental Health 5774650 Intradept Shared District Services 30 30 30 30 957253 Athe Or School Dental Health 57 7460 IntradeptShared District Services 30 30 30 30 2 Applet Applet3030 started 3 Local intranet v A User now has further information as to how this amount has come about and will be able to determine the appropriate action This information can also be used to track down information in the Financial and Materials Management Information System FAMMIS as to the invoice Expenditure Statement 1 or receipt Revenue Statement 3 Issued August 2012 by the Data Collections Unit Page 48 of 71 Ly Queensland SENSIT DCU Instructions for FRAC 20
22. Defaults from the dashboard The example below shows the User Defaults for the logged in DSS User is set as Division QH_ALT_7 Note HR Payroll SAP User Defaults is being used for the example below As this does not update each section of the dashboard you will also be required to update your User Defaults for Fin ance Dollars as well Issued August 2012 by the D ata Collections Unit Page 34 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j Navigation Tree DSS Decision Suppo H Sy stem cj All Dashboard Ei FS HR Payroll SAP E HR Payroll Updates Classic DSS Pay View Pay Slip Pay Posted Fay Worked Pay Run Division P3 Budget FTE Employ Type Ba FTE Analysis Pay Posted Date A2 Fayroll PS FRAC ES Reference Tables E Workforce Management 7 User Defaults User Rollups Rollups are saved automatically when a selection is changed Associated dimensions below are switched ta use the selected rollup When blank the system default iz used 2 a B3 Finance Dollars Employ Type terah al Pathology cae User Options m E3 Public Reports Measure Account Document Type FTE Type Paypoint Paid v Unpaid Period current Previous syster To change the default select down arrow for Division in the User Rollups section Select QH_ALT_2 from the drop down list Issued August 2012 b
23. E herena Tables a FS Workforce Management E T Extract LU User Defaults zi E Finance Destars 3 E Activity Based Furidmg 4 user Options 3 EE Pubbe Reporta Io BAT SEE 1 Ub LILT sanini TU H Hof hi Dreirict D rumernt Tyne Gash Acendal Adiustmaent Posting Sui Cahirel Laer fume Even Papasa Dale 1001 GHETE amount E Ag FRAC Parrot 28 saata E umpir Under 0 28 BEAQSDT Edemal meralBenies Qi T0500 Baena Ursdetreed Wi negar x E A onde qua Ape m a Aen evans d Deion Support Slem Turo internet Laplorer provided by EIS T TE Health a ei De QE Yew Fomai o Tods jeb Qu O id f 59 gone O S 8 Ue Agsen AE hinh esce cre alid genit lont EN DSS Decision Support System all Dashboard zi fe Hn Parer sap Lj Chez DSS ati SSS a c UN ee val Pag Sip Far Potent i c vA 1 i E 79 hap Worked Pay Huni Fath HU Hasin District D rumernt Type ashy Acendal Adjustment Posting Saivi Conny La amp cur m EE budget rre Funding Beain Hem ong Procedure Qader Ting Hibraet Es Pairi Parav ipai Emgse Typ Higar UTE Typu m ES rE Anaigeis uam of Latur mera Artwrian lcgi al LFF ibarot Papok Cada and Deurrgson m tapos F aminci Donanainen Pm rmAC _ RAC Payroll statement im EG Reference Tablas a FS Workforce Management Cj T xiract FRAC Clase J User Defaulis Pel FRAG Paypnini zi E Finance Daisrs HE oesinmontEaron 3 E Activity Based Furidmg Paral N Par C 3 El
24. Ly oon een DCU Instructions for FRAC 2011 2012 Statement 1 Labour Related Labour Related Payroll Expenditure abour Expenditure External Agency Contract Staff Gratia Payments to Staff Superannuation Employer Contributions Payroll and Fringe Benefits Tax abour Related Total Issued August 2012 by the Data Collections Unit Page 6 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 2 Qo hj D 3 D 5 3 r Q gt Q Imm a S D Q g Q Q e Es S D 0 Non Labour Related Food Supplies Other Food Supplies Precooked Frozen Foods ood Supplies NLR Total Issued August 2012 by the Data Collections Unit Page 7 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j Stalement 2 When you open Statement 2 on MAC Online you can either View All to view all sections on the statement or you can click on the individual Sections of the Statement e g Statement 2 View All View All Salaried Medical Officers 164 2804 Registered Nurses 290 7585 nrolled Nurses 55 7821 Student Nurses rainee Pupil Nurses Other Personal Care Staff 23 3444 Diagnostic and Health Professionals 69 5236 Administrative and Clerical Staff 113 0396 Domestic and Other Staff 166 9476 isiting Medical Officers
25. Statement 1 after logging into the DSS production account refer figure 1 Figure 1 Logon to DSS DSS Decision Suppor System Issued August 2012 by the Data Collections Unit Page 63 of 71 Queensland Government Queensland Health QH FRAS Refer figure 2 Figure 2 Zi Decision Support System Microsoft Internet Explorer provided by Queensland Health DCU Instructions for FRAC 2011 2012 File Edit Back View X Favorites Tools Help x a f pe Search SJ f Favorites gA m e fri lud 3 Address B http gqhdss health ald gov au dss pages Jtab asp DSS Decision Support System Navigation Tree All Dashboard BJ HR Payroll SAP Ef Finance Dollars Welearme Michelle Arthur Carihiurm L Classic DSS Atherton Hospital Funding Hierarchy 2010 Operating Surplu B3 Corporate Reports aB Basic Reports B3 Internal Order Tax Reports B3 Funding Percentages E Po FRAC FRAC Finance Statement Prev Year PS Reference Tables RAHE Actual eid Actual i H User Defaults Current Date 09 08 2010 11 58 34 AM Actual Var Pathology Statement 1 24 121 172 21 586 940 2 534 232 5 user Options Labour Related Expenditure 17 414 984 15 629 833 1 785 152 5 Public Reports Payroll Expenditure 14 381 323 13 278 208 1 103 115 Labour Expend Ext AgengyContr 1 652 892 1 083 584 559 308 Ex Gratia P
26. Workers Compensation Other 55 55 Ineligible Non Admitted 26 959 11 592 15 367 Other Patient Related Revenue 417 535 333 442 84 194 m Revenue Retention Proportion Return Ta T Pharmaceuticals 36 089 39 203 3 114 m amp Applet Applet3010 started e 3 Local intranet To retrieve Revenue info only Select Revenue via the Account tab Account EH All Accounts EHS PrIncome EHS Total Gurplusy Deficit Lum Operating aurplusDeaficit HE Expenses BES Mon Operating flows VOuTows EHE Administered Statement EH E 3 Administered Revenue 3 Administered Expenses E ES Accounts Not Defined In Rollup O other Issued August 2012 by the Data Collections Unit Page 65 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j 1 To scroll down further click on the down arrow on the tool bar On the Tool Bar Click on Report Mode 2i Decision Support System Microsoft Internet Explorer provided by Queensland Health File Edit View Favorites Tools Help e o Bak J ix E f5 Search I7 Favorites gA 2 M e wi Address E http qhdss health qld gov au dss pages tab asp i v Ee Links Navigation Tree ss 2i DSS Decision Support System Welearme Michelle Artur Carthurm y All Dashboard BSHR Payroll SAP Ef Finance Dollars j Classic DSS Atherton Hospital Funding Hierarchy 2040 Revenue B3
27. aw P aw w 1 hz P dw T aw T User defaults are optional When left blank the system defaultis used Division GH ALT z Employ Type Hierarchy Measure Account Document Type FTE Type Paypoint Paid v Unpaid Q current previous 9 System Th Panorame Saved View Micresoft Interner Explorer previded by Queensiand Heslih File Eat fie Pavortes mools Helg ar oS Back QQ o iz Las Po Search se Favorites E2 E as Land rss Address http iqhasyvbk Fdca022 dctuat health qld gov aufPanorams NET WwebUl Modules Novaview Savedview aspx Mode SavedviewSwebpartquid CBE0238B B865 44783 B137 8F7542E0C266 7C1laus Ww Go Like 7 SS Metro Nth Royal Brisbane amp V omens Hosp 2009 Employ Type Hierarchy FTE Type Account j Do you want to open or save this file C1 1 Sa laried 3 medigal 90 EL Ere Bes Name by FRAC Paypoint Current as at 10 Feb 2009 xls 595 505 1 495 646 219 346 officers Type Microsoft Excel Worksheet C12 Re gistered 2 201 4520 2 304 2502532 nurses rolled 148 5832 148 4780 pae Cancel 140 492 207 029 2 575 nurses o1 4 Student 0 1547 nurses While files from the Internet can be useful some files can potentially c16 harm your computer If you do not trust the source do not open or Otherp save this file What s the risk ersonal 201 5002 200 5288 care staff C1 7 Di agnosti c and health p
28. for FRAC 201 1 20 1 2 Microsoft Excel Microsoft Excel Measures 20by 20Account 200H_FRAS 20 20Current 20as 20at 2004 20Apr 202009 1 xis i File Edit View Insert Format Tools Data Window Help Type a questi al 0x GEeE vy X Bags o amp x i dai 2 fii 0 BID E e E B ss 43 SH s5 5 A fa cas A ji ve ha A fe Massos by Account QH_FRAS Current as at 04 Apr 2009 D F G H J K L Y N 0 P Q b Actu Gn ES Current as 04 2003 E a 3l P i 13 24 121 172 21 556 840 HM Save As Save in Manual 7 amp a X 5 Tools ET 17 414 984 15 529 833 14 381 323 13 278 208 T History 1 552 892 1 093 584 in Ee My Documents Be Desktop kl File name Atherton FRACO910 Finance xls le Network gt le Save as type Microsoft Excel 4 0 Worksheet xls Cae 1 361 iie 1 238 773 19 546 19 es 6 706 187 TS 957 107 e 81 t 149 143 128 2 mS es 149 143 128 831 sheet 17 l lt 4 Draw y AutoShapes ORBja4i siS8uo5 A z iBK Ready l Sum 146063424 8 NUM 7 taj Manual 910 doc d Decision Support 5 A http ahdss healt Novell GroupWise Fd Microsoft Excel M go S Sia XN E T 11 21 AM Atherton FRACOSU Finance xls may contain Features that are nat compatible with Microsoft Excel 4 0 Worksheet Do you want to keep the workbook in this Format To keep this formak
29. have been made to the HR Payroll SAP module on 28 07 2010 Please click here to review the release notes pss Ea Rested You are asked to replicate any relative private briefing books from the Lattice HR Payroll module and convert to the new HR Payroll SAP Pay Worked Pay Run module as the Lattice HR Payroll module will be switched off in July e E Budget FTE Given there are over 276 000 private briefing books applicable to the old Lattice HR Payroll module we are unable to convert these report aB FTE Analysis All Public reports have been converted to the new HR Payroll SAP module If you experience any difficulty please contact the DSS Support mE3Parroll l un We look forward to your continued cooperation arrac mE Reference Tables Rel mE Workforce Management gt T2 Extract DSS Helpful Hint 1 Prior to running any reports in DSS it is important to ensure that your Global Preferences Global Settings are set up as per the diagram below DSS Decision Support System Global S ettings Shaw only Siblings L View totals To check your default Global Preferences Global Settings Select User Options Select Global Preferences Issued August 2012 by the Data Collections Unit Page 17 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 2011 2012 Navigation Tree e a DSS Decision Support System lj All Dashboard ES HR
30. 1 7 509 318 7 291 7 609 318 03060 Annual Leave Visiting Med Officer 474 497 23 A74 497 23 503310 Lsleav Manager And Clerical 304 314 10 304 314 10 wv uw a 4 Applet Applet3030 started J Local intranet Select District Facility Default Hierarchy should have been set to QH ALT 2 if not refer to DSS Helpful Hint 1 Issued August 2012 by the Data Collections Unit Page 41 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j F Decision Support System Microsoft Internet Explorer provided by Queensland Health File Edit View Favorites Tools Help ae Back eJ ix a L JJ Search IF Favorites gA m B wi lad 5 Address E http ghdss health qld gov au dss pages tab asp Go Links Navigation T 2 eit ares m ul DSS Decision Support System Welcome Michelle Anhur arthi rm y All Dashboard BS HR Payroll SAP Ei Finance Dollars jj Classic DSS B Corporate Reports B amp Basic Reports d Account Report E Cost Centre Report Atherton Hospital Operating SurplusyDeficit 2010 E Cost Centre Account Repo _ Transaction List EH NC Transaction List Detailed e Internal Order Tax Reports E Funding Percentages BS Frac Reference Tables i User Defaults E Pathology B3 User Options PS Public Reports l Applet Applet3030 started a Local intranet v amp amp Decision Support System
31. 11 2012 Queensland Health 3 2 STATEMENT 2 FTE AND LABOUR EXPENSES BY STAFFING CATEGORY An updated report has been developed in the Decision Support System DSS to assist Hospital and Health Services with extracting data for Statement 2 if required The new report DSS FRAC Payroll Statement version 2 is situated in the HR Payroll SAP folder of the DSS Navigation Tree To extract the data for Statement 3 1f required apply the following selections after logging into the DSS production account refer Figure 1 Figure 1 1 Logon to DSS DSS Decision Support System Issued August 2012 by the Data Collections Unit Page 49 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 2 1 DSS Home Page displays E Decision Support System Microsoft Internet Explorer provided by Queensland Health File Edit view Favorites Tools Help aw Ow O DAD Pat trem 6 8S w OS Address http qhdss health gld gov au dss pages tab asp pach apa ae DSS Decision Support System Welcome Michelle Athur arthurrn ly All Dashboard ES HR Payroll SAP IIE Parisi LAAIE Poi HR Payroll Updates l z Pay Slip Pay Posted E Pay Worked Pay Run omo BS Budget FTE m Bs FTE Analysis a3 Payroll BB Frac m Reference Tables i B Em Workforce Management T2 Extract User Defaults aE Finance Dollars a Pathology a Use
32. 20 1 2 162 Office Equipment ee ee 163 Furniture amp Fittings uq Jd LL er a _NotAssined SSO 228 2382 Not Assigned Inst Hospital Fees Instate Payment Nt Intermittent Care Fees Fees Disposal Of Propert Inve VVriteoff Engineering Stores Purch Interest Finance Leases Qtc Market Value Adjustment Suspnc General Suspnc Qld Credit Card Purchase Holding Corporate Card Suspense 2056 Suspne Journal General ede 207 Paysus Lattice Interface Offset NENNEN MEE IER 208 Note ensure that the correct fiscal period has been selected Issued August 2012 by the Data Collections Unit Page 33 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 2011 2012 Ed Microsoft Excel Atherton_ FRACO910 Finance xls Gd File Edit View Insert Format Tools Data Dame aay t BIB o Al X A pur a WD et Ei 1 2 Actual Prev Year Actual Prev Year Actual 3 Statement 1 4 Labour Related Expenditure 5 Payroll Expenditure B Labour Expend Ext Agengy Cuntr 7 Ex Gratia Payments To Staff REET o c wc ER B Superannuation g Payroll amp Fringe Benefit Taxes 10 Non Labour Related Expenditure 11 Food Supplies 12 Other Food Supplies 13 Precaoked Frozen Foods aa See i ij 14 Drug Expenses 15 Clinical Supplies And Semices 1B Non Disposable Inst amp App 17 Disposables 18 Dressings S25 ae ee 19 Prosthetics 20 Other Clinical Requisites 21 Home Medical Aids 5 eS S
33. 3 Corporate Reports m ES Basic Reports amp i E3 Internal Order Tax Reports LI dir _ FRAC Finance Statement FH Reference Tables __ User Defaults F E Casemix m User Options El E Public Reports Walcame David Kearney kearreyd Funding Hierarchy 2009 Operating Surplu Prey Year Prey Year Actual Actual Actual 7 130 486 166 6 451 205 382 679 280 784 4 758 790 754 4 228 459 810 531 330 944 4 145 389 794 3 858 529 907 486 869 887 18374 793 197 711 278 13 736 485 2 911 B77 2 234 407 903 789 352 215 047 45 699 742 22 509 468 20 002 900 2 506 568 2 370 895 412 2 222 745 572 147 949 840 50 230 831 45 082 045 5 168 585 44174 558 39 406 047 4 769 612 5 055 973 6 656 999 399 974 292 552 577 269 215 807 24 336 769 Statement 1 Labour Related Expenditure Payroll Expenditure Labour Expend Ext AgengyiContr Ex Gratia Payments To Staff Superannuation Payroll amp Fringe Benefit Taxes Non Labour Related Expenditure Food Supplies Other Food Supplies Precooked Frozen Foods Drug Expenses Select your Funding Hierarchy Refer to DSS Helpful Hint 1 Figure 1 DSS Decision Support System Welcome Michelle Arthur rarthurrm Slicers Division i H ALT z Funding Hierarchy Jul 2010 Operating Surplu Prev Year status Current Date 04 08 2010 11 27 05 AM Statement 1 Labour Related Expenditure Payroll E
34. 4 Land eee Buildings 1 I Proceeds Clearing Accounts Medical Equipment 200000 Medical Equipment 200000 83 Suspnc General Doo 1 84 Suspne Qld Credit Card Purchase I wq d 5 85 Corporate Card Suspense oo oL LLL 86 Suspne Rannip Nurses Prof Dvlpmnt Ee 87 _ Suspense Prime Vendor a ee 88 Suspne Travel Manager Suspense mn EE EEG 89 SuspneUnpresented Cheque Clearing sd 90 _ Paysus Net Pay Suspense o es ee 91 Paysus P ayroll Suspense Ooo es 92 PaysusDeduction Suspense Po 93 Paysus Lattice Interface Offset 310p ee 94 Paysus Lattice Uncosted Pa Doo o o o 5 95 Paysus Caspay Interface Offset C ee 96 Xman Suspense E O 97 Control Business Area Clearing fd 98 Invsus Stores Purchases O o 99 Invsus Issues Expense o 100 Bnksus Clearing Debit Balance o 101 Allocation Of Corporate Services Eo 102 Ssp Revenue Linen Services o O O 103 Ssp Linen Service Charges O 104 Suspne Journal General sd 105 Paysus Lattice Interface Offset 106 Y 4 gt nNsheet 1 Uu mM l i E acd f em HEN i of Drawy y AutoShapes NV amp LIOA ASB O Z A S3 S5B Ready NUM Further analysis and necessary adjustments can be undertaken before transferring these figures to the FRAC statements Issued August 2012 by the Data Collections Unit Page 70 of 71 Ly Queensland Government userstand Health DCU Instructions for FRAC 2011 2012 4 DSS Reporti
35. 8 i jer Dither 1t m Tr SL 19420 1880 280 48 Inelig bie AdmiRed 18 Veterans Affaus Inpat Fees IM 20 fo Admited Pabent ches 21 cbg Non Admitted Pati Fs ee a 22 2 Mates Com ansation Other 23 Ineligible Non Admi fed 26959 me 15387 24 Dther Pa SM Raitaa Gave ue 25 Revenue Retention Proportion Return D zs dE o E 26 pisei 27 aTr ae Jl l j X 28 sait h Nuts Home Extens Care a a 9 28 sing Home Pat Accom Fees ue eee Se 30 Nulsing Heme Fatt ents nn i ee 31 An 2 tation Fees oe ole Fo 32 Patient Tran ET e Charges o O_O 33 Prosthesis 885 34 _____D Comp Admitted Patie nt Fees D a ee EEENMEENL S 35 Hospi al Pees Int Payments ag ee 38 Pharm sal Benefit Sche e i o ek 37 Otherk i 38 F meae __ 10 170 __17812 27 984 39 igh OF Pi ie Practici 40 Board amp Lod a Staff ET a T a Mea er a Ce 42 Medical Rer ots a3 Ohe Revenue 44 __ Asset Related Revenue 2 935 noj 2 825 46 Gains Or Dizhosal Df Assets I o ap Ce 48 Medical Equipment 200000 ER wp o o ov 47 Medical Equipment lt 200000 ey ee 48 Computer Hardware amp Sof i 49 Office Equipment Issued August 2012 by the Data Collections Unit Page 69 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j 50 Furniture amp Fittings y O Cid 51 Engineering Equipment PF O O 52 Motor Vehicles C ee ee 53 Land Improvement On Site es SL LLL 5
36. 96 202009 1 xls nal T 2 m x File Edit View Insert Format Tools Data Window Help cnay tpe amp x 5 31 fis 43 100 3 Arial 0 gt BLU Ej s 53 EEL LAAs cy fta fa By Cai E R gA l enkas Enie AT X f Measures by Account QH_FRAS Current as at D4 Apr 2009 HDRNEEASSUITMTTNNESNAEDEE O E aaam ee ee r0 Ee oT E a Ks Measures by Account QH FRAS ee as at 04 Apr 2009 al od 11 Supplies ther E 12 Su pes reed nd e M4 gt w sheet1 4l ife Draw AutoShapes a L1O B4 7 i2 asl D L A TEI pe e NUM d REP S LES RY ep i220 Pm Ready ul Manual 0910 dor Mi E Microsoft Excel Meas E Decision Support Syst yy http ghdss health Scroll down to Statement 3 and delete the rows prior to this Issued August 2012 by the Data Collections Unit Page 68 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j E3 Microsoft Excel Measures 20by 20Account 20QH_FRAS 20 20Current 20as 20at 200496 20A pr96 20 200 9 1 xls File Edit wiew Insert Format Tools Data Window Help 3 Question re hel _8x SHA SRY XS BIB o wr Fl MA 0 Arial 0 BLU BIZ SHS WY EEO 5 A ta fea Tat IEEE E e EAs f Statement 3 J Te E re B 1 531 324 65 120 ha 106 atm ments 1 175742 1 148 456 27 285 ACC pre 107 Chart Em EA 202 me 23 ES D71 wate 108 Single t wn A43 mw 241 EN 202 108 Sard _
37. Cancel Select your Facility e g ER Division QH ALT 2 FH all Divisions E53 Division Hot Defined In Rollup HE Ald Health Area Health Services EME old Health Districts CHE Gaitis Ang Hinterland Hsd HPS Alherton Hospital GES gabinda Hospital EHE cairns Hospital EYES cairns Trust Funds tEF ER Community Services BES Community Services EF ESI community Services Er E District Vide Services BHES District wide Services HES Gordonvale Hospital EEF Eg Herberton Hospital r E Information Marat eysterms nit GES innistail Hospital EF Snnistail Trust Funds EER Mareeba Hospital EES Mossman Hospital EFE Pathology Services BHES Pathology Services L d Issued August 2012 by the Data Collections Unit Page 23 of 71 Ly Queensland Government Queensland Health E Division GH ALT 2 FH ali Divisions DCU Instructions for FRAC 2011 2012 EH ES Division Mot Defined In Rollup i ld Health Area Health Services Old Health Districts 1 cairns And Hinterland Had Atherton Hospital na FA Allied Health Services 9 Athe Patatherton Pathology IL Alh Gbs Lilniversal Postnatal Contact Ser HES Hotel Services EB Obstetrical Services HES Pathology Services H E Pharmacy Services P E PS Support Services ES treatment Serices l Babimda Hospital Cairns Hospital 1 HHHH HHHH HHHH HHHH HHHH HHHH HES Managerial Services HES Medical Imaging amp Diagnostics
38. Decision Support System Welcome Michelle Arthur arthur yj All Dashboard IHR Payroll SAP B F Finance Dollars a Classic DSS Atherton Hospital Funding Hierarchy 2040 Revenue Ba Corporate Reports B3 Basic Reports B3 Internal Order Tax Reports Funding Percentages FRAC FRAC Finance Statement 3 htip qh ss health dld gov au panporama connector dil MictSAP Command Dowriload io x 3varite ol Heir M Bad gt x E A Search Sg Favorites B ue E Lal 3 File Download File E dil vie F uu f aB Reference Tables i i User Defaults B Pathology Do you want to open or save this file E User Options RE Public Reports a Name Account QH_FRAS Current as at 04 Apr 2009 xls LN Type Microsoft Excel worksheet From ghdss health gld gov au harm your computer If you do not trust the source do not open or While files from the Internet can be useful some files can potentially save this file What s the tisk lt i LLL 2 Applet Applet3010 started start E E Decision Support Syst i http ahdss health q Ww Manual 0910 dac Mi Ea This will open an Excel Spreadsheet and transfer your report Issued August 2012 by the Data Collections Unit Page 67 of 71 Ly Queensland SENSIT DCU Instructions for FRAC 2011 2012 Queensland Health EEk E3 Microsoft Excel Measures 20by 20Account 20QH_FRAS 20 20Current 20as 20at 2004 20A pr
39. Microsoft Internet Explorer provided by Queensland Health File Edit View Favorites Tools Help C9 sack x ia 5 pa Search xr Favorites 5 A s ddress Ey http ighdss health qld gow aujdss pagesitab asp m j S sesti DSS Decision Support System Aur ati y All Dashboard H I HR Payroll SAP Be Finance Dallars n Classic DSS m B3 Corporate Reports EE Basic Reports LIT Account Report Atherton Hospital Operating Surplus Deticit E Cost Centre Report Cost Centre Account Re a Transaction List Transaction List Detailed i B Internal Order Tax Reports 4 E3 Funding Percentages nE FRAC P Reference Tables iR User Defaults H E Pathology fat E User Options Xil lili Applet Applet3030 started J Local intranet Issued August 2012 by the Data Collections Unit Page 42 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 2 Select Dimensions A Select Dimensions la All Dimensions a4 s EES account EYES Account GH _FRAS EH S cost Centre EYES nivision GALT 3 EES Division aH ALT 7 EHEJ Division aH HETH E Measures EH S Period HES value Type Expand QH_FRAS Issued August 2012 by the Data Collections Unit Page 43 of 71 Queensland Government Queensland Health pr Select Dimensions ta All Dimensions EH S account EHE account 4H FR S amp FF Account Code and Description Accou
40. ORKSHEET abour Related 341601798 384253 183293405 201588 null 524895203 585841 on Labour Related 141436587 149455 75990685 784078 null 217327272 227863 Asset Related 23011518 186161 12347299 976643 null 35358817 283825 stimated Expenditure on Services Facility Calculated 506049903 552325 271531389 289762 snur 0 sr77581292 842087 This worksheet allows you to estimate the cost split across each of the 3 services for the financial year The associated figures will automatically be carried over to the above section Value of previous period 01 JUL 09 to 30 JUN 10 Issued August 2012 by the Data Collections Unit Page 15 of 71 Ly Queensland Government serian Health DCU Instructions for FRAC 2011 2012 3 NAVIGATION OF DSS FRAC REPORTS AND HANDY HINTS 3 1 STATEMENT 1 TOTAL EXPENDITURE A cost element hierarchy called OH FRAS is available in Decision Support System DSS to assist Hospital and Health Services with extracting data for Statement 1 1f required This hierarchy has been incorporated into the DSS FRAC Report which is situated in the Finance Dollars folder of the DSS Navigation Tree Refer to Section 9 for information on QH FRAS To extract the data for Statement 1 and Statement 3 Refer to Section 6 3 STATEMENT 3 TOTAL REVENUE using QH_FRAS apply the following selections after logg
41. Payroll SAP m Es Finance Dollars pa a Pathology F Global Settings User Options uo Request Module Access 4 Shaw only Siblings Links a Wi total Change Password TS SR Global Preferences Training CBT Coordinator Access Report Nc Report Bug ar Enhancement 2 _ Book DSS Training _ Surveys ae Public Reports From the diagram above you will notice the DSS User does not have any selections in their Global Preferences Global Settings To adjust the Global Settings View totals select Top from the drop down list Navigation Tree y AI Dashboard pj ES HR Payroll SAP aE Finance Dollars H Pathology SS j Global Settings Ej Fo user Options E Request Module Access E 3 Show Only Siblings 4 Links a View total m Change Password iew totals B UNE 1 Tag Training CBT gt Coordinator Access Report Report Bug or Enhancement Baook DSS Training _ Surveys ij Em Public Reports Select Save Issued August 2012 by the Data Collections Unit Page 18 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 2011 2012 Navigation Tree zy all Dashboard a ES HR Payroll SAP m Em Finance Dollars a E3 Pathology DSS Decision Support System Nona ES E G bal Settings pm User Options Request Module Access Shen pales tee Change Password Is tires _ Global Prefer
42. Renal Dialysis Unit cute Spinal Cord Injury Unit IDS Unit Icohol and Brug Unit urns Unit Level Ill ardiac Surgery Unit linical Genetics Unit omprehensive Epilepsy Centre oronary Care Unit iabetes Unit omiciliary Care Service eriatric Assessment Unit ospice Care Unit Issued August 2012 by the Data Collections Unit Page 12 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j Statement 7 Specialised Services OrCVIALIOCY ODETXVIV DIO IINLDIVAID VVPICITIETX ORM NYI IMC TAVIT MAO YINI IOAR PUM IMCOC SF TEVIREISELD OCMVILCO LISTES Z INUJ Specialised Services Acute Renal Dialysis Unit 2 Acute Spinal Cord Injury Unit 2 AIDS Unit 2 Alcohol and Drug Unit 2 Burns Unit Level III 2 ardiac Surgery Unit 2 linical Genetics Unit 2 omprehensive Epilepsy Centre 2 oronary Care Unit 2 Diabetes Unit 2 Domiciliary Care Service 2 eriatric Assessment Unit 2 ospice Care Unit 2 nfectious Diseases Unit 2 ntensive Care Unit Level III 2 n vitro Fertilisation Unit 2 agnetic Resonance Imaging Issued August 2012 by the Data Collections Unit Page 13 of 71 Ly Queensland G ee DCU Instructions for FRAC 2011 2012 Statement 8 When you open Statement 8 on MAC Online you can either View All to view all sections on the statement or you can click on the individual Sections of t
43. ance Dollars _ Classic DSS DSS Decision Support System Weltome Michelle Anhurtanhurm Atherton Hospital Funding Hierarchy 2010 Operating Surplu E Corporate Reports E ge Basic Reports E B3 Internal Order Tax Reports i Funding Percentages E ES FRAC FRAC Finance Statement 1 apt l Prev vear x EH B Reference Tables planes Actual Pra Yogi Actual il User Defaults Current Date 09 08 2010 12 05 38 PM Actual Var ES Pathology Statement 3 1 596 443 1 531 324 65 120 E User Options Patient Payments 1 175 742 1 148 456 27 286 E Public Reports Accommodation Charges 731 202 803 273 72 071 Private Single 35 443 15 241 20 202 Private Shared 392 668 499 929 107 261 Private amp Shared Day Band 1 67 071 68 329 1 258 Private amp Shared Day Band 2 16 914 22 139 5 225 Private amp Shared Day Band 3 57 910 54 205 3 705 Private amp Shared Day Band 4 4 209 1 004 3 205 Other Inpatient Bed Charges Private amp Shared Nursing Home 17 256 60 344 43 088 Public Nursing Home Type 52 931 72 662 19 731 Workcover Qld 6 748 12 305 5 557 Workcover Other 5 496 6791 12 286 j Third Party 1 940 1 680 260 Ineligible Admitted 68 378 2 229 66 149 Veterans Affairs Inpat Fees 4 241 4 241 Non Admitted Patient Charges 26 905 11 741 15 164 Web Non Admitted Patients 54 94 148
44. and 3 will be pre populated with financial data from DSS Alt2 hierarchy Districts will no longer need to manually run DSS reports to obtain their FRAC data for transposing onto MS Excel spreadsheets Previous years FRAC data will be available and displayed in MAC Online and e Any redundant FRAC Statements and or information have been removed It should be noted that a full review of general ledger account codes applicable for facility level recurrent expenditure and revenue reporting for FRAC was carried out by Financial Accrual Team The MAC Online Application can be accessed via the Health Statistics Centre website on the Data Collections Unit webpage http gheps health qld gov au hic dsu_oprojects htm A FRAC User Guide will be distributed as a quick reference guide for FRAC Users For full details please see the MAC Online User Manual G HSC DCU MAC Manuals Public 1 112 MACOnlineUserManual final pdf Issued August 2012 by the Data Collections Unit Page 4 of 71 Ly Queensland Government serian Health DCU Instructions for FRAC 2011 2012 2 ON LINE STATEMENT NAVIGATION Statement 1 When you open Statement 1 on MAC Online you can either View All to view all sections on the statement or you can click on the individual Sections of the Statement e g Labour Related EXPENDITURE B DSS EXPENDITURE NOT ASSIGNED GLOBAL COMMENT B Issued August 2012 by the Data Collections Unit Page 5 of 71
45. ayments To Staff Superannuation 1 361 223 1 238 773 122 450 Payroll amp Fringe Benefit Taxes 19 546 19 267 279 Non Labour Related Expenditure 5 706 187 5 957 107 749 080 Fond Supplies 149 143 128 831 20 311 Other Food Supplies 149 143 128 831 20 311 Precooked Frozen Foods Drug Expenses 945 850 1 017 340 71 480 Clinical Supplies And Services 1 859 222 1 722 887 136 235 Non Dispasable Inst amp App 41 030 48 212 7 182 Disposables 496 020 430 769 65 251 Dressings Prosthetics 20 418 15 248 ea et Other Clinical Requisites 148 943 290 753 141 810 Home Medical Aids Medical Gases 35 845 19 909 15 935 Other Clinical Support Reg 2 280 2 912 632 External Clin Services Other 335 543 220 979 114 564 External Clin Ser Pathology 779 143 694 204 94 938 Inventory VWOff Clin Supplies E E il gt i Applet Applet3010 started Select the down arrow to retrieve information for Statement 3 Issued August 2012 by the Data Collections Unit 4 Local intranet Page 64 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 2011 2012 amp Decision Support System Microsoft Internet Explorer provided by Queensland Health File Edit View Favorites Tools Help EIE Bak x i2 f gt I Search PF Favorites oy e fwi m m Address ES http qhdss health qld gov au dss pages tab asp v dco uns Navigation Tree lj All Dashboard BS HR Payroll SAP Fin
46. c D 1n0121 Co oktowWt Collections Sub o 1001 22 Mossman Collections Sub 3 li gt o 1 0124 Teen Dental Flan Call Sub Show Caption o 1004 27 Cunnamulla Collections SU i gt Sllow drill down on selected members Issued August 2012 by the Data Collections Unit Page 47 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j 2i Decision Support System Microsoft Internet Explorer provided by Queensland Health AAA File Edit View Favorites Tools Help ew c E o Back gt x E f Search IF Favorites o gt Se fri 3 Address d amp http ahdss health ald gov au dss pages tab asp v Go links Navigation Tree a El DSS Decision Support System Welcome Michelle Arthur arth rrr y All Dashboard H HR Payroll SAP Jim E PS Finance Dollars Classic DSS E3 Corporate Reports E Be Basic Report Atherton Hospital Operating Surplus Deficit 2010 77460 Intradept Shared Distri L Account Report 3 _ Cost Centre Report E Cost Centre Account Repo L Transaction List Eid m Transaction List Detailed gp Internal Order Tax Reports j E Funding Percentages i BS FRAC B Reference Tables i i User Defaults Ba Pathology B3 User Options T r T T BS Public Reports Cost Centre Code and Description Account Code and Description Actual Budget va d YTD Actual YTD Budget
47. cility Issued August 2012 by the Data Collections Unit Page 53 of 71 Ly Queensland Government Queensland Health Navigation Tree lj All Dashboard Ef HR Payroll SAP A Classic DSS _ Pay View J Pay Slip Pay Posted Pay Worked Pay Run m Budget FTE E3 FTE Analysis m E3 Payroll E Pe FRAC FRAC Payroll Statement V2 i FRAC Payroll Statement V1 H 3 Reference Tables m Workforce Management 1 T2 Extract i t p User Defaults m ES Finance Dollars B Activity Based Funding m ES User Options m ES Public Reports E Atherton Hospita DCU Instructions for FRAC 2011 2012 DSS Decision Support System Recurrent Funds Sum ot Standard Paid Effective Date Effective Date 2408 2011 Pay Posted al ETE Current Date 6 09 2011 2 46 10 PM Amount 01 1 Salaried medical officers 419980942 1515 Ho12 Registered nurses B 300 355 56 53 97 E c13Enrolled nurses _ i 1 971 065 956 29 63 1 6 Other personal care staff 278 530 29 3 02 C1 7 Diagnostic and health professionals 1 664 59524 16 57 C1 8 Administrative and clerical staff 1 553 545 24 24 20 Hog Domestic and other staff i 2 633 232 48 46 76 UNDEF Undef 44 674 26 0 21 VMO vmo 145 765 52 0 39 E All FRAC Paypoint 18 789 576 07 199 88 Your Funding Hierarchy should automatically default to 2012 But please ensure that the whole financial year is selected eg 2012
48. d uk Payin Xs Lj cei bee Dra J Pay vies Par Sip Pay Posted wd Pay Worked Pay Run a E Budget FTE m BE FTE Aney ES Fanali E Fane FRAC Payenll statement m Eb Paterence Tatts mn E Workferte Management Lj T2 Extract I User Detauits pE Finance Collars a BEL Adri Based Furmding gx BE User Onhans 3 Brabus kapor Zi Olt Heati District Datumen Tena Gash v Accnual Adjuster Posting Status Conti Labdur Funding Hierarci Referenz Procedure Order Type Hietarth Pipot Pald Ungad Emeis Tyee Hip rarery FTE Tyne Sie ol Labour Geer ath Mharion Hors rid UNDEF Lied mm L erDm Era HRH En FRAG Panmaini Elige Unnai Pay Posted GHFTR i O36 5950507 O26 SB SDSU Expand UNDEF undef Issued August 2012 by the Data Collections Unit Page 58 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j d iecitipnm Support Sytem Micia lntermet Lapiorner provided Ey Liia mi Lami Heath fie Ld View Favores Tooke H p gt Qu NAH Yao gm O S a Os akesi ne chek cre ifs nid lont trvgainn Trea DSS Decision support System all Dashboard 2 Far parol sar Lj ciie DES 3j Pan Mae LL Pap Sip Pag P sted 1 Far Wabad Far Pun i ER Budgee rre Funding Hrani Feteronoy Procedure Cader Tape Hibraet try Pappu Far v Unpaid Eimgis Typi Hirart hey TE Typa m ES rr Anales ram nf late General Ashera Bici al Vie E idot ij tip Pm rmAC tRAC Payroll statement i
49. e Paysus Payroll Suspense Paysus Deduction Suspense Paysus Lattice Interface Offset Paysus Lattice Uncosted Pays Paysus Caspay Interface Offset xman Suspense il gt Applet Applet3010 started u Local intranet Issued August 2012 by the Data Collections Unit Page 38 of 71 Queensland Government Queensland Health DSS Decision Support System Atherton Hospital Intradept Shared 2010 DCU Instructions for FRAC 2011 2012 Welcome Michelle Arthur arthurm Cost Centre Code and Description Account Code and Description 951001 Athe Tmt Vard Medical 961002 Athe Tmt VVard Surgical 577450 Intradept Shared District Services 57 7450 Intradept Shared District Services 951 004 Athe Eme Emergency Medicine Outpatients 577450 Intradept Shared District Services 951 205 Athe All Occupational Therapy 577450 Intradept Shared District Services 951215 TbI Blg Management And Support Services 577450 Intradept Shared District Services 951503 Athe Mgr Medical Clinical Administration 951505 Athe Sup Medical Records 957 251 Athe Orl Dental Health 577460 Intradept Shared District Services 577460 Intradept Shared District Services 577450 Intradept Shared District Services 957253 Athe Orl Schoo Dental Health 57 7450 Intradept Shared District Services Budget 838 Budget Varia YTD Budget Variance 490
50. e Disability Agreement Nursing 4 34 850 118 473 15 487 134 960 e 8 473 16 487 i H B FRAC 430090 Commission Other 143 143 143 143 ES Reference Tables 443630 Daily Maintenance Charge Long Stay 65 523 66 257 734 65 523 66 257 734 uM User Defaults 450230 Serv Cty Gold Phone 8 8 8 8 Ehi Pathology 500010 Salwag Manager And Clerical 139 47 14 744 1 027 13717 14 744 1 027 B user Options 00030 Salwag Nursing 241 237 286 026 54 789 241 237 296 026 54 788 E Public Reports 500040 Salwag Operation Service 45 381 63 742 8 361 45381 53 742 8 361 500060 Salwag Visiting Medical Officer 4818 4151 658 4 819 4161 658 501030 Overtm Nursing 6 899 6 899 6 999 6 899 501040 Overtm Operation Service 81 81 81 91 502030 Penalt Nursing 55 475 72 365 15 890 55 475 72 355 146 890 02040 Penalt Operation Service 9 830 10 872 1 042 9 830 10 872 1 042 502330 Mealal Nursing 293 293 293 293 502340 Mealal Operation Service 59 j 59 59 59 502430 Laundry Allowance Nursing Hr Payroll j 3 3 3 3 50251 D Rdo Expense Managerial And Clerical 564 564 564 564 502530 Rdo Expense Nursing 8 069 8 069 8 069 58 069 502540 Rdo Expense Operations 1398 1 998 1 998 1 998 502930 Othall Nursing 891 891 891 891 503010 Annual Leave Manager amp Clerical 2178 22B 1 953 2178 226 31 253 503030 Annual Leave Nursing 43762 45490 1 428 43762 45190 1 428 503040 Annual Leave Operation Service 7 28
51. e files can potentially harm your computer IF veu do nat trust the source do not open ar save this file Whats the risk Select Open To open file 4 This will open an Excel Spreadsheet and transfer your report Issued August 2012 by the Data Collections Unit Page 28 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j Jh Panorame Saved View Microsofr Inierner Explorer provided by Queensland Heslth Tool Helg C Back 3 gt iz Las JP Search soe Favorites EA c a Land c Address http iqhasybk dca022 dctuat health qld gov saufjPanorama NET WwebUliModules Novaview Savedview aspx Mode Savedviewawebpartquid CBE0238B B865 4478 B137 8F7542E0C2B6 7Cliaus ww Go Links Metro Nth Royal Brisbane amp VVv omens Hosp 2009 Employ Type Hierarchy FTE Type Account File Download EC bis EN ove a et Do you want to open or save this file c1 1 Sa laried medical officers C1 2 Re gistered 2 301 4820 2 3984 590352 nurses rolled 142 5832 142 4720 Save Cancel 440 4203 307 039 2 575 aS Seat TIDS Bs Mame by FRAC Paypoint Current as at 10 Feb 2009 xls PESOS 4 395 5 40 zer Se Type Microsoft Excel worksheet From qhasvbk dca022 dctuat health qld gov au 487 560 4 707 125 45 248 nurses c1 4 Student 0 1547 nurses c1 6 Otherp ersonal 201 5002 200 5288 care staff C1 7 Di agnosti
52. efrsed INS O1 Edemal Undefined 1 Exigimal General Sere O1 Bdernes Undefined Issued August 2012 by the Data Collections Unit 1 una 49 005 07 16 500 00 oel 48 008 07 Page 60 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j Allocation of UNDEF Undef 30XNS 30XNR External Registered Nurse and should therefore be reported in the Nursing category As for 00XGS The facility would need to investigate further to determine what Paypoint ID s this relates to and roll up into the appropriate category accordingly On the Tool Bar Click on Report Mode Report mode ha CE serm z J Decision Suppor Sytem Micrmealt internet I aploner provided by Uipemitaniu Health Fin Edt ie Trote Toor Heap nj Que O 6 BSD Por r 49 ocn B Os Pei ear Hoty fae mnl ag l era to egens Lh m E AH Dashboard 2 DSS Decision Support System ashibaa x e HE Fayrnll Xam Chus DS J Pay View Pbr She Pay Posted j Pay worked Pay Bri Zu iid Halls District Docurmint Tee Cash v Accrual Aik yT Posting Status Conny Labour budget FE Funding Higearzhg Rederangza Pripis Order Typa klgrarr P4 Pamori Paid Unpaid Empis Tye Hieray FTE Tyne EH E FTE naisis Sina Lain Ctm d Ratwer brin Hir nd UNDEF Ureia a Pa Paget FS marz PRAC Payroll statement am Reference Tables mn R3 workferce Managem
53. elearme Michelle Arthur anhurm L Classic DSS Atherton Hospital Funding Hierarchy 2040 Operating Surplu BS Corporate Reports B ge Basic Reports E B3 Internal Order Tax Reports m B Funding Percentages E ES FRAC CL FRAC Finance Statement ee a en bd P Reference Tables etu Actual Var User Defaults lai 24 121 172 21 586 940 2 534 232 Pathology Labour n Related Ex 17 414 984 15 628 833 1 785 152 E User Options penditure i Payroll ls Public Pi iind Expendi 14 381 323 13 278 208 1 103 115 ture Labour Expend ExtAge 1 652 892 1 093 584 559 308 nay Con tr Ex Gratia P ayments To Staff Supera nnuatio 1 361 223 1 238 773 122 450 n Payroll amp Fringe 19 546 19 267 278 Benefit Taxes le Non Labour Related Ex 5 706 187 5 957 107 748 081 penditure Food S upplies Othe r Food 148 143 128 831 20 311 148 143 128 831 20 311 Sup plies Prec ooke d Fro zen Food wel ut a Applet Applet3010 started J Local intranet ve 3 Click on the Excel Export button Issued August 2012 by the Data Collections Unit Page 27 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j E Decision Support System Microsoft Internet Explorer provided by Queensland Health File aui Ney Favorite oo tei E Back v x E LA pS Search sp Favorites 2 e 2 fi m aS Address http qhdss health qld gov au dss pag
54. ences Training CBT Coordinator Access Report Preferences successfully saved E Report Bug or Enhancement Book DSS Training Surveys m E23 Public Reparts Preferences successfully saved message will display Figure 2 1 QH_FRAS Refer Figure 2 Navigation Tree LL i i nll EI DSS Decision Support Systeri oy All Dashboard i ES HR Payroll gt HR Payroll m E5 Finance Dollars Q Select Cube gE E3 Casemix m ES User Options E e HF Payroll l i i Budget FTE mA Public Reports Appointments Employee Analysis Employee Position FTE Analysis Leave Balance Paurall Position Terminations Issued August 2012 by the Data Collections Unit Page 19 of 71 Queensland Government Queensland Health Click on Finance Dollars Navigation Tree oly all Dashboard E Em HR Payroll SAP EE Finance Dollars Classic DSS mE Corporate Reports m Em Basic Reports DCU Instructions for FRAC 2011 2012 DSS Decision Support System JE Internal Qrder Tax Reports s F3 Fundirig Percentages H R FRAC A PS Reference Tables ES Pathology m E User Options a a Public Reports Click on FRAC Navigation Tree AJ All Dashboard gl B3 HR Payroll Finance Dollars _ Classic DSS m B3 Corporate Reports m Em Basic Reports a Internal Order Tax Reports 5 Frac FRAC Finance Statement m B3 Reference Tables User Defaults Ba Casemix e F3 User Op
55. ent Te Lad J user Defaults n Fre fay Paii H F i ES Finance Dollars EM aa TAAL Pappa i i ze Sti Ea ppd Funding Doch I bExtemal epi haec of 1D AD Hi Buser Options SNS bdamdl ed nhad DEL te ot THULI Dadar Pille Repent v em UNE PEE TS 01 baer Sail tlt a DUE Ti Sed Cay AIINS Obed Lisinehad o vk xa UC DT Exbarral Gasanigl arrik RS Phebe Sebi Sei Dm TH Eabar gi rdi iiin di BNE CH Eseinal Urdrfned Tit 46 Oty tus Paved if Sipers Ta vm 2d Dvir OH AT T fe jati rre Fauna Lum ai phais Barars Later eds Prien Labar Hag W wker akaur dd Lider Parima Laien Tma bier Tine fed Priami Laer cid hidra Deer iniia MH PT Aian Hon FAAC Umm UHITEP Deer Palris Mirita k Cumis Laitan hiim Lakma di Labar Upare Sa TRAC Paris firre Cocke died Dieses p Caiman Ms mhart kaos QH FTE Pay Penri irren Issued August 2012 by the Data Collections Unit Page 6l of 71 Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j This will open an Excel Spreadsheet and transfer your report ere eT Tibi et aimee TEN CHE CERTI DUREE TIT Qu o ra a n PILLE A G B Li Aski er ttzlfahehss neath old ov aidsa pages Lab nup Ev Miashgatitim Tirma DSS Decision Supparts system yall Dashboard ES HF Parrall SAP Jj Classic DSS Lj Far View Pay Slip Pay Perbed T Pag Warked Pay Run a B rusos rr Funding Hiram hti lido Feed al paid eim rri m me dra d P c P emer meer
56. er staff E C11 Salaried meckcal officers 1459 4239 7 01 2 Registered nurses 5643 598148 h be M6 Vmo g C1 3 Enreded nurses 2513 1 842 051 42 2 Oter DC 8 Other persoreal cure star 763 18532254 BE17 Diagnostic andnestth professionals 4479 1 684 70055 E Ct Adeninistratve and tieri TOn m nee 10 70 pessum Sed j6 Y ci OTD Demei end ders 4020 2 289 15317 TE UNDEF under l 0360 5850507 fuwovmo 050 262 797 59 L E Loading Jeva poet Local riranet Issued August 2012 by the Data Collections Unit Page 57 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 2011 2012 S FRAC Class EH All Paypoints c da Ci c1 L M Ci a c Salaried medical officers a2 Registered nurses 2 Enralled nurses 4 Student nurses 5 Traineei pupil nurses 4 other personal care staff J Diagnastic and health professional 8 Administrative and clerical staff 4S Domestic and other staff LINDEF Liridg WhO Vra Other 6606000000006 Ln I pas L lr I Fr E I pas i I bene I ler I pas I NS I PET I A L Cn Le dp cm E Diecitinn Support Sele Mberevoll internet E ploner provided by Giper mitami Health E Mas Edt Wiee Paias Too Heb 4 Qe O xz ahn jr 58 4 oe e E het hiak hanad ril ero m e gs oh aga DSS Decision Supnort Syslen Pilar Vey tacos Trea EYAN Dashboar
57. ern search then select members by highlighting them inthe Fesult pane lintradept 3 Exact search Fastest w O Starting with medium Show Caption Search ca Cancel 3 search Account Code and Description Result 3 First search far members by typing either their names or using pattern search then select members by highlighting them in the Result pane 57 460 Intradepe Shared District Services D z77485 Intradent Corporate Services Overhead O 977475 Intradept Hotel inktradepk w 5 Exact search fastest C3 Starting with medium 5 Anywhere within slowest _ Search At level Show Caption Search OK Cancel Issued August 2012 by the Data Collections Unit Page 46 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j Select Members in Account Cade and Description Select by members Filter and Sort select members by moving them from lett to right You can also change their order by dragging anl if allayy drill iz unchecked You can also select their descendants by clicking the right button on members EH Nae di Q sTTABD Intradept Shared District te 100000 Eank Expernditure Account I9 4npp1n Expd Uncleared Cheques uu 1 n z Expd Uncleared Bank Depi 1000985 Bank Syspense Used On a 1O0100 Bank Collections Account tS 100110 Defenre Force Bank Acct L l E i 100114 Central Pharmacy Callecti
58. es tab asp v Go Links Navigation Tree ici RE 2 DSS Decision Support System Welcorne Michelle Arthur arthiurrri All Dashboard ESHR Payroll SAP gt gt S P Finance Dollars T C Classic DSS Atherton Hospital Funding Hierarchy 2010 Operating Surplus Deficit mE Corporate Reports m Basic Reports b SS a internal order Tas Reports F http qhiss health ald gov ati panorama connector dil M cISAPICommand Download Il E dil F oribe i Hale H B Funding Percentages Pile BERAC TEE 3 ix E pa Search Sz Favorites ex E la 3 __ FRAC Finance Statement HB3 Reference Tables i User Defaults BS Pathology BS User Options E Public Reports File Download Do you want to open or save this file Bd Mame Account QH_FRAS Current as at 04 Apr 2009 xls Type Microsoft Excel Worksheet From qhdss health ald gov au While files from the Internet can be useful some files can potentially harm your computer If you do not trust the source do not open or save this file what s the risk s amp Loading Java Applet n J Local intranet Start ME E B3 11 14 AM ve File Download Do you want to open or save this file Bd Mame Account QH FRAS Current as at 04 Apr 2009 xls Type Microsoft Excel Worksheet From ghdss health gld gov au Cancel While files from the Internet can be useful som
59. for FRAC 201 1 20 1 9j PY TT Gupit Ayali Ubstesell bolerees Tepr ninvide tl fry Qaeersiand Health Qm O DAH D tyme 3 9 Ws idm AE Nap auss heath adgy audes payes Lab aso Ee s amp iaa ci i Gi DSS Decision Support System QAI Dashboard PP Hn Payroll SAP _ Cla exc OFS Pay View Pav Sip Pay Posted Pay worked Fay Rue 2010 Cid iwalth District Document Type Cash vActrual Aajuxtment Posing Status Cerwol Labour w E budget ce Funding Hobrart hy Roforance Procedure Onder Type Hierarthy P ypoint Vaud Employ Type Hibraschy FTE Type amp BFE Anelesis Sum of Labour General Aunerton Hospital FRAC Class w E LATET B Select Dimensior xX P rrac l AbDmensons iu 5 aAccours EB actu strent Cash v Accra ed Cool Centro BB cosas OW ALTI 1 EH BR oneen OM ALTI BB mason H HTH W Document Type _ FRAC Payroll Statement w E unieron Tables x E workforce Managemerit T2 Erran LL User Defaufte amp BS finance Dollars BS acuity Based Funding D iue Optom ruts Reports Stale Emi bee Guy 240872911 munt Dew 0008 2011 21134 P E AM FRAC Paypan E Bempicy Type B 611 Salaried medikal officers 1410 FEHB empiowe pt 2 Registered nungoa s843 SANT Brie tye Bert Enreta purses 1 2573 Sm Tene JT fB C1 6 Other personal care staff 163 Hetrrougnoshe and heam pofasnona 4479 i I C4 amp Adeninistraave amd clerical staf 19 70 HE FRAC Papoi
60. further click on the down arrow on the tool bar To get the rest of the cross tab Issued August 2012 by the Data Collections Unit Page 25 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 2011 2012 Ji Decision Support System Microsoft Internet Explorer provided by Queensland Health File Edit View Favorites Tools Help o Back eJ ix a f JJ Search PF Favorites Lo EE e fri lud Address Navigation Tree ly All Dashboard H I HR Payroll SAP E Finance Dollars HI Classic DSS BA Corporate Reports i ge Basic Reports B3 Internal Order Tax Reports m B Funding Percentages E E FRAC a FRAC Finance Statement P3 Reference Tables User Defaults H Pathology Em User Options E Public Reports ul v amp http ighdss health qld goy au dss pages tab asp DSS Decision Support System Funding Hierarchy 2010 Atherton Hospital Operating Surplu Weltome Michelle Arthur arthiurm Prey Year Status Actual Prev Year Actual Current Date 5 08 2010 9 5019 AM Actual Var Statement 1 24 121 1 72 21 585 840 2 534 232 Labour Related Expenditure 17 414 984 15 529 833 1 785 152 Payroll Expenditure l 14 381 323 13 278 208 1 103 115 Labour Expend Ext AgengyContr 1 652 892 1 093 584 558 308 Ex Gratia Payments To Staff Superannuation
61. ges Webq Non Admitted Patients i Workers Compensation Other e a Ineligible Non Admitted Other Patient Related Revenue Revenue Retention Proportion Return To T mM Pharmaceuticals 3 114 Cwealth Nurs Home Basic Care re eee NNENEEEEEENI Cwealth Nurs Home Extens Care es es 131 Nursing Home Pat Accom Fees pup 132 Nursing Home Payments p 133 Ambulance Transportation Fees Lp 1 Patient Transit Scheme Charges a Prosthesis 685 Admitted Patient Fees Ooo o o 137 Hospital Fees Interstate Payments o S S 138 Pharmaceutical Benefit Scheme Reimb 139 ___ Other Receipts 140 Facility Charges 141 Right Of Private Practice 142 Board amp Lodging Staff Aa o y oaa 143 Meals Staff Ooo E 144 Medical Reports 145 Other Revenue 146 Asset Related Revenue 147 Gains On Disposal Of Assets EE 148 Medical Equipment gt 200000 Ooo ee y y o 149 Medical Equipment lt 200000 Oooo y y o 150 Computer Hardware amp Software od 151 Office Equipment jw 152 Furniture amp Fittings ed 153 Engineering Equipment pou 154 Motor Vehicles p 155 Land Improvement On Site puo 156 Land HEN EE SEEN 157 Buildings HEN EE eee 158 Proceeds Clearing Accounts 159 Medical Equipment gt 200000 es o o y y 160 Medical Equipment lt 200000 161 Computer Hardware amp Software Issued August 2012 by the Data Collections Unit Page 32 of 71 Ly usensane overnment Queensland Health DCU Instructions for FRAC 201 1
62. he Statement e g Statement 8 Admitted Patient Fraction View All View All OPTION T APF BASED ON EXPENDITURE I APF BASED ON EXPENDITURE OPTION 1 OPTION 2 APF BASED ON ACTIVITY APF BASED ON ACTIVITY OPTION 2 WORKSHEET APF REPORTED APF REPORTED OPTION 1 APF BASED ON EXPENDITURE APF BASED ON EXPENDITURE OPTION 1 7 um Stimated Total Expenditure on ADMITTED PATIENTS 506 499 3 552325 rand Total Expenditure from Statement 1 MTHACFR1 BTTT581202 042087 1 Admitted Patient Fraction Based on Expenditure jagg 0 5559 Formula Estimated Total Expenditure on ADMITTED PATIENTS Grand Total Expenditure from Statement 1 MTHACFRTI Value of previous period 01 JUL 09 to 3O JUN TU Issued August 2012 by the Data Collections Unit Page 14 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j Statement 8 Admitted Patient Fraction Option 1 MU HE iss usi APF BASED ON EXPENDITURE OPTION 1 WORKSHEET APF BASED ON EXPENDITURE OPTION 1 stimated Total Expenditure on ADMITTED PATIENTS 506049903 552325 rand Total Expenditure from Statement 1 MTHACFR1 777581292 842087 1 Admitted Patient Fraction Based on Expenditure 0 6508 0 6559 Formula Estimated Total Expenditure on ADMITTED PATIENTS Grand Total Expenditure from Statement 1 MTHACFR1 Value of previous period 01 JUL 09 to 30 JUN f0 Top W
63. ing into the DSS production account refer Figure 1 Figure 1 1 Logon to DSS DSS Decision Support System Username E Password hs ET hied H OH ALT 7 div isi over the weeke pertaining tot Login changed n Odes Click I to register reset your password or reactivate your dn the equival fey account There may be Hers private v ES i recommend Java Version information Java Version Information views where Please conta Visit the DSS Training Module to express an interest or booka poe if assista ce im regui course IZhamypest E Personal and sensitive information must be responsibly and transparently collected and managed in accordance withthe privacy principles applicable to Queensland Health Further Information on this can be sought from the Queensland Health Code of Conduct at assistance conte cet m E mn ko d pm IIS url EG T FI 35 ee il ETE nie pmi mr Issued August 2012 by the Data Collections Unit Page 16 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j 2 DSS Home Page displays Navigation Trea x ae lm DSS Decision Support System Waltona Michelle Arthur Canhurtm ly all Dashboard eli HR Payroll SAP 4 HR Payroll Updates FF User Defaults m ES Finance Dollars mE Pathology aE User Options FS Public Reports O Classic DSS Welcome to the HR Payroll SAP module am Pay View Changes
64. lero VA TUA ATO Meinen EET LIE a ees Typo Hitra ETE Typo a Te Analysis Sum of Labour ay ES Ferroli LN rris t Links de s nin Oid haakt District Doorman Tapa ath y Acriual Adjustment Posting Status ont Labout FRAG Payroll statement x B Reference Tablas ile Download u BS Workforce Management Cj Te extract user Driss pmj 3 Hame 2 enenal 1 Atherton Mespitel LINDEF Undel she E EE financa Dinliars zu Typa Minit Excel Vio ont ES Activity Based Funding Vrae ghis health ofl gems Elser Opbees Publi Reparts De pou want bo open or eave Ehia hin while Ber hom thes fed emet cani be unreal some Ber can hs yr congue you dieta e rcs dira qgen G tren thes Gn iba ee di T U rit Atherton UNDEF m Weed Fam i n nd n Wrdon tib Adele OF pe guine be TAG y F E d J2 1 Hja a Biaw zi zl i TEE M Measures by FRAC Paypoint and Paypows Code and Deacnption for 2010 Qld Health Dismiti Sum of Labour General Atherton H tpsal UNDEF Undef Bs nem l 6 z I l 4 I II ad M opbcWr ID 9 P 0 oe 9 emi CU Le SRF Zs l ad On BE pRB Nane g v sheet 1 jz G g Issued August 2012 by the Data Collections Unit Page 62 of 71 Ly Queensland SENSIT DCU Instructions for FRAC 2011 2012 Queensland Health 3 3 STATEMENT 3 TOTAL REVENUE To extract the data for Statement 3 using QH FRAS apply the same selections for
65. ng Facilities should run their own DSS reports to confirm the figures provided by DSS If facilities require further information on the figures provided the facility should contact DSS If a facility has concerns regarding MAC Online either accessing uploading validating or submitting the facility should contact DCU Issued August 2012 by the Data Collections Unit Page 71 of 71
66. nses ag a Rent Water Rates amp Taxes Insurance ss Printing amp Stationer Postage Data Communication Library Costs And Subscription Motor Vehicle Running Expenses Legal Services Oooo o o y y Computer Charges Other Prof Serv And Consulting Shared Service Provider Charges o ns Workers Compensation Premium 2425 eee Staff Expenses Grants Endowments amp Subs MAR Depreciation Medical Equipment gt 200000 Medical Equipment 200000 Computer Hardware EE S E Office Equipment Furniture amp Fittings me Engineering Equipment Motor Vehicles ee y y Oea 828 Amortisation es es E Issued August 2012 by the Data Collections Unit Page 31 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j 24311 24 321 409 464 380 785 20 679 ee ee eee ee ee 93 532 34 805 58 727 5 326 5 326 80 874 24 617 56 257 es ay ee 98 Computer Software C E 99 Portable amp Attractive General 100 Loss Inventory Price Variances L o vc 7 101 Loss Other Oooo es ee 102 Inventory Write Off Oooo ee o y y 103 Finance Lease Oooo o d Works Codes ese Seren sa al 367m Statement 3 Revenue Patient Payments i 108 Private Single 109 Private Shared 110 Private amp Shared Day Band 1 i oL LLL 118 Workcover Other 119 Third Part 120 Ineligible Admitted 121 Veterans Affairs Inpat Fees 4 a 4 a 122 Non Admitted Patient Char
67. nt C1 9 Domeste and olfver staff 40 20 B Oovernment Report DUNDEE Under 0 V Pipi E wo vmo 0 58 L B Pamom Code I E Paypi Code and Owscmmon iy amp Loadng Java zopet SJ Local rircet oh Se e a abau eg mot annala hiia Qa O di Deh ee O Ea 10 4 ulama A rois hesth 3 qv suldsspagesitab asp Ld 1 DSS Decision Support System Van beares Does dir Winn is elie Masigation Tren AI Dashboard ig EH Pepali kan ates amp lasas Das m r T Hrann T 7 i TU j far Vern Pay Sap Pay Posted Pray Wesked Pay Run 5 B tudas VTL Funding Hihrar fi Relern c Picada Order Tyn Hi amp ran te Payn int ial Enic Typ Hetnarrby FTE Tyna a ESTE Analysis Som of Labios Gen ali Athan teen Vergpil ad FRAC Class Erare reac B mac Clam FRAE Payroll statement x peterence Taties s ER Weettorce Management OT Extech j ter Dati Win Cue Hija Dietrice Dincumant Typs Coach v Arrnual Adinari Posting Stshiz Contre Lanaur EH an Piniriras pa 9 11 Ealatied medrcal geg b I I Roghanna numer a C13 Eruclled miriet m Ej finance Dollarc cn a esad ntnurs s E Tre Based Funding i a C15 Trinealpug purses w E user Options m FO c8 other personal cane et d rubi kopen maim Partive Dale 2402011 On FTE Pay Posted 9 61 7 Diagnostic and health professionais pee 2020 A 21796 n LL amem r9 C1 8 Adminitrative ane elerna stam FRAG Papert 17489 17 851 191 76 c4 Domesne and oth
68. nt GQH_FRAS i Account GH_FRAS Code EYES cost Centre EYES Division 3H ALT 2 EYES nivisian aH ALT 7 EFA Division GH HLTH 4 Measures EYES Period EYES value Type i I lr I eL i I Ls DCU Instructions for FRAC 2011 2012 Drag Account Code and Description and drop it into the report selection tab at the top of the screen A hand should appear E Decision Support System Microsoft Internet Explorer provided by Queensland Health File Edit Favorites Tools Back J x E L P Search sip Favorites EA t e wi lal 3 View Help Address ES http ghdss health qld gov au dss pages tab asp DSS Decision Support System Navigation Tree y All Dashboard BS HR Payroll SAP El e Finance Dollars j j Classic DSS Ei E3 Corporate Reports E E Basic Reports i 5 Account Report E Cost Centre Report j Ea Cost Centre Account Repo l L Transaction List Atherton Hospital Operating Surplus Deficit 2010 Welcome Michelle Arthur arhurm Account Code and Description i LE Transaction List Detailed cz Ba Internal Order Tax Reports Cost Centre Code and Description 951001 Athe TmtVWard Medical 1500010 Salwag Manager And Clerical Account Code and Descriptio Seiect Dimensiors BS Funding Percentages All Dimensions BS Frac 00020 Salwag Medical B3 Reference Tables 500030 Salwag Nursing E User Defaults E Path
69. ology 5 User Options BS Public Reports BS Account 00040 Salwag Operation Service sh tit EH Account aH FRAS 500075 Salwag Health Practitioner 50101 0 Overtm Manager And Clerical 501020 Overtm Medical Sheela dee E a Account QH_FRAS Code 01030 Overtm Nursing EF S cost Centre 50201 0 Penalt Manager And Clerical E S Division aH ALT 2 502030 Penalt Nursing BES Division QH_ALT_ 02040 Penalt Operation Service EH S Division QH_HLTH 502075 Penalt Health Practitioner Measures 502210 Localy Manager And Clerical e Penod EF S value Type 02230 Localy Nursing 502240 Localy Operation Service im eeAccount Code and Desc ription 502310 Mealal Manager And Clerical 502330 Mealal Nursing 502430 Laundry Allowance Nursing Hr Payroll 170 502510 Rdo Expense Managerial And Clerical 231 502530 Rdo Expense Nursing 18 455 02930 Othall Nursing 27 842 40 425 02940 Othall Operation Service 18 5029875 Othall Health Practitioner 38 03010 Annual Leave Manager amp Clerical 4 560 Applet Applet3030 started IZ 170 231 18 465 12 483 18 38 4 560 YTD Budget YTD Budget Variance 1 405 520 282 701 40 425 30 967 115 473 1 630 6 305 167 280 42 602 719 94 856 89 565 42 1 868 1 166 1 432 170 231 18 465 12 483 18
70. r Options aB Public Reports The report should be used as a starting point only It can be expected that the expenditure balances on this report do not exactly match the general ledger labour balances due to accrual journals and recoveries that may be posted out during or at the end of a financial year Select HR Payroll SAP FRAC Issued August 2012 by the Data Collections Unit Page 50 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j E Decision Support 5ystem Microsoft Internet Explorer provided by Queensland Health File Edit View Favorites Tools Help QS sex amp J x EB 75 po Search xr Favorites 4 he Address ra http ighdss health qld gov aufdss pages tab asp DSS Decision Support System Navigation Tree 4 All Dashboard mm HR Payrall SAP gt HR Payroll SAP i Classic DSS Ta Select Cube Pay View of Pay Slip Pay Posted e HE Pare DE oo Budget FTE Pay Worked Pay Run He Cost per FTE p Budget FTE wes ens Percent Split Ej FTE Analysis ve Appointments E Es Payrall Employee Analysis E FRAC e Employee Position 2 a FRAC Payroll Statement V2 FTE Analysis a FRAC Payroll Statement v1 on Leave Balance a Reference Tables e Payroll aE Workforce Management pr Rasher min T Extract e Terminations l Mi User Defaults ce Finance Dollars ES Activity Based Funding aBa User Op
71. s Affairs Inpatient Fees l ccommodation Charges PP Total Issued August 2012 by the Data Collections Unit Page 10 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j Statement 3 Revenue Patient Payments Accommodation Charges Patient Payments Accommodation Charges rivate and Shared Day Benefit Band 1 rivate and Shared Day Benefit Band 2 rivate and Shared Day Benefit Band 3 rivate and Shared Day Benefit Band 4 her Inpatient Bed Charges rivate and Shared Nursing Home Type ublic Nursing Home Type orkCover Queensland orkers Compensation Other eterans Affairs Inpatient Fees l ccommodation Charges PP Total Issued August 2012 by the Data Collections Unit Page 11 of 71 Ly Queensland Government serian Health DCU Instructions for FRAC 2011 2012 Stalement 7 When you open Statement 7 on MAC Online you can either View All to view all sections on the statement or you can click on the individual Sections of the Statement e g Statement 7 Specialised Services View All Specialised Services ee sog gcsagmcct Pp 3m pug Gg bL og Gg Gino pd Gulag S 0 373 04 P PE P GP ugkmgp d d OG HOP pan ga mpg dg Hos vod a s 01g PEL c doceas ulpa cag sggcaee 4g Qa ke arc Specialised Services SPECIALISED SERVICE INDICATOR Validation comments cute
72. s eee 22 Medical Gases 23 Other Clinical Support Req 24 Extemal Clin Services Other 25 External Clin Sen Patholon 26 Inventory W Off Clin Supplies pr ORE 27 Non Clinical Supplies And Serv 38 Bedding And Linen 29 Hardware And Crocker 30 Laundry Materials SS l 31 Cleaning Materials 32 Other Domestic Cons amp Charges 33 Contract Laundry Serres A I 34 Contract Cleaning Services 35 Other Contract Domestic Serv 3B Unifarms 37 Minor Nan Clin Equip Pchs 38 Repairs And Maintenance 39 Building And Plant 40 General Office Equipment 41 Medical Equipment 42 Minor New Works ei T E A TGRI 43 Grounds And Gardens E mme etm d 44 Mator Vehicles 45 Dther Repairs And Maintenance M 4 NAtherton FRACD910 Finance Draw s AutoShapes X CO ER Cell 41 commented by kabi Vistan a6 m Manual 091 0 dor MI Window Help gt Caw amp E l al it 4 100 3 Arial 10 7 f Measures by Account QH_FRAS Current as at 04 Apr 2009 HU 226 3 um 25 2 F G Cube Finance Slicers Division QH ALT 2 Atherton Hospital Fiscal 2010 Account Operating SurplusyDeficit Columns Measures Rows Account GH_FRAS Parameters Status Current Date 5 08 2010 11 16 26 AM Selected Members Measures Actual Prev Year Actual Prev Year Actual Var Account QH_FRAS Statement 1 Labour Related Expenditure Payroll Expenditure Labour Expend Ext Agengy Contr Ex Gratia Payments To Staff Superannuation Pa
73. ser options Fangpanr Cae EBPubr kepet a P epuinl Lewd Oo HB PamainrLasal a E 5S PaypointLeval DU asm us perta Dale 24 2011 SHITE Eite F d E a FRAC Parrotini re ThATA AY b Pagneint tira 1 i Eg T3 Job Cece FlUNDEF Linder 0 28 ShADADT EHB perii E amal Gereral Serdices Wos 10500 00 EHEJ eyeaion Drema Urainen 18 sgr ul Posting Shits Issued August 2012 by the Data Collections Unit Page 59 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 2011 2012 Micrasoft Internet 3plerer provided by Queensland health P Dest isin So ppd EE SI Fla Edt View Faventes Took Help L4 Qm O wid th Sst fimen E E Fuse E ibn obe Feci cr mae peni inn E u Mp Yr GO DSS Decision Support System AI Dashboard Fe E fm HR Paprat SAP uc Tj classe oss Lj Pas Vern jPar Sie Pas Ported s 3 Wihiihites Cid Riding ee aie 1j Pay Worked Pay Run zn Tid Hear Dirseti ict Document Type Carth Aigua again Posing Status Soni Langis z FS Bude FTE Funding Hiers ty Reference Pr cedura Order Tyme Hierarci Farpoint Paid v Unpaid Erriotoy Tyne oerarcny FTE Typa a EF Anabyiii Sim ol abua Genre Aihnariomn decreuit ad INDEF Urin Faypoint Code and Dasciiptinn E Bg iayral mA _ FRAP Payroll Slalrinint a ED Reference Tables a E Workforce Management CH T2 Extract F Uhar Enlaulis D E3 rinis Cellars ay ES ioniy bried Funding sw Eher phis
74. t Explorer provided by Queensland Health File Edit View Favorites Tools Help peck es x i2 f Jj Search S Y Favorites C Address E http ahdss health qld gov au dss pages tab asp Navigation Tree ly All Dashboard m I HR Payroll SAP Finance Dollars DSS Decision Support System Welcome Michelle Arthur arthur Mi Cisse DSE Atherton Hospital Funding Hierarchy 2010 Operating Surplu Fel 3 Corporate Reports H P3 Basic Reports mE Internal Order Tax Reports Ej BS Funding Percentages EE Frac 7 FRAC Finance Statement rs ie Prev Year 3 m BS Reference Tables E HDI actual P e TR eta ge Tui 2 18 Actual H User Defaults EE POETE 18 58 PM Var H S Pathology NetAssigned 44139 22781 23 920 amp ES User Options Qtc Administration Fees EH E Public Reports Intradept Shared District Services 1 138 22 620 23 759 instHospital Fees Instate Payment Nt Intermittent Care Fees Fees Disposal Of Property Inve Writeoff Engineering Stores Purch Interest Finance Leases ate Market Value Adjustment Suspne General Suspnc Gld Credit Card Purchase Holding Corporate Card Suspense 161 161 Suspnc Rannip Nurses Prof Dvlpmnt Claim Suspense Prime Vendor Clearing Invoices Suspnc Travel Manager Suspense Suspne Unpresented Cheque Clearing Paysus Net Pay Suspens
75. tions E Public Reports PLEASE NOTE FRAC Payroll Statement V2 is the default for 2011 2012 data Issued August 2012 by the Data Collections Unit Page 51 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j FRAC Payroll Statement DSS Decision Support System Wel y All Dashboard HR Payroll SAP j Classic DSS Pay View j Pay Slip Pay Posted Pay Worked Pay Run m Budget FTE m E3 FTE Analysis m Payroll Ef FRAC __ FRAC Payroll Statement V2 FRAC Payroll Statement V1 m E3 Reference Tables Division QH ALT 2 2011 N Recurrent Funds Sum of Standard Paid m ES Workforce Management T2 Extract u User Defaults Finance Dollars Activity Based Funding Effective ite Effective ioe ad Pay Posted OH FTE 5 user Opti Current Date 6 09 2011 2 37 02 PM Amount or ae C1 1 Salaried medical officers 4 304 487 51616 6 938 02 B3 Public Reports E C1 2 Registered nurses 1 900 142 409 54 20 775 89 BH 614 3 Enrolled nurses 201 518 3845 3 042 14 C1 4 Student nurses 2 455 691 86 38 06 E 1 5 Trainee punil nurses 114 316 65 3 88 E c4 amp Other personal care staff 123 571 318 42 1 954 55 C17 Diagnostic and health professionals B85447 890 07 7 268 10 C1 8 Administrative and clerical staff 92 578 420 13 8 733 07 B c4 9 Domestic and other staff
76. tions E Public Reports gt Finance Dollars Select Cube DSS Decision Support System a7 se Slicers Qld Health District Funding Hierarchy 2009 Operating Surplu Weloome David Kearney kearneyd Actual Prev Year Actual Prey Year Actual Var Statement 1 Labour Related Expenditure Payroll Expenditure Ex Gratia Payments To Staff Labour Expend Ext AgengyContr 22 2 c Superannuation Payroll amp Fringe Benefit Taxes Nan Labour Related Expenditure Food Supplies Other Faad Supplies Precooked Frozen Foods Drug Expenses Issued August 2012 by the Data Collections Unit 130 486 166 4 759 790 754 4 145 398 794 183 974 793 2 911 407 903 789 22 509 466 2 370 695 412 50 230 631 44174 5658 6 055 973 292 552 577 B 451 205 382 4 228 459 810 3 658 529 907 197 711 278 352 215 047 20 002 900 39 406 047 655 999 268 215 807 BT 679 280 784 531 330 944 486 869 887 13 735 485 2 234 55 888 742 2 506 566 2 222 745 572 147 949 840 45 062 045 5 168 585 4 768 612 399 974 24 336 769 Page 20 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 2011 2012 Click on FRAC Finance Statement DSS Decision Support System Navigation Tree AJ All Dashboard m IHR Payroll mf Finance Dollars 82 Slicers fume PATE ESS Qld Health District B
77. xpenditure Labour Expend Ext Agendgycantr Ex Gratia Payments To Staff Superannuation Fayroll amp Fringe Benefit Taxes Mon Labour Related Expenditure Food Supplies Other Food Supplies Precooked Frozen Foods Drug Expenses Clinical Supplies And Services Mon Disposable Inst amp App Disposables Dressings Prosthetics Other Clinical Requisites Home Medical Aids Medical Gases Other Clinical Support Reg External Clin Services Other External Clin Sern Pathology Inventor wor clin Supplies tal Issued August 2012 by the Data Collections Unit 3 Actual B5B 749 800 452 463 446 419 603 427 21 732 337 183 38 873 377 2 573 512 184 266 354 4 507 463 3 871 852 535 601 24 337 193 41 725 215 1 077 772 21 055 030 10 648 542 1 214 180 1 646 416 693 083 922 187 4 513 849 46 944 Prev rear Actual 635 395 996 427 570 081 368 722 778 18 849 667 37 141 414 2 556 201 207 825 915 4152 739 3 551 421 511 318 26 356 076 51 101 732 1 550 524 21 685 317 6 902 683 1 402 472 1 483 352 567 457 1 135 183 4 133 555 20 124 122 Actual War 31 353 804 54 013 385 50 880 549 2 883 250 183 1 431 863 282 689 23 559 561 344 724 320 441 24 283 2 018 884 19 376 577 582 752 630 287 1 745 858 188 282 157 055 125 626 214 003 380 283 20 171 066 Page 21 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j Double Click on Division QH ALT 2
78. y the Data Collections Unit Page 35 of 71 Ly Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 9j DSS Decision Support System User Rollups Rollups are saved automatically when a selection is changed Associated dimensions below are switched to use the selected rollup When blank the system default is used Division Employ Type gt beeper Pay Posted Date Division GH ALT 7 Division gH HLTH User Defau Its User defaults are optional When left blank the system default iz used Division QH_ALT_ Employ Type Hierarchy Measure Account Document Type FTE Type Paypoint Paid v Unpaid Periad current previous System Loading Please Wait status bar will appear until the Division is updated with the selected item Save Defaults User Defaults will now display with Division QH ALT 2 Issued August 2012 by the Data Collections Unit Page 36 of 71 Queensland Government Queensland Health DCU Instructions for FRAC 201 1 20 1 2 DSS Decision Support System PP gt wo sow ee Pe se a b rd B utu P Rollups are saved automatically when a selection is changed Associated dimensions below are switched to use the selected rollup When blank the system default is used Division Division GH ALT 2 M Pay Posted Date 7 PT ut r zw A a i mi i m 4 i E E ML M ee BR eee ee ee
79. yroll amp Fringe Benefit Taxes Non Labour Related Expenditure Food Supplies Other Food Supplies Precooked Frozen Foods Drug Expenses Clinical Supplies And Services Non Disposable Inst amp App Disposables Dressings Prosthetics Other Clinical Requisites Home Medical Aids Medical Gases Other Clinical Support Reg External Clin Services Other External Clin Serv Pathology InmeentoryANZOff Clin Supplies Non Clinical Supplies And Serv Bedding And Linen Hardware And Crockery Laundry Materials Cleaning Materials Other Domestic Cons amp Charges Contract Laundry Services Contract Cleaning Services Other Contract Domestic Serv Uniforms Minor Non Clin Equip Pchs Repairs And Maintenance Building And Plant General Office Equipment Medical Equipment Minor New Works Grounds And Gardens Motor Vehicles Other Repairs And Maintenance Energy Expenditure Electricity Fuel Oil Other Energy IB 2 4 E Decision Support Syst E http fahdss heal wali E3 Micrasoft Excel Ath SAE 0x ED s Note Reports run in DSS will be reported using the default hierarchy attached to your username DSS Helpful Hint 1 In DSS hierarchy structures are available They are Division QH 2011 Division QH ALT 2 and Division QH ALT 7 For any reports that are executed in DSS will default to the hierarchy structure that 1s linked to your user name To change your default hierarchy Select User

Financial and Residential Activity Collection (FRAC) DSS

Contents

Download Pdf Manuals

Related Search

Related Contents