         transamAs.purchased_new AS 'transam_asset_purchased_new',
         transamAs.quantity AS 'transam_asset_quantity',
         transamAs.quantity_unit AS 'transam_asset_quantity_unit',
+
         transamAs.salvage_value AS 'transam_asset_salvage_value',
         transamAs.scheduled_disposition_year AS 'transam_asset_scheduled_disposition_year',
         transamAs.scheduled_rehabilitation_year AS 'transam_asset_scheduled_rehabilitation_year',

          fta_asset_class.fta_asset_category_id AS 'transit_asset_fta_asset_class_fta_asset_category_id',
          fta_asset_class.name AS 'transit_asset_fta_asset_class_name',

          fta_vehicle_type.active AS 'transit_asset_fta_type_active',
          fta_vehicle_type.code AS 'transit_asset_fta_type_code',
          fta_vehicle_type.default_useful_life_benchmark AS 'transit_asset_fta_type_default_useful_life_benchmark',
          fta_vehicle_type.description AS 'transit_asset_fta_type_description',
          fta_vehicle_type.fta_asset_class_id AS 'transit_asset_fta_type_fta_asset_class_id',
          fta_vehicle_type.name AS 'transit_asset_fta_type_name',
          fta_vehicle_type.useful_life_benchmark_unit AS 'transit_asset_fta_type_useful_life_benchmark_unit',

          transamAs.asset_subtype_id AS 'transam_asset_asset_subtype_id',
          transamAs.asset_tag AS 'asset_tag',

-- ----------------------------------------------------------------------------------------------------------------

DROP VIEW if exists facility_primary_asset_table_views;
      CREATE OR REPLACE VIEW facility_primary_asset_table_views AS
      SELECT
        f.id,
        f.id AS 'facility_id',
