Currently each month around mid month data from EDIS sourced from QHERS is placed on the AS400 by DSAT, later that day it is loaded into Talons SQL automagically - but sites must keep an eye on it and check it VERY IMPORTANT
Each Saturday ED data of all three flavours is drawn from sites to a central server where it is processed and Grouped for IHPA purposes and assigned a URG or Jellinek UDG (JUDG) as well as funding amount.
in the last week of each month this grouped data is returned to sites SQL servers into tblURG_ccfy_tla files, e.g. tblURG_2014_RBH.Only the correct phases for the fiscal year are returned
the correct phase funding and URG data for the fiscal year is placed with basic linkage information in tblURG_ED_index table
the T1HKCPP table for IP XVIP is updated and changed records flagged for XVIP extract
To complete the chain uses must create an XV EMG extract set each month