Membership Fee Type Details Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table storing membership fee type definitions including fee names and additional configuration properties.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| MembershipFeeTypeDetailswid | BIGINT IDENTITY | No | Surrogate warehouse key for the membership fee type detail record |
| FeeTypePK | BIGINT | Yes | Source system primary key for the fee type |
| FeeName | VARCHAR(1000) | Yes | Display name of the membership fee type |
| AdditionalProperties | VARCHAR(MAX) | Yes | JSON or serialized string containing additional configuration properties for the fee type |
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
MembershipFeeTypeDetailswid
Foreign Keys
| Column | References |
|---|---|
| organizationid | an organization entity in the source system |
Was this article helpful?
Your feedback helps us improve our documentation.