DIMACTIVE¶
This dimension table stores information about all active placements for the specified date types.
Columns¶
| Column | Data type | Description |
|---|---|---|
ACTIVEDATE |
TIMESTAMP_NTZ | The date and time when the activity was recorded. |
ACTIVEKEY |
NUMBER | An auto-incremental primary key for the table. |
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. |
CUSTOMERKEY |
NUMBER | A foreign key referencing the customer record in the DIMCUSTOMER table. |
ESTHIREDGP |
NUMBER | The estimated hired gross profit. |
MONTHCONTRACTACTIVECOUNT |
NUMBER | The number of active contracts for a given month. |
MONTHCONTRACTENDINGACTIVECOUNT |
NUMBER | The number of contracts that ended in a given month. |
MONTHCONTRACTSTARTINGACTIVECOUNT |
NUMBER | The number of contracts that started in a given month. |
MONTHPERMANENTSTARTINGACTIVECOUNT |
NUMBER | The number of permanent placements that started in a given month. |
WEEKCONTRACTACTIVECOUNT |
NUMBER | The number of active contracts in a given week. |
WEEKPERMANENTSTARTINGACTIVECOUNT |
NUMBER | The number of permanent placements that started in a given week. |