Notes
Slide Show
Outline
1
Running Extracts
  • Starting Background XV & XVI extracts.
  • Running Auslab Extracts
  • Running Other Extracts


2
Start Background Extracts
  • This is the major processing option and allows all normal monthly extracts to be created.
  • Extracts started in this way will run as what is known as TIPH jobs, (Terminal Independent Process handler). Some may know of them as Phantom Jobs.
  • After the Job is launched, your screen will return to the menu. You may log off or disconnect, or be disconnected, and the Job will still complete.
3
Date Entry Screen
CSH.PERIOD (1)
  • This allows the entry of financial year and calendar period, the combination of terms is used to ensure that no confusion exists in the mind as to what is being asked for.
4
Date Entry Screen
CSH.PERIOD (2)
  • Enter the first year date e.g. for 1996-1997 enter 1996, then <enter>, then the calendar month as a number then <enter> (e.g. 7 is July), then confirm with a Y <enter>. If you do not confirm, you will be re-prompted, if you press <esc> then <enter> you will return to the menu.
  • A list of periods processed and the dates they were processed are shown. (Note this screen is compliant with Y2K issues)
5
Satellites Sites
  • Another screen will follow prompting for the Accounts,  date and time to run. Date and time in 24 hour clock should be used.
  • If satellites are to be launched they will list here and can be de-selected if required.
  • Your ISU will advise you of when they would prefer you to run extracts, taking into consideration processing demands on your system. The process will run even if you log off your terminal, only a reboot of the CSC Reality database or action by Systems staff to kill the job will prevent it from running.
6
Launch Options
  • Following this screen you will be prompted for the tasks you wish to start, EX.XVI.UNIX & EX.XV.IP.UNIX. You may start one or both. In the future there may be more processes that can be started in this screen, and the process names (as here) may vary.
  • Both processes may be started together.



7
EX.XVI.UNIX Options
  • The following screens pertain to EX.XVI.UNIX. This process creates utilisation extracts.
  • The first screen will tell you if the pre-requisite data from third party systems has or has not  been loaded. This only indicates that the loading process has been done, and the number of records loaded.
  • A purge may have deleted the data, and it may still list in this location. If you have not purged the period, this is not an issue.
  • You may choose to exit at this point to run the appropriate prerequisite, if all are in order, you will not be prompted
8
Prerequisite Data loading & processing
  • The next screen allows you to choose which of the several subroutines you may choose to reselect the data file for and then process.


  • Unless you know what you are doing always say "Y" for yes


  • Processes will be run regardless for modules if the period has not been run before for that module.
  • Re-Selection  only relates to the data file as it exists on the HBCIS system or a pre-loaded Talons third party file, it does not relate to re-importing or re-loading the Third party file from the FTP server.
9
Prerequisite Data loading & processing
10
Process subroutines to be run.
  • You will be prompted with the following
    This option will RE-select data from main data file rather than use a previously saved list of data (Almost always use 'Y')
  • THIS OPTION DOES NOT DISABLE A FEEDER
  • When extracts are run for any period, a list of the "Selection" from the data file is saved, If you choose to "NOT" reselect from the data file when repeating a run this existing list will be used,
  • If you then choose not to re-process the extract data, the Output products will be exactly the same as the last time the extract was run for that period.
  • You will be prompted with this as a reminder
    RE-PROCESSING will re-crunch the data and will always occur if the data is RE-selected (Almost Always use 'Y')
    THIS OPTION DOES NOT DISABLE A FEEDER
11
Process subroutines to be run
  • If you choose to re-process while not re-selecting, the data may change very slightly if  in the source data file, existing records have been altered or updated in any way,
  • If you choose to reselect, then re-processing will automatically occur, and any new records will be added to the extract, and any changes to existing records will reflect in the output.
  • In general, always re-select and re-process Y & Y unless you are confident you know what you are doing, why you are doing it, or have been asked to do it by CSH or Allegiance staff.
  • The Phantom will launch now, but will go dormant before actually processing any data until the next occurrence of the time specified on the date specified.
12
EX.XV.IPz.zz.UNIX Options
  • The Options for the XV IP are simple.


13
EX.XV.IPz.zz.UNIX Options (2)
  • You may choose to force a reselect of the file (normally choose "Y"). You may also choose to monitor for changed admissions in the current and last financial periods. This should be done at least once a month, but use the option in the codes setup menu in general to do this.
  • The “file” or “Data File” is the HBCIS Admissions file. Re-selecting from it will look at this file and select Admissions  and Inhouse (Patients Treated) in the period requested in the prior screen. If you select N, it will use the last SAVED LIST of episodes for that period, if there is one, or SELECT anyway if not.
  • Check Saved admission information option will check saved copies of certain data elements for changes. It will look at all admissions back as far as the option in the Mapping And Codes Menu “Saved XV data start date”. This date should be changed from that menu annually once changes in the prior year are of no further interest.
14
EX.XV.IPz.zz.UNIX Options (3)
  • The Cut-off Date for old data will cause only data after and including this date to be extracted. This date can be changed backwards and forwards. Data being held for extract due to changed Admissions information with discharge dates prior to this date will be held. This cut off date overrides any of the previous data inclusions, however changing it back in time will catch previously flagged changes
  • In addition you will be prompted for the time and date to start this extract unless you have just set off an XVI extract, in which case the XV will automatically be set to follow the data gathering of the XVI to ensure all XV data sourced from running and XVI is included.


15
That’s all folks
  • The TIPH extracts will run, printed reports will be output to the spooler options set as system default and extract files created and placed in the appropriate locations.
  • All tasks will be run in the order required and under normal circumstances no other action will be required. You may choose to run your EX.XV.IP.UNIX.ZZZ as often as you wish, weekly would be normal. The EX.XVI.UNIX extract (utilisation) must be run Monthly about 14 days after the end of the month after all other required data has been loaded and processed. The VIII and XXI files are produced in this extract as well.