Section 1512 Data Standards - State, local, tribal

Item #	Descriptive Name of Data Element	Data Element - XML Tag	Definition	Type	Length	Existing Source Systems	Comment ("mandatory" means it must have a value)
ARRA-A-1	Awarding Federal agency to Which Report is Submitted (Code)	Federal Agency/Organization Unit Code	Awarding Federal agency to Which Report is Submitted (Code). code for awarding Federal agency	character	4	USASpending	mandatory not editable in federalreporting.gov Funding Agency/Organization Unit Code should crosswalk to the funding agency/agencies identified by the first two digits of the CFDANumber. Note that several agencies have the same first two digits of the CFDA number. If the Code does not match one of the Funding Agencies tied to the CFDA number, flag it.
ARRA-A-2	Awarding Federal agency to Which Report is Submitted	FundingAgencyName	Awarding Federal agency to Which Report is Submitted. the name of the awarding Federal agency identified in the award document or otherwise instructed by the agency	string	55	eSRS USASpending FPDS CFDA	mandatory not editable in federalreporting.gov
ARRA-A-3	Program Source/Treasury Account Symbol: Agency Code	AgencyTAS	Program Source/Treasury Account Symbol: Agency Code	string	2	FPDS USASpending	mandatory not editable in federalreporting.gov
ARRA-A-4	Program Source/Treasury Account Symbol: Account Code	AccountTAS	Program Source/Treasury Account Symbol: Account Code	string	4	FPDS USASpending	mandatory not editable in federalreporting.gov
ARRA-A-5	Program Source/Treasury Account Symbol; Sub-Account Code (OPTIONAL)	SubAccountTAS	Program Source/Treasury Account Symbol; Sub-Account Code	string	3	FPDS USASpending	optional not editable in federal reporting.gov
ARRA-B	Federal Award Identifier Number/Federal Grant or Other Identifying Number Assigned by the awarding Federal agency	AwardId	Federal Grant or Other Identifying Number Assigned by the awarding Federal agency.	string	Variable (Maximum 50 characters)	FAADS FPDS eSRS USASpending	mandatory not editable in federalreporting.gov The number pulled in from USAspending.gov is the official number and may not be changed in federalreporting.gov.
ARRA-C-1	DUNS Number	RecipientDUNSNumber	Unique Identifier of Entity (DUNS No.) The prime recipient organization’s 9 digit Data Universal Numbering System (DUNS) number or Central Contractor Registration plus 4 extended DUNS number.	string	13	D&B CCR eSRS FPDS USASpending	mandatory not editable in federalreporting.gov
ARRA-C-2	MPIN number or other password	EntityMPINNumber	Marketing procurement id number of recipient or subrecipient/subcontractor or other password for system access	string	13	CCR	mandatory
ARRA-D	EIN	RecipientEIN	The recipient organization’s Employer Identification Number (EIN) provided by the Internal Revenue Service.	string	13	CCR	mandatory not editable in federalreporting.gov will not be uploaded to Recovery.gov
ARRA-E	CFDA	CFDANumber	Catalog of Federal Domestic Assistance: GSA, OMB; published description of Federal assistance program. Catalog of Federal Domestic Assistance (CFDA) number on the award document or provided by the awarding agency. If this award is being funded through multiple programs, provide each CFDA number.	string	7	CFDA FAADS USASpending	mandatory must match a CFDA number in CFDA.gov or validated by CFDA PMO first two digits of CFDA number represent agency and should crosswalk to a federal agency associated with the code in ARRA-A-1
ARRA-F-1	Recipient Organization's Name	RecipientName	Recipient Name and Address of Organization. The legal name of recipient organization and address, including zip code and Congressional district. This should be the same name and address that appears in recipient’s Central Contractor Registration profile.	string	55	D&B CCR eSRS FPDS USASpending	mandatory should populate from entity profile in CCR; may not be changed in federalreporting.gov
ARRA-F-2	Recipient Organization's Address, Line 1	RecipientAddress1	Recipient Name and Address of Organization. The legal name of recipient organization and address, including zip code and Congressional district. This should be the same name and address that appears in recipient’s Central Contractor Registration profile.	string	55	D&B CCR eSRS FPDS USASpending	mandatory should populate from entity profile in CCR; may not be changed in federalreporting.gov
ARRA-F-3	Recipient Organization's Address, Line 2	RecipientAddress2	Recipient Name and Address of Organization. The legal name of recipient organization and address, including zip code and Congressional district. This should be the same name and address that appears in recipient’s Central Contractor Registration profile.	string	55	D&B CCR eSRS FPDS USASpending	mandatory should populate from entity profile in CCR; may not be changed in federalreporting.gov
ARRA-F-4	Recipient Organization's Address, Line 3	RecipientAddress3	Recipient Name and Address of Organization. The legal name of recipient organization and address, including zip code and Congressional district. This should be the same name and address that appears in recipient’s Central Contractor Registration profile.	string	55	D&B CCR eSRS FPDS USASpending	mandatory should populate from entity profile in CCR; may not be changed in federalreporting.gov
ARRA-F-5	Recipient Organization's City	RecipientCity	Recipient Name and Address of Organization. The legal name of recipient organization and address, including zip code and Congressional district. This should be the same name and address that appears in recipient’s Central Contractor Registration profile.	string	55	D&B CCR eSRS FPDS USASpending	mandatory should populate from entity profile in CCR; may not be changed in federalreporting.gov
ARRA-F-6	Recipient Organization's State	RecipientState	Recipient Name and Address of Organization. The legal name of recipient organization and address, including zip code and Congressional district. This should be the same name and address that appears in recipient’s Central Contractor Registration profile.	string	2	D&B CCR eSRS FPDS USASpending	mandatory should populate from entity profile in CCR; may not be changed in federalreporting.gov
ARRA-F-7	Recipient Organization's Zip Code +4	RecipientZipcode	Recipient Name and Address of Organization. The legal name of recipient organization and address, including zip code and Congressional district. This should be the same name and address that appears in recipient’s Central Contractor Registration profile.	string	9	D&B CCR eSRS FPDS USASpending	mandatory should populate from entity profile in CCR; may not be changed in federalreporting.gov
ARRA-F-8	Recipient's Congressional District	RecipientCongressionalDistrict	Recipient Name and Address of Organization. The legal name of recipient organization and address, including zip code and Congressional district. This should be the same name and address that appears in recipient’s Central Contractor Registration profile.	string	2	D&B CCR eSRS FPDS USASpending	mandatory should be derived from recipient's zip+4
ARRA-F-9	Recipient Type	RecipientType	Subrecipient/Subcontractor/Vendor Type Select primary category from the list of categories below. A. State Government. B. County Government. C. City or Township Government. D. Special District Government. E. Regional Organization. F. U.S. Territory or Possession. G. Independent School District. H. Public/State Controlled Institution of Higher Education. I. Indian/Native American Tribal Government (Federally Recognized). J. Indian/Native American Tribal Government (Other than Federally Recognized). K. Indian/Native American Tribally Designated Organization. L. Public/Indian Housing Authority. M. Nonprofit with 501C3 IRS Status (Other than Institution of Higher Education). N. Nonprofit without 501C3 IRS Status (Other than Institution of Higher Education). O. Private Institution of Higher Education. P. Individual. Q. For-Profit Organization (Other than Small Business). R. Small Business. S. Hispanic-serving Institution. T. Historically Black Colleges and Universities (HBCUs). U. Tribally Controlled Colleges and Universities (TCCUs). V. Alaska Native and Native Hawaiian Serving Institutions. W. Non-domestic (non-US) Entity. X. Other.	letter	1	FPDS USASpending	mandatory
ARRA-G	Recipient Account Number or Account Number	RecipientsAccountNumber	Recipient's internal account number for project/award. The account number or any other identifying number assigned by the recipient to the award. This number is strictly for the recipient’s use only and is not required by the awarding Federal agency.	string	55	D&B CCR eSRS FPDS USASpending	optional
ARRA-H-1	Award/Grant Period: Starting Date	AwardBeginDate	Award/Grant Period (Starting Date): The date identified in the award document when Federal sponsorship begins. Note: Some agencies award multi-year grants for a project/grant period (e.g., 5 years) that are funded in increments known as budget periods or funding periods. These are typically annual increments. In those cases, this should be the starting date of the total project/grant period, not the individual budget period or funding period.	Date (YYYYMMDD)	8	FPDS USASpending	mandatory While this is an optional field in USAspending, it must be completed in federalreporting.gov if empty.
ARRA-H-2	Award/Grant Period: Ending Date	AwardEndDate	Award/Grant Period (Ending Date): The date identified in the award document when Federal sponsorship ends. Note: Some agencies award multi-year grants for a project/grant period (e.g., 5 years) that are funded in increments known as budget periods or funding periods. These are typically annual increments. In those cases, this should be the ending date of the total project/grant period, not the individual budget period or funding period. For loans, this would be the end of loan repayment period.	Date (YYYYMMDD)	8	FPDS USASpending	mandatory While this is an optional field in USAspending, it must be completed in federalreporting.gov if empty.
ARRA-I	Reporting Period: Ending Date	ReportPeriodEndDate	Reporting Period End Date. The frequency of required reporting is quarterly. For quarterly reports, the following calendar quarter reporting period end dates shall be used: 9/30; 12/31; 3/31, or 6/30. For final reports, the reporting period end date shall be the end date of the project/grant period.	Date (YYYYMMDD)	8	eSRS USASpending FPDS	mandatory This date may be system generated to be the end date of each calendar quarter starting from the AwardBeginDate to the AwardEndDate.
ARRA-J	Final Recipient Report	FinalReport	Final Recipient Report Indicator (i.e. no future reports) (Yes or No) Check ‘‘yes’’ only if this is the final report for the project / grant period specified	yes/no	3	eSRS	mandatory This indicator would default to "Y" for the final quarter.
ARRA-K	Type of Assistance Transaction	AwardType	Transaction Type—Grant, Contract or Loan	string	2	FPDS USASpending FAADS+	mandatory This should be populated from existing source systems. It may not be edited in federalreporting.gov.
ARRA-S	Date of Award	AwardDate	Award Date (Date Signed)	Date (YYYYMMDD)	8	eSRS FPDS USASpending	mandatory This should be populated from existing source systems. It may not be edited in federalreporting.gov.
ARRA-1-01	Award Title or Name of Project or Activity	AwardDescription	Award Title Description w/ purpose of funding action. A brief descriptive title of the project or activity funded in whole or in part with Recovery Act funds. If this award funds multiple projects or activities, provide a descriptive title that captures the general focus area, e.g., ‘‘community development,’’ ‘‘comprehensive community mental health services to adults with a serious mental illness,’’ etc.	string	Variable (Maximum 4000 characters)	eSRS FPDS USASpending	mandatory This should be populated from existing source systems. It may not be edited in federalreporting.gov.
ARRA-1-02	Total Amount of Recovery Funds Received from Federal Agency/Total Funding Amount in USAspending	AwardAmount	Total Amount of Recovery Funds Received from Federal Agency - Federal Dollar Amount (cumulative)	Currency (Dollar value - numeric)	20	FPDS USASpending	mandatory This should be populated from existing source systems. It may not be edited in federalreporting.gov.
ARRA-1-03	Amount of recovery funds received that were expended to projects or activities	FedExpenditure	Amount of recovery funds received that were expended to projects or activities (‘‘Federal Share of Expenditures’’). the cumulative total for the amount of Federal fund expenditures. For reports prepared on a cash basis, expenditures are the sum of cash disbursements for direct charges for property and services; the amount of indirect expense charged; and the amount of cash advance payments and payments made to subcontractors, subawardees and vendors. For reports prepared on an accrual basis, expenditures are the sum of cash disbursements for direct charges for property and services; the amount of indirect expense incurred; and the net increase or decrease in the amounts owed by the recipient for (1) goods and other property received; (2) services performed by employees, contractors, subcontractors, subawardees, and other payees; and (3) programs for which no current services or performance are required. Do not include program income expended or in-kind contributions applied.	Currency (Dollar value - numeric)	20		mandatory
ARRA-1-04	Infrastructure investments	InvestmentCategory	Choose "Yes" if the awarding agency has determined that this award funds infrastructure investments by State/local governments. If no guidance has been provided by the awarding agency, choose "Yes" if the award funds a public building and/or a public work described in 2 CFR 176.140(a)(2).	yes/no	3		mandatory If "Yes," and investment made by State/local government, infrastructure questions beginning with ARRA-2-05 must be answered.
ARRA-2-01	Description of Project or Activity (code)	Activity_code	Description of Project or Activity (NAICS code or NPC Core code). For awards funding infrastructure, provide the predominant North American Industry Classification System (NAICS) code (www.census.gov/eos/www/naics/) that best describes the Recovery Act infastructure project or activity under this award. For all other awards, provide the National Center for Charitable Statistics "NPC Core" code (http://nccsdataweb.urban.org/PubApps/nteeSearch.php?gQry=all-core&codeType=NPC) that describes the predominant focus of the Recovery Act funded projects or activities under this award.	string	10	eSRS FPDS USASpending	mandatory The recipient should refer to the award document for the applicable NAICS Code (if any). Only one code may be entered for each project/activity record. If response to ARRA-1-04 is "yes," the NAICS code list will be Code list should be a picklist from code list at www.census.gov/eos/www/naics/. If response is "no," user must select a three character code (e.g., A01) from the picklist or a more detailed/granular code, if any, (e.g., A01.02). Picklist should be from codes at http://nccsdataweb.urban.org/PubApps/nteeSearch.php?gQry=all-core&codeType=NPC. This should be added to the next FAADS Plus Format for submitting financial assistance data to USAspending.gov. It would be nice if the NAICS or NPC code description could display in any report tables or search tables.
ARRA-2-02	Description of Project or Activity (brief narrative)	Activity_description	Description of Project or Activity (brief narrative). A description of the overall purpose and expected outputs and outcomes or results of the award and first-tier subaward(s), including significant deliverables and, if appropriate, units of measure. For an award that funds multiple projects or activities, such as a formula block grant, the purpose and outcomes or results may be stated in broad terms unless each project/activity will be listed separately in this report.	string	2000	eSRS FPDS USASpending	mandatory
ARRA-2-03	Evaluation of completion status of the project or activity.	ProjectStatus	Evaluation of completion status of the project or activity. The status of the work that has been completed. This evaluation should be based on performance progress reports and other relevant non-financial performance information. Please choose one of the following options: 1-Not started; 2-Less than 50% completed; 3-Completed 50% or more; 4-Fully Completed.	numeric	1		mandatory Each project/activity entry will be a separate block of data. Submitter may enter multiple blocks of project/activity data.
ARRA-2-04-a	Narrative description of the employment impact of the Recovery Act funded work	JobNarrative	A narrative description of the employment impact of the Recovery Act funded work. This narrative is cumulative for each calendar quarter and at a minimum, will address the impact on the recipient’s workforce, and the impact on the workforces of subrecipients and vendors. At a minimum, the recipient shall provide a brief description of the types of jobs created and jobs retained in the United States and outlying areas. ‘‘Jobs or positions created’’ means those new positions created and filled, or previously existing unfilled positions that are filled, as a result of Recovery Act funding. ‘‘Jobs or positions retained’’ means those previously existing filled positions that are retained as a result of Recovery Act funding. This description may rely on job titles, broader labor categories, or the recipient’s existing practice for describing jobs as long as the terms used are widely understood and describe the general nature of the work. ALTERNATE METHOD: In those circumstances where the recipient employs an approved statistical methodology to generate estimates of job impact, thereby collecting data from a smaller subset of sub-recipients and vendors in order to extrapolate an estimate of job impact to all applicable subrecipients and vendors, the recipient must provide a description of the methodology used.	string	Variable (Maximum 4000 characters)		mandatory
ARRA-2-04-b	An estimate of the number of jobs created and retained	JobNumber	Jobs created and retained. An estimate of the number of jobs created and jobs retained in the United States and outlying areas. At a minimum, this estimate shall include any new positions created and any existing filled positions that were retained to support or carry out Recovery Act projects or activities managed directly by the recipient and by subrecipients and vendors. The number shall be expressed as ‘‘full-time equivalent’’ (FTE), calculated cumulatively as all hours worked divided by the total number of hours in a full-time schedule, as defined by the recipient. For instance, two full-time employees and one parttime employee working half days would be reported as 2.5 FTE in each calendar quarter. A job cannot be reported as both created and retained. As used in this instruction, United States means the 50 States and the District of Columbia, and outlying areas means— (1) Commonwealths. (i) Puerto Rico. (ii) The Northern Mariana Islands; (2) Territories. (i) American Samoa. (ii) Guam. (iii) U.S. Virgin Islands; and (3) Minor outlying islands. (i) Baker Island. (ii) Howland Island. (iii) Jarvis Island. (iv) Johnston Atoll. (v) Kingman Reef. (vi) Midway Islands. (vii) Navassa Island. (viii) Palmyra Atoll. (ix) Wake Atoll.	numeric	10		mandatory number could be "0" but there must be a number
ARRA-2-05	For infrastructure investments made by State and local governments: Total cost of infrastructure investment made by State and Local governments	TotalInfrastructureExpenditure	Total cost of infrastructure investment made by State and Local governments. Provide the cumulative total cost of investment. This amount should include the total cumulative federal expenditures and nonfederal expenditures for the infrastructure investment: Federal (Recovery Act funds): $llllllll. Federal (non-Recovery Act funds): $llllllll. NonFederal: $llllllll.	Currency (Dollar value - numeric)	20		mandatory for those state/local government recipients that marked "yes" to infrastructure question
ARRA-2-05-a	For infrastructure investments made by State and local governments: Federal (Recovery Act funds) expended	TotalFedARRAExpenditure	Total federal ARRA expenditure	Currency (Dollar value - numeric)	20		mandatory for those state/local government recipients that marked "yes" to infrastructure question A valid response is "0" dollars. These amounts should be cumulative so the next quarters amount should be greater than or equal to the previous quarter's amount unless an error was made in the prior quarter.
ARRA-2-05-b	For infrastructure investments made by State and local governments: Federal (non-Recovery Act funds) expended	TotalFedNonARRAExpenditure	Total federal non-ARRA expenditure	Currency (Dollar value - numeric)	20		mandatory for those state/local government recipients that marked "yes" to infrastructure question A valid response is "0" dollars. These amounts should be cumulative so the next quarters amount should be greater than or equal to the previous quarter's amount unless an error was made in the prior quarter.
ARRA-2-05-c	For infrastructure investments made by State and local governments: NonFederal $ expended	TotalNonFedExpenditure	Total non-federal expenditure	Currency (Dollar value - numeric)	20		mandatory for those state/local government recipients that marked "yes" to infrastructure question A valid response is "0" dollars. These amounts should be cumulative so the next quarters amount should be greater than or equal to the previous quarter's amount unless an error was made in the prior quarter.
ARRA-2-06	For infrastructure investments made by State and local governments: What is the rationale of the Award Recipient for funding the infrastructure investment with funds made available under the Recovery Act?	InfrastructureRationale	Rationale of the Award Recipient for funding the infrastructure investment with funds made available under the Recovery Act. Explain how the infrastructure investment will contribute to one or more purposesof the Recovery Act:Purposes:(1) To preserve and create jobs and promote economic recovery.(2) To assist those most impacted by the recession.(3) To provide investments needed to increase economic efficiency by spurring technological advances in science and health.(4) To invest in transportation, environmental protection, and other infrastructure that will provide long-term economic benefits.(5) To stabilize State and local government budgets, in order to minimize and avoid reductions in essential services and counterproductive state andlocal tax increases.	string	Variable (Maximum 4000 characters)		mandatory for those state/local government recipients that marked "yes" to infrastructure question)
ARRA-2-07-a	For infrastructure investments made by State and local governments: Who should we contact if we have concerns about this infrastructure investment?	StateLocalContactName	Name, phone number, address and email address of the appropriate contact in the state/local government.	string	55	CCR Egov	mandatory for those state/local government recipients that marked "yes" to infrastructure question If information is populated by CCR, the recipient should be able to overwrite it since the POC for infrastructure projects or specific awards may not be the same person who is a POC in CCR.
ARRA-2-07-b	For infrastructure investments made by State and local governments: Who should we contact if we have concerns about this infrastructure investment?	StateLocalContactStreetAddress1	Name, phone number, address and email address of the appropriate contact in the state/local government.	string	55	CCR Egov	mandatory for those state/local government recipients that marked "yes" to infrastructure question If information is populated by CCR, the recipient should be able to overwrite it since the POC for infrastructure projects or specific awards may not be the same person who is a POC in CCR.
ARRA-2-07-c	For infrastructure investments made by State and local governments: Who should we contact if we have concerns about this infrastructure investment?	StateLocalContactStreetAddress2	Name, phone number, address and email address of the appropriate contact in the state/local government.	string	55	CCR Egov	mandatory for those state/local government recipients that marked "yes" to infrastructure question If information is populated by CCR, the recipient should be able to overwrite it since the POC for infrastructure projects or specific awards may not be the same person who is a POC in CCR.
ARRA-2-07-d	For infrastructure investments made by State and local governments: Who should we contact if we have concerns about this infrastructure investment?	StateLocalContactStreetAddress3	Name, phone number, address and email address of the appropriate contact in the state/local government.	string	55	CCR Egov	mandatory for those state/local government recipients that marked "yes" to infrastructure question If information is populated by CCR, the recipient should be able to overwrite it since the POC for infrastructure projects or specific awards may not be the same person who is a POC in CCR.
ARRA-2-07-e	For infrastructure investments made by State and local governments: Who should we contact if we have concerns about this infrastructure investment?	StateLocalContactCity	Name, phone number, address and email address of the appropriate contact in the state/local government.	string	55	CCR Egov	mandatory for those state/local government recipients that marked "yes" to infrastructure question If information is populated by CCR, the recipient should be able to overwrite it since the POC for infrastructure projects or specific awards may not be the same person who is a POC in CCR.
ARRA-2-07-f	For infrastructure investments made by State and local governments: Who should we contact if we have concerns about this infrastructure investment?	StateLocalContactState	Name, phone number, address and email address of the appropriate contact in the state/local government.	string	2	CCR Egov	mandatory for those state/local government recipients that marked "yes" to infrastructure question If information is populated by CCR, the recipient should be able to overwrite it since the POC for infrastructure projects or specific awards may not be the same person who is a POC in CCR.
ARRA-2-07-g	For infrastructure investments made by State and local governments: Who should we contact if we have concerns about this infrastructure investment?	StateLocalContactZIPCode	Name, phone number, address and email address of the appropriate contact in the state/local government.	string	9	CCR Egov	mandatory for those state/local government recipients that marked "yes" to infrastructure question If information is populated by CCR, the recipient should be able to overwrite it since the POC for infrastructure projects or specific awards may not be the same person who is a POC in CCR.
ARRA-2-07-h	For infrastructure investments made by State and local governments: Who should we contact if we have concerns about this infrastructure investment?	StateLocalContactCountyCode	Name, phone number, address and email address of the appropriate contact in the state/local government.	string	3	CCR Egov	mandatory for those state/local government recipients that marked "yes" to infrastructure question If information is populated by CCR, the recipient should be able to overwrite it since the POC for infrastructure projects or specific awards may not be the same person who is a POC in CCR.
ARRA-2-07-i	For infrastructure investments made by State and local governments: Who should we contact if we have concerns about this infrastructure investment?	StateLocalContactCongressionalDistrict	Name, phone number, address and email address of the appropriate contact in the state/local government.	string	2	CCR Egov	mandatory for those state/local government recipients that marked "yes" to infrastructure question If information is populated by CCR, the recipient should be able to overwrite it since the POC for infrastructure projects or specific awards may not be the same person who is a POC in CCR.
ARRA-2-07-j	For infrastructure investments made by State and local governments: Who should we contact if we have concerns about this infrastructure investment?	StateLocalContactEmail	Name, phone number, address and email address of the appropriate contact in the state/local government.	string	55		mandatory for those state/local government recipients that marked "yes" to infrastructure question If information is populated by CCR, the recipient should be able to overwrite it since the POC for infrastructure projects or specific awards may not be the same person who is a POC in CCR.
ARRA-L	Recipient Primary Place of Performance: State code	PopStateCode	Recipient Primary Place of Performance (city, state, congressional district, and country) physical location of primary place of performance.	string	2		optional
ARRA-M	Recipient Primary Place of Performance: Code	PopLocationCode	Recipient Primary Place of Performance (city, state, congressional district, and country) physical location of primary place of performance.	string	7		optional
ARRA-N	Recipient Primary Place of Performance: Country Code	PopCountryCode	Recipient Primary Place of Performance (city, state, congressional district, and country) physical location of primary place of performance.	string	3		mandatory Information from existing source system cannot be overwritten in federalreporting.gov.
ARRA-O	Recipient Primary Place of Performance: State	PopLocationName	Recipient Primary Place of Performance (city, state, congressional district, and country) physical location of primary place of performance.	string	25		optional Information from existing source system cannot be overwritten in federalreporting.gov.
ARRA-P	Recipient Primary Place of Performance: Zip Code+4	PopZipCode	Recipient Primary Place of Performance (city, state, congressional district, and country) physical location of primary place of performance.	string	9		mandatory Information from existing source system cannot be overwritten in federalreporting.gov.
ARRA-Q	Recipient Primary Place of Performance: Congressional District	PopCongressDist	Recipient Primary Place of Performance (city, state, congressional district, and country) physical location of primary place of performance.	string	2		optional will be derived from zip+4
ARRA-R	The Area Most Affected by the Project/Activity	RecipientAreaOfBenefit	The area of benefit may be the name(s) of a: State, County, City, Town, School District, or other subdivision	string	16		optional
ARRA-T	The Population Most Affected by the Project/Activity (Code)	RecipientPopOfBenefit	The beneficiaries of the project/activity by population	string	4		optional pick from NPC population codes at http://nccsdataweb.urban.org/PubApps/nteeSearch.php?gQry=all-pop&codeType=NPC
ARRA–3–01-a	Subrecipient/Subcontractor/Vendor: DUNS Number	SubEntityDUNS_number	Subrecipient/Subcontractor/Vendor DUNS Number. the subrecipient organization’s 9 digit Data Universal Numbering System (DUNS) number or Central Contractor Registration plus 4 extended DUNS number.	string	13	D&B CCR eSRS FPDS USASpending	mandatory a valid response could be "0"
ARRA-3-01-b	Subrecipient/Subcontractor: Self-Certification of gross income	SubIncomeCert	Subrecipient/subcontractor self-certification of gross income. "Does the subrecipient or subcontractor certify that the gross income from all sources (federal and nonfederal), for such entity did not exceed $300,000 in the previous tax year of such entity? (Yes/No)."	yes/no	3		optional Question for subrecipients/subcontractors that report transactions directly into the system as required by prime recipient If the response is "Yes," the subcontractor/subrecipient is exempt from reporting subawards/subcontracts. A note should appear on the screen that explains this. The system should tag the entity as not having to report information on its subcontracts/subawards for the next 12 months. This would not prevent the recipient from reporting the information.
ARRA-3-02	Subrecipient/Subcontractor/Vendor: Award or other number assigned by recipient to identify transaction	SubContractNumber	Award Number or Other Identifying Number Assigned by the Recipient Entity to the subaward, subcontract or vendor transaction	string	55	FAADS FPDS eSRS USASpending	optional It is not necessary for the recipient to enter its own tracking/award number, but the federal grant/award nubmber in ARRA-B must track to each related subcontract/subaward/vendor record.
ARRA-3-03	Subrecipient/Subcontractor/Vendor: Name	SubEntityName	Subrecipient/Subcontractor/Vendor Name. the legal name of subrecipient/subcontractor/vendor.	string	55	FAADS FPDS eSRS USASpending	mandatory
ARRA-3-04-a	Subrecipient/Subcontractor/Vendor: Location	SubEntityAddress1	Subrecipient/Subcontractor/Vendor Name. the location of subrecipient/subcontractor/vendor.	string	55	D&B CCR eSRS FPDS USASpending	optional
ARRA-3-04-b	Subrecipient/Subcontractor/Vendor: Location	SubEntityAddress2	Subrecipient/Subcontractor/Vendor Name. the location of subrecipient/subcontractor/vendor.	string	55	D&B CCR eSRS FPDS USASpending	optional
ARRA-3-04-c	Subrecipient/Subcontractor/Vendor: Location	SubEntityAddress3	Subrecipient/Subcontractor/Vendor Name. the location of subrecipient/subcontractor/vendor.	string	55	D&B CCR eSRS FPDS USASpending	optional
ARRA-3-04-d	Subrecipient/Subcontractor/Vendor: Location	SubEntityCity	Subrecipient/Subcontractor/Vendor Name. the location of subrecipient/subcontractor/vendor.	string	55	D&B CCR eSRS FPDS USASpending	mandatory information by be derived from zip+4
ARRA-3-04-e	Subrecipient/Subcontractor/Vendor: Location	SubEntityState	Subrecipient/Subcontractor/Vendor Name. the location of subrecipient/subcontractor/vendor.	string	2	D&B CCR eSRS FPDS USASpending	mandatory information by be derived from zip+4
ARRA-3-04-f	Subrecipient/Subcontractor/Vendor: Location	SubEntityZipcode	Subrecipient/Subcontractor/Vendor Name. the location of subrecipient/subcontractor/vendor.	string	9	D&B CCR eSRS FPDS USASpending	mandatory
ARRA-3-04-g	Subrecipient/Subcontractor/Vendor: Location	SubEntityCongressDistrict	Subrecipient/Subcontractor/Vendor Name. the location of subrecipient/subcontractor/vendor.	string	6		mandatory information by be derived from zip+4
ARRA-3-05	Subrecipient/Subcontractor: Type	SubRecipientType	Subrecipient/Subcontractor/Vendor Type Select primary category from the list of categories below. A. State Government. B. County Government. C. City or Township Government. D. Special District Government. E. Regional Organization. F. U.S. Territory or Possession. G. Independent School District. H. Public/State Controlled Institution of Higher Education. I. Indian/Native American Tribal Government (Federally Recognized). J. Indian/Native American Tribal Government (Other than Federally Recognized). K. Indian/Native American Tribally Designated Organization. L. Public/Indian Housing Authority. M. Nonprofit with 501C3 IRS Status (Other than Institution of Higher Education). N. Nonprofit without 501C3 IRS Status (Other than Institution of Higher Education). O. Private Institution of Higher Education. P. Individual. Q. For-Profit Organization (Other than Small Business). R. Small Business. S. Hispanic-serving Institution. T. Historically Black Colleges and Universities (HBCUs). U. Tribally Controlled Colleges and Universities (TCCUs). V. Alaska Native and Native Hawaiian Serving Institutions. W. Non-domestic (non-US) Entity. X. Other.	letter	1	FPDS USASpending FAADS+	mandatory
ARRA-3-06	Amount of Subcontract or Subaward or Vendor Payment Disbursed	SubawardAmountDisbursed	Amount of Subcontract or Subaward or Vendor Payment Disbursed. The cumulative amount of cash disbursed to the subawardee or subcontractor or vendor as of the reporting period end date.	Currency (Dollar value - numeric)	20		mandatory
ARRA-3-07	Total Amount of Subcontract or Subaward (Ultimate Contract/Award Value)	SubawardValue	Total Amount of Subcontract or Subaward (Ultimate Contract/Award Value). the anticipated total amount of cash to be disbursed to the subawardee or subcontractor by the expiration date of the subaward or subcontract, respectively.	Currency (Dollar value - numeric)	20		mandatory
ARRA–3–08	Subaward/Subcontract AwardDate	SubawardDate	Subaward Date. the date the subcontract or subaward was signed (mm/dd/yyyy).	Date (YYYYMMDD)	8		mandatory
ARRA–3–09-a	Subaward or Subcontract Project/Grant Period: Starting Date	SubawardBeginDate	Subaward Project/Grant Period. the project/grant period established in the subaward document during which sponsorship begins and ends. For multi-year awards for a project/grant period (e.g., 5 years) that are funded in increments known as budget periods or funding periods, please provide the total project/grant period, not the individual budget period or funding period.	Date (YYYYMMDD)	8		optional
ARRA–3–9-b	Subaward or Subcontract Project/Grant Period: Ending Date	SubawardEndDate	Subrecipient Place of Performance (city, state, congressional district, and country). Physical location of primary place of performance.	Date (YYYYMMDD)	8		optional
ARRA-3-10-a	Subaward/Subcontract/Vendor Primary Performance Location: Zip Code	SubRecipientPopLocationCode	Subrecipient Place of Performance (city, state, congressional district, and country). Physical location of primary place of performance.	string	9		optional
ARRA-3-10-b	Subaward or Subcontract Primary Performance Location: Country Code	SubRecipientPopCountryCode	Subrecipient Place of Performance (city, state, congressional district, and country). Physical location of primary place of performance.	string	3		optional
ARRA-3-10-c	Subaward or Subcontract Primary Performance Location: Congressional District	SubRecipientPopCongressDist	Subrecipient Place of Performance (city, state, congressional district, and country). Physical location of primary place of performance.	string	6		optional
ARRA-3-10-d	Subaward or Subcontract: The Area Most Affected by the Project	SubRecipientAreaOfBenefit	Subrecipient Place of Performance (city, state, congressional district, and country). Physical location of primary place of performance.	string	16		optional
ARRA-3-10-e	Description of Subaward or Subcontract or Vendor Payment (brief narrative)	SubActivity_description	Description of Subaward or Subcontract or Vendor Payment (brief narrative). A description of the purpose of the subaward or subcontract. For vendor payment, provide a brief description of what was purchased.	string	100	eSRS FPDS USASpending	mandatory
ARRA-3-11-a	Subrecipient or Subcontractor: Self-certification of public access to information on five most highly compensated officers of the entity	SubCompensationCert	Subrecipient or Subcontractor self-certification of public access to information on five most highly compensated officers. "Does the entity certify that the public has access to information about the compensation of the senior executives of the entity through periodic reports filed under section 13(a) or 15(d) of the Securities Exchange Act of 1934 (15 U.S.C. 78m(a), 78o(d)) or section 6104 of the Internal Revenue Code of 1986 [26 USC § 6104]? ("Yes/No")	yes/no	3		mandatory If the response is "Yes," the subcontractor/subrecipient is exempt from reporting the information under ARRA-3-11-b or ARRA-3-11-c. A note should appear on the screen that explains this. The system should tag the entity as not having to report information on its executive compensation for the next 12 months. This would not prevent the recipient from reporting the information, or from requiring its subs to report the information directly into the system.
ARRA-3-11-b	Subrecipient or Subcontractor: For the five most highly compensated officers of the entity, the names	SubRecipientOfficerName(5)	For the five most highly compensated officers of the entity: names. the names and total compensation of the five most highly compensated officers of the subrecipient entity if— (1) the recipient in its preceding fiscal year received— (a) 80 percent or more of its annual gross revenues in Federal awards; and (b) $25,000,000 or more in annual gross revenues from Federal awards; and (2) the public does not have access to information about the compensation of the senior executives of the entity through periodic reports filed under section 13(a) or 15(d) of the Securities Exchange Act of 1934 (15 U.S.C. 78m(a), 78o(d)) or section 6104 of the Internal Revenue Code of 1986 [26 USC § 6104]. ‘‘Total compensation’’ means the cash and noncash dollar value earned by the executive during the subrecipient’s past fiscal year of the following (for more information see 17 CFR 229.402(c)(2)): (i). Salary and bonus. (ii). Awards of stock, stock options, and stock appreciation rights. Use the dollar amount recognized for financial statement reporting purposes with respect to the fiscal year in accordance with FAS 123R. (iii). Earnings for services under non-equity incentive plans. Does not include group life, health, hospitalization or medical reimbursement plans that do not discriminate in favor of executives, and are available generally to all salaried employees. (iv). Change in pension value. This is the change in present value of defined benefit and actuarial pension plans. (v). Above-market earnings on deferred compensation which are not taxqualified. (vi). Other compensation. For example, severance, termination payments, value of life insurance paid on behalf of the employee, perquisites or property if the value for the executive exceeds $10,000.	string	55		mandatory if response to ARRA-3-11-a is "No."
ARRA-3-11-c	Subrecipient or Subcontractor: For the five most highly compensated officers of the entity, the total compensation	SubRecipientOfficerTotalCompensation(5)	For the five most highly compensated officers of the entity: total compensation	Currency (Dollar value - numeric)	20		mandatory if response to ARRA-3-11-a is "No."
ARRA-4-01	Total Amount of Subcontracts, Subawards and Vendor Payments less than $25,000/award plus total amount of awards to individuals	TotalNumberSmallSubawards	Total Number of Subcontracts and Sub-awards less than $25,000/award and awarded to individuals.	numeric	6		mandatory a valid response could be "0"
ARRA-4-02	Total Number of Subcontracts, Subawards and Vendor Payments less than $25,000/award plus total number of awards to individuals	TotalAmountSmallSubawards	Total Amount of Subcontracts, Subawards and Vendor Payments less than $25,000/award and awarded to individuals.	Currency (Dollar value - numeric)	20		mandatory a valid response could be "0"