I_RealEstateObjectPrt

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_RealEstateObjectPrt.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_RealEstateObjectPrt AS
SELECT
  obj_prt_guid AS RealEstatePrtUUID,
  obj_prt_guid_conv AS RealEstatePrtInternalID,
  obj_guid AS RealEstateUUID,
  part_id AS RealEstatePrtID,
  bld_part_type AS RealEstatePrtBuildingType,
  part_cond AS RealEstatePrtCondition,
  main_usage AS RealEstatePrtMainUsage,
  add_usage_1 AS RealEstatePrtAdditionalUsage1,
  add_usage_2 AS RealEstatePrtAdditionalUsage2,
  bld_method_roof AS RealEstatePrtBldngMethodRoof,
  bld_method_body AS RealEstatePrtBldngMethodBody,
  bld_metd_cellar AS RealEstatePrtBldngMethodCellar,
  utilization AS RealEstatePrtUtilization,
  part_desc AS RealEstatePrtDescription,
  comm_usage_pct AS REPrtCommercialUsagePercent,
  other_usg_flg AS RealEstatePrtThirdPartyUsage,
  ref_obj_prt_guid AS RealEstatePrtRefObjectUUID,
  is_sub_ast_crea AS RealEstatePrtIsSubAssetCreated,
  useful_area AS RealEstatePrtUsableAreaSize,
  usbl_area_uom AS RealEstatePrtUsableAreaUnitMsr,
  useful_area_ren AS REPrtRentedUsableAreaSize,
  usbl_ar_ren_uom AS REPrtRentedUsableAreaUnitMsr,
  useful_vol AS RealEstatePrtUsableVolume,
  usbl_vol_uom AS REPrtUsableVolumeUnitMsr,
  useful_vol_ren AS REPrtRentedUsableVolume,
  usbl_vl_ren_uom AS REPrtRentedUsableVolumeUnitMsr,
  residential_area AS REPrtResidentialAreaSize,
  res_ar_uom AS REPrtResidentialAreaUnitMsr,
  secondary_area AS REPrtSecondaryAreaSize,
  sec_area_uom AS REPrtSecondaryAreaUnitMsr,
  other_area AS RealEstatePrtOtherAreaSize,
  oth_area_uom AS RealEstatePrtOtherAreaUnitMsr,
  no_prt_unit AS REPrtNumberOfBuildingPrt,
  no_prt_unit_ren AS REPrtNumberOfBuildingPrtRented,
  cons_start_date AS REPrtConstructionStartDate,
  permsn_appl_date AS REPrtPermissionAppliedDate,
  permsn_obtd_date AS REPrtPermissionObtainedDate,
  occy_date AS RealEstatePrtOccupancyDate,
  comp_date AS RealEstatePrtCompletionDate,
  final_insp_date AS REPrtFinalInspectionDate,
  rent_amt_planned AS REPrtResidentialPlndRentAmt,
  rent_amt_actual AS REPrtResidentialActlRentAmt,
  rent_plan_curr AS REPrtResidentialPlndRentCrcy,
  rent_act_curr AS REPrtResidentialActlRentCrcy,
  base_period AS REPrtResidentialBasePeriod,
  base_measure AS REPrtResidentialBaseMeasure,
  vacant_posn_pct AS REPrtVacantPositionPercent,
  res_rent_ind AS RealEstatePrtRentType,
  comp_rent_res AS REPrtComparativeRentAmount,
  com_ren_res_curr AS REPrtComparativeRentCurrency,
  land_area AS RealEstatePrtLandAreaSize,
  land_area_uom AS RealEstatePrtLandAreaUnitMsr,
  land_area_ren AS REPrtRentedLandAreaSize,
  land_ar_ren_uom AS REPrtRentedLandAreaUnitMsr,
  no_of_units AS RealEstatePrtNumberOfUnits,
  no_of_floors AS RealEstatePrtNumberOfFloors,
  no_garages AS REPrtNumberOfGarages,
  no_garages_ren AS REPrtNumberOfGaragesRented,
  no_park_unit AS REPrtNumberOfParking,
  no_park_unit_ren AS REPrtNumberOfParkingRented,
  no_park_ug AS REPrtNrOfUndrGrndParking,
  no_park_ug_ren AS REPrtNrOfUndrGrndParkingRntd,
  no_cur_units AS REPrtNumberOfCurrentUnits,
  no_cur_units_ren AS REPrtNmbrOfCurrentUnitsRented,
  no_old_units AS REPrtNumberOfOldUnits,
  no_old_units_ren AS REPrtNumberOfOldUnitsRented,
  no_new_units AS REPrtNumberOfNewUnits,
  no_new_units_ren AS REPrtNumberOfNewUnitsRented,
  no_access_str AS REPrtNumberOfAccessStructures,
  no_sale_level AS RealEstatePrtNumberOfSaleLevel,
  no_of_rooms AS RealEstatePrtNumberOfRooms,
  no_of_beds AS RealEstatePrtNumberOfBeds,
  comm_env_desc AS REPrtCommercialEnvironmentDesc,
  access_str_desc AS REPrtAccessStructureDesc,
  bld_section_desc AS REPrtBuildingSectionDesc,
  price_category AS RealEstatePrtPriceCategory,
  avg_price AS REPrtAveragePricePerDayAmt,
  avg_price_curr AS REPrtAveragePricePerDayCrcy,
  occupancy_pct AS RealEstatePrtOccupancyPct,
  turnover_amt AS RealEstatePrtTurnoverAmt,
  turnover_curr AS RealEstatePrtTurnoverCrcy,
  rental_agmt_typ AS RealEstatePrtRentalAgrmtType,
  last_report_date AS REPrtLastConstructionRptDate,
  bld_progress_amt AS REPrtBuildingProgressAmt,
  bld_amt_curr AS REPrtBuildingProgressCrcy,
  pct_completed AS REPrtBuildingCompletionPct,
  insurance_type AS RealEstatePrtInsuranceType,
  insurance_amt AS RealEstatePrtInsuranceAmt,
  insurance_curr AS RealEstatePrtInsuranceCrcy,
  ins_validity AS RealEstatePrtInsurValidToDate,
  rationing_cost AS RealEstatePrtRationCostAmt,
  rtn_cst_pct AS RealEstatePrtRationCostPct,
  ext_layout_cost AS REPrtExternalLayoutCostAmt,
  ext_lay_cst_pct AS REPrtExternalLayoutCostPct,
  rtn_cst_curr AS RealEstatePrtRationCostCrcy,
  ext_rtn_cst_curr AS REPrtExternalLayoutCostCrcy,
  rtn_cst_com AS REPrtCommercialRationCostAmt,
  rtn_cst_com_curr AS REPrtCommercialRationCostCrcy,
  rtn_cst_com_pct AS REPrtCommercialRationCostPct,
  gross_cold_rent AS RealEstatePrtGrossColdRentAmt,
  gross_rent_curr AS RealEstatePrtGrossColdRentCrcy,
  net_cold_rent AS RealEstatePrtNetColdRentAmt,
  net_rent_curr AS RealEstatePrtNetColdRentCrcy,
  created_by AS RealEstatePrtEnteredBy,
  created_date AS RealEstatePrtEnteredDate,
  created_time AS RealEstatePrtEnteredTime,
  entry_src AS RealEstatePrtEnteredSource,
  last_chg_by AS RealEstatePrtLastChangedBy,
  last_chg_date AS RealEstatePrtLastChangedDate,
  last_chg_time AS RealEstatePrtLastChangedTime,
  processing_src AS RealEstatePrtLastChangedSource,
  no_of_years_com AS REPrtCommlNmbrOfYrsLastValn,
  int_rate_com AS REPrtCommercialInterestRate,
  no_of_years AS REPrtRsdntlLastValnNrOfYrs,
  int_rate AS REPrtRsdntlInterestRate,
  rent_planned_com AS REPrtCommercialPlannedRentAmt,
  rent_actual_com AS REPrtCommercialActualRentAmt,
  plan_curr_com AS REPrtCommercialPlannedRentCrcy,
  act_curr_com AS REPrtCommercialActualRentCrcy,
  base_period_com AS REPrtCommercialBasePeriod,
  base_meas_com AS REPrtCommercialBaseMsr,
  com_rent_ind AS REPrtCommercialRentType,
  comp_rent_com AS REPrtCommercialComparRentAmt,
  comp_ren_com_cur AS REPrtCommercialComparRentCrcy,
  plan_rent_land AS RealEstatePrtPlannedRentAmt,
  actual_rent_land AS RealEstatePrtActualRentAmt,
  plan_rent_curr AS RealEstatePrtPlannedRentCrcy,
  actual_rent_curr AS RealEstatePrtActualRentCrcy,
  base_period_land AS RealEstatePrtRentBasePeriod,
  base_meas_land AS RealEstatePrtRentBaseMeasure,
  depr AS RealEstatePrtDepreciationPct,
  land_cost AS RealEstatePrtLandCostAmt,
  land_cost_curr AS RealEstatePrtLandCostCrcy,
  dev_cost AS REPrtDevelopmentCostAmt,
  dev_cost_curr AS REPrtDevelopmentCostCrcy,
  land_cst_base AS RealEstatePrtLandCostBaseMsr,
  dev_cst_base AS REPrtDevelopmentCostBaseMsr,
  add_land_cst AS REPrtAdditionalLandCostAmt,
  add_cst_curr AS REPrtAdditionalLandCostCrcy,
  add_cst_base AS REPrtAdditionalLandCostBaseMsr,
  const_cost AS REPrtConstructionCostAmt,
  const_cost_curr AS REPrtConstructionCostCrcy,
  base_meas AS REPrtConstructionCostBaseMsr,
  grs_profit AS REPrtYearlyGrossProfitAmt,
  grs_profit_curr AS REPrtYearlyGrossProfitCrcy
FROM P_RealEstatePrt_TF
LEFT OUTER JOIN I_RealEstateObjPrtMstrData AS _RealEstateObjPrtMstrData ON RealEstatePrtUUID = _RealEstateObjPrtMstrData.RealEstatePrtUUID  -- association [0..1]
LEFT OUTER JOIN I_RealEstateObjectData AS _RealEstateObjectData ON RealEstateUUID = _RealEstateObjectData.RealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_RealEstateObjectMasterData AS _RealEstateObjectMasterData ON RealEstateUUID = _RealEstateObjectMasterData.RealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_RealEstatePrtAccessory AS _RealEstatePrtAccessory ON RealEstatePrtUUID = _RealEstatePrtAccessory.RealEstatePrtUUID  -- association [0..*]
LEFT OUTER JOIN I_RealEstatePrtAccsryMstrData AS _RealEstatePrtAccsryMstrData ON RealEstatePrtUUID = _RealEstatePrtAccsryMstrData.RealEstatePrtUUID  -- association [0..*]
LEFT OUTER JOIN I_RealEstatePrtPartner AS _RealEstatePrtPartner ON RealEstatePrtUUID = _RealEstatePrtPartner.RealEstatePrtUUID  -- association [0..*]
LEFT OUTER JOIN I_RealEstatePrtCost AS _RealEstatePrtCost ON RealEstatePrtUUID = _RealEstatePrtCost.RealEstatePrtUUID  -- association [0..*]
LEFT OUTER JOIN I_RealEstatePrtValue AS _RealEstatePrtValue ON RealEstatePrtUUID = _RealEstatePrtValue.RealEstatePrtUUID  -- association [0..*]
LEFT OUTER JOIN I_RealEstatePrtLandRegister AS _RealEstatePrtLandRegister ON RealEstatePrtUUID = _RealEstatePrtLandRegister.RealEstatePrtUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectAssetData AS _RealEstatePrtAssetData ON RealEstatePrtInternalID = _RealEstatePrtAssetData.ObjectAssetReferenceNumber  -- association [0..*]
LEFT OUTER JOIN I_RealEstateObjectUsage AS _RealEstatePrtMainUsage ON RealEstatePrtMainUsage = _RealEstatePrtMainUsage.RealEstateObjectUsage  -- association [0..1]
LEFT OUTER JOIN I_RealEstateObjectUsage AS _RealEstatePrtAdditionalUsage1 ON RealEstatePrtAdditionalUsage1 = _RealEstatePrtAdditionalUsage1.RealEstateObjectUsage  -- association [0..1]
LEFT OUTER JOIN I_RealEstateObjectUsage AS _RealEstatePrtAdditionalUsage2 ON RealEstatePrtAdditionalUsage2 = _RealEstatePrtAdditionalUsage2.RealEstateObjectUsage  -- association [0..1]
LEFT OUTER JOIN I_RealEstatePrtUtilization AS _RealEstatePrtUtilization ON RealEstatePrtUtilization = _RealEstatePrtUtilization.RealEstatePrtUtilization  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _REPrtUsableAreaUnitMsr ON RealEstatePrtUsableAreaUnitMsr = _REPrtUsableAreaUnitMsr.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _REPrtRentedUsableAreaUnitMsr ON REPrtRentedUsableAreaUnitMsr = _REPrtRentedUsableAreaUnitMsr.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _REPrtUsableVolumeUnitMsr ON REPrtUsableVolumeUnitMsr = _REPrtUsableVolumeUnitMsr.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _REPrtRentedUsableVolUnitMsr ON REPrtRentedUsableVolumeUnitMsr = _REPrtRentedUsableVolUnitMsr.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _REPrtResidentialAreaUnitMsr ON REPrtResidentialAreaUnitMsr = _REPrtResidentialAreaUnitMsr.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _REPrtSecondaryAreaUnitMsr ON REPrtSecondaryAreaUnitMsr = _REPrtSecondaryAreaUnitMsr.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RealEstatePrtOtherAreaUnitMsr ON RealEstatePrtOtherAreaUnitMsr = _RealEstatePrtOtherAreaUnitMsr.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RealEstatePrtLandAreaUnitMsr ON RealEstatePrtLandAreaUnitMsr = _RealEstatePrtLandAreaUnitMsr.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _REPrtRentedLandAreaUnitMsr ON REPrtRentedLandAreaUnitMsr = _REPrtRentedLandAreaUnitMsr.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _REPrtResidentialPlndRentCrcy ON REPrtResidentialPlndRentCrcy = _REPrtResidentialPlndRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _REPrtResidentialActlRentCrcy ON REPrtResidentialActlRentCrcy = _REPrtResidentialActlRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _REPrtComparativeRentCurrency ON REPrtComparativeRentCurrency = _REPrtComparativeRentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _REPrtAveragePricePerDayCrcy ON REPrtAveragePricePerDayCrcy = _REPrtAveragePricePerDayCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _RealEstatePrtTurnoverCrcy ON RealEstatePrtTurnoverCrcy = _RealEstatePrtTurnoverCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _REPrtBuildingProgressCrcy ON REPrtBuildingProgressCrcy = _REPrtBuildingProgressCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _RealEstatePrtInsuranceCrcy ON RealEstatePrtInsuranceCrcy = _RealEstatePrtInsuranceCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _RealEstatePrtRationCostCrcy ON RealEstatePrtRationCostCrcy = _RealEstatePrtRationCostCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _REPrtExternalLayoutCostCrcy ON REPrtExternalLayoutCostCrcy = _REPrtExternalLayoutCostCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _REPrtCommercialRationCostCrcy ON REPrtCommercialRationCostCrcy = _REPrtCommercialRationCostCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _REPrtGrossColdRentCrcy ON RealEstatePrtGrossColdRentCrcy = _REPrtGrossColdRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _RealEstatePrtNetColdRentCrcy ON RealEstatePrtNetColdRentCrcy = _RealEstatePrtNetColdRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _REPrtCommercialPlndRentCrcy ON REPrtCommercialPlannedRentCrcy = _REPrtCommercialPlndRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _REPrtCommercialActualRentCrcy ON REPrtCommercialActualRentCrcy = _REPrtCommercialActualRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _REPrtCommercialComparRentCrcy ON REPrtCommercialComparRentCrcy = _REPrtCommercialComparRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _RealEstatePrtPlannedRentCrcy ON RealEstatePrtPlannedRentCrcy = _RealEstatePrtPlannedRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _RealEstatePrtActualRentCrcy ON RealEstatePrtActualRentCrcy = _RealEstatePrtActualRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _RealEstatePrtLandCostCrcy ON RealEstatePrtLandCostCrcy = _RealEstatePrtLandCostCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _REPrtDevelopmentCostCrcy ON REPrtDevelopmentCostCrcy = _REPrtDevelopmentCostCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _REPrtAdditionalLandCostCrcy ON REPrtAdditionalLandCostCrcy = _REPrtAdditionalLandCostCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _REPrtConstructionCostCrcy ON REPrtConstructionCostCrcy = _REPrtConstructionCostCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _REPrtYearlyGrossProfitCrcy ON REPrtYearlyGrossProfitCrcy = _REPrtYearlyGrossProfitCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_RealEstateBasePeriod AS _REPrtResidentialBasePeriod ON REPrtResidentialBasePeriod = _REPrtResidentialBasePeriod.RealEstateBasePeriod  -- association [0..1]
LEFT OUTER JOIN I_RealEstateBasePeriod AS _REPrtCommercialBasePeriod ON REPrtCommercialBasePeriod = _REPrtCommercialBasePeriod.RealEstateBasePeriod  -- association [0..1]
LEFT OUTER JOIN I_RealEstateBasePeriod AS _RealEstatePrtRentBasePeriod ON RealEstatePrtRentBasePeriod = _RealEstatePrtRentBasePeriod.RealEstateBasePeriod  -- association [0..1]
LEFT OUTER JOIN I_RealEstateBaseMeasure AS _REPrtResidentialBaseMeasure ON REPrtResidentialBaseMeasure = _REPrtResidentialBaseMeasure.RealEstateBaseMeasure  -- association [0..1]
LEFT OUTER JOIN I_RealEstateBaseMeasure AS _REPrtCommercialBaseMsr ON REPrtCommercialBaseMsr = _REPrtCommercialBaseMsr.RealEstateBaseMeasure  -- association [0..1]
LEFT OUTER JOIN I_RealEstateBaseMeasure AS _RealEstatePrtRentBaseMeasure ON RealEstatePrtRentBaseMeasure = _RealEstatePrtRentBaseMeasure.RealEstateBaseMeasure  -- association [0..1]
LEFT OUTER JOIN I_RealEstateBaseMeasure AS _REPrtConstructionCostBaseMsr ON REPrtConstructionCostBaseMsr = _REPrtConstructionCostBaseMsr.RealEstateBaseMeasure  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _RealEstatePrtBuildingType ON RealEstatePrtBuildingType = _RealEstatePrtBuildingType.CollateralAttributeIndType AND _RealEstatePrtBuildingType.CollateralAttributeIndCat = 'REO006'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _RealEstatePrtCondition ON RealEstatePrtCondition = _RealEstatePrtCondition.CollateralAttributeIndType AND _RealEstatePrtCondition.CollateralAttributeIndCat = 'REO001'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _RealEstatePrtBldngMethodRoof ON RealEstatePrtBldngMethodRoof = _RealEstatePrtBldngMethodRoof.CollateralAttributeIndType AND _RealEstatePrtBldngMethodRoof.CollateralAttributeIndCat = 'REO007'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _RealEstatePrtBldngMethodBody ON RealEstatePrtBldngMethodBody = _RealEstatePrtBldngMethodBody.CollateralAttributeIndType AND _RealEstatePrtBldngMethodBody.CollateralAttributeIndCat = 'REO008'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _REPrtBldngMethodCellar ON RealEstatePrtBldngMethodCellar = _REPrtBldngMethodCellar.CollateralAttributeIndType AND _REPrtBldngMethodCellar.CollateralAttributeIndCat = 'REO009'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _REPrtBuildingSectionDesc ON REPrtBuildingSectionDesc = _REPrtBuildingSectionDesc.CollateralAttributeIndType AND _REPrtBuildingSectionDesc.CollateralAttributeIndCat = 'REO015'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _RealEstatePrtPriceCategory ON RealEstatePrtPriceCategory = _RealEstatePrtPriceCategory.CollateralAttributeIndType AND _RealEstatePrtPriceCategory.CollateralAttributeIndCat = 'REO013'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _RealEstatePrtRentalAgrmtType ON RealEstatePrtRentalAgrmtType = _RealEstatePrtRentalAgrmtType.CollateralAttributeIndType AND _RealEstatePrtRentalAgrmtType.CollateralAttributeIndCat = 'REO014'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _RealEstatePrtInsuranceType ON RealEstatePrtInsuranceType = _RealEstatePrtInsuranceType.CollateralAttributeIndType AND _RealEstatePrtInsuranceType.CollateralAttributeIndCat = 'REO011'  -- association [0..1]
;