Guru's Verification engine ensures consistency, confidence, and trust in the knowledge your organization shares. Learn more.

Lookup Tables

Return to Support Home


Navigating to Lookup Tables

To begin, click on the “Configuration” button located in the System Management section of the Admin Toolbar.image.png

Next, click on Lookup Tables in the drop down list.image.png

Finally, click on Lookup Tables in the new menu that appears.image.png

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.image.png

To add in a new item, please click on the New Item button located in the Lookup List Editor banner. image.png

Please remember to fill out all of the relevant fields. Once you have finished, click the Save button.image.png

To edit an existing item, start by clicking on a list from the Select List window.image.png

Next click on the item you want to change in the Active List window.image.png

Finally, click on the Edit Item button.image.png

Make all necessary corrections within this section and once completed click the Save button.image.png

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.image.png

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.image.png

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.image.png

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

image.png

Example:

Value = what will be stored in the database and shown on reports

Description = what users will see and select in the dropdown box

image.png

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.

Return to Support Home


GoRev-v2.jpg

You must have Author or Collection Owner permission to create Guru Cards. Contact your team's Guru admins to use this template.