Decode Federal Contract IDs from a tibble
tbl_decode_federal_contract_ids(
data,
id_column = "idContractAnalysis",
type = "Award",
use_future = F,
keywords = NULL,
numeric_threshold = 1,
remove_start_characters = NULL,
office_id_chars = c(1, 6),
budget_year_chars = c(7, 8),
contract_letter_char = 9,
join_office_names = T,
use_sam = F,
select_columns = c("isActive", "idCGACAgency", "nameAgencyCGAC", "isDefenseAccount",
"idOrganizationLevel", "idOrganizationSAMDepartment", "idOffice", "idOfficeFPDS",
"locationOrganization", "cityStateOrganization", "idOrganizationSAM",
"nameDepartment", "slugDepartment", "nameAgency", "nameCommandMajor",
"typeOrganization", "nameOrganization", "nameOrganizationParent", "nameCommandSub",
"idAgencyFPDS", "idOrganizationParent", "idOrganizationSAMAgency", "idOfficeAAC",
"idAddressSAM", "dateOrganizationStart", "slugCGAC",
"isSourceFPDS",
"codeAgencyOMB", "descriptionOffice", "addressStreet1Organization",
"addressStreet2Organization", "cityOrganization", "stateOrganization",
"zipcodeOrganization", "codeCountryOrganization", "hasContractAwards",
"hasContractFunding", "hasFinancialAssistanceFunding",
"hasFinancialAssistanceAwards"),
snake_names = F
)
tbl_decode_federal_contract_ids()