Super Script – Netsmart MIS/EHR Conditional Changes to Data (DST) Values
The Super Script that we developed and use regularly for Netsmart (previously CMHC) MIS/EHR allows changes to the Netsmart MIS database(s) when one or multiple data elements must be changed based on specific criteria.
Script behavior:
Ø The super script is used to
update both record and stand-alone DSTs (data elements) using conditional
logic.
Ø The script can make changes either
to a list of registers or to all registers in a database.
Ø The script produces two files in
the print queue: One file contains the
logic used to determine when a change to the database should be made and the
other shows changes that were made and to which registers.
Ø Both stand-alone DSTs as well as
record DSTs can be updated.
Ø DSTs values can be copied from
one database to another (databases must be linked with a DST containing a
register ID).
Ø When updating DSTs the script can
link from one database to another so that changes can be coordinated between
databases. This functionality is sometimes used to make changes to claims,
ISNs, and events simultaneously.
The script
can make multiple updates from one set of conditions, or multiple updates from
multiple sets of conditions. In other
words, the script can update multiple DSTs (data elements) from one set of
conditions, or multiple sets of DSTs (data elements) from multiple sets of
conditions. For example:
Multiple DSTs from one set of
conditions:
For all clients:
If C.STATE = "OR" and C.ZIP = "97217" then set
C.COUNTY to a value of "1" (Multnomah)
Multiple DSTs being updated from
multiple sets of conditions:
For all clients:
If C.STATE = "OR" and C.ZIP = "97217" then set
C.COUNTY to a value of "1"
(Multnomah)
If C.STATE = "WA" and C.ZIP = "98001" then set
C.COUNTY to a value of "17" (King)
Use the superscript to:
Ø Update database record layers
based on multiple DST values within a record.
Ø Coordinate updates between
claims, ISNs, and events with the same changes at the same time.
Ø Update stand-alone DSTs based on
the specific values of other DSTs.
Ø Simultaneously make multiple
changes to data based on multiple conditions sets.
Ø Delete record layers based on the
DST values within the record.
Limitations:
Ø The current super script cannot
add DST layers. It can only change existing data or remove data.
Ø The script only accesses one
record layer per update. You cannot use the data in one record to determine if
another separate record is to be updated.
Possible additional script features:
Ø A feature can be added to allow
for undoing DST changes after they are made.
Ø Recode tables can be integrated
into the script as a means of specifying the changes to be made.
Ø A modification could be made to
the script to allow for the adding of data layers.
No comments:
Post a Comment