Fact tables¶
Fact tables are central to the star schema design, containing dimension key columns that relate to the Dimension tables, as well as numeric measure columns that store the quantitative data essential for analysis.
| Table | Description | Columns |
|---|---|---|
| ACTIVITY_FACT | This fact table stores information about applicant, job, and contact activities. | 28 |
| CONTACT_JOB_TALENT_FACT | This fact table stores data for contact, job, and talent activities. This table is used in the User Stats Author dashboard. Note: This table contains a subset of the records contained in the ACTIVITY_FACT table. Avionté intends to deprecate this table in future releases. | 29 |
| GROSSPROFIT_FACT | This fact table stores information about gross profit. | 55 |
| INVOICE_FACT | This fact table stores information about invoices. | 38 |
| OPPORTUNITY_TRACKING_FACT | This fact table stores information about opportunities. | 27 |
| PLACEMENT_FACT | This fact table stores information about placements. | 21 |
| REVENUE_ACTIVITY_FACT | This fact table stores information about revenue and job activity. | 20 |
| TALENT_FACT | This fact table stores information about talent. | 20 |
| FO_FACT | This fact table stores Front Office only information. | 36 |
| RECRUITER_SUMMARY_FACT | This fact table stores information for the executive recruiter summary. | 38 |