FreeMED 0.9.x User Interface Issues
Mike
Entered new user, List Users didn't display First, Last , middle name
title and level
This new user has all possible billing rights, however he can't edit
patient data. Edit link next to the patient name is not available
(only view link is there for this user).
Found manage procedure item in the reporting submenu, not easy to
find.
Added new procedure, however it wouldn't show in the procedure list
Jeff
> rev 6082:
>
> Entered new user, List Users didn't display First, Last , middle name
> title and level
> This new user has all possible billing rights, however he can't edit
> patient data. Edit link next to the patient name is not available
> (only view link is there for this user).
Billing rights don't by default involve editing demographic data, from
what I remember. That ACL profile can be changed pretty easily.
> Found manage procedure item in the reporting submenu, not easy to
> find.
Sorry -- I'm open to suggestions about where to put that management screen.
> Added new procedure, however it wouldn't show in the procedure list
Can you check to make sure it's not throwing a database error in the error.log?
--
Thanks,
Jeff
(je...@freemedsoftware.org)
FreeMED Software Foundation, Inc
http://freemedsoftware.org/
Mike
Didn't see any errors in error.log
On May 27, 9:28 pm, Jeff <free...@gmail.com> wrote:
> > rev 6082:
>
> > Entered new user, List Users didn't display First, Last , middle name
> > title and level
> > This new user has all possible billing rights, however he can't edit
> > patient data. Edit link next to the patient name is not available
> > (only view link is there for this user).
>
> Billing rights don't by default involve editing demographic data, from
> what I remember. That ACL profile can be changed pretty easily.
>
> > Found manage procedure item in the reporting submenu, not easy to
> > find.
>
> Sorry -- I'm open to suggestions about where to put that management screen.
>
> > Added new procedure, however it wouldn't show in the procedure list
>
> Can you check to make sure it's not throwing a database error in the error.log?
>
> --
> Thanks,
> Jeff
> FreeMED Software Foundation, Inchttp://freemedsoftware.org/
Michael Duke
--
You received this message because you are subscribed to the Google Groups "FreeMED Support" group.
To post to this group, send email to freemed...@googlegroups.com.
To unsubscribe from this group, send email to freemed-suppo...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/freemed-support?hl=en.
Jeff
> biller should be able to edit coverage for sure
True -- the chances are that we're missing some stock ACL data.
Mike
I can't add a procedure. It wouldn't show up in the list.
Facility screen missing POS code dropdown field (11 -office, 12 - home
etc..)
checked mysql errors.log in /var/log/mysql, nothing exciting there...
On May 28, 11:21 am, Jeff <free...@gmail.com> wrote:
> > biller should be able to edit coverage for sure
>
> True -- the chances are that we're missing some stock ACL data.
>
> --
> Thanks,
> Jeff
Jeff
> Updated Freemed to the last rev.
>
>
> I can't add a procedure. It wouldn't show up in the list.
When you say it doesn't show up in "the list", are you referring to
the list of procedures? Please check to see whether it is showing up
in the procrec table -- it might just be a display/refresh issue.
> Facility screen missing POS code dropdown field (11 -office, 12 - home
> etc..)
That was an issue in the interface definition for FacilityModule. I
fixed it in rev 6093, please update.
( Issue was in http://svn.freemedsoftware.org/freemed/trunk/ui/gwt/src/main/webapp/resources/interface/FacilityModule.module.xml
)
Michael Duke
Mike
On Jun 4, 3:10 pm, Michael Duke <mduk...@gmail.com> wrote:
> Well...we are missing the whole table. Procrec and payrec tables are not
> there.
> This explains why I can't add procedures.
>
>
>
> > > Updated Freemed to the last rev.
>
> > > I can't add a procedure. It wouldn't show up in the list.
>
> > When you say it doesn't show up in "the list", are you referring to
> > the list of procedures? Please check to see whether it is showing up
> > in the procrec table -- it might just be a display/refresh issue.
>
> > > Facility screen missing POS code dropdown field (11 -office, 12 - home
> > > etc..)
>
> > That was an issue in the interface definition for FacilityModule. I
> > fixed it in rev 6093, please update.
>
> > ( Issue was in
> > )
>
> > --
> > Thanks,
> > Jeff
> > (j...@freemedsoftware.org)
> >http://freemedsoftware.org/
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "FreeMED Support" group.
> > To post to this group, send email to freemed...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > freemed-suppo...@googlegroups.com.
> > For more options, visit this group at
>
> - Show quoted text -
Jeff
> I would like to know what triggers creation of the procrec table.
The module indexing process loading the ProcedureModule module produces that.
You can manually load it by SOURCE-ing data/schema/mysql/procrec.sql
from a MySQL console. If there's some sort of nasty error, it could
explain why the table hasn't been properly created.
--
Thanks,
Jeff
(je...@freemedsoftware.org)
Michael Duke
Enter password:
ERROR 2 (HY000) at line 107 in file: 'data/schema/mysql/cpt.sql': File 'data/source/cpt/PPRRVU.csv' not found (Errcode: 2)
Jeff
> mysql -u freemed -p freemed <
> /usr/share/freemed/data/schema/mysql/procrec.sql
> Enter password:
> ERROR 2 (HY000) at line 107 in file: 'data/schema/mysql/cpt.sql': File
> 'data/source/cpt/PPRRVU.csv' not found (Errcode: 2)
I see the issue.
Run:
./data/source/cpt/download-and-prepare.sh
which should download all of the fee schedule files which this depends upon.
Michael Duke
Jeff
> Now afetr I run the script and rerun module indexing I can see both procrec
> and payrec tables.
>
> Question: Will the running of this script be a required step in the
> freemed install procedure ?
Yes.
> Now I can add procedures and see them in the patient procedure list, however
> when I go to Remitt Billing I don't see any entries listed to be billed.
They were added with the appropriate payers, and were set to be billable, etc?
> Question: Do I need to configure payer Remitt Assignments ( like
> paper/electronic formats ans target options) before I'll be able to see the
> billing list?
I believe so. You can use the tool/utility which allows bulk
assignments to be made if you don't want to edit every one of them by
hand.
> Question: Do I need to have Remitt running to be able to fill out remitt
> assignments?
Yes, unless you use the utility. It populates the listboxes with that
information.
(By the way, if it makes any difference, many different FreeMED
systems can share a single REMITT server, so long as each instance of
FreeMED has a separate "user" created in REMITT.)
Michael Duke
Jeff
> Actually, since I have only one payer in the system I don't need to use the
> tool.
> Dropdown list of valid (I presume) values is already provided.
>
> Still I don't see the billing list.
>
> Remitt is not running yet. I have verified that payrec table has an entry
> corresponding to the charge of $100
>
> So what is the query that populates this list? and where this code is
> located?
For the AccountsReceivable screen, it's
org.freemedsoftware.api.Ledger.AgingReportQualified (can be found in
lib/org/freemedsoftware/api/Ledger.class.php), and for the
ClaimsManager screen it's
org.freemedsoftware.api.ClaimLog.AgingReportQualified (can be found in
lib/org/freemedsoftware/api/ClaimLog.class.php).
Michael Duke
Jeff
> Sorry, I asked the wrong question.
>
> I am ready to submit claims to Remitt for processing.
>
> I selected "remitt billing" item from the Billing Menu. I expected to see
> the "Submit Claims" button.
> I don't see the button
Sorry -- I think that's my fault. Just committed a fix to reenable the
REMITT billing page, although I believe we're supposed to bill from
the Claims Manager rather than directly from the REMITT billing
screen. (I believe the workflow is to select a batch of claims and hit
"Bill", although you should also be able to do it now from the REMITT
page)
Mike
Also in claims manager list payer information is not present.
Also when procedure gets added there is no drop-down list to select
the payer to be billed from the patient coverages.
Looking into payrec and procrec tables the coverage information
doesn't get populated there, this could be one reason we don't see
payer info in the claim manager list
On Jun 8, 11:49 am, Jeff <free...@gmail.com> wrote:
> > Sorry, I asked the wrong question.
>
> > I am ready to submit claims to Remitt for processing.
>
> > I selected "remitt billing" item from the Billing Menu. I expected to see
> > the "Submit Claims" button.
> > I don't see the button
>
> Sorry -- I think that's my fault. Just committed a fix to reenable the
> REMITT billing page, although I believe we're supposed to bill from
> the Claims Manager rather than directly from the REMITT billing
> screen. (I believe the workflow is to select a batch of claims and hit
> "Bill", although you should also be able to do it now from the REMITT
> page)
>
> --
> Thanks,
> Jeff
Mike
Would I miss any of the tables if I didn't run other scripts in the
source folder during installation?
npi
icd-10-cm
drugs
What will be the correct sequence of running these data scripts in
relation to install.php, module.php to insure all freemed tables are
created?
What is the correct number of tables for the last revision of freemed
9 ?
Thanks,
sorry for too many questions
On Jun 7, 11:34 am, Jeff <free...@gmail.com> wrote:
> > mysql -u freemed -p freemed <
> > /usr/share/freemed/data/schema/mysql/procrec.sql
> > Enter password:
> > ERROR 2 (HY000) at line 107 in file: 'data/schema/mysql/cpt.sql': File
> > 'data/source/cpt/PPRRVU.csv' not found (Errcode: 2)
>
> I see the issue.
>
> Run:
>
> ./data/source/cpt/download-and-prepare.sh
>
> which should download all of the fee schedule files which this depends upon.
>
> --
> Thanks,
> Jeff
Jeff
> Jeff,
>
> Would I miss any of the tables if I didn't run other scripts in the
> source folder during installation?
>
> npi
> icd-10-cm
> drugs
>
> What will be the correct sequence of running these data scripts in
> relation to install.php, module.php to insure all freemed tables are
> created?
Generally those data scripts can be run in any order, but they should
be run before the initial install.
> What is the correct number of tables for the last revision of freemed
> 9 ?
These are all of the pieces which are loaded from external files (so
they would all need to exist for everything to load properly):
$ fgrep LOAD data/schema/mysql/*
data/schema/mysql/cpt_source.sql:LOAD DATA LOCAL INFILE
"data/source/cpt/extract/PPRRVU09.csv"
data/schema/mysql/cpt_source.sql:LOAD DATA LOCAL INFILE
"data/source/cpt/extract/OPPSCAP.csv"
data/schema/mysql/cpt.sql:LOAD DATA LOCAL INFILE "data/source/cpt/PPRRVU.csv"
data/schema/mysql/growthcharts.sql:LOAD DATA LOCAL INFILE
"data/source/growthcharts/bmiagerev.csv"
data/schema/mysql/growthcharts.sql:LOAD DATA LOCAL INFILE
"data/source/growthcharts/hcageinf.csv"
data/schema/mysql/growthcharts.sql:LOAD DATA LOCAL INFILE
"data/source/growthcharts/lenageinf.csv"
data/schema/mysql/growthcharts.sql:LOAD DATA LOCAL INFILE
"data/source/growthcharts/statage.csv"
data/schema/mysql/growthcharts.sql:LOAD DATA LOCAL INFILE
"data/source/growthcharts/wtage.csv"
data/schema/mysql/growthcharts.sql:LOAD DATA LOCAL INFILE
"data/source/growthcharts/wtageinf.csv"
data/schema/mysql/growthcharts.sql:LOAD DATA LOCAL INFILE
"data/source/growthcharts/wtleninf.csv"
data/schema/mysql/growthcharts.sql:LOAD DATA LOCAL INFILE
"data/source/growthcharts/wtstat.csv"
data/schema/mysql/icd10.sql:LOAD DATA LOCAL INFILE
"data/source/icd-10-cm/icd10.psv"
data/schema/mysql/icd10.sql:LOAD DATA LOCAL INFILE
"data/source/icd-10-cm/icd9to10crosswalk.psv"
data/schema/mysql/multum.sql:LOAD DATA LOCAL INFILE "data/multum/icd_9.csv"
data/schema/mysql/multum.sql:LOAD DATA LOCAL INFILE
"data/multum/multum_combination_drug.csv"
data/schema/mysql/multum.sql:LOAD DATA LOCAL INFILE
"data/multum/multum_dose_form.csv"
data/schema/mysql/multum.sql:LOAD DATA LOCAL INFILE
"data/multum/multum_drug_id.csv"
data/schema/mysql/multum.sql:LOAD DATA LOCAL INFILE
"data/multum/multum_product_strength.csv"
data/schema/mysql/multum.sql:LOAD DATA LOCAL INFILE
"data/multum/multum_route.csv"
data/schema/mysql/multum.sql:LOAD DATA LOCAL INFILE
"data/multum/multum_units.csv"
data/schema/mysql/multum.sql:LOAD DATA LOCAL INFILE
"data/multum/ndc_active_ingredient.csv"
data/schema/mysql/multum.sql:LOAD DATA LOCAL INFILE
"data/multum/ndc_active_ingredient_list.csv"
data/schema/mysql/multum.sql:LOAD DATA LOCAL INFILE
"data/multum/ndc_brand_name.csv"
data/schema/mysql/multum.sql:LOAD DATA LOCAL INFILE
"data/multum/ndc_core_description.csv"
data/schema/mysql/multum.sql:LOAD DATA LOCAL INFILE
"data/multum/ndc_ingredient_strength.csv"
data/schema/mysql/multum.sql:LOAD DATA LOCAL INFILE
"data/multum/ndc_main_multum_drug_code.csv"
data/schema/mysql/multum.sql:LOAD DATA LOCAL INFILE
"data/multum/ndc_orange_book.csv"
data/schema/mysql/multum.sql:LOAD DATA LOCAL INFILE
"data/multum/ndc_pregnancy_category.csv"
data/schema/mysql/multum.sql:LOAD DATA LOCAL INFILE "data/multum/ndc_source.csv"
data/schema/mysql/ndc.sql:LOAD DATA LOCAL INFILE "data/drugs/ndc_listings.csv"
data/schema/mysql/ndc.sql:LOAD DATA LOCAL INFILE "data/drugs/ndc_packages.csv"
data/schema/mysql/ndc.sql:LOAD DATA LOCAL INFILE
"data/drugs/ndc_formulations.csv"
data/schema/mysql/ndc.sql:LOAD DATA LOCAL INFILE
"data/drugs/ndc_applications.csv"
data/schema/mysql/ndc.sql:LOAD DATA LOCAL INFILE "data/drugs/ndc_firms.csv"
data/schema/mysql/ndc.sql:LOAD DATA LOCAL INFILE "data/drugs/ndc_routes.csv"
data/schema/mysql/ndc.sql:LOAD DATA LOCAL INFILE
"data/drugs/ndc_dosage_form.csv"
data/schema/mysql/ndc.sql:LOAD DATA LOCAL INFILE "data/drugs/ndc_tbl_dosage.csv"
data/schema/mysql/ndc.sql:LOAD DATA LOCAL INFILE "data/drugs/ndc_tbl_route.csv"
data/schema/mysql/ndc.sql:LOAD DATA LOCAL INFILE "data/drugs/ndc_tbl_unit.csv"
data/schema/mysql/ndc.sql:LOAD DATA LOCAL INFILE "data/drugs/ndc_schedule.csv"
data/schema/mysql/ndc.sql:LOAD DATA LOCAL INFILE
"data/drugs/orangebook_products.tsv"
data/schema/mysql/npi.sql:LOAD DATA LOCAL INFILE "data/source/npi/npi.csv"
data/schema/mysql/pqri.sql:LOAD DATA LOCAL INFILE
'data/source/pqri/2009_PQRI_SingleSource_PUBLIC_CodeMaster_120808.csv'
Michael Duke
Jeff
is it possible to reduce the height of the menu items on the left side of the screen? to eliminate the need to scroll down the browser?
Jeff
It's a CSS issue -- I have to take a shot at it with firebug to correct that.
The developers who were working on the project did a great job making
a nice looking UI, but used older CSS and HTML tricks to do things
that are much easier now with newer revs of CSS and HTML5 features ...
Mike
For the record I shall say here that the fix did work and I can see
"Perform Billing" tab and "Submit Claims" button.
This problem was solved.
Thank you Jeff.
However on the same screen I can see now 3 dropdown lists
Clearinghouse,
Billing Service,
Billing Contact,
I cannot find corresponding tables in the freemed database unlike
0.8.5 version
Mike
I do see the tables. However, I don't see these 3 modules in the
Support Data list.
Perhaps this is due to the line in the code:
var $MODULE_HIDDEN = true;
found in these 3 modules
Also submitting claims from this screen doesn't give you the feedback
link to the output file from remitt, unlike claims manager module.
So may be it was commented out for a reason.
>
> > - Show quoted text -- Hide quoted text -