Record Type Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table storing record type definitions used to classify different types of records across the system.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| DimRecordTypeWid | BIGINT IDENTITY | No | Surrogate warehouse key for the record type (Primary Key) |
| RecordTypeId | INT | Yes | Numeric identifier for the record type |
| RecordTypeName | NVARCHAR(100) | Yes | Display name of the record type |
| void | BOOLEAN | Yes | Soft-delete flag indicating if the record is voided |
Note: All dimension tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlLastUpdatedOn,etlLastUpdatedBy) which are omitted from this reference for brevity.
Primary Key
DimRecordTypeWid
Foreign Keys
This table has no foreign key relationships to other analytics tables.
Was this article helpful?
Your feedback helps us improve our documentation.