DIMCOMMISSIONTYPE

This dimension table stores information about commission types.

Columns

Column	Data type	Description
BUILDID	NUMBER	Avionté’s unique identifier for each of its customers’ instances or builds. The value in this field is the same for all rows.
COMMISSIONTYPEKEY	NUMBER	The primary key referencing a commission type.
COMMTYPEDESC	NUMBER	The commission names. Most common commission names are Sales Rep Commission and Recruiter Rep Commission.
COMMTYPEID	NUMBER	The unique identifier for the Commission Type record.
CUSTOMERKEY	NUMBER	A foreign key referencing the customer record in the DIMCUSTOMER table.