MDM_PRODUCT
- product_id
- product_name
- product_variance_name
- high_level_product_name
- product_type
- business_unit
- legal_entity
- company
- unit_linked_conventional_flag
- product_sme
- role_profile_name
- master_record_status
- golden_record_start_date
- golden_record_end_date
MDM_PRODUCT_XREF
- product_id
- source_system_name
- source_product_id
- source_product_code
- source_record_identifier
- oneview_id
- ataccama_product_identifier
- mdm_code
- product_code
- legacy_product_code
- bancs_product_code
- xref_status
- xref_start_date
- xref_end_date
MDM_PRODUCT_CLASSIFICATION
- product_id
- product_grouping
- product_review_group
- product_area
- product_type
- product_type_category_1
- product_type_category_2
- group_name
- sub_group_name
- classification_status
- classification_effective_date
- classification_end_date
MDM_PRODUCT_HIERARCHY
- product_id
- parent_product_id
- hierarchy_type
- hierarchy_level
- hierarchy_name
- hierarchy_effective_date
- hierarchy_end_date
- primary_hierarchy_flag
MDM_PRODUCT_RELATIONSHIP
- product_id
- related_product_id
- relationship_type
- relationship_status
- relationship_effective_date
- relationship_end_date
MDM_PRODUCT_LIFECYCLE
- product_id
- product_status
- marketed_status
- product_not_product_flag
- open_to_new_business_flag
- open_to_additional_investments_flag
- open_to_new_schemes_flag
- open_to_new_policies_flag
- date_product_launched
- date_product_closed
- renewable_flag
- reviewable_flag
- lifecycle_effective_date
- lifecycle_end_date
MDM_PRODUCT_GOVERNANCE
- product_id
- record_owner
- data_steward
- survivorship_rule_set
- approval_status
- created_date
- created_by
- last_updated_date
- last_updated_by
- source_precedence_rule
- audit_record_id
MDM_PRODUCT_REFERENCE_LINK
- product_id
- reference_type
- reference_code
- reference_value
- reference_set_name
- effective_date
- end_date
thoughts & threads 