FAC API v1.0.0-beta
auditor
Fields
Field name
Type
Format
Description
audit_year
string
character varying
auditee_ein
integer
integer
auditee_uei
string
character varying
auditor_address_line_1
string
character varying
auditor_city
string
character varying
auditor_contact_title
string
character varying
auditor_country
string
character varying
auditor_ein
integer
integer
auditor_email
string
character varying
auditor_firm_name
string
character varying
auditor_foreign_addr
string
character varying
auditor_phone
integer
bigint
auditor_seq_number
integer
integer
auditor_state
string
character varying
auditor_zip
string
character varying
id
integer
bigint
Note: This is a Primary Key.<pk/>
report_id
string
character varying
cap_text
Fields
Field name
Type
Format
Description
audit_year
string
character varying
auditee_ein
integer
integer
auditee_uei
string
character varying
cap_text
string
text
charts_tables
boolean
boolean
finding_ref_number
string
character varying
fy_end_date
string
date
fy_start_date
string
date
id
integer
bigint
Note: This is a Primary Key.<pk/>
report_id
string
character varying
federal_award
Fields
Field name
Type
Format
Description
additional_award_identification
string
character varying
amount_expended
integer
bigint
audit_year
string
character varying
auditee_ein
integer
integer
auditee_uei
string
character varying
award_seq_number
integer
integer
cluster_name
string
character varying
cluster_total
integer
bigint
federal_agency_prefix
string
character varying
federal_award_extension
string
character varying
federal_program_name
string
character varying
federal_program_total
integer
bigint
findings_count
integer
integer
fy_end_date
string
date
fy_start_date
string
date
id
integer
bigint
Note: This is a Primary Key.<pk/>
is_direct
boolean
boolean
is_loan
boolean
boolean
is_major
boolean
boolean
loan_balance_at_audit_period_end
string
character varying
mp_audit_report_type
string
character varying
other_cluster_name
string
character varying
passthrough_amount
integer
bigint
passthrough_award
boolean
boolean
report_id
string
character varying
state_cluster_name
string
character varying
type_requirement
string
character varying
finding
Fields
Field name
Type
Format
Description
audit_year
string
character varying
auditee_ein
integer
integer
auditee_uei
string
character varying
award_seq_number
integer
integer
federal_agency_prefix
string
character varying
federal_award_extension
string
character varying
finding_ref_number
string
character varying
finding_seq_number
integer
integer
fy_end_date
string
date
fy_start_date
string
date
id
integer
bigint
Note: This is a Primary Key.<pk/>
is_material_weakness
boolean
boolean
is_significant_deficiency
boolean
boolean
modified_opinion
boolean
boolean
other_findings
boolean
boolean
other_non_compliance
boolean
boolean
prior_finding_ref_numbers
string
character varying
questioned_costs
boolean
boolean
repeat_finding
boolean
boolean
report_id
string
character varying
type_requirement
string
character varying
finding_text
Fields
Field name
Type
Format
Description
audit_year
string
character varying
auditee_ein
integer
integer
auditee_uei
string
character varying
charts_tables
boolean
boolean
finding_ref_number
string
character varying
finding_text
string
text
fy_end_date
string
date
fy_start_date
string
date
id
integer
bigint
Note: This is a Primary Key.<pk/>
report_id
string
character varying
general
Fields
Field name
Type
Format
Description
audit_period_covered
string
character varying
audit_type
string
character varying
audit_year
string
character varying
auditee_addl_duns_list
array
character varying[]
auditee_addl_ein_list
array
integer[]
auditee_addl_uei_list
array
character varying[]
auditee_address_line_1
string
character varying
auditee_certified_date
string
date
auditee_certify_name
string
character varying
auditee_certify_title
string
character varying
auditee_city
string
character varying
auditee_contact_name
string
character varying
auditee_contact_title
string
character varying
auditee_duns
array
character varying[]
auditee_ein
integer
integer
auditee_email
string
character varying
auditee_name
string
character varying
auditee_phone
integer
bigint
auditee_state
string
character varying
auditee_uei
string
character varying
auditee_zip
string
character varying
auditor_address_line_1
string
character varying
auditor_certified_date
string
date
auditor_city
string
character varying
auditor_contact_name
string
character varying
auditor_contact_title
string
character varying
auditor_country
string
character varying
auditor_ein
integer
integer
auditor_email
string
character varying
auditor_firm_name
string
character varying
auditor_foreign_addr
string
character varying
auditor_phone
integer
bigint
auditor_state
string
character varying
auditor_zip
string
character varying
cfac_report_id
string
character varying
cfac_version
string
character varying
cognizant_agency
string
character varying
condition_or_deficiency_major_program
boolean
boolean
create_date
string
timestamp with time zone
current_or_former_findings
boolean
boolean
data_source
string
character varying
date_published
string
date
date_received
string
date
dbkey
string
character varying
dollar_threshold
number
double precision
ein_subcode
integer
integer
entity_type
string
character varying
fac_accepted_date
string
date
federal_agency_prefix
string
character varying
federal_award_extension
string
character varying
form_date_received
string
date
fy_end_date
string
date
fy_start_date
string
date
hist_auditee_address_line_2
string
character varying
hist_auditee_fax
integer
bigint
hist_auditor_address_line_2
string
character varying
hist_auditor_fax
integer
bigint
hist_completed_date
string
date
hist_component_date_received
string
date
hist_previous_completed_on
string
date
hist_previous_date_published
string
date
hist_reportable_condition
boolean
boolean
hist_type_of_entity
string
character varying
id
integer
bigint
Note: This is a Primary Key.<pk/>
initial_date_received
string
date
is_duplicate_reports
boolean
boolean
is_going_concern
boolean
boolean
is_low_risk
boolean
boolean
is_material_noncompliance
boolean
boolean
is_material_weakness
boolean
boolean
is_public
boolean
boolean
is_significant_deficiency
boolean
boolean
is_special_framework_required
boolean
boolean
material_weakness
boolean
boolean
material_weakness_major_program
boolean
boolean
modified_date
string
timestamp with time zone
multiple_auditors
boolean
boolean
multiple_duns
boolean
boolean
multiple_ein
boolean
boolean
multiple_uei
boolean
boolean
number_months
integer
integer
oversight_agency
integer
integer
pdf_url
array
character varying[]
prior_year_schedule
boolean
boolean
questioned_costs
boolean
boolean
report_id
string
character varying
report_required
boolean
boolean
special_framework
string
character varying
suppression_code
string
character varying
total_fed_expenditures
integer
bigint
type_audit_code
string
character varying
type_report_financial_statements
string
character varying
type_report_major_program
string
character varying
type_report_special_purpose_framework
string
character varying
note
Fields
Field name
Type
Format
Description
audit_year
string
character varying
auditee_ein
integer
integer
auditee_uei
string
character varying
content
string
text
fy_end_date
string
date
fy_start_date
string
date
id
integer
bigint
Note: This is a Primary Key.<pk/>
note_index
integer
integer
note_seq_number
integer
integer
note_title
string
character varying
report_id
string
character varying
type_id
string
character varying