Dimension tables¶
Dimension tables store descriptive attributes related to the data in the Fact tables, providing context and meaning to the numerical data.
| Table | Description | Columns |
|---|---|---|
| DIMACTIVE | This dimension table stores information about all active placements for the specified date types. | 11 |
| DIMACTIVITYTYPE | This dimension table stores information about all activity types. | 10 |
| DIMAPPLICANT | This dimension table stores information about talent/applicants. | 43 |
| DIMCOMMISSIONTYPE | This dimension table stores information about commission types. | 5 |
| DIMCOMPANY | This dimension table stores information about companies. | 23 |
| DIMCOMPANYBRANCH | This dimension table stores information about company branches. | 9 |
| DIMCUSTOMER | This dimension table stores information about individual customers/clients. There’s only one row in the table and it has setup information for a client. | 23 |
| DIMDATE | This dimension table stores information about all dates (date keys) used. | 30 |
| DIMHIRED | This dimension table stores all placement/assignment related information. | 30 |
| DIMHIREDCOMMISSION | This dimension table stores information about the placement commission. | 14 |
| DIMHIREDENDREASON | This dimension table stores information about the placement end reasons. | 7 |
| DIMHIREDEXTENSIONS | This dimension table stores information about placement extensions. | 26 |
| DIMHIREDTYPE | This dimension table stores information about placement types. | 9 |
| DIMHIRINGMANAGER | This dimension table stores information about the contacts/hiring managers. | 29 |
| DIMJOBTYPE | This dimension table stores information about the job types. | 7 |
| DIMOFFICE | This dimension table stores information about offices. | 12 |
| DIMOPPORTUNITY | This dimension table stores information about opportunities. | 21 |
| DIMREQTIER | This dimension table stores information about the requirements tiers/statuses. | 12 |
| DIMRPTREQ | This dimension table stores information about the job requirements and is preferable to use over the DIMREQ table because it includes more columns. Note: The DIMREQ table has been deprecated, and, depending on when your DataLink account was created, this table may or may not exist in your account. DIMRPTREQ should be used for information about job requirements. | 83 |
| DIMUSER | This dimension table stores user-related information. | 16 |
| DIMWEBAPPLY | This dimension table stores information about web applicants. | 17 |