FAQ

FAQ Categories

Account

Customize Your View

Data Errors

Data Sources

Donations

Federal

Federal Campaign Cash

Graphing

How To

Home Page

Information

Mobile App

My Reports

Popular Reports

Privacy Policy

Searching

Sorting

Workers Compensation

Questions And Answers

Account

How do I retrieve my Password?

Lost your password? Please fill in your username. Note that it is necessary that username be specified exactly as when you have subscribed https://www.openthebooks.com/members/forgot/

back to top

Customize Your View

What is Customize Your View?

Customize Your View will allow you to add or delete columns in the grid. Also, it will allow you to save a customized view for youself to be used at a later time.

back to top

Why can't I edit a Popular View?

Popular views are "public" views which are provided by the administrator which are utilized across the application. These views are read only. If you wish to modify any popular view you can edit any of them and then select "Copy Layout" which will allow you to modify the display columns.

back to top

Data Errors

What can I do if there is an error in my record?

The information on this website is provided by your government employer which is compiled and submitted annually. If you find an error in your record, you should contact your government employer and request that your information be corrected. This is not base salary, but pensionable earnings which can be different then base salary. Pensionable earnings are earned and reported in a given year.

 

 

back to top

Data Sources

Where does this data come from?

The material on this website comes from a number of souces and was obtained under the Freedom of Information Act which includes: U.S. Office of Management and USPS.

back to top

Donations

Are Donations Tax Deductible?

Donations to Open The Books, a project of American Transparency- 501(c)3 non-profit, non-partisan, charitable organization- are tax deductible for federal or state income tax purposes.

back to top

How to turn off the Donate Message on View Results?

The Donate message can be turned off for 90 days when a donation is processed. Donations will help us continue to "Open the Books".

back to top

Can I mail my Donation?

You can mail us your donation.
 
American Transparency
200 S. Frontage Rd, Sute 304, Burr Ridge
IL 60527
 

back to top

Federal

Are any federal employees excluded?

The federal employee data excludes the military, departments of Defense and Treasury, FBI, CIA, White House, Congress, independent commissions and independent agencies. Overtime has been excluded.

back to top

What are the Federal Data Definitions?

3.1 Recipient Information

This section shows information about the recipient of the award; such as the name, location and type of the recipient.

Data Feed field name

Description

recipient_name

The name of the recipient of the award.

recipient_city_code

The five-digit FIPS city code for the city in the address of the recipient of the award.

recipient_city_name

The city in which the address of the recipient of the award is located.

recipient_county_code

The three-digit FIPS county code or ANSI INCITS county code for the county in which the address for the recipient of the award is located.

recipient_county_name

The county in which the address for the recipient of the award is located.

First two characters of
(recipient_state_code)

The two-digit FIPS or INCITS state code for the state or territory in which the address for the recipient of the award is located.

Fourth character onwards of (recipient_state_code)

The name of the state or territory in which the address for the recipient of the award is located.

recipient_zip

The Zip code in the address of the recipient of the award.

recipient_cd

The Congressional district in which the address of the recipient of the award is located. 90 indicates district not known, 00 at-large or statewide, 98 nonvoting, 99 no representative.

recip_cat_type

The original Federal Assistance Awards Data System recipient type code, modified into a set of broader categories (government, individual, nonprofit, for profit, higher ed, other).

recipient_type

The type of recipient (i.e., state government, local government, Indian tribe, individual, small business, for-profit, nonprofit, etc.)


Data Feed field name

Description

receip_addr1

Recipient 's Full address Line 1

receip_addr2

Recipient 's Full address Line 2

receip_addr3

Recipient 's Full address Line 3

duns_no

Unique nine-digit number issued by Dun & Bradstreet to the Agency. Followed by optional DUNS Plus 4 which allows an agency to submit different bank account data for a single DUNS (Assigned by Dun & Bradstreet).

duns_conf_code

Optional data field to enter the D&B Confidence Code received for validated DUNS data (As provided to agencies by Dun & Bradstreet when obtaining DUNS). OMB encourages Agencies to submit this code with their file submissions to affirm the accuracy of data validated through the D&B process.

recipient_country_code

The ISO or FIPS code for the country in which the recipient of the award is located.


3.2 Project and Award Information

This section shows information about the agency that granted the award, under what governmental program, and provides some ID numbers for the award.

Data Feed field name

Description

maj_agency_cat

The combination of two leftmost characters of the contracting agency code representing major federal organizations and departments and its description.

agency_code

A code indicating which governmental agency or bureau provided the award.

agency_name

The name of the governmental agency or bureau that provided the award.

federal_award_id

An agency-specific unique ID number for each individual assistance award. There may be more than one action record per assistance award, because of continuations, revisions, funding adjustments, corrections, etc.

federal_award_mod

A modification number used to indicate action records that modify a previous action record with the same federal award ID.

sai_number

A number assigned by state (as opposed to federal) review agencies to the award during the grant application process.

cfda_program_num

The numeric code that indicates the program under which this award was funded within the Catalog of Federal Domestic Assistance (CFDA). Numbers that contain AAA, AAB etc. are pseudo-codes and are not in CFDA.

cfda_program_title

The title of the program under which the award was funded, taken from the Catalog of Federal Domestic Assistance (CFDA).

assistance_type

The original Federal Assistance Awards Data System assistance type code, modified into a set of broader categories (direct grants, loans, insurance, etc.)

asst_cat_type

The type of assistance provided by the award: whether it is a grant, cooperative agreement, direct payment, loan, insurance, etc.


Data Feed field name

Description

project_description

The description of the project grants, loans, direct payments, insurance or other categories of grants.

progsrc_agen_code

Agency Code part (First 2 characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury.

progsrc_acnt_code

Account Code part (3rd to 6th characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury.

progsrc_subacnt_code

Sub-Account Code part (7th to 9th characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury.

account_title

The description of the Program Source.

rec_flag

Identifies whether the Treasury Account Symbol is for Recovery

uri

An agency defined identifier that is unique for every reported action.

unique_transaction_id

The unique identifying record id.

transaction_status

The status of the particular record, either ‘active’ or ‘inactive’.


3.3 Action

This section shows details on the action taken under the award; the amount of money granted or de-obligated, relevant dates and the type of action.

Data Feed field name

Description

fiscal_year

The fiscal year in which the award occurred. It may be different from the fiscal year of the award record if the record is a late filing or correction of an amount for a prior fiscal year.

fyq

The fiscal year and fiscal year quarter for this record, with the first four digits being the year, the fifth the quarter.

action_type

The type of action for the record: whether it is a new assistance action, a continuation, a revision, or a funding adjustment.

fed_funding_amount

Amount of federal government's obligation or contingent liability, in dollars. A negative number represents a decrease in funding.

non_fed_funding_amount

Amount of non-federal funding, in dollars. A negative number represents a decrease in funding.

total_funding_amount

The total federal plus non-federal funding amount in dollars. A negative number represents a decrease in funding.

face_loan_guran

The face value of the direct loan or loan guarantee.

orig_sub_guran

The original subsidy cost of the direct loan or loan guarantee.

obligation_action_date

Obligation or action date for the award.

starting_date

The starting date for the award.

ending_date

The ending date for the award.

record_type

Federal Assistance Awards Data System record type: 1 = county aggregate record, 2 = individual action record.


Data Feed field name

Description

correction_late_ind

Indicates that the action record is either a correction of a record from a previous quarter or a late reported record from a previous

quarter. The previous quarter is indicated in the Corrected Fiscal Year / Quarter data field.

fyq_correction

The fiscal year (first four digits) and quarter (fifth digit) of the previous fiscal year and quarter that this record corrects, or which it is a late report for.


3.4 Principal Place of Performance

This section shows information on the principal place of performance for the activity supported by the award.

Data Feed field name

Description

principal_place_code

A code for the principal place of performance for the award. The first two digits are the state FIPS code, the next five the county FIPS (three digits followed by **) or city FIPS code. 00***** = multi­state, 00FORGN = foreign country.

principal_place_state

The state or territory name of the principal place of performance for the award.

principal_place_state_code

The combination of two character state code and the state or territory name of the principal place of performance for the award.

principal_place_cc

The city or county name of the principal place of performance for the award.

principal_place_zip

The 9 digit zip code (zip+4) of the principal place of performance for the award.

principal_place_cd

The Congressional District of the principal place of performance for the award.


4 Contracts Data Feeds Data Dictionary

4.1 Amounts

This section shows dollar amounts for the award.

Data Feed field name

Description/FPDS Definition

obligatedamount

The net dollar amount that is obligated or de-obligated by this transaction. If the net is a de-obligation, the amount will be negative.

baseandexercisedoptionsvalue

The contract value for the base contract and any options that have been exercised.

baseandalloptionsvalue

It is the mutually agreed upon total contract or order value including all options (if any). For Indefinite Delivery Vehicles, the estimated value for all orders expected to be placed against the vehicle. For modifications, the change (positive or negative, if any) in the mutually agreed upon total contract value.


4.2 Purchaser Information

This section shows information about the purchaser for the award, i.e. the governmental agency or agencies that made the purchase.

Data Feed field name

Description/FPDS Definition

maj_agency_cat

The combination of two leftmost characters of the contracting agency code representing major federal organizations and departments and its description .

contractingofficeagencyid

A code for the governmental agency or bureau that executed or is otherwise responsible for the transaction.

contractingofficeid

The agency supplied code for the contracting office that executes the transaction.

fundingrequestingofficeid

The agency provided code that identifies the office that provided the preponderance of funds. If the Funding Agency is a DoD agency, the code is the DoD Activity Address Code (DODAAC).

purchasereason

A code that indicates why a civilian agency made a purchase for DoD.

fundedbyforeignentity

Indicates that a foreign government, international organization, or foreign military organization bears some of the cost of the acquisition.

progsourceagency

Agency Code part (First 2 characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury.

progsourceaccount

Account Code part (3rd to 6th characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury.

progsourcesubacct

Sub-Account Code part (7th to 9th characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury.

account_title

The description of the Program Source.

rec_flag

Identifies whether the Treasury Account Symbol is for Recovery.

maj_fund_agency_cat

The combination of two leftmost characters of the funding agency code representing major federal organizations and departments and its description.


4.3 Contract Information

This section shows basic contract information for an award.

Data Feed field name

Description/FPDS Definition

signeddate

The date that a mutually binding agreement was reached. The date signed by the Contracting Officer or the Contractor, whichever is later.

effectivedate

The date that the parties agree will be the starting date for the contract's requirements. Usually, this is the same as the date signed, but may be different.

currentcompletiondate

The current expected or scheduled contract completion date, based on the initial schedule, any options exercised at the time of the award, and any modifications made later.

ultimatecompletiondate

The estimated or scheduled completion date including the base contract or order and all options (if any) whether the options have been exercised or not.

contractactiontype

The type of award for this record. Types of awards include Purchase Orders (PO), Delivery Orders (DO), BPA Calls and Definitive Contracts.

reasonformodification

Code for the type of modification to an award or IDV performed by this transaction.

typeofcontractpricing

The type of contract as defined in FAR Part 16 that applies to this procurement. Can be fixed price, cost plus, labor hours, etc.

lettercontract

Indicates whether the award is an Undefinitized Action.

multiyearcontract

Indicates whether this is a multi-year contract, a contract for the purchase of supplies or services for more than 1, but not more than 5, program years. Such contracts are issued under specific congressional authority for specific programs.

typeofidc

Identifies whether the IDC or Multi-Agency Contract is Indefinite Delivery/Requirements, Indefinite Delivery/Indefinite Quantity, or Indefinite Delivery/Definite Quantity.


Data Feed field name

Description/FPDS Definition

multipleorsingleawardidc

Indicates whether the contract is one of many that resulted from a single solicitation, all of the contracts are for the same or similar items, and contracting officers are required to compare their requirements with the offerings under more

than one contract or are required to acquire the requirement competitively among the awardees. BPA "Multiple or Single Award IDV" value does not pull the "Multiple or Single Award IDV" value of the referenced FSS to the BPA. The "Multiple or Single Award IDV" value shall be required and selected by the user for all BPA bases created.

programacronym

The short name or title used for a GWAC or other contracting program. Examples include COMMITS, ITOPS, SEWP.

performancebasedservicecont ract

Indicates whether the contract is a Performance-Based Service Acquisition (PBSA) as defined by FAR 37.601. A PBSA describes the requirements in terms of results rather than the methods of performance of the work and has other detailed requirements.

majorprogramcode

The agency determined code for a major program within the agency. For an Indefinite Delivery Vehicle, this may be the name of a GWAC (e.g., ITOPS or COMMITS).

contingencyhumanitarianpeac ekeepingoperation

Indicates contract actions that exceed $200,000 and support a contingency operation, a humanitarian operation, or a peacekeeping operation.

costorpricingdata

Indicates whether cost or pricing data was obtained, not obtained, or waived for DoD assigned contracts.

contractfinancing

Type of financing used to effect payment (progress payments, advance payments, etc.).

costaccountingstandardsclaus e

Indicates whether the contract includes a Cost Accounting Standards clause.

descriptionofcontractrequire ment

A brief description of the goods or services bought (for an award) or that are available (for an IDV).


Data Feed field name

Description/FPDS Definition

purchasecardaspaymentmeth od

Indicates whether the method of payment under an award is the Purchase Card. Agencies may issue formal contract documents and make payment using the Purchase Card. It is also permitted that agencies may report Purchase Card purchases.

numberofactions

The number of actions that involved contract modifications for additional supplies or services. Can be reported for new contracts or contract modification transactions.


4.4 Contractor Information

This section shows basic information about the contractor/vendor for an award, such as its name, address, parent and contact information.

Data Feed field name

Description/FPDS Definition

vendorname

The name of the vendor awarded the contract as it appears in CCR or as entered by the user if CCR exception is selected.

vendordoingasbusinessname

The doing as business name of the contractor address.

streetaddress

The first line of the street address for the contractor.

streetaddress2

The second line of the street address for the contractor.

streetaddress3

The third line of the street address for the contractor.

city

The city of the contractor address.

State

The state in the contractor address.

zipcode

The zip code in the contractor address.

vendorcountrycode

The country code in the contractor address.

congressionaldistrict

The Congressional district of the contractor, as derived from the Zip+4 in the contractor address.

dunsnumber

The Dun & Bradstreet number of the vendor. This is used to link records to the Central Contractor Registry (CCR) and only exists for vendors in the CCR.

phoneno

The phone number of the contractor.

faxno

The fax number of the contractor.

mod_parent

The parent company for the vendor, as provided by D&B.

vendor_cd

The combination of the Congressional district code and description of the contractor, as derived from the Zip+4 in the contractor address.

vendor_state_code

The two character state code in the contractor address


4.5 Principal Place of Performance

This section shows the principal place of performance of the award; the place where most of the work was done.

Data Feed field name

Description/FPDS Definition

locationcode

The code from the combined FIPS Pub. 10 and FIPS Pub. 55 that identifies the place where the work is being performed.

statecode

The U.S. state that is the principal place where the work was / is performed.

placeofperformancecountryco de

The country that is the principal place where the work was / is performed.

placeofperformancezipcode

The Zip code of the principal place where the work was / is performed. Data field exists only in XML schema version 1.2 and later.

placeofperformancecongressi onaldistrict

The Congressional district that is the principal place in which the work was / is performed.

pop_cd

The combination of the Congressional district code and description for the principal place in which the work was / is performed.

pop_state_code

The two character state code for the principal place where the work was / is performed.


4.6 Product or Service Information

This section shows information about the product or service purchased by the award.

Data Feed field name

Description/FPDS Definition

psc_cat

The major category that the Federal Procurement Data System Product or Service Code for the record falls within (see page 12 of http://www.fpdsng.com/downloads/service_product_codes.pdf).

productorservicecode

The code that best identifies the product or service procured. If more than one code applies, then the code that represents most of the ultimate contract value is reported.

systemequipmentcode

Two codes that identify the program and weapons system or equipment purchased by a DoD agency. The first character is a number 1-4 that identifies the DoD component. The last 3 characters identify that component's program, system, or equipment.

claimantprogramcode

A claimant program number designates a grouping of supplies, construction, or other services. This data field may have a code from the DoD Procurement Coding Manual Section III, DoD Claimant Program Number.

principalnaicscode

The principal North American Industry Classification System (NAICS) code (used to designate major sectors of the economies of Mexico, Canada, and the United States) that indicates the industry in which the contractor does business.

informationtechnologycomme rcialitemcategory

A code that designates the commercial availability of an information technology product or service.

gfe_gfp

Indicates whether Government Furnished Equipment (GFE) or Government Furnished Property (GFP) used for the contract, pursuant to FAR 45.

useofepadesignatedproducts

Indicates whether EPA approved products with a minimum recovered material content were used, or whether an exception was made.

recoveredmaterialclauses

Indicates whether Recovered Material Certification and/or Estimate of Percentage of Recovered Material Content for EPA-Designated Products clauses were included in the contract.


Data Feed field name

Description/FPDS Definition

seatransportation

Indicates whether the contractor anticipates that some of the supplies may be transported by sea.

contractbundling

Indicates that the value of the contract, including all options, is expected to exceed $5M as a result of consolidating separate small contracts into a single contract likely to be unsuitable for a small business concern, and the reason for bundling.

consolidatedcontract

Indicates whether the contract is a consolidated contract. This is only required if the Funding Agency or the contracting agency is a DoD Agency. Data field exists in XML schema version 1.2 and later only.

countryoforigin

Identifies the country of origin of the product.

placeofmanufacture

Represents whether the end products procured by the contract are manufactured inside or outside the U.S. in accordance with the Buy American Act (see FAR 25.1) and any exceptions or reasons for waivers employed.


4.7 Record Information

This section shows information about a Federal Procurement Data System award record, such as its identifying IDs, which IDV it links to and its fiscal year.

Data Feed field name

Description/FPDS Definition

contractingofficeagencyid

Identifier used to link agency in FPDS-NG to award information.

piid

The unique identifier for each contract, agreement or order.

modnumber

An identifier that uniquely identifies a modification for a contract, agreement, or order.

transactionnumber

Unique identifier for each transaction for a contracting action or modification. There can be more than one in situations such as when an action includes more than one contract type.

fiscal_year

The federal government fiscal year (starting October 1), determined by the "Signed Date" provided by FPDS.

idvagencyid

This is a code for an agency, but it does not necessarily represent the agency that issued the contract. Instead, it serves as part of the unique identification for Federal Procurement Data System IDV records. For awards records, it partially identifies a linked IDV record.

idvpiid

When reporting orders under Indefinite Delivery Vehicles (IDV) such as a GWAC, IDC, FSS, BOA, or BPA, report the Procurement Instrument Identifier (Contract Number or Agreement Number) of the IDV. For the initial load of a BPA under a FSS, this is the FSS contract number. Note: BOAs and BPAs are with industry and not with other Federal Agencies.

idvmodificationnumber

For IDV records, uniquely identifies the modification of the contract, agreement, or order. For awards records, it partially identifies a linked IDV record.

solicitationid

Identifier used to link transactions to solicitation information.

unique_transaction_id

The unique identifying record id.

transaction_status

The status of the particular record, either ‘active’ or ‘inactive’.


4.8 Competition Information

This section shows information on how an award was procured.

Data Feed field name

Description/FPDS Definition

extentcompeted

A code that represents how the contract was competed.

reasonnotcompeted

A code for the reason the contract was not competed -- i.e., solicitation procedures other than full and open competition pursuant to FAR 6.3.

numberofoffersreceived

The number of actual offers/bids received in response to the solicitation.

commercialitemacquisitionpr ocedures

Indicates whether the solicitation used the special requirements for the acquisition of commercial items intended to more closely resemble those customarily used in the commercial marketplace as defined by FAR Part 12.

commercialitemtestprogram

Indicates whether the solicitation used Commercial Item Acquisition Procedures (FAR Part 12) and Simplified Acquisition Procedures (FAR Part 13.5) for acquisitions above the Simplified Acquisition Threshold and below $5,000,000.

smallbusinesscompetitivenes sdemonstrationprogram

Indicates whether the contract was awarded to a U.S. business concern as a result of a solicitation issued on or after Jan 1, 1989 as part of the Small Business Competitiveness Program (FAR Part 19.10).

a76action

Indicates whether the contract action resulted from an A-76/Fair Act competitive sourcing process.

solicitationprocedures

A code for the type of solicitation procedures used. Data field exists only in XML schema version 1.2 and later.

typeofsetaside

A code for the type of set aside determined for the contract action. Data field exists only in XML schema version 1.2 and later.

evaluatedpreference

The type of preference determined for the contract action, reported when a contract was made pursuant to the socioeconomic program price evaluation preferences -- FAR 19.11 and FAR 19.13. Data field exists only in XML schema version 1.2 and later.


Data Feed field name

Description/FPDS Definition

research

A code used when the contract was awarded as part of a Small Business Innovation Research or Small Technology Transfer Research Program. Data field exists only in XML schema version 1.2 and later.

statutoryexceptiontofairoppo rtunity

A code indicating a statutory exception to Fair Opportunity, used awarding a non competitive task order or delivery order exceeding $2500.00 against an IDIQ contract. Data field exists only in XML schema version 1.2 and later.


4.9 Contractor Characteristics

This section shows characteristics of the contractor for an award; such as its size, its type, and a set of flags showing whether it is in various special categories.

Data Feed field name

Description/FPDS Definition

organizationaltype

A code for the type of organization of the vendor.

numberofemployees

The contractor's business size in terms of number of employees. Usually obtained from the CCR (Central Contractor Registry).

annualrevenue

The contractor's annual gross revenue, taken from an average of the last three years. Usually obtained from the CCR (Central Contractor Registry).

firm8aflag

Indicates whether the vendor is an 8(a) Program Participant Organization.

hubzoneflag

Indicates whether the vendor is a Historically Underutilized Business Zone (HUBZone) Firm.

issbacertifiedsmalldisadvantaged business

Indicates whether the vendor is a Small Disadvantaged Business Organization.

shelteredworkshopflag

Indicates whether the vendor is a Sheltered Workshop (JWOD Provider) Organization.

hbcuflag

Indicates whether the vendor is a Historically Black College or University.

educationalinstitutionflag

Indicates whether the vendor is an Educational Institution.

womenownedflag

Indicates whether the vendor is a Woman Owned Business.

veteranownedflag

Indicates whether the vendor is a Veteran Owned Business.

srdvobflag

Indicates whether the vendor is a Service-Related Disabled Veteran Owned Business.

localgovernmentflag

Indicates whether the vendor is a Local Government Organization.

minorityinstitutionflag

Indicates whether the vendor is a Minority Institution.


Data Feed field name

Description/FPDS Definition

aiobflag

Indicates whether the vendor is an American Indian Owned Business.

stategovernmentflag

Indicates whether the vendor is a State Government Organization.

federalgovernmentflag

Indicates whether the vendor is a Federal Government Organization.

minorityownedbusinessflag

Indicates whether the vendor is a Minority Owned Business.

apaobflag

Indicates whether the vendor is an Asian-Pacific American Owned Business.

tribalgovernmentflag

Indicates whether the vendor is a Tribal Government Organization.

baobflag

Indicates whether the vendor is a Black American Owned Business.

naobflag

Indicates whether the vendor is a Native American Owned Business.

saaobflag

Indicates whether the vendor is a Subcontinent Asian (Asian-Indian) American Owned Business.

nonprofitorganizationflag

Indicates whether the vendor is a Nonprofit Organization.

haobflag

Indicates whether the vendor is a Hispanic American Owned Business.

verysmallbusinessflag

Indicates whether the vendor is an Emerging Small Business.

hospitalflag

Indicates whether the vendor is a Hospital.

isindiantribe

Indicates whether the vendor is an Indian Tribe

isnativehawaiianownedorganizati onorfirm

Indicates whether the vendor is a Native Hawaiian Owned Organization Or Firm.

istriballyownedfirm

Indicates whether the vendor is a Tribally Owned Firm.

contractingofficerbusinesssizedet ermination

The Contracting Officer's determination of whether the selected contractor meets the small business size standard for award to a small business for the NAICS code that is applicable to the contract.


Data Feed field name

Description/FPDS Definition

sdbflag

Indicates whether the vendor is a Self-Certified Small Disadvantaged Business Organization.

is1862landgrantcollege

Indicates whether the vendor is a 1862 Land Grant College.

is1890landgrantcollege

Indicates whether the vendor is a 1890 Land Grant College.

is1994landgrantcollege

Indicates whether the vendor is a 1994 Land Grant College.

isveterinarycollege

Indicates whether the vendor is a Veterinary College.

isothernotforprofitorganization

Indicates whether the vendor is a Other Not For Profit Organization.

isserviceprovider

Indicates whether the vendor is a Service Provider.

receivesgrants

Indicates whether the vendor receives Grants.

receivescontractsandgrants

Indicates whether the vendor receives Contracts and Grants.

isairportauthority

Indicates whether the vendor is an Airport Authority.

iscouncilofgovernments

Indicates whether the vendor is a Council of Governments.

ishousingauthoritiespublicortribal

Indicates whether the vendor is a Housing Authorities Public/Tribal.

isinterstateentity

Indicates whether the vendor is a Interstate Entity.

isplanningcommission

Indicates whether the vendor is a Planning Commission.

isportauthority

Indicates whether the vendor is a Port Authority.

istransitauthority

Indicates whether the vendor is a Transit Authority.

issubchapterscorporation

Indicates whether the vendor is a Subchapter S Corporation.

islimitedliabilitycorporation

Indicates whether the vendor is a Limited Liability Corporation.

isforeignownedandlocated

Indicates whether the vendor is Foreign Owned and Located.

interagencycontractingauthority

Indicates whether the transaction is an Economy Act or Statutory


Data Feed field name

Description/FPDS Definition

 

Authority.

isotherminorityowned

Indicates whether the vendor is a Other Minority Owned.

iscommunitydevelopedcorporati onownedfirm

Indicates whether the vendor is a Community Developed Corporation Owned Firm.

islaborsurplusareafirm

Indicates whether the vendor is a Labor Surplus Area Firm.

isfederallyfundedresearchanddev elopmentcorp

Indicates whether the vendor is a Federally Funded Research and Development Corporation.

isfederalgovernmentagency

Indicates whether the vendor is a Federal Government Agency.

iscitylocalgovernment

Indicates whether the vendor is a City Local Government.

iscountylocalgovernment

Indicates whether the vendor is a County Local Government.

isintermunicipallocalgovernment

Indicates whether the vendor is a Inter Municipal Local Government.

islocalgovernmentowned

Indicates whether the vendor is a Local Government Owned.

ismunicipalitylocalgovernment

Indicates whether the vendor is a Municipality Local Government.

isschooldistrictlocalgovernment

Indicates whether the vendor is a School District Local Government.

istownshiplocalgovernment

Indicates whether the vendor is a Township Local Government.

isforeigngovernment

Indicates whether the vendor is a Foreign Government.

iscorporateentitynottaxexempt

Indicates whether the vendor is a Corporate Entity Not Tax Exempt.

ispartnershiporlimitedliabilitypart nership

Indicates whether the vendor is a Partnership Or Limited Liability Partnership.

issolepropreitorship

Indicates whether the vendor is a Sole Proprietorship.

issmallagriculturalcooperative

Indicates whether the vendor is a Small Agricultural Cooperative.

isinternationalorganization

Indicates whether the vendor is a International Organization.


Data Feed field name

Description/FPDS Definition

isotherbusinessororganization

Indicates whether the vendor is Other Business Or Organization.

isarchitectureandengineering

Indicates whether the vendor is a Architecture And Engineering.

iscommunitydevelopmentcorpor ation

Indicates whether the vendor is a Community Development Corporation.

isconstructionfirm

Indicates whether the vendor is a Construction Firm.

isdomesticshelter

Indicates whether the vendor is a Domestic Shelter.

ccrexception

Indicates the reason a vendor/contractor not registered in the mandated CCR system may be used in a purchase

fedbizopps

Indicates whether the synopsis requirements of FAR Subpart 5.2. have been observed.

isalaskannativeownedcorporation orfirm

Indicates whether the vendor is Alaskan Native Owned Corporation or Firm

iscorporateentitytaxexempt

Indicates whether the vendor is Corporate Entity, Tax Exempt

isdotcertifieddisadvantagedbusin essenterprise

Indicates whether the vendor is DoT Certified Disadvantaged Business Enterprise

isforprofitorganization

Indicates whether the vendor is is a Profit Organization or not

isfoundation

Indicates whether the vendor is Foundation

ishispanicservicinginstitution

Indicates whether the vendor is Hispanic Servicing Institution

ismanufacturerofgoods

Indicates whether the vendor is Manufacturer of Goods

isprivateuniversityorcollege

Indicates whether the vendor is Private University or College

isschoolofforestry

Indicates whether the vendor is School of Forestry

isstatecontrolledinstitutionofhigh erlearning

Indicates whether the vendor is State Controlled Institution of Higher Learning

istribalcollege

Indicates whether the vendor is Tribal College


Data Feed field name

Description/FPDS Definition

isveterinaryhospital

Indicates whether the vendor is Veterinary Hospital

localareasetaside

When awarding emergency response contracts during the term of a major disaster or emergency declaration by the President of the United States under the authority of the Robert T. Stafford Disaster Relief and Emergency Assistance Act (42 U.S.C. 5121, et seq.), preference shall be given, to the extent feasible and practicable, to local firms. Preference may be given through a local area set-aside or an evaluation preference

manufacturingorganizationtype

Code that indicates vendor entity

nationalinterestactioncode

A code that represents the national interest for which the contract is created

priceevaluationpercentdifference

Indicates the percent difference between the award price and the lowest priced offer from a responsive, responsible non-HUBZone or non-SDB

receivescontracts

Indicates whether the vendor receives contracts

subcontractplan

Indicates whether a Subcontracting Plan was included in the contract


4.10 Legislative Mandates

This section shows whether various legislative mandates apply to the award.

Data Feed field name

Description/FPDS Definition

walshhealyact

Indicates whether the transaction is subject to the Walsh-Healy Act (passed in 1936, establishing overtime as hours worked in excess of 40 hours per week).

servicecontractact

Indicates whether the transaction is subject to the Service Contract Act (concerning payment of prevailing wage rates and fringe benefits to service employees).

davisbaconact

Indicates whether the transaction is subject to the Davis-Bacon Act (concerning the payment of prevailing wages on public works projects).

clingercohenact

Indicates the funding office has certified that the information technology purchase meets the planning requirements in 40 USC 1422 and 1423.

otherstatutoryauthority

Indicates whether the transaction is subject to other statutory authority (i.e., legislation other than the Economy Act).


back to top

Why do the Federal Loans appear large?

All information from the U.S. Department of Education including student loans is displayed exactly as reported. Yes, there are mistakes.  For example, we feel that student loan information is self-evidently wrong by at least two decimal places and possibility three decimal places. In February, a United States government spokesperson said the data is accurate as reported to usaspending.gov.  We are requesting review by the U.S. Department of Education.

back to top

Federal Campaign Cash

What are Contributions by Individuals?

The individual contributions contains each contribution from an individual to a federal committee if the contribution was at least $200.
 
Field Name  Description 
Filer Identification Number
A 9-character alpha-numeric code assigned to a
committee by the Federal Election Commission
Amendment Indicator
Indicates if the report being filed is new (N), an
amendment (A) to a previous report, or a
termination (T) report.
Report Type Indicates the type of report filed. List of report type codes
Primary-General Indicator
This code indicates the election for which the contribution
was made. EYYYY (election plus election year)
P = Primary
G = General
O = Other
C = Convention
R = Runoff
S = Special
E = Recount
Microfilm Location (YYOORRRFFFF) Indicates the physical location of the filing.
Transaction Type
Transaction types 10, 11, 15, 15C, 15E, 15I, 15T, 19,
22Y, 24I, 24T, 20Y and 21Y are included in the INDIV file.
 
For more information about transaction type codes see this list of transaction type codes
Entity Type CAN = Candidate
CCM = Candidate Committee
COM = Committee
IND = Individual (a person)
ORG = Organization (not a committee and not a person)
PAC = Political Action Committee
PTY = Party Organization
Contributor/Lender/Transfer Name  
City/Town  
State  
Zip Code  
Employer  
Occupation  
Transaction Date(MMDDYYYY)  
Transaction Amount  
Other Identification Number
For contributions from individuals this column is null.
For contributions from candidates or other committees
this column will contain that contributor's FEC ID.
Transaction ID
ONLY VALID FOR ELECTRONIC FILINGS. A unique
identifier permanently associated with each itemization
or transaction appearing in an FEC electronic file.
File Number / Report ID Unique report id
Memo Code
'X' indicates that the amount is NOT to be included in
the itemization total.
Memo Text
A description of the activity. Memo Text is available on
itemized amounts on Schedules A and B. These
transactions are included in the itemization total.
FEC Record Number Unique row ID

back to top

What are Contributions to Committees from Committees?

The contributions to committees from committees contains each contribution or independent expenditure made by a PAC, party committee, candidate committee, or other federal committee to another committee during the two-year election cycle.
 
Field Name  Description 
Filer Identification Number A 9-character alpha-numeric code assigned to a committee by the Federal Election Commission
Amendment Indicator Indicates if the report being filed is new (N), an amendment (A) to a previous report, or a termination (T) report.
Report Type Indicates the type of report filed. List of report type codes
Primary-General Indicator This code indicates the election for which the contribution was made. EYYYY (election Primary, General, Other plus election year)
Microfilm Location (YYOORRRFFFF) Indicates the physical location of the filing.
Transaction Type Transaction types 10J, 11J, 13, 15J, 15Z, 16C, 16F, 16G, 16R, 17R, 17Z, 18G, 18J, 18K, 18U, 19J, 20, 20C, 20F, 20G, 20R, 22H, 22Z, 23Y, 24A, 24C, 24E, 24F, 24G, 24H, 24K, 24N, 24P, 24R, 24U, 24Z and 29 are included in the OTH file.
 
For more information about transaction type codes see this list of transaction type codes
Entity Type CAN = Candidate
CCM = Candidate Committee
COM = Committee
IND = Individual (a person)
ORG = Organization (not a committee and not a person)
PAC = Political Action Committee
PTY = Party Organization
Contributor/Lender/Transfer Name  
City/Town  
State  
Zip Code  
Employer  
Occupation  
Transaction Date(MMDDYYYY)  
Transaction Amount  
Other Identification Number For contributions from individuals this column is null. For contributions from candidates or other committees this column will contain that contributor's FEC ID.
Transaction ID ONLY VALID FOR ELECTRONIC FILINGS. A unique identifier permanently associated with each itemization or transaction appearing in an FEC electronic file.
File Number / Report ID Unique report id
Memo Code 'X' indicates that the amount is NOT to be included in the itemization total.
Memo Text A description of the activity. Memo Text is available on itemized amounts on Schedules A and B. These transactions are included in the itemization total.
FEC Record Number Unique row ID

back to top

What are Contributions to Candidates from Committees?

The contributions to candidates from committees contains each contribution or independent expenditure made by a PAC, party committee, candidate committee, or other federal committee to a candidate during the two-year election cycle.
 
Field Name  Description 
Filer Identification Number A 9-character alpha-numeric code assigned to a committee by the Federal Election Commission
Amendment Indicator Indicates if the report being filed is new (N), an amendment (A) to a previous report, or a termination (T) report.
Report Type Indicates the type of report filed. List of report type codes
Primary-General Indicator This code indicates the election for which the contribution was made. EYYYY (election Primary, General, Other plus election year)
Microfilm Location (YYOORRRFFFF) Indicates the physical location of the filing.
Transaction Type Transaction types 24A, 24C, 24E, 24F, 24H, 24K, 24N, 24P, 24R and 24Z are included in the PAS2 file.
 
For more information about transaction type codes see this list of transaction type codes
Entity Type CAN = Candidate
CCM = Candidate Committee
COM = Committee
IND = Individual (a person)
ORG = Organization (not a committee and not a person)
PAC = Political Action Committee
PTY = Party Organization
Contributor/Lender/Transfer Name  
City/Town  
State  
Zip Code  
Employer  
Occupation  
Transaction Date(MMDDYYYY)  
Transaction Amount  
Other Identification Number For contributions from individuals this column is null. For contributions from candidates or other committees this column will contain that contributor's FEC ID.
Candidate Identification Number Candidate receiving money from the filing committee
Transaction ID ONLY VALID FOR ELECTRONIC FILINGS. A unique identifier permanently associated with each itemization or transaction appearing in an FEC electronic file.
File Number / Report ID Unique report id
Memo Code 'X' indicates that the amount is NOT to be included in the itemization total.
Memo Text A description of the activity. Memo Text is available on itemized amounts on Schedules A and B. These transactions are included in the itemization total.
FEC Record Number Unique row ID
 

back to top

Graphing

Why would the graph contain duplicate employee names from multiple employers or the same employer?

We attempted to requested distinct employee identifiers, but those requests were not granted. If when graphing an employee you find multiple names from multiple employers or the same employer in the same year this would most likely be different employees. If the years do not overlap then this would be the same employee moving between different employers. The graph would be correctly mapped approximately 97% of the time.

back to top

Why would the graph display slightly off the page?

Make sure your browser zoom is set at (100%) and the graph will display properly on the screen.

back to top

Why is the graphing not always available?

Graphing will be available only where multiple years of data exist.

back to top

How To

Do you have a "How To" Register Video Available?

 

back to top

Do you have a "How To" Search Videos Available?

 
 
 
 

back to top

Do you have a "How To" use the Mobile App Video Available?

 

back to top

Home Page

Why is the “Continue” button disabled on the home page?

The “Continue” button will only become enabled once you select a state, employee status, and area of government from the dropdowns.

back to top

Information

Why do you post this salary information?

As a public employee, your salary is paid with tax dollars, and is therefore available to the public.

back to top

Are overtime included in local police and fire employees’ annual wages?

Overtime amounts have been included in annual wages when it has been provided. To see individual employee overtime amounts customize the display using “Customize You View” option and select is from the available columns.

back to top

Are there any disclaimers?

All information published on this website has been compiled using the Freedom of Information Act. If there is an error in your employment record, please contact your government employer and we will update in the next addition. For security purposes, additions or corrections will only be updated in this manner.

back to top

Mobile App

Why is my iPhone not showing new data?

The browser cache stores the content of pages so the pages open faster the next time you visit them. If a page you open isn't showing new content, clearing the cache may help.

 

To clear the browser cache

From the Home screen, choose Settings > Safari. Tap Clear Cache.

back to top

Why is my Android phone not showing new data?

 

Clearing the cache and data of an Android app

  1. Press your device's Home button.
  2. Press your device's Menu button.
  3. Tap Settings (or System Settings).
  4. Tap Application Manager (or Apps).
  5. Scroll to find the app you want to clean up, then tap the app icon.
  6. Tap Force Stop.
  7. Tap Clear Cache. Try using the app again to see if it's working fine.
  8. Still experiencing a problem? Go through steps 1-6, and then tap Clear Data.
    • Clearing the app data will remove any custom options and settings.

back to top

My Reports

What are My Reports?

My Reports are saved searches for each Search Area.

back to top

Popular Reports

What are Popular Reports?

Popular Reports are predefined views of data available for each Search Area.

back to top

Privacy Policy

Financial Information You Choose to Provide

Donors are free to choose to make an online gift, and will have to provide credit card billing information.  Whenever this information is collected and transferred over the Internet to our secure server, it is encrypted using Secure Socket Layer (SSL) technology. SSL technology is  the industry standard security technology and is designed to protect sensitive information.  Whenever online donations are allowed, the url at https://www.openthebooks.com/donation/ will display a third party secure site seal to assure our Web site is authentic & all transactions are secured with SSL encryption.  Please make a secure online donation and the credit card information that you provide will be used only to process your gift and will not be used for any other purposes.

back to top

Searching

Why are my "View Results" not returning data?

If you’re using any "Search Criteria" input fields for example, "Name" for searching you need to select an item from the dropdown. The system does an exact match like a dropdown would do. When you start typing the top 10 available options which you need to select one item to use in your "Search Criteria". If you do not select an item from the dropdown and try searching using your own input text you’re search results will not return correctly.

back to top

How do I search for my public school teacher?

Remember, Chicago is separate from the “rest of Illinois”.  If you want a Chicago public school teacher, select “active” or “retired” from the “EMPLOYMENT STATUS” menu; then choose “CHICAGO PUBLIC SCHOOLS (CPS)” from the drop-down menu under “AREA OF GOVERNMENT”.
 
If you want to search a public school teacher “outside of Chicago”, select “active” or “retired” from the “EMPLOYMENT STATUS” menu; then select “PUBLIC SCHOOL TEACHERS” from the drop-down menu under “AREA OF GOVERNMENT”.

Narrow your search by typing the NAME OF TEACHER into the search box on the left side of screen. Wait for your computer to display the teachers name and click on the name. Further narrow your search by typing the SCHOOL DISTRICT into the search box and click on the district.  Narrow your search by selecting the year, if you just want 2010, 2009 and 2008, click to select.  To view results, click the VIEW RESULTS button.
 

back to top

How do I search for STAFF, ADMINISTRATION, or SUPERINTENDENTS in public schools?

Outside Chicago:
 
To find teachers, administration, and superintendents select “active” or “retired” from the “EMPLOYMENT STATUS” menu; then select “PUBLIC SCHOOL TEACHERS” under the drop-down menu “AREA OF GOVERNMENT”.

To find the staff (janitors, secretaries, etc) of a public school district, select “active” or “retired” from the “EMPLOYMENT STATUS” menu; then select “VILLAGE, TOWNSHIP, COUNTY, PARK, LIBRARY”under the drop-down menu “AREA OF GOVERNMENT”.  The staff of a public school district will not be found under “PUBLIC SCHOOL TEACHERS”. 
 
In Chicago:

To find active teachers, administration, and staff select “active” from the “EMPLOYMENT STATUS” menu; then select “CHICAGO PUBLIC SCHOOLS (CPS)” under the drop-down menu “AREA OF GOVERNMENT”.

To find retired staff (janitors, secretaries, etc) and administrators of a Chicago public school, select “retired” from the “EMPLOYMENT STATUS” menu; then select “CHICAGO PUBLIC SCHOOL ADMIN/STAFF” under the drop-down menu A1

back to top

Why is the City of Chicago and Cook County separate from the “rest of Illinois”?

In more ways than our website, this is a fact!  Illinois is designed this way.  The search on our website mirrors the reality of our state.

back to top

How do I search for local police and fire?

To find active police or fire employees, select “active” from the “EMPLOYMENT STATUS” menu; then select “LOCAL POLICE & FIRE” under the drop-down menu “AREA OF GOVERNMENT”. You must search by the name of the fire or police district.  If you aren’t finding it, we possibly don’t have the data in our system yet. The police and fire employees will not be found under “VILLAGE, TOWNSHIP, COUNTY, PARK, LIBRARY”.

back to top

Why do the years of data vary between different Areas of Government?

Some areas of government went from either paper or an existing system and not all the existing data has been converted and is available.

back to top

While searching why do I get see "The search tool is unavailable at the moment"?

Delete your cache and other browser data
 

You have control over your browsing data. This data includes things like your browsing and download history and saved form data. Use the "Clear browsing data" dialog to delete all your data or just a portion of your data, collected during a specific period of time.

Chrome - Delete Cache

  1. Click the Chrome menu Chrome menu on the browser toolbar.
  2. Select Tools.
  3. Select Clear browsing data.
  4. In the dialog that appears, select the checkboxes for the types of information that you want to remove.
  5. Use the menu at the top to select the amount of data that you want to delete. Select beginning of time to delete everything.
  6. Click Clear browsing data.

Internet Explorer 9 and 8 - Delete Cache

  1. Click Tools, and select Delete Browsing History
  2. Deselect Preserve Favorites website data, and select Temporary Internet files,Cookies, and History
  3. Click Delete

Internet Explorer 7 - Delete Cache

  1. From the Tools menu in the upper right, selectDelete Browsing History
  2. To delete your cache, click Delete files

    To delete your cookies, click Delete cookies

    To delete your history, click Delete history

  3. Click Close, and then click OK to exit.
 
 

back to top

Sorting

Can I sort the search results?

Clicking on any grid header will sort the search results by that column in ascending order. After clicking on a grid header an icon will appear next to that column. Clicking on the same column a second time will sort the data in descending order. Only one column is sortable at a time.

back to top

Workers Compensation

Where can I find additional details on Illinois State Worker Compensation Claims?

To find out additional details on Illinois State Worker Compensation (IWCC) claims enter the "Case ID" from the State workers Compensation Claims (IWCC) search results into the Case Docket ICWD website and more case details can be found.

 

back to top