Before you can start the configuration of the strategic reporting extracts, the Gateway needs to be enabled by TPP and a user configured with the correct permissions to access the strategic reporting extracts.
It’s recommended that a Cauldicott guardian account is used to enable the extract user and grant the Download Strategic Reporting Extracts access rights (within the users settings click on the data gathering tab - tick download strategic reporting). The member of staff will need to be logged into the Gateway mode 24/7 with the exception of rebooting the PC. There’s no reason why the user should not always log on in Gateway mode.
Support Contact Details
Informatica Support - Email : Support@ishealth.co.uk Tele: 03303353110
TPP SystmOne Support - Tele: 0113 205 0099 (NAT code is used for support purposes)
Run SystmOne in Gateway Mode
TPP SystmOne has a special running mode for its Gateway session which is not the normal TPP icon. Usually a separate TPP Gateway icon is added to the desktop, the extract user must log into TPP using the Gateway mode.
Check the TPP Gateway Shortcut Is Using A High Memory Client
Right click on the SystmOne Gateway shortcut on the desktop
Click on Properties
Shortcut tab
Target path should be : ‘C:\apps\Tpp\rungenps.bat -Xmx1024m -Xskipmemorycheck’
Change the path to above if needed
Click on Apply
Click on OK
If a change was made ask the user to logout and back into the Gateway mode to check this opens OK
Note: If the practice are new to Strategic Reporting they may not have a TPP Gateway shortcut on the desktop of the designated PC, follow the ‘How To Add A TPP Gateway Shortcut’ below
How To Add A TPP Gateway Shortcut
If there’s no TPP Gateway mode icon on the desktop create a shortcut icon using the path:-
C:\apps\Tpp\rungenps.bat -Xmx1024m -Xskipmemorycheck
Note: SystmOne running in Gateway mode will display the word Gateway in the caption bar of its main window.
Configure the Gateway PC to log back on after maintenance updates are applied
Within TPP click on Settings
Click on Organisation Preferences
Highlight Gateway Settings in the left column
Click ‘This PC’ to enable for the current PC
Click OK
Extract Configuration Setup
Configure A New Organisation Group
Note: throughout the document you will see reference to NACS CODE - you must enter the PRACTICE NACS / ODS CODE E.G A12345
Ask the practice to log into the TPP Gateway as the user granted with the Download Strategic Reporting Extracts access above.
Note: the extract user must not log into the TPP Gateway using their Smartcard as the Gateway will logout once the Smartcard is removed.
Click on Setup
Click on Users & Policy
Click on Organisation Groups
Click on New Group
The box below will open :-
Configure as follows:-
Group name: Informatica (NACS CODE) - E.G Informatica A12345
Parent organisation group
Click on the house icon
Tick ‘Only show groups in this organisation and a member of’
Select the practice
Click on OK
Function/speciality
Click on the down arrow
Tick the this organisation box
Select Strategic Reporting
General description: Skyline Extracts
Membership terms
Tick Membership must be approved by your organisation
Tick Allow reporting across entire group
Tick Strategic reporting group
Click on OK
Note: If an invite box opens click on cancel
A box will be displayed advising that a new organisation group has been created and to contact the TPP helpdesk to schedule the report.
Click on OK
Configure Extract Tables And Fields
Click on Setup
Click on Users & Policy
Click on Strategic Reporting Download Configurations
Strategic Reporting : Select Informatica (NACS CODE) from the drop-down box if there are more than one configured/available.
Click New to create a new extract report (Amend can be used to edit and existing report)
The following window will open :-
Configure as follows:-
Configuration name: Informatica Reporting
Location
Root Directory:
Click on the folder icon
Type the file name C:\Programdata\Informatica\Data Extracts
Click on Select
Click YES to create
Root directory new units:
Click on the folder icon
Type the file name C:\Programdata\Informatica\Data Extracts\New
Click on select
Click YES to create
Note: At this point Skyline is not using the ‘New Units' but we’re setting up the path in advance
Options
Tick Normalised values for static lists
Tick Normalise values for locally configured lists
Untick Manage Full Download
Technical Contact
Search and select the user with Gateway permissions
Content
The box will be blank - click on the +
Highlight the following tables one at a time and click the right arrow to select
SRAppointment
SRAppointmentRoom
SRCode
SREvent
SRGPPracticeHistory
SRImmunisation
SROrganisation
SRPatient
SRPatientAddressHistory
SRPatientContactDetails
SRPatientRegistration
SRPrimaryCareMedication
SRProblem
SRRepeatTemplate
SRRota
SRStaffMember
SRStaffMemberProfile
SRStaffMemberProfileRole
The window should look similar to below with 18 tables under content:-
Click on OK to create the download report
Note: Informatica Reporting should now be listed
If you click on Informatica Reporting the configured tables will be listed similar to below.
Scheduling The Extract
Note, As mentioned above, the TPP Gateway must be running during the reporting period, which is from 9pm to 10.30am This can vary depending on the extract job finish time.
Friday evenings are apparently special in terms of generating full extracts, it’s not always possible to create a new extract and have it run a full extract before the subsequent Friday however this requires more testing by development to be sure.
Click on Setup
Click on Users & Policy
Click on Scheduled Jobs
Note: Scheduled strategic reporting may be listed, these are jobs already setup by the practice and should be ignored.
Click on the + to create a new schedule
Click on Strategic Reporting Download
The following box will open :-
Configure as follows:-
Run On: Gateway
Due: Set this to todays date and 23:00
Repeat: Tick to keep the schedule on repeat
Strategic Reporting Group: Informatica (NACS CODE)
Download Configuration: Informatica Reporting
Click the + to the right of the box displaying Informatica Reporting
Informatica (NACS CODE) should be added to the configurations to download
Click on OK
The following box will open showing the new schedule in a grey box with details.
Note, As long as the TPP Gateway is logged in, the scheduled report will begin automatically downloading at the scheduled time once TPP has activated the new organisation group.
Request That TPP Enabling The Organisation Group
The practice must email SystmOneSetup@TPP-UK.com and provide the following information:-
Practice NACS code
Name of the new Organisation Group : Informatica (NACS CODE)
Request that strategic reporting is enabled for the new Organisation group
Email Support@ishealth.co.uk once TPP have activated Informatica (NACS CODE)