FFATA Sub Reporting Data Model 8-14-2020.xlsx

FFATA Subaward and Executive Compensation Reporting Requirements

FFATA Sub Reporting Data Model 8-14-2020.xlsx

OMB: 3090-0292

Document [xlsx]
Download: xlsx | pdf
# demott_d: As of 3:15 7/19- only edit was deletion of SAI element. GRANTS ELEMENT NAME GRANTS DEFINITION Sub-field (if applicable) Required (Y/N) Field Type Awardee can flag for correction if derived from FAADS+ (Y/N)

VIEWABLE PRIME AWARD DATA ELEMENTS An agency awarding official must include the award term that requires recipient reporting of subawards in any new award with an obligation date on or after October 1, 2010; $25,000 threshold.
1 Federal Award Identifier Number (FAIN) The award number or other identifying number assigned by the Federal awarding agency, such as the federal grant number.
Y Pre-populated N
3 Federal Agency Name The name of the Federal awarding agency.
Y Pre-populated N
4 Awardee - DUNS Number The prime awardee organization’s 9-digit Data Universal Numbering System (DUNS) number associated with the award.
Y Pre-populated Y
5 Awardee - DUNS Number +4 The +4 extension to a DUNS number created by registrants in CCR when there is a need for more than one bank/Electronic Funds Transfer (EFT) account for a location.
N Pre-populated if available Y
6 Awardee - Name The name of the awardee organization. This will be the same name and address that appears in awardee’s Central Contractor Registration (CCR) profile, as applicable.
Y Pre-populated
7 Awardee - DBA Name The "doing-business-as" name of the organization. This will be the same name and address that appears in awardee’s Central Contractor Registration (CCR) profile, as applicable.
N Pre-populated if available
8 Awardee - Address Address where the awardee organization is located. This will be the same name and address that appears in awardee’s Central Contractor Registration (CCR) profile, as applicable.






Street 1 Y Pre-populated



Street 2 Y Pre-populated



Street 3 Y Pre-populated



City Y Pre-populated



State Y Pre-populated



Country Y Pre-populated



Zip +4 Y Pre-populated



Congressional District Y Pre-populated
9 Awardee - Parent DUNS Number The prime awardee parent organization’s 9-digit Data Universal Numbering System (DUNS) number. This will be the same parent DUNS that appears in awardee’s Central Contractor Registration (CCR) profile, as applicable.
Y Pre-populated if available
10 Principal Place Of Performance The primary site where the work will be performed.






City (or County) Y Pre-populated if available Y



State Y Pre-populated if available Y



Country Y Pre-populated if available Y



Zip +4 Y Pre-populated if available Y



Congressional District Y Pre-populated
11 CFDA Program Number (and Program Title) The number and program title associated with the published description of Federal assistance program in the Catalog of Federal Domestic Assistance (CFDA).
Y Pre-populated N
12 Project Description Award title and description of the purpose of each funding action, if any. The description should capture the overall purpose of the award and, if there are multiple funding actions, sufficient description to define the need for each funding action. Example of project description: "Investment in public transportation: replace four 10 year old electric commuter train cars. In addition, funds will be used to construct a multi-modal Park and Ride facility featuring: commuter parking, transit hub, bicycle accommodations, and a potential future platform." For a second funding action to this grant, an example of an additional description: "Replace 2 additional electric commuter train cars that are 8+ years old."
Y Pre-populated if available Y
13 Total Federal Funding Amount The net dollar amount of the Federal award including modifications.
Y Pre-populated N
14 Obligation/Action Date Date the award agreement was signed.
Y Pre-populated N
15 Starting Date - Ending Date The dates the project begins and ends.
N Predefined values; Month and Year Y
16 Awardee Names and Compensation of Highly Compensated Officers
Names and total compensation of Top 5 highly compensated officials of the awardee organization. This will be the same compensation information that appears in awardee’s Central Contractor Registration (CCR) profile, as applicable. If not available from CCR the following questions are used to determine applicability of the element.
Y Pre-populated if available or manual entry


Q1. In your business or organization’s previous fiscal year, did your business or organization (including parent organization, all branches, and all affiliates worldwide) receive (1) 80 percent or more of your annual gross revenues in U.S. federal contracts, subcontracts, loans, grants, subgrants, and/or cooperative agreements; and (2) $25,000,000 or more in annual gross revenues from U.S. federal contracts, subcontracts, loans, grants, subgrants, and/or cooperative agreements?
Y Radio button: Yes or No
If Yes, must answer Q2
If No, user not required to provide data



Q2. Does the public have access to information about the compensation of the senior executives in your business or organization (including parent organization, all branches, and all affiliates worldwide) through periodic reports filed under section 13(a) or 15(d) of the Securities Exchange Act of 1934 (15 U.S.C. 78m(a), 78o(d)) or section 6104 of the Internal Revenue Code of 1986?
Y Radio button: Yes or No
If Yes, provide link to SEC: http://www.sec.gov/
If No, user must enter Top 5 Data




Name
If manual - free text



Amount
If manual - free text



Name
If manual - free text



Amount
If manual - free text



Name
If manual - free text



Amount
If manual - free text



Name
If manual - free text



Amount
If manual - free text



Name
If manual - free text



Amount
If manual - free text
17 Date of Report Submission

Y Auto-complete at time of submission

SUBAWARD DATA ELEMENTS ENTERED BY PRIME
1 Subawardee - DUNS Number The subawardee organization’s 9-digit Data Universal Numbering System (DUNS) number.
Y Manual entry
2 Subawardee - DUNS Number +4 The +4 extension to a DUNS number created by registrants in CCR when there is a need for more than one bank/Electronic Funds Transfer (EFT) account for a location.
N Manual entry
3 Subawardee - Name The subawardee organization’s 9-digit Data Universal Numbering System (DUNS) number. This will be the same information that appears in subawardee’s Central Contractor Registration (CCR) profile, as applicable.
Y Pre-populated if available
4 Subawardee - DBA Name The "doing-business-as" name of the subawardee organization. This will be the same name and address that appears in subawardee’s Central Contractor Registration (CCR) profile, as applicable.
N Pre-populated if available
5 Subawardee - Address Address where the subawardee organization is located. This will be the same name and address that appears in subawardee’s Central Contractor Registration (CCR) profile, as applicable, otherwise manually entered.






Street 1 Y Pre-populated if available; or if manual, free entry



Street 2 Y Pre-populated if available; or if manual, free entry



Street 3 Y Pre-populated if available; or if manual, free entry



City Y Pre-populated



State Y Pre-populated



Country Y Pre-populated



Zip +4 Y Pre-populated if available; or if manual, free entry



Congressional District Y Pre-populated
6 Subawardee Parent DUNS Number The subawardee parent organization’s 9-digit Data Universal Numbering System (DUNS) number. This will be the same parent DUNS that appears in subawardee’s Central Contractor Registration (CCR) profile, as applicable.
Y Pre-populated if available
7 Amount of Subaward The net dollar amount of Federal funds awarded to the subawardee including modifications. The subaward carries forward the purpose of the Federal prime award.
Y Free text entry
8 Subaward Obligation/Action Date Date the subaward agreement was signed.
Y calendar widget
9 CFDA Program Number (and Program Title) The number and program title associated with the published description of Federal assistance program in the Catalog of Federal Domestic Assistance (CFDA).
Y Pre-populated N
10 Federal Agency Name The name of the Federal awarding agency.
Y Pre-populated N
11 Subawardee Principal Place of Performance The primary site where the work will be performed.





Enter the city unless a county, as a whole, is the subawardee. City (or County) Y Manual entry



State Y Manual entry



Country Y Manual entry



Zip +4 Y Manual entry



Congressional District Y Pre-populated
12 Subaward Number Subaward number or other identifying number assigned by the prime awardee organization to facilitate the tracking of its subawards.
Y Free text entry
13 Subawardee Names and Compensation of Highly Compensated Officers
Names and total compensation of Top 5 highly compensated officials of the subawardee organization. This will be the same compensation information that appears in subawardee’s Central Contractor Registration (CCR) profile, as applicable. If not available from CCR the following questions are used to determine applicability of the element.
Y Pre-populated if available or manual entry


Q1. In your business or organization’s previous fiscal year, did your business or organization (including parent organization, all branches, and all affiliates worldwide) receive (1) 80 percent or more of your annual gross revenues in U.S. federal contracts, subcontracts, loans, grants, subgrants, and/or cooperative agreements; and (2) $25,000,000 or more in annual gross revenues from U.S. federal contracts, subcontracts, loans, grants, subgrants, and/or cooperative agreements?
Y Radio button: Yes or No
If Yes, must answer Q2
If No, user not required to provide data



Q2. Does the public have access to information about the compensation of the senior executives in your business or organization (including parent organization, all branches, and all affiliates worldwide) through periodic reports filed under section 13(a) or 15(d) of the Securities Exchange Act of 1934 (15 U.S.C. 78m(a), 78o(d)) or section 6104 of the Internal Revenue Code of 1986?
Y Radio button: Yes or No
If Yes, provide link to SEC: http://www.sec.gov/




Name
If manual - free text



Amount
If manual - free text



Name
If manual - free text



Amount
If manual - free text



Name
If manual - free text



Amount
If manual - free text



Name
If manual - free text



Amount
If manual - free text



Name
If manual - free text



Amount
If manual - free text
14 Subaward Project Description Award title and description of the purpose of each funding action, if any. The description should capture the overall purpose of the subaward and, if there are multiple funding actions, sufficient description to define the need for each funding action. Example of project description: "Investment in public transportation: replace four 10 year old electric commuter train cars. In addition, funds will be used to construct a multi-modal Park and Ride facility featuring: commuter parking, transit hub, bicycle accommodations, and a potential future platform." For a second funding action to this grant, an example of an additional description: "Replace 2 additional electric commuter train cars that are 8+ years old."
Y Free text entry

File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy