DIMHIREDCOMMISSION

This dimension table stores information about the placement commission.

Columns

Column	Data type	Description
AMOUNT	NUMBER	Commission Amount.
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.
COMMID	NUMBER	The unique identifier for the Commission hired record.
COMMISSIONTYPEID	NUMBER	A foreign key referencing a commission type in the DIMCOMMISSIONTYPE table.
COMMISSIONTYPEKEY	NUMBER	A foreign key referencing a commission type in the DIMCOMMISSIONTYPE table.
CUSTOMERKEY	NUMBER	A foreign key referencing the customer record in the DIMCUSTOMER table.
HIREDCOMMISSIONKEY	NUMBER	The primary key referencing a placement commission.
HIREDKEY	NUMBER	A foreign key referencing a placement in the DIMHIRED table.
PERCENTAGE	NUMBER	Commission Percentage.
REQHIREDID	NUMBER	The identifier for the placement / assignment.
REQID	NUMBER	A foreign key referencing a job requirement in the DIMRPTREQ table.
REQKEY	NUMBER	A foreign key referencing a job requirement in the DIMRPTREQ table.
USERID	NUMBER	A foreign key referencing a user to whom the commission is provided in the DIMUSER table.
USERKEY	NUMBER	A foreign key referencing a user to whom the commission is provided in the DIMUSER table.