FY22_SC_READ_ME.txt

Small Business Goaling FY-2022 Data Request:

FY22_SC.zip	- Is an encrypted, compressed file that Contains the following FY22_SC.CSV file
Password will be shared in a separate email

FY22_SC.csv	-	This file Provides Computed data for Small Business Goaling eligible contracts for FY 2021 (With calculated metric values and Standard/Single Credit calculations for certain categories of Small Business Dollars).
	
Delimiter used : '^'

Data as of February 22, 2023 11:59:59 PM

Total Number of rows in the file: 6088454	
Total Number of Actions: 83409554	
Total Dollars Obligated: $ 607120809279.61

Column names included in FY22_SC.csv file are indicated below in the table creation script:


CREATE TABLE "fy22_sc_final"
(
   award_or_idv varchar(5),
   a76_action varchar(1),
   agency_code varchar(4),
   piid_agency_name varchar(86),
   alternative_advertising varchar(3),
   aistatus varchar(1),
   ai_status_desc char(5),
   aitype varchar(1),
   award_idv_type_description varchar(27),
   ccr_exception_type char(1),
   claimant_program_code varchar(3),
   claimant_program_description varchar(60),
   co_bus_size_determination varchar(25),
   commercial_item_acquisition varchar(1),
   commercial_item_test_program varchar(10),
   citp_desc varchar(3),
   contingency_ops varchar(1),
   bundled_contract_exception varchar(1),
   contract_financing varchar(4),
   contract_for_foreign_entity varchar(1),
   contracting_agency_id varchar(4),
   contracting_agency_name varchar(86),
   contracting_department_id varchar(10),
   contracting_department_name varchar(86),
   contracting_office_id varchar(6),
   contracting_office_name varchar(150),
   region_code varchar(20),
   cost_acct_standards varchar(1),
   cost_or_pricing_data varchar(21),
   country_of_origin varchar(3),
   award_country_name varchar(45),
   completion_date timestamp,
   current_contract_value numeric(37,2),
   date_signed timestamp,
   description_of_requirement varchar(4500),
   dollars_obligated numeric(37,2),
   dollars_obligated_per_action numeric(15,2),
   economy_act varchar(3),
   effective_date timestamp,
   use_of_epa_products varchar(3),
   email_address varchar(64),
   evaluated_preference varchar(6),
   extent_competed varchar(3),
   fee_paid_for_use_of_service numeric(37,2),
   fee_range_lower_value numeric(37,2),
   fee_range_upper_value numeric(37,2),
   fixed_fee_value numeric(37,2),
   funding_agency_id varchar(4),
   funding_agency_name varchar(102),
   funding_office_id varchar(6),
   funding_office_name varchar(150),
   funding_department_id char(10),
   funding_department_name varchar(96),
   idv_last_date timestamp,
   it_commercial_item_category varchar(3),
   last_modified_by varchar(50),
   last_modified_date timestamp,
   letter_contract varchar(1),
   major_program_code varchar(105),
   place_of_perform_location_code varchar(5),
   place_of_perform_location_name varchar(28),
   place_of_perform_state_code char(2),
   pop_location_state_name varchar(35),
   feature_id char(3),
   feat_name char(3),
   pop_county_code varchar(40),
   pop_county_name varchar(25),
   feat_class char(3),
   fips_class varchar(3),
   place_of_perform_country_code char(3),
   place_of_perform_country_name varchar(45),
   place_of_perform_zip_code varchar(10),
   max_order_limit numeric(38,12),
   modification_number varchar(25),
   multiple_or_single_award_idc varchar(40),
   principal_naics_code varchar(6),
   principal_naics_description varchar(118),
   number_of_actions int,
   number_of_offers_received int,
   is_perfor_based_ser_acqu varchar(1),
   pbsc_short_description varchar(36),
   ordering_procedure varchar(1000),
   prepared_by varchar(50),
   prepared_date timestamp,
   piid varchar(50),
   pre_award_synopsis_requirement varchar(3),
   original_agency_code varchar(4),
   original_piid varchar(50),
   award_class_id int,
   is_transfered varchar(4),
   ref_idv_class_id int,
   place_of_manufacture varchar(4),
   pom_short_description varchar(109),
   price_eval_diff bigint,
   product_or_service_code varchar(4),
   product_or_service_description varchar(105),
   system_equipment_code varchar(4),
   system_equipment_desc varchar(38),
   program_acronym varchar(35),
   purchase_card_payment_method varchar(3),
   reason_for_modification varchar(1),
   reason_for_modification_desc varchar(61),
   reason_for_purchase varchar(3),
   reason_not_competed varchar(3),
   reason_not_sb varchar(3),
   reason_not_sb_desc varchar(35),
   reason_not_sdb varchar(3),
   reason_not_sdb_desc varchar(35),
   recovered_material_clauses varchar(1),
   recovered_material_cls_desc varchar(72),
   reference_agency_code varchar(4),
   reference_modification_number varchar(25),
   idv_piid varchar(50),
   reveal_date timestamp,
   research varchar(3),
   sbc_demonstration_program varchar(3),
   sea_transportation varchar(7),
   solicitation_id varchar(25),
   solicitation_procedures varchar(5),
   statry_exptn_to_fair_oprtnty varchar(4),
   subcontract_plan varchar(1),
   type_of_contract_pricing varchar(1),
   tocp_short_description varchar(91),
   type_of_fee_for_use_of_service varchar(3),
   synopsis_waiver_exception varchar(3),
   transaction_number bigint,
   type_of_idc varchar(20),
   type_of_set_aside varchar(10),
   est_ultimate_completion_date timestamp,
   ultimate_contract_value numeric(37,2),
   who_can_use varchar(206),
   uei_name varchar(126),
   vendor_uei varchar(12),
   vendor_address_line_1 varchar(115),
   vendor_address_line_2 varchar(64),
   address_line_3 varchar(40),
   vendor_address_city varchar(52),
   address_state varchar(40),
   vendor_address_state_name varchar(35),
   vendor_address_zip_code varchar(35),
   vendor_country_code varchar(3),
   vendor_address_country_name varchar(36),
   vendor_phone_number varchar(20),
   aiob_flag varchar(3),
   apaob_flag varchar(3),
   baob_flag varchar(3),
   educational_institution_flag varchar(3),
   firm_8a_flag varchar(3),
   emerging_small_business_flag varchar(3),
   very_small_business_flag varchar(3),
   federal_government_flag varchar(3),
   haob_flag varchar(3),
   hbcu_flag varchar(3),
   hospital_flag varchar(3),
   hubzone_flag varchar(3),
   selfcert_hubzone_jointventure varchar(3),
   local_government_flag varchar(3),
   minority_institution_flag varchar(3),
   minority_owned_business_flag varchar(3),
   naob_flag varchar(3),
   nonprofit_organization_flag varchar(3),
   organizational_type varchar(40),
   saaob_flag varchar(3),
   sdb_flag varchar(3),
   sheltered_workshop_flag varchar(3),
   small_business_flag varchar(3),
   srdvob_flag varchar(3),
   state_government_flag varchar(3),
   tribal_government_flag varchar(3),
   veteran_owned_flag varchar(3),
   women_owned_flag varchar(3),
   wosb_flag varchar(3),
   jvwosb_flag varchar(3),
   edwosb_flag varchar(3),
   edjvwosb_flag varchar(3),
   annual_revenue numeric(38,12),
   number_of_employees bigint,
   alaskan_native_corporation varchar(3),
   indian_tribe varchar(3),
   native_hawaiian_organization varchar(3),
   tribally_owned varchar(3),
   firm8a_joint_venture varchar(3),
   other_minority_owned varchar(3),
   community_development_corp varchar(3),
   labor_surplus_area_firm varchar(3),
   federally_funded_r_and_d_corp varchar(3),
   federal_agency varchar(3),
   city varchar(3),
   county varchar(3),
   inter_municipal varchar(3),
   local_government_owned varchar(3),
   municipality varchar(3),
   school_district varchar(3),
   township varchar(3),
   foreign_government varchar(3),
   corp_entity_not_tax_exempt varchar(3),
   corp_entity_tax_exempt varchar(3),
   partnership_or_llp varchar(3),
   sole_propreitorship varchar(3),
   small_agricultural_cooperative varchar(3),
   international_organization varchar(3),
   other varchar(3),
   architecture_and_engineering varchar(3),
   community_corp_owned_firm varchar(3),
   construction_firm varchar(3),
   domestic_shelter varchar(3),
   foundation varchar(3),
   manufacturer_of_goods varchar(3),
   research_and_development varchar(3),
   service_provider varchar(3),
   veterinary_hospital varchar(3),
   hispanic_servicing_institution varchar(3),
   contracts varchar(3),
   grants varchar(3),
   contracts_grants varchar(3),
   airport_authority varchar(3),
   council_of_governments varchar(3),
   housing_public_or_tribal varchar(3),
   interstate_entity varchar(3),
   planning_commission varchar(3),
   port_authority varchar(3),
   transit_authority varchar(3),
   subchapter_s_corporation varchar(3),
   limited_liability_corporation varchar(3),
   foreign_owned_and_located varchar(3),
   state_of_incorporation varchar(4),
   country_of_incorporation varchar(4),
   for_profit_organization varchar(3),
   other_not_for_profit_org varchar(3),
   land_grant_college_1862 varchar(3),
   land_grant_college_1890 varchar(3),
   land_grant_college_1994 varchar(3),
   private_university_or_college varchar(3),
   school_of_forestry varchar(3),
   higher_learning varchar(3),
   tribal_college varchar(3),
   veterinary_college varchar(3),
   dot_certified_disadv_bus varchar(3),
   sdb varchar(3),
   us_government_entity varchar(3),
   nhsi_flag varchar(3),
   ansi_flag varchar(3),
   congressional_district varchar(6),
   congressional_district_desc varchar(65),
   vendor_congressional_district varchar(6),
   contractor_name varchar(103),
   doing_business_as_name varchar(120),
   national_interest_code varchar(4),
   national_interest_description varchar(62),
   url_of_program varchar(200),
   other_statutory_authority varchar(940),
   extent_competed_description varchar(52),
   evaluated_preference_desc varchar(51),
   reason_not_competed_desc varchar(52),
   research_description varchar(59),
   solicitation_procedures_desc varchar(42),
   fair_oprtnty_desc varchar(53),
   type_of_set_aside_description varchar(100),
   version varchar(10),
   created_via varchar(2),
   parent_macom_code varchar(60),
   place_congressional_state_name varchar(35),
   department varchar(8),
   agency varchar(8),
   macom_org_id varchar(8),
   macom_org_code varchar(20),
   macom_org_name varchar(44),
   subcom1_org_id varchar(8),
   subcom1_org_code varchar(20),
   subcom1_org_name varchar(50),
   subcom2_org_id varchar(8),
   subcom2_org_code varchar(20),
   subcom2_org_name varchar(50),
   subcom3_org_id varchar(8),
   subcom3_org_code varchar(20),
   subcom3_org_name varchar(37),
   subcom4_org_id varchar(8),
   subcom4_org_code varchar(20),
   subcom4_org_name varchar(20),
   hierarchy_start_date timestamp,
   hierarchy_end_date timestamp,
   id_hierarchy varchar(64),
   code_hierarchy varchar(71),
   foreign_funding_desc varchar(21),
   mfg_organization_type varchar(1),
   mfg_organization_type_desc varchar(51),
   undefinitized_action_desc varchar(26),
   multiyear_contract varchar(1),
   multiyear_contract_desc varchar(3),
   cas_clause_desc varchar(30),
   pcard_as_payment varchar(3),
   pcard_as_payment_desc varchar(3),
   clinger_cohen_plan_compliance varchar(1),
   clinger_cohen_act_desc varchar(3),
   walsh_healey_act varchar(1),
   walsh_healey_act_desc varchar(14),
   service_contract_act varchar(1),
   service_contract_act_desc varchar(14),
   davis_bacon_act varchar(1),
   davis_bacon_act_desc varchar(14),
   contracting_authority varchar(1),
   contracting_authority_desc varchar(25),
   gfe_gfp varchar(1),
   gfe_gfp_desc varchar(32),
   consolidated_contract varchar(1),
   consolidated_contract_desc varchar(56),
   fed_biz_opps varchar(1),
   fed_biz_opps_desc varchar(14),
   a76_desc varchar(3),
   commercial_item_acquistn_desc varchar(100),
   local_area_set_aside varchar(4),
   lasa_description varchar(3),
   agency_identifier varchar(15),
   main_account_code varchar(15),
   sub_account_code varchar(15),
   initiative varchar(38),
   fiscal_year varchar(4),
   non_government_value numeric(37,2),
   ngc_participation varchar(3),
   ngc_participation_desc varchar(42),
   type_of_agreement varchar(10),
   idv_contract_type varchar(1),
   idv_type_description varchar(21),
   idv_mul_or_single_award_idc varchar(3),
   idv_subcontract_plan varchar(1),
   idv_subcontract_plan_desc varchar(100),
   idv_naics varchar(6),
   idv_naics_desc varchar(118),
   idv_co_bus_size varchar(1),
   idv_co_bus_size_desc varchar(100),
   idv_who_can_use varchar(206),
   idv_who_can_use_desc varchar(100),
   idv_major_program_code varchar(300),
   idv_contract_bundling varchar(1),
   idv_contract_bundling_desc varchar(100),
   idv_type_of_contract varchar(1),
   idv_type_of_contract_desc varchar(1000),
   idv_type_of_idc varchar(20),
   idv_type_of_idc_desc varchar(1000),
   idv_program_acronym varchar(75),
   idv_contracting_agency_id varchar(4),
   idv_contracting_agency_name varchar(69),
   idv_department_id varchar(10),
   idv_department_name varchar(69),
   idv_ref_idv_agency_code varchar(4),
   idv_ref_idv_piid varchar(50),
   idv_part8_or_part13 varchar(6),
   idv_type_of_set_aside varchar(10),
   idv_type_of_set_aside_desc varchar(100),
   idv_extent_competed varchar(3),
   idv_extent_competed_desc varchar(255),
   idv_solicitation_procedures varchar(5),
   idv_solicitation_proc_desc varchar(100),
   idv_evaluated_preference varchar(6),
   idv_evaluated_pref_desc varchar(100),
   idv_fair_opportunity varchar(4),
   idv_fair_opportunity_desc varchar(100),
   idv_reason_not_competed varchar(3),
   idv_reason_not_com_desc varchar(255),
   idv_local_area_set_aside varchar(4),
   idv_lasa_description varchar(3),
   idv_psc_code varchar(4),
   idv_psc_desc varchar(100),
   idv_signed_date timestamp,
   idv_effective_date timestamp,
   idv_last_date_to_order timestamp,
   idv_number_of_offers int,
   idv_ciap varchar(3),
   idv_ciap_desc varchar(100),
   idv_citp varchar(10),
   idv_solicitation_id varchar(25),
   idv_fiscal_year varchar(4),
   idv_mul_or_single_comp varchar(3),
   part8_or_part13 varchar(6),
   award_fiscal_year varchar(4),
   clod_date timestamp,
   post_clod_mod varchar(3),
   v14_part8_bpa_or_call varchar(3),
   ultimate_uei varchar(12),
   ultimate_uei_name varchar(130),
   global_st_add_1 varchar(132),
   global_st_add_2 varchar(64),
   global_city varchar(35),
   global_postal_code varchar(35),
   global_country_code varchar(3),
   global_state_code varchar(20),
   total_sb_act_eligible_actions int,
   total_sb_act_eligible_dollars numeric(37,2),
   small_business_actions int,
   small_business_dollars numeric(37,2),
   sdb_actions int,
   sdb_dollars numeric(37,2),
   eight_a_procedure_actions int,
   eight_a_procedure_dollars numeric(37,2),
   vosb_actions int,
   vosb_dollars numeric(37,2),
   srdvob_actions int,
   srdvob_dollars numeric(37,2),
   wosb_actions int,
   wosb_dollars numeric(37,2),
   cer_hubzone_sb_actions int,
   cer_hubzone_sb_dollars numeric(37,2),
   sb_set_aside_total_actions int,
   sb_set_aside_total_dollars numeric(37,2),
   sb_set_aside_part_actions int,
   sb_set_aside_part_dollars numeric(37,2),
   reserved_sb_actions int,
   reserved_sb_dollars numeric(37,2),
   no_sb_set_aside_actions int,
   no_sb_set_aside_dollars numeric(38,2),
   eight_a_competed_actions int,
   eight_a_competed_dollars numeric(37,2),
   eight_a_sole_source_actions int,
   eight_a_sole_source_dollars numeric(37,2),
   eight_a_with_hubzone_actions int,
   eight_a_with_hubzone_dollars numeric(37,2),
   hbcu_mi_set_aside_tactions int,
   hbcu_mi_set_aside_tdollars numeric(37,2),
   hbcu_mi_set_aside_pactions int,
   hbcu_mi_set_aside_pdollars numeric(37,2),
   hbcu_mi_vendor_type_actions int,
   hbcu_mi_vendor_type_dollars numeric(37,2),
   hubzone_set_aside_actions int,
   hubzone_set_aside_dollars numeric(37,2),
   hubzone_sole_source_actions int,
   hubzone_sole_source_dollars numeric(37,2),
   hubzone_vendor_type_actions int,
   hubzone_vendor_type_dollars numeric(37,2),
   sdvosbc_actions int,
   sdvosbc_dollars numeric(37,2),
   sdvosbs_actions int,
   sdvosbs_dollars numeric(37,2),
   srdvob_vendor_type_actions int,
   srdvob_vendor_type_dollars numeric(37,2),
   esb_actions int,
   esb_dollars numeric(37,2),
   esb_vendor_type_actions int,
   esb_vendor_type_dollars numeric(37,2),
   buy_indian_actions int,
   buy_indian_dollars numeric(37,2),
   buy_indian_vendor_type_actions int,
   buy_indian_vendor_type_dollars numeric(37,2),
   product_or_service_type varchar(1),
   inherently_governmental_code varchar(10),
   inherently_governmental_desc varchar(37),
   cage_code varchar(5),
   base_date_signed timestamp,
   closed_by varchar(50),
   closed_date timestamp,
   closed_status varchar(1),
   total_estimated_order_value numeric(37,2)
)
;