Full text
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Validation Update Summary
Page 1 of 27
Here is a summary of the validation modifications as of 11/4/2020. (Note: Existing rules are still in place. These are additional rules that are added to the original set.)
1
Date validations have been added and updated for all funding instruments (contracts >$50,000, grants >$50,000, etc…) to ensure compliance with the
Coronavirus Relief Fund legislation (Funds must be obligated and expended by 12/30/2020, expenditures must fall within the period of performance that
ends no later than 12/30/2020, etc...) and to prevent typos, the "year" field must be 1990 or higher.
2
Obligation amount validations have been updated for all funding instruments to ensure that each record is fully obligated (ex: Award Amount = Cumulative
Obligated Amount) and that the total obligations across the report does not exceed the total CRF funding.
3
Expenditure amount validations have been updated to ensure that the expenditures by project (including “No Project Assigned”) do not exceed the
obligations for the same project.
key:
Cells containing additional validation rules have been highlighted yellow
Cells containing the corrected value for "No Project Assigned" and "Workers Compensation"
bold
The new validation rule(s) within that cell is bold.
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
General Instructions
Page 2 of 27
How to use the Data Dictionary:
Column Label
Description
Column
The column within a tab where a particular field is located.
Field Label
The name for each type of data that is being requested.
Definition
Additional information about the data that is being requested.
Identifies whether or not a field is required.
- Yes = There must always be a value in this field.
- No = It is optional whether or not to include a value in this field.
- See business rules = This field may or may not be required based on the business rules. (ex: Sub-Recipient requires either a DUNS or
Required?
an Identification Number but not both.)
Type of data that is needed within this field:
- String = Alpha-Numeric
- Number = Numeric or currency (without $ character)
Data Type
- Date = MM/DD/YYYY
Whether or not the values provided must fit within a specific list:
- User input = Data is not limited to the items specified in the List of Values column.
Field Type
- Drop Down List = Values must match one of the items specified in the List of Values column.
Number of characters that can be used within this field. If a number field uses decimals, the field length information shows two values,
the number of characters before the decimal and the number of characters after the decimal (ex: 18,2). Any characters past the
Max Field Length
specified field length will be cropped off upon upload.
A predefined list of valid values that will map to a drop down field or checkbox in the online form. This column will also specify whether
one or multiple values can be included. If allowed to use multiple values (ex: Organization Type on the Sub-Recipient tab) then use the
List of Values
bar (|) delimiter between values.
Business Rules
Clarification for when data is required, validation rules, etc…
General
The Template structure cannot be modified. Modifying the Template will cause the Upload to fail. For example,
- Editing column names
- Editing tab names
- Editing the column order
- Deleting tab or changing the order of the tabs
Helpful hints for the Upload process
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
General Instructions
Page 3 of 27
Helpful hints for the Upload process
Cover Page Tab
The Cover Page data ensures that the file is uploaded to the correct reporting period for your organization.
- Leave the Report Name and Program values as provided.
- The first uploaded file will include data from 3/1/2020 - 9/30-2020, but will be loaded into the 7/1/2020 - 9/30/2020 reporting
period's online form. You can use either date range in the Cover Page tab.
- The following reporting periods must match the actual date range of the reporting period being uploaded (ex: 10/1/2020 -
12/31/2020).
- The Prime Recipient DUNS # must match the DUNS number of the online Financial Progress Report.
Projects Tab
The Projects Tab contains all Projects established for Coronavirus Relief Fund funding.
- All Projects must be listed each reporting period.
- Only update the status field for Projects that were previously uploaded. Any other changes (ex: name or description) to previously
loaded projects must be done via the UI.
- Any new Projects added to the Projects tab will need to be updated as part of the next Reporting cycle.
- The Project Identification Number must be unique and will be used on the other tabs to identify a project.
Sub-Recipient Tab
The Sub-Recipient Tab contains new Sub-Recipient organizations.
- Use a SAM.gov registered DUNS number OR an Identification Number, not both.
- When using a SAM.gov registered DUNS, do not fill in the rest of the fields.
-- Be careful if copying the DUNS from another system that the leading zeros do not get stripped off. (The column is currently formatted
as text so should be able to handle leading zeros but formatting is sometimes overridden when copying from another system or
spreadsheet.)
- When using an Identification Number, you have to fill in all required fields.
- A DUNS not registered with SAM.gov can be used for the Identification Number.
- A DUNS or Identification Number must be unique and will be used on the other tabs to identify a Sub-Recipient Organization.
- Use the 5 digit zip code if you don't know the Zip+4. The system will do the lookup for you when it is confirming the address with the
USPS data.
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
General Instructions
Page 4 of 27
Helpful hints for the Upload process
Contracts Tab
>=$50,000
The Contracts Tab contains any contracts that have new obligation and/or expenditure data for the specified reporting period.
- All required fields must be filled in for new contracts.
-- Use the DUNS or Identification Number to identify which Sub-Recipient organization received the Contract. (Do not include the name
of the Sub-Recipient Organization.)
-- Contract Numbers must be unique.
- If there are no obligations or expenditures for the reporting period, do not include the contract.
- If there are no contracts >= $50,000, do not add anything to this tab.
- See the Obligations helpful hint for more information.
- See the Expenditures helpful hint for more information.
Grants Tab
>=$50,000
The Grants Tab contains any grant awards that have new obligation and/or expenditure data for the specified reporting period.
- All required fields must be filled in for new grants.
-- Use the DUNS or Identification Number to identify which Sub-Recipient organization received the grant. (Do not include the name of
the Sub-Recipient Organization.)
-- Award Numbers must be unique.
- If there are no obligations or expenditures for the reporting period, do not include the grant.
- If there are no grants >= $50,000, do not add anything to this tab.
- See the Obligations helpful hint for more information.
- See the Expenditures helpful hint for more information.
Loans Tab >=
$50,000
The Loans Tab contains any loans that have new obligation and/or payment data for the specified reporting period.
- All required fields must be filled in for new loans.
-- Use the DUNS or Identification Number to identify which Sub-Recipient organization received the loan. (Do not include the name of
the Sub-Recipient Organization.)
-- Loan Numbers must be unique.
- If there are no obligations or payments for the reporting period, do not include the loan.
- If there are no loans >= $50,000, do not add anything to this tab.
- See the Obligations helpful hint for more information.
- See the Payments helpful hint for more information.
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
General Instructions
Page 5 of 27
Helpful hints for the Upload process
Transfers Tab
>=$50,000
The Transfers Tab contains any transfers that have new obligation and/or expenditure data for the specified reporting period.
- All required fields must be filled in for new transfers.
-- Use the DUNS or Identification Number to identify which Sub-Recipient organization received the transfer. (Do not include the name
of the Sub-Recipient Organization.)
-- Only use Sub-Recipient Organizations that have organization types listed on the Transfer tab's Business Rules. (Transfers that are
linked to Sub-Recipient Organizations with other organization types will not pass validation.)
-- Transfer Numbers must be unique.
- If there are no obligations or expenditures for the reporting period, do not include the transfer.
- If there are no transfers >= $50,000, do not add anything to this tab.
- See the Obligations helpful hint for more information.
- See the Expenditures helpful hint for more information.
Direct Tab >=$50,000
The Direct Tab contains any direct payments that have new obligation and/or expenditure data for the specified reporting period.
- All required fields must be filled in for new direct payments.
-- Use the DUNS or Identification Number to identify which Sub-Recipient organization received the direct payment. (Do not include the
name of the Sub-Recipient Organization.)
- If there are no obligations or expenditures for the reporting period, do not include the direct payment.
- If there are no direct payments >= $50,000, do not add anything to this tab.
- See the Obligations helpful hint for more information.
- See the Expenditures helpful hint for more information.
Aggregate Awards
< $50000 Tab
The Aggregate Awards < $50000 collects totals for smaller Contracts, Grants, Loans, Transfers, and Direct Payments.
- Leave the labels for the funding types in the first column as provided. Do not change the order of these rows.
- Only fill in values for the funding types that had obligations and/or expenditures/payments within the reporting period you are
reporting. (You do not have to enter 0.00 if there is no data.)
Aggregate Payments
Individual
The Aggregate Payments Individual collects totals for individuals.
- Only fill in values if there were obligations and/or expenditures within the reporting period you are reporting. (You do not have to
enter 0.00 if there is no data.)
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
General Instructions
Page 6 of 27
Helpful hints for the Upload process
Obligations - General
Guidance
- Create a separate row for each Current Quarter Obligation within a Contract, Grant, Loan, Transfer, or Direct Payment. (In other
words, if a contract is split into more than one Obligation Project, you will have to repeat all of the data to the left.)
- A row can have obligations without expenditures. (All required fields to the left of Obligation Project will have to be included so that it
is clear which Contract this obligation is for.)
- Use the Project Identification Number in the Obligation Project field to identify which Project the obligation is for. (Do not include the
name of the Project.) If the obligation is not related to a project, use the phrase "No Project Assigned".
- A Project cannot be split into more than one obligation.
- A prime’s total obligations should not exceed total Coronavirus Relief Funds received
- Total Cumulative Obligations across all reporting periods:
-- for a specific Contract = Contract Amount
-- for a specific Grant = Award Amount
-- for a specific Loan = Loan Amount
-- for a specific Transfer = Transfer Amount
-- for a specific Direct Payment = Obligation Amount
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
General Instructions
Page 7 of 27
Helpful hints for the Upload process
Expenditures -
General Guidance
- Use the same row to show a Project's Obligation and Expenditure data. (In other words, don't mix and match Obligation Projects and
Expenditure Projects.)
- Create a separate row for each Expenditure. (In other words, if the contract is split into more than one Expenditure, you will have to
repeat all of the data to the left, including the Obligation Project and Current Quarter Obligation.)
- A row can have expenditures without obligations if the obligation was reported in a previous reporting period. (All required fields to
the left of Obligation Project will have to be included so that it is clear which Contract this Expenditure is for.)
- Use the Project Identification Number in the Expenditure Project field to identify which Project an expenditure is for. (Do not include
the name of the Project.) If the expenditure is not related to a project, use the phrase "No Project Assigned".
- The Expenditure Projects can only use values that have been linked to an obligation either in the current project period or a previous
project period. (This includes "No Project Assigned".)
- Cumulative Expenditures for a specific project (or “no project assigned”) <= cumulative obligations for that same project (or “no
project assigned”)
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
General Instructions
Page 8 of 27
Helpful hints for the Upload process
Payments (Only Used
for Loans) - General
Guidance
- Use the same row to show a Project's Obligation and Payment data. (In other words, don't mix and match Obligation Projects and
Payment Projects.)
- Create a separate row for each Payment. (In other words, if the contract is split into more than one payment, you will have to repeat
all of the data to the left, including the Obligation Project and Current Quarter Obligation.)
- A row can have payments without obligations if the obligation was reported in a previous reporting period. (All required fields to the
left of Obligation Project will have to be included so that it is clear which Loan this payment is for.)
- Use the Project Identification Number in the Payment Project field to identify which Project a payment is for. (Do not include the
name of the Project.) If the payment is not related to a project, use the phrase "No Project Assigned".
- The Payment Projects can only use values that have been linked to an obligation either in the current project period or a previous
project period.
- Cumulative Payments for a specific project (or “no project assigned”) <= cumulative obligations for that same project (or “no project
assigned”)
Reporting Period 3
and up
- Contracts, Grants, Loans, Transfers, or Direct Payments previously reported do not have to be included in subsequent reporting
periods unless they have additional obligations and/or expenditures.
- Contracts, Grants, Loans, Transfers, or Direct Payments that have been given more funding (or had funding taken away) should:
-- update the Amount field with the new total value
-- put the amount added (or removed) in the Current Quarter Obligation field
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Cover Page
Page 9 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
A
Report Name
Financial Progress Reporting
See business
rules
String
Labels
N/A
This is pre-populated.
B
Program
Coronavirus Relief Fund
See business
rules
String
Labels
N/A
This is pre-populated.
C
Reporting Period Start Date
First day in the reporting period
Yes
Date
MM/DD/YYYY
10
D
Reporting Period End Date
Last day of the reporting period
Yes
Date
MM/DD/YYYY
10
E
Prime Recipient DUNS #
Unique identifier for the Prime Recipient organization.
Yes
String
User Input
9
This must be the DUNS number provided by Treasury
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Projects
Page 10 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
A
Project Name
The brief descriptive name of the project funded in whole or in part with Coronavirus
Relief Funds.
Yes
string
User Input
256
N/A
B
Project Identification Number
Unique trackable identification number for the project or activity
Yes
string
User Input
25
- Each Project Identification Number must be unique.
- These values will be used on the other tabs to identify which
project an Obligation, Expenditure, or Payment relates to.
C
Description
A description of the overall purpose and expected outputs and outcomes or results of
the project or activity funded by the Coronavirus Relief Fund, including significant
deliverables and, if appropriate, associated units of measure. The purpose and
outcomes or results should be stated in terms that allow an understanding that the
project or activity is necessary due to the public health emergency with respect to
the coronavirus disease 2019 (COVID-19).
Yes
string
User Input
2000
D
Status
Evaluation of completion status of the project or activity funded by the Coronavirus
Relief Fund. The status of work that has been completed. This evaluation should be
based on performance progress reports and other relevant non-financial
performance information.
Yes
string
Pre-defined List
of Values -- See
Column H (8),
List of Values
23
Options for selection (select one):
- Not started
- Less than 50% completed
- Completed 50% or more
- Fully completed
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Sub-Recipient
Page 11 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
A
DUNS Number
The unique identification number for the Sub-Recipient Organization of the prime
recipient's Coronavirus Relief Funds. Currently the identifier is the 9-digit number
assigned by Dun and Bradstreet (D&B) referred to as the DUNS® number.
See business
rules
string
User input
9
- Fill in either DUNS or Identification Number, not both.
-- The DUNS number must be registered with SAM.gov to be
used in this field
-- If DUNS number is filled in, then the rest of the Sub-Recipient
fields should not be filled in. The upload process will look up the
rest of the fields on SAM.gov.
- Each DUNS and/or Identification Number must be unique.
- These values will be used on the other tabs to identify which
Sub-Recipient organization a Contract, Grant, Loan, Transfer, or
Direct Payment relates to.
B
Identification Number
User defined unique identification number for the Sub-Recipient organization if they
do not have a DUNS number.
See business
rules
string
User input
9
- Fill in either DUNS or Identification Number, not both.
-- If DUNS is not filled in, then the Identification Number is
required.
-- If the Sub-Recipient organization has a DUNS number that is
not registered with SAM.gov, you can use that as the
Identification Number.
- Each DUNS and/or Identification Number must be unique.
- These values will be used on the other tabs to identify which
Sub-Recipient organization a Contract, Grant, Loan, Transfer, or
Direct Payment relates to.
C
Legal Name
The name of the Sub-Recipient Organization.
See business
rules
string
User input
120
This field is required if there isn't a DUNS number registered
with SAM.gov.
D
Address Line 1
First line of the Sub-Recipient Organization's address.
See business
rules
string
User input
150
This field is required if there isn't a DUNS number registered
with SAM.gov.
E
Address Line 2
Second line of the Sub-Recipient Organization's address.
No
string
User input
150
F
Address Line 3
Third line of the Sub-Recipient Organization's address.
No
string
User input
150
G
City Name
Name of the city in which the Sub-Recipient Organization is located.
See business
rules
string
User input
40
This field is required if there isn't a DUNS number registered
with SAM.gov.
H
State Code
United States Postal Service (USPS) two-letter abbreviation for the state or territory
in which the Sub-Recipient Organization is located.
See business
rules
string
User input
2
This field is required if there isn't a DUNS number registered
with SAM.gov.
I
Zip+4
United States ZIP code (five digits) concatenated with the additional +4 digits
associated with the Sub-Recipient Organization's address.
See business
rules
string
User input
10
This field is required if there isn't a DUNS number registered
with SAM.gov.
Note: Use the 5 digit zip code if you don't know the Zip+4. The
system will do the lookup for you when it is confirming the
address with the USPS data.
J
Country Name
The country in which the Sub-Recipient Organization is located.
See business
rules
string
Pre-defined List
of Values -- See
Column H (8),
List of Values
100
Options for selection (choose one):
- Afghanistan
- Albania
- Algeria
- American Samoa
- Andorra
- Angola
- Anguilla
- Antarctica
- Antigua And Barbuda
- Argentina
- Armenia
- Aruba
- Australia
- Austria
- Azerbaijan
- Bahamas
- Bahrain
- Bangladesh
- Barbados
- Belarus
- Belgium
- Belize
- Benin
- Bermuda
- Bhutan
- Bolivia
- Bosnia And Herzegovina
This field is required if there isn't a DUNS number registered
with SAM.gov.
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Sub-Recipient
Page 12 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
K
Organization Type
A collection of indicators of different types of Sub-Recipient Organizations based on
socio-economic status and organization / business areas.
See business
rules
string
Pre-defined List
of Values -- See
Column H (8),
List of Values
82
Options for selection (use a "|" pipe delimiter between records if there are more than one):
- State Government
- County Government
- City or Township Government
- Special District Government
- Independent School District
- Public/State Controlled Institution of Higher Education
- Indian/Native American Tribal Government (Federally Recognized)
- Indian/Native American Tribal Designated Organization
- Public/Indian Housing Authority
- Nonprofit with 501C3 IRS Status (Other than an Institution of Higher Education)
- Nonprofit without 501C3 IRS Status (Other than an Institution of Higher Education)
- Private Institution of Higher Education
- For-Profit Organization (Other than Small Business)
- Small Business
- Hispanic-serving Institution
- Historically Black College or University (HBCU)
- Tribally Controlled College or University (TCCU)
- Alaska Native and Native Hawaiian Serving Institutions
- Non-domestic (non-U.S.) Entity
- Other
This field is required if there isn't a DUNS number registered
with SAM.gov.
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Contracts
Page 13 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
A
Sub-Recipient Organization
(Contractor)
Sub-Recipient Organization from the list added via the Sub-Recipient tab or
previously uploaded into the Sub-Recipient Organizations section.
Yes
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
9
DUNS # or Identification Number
B
Contract Number
Prime recipient's internal account number for the contract; the account number or
any other identifying number assigned by the prime recipient to the contract.
Yes
String
User input
55
This number must be unique across all contracts.
C
Contract Type
The type of contract issued by the prime recipient.
Yes
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
30
Options for selection (select one):
- Purchase Order
- Delivery Order
- Blanket Purchase Agreement
- Definitive Contract
D
Contract Amount
Total amount of Coronavirus Relief Fund dollars on the contract issued by the prime
recipient.
Yes
Number
User input
18,2
Contract Amount <= Total Amount Coronavirus Relief Funds
Received as reported by Treasury.
E
Contract Date
The date that a mutually binding agreement was reached; the date signed by the
prime or contractor, whichever is later.
Yes
Date
MM/DD/YYYY
10
- This should be <= reporting period end date
- Contract Date >=1/1/1990
- Contract Date <= 12/30/2020
F
Period of Performance Start Date
The date on which efforts begin or the contract is otherwise effective.
Yes
Date
MM/DD/YYYY
10
- Period of Performance Start Date must be >= Contract Date
- Period of Performance Start Date >=1/1/1990
G
Period of Performance End Date
The date on which all effort is completed or the contract is otherwise ended.
Yes
Date
MM/DD/YYYY
10
- Period of Performance End Date must be >= Start Date
- Period of Performance End Date >=1/1/1990
- Period of Performance End Date <= 12/30/2020
H
Primary Place of Performance Address
Line 1
First line of the address where the predominant performance of the contract will be
accomplished.
Yes
String
User input
150
I
Primary Place of Performance Address
Line 2
Second line of the address where the predominant performance of the contract will
be accomplished.
No
String
User input
150
J
Primary Place of Performance Address
Line 3
Third line of the address where the predominant performance of the contract will be
accomplished.
No
String
User input
150
K
Primary Place of Performance City
Name
The name of the city where the predominant performance of the contract will be
accomplished.
For services: In the case of subscription services, software licenses, or similar type
services - use the location where these services are being used; in the case of
services that begin in one location and end in another (e.g., shipping) - use the
destination; in the case of services being performed in oceans/seas - choose the
closest major city (if in U.S. waters); in another country's waters - choose that
country; if in open waters - choose the closest country and choose the closest major
city if that country is the U.S.; in the case of services being performed in the
atmosphere or space - choose the location from which the equipment conducting the
services was launched.
For Goods/Supplies: Items being manufactured should reflect the manufacture site as
the place of performance; all other goods should enter the location the item was
taken from inventory (e.g., the store location, etc.).
Yes
String
User input
40
L
Primary Place of Performance State
Code
United States Postal Service (USPS) two-letter abbreviation for the state or territory
indicating where the predominant performance of the contract will be accomplished.
Identify States, the District of Columbia, territories (i.e., American Samoa, Guam,
Northern Mariana Islands, Puerto Rico, U.S. Virgin Islands) and associated states (i.e.,
Republic of the Marshall Islands, the Federated States of Micronesia, and Palau) by
their USPS two-letter abbreviation for the purposes of reporting.
Yes
String
User input
2
M
Primary Place of Performance Zip+4
United States ZIP code (five digits) concatenated with the additional +4 digits,
identifying where the predominant performance of the contract will be
accomplished.
Yes
String
User input
10
Note: Use the 5 digit zip code if you don't know the Zip+4. The
system will do the lookup for you when it is confirming the
address with the USPS data.
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Contracts
Page 14 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
N
Primary Place of Performance Country
Name
Name of the country where the predominant performance of the Contract will be
accomplished.
Yes
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
100
Options for selection (choose one):
- Afghanistan
- Albania
- Algeria
- American Samoa
- Andorra
- Angola
- Anguilla
- Antarctica
- Antigua And Barbuda
- Argentina
- Armenia
- Aruba
- Australia
- Austria
- Azerbaijan
- Bahamas
- Bahrain
- Bangladesh
- Barbados
- Belarus
- Belgium
- Belize
- Benin
- Bermuda
- Bhutan
- Bolivia
- Bosnia And Herzegovina
O
Contract Description
A brief description of the purpose of the contract.
Yes
String
User input
4000
P
Obligation Project
Project that an Obligation was for.
See business
rules
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
25
Options for selection (choose one):
- Project Identification Number from the Projects tab.
- If the obligation is not related to a project, use "No Project Assigned".
- If a contract is used for more than one project, each project
must be listed in a separate row with their current quarter
obligation amount. The contract fields to the left must be
repeated for each.
- Don't break a project into more than one Current Quarter
Obligation amount.
- If there weren't any obligations for this project within this
reporting period, then this field can be blank.
Q
Current Quarter Obligation
Amount obligated for this specific Project for this Contract within this Quarter. (This
could go up or down.)
See business
rules
Number
User input
18,2
- Current Quarter Obligation <= Contract Amount
- There can only be one Current Quarter Obligation amount per
Project per Contract.
- If there weren't any obligations for this project within this
reporting period, then this field can be blank.
R
Expenditure Project
Project that an Expenditure was for.
See business
rules
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
25
Options for selection (choose one):
- Project Identification Number from the Projects tab.
- If the expenditure is not related to a project, use "No Project Assigned".
- If there is an expenditure within this reporting period for this
contract, then this is a required field.
- Only the projects that were used for obligations within this
contract can be used for expenditures.
- The Obligation Project and Expenditure Project should match
within a row.
- If a contract has more than one expenditure, each expenditure
must be listed in a separate row. The obligation and contract
fields to the left must be repeated for each.
- The same project can be used for more than one expenditure.
- If there weren't any expenditures within this reporting period
for this contract, then this field can be blank.
S
Expenditure Start Date
Start date for the range of time when the expenditure occurred.
See business
rules
Date
MM/DD/YYYY
10
- If there is an expenditure within this reporting period for this
contract, then this is a required field.
- Expenditure Start Date >=1/1/1990
- Expenditure Start Date must be >= Contract Date.
- Expenditure Start Date >= Period of Performance Start Date
- If there weren't any expenditures within this reporting period
for this contract, then this field can be blank.
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Contracts
Page 15 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
T
Expenditure End Date
End date for the range of time when the expenditure occurred.
See business
rules
Date
MM/DD/YYYY
10
- If there is an expenditure within this reporting period for this
contract, then this is a required field.
- Expenditure End Date must be >= Expenditure Start Date.
- Expenditure End Date <= Period of Performance End Date
- Expenditure End Date <= Reporting Period end date
- Expenditure End Date >=1/1/1990
- Expenditure End Date <=12/30/20
- If there weren't any expenditures within this reporting period
for this contract, then this field can be blank.
U
Cost or Expenditure Amount
The amount of the cost or expenditure entered for this record when it was created.
See business
rules
Number
User input
18,2
- If there is an expenditure within this reporting period for this
contract, then this is a required field.
- Total expenditures cannot exceed total obligations across
reporting periods.
- If there weren't any expenditures within this reporting period
for this contract, then this field can be blank.
V
Cost or Expenditure Category
The group to which the purpose of the obligated cost or expenditure closely relates
to entered for this record when it was created.
See business
rules
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
74
Options for selection (choose one):
- Administrative Expenses
- Budgeted Personnel and Services Diverted to a Substantially Different Use
- COVID-19 Testing and Contact Tracing
- Economic Support (Other than Small Business, Housing, and Food Assistance)
- Expenses Associated with the Issuance of Tax Anticipation Notes
- Facilitating Distance Learning
- Food Programs
- Housing Support
- Improve Telework Capabilities of Public Employees
- Medical Expenses
- Nursing Home Assistance
- Payroll for Public Health and Safety Employees
- Personal Protective Equipment
- Public Health Expenses
- Small Business Assistance
- Unemployment Benefits
- Workers Compensation
- Items Not Listed Above
- If there is an expenditure within this reporting period for this
contract, then this is a required field.
- If there weren't any expenditures within this reporting period
for this contract, then this field can be blank.
W
Category Description
Description for Cost or Expenditure Category field value of "Items Not Listed Above".
See business
rules
String
User input
300
This field is required if the Cost or Expenditure Category field =
"Items Not Listed Above".
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Grants
Page 16 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
A
Sub-Recipient Organization (Awardee)
Sub-Recipient Organization from the list added via the Sub-Recipient tab or
previously uploaded into the Sub-Recipient Organizations section.
Yes
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
9
DUNS # or Identification Number
B
Award Number
Prime recipient's internal account number for the award; the account number or any
other identifying number assigned by the prime recipient to the award. This number
is strictly for the prime recipient’s use only.
Yes
String
User input
55
This number must be unique across all grants.
C
Award Payment Method
The type of grant issued by the prime recipient.
Yes
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
20
Options for selection (select one):
- Lump Sum Payment(s)
- Reimbursable
D
Award Amount
Total amount of Coronavirus Relief Fund dollars on the award issued by the prime
recipient.
Yes
Number
User input
18,2
Award Amount <= Total Amount Coronavirus Relief Funds
Received as reported by Treasury.
E
Award Date
The date that a mutually binding agreement was reached; the date signed by the
prime or borrower, whichever is later.
Yes
Date
MM/DD/YYYY
10
- This should be <= reporting period end date
- Award Date >=1/1/1990
- Award Date <= 12/30/2020
F
Period of Performance Start Date
The date on which efforts begin or the grant is otherwise effective.
Yes
Date
MM/DD/YYYY
10
- Period of Performance Start Date must be >= Award Date
- Period of Performance Start Date >=1/1/1990
G
Period of Performance End Date
The date on which all effort is completed or the grant is otherwise ended.
Yes
Date
MM/DD/YYYY
10
- Period of Performance End Date must be >= Start Date
- Period of Performance End Date >=1/1/1990
- Period of Performance End Date <= 12/30/2020
H
Primary Place of Performance Address
Line 1
First line of the address where the predominant performance of the Grant will be
accomplished.
Yes
String
User input
150
I
Primary Place of Performance Address
Line 2
Second line of the address where the predominant performance of the Grant will be
accomplished.
No
String
User input
150
J
Primary Place of Performance Address
Line 3
Third line of the address where the predominant performance of the Grant will be
accomplished.
No
String
User input
150
K
Primary Place of Performance City
Name
The name of the city where the predominant performance of the Grant will be
accomplished.
For services: In the case of subscription services, software licenses, or similar type
services - use the location where these services are being used; in the case of
services that begin in one location and end in another (e.g., shipping) - use the
destination; in the case of services being performed in oceans/seas - choose the
closest major city (if in U.S. waters); in another country's waters - choose that
country; if in open waters - choose the closest country and choose the closest major
city if that country is the U.S.; in the case of services being performed in the
atmosphere or space - choose the location from which the equipment conducting the
services was launched.
For Goods/Supplies: Items being manufactured should reflect the manufacture site as
the place of performance; all other goods should enter the location the item was
taken from inventory (e.g., the store location, etc.).
Yes
String
User input
40
L
Primary Place of Performance State
Code
United States Postal Service (USPS) two-letter abbreviation for the state or territory
indicating where the predominant performance of the Grant will be accomplished.
Identify States, the District of Columbia, territories (i.e., American Samoa, Guam,
Northern Mariana Islands, Puerto Rico, U.S. Virgin Islands) and associated states (i.e.,
Republic of the Marshall Islands, the Federated States of Micronesia, and Palau) by
their USPS two-letter abbreviation for the purposes of reporting.
Yes
String
User input
2
M
Primary Place of Performance Zip+4
United States ZIP code (five digits) concatenated with the additional +4 digits,
identifying where the predominant performance of the Grant will be accomplished.
Yes
String
User input
10
Note: Use the 5 digit zip code if you don't know the Zip+4. The
system will do the lookup for you when it is confirming the
address with the USPS data.
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Grants
Page 17 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
N
Primary Place of Performance Country
Name
Name of the country where the predominant performance of the Grant will be
accomplished.
Yes
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
100
Options for selection (choose one):
- Afghanistan
- Albania
- Algeria
- American Samoa
- Andorra
- Angola
- Anguilla
- Antarctica
- Antigua And Barbuda
- Argentina
- Armenia
- Aruba
- Australia
- Austria
- Azerbaijan
- Bahamas
- Bahrain
- Bangladesh
- Barbados
- Belarus
- Belgium
- Belize
- Benin
- Bermuda
- Bhutan
- Bolivia
- Bosnia And Herzegovina
O
Award Description
A brief description of the purpose of the award.
Yes
String
User input
4000
P
Is awardee complying with terms and
conditions of the grant?
Confirmation that the Awardee is in compliance as defined by the Prime Recipient
Organization.
Yes
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
3
Options for selection (choose one):
- Yes
- No
Q
Non-Compliance Explanation
This only shows if the user selects "No" in the Is awardee complying with terms and
conditions of the grant? field.
See business
rules
String
User input
50
This field is required if the "Is awardee complying with terms
and conditions of the grant?" field = "No".
R
Obligation Project
Project that an Obligation was for.
See business
rules
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
25
Options for selection (choose one):
- Project Identification Number from the Projects tab.
- If the obligation is not related to a project, use "No Project Assigned".
- If a grant is used for more than one project, each project must
be listed in a separate row with their current quarter obligation
amount. The grant fields to the left must be repeated for each.
- Don't break a project into more than one Current Quarter
Obligation amount.
- If there weren't any obligations for this project within this
reporting period, then this field can be blank.
S
Current Quarter Obligation
Amount obligated for this specific Project for this Grant within this Quarter. (This
could go up or down.)
See business
rules
Number
User input
18,2
- Current Quarter Obligation <= Award Amount
- There can only be one Current Quarter Obligation amount per
Project per grant.
- If there weren't any obligations for this project within this
reporting period, then this field can be blank.
T
Expenditure Project
Project that an Expenditure was for.
See business
rules
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
25
Options for selection (choose one):
- Project Identification Number from the Projects tab.
- If the expenditure is not related to a project, use "No Project Assigned".
- If there is an expenditure within this reporting period for this
grant, then this is a required field.
- Only the projects that were used for obligations within this
grant can be used for expenditures.
- The Obligation Project and Expenditure Project should match
within a row.
- If a grant has more than one expenditure, each expenditure
must be listed in a separate row. The obligation and grant fields
to the left must be repeated for each.
- The same project can be used for more than one expenditure.
- If there weren't any expenditures within this reporting period
for this grant, then this field can be blank.
U
Expenditure Start Date
Start date for the range of time when the expenditure occurred.
See business
rules
Date
MM/DD/YYYY
10
- If there is an expenditure within this reporting period for this
grant, then this is a required field.
- Expenditure Start Date must be >= Award Date.
- Expenditure Start Date >= Period of Performance Start Date
- Expenditure Start Date >=1/1/1990
- If there weren't any expenditures within this reporting period
for this grant, then this field can be blank.
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Grants
Page 18 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
V
Expenditure End Date
End date for the range of time when the expenditure occurred.
See business
rules
Date
MM/DD/YYYY
10
- If there is an expenditure within this reporting period for this
grant, then this is a required field.
- Expenditure End Date must be >= Expenditure Start Date.
- Expenditure End Date <= Period of Performance End Date
- Expenditure End Date <= Reporting Period end date
- Expenditure End Date >=1/1/1990
- Expenditure End Date <=12/30/20
- If there weren't any expenditures within this reporting period
for this grant, then this field can be blank.
W
Cost or Expenditure Amount
The amount of the cost or expenditure entered for this record when it was created.
See business
rules
Number
User input
18,2
- If there is an expenditure within this reporting period for this
grant, then this is a required field.
- Total expenditures cannot exceed total obligations across
reporting periods.
- If there weren't any expenditures within this reporting period
for this grant, then this field can be blank.
X
Cost or Expenditure Category
The group to which the purpose of the obligated cost or expenditure closely relates
to entered for this record when it was created.
See business
rules
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
74
Options for selection (choose one):
- Administrative Expenses
- Budgeted Personnel and Services Diverted to a Substantially Different Use
- COVID-19 Testing and Contact Tracing
- Economic Support (Other than Small Business, Housing, and Food Assistance)
- Expenses Associated with the Issuance of Tax Anticipation Notes
- Facilitating Distance Learning
- Food Programs
- Housing Support
- Improve Telework Capabilities of Public Employees
- Medical Expenses
- Nursing Home Assistance
- Payroll for Public Health and Safety Employees
- Personal Protective Equipment
- Public Health Expenses
- Small Business Assistance
- Unemployment Benefits
- Workers Compensation
- Items Not Listed Above
- If there is an expenditure within this reporting period for this
grant, then this is a required field.
- If there weren't any expenditures within this reporting period
for this grant, then this field can be blank.
Y
Category Description
Description for Cost or Expenditure Category field value of "Items Not Listed Above".
See business
rules
String
User input
300
This field is required if the Cost or Expenditure Category field =
"Items Not Listed Above".
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Loans
Page 19 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
A
Sub-Recipient Organization (Borrower) Sub-Recipient Organization from the list added via the Sub-Recipient tab or
previously uploaded into the Sub-Recipient Organizations section.
Yes
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
9
DUNS # or Identification Number
B
Loan Number
Prime recipient's internal account number for the loan; the account number or any
other identifying number assigned by the prime recipient to the loan. This number is
strictly for the prime recipient’s use only.
Yes
String
User input
55
This number must be unique across all loans.
C
Loan Amount
Total amount of Coronavirus Relief Fund dollars on the loan issued by the prime
recipient.
Yes
Number
User input
18,2
Loan Amount <= Total Amount Coronavirus Relief Funds
Received as reported by Treasury.
D
Loan Date
The date that a mutually binding agreement was reached; the date signed by the
prime or borrower, whichever is later.
Yes
Date
MM/DD/YYYY
10
- Loan Date <= reporting period end date
- Loan Date <= 12/30/2020
- Loan Date >=1/1/1990
E
Loan Expiration Date
The date on which the loan is expected to be repaid in full.
Yes
Date
MM/DD/YYYY
10
- Loan Expiration Date >= Loan Date
- Loan Expiration Date >=1/1/1990
- Loan Expiration Date <= 12/30/2020
F
Primary Place of Performance Address
Line 1
First line of the address where the predominant performance of the Loan will be
accomplished.
Yes
String
User input
150
G
Primary Place of Performance Address
Line 2
Second line of the address where the predominant performance of the Loan will be
accomplished.
No
String
User input
150
H
Primary Place of Performance Address
Line 3
Third line of the address where the predominant performance of the Loan will be
accomplished.
No
String
User input
150
I
Primary Place of Performance City
Name
The name of the city where the predominant performance of the Loan will be
accomplished.
For services: In the case of subscription services, software licenses, or similar type
services - use the location where these services are being used; in the case of
services that begin in one location and end in another (e.g., shipping) - use the
destination; in the case of services being performed in oceans/seas - choose the
closest major city (if in U.S. waters); in another country's waters - choose that
country; if in open waters - choose the closest country and choose the closest major
city if that country is the U.S.; in the case of services being performed in the
atmosphere or space - choose the location from which the equipment conducting the
services was launched.
For Goods/Supplies: Items being manufactured should reflect the manufacture site as
the place of performance; all other goods should enter the location the item was
taken from inventory (e.g., the store location, etc.).
Yes
String
User input
40
J
Primary Place of Performance State
Code
United States Postal Service (USPS) two-letter abbreviation for the state or territory
indicating where the predominant performance of the Loan will be accomplished.
Identify States, the District of Columbia, territories (i.e., American Samoa, Guam,
Northern Mariana Islands, Puerto Rico, U.S. Virgin Islands) and associated states (i.e.,
Republic of the Marshall Islands, the Federated States of Micronesia, and Palau) by
their USPS two-letter abbreviation for the purposes of reporting.
Yes
String
User input
2
K
Primary Place of Performance Zip+4
United States ZIP code (five digits) concatenated with the additional +4 digits,
identifying where the predominant performance of the Loan will be accomplished.
Yes
String
User input
10
Note: Use the 5 digit zip code if you don't know the Zip+4. The
system will do the lookup for you when it is confirming the
address with the USPS data.
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Loans
Page 20 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
L
Primary Place of Performance Country
Name
Name of the country where the predominant performance of the Loan will be
accomplished.
Yes
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
100
Options for selection (choose one):
- Afghanistan
- Albania
- Algeria
- American Samoa
- Andorra
- Angola
- Anguilla
- Antarctica
- Antigua And Barbuda
- Argentina
- Armenia
- Aruba
- Australia
- Austria
- Azerbaijan
- Bahamas
- Bahrain
- Bangladesh
- Barbados
- Belarus
- Belgium
- Belize
- Benin
- Bermuda
- Bhutan
- Bolivia
- Bosnia And Herzegovina
M
Loan Description
A brief description of the purpose of the loan.
Yes
String
User input
4000
N
Obligation Project
Project that an Obligation was for.
See business
rules
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
25
Options for selection (choose one):
- Project Identification Number from the Projects tab.
- If the obligation is not related to a project, use "No Project Assigned".
- If a loan is used for more than one project, each project must
be listed in a separate row with their current quarter obligation
amount. The loan fields to the left must be repeated for each.
- Don't break a project into more than one Current Quarter
Obligation amount.
- If there weren't any obligations for this project within this
reporting period, then this field can be blank.
O
Current Quarter Obligation
Amount obligated for this specific Project for this Loan within this Quarter. (This
could go up or down.)
See business
rules
Number
User input
18,2
- Current Quarter Obligation <= Loan Amount
- There can only be one Current Quarter Obligation amount per
Project per loan.
- If there weren't any obligations for this project within this
reporting period, then this field can be blank.
P
Payment Project
Project that a Payment was for.
See business
rules
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
25
Options for selection (choose one):
- Project Identification Number from the Projects tab.
- If the payment is not related to a project, use "No Project Assigned".
- If there is a payment within this reporting period for this loan,
then this is a required field.
- Only the projects that were used for obligations within this
loan can be used for payments.
- The Obligation Project and Payment Project should match
within a row.
- If a loan has more than one payment, each payment must be
listed in a separate row. The obligation and loan fields to the
left must be repeated for each.
- The same project can be used for more than one payment.
- If there weren't any payments within this reporting period for
this loan, then this field can be blank.
Q
Payment Date
Date when the payment occurred.
See business
rules
Date
MM/DD/YYYY
10
- If there is a payment within this reporting period for this loan,
then this is a required field.
- Payment Date must be >= Loan Date.
- Payment Date <= Loan Expiration Date
- Payment Date <= Reporting Period end date
- Payment Date >=1/1/1990
- Payment Date <=12/30/20
- If there weren't any payments within this reporting period for
this loan, then this field can be blank.
R
Payment Amount
The amount of the Payment entered for this record when it was created in a previous
reporting period.
See business
rules
Number
User input
18,2
- If there is a payment within this reporting period for this loan,
then this is a required field.
- Total payments cannot exceed total obligations across
reporting periods.
- If there weren't any payments within this reporting period for
this loan, then this field can be blank.
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Loans
Page 21 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
S
Loan Category
The group to which the purpose of the loan closely relates to entered for this record
when it was created in a previous reporting period.
See business
rules
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
74
Options for selection (choose one):
- Administrative Expenses
- Budgeted Personnel and Services Diverted to a Substantially Different Use
- COVID-19 Testing and Contact Tracing
- Economic Support (Other than Small Business, Housing, and Food Assistance)
- Expenses Associated with the Issuance of Tax Anticipation Notes
- Facilitating Distance Learning
- Food Programs
- Housing Support
- Improve Telework Capabilities of Public Employees
- Medical Expenses
- Nursing Home Assistance
- Payroll for Public Health and Safety Employees
- Personal Protective Equipment
- Public Health Expenses
- Small Business Assistance
- Unemployment Benefits
- Workers Compensation
- Items Not Listed Above
- If there is a payment within this reporting period for this loan,
then this is a required field.
- If there weren't any payments within this reporting period for
this loan, then this field can be blank.
T
Category Description
Description for Payment Category field value of "Items Not Listed Above".
See business
rules
String
User input
300
This field is required if the Cost or Loan Category field = "Items
Not Listed Above".
U
Will these payments be repurposed for
Future Use?
Clarification whether a payment amount will be repurposed or returned to Treasury.
See business
rules
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
Options for selection (select one):
- Yes
- No, Returning to Treasury
- If there is a payment within this reporting period for this loan,
then this is a required field.
- If there weren't any payments within this reporting period for
this loan, then this field can be blank.
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Transfers
Page 22 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
A
Sub-Recipient Organization
(Transferee/Government Unit)
Sub-Recipient Organization from the list added via the Sub-Recipient tab or
previously uploaded into the Sub-Recipient Organizations section.
Yes
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
9
DUNS # or Identification Number
Only Sub-Recipient Organizations flagged with the following org
types on SAM.gov or the Sub-Recipient tab.
- City or Township Government
- County Government
- Indian/Native American Tribal Designated Organization
- Indian/Native American Tribal Government (Federally
Recognized)
- Special District Government
- State Government
B
Transfer Number
Prime recipient's internal account number for the award; the account number or any
other identifying number assigned by the prime recipient to the award. This number
is strictly for the prime recipient’s use only.
Yes
String
User input
55
This number must be unique across all transfers.
C
Transfer Type
The type of transfer issued by the prime recipient.
Yes
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
30
Options for selection (select one):
- Lump Sum Payment(s)
- Reimbursable
D
Transfer Amount
Total amount of Coronavirus Relief Fund dollars transferred by the prime recipient to
another government.
Yes
Number
User input
18,2
Transfer Amount <= Total Amount Coronavirus Relief Funds
Received as reported by Treasury.
E
Transfer Date
The date that the prime recipient transfers funds to the transferee.
Yes
Date
MM/DD/YYYY
10
- Transfer Date <= reporting period end date
- Transfer Date >=1/1/1990
- Transfer Date <= 12/30/2020
F
Purpose Description
The brief description of the purpose of the transfer.
Yes
String
User input
4000
G
Obligation Project
Project that an Obligation was for.
See business
rules
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
25
Options for selection (choose one):
- Project Identification Number from the Projects tab.
- If the obligation is not related to a project, use "No Project Assigned".
- If a transfer is used for more than one project, each project
must be listed in a separate row with their current quarter
obligation amount. The transfer fields to the left must be
repeated for each.
- Don't break a project into more than one Current Quarter
Obligation amount.
- If there weren't any obligations for this project within this
reporting period, then this field can be blank.
H
Current Quarter Obligation
Amount obligated for this specific Project for this Transfer within this Quarter. (This
could go up or down.)
See business
rules
Number
User input
18,2
- Current Quarter Obligation <= Transfer Amount
- There can only be one Current Quarter Obligation amount per
Project per transfer.
- If there weren't any obligations for this project within this
reporting period, then this field can be blank.
I
Expenditure Project
Project that an Expenditure was for.
See business
rules
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
25
Options for selection (choose one):
- Project Identification Number from the Projects tab.
- If the expenditure is not related to a project, use "No Project Assigned".
- If there is an expenditure within this reporting period for this
transfer, then this is a required field.
- Only the projects that were used for obligations within this
transfer can be used for expenditures.
- The Obligation Project and Expenditure Project should match
within a row.
- If a transfer has more than one expenditure, each expenditure
must be listed in a separate row. The obligation and transfer
fields to the left must be repeated for each.
- The same project can be used for more than one expenditure.
- If there weren't any expenditures within this reporting period
for this transfer, then this field can be blank.
J
Expenditure Start Date
Start date for the range of time when the expenditure occurred.
See business
rules
Date
MM/DD/YYYY
10
- If there is an expenditure within this reporting period for this
transfer, then this is a required field.
- Expenditure Start Date can be earlier than the Transfer Date.
This is allowed to handle reimbursable transfers. Transfers is the
only funding instrument that allows this.
- Expenditure Start Date >=1/1/1990
- If there weren't any expenditures within this reporting period
for this transfer, then this field can be blank.
K
Expenditure End Date
End date for the range of time when the expenditure occurred.
See business
rules
Date
MM/DD/YYYY
10
- If there is an expenditure within this reporting period for this
transfer, then this is a required field.
- Expenditure End Date must be >= Expenditure Start Date.
- Expenditure End Date <= Reporting Period end date
- Expenditure End Date >=1/1/1990
- Expenditure End Date <=12/30/20
- If there weren't any expenditures within this reporting period
for this transfer, then this field can be blank.
L
Cost or Expenditure Amount
The amount of the cost or expenditure entered for this record when it was created.
See business
rules
Number
User input
18,2
- If there is an expenditure within this reporting period for this
transfer, then this is a required field.
- Total expenditures cannot exceed total obligations across
reporting periods.
- If there weren't any expenditures within this reporting period
for this transfer, then this field can be blank.
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Transfers
Page 23 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
M
Cost or Expenditure Category
The group to which the purpose of the obligated cost or expenditure closely relates
to entered for this record when it was created.
See business
rules
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
74
Options for selection (choose one):
- Administrative Expenses
- Budgeted Personnel and Services Diverted to a Substantially Different Use
- COVID-19 Testing and Contact Tracing
- Economic Support (Other than Small Business, Housing, and Food Assistance)
- Expenses Associated with the Issuance of Tax Anticipation Notes
- Facilitating Distance Learning
- Food Programs
- Housing Support
- Improve Telework Capabilities of Public Employees
- Medical Expenses
- Nursing Home Assistance
- Payroll for Public Health and Safety Employees
- Personal Protective Equipment
- Public Health Expenses
- Small Business Assistance
- Unemployment Benefits
- Workers Compensation
- Items Not Listed Above
- If there is an expenditure within this reporting period for this
transfer, then this is a required field.
- If there weren't any expenditures within this reporting period
for this transfer, then this field can be blank.
N
Category Description
Description for Cost or Expenditure Category field value of "Items Not Listed Above".
See business
rules
String
User input
300
This field is required if the Cost or Expenditure Category field =
"Items Not Listed Above".
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Direct
Page 24 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
A
Sub-Recipient Organization (Payee)
Sub-Recipient Organization from the list added via the Sub-Recipient tab or
previously uploaded into the Sub-Recipient Organizations section.
Yes
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
9
DUNS # or Identification Number
B
Obligation Amount
Total amount of Coronavirus Relief Fund dollars in this Direct Payment.
Yes
Number
User input
18,2
Obligation Amount <= Total Amount Coronavirus Relief Funds
Received as reported by Treasury.
C
Obligation Date
The date the prime recipient obligated the cost or expenditure due to the public
health emergency with respect to COVID-19 (the date must be between March 1,
2020 and December 30, 2020).
Yes
Date
MM/DD/YYYY
10
- Obligation Date <= reporting period end date
- Obligation Date >=1/1/1990
- Obligation Date <= 12/30/2020
D
Obligation Project
Project that an Obligation was for.
See business
rules
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
25
Options for selection (choose one):
- Project Identification Number from the Projects tab.
- If the obligation is not related to a project, use "No Project Assigned".
- If a direct payment is used for more than one project, each
project must be listed in a separate row with their current
quarter obligation amount. The direct payment fields to the left
must be repeated for each.
- Don't break a project into more than one Current Quarter
Obligation amount.
- If there weren't any obligations for this project within this
reporting period, then this field can be blank.
E
Current Quarter Obligation
Amount obligated for this specific Project for this Direct Payment within this Quarter.
(This could go up or down.)
See business
rules
Number
User input
18,2
- Current Quarter Obligation <= Obligation Amount
- There can only be one Current Quarter Obligation amount per
Project per Direct Payment.
- If there weren't any obligations for this project within this
reporting period, then this field can be blank.
F
Expenditure Project
Project that an Expenditure was for.
See business
rules
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
25
Options for selection (choose one):
- Project Identification Number from the Projects tab.
- If the expenditure is not related to a project, use "No Project Assigned".
- If there is an expenditure within this reporting period for this
direct payment, then this is a required field.
- Only the projects that were used for obligations within this
direct payment can be used for expenditures.
- The Obligation Project and Expenditure Project should match
within a row.
- If a direct payment has more than one expenditure, each
expenditure must be listed in a separate row. The obligation
and direct payment fields to the left must be repeated for each.
- The same project can be used for more than one expenditure.
- If there weren't any expenditures within this reporting period
for this direct payment, then this field can be blank.
G
Expenditure Start Date
Start date for the range of time when the expenditure occurred.
See business
rules
Date
MM/DD/YYYY
10
- If there is an expenditure within this reporting period for this
direct payment, then this is a required field.
- Expenditure Start Date >= Obligation Date.
- Expenditure Start Date >=1/1/1990
- If there weren't any expenditures within this reporting period
for this direct payment, then this field can be blank.
H
Expenditure End Date
End date for the range of time when the expenditure occurred.
See business
rules
Date
MM/DD/YYYY
10
- If there is an expenditure within this reporting period for this
direct payment, then this is a required field.
- Expenditure End Date must be >= Expenditure Start Date.
- Expenditure End Date <= Reporting Period end date
- Expenditure End Date >=1/1/1990
- Expenditure End Date <=12/30/20
- If there weren't any expenditures within this reporting period
for this direct payment, then this field can be blank.
I
Cost or Expenditure Amount
The amount of the cost or expenditure entered for this record when it was created.
See business
rules
Number
User input
18,2
- If there is an expenditure within this reporting period for this
direct payment, then this is a required field.
- Total expenditures cannot exceed total obligations across
reporting periods.
- If there weren't any expenditures within this reporting period
for this direct payment, then this field can be blank.
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Direct
Page 25 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
J
Cost or Expenditure Category
The group to which the purpose of the obligated cost or expenditure closely relates
to entered for this record when it was created.
See business
rules
String
Pre-defined List
of Values -- See
Column H (8),
List of Values
74
Options for selection (choose one):
- Administrative Expenses
- Budgeted Personnel and Services Diverted to a Substantially Different Use
- COVID-19 Testing and Contact Tracing
- Economic Support (Other than Small Business, Housing, and Food Assistance)
- Expenses Associated with the Issuance of Tax Anticipation Notes
- Facilitating Distance Learning
- Food Programs
- Housing Support
- Improve Telework Capabilities of Public Employees
- Medical Expenses
- Nursing Home Assistance
- Payroll for Public Health and Safety Employees
- Personal Protective Equipment
- Public Health Expenses
- Small Business Assistance
- Unemployment Benefits
- Workers Compensation
- Items Not Listed Above
- If there is an expenditure within this reporting period for this
direct payment, then this is a required field.
- If there weren't any expenditures within this reporting period
for this direct payment, then this field can be blank.
K
Category Description
Description for Cost or Expenditure Category field value of "Items Not Listed Above".
See business
rules
String
User input
300
This field is required if the Cost or Expenditure Category field =
"Items Not Listed Above".
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Aggregate Awards < 50000
Page 26 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
A
Funding Type
The Funding Type that had obligation or expenditure/payment activity during the
reporting period.
See business
rules
String
Labels
N/A
The system will show the following labels
- Aggregate of Contracts Awarded for <$50,000
- Aggregate of Grants Awarded for <$50,000
- Aggregate of Loans Issued for <$50,000
- Aggregate of Transfers <$50,000
- Aggregate of Direct Payments <$50,000
These are included so that the correct obligation and/or
expenditure/payment data is entered into the correct row.
Please do not delete or change the order of these labels.
B
Current Quarter Obligation
Sum of obligations within this Quarter for this funding type (ex: Aggregate of
Contracts Awarded for <$50,000).
See business
rules
Number
User input
20,2
- Current Quarter Obligation <= Total Amount Coronavirus Relief
Funds Received as reported by Treasury.
- It is possible that a Funding Type does not have an obligation
within a particular reporting period. If so, leave this field blank.
C
Current Quarter Expenditure/Payments Sum of Expenditures or Payments within this Quarter for this funding type (ex:
Aggregate of Contracts Awarded for <$50,000).
See business
rules
Number
User input
20,2
- Current Quarter Expenditure/Payments <= Total Amount
Coronavirus Relief Funds Received as reported by Treasury.
- It is possible that a Funding Type does not have an
expenditure/payment within a particular reporting period. If so,
leave this field blank.
Coronavirus Relief Fund Financial Progress Report
Upload Data Dictionary
Aggregate Payments Individual
Page 27 of 27
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
Column
Field Label
Definition
Required?
Data Type
Field Type
Max Field
Length
List of Values
Business Rules
A
Current Quarter Obligation
Sum of obligations within this Quarter for Direct Payments to Individuals
See business
rules
Number
User input
20,2
- Current Quarter Obligation <= Total Amount Coronavirus Relief
Funds Received as reported by Treasury.
- It is possible that there is no obligation within a particular
reporting period. If so, leave this field blank.
B
Current Quarter Expenditure
Sum of Expenditures within this Quarter for Direct Payments to Individuals
See business
rules
Number
User input
20,2
- Current Quarter Expenditure/Payments <= Total Amount
Coronavirus Relief Funds Received as reported by Treasury.
- It is possible that there is no Current Quarter Expenditure
within a particular reporting period. If so, leave this field blank.