data-raw/column_names.R

get_column_names_list <- list(TEMP = c("record_type", "spot_date", "temperature_out_turn", "normal_reference_temperature", "low_reference_temperature", "high_reference_temperature"),
                              BOD = c("record_type", "bm_unit_id", "bm_unit_type", "lead_party_name", "ngc_bm_unit_name", "settlement_date", "settlement_period", "bm_offer_pair_number", "from_time", "from_level", "to_time", "to_level", "bid_price", "offer_price"),
                              CDN = c("record_type", "participant_id", "credit_default_level", "entered_default_settlement_date", "entered_default_settlement_period", "cleared_default_settlement_date", "cleared_default_settlement_period", "cleared_default_text"),
                              SYSWARN = c("record_type", "warning_date_time", "warning_text"),
                              DISBSAD = c("record_type", "settlement_date", "settlement_period", "action_identifier", "so_flag", "balancing_services_adjustment_action_stor_provider_flag", "action_cost", "action_volume"),
                              NETBSAD = c("record_type", "settlement_date","settlement_period", "net_energy_sell_price_cost_adjustment__esca", "net_energy_sell_price_volume_adjustment_esva", "net_energy_sell_price_volume_adjustment_ssva", "sell_price_price_adjust_spa", "net_energy_buy_price_cost_adjustment_ebca", "net_energ_buy_price_volume_adjustment_ebva", "net_system_buy_price_volume_adjustment_sbva", "buy_price_price_adjust_bpa"),
                              FREQ = c("record_type", "date_time", "frequency_hz"),
                              MID = c("record_type", "data_provider", "settlement_date", "settlement_period", "price", "volume"),
                              DEVINDOD = c("record_type" ,"settlement_date", "daily_energy_volume_outturn", "daily_energy_volume_normal_reference", "daily_energy_volume_low_reference", "daily_energy_volume_high_reference"),
                              NONBM = c("record_type", "settlement_date", "settlement_period", "system_zone", "nonbm_publish_time", "instructed_volume_mwh", "active_flag"),
                              QAS = c("record_type", "bm_unit_id", "bm_unit_type", "lead_party_name", "ngc_bm_unit_name", "settlement_date", "settlement_period", "balancing_service_volume", "active_flag"),
                              ROLSYSDEM = c("record_type", "settlement_date", "demand_mw"),
                              WINDFORPK = c("record_type", "settlement_date", "time_max_wind_generation", "peak_mw", "total_metered_capacity_mw", "data_last_updated"),
                              WINDFORFUELHH = c("record_type", "settlement_date", "settlement_period", "publication_time_initial_forecast", "initial_forecast_generation_mw", "publication_time_latest_forecast", "last_forecast_generation_mw", "publication_time_outturn", "outturn_generation_mw"),
                              FUELINSTHHCUR = c("record_type", "gb_generating_plant", "current_mw", "current_percentage", "current_total_mw", "current_total_percentage","last_half_hour", "last_half_hour_mw", "last_half_hour_percentage", "last_half_hour_total_mw", "last_24_hours","last_24_hours_mw","last_24_hours_percentage", "last_24_hours_total_mw", "last_24_hours_total_percentage", "date_last_updated"),
                              FUELINST = c("record_type", "settlement_date", "settlement_period", "spot_time",  "ccgt", "oil", "coal", "nuclear", "wind", "ps" ,"npshyd","ocgt", "other", "intfr", "intirl", "intned", "intew", "biomass", "intnem", "inelec", "inifa2", "intnsl"),
                              FUELHH = c("record_type", "settlement_date", "settlement_period", "spot_time", "bidding_zone", "bidding_zone_total_generation", "ccgt","oil", "coal", "nuclear", "wind", "ps" ,"npshyd","ocgt", "other", "intfr", "intirl", "intned", "intew", "intnem", "biomass", "intnem", "inelec", "inifa2", "intnsl"),
                              INTERFUELHH = c("record_type", "settlement_date", "settlement_period", "intfr_external_interconnector_flows_france", "intirl_external_interconnector_flows_ireland", "intned_external_interconnector_flows_netherlands", "inew_external_interconnector_flow_ireland_east_west", "intnem_external_interconnector_flows_belgium_nemo"),
                              NOU2T14D = c("record_type", "publication_time", "system_zone","settlement_date", "output_usable"),
                              FOU2T14D = c("record_type", "fuel_type", "publication_date_time", "system_zone", "settlement_date", "output_usable"),
                              UOU2T14D = c("record_type", "bm_unit_id", "fuel_type", "publication_date_time", "system_zone", "settlement_date"),
                              NOU2T52W = c("record_type", "publication_time", "system_zone", "calendar_week_number", "calendar_year", "output_usable"),
                              FOU2T52W = c("record_type", "fuel_type", "publishing_time", "system_zone", "calendar_week_number", "calendar_year", "output_usable"),
                              UOU2T52W = c("record_type", "bm_unit_id", "fuel_type", "publishing_time", "system_zone", "calendar_week", "number", "calendar_year", "output_usable"),
                              NOUY1 = c("record_type", "publication_time", "system_zone", "calendar_week_number", "calendar_year", "output_usable"),
                              NOUY2 = c("record_type", "publication_time", "system_zone", "calendar_week_number", "calendar_year", "output_usable"),
                              NOUY3 = c("record_type", "publication_time", "system_zone", "calendar_week_number", "calendar_year", "output_usable"),
                              NOUY4 = c("record_type", "publication_time", "system_zone", "calendar_week_number", "calendar_year", "output_usable"),
                              NOUY5 = c("record_type", "publication_time", "system_zone", "calendar_week_number", "calendar_year", "output_usable"),
                              ZOU2T14D = c("record_type", "publication_time", "system_zone", "settlement_date", "ouput_usable"),
                              ZOU2T52W = c("record_type", "publishing_period_date", "system_zone", "calendar_week_number", "calendar_year", "output_usable"),
                              ZOUY1 = c("record_type", "publication_time", "system_zone", "calendar_week_number", "calendar_year", "output_usable"),
                              ZOUY2 = c("record_type", "publication_time", "system_zone", "calendar_week_number", "calendar_year", "output_usable"),
                              ZOUY3 = c("record_type", "publication_time", "system_zone", "calendar_week_number", "calendar_year", "output_usable"),
                              ZOUY4 = c("record_type", "publication_time", "system_zone", "calendar_week_number", "calendar_year", "output_usable"),
                              ZOUY5 = c("record_type", "publication_time", "system_zone", "calendar_week_number", "calendar_year", "output_usable"),
                              INDOITSDO = c("record_type", "settlement_date", "settlement_period", "system_zone", "publish_time", "demand"),
                              MELIMBALNGC = c("zone_id", "settlement_date", "settlement_period", "record_type", "publish_time", "margin_imbalance_volume"),
                              FORDAYDEM = c("record_type", "settlement_date", "settlement_period", "zone_boundary_id" ,"publish_time", "demand_spndemand_spngeneration"),
                              DEMMF2T14D = c("settlement_date", "settlement_period", "zone_boundary_id", "record_type", "publish_time", "demand_margin"),
                              DEMMF2T52W = c("week_number", "zone_boundary_id", "record_type", "publication_time", "demand_margin"),
                              SOSOP = c("record_type", "trade_type", "start_time", "trade_direction", "contract_identification", "trade_quantity", "trade_price"),
                              SOSOT = c("record_type", "warning_date_time", "message_text"),
                              PKDEMYESTTDYTOM = c("record_type", "settlement_date", "forecast_demand_peak_mw", "forecast_peak_demand_time", "actual_demand_peak", "actual_peak_demand_time", "last_updated", "active_flag"),
                              INDPKDEMINFO = c("record_type", "settlement_date", "gb_demand_mw", "time_of_peak", "active_flag"),
                              SYSDEM = c("record_type", "settlement_date", "settlement_period", "gb_demand_mw"),
                              INDTRIADDEMINFO = c("record_type", "settlement_date", "gb_demand", "time_of_peak", "date_last_updated", "active_flag"),
                              PHYBMDATA = c("record_type", "bm_unit_id", "bm_unit_type", "lead_party_name", "ngc_bm_unit_name", "settlement_date", "settlement_period", "from_time", "from_level", "to_time", "to_level"),
                              DYNBMDATA = c("record_type", "bm_unit_id", "bm_unit_type", "lead_party_name", "ngc_bm_unit_name", "settlement_date", "settlement_period", "time", "rate_1", "elbow_2", "rate_2", "elbow_3", "rate_3"),
                              DERBMDATA = c("record_type", "bm_unit_id", "bm_unit_type", "lead_party_name", "ngc_bm_unit_name", "settlement_date", "settlement_period", "acceptance_id", "short_acceptance_flag", "volume_accepted_bo_pair_-6",  "volume_accepted_bo_pair_-5",  "volume_accepted_bo_pair_-4",  "volume_accepted_bo_pair_-3",  "volume_accepted_bo_pair_-2",  "volume_accepted_bo_pair_-1",  "volume_accepted_bo_pair_0",  "volume_accepted_bo_pair_1",  "volume_accepted_bo_pair_2",  "volume_accepted_bo_pair_3",  "volume_accepted_bo_pair_4",  "volume_accepted_bo_pair_5",  "volume_accepted_bo_pair_6"),
                              DERSYSDATA =  c("record_type", "settlement_date", "settlement_period", "system_sell_price", "system_buy_price", "bsad_default", "price_derivation_code", "reserve_scarcity_price", "indicative_net_imbalance_volume", "replacement_price", "replacement_price_calculation_volume", "total_system_accepted_offer_volume", "total_system_accepted_bid_volume", "total_system_tagged_accepted_offer_volume", "total_system_tagged_accepted_bid_volume", "system_total_priced_accepted_offer_volume", "system_total_priced_accepted_bid_volume", "total_system_adjustment_sell_volume", "total_system_adjustment_buy_volume", "total_system_tagged_adjustment_sell_volume", "total_system_tagged_adjustment_buy_volume"),
                              DETSYSPRICES = c("record_type", "settlement_date", "settlement_period", "index_sequence_number", "component_identifier", "acceptance_id", "bid_offer_pair_id", "cadl_flag", "so_flag", "stor_provider_flag", "repriced_indicator","bid_offer_original_price", "reserve_scarcity_price", "bid_offer_volume", "dmat_adjusted_volume", "arbitrage_adjusted_volume", "niv_adjusted_volume", "par_adjusted_volume", "stack_item_final_price", "tlm", "tlm adjusted volume", "tlm_adjusted_cost"),
                              MKTDEPTHDATA = c(""),
                              LATESTACCEPTS = c(""),
                              HISTACCEPTS = c(""),
                              SYSMSG = c(""),
                              BMUNITSEARCH = c(""),
                              SYSWARNTDYTOM = c(""),
                              HISTSYSWARN = c(""),
                              LOLPDRM = c(""),
                              DEMCI = c(""),
                              STORAW = c(""),
                              TRADINGUNIT = c("")

)
ARawles/BMRSr documentation built on Feb. 1, 2023, 12:11 p.m.