# View: royalty_accounting_prod_vw_fact_contract_history

**View Name:** royalty_accounting_prod_vw_fact_contract_history
**Table Source:** `ROYALTY_ACCOUNTING.prod.vw_fact_contract_history`
**File Path:** `views/royalty_accounting_prod_vw_fact_contract_history.view.lkml`

## Overview

- **File Size:** 9105 bytes
- **Lines of Code:** 374
- **Dimensions:** 44
- **Measures:** 0
- **Dimension Groups:** 3
- **Filters:** 0

## Comments & Notes

- 9662;{% endif %}: {{ column_values.size }} {% if column_values.size == 1 %}value{% else %}values{% endif %}</summary>
- 9662;{% endif %}: {{ column_values.size }} {% if column_values.size == 1 %}value{% else %}values{% endif %}</summary>

## Dimensions

| Name | Type |
|------|------|
| `contract_history_id` | number |
| `change_type` | string |
| `is_latest` | string |
| `high_lvl_change_details` | string |
| `change_details` | string |
| `contract_id` | number |
| `contract_type` | string |
| `reference_sap_profit_center_id` | number |
| `contract_last_modified_by` | string |
| `contract_last_modified` | string |
| `summary_note` | string |
| `general_note` | string |
| `contract_term_history_id` | number |
| `contract_term_id` | number |
| `term_type` | string |
| `attachments` | string |
| `is_base_term` | yesno |
| `attachments_relations` | string |
| `term_last_modified_by` | string |
| `term_last_modified` | date_time |
| `term_deleted_by` | string |
| `term_deleted_at` | date_time |
| `contract_term_condition_history_id` | number |
| `contract_term_condition_id` | number |
| `priority` | string |
| `term_rate` | number |
| `term_condition_last_modified_by` | string |
| `term_condition_last_modified` | date_time |
| `term_condition_deleted_by` | string |
| `term_condition_deleted_at` | date_time |
| `commission` | number |
| `sort_col` | string |
| `last_modified_combined` | date_time |
| `old_value` | string |
| `new_value` | string |
| `last_modified_by_combined` | string |
| `signing_entity_legal_name` | string |
| `schedule_id` | number |
| `schedule_name` | string |
| `lifecycle_status` | string |
| `lifecycle_term_start` | string |
| `lifecycle_term_end` | string |
| `renewal_effective` | string |
| `renewal_type` | string |

## Dimension Groups

| Name | Type |
|------|------|
| `contract_term_start` | time |
| `contract_term_end` | time |
| `sap_created_at` | time |