|
|
|
Legacy
Talons changes 2000-2001
Table of Contents
Check Saved XV Fields for changes
Add
Contract Role and Type to HKDZNR in XV
Add NMDS
Specialty to HKR8CD in XV
Split
Extract XVI by Feeder System
Create
Boarder Bedday and PDS Feeder Keys
Add User
definable cut off date to XV Record Re-extraction
Change
Feeder System on surgery minute products from UNIT to THTR
Change
“Days since last discharge” to show 999
Change
code table filenames to include an extension of .TXT
Add
Ordering Doctor and Actual Charge fields for AUSLAB in XVI
Add
Triage Category to HKD5NR in IPXV
Changes to Feeder system names at Multi-campus sites.
New Product names for EDIS and EMG2.7.
As part of the updates, three sections of the manual
have been revised, and a number of new data elements added to the spreadsheet.
Manual Additions include
Start Background Extracts
Check Saved XV Fields for changes
Saved XV data start date
These changes are
also at https://www.csh.com.au/qldt2man.htm
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. The date entry Screen will display
Figure 2 Date Entry Screen, CSH.PERIOD
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. 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)
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.
Figure 3
Launch Options
Both processes may be started together.
The following screens pertain to EX.XVI.UNIX,
which creates utilisation extracts.
The first screen will tell you if the
pre-requisite data from third party systems has not been loaded. This only
indicates that the loading process has been done, and the number of records
loaded.
Figure 4 Prerequisite Data loading &
processing
You may choose to exit at this point to run the
appropriate prerequisite, if all are in order, you will not be prompted.
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>>>>
Figure 5 List of process subroutines to be run.
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.
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 fun 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, The 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
If you choose to re-process while not
re-selecting, the data may change very slightly if 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.
A prompt for the time and date to sleep until
processing will commence will then appear. 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. Your IMSU 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.
Figure 6 Time for Bed?
Enter the time in 24hour clock, press space
<enter> to run now.
The following screens relate to running the
demographic and medical records extract XV.
Figure 7 EX.XV.IPz.zz.UNIX Options
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.
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 indefinitely
until this date is put back (if ever). This date complements but is separate
from the Saved information date. You must match the dates if you wish to do
retrospective checking. One date set the limit how far back to look, the other
date limits discharges prior to the date entered.
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.
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.
Check
Saved XV Fields for changes
This screen will run the CHECK SAVED
INFORMATION process, see below. It should be run about once every couple of
months. You can change the date here (see below). This process can also be
optionally run with the XV extract, however it should be run here for
preference.
This screen allows the start date for
monitoring a number of set fields for changes.
The fields include changes to any one of the
following data elements.
|
Data Element |
File details |
|
Admit
date |
Admissions
File |
|
Disch
Date |
Admissions
File |
|
DRG |
MED-REC
file |
|
Account
class |
Admissions
file, Account class at admission. |
|
LOS
- Leave |
Admissions
file, detects changes in leave status |
|
Principle
Diagnosis |
MED-REC
file |
|
Discharge
Code |
Admissions
file |
|
Principle
Procedure |
MED-REC
file |
|
Days
On List |
EAM.ELECTIVES |
|
Wait
List Category |
EAM.ELECTIVES
|
|
NMDS
Specialty |
EAM.ELECTIVES
10 , EAM.UNITS |
|
Contract
Role |
ADMISSIONS
|
|
Contract
Type |
ADMISSIONS
|
|
Admission
Type |
ADMISSIONS
|
|
SNAP
Group |
SNAP
data as extracted |
|
Care
type |
From
Admissions File |
|
SNAP
Days |
SNAP
Data as extracted |
Add Contract
Role and Type to HKDZNR in XV
Add the concatenated contract role (ADM-PARAMS,CONTRACT.ROLE file, Attribute 1) and contract type
(ADM-PARAMS,CONTRACT.TYPE
file, Attribute 1) to HKDZNR, “MRI Phone Exchange” Field 74,
Start Position 607, Length 2 to XV.
If blank, send blank. This information is mandatory in HBCIS for
patients with an Admission Source of 11, 12 or 13 or a Discharge Code of 10 or
11.
File name: ADM.CONTRACTED.CARE
Contract Type
- Attribute
2
Contract Role - Attribute 3
Documentation ; Spreadsheet
Altered. Note - Not numeric anymore, Marked with Grey Highlight
Installation Notes
Create Q-Pointer to ADM.CONTRACTED.CARE file in ADM Account.
Add NMDS
Specialty to HKR8CD in XV
Add the NMDS Specialty (EAM.SPECIALTY file,
Attribute 2) to HKR8CD “MRI Expired Code” Field 66, Start Position 586, Length 2 to XV.
Attribute 10 of the EAM.ELECTIVES file has the
Unit code, which can be looked up in the EAM.UNITS file attribute 2 to give the
EAM Specialty code.
Documentation ; Spreadsheet
Altered. Marked with Grey Highlight.
Installation Notes,
Create Q-Pointers to EAM.UNITS,
Install Subroutine CSH.EAM.2,
Install EX.XV.IP10.3.UNIX.
Split
Extract XVI by Feeder System
This
should be done as per Jim White’s suggestion. An option to allow sites to
choose between a split XVI and a combined XVI should be made available. Split
Extract XVI by Feeder System.
See Quote re AUSLAB and PDS factors, (not all PDS) including
point 14. No combined option will be allowed, it will have to be run from a
separate menu option Sites will either have the combined option and use it, or
stay as they are and not have the menu option. There will be no user option to
alternate.
Installation Notes
Install TALONS.INCLUDES IP.OP.INCL.T2 with Feeder Index Changes
Update APP XVI routine to Create XVOP.REC Feeder Index
Check EMG2.7 Makes call to
IP.OP.INCL.T2
Check EDIS Makes call to IP.OP.INCL.T2
Install EX.XVI.LAUNCH.PHANT Update
Install EX.XVI.UNIX Update
Install EX.XVI.PDS2.9E Update
Install EX.XVI.AUSLAB.UNIX New Program
Update TP LAUNCH.OPTS, add EX.XVI.AUSLAB.UNIX Option
Within the Start Background Extracts
parameters add a field for setting the date to run as well as the time to run.
Installation Notes
Install EX.XVI.LAUNCH.PHANT Update
Install EX.XVI.UNIX Update
Install EX.XV.IP10.3.UNIX New Program
Update TP LAUNCH.OPTS, modify EX.XV.IP10.3.UNIX Option
Design Talons to automatically run Extract XV
after Extract XVI, if Extract XV has been flagged to be run by the user.
Installation Notes See Above
Age calculations
should be modified to reflect the following:
Age calculations Age Days for all ages be total number whole days from
birth to admission date.
Age Days is greater than 99 then blank. Field 90 Start position 670 length 2
Age Months is greater than 99 then blank. Field 91 Start position 672 length 2
When no date of birth Age Months and Age Days should be blank.
Documentation ; Spreadsheet
Altered. Marked with Grey Highlight.
Installation Notes
Install EX.XV.IP10.3.UNIX New Program
Update TP LAUNCH.OPTS, modify EX.XV.IP10.3.UNIX Option
Create
Boarder Bedday and PDS Feeder Keys
For
Feeder Systems UNIT and WARD,
If
Feeder System = UNIT and Admit Type = 08
Then
create a Bedday Feeder Key with a procedure code of BEDDAY#B in lieu of either
a BEDDAY#P, #S or #R.
For
the PDS records:
Where
the Admit Type is 08 create A, P and N feeder keys that have the suffix X#B in
lieu of feeder keys that have the suffix X.
Installation Notes
Install EX.XVI.PDS2.10E Update
Install EX.XVI.ADM2.10.4.MC new program
Add User
definable cut off date to XV Record Re-extraction
Modify Talons to allow the user to
specify a date from which discharged records will not be included within the
XV. If no cut-off date is specified then all records with changes to critical
fields should be extracted. The date entered should be maintained as the
default for subsequent processing. Sites want to be able to close data sets
from previous financial years. A choice between "Select any records
changed from start of Previous financial year" and "Select only
records changed from Current financial year" would probably be sufficient.
Installation Notes
Install EX.XV.IP10.3.UNIX New Program
Update TP LAUNCH.OPTS, modify EX.XV.IP10.3.UNIX Option
Change
Feeder System on surgery minute products from UNIT to THTR
Change
Talons so that the feeder key for ORMIS and TMS surgical minutes products
displays THTR as the feeder system and not UNIT for the new financial year.
This is a management issue within TII. In the volume interface, products are
presented grouped by feeder system. Much of our crystal reporting is also
structured around departmental reporting by feeder system, by product. Tagging
surgical minutes with "UNIT" excludes them from inclusion within the
THTR grouping.
Installation Notes
Modify each sites TMS/ORMIS program to remove “UNIT” in quotes and
replace with FEEDER$ variable
Change “Days
since last discharge” to show 999
Field
HKEONR “MRI Group 2 Sec Procs” is populated by Talons with the number of days
since last discharge. This field is only 3 characters long hence requesting
this change. Change to show 999 where greater than 999
Installation Notes
Install EX.XV.IP10.3.UNIX New Program
Update TP LAUNCH.OPTS, modify EX.XV.IP10.3.UNIX Option
Change code
table filenames to include an extension of .TXT
Change
Talons so that code tables FTP’d to Transition host appear with extensions .TXT
as well as filenames.
Installation Notes
Install EX.TABLES.UNIX Update
Change
Talons so that the following additional fields are checked for “Change info”
during the Talons medical record extract routine.
|
Field Name |
HBCIS
Filename |
Attribute
Number |
|
Days On List |
EAM.ELECTIVES |
Calculated from Date on list and admission date. |
|
Wait List Category |
EAM.ELECTIVES |
21 |
|
NMDS Specialty |
EAM.ELECTIVES 10 , EAM.UNITS |
10/2 |
|
Contract Role |
ADMISSIONS |
?? |
|
Contract Type |
ADMISSIONS |
?? |
|
Admission Type |
ADMISSIONS |
9 |
|
SNAP Group |
SNAP data as extracted |
|
|
Care type |
From Admissions File |
|
|
SNAP Days |
SNAP Data as extracted |
|
Re-flag all records discharged since 01/07/1999
for re-extraction with inclusion of the new fields, such as NMDS Specialty.
Installation Notes
Install EX.XV.IP10.3.UNIX New Program
Update TP LAUNCH.OPTS, modify EX.XV.IP10.3.UNIX Option
Install CHECK.SAVED.INFO update
Add Reflag Option to Setup Menu
Install XVIP.REFLAG Screen and Routines XVIP.REFLAG.SUB
Modify Talons to bring through the
anaesthetist field (TMS Scout Sheet, Attribute 13) and equivalent in ORMIS, add to Extract XV Field 61 Start Position 567- HKNECD (6th Doctor, 5th
Physician).
Documentation ; Spreadsheet
Altered. Marked with Grey Highlight.
Installation Notes
Install EX.XV.IP10.3.UNIX New Program
Update TP LAUNCH.OPTS, modify EX.XV.IP10.3.UNIX Option
Add Ordering
Doctor and Actual Charge fields for AUSLAB in XVI
Modify
Talons to populate the Ordering Doctor and Actual Charge fields in Extract XVI
from the “Requesting Department” and “Procedure Input Actual Charge” fields
within the AUSLAB Extract Specification
V1.6.3.
Agreed and understood
meaning of specification
Deferred due to absence of data, changes made to code to allow information
Add Triage
Category to HKD5NR in IPXV
Modify Talons to populate the Triage
Category in Extract IPXV for patients with an emergency attendance immediately
prior to the inpatient episode. This should be coming through in XV to HKD5NR
“MRI Trauma Count” Field
84, Start Position 637, Length 3 and is currently not being calculated.
Documentation ; Spreadsheet
Altered. Marked with Grey Highlight.
Installation Notes
Modify Each sites EMERG or EDIS program to call to IP.OP.INCL.T2 without
setting clinic = EM to ascertain IP Episode
As at 1 July 1999 the anaesthetic
codes in TMS changed from 2 characters to 3 characters. The anaesthetic type is
stored in Extract XV, HKNFCD “MRI Anaesthesia Type”, Field 62 start position 577, length 2.
Currently the first two characters of the anaesthetic code are brought through
into Extract XV. These are not unique, creating 3 duplicates. However, the
combination of the first and third characters of all anaesthetic codes are
unique. (The reference table is shown below) Please modify the pick routine to
populate the XV field with these two characters, rather than the first and
second.
Documentation ; Spreadsheet
Altered. Marked with Grey Highlight.
Installation Notes
Install EX.XV.IP10.3.UNIX New Program
Update TP LAUNCH.OPTS, modify EX.XV.IP10.3.UNIX Option
Changes to Feeder system names at
Multi-campus sites.
In
order to ensure no confusion regarding Ward and unit codes, several feeders
have the Feeder system name changed to reflect the Campus code in use. Only applies to MAT, RDC and FCD.
New Product names for EDIS and
EMG2.7.
Minutes-nn has been altered to TRMIN-nn in line
with changes requested by QH earlier in the year but deferred to start of year
for some sites. Mainly applies to EMG2.7
The impact will mean some extensive reallocation
of intermediate products and adding new products.