Package Value Fact Consolidated
ZTZenoti Docs Team Updated April 10, 2026 10 min readGuide
Consolidated fact table capturing package financial values including sale prices, taxes, discounts, liabilities, payments, suspense, and revenue recognition across package lifecycle events.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| Organization Name | VARCHAR(512) | Yes | Name of the organization. Sourced from DimOrganization.organization_name. |
| Organization Account Name | VARCHAR(256) | Yes | Account name of the organization. Sourced from DimOrganization.organization_account_name. |
| Package Sale center name | VARCHAR(128) | Yes | Name of the center where the package was sold. Sourced from DimCenter.center_name. |
| Package Sale Center Zone Name | VARCHAR(512) | Yes | Zone name of the package sale center. Sourced from DimCenter.zone_name. |
| Package Sale center company name | VARCHAR(128) | Yes | Company name of the package sale center. Sourced from DimCenter.company_name. |
| Payment Center Name | VARCHAR(128) | Yes | Name of the center where payment was made. Sourced from DimCenter.center_name. |
| Payment Center Zone Name | VARCHAR(512) | Yes | Zone name of the payment center. Sourced from DimCenter.zone_name. |
| Package Redemption Center | VARCHAR(4096) | Yes | Name of the center where the package was redeemed. Sourced from DimCenter.center_name. |
| Package Redemption Center Zone | VARCHAR(4096) | Yes | Zone name of the package redemption center. Sourced from DimCenter.zone_name. |
| User Id | VARCHAR(36) | Yes | Unique identifier (UUID) of the guest. Sourced from DimGuest.user_id. |
| Guest First Name | VARCHAR(160) | Yes | First name of the guest. Sourced from DimGuest.first_name. |
| Guest Last Name | VARCHAR(256) | Yes | Last name of the guest. Sourced from DimGuest.last_name. |
| Guest Middle Name | VARCHAR(160) | Yes | Middle name of the guest. Sourced from DimGuest.middle_name. |
| guest Address 1 | VARCHAR(512) | Yes | Primary address line of the guest. Sourced from DimGuest.address1. |
| guest Address 2 | VARCHAR(512) | Yes | Secondary address line of the guest. Sourced from DimGuest.address2. |
| Guest City | VARCHAR(128) | Yes | City of the guest. Sourced from DimGuest.city. |
| Guest Zipcode | VARCHAR(128) | Yes | Zip code of the guest. Sourced from DimGuest.zipcode. |
| Guest Type Name | VARCHAR(128) | Yes | Guest type classification name. Sourced from DimGuest.type_name. |
| Guest Email | VARCHAR(256) | Yes | Email address of the guest. Sourced from DimGuest.email. |
| Guest Mobile Phone | VARCHAR(64) | Yes | Mobile phone number of the guest. Sourced from DimGuest.mobile_phone. |
| Guest Home Phone | VARCHAR(64) | Yes | Home phone number of the guest. Sourced from DimGuest.home_phone. |
| Guest Phone Code | VARCHAR(64) | Yes | Phone country code of the guest. Sourced from DimGuest.phone_code. |
| Guest Code | VARCHAR(128) | Yes | Unique guest code identifier. Sourced from DimGuest.guest_code. |
| Guest Gender | VARCHAR(128) | Yes | Gender of the guest. Sourced from DimGuest.gender. |
| Guest State | VARCHAR(4096) | Yes | State of the guest. Sourced from DimGuest.state. |
| guest base center | VARCHAR(4096) | Yes | Base center assigned to the guest. Sourced from DimGuest.base_center. |
| Guest Country Name | VARCHAR(4096) | Yes | Country name of the guest. Sourced from DimGuest.country_name. |
| Is Guest InActive | BOOLEAN | Yes | Indicates whether the guest is inactive. Sourced from DimGuest.is_inactive. |
| Guest Tags | VARCHAR(65535) | Yes | Tags associated with the guest. Sourced from DimGuest.tags. |
| Service Name | VARCHAR(512) | Yes | Name of the service. Sourced from DimService.service_name. |
| Service Length | INTEGER | Yes | Duration of the service in minutes. Sourced from DimService.service_length. |
| Service Category | VARCHAR(256) | Yes | Category of the service. Sourced from DimService.category. |
| Service Parent Category | VARCHAR(256) | Yes | Parent category of the service. Sourced from DimService.parent_category. |
| Service Has Variant | VARCHAR(14) | Yes | Indicates whether the service has variants. Sourced from DimService.has_variant. |
| Service Is Variant | VARCHAR(14) | Yes | Indicates whether the service is a variant. Sourced from DimService.is_variant. |
| Service BusinessUnit | VARCHAR(200) | Yes | Business unit of the service. Sourced from DimService.businessunit. |
| Is Service InActive | BOOLEAN | Yes | Indicates whether the service is inactive. Sourced from DimService.is_inactive. |
| Service Tags | VARCHAR(65535) | Yes | Tags associated with the service. Sourced from DimService.tags. |
| Product Name | VARCHAR(256) | Yes | Name of the product. Sourced from DimProduct.product_name. |
| Product Category | VARCHAR(256) | Yes | Category of the product. Sourced from DimProduct.category. |
| Product Parent Category | VARCHAR(256) | Yes | Parent category of the product. Sourced from DimProduct.parent_category. |
| Product Business Unit | VARCHAR(800) | Yes | Business unit of the product. Sourced from DimProduct.business_unit. |
| Product Has Variant | BOOLEAN | Yes | Indicates whether the product has variants. Sourced from DimProduct.has_variant. |
| Is Product InActive | BOOLEAN | Yes | Indicates whether the product is inactive. Sourced from DimProduct.is_inactive. |
| Product Tags | VARCHAR(65535) | Yes | Tags associated with the product. Sourced from DimProduct.tags. |
| class name | VARCHAR(1024) | Yes | Name of the class. Sourced from DimClass.class_name. |
| is workshop | BOOLEAN | Yes | Indicates whether the class is a workshop. Sourced from DimClass.is_workshop. |
| class length | INTEGER | Yes | Duration of the class in minutes. Sourced from DimClass.class_length. |
| class category | VARCHAR(256) | Yes | Category of the class. Sourced from DimClass.category. |
| class parent category | VARCHAR(256) | Yes | Parent category of the class. Sourced from DimClass.parent_category. |
| class businessunit | VARCHAR(200) | Yes | Business unit of the class. Sourced from DimClass.businessunit. |
| is class inactive | BOOLEAN | Yes | Indicates whether the class is inactive. Sourced from DimClass.is_inactive. |
| class tags | VARCHAR(65535) | Yes | Tags associated with the class. Sourced from DimClass.tags. |
| Package Name | VARCHAR(1024) | Yes | Name of the package. Sourced from DimPackage.package_name. |
| Package Type | VARCHAR(14) | Yes | Type of the package (e.g., Membership, Series). Sourced from DimPackage.package_type. |
| Package Category | VARCHAR(200) | Yes | Category of the package. Sourced from DimPackage.category. |
| Package BusinessUnit | VARCHAR(200) | Yes | Business unit of the package. Sourced from DimPackage.businessunit. |
| Is Package InActive | BOOLEAN | Yes | Indicates whether the package is inactive. Sourced from DimPackage.is_inactive. |
| Package Tags | VARCHAR(65535) | Yes | Tags associated with the package. Sourced from DimPackage.tags. |
| package id | VARCHAR(36) | Yes | Unique identifier (UUID) of the package. |
| package version id | VARCHAR(36) | Yes | Unique identifier (UUID) of the package version. |
| package code | VARCHAR(128) | Yes | Code assigned to the package. |
| Item Type Code | VARCHAR(100) | Yes | Code representing the type of item in the package benefit. |
| Package Start Date | TIMESTAMP | Yes | Start date and time of the package. |
| Package End Date | TIMESTAMP | Yes | End date and time of the package. |
| Template Package versionid | VARCHAR(36) | Yes | Version ID of the template package. |
| Business Unit | VARCHAR(800) | Yes | Business unit associated with the record. |
| Package Sale By Employee First Name | VARCHAR(160) | Yes | First name of the employee who sold the package. Sourced from DimEmployee.first_name. |
| Package Sale By Employee Last Name | VARCHAR(256) | Yes | Last name of the employee who sold the package. Sourced from DimEmployee.last_name. |
| Package Sale By Employee Code | VARCHAR(128) | Yes | Code of the employee who sold the package. Sourced from DimEmployee.employee_code. |
| Package Sale By Employee - Code | VARCHAR(128) | Yes | Alternate code of the selling employee. Sourced from DimEmployee.employee_code. |
| Package Sale By Employee Job Name | VARCHAR(1020) | Yes | Job name of the selling employee. Sourced from DimEmployee.job_name. |
| Package Sale By Employee Job Code | VARCHAR(512) | Yes | Job code of the selling employee. Sourced from DimEmployee.job_code. |
| Package sale by employee additional field 1 | VARCHAR(8000) | Yes | Custom additional field 1 for the selling employee. Sourced from DimEmployee.additional_field_1. |
| Package sale by employee additional field 2 | VARCHAR(8000) | Yes | Custom additional field 2 for the selling employee. Sourced from DimEmployee.additional_field_2. |
| Item Sale By Employee First Name | VARCHAR(160) | Yes | First name of the employee who sold the item. Sourced from DimEmployee.first_name. |
| Item Sale By Employee Last Name | VARCHAR(256) | Yes | Last name of the employee who sold the item. Sourced from DimEmployee.last_name. |
| Item Sale By Employee Code | VARCHAR(128) | Yes | Code of the employee who sold the item. Sourced from DimEmployee.employee_code. |
| Item Sale By Employee - Code | VARCHAR(128) | Yes | Alternate code of the item selling employee. Sourced from DimEmployee.employee_code. |
| Item Sale By Employee Job Name | VARCHAR(1020) | Yes | Job name of the item selling employee. Sourced from DimEmployee.job_name. |
| Item Sale By Employee Job Code | VARCHAR(512) | Yes | Job code of the item selling employee. Sourced from DimEmployee.job_code. |
| Item sale by employee additional field 1 | VARCHAR(8000) | Yes | Custom additional field 1 for the item selling employee. Sourced from DimEmployee.additional_field_1. |
| Item sale by employee additional field 2 | VARCHAR(8000) | Yes | Custom additional field 2 for the item selling employee. Sourced from DimEmployee.additional_field_2. |
| is center franchise | BOOLEAN | Yes | Indicates whether the center is a franchise. Sourced from DimCenter.is_franchise. |
| center cst number | VARCHAR(80) | Yes | CST number of the center. Sourced from DimCenter.cst_number. |
| center tin number | VARCHAR(80) | Yes | TIN number of the center. Sourced from DimCenter.tin_number. |
| center tot number | VARCHAR(80) | Yes | TOT number of the center. Sourced from DimCenter.tot_number. |
| center service tax number | VARCHAR(80) | Yes | Service tax number of the center. Sourced from DimCenter.service_tax_number. |
| center vat number | VARCHAR(80) | Yes | VAT number of the center. Sourced from DimCenter.vat_number. |
| center luxary tax number | VARCHAR(80) | Yes | Luxury tax number of the center. Sourced from DimCenter.luxary_tax_number. |
| Is Custom Package | BOOLEAN | Yes | Indicates whether the package is a custom package. |
| Minutes To ADD | INTEGER | Yes | Timezone offset in minutes for the center. |
| brand name | VARCHAR(512) | Yes | Brand name associated with the record. |
| Package Sale Center Code | VARCHAR(40) | Yes | Code of the package sale center. Sourced from DimCenter.center_code. |
| Payment Center Code | VARCHAR(40) | Yes | Code of the payment center. Sourced from DimCenter.center_code. |
| Package Redemption Center Code | VARCHAR(40) | Yes | Code of the package redemption center. Sourced from DimCenter.center_code. |
| factsegmentwid | BIGINT | Yes | Fact segment warehouse identifier for ETL partitioning. |
| Unit Item Type Code | INTEGER | Yes | Numeric code for the unit item type. |
| record type | INTEGER | Yes | Numeric code representing the record type. |
| Package grace period | TIMESTAMP | Yes | Grace period end date for the package. |
| quantity | INTEGER | Yes | Total quantity of the package benefit. |
| Quantity Redeemed | INTEGER | Yes | Number of units redeemed from the package benefit. |
| Package Sale Price | FLOAT | Yes | Original sale price of the package. |
| Package Discount | FLOAT | Yes | Discount amount applied to the package. |
| Package Tax | FLOAT | Yes | Tax amount applied to the package. |
| Package Final Sale Price | FLOAT | Yes | Final sale price of the package after discounts and tax. |
| Package Sale Liability | FLOAT | Yes | Liability amount from the package sale. |
| Package IRR | FLOAT | Yes | Internal rate of return for the package. |
| Amount Paid For Package | FLOAT | Yes | Total amount paid for the package. |
| Amount Paid for Item | FLOAT | Yes | Amount paid attributed to the item. |
| Tax Paid for Package | FLOAT | Yes | Tax amount paid for the package. |
| Tax Paid for Item | FLOAT | Yes | Tax amount paid for the item. |
| Adjusted Amount Paid For Package | FLOAT | Yes | Adjusted amount paid for the package. |
| Adjusted Amount Paid For Item | FLOAT | Yes | Adjusted amount paid for the item. |
| Adjusted Tax Paid For Package | FLOAT | Yes | Adjusted tax paid for the package. |
| Adjusted Tax Paid For Item | FLOAT | Yes | Adjusted tax paid for the item. |
| suspense | FLOAT | Yes | Suspense amount (unrecognized revenue). |
| Payment date time in center | TIMESTAMP | Yes | Payment date and time in the center local timezone. |
| Payment date in center | DATE | Yes | Payment date in the center local timezone. |
| Sale date time in center | TIMESTAMP | Yes | Sale date and time in the center local timezone. |
| Sale date in center | DATE | Yes | Sale date in the center local timezone. |
| Closed date time in center | TIMESTAMP | Yes | Invoice closed date and time in the center local timezone. |
| Closed date in center | DATE | Yes | Invoice closed date in the center local timezone. |
| Created date time in center | TIMESTAMP | Yes | Record created date and time in the center local timezone. |
| Created date in center | DATE | Yes | Record created date in the center local timezone. |
| Package item sale price | FLOAT | Yes | Sale price of the package item. |
| Package item final sale price | FLOAT | Yes | Final sale price of the package item after discounts. |
| Package Invoice Id | VARCHAR(36) | Yes | Unique identifier (UUID) of the package invoice. |
| Package Invoice Item Id | VARCHAR(36) | Yes | Unique identifier (UUID) of the package invoice item. |
| Invoice Status | VARCHAR(100) | Yes | Status of the invoice (e.g., Closed, Open). |
| transactionid | VARCHAR(36) | Yes | Unique identifier (UUID) of the payment transaction. |
| payment option type | VARCHAR(200) | Yes | Type of payment option used. |
| Package Payment Type | VARCHAR(200) | Yes | Type of payment for the package. |
| Package Invoice No | VARCHAR(320) | Yes | Invoice number for the package. |
| redemption Date | TIMESTAMP | Yes | Date and time when the package benefit was redeemed. |
| redeemedinvoiceitemid | VARCHAR(36) | Yes | Invoice item ID associated with the redemption. |
| itemdiscount | FLOAT | Yes | Discount applied to the item. |
| unititemdiscount | VARCHAR(256) | Yes | Unit item discount description or value. |
| itemlistprice | FLOAT | Yes | List price of the item before discounts. |
| approvalnumber | VARCHAR(512) | Yes | Payment approval/authorization number. |
| creditcardlastfourdigits | VARCHAR(256) | Yes | Last four digits of the credit card used. |
| refund invoice id | VARCHAR(36) | Yes | Invoice ID associated with a refund. |
| refund Invoice item id | VARCHAR(36) | Yes | Invoice item ID associated with a refund. |
| Total refund value | FLOAT | Yes | Total monetary value of the refund. |
| product category code | VARCHAR(256) | Yes | Code for the product category. Sourced from DimProduct.category_code. |
| product parent category code | VARCHAR(256) | Yes | Code for the product parent category. Sourced from DimProduct.parent_category_code. |
| package benefit Product Tag | NVARCHAR(2048) | Yes | Tag identifying the product benefit within the package. |
| service category code | VARCHAR(256) | Yes | Code for the service category. Sourced from DimService.category_code. |
| service parent category code | VARCHAR(256) | Yes | Code for the service parent category. Sourced from DimService.parent_category_code. |
| package benefit Service Tag | VARCHAR(2048) | Yes | Tag identifying the service benefit within the package. |
| isrevenuerecognized | BOOLEAN | Yes | Indicates whether revenue has been recognized. |
| isfirstpaymentonpackage | BOOLEAN | Yes | Indicates whether this is the first payment on the package. |
| itemlevelapportionfactor | FLOAT | Yes | Apportion factor used for item-level revenue allocation. |
| class category code | VARCHAR(256) | Yes | Code for the class category. Sourced from DimClass.category_code. |
| class parent category code | VARCHAR(256) | Yes | Code for the class parent category. Sourced from DimClass.parent_category_code. |
| package benefit Class Tag | VARCHAR(2048) | Yes | Tag identifying the class benefit within the package. |
| benefit refund quantity | INTEGER | Yes | Quantity of benefits refunded. |
| etlcreatedby | BIGINT | Yes | Identifier of the ETL process that created the record. |
| LP Redemption | FLOAT | Yes | Loyalty points redemption amount. |
| Sale Liability Excl LP Redemption | FLOAT | Yes | Sale liability excluding loyalty points redemption. |
| Suspense Excl LP Redemption | FLOAT | Yes | Suspense amount excluding loyalty points redemption. |
Primary Key
No explicit primary key is defined. The combination of Package Invoice Item Id, record type, and redeemedinvoiceitemid can serve as a logical key.
Foreign Keys
User Idreferences DimGuestPackage Sale center name/Package Sale Center Codereferences DimCenter (sale center)Payment Center Name/Payment Center Codereferences DimCenter (payment center)Package Redemption Center/Package Redemption Center Codereferences DimCenter (redemption center)Package Sale By Employee First Name,Package Sale By Employee Codereferences DimEmployee (selling employee)Item Sale By Employee First Name,Item Sale By Employee Codereferences DimEmployee (item selling employee)Service Namereferences DimServiceProduct Namereferences DimProductclass namereferences DimClassPackage Name,package idreferences DimPackage
Enumerator Values
| Column Name | Known Values |
|---|---|
| Package Type | Membership, Series, etc. |
| Invoice Status | Closed, Open, etc. |
| record type | Integer codes representing Sale, Redemption, Refund |
| Item Type Code | Service, Product, Class |
| Guest Gender | Male, Female, etc. |
Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.
Was this article helpful?
Your feedback helps us improve our documentation.