Click Setup on the Main menu to see the Setup form.
Click the blue link to the left of any of the ten folder fields to see the files in that folder. Client Code, Logo, Director and Screen Txt are used to customize the Tox report.
Logo is the default logo for the Tox report. The file is stored in the same folder as the data tables. If there is a file with the same name as the Cust with the same extension as the Logo in the table database folder, it is used instead. For example, if the database tables are in z:\work\, the Logo file is Logo.gif and the Cust on the Accession form is ADX, the report would use z:\work\ADX.gif as the logo if it was found, otherwise it would use z:\work\logo.gif.
If you can specify the filename of scans, the Doc form will rename those files in the Scan folder and move them to the Doc folder.
The HL7 File field looks for files with the extension of .HL7 in the LTIn Folder. Select the HL7 File and click Import to import the HL7 results into the AccessionDetail table. The function uses the OBX segment to fill the Res and Qty fields, NTE for the Comment, MSH to verify HL7 format, PID to verify the Patient matches and ORC to verify the AccessionID. After the batch has been imported, it moves the HL7 file to the ImportFolder\Completed folder and opens the Accession form to the selected records.
If ORM is checked, the app looks for .HL7 files in the HL7In Folder. This function imports a single HL7 record to the Accession table and sets up the AccessionDetail records for the screening and confirm panels. It uses the MSH segment to verify HL7 format, PID for patient data, ORC for the TMRecID foreign key into another system, IN1 for insurance data, PV1 for practitioner and NPINo, DG1 for ICD10 conditions, RXO for meds the patient is taking and OBR for panel and test data. After import, the file will be moved to the HL7In\Completed folder and the Accession form will be opened to the imported record.
Template specifies the Excel file used for DNA analysis. It is limited to 80 samples.
ImpBF imports the BioFire File from the BFFolder. This file is in XML format and creates 11 temporary tables in Access. The tables update results in the AccessionDetail table and the comment in the Accession table. After import, the file is moved to the ImportFolder\Completed forlder and the Accession form is opened to the correct record.
To view any raw table in the system, select it in the Table combo and click View or to export it to CSV, DBF (dBase, FoxPro, Clipper), HTM (for web browsers), MDB (Access), RTF (Word or WordPad), SNP (free Access reader from Microsoft), TXT or XLS (Excel) formats.
Click Edit to open a form to edit the records in a table. The New button will be disabled if a related form must be open to add a new record. For example, New on the Invoice form might be disabled if Contact isn't open.
While viewing a table, you can drag the column headers into the order you want, highlight several columns together and right click, sort A-Z or Z-A. When you are done viewing, answer NO when asked if you want to save the table layout.
Click TblDoc to see a full data dictionary of the system including field definitions. This HTML document is opened in your browser.
The User form lets the Super user add or edit users. Normal users are limited in the data they can edit on themselves, but they can change their password here.
More info on setting up users
Click Link to change where the data tables are located. If you see the box asking where the data tables are upon opening the database, you may have a network error and should call for support to avoid storing your work in the wrong location.
Backup quickly saves a copy of the data tables to another location such as a flash drive.
Quit to force users out of the database for maintenance.
Compact rebuilds the indexes, repairs and reduces the size of the tables database. This requires exclusive access to the database, so it is best done after work. You can use the Quit function if people are widely distributed. If you change lots of data, you will notice improved performance if you compact weekly.
ViewAlt lets you view raw data in another database. Set the database path in the AltDB field and select the table in the Table combo. Click ViewAlt to see the data read-only.
The ICD form shows illnesses or medical conditions by ICD10 code. You can enter a short description if desired. These codes are used to build an ICD10 string for each patient in the Accession table.
Enter insurance companies on the Insurance form. This data is used by the Payment subform on the Accession form. If there is a match, fields from this table are automatically filled in on the Payment subform.
Enter medications on the Med form. If there is a test in the Test table that will show positive for a med, use the TestCode with an M instead of an S for screeing or C for confirmation. Use the DEA drug class for those test codes. For example, the med code for Oxycodone (Class EEE) is EEE-M1. The screening test code would be EEE-S1 and the confirmation test code would be EEE-C1. If you add a comment like Oxymorphone can be a metabolite of Oxycodone, it will appear on the Tox report when Oxycodone is detected.
Panels are collections of tests. A CCP Comprehensive Confirmation Panel might contain more than 100 tests and thus save a great deal of data entry when requesting a group of tests. You must associate the tests with each panel. You can uncheck a test on the AccessionDetail form to remove it from that accession. The number of accessions at the bottom of the form lets you see how popular that panel is.
Contact info for requesting doctors or practitioners is entered on the Practitioner form. Select the salesperson associated with that practitioner. This data is automatically filled into the Accession form based on the NPINo.
Tests can be either screening (positive, negative or equivocal) or confirmation (quantitative results within a valid range). The LTCode lets you translate data from an external system. Class is the DEA drug class. The Compound should match the name of the test in the LCMS machine. The ShortTitle appears on the Tox report. Use the Class in setting the Test code. A-C1 would be the first comprehensive test you offer in DEA class A. Enter the RangeMin and RangeMax and Neg for comprehensive tests. Check Inactive when the test is no longer performed to retain the range info. Click Panels at the bottom of the form to see the panels in which this test is included.
The Combo form lets you edit tables in your system that only have one or two fields (Batch, BilledTo, BillingType, Category, Class, CreatinineFlag, Cust, DocType, Font, Gender, PanelType, PayerType, Priority, Race, Relationship, ResGroup, Salesperson, SGFlag, Specimen, Status, SubClass and TestType) without having to use separate forms for each table. Enter a decimal value in the Sort field to control the order in which the values are displayed. Use the Comment field to show the level of the salesperson.
The Data Integrity form contains queries that expose problems with your relational data. Click Calc to count the problems for each query. Click Calc1 to count the problems with only one query. As you scroll through the queries, you will see the description and Fix for each problem. Click SQL to view the raw SQL of the query. Click View to view the records returned (read only). Click Export to save the query to CSV, DBF (dBase, FoxPro, Clipper), HTM (for web browsers), MDB (Access), RTF (Word or WordPad), SNP (free Access reader from Microsoft), TXT or XLS (Excel) formats. Click Sel to select the records returned in the query. To edit the problem records, open the form and find for |SEL|. If the problem can be corrected automatically, a Fix button will appear between Calc and Sel.
Color lets you set the form color for different users or to show a difference between normal and super users. Click GetColor to get the color property that is currently used. Check Super for super user or uncheck it for normal users. Click the + or - key by Red, Green or Blue to experiment with different colors or click Web to see a palette of web colors. When you find a color you like, click Save to save it for all forms for all users or super users. The default color is 41975984.