Australian Vaccination Certificate requirements
To quote the practice manager in Hong Kong "Apparently Australia is getting stricter on it's required information for vaccination certificates, meaning that the template we are currently using isn't sufficient. The authorities are now asking for the manufacturer details as well as the due date of the next vaccination."
a) has anyone come across this ? [It may just apply for animals coming into Australia]
b) any suggestions as to how to do it? [Our current vaccination certificates use macro:eval(history:medication(...)) to generate the vaccation history on the certificate. I could use macro:eval(getReminders(...)) but this is going dump all reminders for the customer, not just the vaccination reminders for the current patient. I have a suspicion that the solution lies in using a jrxml based certificate than than (as currently) an odt based one. Then I could have two detail sections, one calling a subreport to display the vaccination data and one to display the reminder data - filtered to show only vaccinations reminders for this patient.]
Another alternative is to build a report that generates an 'Australian Import Vaccination Certificate'. Since the report runs with an SQL data source, one is not shackled by the constraints of the available JxPath Extension Functions.
All comments welcomed.
Regards, Tim G
Re: Australian Vaccination Certificate requirements
I am DAFF accredited Tim - and I will say this - the best thing the vets conducting pre export examinations and vaccinations on behalf of the Australian Government can do - is use the little stickers that come on almost every bottle of vaccination and place them on the vaccine certificates. That combined with writing your name and address on the certificate clearly is really helpful. Those stickers have the Manufacturer, brand, expiry date and batch number written on them....stick them on the certificate after printing. With regard to the due-date - I haven't looked at it yet but you should be able to retrieve that info in a document quiet easily...HOWEVER - and here is the catch the reminder is not updated until the visit is finalized...hence...it wont be retrievable until AFTER they pay....which is highly frustrating...because documents attached to products are generated at billing. The final alternative is to use a jxpath to call the reminder template linked to the product and call the due date that way....havent looked at it...To be honest the certificates need to be signed in blue pen anyway and I just right in the due date then...Rabies vaccinations are also interesting because the Australian government also requires an EFFECTIVE date - the date when the vaccines starts being effective (for Rabies this is arbitrarily 3 weeks after injection)
You can download the Australian governments official rabies vaccination certificate (International Rabies Vaccination Movement Certificate from the DAFF website as well) or atleast a template - if you cant find I can send you my ODT formatted one...
BTW we don't really care about anything other than the last vaccination. History is sort of irrelevant.
Re: Australian Vaccination Certificate requirements
Ben - Thanks for the DAFF reference - I found http://www.daff.gov.au/biosecurity/cat-dogs. I will consult with the practice manager. Regards, Tim G
Re: Australian Vaccination Certificate requirements
The fix turned out to be easy. The practice is not generating the export paperwork or the RNATT certificate, and it turns out that the lab that does this is happy if the practice's certificate says '3 year vaccine' or '1 year vaccine' depending on the vaccination type - so they just modified the Printed Description to include this and it comes out as per below. Thanks for the help, Regards, Tim G