DIMACTIVITYTYPE¶
This dimension table stores information about all activity types.
Columns¶
| Column | Data type | Description |
|---|---|---|
ACTIVITYCATEGORY |
VARCHAR | The category of the activity. |
ACTIVITYID |
NUMBER | The identifier for the activity. |
ACTIVITYNAME |
VARCHAR | The name of the activity. |
ACTIVITYORDER |
NUMBER | The order of the activity. |
ACTIVITYSUBTYPE |
VARCHAR | The subtype of the activity. |
ACTIVITYTYPE |
VARCHAR | The type of the activity. |
ACTIVITYTYPEKEY |
NUMBER | The primary key referencing an activity type. |
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. |
MODDATE |
TIMESTAMP_NTZ | The date and time when the activity record was modified. |