usaspending_api/download/v2/download_column_historical_lookups.py
"""
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
"""
import copy
from collections import OrderedDict
from usaspending_api.awards.models.transaction_fabs import FABS_TO_TRANSACTION_SEARCH_COL_MAP
from usaspending_api.awards.models.transaction_fpds import FPDS_TO_TRANSACTION_SEARCH_COL_MAP
from usaspending_api.awards.models.transaction_normalized import NORM_TO_TRANSACTION_SEARCH_COL_MAP
from usaspending_api.download.filestreaming import NAMING_CONFLICT_DISCRIMINATOR
query_paths = {
"award": {
"d1": OrderedDict(
[
("contract_award_unique_key", "generated_unique_award_id"),
("award_id_piid", "piid"),
(
"parent_award_agency_id",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['referenced_idv_agency_iden']}",
),
(
"parent_award_agency_name",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['referenced_idv_agency_desc']}",
),
("parent_award_id_piid", "parent_award_piid"),
(
"disaster_emergency_fund_codes" + NAMING_CONFLICT_DISCRIMINATOR,
None,
), # Annotation is used to create this column
("outlayed_amount_from_COVID-19_supplementals", None), # Annotation is used to create this column
("obligated_amount_from_COVID-19_supplementals", None), # Annotation is used to create this column
("outlayed_amount_from_IIJA_supplemental", None), # Annotation is used to create this column
("obligated_amount_from_IIJA_supplemental", None), # Annotation is used to create this column
("total_obligated_amount", "total_obligation"),
("total_outlayed_amount", "total_outlays"),
(
"current_total_value_of_award",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['current_total_value_award']}",
),
(
"potential_total_value_of_award",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['potential_total_value_awar']}",
),
("award_base_action_date", "date_signed"),
("award_base_action_date_fiscal_year", None), # Annotation is used to create this column
(
"award_latest_action_date",
f"latest_transaction_search__{NORM_TO_TRANSACTION_SEARCH_COL_MAP['action_date']}",
),
("award_latest_action_date_fiscal_year", None), # Annotation is used to create this column
("period_of_performance_start_date", "period_of_performance_start_date"),
(
"period_of_performance_current_end_date",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['period_of_performance_curr']}",
),
(
"period_of_performance_potential_end_date",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['period_of_perf_potential_e']}",
),
(
"ordering_period_end_date",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['ordering_period_end_date']}",
),
(
"solicitation_date",
f"earliest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['solicitation_date']}",
),
(
"awarding_agency_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['awarding_agency_code']}",
),
(
"awarding_agency_name",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['awarding_agency_name']}",
),
(
"awarding_sub_agency_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['awarding_sub_tier_agency_c']}",
),
(
"awarding_sub_agency_name",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['awarding_sub_tier_agency_n']}",
),
(
"awarding_office_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['awarding_office_code']}",
),
(
"awarding_office_name",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['awarding_office_name']}",
),
(
"funding_agency_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['funding_agency_code']}",
),
(
"funding_agency_name",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['funding_agency_name']}",
),
(
"funding_sub_agency_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['funding_sub_tier_agency_co']}",
),
(
"funding_sub_agency_name",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['funding_sub_tier_agency_na']}",
),
(
"funding_office_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['funding_office_code']}",
),
(
"funding_office_name",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['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
("object_classes_funding_this_award", None), # Annotation is used to create this column
("program_activities_funding_this_award", None), # Annotation is used to create this column
(
"foreign_funding",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['foreign_funding']}",
),
(
"foreign_funding_description",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['foreign_funding_desc']}",
),
("sam_exception", f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['sam_exception']}"),
(
"sam_exception_description",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['sam_exception_description']}",
),
(
"recipient_uei",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['awardee_or_recipient_uei']}",
),
(
"recipient_duns",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['awardee_or_recipient_uniqu']}",
),
(
"recipient_name",
"latest_transaction_search__recipient_name",
),
(
"recipient_name_raw",
"latest_transaction_search__recipient_name_raw",
),
(
"recipient_doing_business_as_name",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['vendor_doing_as_business_n']}",
),
("cage_code", f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['cage_code']}"),
(
"recipient_parent_uei",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['ultimate_parent_uei']}",
),
(
"recipient_parent_duns",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['ultimate_parent_unique_ide']}",
),
(
"recipient_parent_name",
"latest_transaction_search__parent_recipient_name",
),
(
"recipient_parent_name_raw",
"latest_transaction_search__parent_recipient_name_raw",
),
(
"recipient_country_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_country_code']}",
),
(
"recipient_country_name",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_country_name']}",
),
(
"recipient_address_line_1",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_address_line1']}",
),
(
"recipient_address_line_2",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_address_line2']}",
),
(
"recipient_city_name",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_city_name']}",
),
(
"prime_award_summary_recipient_county_fips_code",
"latest_transaction_search__recipient_location_county_fips",
),
(
"recipient_county_name",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_county_name']}",
),
(
"prime_award_summary_recipient_state_fips_code",
"latest_transaction_search__recipient_location_state_fips",
),
(
"recipient_state_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_state_code']}",
),
(
"recipient_state_name",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_state_descrip']}",
),
(
"recipient_zip_4_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_zip4']}",
),
("prime_award_summary_recipient_cd_original", None), # Annotation is used to create this column
("prime_award_summary_recipient_cd_current", None), # Annotation is used to create this column
(
"recipient_phone_number",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['vendor_phone_number']}",
),
(
"recipient_fax_number",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['vendor_fax_number']}",
),
(
"primary_place_of_performance_country_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['place_of_perform_country_c']}",
),
(
"primary_place_of_performance_country_name",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['place_of_perf_country_desc']}",
),
(
"primary_place_of_performance_city_name",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['place_of_perform_city_name']}",
),
(
"prime_award_summary_place_of_performance_county_fips_code",
"latest_transaction_search__pop_county_fips",
),
(
"primary_place_of_performance_county_name",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['place_of_perform_county_na']}",
),
(
"prime_award_summary_place_of_performance_state_fips_code",
"latest_transaction_search__pop_state_fips",
),
(
"primary_place_of_performance_state_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['place_of_performance_state']}",
),
(
"primary_place_of_performance_state_name",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['place_of_perfor_state_desc']}",
),
(
"primary_place_of_performance_zip_4",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['place_of_performance_zip4a']}",
),
(
"prime_award_summary_place_of_performance_cd_original",
None,
), # Annotation is used to create this column
(
"prime_award_summary_place_of_performance_cd_current",
None,
), # Annotation is used to create this column
(
"award_or_idv_flag",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['pulled_from']}",
),
(
"award_type_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['contract_award_type']}",
), # Column is appended to in account_download.py
(
"award_type",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['contract_award_type_desc']}",
), # Column is appended to in account_download.py
("idv_type_code", f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['idv_type']}"),
(
"idv_type",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['idv_type_description']}",
),
(
"multiple_or_single_award_idv_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['multiple_or_single_award_i']}",
),
(
"multiple_or_single_award_idv",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['multiple_or_single_aw_desc']}",
),
("type_of_idc_code", f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['type_of_idc']}"),
(
"type_of_idc",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['type_of_idc_description']}",
),
(
"type_of_contract_pricing_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['type_of_contract_pricing']}",
),
(
"type_of_contract_pricing",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['type_of_contract_pric_desc']}",
),
("prime_award_base_transaction_description", "description"),
(
"solicitation_identifier",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['solicitation_identifier']}",
),
(
"number_of_actions",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['number_of_actions']}",
),
(
"inherently_governmental_functions",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['inherently_government_func']}",
),
(
"inherently_governmental_functions_description",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['inherently_government_desc']}",
),
(
"product_or_service_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['product_or_service_code']}",
),
(
"product_or_service_code_description",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['product_or_service_co_desc']}",
),
(
"contract_bundling_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['contract_bundling']}",
),
(
"contract_bundling",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['contract_bundling_descrip']}",
),
(
"dod_claimant_program_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['dod_claimant_program_code']}",
),
(
"dod_claimant_program_description",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['dod_claimant_prog_cod_desc']}",
),
("naics_code", f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['naics']}"),
(
"naics_description",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['naics_description']}",
),
(
"recovered_materials_sustainability_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['recovered_materials_sustai']}",
),
(
"recovered_materials_sustainability",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['recovered_materials_s_desc']}",
),
(
"domestic_or_foreign_entity_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['domestic_or_foreign_entity']}",
),
(
"domestic_or_foreign_entity",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['domestic_or_foreign_e_desc']}",
),
(
"dod_acquisition_program_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['program_system_or_equipmen']}",
),
(
"dod_acquisition_program_description",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['program_system_or_equ_desc']}",
),
(
"information_technology_commercial_item_category_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['information_technology_com']}",
),
(
"information_technology_commercial_item_category",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['information_technolog_desc']}",
),
(
"epa_designated_product_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['epa_designated_product']}",
),
(
"epa_designated_product",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['epa_designated_produc_desc']}",
),
(
"country_of_product_or_service_origin_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['country_of_product_or_serv']}",
),
(
"country_of_product_or_service_origin",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['country_of_product_or_desc']}",
),
(
"place_of_manufacture_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['place_of_manufacture']}",
),
(
"place_of_manufacture",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['place_of_manufacture_desc']}",
),
(
"subcontracting_plan_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['subcontracting_plan']}",
),
(
"subcontracting_plan",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['subcontracting_plan_desc']}",
),
(
"extent_competed_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['extent_competed']}",
),
(
"extent_competed",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['extent_compete_description']}",
),
(
"solicitation_procedures_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['solicitation_procedures']}",
),
(
"solicitation_procedures",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['solicitation_procedur_desc']}",
),
(
"type_of_set_aside_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['type_set_aside']}",
),
(
"type_of_set_aside",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['type_set_aside_description']}",
),
(
"evaluated_preference_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['evaluated_preference']}",
),
(
"evaluated_preference",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['evaluated_preference_desc']}",
),
("research_code", f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['research']}"),
(
"research",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['research_description']}",
),
(
"fair_opportunity_limited_sources_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['fair_opportunity_limited_s']}",
),
(
"fair_opportunity_limited_sources",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['fair_opportunity_limi_desc']}",
),
(
"other_than_full_and_open_competition_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['other_than_full_and_open_c']}",
),
(
"other_than_full_and_open_competition",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['other_than_full_and_o_desc']}",
),
(
"number_of_offers_received",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['number_of_offers_received']}",
),
(
"commercial_item_acquisition_procedures_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['commercial_item_acquisitio']}",
),
(
"commercial_item_acquisition_procedures",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['commercial_item_acqui_desc']}",
),
(
"small_business_competitiveness_demonstration_program",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['small_business_competitive']}",
),
(
"simplified_procedures_for_certain_commercial_items_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['commercial_item_test_progr']}",
),
(
"simplified_procedures_for_certain_commercial_items",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['commercial_item_test_desc']}",
),
(
"a76_fair_act_action_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['a_76_fair_act_action']}",
),
(
"a76_fair_act_action",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['a_76_fair_act_action_desc']}",
),
(
"fed_biz_opps_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['fed_biz_opps']}",
),
(
"fed_biz_opps",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['fed_biz_opps_description']}",
),
(
"local_area_set_aside_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['local_area_set_aside']}",
),
(
"local_area_set_aside",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['local_area_set_aside_desc']}",
),
(
"price_evaluation_adjustment_preference_percent_difference",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['price_evaluation_adjustmen']}",
),
(
"clinger_cohen_act_planning_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['clinger_cohen_act_planning']}",
),
(
"clinger_cohen_act_planning",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['clinger_cohen_act_pla_desc']}",
),
(
"materials_supplies_articles_equipment_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['materials_supplies_article']}",
),
(
"materials_supplies_articles_equipment",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['materials_supplies_descrip']}",
),
(
"labor_standards_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['labor_standards']}",
),
(
"labor_standards",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['labor_standards_descrip']}",
),
(
"construction_wage_rate_requirements_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['construction_wage_rate_req']}",
),
(
"construction_wage_rate_requirements",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['construction_wage_rat_desc']}",
),
(
"interagency_contracting_authority_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['interagency_contracting_au']}",
),
(
"interagency_contracting_authority",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['interagency_contract_desc']}",
),
(
"other_statutory_authority",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['other_statutory_authority']}",
),
(
"program_acronym",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['program_acronym']}",
),
(
"parent_award_type_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['referenced_idv_type']}",
),
(
"parent_award_type",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['referenced_idv_type_desc']}",
),
(
"parent_award_single_or_multiple_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['referenced_mult_or_single']}",
),
(
"parent_award_single_or_multiple",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['referenced_mult_or_si_desc']}",
),
("major_program", f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['major_program']}"),
(
"national_interest_action_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['national_interest_action']}",
),
(
"national_interest_action",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['national_interest_desc']}",
),
(
"cost_or_pricing_data_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['cost_or_pricing_data']}",
),
(
"cost_or_pricing_data",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['cost_or_pricing_data_desc']}",
),
(
"cost_accounting_standards_clause_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['cost_accounting_standards']}",
),
(
"cost_accounting_standards_clause",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['cost_accounting_stand_desc']}",
),
(
"government_furnished_property_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['government_furnished_prope']}",
),
(
"government_furnished_property",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['government_furnished_prope']}",
),
(
"sea_transportation_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['sea_transportation']}",
),
(
"sea_transportation",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['sea_transportation_desc']}",
),
(
"consolidated_contract_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['consolidated_contract']}",
),
(
"consolidated_contract",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['consolidated_contract_desc']}",
),
(
"performance_based_service_acquisition_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['performance_based_service']}",
),
(
"performance_based_service_acquisition",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['performance_based_se_desc']}",
),
(
"multi_year_contract_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['multi_year_contract']}",
),
(
"multi_year_contract",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['multi_year_contract_desc']}",
),
(
"contract_financing_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['contract_financing']}",
),
(
"contract_financing",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['contract_financing_descrip']}",
),
(
"purchase_card_as_payment_method_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['purchase_card_as_payment_m']}",
),
(
"purchase_card_as_payment_method",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['purchase_card_as_paym_desc']}",
),
(
"contingency_humanitarian_or_peacekeeping_operation_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['contingency_humanitarian_o']}",
),
(
"contingency_humanitarian_or_peacekeeping_operation",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['contingency_humanitar_desc']}",
),
(
"alaskan_native_corporation_owned_firm",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['alaskan_native_owned_corpo']}",
),
(
"american_indian_owned_business",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['american_indian_owned_busi']}",
),
(
"indian_tribe_federally_recognized",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['indian_tribe_federally_rec']}",
),
(
"native_hawaiian_organization_owned_firm",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['native_hawaiian_owned_busi']}",
),
(
"tribally_owned_firm",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['tribally_owned_business']}",
),
(
"veteran_owned_business",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['veteran_owned_business']}",
),
(
"service_disabled_veteran_owned_business",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['service_disabled_veteran_o']}",
),
(
"woman_owned_business",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['woman_owned_business']}",
),
(
"women_owned_small_business",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['women_owned_small_business']}",
),
(
"economically_disadvantaged_women_owned_small_business",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['economically_disadvantaged']}",
),
(
"joint_venture_women_owned_small_business",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['joint_venture_women_owned']}",
),
(
"joint_venture_economic_disadvantaged_women_owned_small_bus",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['joint_venture_economically']}",
),
(
"minority_owned_business",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['minority_owned_business']}",
),
(
"subcontinent_asian_asian_indian_american_owned_business",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['subcontinent_asian_asian_i']}",
),
(
"asian_pacific_american_owned_business",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['asian_pacific_american_own']}",
),
(
"black_american_owned_business",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['black_american_owned_busin']}",
),
(
"hispanic_american_owned_business",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['hispanic_american_owned_bu']}",
),
(
"native_american_owned_business",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['native_american_owned_busi']}",
),
(
"other_minority_owned_business",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['other_minority_owned_busin']}",
),
(
"contracting_officers_determination_of_business_size",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['contracting_officers_desc']}",
),
(
"contracting_officers_determination_of_business_size_code",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['contracting_officers_deter']}",
),
(
"emerging_small_business",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['emerging_small_business']}",
),
(
"community_developed_corporation_owned_firm",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['community_developed_corpor']}",
),
(
"labor_surplus_area_firm",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['labor_surplus_area_firm']}",
),
(
"us_federal_government",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['us_federal_government']}",
),
(
"federally_funded_research_and_development_corp",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['federally_funded_research']}",
),
(
"federal_agency",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['federal_agency']}",
),
(
"us_state_government",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['us_state_government']}",
),
(
"us_local_government",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['us_local_government']}",
),
(
"city_local_government",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['city_local_government']}",
),
(
"county_local_government",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['county_local_government']}",
),
(
"inter_municipal_local_government",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['inter_municipal_local_gove']}",
),
(
"local_government_owned",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['local_government_owned']}",
),
(
"municipality_local_government",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['municipality_local_governm']}",
),
(
"school_district_local_government",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['school_district_local_gove']}",
),
(
"township_local_government",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['township_local_government']}",
),
(
"us_tribal_government",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['us_tribal_government']}",
),
(
"foreign_government",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['foreign_government']}",
),
(
"organizational_type",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['organizational_type']}",
),
(
"corporate_entity_not_tax_exempt",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['corporate_entity_not_tax_e']}",
),
(
"corporate_entity_tax_exempt",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['corporate_entity_tax_exemp']}",
),
(
"partnership_or_limited_liability_partnership",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['partnership_or_limited_lia']}",
),
(
"sole_proprietorship",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['sole_proprietorship']}",
),
(
"small_agricultural_cooperative",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['small_agricultural_coopera']}",
),
(
"international_organization",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['international_organization']}",
),
(
"us_government_entity",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['us_government_entity']}",
),
(
"community_development_corporation",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['community_development_corp']}",
),
(
"domestic_shelter",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['domestic_shelter']}",
),
(
"educational_institution",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['educational_institution']}",
),
("foundation", f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['foundation']}"),
("hospital_flag", f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['hospital_flag']}"),
(
"manufacturer_of_goods",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['manufacturer_of_goods']}",
),
(
"veterinary_hospital",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['veterinary_hospital']}",
),
(
"hispanic_servicing_institution",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['hispanic_servicing_institu']}",
),
("receives_contracts", f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['contracts']}"),
(
"receives_financial_assistance",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['grants']}",
),
(
"receives_contracts_and_financial_assistance",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['receives_contracts_and_gra']}",
),
(
"airport_authority",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['airport_authority']}",
),
(
"council_of_governments",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['council_of_governments']}",
),
(
"housing_authorities_public_tribal",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['housing_authorities_public']}",
),
(
"interstate_entity",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['interstate_entity']}",
),
(
"planning_commission",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['planning_commission']}",
),
(
"port_authority",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['port_authority']}",
),
(
"transit_authority",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['transit_authority']}",
),
(
"subchapter_scorporation",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['subchapter_s_corporation']}",
),
(
"limited_liability_corporation",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['limited_liability_corporat']}",
),
(
"foreign_owned",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['foreign_owned_and_located']}",
),
(
"for_profit_organization",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['for_profit_organization']}",
),
(
"nonprofit_organization",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['nonprofit_organization']}",
),
(
"other_not_for_profit_organization",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['other_not_for_profit_organ']}",
),
(
"the_ability_one_program",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['the_ability_one_program']}",
),
(
"private_university_or_college",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['private_university_or_coll']}",
),
(
"state_controlled_institution_of_higher_learning",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['state_controlled_instituti']}",
),
(
"1862_land_grant_college",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['c1862_land_grant_college']}",
),
(
"1890_land_grant_college",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['c1890_land_grant_college']}",
),
(
"1994_land_grant_college",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['c1994_land_grant_college']}",
),
(
"minority_institution",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['minority_institution']}",
),
(
"historically_black_college",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['historically_black_college']}",
),
(
"tribal_college",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['tribal_college']}",
),
(
"alaskan_native_servicing_institution",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['alaskan_native_servicing_i']}",
),
(
"native_hawaiian_servicing_institution",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['native_hawaiian_servicing']}",
),
(
"school_of_forestry",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['school_of_forestry']}",
),
(
"veterinary_college",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['veterinary_college']}",
),
(
"dot_certified_disadvantage",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['dot_certified_disadvantage']}",
),
(
"self_certified_small_disadvantaged_business",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['self_certified_small_disad']}",
),
(
"small_disadvantaged_business",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['small_disadvantaged_busine']}",
),
(
"c8a_program_participant",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['c8a_program_participant']}",
),
(
"historically_underutilized_business_zone_hubzone_firm",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['historically_underutilized']}",
),
(
"sba_certified_8a_joint_venture",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['sba_certified_8_a_joint_ve']}",
),
("highly_compensated_officer_1_name", "officer_1_name"),
("highly_compensated_officer_1_amount", "officer_1_amount"),
("highly_compensated_officer_2_name", "officer_2_name"),
("highly_compensated_officer_2_amount", "officer_2_amount"),
("highly_compensated_officer_3_name", "officer_3_name"),
("highly_compensated_officer_3_amount", "officer_3_amount"),
("highly_compensated_officer_4_name", "officer_4_name"),
("highly_compensated_officer_4_amount", "officer_4_amount"),
("highly_compensated_officer_5_name", "officer_5_name"),
("highly_compensated_officer_5_amount", "officer_5_amount"),
("usaspending_permalink", None), # to be filled in by annotation
(
"last_modified_date",
f"latest_transaction_search__{FPDS_TO_TRANSACTION_SEARCH_COL_MAP['last_modified']}",
),
]
),
"d2": OrderedDict(
[
("assistance_award_unique_key", "generated_unique_award_id"),
("award_id_fain", "fain"),
("award_id_uri", "uri"),
("sai_number", f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['sai_number']}"),
(
"disaster_emergency_fund_codes" + NAMING_CONFLICT_DISCRIMINATOR,
None,
), # Annotation is used to create this column
("outlayed_amount_from_COVID-19_supplementals", None), # Annotation is used to create this column
("obligated_amount_from_COVID-19_supplementals", None), # Annotation is used to create this column
("outlayed_amount_from_IIJA_supplemental", None), # Annotation is used to create this column
("obligated_amount_from_IIJA_supplemental", None), # Annotation is used to create this column
(
"award_latest_action_date",
f"latest_transaction_search__{NORM_TO_TRANSACTION_SEARCH_COL_MAP['action_date']}",
), # Annotation is used to create this column
("award_latest_action_date_fiscal_year", None), # Annotation is used to create this column
("total_obligated_amount", "total_obligation"),
("total_outlayed_amount", "total_outlays"),
("indirect_cost_federal_share_amount", "total_indirect_federal_sharing"),
("total_non_federal_funding_amount", "non_federal_funding_amount"),
("total_funding_amount", "total_funding_amount"),
("total_face_value_of_loan", "total_loan_value"),
("total_loan_subsidy_cost", "total_subsidy_cost"),
("award_base_action_date", "date_signed"),
("award_base_action_date_fiscal_year", None), # Annotation is used to create this column
("period_of_performance_start_date", "period_of_performance_start_date"),
("period_of_performance_current_end_date", "period_of_performance_current_end_date"),
(
"awarding_agency_code",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['awarding_agency_code']}",
),
(
"awarding_agency_name",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['awarding_agency_name']}",
),
(
"awarding_sub_agency_code",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['awarding_sub_tier_agency_c']}",
),
(
"awarding_sub_agency_name",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['awarding_sub_tier_agency_n']}",
),
(
"awarding_office_code",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['awarding_office_code']}",
),
(
"awarding_office_name",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['awarding_office_name']}",
),
(
"funding_agency_code",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['funding_agency_code']}",
),
(
"funding_agency_name",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['funding_agency_name']}",
),
(
"funding_sub_agency_code",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['funding_sub_tier_agency_co']}",
),
(
"funding_sub_agency_name",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['funding_sub_tier_agency_na']}",
),
(
"funding_office_code",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['funding_office_code']}",
),
(
"funding_office_name",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['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
("object_classes_funding_this_award", None), # Annotation is used to create this column
("program_activities_funding_this_award", None), # Annotation is used to create this column
("recipient_uei", f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['uei']}"),
(
"recipient_duns",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['awardee_or_recipient_uniqu']}",
),
(
"recipient_name",
"latest_transaction_search__recipient_name",
),
(
"recipient_name_raw",
"latest_transaction_search__recipient_name_raw",
),
(
"recipient_parent_uei",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['ultimate_parent_uei']}",
),
(
"recipient_parent_duns",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['ultimate_parent_unique_ide']}",
),
(
"recipient_parent_name",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['ultimate_parent_legal_enti']}",
),
(
"recipient_country_code",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_country_code']}",
),
(
"recipient_country_name",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_country_name']}",
),
(
"recipient_address_line_1",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_address_line1']}",
),
(
"recipient_address_line_2",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_address_line2']}",
),
(
"recipient_city_code",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_city_code']}",
),
(
"recipient_city_name",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_city_name']}",
),
(
"prime_award_summary_recipient_county_fips_code",
"latest_transaction_search__recipient_location_county_fips",
),
(
"recipient_county_name",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_county_name']}",
),
(
"prime_award_summary_recipient_state_fips_code",
"latest_transaction_search__recipient_location_state_fips",
),
(
"recipient_state_code",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_state_code']}",
),
(
"recipient_state_name",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_state_name']}",
),
(
"recipient_zip_code",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_zip5']}",
),
(
"recipient_zip_last_4_code",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_zip_last4']}",
),
("prime_award_summary_recipient_cd_original", None), # Annotation is used to create this column
("prime_award_summary_recipient_cd_current", None), # Annotation is used to create this column
(
"recipient_foreign_city_name",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_foreign_city']}",
),
(
"recipient_foreign_province_name",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_foreign_provi']}",
),
(
"recipient_foreign_postal_code",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['legal_entity_foreign_posta']}",
),
(
"primary_place_of_performance_scope",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['place_of_performance_scope']}",
),
(
"primary_place_of_performance_country_code",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['place_of_perform_country_c']}",
),
(
"primary_place_of_performance_country_name",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['place_of_perform_country_n']}",
),
(
"primary_place_of_performance_code",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['place_of_performance_code']}",
),
(
"primary_place_of_performance_city_name",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['place_of_performance_city']}",
),
(
"prime_award_summary_place_of_performance_county_fips_code",
"latest_transaction_search__pop_county_fips",
),
(
"primary_place_of_performance_county_name",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['place_of_perform_county_na']}",
),
(
"prime_award_summary_place_of_performance_state_fips_code",
"latest_transaction_search__pop_state_fips",
),
(
"primary_place_of_performance_state_name",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['place_of_perform_state_nam']}",
),
(
"primary_place_of_performance_zip_4",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['place_of_performance_zip4a']}",
),
(
"prime_award_summary_place_of_performance_cd_original",
None,
), # Annotation is used to create this column
(
"prime_award_summary_place_of_performance_cd_current",
None,
), # Annotation is used to create this column
(
"primary_place_of_performance_foreign_location",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['place_of_performance_forei']}",
),
("cfda_numbers_and_titles", None), # Annotation is used to create this column
(
"funding_opportunity_number",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['funding_opportunity_number']}",
),
(
"funding_opportunity_goals_text",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['funding_opportunity_goals']}",
),
(
"assistance_type_code",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['assistance_type']}",
),
(
"assistance_type_description",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['assistance_type_desc']}",
),
("prime_award_base_transaction_description", "description"),
(
"business_funds_indicator_code",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['business_funds_indicator']}",
),
(
"business_funds_indicator_description",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['business_funds_ind_desc']}",
),
(
"business_types_code",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['business_types']}",
),
(
"business_types_description",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['business_types_desc']}",
),
("record_type_code", f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['record_type']}"),
(
"record_type_description",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['record_type_description']}",
),
("highly_compensated_officer_1_name", "officer_1_name"),
("highly_compensated_officer_1_amount", "officer_1_amount"),
("highly_compensated_officer_2_name", "officer_2_name"),
("highly_compensated_officer_2_amount", "officer_2_amount"),
("highly_compensated_officer_3_name", "officer_3_name"),
("highly_compensated_officer_3_amount", "officer_3_amount"),
("highly_compensated_officer_4_name", "officer_4_name"),
("highly_compensated_officer_4_amount", "officer_4_amount"),
("highly_compensated_officer_5_name", "officer_5_name"),
("highly_compensated_officer_5_amount", "officer_5_amount"),
("usaspending_permalink", None), # to be filled in by annotation
(
"last_modified_date",
f"latest_transaction_search__{FABS_TO_TRANSACTION_SEARCH_COL_MAP['modified_at']}",
),
]
),
},
"transaction_search": {
"d1": OrderedDict(
[
("contract_transaction_unique_key", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["detached_award_proc_unique"]),
("contract_award_unique_key", "generated_unique_award_id"),
("award_id_piid", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["piid"]),
("modification_number", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["award_modification_amendme"]),
("transaction_number", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["transaction_number"]),
("parent_award_agency_id", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["referenced_idv_agency_iden"]),
("parent_award_agency_name", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["referenced_idv_agency_desc"]),
("parent_award_id_piid", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["parent_award_id"]),
("parent_award_modification_number", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["referenced_idv_modificatio"]),
("federal_action_obligation", NORM_TO_TRANSACTION_SEARCH_COL_MAP["federal_action_obligation"]),
("total_dollars_obligated", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["total_obligated_amount"]),
("total_outlayed_amount_for_overall_award", None), # Annotation is used to create this column
("base_and_exercised_options_value", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["base_exercised_options_val"]),
("current_total_value_of_award", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["current_total_value_award"]),
("base_and_all_options_value", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["base_and_all_options_value"]),
("potential_total_value_of_award", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["potential_total_value_awar"]),
("disaster_emergency_fund_codes_for_overall_award", None), # Annotation is used to create this column
(
"outlayed_amount_from_COVID-19_supplementals_for_overall_award",
None,
), # Annotation is used to create this column
(
"obligated_amount_from_COVID-19_supplementals_for_overall_award",
None,
), # Annotation is used to create this column
(
"outlayed_amount_from_IIJA_supplemental_for_overall_award",
None,
), # Annotation is used to create this column
(
"obligated_amount_from_IIJA_supplemental_for_overall_award",
None,
), # Annotation is used to create this column
("action_date", NORM_TO_TRANSACTION_SEARCH_COL_MAP["action_date"]),
("action_date_fiscal_year", None), # Annotation is used to create this column
("period_of_performance_start_date", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["period_of_performance_star"]),
(
"period_of_performance_current_end_date",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["period_of_performance_curr"],
),
(
"period_of_performance_potential_end_date",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["period_of_perf_potential_e"],
),
("ordering_period_end_date", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["ordering_period_end_date"]),
("solicitation_date", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["solicitation_date"]),
("awarding_agency_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["awarding_agency_code"]),
("awarding_agency_name", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["awarding_agency_name"]),
("awarding_sub_agency_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["awarding_sub_tier_agency_c"]),
("awarding_sub_agency_name", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["awarding_sub_tier_agency_n"]),
("awarding_office_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["awarding_office_code"]),
("awarding_office_name", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["awarding_office_name"]),
("funding_agency_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["funding_agency_code"]),
("funding_agency_name", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["funding_agency_name"]),
("funding_sub_agency_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["funding_sub_tier_agency_co"]),
("funding_sub_agency_name", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["funding_sub_tier_agency_na"]),
("funding_office_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["funding_office_code"]),
("funding_office_name", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["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
("object_classes_funding_this_award", None), # Annotation is used to create this column
("program_activities_funding_this_award", None), # Annotation is used to create this column
("foreign_funding", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["foreign_funding"]),
("foreign_funding_description", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["foreign_funding_desc"]),
("sam_exception", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["sam_exception"]),
("sam_exception_description", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["sam_exception_description"]),
("recipient_uei", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["awardee_or_recipient_uei"]),
("recipient_duns", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["awardee_or_recipient_uniqu"]),
("recipient_name", "recipient_name"),
("recipient_name_raw", "recipient_name_raw"),
("recipient_doing_business_as_name", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["vendor_doing_as_business_n"]),
("cage_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["cage_code"]),
("recipient_parent_uei", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["ultimate_parent_uei"]),
("recipient_parent_duns", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["ultimate_parent_unique_ide"]),
("recipient_parent_name", "parent_recipient_name"),
("recipient_parent_name_raw", "parent_recipient_name_raw"),
("recipient_country_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_country_code"]),
("recipient_country_name", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_country_name"]),
("recipient_address_line_1", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_address_line1"]),
("recipient_address_line_2", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_address_line2"]),
("recipient_city_name", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_city_name"]),
(
"prime_award_transaction_recipient_county_fips_code",
"recipient_location_county_fips",
),
("recipient_county_name", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_county_name"]),
(
"prime_award_transaction_recipient_state_fips_code",
"recipient_location_state_fips",
),
("recipient_state_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_state_code"]),
("recipient_state_name", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_state_descrip"]),
("recipient_zip_4_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_zip4"]),
("prime_award_transaction_recipient_cd_original", None), # Annotation is used to create this column
("prime_award_transaction_recipient_cd_current", None), # Annotation is used to create this column
("recipient_phone_number", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["vendor_phone_number"]),
("recipient_fax_number", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["vendor_fax_number"]),
(
"primary_place_of_performance_country_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["place_of_perform_country_c"],
),
(
"primary_place_of_performance_country_name",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["place_of_perf_country_desc"],
),
(
"primary_place_of_performance_city_name",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["place_of_perform_city_name"],
),
(
"prime_award_transaction_place_of_performance_county_fips_code",
"pop_county_fips",
),
(
"primary_place_of_performance_county_name",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["place_of_perform_county_na"],
),
(
"prime_award_transaction_place_of_performance_state_fips_code",
"pop_state_fips",
),
(
"primary_place_of_performance_state_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["place_of_performance_state"],
),
(
"primary_place_of_performance_state_name",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["place_of_perfor_state_desc"],
),
(
"primary_place_of_performance_zip_4",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["place_of_performance_zip4a"],
),
(
"prime_award_transaction_place_of_performance_cd_original",
None,
), # Annotation is used to create this column
(
"prime_award_transaction_place_of_performance_cd_current",
None,
), # Annotation is used to create this column
("award_or_idv_flag", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["pulled_from"]),
(
"award_type_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["contract_award_type"],
), # Column is appended to in account_download.py
(
"award_type",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["contract_award_type_desc"],
), # Column is appended to in account_download.py
("idv_type_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["idv_type"]),
("idv_type", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["idv_type_description"]),
("multiple_or_single_award_idv_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["multiple_or_single_award_i"]),
("multiple_or_single_award_idv", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["multiple_or_single_aw_desc"]),
("type_of_idc_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["type_of_idc"]),
("type_of_idc", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["type_of_idc_description"]),
("type_of_contract_pricing_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["type_of_contract_pricing"]),
("type_of_contract_pricing", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["type_of_contract_pric_desc"]),
("transaction_description", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["award_description"]),
("prime_award_base_transaction_description", "award__description"),
("action_type_code", NORM_TO_TRANSACTION_SEARCH_COL_MAP["action_type"]),
("action_type", NORM_TO_TRANSACTION_SEARCH_COL_MAP["action_type_description"]),
("solicitation_identifier", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["solicitation_identifier"]),
("number_of_actions", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["number_of_actions"]),
("inherently_governmental_functions", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["inherently_government_func"]),
(
"inherently_governmental_functions_description",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["inherently_government_desc"],
),
("product_or_service_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["product_or_service_code"]),
(
"product_or_service_code_description",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["product_or_service_co_desc"],
),
("contract_bundling_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["contract_bundling"]),
("contract_bundling", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["contract_bundling_descrip"]),
("dod_claimant_program_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["dod_claimant_program_code"]),
("dod_claimant_program_description", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["dod_claimant_prog_cod_desc"]),
("naics_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["naics"]),
("naics_description", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["naics_description"]),
(
"recovered_materials_sustainability_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["recovered_materials_sustai"],
),
(
"recovered_materials_sustainability",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["recovered_materials_s_desc"],
),
("domestic_or_foreign_entity_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["domestic_or_foreign_entity"]),
("domestic_or_foreign_entity", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["domestic_or_foreign_e_desc"]),
("dod_acquisition_program_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["program_system_or_equipmen"]),
(
"dod_acquisition_program_description",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["program_system_or_equ_desc"],
),
(
"information_technology_commercial_item_category_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["information_technology_com"],
),
(
"information_technology_commercial_item_category",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["information_technolog_desc"],
),
("epa_designated_product_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["epa_designated_product"]),
("epa_designated_product", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["epa_designated_produc_desc"]),
(
"country_of_product_or_service_origin_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["country_of_product_or_serv"],
),
(
"country_of_product_or_service_origin",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["country_of_product_or_desc"],
),
("place_of_manufacture_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["place_of_manufacture"]),
("place_of_manufacture", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["place_of_manufacture_desc"]),
("subcontracting_plan_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["subcontracting_plan"]),
("subcontracting_plan", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["subcontracting_plan_desc"]),
("extent_competed_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["extent_competed"]),
("extent_competed", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["extent_compete_description"]),
("solicitation_procedures_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["solicitation_procedures"]),
("solicitation_procedures", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["solicitation_procedur_desc"]),
("type_of_set_aside_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["type_set_aside"]),
("type_of_set_aside", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["type_set_aside_description"]),
("evaluated_preference_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["evaluated_preference"]),
("evaluated_preference", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["evaluated_preference_desc"]),
("research_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["research"]),
("research", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["research_description"]),
(
"fair_opportunity_limited_sources_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["fair_opportunity_limited_s"],
),
("fair_opportunity_limited_sources", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["fair_opportunity_limi_desc"]),
(
"other_than_full_and_open_competition_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["other_than_full_and_open_c"],
),
(
"other_than_full_and_open_competition",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["other_than_full_and_o_desc"],
),
("number_of_offers_received", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["number_of_offers_received"]),
(
"commercial_item_acquisition_procedures_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["commercial_item_acquisitio"],
),
(
"commercial_item_acquisition_procedures",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["commercial_item_acqui_desc"],
),
(
"small_business_competitiveness_demonstration_program",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["small_business_competitive"],
),
(
"simplified_procedures_for_certain_commercial_items_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["commercial_item_test_progr"],
),
(
"simplified_procedures_for_certain_commercial_items",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["commercial_item_test_desc"],
),
("a76_fair_act_action_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["a_76_fair_act_action"]),
("a76_fair_act_action", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["a_76_fair_act_action_desc"]),
("fed_biz_opps_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["fed_biz_opps"]),
("fed_biz_opps", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["fed_biz_opps_description"]),
("local_area_set_aside_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["local_area_set_aside"]),
("local_area_set_aside", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["local_area_set_aside_desc"]),
(
"price_evaluation_adjustment_preference_percent_difference",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["price_evaluation_adjustmen"],
),
("clinger_cohen_act_planning_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["clinger_cohen_act_planning"]),
("clinger_cohen_act_planning", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["clinger_cohen_act_pla_desc"]),
(
"materials_supplies_articles_equipment_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["materials_supplies_article"],
),
(
"materials_supplies_articles_equipment",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["materials_supplies_descrip"],
),
("labor_standards_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["labor_standards"]),
("labor_standards", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["labor_standards_descrip"]),
(
"construction_wage_rate_requirements_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["construction_wage_rate_req"],
),
(
"construction_wage_rate_requirements",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["construction_wage_rat_desc"],
),
(
"interagency_contracting_authority_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["interagency_contracting_au"],
),
("interagency_contracting_authority", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["interagency_contract_desc"]),
("other_statutory_authority", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["other_statutory_authority"]),
("program_acronym", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["program_acronym"]),
(
"parent_award_type_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["referenced_idv_type"],
), # Column is appended to in account_download.py
(
"parent_award_type",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["referenced_idv_type_desc"],
), # Column is appended to in account_download.py
(
"parent_award_single_or_multiple_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["referenced_mult_or_single"],
),
("parent_award_single_or_multiple", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["referenced_mult_or_si_desc"]),
("major_program", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["major_program"]),
("national_interest_action_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["national_interest_action"]),
("national_interest_action", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["national_interest_desc"]),
("cost_or_pricing_data_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["cost_or_pricing_data"]),
("cost_or_pricing_data", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["cost_or_pricing_data_desc"]),
(
"cost_accounting_standards_clause_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["cost_accounting_standards"],
),
("cost_accounting_standards_clause", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["cost_accounting_stand_desc"]),
(
"government_furnished_property_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["government_furnished_prope"],
),
("government_furnished_property", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["government_furnished_desc"]),
("sea_transportation_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["sea_transportation"]),
("sea_transportation", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["sea_transportation_desc"]),
("undefinitized_action_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["undefinitized_action"]),
("undefinitized_action", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["undefinitized_action_desc"]),
("consolidated_contract_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["consolidated_contract"]),
("consolidated_contract", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["consolidated_contract_desc"]),
(
"performance_based_service_acquisition_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["performance_based_service"],
),
(
"performance_based_service_acquisition",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["performance_based_se_desc"],
),
("multi_year_contract_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["multi_year_contract"]),
("multi_year_contract", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["multi_year_contract_desc"]),
("contract_financing_code", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["contract_financing"]),
("contract_financing", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["contract_financing_descrip"]),
(
"purchase_card_as_payment_method_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["purchase_card_as_payment_m"],
),
("purchase_card_as_payment_method", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["purchase_card_as_paym_desc"]),
(
"contingency_humanitarian_or_peacekeeping_operation_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["contingency_humanitarian_o"],
),
(
"contingency_humanitarian_or_peacekeeping_operation",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["contingency_humanitar_desc"],
),
(
"alaskan_native_corporation_owned_firm",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["alaskan_native_owned_corpo"],
),
("american_indian_owned_business", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["american_indian_owned_busi"]),
("indian_tribe_federally_recognized", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["indian_tribe_federally_rec"]),
(
"native_hawaiian_organization_owned_firm",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["native_hawaiian_owned_busi"],
),
("tribally_owned_firm", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["tribally_owned_business"]),
("veteran_owned_business", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["veteran_owned_business"]),
(
"service_disabled_veteran_owned_business",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["service_disabled_veteran_o"],
),
("woman_owned_business", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["woman_owned_business"]),
("women_owned_small_business", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["women_owned_small_business"]),
(
"economically_disadvantaged_women_owned_small_business",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["economically_disadvantaged"],
),
(
"joint_venture_women_owned_small_business",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["joint_venture_women_owned"],
),
(
"joint_venture_economic_disadvantaged_women_owned_small_bus",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["joint_venture_economically"],
),
("minority_owned_business", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["minority_owned_business"]),
(
"subcontinent_asian_asian_indian_american_owned_business",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["subcontinent_asian_asian_i"],
),
(
"asian_pacific_american_owned_business",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["asian_pacific_american_own"],
),
("black_american_owned_business", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["black_american_owned_busin"]),
("hispanic_american_owned_business", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["hispanic_american_owned_bu"]),
("native_american_owned_business", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["native_american_owned_busi"]),
("other_minority_owned_business", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["other_minority_owned_busin"]),
(
"contracting_officers_determination_of_business_size",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["contracting_officers_desc"],
),
(
"contracting_officers_determination_of_business_size_code",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["contracting_officers_deter"],
),
("emerging_small_business", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["emerging_small_business"]),
(
"community_developed_corporation_owned_firm",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["community_developed_corpor"],
),
("labor_surplus_area_firm", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["labor_surplus_area_firm"]),
("us_federal_government", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["us_federal_government"]),
(
"federally_funded_research_and_development_corp",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["federally_funded_research"],
),
("federal_agency", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["federal_agency"]),
("us_state_government", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["us_state_government"]),
("us_local_government", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["us_local_government"]),
("city_local_government", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["city_local_government"]),
("county_local_government", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["county_local_government"]),
("inter_municipal_local_government", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["inter_municipal_local_gove"]),
("local_government_owned", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["local_government_owned"]),
("municipality_local_government", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["municipality_local_governm"]),
("school_district_local_government", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["school_district_local_gove"]),
("township_local_government", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["township_local_government"]),
("us_tribal_government", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["us_tribal_government"]),
("foreign_government", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["foreign_government"]),
("organizational_type", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["organizational_type"]),
("corporate_entity_not_tax_exempt", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["corporate_entity_not_tax_e"]),
("corporate_entity_tax_exempt", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["corporate_entity_tax_exemp"]),
(
"partnership_or_limited_liability_partnership",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["partnership_or_limited_lia"],
),
("sole_proprietorship", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["sole_proprietorship"]),
("small_agricultural_cooperative", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["small_agricultural_coopera"]),
("international_organization", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["international_organization"]),
("us_government_entity", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["us_government_entity"]),
("community_development_corporation", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["community_development_corp"]),
("domestic_shelter", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["domestic_shelter"]),
("educational_institution", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["educational_institution"]),
("foundation", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["foundation"]),
("hospital_flag", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["hospital_flag"]),
("manufacturer_of_goods", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["manufacturer_of_goods"]),
("veterinary_hospital", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["veterinary_hospital"]),
("hispanic_servicing_institution", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["hispanic_servicing_institu"]),
("receives_contracts", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["contracts"]),
("receives_financial_assistance", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["grants"]),
(
"receives_contracts_and_financial_assistance",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["receives_contracts_and_gra"],
),
("airport_authority", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["airport_authority"]),
("council_of_governments", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["council_of_governments"]),
("housing_authorities_public_tribal", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["housing_authorities_public"]),
("interstate_entity", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["interstate_entity"]),
("planning_commission", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["planning_commission"]),
("port_authority", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["port_authority"]),
("transit_authority", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["transit_authority"]),
("subchapter_scorporation", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["subchapter_s_corporation"]),
("limited_liability_corporation", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["limited_liability_corporat"]),
("foreign_owned", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["foreign_owned_and_located"]),
("for_profit_organization", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["for_profit_organization"]),
("nonprofit_organization", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["nonprofit_organization"]),
("other_not_for_profit_organization", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["other_not_for_profit_organ"]),
("the_ability_one_program", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["the_ability_one_program"]),
("private_university_or_college", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["private_university_or_coll"]),
(
"state_controlled_institution_of_higher_learning",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["state_controlled_instituti"],
),
("1862_land_grant_college", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["c1862_land_grant_college"]),
("1890_land_grant_college", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["c1890_land_grant_college"]),
("1994_land_grant_college", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["c1994_land_grant_college"]),
("minority_institution", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["minority_institution"]),
("historically_black_college", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["historically_black_college"]),
("tribal_college", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["tribal_college"]),
(
"alaskan_native_servicing_institution",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["alaskan_native_servicing_i"],
),
(
"native_hawaiian_servicing_institution",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["native_hawaiian_servicing"],
),
("school_of_forestry", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["school_of_forestry"]),
("veterinary_college", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["veterinary_college"]),
("dot_certified_disadvantage", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["dot_certified_disadvantage"]),
(
"self_certified_small_disadvantaged_business",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["self_certified_small_disad"],
),
("small_disadvantaged_business", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["small_disadvantaged_busine"]),
("c8a_program_participant", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["c8a_program_participant"]),
(
"historically_underutilized_business_zone_hubzone_firm",
FPDS_TO_TRANSACTION_SEARCH_COL_MAP["historically_underutilized"],
),
("sba_certified_8a_joint_venture", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["sba_certified_8_a_joint_ve"]),
("highly_compensated_officer_1_name", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["officer_1_name"]),
("highly_compensated_officer_1_amount", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["officer_1_amount"]),
("highly_compensated_officer_2_name", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["officer_2_name"]),
("highly_compensated_officer_2_amount", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["officer_2_amount"]),
("highly_compensated_officer_3_name", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["officer_3_name"]),
("highly_compensated_officer_3_amount", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["officer_3_amount"]),
("highly_compensated_officer_4_name", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["officer_4_name"]),
("highly_compensated_officer_4_amount", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["officer_4_amount"]),
("highly_compensated_officer_5_name", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["officer_5_name"]),
("highly_compensated_officer_5_amount", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["officer_5_amount"]),
("usaspending_permalink", None), # to be filled in by annotation
("initial_report_date", "initial_report_date"),
("last_modified_date", FPDS_TO_TRANSACTION_SEARCH_COL_MAP["last_modified"]),
]
),
"d2": OrderedDict(
[
("assistance_transaction_unique_key", FABS_TO_TRANSACTION_SEARCH_COL_MAP["afa_generated_unique"]),
("assistance_award_unique_key", "generated_unique_award_id"),
("award_id_fain", FABS_TO_TRANSACTION_SEARCH_COL_MAP["fain"]),
("modification_number", NORM_TO_TRANSACTION_SEARCH_COL_MAP["modification_number"]),
("award_id_uri", FABS_TO_TRANSACTION_SEARCH_COL_MAP["uri"]),
("sai_number", FABS_TO_TRANSACTION_SEARCH_COL_MAP["sai_number"]),
("federal_action_obligation", NORM_TO_TRANSACTION_SEARCH_COL_MAP["federal_action_obligation"]),
("total_obligated_amount", "award__total_obligation"),
("total_outlayed_amount_for_overall_award", None), # Annotation is used to create this column
("indirect_cost_federal_share_amount", FABS_TO_TRANSACTION_SEARCH_COL_MAP["indirect_federal_sharing"]),
("non_federal_funding_amount", FABS_TO_TRANSACTION_SEARCH_COL_MAP["non_federal_funding_amount"]),
("total_non_federal_funding_amount", "award__non_federal_funding_amount"),
("face_value_of_loan", FABS_TO_TRANSACTION_SEARCH_COL_MAP["face_value_loan_guarantee"]),
("original_loan_subsidy_cost", NORM_TO_TRANSACTION_SEARCH_COL_MAP["original_loan_subsidy_cost"]),
("total_face_value_of_loan", "award__total_loan_value"),
("total_loan_subsidy_cost", "award__total_subsidy_cost"),
("generated_pragmatic_obligations", "generated_pragmatic_obligation"),
("disaster_emergency_fund_codes_for_overall_award", None), # Annotation is used to create this column
(
"outlayed_amount_from_COVID-19_supplementals_for_overall_award",
None,
), # Annotation is used to create this column
(
"obligated_amount_from_COVID-19_supplementals_for_overall_award",
None,
), # Annotation is used to create this column
(
"outlayed_amount_from_IIJA_supplemental_for_overall_award",
None,
), # Annotation is used to create this column
(
"obligated_amount_from_IIJA_supplemental_for_overall_award",
None,
),
("action_date", NORM_TO_TRANSACTION_SEARCH_COL_MAP["action_date"]),
("action_date_fiscal_year", None), # Annotation is used to create this column
(
"period_of_performance_start_date",
NORM_TO_TRANSACTION_SEARCH_COL_MAP["period_of_performance_start_date"],
),
(
"period_of_performance_current_end_date",
NORM_TO_TRANSACTION_SEARCH_COL_MAP["period_of_performance_current_end_date"],
),
("awarding_agency_code", FABS_TO_TRANSACTION_SEARCH_COL_MAP["awarding_agency_code"]),
("awarding_agency_name", FABS_TO_TRANSACTION_SEARCH_COL_MAP["awarding_agency_name"]),
("awarding_sub_agency_code", FABS_TO_TRANSACTION_SEARCH_COL_MAP["awarding_sub_tier_agency_c"]),
("awarding_sub_agency_name", FABS_TO_TRANSACTION_SEARCH_COL_MAP["awarding_sub_tier_agency_n"]),
("awarding_office_code", FABS_TO_TRANSACTION_SEARCH_COL_MAP["awarding_office_code"]),
("awarding_office_name", FABS_TO_TRANSACTION_SEARCH_COL_MAP["awarding_office_name"]),
("funding_agency_code", FABS_TO_TRANSACTION_SEARCH_COL_MAP["funding_agency_code"]),
("funding_agency_name", FABS_TO_TRANSACTION_SEARCH_COL_MAP["funding_agency_name"]),
("funding_sub_agency_code", FABS_TO_TRANSACTION_SEARCH_COL_MAP["funding_sub_tier_agency_co"]),
("funding_sub_agency_name", FABS_TO_TRANSACTION_SEARCH_COL_MAP["funding_sub_tier_agency_na"]),
("funding_office_code", FABS_TO_TRANSACTION_SEARCH_COL_MAP["funding_office_code"]),
("funding_office_name", FABS_TO_TRANSACTION_SEARCH_COL_MAP["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
("object_classes_funding_this_award", None), # Annotation is used to create this column
("program_activities_funding_this_award", None), # Annotation is used to create this column
("recipient_uei", FABS_TO_TRANSACTION_SEARCH_COL_MAP["uei"]),
("recipient_duns", FABS_TO_TRANSACTION_SEARCH_COL_MAP["awardee_or_recipient_uniqu"]),
("recipient_name", "recipient_name"),
("recipient_name_raw", "recipient_name_raw"),
("recipient_parent_uei", FABS_TO_TRANSACTION_SEARCH_COL_MAP["ultimate_parent_uei"]),
("recipient_parent_duns", FABS_TO_TRANSACTION_SEARCH_COL_MAP["ultimate_parent_unique_ide"]),
("recipient_parent_name", "parent_recipient_name"),
("recipient_parent_name_raw", "parent_recipient_name_raw"),
("recipient_country_code", FABS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_country_code"]),
("recipient_country_name", FABS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_country_name"]),
("recipient_address_line_1", FABS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_address_line1"]),
("recipient_address_line_2", FABS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_address_line2"]),
("recipient_city_code", FABS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_city_code"]),
("recipient_city_name", FABS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_city_name"]),
("prime_award_transaction_recipient_county_fips_code", "recipient_location_county_fips"),
("recipient_county_name", FABS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_county_name"]),
(
"prime_award_transaction_recipient_state_fips_code",
"recipient_location_state_fips",
),
("recipient_state_code", FABS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_state_code"]),
("recipient_state_name", FABS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_state_name"]),
("recipient_zip_code", FABS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_zip5"]),
("recipient_zip_last_4_code", FABS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_zip_last4"]),
("prime_award_transaction_recipient_cd_original", None), # Annotation is used to create this column
("prime_award_transaction_recipient_cd_current", None), # Annotation is used to create this column
("recipient_foreign_city_name", FABS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_foreign_city"]),
("recipient_foreign_province_name", FABS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_foreign_provi"]),
("recipient_foreign_postal_code", FABS_TO_TRANSACTION_SEARCH_COL_MAP["legal_entity_foreign_posta"]),
(
"primary_place_of_performance_scope",
FABS_TO_TRANSACTION_SEARCH_COL_MAP["place_of_performance_scope"],
),
(
"primary_place_of_performance_country_code",
FABS_TO_TRANSACTION_SEARCH_COL_MAP["place_of_perform_country_c"],
),
(
"primary_place_of_performance_country_name",
FABS_TO_TRANSACTION_SEARCH_COL_MAP["place_of_perform_country_n"],
),
("primary_place_of_performance_code", FABS_TO_TRANSACTION_SEARCH_COL_MAP["place_of_performance_code"]),
(
"primary_place_of_performance_city_name",
FABS_TO_TRANSACTION_SEARCH_COL_MAP["place_of_performance_city"],
),
(
"prime_award_transaction_place_of_performance_county_fips_code",
"pop_county_fips",
),
(
"primary_place_of_performance_county_name",
FABS_TO_TRANSACTION_SEARCH_COL_MAP["place_of_perform_county_na"],
),
(
"prime_award_transaction_place_of_performance_state_fips_code",
"pop_state_fips",
),
(
"primary_place_of_performance_state_name",
FABS_TO_TRANSACTION_SEARCH_COL_MAP["place_of_perform_state_nam"],
),
(
"primary_place_of_performance_zip_4",
FABS_TO_TRANSACTION_SEARCH_COL_MAP["place_of_performance_zip4a"],
),
(
"prime_award_transaction_place_of_performance_cd_original",
None,
), # Annotation is used to create this column
(
"prime_award_transaction_place_of_performance_cd_current",
None,
), # Annotation is used to create this column
(
"primary_place_of_performance_foreign_location",
FABS_TO_TRANSACTION_SEARCH_COL_MAP["place_of_performance_forei"],
),
("cfda_number", FABS_TO_TRANSACTION_SEARCH_COL_MAP["cfda_number"]),
("cfda_title", FABS_TO_TRANSACTION_SEARCH_COL_MAP["cfda_title"]),
("funding_opportunity_number", FABS_TO_TRANSACTION_SEARCH_COL_MAP["funding_opportunity_number"]),
("funding_opportunity_goals_text", FABS_TO_TRANSACTION_SEARCH_COL_MAP["funding_opportunity_goals"]),
("assistance_type_code", FABS_TO_TRANSACTION_SEARCH_COL_MAP["assistance_type"]),
("assistance_type_description", FABS_TO_TRANSACTION_SEARCH_COL_MAP["assistance_type_desc"]),
("transaction_description", FABS_TO_TRANSACTION_SEARCH_COL_MAP["award_description"]),
("prime_award_base_transaction_description", "award__description"),
("business_funds_indicator_code", FABS_TO_TRANSACTION_SEARCH_COL_MAP["business_funds_indicator"]),
("business_funds_indicator_description", FABS_TO_TRANSACTION_SEARCH_COL_MAP["business_funds_ind_desc"]),
("business_types_code", FABS_TO_TRANSACTION_SEARCH_COL_MAP["business_types"]),
("business_types_description", FABS_TO_TRANSACTION_SEARCH_COL_MAP["business_types_desc"]),
("correction_delete_indicator_code", FABS_TO_TRANSACTION_SEARCH_COL_MAP["correction_delete_indicatr"]),
(
"correction_delete_indicator_description",
FABS_TO_TRANSACTION_SEARCH_COL_MAP["correction_delete_ind_desc"],
),
("action_type_code", NORM_TO_TRANSACTION_SEARCH_COL_MAP["action_type"]),
("action_type_description", FABS_TO_TRANSACTION_SEARCH_COL_MAP["action_type_description"]),
("record_type_code", FABS_TO_TRANSACTION_SEARCH_COL_MAP["record_type"]),
("record_type_description", FABS_TO_TRANSACTION_SEARCH_COL_MAP["record_type_description"]),
("highly_compensated_officer_1_name", FABS_TO_TRANSACTION_SEARCH_COL_MAP["officer_1_name"]),
("highly_compensated_officer_1_amount", FABS_TO_TRANSACTION_SEARCH_COL_MAP["officer_1_amount"]),
("highly_compensated_officer_2_name", FABS_TO_TRANSACTION_SEARCH_COL_MAP["officer_2_name"]),
("highly_compensated_officer_2_amount", FABS_TO_TRANSACTION_SEARCH_COL_MAP["officer_2_amount"]),
("highly_compensated_officer_3_name", FABS_TO_TRANSACTION_SEARCH_COL_MAP["officer_3_name"]),
("highly_compensated_officer_3_amount", FABS_TO_TRANSACTION_SEARCH_COL_MAP["officer_3_amount"]),
("highly_compensated_officer_4_name", FABS_TO_TRANSACTION_SEARCH_COL_MAP["officer_4_name"]),
("highly_compensated_officer_4_amount", FABS_TO_TRANSACTION_SEARCH_COL_MAP["officer_4_amount"]),
("highly_compensated_officer_5_name", FABS_TO_TRANSACTION_SEARCH_COL_MAP["officer_5_name"]),
("highly_compensated_officer_5_amount", FABS_TO_TRANSACTION_SEARCH_COL_MAP["officer_5_amount"]),
("usaspending_permalink", None), # to be filled in by annotation
("initial_report_date", "initial_report_date"),
("last_modified_date", FABS_TO_TRANSACTION_SEARCH_COL_MAP["modified_at"]),
]
),
},
"subaward_search": {
"d1": OrderedDict(
[
("prime_award_unique_key", "unique_award_key"),
("prime_award_piid", "piid"),
("prime_award_parent_piid", "parent_award_id"),
("prime_award_amount", "award_amount"),
("prime_award_disaster_emergency_fund_codes", None), # Annotation is used to create this column
(
"prime_award_outlayed_amount_from_COVID-19_supplementals",
None,
), # Annotation is used to create this column
(
"prime_award_obligated_amount_from_COVID-19_supplementals",
None,
), # Annotation is used to create this column
(
"prime_award_outlayed_amount_from_IIJA_supplemental",
None,
), # Annotation is used to create this column
(
"prime_award_obligated_amount_from_IIJA_supplemental",
None,
), # Annotation is used to create this column
(
"prime_award_total_outlayed_amount",
None,
), # Annotation is used to create this column
("prime_award_base_action_date", "action_date"),
("prime_award_base_action_date_fiscal_year", None), # Annotation is used to create this column
("prime_award_latest_action_date", "latest_transaction__action_date"),
("prime_award_latest_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_period_of_performance_potential_end_date",
None,
), # Annotation is used to create this column
("prime_award_awarding_agency_code", "awarding_agency_code"),
("prime_award_awarding_agency_name", "awarding_agency_name"),
("prime_award_awarding_sub_agency_code", "awarding_sub_tier_agency_c"),
("prime_award_awarding_sub_agency_name", "awarding_sub_tier_agency_n"),
("prime_award_awarding_office_code", "awarding_office_code"),
("prime_award_awarding_office_name", "awarding_office_name"),
("prime_award_funding_agency_code", "funding_agency_code"),
("prime_award_funding_agency_name", "funding_agency_name"),
("prime_award_funding_sub_agency_code", "funding_sub_tier_agency_co"),
("prime_award_funding_sub_agency_name", "funding_sub_tier_agency_na"),
("prime_award_funding_office_code", "funding_office_code"),
("prime_award_funding_office_name", "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_award_object_classes_funding_this_award", None), # Annotation is used to create this column
("prime_award_program_activities_funding_this_award", None), # Annotation is used to create this column
("prime_awardee_uei", "awardee_or_recipient_uei"),
("prime_awardee_duns", "awardee_or_recipient_uniqu"),
("prime_awardee_name", "awardee_or_recipient_legal"),
("prime_awardee_dba_name", "dba_name"),
("prime_awardee_parent_uei", "ultimate_parent_uei"),
("prime_awardee_parent_duns", "ultimate_parent_unique_ide"),
("prime_awardee_parent_name", "ultimate_parent_legal_enti"),
("prime_awardee_country_code", "legal_entity_country_code"),
("prime_awardee_country_name", "legal_entity_country_name"),
("prime_awardee_address_line_1", "legal_entity_address_line1"),
("prime_awardee_city_name", "legal_entity_city_name"),
("prime_awardee_county_fips_code", "legal_entity_county_fips"),
("prime_awardee_county_name", "latest_transaction__recipient_location_county_name"),
("prime_awardee_state_fips_code", "legal_entity_state_fips"),
("prime_awardee_state_code", "legal_entity_state_code"),
("prime_awardee_state_name", "legal_entity_state_name"),
("prime_awardee_zip_code", "legal_entity_zip"),
("prime_award_summary_recipient_cd_original", None), # Annotation is used to create this column
("prime_award_summary_recipient_cd_current", None), # Annotation is used to create this column
("prime_awardee_foreign_postal_code", "legal_entity_foreign_posta"),
("prime_awardee_business_types", "business_types"),
("prime_award_primary_place_of_performance_city_name", "place_of_perform_city_name"),
("prime_award_primary_place_of_performance_county_fips_code", "place_of_perform_county_fips"),
("prime_award_primary_place_of_performance_county_name", "pop_county_name"),
("prime_award_primary_place_of_performance_state_fips_code", "place_of_perform_state_fips"),
("prime_award_primary_place_of_performance_state_code", "place_of_perform_state_code"),
("prime_award_primary_place_of_performance_state_name", "place_of_perform_state_name"),
(
"prime_award_primary_place_of_performance_address_zip_code",
"place_of_performance_zip",
),
(
"prime_award_summary_place_of_performance_cd_original",
None,
), # Annotation is used to create this column
(
"prime_award_summary_place_of_performance_cd_current",
None,
), # Annotation is used to create this column
(
"prime_award_primary_place_of_performance_country_code",
"place_of_perform_country_co",
),
(
"prime_award_primary_place_of_performance_country_name",
"place_of_perform_country_na",
),
("prime_award_base_transaction_description", "award_description"),
("prime_award_project_title", "program_title"),
("prime_award_naics_code", "naics"),
("prime_award_naics_description", "naics_description"),
(
"prime_award_national_interest_action_code",
"latest_transaction__national_interest_action",
),
(
"prime_award_national_interest_action",
"latest_transaction__national_interest_desc",
),
("subaward_type", "subaward_type"),
("subaward_fsrs_report_id", "internal_id"),
("subaward_fsrs_report_year", "subaward_report_year"),
("subaward_fsrs_report_month", "subaward_report_month"),
("subaward_number", "subaward_number"),
("subaward_amount", "subaward_amount"),
("subaward_action_date", "sub_action_date"),
("subaward_action_date_fiscal_year", None), # Annotation is used to create this column
("subawardee_uei", "sub_awardee_or_recipient_uei"),
("subawardee_duns", "sub_awardee_or_recipient_uniqu"),
("subawardee_name", "sub_awardee_or_recipient_legal"),
("subawardee_dba_name", "sub_dba_name"),
("subawardee_parent_uei", "sub_ultimate_parent_uei"),
("subawardee_parent_duns", "sub_ultimate_parent_unique_ide"),
("subawardee_parent_name", "sub_ultimate_parent_legal_enti"),
("subawardee_country_code", "sub_legal_entity_country_code"),
("subawardee_country_name", "sub_legal_entity_country_name"),
("subawardee_address_line_1", "sub_legal_entity_address_line1"),
("subawardee_city_name", "sub_legal_entity_city_name"),
("subawardee_state_code", "sub_legal_entity_state_code"),
("subawardee_state_name", "sub_legal_entity_state_name"),
("subawardee_zip_code", "sub_legal_entity_zip"),
("subaward_recipient_cd_original", None), # Annotation is used to create this column
("subaward_recipient_cd_current", None), # Annotation is used to create this column
("subawardee_foreign_postal_code", "sub_legal_entity_foreign_posta"),
("subawardee_business_types", "sub_business_types"),
("subaward_primary_place_of_performance_city_name", "sub_place_of_perform_city_name"),
(
"subaward_primary_place_of_performance_state_code",
"sub_place_of_perform_state_code",
),
(
"subaward_primary_place_of_performance_state_name",
"sub_place_of_perform_state_name",
),
(
"subaward_primary_place_of_performance_address_zip_code",
"sub_place_of_performance_zip",
),
("subaward_place_of_performance_cd_original", None), # Annotation is used to create this column
("subaward_place_of_performance_cd_current", None), # Annotation is used to create this column
(
"subaward_primary_place_of_performance_country_code",
"sub_place_of_perform_country_co",
),
(
"subaward_primary_place_of_performance_country_name",
"sub_place_of_perform_country_na",
),
("subaward_description", "subaward_description"),
("subawardee_highly_compensated_officer_1_name", "sub_high_comp_officer1_full_na"),
("subawardee_highly_compensated_officer_1_amount", "sub_high_comp_officer1_amount"),
("subawardee_highly_compensated_officer_2_name", "sub_high_comp_officer2_full_na"),
("subawardee_highly_compensated_officer_2_amount", "sub_high_comp_officer2_amount"),
("subawardee_highly_compensated_officer_3_name", "sub_high_comp_officer3_full_na"),
("subawardee_highly_compensated_officer_3_amount", "sub_high_comp_officer3_amount"),
("subawardee_highly_compensated_officer_4_name", "sub_high_comp_officer4_full_na"),
("subawardee_highly_compensated_officer_4_amount", "sub_high_comp_officer4_amount"),
("subawardee_highly_compensated_officer_5_name", "sub_high_comp_officer5_full_na"),
("subawardee_highly_compensated_officer_5_amount", "sub_high_comp_officer5_amount"),
("usaspending_permalink", None), # to be filled in by annotation
("subaward_fsrs_report_last_modified_date", "date_submitted"),
]
),
"d2": OrderedDict(
[
("prime_award_unique_key", "unique_award_key"),
("prime_award_fain", "fain"),
("prime_award_amount", "award_amount"),
("prime_award_disaster_emergency_fund_codes", None), # Annotation is used to create this column
(
"prime_award_outlayed_amount_from_COVID-19_supplementals",
None,
), # Annotation is used to create this column
(
"prime_award_obligated_amount_from_COVID-19_supplementals",
None,
), # Annotation is used to create this column
(
"prime_award_outlayed_amount_from_IIJA_supplemental",
None,
), # Annotation is used to create this column
(
"prime_award_obligated_amount_from_IIJA_supplemental",
None,
), # Annotation is used to create this column
(
"prime_award_total_outlayed_amount",
None,
), # Annotation is used to create this column
("prime_award_base_action_date", "action_date"),
("prime_award_base_action_date_fiscal_year", None), # Annotation is used to create this column
("prime_award_latest_action_date", "latest_transaction__action_date"),
("prime_award_latest_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", "awarding_agency_code"),
("prime_award_awarding_agency_name", "awarding_agency_name"),
("prime_award_awarding_sub_agency_code", "awarding_sub_tier_agency_c"),
("prime_award_awarding_sub_agency_name", "awarding_sub_tier_agency_n"),
("prime_award_awarding_office_code", "awarding_office_code"),
("prime_award_awarding_office_name", "awarding_office_name"),
("prime_award_funding_agency_code", "funding_agency_code"),
("prime_award_funding_agency_name", "funding_agency_name"),
("prime_award_funding_sub_agency_code", "funding_sub_tier_agency_co"),
("prime_award_funding_sub_agency_name", "funding_sub_tier_agency_na"),
("prime_award_funding_office_code", "funding_office_code"),
("prime_award_funding_office_name", "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_award_object_classes_funding_this_award", None), # Annotation is used to create this column
("prime_award_program_activities_funding_this_award", None), # Annotation is used to create this column
("prime_awardee_uei", "awardee_or_recipient_uei"),
("prime_awardee_duns", "awardee_or_recipient_uniqu"),
("prime_awardee_name", "awardee_or_recipient_legal"),
("prime_awardee_dba_name", "dba_name"),
("prime_awardee_parent_uei", "ultimate_parent_uei"),
("prime_awardee_parent_duns", "ultimate_parent_unique_ide"),
("prime_awardee_parent_name", "ultimate_parent_legal_enti"),
("prime_awardee_country_code", "legal_entity_country_code"),
("prime_awardee_country_name", "legal_entity_country_name"),
("prime_awardee_address_line_1", "legal_entity_address_line1"),
("prime_awardee_city_name", "legal_entity_city_name"),
("prime_awardee_county_fips_code", "legal_entity_county_fips"),
("prime_awardee_county_name", "latest_transaction__recipient_location_county_name"),
("prime_awardee_state_fips_code", "legal_entity_state_fips"),
("prime_awardee_state_code", "legal_entity_state_code"),
("prime_awardee_state_name", "legal_entity_state_name"),
("prime_awardee_zip_code", "legal_entity_zip"),
("prime_award_summary_recipient_cd_original", None), # Annotation is used to create this column
("prime_award_summary_recipient_cd_current", None), # Annotation is used to create this column
("prime_awardee_foreign_postal_code", "legal_entity_foreign_posta"),
("prime_awardee_business_types", "business_types"),
("prime_award_primary_place_of_performance_scope", "place_of_perform_scope"),
("prime_award_primary_place_of_performance_city_name", "place_of_perform_city_name"),
("prime_award_primary_place_of_performance_county_fips_code", "place_of_perform_county_fips"),
("prime_award_primary_place_of_performance_county_name", "pop_county_name"),
("prime_award_primary_place_of_performance_state_fips_code", "place_of_perform_state_fips"),
("prime_award_primary_place_of_performance_state_code", "place_of_perform_state_code"),
("prime_award_primary_place_of_performance_state_name", "place_of_perform_state_name"),
(
"prime_award_primary_place_of_performance_address_zip_code",
"place_of_performance_zip",
),
(
"prime_award_summary_place_of_performance_cd_original",
None,
), # Annotation is used to create this column
(
"prime_award_summary_place_of_performance_cd_current",
None,
), # Annotation is used to create this column
(
"prime_award_primary_place_of_performance_country_code",
"place_of_perform_country_co",
),
(
"prime_award_primary_place_of_performance_country_name",
"place_of_perform_country_na",
),
("prime_award_base_transaction_description", "award_description"),
("prime_award_cfda_numbers_and_titles", None), # Annotation is used to create this column
("subaward_type", "subaward_type"),
("subaward_fsrs_report_id", "internal_id"),
("subaward_fsrs_report_year", "subaward_report_year"),
("subaward_fsrs_report_month", "subaward_report_month"),
("subaward_number", "subaward_number"),
("subaward_amount", "subaward_amount"),
("subaward_action_date", "sub_action_date"),
("subaward_action_date_fiscal_year", None), # Annotation is used to create this column
("subawardee_uei", "sub_awardee_or_recipient_uei"),
("subawardee_duns", "sub_awardee_or_recipient_uniqu"),
("subawardee_name", "sub_awardee_or_recipient_legal_raw"),
("subawardee_dba_name", "sub_dba_name"),
("subawardee_parent_uei", "sub_ultimate_parent_uei"),
("subawardee_parent_duns", "sub_ultimate_parent_unique_ide"),
("subawardee_parent_name", "sub_ultimate_parent_legal_enti_raw"),
("subawardee_country_code", "sub_legal_entity_country_code_raw"),
("subawardee_country_name", "sub_legal_entity_country_name_raw"),
("subawardee_address_line_1", "sub_legal_entity_address_line1"),
("subawardee_city_name", "sub_legal_entity_city_name"),
("subawardee_state_code", "sub_legal_entity_state_code"),
("subawardee_state_name", "sub_legal_entity_state_name"),
("subawardee_zip_code", "sub_legal_entity_zip"),
("subaward_recipient_cd_original", None), # Annotation is used to create this column
("subaward_recipient_cd_current", None), # Annotation is used to create this column
("subawardee_foreign_postal_code", "sub_legal_entity_foreign_posta"),
("subawardee_business_types", "sub_business_types"),
("subaward_primary_place_of_performance_city_name", "sub_place_of_perform_city_name"),
(
"subaward_primary_place_of_performance_state_code",
"sub_place_of_perform_state_code",
),
(
"subaward_primary_place_of_performance_state_name",
"sub_place_of_perform_state_name",
),
(
"subaward_primary_place_of_performance_address_zip_code",
"sub_place_of_performance_zip",
),
("subaward_place_of_performance_cd_original", None), # Annotation is used to create this column
("subaward_place_of_performance_cd_current", None), # Annotation is used to create this column
(
"subaward_primary_place_of_performance_country_code",
"sub_place_of_perform_country_co_raw",
),
(
"subaward_primary_place_of_performance_country_name",
"sub_place_of_perform_country_na",
),
("subaward_description", "subaward_description"),
("subawardee_highly_compensated_officer_1_name", "sub_high_comp_officer1_full_na"),
("subawardee_highly_compensated_officer_1_amount", "sub_high_comp_officer1_amount"),
("subawardee_highly_compensated_officer_2_name", "sub_high_comp_officer2_full_na"),
("subawardee_highly_compensated_officer_2_amount", "sub_high_comp_officer2_amount"),
("subawardee_highly_compensated_officer_3_name", "sub_high_comp_officer3_full_na"),
("subawardee_highly_compensated_officer_3_amount", "sub_high_comp_officer3_amount"),
("subawardee_highly_compensated_officer_4_name", "sub_high_comp_officer4_full_na"),
("subawardee_highly_compensated_officer_4_amount", "sub_high_comp_officer4_amount"),
("subawardee_highly_compensated_officer_5_name", "sub_high_comp_officer5_full_na"),
("subawardee_highly_compensated_officer_5_amount", "sub_high_comp_officer5_amount"),
("usaspending_permalink", None), # to be filled in by annotation
("subaward_fsrs_report_last_modified_date", "date_submitted"),
]
),
},
"gtas_balances": {
"treasury_account": OrderedDict(
[
("owning_agency_name", "treasury_account_identifier__federal_account__parent_toptier_agency__name"),
("submission_period", "submission_period"), # Column is annotated in account_download.py
(
"allocation_transfer_agency_identifier_code",
"allocation_transfer_agency_identifier_code",
), # Column is annotated in account_download.py
("agency_identifier_code", "agency_identifier_code"), # Column is annotated in account_download.py
(
"beginning_period_of_availability",
"beginning_period_of_availability",
), # Column is annotated in account_download.py
(
"ending_period_of_availability",
"ending_period_of_availability",
), # Column is annotated in account_download.py
("availability_type_code", "availability_type_code"), # Column is annotated in account_download.py
("main_account_code", "main_account_code"), # Column is annotated in account_download.py
("sub_account_code", "sub_account_code"), # Column is annotated in account_download.py
("treasury_account_symbol", "tas_rendering_label"),
("treasury_account_name", "treasury_account_identifier__account_title"),
("agency_identifier_name", "agency_identifier_name"), # Column is annotated in account_download.py
(
"allocation_transfer_agency_identifier_name",
"allocation_transfer_agency_identifier_name",
), # Column is annotated in account_download.py
("budget_function", "treasury_account_identifier__budget_function_title"),
("budget_subfunction", "treasury_account_identifier__budget_subfunction_title"),
("federal_account_symbol", "treasury_account_identifier__federal_account__federal_account_code"),
("federal_account_name", "treasury_account_identifier__federal_account__account_title"),
("disaster_emergency_fund_code", "disaster_emergency_fund__code"),
("disaster_emergency_fund_name", "disaster_emergency_fund__public_law"),
(
"budget_authority_unobligated_balance_brought_forward",
"budget_authority_unobligated_balance_brought_forward_cpe",
),
(
"adjustments_to_unobligated_balance_brought_forward_fyb",
"adjustments_to_unobligated_balance_brought_forward_fyb",
),
(
"adjustments_to_unobligated_balance_brought_forward_cpe",
"adjustments_to_unobligated_balance_brought_forward_cpe",
),
("budget_authority_appropriated_amount", "budget_authority_appropriation_amount_cpe"),
("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", "other_budgetary_resources_amount_cpe"),
("total_budgetary_resources", "total_budgetary_resources_cpe"),
("prior_year_paid_obligation_recoveries", "prior_year_paid_obligation_recoveries"),
("anticipated_prior_year_obligation_recoveries", "anticipated_prior_year_obligation_recoveries"),
("obligations_incurred", "obligations_incurred_total_cpe"),
(
"deobligations_or_recoveries_or_refunds_from_prior_year",
"deobligations_or_recoveries_or_refunds_from_prior_year_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"),
]
)
},
"account_balances": {
"treasury_account": OrderedDict(
[
("owning_agency_name", "treasury_account_identifier__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_identifier_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_identifier__tas_rendering_label"),
("treasury_account_name", "treasury_account_identifier__account_title"),
("agency_identifier_name", "agency_identifier_name"),
("allocation_transfer_agency_identifier_name", "allocation_transfer_agency_identifier_name"),
("budget_function", "treasury_account_identifier__budget_function_title"),
("budget_subfunction", "treasury_account_identifier__budget_subfunction_title"),
("federal_account_symbol", "treasury_account_identifier__federal_account__federal_account_code"),
("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_cpe",
"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"), # Column is annotated in account_download.py
("status_of_budgetary_resources_total", "status_of_budgetary_resources_total_cpe"),
(
"last_modified_date" + NAMING_CONFLICT_DISCRIMINATOR,
"last_modified_date" + NAMING_CONFLICT_DISCRIMINATOR,
), # Column is annotated in account_download.py
]
),
"federal_account": OrderedDict(
[
("owning_agency_name", "treasury_account_identifier__federal_account__parent_toptier_agency__name"),
("reporting_agency_name", "reporting_agency_name"), # Column is annotated in account_download.py
("submission_period", "submission_period"), # Column is annotated in account_download.py
("federal_account_symbol", "treasury_account_identifier__federal_account__federal_account_code"),
("federal_account_name", "treasury_account_identifier__federal_account__account_title"),
("agency_identifier_name", "agency_identifier_name"),
("budget_function", "budget_function"), # Column is annotated in account_download.py
("budget_subfunction", "budget_subfunction"), # Column is annotated in account_download.py
(
"budget_authority_unobligated_balance_brought_forward",
"budget_authority_unobligated_balance_brought_forward",
),
(
"adjustments_to_unobligated_balance_brought_forward_cpe",
"adjustments_to_unobligated_balance_brought_forward_cpe",
),
("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"), # Column is annotated in account_download.py
("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"),
("submission_period", "submission_period"), # Column is annotated in account_download.py
("allocation_transfer_agency_identifier_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__tas_rendering_label"),
("treasury_account_name", "treasury_account__account_title"),
("agency_identifier_name", "agency_identifier_name"),
("allocation_transfer_agency_identifier_name", "allocation_transfer_agency_identifier_name"),
("budget_function", "treasury_account__budget_function_title"),
("budget_subfunction", "treasury_account__budget_subfunction_title"),
("federal_account_symbol", "treasury_account__federal_account__federal_account_code"),
("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"),
("disaster_emergency_fund_code", "disaster_emergency_fund__code"),
("disaster_emergency_fund_name", "disaster_emergency_fund__title"),
("obligations_incurred", "obligations_incurred_by_program_object_class_cpe"),
("obligations_undelivered_orders_unpaid_total", "obligations_undelivered_orders_unpaid_total_cpe"),
("obligations_undelivered_orders_unpaid_total_FYB", "obligations_undelivered_orders_unpaid_total_fyb"),
(
"USSGL480100_undelivered_orders_obligations_unpaid",
"ussgl480100_undelivered_orders_obligations_unpaid_cpe",
),
(
"USSGL480100_undelivered_orders_obligations_unpaid_FYB",
"ussgl480100_undelivered_orders_obligations_unpaid_fyb",
),
(
"USSGL488100_upward_adj_prior_year_undeliv_orders_oblig_unpaid",
"ussgl488100_upward_adjust_pri_undeliv_order_oblig_unpaid_cpe",
),
("obligations_delivered_orders_unpaid_total", "obligations_delivered_orders_unpaid_total_cpe"),
("obligations_delivered_orders_unpaid_total_FYB", "obligations_delivered_orders_unpaid_total_cpe"),
(
"USSGL490100_delivered_orders_obligations_unpaid",
"ussgl490100_delivered_orders_obligations_unpaid_cpe",
),
(
"USSGL490100_delivered_orders_obligations_unpaid_FYB",
"ussgl490100_delivered_orders_obligations_unpaid_fyb",
),
(
"USSGL498100_upward_adj_of_prior_year_deliv_orders_oblig_unpaid",
"ussgl498100_upward_adjust_pri_deliv_orders_oblig_unpaid_cpe",
),
(
"gross_outlay_amount_FYB_to_period_end",
"gross_outlay_amount_FYB_to_period_end",
), # Column is annotated in account_download.py
("gross_outlay_amount_FYB", "gross_outlay_amount_by_program_object_class_fyb"),
(
"gross_outlays_undelivered_orders_prepaid_total",
"gross_outlays_undelivered_orders_prepaid_total_cpe",
),
(
"gross_outlays_undelivered_orders_prepaid_total_FYB",
"gross_outlays_undelivered_orders_prepaid_total_cpe",
),
(
"USSGL480200_undelivered_orders_obligations_prepaid_advanced",
"ussgl480200_undelivered_orders_oblig_prepaid_advanced_cpe",
),
(
"USSGL480200_undelivered_orders_obligations_prepaid_advanced_FYB",
"ussgl480200_undelivered_orders_oblig_prepaid_advanced_fyb",
),
(
"USSGL488200_upward_adj_prior_year_undeliv_orders_oblig_prepaid",
"ussgl488200_up_adjust_pri_undeliv_order_oblig_ppaid_adv_cpe",
),
("gross_outlays_delivered_orders_paid_total", "gross_outlays_delivered_orders_paid_total_cpe"),
("gross_outlays_delivered_orders_paid_total_FYB", "gross_outlays_delivered_orders_paid_total_fyb"),
("USSGL490200_delivered_orders_obligations_paid", "ussgl490200_delivered_orders_obligations_paid_cpe"),
(
"USSGL490800_authority_outlayed_not_yet_disbursed",
"ussgl490800_authority_outlayed_not_yet_disbursed_cpe",
),
(
"USSGL490800_authority_outlayed_not_yet_disbursed_FYB",
"ussgl490800_authority_outlayed_not_yet_disbursed_fyb",
),
(
"USSGL498200_upward_adj_of_prior_year_deliv_orders_oblig_paid",
"ussgl498200_upward_adjust_pri_deliv_orders_oblig_paid_cpe",
),
(
"deobligations_or_recoveries_or_refunds_from_prior_year",
"deobligations_recoveries_refund_pri_program_object_class_cpe",
),
(
"USSGL487100_downward_adj_prior_year_unpaid_undeliv_orders_oblig",
"ussgl487100_down_adj_pri_unpaid_undel_orders_oblig_recov_cpe",
),
(
"USSGL497100_downward_adj_prior_year_unpaid_deliv_orders_oblig",
"ussgl497100_down_adj_pri_unpaid_deliv_orders_oblig_recov_cpe",
),
(
"USSGL487200_downward_adj_prior_year_prepaid_undeliv_order_oblig",
"USSGL487200_downward_adj_prior_year_prepaid_undeliv_order_oblig",
),
(
"USSGL497200_downward_adj_of_prior_year_paid_deliv_orders_oblig",
"USSGL497200_downward_adj_of_prior_year_paid_deliv_orders_oblig",
), # Column is annotated in account_download.py
(
"USSGL483100_undelivered_orders_obligations_transferred_unpaid",
"ussgl483100_undelivered_orders_oblig_transferred_unpaid_cpe",
),
(
"USSGL493100_delivered_orders_obligations_transferred_unpaid",
"ussgl493100_delivered_orders_oblig_transferred_unpaid_cpe",
),
(
"USSGL483200_undeliv_orders_oblig_transferred_prepaid_advanced",
"ussgl483200_undeliv_orders_oblig_transferred_prepaid_adv_cpe",
),
(
"last_modified_date" + NAMING_CONFLICT_DISCRIMINATOR,
"last_modified_date" + NAMING_CONFLICT_DISCRIMINATOR,
), # Column is annotated in account_download.py
]
),
"federal_account": OrderedDict(
[
("owning_agency_name", "treasury_account__federal_account__parent_toptier_agency__name"),
("reporting_agency_name", "reporting_agency_name"), # Column is annotated in account_download.py
("submission_period", "submission_period"), # Column is annotated in account_download.py
("agency_identifier_name", "agency_identifier_name"),
("budget_function", "budget_function"), # Column is annotated in account_download.py
("budget_subfunction", "budget_subfunction"), # Column is annotated in account_download.py
("federal_account_symbol", "treasury_account__federal_account__federal_account_code"),
("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"),
("disaster_emergency_fund_code", "disaster_emergency_fund__code"),
("disaster_emergency_fund_name", "disaster_emergency_fund__title"),
("obligations_incurred", "obligations_incurred"),
("obligations_undelivered_orders_unpaid_total", None), # annotated in download_annotation_functions.py
(
"obligations_undelivered_orders_unpaid_total_FYB",
None,
), # annotated in download_annotation_functions.py
(
"USSGL480100_undelivered_orders_obligations_unpaid",
None,
), # annotated in download_annotation_functions.py
(
"USSGL480100_undelivered_orders_obligations_unpaid_FYB",
None,
), # annotated in download_annotation_functions.py
(
"USSGL488100_upward_adj_prior_year_undeliv_orders_oblig_unpaid",
None,
), # annotated in download_annotation_functions.py
("obligations_delivered_orders_unpaid_total", None), # annotated in download_annotation_functions.py
(
"obligations_delivered_orders_unpaid_total_FYB",
None,
), # annotated in download_annotation_functions.py
(
"USSGL490100_delivered_orders_obligations_unpaid",
None,
), # annotated in download_annotation_functions.py
(
"USSGL490100_delivered_orders_obligations_unpaid_FYB",
None,
), # annotated in download_annotation_functions.py
(
"USSGL498100_upward_adj_of_prior_year_deliv_orders_oblig_unpaid",
None,
), # annotated in download_annotation_functions.py
(
"gross_outlay_amount_FYB_to_period_end",
"gross_outlay_amount_FYB_to_period_end",
), # Column is annotated in account_download.py
("gross_outlay_amount_FYB", None), # annotated in download_annotation_functions.py
(
"gross_outlays_undelivered_orders_prepaid_total",
None,
), # annotated in download_annotation_functions.py
(
"gross_outlays_undelivered_orders_prepaid_total_FYB",
None,
), # annotated in download_annotation_functions.py
(
"USSGL480200_undelivered_orders_obligations_prepaid_advanced",
None,
), # annotated in download_annotation_functions.py
(
"USSGL480200_undelivered_orders_obligations_prepaid_advanced_FYB",
None,
), # annotated in download_annotation_functions.py
(
"USSGL488200_upward_adj_prior_year_undeliv_orders_oblig_prepaid",
None,
), # annotated in download_annotation_functions.py
("gross_outlays_delivered_orders_paid_total", None), # annotated in download_annotation_functions.py
(
"gross_outlays_delivered_orders_paid_total_FYB",
None,
), # annotated in download_annotation_functions.py
(
"USSGL490200_delivered_orders_obligations_paid",
None,
), # annotated in download_annotation_functions.py
(
"USSGL490800_authority_outlayed_not_yet_disbursed",
None,
), # annotated in download_annotation_functions.py
(
"USSGL490800_authority_outlayed_not_yet_disbursed_FYB",
None,
), # annotated in download_annotation_functions.py
(
"USSGL498200_upward_adj_of_prior_year_deliv_orders_oblig_paid",
None,
), # annotated in download_annotation_functions.py
(
"deobligations_or_recoveries_or_refunds_from_prior_year",
None,
), # annotated in download_annotation_functions.py
(
"USSGL487100_downward_adj_prior_year_unpaid_undeliv_orders_oblig",
None,
), # annotated in download_annotation_functions.py
(
"USSGL497100_downward_adj_prior_year_unpaid_deliv_orders_oblig",
None,
), # annotated in download_annotation_functions.py
(
"USSGL487200_downward_adj_prior_year_prepaid_undeliv_order_oblig",
"USSGL487200_downward_adj_prior_year_prepaid_undeliv_order_oblig",
),
(
"USSGL497200_downward_adj_of_prior_year_paid_deliv_orders_oblig",
"USSGL497200_downward_adj_of_prior_year_paid_deliv_orders_oblig",
), # Column is annotated in account_download.py
(
"USSGL483100_undelivered_orders_obligations_transferred_unpaid",
None,
), # annotated in download_annotation_functions.py
(
"USSGL493100_delivered_orders_obligations_transferred_unpaid",
None,
), # annotated in download_annotation_functions.py
(
"USSGL483200_undeliv_orders_oblig_transferred_prepaid_advanced",
None,
), # annotated in download_annotation_functions.py
(
"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 annotated in account_download.py
("allocation_transfer_agency_identifier_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__tas_rendering_label"),
("treasury_account_name", "treasury_account__account_title"),
("agency_identifier_name", "agency_identifier_name"),
("allocation_transfer_agency_identifier_name", "allocation_transfer_agency_identifier_name"),
("budget_function", "treasury_account__budget_function_title"),
("budget_subfunction", "treasury_account__budget_subfunction_title"),
("federal_account_symbol", "treasury_account__federal_account__federal_account_code"),
("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"),
("disaster_emergency_fund_code", "disaster_emergency_fund__code"),
("disaster_emergency_fund_name", "disaster_emergency_fund__title"),
("transaction_obligated_amount", "transaction_obligated_amount"),
(
"gross_outlay_amount_FYB_to_period_end",
"gross_outlay_amount_FYB_to_period_end",
), # Column is annotated in account_download.py
(
"USSGL487200_downward_adj_prior_year_prepaid_undeliv_order_oblig",
"USSGL487200_downward_adj_prior_year_prepaid_undeliv_order_oblig",
), # Column is annotated in account_download.py
(
"USSGL497200_downward_adj_of_prior_year_paid_deliv_orders_oblig",
"USSGL497200_downward_adj_of_prior_year_paid_deliv_orders_oblig",
), # Column is annotated in account_download.py
("award_unique_key", "award__generated_unique_award_id"),
("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
("award_latest_action_date", "award__certified_date"),
(
"award_latest_action_date_fiscal_year",
"award_latest_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_search__ordering_period_end_date"),
("award_type_code", "award_type_code"), # Column is annotated in account_download.py
("award_type", "award_type"), # Column is annotated in account_download.py
("idv_type_code", "award__latest_transaction_search__idv_type"),
("idv_type", "award__latest_transaction_search__idv_type_description"),
("prime_award_base_transaction_description", "award__description"),
("awarding_agency_code", "award__latest_transaction_search__awarding_agency_code"),
("awarding_agency_name", "award__latest_transaction_search__awarding_toptier_agency_name_raw"),
("awarding_subagency_code", "award__latest_transaction_search__awarding_sub_tier_agency_c"),
("awarding_subagency_name", "award__latest_transaction_search__awarding_subtier_agency_name_raw"),
("awarding_office_code", "award__latest_transaction_search__awarding_office_code"),
("awarding_office_name", "award__latest_transaction_search__awarding_office_name"),
("funding_agency_code", "award__latest_transaction_search__funding_agency_code"),
("funding_agency_name", "award__latest_transaction_search__funding_toptier_agency_name_raw"),
("funding_sub_agency_code", "award__latest_transaction_search__funding_sub_tier_agency_co"),
("funding_sub_agency_name", "award__latest_transaction_search__funding_subtier_agency_name_raw"),
("funding_office_code", "award__latest_transaction_search__funding_office_code"),
("funding_office_name", "award__latest_transaction_search__funding_office_name"),
("recipient_uei", "award__latest_transaction_search__recipient_uei"),
("recipient_duns", "award__latest_transaction_search__recipient_unique_id"),
("recipient_name", "award__latest_transaction_search__recipient_name"),
("recipient_name_raw", "award__latest_transaction_search__recipient_name_raw"),
("recipient_parent_uei", "award__latest_transaction_search__parent_uei"),
("recipient_parent_duns", "award__latest_transaction_search__parent_uei"),
("recipient_parent_name", "award__latest_transaction_search__parent_recipient_name"),
("recipient_parent_name_raw", "award__latest_transaction_search__parent_recipient_name_raw"),
("recipient_country", "award__latest_transaction_search__recipient_location_country_code"),
("recipient_state", "award__latest_transaction_search__recipient_location_state_code"),
("recipient_county", "award__latest_transaction_search__recipient_location_county_name"),
("recipient_city", "award__latest_transaction_search__recipient_location_city_name"),
(
"prime_award_summary_recipient_cd_original",
"prime_award_summary_recipient_cd_original",
), # Column is annotated in account_download.py, function generate_treasury_account_query
(
"prime_award_summary_recipient_cd_current",
"prime_award_summary_recipient_cd_current",
), # Column is annotated in account_download.py, function generate_treasury_account_query
("recipient_zip_code", "recipient_zip_code"), # Column is annotated in account_download.py
("primary_place_of_performance_country", "award__latest_transaction_search__pop_country_name"),
("primary_place_of_performance_state", "award__latest_transaction_search__pop_state_name"),
("primary_place_of_performance_county", "award__latest_transaction_search__pop_county_name"),
(
"prime_award_summary_place_of_performance_cd_original",
"prime_award_summary_place_of_performance_cd_original",
), # Column is annotated in account_download.py, function generate_treasury_account_query
(
"prime_award_summary_place_of_performance_cd_current",
"prime_award_summary_place_of_performance_cd_current",
), # Column is annotated in account_download.py, function generate_treasury_account_query
(
"primary_place_of_performance_zip_code",
"award__latest_transaction_search__place_of_performance_zip4a",
),
("cfda_number", "award__latest_transaction_search__cfda_number"),
("cfda_title", "award__latest_transaction_search__cfda_title"),
("product_or_service_code", "award__latest_transaction_search__product_or_service_code"),
(
"product_or_service_code_description",
"award__latest_transaction_search__product_or_service_description",
),
("naics_code", "award__latest_transaction_search__naics_code"),
("naics_description", "award__latest_transaction_search__naics_description"),
("national_interest_action_code", "award__latest_transaction_search__national_interest_action"),
("national_interest_action", "award__latest_transaction_search__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
]
),
"federal_account": OrderedDict(
[
("owning_agency_name", "treasury_account__federal_account__parent_toptier_agency__name"),
("reporting_agency_name", "reporting_agency_name"), # Column is annotated in account_download.py
("submission_period", "submission_period"), # Column is annotated in account_download.py
("federal_account_symbol", "treasury_account__federal_account__federal_account_code"),
("federal_account_name", "treasury_account__federal_account__account_title"),
("agency_identifier_name", "agency_identifier_name"),
("budget_function", "budget_function"), # Column is annotated in account_download.py
("budget_subfunction", "budget_subfunction"), # Column is annotated 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"),
("disaster_emergency_fund_code", "disaster_emergency_fund__code"),
("disaster_emergency_fund_name", "disaster_emergency_fund__title"),
("transaction_obligated_amount", "transaction_obligated_amount"),
(
"gross_outlay_amount_FYB_to_period_end",
"gross_outlay_amount_FYB_to_period_end",
), # Column is annotated in account_download.py
(
"USSGL487200_downward_adj_prior_year_prepaid_undeliv_order_oblig",
"USSGL487200_downward_adj_prior_year_prepaid_undeliv_order_oblig",
), # Column is annotated in account_download.py
(
"USSGL497200_downward_adj_of_prior_year_paid_deliv_orders_oblig",
"USSGL497200_downward_adj_of_prior_year_paid_deliv_orders_oblig",
), # Column is annotated in account_download.py
("award_unique_key", "award__generated_unique_award_id"),
("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
("award_latest_action_date", "award__certified_date"),
(
"award_latest_action_date_fiscal_year",
"award_latest_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_search__ordering_period_end_date"),
("award_type_code", "award_type_code"), # Column is annotated in account_download.py
("award_type", "award_type"), # Column is annotated in account_download.py
("idv_type_code", "award__latest_transaction_search__idv_type"),
("idv_type", "award__latest_transaction_search__idv_type_description"),
("prime_award_base_transaction_description", "award__description"),
("awarding_agency_code", "award__latest_transaction_search__awarding_agency_code"),
("awarding_agency_name", "award__latest_transaction_search__awarding_toptier_agency_name_raw"),
("awarding_subagency_code", "award__latest_transaction_search__awarding_sub_tier_agency_c"),
("awarding_subagency_name", "award__latest_transaction_search__awarding_subtier_agency_name_raw"),
("awarding_office_code", "award__latest_transaction_search__awarding_office_code"),
("awarding_office_name", "award__latest_transaction_search__awarding_office_name"),
("funding_agency_code", "award__latest_transaction_search__funding_agency_code"),
("funding_agency_name", "award__latest_transaction_search__funding_toptier_agency_name_raw"),
("funding_sub_agency_code", "award__latest_transaction_search__funding_sub_tier_agency_co"),
("funding_sub_agency_name", "award__latest_transaction_search__funding_subtier_agency_name_raw"),
("funding_office_code", "award__latest_transaction_search__funding_office_code"),
("funding_office_name", "award__latest_transaction_search__funding_office_name"),
("recipient_uei", "award__latest_transaction_search__recipient_uei"),
("recipient_duns", "award__latest_transaction_search__recipient_unique_id"),
("recipient_name", "award__latest_transaction_search__recipient_name"),
("recipient_name_raw", "award__latest_transaction_search__recipient_name_raw"),
("recipient_parent_uei", "award__latest_transaction_search__parent_uei"),
("recipient_parent_duns", "award__latest_transaction_search__parent_uei"),
("recipient_parent_name", "award__latest_transaction_search__parent_recipient_name"),
("recipient_parent_name_raw", "award__latest_transaction_search__parent_recipient_name_raw"),
("recipient_country", "award__latest_transaction_search__recipient_location_country_code"),
("recipient_state", "award__latest_transaction_search__recipient_location_state_code"),
("recipient_county", "award__latest_transaction_search__recipient_location_county_name"),
("recipient_city", "award__latest_transaction_search__recipient_location_city_name"),
(
"prime_award_summary_recipient_cd_original",
"prime_award_summary_recipient_cd_original",
), # Column is annotated in account_download.py, function generate_treasury_account_query
(
"prime_award_summary_recipient_cd_current",
"prime_award_summary_recipient_cd_current",
), # Column is annotated in account_download.py, function generate_treasury_account_query
("recipient_zip_code", "recipient_zip_code"), # Column is annotated in account_download.py
("primary_place_of_performance_country", "award__latest_transaction_search__pop_country_name"),
("primary_place_of_performance_state", "award__latest_transaction_search__pop_state_name"),
("primary_place_of_performance_county", "award__latest_transaction_search__pop_county_name"),
(
"prime_award_summary_place_of_performance_cd_original",
"prime_award_summary_place_of_performance_cd_original",
), # Column is annotated in account_download.py, function generate_treasury_account_query
(
"prime_award_summary_place_of_performance_cd_current",
"prime_award_summary_place_of_performance_cd_current",
), # Column is annotated in account_download.py, function generate_treasury_account_query
(
"primary_place_of_performance_zip_code",
"award__latest_transaction_search__place_of_performance_zip4a",
),
("cfda_number", "award__latest_transaction_search__cfda_number"),
("cfda_title", "award__latest_transaction_search__cfda_title"),
("product_or_service_code", "award__latest_transaction_search__product_or_service_code"),
(
"product_or_service_code_description",
"award__latest_transaction_search__product_or_service_description",
),
("naics_code", "award__latest_transaction_search__naics_code"),
("naics_description", "award__latest_transaction_search__naics_description"),
("national_interest_action_code", "award__latest_transaction_search__national_interest_action"),
("national_interest_action", "award__latest_transaction_search__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
]
),
},
"disaster": {
"recipient": OrderedDict(
[
("recipient", "recipient_name"),
("award_obligations", "award_obligations"),
("award_outlays", "award_outlays"),
("face_value_of_loans", "face_value_of_loans"),
("number_of_awards", "number_of_awards"),
]
)
},
}
# IDV Orders are identical to Award but only contain "d1"
query_paths["idv_orders"] = {"d1": copy.deepcopy(query_paths["award"]["d1"])}
# IDV Transactions are identical to Transactions but only contain "d1"
query_paths["idv_transaction_history"] = {"d1": copy.deepcopy(query_paths["transaction_search"]["d1"])}
# Assistance Transactions are identical to Transactions but only contain "d2"
query_paths["assistance_transaction_history"] = {"d2": copy.deepcopy(query_paths["transaction_search"]["d2"])}