# View: royalty_accounting_dev_vw_fact_contract_history

**View Name:** royalty_accounting_dev_vw_fact_contract_history
**Table Source:** `dev.hsingh.vw_fact_contract_history_qa_dev`
**File Path:** `views/royalty_accounting_dev_vw_fact_contract_history.view.lkml`

## Overview

- **File Size:** 10133 bytes
- **Lines of Code:** 402
- **Dimensions:** 45
- **Measures:** 0
- **Dimension Groups:** 3
- **Filters:** 0

## Comments & Notes

- html: {{value | replace: '|||', '<br/>'}} ;;
- 9662;{% endif %}: {{ column_values.size }} {% if column_values.size == 1 %}value{% else %}values{% endif %}</summary>
- html: {{value | replace: '|||', '<br/>'}} ;;

## 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 |
| `contract_lifecycle_id` | string |

## Dimension Groups

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