Download:
pdf |
pdf“Transparency, Accountability, and Oversight”
Recipient Reporting
Data Model
V4.0
-
FINAL PRODUCTION RELEASE
for Quarter Ending September 30, 2010
Note: this model may be adjusted for future reporting cycles
Note to users of this data model
This data model is intended to be used in conjunction with the Section 1512 of American Recovery
and Reinvestment Act. Recipient reporting is being executed through the web based
FederalReporting.Gov recipient reporting solution. The Web based form, MS Excel template and
XML schema options for report submission will be found on that site and will conform to this
model. Clarifications to the elements will be published as a set of Frequently Asked Questions to
FederalReporting.Gov.
It is important to note that this model is intended for use for the quarter ending September 30, 2010.
This model and the report submission templates may not be wholly applicable to future reporting
cycles. Recipients should reference formal guidance and updates for future reporting requirements.
Page 2 of 46
Data Dictionary
The data dictionary describes the data elements specifically required for recipient reporting under the American Recovery and Reinvestment
Act of 2009 (Recovery Act).
Table 1 - Recipient Reporting Data Dictionary
Data
Elemen
ts
Data Element
Yellow – Input (user provided)
Blue – System provided (e.g. CCR, Agency Code Reference
Table)
Definition
RECIPIENT DATA ELEMENTS
Funding Agency
Numeric code of Federal
Code
Agency that is responsible
for funding/distributing the
ARRA funds to Recipients.
Type
string
Max
Lengt
h
4
Example
6800
Comments
Federal
Agency
code is
mandatory
for
Recipient
Reporting.
Control
April 1, 2009
This is a
Federal
mandatory
Register
field.
Transparency
Act Guidance
March 30, 2007
Initial
The Funding Reference:
Agency is
fips95-2.pdf
the agency
that receives Latest
the ARRA
Reference:
funds
NIST Special
through the Publication
ARRA
800-87
funds
appropriatio
Page 3 of 46
Validation
and
Business
Rule(s)
Data Element
Definition
Type
Max
Lengt
h
Example
Comments
Control
Validation
and
Business
Rule(s)
This field
is inferred
given the
Funding
Agency
Code
provided
This is a
mandatory
field.
n.
Funding Agency
Name
The Federal Agency name
corresponding to the Federal
Agency Code used.
string
55
ENVIRONMEN
TAL
PROTECTION
AGENCY
Inferred
given the
Funding
Agency
Code
April 1, 2009
Federal
Register
Transparency
Act Guidance
March 30, 2007
Awarding
Agency Code
Numeric code of the agency
that awarded and
administering the award on
behalf of the Funding
Agency.
string
4
4700
The
Awarding
Agency is
the agency
that awards
administers
the ARRA
funds on
behalf of the
Funding
Agency.
April 1, 2009
Federal
Register
Transparency
Act Guidance
March 30, 2007
In many
cases, the
Page 4 of 46
Initial
Reference:
fips95-2.pdf
Latest
Reference:
NIST Special
Data Element
Definition
Type
Max
Lengt
h
Example
Comments
Awarding
Agency is
the same as
the Funding
Agency.
Awarding
Agency Name
The Federal Agency name
corresponding to the
Awarding Agency Code
used.
string
55
In some
cases, such
as some
contracts –
the Funding
Agency (e.g.
HHS)
delegates
the
administrati
on and
awarding
responsibilit
ies to
another
agency like
GSA.
GENERAL
Inferred
SERVICES
given the
ADMINISTRATI Awarding
ON
Agency
Code
Page 5 of 46
Control
Validation
and
Business
Rule(s)
Publication
800-87
April 1, 2009
Federal
Register
Transparency
Act Guidance
March 30, 2007
This field
is inferred
given the
Awarding
Agency
Code
provided
Data Element
Program Source
(TAS)
Definition
The Agency Treasury
Account Symbol (TAS) that
identifies the funding
Program Source. This
Program Source is based out
of the OMB TAS list.
Type
string
Max
Lengt
h
Example
Comments
Control
17
TRAGENCY (2)
+ "-" + TRACCT
(4) + "-" +
SUBACCT(3)
Assuming
that
Agencies
will provide
the code to
Recipient
Transparency
Act Guidance
March 30, 2007
Note: The
SUBACCT (3) is
optional; i.e. only
provided when
applicable
Federal Contractors may find
the TAS in their contract or
by calling the contracting
officer.
Award Number
The identifying number
assigned by the awarding
Federal Agency, such as the
federal grant number, federal
contract number or the
federal loan number.
string
50
Varies by award
and agencies
Note:
Program
Source
(TAS) is
mandatory
for
Recipient
Reporting.
The award
number is
case, space
and special
character
sensitive. It
should be
the same as
it appears in
the federal
award
document.
Award
Number is
Page 6 of 46
Validation
and
Business
Rule(s)
OMB TAS
list.
This is a
mandatory
field.
April 1, 2009
Federal
Register
Transparency
Act Guidance
March 30, 2007
This is a
mandatory
field.
The award
number is
case, space
and special
character
sensitive. It
should be
the same as
it appears
in the
federal
Data Element
Definition
Type
Max
Lengt
h
Example
Comments
mandatory
for
Recipient
Reporting
Order Number
This data element only
applies to Contracts
string
50
Varies by award
and agencies
This is a
contractonly data
element. If
applicable,
order
number
should be
entered;
otherwise
the field
should be
left blank.
The order
number is
case, space
and special
character
sensitive. It
should be
Page 7 of 46
Control
Validation
and
Business
Rule(s)
award
document.
This is an
optional
field
This is onl
y for
Contract.
Data Element
Definition
Type
Max
Lengt
h
Example
Comments
Control
Validation
and
Business
Rule(s)
the same as
it appears in
the federal
award
document.
This field
should not
be used for
any other
purpose,
including
numbers
associated
with grants,
loans, or
other
financial
assistance.
Recipient DUNS
Number
The prime recipient
string
organization‘s 9-digit Data
Universal Numbering System
(DUNS) number
9
123456789
The 9-digit
DUNS# is
mandatory
Parent DUNS
Number
Unique Identifier of Parent
Organization / Company
(DUNS No.)
9
This field is
inferred; obtained
through CCR.
The System
will pull the
parent
organization
‘s DUNS#
string
Page 8 of 46
April 1, 2009
This is a
Federal
mandatory
Register
field.
Transparency
Act Guidance
March 30, 2007
Transparency
Act Guidance
March 30, 2007
Data Element
Definition
Type
Max
Lengt
h
Example
Comments
Control
Validation
and
Business
Rule(s)
from CCR
Recipient Type
CFDA Number
Government
Contracting
Office Code
This data element is inferred
from CCR. The field inferred
is ―Business Type‖ in CCR.
string
The Catalog of Federal
Domestic Assistance
(CFDA) number is the
number associated with the
published description of
Federal assistance program
in the Catalog of Federal
Domestic Assistance.
string
The agency supplied code of
the contracting office that
executes the transaction.
string
300
6
6
2F - U.S. State
Government
M8 - Educational
Institution
66.039
064MA
Page 9 of 46
The System
will pull this
field from
CCR
April 1, 2009
Federal
Register
Fixed list
from CCR
This field
only applies
to grants and
loans.
April 1, 2009
Federal
Register
Transparency
Act Guidance
March 30, 2007
This field
only
applies to
grants and
loans.
The CFDA
number
should be
the same as
the one
found in
CFDA.gov
for
Recovery.
This
contracting
office code
can be
located on
the contract
document
This field
only
applies to
federally
awarded
contracts.
Data Element
Definition
Type
Max
Lengt
h
Example
Comments
Government
Contracting
Office Name
The government contracting string
office name inferred from the
government contracting
office code used.
100
DEPT OF
AGRIC/FARME
RS HOME
ADMINISTRATI
ON
Inferred
given the
Government
Contracting
Office Code
Recipient Legal
Name
Recipient DBA
Name
Recipient
Address 1
Recipient
Address 2
Recipient
Address 3
Recipient City
Recipient State
Recipient Zip
Code
Recipient
Country
Recipient
Congressional
District)
Recipient name and address
of Organization. The legal
and DBA (Doing-BusinessAs) name of recipient
organization and address,
including zip code. This
should be the same name and
address that appears in
recipient‘s Central
Contractor Registration
(CCR) profile.
string
120
string
120
This field is
inferred; obtained
through CCR
The System
will pull this
information
from CCR
string
55
string
55
string
55
string
string
string
35
2
9
string
3
string
2
51
This field is
mandatory.
Page 10 of 46
Control
Validation
and
Business
Rule(s)
This field
only
applies to
federally
awarded
contracts.
April 1, 2009
Data
Federal
populated
Register
from
Transparency
details
Act Guidance
found in
March 30, 2007 CCR
through the
Recipient
DUNS#
look-up
April 1, 2009
Federal
Register
This is a
mandatory
field.
Data Element
Recipient
Account Number
Final Report
Definition
Recipient's internal account
number for 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.
Final Project Report
Indicator (i.e. no future
reports) (Y or N). Check "Y"
only if this is the final report
and there will be no further
quarterly reports.
Type
Max
Lengt
h
string
255
string
1
Example
Comments
This field is
optional.
This is an
internal
tracking
number for
the Prime
Recipient
community.
April 1, 2009
Federal
Register
Validation
and
Business
Rule(s)
This is an
optional
field.
Y
Check ‗‗Y‘‘
only if this
is the final
report for
the award
period
specified.
April 1, 2009
Federal
Register
This is a
mandatory
field
For Grants
and Loans:
Check ―Y‖
only if all
ARRA
funds
associated
with the
award have
been
expended at
the prime
recipient
Page 11 of 46
Control
Data Element
Definition
Type
Max
Lengt
h
Example
Comments
level, all or
nearly all
ARRA
funds
associated
with the
award have
been
invoiced and
received, no
additional
jobs will be
funded, the
project
status is
complete
per agency
requirement
s and/or
performance
measures,
and the
Project
Status field
is marked as
―Fully
Complete‖
(marked as
―4‖).
Page 12 of 46
Control
Validation
and
Business
Rule(s)
Data Element
Award Type
Definition
Award Type—Grant, Loan,
or Federally Awarded
Contract
Type
string
Max
Lengt
h
8
Example
GRANT
Other types of federal
financial assistance not
specifically identified above
Page 13 of 46
Comments
For
Federally
Awarded
Contracts:
Check ―Y‖
only if
report meets
all of the
requirement
s of the
FAQ ―When
should a
Federal
contractor
submit its
final
quarterly
report?‖ at
http://www.
whitehouse.
gov/omb/rec
overy_faqs_
contractors
This is a
mandatory
field.
Control
Validation
and
Business
Rule(s)
Transparency
This is a
Act Guidance
mandatory
March 30, 2007 field.
Data Element
Award Date
Award
Description
Project Name or
Project/Program
Title
Definition
should be reported under the
award type of Grant.
The date when the award is
signed by the Awarding
Agency Official.
For Grants and Loans:
Award Title and description
with purpose of each funding
action if any. The description
should capture the overall
purpose of the award and, if
there are multiple funding
actions, sufficient description
to define the need for each
funding action.
For Federally Awarded
Contracts: Provide a
description of the overall
purpose and expected
outcomes, or results of the
contract or action under the
contract funded by the
Recovery Act, including
significant deliverables and,
if appropriate, associated
units of measure.
The brief descriptive Title of
the project or activity funded
in whole or in part with
Type
Max
Lengt
h
Date
(YYYY
MMDD
)
string
8
string
4000
256
Example
Comments
Control
Validation
and
Business
Rule(s)
20090530
This is a
mandatory
field.
Transparency
This is a
Act Guidance
mandatory
March 30, 2007 field.
. "Investment in
public
transportation:
replace four 10
year old electric
commuter train
cars. In addition,
funds will be
used to construct
a multi-modal
Park and Ride
facility featuring:
commuter
parking, transit
hub, bicycle
accommodations,
and a potential
future platform."
This is a
mandatory
field.
April 1, 2009
This is a
Federal
mandatory
Register
field.
Transparency
Act Guidance
March 30, 2007
F006: Land
Title as
Treatment
indicated on
Practices Services the Award
Page 14 of 46
April 1, 2009
Federal
Register
This field
only
applies to
Data Element
Definition
Type
Max
Lengt
h
Recovery Act funds
Quarterly
Activities/Project
Description for
Prime and Subrecipients
string
For Grants and Loans
A description of the overall
purpose and expected outputs
and outcomes or results of
the award and first-tier
Subaward(s), including
significant deliverables,
status, and, if appropriate,
units of measure.
For an award that funds
multiple projects such as a
formula block grant, the
purpose and outcomes or
results should be stated in
terms that allow an
understanding of
accomplishments .
In instances where the final
prime recipient expenditures
are less than the award
amount listed on the report
due to an amendment in the
original agreement or if the
project came in under
budget, the recipient must
provide a description in this
Example
(plowing/clearing
, etc.)
2000
Drinking water
will be in
compliance with
Safe Drinking
Water Act.
Reduced inflow
and infiltration
will improve
waste water
treatment plant
effectiveness
Page 15 of 46
Comments
Control
document/Pr
oduct or
Service
Code
This is a
April 1, 2009
mandatory
Federal
field
Register
Validation
and
Business
Rule(s)
Grants and
Loans.
This is a
mandatory
field
Data Element
Definition
Type
Max
Lengt
h
Example
Comments
Control
Validation
and
Business
Rule(s)
field explaining why the final
amount in the ―Total Federal
Amount of ARRA
Expenditure‖ field does not
equal the amount in the
―Award Amount‖ field, and
confirming that no more
funds will be expended by
the prime recipient.
Project Status
For Federally Awarded
Contracts
A description of all
significant services
performed/supplies
delivered, including
construction, for which the
prime contractor invoiced in
this calendar quarter.
Evaluation of completion
status of the project, activity,
or federally awarded contract
action funded by the
Recovery Act. The status of
the work that has been
completed. This evaluation
should be based on
performance progress reports
and other relevant nonfinancial performance
string
20
"Fully
Completed"
This is a
mandatory
field.
Options for
selection:
Not
started;
Less
than 50%
completed;
Page 16 of 46
April 1, 2009
Federal
Register
This is a
mandatory
field
Data Element
Definition
Type
Max
Lengt
h
Example
Options for selection: Not
started; Less than 50%
completed; Completed 50%
or more; Fully Completed.
Activity Code
(NAICS or
NTEE-NPC)
Control
Validation
and
Business
Rule(s)
Com
pleted 50%
or more;
Fully
Completed.
information.
For awards funding multiple
projects such as formula
block grants, provide your
best estimate of completion
of all projects based on any
aggregate data and
information.
For Federally Awarded
Contracts: Enter the 6-digit
North American Industry
Classification System
(NAICS) code found in the
solicitation/contract.
Comments
string
20 115310
For Grants and Loans:
For awards primarily funding
infrastructure projects, enter
the North American Industry
Classification System
(NAICS) code(s) that
describe the Recovery Act
projects or activities under
this award. A searchable
Page 17 of 46
NAICS April 1, 2009
annual; NPC Federal
- annual
Register
This is a
mandatory
field
Data Element
Definition
Type
Max
Lengt
h
Example
Comments
2000
Support
Activities for
Forestry
This field is
inferred
from the
Activity
Code
entered/prov
ided
Control
Validation
and
Business
Rule(s)
code list is at
http://www.census.gov/naics/
.
Activity
Description
For all other awards, provide
the National Center for
Charitable Statistics
‗‗NTEE–NPC‘‘ code(s) that
describe the Recovery Act
projects or activities under
this award. A searchable
code list is at
http://nccsdataweb.urban.org/
PubApps/nteeSearch.
php?gQry=allcore&codeType=NPC.
Description of the Activity
string
Code for NAICS or NTEENPC.
Page 18 of 46
This field
is inferred
from the
Activity
Code
entered/pro
vided
Data Element
Number Of Jobs
Definition
Type
Jobs created and retained. An Number
estimate of the combined
number of jobs created and
jobs retained funded by the
Recovery Act during the
current reporting quarter in
the United States and
outlying areas. For grants
and loans, the number shall
include the number of jobs
created and retained by sub
recipients and vendors. The
number shall be expressed as
‗‗full-time equivalent‘‘
(FTE), calculated quarterly
as all hours worked and
funded by the Recovery Act
during the current reporting
quarter divided by the total
number of hours in a fulltime schedule for the quarter,
as defined by the recipient or
federal contractor. For more
information on how to
perform this calculation,
please see OMB
Memorandum M-10-08,
found at
http://www.whitehouse.gov/o
mb/assets/memoranda_2010/
Max
Lengt
h
10
Example
100
Page 19 of 46
Comments
This is a
mandatory
field.
Control
Validation
and
Business
Rule(s)
This is a
mandatory
field.
Data Element
Definition
Type
Max
Lengt
h
m10-08.pdf. An example of
calculating jobs for federal
contractors can be found at
http://www.whitehouse.gov/o
mb/recovery_faqs_contractor
s.
For instance, two full-time
employees and one part-time
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.
Page 20 of 46
Example
Comments
Control
Validation
and
Business
Rule(s)
Data Element
Definition
Type
Max
Lengt
h
(ii) Howland Island.
(iii) Jarvis Island.
(iv) Johnston Atoll.
(v) Kingman Reef.
(vi) Midway Islands.
(vii) Navassa Island.
(viii) Palmyra Atoll.
(ix) Wake Atoll.
For Grants and Loans:
See OMB M-10-08
For Federally Awarded
Contracts: See FAR
Clause 52.204-11
Page 21 of 46
Example
Comments
Control
Validation
and
Business
Rule(s)
Data Element
Description of
Jobs
Created/Retained
Definition
A narrative description of the
employment impact of the
Recovery Act funded work.
This narrative is for each
calendar quarter and at a
minimum, will address the
impact on the recipient‘s or
federal contractor‘s
workforce (for grants and
loans, recipients shall also
include the impact on the
workforces of sub recipients
and vendors and for Federal
contracts, see FAR clause
52.204-11 in the contract).
Type
string
Max
Lengt
h
4000
Provide a brief narrative
description of the types of
jobs created and jobs retained
in the United States and
outlying areas. 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.
Page 22 of 46
Example
Comments
This is a
mandatory
field.
Control
Validation
and
Business
Rule(s)
April 1, 2009
This is a
Federal
mandatory
Register ARRA field
Data Element
Amount of
Award
Definition
For Grants:
The total amount of
Recovery Act dollars on the
award.
For Loans:
The total Recovery Act
amount of the loan obligated
by the Federal Agency. This
is the face value of the loan.
Total Federal
Amount ARRA
Funds
Received/Invoice
d
For Federally Awarded
Contracts:
The total Recovery Act
amount obligated by the
Federal Agency.
For Grants and Loans: The
amount of Recovery Act
funds received through drawdown, reimbursement or
invoice.
Type
Max
Lengt
h
Currenc
y
(Dollar
value numeric
)
18,21
Currenc
y
(Dollar
value numeric
)
18,2
Example
Comments
Control
200000.01
Total
specific
federal
funding as
indicated on
the award
document
April 1, 2009
Federal
Register
Transparency
Act Guidance
March 30, 2007
200000.01
This is a
mandatory
field
April 1, 2009
This is a
Federal
mandatory
Register ARRA field.
For Federally Awarded
Contracts: The amount of
Recovery Act funds invoiced
by the federal contractor
(cumulative).
1
The data length of 18,2 indicates total length of 18 characters with 2 characters after the decimal.
Page 23 of 46
Validation
and
Business
Rule(s)
This is a
mandatory
field
Data Element
Total Federal
Amount of
ARRA
Expenditure
Definition
This is for grants and loans
only.
Amount of recovery funds
received or will be received
that were expended to
projects or activities
(‗‗Federal Share of
Expenditures‘‘). The
cumulative total for the
amount of Federal fund
expenditures, which may
include amounts captured in
other fields as well, such as
amounts in ―Total Federal
ARRA Infrastructure
Expenditure,‖ ―Total
Amount of Payments to
Vendors less than
$25,000/Award,‖ and/or
―Total Subaward Funds
Disbursed.‖ 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
Type
Max
Lengt
h
Currenc
y
(Dollar
value numeric
)
18,2
Example
200000.01
Page 24 of 46
Comments
This only
applies to
grants and
loans .
Control
Validation
and
Business
Rule(s)
April 1, 2009
Total
Federal
Federal
Register ARRA Amount of
ARRA
Expenditur
e should
not exceed
the Amount
of Award
Data Element
Total Federal
ARRA
Infrastructure
Expenditure
Definition
Type
subcontractors and
Subawardees. For reports
prepared on an accrual basis,
expenditures are the sum of
disbursements for direct
charges for property and
services; the amount of
indirect expense incurred;;
and the total amount 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. The recipient will
determine whether to report
on a cash or accrual basis
based upon their record
keeping system.
This is for grants and loans Currenc
only Total federal ARRA
y
Infrastructure expenditure
(Dollar
value numeric
)
Max
Lengt
h
18,2
Example
200000.01
Page 25 of 46
Comments
This is a
conditional
field for
investing in
infrastructur
e
Control
April 1, 2009
Federal
Register
Validation
and
Business
Rule(s)
This is a
conditional
field for
investing in
infrastructu
re
Data Element
Infrastructure
Purpose and
Rationale
Definition
Type
This is for grants and loans string
only Purpose and rationale of
funds received for
infrastructure investment
with funds made available
under the Recovery Act.
Identify the purpose and
explain how the
infrastructure investment will
contribute to one or more
purposes of 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
Max
Lengt
h
Variab
le
(Maxi
mum
4000
charac
ters)
Page 26 of 46
Example
Comments
This is a
conditional
field. If
reporting
infrastructur
e
investment,
a
rationale/ex
planation
has to be
provided.
Control
Validation
and
Business
Rule(s)
April 1, 2009
This is a
Federal
conditional
Register ARRA field. If
reporting
infrastructu
re
investment,
a
rationale/ex
planation
has to be
provided.
Data Element
Definition
Type
Max
Lengt
h
Example
Comments
Control
This field is
a
conditional
requirement
associated
with
infrastructur
e investment
April 1, 2009
Federal
Register
Transparency
Act Guidance
March 30, 2007
local government budgets, in
order to minimize and
avoid reductions in essential
services and
counterproductive state and
local tax increases.
Infrastructure
Contact Name
Infrastructure
Contact Street
Address 1
Infrastructure
Contact Street
Address 2
This is for grants and loans
only Name, phone number,
address and email address of
the appropriate contact.
string
120
string
55
string
55
Page 27 of 46
Validation
and
Business
Rule(s)
Data Element
Definition
Type
Max
Lengt
h
Example
Comments
Control
Validation
and
Business
Rule(s)
Infrastructure
Contact Street
Address 3
string
55
Infrastructure
Contact City
string
35
Infrastructure
Contact State
string
2
Infrastructure
State/Local
Contact Zip Code
+4
string
9
Infrastructure
Contact Email
string
320
Infrastructure
Contact Phone
string
30
Infrastructure
Contact Extn
string
10
string
55
This field is
optional.
This field
is optional.
string
55
This field is
optional
This field
is optional
Primary Place of
Performance –
Street Address 1
Primary Place of
Performance –
Street Address 2
Recipient Primary Place of
Performance (city, state,
congressional district, and
country) physical location of
primary place of
performance.
Page 28 of 46
Data Element
Definition
Primary Place of
Performance –
State
Primary Place of
Performance –
Country
Primary Place of
Performance –
Zip Code + 4
Primary Place of
Performance –
City
Primary Place of
Performance Congressional
District
Prime Recipient
indication of
reporting
applicability
Type
Max
Lengt
h
Example
string
2
MD
string
2
US
string
9
220334902
string
35
Rockville
string
2
08
string
3
Yes
Names and total
compensation of each of the
five most highly
compensated officers of the
recipient for the calendar
year in which the award is
awarded if—
Page 29 of 46
Comments
This is a
mandatory
field
This is a
mandatory
field
This is the 2
letter alpha
code.
This is a
mandatory
field
This is a
mandatory
field
This is a
mandatory
field
This is a
Yes or No
field
Control
Validation
and
Business
Rule(s)
April 1, 2009
This is a
Federal
mandatory
Register
field.
Transparency
This is a
Act Guidance
mandatory
March 30, 2007 field
This is a
mandatory
field.
This is a
mandatory
field.
This is a
mandatory
field.
If all of the
conditions
in the
definition
apply the
recipient
must report
in the
highly
Data Element
Definition
Type
Max
Lengt
h
(i) In the recipient‘s
preceding fiscal year, the
recipient received—
(A) 80 percent or more of its
annual gross revenues from
Federal contracts (and
subcontracts), loans, grants
(and subgrants) and
cooperative agreements; and
(B) $25,000,000 or more in
annual gross revenues from
Federal contracts (and
subcontracts), loans, grants
(and subgrants) and
cooperative agreements; and
(ii) The public does not have
access to information about
the compensation of the
senior executives 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.
Page 30 of 46
Example
Comments
Control
Validation
and
Business
Rule(s)
compensate
d fields
Data Element
Prime Recipient
Highly
Compensated
Name(5)
Definition
Names of each of the five
most highly compensated
officers of the recipient for
the calendar year in which
the award is awarded if—
Type
string
array
Max
Lengt
h
55
Example
Tom Jones
John Doe
Mary Smith
Ivana B. Rich
Amanda King
(i) In the recipient‘s
preceding fiscal year, the
recipient received—
(A) 80 percent or more of its
annual gross revenues from
Federal contracts (and
subcontracts), loans, grants
(and subgrants) and
cooperative agreements; and
Comments
Control
This is a
April 1, 2009
conditional
Federal
field based
Register
on the
―Prime
Recipient
indication of
reporting
applicability
‖ data
element
Validation
and
Business
Rule(s)
This is a
conditional
field based
on the
―Prime
Recipient
indication
of reporting
applicabilit
y‖ data
element
If all of the
conditions
in the
definition
apply the
recipient
must report
in the
highly
compensate
d fields
(B) $25,000,000 or more in
annual gross revenues from
Federal contracts (and
subcontracts), loans, grants
(and subgrants) and
cooperative agreements; and
(ii) The public does not have
access to information about
the compensation of the
senior executives through
periodic reports filed under
Section 13(a) or 15(d) of the
Page 31 of 46
Data Element
Definition
Type
Max
Lengt
h
Currenc
y Array
(Dollar
value numeric
)
18,2
Example
Comments
Control
Validation
and
Business
Rule(s)
Securities Exchange Act of
1934 (15 U.S.C. 78m(a),
78o(d)) or Section 6104 of
the Internal Revenue Code of
1986.
Prime Recipient
Highly
Compensated
Compensation(5)
(Conditional)
For the five most highly
compensated officers of the
recipient: total compensation
‗‗Total compensation‘‘ is
defined for
100000.01
500000.01
400000.01
350000.01
700000.01
Federally Awarded
Contracts:
FAR Clause 52.204-11
Grants and Loans:
‗‗Total compensation‘‘
means the cash and noncash
dollar value earned by the
executive during the sub
recipient‘s past fiscal year of
This is a
April 1, 2009
conditional
Federal
field based
Register
on the
―Prime
Recipient
indication of
reporting
applicability
‖ data
element
This is a
conditional
field based
on the
―Prime
Recipient
indication
of reporting
applicabilit
y‖ data
element
If all of the
conditions
in the
definition
Page 32 of 46
Data Element
Definition
Type
Max
Lengt
h
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 tax-qualified.
Page 33 of 46
Example
Comments
Control
Validation
and
Business
Rule(s)
apply the
recipient
must report
in the
highly
compensate
d fields
Data Element
Total Number of
Sub-awards to
individuals
Total Amount of
Sub-awards to
individuals
Total Number of
payments to
vendors less than
$25,000/award
Total Amount of
payments to
vendors less than
$25,000/award
Definition
(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.
Total Number of Sub-awards
to individuals.
Total Amount of Sub-awards
to individuals. Amounts
reported are cumulative for
the award.
Type
string
Currenc
y
(Dollar
value numeric
)
For Grants and Loans Only string
Total Number of payments
by the prime recipient to
vendors less than
$25,000/award.
For Grants and Loans Only Currenc
Total Amount of payments
y
by the prime recipient to
(Dollar
vendors less than
value $25,000/award for the
numeric
reporting quarter. Amounts
)
Max
Lengt
h
6
18,2
6
18,2
Example
Comments
Control
Validation
and
Business
Rule(s)
10
This is a
mandatory
field
April 1, 2009
Federal
Register
This is a
mandatory
field
240000.01
This is a
mandatory
field
April 1, 2009
Federal
Register
This is a
mandatory
field
10
This is a
mandatory
field
April 1, 2009
Federal
Register
20000.01
No single
Sub-award
can exceed
$24,999 or
must be
submitted
April 1, 2009
Federal
Register
This is a
mandatory
field for
grants and
loans
This is a
mandatory
field for
grants and
loans
Page 34 of 46
Data Element
Definition
Type
Max
Lengt
h
Example
reported are cumulative for
the award.
Total Number of
Sub-awards less
than
$25,000/award.
Total Number of Sub-awards
less than $25,000/award.
string
Total Amount of
Subawards less
than
$25,000/award.
Total Amount of Subawards
less than $25,000/award for
the reporting quarter.
Amounts reported are
cumulative for the award.
Currenc
y
(Dollar
value numeric
)
SUB RECIPIENT DATA ELEMENTS
Sub recipient
The sub recipient
string
DUNS Number
organization‘s 9- digit Data
Universal Numbering System
(DUNS) number
Subaward
Subaward Number or Other
string
Number
Identifying Number
Assigned by the Recipient
Entity
6
18,2
10
Comments
individually
in the
vendor
Section of
the report.
This is a
mandatory
field
Control
Validation
and
Business
Rule(s)
April 1, 2009
Federal
Register
This is a
mandatory
field
20000.01
No single
Sub-award
can exceed
$24,999 or
must be
submitted
individually
in the
subrecipeint
Section of
report.
April 1, 2009
Federal
Register
This is a
mandatory
field
9
123456789
9digit
DUNS# is
mandatory
April 1, 2009
Federal
Register
This is a
mandatory
field.
55
Sub-award
number provided
by Prime
Recipient
Prime
Recipient
assigns a
sub-award
April 1, 2009
Federal
Register
This is a
mandatory
field.
Page 35 of 46
Data Element
Sub recipient
Legal Name
Definition
Max
Lengt
h
string
120
string
120
string
55
string
55
Sub recipient
Address 3
Sub recipient City
string
55
string
35
Sub recipient
State
Sub recipient
Zip+4
Sub recipient
Country
Sub recipient
Congressional
District
string
2
string
9
string
3
string
2
Sub recipient
DBA Name
Sub recipient
Address 1
Sub recipient
Address 2
The legal name of sub
recipient as registered in
CCR or D&B
The Doing-Business-As
(DBA) name of sub recipient
as registered in CCR or D&B
Sub recipient Location.
Physical location as listed in
the Central Contractor
Registration.
Type
Example
This field is
inferred; obtained
through CCR or
D&B.
51
Page 36 of 46
Comments
number
(federally
awarded
contract,
grant, loan)
to the Sub
Recipient
The System
will pull this
information
from CCR
or D&B
This field is
mandatory
Control
Validation
and
Business
Rule(s)
April 1, 2009
Federal
Register
Data
Populated
from
details
found in
CCR or
D&B
through the
DUNS#
look-up
April 1, 2009
Federal
Register
This is a
mandatory
field
Data Element
Sub recipient
Type
Amount of
Subaward
Definition
This data element is inferred
from CCR. The field inferred
is ―Business Type‖ in CCR.
The anticipated total amount
of funds to be disbursed to
the sub-awardee over the life
of the award.
For Federally Awarded
Contracts: Total amount of
subcontract
Type
string
Currenc
y
(Dollar
value numeric
)
Max
Lengt
h
300
18,2
Example
2F - U.S. State
Government
M8 - Educational
Institution
200000.01
Page 37 of 46
Comments
The System
will pull this
field from
CCR
Control
April 1, 2009
Federal
Register
Sub Awards April 1, 2009
over
Federal
$25,000.
Register
Reports are
cumulative
and
aggregated
by
subrecipient.
Multiple
subawards
to a single
subrecipient
under the
same award
should be
aggregated
and reported
in this field
if the
cumulative
total
exceeds
$25,000 for
the quarter.
Validation
and
Business
Rule(s)
Fixed list
from CCR
This is a
mandatory
field
Data Element
Total Subaward
Funds Disbursed
Subaward Date
Sub recipient
Primary Place of
Performance –
Street Address 1
Sub recipient
Primary Place of
Performance –
Street Address 2
Sub recipient
Place of
Performance State
Sub recipient
Place of
Performance –
Country
Sub recipient
Place of
Definition
For Grants and Loans Only
Amount of Subaward
Disbursed. The cumulative
amount of cash disbursed to
the sub-awardee as of the
reporting period end date.
Subaward Date. The date the
Subaward was signed
(mm/dd/yyyy).
Sub recipient Place of
Performance (city, state,
congressional district, and
country). The physical
location of primary place of
performance.
Type
Max
Lengt
h
Example
Currenc
y
(Dollar
value numeric
)
Date
(YYYY
MMDD
)
string
18,2
200000.01
8
20091212
55
string
55
string
2
MD
string
2
US
Comments
The date is
found on the
sub-award
document
This field is
optional.
Control
April 1, 2009
Federal
Register
Validation
and
Business
Rule(s)
This field
is
mandatory
April 1, 2009
Federal
Register
This field
is
mandatory
This field
is optional.
This field is
optional
This field is
mandatory
This field
is optional
April 1, 2009
Federal
Register
Transparency
Act Guidance
March 30, 2007
This field
is
mandatory
This field
is
mandatory
This is the 2
letter alpha
code.
string
9
220334902
Page 38 of 46
This field
is
Data Element
Definition
Type
Max
Lengt
h
Example
Comments
Performance –
Zip Code + 4
Sub recipient
Place of
Performance City
Sub recipient
Place of
Performance Congressional
District
Sub Recipient
indication of
reporting
applicability
Names and total
compensation of each of the
five most highly
compensated officers of the
sub recipient for the calendar
year in which the awarded is
awarded if—
Control
Validation
and
Business
Rule(s)
mandatory
string
35
Rockville
string
2
8
This field is
mandatory
This field
is
mandatory
string
3
Yes
This is a
Yes or No
field
If all of the
conditions
in the
definition
apply the
recipient or
delegated
sub
recipient
must report
in the
highly
compensate
d fields
(i) In the sub recipient‘s
preceding fiscal year, the sub
recipient received—
(A) 80 percent or more of its
annual gross revenues from
Federal contracts (and
subcontracts), loans, grants
(and subgrants) and
cooperative agreements; and
Page 39 of 46
This field
is
mandatory
Data Element
Definition
Type
Max
Lengt
h
(B) $25,000,000 or more in
annual gross revenues from
Federal contracts (and
subcontracts), loans, grants
(and subgrants) and
cooperative agreements; and
(ii) The public does not have
access to information about
the compensation of the
senior executives 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.
Page 40 of 46
Example
Comments
Control
Validation
and
Business
Rule(s)
Data Element
Sub Recipient
Highly
Compensated
Name(5)
Definition
Names of each of the five
most highly compensated
officers of the sub recipient
for the calendar year in
which the award is awarded
if—
Type
string
array
Max
Lengt
h
55
Example
Tom Jones
John Doe
Mary Smith
Ivana B. Rich
Amanda King
(i) In the sub recipient‘s
preceding fiscal year, the sub
recipient received—
(A) 80 percent or more of its
annual gross revenues from
Federal contracts (and
subcontracts), loans, grants
(and subgrants) and
cooperative agreements; and
Comments
Control
This is a
April 1, 2009
conditional
Federal
field based
Register
on the sub
recipient
indication of
reporting
applicability
data element
Validation
and
Business
Rule(s)
This is a
conditional
field based
on the ―Sub
Recipient
indication
of reporting
applicabilit
y‖ data
element
If all of the
conditions
in the
definition
apply the
recipient or
delegated
sub
recipient
must report
in the
highly
compensate
d fields
(B) $25,000,000 or more in
annual gross revenues from
Federal contracts (and
subcontracts), loans, grants
(and subgrants) and
cooperative agreements; and
(ii) The public does not have
access to information about
the compensation of the
senior executives through
periodic reports filed under
Page 41 of 46
Data Element
Definition
Type
Max
Lengt
h
Currenc
y Array
(Dollar
value numeric
)
18,2
Example
Comments
Control
Validation
and
Business
Rule(s)
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.
Sub Recipient
Highly
Compensated
Compensation(5)
(Conditional)
For the five most highly
compensated officers of the
sub recipient: total
compensation
‗‗Total compensation‘‘ is
defined for
100000.01
500000.01
400000.01
350000.01
700000.01
Federally Awarded
Contracts:
FAR Clause 52.204-11
This is a
April 1, 2009
conditional
Federal
field based
Register
on the sub
recipient
indication of
reporting
applicability
data
element.
This is a
conditional
field based
on the ―Sub
Recipient
indication
of reporting
applicabilit
y‖ data
element
If all of the
conditions
in the
Grants and Loans:
‗‗Total compensation‘‘
means the cash and noncash
Page 42 of 46
Data Element
Definition
Type
Max
Lengt
h
dollar value earned by the
executive during the sub
recipient‘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.
Page 43 of 46
Example
Comments
Control
Validation
and
Business
Rule(s)
definition
apply the
recipient
must report
in the
highly
compensate
d fields
Data Element
Definition
Type
Max
Lengt
h
Example
(v). Above-market earnings
on deferred compensation
which are not tax-qualified.
(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.
VENDOR DATA ELEMENTS (All these elements are for Grants and Loans Only)
Award Number – For Grants and Loans
string
50
Varies by award
Prime Recipient
and agencies
Only:
Vendor
Identifying Number
Assigned by the prime
recipient.
Subaward
Number – Subrecipient Vendor
For Grants and Loans
Only:
Award Number or Other
Identifying Number
Assigned by the Subrecipient
string
55
Sub-award
number provided
by Prime
Recipient
Vendor DUNS
Number
For Grants and Loans
Only:
Vendor DUNS Number. The
vendor‘s 9 digit Data
string
9
123456789
Page 44 of 46
Comments
Control
Validation
and
Business
Rule(s)
Complete
this field if
submitting
Prime
Recipient
vendor
information.
Complete
this field if
submitting
Sub
Recipient
vendor
information.
DUNS#
9digit is
preferred.
See
April 1, 2009
Federal
Register
Transparency
Act Guidance
March 30, 2007
This is a
mandatory
field for
Prime
Recipient
Report
April 1, 2009
Federal
Register
This is a
mandatory
field for
Sub
Recipient
Report
April 1, 2009
Federal
Register
Data Element
Definition
Type
Max
Lengt
h
Example
Universal Numbering System
(DUNS) number
Comments
Control
comments
for Vendor
HQ Zip
Code and
Vendor
Name data
elements
Vendor HQ Zip
Code + 4
For Grants and Loans
Only:
The zipcode of the vendor's
headquarters.
string
9
220334902
Vendor Name
For Grants and Loans
Only:
The name of the vendor.
string
55
ROOFING
RESOURCES
INC
Product and
Service
Description
For Grants and Loans
Only:
A description of the product
and/or service provided by
the vendor
This field is optional for
vendors of sub-recipients
string
255
Runway repair
Page 45 of 46
Vendor HQ
Zip Code
and Vendor
Name are
required if
DUNS# is
not available
Vendor HQ
Zip Code
and Vendor
Name are
required if
DUNS# is
not available
Short
April 1, 2009
description
Federal
of product
Register
and/or
service
Validation
and
Business
Rule(s)
Data Element
Payment Amount
Definition
For Grants and Loans
Only:
The amount invoiced to the
vendor (aggregated) that will
be paid with ARRA funds
Type
Max
Lengt
h
Currenc
y
(Dollar
value numeric
)
18,2
Example
50000.01
This field is optional for
vendors of sub-recipients
Page 46 of 46
Comments
Payments
exceeding
$25,000 for
the quarter
are reported.
Amount
reported is
cumulative
and
aggregated
by vendor.
Multiple
payments to
a single
vendor
under the
same award
should be
aggregated
and reported
in this field
if the
cumulative
total
exceeds
$25,000 for
the quarter.
Control
April 1, 2009
Federal
Register
Validation
and
Business
Rule(s)
| File Type | application/pdf |
| Author | carltongravatt |
| File Modified | 2013-03-13 |
| File Created | 2010-09-30 |