Attachment 3_Recipient Reporting Data Model

Attachment 3_Recipient Reporting Data Model.pdf

STAR METRICS (OD)

Attachment 3_Recipient Reporting Data Model

OMB: 0925-0616

Document [pdf]
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 Typeapplication/pdf
Authorcarltongravatt
File Modified2010-04-22
File Created2010-04-22

© 2024 OMB.report | Privacy Policy