FlaReporting System User Guide - PowerPoint PPT Presentation

Title: FlaReporting System User Guide


1
FlaReporting SystemUser Guide

• As of September 18, 2009

2
Award TypeSelect the award type Grant, Loan
or Contract
Award NumberEnter the identifying number
assigned by the awarding Federal Agency such as
the Federal grant number, Federal contract
number, or the Federal loan number. It should be
the same as it appears in federal award
document This field is case, space, and special
character sensitive.50 characters or less.
Funding Agency CodeSelect the code and agency
name from the drop down. 4 digit codeFunding
agency name inferred by code.
Awarding Agency CodeSelect the code and agency
name from the drop down.In many cases the
Awarding Agency and Funding Agency are the same,
although they may also be different.4-digit
code.Awarding agency name inferred by code.
Award DateEnter the date the award was signed.
You must enter / between the month, day and
year.Format MM/DD/YYYY
CFDA NumberEnter the CFDA (Catalog of Federal
Domestic Assistance) number associated with the
published description of Federal assistance
program in the catalog for the recipient
award.Format . (6 characters)To search
for a CFDA number, go to www.CFDA.gov
Program Source (TAS)Select the Agency Treasury
Account Symbol (TAS) that identifies the funding
Program Source. The Program Source is based on
the OMB TAS list of ARRA Programs.Federal
contractors may find the TAS on their contract or
by calling the contracting officer.
Sub Account NumberSubAccount Number for the
selected Program Source (TAS).Enter the 3-digit
extension of the Program Source (TAS) identifying
an Agency sub account.This field should only be
completed if applicable.
Award DescriptionEnter 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 associated units of measure.
Enter award title and description with purpose of
each funding action if any.
3
Final ReportIndicate Y only if this will be
the final report filed for this award and there
will be no further quarterly reports, otherwise
indicate N
Amount of AwardEnter the total Federal amount
of award.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. For
Contracts The total amount obligated by the
Federal agency.
Total Number of Sub Awards to IndividualsEnter
the Total Number of Sub Awards to Individuals
Total Amount of Sub Awards to IndividualsEnter
the Total Amount of Sub Awards to Individuals
Total Number of Payments to VendorsEnter the
Total Number of Payments to Vendors less than
25,000/award.
Total Amount of Payments to Vendors of Sub
Awards to IndividualsEnter the Total Number of
Payments to Vendors Less than 25,000/award for
the reporting quarter
Total Sub Awards less than 25K/awardEnter
the Total Number of Sub Awards less than
25,000/award.
Total Amount of Sub Awards less
25K/awardEnter the Total Amount of Sub Awards
Less than 25,000 award for the reporting quarter.
4
Project/Program Name or TitleEnter a brief
descriptive title of the project or activity
funded in whole or in part with Recovery Act
funds. This title can be found on the Award
document. Product or Service code.
Activity CodeEnter either NAICS or NTEE-NPC
Codes www.census.gov/naics . For awards primarily
funding infrastructure projects, select a NAICS
code. For all other awards, select a NTEE-NPC
code. http//nccsdataweb.urban.org/PubApps/nte
At least one activity code is required.
Project StatusUse the descriptions in the Data
Model to evaluate the completion status of the
project work. Valid Project Statuses are Not
Started Less than 50 completed Completed 50
or more Fully Completed.
Quarterly Activities/Proj.DescEnter a
description of the overall purpose and the
expected results of the award and the first-tier
sub award(s) including significant deliverables.
If funding multiple projects (block grants) this
may be stated in broad terms
Infrastructure Contact Name Enter the name of
the Infrastructure Contact
Infrastructure Contact Email Enter the email
address for the designated Infrastructure Contact
Infrastructure Contact Phone Enter the name of
the Infrastructure Contact
Infra. Contact Street Address 1 1. Enter the
first line of the street address for the
designated Infrastructure Contact.
Infra. Contact Street Address 2 2. Enter the
second line of the street address for the
designated Infrastructure Contact.
Infra. Contact Street Address 3 3. Enter the
third line of the street address for the
designated Infrastructure Contact.
Infra. Contact City Enter the name of the City
for the designated Infrastructure Contact
Infra. Contact State Enter the name of the State
for the designated Infrastructure Contact
Infra. Contact Zip 4 Infrastructure State/Local
Contact ZIP Code4 for the designated
Infrastructure Contact
Infrastructure Purpose/RationaleIf applicable,
enter an explanation about how the
infrastructure investment will contribute to one
or more purposes of the Recovery Act. Refer to
the Data Model for details on what to
report.4000 characters or less
5
Primary POP Street Address 1 (Optional) Primary
Place of Performance Street Address 1. Enter the
first line of the street address for the
Recipients Primary Place of Performance.55
characters or less.
Primary POP Street Address 2 (Optional) Primary
Place of Performance Street Address 2. Enter the
second line of the street address for the
Recipients Primary Place of Performance.55
characters or less
Primary POP City Primary Place of Performance
City. Enter the name of the city for the
Recipients Primary Place of Performance.35
characters or less.
Primary POP State Enter the POP State
Primary POP ZIP Code4 Primary Place of
Performance ZIP Code4. Enter the ZIP Code4 for
the Recipients Primary Place of
Performance.Format Exactly 9-digits. Do not
include dashes.
Primary POP CountryPrimary Place of Performance
Country. Enter the 2-digit code for the
Recipients Primary Place of Performance
Country.2-digit alpha code
Primary POP Congressional DistrictPrimary Place
of Performance Congressional District. Enter the
Recipients Primary Place of Performance
Congressional District.2-digit code
Primary POP CountyPrimary Place of Performance
County. Enter the 2-digit code for the
Recipients Primary Place of Performance
County.2-digit code
6
Total Federal Amount ARRA Funds
Received/InvoicedTotal Federal Amount ARRA
Funds Received/Invoiced. Enter the amount of
Recovery Act Funds received through draw-down,
reimbursement, or invoiced.
Total Federal Amount ARRA ExpenditureEnter the
cumulative total amount of Recovery funds
received that were expended to projects or
activities. Refer to pg. 12 of the the Data Model
for details on how to calculate this amount.
Total Federal ARRA Infrastructure
ExpenditureEnter the total Federal ARRA
infrastructure expenditure. This field is only
required if you are reporting for infrastructure
investment.
Number of JobsEstimate the number of jobs
created and jobs retained in the US and outlying
areas. Refer to pg. 9 of the Data Model for
guidance on how to calculate this number.
Description of Jobs CreatedProvide a brief
description of the types of jobs created and a
narrative description of the employment impact
resulting using Recovery Act funds.
Infrastructure Purpose/RationaleIf applicable,
enter an explanation about how the
infrastructure investment will contribute to one
or more purposes of the Recovery Act.Refer to
the Data Model for details on what to
report.4000 characters or less
7
Once you have completed your edits, make sure you
hit Save
8
Organization NameEnter the name of your
organization
Account Number(Optional) The Prime Recipients
internal account number for the award. This
field is for the Recipient's use only, and is not
required by the awarding Federal agency.255
characters or less.
DUNS NumberEnter the Prime Recipient
organizations Data Universal Numbering System
(DUNS) number.9-digits.
Parent DUNS NumberSystem generated
Street Address 1Federal system generated
CountyEnter 2-digit county code
Street Address 2Federal system generated
Congressional DistrictEnter the Congressional
District of the Prime Recipient.2-digit code.
Street Address 3Federal system generated
CityFederal system generated
CountryFederal system generated
StateFederal system generated
Zip Code4Federal system generated
Compensation 1, 2, 3, 4, 5Highly Compensated
Officer Compensation. Enter the compensation for
the five Highly Compensated Officer. Refer to
the Recipient Reporting Data Model for the
details on how to calculate Total Compensation
for Grants and Loans.
Determination of Top 5 CompensatedYes if in
the Recipients preceding fiscal year, the
Recipient received 80 and 25Mannual gross
revenue from Federal contracts, loans, grants,
and cooperative agreements, and public does not
have access to Sr. executive compensation, else
No
Officer 1, 2,3, 4, 5 NameEnter the names of the
five Highly Compensated Officer.55 characters
or less
9
Chose the Sub-recipient you want to review or edit
10
Sub Award DateEnter the date the Sub Award was
signed. You must enter / between the month,
date and yearFormat MM/DD/YYYY
Sub Award NumberEnter the Sub Award Number or
other identifying number assigned by the Prime
Recipient entity.55 characters or less.
Amount of Sub AwardEnter the anticipated total
amount of funds to be disbursed to the Sub
Awardee over the life of the award.
Sub Recipient DUNS NumberEnter the Sub
Recipient organizations Data Universal Numbering
System (DUNS) number.9-digits.
Total Sub Award Funds DisbursedEnter the
cumulative amount of cash disbursed to the Sub
Awardee as of the Report Period End Date.
CountyEnter the 2-digit county code.
Sub Recipient Congressional DistrictSub
Recipient Congressional District. Enter the
Congressional District of the Sub
Recipient.2-digit code.
Congressional District Sub Recipient Primary
Place of Performance Congressional District.
Enter the Sub Recipients Place of Primary
Performance Congressional District.2-digit code.
Street Address 1(Optional) Sub Recipient Primary
Place of Performance Street Address 1. Enter the
first line of the street address for the Sub
Recipients Primary Place of Performance.55
characters or less.
CountrySub Recipient Primary Place of
Performance Country. Enter the 2-digit code for
the Sub Recipients Primary Place of Performance
Country.2-digit code
Street Address 2(Optional) Sub Recipient Primary
Place of Performance Street Address 2. Enter the
second line of the street address for the Sub
Recipients Primary Place of Performance.55
characters or less.
CitySub Recipient Primary Place of Performance
City. Enter the name of the city for the Sub
Recipients Primary Place of Performance.35
characters or less.
StateUse the drop-down to select the State for
the Sub recipients Primary Place of Performance.
Zip Code4Sub Recipient Primary Place of
Performance ZIP Code4. Enter the ZIP Code4 for
the Sub Recipients Primary Place of
Performance.Format Exactly 9-digits. Do not
include dashes.
11
Chose the Sub-recipient you want to review or edit
12
Organization Name
Sub Recipients DUNS Number Enter the Sub
Recipient organizations Data Universal Numbering
System (DUNS) number.9-digit
Account Number(Optional) Recipients internal
account number for award.
Parent DUNS NumberOptional
TypeThis data element is inferred from CCR. The
field inferred is Business Type in CCR.
Street Address 1 (Optional) Sub Recipient
Primary Place of Performance Street Address 1.
Enter the first line of the street address for
the Sub Recipients Primary Place of Performance.
CountyEnter the 2-digit county code.
Congressional DistrictSub-Recipient Primary
Place of Performance Congressional District.
Enter the Sub Recipients Place of Primary
Performance Congressional District.2-digit code.
Street Address 2(Optional) Sub Recipient Primary
Place of Performance Street Address 2. Enter the
second line of the street address for the Sub
Recipients Primary Place of Performance.55
characters or less.
Vendor DUNS Number ()
CountrySub-Recipient Primary Place of
Performance Country. Enter the 2-digit code for
the Sub Recipients Primary Place of Performance
Country.2-digit code.
CitySub Recipient Primary Place of Performance
City. Enter the name of the city for the Sub
Recipients Primary Place of Performance.35
characters or less.
Zip4Sub Recipient Primary Place of Performance
ZIP Code4. Enter the ZIP Code4 for the Sub
Recipients Primary Place of Performance.Format
Exactly 9-digits. Do not include dashes.
Street Address 3 (Optional) Sub Recipient
Primary Place of Performance Street Address 2.
Enter the second line of the street address for
the Sub Recipients Primary Place of
Performance.55 characters or less
StateUse the drop-down to select the State for
the Sub Recipients Primary Place of Performance.
13
Compensation 1, 2, 3, 4, 5Highly Compensated
Officer Compensation. Enter the compensation for
the five Highly Compensated Officer. Refer to
the Recipient Reporting Data Model for the
details on how to calculate Total Compensation
for Grants and Loans.
Determination of Top 5 CompensatedYes if in
the Recipients preceding fiscal year, the
Recipient received 80 and 25Mannual gross
revenue from Federal contracts, loans, grants,
and cooperative agreements, and public does not
have access to Sr. executive compensation, else
No
Officer 1, 2,3, 4, 5 NameEnter the names of the
five Highly Compensated Officer.55 characters
or less
Indication of Reporting Applicability YESif in
the recipients preceding fiscal year, recipients
received 80 and 25M annual gross revenue
from federal contracts, loans, grants and
cooperative agreements, and public does not have
access to SR. Executive compensation, else NO
14
Vendor DUNS Number ()Enter the Vendor
organizations Data Universal Numbering System
(DUNS) number () If this information is not
available, then you are required to provide BOTH
the Vendor Name and Vendor HQ ZIP
Code4 9-digits.
Payment AmountEnter the amount invoiced to the
Vendor (aggregated) that will be paid with ARRA
funds
Vendor Name ()Enter the name of the Vendor
organizations name () If you are not providing
the Vendors DUNS number, you must provide BOTH
this field and the Vendor organization's ZIP
Code4 55 characters or less
15
Vendor Name ()Enter the name of the Vendor
organizations name () If you are not providing
the Vendors DUNS number, you must provide BOTH
this field and the Vendor organization's ZIP
Code4 55 characters or less
Vendor DUNS Number ()Enter the Vendor
organizations Data Universal Numbering System
(DUNS) number () If this information is not
available, then you are required to provide BOTH
the Vendor Name and Vendor HQ ZIP
Code4 9-digits.
Payment AmountEnter the amount invoiced to the
vendor (aggregated) that will be paid with ARRA
funds. This field is optional for vendors of Sub
Recipients.
Vendor HQ Zip Code4()Enter the ZIP Code 4 of
the Vendor organizations headquarters. () If
you are not providing the Vendors DUNS number,
you must provide BOTH this field and the Vendor
organization's name. 9-digits.
Product Service DescriptionEnter a description
of the product and/or service provided by the
Vendor This field is optional for vendors of Sub
Recipients. 255 characters or less
Sub Award Number ()Enter the identifying Award
Number assigned by the Sub Recipient. () This
field is only required if the Vendor is the
Vendor for a Sub Recipient. 55 characters or
less.