usaspending_api/transactions/delta_models/detached_award_procurement.py
DETACHED_AWARD_PROCUREMENT_COLUMNS = {
"detached_award_procurement_id": {"delta": "INTEGER", "postgres": "INTEGER"},
"detached_award_proc_unique": {"delta": "STRING", "postgres": "TEXT"},
"a_76_fair_act_action": {"delta": "STRING", "postgres": "TEXT"},
"a_76_fair_act_action_desc": {"delta": "STRING", "postgres": "TEXT"},
"action_date": {"delta": "STRING", "postgres": "TEXT"},
"action_type": {"delta": "STRING", "postgres": "TEXT"},
"action_type_description": {"delta": "STRING", "postgres": "TEXT"},
"additional_reporting": {"delta": "STRING", "postgres": "TEXT"},
"agency_id": {"delta": "STRING", "postgres": "TEXT"},
"airport_authority": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"alaskan_native_owned_corpo": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"alaskan_native_servicing_i": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"american_indian_owned_busi": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"annual_revenue": {"delta": "STRING", "postgres": "TEXT"},
"asian_pacific_american_own": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"award_description": {"delta": "STRING", "postgres": "TEXT"},
"award_modification_amendme": {"delta": "STRING", "postgres": "TEXT"},
"award_or_idv_flag": {"delta": "STRING", "postgres": "TEXT"},
"awardee_or_recipient_legal": {"delta": "STRING", "postgres": "TEXT"},
"awardee_or_recipient_uei": {"delta": "STRING", "postgres": "TEXT"},
"awardee_or_recipient_uniqu": {"delta": "STRING", "postgres": "TEXT"},
"awarding_agency_code": {"delta": "STRING", "postgres": "TEXT"},
"awarding_agency_name": {"delta": "STRING", "postgres": "TEXT"},
"awarding_office_code": {"delta": "STRING", "postgres": "TEXT"},
"awarding_office_name": {"delta": "STRING", "postgres": "TEXT"},
"awarding_sub_tier_agency_c": {"delta": "STRING", "postgres": "TEXT"},
"awarding_sub_tier_agency_n": {"delta": "STRING", "postgres": "TEXT"},
"base_and_all_options_value": {"delta": "STRING", "postgres": "TEXT"},
"base_exercised_options_val": {"delta": "STRING", "postgres": "TEXT"},
"black_american_owned_busin": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"business_categories": {"delta": "ARRAY<STRING>", "postgres": "TEXT[]"},
"c1862_land_grant_college": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"c1890_land_grant_college": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"c1994_land_grant_college": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"c8a_program_participant": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"cage_code": {"delta": "STRING", "postgres": "TEXT"},
"city_local_government": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"clinger_cohen_act_pla_desc": {"delta": "STRING", "postgres": "TEXT"},
"clinger_cohen_act_planning": {"delta": "STRING", "postgres": "TEXT"},
"commercial_item_acqui_desc": {"delta": "STRING", "postgres": "TEXT"},
"commercial_item_acquisitio": {"delta": "STRING", "postgres": "TEXT"},
"commercial_item_test_desc": {"delta": "STRING", "postgres": "TEXT"},
"commercial_item_test_progr": {"delta": "STRING", "postgres": "TEXT"},
"community_developed_corpor": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"community_development_corp": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"consolidated_contract": {"delta": "STRING", "postgres": "TEXT"},
"consolidated_contract_desc": {"delta": "STRING", "postgres": "TEXT"},
"construction_wage_rat_desc": {"delta": "STRING", "postgres": "TEXT"},
"construction_wage_rate_req": {"delta": "STRING", "postgres": "TEXT"},
"contingency_humanitar_desc": {"delta": "STRING", "postgres": "TEXT"},
"contingency_humanitarian_o": {"delta": "STRING", "postgres": "TEXT"},
"contract_award_type": {"delta": "STRING", "postgres": "TEXT"},
"contract_award_type_desc": {"delta": "STRING", "postgres": "TEXT"},
"contract_bundling": {"delta": "STRING", "postgres": "TEXT"},
"contract_bundling_descrip": {"delta": "STRING", "postgres": "TEXT"},
"contract_financing": {"delta": "STRING", "postgres": "TEXT"},
"contract_financing_descrip": {"delta": "STRING", "postgres": "TEXT"},
"contracting_officers_desc": {"delta": "STRING", "postgres": "TEXT"},
"contracting_officers_deter": {"delta": "STRING", "postgres": "TEXT"},
"contracts": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"corporate_entity_not_tax_e": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"corporate_entity_tax_exemp": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"cost_accounting_stand_desc": {"delta": "STRING", "postgres": "TEXT"},
"cost_accounting_standards": {"delta": "STRING", "postgres": "TEXT"},
"cost_or_pricing_data": {"delta": "STRING", "postgres": "TEXT"},
"cost_or_pricing_data_desc": {"delta": "STRING", "postgres": "TEXT"},
"council_of_governments": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"country_of_product_or_desc": {"delta": "STRING", "postgres": "TEXT"},
"country_of_product_or_serv": {"delta": "STRING", "postgres": "TEXT"},
"county_local_government": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"created_at": {"delta": "TIMESTAMP", "postgres": "TIMESTAMP"},
"current_total_value_award": {"delta": "STRING", "postgres": "TEXT"},
"division_name": {"delta": "STRING", "postgres": "TEXT"},
"division_number_or_office": {"delta": "STRING", "postgres": "TEXT"},
"dod_claimant_prog_cod_desc": {"delta": "STRING", "postgres": "TEXT"},
"dod_claimant_program_code": {"delta": "STRING", "postgres": "TEXT"},
"domestic_or_foreign_e_desc": {"delta": "STRING", "postgres": "TEXT"},
"domestic_or_foreign_entity": {"delta": "STRING", "postgres": "TEXT"},
"domestic_shelter": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"dot_certified_disadvantage": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"economically_disadvantaged": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"educational_institution": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"emerging_small_business": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"entity_data_source": {"delta": "STRING", "postgres": "TEXT"},
"epa_designated_produc_desc": {"delta": "STRING", "postgres": "TEXT"},
"epa_designated_product": {"delta": "STRING", "postgres": "TEXT"},
"evaluated_preference": {"delta": "STRING", "postgres": "TEXT"},
"evaluated_preference_desc": {"delta": "STRING", "postgres": "TEXT"},
"extent_compete_description": {"delta": "STRING", "postgres": "TEXT"},
"extent_competed": {"delta": "STRING", "postgres": "TEXT"},
"fair_opportunity_limi_desc": {"delta": "STRING", "postgres": "TEXT"},
"fair_opportunity_limited_s": {"delta": "STRING", "postgres": "TEXT"},
"fed_biz_opps": {"delta": "STRING", "postgres": "TEXT"},
"fed_biz_opps_description": {"delta": "STRING", "postgres": "TEXT"},
"federal_action_obligation": {"delta": "NUMERIC(38, 18)", "postgres": "NUMERIC(38,18"},
"federal_agency": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"federally_funded_research": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"for_profit_organization": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"foreign_funding": {"delta": "STRING", "postgres": "TEXT"},
"foreign_funding_desc": {"delta": "STRING", "postgres": "TEXT"},
"foreign_government": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"foreign_owned_and_located": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"foundation": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"funding_agency_code": {"delta": "STRING", "postgres": "TEXT"},
"funding_agency_name": {"delta": "STRING", "postgres": "TEXT"},
"funding_office_code": {"delta": "STRING", "postgres": "TEXT"},
"funding_office_name": {"delta": "STRING", "postgres": "TEXT"},
"funding_sub_tier_agency_co": {"delta": "STRING", "postgres": "TEXT"},
"funding_sub_tier_agency_na": {"delta": "STRING", "postgres": "TEXT"},
"government_furnished_desc": {"delta": "STRING", "postgres": "TEXT"},
"government_furnished_prope": {"delta": "STRING", "postgres": "TEXT"},
"grants": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"high_comp_officer1_amount": {"delta": "STRING", "postgres": "TEXT"},
"high_comp_officer1_full_na": {"delta": "STRING", "postgres": "TEXT"},
"high_comp_officer2_amount": {"delta": "STRING", "postgres": "TEXT"},
"high_comp_officer2_full_na": {"delta": "STRING", "postgres": "TEXT"},
"high_comp_officer3_amount": {"delta": "STRING", "postgres": "TEXT"},
"high_comp_officer3_full_na": {"delta": "STRING", "postgres": "TEXT"},
"high_comp_officer4_amount": {"delta": "STRING", "postgres": "TEXT"},
"high_comp_officer4_full_na": {"delta": "STRING", "postgres": "TEXT"},
"high_comp_officer5_amount": {"delta": "STRING", "postgres": "TEXT"},
"high_comp_officer5_full_na": {"delta": "STRING", "postgres": "TEXT"},
"hispanic_american_owned_bu": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"hispanic_servicing_institu": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"historically_black_college": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"historically_underutilized": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"hospital_flag": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"housing_authorities_public": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"idv_type": {"delta": "STRING", "postgres": "TEXT"},
"idv_type_description": {"delta": "STRING", "postgres": "TEXT"},
"indian_tribe_federally_rec": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"information_technolog_desc": {"delta": "STRING", "postgres": "TEXT"},
"information_technology_com": {"delta": "STRING", "postgres": "TEXT"},
"inherently_government_desc": {"delta": "STRING", "postgres": "TEXT"},
"inherently_government_func": {"delta": "STRING", "postgres": "TEXT"},
"initial_report_date": {"delta": "STRING", "postgres": "TEXT"},
"inter_municipal_local_gove": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"interagency_contract_desc": {"delta": "STRING", "postgres": "TEXT"},
"interagency_contracting_au": {"delta": "STRING", "postgres": "TEXT"},
"international_organization": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"interstate_entity": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"joint_venture_economically": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"joint_venture_women_owned": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"labor_standards": {"delta": "STRING", "postgres": "TEXT"},
"labor_standards_descrip": {"delta": "STRING", "postgres": "TEXT"},
"labor_surplus_area_firm": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"last_modified": {"delta": "STRING", "postgres": "TEXT"},
"legal_entity_address_line1": {"delta": "STRING", "postgres": "TEXT"},
"legal_entity_address_line2": {"delta": "STRING", "postgres": "TEXT"},
"legal_entity_address_line3": {"delta": "STRING", "postgres": "TEXT"},
"legal_entity_city_name": {"delta": "STRING", "postgres": "TEXT"},
"legal_entity_congressional": {"delta": "STRING", "postgres": "TEXT"},
"legal_entity_country_code": {"delta": "STRING", "postgres": "TEXT"},
"legal_entity_country_name": {"delta": "STRING", "postgres": "TEXT"},
"legal_entity_county_code": {"delta": "STRING", "postgres": "TEXT"},
"legal_entity_county_name": {"delta": "STRING", "postgres": "TEXT"},
"legal_entity_state_code": {"delta": "STRING", "postgres": "TEXT"},
"legal_entity_state_descrip": {"delta": "STRING", "postgres": "TEXT"},
"legal_entity_zip4": {"delta": "STRING", "postgres": "TEXT"},
"legal_entity_zip5": {"delta": "STRING", "postgres": "TEXT"},
"legal_entity_zip_last4": {"delta": "STRING", "postgres": "TEXT"},
"limited_liability_corporat": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"local_area_set_aside": {"delta": "STRING", "postgres": "TEXT"},
"local_area_set_aside_desc": {"delta": "STRING", "postgres": "TEXT"},
"local_government_owned": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"major_program": {"delta": "STRING", "postgres": "TEXT"},
"manufacturer_of_goods": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"materials_supplies_article": {"delta": "STRING", "postgres": "TEXT"},
"materials_supplies_descrip": {"delta": "STRING", "postgres": "TEXT"},
"minority_institution": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"minority_owned_business": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"multi_year_contract": {"delta": "STRING", "postgres": "TEXT"},
"multi_year_contract_desc": {"delta": "STRING", "postgres": "TEXT"},
"multiple_or_single_aw_desc": {"delta": "STRING", "postgres": "TEXT"},
"multiple_or_single_award_i": {"delta": "STRING", "postgres": "TEXT"},
"municipality_local_governm": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"naics": {"delta": "STRING", "postgres": "TEXT"},
"naics_description": {"delta": "STRING", "postgres": "TEXT"},
"national_interest_action": {"delta": "STRING", "postgres": "TEXT"},
"national_interest_desc": {"delta": "STRING", "postgres": "TEXT"},
"native_american_owned_busi": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"native_hawaiian_owned_busi": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"native_hawaiian_servicing": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"nonprofit_organization": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"number_of_actions": {"delta": "STRING", "postgres": "TEXT"},
"number_of_employees": {"delta": "STRING", "postgres": "TEXT"},
"number_of_offers_received": {"delta": "STRING", "postgres": "TEXT"},
"ordering_period_end_date": {"delta": "STRING", "postgres": "TEXT"},
"organizational_type": {"delta": "STRING", "postgres": "TEXT"},
"other_minority_owned_busin": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"other_not_for_profit_organ": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"other_statutory_authority": {"delta": "STRING", "postgres": "TEXT"},
"other_than_full_and_o_desc": {"delta": "STRING", "postgres": "TEXT"},
"other_than_full_and_open_c": {"delta": "STRING", "postgres": "TEXT"},
"parent_award_id": {"delta": "STRING", "postgres": "TEXT"},
"partnership_or_limited_lia": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"performance_based_se_desc": {"delta": "STRING", "postgres": "TEXT"},
"performance_based_service": {"delta": "STRING", "postgres": "TEXT"},
"period_of_perf_potential_e": {"delta": "STRING", "postgres": "TEXT"},
"period_of_performance_curr": {"delta": "STRING", "postgres": "TEXT"},
"period_of_performance_star": {"delta": "STRING", "postgres": "TEXT"},
"piid": {"delta": "STRING", "postgres": "TEXT"},
"place_of_manufacture": {"delta": "STRING", "postgres": "TEXT"},
"place_of_manufacture_desc": {"delta": "STRING", "postgres": "TEXT"},
"place_of_perf_country_desc": {"delta": "STRING", "postgres": "TEXT"},
"place_of_perfor_state_desc": {"delta": "STRING", "postgres": "TEXT"},
"place_of_perform_city_name": {"delta": "STRING", "postgres": "TEXT"},
"place_of_perform_country_c": {"delta": "STRING", "postgres": "TEXT"},
"place_of_perform_country_n": {"delta": "STRING", "postgres": "TEXT"},
"place_of_perform_county_co": {"delta": "STRING", "postgres": "TEXT"},
"place_of_perform_county_na": {"delta": "STRING", "postgres": "TEXT"},
"place_of_perform_state_nam": {"delta": "STRING", "postgres": "TEXT"},
"place_of_perform_zip_last4": {"delta": "STRING", "postgres": "TEXT"},
"place_of_performance_congr": {"delta": "STRING", "postgres": "TEXT"},
"place_of_performance_locat": {"delta": "STRING", "postgres": "TEXT"},
"place_of_performance_state": {"delta": "STRING", "postgres": "TEXT"},
"place_of_performance_zip4a": {"delta": "STRING", "postgres": "TEXT"},
"place_of_performance_zip5": {"delta": "STRING", "postgres": "TEXT"},
"planning_commission": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"port_authority": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"potential_total_value_awar": {"delta": "STRING", "postgres": "TEXT"},
"price_evaluation_adjustmen": {"delta": "STRING", "postgres": "TEXT"},
"private_university_or_coll": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"product_or_service_co_desc": {"delta": "STRING", "postgres": "TEXT"},
"product_or_service_code": {"delta": "STRING", "postgres": "TEXT"},
"program_acronym": {"delta": "STRING", "postgres": "TEXT"},
"program_system_or_equ_desc": {"delta": "STRING", "postgres": "TEXT"},
"program_system_or_equipmen": {"delta": "STRING", "postgres": "TEXT"},
"pulled_from": {"delta": "STRING", "postgres": "TEXT"},
"purchase_card_as_paym_desc": {"delta": "STRING", "postgres": "TEXT"},
"purchase_card_as_payment_m": {"delta": "STRING", "postgres": "TEXT"},
"receives_contracts_and_gra": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"recovered_materials_s_desc": {"delta": "STRING", "postgres": "TEXT"},
"recovered_materials_sustai": {"delta": "STRING", "postgres": "TEXT"},
"referenced_idv_agency_desc": {"delta": "STRING", "postgres": "TEXT"},
"referenced_idv_agency_iden": {"delta": "STRING", "postgres": "TEXT"},
"referenced_idv_agency_name": {"delta": "STRING", "postgres": "TEXT"},
"referenced_idv_modificatio": {"delta": "STRING", "postgres": "TEXT"},
"referenced_idv_type": {"delta": "STRING", "postgres": "TEXT"},
"referenced_idv_type_desc": {"delta": "STRING", "postgres": "TEXT"},
"referenced_mult_or_si_desc": {"delta": "STRING", "postgres": "TEXT"},
"referenced_mult_or_single": {"delta": "STRING", "postgres": "TEXT"},
"research": {"delta": "STRING", "postgres": "TEXT"},
"research_description": {"delta": "STRING", "postgres": "TEXT"},
"sam_exception": {"delta": "STRING", "postgres": "TEXT"},
"sam_exception_description": {"delta": "STRING", "postgres": "TEXT"},
"sba_certified_8_a_joint_ve": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"school_district_local_gove": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"school_of_forestry": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"sea_transportation": {"delta": "STRING", "postgres": "TEXT"},
"sea_transportation_desc": {"delta": "STRING", "postgres": "TEXT"},
"self_certified_small_disad": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"service_disabled_veteran_o": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"small_agricultural_coopera": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"small_business_competitive": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"small_disadvantaged_busine": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"sole_proprietorship": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"solicitation_date": {"delta": "STRING", "postgres": "TEXT"},
"solicitation_identifier": {"delta": "STRING", "postgres": "TEXT"},
"solicitation_procedur_desc": {"delta": "STRING", "postgres": "TEXT"},
"solicitation_procedures": {"delta": "STRING", "postgres": "TEXT"},
"state_controlled_instituti": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"subchapter_s_corporation": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"subcontinent_asian_asian_i": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"subcontracting_plan": {"delta": "STRING", "postgres": "TEXT"},
"subcontracting_plan_desc": {"delta": "STRING", "postgres": "TEXT"},
"the_ability_one_program": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"total_obligated_amount": {"delta": "STRING", "postgres": "TEXT"},
"township_local_government": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"transaction_number": {"delta": "STRING", "postgres": "TEXT"},
"transit_authority": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"tribal_college": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"tribally_owned_business": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"type_of_contract_pric_desc": {"delta": "STRING", "postgres": "TEXT"},
"type_of_contract_pricing": {"delta": "STRING", "postgres": "TEXT"},
"type_of_idc": {"delta": "STRING", "postgres": "TEXT"},
"type_of_idc_description": {"delta": "STRING", "postgres": "TEXT"},
"type_set_aside": {"delta": "STRING", "postgres": "TEXT"},
"type_set_aside_description": {"delta": "STRING", "postgres": "TEXT"},
"ultimate_parent_legal_enti": {"delta": "STRING", "postgres": "TEXT"},
"ultimate_parent_uei": {"delta": "STRING", "postgres": "TEXT"},
"ultimate_parent_unique_ide": {"delta": "STRING", "postgres": "TEXT"},
"undefinitized_action": {"delta": "STRING", "postgres": "TEXT"},
"undefinitized_action_desc": {"delta": "STRING", "postgres": "TEXT"},
"unique_award_key": {"delta": "STRING", "postgres": "TEXT"},
"updated_at": {"delta": "TIMESTAMP", "postgres": "TIMESTAMP"},
"us_federal_government": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"us_government_entity": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"us_local_government": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"us_state_government": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"us_tribal_government": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"vendor_alternate_name": {"delta": "STRING", "postgres": "TEXT"},
"vendor_alternate_site_code": {"delta": "STRING", "postgres": "TEXT"},
"vendor_doing_as_business_n": {"delta": "STRING", "postgres": "TEXT"},
"vendor_enabled": {"delta": "STRING", "postgres": "TEXT"},
"vendor_fax_number": {"delta": "STRING", "postgres": "TEXT"},
"vendor_legal_org_name": {"delta": "STRING", "postgres": "TEXT"},
"vendor_location_disabled_f": {"delta": "STRING", "postgres": "TEXT"},
"vendor_phone_number": {"delta": "STRING", "postgres": "TEXT"},
"vendor_site_code": {"delta": "STRING", "postgres": "TEXT"},
"veteran_owned_business": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"veterinary_college": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"veterinary_hospital": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"woman_owned_business": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
"women_owned_small_business": {"delta": "BOOLEAN", "postgres": "BOOLEAN"},
}
DETACHED_AWARD_PROCUREMENT_DELTA_COLUMNS = {k: v["delta"] for k, v in DETACHED_AWARD_PROCUREMENT_COLUMNS.items()}
DETACHED_AWARD_PROCUREMENT_POSTGRES_COLUMNS = {k: v["postgres"] for k, v in DETACHED_AWARD_PROCUREMENT_COLUMNS.items()}
detached_award_procurement_create_sql_string = fr"""
CREATE OR REPLACE TABLE {{DESTINATION_TABLE}} (
{", ".join([f'{key} {val}' for key, val in DETACHED_AWARD_PROCUREMENT_DELTA_COLUMNS.items()])}
)
USING DELTA
LOCATION 's3a://{{SPARK_S3_BUCKET}}/{{DELTA_LAKE_S3_PATH}}/{{DESTINATION_DATABASE}}/{{DESTINATION_TABLE}}'
"""