#21 MedBase / MEPS Strength Audit

[Dave Andrus]

Background:

Chris Tyler manually stepped through a process to
reconcile, correct, and prove that their MEPS data
matched up 100% to the MedBase data. Recently, a
similar issue at WBAMC popped up and it is likely that
the same procedure will have to be performed. As Neil
succinctly described, "This is a process problem
throughout the entire region -- If the extended status
and unit for soldiers is not maintained, it will wreck
significant havoc with the MedBase numbers."

Vision:

Define a method that summarizes and communicates
accountability discrepancies between MedBase (as the
standard) and MEPS (as the comparison) to key SRP,
S1, and Command personnel so they can see (at a
glance) the impact that poor in-processing and out-
processing discipline has on the reports going up to
GPRMC. Statuses should be summarized in a Green-
Amber-Red using similar thresholds for success/failure as
the QTB. Finally, we need to publish (and provide to the
failities) a set of best practices / lessons learned
describing the bare-minimum in/out processing that must
be done in the system to achieve a RED rating; what
must be done to achieve AMBER; and what must be
done to achieve GREEN.

[Dave Andrus]

Logged In: YES
user_id=97668

As an addendum to this vision, there needs to be a way to
record the over-all success rate over time and plot an MTF's /
the region's success that shows performance trends.

[Neil Watkins]

Logged In: YES
user_id=950643

At IACH, I have provided the IMR (Command Med Readiness)
reports to the users via MEPS Generic Reports. The leaders
can change the selected population using the standard
MEPS-TH $OrgEntityID$ variable that displays the
oragnization tree. The report shows all 31 elements of the
IMR and a G for Go and N for NO GO. Also, if it does not
apply (males don't need pregnancy tests) then you get a G.
This part is defined by the MedBase PO as it utilizes the
SPRT.Command_Med_Readiness view. Through the use of
Generic Reports, I also send a list of all users who are not
inluded in the GPRMC Command Medical Readiness report
since they have never had an IMR in MEDBASE. This allows
the command to focus on gettting the individuals up-to-date.

[coloradocwboy]

Logged In: YES
user_id=1026167

Neil, I beleive we have the same basic concept in place. Are
you pulling this data real-time or on a schedule? I'm only
pulling the data over twice a day or on demand when needed.
I found to transfer the just the immunizations data it can take
up to 20 mintues. Unless you have a better process.......

[coloradocwboy]

Logged In: YES
user_id=1026167

Requirements Doc added.

[coloradocwboy]

Logged In: YES
user_id=1026167

I've attached a copy of the Rough Draft Admin Guide. All I
really need is the setup doc for the Oracle client from Neil
and I should be able to get this out to everyone.

[coloradocwboy]

Logged In: YES
user_id=1026167

Moving files to new project.