{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Doc history","REFDATES","RULES","Stage & Condition","MAIN","CCGs","System Types","QUERYSETS","SUMMARY","CSEPAC1-IN","CSEPAC2-IN","CSEPAC1","CSEPAC2","CSEPAC3","CSEPAC1-CTV","CSEPAC2-CTV","CSEPAC3-CTV","CSEPAC3-IN"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":15,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Doc history","index":0,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Date","Description","Who"]
["2016-09-08","First version","SJM"]
["2017-07-07","v1-17","SJM"]

{"sheet":"REFDATES","index":1,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["TODAY",{"$f":"TEXT(TODAY(),\"dd/mm/yyyy\")","v":"12/07/2017"},{"$f":"B1","v":"12/07/2017"},{"$f":"B1","v":"12/07/2017"},{"$f":"B1","v":"12/07/2017"},{"$f":"B1","v":"12/07/2017"},null,null," "]

{"sheet":"RULES","index":2,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["CSEPAC1-IN","COUNT","-","-"]
["CSEPAC2-IN","LIST","TIDY",0]
["CSEPAC3-IN","LIST","DEHEAD",0]

{"sheet":"Stage & Condition","index":3,"n_rows":54,"n_cols":3,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["Code","Definition"]
["8CM15","BLUE",1]
["8CM16","GREEN",2]
["8CM17","YELLOW",3]
["8CM18","RED",4]
["XaZb7","BLUE",1]
["XaZbA","GREEN",2]
["XaZbD","YELLOW",3]
["XaZbE","RED",4]
[]
["2128.","Same"]
["2128","Same"]
["212C.","Poor"]
["212C","Poor"]
["212D.","Unstab"]
["212D","Unstab"]
["2127.","Worsen"]
["2127","Worsen"]
["XM1UN","Deteri"]
[]
["94Z1","Preferred place of death: home","Home"]
["94Z1.","Preferred place of death: home","Home"]
["94Z2","Preferred place of death: hospice","Hospice"]
["94Z2.","Preferred place of death: hospice","Hospice"]
["94Z3","Preferred place of death: community hospital","Comm hosp"]
["94Z3.","Preferred place of death: community hospital","Comm hosp"]
["94Z4","Preferred place of death: hospital","Hospital"]
["94Z4.","Preferred place of death: hospital","Hospital"]
["94Z5","Preferred place of death: nursing home","NH"]
["94Z5.","Preferred place of death: nursing home","NH"]
["94Z6","Preferred place of death: patient unable to express preference","Unable"]
["94Z6.","Preferred place of death: patient unable to express preference","Unable"]
["94Z7","Preferred place of death: discussion not appropriate","Inapprop"]
["94Z7.","Preferred place of death: discussion not appropriate","Inapprop"]
["94Z8","Preferred place of death: patient undecided","Undecided"]
["94Z8.","Preferred place of death: patient undecided","Undecided"]
["94ZD","Preferred place of death: patient declined discussion","Declined"]
["94ZD.","Preferred place of death: patient declined discussion","Declined"]
["94ZE","Preferred place of death: residential home","RH"]
["94ZE.","Preferred place of death: residential home","RH"]
["94ZF","Preferred place of death: usual place of residence","Usual"]
["94ZF.","Preferred place of death: usual place of residence","Usual"]
["XaJ3g","Preferred place of death: home","Home"]
["XaJ3h","Preferred place of death: hospice","Hospice"]
["XaJ3i","Preferred place of death: community hospital","Comm hosp"]
["XaJ3j","Preferred place of death: hospital","Hospital"]
["XaJ3k","Preferred place of death: nursing home","NH"]
["XaQiX","Preferred place of death: residential home","RH"]
["XaQzq","Preferred place of death: patient unable to express preference","Unable"]
["XaQzr","Preferred place of death: discussion not appropriate","Inapprop"]
["XaQzt","Preferred place of death: patient undecided","Undecided"]
["XaVww","Preferred place of death: care home","Care home"]
["XaXOt","Preferred place of death: patient declined discussion","Declined"]
["XaYsj","Preferred place of death: usual place of residence","Usual"]

{"sheet":"MAIN","index":4,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[null,"END OF LIFE - MIQUEST QUERIES",null,null,null,"Version 1-21 12/07/2017"]
[null,null,null,null,null,"© copyright 2016-17 NHS South, Central and West Commissioning Support Unit "]
[null,"This tool creates MIQUEST queries and processes the results."]
[]
[null,"STEP 1 - CONFIGURE THE QUERIES"]
[]
[null,"MIQUEST query set :","CSEPAC"]
[]
[null,"Enter your practice code here (e.g. J84999) --->",null,null,"--> press tab or the enter key"]
[]
[null,"Select your clinical system type --->",null,null,"--> press tab or the enter key"]
[]
[null,"Reference period :","TODAY"]
[]
[null,"First reference date:",{"$f":"VLOOKUP($C$14,REFDATES!$A$1:$E$22,2,FALSE)","v":"12/07/2017"}]
[]
[null,"Second reference date:",{"$f":"VLOOKUP($C$14,REFDATES!$A$1:$E$22,3,FALSE)","v":"12/07/2017"}]
[]
[null,"Third reference date:",{"$f":"VLOOKUP($C$14,REFDATES!$A$1:$E$22,4,FALSE)","v":"12/07/2017"}]
[]
[null,"Fourth reference date:",{"$f":"VLOOKUP($C$14,REFDATES!$A$1:$E$22,5,FALSE)","v":"12/07/2017"}]
[]
[null,"Fifth reference date:",{"$f":"VLOOKUP($C$14,REFDATES!$A$1:$F$22,6,FALSE)","v":"12/07/2017"}]
[]
[]
[null,"Save the queries on your computer …"]
[]
[]
[]
[]
[null,"If nothing happens when you click the green button (after tab or enter key), you will need to enable macros - see below for details."]
[]
[null,"STEP 2 - RUN THE MIQUEST QUERIES"]
[]
[null,"Run the MIQUEST queries on your clinical system"]
[]
[null,"You can close this workbook while you run the queries if you wish"]
[]
[null,"STEP 3 - PROCESS THE MIQUEST RESULTS"]
[]
[null,null,"WARNING - This workbook will contain visible and hidden Personal Identifiable Data (PID)"]
[]
[]
[]
[null,"To enable macros (Excel 2007 and 2010)"]
[null,"Click the office button (Excel 2007) or 'File' (Excel 2010)"]
[null,"Click Excel Options"]
[null,"Select Trust Centre"]
[null,"Click Trust Centre Settings"]
[null,"Select Macro Settings"]
[null,"Click Disable all macros with notification"]
[null,"Click OK"]
[null,"Click OK"]
[null,"Close Excel"]
[null,"Open the workbook again and enable macros with the Options button …"]
[null,"… alongside the 'Macros have been disabled' Security Warning message."]

{"sheet":"CCGs","index":5,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Fareham and Gosport","FAG"]
["Isle Of Wight","IOW"]
["North East Hants & Farnham","NEHF"]
["North Hampshire","NHF"]
["Portsmouth","POR"]
["Southampton","SOT"]
["South East Hampshire","SHE"]
["Surrey Downs","SDO"]
["Surrey Heath","SHE"]
["West Hampshire","WH"]

{"sheet":"System Types","index":6,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["EMIS Web"]
["INPS Vision"]
["MICROTEST"]
["TPP SystmOne"]

{"sheet":"QUERYSETS","index":7,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Name","Number of queries","FirstRefDate","SecondRefDate","ThirdRefDate","FourthRefDate","FifthRefDate","ReferencePeriod","Title"]
["CSEPAC",3,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","yes","End of Life"]

{"sheet":"SUMMARY","index":8,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"DATA SUMMARY"]
[]
[null,"MIQUEST query set:",{"$f":"VLOOKUP(\"*QRY_SETID\",'CSEPAC1-IN'!A:B,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(\"*QRY_SETID\",'CSEPAC1-IN'!A:C,3,FALSE)","v":{"$error":"#N/A"}}]
[null,"Practice code:",{"$f":"VLOOKUP(\"*ENQ_RSPID\",'CSEPAC1-IN'!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"MIQUEST run date:",{"$f":"VLOOKUP(\"*RSP_RDATE\",'CSEPAC1-IN'!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[null,"Number of patients:",{"$f":"VLOOKUP(\"$1\",'CSEPAC1-IN'!A:B,2,FALSE)","v":{"$error":"#N/A"}},"For patient details, look in tab CSEPAC2-IN"]

{"sheet":"CSEPAC1-IN","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"CSEPAC2-IN","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CSEPAC1","index":11,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["*QRY_WDATE,20160908,08/09/2016"]
["*QRY_SDATE,20160908,08/09/2016"]
["*QRY_TITLE,CSEPAC1,GSF POPULATION IDENTIFIED FOR FUTURE PLANNING"]
["*QRY_ORDER,001"]
["*QRY_AGREE,LOCAL,"]
["*QRY_SETID,CSEPAC,EPACCS FUTURE PLANNING READ"]
["*ENQ_IDENT,LOCAL,Local Enquirer"]
["*QRY_MEDIA,D,DISK"]
["*ENQ_RSPID,<<RSPID>>,"]
["*QRY_CODES,0,9999R2,Read version 2"]
["SUBSET CSEPAC1 TEMP"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["WHERE CODE IN (\"8CM15\",\"8CM16\",\"8CM17\",\"8CM18\")"]
[" "]

{"sheet":"CSEPAC2","index":12,"n_rows":95,"n_cols":1,"rows_kept":95,"cut":false,"hidden":true,"merged":[]}
["*QRY_WDATE,20170411,11/04/2017"]
["*QRY_SDATE,20170411,11/04/2017"]
["*QRY_TITLE,CSEPAC2,REPORT ON GSF POP IDENTIFIED FOR FUTURE PLANNING"]
["*QRY_ORDER,002"]
["*QRY_AGREE,LOCAL,"]
["*QRY_SETID,CSEPAC,EPACCS FUTURE PLANNING READ"]
["*ENQ_IDENT,LOCAL,Local Enquirer"]
["*QRY_MEDIA,D,DISK"]
["*ENQ_RSPID,<<RSPID>>,"]
["*QRY_CODES,0,9999R2,Read version 2"]
["DEFINE AGE AS @YEARS(\"<<REFDATE1>>\",DATE_OF_BIRTH)"]
["DEFINE BLANK AS \" \""]
["DEFINE BLANK2 AS \" \""]
["FOR CSEPAC1"]
["REPORT FIXED"]
["PRINT SURNAME,FORENAME,NHS_NUMBER,AGE"]
["FROM PATIENTS"]
["#1 Patient details"]
["PRINT DATE,CODE,TEXT"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["     WHERE CODE IN (\"9NN60\")"]
["#2 Named GP"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"2128\",\"2127\",\"212C\",\"212D\")"]
["#3 Patient's condition"]
["PRINT VALUE1,DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"9NNg2\")      "]
["#4 Referred to Comm. Care Team"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"8CPC\")"]
["#5 Advance care planning"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"9NNV\")"]
["#6 Known to social services"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"9EB5\")"]
["#7 DLA applied for"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"8CS2\")"]
["#8 CHC funding applied for"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["   WHERE CODE IN (\"8BMM\")"]
["#9 Anticipated meds in place"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["   WHERE CODE IN (\"9NNR\")"]
["#10 Frequent CCT input"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["   WHERE CODE IN (\"13GZ\")"]
["#11 Adequate PoC in place"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["   WHERE CODE IN (\"9DB\")"]
["#12 Verification of death cert."]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"1R10\")"]
["#13 DNACPR in place"]
["PRINT DATE,CODE,BLANK,BLANK2"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"94Z1\",\"94Z2\",\"94Z3\",\"94Z4\",\"94Z5\",\"94ZE\",\"94ZF\",\"94Z6\",\"94Z7\",\"94ZD\",\"94Z8\")"]
["#14 Preferred place of death"]
["PRINT DATE,CODE,BLANK,BLANK2"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"ZV450\",\"2JS\",\"88A9\")"]
["#15 Cardio pacemaker or defibrillator"]
["PRINT DATE,CODE,BLANK,BLANK2"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["   WHERE CODE IN (\"8BPR\")"]
["#16 Supply of medication available at home"]
["PRINT DATE,CODE,BLANK,BLANK2"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"8HH7\",\"9NgD\",\"9NgA\",\"8H7g\",\"8IEE\",\"8HgX\")"]
["#17 Specialist palliative care"]
["PRINT DATE,CODE,BLANK,BLANK2"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["   WHERE CODE IN (\"9W4\",\"9W5\",\"9W6\")"]
["#18 Power of Attorney"]
["PRINT DATE,CODE,BLANK,BLANK2"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["   WHERE CODE IN (\"9NgG\")"]
["#19 ADRT"]
["PRINT DATE,CODE,TEXT,BLANK2"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["   WHERE CODE IN (\"8CM3\",\"2Jd\")"]
["#20 Meeting notes"]
[" "]

{"sheet":"CSEPAC3","index":13,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["*QRY_WDATE,20170707,07/07/2017"]
["*QRY_SDATE,20170707,07/07/2017"]
["*QRY_TITLE,CSEPAC3,REPORT 2 ON GSF POP IDENTIFIED FOR FUTURE PLANNING"]
["*QRY_ORDER,003"]
["*QRY_AGREE,LOCAL,"]
["*QRY_SETID,CSEPAC,EPACCS FUTURE PLANNING READ"]
["*ENQ_IDENT,LOCAL,Local Enquirer"]
["*QRY_MEDIA,D,DISK"]
["*ENQ_RSPID,<<RSPID>>,"]
["*QRY_CODES,0,9999R2,Read version 2"]
["DEFINE AGE AS @YEARS(\"<<REFDATE1>>\",DATE_OF_BIRTH)"]
["DEFINE BLANK AS \" \""]
["FOR CSEPAC1"]
["REPORT FIXED"]
["PRINT SURNAME,FORENAME,NHS_NUMBER,AGE"]
["FROM PATIENTS"]
["#1 Patient details"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["     WHERE CODE IN (\"8CM15\",\"8CM16\",\"8CM17\",\"8CM18\")"]
["#2 GSF stage"]
[" "]
[" "]

{"sheet":"CSEPAC1-CTV","index":14,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["*QRY_WDATE,20160908,08/09/2016"]
["*QRY_SDATE,20160908,08/09/2016"]
["*QRY_TITLE,CSEPAC1,GSF POPULATION IDENTIFIED FOR FUTURE PLANNING"]
["*QRY_ORDER,001"]
["*QRY_AGREE,LOCAL,"]
["*QRY_SETID,CSEPAC,EPACCS FUTURE PLANNING READ"]
["*ENQ_IDENT,LOCAL,Local Enquirer"]
["*QRY_MEDIA,D,DISK"]
["*ENQ_RSPID,<<RSPID>>,"]
["*QRY_CODES,0,9999R3,Read version 3"]
["SUBSET CSEPAC1 TEMP"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["WHERE CODE IN (\"XaZb7\",\"XaZbA\",\"XaZbD\",\"XaZbE\")"]
[" "]

{"sheet":"CSEPAC2-CTV","index":15,"n_rows":95,"n_cols":1,"rows_kept":95,"cut":false,"hidden":true,"merged":[]}
["*QRY_WDATE,20170411,11/04/2017"]
["*QRY_SDATE,20170411,11/04/2017"]
["*QRY_TITLE,CSEPAC2,REPORT ON GSF POP IDENTIFIED FOR FUTURE PLANNING"]
["*QRY_ORDER,002"]
["*QRY_AGREE,LOCAL,"]
["*QRY_SETID,CSEPAC,EPACCS FUTURE PLANNING READ"]
["*ENQ_IDENT,LOCAL,Local Enquirer"]
["*QRY_MEDIA,D,DISK"]
["*ENQ_RSPID,<<RSPID>>,"]
["*QRY_CODES,0,9999R3,Read version 3"]
["DEFINE AGE AS @YEARS(\"<<REFDATE1>>\",DATE_OF_BIRTH)"]
["DEFINE BLANK AS \" \""]
["DEFINE BLANK2 AS \" \""]
["FOR CSEPAC1"]
["REPORT FIXED"]
["PRINT SURNAME,FORENAME,NHS_NUMBER,AGE"]
["FROM PATIENTS"]
["#1 Patient details"]
["PRINT DATE,CODE,TEXT"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["     WHERE CODE IN (\"XacWQ\")"]
["#2 Named GP"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"2128.\",\"2127.\",\"212C.\",\"212D.\",\"XM1UN\")"]
["#3 Patient's condition"]
["PRINT VALUE1,DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"XaAQq\")      "]
["#4 Referred to Comm. Care Team"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"XaXb6\")"]
["#5 Advance care planning"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"XaAey\")"]
["#6 Known to social services"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"9EB5.\")"]
["#7 DLA applied for"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"XaVzx\")"]
["#8 CHC funding applied for"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["   WHERE CODE IN (\"XaPmq\")"]
["#9 Anticipated meds in place"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["   WHERE CODE IN (\"XaLJP\")"]
["#10 Frequent CCT imput"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["   WHERE CODE IN (\"XE0p4\")"]
["#11 Adequate PoC in place"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["   WHERE CODE IN (\"9DB..\")"]
["#12 Verification of death cert."]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"XaZ9c\")"]
["#13 DNACPR in place"]
["PRINT DATE,CODE,BLANK,BLANK2"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"XaJ3g\",\"XaJ3h\",\"XaJ3i\",\"XaJ3j\",\"XaJ3k\",\"XaQiX\",\"XaVww\",\"XaYsj\",\"XaQzq\",\"XaQzr\",\"XaXOt\",\"XaQzt\")"]
["#14 Preferred place of death"]
["PRINT DATE,CODE,BLANK,BLANK2"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"Xa8D5\",\"XaNR7\",\"XaYZM\")"]
["#15 Cardio pacemaker or defibrillator"]
["PRINT DATE,CODE,BLANK,BLANK2"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["   WHERE CODE IN (\"XaZke\")"]
["#16 Supply of medication available at home"]
["PRINT DATE,CODE,BLANK,BLANK2"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["    WHERE CODE IN (\"XaIlk\",\"XaLKI\",\"XaXqW\",\"XaAex\",\"XaXoP\",\"XaAmT\")"]
["#17 Specialist palliative care"]
["PRINT DATE,CODE,BLANK,BLANK2"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["   WHERE CODE IN (\"XaOc4\",\"XaOc5\",\"Ua0Sq\")"]
["#18 Power of Attorney"]
["PRINT DATE,CODE,BLANK,BLANK2"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["   WHERE CODE IN (\"XaYld\")"]
["#19 ADRT"]
["PRINT DATE,CODE,TEXT,BLANK2"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["   WHERE CODE IN (\"XaLG1\",\"X76Ao\")"]
["#20 Meeting notes"]
[" "]

{"sheet":"CSEPAC3-CTV","index":16,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["*QRY_WDATE,20170707,07/07/2017"]
["*QRY_SDATE,20170707,07/07/2017"]
["*QRY_TITLE,CSEPAC3,REPORT 2 ON GSF POP IDENTIFIED FOR FUTURE PLANNING"]
["*QRY_ORDER,003"]
["*QRY_AGREE,LOCAL,"]
["*QRY_SETID,CSEPAC,EPACCS FUTURE PLANNING READ"]
["*ENQ_IDENT,LOCAL,Local Enquirer"]
["*QRY_MEDIA,D,DISK"]
["*ENQ_RSPID,<<RSPID>>,"]
["*QRY_CODES,0,9999R3,Read version 3"]
["DEFINE AGE AS @YEARS(\"<<REFDATE1>>\",DATE_OF_BIRTH)"]
["DEFINE BLANK AS \" \""]
["FOR CSEPAC1"]
["REPORT FIXED"]
["PRINT SURNAME,FORENAME,NHS_NUMBER,AGE"]
["FROM PATIENTS"]
["#1 Patient details"]
["PRINT DATE,CODE,BLANK"]
["FROM JOURNALS (LATEST FOR PATIENT)"]
["     WHERE CODE IN (\"XaZb7\",\"XaZbA\",\"XaZbD\",\"XaZbE\")"]
["#2 GSF stage"]
[" "]

{"sheet":"CSEPAC3-IN","index":17,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}