OIG-CA-20-030: Coronavirus Relief Fund Recipient Reporting Portal Data Dictionary

Summary

Treasury Office of Inspector General document OIG-CA-20-030, the Coronavirus Relief Fund Recipient Reporting Portal Data Dictionary, dated September 2, 2020. It defines each data element that prime recipients of the fund must report through the portal, stating for each whether it is required or optional and whether it is prepopulated or entered by the user. Elements cover the prime recipient's DUNS number, address, recipient type and total Coronavirus Relief Funds received; each project's name, description and completion status; sub-recipient organizations; and contracts, including contract number, type, amount, dates and place of performance. Further sections cover aggregate reporting of payments under $50,000 and aggregate direct payments to individuals, with current-quarter and cumulative obligation and expenditure totals.

Summary drafted by a model from the document's text below and checked by script against that text before publication. It is a navigation aid, not a reading of what the document proves. Where AI is used

Full text

OIG-CA-20-030
Coronavirus Relief Fund Recipient Reporting Portal Data Dictionary
CARES Act
September 2, 2020
Office of Inspector General
Department of the Treasury

Data Element
Definition
Reporting Form
Required/Optional Comments
DUNS
The unique identification number for the prime recipient. Currently the identifier is the 9-digit
number assigned by Dun and Bradstreet (D&B) referred to as the DUNS® number.
Prime Recipient
Required
Legal Entity Name
The name of the prime recipient.
Prime Recipient
Required
Prepopulated
Address Line 1
First line of the prime recipient's address.
Prime Recipient
Required
Prepopulated
Address Line 2
Second line of the prime recipient's address.
Prime Recipient
Optional
Prepopulated
Address Line 3
Third line of the prime recipient's  address.
Prime Recipient
Optional
Prepopulated
City Name
Name of the city in which the prime recipient is located.
Prime Recipient
Required
Prepopulated
State Code
United States Postal Service (USPS) two-letter abbreviation for the state or territory in which the
prime recipient is located.
Prime Recipient
Required
Prepopulated
Zip+4
United States ZIP code (five digits) concatenated with the additional +4 digits associated with
the prime recipient's address.
Prime Recipient
Required
Prepopulated
Congressional District
The congressional district in which the recipient is located. U.S. States with a single
congressional district should use Congressional District code 00 (indicating an at-large district).
U.S. Territories and the District of Columbia should use Congressional District code 98
(indicating a non-voting representative).
Prime Recipient
Required
Prepopulated
Country Name
The name corresponding to the country code in which the prime recipient is located.
Prime Recipient
Required
Prepopulated
Country Code
Code for the country in which the prime recipient is located, using the International Standard for
country codes (ISO) 3166-1 Alpha-3 GENC Profile, minus the codes listed for those territories
and possessions of the United States already identified as “states.”
Prime Recipient
Required
Prepopulated
Recipient Type
The type of prime recipient receiving Coronavirus Relief Fund payment:
Options for selection (select one):
- State Government
- Local Government
- DC/Territory
- Tribal Government
Prime Recipient
Required
Prepopulated
CFDA Number
The number assigned to a Federal area of work in the Catalog of Federal Domestic Assistance
(CFDA).
Prime Recipient
Conditionally
Required
Prepopulated
Total Amount Coronavirus Relief Funds
Received
Total amount of Coronavirus Relief Funds received by the prime recipient.
Prime Recipient
Required
Prepopulated
Point of Contact Name
The name of the prime recipient's primary point of contact.
Prime Recipient
Required
Prepopulated
Point of Contact Title
The title of the prime recipient's primary point of contact.
Prime Recipient
Required
Prepopulated
Point of Contact Email
The email address of the prime recipient's primary point of contact.
Prime Recipient
Required
Prepopulated
Point of Contact Phone
The phone number of the prime recipient's primary point of contact.
Prime Recipient
Required
Prepopulated

Data Element
Definition
Reporting Form
Required/Optional
Comments
Project Name
The brief descriptive name of the project funded in whole or in part with Coronavirus Relief
Funds.
Projects
Required
User manually enters
Project Identification Number
Unique trackable identification number for the project or activity
Projects
Required
The user will need to create an identification number for each project
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).
Projects
Required
The user will need to add a description of each
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.
Options for selection (select one):
- Select One (Default)
- Not started
- Less than 50% completed
- Completed 50% or more
- Fully completed
Projects
Required
Recipients should review this element for each reporting period to ensure that the status of each
project is up to date.

Data Element
Definition
Reporting Form
Required/Optional
Comments
DUNS Number Available
Yes/No
This is used to turn on/off the DUNS search functionality.
Defaults to "Yes".
Sub-Recipient
Organization Edit
Required
User manually enters
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.
Sub-Recipient
Organization Edit
Optional
DUNS Search tool uses this field to pull in data from SAM.gov.
DUNS Validation
Results of the DUNS search:
- DUNS Verified
- DUNS Not Verified
Sub-Recipient
Organization Edit
Optional
This shows the results of the DUNS search. If the results are DUNS Not Verified, then the user will have
to change to DUNS Available = No and manually enter the field values.
Identification Number
User defined unique identification number for the Sub-Recipient organization if they do not
have a DUNS number.
Sub-Recipient
Organization Edit
Optional
If DUNS Available = Yes and DUNS search is successful, this is not available.
If DUNS Available = No, this field is editable but optional.
Legal Name
The name of the Sub-Recipient Organization.
Sub-Recipient
Organization Edit
Required
If DUNS Available = Yes and DUNS search is successful, this is automatically populated and the field is
read only.
If DUNS Available = No, this field is editable and required.
Address Line 1
First line of the Sub-Recipient Organization's address.
Sub-Recipient
Organization Edit
Required
If DUNS Available = Yes and DUNS search is successful, this is automatically populated and the field is
read only.
If DUNS Available = No, this field is editable and required.
Note: The values can be overridden by the Address Validation.
Address Line 2
Second line of the Sub-Recipient Organization's address.
Sub-Recipient
Organization Edit
Optional
If DUNS Available = Yes and DUNS search is successful, this is automatically populated and the field is
read only.
If DUNS Available = No, this field is editable but not required.
Note: The values can be overridden by the Address Validation.
Address Line 3
Third line of the Sub-Recipient Organization's address.
Sub-Recipient
Organization Edit
Optional
If DUNS Available = Yes and DUNS search is successful, this is automatically populated and the field is
read only.
If DUNS Available = No, this field is editable but not required.
Note: The values can be overridden by the Address Validation.
City Name
Name of the city in which the Sub-Recipient Organization is located.
Sub-Recipient
Organization Edit
Required
If DUNS Available = Yes and DUNS search is successful, this is automatically populated and the field is
read only.
If DUNS Available = No, this field is editable and required.
Note: The values can be overridden by the Address Validation.
State Code
United States Postal Service (USPS) two-letter abbreviation for the state or territory in which the
Sub-Recipient Organization is located.
Sub-Recipient
Organization Edit
Required
If DUNS Available = Yes and DUNS search is successful, this is automatically populated and the field is
read only.
If DUNS Available = No, this field is editable and required.
Note: The values can be overridden by the Address Validation.
Zip+4
United States ZIP code (five digits) concatenated with the additional +4 digits associated with
the Sub-Recipient Organization's address.
Sub-Recipient
Organization Edit
Required
If DUNS Available = Yes and DUNS search is successful, this is automatically populated and the field is
read only.
If DUNS Available = No, this field is editable and required.
Note: The values can be overridden by the Address Validation.
Address Validation
Results of the Address validation:
- Validated Address
- Address not Validated
Sub-Recipient
Organization Edit
Optional
This only appears if the DUNS Available = No.
This updates based on the results of the Address Validation tool.
Note: Foreign addresses will not pass Address validation.
Country Name
The name corresponding to the country code in which the Sub-Recipient Organization is located.
Sub-Recipient
Organization Edit
Required
If DUNS Available = Yes and DUNS search is successful, this is automatically populated.
If DUNS Available = No, this field is filled in by the Address Validation.
If this organization is outside the USA, then this field is a dropdown that the user must manually select
from.
The value selected here will update the Country Code field above.
Country Code
Code for the country in which the Sub-Recipient Organization is located, using the International
Standard for country codes (ISO) 3166-1 Alpha-3 GENC Profile, minus the codes listed for those
territories and possessions of the United States already identified as “states.”
Sub-Recipient
Organization Edit
Required
The field is read only.
If DUNS Available = Yes and DUNS search is successful, this is automatically populated.
If DUNS Available = No, this field is filled in by the Address Validation.
If this organization is outside the USA, then this field will be updated based on the Country Name
selected.
Congressional District
The congressional district in which the Sub-Recipient Organization is located. U.S. States with a
single congressional district should use Congressional District code 00 (indicating an at-large
district). U.S. Territories and the District of Columbia should use Congressional District code 98
(indicating a non-voting representative).
Sub-Recipient
Organization Edit
Optional
The field is read only.
If DUNS Available = Yes and DUNS search is successful, this is automatically populated.
If DUNS Available = No, this field is filled in by the Address Validation.
If this organization is outside the USA, then this field will be blank.
Organization Type
A collection of indicators of different types of Sub-Recipient Organizations based on socio-
economic status and organization / business areas.
Sub-Recipient
Organization Edit
Required
If DUNS Available = Yes and DUNS search is successful, this is automatically populated and the field is
read only.
If DUNS Available = No, this field is editable and required.
User can choose more than one.

Data Element
Definition
Reporting Form
Required/Optional
Comments
Sub-Recipient Organization (Contractor)
Sub-Recipient Organization from the list added via the Sub-Recipient Organizations section.
Dopdown includes:
- "<Sub-Recipient Organization's name> - <DUNS>" OR "<Sub-Recipient Organization's name> -
<Identification Number>"
Values are listed in alphabetical order by Sub-Recipient Organization's name, then DUNS.
Users can only select one.
Contracts Edit - Overview
section
Required
User selects from a list of the sub-recipients added in the sub-recipient tab
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.
Contracts Edit - Overview
section
Required
User manually enters
Contract Type
The type of contract issued by the prime recipient.
Options for selection (select one):
- Purchase Order
- Delivery Order
- Blanket Purchase Agreement
- Definitive Contract
Contracts Edit - Overview
section
Required
User selects from the list
Contract Amount
Total amount of Coronavirus Relief Fund dollars on the contract issued by the prime recipient.
Contracts Edit - Overview
section
Required
User manually enters
Contract Date
The date that a mutually binding agreement was reached; the date signed by the prime or
contractor, whichever is later.
Contracts Edit - Overview
section
Required
User manually enters
Period of Performance Start Date
The date on which efforts begin or the contract is otherwise effective.
Contracts Edit - Overview
section
Required
User manually enters
Period of Performance End Date
The date on which all effort is completed or the contract is otherwise ended.
Contracts Edit - Overview
section
Required
User manually enters
Primary Place of Performance Address
Line 1
First line of the address where the predominant performance of the contract will be
accomplished.
Contracts Edit - Overview
section
Required
User manually enters these values.
Note: The values can be overridden by the Address Validation.
Primary Place of Performance Address
Line 2
Second line of the address where the predominant performance of the contract will be
accomplished.
Contracts Edit - Overview
section
Optional
User manually enters these values.
Note: The values can be overridden by the Address Validation.
Primary Place of Performance Address
Line 3
Third line of the address where the predominant performance of the contract will be
accomplished.
Contracts Edit - Overview
section
Optional
User manually enters these values.
Note: The values can be overridden by the Address Validation.
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.).
Contracts Edit - Overview
section
Required
User manually enters these values.
Note: The values can be overridden by the Address Validation.
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.
Contracts Edit - Overview
section
Required
User manually enters these values.
Note: The values can be overridden by the Address Validation.
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.
Contracts Edit - Overview
section
Required
User manually enters these values.
Note: The values can be overridden by the Address Validation.
Address Validation
Results of the Address validation:
- Validated Address
- Address not Validated
Contracts Edit - Overview
section
Optional
This updates based on the results of the Address Validation tool.
Note: Foreign addresses will not pass Address validation.
Primary Place of Performance Country
Name
Name of the country represented by the country code where the predominant performance of the
contract will be accomplished.
Contracts Edit - Overview
section
Required
This field is filled in by the Address Validation.
OR
If this organization is outside the USA, then this field is a dropdown that the user must manually select
from.
The value selected here will update the Country Code field above.
Primary Place of Performance Country
Code
Country code where the predominant performance of the contract will be accomplished.
Contracts Edit - Overview
section
Required
This field is filled in by the Address Validation.
OR
If this organization is outside the USA, then this field will be updated based on the Country Name
selected.
Primary Place of Performance
Congressional District
The congressional district in which the predominant performance of the contract is located. U.S.
States with a single congressional district should use Congressional District code 00 (indicating an
at-large district). U.S. Territories and the District of Columbia should use Congressional District
code 98 (indicating a non-voting representative).
Contracts Edit - Overview
section
Required
This field is filled in by the Address Validation.
If this organization is outside the USA, then this field will be blank.
Contract Description
A brief description of the purpose of the contract.
Contracts Edit - Overview
section
Required
Obligations
Label for the section that contains the Obligations table.
Contracts Edit -
Obligations Section
N/A
Project
Project from the list added via the Projects section.
Dopdown includes:
- <Project #> - <Project/Activity Name>
- "No Assigned Project"
Values are listed in alphabetical order by Project number, then Project name.
Users can only select one per row.
Each Project can only be selected once within the table.
Contracts Edit -
Obligations Section (table)
Required
System loads all records from the Projects section into the dropdown.
Current Quarter Obligation
Amount obligated for this specific Project within this Quarter. (This could go up or down.)
Contracts Edit -
Obligations Section (table)
Required
User manually enters
Cumulative Obligation
Total amount obligated for this Project across all reporting periods.
This includes the Current Quarter Obligation.
Contracts Edit -
Obligations Section (table)
Required
System sums the Current Quarter Obligation values for this Project for all reporting periods including this
one.
Current Quarter Expenditure
Total expenditure amount for this Project within this reporting period.
(ie: Sum per Project from the Current Quarter Expenditures table.)
Contracts Edit -
Obligations Section (table)
Required
System sums the Cost or Expenditure Amount values for this Project for this reporting period (ie: from
the Expenditures table below).
Cumulative Expenditure
Total expenditure amount for this Project across all reporting periods.
This includes the Current Quarter Expenditure.
(ie: Sum per Project from the Current Quarter Expenditures table AND the Previous Expenditures
(All previous quarters) table.)
Contracts Edit -
Obligations Section (table)
Required
System sums the Cost or Expenditure Amount values for this Project for all reporting periods including
this one.
Total Current Quarter Obligation
Total for the Current Quarter Obligation column.
Contracts Edit -
Obligations Section (table)
Required
System sums the Current Quarter Obligation column.
Total Cumulative Obligation
Total for the Cumulative Obligation column.
Contracts Edit -
Obligations Section (table)
Required
System sums the Cumulative Obligation column.
Total Current Quarter Expenditure
Total for the Current Quarter Expenditure column.
Contracts Edit -
Obligations Section (table)
Required
System sums the Current Quarter Expenditure column.
Total Cumulative Expenditure
Total for the Cumulative Expenditure column.
Contracts Edit -
Obligations Section (table)
Required
System sums the Cumulative Expenditure column.
Previous Expenditures (All previous
quarters)
Label for the section that contains the Previous Expenditures (All previous quarters) table.
Contracts Edit - Previous
Expenditures Section
N/A
Project
Project entered for this record when it was created in a previous reporting period.
Contracts Edit - Previous
Expenditures Section
(table)
Required
System generated
Expenditure Date Range
Date range for the expenditure entered for this record when it was created in a previous
reporting period.
Contracts Edit - Previous
Expenditures Section
(table)
Required
System generated
Cost or Expenditure Amount
The amount of the cost or expenditure entered for this record when it was created in a previous
reporting period.
Contracts Edit - Previous
Expenditures Section
(table)
Required
System generated
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 in a previous reporting period.
Contracts Edit - Previous
Expenditures Section
(table)
Required
System generated
Category Description
Cost or Expenditure Category field "Other" description entered for this record when it was
created in a previous reporting period..
Contracts Edit - Previous
Expenditures Section
(table)
Conditionally
Required
System generated
Total Cost or Expenditure Amount
Total for the Cost or Expenditure Amount column.
Contracts Edit - Previous
Expenditures Section
(table)
Required
Sum of the Cost or Expenditure Amount column.
Current Quarter Expenditures
Label for the section that contains the Current Quarter Expenditures table.
Contracts Edit - Current
Quarter Expenditures
Section
N/A
Project
Project from the list added via the Projects section.
Dopdown includes:
- <Project #> - <Project/Activity Name>
- "No Assigned Project"
Values are listed in alphabetical order by Project number, then Project name.
Users can only select one per row.
Each Project can be selected more than once within the table.
Contracts Edit - Current
Quarter Expenditures
Section (table)
Required
System loads projects from the Obligation table into the dropdown.
Expenditure Date Range
Date range for the expenditure. This will include two date fields.
Contracts Edit - Current
Quarter Expenditures
Section (table)
Required
User manually enters
Cost or Expenditure Amount
The amount of the cost or expenditure obligated by the prime recipient due to the public health
emergency with respect to COVID-19.
Contracts Edit - Current
Quarter Expenditures
Section (table)
Required
User manually enters
Cost or Expenditure Category
Indication of the group to which the purpose of the obligated cost or expenditure closely relates
to.
Options for selections (select 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
Contracts Edit - Current
Quarter Expenditures
Section (table)
Required
User selects from a list of expenditure categories
Category Description
This only allows the user to enter data if the Cost or Expenditure Category field = "Items Not
Listed Above".
Contracts Edit - Current
Quarter Expenditures
Section (table)
Conditionally
Required
User manually enters
Total Cost or Expenditure Amount
Total for the Cost or Expenditure Amount column.
Contracts Edit - Current
Quarter Expenditures
Section (table)
Required
Sum of the Cost or Expenditure Amount column.

Data Element
Definition
Reporting Form
Required/Optional Comments
Sub-Recipient Organization (Awardee)
Sub-Recipient Organization from the list added via the Sub-Recipient Organizations section.
Dopdown includes:
- "<Sub-Recipient Organization's name> - <DUNS>" OR "<Sub-Recipient Organization's name> -
<Identification Number>"
Values are listed in alphabetical order by Sub-Recipient Organization's name, then DUNS.
Users can only select one.
Grants Edit - Overview
section
Required
System loads all Sub-Recipient records into the dropdown.
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.
Grants Edit - Overview
section
Required
User manually enters
Award Payment Method
The type of grant issued by the prime recipient.
Dropdown values:
- Lump Sum Payment(s)
- Reimbursable
Grants Edit - Overview
section
Required
User selects from a list
Award Amount
Total amount of Coronavirus Relief Fund dollars on the award issued by the prime recipient.
Grants Edit - Overview
section
Required
User manually enters
Award Date
The date that a mutually binding agreement was reached; the date signed by the prime or
borrower, whichever is later.
Grants Edit - Overview
section
Required
User manually enters
Period of Performance Start Date
The date on which efforts begin or the grant is otherwise effective.
Grants Edit - Overview
section
Required
User manually enters
Period of Performance End Date
The date on which all effort is completed or the grant is otherwise ended.
Grants Edit - Overview
section
Required
User manually enters
Primary Place of Performance Address
Line 1
First line of the address where the predominant performance of the Grant will be
accomplished.
Grants Edit - Overview
section
Required
User manually enters these values.
Note: The values can be overridden by the Address Validation.
Primary Place of Performance Address
Line 2
Second line of the address where the predominant performance of the Grant will be
accomplished.
Grants Edit - Overview
section
Optional
User manually enters these values.
Note: The values can be overridden by the Address Validation.
Primary Place of Performance Address
Line 3
Third line of the address where the predominant performance of the Grant will be
accomplished.
Grants Edit - Overview
section
Optional
User manually enters these values.
Note: The values can be overridden by the Address Validation.
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.).
Grants Edit - Overview
section
Required
User manually enters these values.
Note: The values can be overridden by the Address Validation.
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.
Grants Edit - Overview
section
Required
User manually enters these values.
Note: The values can be overridden by the Address Validation.
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.
Grants Edit - Overview
section
Required
User manually enters these values.
Note: The values can be overridden by the Address Validation.
Address Validation
Results of the Address validation:
- Validated Address
- Address not Validated
Grants Edit - Overview
section
Optional
This updates based on the results of the Address Validation tool.
Note: Foreign addresses will not pass Address validation.
Primary Place of Performance Country
Name
Name of the country represented by the country code where the predominant performance
of the Grant will be accomplished.
Grants Edit - Overview
section
Required
This field is filled in by the Address Validation.
OR
If this organization is outside the USA, then this field is a dropdown that the user must manually
select from.
The value selected here will update the Country Code field above.
Primary Place of Performance Country
Code
Country code where the predominant performance of the Grant will be accomplished.
Grants Edit - Overview
section
Required
This field is filled in by the Address Validation.
OR
If this organization is outside the USA, then this field will be updated based on the Country Name
selected.
Primary Place of Performance
Congressional District
The congressional district in which the predominant performance of the Grant is located. U.S.
States with a single congressional district should use Congressional District code 00 (indicating
an at-large district). U.S. Territories and the District of Columbia should use Congressional
District code 98 (indicating a non-voting representative).
Grants Edit - Overview
section
Required
This field is filled in by the Address Validation.
If this organization is outside the USA, then this field will be blank.
Award Description
A brief description of the purpose of the award.
Grants Edit - Overview
section
Required
User manually enters
Obligations
Label for the section that contains the Obligations table.
Grants Edit - Obligations
Section
N/A
Project
Project from the list added via the Projects section.
Dopdown includes:
- <Project #> - <Project/Activity Name>
- "No Assigned Project"
Values are listed in alphabetical order by Project number, then Project name.
Users can only select one per row.
Each Project can only be selected once within the table.
Grants Edit - Obligations
Section (table)
Required
User selects from a list of the projects the user created in the projects section
Current Quarter Obligation
Amount obligated for this specific Project within this Quarter. (This could go up or down.)
Grants Edit - Obligations
Section (table)
Required
User manually enters
Cumulative Obligation
Total amount obligated for this Project across all reporting periods.
This includes the Current Quarter Obligation.
Grants Edit - Obligations
Section (table)
Required
System sums the Current Quarter Obligation values for this Project for all reporting periods including
this one.
Current Quarter Expenditure
Total expenditure amount for this Project within this reporting period.
(ie: Sum per Project from the Current Quarter Expenditures table.)
Grants Edit - Obligations
Section (table)
Required
System sums the Cost or Expenditure Amount values for this Project for this reporting period (ie:
from the Expenditures table below).
Cumulative Expenditure
Total expenditure amount for this Project across all reporting periods.
This includes the Current Quarter Expenditure.
(ie: Sum per Project from the Current Quarter Expenditures table AND the Previous
Expenditures (All previous quarters) table.)
Grants Edit - Obligations
Section (table)
Required
System sums the Cost or Expenditure Amount values for this Project for all reporting periods
including this one.
Total Current Quarter Obligation
Total for the Current Quarter Obligation column.
Grants Edit - Obligations
Section (table)
Required
System sums the Current Quarter Obligation column.
Total Cumulative Obligation
Total for the Cumulative Obligation column.
Grants Edit - Obligations
Section (table)
Required
System sums the Cumulative Obligation column.
Total Current Quarter Expenditure
Total for the Current Quarter Expenditure column.
Grants Edit - Obligations
Section (table)
Required
System sums the Current Quarter Expenditure column.
Total Cumulative Expenditure
Total for the Cumulative Expenditure column.
Grants Edit - Obligations
Section (table)
Required
System sums the Cumulative Expenditure column.
Previous Expenditures (All previous
quarters)
Label for the section that contains the Previous Expenditures (All previous quarters) table.
Grants Edit - Previous
Expenditures Section
N/A
Project
Project entered for this record when it was created in a previous reporting period.
Grants Edit - Previous
Expenditures Section
(table)
Required
System generated
Expenditure Date Range
Date range for the expenditure entered for this record when it was created in a previous
reporting period.
Grants Edit - Previous
Expenditures Section
(table)
Required
System generated
Cost or Expenditure Amount
The amount of the cost or expenditure entered for this record when it was created in a
previous reporting period.
Grants Edit - Previous
Expenditures Section
(table)
Required
System generated
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 in a previous reporting period.
Grants Edit - Previous
Expenditures Section
(table)
Required
System generated
Category Description
Cost or Expenditure Category field "Other" description entered for this record when it was
created in a previous reporting period..
Grants Edit - Previous
Expenditures Section
(table)
Conditionally
Required
System generated
Total Cost or Expenditure Amount
Total for the Cost or Expenditure Amount column.
Grants Edit - Previous
Expenditures Section
(table)
Required
Sum of the Cost or Expenditure Amount column.
Current Quarter Expenditures
Label for the section that contains the Current Quarter Expenditures table.
Grants Edit - Current
Quarter Expenditures
Section
N/A
Is awardee complying with terms and
conditions of the grant?
Is awardee complying with terms and conditions of the grant?
- Yes
- No
Grants Edit - Current
Quarter Expenditures
Section
Required
User selects
Non-Compliance Explanation
This only shows if the user selects "No" in the Is awardee complying with terms and
conditions of the grant? field.
Grants Edit - Current
Quarter Expenditures
Section
Conditionally
Required
User must enter if response to compliance question is "No"
Project
Project from the list added via the Projects section.
Dopdown includes:
- <Project #> - <Project/Activity Name>
- "No Assigned Project"
Values are listed in alphabetical order by Project number, then Project name.
Users can only select one per row.
Each Project can be selected more than once within the table.
Grants Edit - Current
Quarter Expenditures
Section (table)
Required
System loads projects from the Obligation table into the dropdown.
Expenditure Date Range
Date range for the expenditure. This will include two date fields.
Grants Edit - Current
Quarter Expenditures
Section (table)
Required
User manually enters
Cost or Expenditure Amount
The amount of the cost or expenditure obligated by the prime recipient due to the public
health emergency with respect to COVID-19.
Grants Edit - Current
Quarter Expenditures
Section (table)
Required
User manually enters
Cost or Expenditure Category
Indication of the group to which the purpose of the obligated cost or expenditure closely
relates to.
Options for selections (select 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
Grants Edit - Current
Quarter Expenditures
Section (table)
Required
User selects from a list of expenditure categories
Category Description
This only allows the user to enter data if the Cost or Expenditure Category field = "Items Not
Listed Above".
Grants Edit - Current
Quarter Expenditures
Section (table)
Conditionally
Required
User manually enters
Total Cost or Expenditure Amount
Total for the Cost or Expenditure Amount column.
Grants Edit - Current
Quarter Expenditures
Section (table)
Required
Sum of the Cost or Expenditure Amount column.

Data Element
Definition
Reporting Form
Required/Optional Comments
Sub-Recipient Organization (Borrower)
Sub-Recipient Organization from the list added via the Sub-Recipient Organizations section.
Dopdown includes:
- "<Sub-Recipient Organization's name> - <DUNS>" OR "<Sub-Recipient Organization's name> -
<Identification Number>"
Values are listed in alphabetical order by Sub-Recipient Organization's name, then DUNS.
Users can only select one.
Loans Edit - Overview
section
Required
System loads all Sub-Recipient records into the dropdown.
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.
Loans Edit - Overview
section
Required
User manually enters
Loan Amount
Total amount of Coronavirus Relief Fund dollars on the loan issued by the prime recipient.
Loans Edit - Overview
section
Required
User manually enters
Loan Date
The date that a mutually binding agreement was reached; the date signed by the prime or
borrower, whichever is later.
Loans Edit - Overview
section
Required
User manually enters
Loan Expiration Date
The date on which the loan is expected to be repaid in full.
Loans Edit - Overview
section
Required
User manually enters
Primary Place of Performance Address
Line 1
First line of the address where the predominant performance of the Loan will be
accomplished.
Loans Edit - Overview
section
Required
User manually enters these values.
Note: The values can be overridden by the Address Validation.
Primary Place of Performance Address
Line 2
Second line of the address where the predominant performance of the Loan will be
accomplished.
Loans Edit - Overview
section
Optional
User manually enters these values.
Note: The values can be overridden by the Address Validation.
Primary Place of Performance Address
Line 3
Third line of the address where the predominant performance of the Loan will be
accomplished.
Loans Edit - Overview
section
Optional
User manually enters these values.
Note: The values can be overridden by the Address Validation.
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.).
Loans Edit - Overview
section
Required
User manually enters these values.
Note: The values can be overridden by the Address Validation.
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.
Loans Edit - Overview
section
Required
User manually enters these values.
Note: The values can be overridden by the Address Validation.
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.
Loans Edit - Overview
section
Required
User manually enters these values.
Note: The values can be overridden by the Address Validation.
Address Validation
Results of the Address validation:
- Validated Address
- Address not Validated
Loans Edit - Overview
section
Optional
This updates based on the results of the Address Validation tool.
Note: Foreign addresses will not pass Address validation.
Primary Place of Performance Country
Name
Name of the country represented by the country code where the predominant performance
of the Loan will be accomplished.
Loans Edit - Overview
section
Required
This field is filled in by the Address Validation.
OR
If this organization is outside the USA, then this field is a dropdown that the user must manually
select from.
The value selected here will update the Country Code field above.
Primary Place of Performance Country
Code
Country code where the predominant performance of the Loan will be accomplished.
Loans Edit - Overview
section
Required
This field is filled in by the Address Validation.
OR
If this organization is outside the USA, then this field will be updated based on the Country Name
selected.
Primary Place of Performance
Congressional District
The congressional district in which the predominant performance of the Loan is located. U.S.
States with a single congressional district should use Congressional District code 00 (indicating
an at-large district). U.S. Territories and the District of Columbia should use Congressional
District code 98 (indicating a non-voting representative).
Loans Edit - Overview
section
Required
This field is filled in by the Address Validation.
If this organization is outside the USA, then this field will be blank.
Loan Description
A brief description of the purpose of the loan.
Loans Edit - Overview
section
Required
User manually enters
Obligations
Label for the section that contains the Obligations table.
Loans Edit - Obligations
Section
N/A
Project
Project from the list added via the Projects section.
Dopdown includes:
- <Project #> - <Project/Activity Name>
- "No Assigned Project"
Values are listed in alphabetical order by Project number, then Project name.
Users can only select one per row.
Each Project can only be selected once within the table.
Loans Edit - Obligations
Section (table)
Required
System loads all records from the Projects section into the dropdown.
Current Quarter Obligation
Amount obligated for this specific Project within this Quarter. (This could go up or down.)
Loans Edit - Obligations
Section (table)
Required
User manually enters
Cumulative Obligation
Total amount obligated for this Project across all reporting periods.
This includes the Current Quarter Obligation.
Loans Edit - Obligations
Section (table)
Required
System sums the Current Quarter Obligation values for this Project for all reporting periods including
this one.
Current Quarter Payment
Total payment amount for this Project within this reporting period.
(ie: Sum per Project from the Current Quarter Payments table.)
Loans Edit - Obligations
Section (table)
Required
System sums the Payment Amount values for this Project for this reporting period
(ie: Sum per Project from the Current Quarter Payments table.)
Cumulative Payments
Total payment amount for this Project across all reporting periods.
This includes the Current Quarter Payments.
(ie: Sum per Project from the Current Quarter Payments table AND the Previous Payments (All
previous quarters) table.)
Loans Edit - Obligations
Section (table)
Required
System sums the Payment Amount values for this Project for all reporting periods including this one.
(ie: Sum per Project from the Current Quarter Payments table AND the Previous Payments (All
previous quarters) table.)
Total Current Quarter Obligation
Total for the Current Quarter Obligation column.
Loans Edit - Obligations
Section (table)
Required
System sums the Current Quarter Obligation column.
Total Cumulative Obligation
Total for the Cumulative Obligation column.
Loans Edit - Obligations
Section (table)
Required
System sums the Cumulative Obligation column.
Total Current Quarter Payments
Total for the Current Quarter Payments column.
Loans Edit - Obligations
Section (table)
Required
System sums the Current Quarter Payments column.
Total Cumulative Payments
Total for the Cumulative Payments column.
Loans Edit - Obligations
Section (table)
Required
System sums the Cumulative Payments column.
Previous Payments (All previous
quarters)
Label for the section that contains the Previous Payments (All previous quarters) table.
Loans Edit - Previous
Payments Section
N/A
Project
Project entered for this record when it was created in a previous reporting period.
Loans Edit - Previous
Payments Section (table)
Required
System generated
Payment Date
Payment Date entered for this record when it was created in a previous reporting period.
Loans Edit - Previous
Payments Section (table)
Required
System generated
Payment Amount
The amount of the Payment entered for this record when it was created in a previous
reporting period.
Loans Edit - Previous
Payments Section (table)
Required
Validation: Cannot be higher than the Obligated Amount for this Project.
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.
Loans Edit - Previous
Payments Section (table)
Required
System generated
Category Description
Loan Category field "Other" description entered for this record when it was created in a
previous reporting period.
Loans Edit - Previous
Payments Section (table)
Conditionally
Required
System generated
Will these payments be repurposed for
Future Use?
Will these payments be repurposed for Future Use? value entered for this record when it was
created in a previous reporting period.
Loans Edit - Previous
Payments Section (table)
Required
System generated
Total Payment Amount
Total for the Payment Amount column.
Loans Edit - Previous
Payments Section (table)
Required
Sum of the Payment Amount column.
Current Quarter Payments
Label for the section that contains the Current Quarter Payments table.
Loans Edit - Current
Quarter Payments
Section
N/A
Project
Project from the list added via the Projects section.
Dopdown includes:
- <Project #> - <Project/Activity Name>
- "No Assigned Project"
Values are listed in alphabetical order by Project number, then Project name.
Users can only select one per row.
Each Project can be selected more than once within the table.
Loans Edit - Current
Quarter Payments
Section (table)
Required
System loads projects from the Obligation table into the dropdown.
Payment Date
The date the prime recipient received payment from the borrower for the loan they were
issued due to the public health emergency with respect to COVID-19.
Loans Edit - Current
Quarter Payments
Section (table)
Required
User manually enters
Payment Amount
The amount of funds the prime recipient received in payment from the borrower for the loan
they were issued due to the public health emergency with respect to COVID-19.
Loans Edit - Current
Quarter Payments
Section (table)
Required
User manually enters
Loan Category
Indication of the group to which the purpose of the payment closely relates to.
Options for selections (select 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
Loans Edit - Current
Quarter Payments
Section (table)
Required
User selects from a list of loan categories
Category Description
This only allows the user to enter data if the Cost or Expenditure Category field = "Items Not
Listed Above".
Loans Edit - Current
Quarter Payments
Section (table)
Conditionally
Required
User manually enters
Will these payments be repurposed for
Future Use?
Options for selection (select one):
- Yes
- No, Returning to Treasury
Loans Edit - Current
Quarter Payments
Section (table)
Required
User selects "Yes" or "No"
Total Payment Amount
Total for the Payment Amount column.
Loans Edit - Current
Quarter Payments
Section (table)
Required
Sum of the Payment Amount column.

Data Element
Definition
Reporting Form
Required/Optional Comments
Sub-Recipient Organization
(Transferee/Government Unit)
Sub-Recipient Organization from the list added via the Sub-Recipient Organizations section.
Dopdown includes:
- "<Sub-Recipient Organization's name> - <DUNS>" OR "<Sub-Recipient Organization's name> -
<Identification Number>"
Values are listed in alphabetical order by Sub-Recipient Organization's name, then DUNS.
Users can only select one.
Transfers Edit - Overview
section
Required
System loads all Sub-Recipient records into the dropdown.
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.
Transfers Edit - Overview
section
Required
User manually enters
Transfer Amount
Total amount of Coronavirus Relief Fund dollars transferred by the prime recipient to another
government.
Transfers Edit - Overview
section
Required
User manually enters
Transfer Date
The date that the prime recipient transfers funds to the transferee.
Transfers Edit - Overview
section
Required
User manually enters
Transfer Type
The type of transfer issued by the prime recipient.
Dropdown values:
- Lump Sum Payment(s)
- Reimbursable
Transfers Edit - Overview
section
Required
User selects from list
Purpose Description
The brief description of the purpose of the transfer.
Transfers Edit - Overview
section
Required
User manually enters
Obligations
Label for the section that contains the Obligations table.
Transfers Edit -
Obligations Section
N/A
Project
Project from the list added via the Projects section.
Dopdown includes:
- <Project #> - <Project/Activity Name>
- "No Assigned Project"
Values are listed in alphabetical order by Project number, then Project name.
Users can only select one per row.
Each Project can only be selected once within the table.
Transfers Edit -
Obligations Section
(table)
Required
System loads all records from the Projects section into the dropdown.
Current Quarter Obligation
Amount obligated for this specific Project within this Quarter. (This could go up or down.)
Transfers Edit -
Obligations Section
(table)
Required
User manually enters
Cumulative Obligation
Total amount obligated for this Project across all reporting periods.
This includes the Current Quarter Obligation.
Transfers Edit -
Obligations Section
(table)
Required
System sums the Current Quarter Obligation values for this Project for all reporting periods including
this one.
Current Quarter Expenditure
Total expenditure amount for this Project within this reporting period.
(ie: Sum per Project from the Current Quarter Expenditures table.)
Transfers Edit -
Obligations Section
(table)
Required
System sums the Cost or Expenditure Amount values for this Project for this reporting period (ie:
from the Expenditures table below).
Cumulative Expenditure
Total expenditure amount for this Project across all reporting periods.
This includes the Current Quarter Expenditure.
(ie: Sum per Project from the Current Quarter Expenditures table AND the Previous
Expenditures (All previous quarters) table.)
Transfers Edit -
Obligations Section
(table)
Required
System sums the Cost or Expenditure Amount values for this Project for all reporting periods
including this one.
Total Current Quarter Obligation
Total for the Current Quarter Obligation column.
Transfers Edit -
Obligations Section
(table)
Required
System sums the Current Quarter Obligation column.
Total Cumulative Obligation
Total for the Cumulative Obligation column.
Transfers Edit -
Obligations Section
(table)
Required
System sums the Cumulative Obligation column.
Total Current Quarter Expenditure
Total for the Current Quarter Expenditure column.
Transfers Edit -
Obligations Section
(table)
Required
System sums the Current Quarter Expenditure column.
Total Cumulative Expenditure
Total for the Cumulative Expenditure column.
Transfers Edit -
Obligations Section
(table)
Required
System sums the Cumulative Expenditure column.
Previous Expenditures (All previous
quarters)
Label for the section that contains the Previous Expenditures (All previous quarters) table.
Transfers Edit - Previous
Expenditures Section
N/A
Project
Project entered for this record when it was created in a previous reporting period.
Transfers Edit - Previous
Expenditures Section
(table)
Required
System generated
Expenditure Date Range
Date range for the expenditure entered for this record when it was created in a previous
reporting period.
Transfers Edit - Previous
Expenditures Section
(table)
Required
System generated
Cost or Expenditure Amount
The amount of the cost or expenditure entered for this record when it was created in a
previous reporting period.
Transfers Edit - Previous
Expenditures Section
(table)
Required
Validation: Cannot be higher than the Obligated Amount for this Project.
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 in a previous reporting period.
Transfers Edit - Previous
Expenditures Section
(table)
Required
System generated
Category Description
Cost or Expenditure Category field "Other" description entered for this record when it was
created in a previous reporting period..
Transfers Edit - Previous
Expenditures Section
(table)
Conditionally
Required
System generated
Total Cost or Expenditure Amount
Total for the Cost or Expenditure Amount column.
Transfers Edit - Previous
Expenditures Section
(table)
Required
Sum of the Cost or Expenditure Amount column.
Current Quarter Expenditures
Label for the section that contains the Current Quarter Expenditures table.
Transfers Edit - Current
Quarter Expenditures
Section
N/A
Project
Project from the list added via the Projects section.
Dopdown includes:
- <Project #> - <Project/Activity Name>
- "No Assigned Project"
Values are listed in alphabetical order by Project number, then Project name.
Users can only select one per row.
Each Project can be selected more than once within the table.
Transfers Edit - Current
Quarter Expenditures
Section (table)
Required
User selects projects from a list of projects the user created in the project section
Expenditure Date Range
Date range for the expenditure. This will include two date fields.
Transfers Edit - Current
Quarter Expenditures
Section (table)
Required
User manually enters
Cost or Expenditure Amount
The amount of the cost or expenditure obligated by the prime recipient due to the public
health emergency with respect to COVID-19.
Transfers Edit - Current
Quarter Expenditures
Section (table)
Required
User manually enters
Cost or Expenditure Category
Indication of the group to which the purpose of the obligated cost or expenditure closely
relates to.
Options for selections (select 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
Transfers Edit - Current
Quarter Expenditures
Section (table)
Required
User selects from a list of expenditure categories
Category Description
This only allows the user to enter data if the Cost or Expenditure Category field = "Items Not
Listed Above".
Transfers Edit - Current
Quarter Expenditures
Section (table)
Conditionally
Required
User manually enters
Total Cost or Expenditure Amount
Total for the Cost or Expenditure Amount column.
Transfers Edit - Current
Quarter Expenditures
Section (table)
Required
Sum of the Cost or Expenditure Amount column.

Data Element
Definition
Reporting Form
Required/Optional Comments
Sub-Recipient Organization (Payee)
Sub-Recipient Organization from the list added via the Sub-Recipient Organizations section.
Dopdown includes:
- "<Sub-Recipient Organization's name> - <DUNS>" OR "<Sub-Recipient Organization's name> -
<Identification Number>"
Values are listed in alphabetical order by Sub-Recipient Organization's name, then DUNS.
Users can only select one.
Direct Payments Edit -
Overview section
Required
System loads all Sub-Recipient records into the dropdown.
Obligation Amount
Total amount of Coronavirus Relief Fund dollars in this Direct Payment.
Direct Payments Edit -
Overview section
Required
User manually enters
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).
Direct Payments Edit -
Overview section
Required
User manually enters
Obligations
Label for the section that contains the Obligations table.
Direct Payments Edit -
Obligations Section
N/A
Project
Project from the list added via the Projects section.
Dopdown includes:
- <Project #> - <Project/Activity Name>
- "No Assigned Project"
Values are listed in alphabetical order by Project number, then Project name.
Users can only select one per row.
Each Project can only be selected once within the table.
Direct Payments Edit -
Obligations Section
(table)
Required
System loads all records from the Projects section into the dropdown.
Current Quarter Obligation
Amount obligated for this specific Project within this Quarter. (This could go up or down.)
Direct Payments Edit -
Obligations Section
(table)
Required
User manually enters
Cumulative Obligation
Total amount obligated for this Project across all reporting periods.
This includes the Current Quarter Obligation.
Direct Payments Edit -
Obligations Section
(table)
Required
System sums the Current Quarter Obligation values for this Project for all reporting periods including
this one.
Current Quarter Expenditure
Total expenditure amount for this Project within this reporting period.
(ie: Sum per Project from the Current Quarter Expenditures table.)
Direct Payments Edit -
Obligations Section
(table)
Required
System sums the Cost or Expenditure Amount values for this Project for this reporting period (ie:
from the Expenditures table below).
Cumulative Expenditure
Total expenditure amount for this Project across all reporting periods.
This includes the Current Quarter Expenditure.
(ie: Sum per Project from the Current Quarter Expenditures table AND the Previous
Expenditures (All previous quarters) table.)
Direct Payments Edit -
Obligations Section
(table)
Required
System sums the Cost or Expenditure Amount values for this Project for all reporting periods
including this one.
Total Current Quarter Obligation
Total for the Current Quarter Obligation column.
Direct Payments Edit -
Obligations Section
(table)
Required
System sums the Current Quarter Obligation column.
Total Cumulative Obligation
Total for the Cumulative Obligation column.
Direct Payments Edit -
Obligations Section
(table)
Required
System sums the Cumulative Obligation column.
Total Current Quarter Expenditure
Total for the Current Quarter Expenditure column.
Direct Payments Edit -
Obligations Section
(table)
Required
System sums the Current Quarter Expenditure column.
Total Cumulative Expenditure
Total for the Cumulative Expenditure column.
Direct Payments Edit -
Obligations Section
(table)
Required
System sums the Cumulative Expenditure column.
Previous Expenditures (All previous
quarters)
Label for the section that contains the Previous Expenditures (All previous quarters) table.
Direct Payments Edit -
Previous Expenditures
Section
N/A
Project
Project entered for this record when it was created in a previous reporting period.
Direct Payments Edit -
Previous Expenditures
Section (table)
Required
System generated
Expenditure Date Range
Date range for the expenditure entered for this record when it was created in a previous
reporting period.
Direct Payments Edit -
Previous Expenditures
Section (table)
Required
System generated
Cost or Expenditure Amount
The amount of the cost or expenditure entered for this record when it was created in a
previous reporting period.
Direct Payments Edit -
Previous Expenditures
Section (table)
Required
Validation: Cannot be higher than the Obligated Amount for this Project.
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 in a previous reporting period.
Direct Payments Edit -
Previous Expenditures
Section (table)
Required
System generated
Category Description
Cost or Expenditure Category field "Other" description entered for this record when it was
created in a previous reporting period..
Direct Payments Edit -
Previous Expenditures
Section (table)
Conditionally
Required
System generated
Total Cost or Expenditure Amount
Total for the Cost or Expenditure Amount column.
Direct Payments Edit -
Previous Expenditures
Section (table)
Required
Sum of the Cost or Expenditure Amount column.
Current Quarter Expenditures
Label for the section that contains the Current Quarter Expenditures table.
Direct Payments Edit -
Current Quarter
Expenditures Section
N/A
Project
Project from the list added via the Projects section.
Dopdown includes:
- <Project #> - <Project/Activity Name>
- "No Assigned Project"
Values are listed in alphabetical order by Project number, then Project name.
Users can only select one per row.
Each Project can be selected more than once within the table.
Direct Payments Edit -
Current Quarter
Expenditures Section
(table)
Required
System loads projects from the Obligation table into the dropdown.
Expenditure Date Range
Date range for the expenditure. This will include two date fields.
Direct Payments Edit -
Current Quarter
Expenditures Section
(table)
Required
User manually enters
Cost or Expenditure Amount
The amount of the cost or expenditure obligated by the prime recipient due to the public
health emergency with respect to COVID-19.
Direct Payments Edit -
Current Quarter
Expenditures Section
(table)
Required
User manually enters
Cost or Expenditure Category
Indication of the group to which the purpose of the obligated cost or expenditure closely
relates to.
Options for selections (select 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
Direct Payments Edit -
Current Quarter
Expenditures Section
(table)
Required
User selects from list of expenditure categories
Category Description
This only allows the user to enter data if the Cost or Expenditure Category field = "Items Not
Listed Above".
Direct Payments Edit -
Current Quarter
Expenditures Section
(table)
Conditionally
Required
User manually enters
Total Cost or Expenditure Amount
Total for the Cost or Expenditure Amount column.
Direct Payments Edit -
Current Quarter
Expenditures Section
(table)
Required
Sum of the Cost or Expenditure Amount column.

Data Element
Definition
Reporting Form
Required/Optional
Comments
Aggregate of Contracts Awarded for
<$50,000: Updates this Quarter?
Yes/No to determine whether or not the amount field for this funding type should be updated.
<$50k Aggregate
Required
User selects
Aggregate of Contracts Awarded for
<$50,000: Current Quarter Obligation
The total amount of funds awarded to contracts worth less than $50,000 in this reporting
quarter.
<$50k Aggregate
Conditionally
Required
User manually enters
Aggregate of Contracts Awarded for
<$50,000: Cumulative Obligation
Total amount  of funds awarded to contracts worth less than $50,000 all reporting periods.
This includes the Current Quarter Obligation.
<$50k Aggregate
Required
System sums the Current Quarter Obligation values for all reporting periods including this one.
Aggregate of Contracts Awarded for
<$50,000: Current Quarter
Expenditure/Payments
The total expenditure or payment within this reporting quarter for this funding type.
<$50k Aggregate
Conditionally
Required
User manually enters
Aggregate of Contracts Awarded for
<$50,000: Cumulative
Expenditure/Payments
The total expenditure or payment within all reporting periods for this funding type.
This includes the Current Quarter Expenditure/Payments.
<$50k Aggregate
Required
System sums the Expenditure/Payments Amount values for all reporting periods including this one.
Aggregate of Grants Awarded for
<$50,000: Updates this Quarter?
Yes/No to determine whether or not the amount field for this funding type should be updated.
<$50k Aggregate
Required
User selects
Aggregate of Grants Awarded for
<$50,000: Current Quarter Obligation
The total amount of funds awarded to grants worth less than $50,000 in this reporting quarter.
<$50k Aggregate
Conditionally
Required
System generated
Cumulative Aggregate of Grants Awarded
for <$50,000: Cumulative Obligation
Total amount  of funds awarded to grants worth less than $50,000 all reporting periods.
This includes the Current Quarter Obligation.
<$50k Aggregate
Required
System sums the Current Quarter Obligation values for all reporting periods including this one.
Cumulative Aggregate of Grants Awarded
for <$50,000: Current Quarter
Expenditure/Payments
The total expenditure or payment within this reporting quarter for this funding type.
<$50k Aggregate
Conditionally
Required
User manually enters
Cumulative Aggregate of Grants Awarded
for <$50,000: Cumulative
Expenditure/Payments
The total expenditure or payment within all reporting periods for this funding type.
This includes the Current Quarter Expenditure/Payments.
<$50k Aggregate
Required
System sums the Expenditure/Payments Amount values for all reporting periods including this one.
Aggregate of Loans Issued for <$50,000:
Updates this Quarter?
Yes/No to determine whether or not the amount field for this funding type should be updated.
<$50k Aggregate
Required
User selects
Aggregate of Loans Issued for <$50,000:
Current Quarter Obligation
The total amount of loans issued less than $50,000 in this reporting quarter.
<$50k Aggregate
Conditionally
Required
User manually enters
Cumulative Aggregate of Loans Issued for
<$50,000: Cumulative Obligation
The total amount of loans issued less than $50,000 all reporting periods.
This includes the Current Quarter Obligation.
<$50k Aggregate
Required
System sums the Current Quarter Obligation values for all reporting periods including this one.
Cumulative Aggregate of Loans Issued for
<$50,000: Current Quarter
Expenditure/Payments
The total expenditure or payment within this reporting quarter for this funding type.
<$50k Aggregate
Conditionally
Required
User manually enters
Cumulative Aggregate of Loans Issued for
<$50,000: Cumulative
Expenditure/Payments
The total expenditure or payment within all reporting periods for this funding type.
This includes the Current Quarter Expenditure/Payments.
<$50k Aggregate
Required
System sums the Expenditure/Payments Amount values for all reporting periods including this one.
Aggregate of Transfers <$50,000:
Updates this Quarter?
Yes/No to determine whether or not the amount field for this funding type should be updated.
<$50k Aggregate
Required
User selects
Aggregate of Transfers <$50,000: Current
Quarter Obligation
The total amount of transfers less than $50,000 in this reporting quarter.
<$50k Aggregate
Conditionally
Required
User manually enters
Cumulative Aggregate of Transfers
<$50,000: Cumulative Obligation
Total amount  of transfers less than $50,000 all reporting periods.
This includes the Current Quarter Obligation.
<$50k Aggregate
Required
System sums the Current Quarter Obligation values for all reporting periods including this one.
Cumulative Aggregate of Transfers
<$50,000: Current Quarter
Expenditure/Payments
The total expenditure or payment within this reporting quarter for this funding type.
<$50k Aggregate
Conditionally
Required
User manually enters
Cumulative Aggregate of Transfers
<$50,000: Cumulative
Expenditure/Payments
The total expenditure or payment within all reporting periods for this funding type.
This includes the Current Quarter Expenditure/Payments.
<$50k Aggregate
Required
System sums the Expenditure/Payments Amount values for all reporting periods including this one.
Aggregate of Direct Payments <$50,000:
Updates this Quarter?
Yes/No to determine whether or not the amount field for this funding type should be updated.
<$50k Aggregate
Required
User selects
Aggregate of Direct Payments <$50,000:
Current Quarter Obligation
The total amount of direct payments worth less than $50,000 in this reporting quarter.
<$50k Aggregate
Conditionally
Required
User manually enters
Cumulative Aggregate of Direct Payments
<$50,000: Cumulative Obligation
Total amount  of direct payments worth less than $50,000 all reporting periods.
This includes the Current Quarter Obligation.
<$50k Aggregate
Required
System sums the Current Quarter Obligation values for all reporting periods including this one.
Cumulative Aggregate of Direct Payments
<$50,000: Current Quarter
Expenditure/Payments
The total expenditure or payment within this reporting quarter for this funding type.
<$50k Aggregate
Conditionally
Required
User manually enters
Cumulative Aggregate of Direct Payments
<$50,000: Cumulative
Expenditure/Payments
The total expenditure or payment within all reporting periods for this funding type.
This includes the Current Quarter Expenditure/Payments.
<$50k Aggregate
Required
System sums the Expenditure/Payments Amount values for all reporting periods including this one.
Total Current Quarter Obligation
Total for the Current Quarter Obligation column.
<$50k Aggregate
Required
System sums the Current Quarter Obligation column.
Total Cumulative Obligation
Total for the Cumulative Obligation column.
<$50k Aggregate
Required
System sums the Cumulative Obligation column.
Total Current Quarter Expenditure
Total Current Quarter Expenditure/Payments column.
<$50k Aggregate
Required
System sums the Current Quarter Expenditure/Payments column.
Total Cumulative Expenditure/Payments
Total Cumulative Expenditure/Payments column.
<$50k Aggregate
Required
System sums the Cumulative Expenditure/Payments column.

Data Element
Definition
Reporting Form
Required/Optional Comments
Aggregate of Direct Payments to
Individuals: Updates this Quarter?
Yes/No to determine whether or not the amount field for this funding type should be
updated.
Individuals
Required
User selects
Aggregate of Direct Payments to
Individuals: Current Quarter Obligation
The total amount paid to individuals in this reporting quarter.
Individuals
Conditionally
Required
User manually enters
Aggregate of Direct Payments to
Individuals: Cumulative Obligation
The total amount paid to individuals for all reporting periods.
This includes the Current Quarter Obligation.
Individuals
Required
System sums the Current Quarter Obligation values for all reporting periods including this one.
Aggregate of Direct Payments to
Individuals: Current Quarter Expenditure The total expenditure or payment within this reporting quarter for this funding type.
<$50k Aggregate
Conditionally
Required
User manually enters
Aggregate of Direct Payments to
Individuals: Cumulative Expenditure
The total expenditure or payment within all reporting periods for this funding type.
This includes the Current Quarter Expenditures/Payments.
<$50k Aggregate
Required
System sums the Expenditure Amount values for all reporting periods including this one.

File and source

File

OIG-CA-20-030-coronavirus-relief-fund-recipient-reporting-portal-data-dictionary.pdf

Size

320,332 bytes

SHA-256

eb5987a9cb5f612526248f36601c088ca5235c91673a4657ee76296f8af7ae00

Our copy

OIG-CA-20-030-coronavirus-relief-fund-recipient-reporting-portal-data-dictionary.pdf

Original

oig.treasury.gov