from collections import OrderedDict
from usaspending_api.download.filestreaming import NAMING_CONFLICT_DISCRIMINATOR

"""
Sets up mappings from column names used in downloads to the query paths used to get the data from django.

Not in use while we pull CSV data from the non-historical tables. Until we switch to pulling CSV downloads from the
historical tables TransactionFPDS and TransactionFABS, import download_column_lookups.py instead.

NOTE: To allow for annotations to be used on download a pair of ("<alias>", None) is used so that a placeholder
for the column is made, but it can be removed to avoid being used as a query path.
"""
"""
Code to generate these from spreadsheets:

tail -n +3 'usaspending_api/data/DAIMS_IDD_Resorted+DRW+KB+GGv7/D2-Award (Financial Assistance)-Table 1.csv' >
d2_columns.csv

"""


query_paths = {
    "award": {
        "d1": OrderedDict(
            [
                ("contract_award_unique_key", "award__generated_unique_award_id"),
                ("award_id_piid", "award__piid"),
                ("parent_award_agency_id", "award__latest_transaction__contract_data__referenced_idv_agency_iden"),
                ("parent_award_agency_name", "award__latest_transaction__contract_data__referenced_idv_agency_desc"),
                ("parent_award_id_piid", "award__parent_award_piid"),
                ("total_obligated_amount", "award__total_obligation"),
                ("current_total_value_of_award", "award__latest_transaction__contract_data__current_total_value_award"),
                (
                    "potential_total_value_of_award",
                    "award__latest_transaction__contract_data__potential_total_value_awar",
                ),
                ("award_base_action_date", "award__date_signed"),
                ("award_base_action_date_fiscal_year", None),  # Annotation is used to create this column
                ("period_of_performance_start_date", "award__period_of_performance_start_date"),
                (
                    "period_of_performance_current_end_date",
                    "award__latest_transaction__contract_data__period_of_performance_curr",
                ),
                (
                    "period_of_performance_potential_end_date",
                    "award__latest_transaction__contract_data__period_of_perf_potential_e",
                ),
                ("ordering_period_end_date", "award__latest_transaction__contract_data__ordering_period_end_date"),
                ("solicitation_date", "award__earliest_transaction__contract_data__solicitation_date"),
                ("awarding_agency_code", "award__latest_transaction__contract_data__awarding_agency_code"),
                ("awarding_agency_name", "award__latest_transaction__contract_data__awarding_agency_name"),
                ("awarding_sub_agency_code", "award__latest_transaction__contract_data__awarding_sub_tier_agency_c"),
                ("awarding_sub_agency_name", "award__latest_transaction__contract_data__awarding_sub_tier_agency_n"),
                ("awarding_office_code", "award__latest_transaction__contract_data__awarding_office_code"),
                ("awarding_office_name", "award__latest_transaction__contract_data__awarding_office_name"),
                ("funding_agency_code", "award__latest_transaction__contract_data__funding_agency_code"),
                ("funding_agency_name", "award__latest_transaction__contract_data__funding_agency_name"),
                ("funding_sub_agency_code", "award__latest_transaction__contract_data__funding_sub_tier_agency_co"),
                ("funding_sub_agency_name", "award__latest_transaction__contract_data__funding_sub_tier_agency_na"),
                ("funding_office_code", "award__latest_transaction__contract_data__funding_office_code"),
                ("funding_office_name", "award__latest_transaction__contract_data__funding_office_name"),
                ("treasury_accounts_funding_this_award", None),  # Annotation is used to create this column
                ("federal_accounts_funding_this_award", None),  # Annotation is used to create this column
                ("foreign_funding", "award__latest_transaction__contract_data__foreign_funding"),
                ("foreign_funding_description", "award__latest_transaction__contract_data__foreign_funding_desc"),
                ("sam_exception", "award__latest_transaction__contract_data__sam_exception"),
                ("sam_exception_description", "award__latest_transaction__contract_data__sam_exception_description"),
                ("recipient_duns", "award__latest_transaction__contract_data__awardee_or_recipient_uniqu"),
                ("recipient_name", "award__latest_transaction__contract_data__awardee_or_recipient_legal"),
                (
                    "recipient_doing_business_as_name",
                    "award__latest_transaction__contract_data__vendor_doing_as_business_n",
                ),
                ("cage_code", "award__latest_transaction__contract_data__cage_code"),
                ("recipient_parent_duns", "award__latest_transaction__contract_data__ultimate_parent_unique_ide"),
                ("recipient_parent_name", "award__latest_transaction__contract_data__ultimate_parent_legal_enti"),
                ("recipient_country_code", "award__latest_transaction__contract_data__legal_entity_country_code"),
                ("recipient_country_name", "award__latest_transaction__contract_data__legal_entity_country_name"),
                ("recipient_address_line_1", "award__latest_transaction__contract_data__legal_entity_address_line1"),
                ("recipient_address_line_2", "award__latest_transaction__contract_data__legal_entity_address_line2"),
                ("recipient_city_name", "award__latest_transaction__contract_data__legal_entity_city_name"),
                ("recipient_state_code", "award__latest_transaction__contract_data__legal_entity_state_code"),
                ("recipient_state_name", "award__latest_transaction__contract_data__legal_entity_state_descrip"),
                ("recipient_zip_4_code", "award__latest_transaction__contract_data__legal_entity_zip4"),
                (
                    "recipient_congressional_district",
                    "award__latest_transaction__contract_data__legal_entity_congressional",
                ),
                ("recipient_phone_number", "award__latest_transaction__contract_data__vendor_phone_number"),
                ("recipient_fax_number", "award__latest_transaction__contract_data__vendor_fax_number"),
                (
                    "primary_place_of_performance_country_code",
                    "award__latest_transaction__contract_data__place_of_perform_country_c",
                ),
                (
                    "primary_place_of_performance_country_name",
                    "award__latest_transaction__contract_data__place_of_perf_country_desc",
                ),
                (
                    "primary_place_of_performance_city_name",
                    "award__latest_transaction__contract_data__place_of_perform_city_name",
                ),
                (
                    "primary_place_of_performance_county_name",
                    "award__latest_transaction__contract_data__place_of_perform_county_na",
                ),
                (
                    "primary_place_of_performance_state_code",
                    "award__latest_transaction__contract_data__place_of_performance_state",
                ),
                (
                    "primary_place_of_performance_state_name",
                    "award__latest_transaction__contract_data__place_of_perfor_state_desc",
                ),
                (
                    "primary_place_of_performance_zip_4",
                    "award__latest_transaction__contract_data__place_of_performance_zip4a",
                ),
                (
                    "primary_place_of_performance_congressional_district",
                    "award__latest_transaction__contract_data__place_of_performance_congr",
                ),
                ("award_or_idv_flag", "award__latest_transaction__contract_data__pulled_from"),
                (
                    "award_type_code",
                    "award__latest_transaction__contract_data__contract_award_type",
                ),  # Column is appended to in account_download.py
                (
                    "award_type",
                    "award__latest_transaction__contract_data__contract_award_type_desc",
                ),  # Column is appended to in account_download.py
                ("idv_type_code", "award__latest_transaction__contract_data__idv_type"),
                ("idv_type", "award__latest_transaction__contract_data__idv_type_description"),
                (
                    "multiple_or_single_award_idv_code",
                    "award__latest_transaction__contract_data__multiple_or_single_award_i",
                ),
                (
                    "multiple_or_single_award_idv",
                    "award__latest_transaction__contract_data__multiple_or_single_aw_desc",
                ),
                ("type_of_idc_code", "award__latest_transaction__contract_data__type_of_idc"),
                ("type_of_idc", "award__latest_transaction__contract_data__type_of_idc_description"),
                ("type_of_contract_pricing_code", "award__latest_transaction__contract_data__type_of_contract_pricing"),
                ("type_of_contract_pricing", "award__latest_transaction__contract_data__type_of_contract_pric_desc"),
                ("award_description", "award__description"),
                ("solicitation_identifier", "award__latest_transaction__contract_data__solicitation_identifier"),
                ("number_of_actions", "award__latest_transaction__contract_data__number_of_actions"),
                (
                    "inherently_governmental_functions",
                    "award__latest_transaction__contract_data__inherently_government_func",
                ),
                (
                    "inherently_governmental_functions_description",
                    "award__latest_transaction__contract_data__inherently_government_desc",
                ),
                ("product_or_service_code", "award__latest_transaction__contract_data__product_or_service_code"),
                (
                    "product_or_service_code_description",
                    "award__latest_transaction__contract_data__product_or_service_co_desc",
                ),
                ("contract_bundling_code", "award__latest_transaction__contract_data__contract_bundling"),
                ("contract_bundling", "award__latest_transaction__contract_data__contract_bundling_descrip"),
                ("dod_claimant_program_code", "award__latest_transaction__contract_data__dod_claimant_program_code"),
                (
                    "dod_claimant_program_description",
                    "award__latest_transaction__contract_data__dod_claimant_prog_cod_desc",
                ),
                ("naics_code", "award__latest_transaction__contract_data__naics"),
                ("naics_description", "award__latest_transaction__contract_data__naics_description"),
                (
                    "recovered_materials_sustainability_code",
                    "award__latest_transaction__contract_data__recovered_materials_sustai",
                ),
                (
                    "recovered_materials_sustainability",
                    "award__latest_transaction__contract_data__recovered_materials_s_desc",
                ),
                (
                    "domestic_or_foreign_entity_code",
                    "award__latest_transaction__contract_data__domestic_or_foreign_entity",
                ),
                ("domestic_or_foreign_entity", "award__latest_transaction__contract_data__domestic_or_foreign_e_desc"),
                (
                    "dod_acquisition_program_code",
                    "award__latest_transaction__contract_data__program_system_or_equipmen",
                ),
                (
                    "dod_acquisition_program_description",
                    "award__latest_transaction__contract_data__program_system_or_equ_desc",
                ),
                (
                    "information_technology_commercial_item_category_code",
                    "award__latest_transaction__contract_data__information_technology_com",
                ),
                (
                    "information_technology_commercial_item_category",
                    "award__latest_transaction__contract_data__information_technolog_desc",
                ),
                ("epa_designated_product_code", "award__latest_transaction__contract_data__epa_designated_product"),
                ("epa_designated_product", "award__latest_transaction__contract_data__epa_designated_produc_desc"),
                (
                    "country_of_product_or_service_origin_code",
                    "award__latest_transaction__contract_data__country_of_product_or_serv",
                ),
                (
                    "country_of_product_or_service_origin",
                    "award__latest_transaction__contract_data__country_of_product_or_desc",
                ),
                ("place_of_manufacture_code", "award__latest_transaction__contract_data__place_of_manufacture"),
                ("place_of_manufacture", "award__latest_transaction__contract_data__place_of_manufacture_desc"),
                ("subcontracting_plan_code", "award__latest_transaction__contract_data__subcontracting_plan"),
                ("subcontracting_plan", "award__latest_transaction__contract_data__subcontracting_plan_desc"),
                ("extent_competed_code", "award__latest_transaction__contract_data__extent_competed"),
                ("extent_competed", "award__latest_transaction__contract_data__extent_compete_description"),
                ("solicitation_procedures_code", "award__latest_transaction__contract_data__solicitation_procedures"),
                ("solicitation_procedures", "award__latest_transaction__contract_data__solicitation_procedur_desc"),
                ("type_of_set_aside_code", "award__latest_transaction__contract_data__type_set_aside"),
                ("type_of_set_aside", "award__latest_transaction__contract_data__type_set_aside_description"),
                ("evaluated_preference_code", "award__latest_transaction__contract_data__evaluated_preference"),
                ("evaluated_preference", "award__latest_transaction__contract_data__evaluated_preference_desc"),
                ("research_code", "award__latest_transaction__contract_data__research"),
                ("research", "award__latest_transaction__contract_data__research_description"),
                (
                    "fair_opportunity_limited_sources_code",
                    "award__latest_transaction__contract_data__fair_opportunity_limited_s",
                ),
                (
                    "fair_opportunity_limited_sources",
                    "award__latest_transaction__contract_data__fair_opportunity_limi_desc",
                ),
                (
                    "other_than_full_and_open_competition_code",
                    "award__latest_transaction__contract_data__other_than_full_and_open_c",
                ),
                (
                    "other_than_full_and_open_competition",
                    "award__latest_transaction__contract_data__other_than_full_and_o_desc",
                ),
                ("number_of_offers_received", "award__latest_transaction__contract_data__number_of_offers_received"),
                (
                    "commercial_item_acquisition_procedures_code",
                    "award__latest_transaction__contract_data__commercial_item_acquisitio",
                ),
                (
                    "commercial_item_acquisition_procedures",
                    "award__latest_transaction__contract_data__commercial_item_acqui_desc",
                ),
                (
                    "small_business_competitiveness_demonstration_program",
                    "award__latest_transaction__contract_data__small_business_competitive",
                ),
                (
                    "simplified_procedures_for_certain_commercial_items_code",
                    "award__latest_transaction__contract_data__commercial_item_test_progr",
                ),
                (
                    "simplified_procedures_for_certain_commercial_items",
                    "award__latest_transaction__contract_data__commercial_item_test_desc",
                ),
                ("a76_fair_act_action_code", "award__latest_transaction__contract_data__a_76_fair_act_action"),
                ("a76_fair_act_action", "award__latest_transaction__contract_data__a_76_fair_act_action_desc"),
                ("fed_biz_opps_code", "award__latest_transaction__contract_data__fed_biz_opps"),
                ("fed_biz_opps", "award__latest_transaction__contract_data__fed_biz_opps_description"),
                ("local_area_set_aside_code", "award__latest_transaction__contract_data__local_area_set_aside"),
                ("local_area_set_aside", "award__latest_transaction__contract_data__local_area_set_aside_desc"),
                (
                    "price_evaluation_adjustment_preference_percent_difference",
                    "award__latest_transaction__contract_data__price_evaluation_adjustmen",
                ),
                (
                    "clinger_cohen_act_planning_code",
                    "award__latest_transaction__contract_data__clinger_cohen_act_planning",
                ),
                ("clinger_cohen_act_planning", "award__latest_transaction__contract_data__clinger_cohen_act_pla_desc"),
                (
                    "materials_supplies_articles_equipment_code",
                    "award__latest_transaction__contract_data__materials_supplies_article",
                ),
                (
                    "materials_supplies_articles_equipment",
                    "award__latest_transaction__contract_data__materials_supplies_descrip",
                ),
                ("labor_standards_code", "award__latest_transaction__contract_data__labor_standards"),
                ("labor_standards", "award__latest_transaction__contract_data__labor_standards_descrip"),
                (
                    "construction_wage_rate_requirements_code",
                    "award__latest_transaction__contract_data__construction_wage_rate_req",
                ),
                (
                    "construction_wage_rate_requirements",
                    "award__latest_transaction__contract_data__construction_wage_rat_desc",
                ),
                (
                    "interagency_contracting_authority_code",
                    "award__latest_transaction__contract_data__interagency_contracting_au",
                ),
                (
                    "interagency_contracting_authority",
                    "award__latest_transaction__contract_data__interagency_contract_desc",
                ),
                ("other_statutory_authority", "award__latest_transaction__contract_data__other_statutory_authority"),
                ("program_acronym", "award__latest_transaction__contract_data__program_acronym"),
                (
                    "parent_award_type_code",
                    "award__latest_transaction__contract_data__referenced_idv_type",
                ),  # Column is appended to in account_download.py
                (
                    "parent_award_type",
                    "award__latest_transaction__contract_data__referenced_idv_type_desc",
                ),  # Column is appended to in account_download.py
                (
                    "parent_award_single_or_multiple_code",
                    "award__latest_transaction__contract_data__referenced_mult_or_single",
                ),
                (
                    "parent_award_single_or_multiple",
                    "award__latest_transaction__contract_data__referenced_mult_or_si_desc",
                ),
                ("major_program", "award__latest_transaction__contract_data__major_program"),
                ("national_interest_action_code", "award__latest_transaction__contract_data__national_interest_action"),
                ("national_interest_action", "award__latest_transaction__contract_data__national_interest_desc"),
                ("cost_or_pricing_data_code", "award__latest_transaction__contract_data__cost_or_pricing_data"),
                ("cost_or_pricing_data", "award__latest_transaction__contract_data__cost_or_pricing_data_desc"),
                (
                    "cost_accounting_standards_clause_code",
                    "award__latest_transaction__contract_data__cost_accounting_standards",
                ),
                (
                    "cost_accounting_standards_clause",
                    "award__latest_transaction__contract_data__cost_accounting_stand_desc",
                ),
                (
                    "government_furnished_property_code",
                    "award__latest_transaction__contract_data__government_furnished_prope",
                ),
                (
                    "government_furnished_property",
                    "award__latest_transaction__contract_data__government_furnished_prope",
                ),
                ("sea_transportation_code", "award__latest_transaction__contract_data__sea_transportation"),
                ("sea_transportation", "award__latest_transaction__contract_data__sea_transportation_desc"),
                ("consolidated_contract_code", "award__latest_transaction__contract_data__consolidated_contract"),
                ("consolidated_contract", "award__latest_transaction__contract_data__consolidated_contract_desc"),
                (
                    "performance_based_service_acquisition_code",
                    "award__latest_transaction__contract_data__performance_based_service",
                ),
                (
                    "performance_based_service_acquisition",
                    "award__latest_transaction__contract_data__performance_based_se_desc",
                ),
                ("multi_year_contract_code", "award__latest_transaction__contract_data__multi_year_contract"),
                ("multi_year_contract", "award__latest_transaction__contract_data__multi_year_contract_desc"),
                ("contract_financing_code", "award__latest_transaction__contract_data__contract_financing"),
                ("contract_financing", "award__latest_transaction__contract_data__contract_financing_descrip"),
                (
                    "purchase_card_as_payment_method_code",
                    "award__latest_transaction__contract_data__purchase_card_as_payment_m",
                ),
                (
                    "purchase_card_as_payment_method",
                    "award__latest_transaction__contract_data__purchase_card_as_paym_desc",
                ),
                (
                    "contingency_humanitarian_or_peacekeeping_operation_code",
                    "award__latest_transaction__contract_data__contingency_humanitarian_o",
                ),
                (
                    "contingency_humanitarian_or_peacekeeping_operation",
                    "award__latest_transaction__contract_data__contingency_humanitar_desc",
                ),
                (
                    "alaskan_native_corporation_owned_firm",
                    "award__latest_transaction__contract_data__alaskan_native_owned_corpo",
                ),
                (
                    "american_indian_owned_business",
                    "award__latest_transaction__contract_data__american_indian_owned_busi",
                ),
                (
                    "indian_tribe_federally_recognized",
                    "award__latest_transaction__contract_data__indian_tribe_federally_rec",
                ),
                (
                    "native_hawaiian_organization_owned_firm",
                    "award__latest_transaction__contract_data__native_hawaiian_owned_busi",
                ),
                ("tribally_owned_firm", "award__latest_transaction__contract_data__tribally_owned_business"),
                ("veteran_owned_business", "award__latest_transaction__contract_data__veteran_owned_business"),
                (
                    "service_disabled_veteran_owned_business",
                    "award__latest_transaction__contract_data__service_disabled_veteran_o",
                ),
                ("woman_owned_business", "award__latest_transaction__contract_data__woman_owned_business"),
                ("women_owned_small_business", "award__latest_transaction__contract_data__women_owned_small_business"),
                (
                    "economically_disadvantaged_women_owned_small_business",
                    "award__latest_transaction__contract_data__economically_disadvantaged",
                ),
                (
                    "joint_venture_women_owned_small_business",
                    "award__latest_transaction__contract_data__joint_venture_women_owned",
                ),
                (
                    "joint_venture_economic_disadvantaged_women_owned_small_bus",
                    "award__latest_transaction__contract_data__joint_venture_economically",
                ),
                ("minority_owned_business", "award__latest_transaction__contract_data__minority_owned_business"),
                (
                    "subcontinent_asian_asian_indian_american_owned_business",
                    "award__latest_transaction__contract_data__subcontinent_asian_asian_i",
                ),
                (
                    "asian_pacific_american_owned_business",
                    "award__latest_transaction__contract_data__asian_pacific_american_own",
                ),
                (
                    "black_american_owned_business",
                    "award__latest_transaction__contract_data__black_american_owned_busin",
                ),
                (
                    "hispanic_american_owned_business",
                    "award__latest_transaction__contract_data__hispanic_american_owned_bu",
                ),
                (
                    "native_american_owned_business",
                    "award__latest_transaction__contract_data__native_american_owned_busi",
                ),
                (
                    "other_minority_owned_business",
                    "award__latest_transaction__contract_data__other_minority_owned_busin",
                ),
                (
                    "contracting_officers_determination_of_business_size",
                    "award__latest_transaction__contract_data__contracting_officers_desc",
                ),
                (
                    "contracting_officers_determination_of_business_size_code",
                    "award__latest_transaction__contract_data__contracting_officers_deter",
                ),
                ("emerging_small_business", "award__latest_transaction__contract_data__emerging_small_business"),
                (
                    "community_developed_corporation_owned_firm",
                    "award__latest_transaction__contract_data__community_developed_corpor",
                ),
                ("labor_surplus_area_firm", "award__latest_transaction__contract_data__labor_surplus_area_firm"),
                ("us_federal_government", "award__latest_transaction__contract_data__us_federal_government"),
                (
                    "federally_funded_research_and_development_corp",
                    "award__latest_transaction__contract_data__federally_funded_research",
                ),
                ("federal_agency", "award__latest_transaction__contract_data__federal_agency"),
                ("us_state_government", "award__latest_transaction__contract_data__us_state_government"),
                ("us_local_government", "award__latest_transaction__contract_data__us_local_government"),
                ("city_local_government", "award__latest_transaction__contract_data__city_local_government"),
                ("county_local_government", "award__latest_transaction__contract_data__county_local_government"),
                (
                    "inter_municipal_local_government",
                    "award__latest_transaction__contract_data__inter_municipal_local_gove",
                ),
                ("local_government_owned", "award__latest_transaction__contract_data__local_government_owned"),
                (
                    "municipality_local_government",
                    "award__latest_transaction__contract_data__municipality_local_governm",
                ),
                (
                    "school_district_local_government",
                    "award__latest_transaction__contract_data__school_district_local_gove",
                ),
                ("township_local_government", "award__latest_transaction__contract_data__township_local_government"),
                ("us_tribal_government", "award__latest_transaction__contract_data__us_tribal_government"),
                ("foreign_government", "award__latest_transaction__contract_data__foreign_government"),
                ("organizational_type", "award__latest_transaction__contract_data__organizational_type"),
                (
                    "corporate_entity_not_tax_exempt",
                    "award__latest_transaction__contract_data__corporate_entity_not_tax_e",
                ),
                ("corporate_entity_tax_exempt", "award__latest_transaction__contract_data__corporate_entity_tax_exemp"),
                (
                    "partnership_or_limited_liability_partnership",
                    "award__latest_transaction__contract_data__partnership_or_limited_lia",
                ),
                ("sole_proprietorship", "award__latest_transaction__contract_data__sole_proprietorship"),
                (
                    "small_agricultural_cooperative",
                    "award__latest_transaction__contract_data__small_agricultural_coopera",
                ),
                ("international_organization", "award__latest_transaction__contract_data__international_organization"),
                ("us_government_entity", "award__latest_transaction__contract_data__us_government_entity"),
                (
                    "community_development_corporation",
                    "award__latest_transaction__contract_data__community_development_corp",
                ),
                ("domestic_shelter", "award__latest_transaction__contract_data__domestic_shelter"),
                ("educational_institution", "award__latest_transaction__contract_data__educational_institution"),
                ("foundation", "award__latest_transaction__contract_data__foundation"),
                ("hospital_flag", "award__latest_transaction__contract_data__hospital_flag"),
                ("manufacturer_of_goods", "award__latest_transaction__contract_data__manufacturer_of_goods"),
                ("veterinary_hospital", "award__latest_transaction__contract_data__veterinary_hospital"),
                (
                    "hispanic_servicing_institution",
                    "award__latest_transaction__contract_data__hispanic_servicing_institu",
                ),
                ("receives_contracts", "award__latest_transaction__contract_data__contracts"),
                ("receives_financial_assistance", "award__latest_transaction__contract_data__grants"),
                (
                    "receives_contracts_and_financial_assistance",
                    "award__latest_transaction__contract_data__receives_contracts_and_gra",
                ),
                ("airport_authority", "award__latest_transaction__contract_data__airport_authority"),
                ("council_of_governments", "award__latest_transaction__contract_data__council_of_governments"),
                (
                    "housing_authorities_public_tribal",
                    "award__latest_transaction__contract_data__housing_authorities_public",
                ),
                ("interstate_entity", "award__latest_transaction__contract_data__interstate_entity"),
                ("planning_commission", "award__latest_transaction__contract_data__planning_commission"),
                ("port_authority", "award__latest_transaction__contract_data__port_authority"),
                ("transit_authority", "award__latest_transaction__contract_data__transit_authority"),
                ("subchapter_scorporation", "award__latest_transaction__contract_data__subchapter_s_corporation"),
                (
                    "limited_liability_corporation",
                    "award__latest_transaction__contract_data__limited_liability_corporat",
                ),
                ("foreign_owned", "award__latest_transaction__contract_data__foreign_owned_and_located"),
                ("for_profit_organization", "award__latest_transaction__contract_data__for_profit_organization"),
                ("nonprofit_organization", "award__latest_transaction__contract_data__nonprofit_organization"),
                (
                    "other_not_for_profit_organization",
                    "award__latest_transaction__contract_data__other_not_for_profit_organ",
                ),
                ("the_ability_one_program", "award__latest_transaction__contract_data__the_ability_one_program"),
                (
                    "private_university_or_college",
                    "award__latest_transaction__contract_data__private_university_or_coll",
                ),
                (
                    "state_controlled_institution_of_higher_learning",
                    "award__latest_transaction__contract_data__state_controlled_instituti",
                ),
                ("1862_land_grant_college", "award__latest_transaction__contract_data__c1862_land_grant_college"),
                ("1890_land_grant_college", "award__latest_transaction__contract_data__c1890_land_grant_college"),
                ("1994_land_grant_college", "award__latest_transaction__contract_data__c1994_land_grant_college"),
                ("minority_institution", "award__latest_transaction__contract_data__minority_institution"),
                ("historically_black_college", "award__latest_transaction__contract_data__historically_black_college"),
                ("tribal_college", "award__latest_transaction__contract_data__tribal_college"),
                (
                    "alaskan_native_servicing_institution",
                    "award__latest_transaction__contract_data__alaskan_native_servicing_i",
                ),
                (
                    "native_hawaiian_servicing_institution",
                    "award__latest_transaction__contract_data__native_hawaiian_servicing",
                ),
                ("school_of_forestry", "award__latest_transaction__contract_data__school_of_forestry"),
                ("veterinary_college", "award__latest_transaction__contract_data__veterinary_college"),
                ("dot_certified_disadvantage", "award__latest_transaction__contract_data__dot_certified_disadvantage"),
                (
                    "self_certified_small_disadvantaged_business",
                    "award__latest_transaction__contract_data__self_certified_small_disad",
                ),
                (
                    "small_disadvantaged_business",
                    "award__latest_transaction__contract_data__small_disadvantaged_busine",
                ),
                ("c8a_program_participant", "award__latest_transaction__contract_data__c8a_program_participant"),
                (
                    "historically_underutilized_business_zone_hubzone_firm",
                    "award__latest_transaction__contract_data__historically_underutilized",
                ),
                (
                    "sba_certified_8a_joint_venture",
                    "award__latest_transaction__contract_data__sba_certified_8_a_joint_ve",
                ),
                ("highly_compensated_officer_1_name", "award__officer_1_name"),
                ("highly_compensated_officer_1_amount", "award__officer_1_amount"),
                ("highly_compensated_officer_2_name", "award__officer_2_name"),
                ("highly_compensated_officer_2_amount", "award__officer_2_amount"),
                ("highly_compensated_officer_3_name", "award__officer_3_name"),
                ("highly_compensated_officer_3_amount", "award__officer_3_amount"),
                ("highly_compensated_officer_4_name", "award__officer_4_name"),
                ("highly_compensated_officer_4_amount", "award__officer_4_amount"),
                ("highly_compensated_officer_5_name", "award__officer_5_name"),
                ("highly_compensated_officer_5_amount", "award__officer_5_amount"),
                ("usaspending_permalink", None),  # to be filled in by annotation
                ("last_modified_date", "award__latest_transaction__contract_data__last_modified"),
            ]
        ),
        "d2": OrderedDict(
            [
                ("assistance_award_unique_key", "award__generated_unique_award_id"),
                ("award_id_fain", "award__fain"),
                ("award_id_uri", "award__uri"),
                ("sai_number", "award__latest_transaction__assistance_data__sai_number"),
                ("total_obligated_amount", "award__total_obligation"),
                ("total_non_federal_funding_amount", "award__non_federal_funding_amount"),
                ("total_funding_amount", "award__total_funding_amount"),
                ("total_face_value_of_loan", "award__total_loan_value"),
                ("total_loan_subsidy_cost", "award__total_subsidy_cost"),
                ("award_base_action_date", "award__date_signed"),
                ("award_base_action_date_fiscal_year", None),  # Annotation is used to create this column
                ("period_of_performance_start_date", "award__period_of_performance_start_date"),
                ("period_of_performance_current_end_date", "award__period_of_performance_current_end_date"),
                ("awarding_agency_code", "award__latest_transaction__assistance_data__awarding_agency_code"),
                ("awarding_agency_name", "award__latest_transaction__assistance_data__awarding_agency_name"),
                ("awarding_sub_agency_code", "award__latest_transaction__assistance_data__awarding_sub_tier_agency_c"),
                ("awarding_sub_agency_name", "award__latest_transaction__assistance_data__awarding_sub_tier_agency_n"),
                ("awarding_office_code", "award__latest_transaction__assistance_data__awarding_office_code"),
                ("awarding_office_name", "award__latest_transaction__assistance_data__awarding_office_name"),
                ("funding_agency_code", "award__latest_transaction__assistance_data__funding_agency_code"),
                ("funding_agency_name", "award__latest_transaction__assistance_data__funding_agency_name"),
                ("funding_sub_agency_code", "award__latest_transaction__assistance_data__funding_sub_tier_agency_co"),
                ("funding_sub_agency_name", "award__latest_transaction__assistance_data__funding_sub_tier_agency_na"),
                ("funding_office_code", "award__latest_transaction__assistance_data__funding_office_code"),
                ("funding_office_name", "award__latest_transaction__assistance_data__funding_office_name"),
                ("treasury_accounts_funding_this_award", None),  # Annotation is used to create this column
                ("federal_accounts_funding_this_award", None),  # Annotation is used to create this column
                ("recipient_duns", "award__latest_transaction__assistance_data__awardee_or_recipient_uniqu"),
                ("recipient_name", "award__latest_transaction__assistance_data__awardee_or_recipient_legal"),
                ("recipient_parent_duns", "award__latest_transaction__assistance_data__ultimate_parent_unique_ide"),
                ("recipient_parent_name", "award__latest_transaction__assistance_data__ultimate_parent_legal_enti"),
                ("recipient_country_code", "award__latest_transaction__assistance_data__legal_entity_country_code"),
                ("recipient_country_name", "award__latest_transaction__assistance_data__legal_entity_country_name"),
                ("recipient_address_line_1", "award__latest_transaction__assistance_data__legal_entity_address_line1"),
                ("recipient_address_line_2", "award__latest_transaction__assistance_data__legal_entity_address_line2"),
                ("recipient_city_code", "award__latest_transaction__assistance_data__legal_entity_city_code"),
                ("recipient_city_name", "award__latest_transaction__assistance_data__legal_entity_city_name"),
                ("recipient_county_code", "award__latest_transaction__assistance_data__legal_entity_county_code"),
                ("recipient_county_name", "award__latest_transaction__assistance_data__legal_entity_county_name"),
                ("recipient_state_code", "award__latest_transaction__assistance_data__legal_entity_state_code"),
                ("recipient_state_name", "award__latest_transaction__assistance_data__legal_entity_state_name"),
                ("recipient_zip_code", "award__latest_transaction__assistance_data__legal_entity_zip5"),
                ("recipient_zip_last_4_code", "award__latest_transaction__assistance_data__legal_entity_zip_last4"),
                (
                    "recipient_congressional_district",
                    "award__latest_transaction__assistance_data__legal_entity_congressional",
                ),
                (
                    "recipient_foreign_city_name",
                    "award__latest_transaction__assistance_data__legal_entity_foreign_city",
                ),
                (
                    "recipient_foreign_province_name",
                    "award__latest_transaction__assistance_data__legal_entity_foreign_provi",
                ),
                (
                    "recipient_foreign_postal_code",
                    "award__latest_transaction__assistance_data__legal_entity_foreign_posta",
                ),
                (
                    "primary_place_of_performance_scope",
                    "award__latest_transaction__assistance_data__place_of_performance_scope",
                ),
                (
                    "primary_place_of_performance_country_code",
                    "award__latest_transaction__assistance_data__place_of_perform_country_c",
                ),
                (
                    "primary_place_of_performance_country_name",
                    "award__latest_transaction__assistance_data__place_of_perform_country_n",
                ),
                (
                    "primary_place_of_performance_code",
                    "award__latest_transaction__assistance_data__place_of_performance_code",
                ),
                (
                    "primary_place_of_performance_city_name",
                    "award__latest_transaction__assistance_data__place_of_performance_city",
                ),
                (
                    "primary_place_of_performance_county_code",
                    "award__latest_transaction__assistance_data__place_of_perform_county_co",
                ),
                (
                    "primary_place_of_performance_county_name",
                    "award__latest_transaction__assistance_data__place_of_perform_county_na",
                ),
                (
                    "primary_place_of_performance_state_name",
                    "award__latest_transaction__assistance_data__place_of_perform_state_nam",
                ),
                (
                    "primary_place_of_performance_zip_4",
                    "award__latest_transaction__assistance_data__place_of_performance_zip4a",
                ),
                (
                    "primary_place_of_performance_congressional_district",
                    "award__latest_transaction__assistance_data__place_of_performance_congr",
                ),
                (
                    "primary_place_of_performance_foreign_location",
                    "award__latest_transaction__assistance_data__place_of_performance_forei",
                ),
                ("cfda_number", "award__latest_transaction__assistance_data__cfda_number"),
                ("cfda_title", "award__latest_transaction__assistance_data__cfda_title"),
                ("assistance_type_code", "award__latest_transaction__assistance_data__assistance_type"),
                ("assistance_type_description", "award__latest_transaction__assistance_data__assistance_type_desc"),
                ("award_description", "award__description"),
                (
                    "business_funds_indicator_code",
                    "award__latest_transaction__assistance_data__business_funds_indicator",
                ),
                (
                    "business_funds_indicator_description",
                    "award__latest_transaction__assistance_data__business_funds_ind_desc",
                ),
                ("business_types_code", "award__latest_transaction__assistance_data__business_types"),
                ("business_types_description", "award__latest_transaction__assistance_data__business_types_desc"),
                ("record_type_code", "award__latest_transaction__assistance_data__record_type"),
                ("record_type_description", "award__latest_transaction__assistance_data__record_type_description"),
                ("highly_compensated_officer_1_name", "award__officer_1_name"),
                ("highly_compensated_officer_1_amount", "award__officer_1_amount"),
                ("highly_compensated_officer_2_name", "award__officer_2_name"),
                ("highly_compensated_officer_2_amount", "award__officer_2_amount"),
                ("highly_compensated_officer_3_name", "award__officer_3_name"),
                ("highly_compensated_officer_3_amount", "award__officer_3_amount"),
                ("highly_compensated_officer_4_name", "award__officer_4_name"),
                ("highly_compensated_officer_4_amount", "award__officer_4_amount"),
                ("highly_compensated_officer_5_name", "award__officer_5_name"),
                ("highly_compensated_officer_5_amount", "award__officer_5_amount"),
                ("usaspending_permalink", None),  # to be filled in by annotation
                ("last_modified_date", "award__latest_transaction__assistance_data__modified_at"),
            ]
        ),
    },
    "transaction": {
        "d1": OrderedDict(
            [
                ("contract_transaction_unique_key", "transaction__contract_data__detached_award_proc_unique"),
                ("contract_award_unique_key", "transaction__award__generated_unique_award_id"),
                ("award_id_piid", "transaction__contract_data__piid"),
                ("modification_number", "transaction__contract_data__award_modification_amendme"),
                ("transaction_number", "transaction__contract_data__transaction_number"),
                ("parent_award_agency_id", "transaction__contract_data__referenced_idv_agency_iden"),
                ("parent_award_agency_name", "transaction__contract_data__referenced_idv_agency_desc"),
                ("parent_award_id_piid", "transaction__contract_data__parent_award_id"),
                ("parent_award_modification_number", "transaction__contract_data__referenced_idv_modificatio"),
                ("federal_action_obligation", "transaction__federal_action_obligation"),
                ("total_dollars_obligated", "transaction__contract_data__total_obligated_amount"),
                ("base_and_exercised_options_value", "transaction__contract_data__base_exercised_options_val"),
                ("current_total_value_of_award", "transaction__contract_data__current_total_value_award"),
                ("base_and_all_options_value", "transaction__contract_data__base_and_all_options_value"),
                ("potential_total_value_of_award", "transaction__contract_data__potential_total_value_awar"),
                ("action_date", "transaction__action_date"),
                ("action_date_fiscal_year", None),  # Annotation is used to create this column
                ("period_of_performance_start_date", "transaction__contract_data__period_of_performance_star"),
                ("period_of_performance_current_end_date", "transaction__contract_data__period_of_performance_curr"),
                ("period_of_performance_potential_end_date", "transaction__contract_data__period_of_perf_potential_e"),
                ("ordering_period_end_date", "transaction__contract_data__ordering_period_end_date"),
                ("solicitation_date", "transaction__contract_data__solicitation_date"),
                ("awarding_agency_code", "transaction__contract_data__awarding_agency_code"),
                ("awarding_agency_name", "transaction__contract_data__awarding_agency_name"),
                ("awarding_sub_agency_code", "transaction__contract_data__awarding_sub_tier_agency_c"),
                ("awarding_sub_agency_name", "transaction__contract_data__awarding_sub_tier_agency_n"),
                ("awarding_office_code", "transaction__contract_data__awarding_office_code"),
                ("awarding_office_name", "transaction__contract_data__awarding_office_name"),
                ("funding_agency_code", "transaction__contract_data__funding_agency_code"),
                ("funding_agency_name", "transaction__contract_data__funding_agency_name"),
                ("funding_sub_agency_code", "transaction__contract_data__funding_sub_tier_agency_co"),
                ("funding_sub_agency_name", "transaction__contract_data__funding_sub_tier_agency_na"),
                ("funding_office_code", "transaction__contract_data__funding_office_code"),
                ("funding_office_name", "transaction__contract_data__funding_office_name"),
                ("treasury_accounts_funding_this_award", None),  # Annotation is used to create this column
                ("federal_accounts_funding_this_award", None),  # Annotation is used to create this column
                ("foreign_funding", "transaction__contract_data__foreign_funding"),
                ("foreign_funding_description", "transaction__contract_data__foreign_funding_desc"),
                ("sam_exception", "transaction__contract_data__sam_exception"),
                ("sam_exception_description", "transaction__contract_data__sam_exception_description"),
                ("recipient_duns", "transaction__contract_data__awardee_or_recipient_uniqu"),
                ("recipient_name", "transaction__contract_data__awardee_or_recipient_legal"),
                ("recipient_doing_business_as_name", "transaction__contract_data__vendor_doing_as_business_n"),
                ("cage_code", "transaction__contract_data__cage_code"),
                ("recipient_parent_duns", "transaction__contract_data__ultimate_parent_unique_ide"),
                ("recipient_parent_name", "transaction__contract_data__ultimate_parent_legal_enti"),
                ("recipient_country_code", "transaction__contract_data__legal_entity_country_code"),
                ("recipient_country_name", "transaction__contract_data__legal_entity_country_name"),
                ("recipient_address_line_1", "transaction__contract_data__legal_entity_address_line1"),
                ("recipient_address_line_2", "transaction__contract_data__legal_entity_address_line2"),
                ("recipient_city_name", "transaction__contract_data__legal_entity_city_name"),
                ("recipient_state_code", "transaction__contract_data__legal_entity_state_code"),
                ("recipient_state_name", "transaction__contract_data__legal_entity_state_descrip"),
                ("recipient_zip_4_code", "transaction__contract_data__legal_entity_zip4"),
                ("recipient_congressional_district", "transaction__contract_data__legal_entity_congressional"),
                ("recipient_phone_number", "transaction__contract_data__vendor_phone_number"),
                ("recipient_fax_number", "transaction__contract_data__vendor_fax_number"),
                ("primary_place_of_performance_country_code", "transaction__contract_data__place_of_perform_country_c"),
                ("primary_place_of_performance_country_name", "transaction__contract_data__place_of_perf_country_desc"),
                ("primary_place_of_performance_city_name", "transaction__contract_data__place_of_perform_city_name"),
                ("primary_place_of_performance_county_name", "transaction__contract_data__place_of_perform_county_na"),
                ("primary_place_of_performance_state_code", "transaction__contract_data__place_of_performance_state"),
                ("primary_place_of_performance_state_name", "transaction__contract_data__place_of_perfor_state_desc"),
                ("primary_place_of_performance_zip_4", "transaction__contract_data__place_of_performance_zip4a"),
                (
                    "primary_place_of_performance_congressional_district",
                    "transaction__contract_data__place_of_performance_congr",
                ),
                ("award_or_idv_flag", "transaction__contract_data__pulled_from"),
                (
                    "award_type_code",
                    "transaction__contract_data__contract_award_type",
                ),  # Column is appended to in account_download.py
                (
                    "award_type",
                    "transaction__contract_data__contract_award_type_desc",
                ),  # Column is appended to in account_download.py
                ("idv_type_code", "transaction__contract_data__idv_type"),
                ("idv_type", "transaction__contract_data__idv_type_description"),
                ("multiple_or_single_award_idv_code", "transaction__contract_data__multiple_or_single_award_i"),
                ("multiple_or_single_award_idv", "transaction__contract_data__multiple_or_single_aw_desc"),
                ("type_of_idc_code", "transaction__contract_data__type_of_idc"),
                ("type_of_idc", "transaction__contract_data__type_of_idc_description"),
                ("type_of_contract_pricing_code", "transaction__contract_data__type_of_contract_pricing"),
                ("type_of_contract_pricing", "transaction__contract_data__type_of_contract_pric_desc"),
                ("award_description", "transaction__contract_data__award_description"),
                ("action_type_code", "transaction__action_type"),
                ("action_type", "transaction__action_type_description"),
                ("solicitation_identifier", "transaction__contract_data__solicitation_identifier"),
                ("number_of_actions", "transaction__contract_data__number_of_actions"),
                ("inherently_governmental_functions", "transaction__contract_data__inherently_government_func"),
                (
                    "inherently_governmental_functions_description",
                    "transaction__contract_data__inherently_government_desc",
                ),
                ("product_or_service_code", "transaction__contract_data__product_or_service_code"),
                ("product_or_service_code_description", "transaction__contract_data__product_or_service_co_desc"),
                ("contract_bundling_code", "transaction__contract_data__contract_bundling"),
                ("contract_bundling", "transaction__contract_data__contract_bundling_descrip"),
                ("dod_claimant_program_code", "transaction__contract_data__dod_claimant_program_code"),
                ("dod_claimant_program_description", "transaction__contract_data__dod_claimant_prog_cod_desc"),
                ("naics_code", "transaction__contract_data__naics"),
                ("naics_description", "transaction__contract_data__naics_description"),
                ("recovered_materials_sustainability_code", "transaction__contract_data__recovered_materials_sustai"),
                ("recovered_materials_sustainability", "transaction__contract_data__recovered_materials_s_desc"),
                ("domestic_or_foreign_entity_code", "transaction__contract_data__domestic_or_foreign_entity"),
                ("domestic_or_foreign_entity", "transaction__contract_data__domestic_or_foreign_e_desc"),
                ("dod_acquisition_program_code", "transaction__contract_data__program_system_or_equipmen"),
                ("dod_acquisition_program_description", "transaction__contract_data__program_system_or_equ_desc"),
                (
                    "information_technology_commercial_item_category_code",
                    "transaction__contract_data__information_technology_com",
                ),
                (
                    "information_technology_commercial_item_category",
                    "transaction__contract_data__information_technolog_desc",
                ),
                ("epa_designated_product_code", "transaction__contract_data__epa_designated_product"),
                ("epa_designated_product", "transaction__contract_data__epa_designated_produc_desc"),
                ("country_of_product_or_service_origin_code", "transaction__contract_data__country_of_product_or_serv"),
                ("country_of_product_or_service_origin", "transaction__contract_data__country_of_product_or_desc"),
                ("place_of_manufacture_code", "transaction__contract_data__place_of_manufacture"),
                ("place_of_manufacture", "transaction__contract_data__place_of_manufacture_desc"),
                ("subcontracting_plan_code", "transaction__contract_data__subcontracting_plan"),
                ("subcontracting_plan", "transaction__contract_data__subcontracting_plan_desc"),
                ("extent_competed_code", "transaction__contract_data__extent_competed"),
                ("extent_competed", "transaction__contract_data__extent_compete_description"),
                ("solicitation_procedures_code", "transaction__contract_data__solicitation_procedures"),
                ("solicitation_procedures", "transaction__contract_data__solicitation_procedur_desc"),
                ("type_of_set_aside_code", "transaction__contract_data__type_set_aside"),
                ("type_of_set_aside", "transaction__contract_data__type_set_aside_description"),
                ("evaluated_preference_code", "transaction__contract_data__evaluated_preference"),
                ("evaluated_preference", "transaction__contract_data__evaluated_preference_desc"),
                ("research_code", "transaction__contract_data__research"),
                ("research", "transaction__contract_data__research_description"),
                ("fair_opportunity_limited_sources_code", "transaction__contract_data__fair_opportunity_limited_s"),
                ("fair_opportunity_limited_sources", "transaction__contract_data__fair_opportunity_limi_desc"),
                ("other_than_full_and_open_competition_code", "transaction__contract_data__other_than_full_and_open_c"),
                ("other_than_full_and_open_competition", "transaction__contract_data__other_than_full_and_o_desc"),
                ("number_of_offers_received", "transaction__contract_data__number_of_offers_received"),
                (
                    "commercial_item_acquisition_procedures_code",
                    "transaction__contract_data__commercial_item_acquisitio",
                ),
                ("commercial_item_acquisition_procedures", "transaction__contract_data__commercial_item_acqui_desc"),
                (
                    "small_business_competitiveness_demonstration_program",
                    "transaction__contract_data__small_business_competitive",
                ),
                (
                    "simplified_procedures_for_certain_commercial_items_code",
                    "transaction__contract_data__commercial_item_test_progr",
                ),
                (
                    "simplified_procedures_for_certain_commercial_items",
                    "transaction__contract_data__commercial_item_test_desc",
                ),
                ("a76_fair_act_action_code", "transaction__contract_data__a_76_fair_act_action"),
                ("a76_fair_act_action", "transaction__contract_data__a_76_fair_act_action_desc"),
                ("fed_biz_opps_code", "transaction__contract_data__fed_biz_opps"),
                ("fed_biz_opps", "transaction__contract_data__fed_biz_opps_description"),
                ("local_area_set_aside_code", "transaction__contract_data__local_area_set_aside"),
                ("local_area_set_aside", "transaction__contract_data__local_area_set_aside_desc"),
                (
                    "price_evaluation_adjustment_preference_percent_difference",
                    "transaction__contract_data__price_evaluation_adjustmen",
                ),
                ("clinger_cohen_act_planning_code", "transaction__contract_data__clinger_cohen_act_planning"),
                ("clinger_cohen_act_planning", "transaction__contract_data__clinger_cohen_act_pla_desc"),
                (
                    "materials_supplies_articles_equipment_code",
                    "transaction__contract_data__materials_supplies_article",
                ),
                ("materials_supplies_articles_equipment", "transaction__contract_data__materials_supplies_descrip"),
                ("labor_standards_code", "transaction__contract_data__labor_standards"),
                ("labor_standards", "transaction__contract_data__labor_standards_descrip"),
                ("construction_wage_rate_requirements_code", "transaction__contract_data__construction_wage_rate_req"),
                ("construction_wage_rate_requirements", "transaction__contract_data__construction_wage_rat_desc"),
                ("interagency_contracting_authority_code", "transaction__contract_data__interagency_contracting_au"),
                ("interagency_contracting_authority", "transaction__contract_data__interagency_contract_desc"),
                ("other_statutory_authority", "transaction__contract_data__other_statutory_authority"),
                ("program_acronym", "transaction__contract_data__program_acronym"),
                (
                    "parent_award_type_code",
                    "transaction__contract_data__referenced_idv_type",
                ),  # Column is appended to in account_download.py
                (
                    "parent_award_type",
                    "transaction__contract_data__referenced_idv_type_desc",
                ),  # Column is appended to in account_download.py
                ("parent_award_single_or_multiple_code", "transaction__contract_data__referenced_mult_or_single"),
                ("parent_award_single_or_multiple", "transaction__contract_data__referenced_mult_or_si_desc"),
                ("major_program", "transaction__contract_data__major_program"),
                ("national_interest_action_code", "transaction__contract_data__national_interest_action"),
                ("national_interest_action", "transaction__contract_data__national_interest_desc"),
                ("cost_or_pricing_data_code", "transaction__contract_data__cost_or_pricing_data"),
                ("cost_or_pricing_data", "transaction__contract_data__cost_or_pricing_data_desc"),
                ("cost_accounting_standards_clause_code", "transaction__contract_data__cost_accounting_standards"),
                ("cost_accounting_standards_clause", "transaction__contract_data__cost_accounting_stand_desc"),
                ("government_furnished_property_code", "transaction__contract_data__government_furnished_prope"),
                ("government_furnished_property", "transaction__contract_data__government_furnished_desc"),
                ("sea_transportation_code", "transaction__contract_data__sea_transportation"),
                ("sea_transportation", "transaction__contract_data__sea_transportation_desc"),
                ("undefinitized_action_code", "transaction__contract_data__undefinitized_action"),
                ("undefinitized_action", "transaction__contract_data__undefinitized_action_desc"),
                ("consolidated_contract_code", "transaction__contract_data__consolidated_contract"),
                ("consolidated_contract", "transaction__contract_data__consolidated_contract_desc"),
                ("performance_based_service_acquisition_code", "transaction__contract_data__performance_based_service"),
                ("performance_based_service_acquisition", "transaction__contract_data__performance_based_se_desc"),
                ("multi_year_contract_code", "transaction__contract_data__multi_year_contract"),
                ("multi_year_contract", "transaction__contract_data__multi_year_contract_desc"),
                ("contract_financing_code", "transaction__contract_data__contract_financing"),
                ("contract_financing", "transaction__contract_data__contract_financing_descrip"),
                ("purchase_card_as_payment_method_code", "transaction__contract_data__purchase_card_as_payment_m"),
                ("purchase_card_as_payment_method", "transaction__contract_data__purchase_card_as_paym_desc"),
                (
                    "contingency_humanitarian_or_peacekeeping_operation_code",
                    "transaction__contract_data__contingency_humanitarian_o",
                ),
                (
                    "contingency_humanitarian_or_peacekeeping_operation",
                    "transaction__contract_data__contingency_humanitar_desc",
                ),
                ("alaskan_native_corporation_owned_firm", "transaction__contract_data__alaskan_native_owned_corpo"),
                ("american_indian_owned_business", "transaction__contract_data__american_indian_owned_busi"),
                ("indian_tribe_federally_recognized", "transaction__contract_data__indian_tribe_federally_rec"),
                ("native_hawaiian_organization_owned_firm", "transaction__contract_data__native_hawaiian_owned_busi"),
                ("tribally_owned_firm", "transaction__contract_data__tribally_owned_business"),
                ("veteran_owned_business", "transaction__contract_data__veteran_owned_business"),
                ("service_disabled_veteran_owned_business", "transaction__contract_data__service_disabled_veteran_o"),
                ("woman_owned_business", "transaction__contract_data__woman_owned_business"),
                ("women_owned_small_business", "transaction__contract_data__women_owned_small_business"),
                (
                    "economically_disadvantaged_women_owned_small_business",
                    "transaction__contract_data__economically_disadvantaged",
                ),
                ("joint_venture_women_owned_small_business", "transaction__contract_data__joint_venture_women_owned"),
                (
                    "joint_venture_economic_disadvantaged_women_owned_small_bus",
                    "transaction__contract_data__joint_venture_economically",
                ),
                ("minority_owned_business", "transaction__contract_data__minority_owned_business"),
                (
                    "subcontinent_asian_asian_indian_american_owned_business",
                    "transaction__contract_data__subcontinent_asian_asian_i",
                ),
                ("asian_pacific_american_owned_business", "transaction__contract_data__asian_pacific_american_own"),
                ("black_american_owned_business", "transaction__contract_data__black_american_owned_busin"),
                ("hispanic_american_owned_business", "transaction__contract_data__hispanic_american_owned_bu"),
                ("native_american_owned_business", "transaction__contract_data__native_american_owned_busi"),
                ("other_minority_owned_business", "transaction__contract_data__other_minority_owned_busin"),
                (
                    "contracting_officers_determination_of_business_size",
                    "transaction__contract_data__contracting_officers_desc",
                ),
                (
                    "contracting_officers_determination_of_business_size_code",
                    "transaction__contract_data__contracting_officers_deter",
                ),
                ("emerging_small_business", "transaction__contract_data__emerging_small_business"),
                (
                    "community_developed_corporation_owned_firm",
                    "transaction__contract_data__community_developed_corpor",
                ),
                ("labor_surplus_area_firm", "transaction__contract_data__labor_surplus_area_firm"),
                ("us_federal_government", "transaction__contract_data__us_federal_government"),
                (
                    "federally_funded_research_and_development_corp",
                    "transaction__contract_data__federally_funded_research",
                ),
                ("federal_agency", "transaction__contract_data__federal_agency"),
                ("us_state_government", "transaction__contract_data__us_state_government"),
                ("us_local_government", "transaction__contract_data__us_local_government"),
                ("city_local_government", "transaction__contract_data__city_local_government"),
                ("county_local_government", "transaction__contract_data__county_local_government"),
                ("inter_municipal_local_government", "transaction__contract_data__inter_municipal_local_gove"),
                ("local_government_owned", "transaction__contract_data__local_government_owned"),
                ("municipality_local_government", "transaction__contract_data__municipality_local_governm"),
                ("school_district_local_government", "transaction__contract_data__school_district_local_gove"),
                ("township_local_government", "transaction__contract_data__township_local_government"),
                ("us_tribal_government", "transaction__contract_data__us_tribal_government"),
                ("foreign_government", "transaction__contract_data__foreign_government"),
                ("organizational_type", "transaction__contract_data__organizational_type"),
                ("corporate_entity_not_tax_exempt", "transaction__contract_data__corporate_entity_not_tax_e"),
                ("corporate_entity_tax_exempt", "transaction__contract_data__corporate_entity_tax_exemp"),
                (
                    "partnership_or_limited_liability_partnership",
                    "transaction__contract_data__partnership_or_limited_lia",
                ),
                ("sole_proprietorship", "transaction__contract_data__sole_proprietorship"),
                ("small_agricultural_cooperative", "transaction__contract_data__small_agricultural_coopera"),
                ("international_organization", "transaction__contract_data__international_organization"),
                ("us_government_entity", "transaction__contract_data__us_government_entity"),
                ("community_development_corporation", "transaction__contract_data__community_development_corp"),
                ("domestic_shelter", "transaction__contract_data__domestic_shelter"),
                ("educational_institution", "transaction__contract_data__educational_institution"),
                ("foundation", "transaction__contract_data__foundation"),
                ("hospital_flag", "transaction__contract_data__hospital_flag"),
                ("manufacturer_of_goods", "transaction__contract_data__manufacturer_of_goods"),
                ("veterinary_hospital", "transaction__contract_data__veterinary_hospital"),
                ("hispanic_servicing_institution", "transaction__contract_data__hispanic_servicing_institu"),
                ("receives_contracts", "transaction__contract_data__contracts"),
                ("receives_financial_assistance", "transaction__contract_data__grants"),
                (
                    "receives_contracts_and_financial_assistance",
                    "transaction__contract_data__receives_contracts_and_gra",
                ),
                ("airport_authority", "transaction__contract_data__airport_authority"),
                ("council_of_governments", "transaction__contract_data__council_of_governments"),
                ("housing_authorities_public_tribal", "transaction__contract_data__housing_authorities_public"),
                ("interstate_entity", "transaction__contract_data__interstate_entity"),
                ("planning_commission", "transaction__contract_data__planning_commission"),
                ("port_authority", "transaction__contract_data__port_authority"),
                ("transit_authority", "transaction__contract_data__transit_authority"),
                ("subchapter_scorporation", "transaction__contract_data__subchapter_s_corporation"),
                ("limited_liability_corporation", "transaction__contract_data__limited_liability_corporat"),
                ("foreign_owned", "transaction__contract_data__foreign_owned_and_located"),
                ("for_profit_organization", "transaction__contract_data__for_profit_organization"),
                ("nonprofit_organization", "transaction__contract_data__nonprofit_organization"),
                ("other_not_for_profit_organization", "transaction__contract_data__other_not_for_profit_organ"),
                ("the_ability_one_program", "transaction__contract_data__the_ability_one_program"),
                ("private_university_or_college", "transaction__contract_data__private_university_or_coll"),
                (
                    "state_controlled_institution_of_higher_learning",
                    "transaction__contract_data__state_controlled_instituti",
                ),
                ("1862_land_grant_college", "transaction__contract_data__c1862_land_grant_college"),
                ("1890_land_grant_college", "transaction__contract_data__c1890_land_grant_college"),
                ("1994_land_grant_college", "transaction__contract_data__c1994_land_grant_college"),
                ("minority_institution", "transaction__contract_data__minority_institution"),
                ("historically_black_college", "transaction__contract_data__historically_black_college"),
                ("tribal_college", "transaction__contract_data__tribal_college"),
                ("alaskan_native_servicing_institution", "transaction__contract_data__alaskan_native_servicing_i"),
                ("native_hawaiian_servicing_institution", "transaction__contract_data__native_hawaiian_servicing"),
                ("school_of_forestry", "transaction__contract_data__school_of_forestry"),
                ("veterinary_college", "transaction__contract_data__veterinary_college"),
                ("dot_certified_disadvantage", "transaction__contract_data__dot_certified_disadvantage"),
                (
                    "self_certified_small_disadvantaged_business",
                    "transaction__contract_data__self_certified_small_disad",
                ),
                ("small_disadvantaged_business", "transaction__contract_data__small_disadvantaged_busine"),
                ("c8a_program_participant", "transaction__contract_data__c8a_program_participant"),
                (
                    "historically_underutilized_business_zone_hubzone_firm",
                    "transaction__contract_data__historically_underutilized",
                ),
                ("sba_certified_8a_joint_venture", "transaction__contract_data__sba_certified_8_a_joint_ve"),
                ("highly_compensated_officer_1_name", "transaction__contract_data__officer_1_name"),
                ("highly_compensated_officer_1_amount", "transaction__contract_data__officer_1_amount"),
                ("highly_compensated_officer_2_name", "transaction__contract_data__officer_2_name"),
                ("highly_compensated_officer_2_amount", "transaction__contract_data__officer_2_amount"),
                ("highly_compensated_officer_3_name", "transaction__contract_data__officer_3_name"),
                ("highly_compensated_officer_3_amount", "transaction__contract_data__officer_3_amount"),
                ("highly_compensated_officer_4_name", "transaction__contract_data__officer_4_name"),
                ("highly_compensated_officer_4_amount", "transaction__contract_data__officer_4_amount"),
                ("highly_compensated_officer_5_name", "transaction__contract_data__officer_5_name"),
                ("highly_compensated_officer_5_amount", "transaction__contract_data__officer_5_amount"),
                ("usaspending_permalink", None),  # to be filled in by annotation
                ("last_modified_date", "transaction__contract_data__last_modified"),
            ]
        ),
        "d2": OrderedDict(
            [
                ("assistance_transaction_unique_key", "transaction__assistance_data__afa_generated_unique"),
                ("assistance_award_unique_key", "transaction__award__generated_unique_award_id"),
                ("award_id_fain", "transaction__assistance_data__fain"),
                ("modification_number", "transaction__modification_number"),
                ("award_id_uri", "transaction__assistance_data__uri"),
                ("sai_number", "transaction__assistance_data__sai_number"),
                ("federal_action_obligation", "transaction__federal_action_obligation"),
                ("total_obligated_amount", "transaction__award__total_obligation"),
                ("non_federal_funding_amount", "transaction__assistance_data__non_federal_funding_amount"),
                ("total_non_federal_funding_amount", "transaction__award__non_federal_funding_amount"),
                ("face_value_of_loan", "transaction__assistance_data__face_value_loan_guarantee"),
                ("original_loan_subsidy_cost", "transaction__original_loan_subsidy_cost"),
                ("total_face_value_of_loan", "transaction__award__total_loan_value"),
                ("total_loan_subsidy_cost", "transaction__award__total_subsidy_cost"),
                ("action_date", "transaction__action_date"),
                ("action_date_fiscal_year", None),  # Annotation is used to create this column
                ("period_of_performance_start_date", "transaction__period_of_performance_start_date"),
                ("period_of_performance_current_end_date", "transaction__period_of_performance_current_end_date"),
                ("awarding_agency_code", "transaction__assistance_data__awarding_agency_code"),
                ("awarding_agency_name", "transaction__assistance_data__awarding_agency_name"),
                ("awarding_sub_agency_code", "transaction__assistance_data__awarding_sub_tier_agency_c"),
                ("awarding_sub_agency_name", "transaction__assistance_data__awarding_sub_tier_agency_n"),
                ("awarding_office_code", "transaction__assistance_data__awarding_office_code"),
                ("awarding_office_name", "transaction__assistance_data__awarding_office_name"),
                ("funding_agency_code", "transaction__assistance_data__funding_agency_code"),
                ("funding_agency_name", "transaction__assistance_data__funding_agency_name"),
                ("funding_sub_agency_code", "transaction__assistance_data__funding_sub_tier_agency_co"),
                ("funding_sub_agency_name", "transaction__assistance_data__funding_sub_tier_agency_na"),
                ("funding_office_code", "transaction__assistance_data__funding_office_code"),
                ("funding_office_name", "transaction__assistance_data__funding_office_name"),
                ("treasury_accounts_funding_this_award", None),  # Annotation is used to create this column
                ("federal_accounts_funding_this_award", None),  # Annotation is used to create this column
                ("recipient_duns", "transaction__assistance_data__awardee_or_recipient_uniqu"),
                ("recipient_name", "transaction__assistance_data__awardee_or_recipient_legal"),
                ("recipient_parent_duns", "transaction__assistance_data__ultimate_parent_unique_ide"),
                ("recipient_parent_name", "transaction__assistance_data__ultimate_parent_legal_enti"),
                ("recipient_country_code", "transaction__assistance_data__legal_entity_country_code"),
                ("recipient_country_name", "transaction__assistance_data__legal_entity_country_name"),
                ("recipient_address_line_1", "transaction__assistance_data__legal_entity_address_line1"),
                ("recipient_address_line_2", "transaction__assistance_data__legal_entity_address_line2"),
                ("recipient_city_code", "transaction__assistance_data__legal_entity_city_code"),
                ("recipient_city_name", "transaction__assistance_data__legal_entity_city_name"),
                ("recipient_county_code", "transaction__assistance_data__legal_entity_county_code"),
                ("recipient_county_name", "transaction__assistance_data__legal_entity_county_name"),
                ("recipient_state_code", "transaction__assistance_data__legal_entity_state_code"),
                ("recipient_state_name", "transaction__assistance_data__legal_entity_state_name"),
                ("recipient_zip_code", "transaction__assistance_data__legal_entity_zip5"),
                ("recipient_zip_last_4_code", "transaction__assistance_data__legal_entity_zip_last4"),
                ("recipient_congressional_district", "transaction__assistance_data__legal_entity_congressional"),
                ("recipient_foreign_city_name", "transaction__assistance_data__legal_entity_foreign_city"),
                ("recipient_foreign_province_name", "transaction__assistance_data__legal_entity_foreign_provi"),
                ("recipient_foreign_postal_code", "transaction__assistance_data__legal_entity_foreign_posta"),
                ("primary_place_of_performance_scope", "transaction__assistance_data__place_of_performance_scope"),
                (
                    "primary_place_of_performance_country_code",
                    "transaction__assistance_data__place_of_perform_country_c",
                ),
                (
                    "primary_place_of_performance_country_name",
                    "transaction__assistance_data__place_of_perform_country_n",
                ),
                ("primary_place_of_performance_code", "transaction__assistance_data__place_of_performance_code"),
                ("primary_place_of_performance_city_name", "transaction__assistance_data__place_of_performance_city"),
                (
                    "primary_place_of_performance_county_code",
                    "transaction__assistance_data__place_of_perform_county_co",
                ),
                (
                    "primary_place_of_performance_county_name",
                    "transaction__assistance_data__place_of_perform_county_na",
                ),
                ("primary_place_of_performance_state_name", "transaction__assistance_data__place_of_perform_state_nam"),
                ("primary_place_of_performance_zip_4", "transaction__assistance_data__place_of_performance_zip4a"),
                (
                    "primary_place_of_performance_congressional_district",
                    "transaction__assistance_data__place_of_performance_congr",
                ),
                (
                    "primary_place_of_performance_foreign_location",
                    "transaction__assistance_data__place_of_performance_forei",
                ),
                ("cfda_number", "transaction__assistance_data__cfda_number"),
                ("cfda_title", "transaction__assistance_data__cfda_title"),
                ("assistance_type_code", "transaction__assistance_data__assistance_type"),
                ("assistance_type_description", "transaction__assistance_data__assistance_type_desc"),
                ("award_description", "transaction__assistance_data__award_description"),
                ("business_funds_indicator_code", "transaction__assistance_data__business_funds_indicator"),
                ("business_funds_indicator_description", "transaction__assistance_data__business_funds_ind_desc"),
                ("business_types_code", "transaction__assistance_data__business_types"),
                ("business_types_description", "transaction__assistance_data__business_types_desc"),
                ("correction_delete_indicator_code", "transaction__assistance_data__correction_delete_indicatr"),
                ("correction_delete_indicator_description", "transaction__assistance_data__correction_delete_ind_desc"),
                ("action_type_code", "transaction__action_type"),
                ("action_type_description", "transaction__assistance_data__action_type_description"),
                ("record_type_code", "transaction__assistance_data__record_type"),
                ("record_type_description", "transaction__assistance_data__record_type_description"),
                ("highly_compensated_officer_1_name", "transaction__assistance_data__officer_1_name"),
                ("highly_compensated_officer_1_amount", "transaction__assistance_data__officer_1_amount"),
                ("highly_compensated_officer_2_name", "transaction__assistance_data__officer_2_name"),
                ("highly_compensated_officer_2_amount", "transaction__assistance_data__officer_2_amount"),
                ("highly_compensated_officer_3_name", "transaction__assistance_data__officer_3_name"),
                ("highly_compensated_officer_3_amount", "transaction__assistance_data__officer_3_amount"),
                ("highly_compensated_officer_4_name", "transaction__assistance_data__officer_4_name"),
                ("highly_compensated_officer_4_amount", "transaction__assistance_data__officer_4_amount"),
                ("highly_compensated_officer_5_name", "transaction__assistance_data__officer_5_name"),
                ("highly_compensated_officer_5_amount", "transaction__assistance_data__officer_5_amount"),
                ("usaspending_permalink", None),  # to be filled in by annotation
                ("last_modified_date", "transaction__assistance_data__modified_at"),
            ]
        ),
    },
    "subaward": {
        "d1": OrderedDict(
            [
                ("prime_award_unique_key", "broker_subaward__unique_award_key"),
                ("prime_award_piid", "broker_subaward__award_id"),
                ("prime_award_parent_piid", "broker_subaward__parent_award_id"),
                ("prime_award_amount", "broker_subaward__award_amount"),
                ("prime_award_base_action_date", "broker_subaward__action_date"),
                ("prime_award_base_action_date_fiscal_year", None),  # Annotation is used to create this column
                ("prime_award_period_of_performance_start_date", "award__period_of_performance_start_date"),
                ("prime_award_period_of_performance_current_end_date", "award__period_of_performance_current_end_date"),
                ("period_of_performance_potential_end_date", None),  # Annotation is used to create this column
                ("prime_award_awarding_agency_code", "broker_subaward__awarding_agency_code"),
                ("prime_award_awarding_agency_name", "broker_subaward__awarding_agency_name"),
                ("prime_award_awarding_sub_agency_code", "broker_subaward__awarding_sub_tier_agency_c"),
                ("prime_award_awarding_sub_agency_name", "broker_subaward__awarding_sub_tier_agency_n"),
                ("prime_award_awarding_office_code", "broker_subaward__awarding_office_code"),
                ("prime_award_awarding_office_name", "broker_subaward__awarding_office_name"),
                ("prime_award_funding_agency_code", "broker_subaward__funding_agency_code"),
                ("prime_award_funding_agency_name", "broker_subaward__funding_agency_name"),
                ("prime_award_funding_sub_agency_code", "broker_subaward__funding_sub_tier_agency_co"),
                ("prime_award_funding_sub_agency_name", "broker_subaward__funding_sub_tier_agency_na"),
                ("prime_award_funding_office_code", "broker_subaward__funding_office_code"),
                ("prime_award_funding_office_name", "broker_subaward__funding_office_name"),
                ("prime_award_treasury_accounts_funding_this_award", None),  # Annotation is used to create this column
                ("prime_award_federal_accounts_funding_this_award", None),  # Annotation is used to create this column
                ("prime_awardee_duns", "broker_subaward__awardee_or_recipient_uniqu"),
                ("prime_awardee_name", "broker_subaward__awardee_or_recipient_legal"),
                ("prime_awardee_dba_name", "broker_subaward__dba_name"),
                ("prime_awardee_parent_duns", "broker_subaward__ultimate_parent_unique_ide"),
                ("prime_awardee_parent_name", "broker_subaward__ultimate_parent_legal_enti"),
                ("prime_awardee_country_code", "broker_subaward__legal_entity_country_code"),
                ("prime_awardee_country_name", "broker_subaward__legal_entity_country_name"),
                ("prime_awardee_address_line_1", "broker_subaward__legal_entity_address_line1"),
                ("prime_awardee_city_name", "broker_subaward__legal_entity_city_name"),
                ("prime_awardee_state_code", "broker_subaward__legal_entity_state_code"),
                ("prime_awardee_state_name", "broker_subaward__legal_entity_state_name"),
                ("prime_awardee_zip_code", "broker_subaward__legal_entity_zip"),
                ("prime_awardee_congressional_district", "broker_subaward__legal_entity_congressional"),
                ("prime_awardee_foreign_postal_code", "broker_subaward__legal_entity_foreign_posta"),
                ("prime_awardee_business_types", "broker_subaward__business_types"),
                ("prime_award_primary_place_of_performance_city_name", "broker_subaward__place_of_perform_city_name"),
                ("prime_award_primary_place_of_performance_state_code", "broker_subaward__place_of_perform_state_code"),
                ("prime_award_primary_place_of_performance_state_name", "broker_subaward__place_of_perform_state_name"),
                (
                    "prime_award_primary_place_of_performance_address_zip_code",
                    "broker_subaward__place_of_performance_zip",
                ),
                (
                    "prime_award_primary_place_of_performance_congressional_district",
                    "broker_subaward__place_of_perform_congressio",
                ),
                (
                    "prime_award_primary_place_of_performance_country_code",
                    "broker_subaward__place_of_perform_country_co",
                ),
                (
                    "prime_award_primary_place_of_performance_country_name",
                    "broker_subaward__place_of_perform_country_na",
                ),
                ("prime_award_description", "broker_subaward__award_description"),
                ("prime_award_project_title", "broker_subaward__program_title"),
                ("prime_award_naics_code", "broker_subaward__naics"),
                ("prime_award_naics_description", "broker_subaward__naics_description"),
                ("national_interest_action_code", "award__latest_transaction__contract_data__national_interest_action"),
                ("national_interest_action", "award__latest_transaction__contract_data__national_interest_desc"),
                ("subaward_type", "broker_subaward__subaward_type"),
                ("subaward_fsrs_report_id", "broker_subaward__internal_id"),
                ("subaward_fsrs_report_year", "broker_subaward__subaward_report_year"),
                ("subaward_fsrs_report_month", "broker_subaward__subaward_report_month"),
                ("subaward_number", "broker_subaward__subaward_number"),
                ("subaward_amount", "broker_subaward__subaward_amount"),
                ("subaward_action_date", "broker_subaward__sub_action_date"),
                ("subaward_action_date_fiscal_year", None),  # Annotation is used to create this column
                ("subawardee_duns", "broker_subaward__sub_awardee_or_recipient_uniqu"),
                ("subawardee_name", "broker_subaward__sub_awardee_or_recipient_legal"),
                ("subawardee_dba_name", "broker_subaward__sub_dba_name"),
                ("subawardee_parent_duns", "broker_subaward__sub_ultimate_parent_unique_ide"),
                ("subawardee_parent_name", "broker_subaward__sub_ultimate_parent_legal_enti"),
                ("subawardee_country_code", "broker_subaward__sub_legal_entity_country_code"),
                ("subawardee_country_name", "broker_subaward__sub_legal_entity_country_name"),
                ("subawardee_address_line_1", "broker_subaward__sub_legal_entity_address_line1"),
                ("subawardee_city_name", "broker_subaward__sub_legal_entity_city_name"),
                ("subawardee_state_code", "broker_subaward__sub_legal_entity_state_code"),
                ("subawardee_state_name", "broker_subaward__sub_legal_entity_state_name"),
                ("subawardee_zip_code", "broker_subaward__sub_legal_entity_zip"),
                ("subawardee_congressional_district", "broker_subaward__sub_legal_entity_congressional"),
                ("subawardee_foreign_postal_code", "broker_subaward__sub_legal_entity_foreign_posta"),
                ("subawardee_business_types", "broker_subaward__sub_business_types"),
                ("subaward_primary_place_of_performance_address_line_1", "broker_subaward__place_of_perform_street"),
                ("subaward_primary_place_of_performance_city_name", "broker_subaward__sub_place_of_perform_city_name"),
                (
                    "subaward_primary_place_of_performance_state_code",
                    "broker_subaward__sub_place_of_perform_state_code",
                ),
                (
                    "subaward_primary_place_of_performance_state_name",
                    "broker_subaward__sub_place_of_perform_state_name",
                ),
                (
                    "subaward_primary_place_of_performance_address_zip_code",
                    "broker_subaward__sub_place_of_performance_zip",
                ),
                (
                    "subaward_primary_place_of_performance_congressional_district",
                    "broker_subaward__sub_place_of_perform_congressio",
                ),
                (
                    "subaward_primary_place_of_performance_country_code",
                    "broker_subaward__sub_place_of_perform_country_co",
                ),
                (
                    "subaward_primary_place_of_performance_country_name",
                    "broker_subaward__sub_place_of_perform_country_na",
                ),
                ("subaward_description", "broker_subaward__subaward_description"),
                ("subawardee_highly_compensated_officer_1_name", "broker_subaward__sub_high_comp_officer1_full_na"),
                ("subawardee_highly_compensated_officer_1_amount", "broker_subaward__sub_high_comp_officer1_amount"),
                ("subawardee_highly_compensated_officer_2_name", "broker_subaward__sub_high_comp_officer2_full_na"),
                ("subawardee_highly_compensated_officer_2_amount", "broker_subaward__sub_high_comp_officer2_amount"),
                ("subawardee_highly_compensated_officer_3_name", "broker_subaward__sub_high_comp_officer3_full_na"),
                ("subawardee_highly_compensated_officer_3_amount", "broker_subaward__sub_high_comp_officer3_amount"),
                ("subawardee_highly_compensated_officer_4_name", "broker_subaward__sub_high_comp_officer4_full_na"),
                ("subawardee_highly_compensated_officer_4_amount", "broker_subaward__sub_high_comp_officer4_amount"),
                ("subawardee_highly_compensated_officer_5_name", "broker_subaward__sub_high_comp_officer5_full_na"),
                ("subawardee_highly_compensated_officer_5_amount", "broker_subaward__sub_high_comp_officer5_amount"),
                ("usaspending_permalink", None),  # to be filled in by annotation
                ("subaward_fsrs_report_last_modified_date", "broker_subaward__date_submitted"),
            ]
        ),
        "d2": OrderedDict(
            [
                ("prime_award_unique_key", "broker_subaward__unique_award_key"),
                ("prime_award_fain", "broker_subaward__award_id"),
                ("prime_award_amount", "broker_subaward__award_amount"),
                ("prime_award_base_action_date", "broker_subaward__action_date"),
                ("prime_award_base_action_date_fiscal_year", None),  # Annotation is used to create this column
                ("prime_award_period_of_performance_start_date", "award__period_of_performance_start_date"),
                ("prime_award_period_of_performance_current_end_date", "award__period_of_performance_current_end_date"),
                ("prime_award_awarding_agency_code", "broker_subaward__awarding_agency_code"),
                ("prime_award_awarding_agency_name", "broker_subaward__awarding_agency_name"),
                ("prime_award_awarding_sub_agency_code", "broker_subaward__awarding_sub_tier_agency_c"),
                ("prime_award_awarding_sub_agency_name", "broker_subaward__awarding_sub_tier_agency_n"),
                ("prime_award_awarding_office_code", "broker_subaward__awarding_office_code"),
                ("prime_award_awarding_office_name", "broker_subaward__awarding_office_name"),
                ("prime_award_funding_agency_code", "broker_subaward__funding_agency_code"),
                ("prime_award_funding_agency_name", "broker_subaward__funding_agency_name"),
                ("prime_award_funding_sub_agency_code", "broker_subaward__funding_sub_tier_agency_co"),
                ("prime_award_funding_sub_agency_name", "broker_subaward__funding_sub_tier_agency_na"),
                ("prime_award_funding_office_code", "broker_subaward__funding_office_code"),
                ("prime_award_funding_office_name", "broker_subaward__funding_office_name"),
                ("prime_award_treasury_accounts_funding_this_award", None),  # Annotation is used to create this column
                ("prime_award_federal_accounts_funding_this_award", None),  # Annotation is used to create this column
                ("prime_awardee_duns", "broker_subaward__awardee_or_recipient_uniqu"),
                ("prime_awardee_name", "broker_subaward__awardee_or_recipient_legal"),
                ("prime_awardee_dba_name", "broker_subaward__dba_name"),
                ("prime_awardee_parent_duns", "broker_subaward__ultimate_parent_unique_ide"),
                ("prime_awardee_parent_name", "broker_subaward__ultimate_parent_legal_enti"),
                ("prime_awardee_country_code", "broker_subaward__legal_entity_country_code"),
                ("prime_awardee_country_name", "broker_subaward__legal_entity_country_name"),
                ("prime_awardee_address_line_1", "broker_subaward__legal_entity_address_line1"),
                ("prime_awardee_city_name", "broker_subaward__legal_entity_city_name"),
                ("prime_awardee_state_code", "broker_subaward__legal_entity_state_code"),
                ("prime_awardee_state_name", "broker_subaward__legal_entity_state_name"),
                ("prime_awardee_zip_code", "broker_subaward__legal_entity_zip"),
                ("prime_awardee_congressional_district", "broker_subaward__legal_entity_congressional"),
                ("prime_awardee_foreign_postal_code", "broker_subaward__legal_entity_foreign_posta"),
                ("prime_awardee_business_types", "broker_subaward__business_types"),
                ("prime_award_primary_place_of_performance_scope", "subaward__place_of_perform_scope"),
                ("prime_award_primary_place_of_performance_city_name", "broker_subaward__place_of_perform_city_name"),
                ("prime_award_primary_place_of_performance_state_code", "broker_subaward__place_of_perform_state_code"),
                ("prime_award_primary_place_of_performance_state_name", "broker_subaward__place_of_perform_state_name"),
                (
                    "prime_award_primary_place_of_performance_address_zip_code",
                    "broker_subaward__place_of_performance_zip",
                ),
                (
                    "prime_award_primary_place_of_performance_congressional_district",
                    "broker_subaward__place_of_perform_congressio",
                ),
                (
                    "prime_award_primary_place_of_performance_country_code",
                    "broker_subaward__place_of_perform_country_co",
                ),
                (
                    "prime_award_primary_place_of_performance_country_name",
                    "broker_subaward__place_of_perform_country_na",
                ),
                ("prime_award_description", "broker_subaward__award_description"),
                ("prime_award_cfda_number", "broker_subaward__cfda_numbers"),
                ("prime_award_cfda_title", "broker_subaward__cfda_titles"),
                ("subaward_type", "broker_subaward__subaward_type"),
                ("subaward_fsrs_report_id", "broker_subaward__internal_id"),
                ("subaward_fsrs_report_year", "broker_subaward__subaward_report_year"),
                ("subaward_fsrs_report_month", "broker_subaward__subaward_report_month"),
                ("subaward_number", "broker_subaward__subaward_number"),
                ("subaward_amount", "broker_subaward__subaward_amount"),
                ("subaward_action_date", "broker_subaward__sub_action_date"),
                ("subaward_action_date_fiscal_year", None),  # Annotation is used to create this column
                ("subawardee_duns", "broker_subaward__sub_awardee_or_recipient_uniqu"),
                ("subawardee_name", "broker_subaward__sub_awardee_or_recipient_legal"),
                ("subawardee_dba_name", "broker_subaward__sub_dba_name"),
                ("subawardee_parent_duns", "broker_subaward__sub_ultimate_parent_unique_ide"),
                ("subawardee_parent_name", "broker_subaward__sub_ultimate_parent_legal_enti"),
                ("subawardee_country_code", "broker_subaward__sub_legal_entity_country_code"),
                ("subawardee_country_name", "broker_subaward__sub_legal_entity_country_name"),
                ("subawardee_address_line_1", "broker_subaward__sub_legal_entity_address_line1"),
                ("subawardee_city_name", "broker_subaward__sub_legal_entity_city_name"),
                ("subawardee_state_code", "broker_subaward__sub_legal_entity_state_code"),
                ("subawardee_state_name", "broker_subaward__sub_legal_entity_state_name"),
                ("subawardee_zip_code", "broker_subaward__sub_legal_entity_zip"),
                ("subawardee_congressional_district", "broker_subaward__sub_legal_entity_congressional"),
                ("subawardee_foreign_postal_code", "broker_subaward__sub_legal_entity_foreign_posta"),
                ("subawardee_business_types", "broker_subaward__sub_business_types"),
                ("subaward_primary_place_of_performance_address_line_1", "broker_subaward__place_of_perform_street"),
                ("subaward_primary_place_of_performance_city_name", "broker_subaward__sub_place_of_perform_city_name"),
                (
                    "subaward_primary_place_of_performance_state_code",
                    "broker_subaward__sub_place_of_perform_state_code",
                ),
                (
                    "subaward_primary_place_of_performance_state_name",
                    "broker_subaward__sub_place_of_perform_state_name",
                ),
                (
                    "subaward_primary_place_of_performance_address_zip_code",
                    "broker_subaward__sub_place_of_performance_zip",
                ),
                (
                    "subaward_primary_place_of_performance_congressional_district",
                    "broker_subaward__sub_place_of_perform_congressio",
                ),
                (
                    "subaward_primary_place_of_performance_country_code",
                    "broker_subaward__sub_place_of_perform_country_co",
                ),
                (
                    "subaward_primary_place_of_performance_country_name",
                    "broker_subaward__sub_place_of_perform_country_na",
                ),
                ("subaward_description", "broker_subaward__subaward_description"),
                ("subawardee_highly_compensated_officer_1_name", "broker_subaward__sub_high_comp_officer1_full_na"),
                ("subawardee_highly_compensated_officer_1_amount", "broker_subaward__sub_high_comp_officer1_amount"),
                ("subawardee_highly_compensated_officer_2_name", "broker_subaward__sub_high_comp_officer2_full_na"),
                ("subawardee_highly_compensated_officer_2_amount", "broker_subaward__sub_high_comp_officer2_amount"),
                ("subawardee_highly_compensated_officer_3_name", "broker_subaward__sub_high_comp_officer3_full_na"),
                ("subawardee_highly_compensated_officer_3_amount", "broker_subaward__sub_high_comp_officer3_amount"),
                ("subawardee_highly_compensated_officer_4_name", "broker_subaward__sub_high_comp_officer4_full_na"),
                ("subawardee_highly_compensated_officer_4_amount", "broker_subaward__sub_high_comp_officer4_amount"),
                ("subawardee_highly_compensated_officer_5_name", "broker_subaward__sub_high_comp_officer5_full_na"),
                ("subawardee_highly_compensated_officer_5_amount", "broker_subaward__sub_high_comp_officer5_amount"),
                ("usaspending_permalink", None),  # to be filled in by annotation
                ("subaward_fsrs_report_last_modified_date", "broker_subaward__date_submitted"),
            ]
        ),
    },
    "account_balances": {
        "treasury_account": OrderedDict(
            [
                ("owning_agency_name", "treasury_account_identifier__funding_toptier_agency__name"),
                ("reporting_agency_name", "submission__reporting_agency_name"),
                (
                    "last_reported_submission_period",
                    "last_reported_submission_period",
                ),  # Column is appended to in account_download.py
                (
                    "allocation_transfer_agency_identifer_code",
                    "treasury_account_identifier__allocation_transfer_agency_id",
                ),
                ("agency_identifier_code", "treasury_account_identifier__agency_id"),
                ("beginning_period_of_availability", "treasury_account_identifier__beginning_period_of_availability"),
                ("ending_period_of_availability", "treasury_account_identifier__ending_period_of_availability"),
                ("availability_type_code", "treasury_account_identifier__availability_type_code"),
                ("main_account_code", "treasury_account_identifier__main_account_code"),
                ("sub_account_code", "treasury_account_identifier__sub_account_code"),
                ("treasury_account_symbol", "treasury_account_symbol"),  # Column is appended to in account_download.py
                ("treasury_account_name", "treasury_account_identifier__account_title"),
                ("agency_identifier_name", "agency_identifier_name"),  # Column is appended to in account_download.py
                (
                    "allocation_transfer_agency_identifer_name",
                    "allocation_transfer_agency_identifer_name",
                ),  # Column is appended to in account_download.py
                ("budget_function", "treasury_account_identifier__budget_function_title"),
                ("budget_subfunction", "treasury_account_identifier__budget_subfunction_title"),
                ("federal_account_symbol", "federal_account_symbol"),  # Column is appended to in account_download.py
                ("federal_account_name", "treasury_account_identifier__federal_account__account_title"),
                (
                    "budget_authority_unobligated_balance_brought_forward",
                    "budget_authority_unobligated_balance_brought_forward_fyb",
                ),
                (
                    "adjustments_to_unobligated_balance_brought_forward",
                    "adjustments_to_unobligated_balance_brought_forward_cpe",
                ),
                ("budget_authority_appropriated_amount", "budget_authority_appropriated_amount_cpe"),
                ("borrowing_authority_amount", "borrowing_authority_amount_total_cpe"),
                ("contract_authority_amount", "contract_authority_amount_total_cpe"),
                (
                    "spending_authority_from_offsetting_collections_amount",
                    "spending_authority_from_offsetting_collections_amount_cpe",
                ),
                ("total_other_budgetary_resources_amount", "other_budgetary_resources_amount_cpe"),
                ("total_budgetary_resources", "total_budgetary_resources_amount_cpe"),
                ("obligations_incurred", "obligations_incurred_total_by_tas_cpe"),
                (
                    "deobligations_or_recoveries_or_refunds_from_prior_year",
                    "deobligations_recoveries_refunds_by_tas_cpe",
                ),
                ("unobligated_balance", "unobligated_balance_cpe"),
                ("gross_outlay_amount", "gross_outlay_amount_by_tas_cpe"),
                ("status_of_budgetary_resources_total", "status_of_budgetary_resources_total_cpe"),
                ("last_modified_date", "submission__certified_date"),
            ]
        ),
        "federal_account": OrderedDict(
            [
                ("owning_agency_name", "treasury_account_identifier__federal_account__parent_toptier_agency__name"),
                ("reporting_agency_name", "reporting_agency_name"),  # Column is appended to in account_download.py
                (
                    "last_reported_submission_period",
                    "last_reported_submission_period",
                ),  # Column is appended to in account_download.py
                ("federal_account_symbol", "federal_account_symbol"),  # Column is appended to in account_download.py
                ("federal_account_name", "treasury_account_identifier__federal_account__account_title"),
                ("agency_identifier_name", "agency_identifier_name"),  # Column is appended to in account_download.py
                ("budget_function", "budget_function"),  # Column is appended to in account_download.py
                ("budget_subfunction", "budget_subfunction"),  # Column is appended to in account_download.py
                (
                    "budget_authority_unobligated_balance_brought_forward",
                    "budget_authority_unobligated_balance_brought_forward",
                ),
                (
                    "adjustments_to_unobligated_balance_brought_forward",
                    "adjustments_to_unobligated_balance_brought_forward",
                ),
                ("budget_authority_appropriated_amount", "budget_authority_appropriated_amount"),
                ("borrowing_authority_amount", "borrowing_authority_amount"),
                ("contract_authority_amount", "contract_authority_amount"),
                (
                    "spending_authority_from_offsetting_collections_amount",
                    "spending_authority_from_offsetting_collections_amount",
                ),
                ("total_other_budgetary_resources_amount", "total_other_budgetary_resources_amount"),
                ("total_budgetary_resources", "total_budgetary_resources"),
                ("obligations_incurred", "obligations_incurred"),
                (
                    "deobligations_or_recoveries_or_refunds_from_prior_year",
                    "deobligations_or_recoveries_or_refunds_from_prior_year",
                ),
                ("unobligated_balance", "unobligated_balance"),
                ("gross_outlay_amount", "gross_outlay_amount"),
                ("status_of_budgetary_resources_total", "status_of_budgetary_resources_total"),
                (
                    "last_modified_date" + NAMING_CONFLICT_DISCRIMINATOR,
                    "last_modified_date" + NAMING_CONFLICT_DISCRIMINATOR,
                ),  # Column is annotated in account_download.py
            ]
        ),
    },
    "object_class_program_activity": {
        "treasury_account": OrderedDict(
            [
                ("owning_agency_name", "treasury_account__funding_toptier_agency__name"),
                ("reporting_agency_name", "submission__reporting_agency_name"),
                (
                    "last_reported_submission_period",
                    "last_reported_submission_period",
                ),  # Column is appended to in account_download.py
                ("allocation_transfer_agency_identifer_code", "treasury_account__allocation_transfer_agency_id"),
                ("agency_identifier_code", "treasury_account__agency_id"),
                ("beginning_period_of_availability", "treasury_account__beginning_period_of_availability"),
                ("ending_period_of_availability", "treasury_account__ending_period_of_availability"),
                ("availability_type_code", "treasury_account__availability_type_code"),
                ("main_account_code", "treasury_account__main_account_code"),
                ("sub_account_code", "treasury_account__sub_account_code"),
                ("treasury_account_symbol", "treasury_account_symbol"),  # Column is appended to in account_download.py
                ("treasury_account_name", "treasury_account__account_title"),
                ("agency_identifier_name", "agency_identifier_name"),  # Column is appended to in account_download.py
                (
                    "allocation_transfer_agency_identifer_name",
                    "allocation_transfer_agency_identifer_name",
                ),  # Column is appended to in account_download.py
                ("budget_function", "treasury_account__budget_function_title"),
                ("budget_subfunction", "treasury_account__budget_subfunction_title"),
                ("federal_account_symbol", "federal_account_symbol"),  # Column is appended to in account_download.py
                ("federal_account_name", "treasury_account__federal_account__account_title"),
                ("program_activity_code", "program_activity__program_activity_code"),
                ("program_activity_name", "program_activity__program_activity_name"),
                ("object_class_code", "object_class__object_class"),
                ("object_class_name", "object_class__object_class_name"),
                ("direct_or_reimbursable_funding_source", "object_class__direct_reimbursable"),
                ("obligations_incurred", "obligations_incurred_by_program_object_class_cpe"),
                (
                    "deobligations_or_recoveries_or_refunds_from_prior_year",
                    "deobligations_recoveries_refund_pri_program_object_class_cpe",
                ),
                ("gross_outlay_amount", "gross_outlay_amount_by_program_object_class_cpe"),
                ("last_modified_date", "submission__certified_date"),
            ]
        ),
        "federal_account": OrderedDict(
            [
                ("owning_agency_name", "treasury_account__federal_account__parent_toptier_agency__name"),
                ("reporting_agency_name", "reporting_agency_name"),  # Column is appended to in account_download.py
                (
                    "last_reported_submission_period",
                    "last_reported_submission_period",
                ),  # Column is appended to in account_download.py
                ("federal_account_symbol", "federal_account_symbol"),  # Column is appended to in account_download.py
                ("federal_account_name", "treasury_account__federal_account__account_title"),
                ("agency_identifier_name", "agency_identifier_name"),  # Column is appended to in account_download.py
                ("budget_function", "budget_function"),  # Column is appended to in account_download.py
                ("budget_subfunction", "budget_subfunction"),  # Column is appended to in account_download.py
                ("program_activity_code", "program_activity__program_activity_code"),
                ("program_activity_name", "program_activity__program_activity_name"),
                ("object_class_code", "object_class__object_class"),
                ("object_class_name", "object_class__object_class_name"),
                ("direct_or_reimbursable_funding_source", "object_class__direct_reimbursable"),
                ("obligations_incurred", "obligations_incurred"),
                (
                    "deobligations_or_recoveries_or_refunds_from_prior_year",
                    "deobligations_or_recoveries_or_refunds_from_prior_year",
                ),
                ("gross_outlay_amount", "gross_outlay_amount"),
                (
                    "last_modified_date" + NAMING_CONFLICT_DISCRIMINATOR,
                    "last_modified_date" + NAMING_CONFLICT_DISCRIMINATOR,
                ),  # Column is annotated in account_download.py
            ]
        ),
    },
    # Financial Accounts by Awards
    "award_financial": {
        "treasury_account": OrderedDict(
            [
                ("owning_agency_name", "treasury_account__funding_toptier_agency__name"),
                ("reporting_agency_name", "submission__reporting_agency_name"),
                ("submission_period", "submission_period"),  # Column is appended to in account_download.py
                ("allocation_transfer_agency_identifer_code", "treasury_account__allocation_transfer_agency_id"),
                ("agency_identifier_code", "treasury_account__agency_id"),
                ("beginning_period_of_availability", "treasury_account__beginning_period_of_availability"),
                ("ending_period_of_availability", "treasury_account__ending_period_of_availability"),
                ("availability_type_code", "treasury_account__availability_type_code"),
                ("main_account_code", "treasury_account__main_account_code"),
                ("sub_account_code", "treasury_account__sub_account_code"),
                ("treasury_account_symbol", "treasury_account_symbol"),  # Column is appended to in account_download.py
                ("treasury_account_name", "treasury_account__account_title"),
                ("agency_identifier_name", "agency_identifier_name"),  # Column is appended to in account_download.py
                (
                    "allocation_transfer_agency_identifer_name",
                    "allocation_transfer_agency_identifer_name",
                ),  # Column is appended to in account_download.py
                ("budget_function", "treasury_account__budget_function_title"),
                ("budget_subfunction", "treasury_account__budget_subfunction_title"),
                ("federal_account_symbol", "federal_account_symbol"),  # Column is appended to in account_download.py
                ("federal_account_name", "treasury_account__federal_account__account_title"),
                ("program_activity_code", "program_activity__program_activity_code"),
                ("program_activity_name", "program_activity__program_activity_name"),
                ("object_class_code", "object_class__object_class"),
                ("object_class_name", "object_class__object_class_name"),
                ("direct_or_reimbursable_funding_source", "object_class__direct_reimbursable"),
                ("award_id_piid", "piid"),
                ("parent_award_id_piid", "parent_award_id"),
                ("award_id_fain", "fain"),
                ("award_id_uri", "uri"),
                ("award_base_action_date", "award__date_signed"),
                (
                    "award_base_action_date_fiscal_year",
                    "award_base_action_date_fiscal_year",
                ),  # Column is annotated in account_download.py
                ("period_of_performance_start_date", "award__period_of_performance_start_date"),
                ("period_of_performance_current_end_date", "award__period_of_performance_current_end_date"),
                ("ordering_period_end_date", "award__latest_transaction__contract_data__ordering_period_end_date"),
                ("transaction_obligated_amount", "transaction_obligated_amount"),
                ("award_unique_key", "award__generated_unique_award_id"),
                ("award_type_code", "award_type_code"),  # Column is appended to in account_download.py
                ("award_type", "award_type"),  # Column is appended to in account_download.py
                ("idv_type_code", "award__latest_transaction__contract_data__idv_type"),
                ("idv_type", "award__latest_transaction__contract_data__idv_type_description"),
                ("award_description", "award__description"),
                ("awarding_agency_code", "awarding_agency_code"),  # Column is annotated in account_download.py
                ("awarding_agency_name", "awarding_agency_name"),  # Column is annotated in account_download.py
                ("awarding_subagency_code", "awarding_subagency_code"),  # Column is annotated in account_download.py
                ("awarding_subagency_name", "awarding_subagency_name"),  # Column is annotated in account_download.py
                ("awarding_office_code", "awarding_office_code"),  # Column is annotated in account_download.py
                ("awarding_office_name", "awarding_office_name"),  # Column is annotated in account_download.py
                ("funding_agency_code", "funding_agency_code"),  # Column is annotated in account_download.py
                ("funding_agency_name", "funding_agency_name"),  # Column is annotated in account_download.py
                ("funding_sub_agency_code", "funding_sub_agency_code"),  # Column is annotated in account_download.py
                ("funding_sub_agency_name", "funding_sub_agency_name"),  # Column is annotated in account_download.py
                ("funding_office_code", "funding_office_code"),  # Column is annotated in account_download.py
                ("funding_office_name", "funding_office_name"),  # Column is annotated in account_download.py
                ("recipient_duns", "recipient_duns"),  # Column is annotated in account_download.py
                ("recipient_name", "recipient_name"),  # Column is annotated in account_download.py
                ("recipient_parent_duns", "recipient_parent_duns"),  # Column is annotated in account_download.py
                ("recipient_parent_name", "recipient_parent_name"),  # Column is annotated in account_download.py
                ("recipient_country", "recipient_country"),  # Column is annotated in account_download.py
                ("recipient_state", "recipient_state"),  # Column is annotated in account_download.py
                ("recipient_county", "recipient_county"),  # Column is annotated in account_download.py
                ("recipient_city", "recipient_city"),  # Column is annotated in account_download.py
                ("recipient_congressional_district", "recipient_congressional_district"),
                # Column is annotated in account_download.py
                ("recipient_zip_code", "recipient_zip_code"),  # Column is annotated in account_download.py
                (
                    "primary_place_of_performance_country",
                    "primary_place_of_performance_country",
                ),  # Column is annotated in account_download.py
                (
                    "primary_place_of_performance_state",
                    "primary_place_of_performance_state",
                ),  # Column is annotated in account_download.py
                (
                    "primary_place_of_performance_county",
                    "primary_place_of_performance_county",
                ),  # Column is annotated in account_download.py
                (
                    "primary_place_of_performance_congressional_district",
                    "primary_place_of_performance_congressional_district",
                ),  # Column is annotated in account_download.py
                (
                    "primary_place_of_performance_zip_code",
                    "primary_place_of_performance_zip_code",
                ),  # Column is annotated in account_download.py
                ("cfda_number", "award__latest_transaction__assistance_data__cfda_number"),
                ("cfda_title", "award__latest_transaction__assistance_data__cfda_title"),
                ("product_or_service_code", "award__latest_transaction__contract_data__product_or_service_code"),
                (
                    "product_or_service_code_description",
                    "award__latest_transaction__contract_data__product_or_service_co_desc",
                ),
                ("naics_code", "award__latest_transaction__contract_data__naics"),
                ("naics_description", "award__latest_transaction__contract_data__naics_description"),
                ("national_interest_action_code", "award__latest_transaction__contract_data__national_interest_action"),
                ("national_interest_action", "award__latest_transaction__contract_data__national_interest_desc"),
                ("usaspending_permalink", "usaspending_permalink"),  # to be filled in by annotation
                ("last_modified_date", "submission__certified_date"),
            ]
        ),
        "federal_account": OrderedDict(
            [
                ("owning_agency_name", "treasury_account__federal_account__parent_toptier_agency__name"),
                ("reporting_agency_name", "reporting_agency_name"),  # Column is appended to in account_download.py
                ("submission_period", "submission_period"),  # Column is appended to in account_download.py
                ("federal_account_symbol", "federal_account_symbol"),  # Column is appended to in account_download.py
                ("federal_account_name", "treasury_account__federal_account__account_title"),
                ("agency_identifier_name", "agency_identifier_name"),  # Column is appended to in account_download.py
                ("budget_function", "budget_function"),  # Column is appended to in account_download.py
                ("budget_subfunction", "budget_subfunction"),  # Column is appended to in account_download.py
                ("program_activity_code", "program_activity__program_activity_code"),
                ("program_activity_name", "program_activity__program_activity_name"),
                ("object_class_code", "object_class__object_class"),
                ("object_class_name", "object_class__object_class_name"),
                ("direct_or_reimbursable_funding_source", "object_class__direct_reimbursable"),
                ("award_id_piid", "piid"),
                ("parent_award_id_piid", "parent_award_id"),
                ("award_id_fain", "fain"),
                ("award_id_uri", "uri"),
                ("award_base_action_date", "award__date_signed"),
                (
                    "award_base_action_date_fiscal_year",
                    "award_base_action_date_fiscal_year",
                ),  # Column is appended to in account_download.py
                ("period_of_performance_start_date", "award__period_of_performance_start_date"),
                ("period_of_performance_current_end_date", "award__period_of_performance_current_end_date"),
                ("ordering_period_end_date", "award__latest_transaction__contract_data__ordering_period_end_date"),
                ("transaction_obligated_amount", "transaction_obligated_amount"),
                ("award_unique_key", "award__generated_unique_award_id"),
                ("award_type_code", "award_type_code"),  # Column is appended to in account_download.py
                ("award_type", "award_type"),  # Column is appended to in account_download.py
                ("idv_type_code", "award__latest_transaction__contract_data__idv_type"),
                ("idv_type", "award__latest_transaction__contract_data__idv_type_description"),
                ("award_description", "award__description"),
                ("awarding_agency_code", "awarding_agency_code"),  # Column is annotated in account_download.py
                ("awarding_agency_name", "awarding_agency_name"),  # Column is annotated in account_download.py
                ("awarding_subagency_code", "awarding_subagency_code"),  # Column is annotated in account_download.py
                ("awarding_subagency_name", "awarding_subagency_name"),  # Column is annotated in account_download.py
                ("awarding_office_code", "awarding_office_code"),  # Column is annotated in account_download.py
                ("awarding_office_name", "awarding_office_name"),  # Column is annotated in account_download.py
                ("funding_agency_code", "funding_agency_code"),  # Column is annotated in account_download.py
                ("funding_agency_name", "funding_agency_name"),  # Column is annotated in account_download.py
                ("funding_sub_agency_code", "funding_sub_agency_code"),  # Column is annotated in account_download.py
                ("funding_sub_agency_name", "funding_sub_agency_name"),  # Column is annotated in account_download.py
                ("funding_office_code", "funding_office_code"),  # Column is annotated in account_download.py
                ("funding_office_name", "funding_office_name"),  # Column is annotated in account_download.py
                ("recipient_duns", "recipient_duns"),  # Column is annotated in account_download.py
                ("recipient_name", "recipient_name"),  # Column is annotated in account_download.py
                ("recipient_parent_duns", "recipient_parent_duns"),  # Column is annotated in account_download.py
                ("recipient_parent_name", "recipient_parent_name"),  # Column is annotated in account_download.py
                ("recipient_country", "recipient_country"),  # Column is annotated in account_download.py
                ("recipient_state", "recipient_state"),  # Column is annotated in account_download.py
                ("recipient_county", "recipient_county"),  # Column is annotated in account_download.py
                ("recipient_city", "recipient_city"),  # Column is annotated in account_download.py
                ("recipient_congressional_district", "recipient_congressional_district"),
                # Column is annotated in account_download.py
                ("recipient_zip_code", "recipient_zip_code"),  # Column is annotated in account_download.py
                (
                    "primary_place_of_performance_country",
                    "primary_place_of_performance_country",
                ),  # Column is annotated in account_download.py
                (
                    "primary_place_of_performance_state",
                    "primary_place_of_performance_state",
                ),  # Column is annotated in account_download.py
                (
                    "primary_place_of_performance_county",
                    "primary_place_of_performance_county",
                ),  # Column is annotated in account_download.py
                (
                    "primary_place_of_performance_congressional_district",
                    "primary_place_of_performance_congressional_district",
                ),  # Column is annotated in account_download.py
                (
                    "primary_place_of_performance_zip_code",
                    "primary_place_of_performance_zip_code",
                ),  # Column is annotated in account_download.py
                ("cfda_number", "award__latest_transaction__assistance_data__cfda_number"),
                ("cfda_title", "award__latest_transaction__assistance_data__cfda_title"),
                ("product_or_service_code", "award__latest_transaction__contract_data__product_or_service_code"),
                (
                    "product_or_service_code_description",
                    "award__latest_transaction__contract_data__product_or_service_co_desc",
                ),
                ("naics_code", "award__latest_transaction__contract_data__naics"),
                ("naics_description", "award__latest_transaction__contract_data__naics_description"),
                ("national_interest_action_code", "award__latest_transaction__contract_data__national_interest_action"),
                ("national_interest_action", "award__latest_transaction__contract_data__national_interest_desc"),
                ("usaspending_permalink", "usaspending_permalink"),  # to be filled in by annotation
                (
                    "last_modified_date" + NAMING_CONFLICT_DISCRIMINATOR,
                    "last_modified_date" + NAMING_CONFLICT_DISCRIMINATOR,
                ),  # Column is annotated in account_download.py
            ]
        ),
    },
}

# IDV Orders are nearly identical to awards but start from the Awards table
# instead of from UniversalAwardView materialized view so we need to lop off
# the leading "award__" bit.
query_paths["idv_orders"] = {
    "d1": OrderedDict(
        [(k, v[7:] if v is not None and v.startswith("award__") else v) for k, v in query_paths["award"]["d1"].items()]
    )
}

# Likewise, IDV Transactions start directly in TransactionFPDS instead of
# UniversalTransactionView.
query_paths["idv_transaction_history"] = {
    "d1": OrderedDict(
        [
            (k, v[13:] if v is not None and v.startswith("transaction__") else v)
            for k, v in query_paths["transaction"]["d1"].items()
        ]
    )
}

query_paths["assistance_transaction_history"] = {
    "d2": OrderedDict(
        [
            (k, v[13:] if v is not None and v.startswith("transaction__") else v)
            for k, v in query_paths["transaction"]["d2"].items()
        ]
    )
}
