Lookup Tables
Navigating to Lookup Tables
To begin, click on the “Configuration” button located in the System Management section of the Admin Toolbar.
Next, click on Lookup Tables in the drop down list.
Finally, click on Lookup Tables in the new menu that appears.
The Lookup List Editor module will now appear on your screen. To select the list relevant to your situation please click on it in the Select List section of this window.
To add in a new item, please click on the New Item button located in the Lookup List Editor banner.
Please remember to fill out all of the relevant fields. Once you have finished, click the Save button.
To edit an existing item, start by clicking on a list from the Select List window.
Next click on the item you want to change in the Active List window.
Finally, click on the Edit Item button.
Make all necessary corrections within this section and once completed click the Save button.
Lastly, you may remove an item from a list by highlighting the item you would like to remove in the Active List window and clicking the Delete Item button. NOTE: This cannot be undone once deleted.
Configuring Colors in Lookup Table
GoRev now supports the ability to color code your coding or workflow statuses. You can update a specific status color code by selecting one of the items in either FollowUpStatuses or CodingStatuses and you will see the below. Simply click Choose Color, pick a color, and then click on the Save button.
Example of new colors in use
Now that you have assigned colors you will see them show up in a new color column added to GoRev data grids in Follow Up and Coding modules.
List of Existing Look up Tables
This is the complete listing of look up tables as of GoRev version 2024.05.13. Some of these tables are reserved for internal use by GoRev support to facilitate specific functionality. The permission Look Up Tables must be granted to a user in order to access the lookup list area within GoRev. In addition to this, the Permission required below in each list indicates which security group a user must have in order to see a specific lookup table.
AdditionalCollectors
Permission Required:
Used For:
Example:
AdditionalReferralSources
Permission Required:
Used For: Populates drop down options for Referral Source in Stat Check in, New Visit, and Patient Overview
Example:
Value = what will be stored in the database and shown on reports
Description = what users will see and select in the dropdown box
AllowedModifiers
Permission Required: CodingManager
Used For:
Example:
AnesthesiaTypes
Permission Required:
Used For:
Example:
AppointmentCancellationReason
Permission Required:
Used For:
Example:
AppointmentRescheduleReason
Permission Required:
Used For:
Example:
CgenBreakoutRevenueCodes
Permission Required:
Used For:
Example:
CgenRollupRevenueCodes
Permission Required:
Used For:
Example:
CodingStatuses
Permission Required:
Used For:
Example:
CodingStatusesRequiringNotes
Permission Required:
Used For:
Example:
ContractCodes
Permission Required:
Used For:
Example:
CustomPaymentTypes
Permission Required:
Used For:
Example:
DigitalRegistrationPackets
Permission Required:
Used For:
Example:
DiscountTypes
Permission Required:
Used For:
Example:
DispositionCodes
Permission Required:
Used For:
Example:
EmploymentStatuses
Permission Required:
Used For:
Example:
ExternalAccountPrefixes
Permission Required:
Used For:
Example:
FacilityCategories
Permission Required:
Used For:
Example:
FileCategories
Permission Required:
Used For:
Example:
FileCategoriesAutoSendToPortal
Permission Required:
Used For:
Example:
FileCategoriesVisibleToPatient
Permission Required:
Used For:
Example:
FinancialStatuses
Permission Required:
Used For:
Example:
HoldRevenueCodesInClearinghouse
Permission Required:
Used For:
Example:
InboundFaxCategory
Permission Required:
Used For:
Example:
InboundFaxRoutes
Permission Required:
Used For:
Example:
InsuranceGroupFileCategories
Permission Required:
Used For:
Example:
InsuranceGroupFundingTypes
Permission Required:
Used For:
Example:
InsuranceGroupPaymentMethods
Permission Required:
Used For:
Example:
InsuranceGroupPlanTypes
Permission Required:
Used For:
Example:
InventoryCategory
Permission Required:
Used For:
Example:
InventoryLocation
Permission Required:
Used For:
Example:
InventoryUnitsOfMeasurement
Permission Required:
Used For:
Example:
LabContainerTypes
Permission Required:
Used For:
Example:
LabCustomSpecimenTypes
Permission Required:
Used For:
Example:
LabCustomSpecimenTypes
Permission Required:
Used For:
Example:
LabOrderPanelCategories
Permission Required:
Used For:
Example:
LabResultStatuses
Permission Required:
Used For:
Example:
OpenCareDataShard
Permission Required:
Used For:
Example:
PatientOccupations
Permission Required:
Used For:
Example:
PatientRelationships
Permission Required:
Used For:
Example:
PersistentCodingStatuses
Permission Required:
Used For:
Example:
PlanTypes
Permission Required:
Used For:
Example:
PortalMessagingFolders
Permission Required:
Used For:
Example:
PortalResultStatusesDoNotNotify
Permission Required:
Used For:
Example:
PostingClassifications
Permission Required:
Used For:
Example:
PreregistrationEmails
Permission Required:
Used For:
Example:
ReferenceLabs
Permission Required:
Used For:
Example:
ResourceFileCategories
Permission Required:
Used For:
Example:
ServiceTypeGroups
Permission Required:
Used For:
Example:
ServiceTypes
Permission Required:
Used For:
Example:
ShelfDevice
Permission Required:
Used For:
Example:
ShelfLocation
Permission Required:
Used For:
Example:
ShelfRoom
Permission Required:
Used For:
Example:
ShelfTag
Permission Required:
Used For:
Example:
ShelfType
Permission Required:
Used For:
Example:
ShipmentCourier
Permission Required:
Used For:
Example:
ShipmentStatus
Permission Required:
Used For:
Example:
StateBoardTitles
Permission Required:
Used For:
Example:
StatementRevenueCodeDescriptions
Permission Required:
Used For:
Example:
StatementServiceTypeDescriptions
Permission Required:
Used For:
Example:
VisitCustomValues
Permission Required:
Used For:
Example:
VisitStatuses
Permission Required:
Used For:
Example:
Additional Resources
GoRev Support Team
If you have any additional questions or concerns regarding this tutorial, please contact the GoRev Support Team by phone at (317) 794-3900 or by email at ask@gorev.com
Note: Always submit an IT Support Ticket detailing the problem that you are experiencing with this portion of GoRev, if possible, as this will give GoRev Support Agents access to information that will help expedite the resolution of your issue. If you are unsure how to submit an IT Support Ticket in GoRev, please see the IT Support Ticket Creation tutorial for assistance.