Here’s a big picture look on how data functions within SimplyComp.
Compensable Events are where you can bring in your raw data. These tables normally contain order information like amount fields, owners, order type, date, etc and is considered your main data.
Compensable Reports are copies of your Compensable Events. These copies allow you to filter and manipulate your Compensable Event data to get it calculation ready. These manipulations include applying mathematical formulas to your data and bringing in Lookup Columns.
Lookup Tables contain your reference data. This data is needed to run calculations, but is not part of your main data. Some examples of reference data can include your hierarchy, teams for named relationships, cost per unit, release dates for deals, etc. These tables function like VLOOKUPS in Excel to take a column in your Compensable Report, match a column in your Lookup Table, and return another column from your Lookup Table into your Compensable Report.
The example below explains a common setup we see within SimplyComp.
The Compensable Event below shows the majority of the deal level information.
The Compensable Report is a copy of the Compensable Event with filters and columns (orange rectangles) added to the table. In this instance, people are paid off of New Deals (Payment Rule not pictured). The filter is selected for only this deal type (See “Filters” at the top of the table). All deals that are not excluded from this filter will be paid out with the New Business Payment Rule.