# catalog_product_groups

<!-- Generated from apps/irrigation/dbt_redshift/models/client_data/sources.yml. Do not edit by hand — run `make generate-client-data-dictionary`. -->

Sales Proposition product group (contract) definitions, scoped to client workspaces.

| Column | Description |
| --- | --- |
| `id` | Unique identifier for the product group |
| `internal_reference` | Internal reference code for the product group |
| `contract_earliest_start_date` | Earliest allowed contract start date for products in this group |
| `contract_latest_start_date` | Latest allowed contract start date for products in this group |
| `contract_earliest_end_date` | Earliest allowed contract end date for products in this group |
| `contract_latest_end_date` | Latest allowed contract end date for products in this group |
| `workspace_id` | The ID of this workspace |
| `created_at` | Timestamp indicating when the product group was created |
| `updated_at` | Timestamp indicating when the product group was last updated |
| `default_expiry_duration_in_seconds` | Default duration, in seconds, before an unconfirmed booking against this group expires |
| `allow_booking_expiry_timer` | Whether the booking expiry timer is enabled for this product group |
| `academic_year` | Academic year this product group applies to |
| `agreement_id` | Identifier of the agreement associated with this product group |
| `cancellation_policy_id` | Identifier of the cancellation policy applied to this product group |
| `state` | Current lifecycle state of the product group |
| `publish_start_date` | Date from which this product group is published |
| `publish_end_date` | Date after which this product group is no longer published |
| `publish_state` | Publish status of the product group |
| `type` | Type of the product group |
| `product_segment` | Sales segment this product group belongs to |
| `contract_template_external_id` | External identifier of the contract template used by this product group |
| `requires_cancellation_policy` | Whether products in this group require a cancellation policy |
| `timestamp` | Date when the table was last synchronized |