{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["FFATA"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"FFATA","index":0,"n_rows":83,"n_cols":7,"rows_kept":83,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,3,1,6],[43,1,43,6]],"flags":["formulas_cached_only"]}
["#","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)"]
[null,"VIEWABLE PRIME AWARD DATA ELEMENTS",null,"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.",null,"Y","Pre-populated","N"]
[3,"Federal Agency Name","The name of the Federal awarding agency.",null,"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.",null,"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.",null,"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.",null,"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.",null,"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."]
[null,null,null,"Street 1","Y","Pre-populated"]
[null,null,null,"Street 2","Y","Pre-populated"]
[null,null,null,"Street 3","Y","Pre-populated"]
[null,null,null,"City","Y","Pre-populated"]
[null,null,null,"State","Y","Pre-populated"]
[null,null,null,"Country","Y","Pre-populated"]
[null,null,null,"Zip +4","Y","Pre-populated"]
[null,null,null,"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.",null,"Y","Pre-populated if available"]
[10,"Principal Place Of Performance","The primary site where the work will be performed."]
[null,null,null,"City (or County)","Y","Pre-populated if available","Y"]
[null,null,null,"State","Y","Pre-populated if available","Y"]
[null,null,null,"Country","Y","Pre-populated if available","Y"]
[null,null,null,"Zip +4","Y","Pre-populated if available","Y"]
[null,null,null,"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).",null,"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.\"",null,"Y","Pre-populated if available","Y"]
[13,"Total Federal Funding Amount","The net dollar amount of the Federal award including modifications.",null,"Y","Pre-populated","N"]
[14,"Obligation/Action Date","Date the award agreement was signed.",null,"Y","Pre-populated","N"]
[15,"Starting Date - Ending Date","The dates the project begins and ends.",null,"N","Predefined values; Month and Year","Y"]
[16,"Awardee Names and Compensation of Highly Compensated Officers\n","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.",null,"Y","Pre-populated if available or manual entry"]
[null,null,"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?",null,"Y","Radio button: Yes or No\nIf Yes, must answer Q2\nIf No, user not required to provide data"]
[null,null,"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?",null,"Y","Radio button: Yes or No\nIf Yes, provide link to SEC: http://www.sec.gov/\nIf No, user must enter Top 5 Data"]
[null,null,null,"Name",null,"If manual - free text"]
[null,null,null,"Amount",null,"If manual - free text"]
[null,null,null,"Name",null,"If manual - free text"]
[null,null,null,"Amount",null,"If manual - free text"]
[null,null,null,"Name",null,"If manual - free text"]
[null,null,null,"Amount",null,"If manual - free text"]
[null,null,null,"Name",null,"If manual - free text"]
[null,null,null,"Amount",null,"If manual - free text"]
[null,null,null,"Name",null,"If manual - free text"]
[null,null,null,"Amount",null,"If manual - free text"]
[17,"Date of Report Submission",null,null,"Y","Auto-complete at time of submission"]
[null,"SUBAWARD DATA ELEMENTS ENTERED BY PRIME"]
[1,"Subawardee - DUNS Number","The subawardee organization’s 9-digit Data Universal Numbering System (DUNS) number.",null,"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.",null,"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. MHC - TYPO?",null,"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.",null,"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."]
[null,null,null,"Street 1","Y","Pre-populated if available; or if manual, free entry"]
[null,null,null,"Street 2","Y","Pre-populated if available; or if manual, free entry"]
[null,null,null,"Street 3","Y","Pre-populated if available; or if manual, free entry"]
[null,null,null,"City","Y","Pre-populated"]
[null,null,null,"State","Y","Pre-populated"]
[null,null,null,"Country","Y","Pre-populated"]
[null,null,null,"Zip +4","Y","Pre-populated if available; or if manual, free entry"]
[null,null,null,"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.",null,"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. ",null,"Y","Free text entry"]
[8,"Subaward Obligation/Action Date","Date the subaward agreement was signed.",null,"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).",null,"Y","Pre-populated","N"]
[10,"Federal Agency Name","The name of the Federal awarding agency.",null,"Y","Pre-populated","N"]
[11,"Subawardee Principal Place of Performance","The primary site where the work will be performed."]
[null,null,"Enter the city unless a county, as a whole, is the subawardee.","City (or County)","Y","Manual entry"]
[null,null,null,"State","Y","Manual entry"]
[null,null,null,"Country","Y","Manual entry"]
[null,null,null,"Zip +4","Y","Manual entry"]
[null,null,null,"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. ",null,"Y","Free text entry"]
[13,"Subawardee Names and Compensation of Highly Compensated Officers\n","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.",null,"Y","Pre-populated if available or manual entry"]
[null,null,"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?",null,"Y","Radio button: Yes or No\nIf Yes, must answer Q2\nIf No, user not required to provide data"]
[null,null,"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?",null,"Y","Radio button: Yes or No\nIf Yes, provide link to SEC: http://www.sec.gov/"]
[null,null,null,"Name",null,"If manual - free text"]
[null,null,null,"Amount",null,"If manual - free text"]
[null,null,null,"Name",null,"If manual - free text"]
[null,null,null,"Amount",null,"If manual - free text"]
[null,null,null,"Name",null,"If manual - free text"]
[null,null,null,"Amount",null,"If manual - free text"]
[null,null,null,"Name",null,"If manual - free text"]
[null,null,null,"Amount",null,"If manual - free text"]
[null,null,null,"Name",null,"If manual - free text"]
[null,null,null,"Amount",null,"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.\"",null,"Y","Free text entry"]