Download:
pdf |
pdf“Transparency, Accountability, and
Oversight”
Recipient Reporting
Data Model
V3.0
FINAL PRODUCTION RELEASE
- for Quarter Ending December 31, 2009
Note: this model may be adjusted for future reporting cycles
Recipient Reporting Data Model- For
Quarter Ending 12/31/2009
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 December
31, 2009. 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 23
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Dictionary
The data dictionary describes the data elements specifically required for recipient reporting under the American Recovery and Reinvestment Act of 2009 (ARRA).
Table 1 - Recipient Reporting Data Dictionary
Data
Elements
Data Element
Yellow – Input (user provided)
Blue – System provided (e.g. CCR, Agency Code Reference Table)
Definition
RECIPIENT DATA ELEMENTS
Funding Agency Code
Numeric code of Federal Agency that is responsible
for funding/distributing the ARRA funds to
Recipients.
Type
Max
Length
string
4
Example
6800
Comments
Control
Validation and
Business
Rule(s)
Federal Agency
code is
mandatory for
Recipient
Reporting.
April 1, 2009 Federal
Register Transparency
Act Guidance March
30, 2007
This is a
mandatory field.
The Funding
Agency is the
agency that
receives the
ARRA funds
through the
ARRA funds
appropriation.
Initial Reference:
fips95-2.pdf
Latest Reference:
NIST Special
Publication 800-87
Funding Agency Name
The Federal Agency name corresponding to the
Federal Agency Code used.
string
55
ENVIRONME
NTAL
PROTECTION
AGENCY
Inferred given
the Funding
Agency Code
April 1, 2009 Federal
Register Transparency
Act Guidance March
30, 2007
This field is
inferred given
the Funding
Agency Code
provided
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
This is a
mandatory field.
In many cases,
the Awarding
Page 3 of 23
Initial Reference:
fips95-2.pdf
Latest Reference:
NIST Special
Publication 800-87
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Element
Definition
Type
Max
Length
Example
Comments
Control
Validation and
Business
Rule(s)
Agency is the
same as the
Funding
Agency.
In some cases,
such as some
contracts –the
Funding
Agency (e.g.
HHS) delegates
the
administration
and awarding
responsibilities
to another
agency like
GSA.
Inferred given
the Awarding
Agency Code
Awarding Agency Name
The Federal Agency name corresponding to the
Awarding Agency Code used.
string
55
GENERAL
SERVICES
ADMINISTRA
TION
Program Source (TAS)
The Agency Treasury Account Symbol (TAS) that
identifies the funding Program Source. This
Program Source is based out of the OMB TAS list.
string
17
TRAGENCY
(2) + "-" +
TRACCT (4) +
"-" +
SUBACCT(3)
Assuming that
Agencies will
provide the
code to
Recipient
Note: The
SUBACCT (3)
is optional; i.e.
only provided
when
applicable
Note: Program
Source (TAS) is
mandatory for
Recipient
Reporting.
Federal Contractors may find the TAS in their
contract or by calling the contracting officer.
Page 4 of 23
April 1, 2009 Federal
Register Transparency
Act Guidance March
30, 2007
Transparency Act
Guidance March 30,
2007
This field is
inferred given
the Awarding
Agency Code
provided
OMB TAS list.
This is a
mandatory field.
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Element
Award Number
Order Number
Definition
The identifying number assigned by the awarding
Federal Agency, such as the federal grant number,
federal contract number or the federal loan number.
This data element only applies to Contract.
Type
string
string
Max
Length
50
50
Example
Varies by
award and
agencies
Varies by
award and
agencies
Comments
Control
The award
number is case,
space and
special
character
sensitive. It
should be the
same as it
appears in the
federal award
document.
April 1, 2009 Federal
Register Transparency
Act Guidance March
30, 2007
Award Number
is mandatory
for Recipient
Reporting
This is a
contract only
data element. If
applicable,
order number
should be
entered;
otherwise the
field should be
left blank.
Validation and
Business
Rule(s)
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 award
document.
This is an
optional field.
This is only for
Contract.
The order
number is case,
space and
special
character
sensitive. It
should be the
same as it
appears in the
federal award
document.
Recipient DUNS Number
The prime recipient organization‘s 9-digit Data
Universal Numbering System (DUNS) number
string
Page 5 of 23
9
123456789
The 9-digit
DUNS# is
mandatory
April 1, 2009 Federal
Register Transparency
Act Guidance March
30, 2007
This is a
mandatory field.
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Element
Definition
Type
Max
Length
Example
Comments
Control
Validation and
Business
Rule(s)
Parent DUNS Number
Unique Identifier of Parent Organization / Company
(DUNS No.)
string
9
This field is
inferred;
obtained
through CCR.
The System will
pull the parent
organization‘s
DUNS# from
CCR
Transparency Act
Guidance March 30,
2007
Recipient Type
This data element is inferred from CCR. The field
inferred is ―Business Type‖ in CCR.
string
300
2F - U.S. State
Government
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.
CFDA Number
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
6
Government Contracting
Office Code
The agency supplied code of the contracting office
that executes the transaction.
string
6
Government Contracting
Office Name
The government contracting office name inferred
from the government contracting office code used.
string
100
Recipient Legal Name
Recipient name and address of Organization. The
legal and DBA (Doing-Business-As) 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
string
55
Recipient Address 2
string
55
Recipient Address 3
string
55
Recipient City
string
35
Recipient State
string
2
Recipient DBA Name
Recipient Address 1
Page 6 of 23
M8 Educational
Institution
66.039
064MA
DEPT OF
AGRIC/FARM
ERS HOME
ADMINISTRA
TION
This field is
inferred;
obtained
through CCR
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
Inferred given
the
Government
Contracting
Office Code
The System will
pull this
information
from CCR
This field only
applies to
federally
awarded
contracts.
April 1, 2009 Federal
Register Transparency
Act Guidance March
30, 2007
This field only
applies to
federally
awarded
contracts.
Data populated
from details
found in CCR
through the
Recipient
DUNS# look-up
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Element
Definition
Type
Max
Length
Recipient Zip Code
string
9
Recipient Country
string
3
Recipient Congressional
District)
string
2
Example
Comments
Control
Validation and
Business
Rule(s)
51
This field is
mandatory.
April 1, 2009 Federal
Register
This is a
mandatory field.
This field is
optional.
This is an
internal tracking
number for the
Prime Recipient
community.
April 1, 2009 Federal
Register
This is an
optional field.
Recipient Account
Number
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.
string
255
Final Report
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.
string
1
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
Award Type
Award Type—Grant, Loan, or Federally Awarded
Contract
string
8
GRANT
This is a
mandatory field.
Transparency Act
Guidance March 30,
2007
This is a
mandatory field.
Date
(YYYYM
MDD)
string
8
20090530
This is a
mandatory field.
This is a
mandatory field.
Special
Education PART
B/PRESCHO
OL
This is a
mandatory field.
Transparency Act
Guidance March 30,
2007
April 1, 2009 Federal
Register Transparency
Act Guidance March
30, 2007
F006: Land
Treatment
Practices
Services
Title as
indicated on the
Award
document/Prod
April 1, 2009 Federal
Register
This field only
applies to
Grants and
Loans.
Award Date
Award Description
Project Name or
Project/Program Title
Other types of federal financial assistance not
specifically identified above should be reported
under the award type of Grant.
The date when the award is signed.
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. For example, ‗‗community development,‘‘
‗‗comprehensive community mental health services
to adults with a serious mental illness,‘‘ etc.
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 Recovery Act funds
string
4000
256
Page 7 of 23
This is a
mandatory field.
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Element
Quarterly
Activities/Project
Description
Project Status
Definition
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 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 may be stated in broad terms.
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 non-financial performance information.
Type
Max
Length
string
2000
string
20
Example
Comments
(plowing/cleari
ng, etc.)
Powers and
Gold Beach
Ranger
Districts Curry
County OR
Has Fuels
Item 1 Chetco
Area and Item
3 - Powers
Area
uct or Service
Code
This is a
mandatory field
April 1, 2009 Federal
Register
This is a
mandatory field
"Fully
Completed"
This is a
mandatory field.
April 1, 2009 Federal
Register
This is a
mandatory field
Options for
selection:
Not started;
Less than
50%
completed;
Completed
50% or more;
Fully
Completed.
Options for selection: Not started; Less than 50%
completed; Completed 50% or more; Fully
Completed.
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.
Page 8 of 23
Control
Validation and
Business
Rule(s)
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Element
Activity Code (NAICS or
NTEE-NPC)
Definition
For Federally Awarded Contracts: Enter the 6digit North American Industry Classification System
(NAICS) code found in the solicitation/contract.
Type
Max
Length
string
20
Example
Comments
115310
NAICS annual; NPC annual
Support
Activities for
Forestry
This field is
inferred from
the Activity
Code
entered/provide
d
This is a
mandatory field.
Control
April 1, 2009 Federal
Register
Validation and
Business
Rule(s)
This is a
mandatory field
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 code list is at
http://www.census.gov/naics/.
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=all-core&codeType=NPC.
Activity Description
Description of the Activity Code for NAICS or NTEENPC.
string
Number Of Jobs
Jobs created and retained. An 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/omb/assets/memoranda
_2010/m10-08.pdf. An example of calculating jobs
for federal contractors can be found at
http://www.whitehouse.gov/omb/recovery_faqs_cont
ractors.
Number
2000
10
For instance, two full-time employees and one part-
Page 9 of 23
100
This field is
inferred from
the Activity
Code
entered/provide
d
This is a
mandatory field.
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Element
Definition
Type
Max
Length
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.
(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 Memo M-1008
For Federally Awarded Contracts: See FAR
Clause 52.204-11
Page 10 of 23
Example
Comments
Control
Validation and
Business
Rule(s)
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
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).
Type
string
Max
Length
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 11 of 23
Example
Comments
This is a
mandatory field.
Control
April 1, 2009 Federal
Register ARRA
Validation and
Business
Rule(s)
This is a
mandatory field
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Element
Amount of Award
Definition
For Grants:
The total amount of Federal dollars on the award.
For Loans:
The total amount of the loan obligated by the
Federal Agency. This is the face value of the loan.
Total Federal Amount
ARRA Funds
Received/Invoiced
For Federally Awarded Contracts:
The total amount obligated by the Federal Agency.
For Grants and Loans: The amount of Recovery
Act funds received through draw-down,
reimbursement or invoice.
Type
Max
Length
Currenc
y (Dollar
value numeric)
18,21
Currenc
y (Dollar
value numeric)
18,2
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 12 of 23
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 Federal
Register ARRA
Validation and
Business
Rule(s)
This is a
mandatory field
This is a
mandatory field.
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Element
Definition
Type
Max
Length
Example
Comments
Control
Total Federal Amount of
ARRA Expenditure
This is for grants and loans only.
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;
the value of third-party in-kind contributions applied;
and the amount of cash advance payments and
payments made to subcontractors and
Subawardees. 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;
the value of in-kind contributions applied; 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.
Currenc
y (Dollar
value numeric)
18,2
200000.01
This only
applies to
grants and
loans .
April 1, 2009 Federal
Register ARRA
Total Federal ARRA
Infrastructure Expenditure
This is for grants and loans only Total federal
ARRA Infrastructure expenditure
Currenc
y (Dollar
value numeric)
18,2
200000.01
This is a
conditional field
for investing in
infrastructure
April 1, 2009 Federal
Register
Page 13 of 23
Validation and
Business
Rule(s)
Total Federal
Amount of
ARRA
Expenditure
should not
exceed the
Amount of
Award
This is a
conditional field
for investing in
infrastructure
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Element
Definition
Type
Max
Length
Example
Comments
Control
Infrastructure Purpose
and Rationale
This is for grants and loans 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 local government budgets,
in order to minimize and
avoid reductions in essential services and
counterproductive state and
local tax increases.
string
Variable
(Maximu
m 4000
characte
rs)
This is a
conditional
field. If
reporting
infrastructure
investment, a
rationale/explan
ation has to be
provided.
April 1, 2009 Federal
Register ARRA
Infrastructure Contact
Name
This is for grants and loans only Name, phone
number, address and email address of the
appropriate contact.
string
120
April 1, 2009 Federal
Register Transparency
Act Guidance March
30, 2007
Infrastructure Contact
Street Address 1
string
55
This field is a
conditional
requirement
associated with
infrastructure
investment
Infrastructure Contact
Street Address 2
string
55
Infrastructure Contact
Street Address 3
string
55
Infrastructure Contact City
string
35
Infrastructure Contact
State
string
2
Page 14 of 23
Validation and
Business
Rule(s)
This is a
conditional
field. If
reporting
infrastructure
investment, a
rationale/explan
ation has to be
provided.
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Element
Definition
Type
Max
Length
Example
Comments
Control
Validation and
Business
Rule(s)
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
string
2
MD
string
2
US
Primary Place of
Performance – Street
Address 1
Primary Place of
Performance – Street
Address 2
Primary Place of
Performance – State
Primary Place of
Performance – Country
Recipient Primary Place of Performance (city, state,
congressional district, and country) physical location
of primary place of performance.
This is a
mandatory field
This is a
mandatory field
April 1, 2009 Federal
Register Transparency
Act Guidance March
30, 2007
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.
Primary Place of
Performance – Zip Code
+4
Primary Place of
Performance – City
string
9
220334902
string
35
Rockville
This is a
mandatory field
This is a
mandatory field.
Primary Place of
Performance Congressional District
string
2
08
This is a
mandatory field
This is a
mandatory field.
Prime Recipient indication
of reporting applicability
string
3
Yes
This is a Yes
or No field
If all of the
conditions in
the definition
apply the
recipient must
report in the
highly
compensated
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—
(i) In the recipient‘s preceding fiscal year, the
recipient received—
Page 15 of 23
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Element
Definition
Type
Max
Length
Example
Comments
Control
Validation and
Business
Rule(s)
fields
(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.
Prime Recipient Highly
Compensated Name(5)
Names of each of the five most highly compensated
officers of the recipient for the calendar year in
which the award is awarded if—
string
array
55
(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
Tom Jones
John Doe
Mary Smith
Ivana B. Rich
Amanda King
This is a
conditional field
based on the
―Prime
Recipient
indication of
reporting
applicability‖
data element
April 1, 2009 Federal
Register
This is a
conditional field
based on the
―Prime
Recipient
indication of
reporting
applicability‖
data element
If all of the
conditions in
the definition
apply the
recipient must
report in the
highly
compensated
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 Securities Exchange Act of 1934 (15
U.S.C. 78m(a), 78o(d)) or section 6104 of the
Internal Revenue Code of 1986.
Page 16 of 23
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Element
Prime Recipient Highly
Compensated
Compensation(5)
(Conditional)
Definition
For the five most highly compensated officers of the
recipient: total compensation
‗‗Total compensation‘‘ is defined for
Federally Awarded Contracts:
FAR Clause 52.204-11
Total Number of Subawards to individuals
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 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.
(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 Subawards to individuals
Total Amount of Sub-awards to individuals.
Total Number of
payments to vendors less
than $25,000/award
For Grants and Loans Only
Total Number of payments to vendors less than
$25,000/award.
Type
Max
Length
Currenc
y Array
(Dollar
value numeric)
18,2
Example
100000.01
500000.01
400000.01
350000.01
700000.01
Comments
This is a
conditional field
based on the
―Prime
Recipient
indication of
reporting
applicability‖
data element
Control
April 1, 2009 Federal
Register
Validation and
Business
Rule(s)
This is a
conditional field
based on the
―Prime
Recipient
indication of
reporting
applicability‖
data element
If all of the
conditions in
the definition
apply the
recipient must
report in the
highly
compensated
fields
string
Currenc
y (Dollar
value numeric)
string
6
18,2
6
Page 17 of 23
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
This is a
mandatory field
for grants and
loans
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Element
Definition
Type
Max
Length
18,2
Total Amount of
payments to vendors less
than $25,000/award
For Grants and Loans Only
Total Amount of payments to vendors less than
$25,000/award.for the reporting quarter.
Currenc
y (Dollar
value numeric)
Total Number of Subawards 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.
Currenc
y (Dollar
value numeric)
6
18,2
Example
20000.01
Comments
Control
Validation and
Business
Rule(s)
This is a
mandatory field
for grants and
loans
No single Subaward can
exceed $24,999
or must be
submitted
individually
This is a
mandatory field
April 1, 2009 Federal
Register
April 1, 2009 Federal
Register
This is a
mandatory field
20000.01
No single Subaward can
exceed $24,999
or must be
submitted
individually
April 1, 2009 Federal
Register
This is a
mandatory field
10
SUB RECIPIENT DATA ELEMENTS
Sub recipient DUNS
Number
The sub recipient organization‘s 9- digit Data
Universal Numbering System (DUNS) number
string
9
123456789
9digit DUNS#
is mandatory
April 1, 2009 Federal
Register
This is a
mandatory field.
Subaward Number
Subaward Number or Other Identifying Number
Assigned by the Recipient Entity
string
55
Sub-award
number
provided by
Prime
Recipient
April 1, 2009 Federal
Register
This is a
mandatory field.
Sub recipient Legal Name
The legal name of sub recipient as registered in
CCR or D&B
string
120
April 1, 2009 Federal
Register
Sub recipient DBA Name
The Doing-Business-As (DBA) name of sub
recipient as registered in CCR or D&B
string
120
This field is
inferred;
obtained
through CCR
or D&B.
Prime Recipient
assigns a subaward number
(federally
awarded
contract, grant,
loan) to the
Sub Recipient
The System will
pull this
information
from CCR or
D&B
Data Populated
from details
found in CCR
or D&B through
the DUNS#
look-up
Sub recipient Address 1
Sub recipient Location. Physical location as listed in
the Central Contractor Registration.
string
55
Sub recipient Address 2
string
55
Sub recipient Address 3
string
55
Page 18 of 23
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Element
Definition
Type
Max
Length
Sub recipient City
string
35
Sub recipient State
string
2
Sub recipient Zip+4
string
9
Sub recipient Country
string
3
Sub recipient
Congressional District
string
2
string
300
Sub recipient Type
This data element is inferred from CCR. The field
inferred is ―Business Type‖ in CCR.
Example
Comments
Control
Validation and
Business
Rule(s)
51
This field is
mandatory
April 1, 2009 Federal
Register
This is a
mandatory field
2F - U.S. State
Government
The System will
pull this field
from CCR
April 1, 2009 Federal
Register
Fixed list from
CCR
M8 Educational
Institution
Amount of Subaward
The anticipated total amount of funds to be
disbursed to the sub-awardee over the life of the
award.
Currenc
y (Dollar
value numeric)
18,2
200000.01
April 1, 2009 Federal
Register
This is a
mandatory field
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).
Currenc
y (Dollar
value numeric)
Date
(YYYYM
MDD)
18,2
200000.01
April 1, 2009 Federal
Register
This field is
mandatory
8
20091212
April 1, 2009 Federal
Register
This field is
mandatory
Sub recipient Place of Performance (city, state,
congressional district, and country). The physical
location of primary place of performance.
string
55
Sub recipient Primary
Place of Performance –
Street Address 2
Sub recipient Place of
Performance - State
string
55
string
2
MD
Sub recipient Place of
Performance – Country
string
2
US
For Federally Awarded Contracts: Total amount of
subcontract
Total Subaward Funds
Disbursed
Subaward Date
Sub recipient Primary
Place of Performance –
Street Address 1
The date is
found on the
sub-award
document
This field is
optional.
This field is
optional
This field is
mandatory
This is the 2
letter alpha
Page 19 of 23
This field is
optional.
This field is
optional
April 1, 2009 Federal
Register Transparency
Act Guidance March
30, 2007
This field is
mandatory
This field is
mandatory
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Element
Definition
Type
Max
Length
Example
Comments
Control
Validation and
Business
Rule(s)
code.
Sub recipient Place of
Performance – Zip Code
+4
string
9
220334902
This field is
mandatory
Sub recipient Place of
Performance - City
string
35
Rockville
This field is
mandatory
Sub recipient Place of
Performance Congressional District
Sub Recipient indication
of reporting applicability
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
compensated
fields
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—
(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
(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 20 of 23
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
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
Length
55
(i) In the sub recipient‘s preceding fiscal year, the
sub recipient received—
Example
Tom Jones
John Doe
Mary Smith
Ivana B. Rich
Amanda King
(A) 80 percent or more of its annual gross revenues
from Federal contracts (and subcontracts), loans,
grants (and subgrants) and cooperative
agreements; and
Comments
This is a
conditional field
based on the
sub recipient
indication of
reporting
applicability
data element
Control
April 1, 2009 Federal
Register
If all of the
conditions in
the definition
apply the
recipient or
delegated sub
recipient must
report in the
highly
compensated
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 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
Federally Awarded Contracts:
FAR Clause 52.204-11
Validation and
Business
Rule(s)
This is a
conditional field
based on the
―Sub Recipient
indication of
reporting
applicability‖
data element
Currenc
y Array
(Dollar
value numeric)
18,2
100000.01
500000.01
400000.01
350000.01
700000.01
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 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
This is a
conditional field
based on the
sub recipient
indication of
reporting
applicability
data element.
April 1, 2009 Federal
Register
This is a
conditional field
based on the
―Sub Recipient
indication of
reporting
applicability‖
data element
If all of the
conditions in
the definition
apply the
recipient must
report in the
highly
compensated
fields
Page 21 of 23
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Element
Definition
Type
Max
Length
Example
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
comments for
Vendor HQ Zip
Code and
Vendor Name
data elements
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
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.
(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 – Prime
Recipient Vendor
For Grants and Loans Only:
Identifying Number Assigned by the prime recipient.
string
50
Varies by
award and
agencies
Subaward Number – Subrecipient Vendor
For Grants and Loans Only:
Award Number or Other Identifying Number
Assigned by the Sub-recipient
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
Universal Numbering System (DUNS) number
string
9
123456789
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
string
255
Runway repair
Page 22 of 23
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
description of
April 1, 2009 Federal
Register
April 1, 2009 Federal
Register
Recipient Reporting Data Model- For Quarter Ending 12/31/2009
Data Element
Definition
Type
Max
Length
Example
by the vendor
This field is optional for vendors of sub-recipients
Payment Amount
For Grants and Loans Only:
The amount invoiced to the vendor (aggregated)
that will be paid with ARRA funds
This field is optional for vendors of sub-recipients
Comments
Control
product and/or
service
Currenc
y
(Dollar
value numeric)
18,2
Page 23 of 23
50000.01
April 1, 2009 Federal
Register
Validation and
Business
Rule(s)
File Type | application/pdf |
Author | carltongravatt |
File Modified | 2010-04-22 |
File Created | 2010-04-22 |