{"text_format":"5","workbook":"xls","n_sheets":6,"sheets":["Using Toolkit","DAT Instructions","Form Info","Global Index","Form DAT","Templates"],"props":{"creator":"Northrop Grumman User","last_modified_by":"Northrop Grumman User","company":"Northrop Grumman Corporation"},"not_rendered":{"images":1,"external_links":1,"defined_names":5},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Using Toolkit","index":0,"n_rows":25,"n_cols":4,"rows_kept":25,"merged":[[2,1,2,2],[4,1,4,2],[6,1,6,2],[8,1,8,2],[10,1,10,2],[24,1,24,2]],"flags":["formulas_cached_only"]}
["USING THE DATA ANALYSIS TEMPLATE TOOLKIT",null,null,"V03R20"]
[]
["1.","It is recommended that you print this sheet. To do so, click File, Print on the menu at the top the screen."]
[]
["2.","Click on the DAT Instructions tab at the bottom of the screen. It is recommended that you print these instructions to use as a reference during the process of creating your Data Analysis Template (DAT). To do so, click File, Print on the menu at the top the screen."]
[]
["3.","Click on the Form Info tab at the bottom of the screen.  Fill in the requested information about the form.  Refer to the instructions printed in 1. for guidance."]
[]
["4.","Click on the Global Index tab at the bottom of the screen.  The Global Index serves two purposes:\n\n          o It gives you the ability to view the Grants.gov Global Library of standard fields and their attributes\n          o It gives you the ability to utilize pre-formatted templates to be used as rows in your form's Data Analysis Template (DAT).\n\nNow is the time to begin preparing  the Data AnalysisTemplate (DAT)."]
[]
["5.","Determine the first (next) data element on the form.  A data element is a data entry field, form title, section header or label."]
[null,null,"IS IT A FORM TITLE, SECTION HEADER, OR LABEL?"]
[]
[null,null,"YES. Copy the Label row template into your DAT.\nLook for Label in the Global Index section III. General Data Element Formats.  Click on Label. The template row for a label will be highlighted. Select Edit, Copy from the menu at the top of the screen.  Click on the FORM DAT tab at the bottom of the screen. Click on the appropriate row number  to paste the template into.  From the menu, select Edit, Paste.  Use the DAT instructions as guidance for filling in all columns in red."]
[]
[null,null,"NO.  Then it must be a data entry field."]
[]
[null,null,"Grants.gov has created a required standard for representing names and addresses on forms.  Elements related to names and addresses are grouped together in data element groups.  If a data element group is selected, all fields within that group must be included.\n\nIS THE ELEMENT PART OF A NAME OR ADDRESS?\n\nYES. To use the Human Name Group or Address Group, click on the appropriate link in section II of the Global Index. Select Edit, Copy from the menu at the top of the screen.  Click on the FORM DAT tab at the bottom of the screen. Click on the row number into which template will be pasted.  From the menu, select Edit, Paste.  Use the DAT instructions as guidance for filling in all columns in red."]
[]
[null,null,"NO.  IS THE ELEMENT A GLOBAL DATA ELEMENT?\n\nA global data element is a data element that is commonly used on forms across agencies. Grants.gov has standardized the attributes for global data elements.  Some global data elements may be pre-populated from the application cover sheets, some may be post-populated after submission to Grants.gov, and some may be forward-populated from the application cover sheets.  The Global Index in section I provides a list of global data elements."]
[]
[null,null,"YES. Copy the element's template into your DAT.\nClick on the name of the element.  The template row for a label will be highlighted. Select Edit, Copy from the menu at the top of the screen.  Click on the FORM DAT tab at the bottom of the screen. Click on the row number into which the template will be pasted.  From the menu, select Edit, Paste.  Use the DAT instructions as guidance for filling in all columns in red."]
[null,null,"NO.  THEN THE ELEMENT MUST BE AGENCY-SPECIFIC.\nDetermine the General Field Format in section III of the Global Index that best reflects the data element.  Click on the name of the format or one of the options beneath it.  The template row(s) will be highlighted. Select Edit, Copy from the menu at the top of the screen.  Click on the FORM DAT tab at the bottom of the screen. Click on the row number into which  the template will be pasted.  From the menu, select Edit, Paste.  Use the DAT instructions as guidance for filling in all columns in red. For information about pre-populating, post-populating, and forward-populating, refer to the DAT instructions."]
[]
[null,"Repeat all of the steps in 5. until all elements on the form are represented on the DAT.  The data elements on the DAT should be in the same order they appear on the form.  For answers to questions about the process of preparing a Data Analysis Template, contact the PMO Program Advisor."]

{"sheet":"DAT Instructions","index":1,"n_rows":71,"n_cols":4,"rows_kept":71,"merged":[[1,2,1,3],[1,6,1,7],[2,2,2,3],[3,2,3,3],[4,2,4,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[15,2,15,3],[15,6,15,7],[16,2,16,3],[16,6,16,7],[17,2,17,3],[17,6,17,7],[18,2,18,3],[18,6,18,7],[19,0,23,0],[19,1,23,1],[19,2,19,3],[19,6,19,7],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,0,26,0],[24,1,26,1],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,0,28,0],[27,1,28,1],[27,2,27,3],[27,4,28,4],[27,5,28,5],[27,6,27,7],[28,2,28,3],[28,6,28,7],[29,2,29,3],[30,0,36,0],[30,1,36,1],[30,2,30,3],[30,4,42,4],[30,5,42,5],[30,6,30,7],[37,2,37,3],[38,0,43,0],[38,1,43,1],[44,0,49,0],[44,1,49,1],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[48,6,48,7],[49,2,49,3],[50,2,50,3],[50,6,50,7],[51,0,56,0],[51,1,56,1],[51,2,51,3],[51,4,54,4],[51,6,51,7],[52,2,52,3],[53,2,53,3],[54,2,54,3],[55,2,55,3],[56,2,56,3],[57,0,60,0],[57,1,60,1],[57,2,57,3],[57,4,59,4],[57,5,59,5],[57,6,57,7],[58,2,58,3],[59,2,59,3],[60,2,60,3],[61,0,64,0],[61,1,64,1],[61,2,61,3],[61,4,63,4],[61,5,63,5],[61,6,61,7],[62,2,62,3],[63,2,63,3],[63,6,63,7],[64,2,64,3],[65,2,65,3],[66,0,70,0],[66,1,70,1],[66,2,66,3],[66,6,66,7],[67,2,67,3],[67,4,75,4],[67,5,75,5],[68,2,68,3],[69,2,69,3],[70,2,70,3],[76,6,76,7],[77,6,77,7],[78,6,78,7],[79,6,79,7]],"flags":["formulas_cached_only"]}
["FORM INFORMATION"]
["ROW","ROW NAME","ROW DEFINITION"]
["[A]","Form Name / Title","The name of the form to be displayed on the Grants.gov system"]
["[B]","Form Number","The number associated with the form within the agency."]
["[C]","Version Number","The version number of the form within the agency."]
["[D]","Version Date","The version date of the form."]
["[E]","Description ","A short description of the form."]
["[F]","OMB Control Number ","The control number issued by the Office of Management and Budget (OMB) when a form is cleared."]
["[G]","OMB Expiration Date ","The expiration date issued by the Office of Management and Budget (OMB.)"]
["[H]","Form Family","The families this form should be include with."]
[]
[]
[]
[]
["FORM ELEMENTS"]
["COLUMN","COLUMN NAME","COLUMN DEFINITION"]
["[1]","Field #","A unique, sequential number for (a) each field on the form for which data will be entered or selected and (b) form title, section headers or labels.  Use the block number on the form mock up, if any, otherwise start the count with 1.  Format is <block#>-<field#> (e.g. Block 15, field 1 would be represented as 15-1.) "]
["[2]","Field Label","The name of the field as presented on the form.  This label will be used at the beginning of the Help Tip and Accessibility Text.  If the label has more than 25 characters, then provide an abbreviated version in the Short Field Label [3] column.  This column is also used when Field Implementation [16] is label and you are specifying the form title, section headers, or labels.  You may change any Global Library template label in red to the label as specified on the form."]
["[3]","Short Field Label","Enter condensed version for use at the beginning of Help Tip and Accessibility Text.  Please limit to 40 characters or less and do not abbreviate words."]
["[4]","Required?","- Enter \"Yes\" if the field must be completed before the application can be submitted. "]
[null,null,"- If the field is optional, conditional, or  \"Required if\" then enter \"No\" in this column."]
[null,null,"- If the field is calculated (see BUSINESS RULES [11]) and all fields involved in the calculation are optional,  enter “No” in this column."]
[null,null,"- If the field is calculated (see BUSINESS RULES [11]) and one or more of the fields involved in the calculation are mandatory, enter “Yes” in this column."]
[null,null,"- If the field is to be forward-populated (see FIELD TYPE [8]), then the value for this column should be the same as the value of the source field (e.g. if the source field is optional, the destination field is optional, if the source field is mandatory, the destination field is mandatory)."]
["[5]","Minimum Occurrences","-  The minimum number of entries that can be made for the same field."]
[null,null,"-  Enter 0 if the field is optional."]
[null,null,"-  Enter 1 or more if the field must be completed before the application can be submitted."]
["[6]","Maximum Occurrences","-  The maximum number of entries that can be made for the same field."]
[null,null,"-  Must be 1 or more."]
["[7]","Agency Field Name","Short name that describes the field.  This name will be used as an input to the XML schema.  For Global Data Elements, a suggested name is pre-filled in red, though it may be changed.  Grants.gov may modify names as needed to meet guidelines and standards.  Note:  Each Agency Field Name must be unique on a DAT."]
["[8]","Field Type","Select one from the following 5 options:"]
[null,null,"Pre-populated","- Field will be populated with data from the application package. See Global Index Section II for a list of qualifying fields."]
[null,null,"Post-populated","- Field will be populated in a form after submission to Grants.gov. See the Global Index Section III for a list of qualifying fields."]
[null,null,"Forward-populated","- Field will be populated with data from the application cover page (e.g., SF424, SF424 (R&R)) or\n- Field will be populated with data entered earlier in the form."]
[null,null,"Global","- Field is a global data element that is not forward-populated or a global data element group."]
[null,null,"Agency Specific","- Field is unique to your agency.  Enter values in ALL columns in this DAT as indicated by the instructions."]
[null,null,"Radio Group","- Agency-specific field that displays a limited set of alternatives.  Applicant has the option of selecting one value."]
["[9]","Global Library Field Name","- Pre-formatted for your convenience. No action required."]
["[10]","Field Type Source","If Pre-populated","- Pre-formatted for your convenience. No action required."]
[null,null,"If Post-Populated","- Pre-formatted for your convenience. No action required."]
[null,null,"If Foward-Populated","- If \"Foward-populated\" was selected in the Field Type [8] column, enter the source's form name (as found on the PureEdge version of the form) and field #. Should be in the format <form name>-<block #>-<field #> (e.g. SF424-6-1.)"]
[null,null,"If Global","- If \"Global\" was selected in Field Type [8] column, enter n/a."]
[null,null,"If Agency Specific","- Pre-formatted for your convenience. No action required."]
[null,null,"If Radio Group","- If \"Radio Group\" was selected in the Field Type [8] column, then enter the name radio group.  The radio group name may be the same as the Field Label."]
["[11]","Business Rules","Simple rules about the field, such as:"]
[null,null,"- Is a specific format required (e.g., 4 digit year and 5 digit code like \"2004-abcdf\")? Remember to indicate this format in the element's help tip."]
[null,null,"- Is a calculation required for this field (e.g., Total = 15-1 + 15-2 + 15-3 + 15-4)"]
[null,null,"- Is this field conditionally required (e.g., Required if 3-1 is Yes)"]
[null,null,"- NOTE:   Grants.gov does not enforce business rules across forms."]
[null,null,"- Enter n/a if there are no business rules for the field."]
["[12]","Data Type","- Pre-formatted for your convenience. No action required."]
["[13]","List of Values","-  If theData Type [12] is LIST, provide a list of values that you want to be given to the user."]
[null,null,"-  The format of each list item should be <id>: <description>. Use && to separate each value (e.g. MD: Maryland&& VA: Virginia)"]
[null,null,"-  For Minimum # of Characters [14] and Maximum # of Characters [15], enter the character count for the shortest and longest values in the list"]
[null,null,"-  If the field is required, it must have a default value.  Mark the default value with an asterisk before the value, if any (e.g. *MD: Maryland.)  If the user does not change \n   the selection, the field will automatically be filled with the default value."]
[null,null,"-  Enter n/a if a list of values does not apply."]
[null,null,"- NOTE:  No list of values is needed for Radio Groups.  This list of values is the Field Labels for the Radio Group's radio options."]
["[14]","Minimum # of Characters or Minimum Value\n","-  If the Data Type [12] is AN, enter the minimum number of characters that may be entered into a field (minimum field length.)  If the field is optional, enter 0."]
[null,null,"-  If the Data Type [12] is INTEGER, $, or DECIMAL(2), enter the minimum value for the field including decimals where applicable \n   (e.g. enter \"5000\" if the value cannot be less than 5000.)"]
[null,null,"-  If the Data Type [12] is LIST, FILE, MULTIFILE or DATE, enter \"n/a\" in this column."]
[null,null,"- A hyphen is not counted as a character if it is included on the form for presentation purposes.  It is counted if it is to be stored with the data."]
["[15]","Maximum # of Characters or Maximum Value\n","-  If the Data Type [12] is AN, enter the maximum number of characters that may be entered into a field (maximum field length.)"]
[null,null,"-  If the Data Type [12] is INTEGER, $, or DECIMAL(2), enter the maximum value for the field including decimals where applicable\n   (e.g. enter \"10,000\" if the value cannot be more than 10,000.)"]
[null,null,"-  If the Data Type [12] is LIST, FILE, MULTIFILE, or DATE, enter \"n/a\" in this column."]
[null,null,"- A hyphen is not counted as a character if it is included on the form for presentation purposes.  It is counted if it is to be stored with the data."]
["[16]","Field Implementation ","- Pre-formatted for your convenience."]
["[17]","Help Tip","Text that will be displayed when the applicant clicks on the help icon.  Please compose the wording carefully, as this text will be used for the Accessibility text as well as the Help Tip. Use the following guidelines for creating help tips:\n"]
[null,null,"- Start all help tips with \"Enter the…\" or \"Select the…\" or \"Pre-populated from the…\" or \"Click to select…\""]
[null,null,"- If the field is required, then the help tip should end with the statement \"This field is required.\"  Add \"This field is required\" to the end of global help tips if they are required."]
[null,null,"- If the field has a certain format, then the tip should contain text describing the required format."]
[null,null,"- If a Radio Group is required, then the help tip on the Radio Group Header should state \"One selection is required.\""]

{"sheet":"Form Info","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"merged":[[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,0,12,0]],"flags":["formulas_cached_only"]}
["FORM INFORMATION"]
["Form Name / Title","CERTIFICATIONS REGARDING LOBBYING; DEBARMENT, SUSPENSION AND OTHER  RESPONSIBILITY MATTERS; AND DRUG-FREE WORKPLACE REQUIREMENTS"]
["Form Number","ED 80-0013"]
["Version Number"]
["Version Date","1998-12-01"]
["Description "]
["OMB Control Number "]
["OMB Expiration Date "]
["Form Family\n(select all that apply)","X","SF424"]
[null,"X","SF424 R&R"]
[null,null,"SF424 Individual"]
[null,null,"SF424 Mandatory"]
[null,null,"SF424 Short Organizational"]

{"sheet":"Global Index","index":3,"n_rows":31,"n_cols":4,"rows_kept":31,"merged":[[0,0,0,3],[2,0,2,3],[4,0,4,1],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[13,2,13,3],[16,0,16,1],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,0,21,1],[24,2,24,3],[25,0,25,1],[25,2,25,3],[27,2,27,3]],"flags":["formulas_cached_only"]}
["Grants.gov Global Index"]
[]
["Click on an element name, data element group name, or general element format to view its DAT row template.  \nFollow the instructions to copy and paste template rows into the Form DAT."]
[]
["I.  GLOBAL DATA ELEMENTS",null,"III.  GENERAL DATA ELEMENT FORMATS"]
["Agency Name","Employer/Taxpayer Identification Number (EIN/TIN)","Alphanumeric"]
["Applicant ID","Fax","Button"]
["CFDA Number","Federal Award Identifier","Date"]
["CFDA Title","Federal Entity Identifier","Degree Earned"]
["Congressional District: Applicant","Organization Name (Legal Name)","Dollar Amount"]
["Congressional District: Program/Project","Phone Number","Dollar Amount Total"]
["Country","Project Name","File Attachment - Single"]
["Department Name","Project Title","Optional","Required"]
["Division Name","Social Security Number","File Attachment - Multiple"]
["DUNS Number","Title","Optional","Required"]
["Email","Type of Applicant","Numeric"]
["DATA ELEMENTS THAT CAN BE PRE-POPULATED FROM THE APPLICATION PACKAGE",null,"with 2 decimals","without decimals"]
["Agency Name","Competition Identification Number","Label"]
["CFDA Number","Competition Identification Title","List - Drop Down (one selection from a drop-down list of values)"]
["CFDA Title","Funding Opportunity Number","List - Checkbox (Check for yes.  May select multiple options)"]
[null,"Funding Opportunity Title","List - Radio Group (one selection from a group of options)"]
["DATA ELEMENTS THAT ARE POST-POPULATED AFTER SUBMISSION TO GRANTS.GOV",null,"Optional","Required"]
["AOR Signature",null,"Percent"]
["Date Received",null,"with  2 decimals","without decimals"]
["Date Signed",null,"Year"]
["II.  GLOBAL DATA ELEMENT GROUPS",null,"Yes/No Radio Group"]
["Address Group","Street1, Street2, City, County, Province, State, Zip Code, Country","Optional","Required"]
["Human Name Group","Prefix, First Name, Middle Name, Last Name, Suffix","Yes/No/Other Radio Group"]
[null,null,"Optional","Required"]
[null,null,"Yes/No/Not Applicable Radio Group"]
[null,null,"Optional","Required"]

{"sheet":"Form DAT","index":4,"n_rows":48,"n_cols":17,"rows_kept":48,"headers":{"footer":["Printed:","","of"]},"flags":["formulas_cached_only"]}
["FORM TITLE:",null,"CERTIFICATIONS REGARDING LOBBYING; DEBARMENT, SUSPENSION AND OTHER  RESPONSIBILITY MATTERS; AND DRUG-FREE WORKPLACE REQUIREMENTS"]
["[1]","[2]\n","[3]\n","[4]\n","[5]\n","[6]\n","[7]\n","[8]\n","[9]","[10]\n","[11]\n","[12]","[13]","[14]","[15]\n","[16]\n","[17]\n"]
["Field #","Field\nLabel","Short Field\nLabel","Required?","Minimum\nOccurrences","Maximum\nOccurrences","Agency Field\nName","Field Type","Global Library\nField Name","Field Type\nSource","Business Rules","Data Type","List of\nValues","Min  # of Chars or\nMin Value","Max # of\nChars or\nMax Value","Field\nImplementation","Help Tip"]
["0-1","CERTIFICATIONS REGARDING LOBBYING; DEBARMENT, SUSPENSION AND OTHER  RESPONSIBILITY MATTERS; AND DRUG-FREE WORKPLACE REQUIREMENTS","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["0-2","Applicants should refer to the regulations cited below to determine the certification to which they are required to attest. Applicants should also review the instructions for certification included in the regulations before completing this form. Signature of this form provides for compliance with certification requirements under 34 CFR Part 82, \"New Restrictions on Lobbying,\" and 34 CFR Part 85, \"Government-wide Debarment and Suspension (Nonprocurement) and Government-wide Requirements for Drug-Free Workplace (Grants).\" The certifications shall be treated as a material representation of fact upon which reliance will be placed when the Department of Education determines to award the covered transaction, grant, or cooperative agreement.","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["1-0","1. LOBBYING   \n\nAs required by Section 1352, Title 31 of the U.S. Code, and implemented at 34 CFR Part 82, for persons entering into a grant or cooperative agreement over $100,000, as defined at 34 CFR Part 82, Sections 82.105 and 82.110, the applicant certifies that:  ","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["1-a","(a) No Federal appropriated funds have been paid or will be paid, by or on behalf of the undersigned, to any person for influencing or attempting to influence an officer or employee of any agency, a Member of Congress, an officer or employee of Congress, or an employee of a Member of Congress in connection with the making of any Federal grant, the entering into of any cooperative agreement, and the extension, continuation, renewal, amendment, or modification of any Federal grant or cooperative agreement;   ","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["1-b","(b) If any funds other than Federal appropriated funds have been paid or will be paid to any person for influencing or attempting to influence an officer or employee of any agency, a Member of Congress, an officer or employee of Congress, or an employee of a Member of Congress in connection with this Federal grant or cooperative agreement, the undersigned shall complete and submit Standard Form - LLL, \"Disclosure Form to Report Lobbying,\" in accordance with its instructions;","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["1-c","(c) The undersigned shall require that the language of this certification be included in the award documents for all subawards at all tiers (including subgrants, contracts under grants and cooperative agreements, and subcontracts) and that all subrecipients shall certify and disclose accordingly.","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["2-0","2. DEBARMENT, SUSPENSION, AND OTHER RESPONSIBILITY MATTERS   As required by Executive Order 12549, Debarment and Suspension, and implemented at 34 CFR Part 85, for prospective participants in primary covered transactions, as defined at 34 CFR Part 85, Sections 85.105 and 85.110 --   ","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["2-A-a","A. The applicant certifies that it and its principals:   \n\n(a) Are not presently debarred, suspended, proposed for debarment, declared ineligible, or voluntarily excluded from covered transactions by any Federal department or agency;","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["2-A-b","(b) Have not within a three-year period preceding this application been convicted of or had a civil judgement rendered against them for commission of fraud or a criminal offense in connection with obtaining, attempting to obtain, or performing a public (Federal, State, or local) transaction or contract under a public transaction; violation of Federal or State antitrust statutes or commission of embezzlement, theft, forgery, bribery, falsification or destruction of records, making false statements, or receiving stolen property; ","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["2-A-c","(c) Are not presently indicted for or otherwise criminally or civilly charged by a governmental entity (Federal, State, or local) with commission of any of the offenses enumerated in paragraph (2)(b) of this certification; and","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["2-A-d","d) Have not within a three-year period preceding this application had one or more public transaction (Federal, State, or local) terminated for cause or default; and","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["2-B"," B. Where the applicant is unable to certify to any of the statements in this certification, he or she shall attach an  explanation to this application.","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["2-B-1","n/a","n/a","No","0","1","ExplanationAttachment","Global","att:AttachedFileDataType","n/a","Agency specific help tips for each button and file element.  See help tips.","FILE","n/a","n/a","n/a","Single_File","Press this button to find and attach a document to satisfy the following: \"Where the applicant is unable to certify to any of the statements in this certification, he or she shall attach an explanation to this application.\"\n\nPressing this button will allow deletion of the attachment from the form.\n\nPressing this button views any attachment made to the form.\n\nThis field shows the name of any attachment to the form."]
["3-0","3. DRUG-FREE WORKPLACE  (GRANTEES OTHER THAN INDIVIDUALS)   As required by the Drug-Free Workplace Act of 1988, and implemented at 34 CFR Part 85, Subpart F, for grantees, as defined at 34 CFR Part 85, Sections 85.605 and 85.610 --   ","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["3-A-a","A. The applicant certifies that it will or will continue to provide a drug-free workplace by:   \n\n(a) Publishing a statement notifying employees that the unlawful manufacture, distribution, dispensing, possession, or use of a controlled substance is prohibited in the grantee's workplace and specifying the actions that will be taken against employees for violation of such prohibition;  ","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["3-A-b","(b) Establishing an on-going drug-free awareness program to inform employees about:   \n\n(1) The dangers of drug abuse in the workplace;   \n\n(2) The grantee's policy of maintaining a drug-free workplace;   \n\n(3) Any available drug counseling, rehabilitation, and employee assistance programs; and   \n\n(4) The penalties that may be imposed upon employees for drug abuse violations occurring in the workplace; ","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["3-A-c","(c) Making it a requirement that each employee to be engaged in the performance of the grant be given a copy of the statement required by paragraph (a);","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["3-A-d","(d) Notifying the employee in the statement required by paragraph (a) that, as a condition of employment under the grant, the employee will:   \n\n(1) Abide by the terms of the statement; and   \n\n(2) Notify the employer in writing of his or her conviction for a violation of a criminal drug statute occurring in the workplace no later than five calendar days after such conviction;","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["3-A-e","(e) Notifying the agency, in writing, within 10 calendar days after receiving notice under subparagraph (d)(2) from an employee or otherwise receiving actual notice of such conviction. Employers of convicted employees must provide notice, including position title, to: Director, Grants Policy and Oversight Staff, U.S. Department of Education, 400 Maryland Avenue, S.W. (Room 3652, GSA Regional Office Building No. 3), Washington, DC 20202-4248. Notice shall include the identification number(s) of each affected grant;","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["3-A-f","(f) Taking one of the following actions, within 30 calendar days of receiving notice under subparagraph (d)(2), with respect to any employee who is so convicted:   \n\n(1) Taking appropriate personnel action against such an employee, up to and including termination, consistent with the requirements of the Rehabilitation Act of 1973, as amended; or   \n\n(2) Requiring such employee to participate satisfactorily in a drug abuse assistance or rehabilitation program approved for such purposes by a Federal, State, or local health, law enforcement, or other appropriate agency;   ","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["3-A-g","(g) Making a good faith effort to continue to maintain a  drug-free workplace through implementation of paragraphs  (a), (b), (c), (d), (e), and (f).  ","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["3-B","B. The grantee may insert in the space provided below the site(s) for the performance of work done in connection with the specific grant:   ","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["3-B-1","Place of Performance (Street address, city, county, state, zip code)","n/a","Yes",1,1,"PerformanceLocation","Global","globLib:AddressDataType","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["3-B-1-1","Address","n/a","Yes",1,1,"Street1","Global","globLib:Street1","n/a","n/a","AN","n/a",1,55,"Field","Street address for the location where the work will be performed"]
["3-B-1-2","n/a","n/a","No",0,1,"Street2","Global","globLib:Street2","n/a","n/a","AN","n/a",0,55,"Field","Street address for the location where the work will be performed"]
["3-B-1-3","City","n/a","Yes",1,1,"City","Global","globLib:City","n/a","n/a","AN","n/a",1,35,"Field","City where the work will be performed."]
["3-B-1-4","County","n/a","No",0,1,"County","Global","globLib:County","n/a","n/a","AN","n/a",0,30,"Field","County where the work will be performed"]
["3-B-1-5","State","n/a","Yes",1,1,"State","Global","globLib:State","n/a","n/a","LIST","50 US States, US possessions, territories, military codes",8,55,"Popup","State where work will be performed"]
["3-B-1-6","Zip","n/a","No",0,1,"ZipPostalCode","Global","globLib:ZipPostalCode","n/a","n/a","AN","n/a",0,30,"Field","Zip Code (or ZIP+4) of the location where the work will be performed"]
["3-B-2-1","Check ","n/a","No",0,1,"AdditionalLocation","Agency-specific","globLib:YesNoDataType","n/a","n/a","n/a","n/a","n/a","n/a","Check","Check if there are workplaces on file that are not identified here."]
["3-B-2-2","if there are workplaces on file that are not identified here.","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["3-B-3","DRUG-FREE WORKPLACE  (GRANTEES WHO ARE INDIVIDUALS)   As required by the Drug-Free Workplace Act of 1988, and implemented at 34 CFR Part 85, Subpart F, for grantees, as  defined at 34 CFR Part 85, Sections 85.605 and 85.610 --  ","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["3-B-3-A","A. As a condition of the grant, I certify that I will not engage in the unlawful manufacture, distribution, dispensing, possession, or use of a controlled substance in conducting any activity with the grant; and","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["3-B-3-B","B. If convicted of a criminal drug offense resulting from a violation occurring during the conduct of any grant activity, I will report the conviction, in writing, within 10 calendar days of the conviction, to: Director, Grants Policy and Oversight Staff, Department of Education, 400 Maryland Avenue, S.W. (Room 3652, GSA Regional Office Building No. 3), Washington, DC 20202-4248. Notice shall include the identification number(s) of each affected grant.","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["4-0","As the duly authorized representative of the applicant, I hereby certify that the applicant will comply with the above certifications.","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["4-1","* NAME OF APPLICANT","n/a","Yes","1","1","OrganizationName","Forward-populated","globLib:OrganizationNameDataType","SF424(R&R)-5-2","n/a","AN","n/a","1",60,"Field","This read-only field is pre-filled from the SF424 Legal Name."]
["4-2","* PRINTED NAME AND TITLE OF AUTHORIZED REPRESENTATIVE","n/a","Yes","1","1","AuthorizedRepresentativeName","Global","globLib:HumanNameDataType","n/a","n/a","n/a","n/a","n/a","n/a","Label","n/a"]
["4-2-1","Prefix:","Prefix","No",0,1,"PrefixName","Forward-populated","globLib:PrefixName","SF424(R&R)-19-1","n/a","LIST","Mr.&&Mrs.&&Miss&&Ms.&&Dr.&&Rev.&&Prof.",0,10,"Combobox","This read-only field is pre-filled from the SF-424 Authorized Representative's name information."]
["4-2-2","First Name:","First Name","Yes",1,1,"FirstName","Forward-populated","globLib:FirstName","SF424(R&R)-19-2","n/a","AN","n/a",1,35,"Field","This read-only field is pre-filled from the SF-424 Authorized Representative's name information."]
["4-2-3","Middle Name:","Middle Name","No",0,1,"MiddleName","Forward-populated","globLib:MiddleName","SF424(R&R)-19-3","n/a","AN","n/a",0,25,"Field","This read-only field is pre-filled from the SF-424 Authorized Representative's name information."]
["4-2-4","Last Name:","Last Name","Yes",1,1,"LastName","Forward-populated","globLib:LastName","SF424(R&R)-19-4","n/a","AN","n/a",1,60,"Field","This read-only field is pre-filled from the SF-424 Authorized Representative's name information."]
["4-2-5","Suffix:","Suffix","No",0,1,"SuffixName","Forward-populated","globLib:SuffixName","SF424(R&R)-19-5","n/a","LIST","Jr.&&Sr.&&M.D.&&Ph.D",0,10,"Combobox","This read-only field is pre-filled from the SF-424 Authorized Representative's name information."]
["4-2-6","Title:","Title","Yes","1","1","AuthorizedRepresentativeTitle","Forward-populated","globLib:HumanTitleDataType","SF424(R&R)-19-6","n/a","AN","n/a","Fill In",45,"Field","This read-only field is pre-filled from the SF-424 Authorized Representative's Title."]
["4-2-7","SIGNATURE:","AOR Signature","Yes","1","1","AuthorizedRepresentativeSignature","Post-Populated","globLib:SignatureDataType","n/a","Display on form 'This field will be completed on submission to Grants.gov.'","AN","n/a",1,144,"Label","n/a"]
["4-2-8","DATE:","Date Signed","Yes","1","1","SignedDate","Post-Populated","globLib:DateSignedDataType","n/a","Display on form 'This field will be completed on submission to Grants.gov.'","DATE","n/a","n/a","n/a","Label","n/a"]

{"sheet":"Templates","index":5,"n_rows":123,"n_cols":17,"rows_kept":123,"merged":[[2,0,2,7],[7,0,7,16],[47,0,47,16],[58,0,58,16]],"flags":["formulas_cached_only"]}
["DATA ANALYSIS ROW TEMPLATES"]
[]
["INSTRUCTIONS: Listed below are Data Analysis row templates for data elements and formats defined in the Global Library.  To copy into your DAT, select Edit, Copy from the menu at the top of the screen.  Click on the FORM DAT tab at the bottom of the screen. Click on the row number you want to paste the template into.  From the menu, select Edit, Paste.  Use the instructions on the DAT INSTRUCTIONS tab as guidance for filling in all columns in red."]
[]
["[1]","[2]","[3]","[4]","[5]","[6]","[7]","[8]","[9]","[10]","[11]","[12]","[13]","[14]","[15]","[16]","[17]"]
["Field #","Field\nLabel","Short Field\nLabel","Required?","Minimum\nOccurrences","Maximum\nOccurrences","Agency Field\nName","Field Type","Global Library\nField Name","Field Type\nSource","Business Rules","Data Type","List of\nValues","Min  # of Chars or\nMin Value","Max # of\nChars or\nMax Value","Field\nImplementation","Help Tip"]
[]
["GLOBAL DATA ELEMENTS"]
["Fill In\nUnique #","Agency Name:","Agency Name","Fill In","Fill In","Fill In","AgencyName","Global or\nForward-populated","globLib:AgencyNameDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a","Fill In",60,"Field","Enter the name of the Federal Agency."]
["Fill In\nUnique #","Applicant ID:","Applicant ID","Fill In","Fill In","Fill In","ApplicantID","Global or\nForward-populated","globLib:ApplicantIDDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a","Fill In",30,"Field","Enter the applicant's control number (if applicable)"]
["Fill In\nUnique #","CFDA Number:","CFDA Number","Fill In","Fill In","Fill In","CFDANumber","Global","globLib:CFDANumberDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a","Fill In",15,"Field","Enter the Catalog of Federal Domestic Assistance number. The first two digits identify the Federal department or agency that administers the program, and the last three numbers are assigned in numerical sequence."]
["Fill In\nUnique #","CFDA/Program Title:","CFDA/Program Title","Fill In","Fill In","Fill In","CFDAProgramTitle","Global","globLib:CFDATitleDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a","Fill In",120,"Field","Enter the Catalog of Federal Domestic Assistance program title."]
["Fill In\nUnique #","Congressional District: Applicant:","Applicant District","Fill In","Fill In","Fill In","CongressionalDistrictApplicant","Global or\nForward-populated","globLib:CongressionalDistrictDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a","Fill In",6,"Field","Enter the Congressional District in the format: 2 character State Abbreviation - 3 character District Number. Examples: CA-005 for California's 5th district, CA-012 for California's 12th district.\n\nIf outside the US, enter 00-000."]
["Fill In\nUnique #","Congressional District: Program/Project:","Program District","Fill In","Fill In","Fill In","CongressionalDistrictProgramProject","Global or\nForward-populated","globLib:CongressionalDistrictDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a","Fill In",6,"Field","Enter the Congressional District in the format: 2 character State Abbreviation - 3 character District Number. Examples: CA-005 for California's 5th district, CA-012 for California's 12th district.\n\nIf all districts in a state are affected, enter \"all\" for the district number. Example: MD-all for all congressional districts in Maryland.\n\nIf nationwide (all districts in all states), enter US-all.\n\nIf the program/project is outside the US, enter 00-000."]
["Fill In\nUnique #","Country:","Country","Fill In","Fill In","Fill In","Country","Global or\nForward-populated","globLib:CountryDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","LIST","ISO 3166 Country Code List","Fill In",49,"Popup","Select the Country from the provided list.  This field is required."]
["Fill In\nUnique #","Department Name:","Department Name","Fill In","Fill In","Fill In","DepartmentName","Global or\nForward-populated","globLib:DepartmentNameDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a","Fill In",30,"Field","Enter the name of primary organizational department, service, laboratory, or equivalent level within the organization which will undertake the assistance activity"]
["Fill In\nUnique #","Division Name:","Division Name","Fill In","Fill In","Fill In","DivisionName","Global or\nForward-populated","globLib:DivisionNameDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a","Fill In",30,"Field","Enter the name of primary organizational division, office, or major subdivision which will undertake the assistance activity"]
["Fill In\nUnique #","DUNS Number:","DUNS Number","Fill In","Fill In","Fill In","DUNSNumber","Global or\nForward-populated","globLib:DUNSIDDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","If entered length is 9, then append '0000'","AN","n/a",9,13,"Field","Enter the DUNS or DUNS+4 number of the applicant organization."]
["Fill In\nUnique #","Email:","Email","Fill In","Fill In","Fill In","Email","Global or\nForward-populated","globLib:EmailDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","E-mail validation","AN","n/a","Fill In",60,"Field","Enter a valid Email Address."]
["Fill In\nUnique #","Employer/Taxpayer Identification Number (EIN/TIN):","EIN/TIN","Fill In","Fill In","Fill In","EmployerTaxpayerIdentificationNumber","Global or\nForward-populated","globLib:EmployerIDDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a",9,30,"Field","Enter either TIN or EIN as assigned by the Internal Revenue Service.  If your organization is not in the US, enter 44-4444444"]
["Fill In\nUnique #","Fax:","Fax","Fill In","Fill In","Fill In","Fax","Global or\nForward-populated","globLib:TelephoneNumberDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a","Fill In",25,"Field","Enter the Fax Number."]
["Fill In\nUnique #","Federal Award Identifier:","Federal Award Identifier","Fill In","Fill In","Fill In","FederalAwardIdentifier","Global or\nForward-populated","globLib:ProjectAwardNumberDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a","Fill In",25,"Field","Enter the award number previously assigned by the Federal agency, if any."]
["Fill In\nUnique #","Federal Entity Identifier:","Federal Entity Identifier","Fill In","Fill In","Fill In","FederalEntityIdentifier","Global or\nForward-populated","globLib:FederalIDDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a","Fill In",30,"Field","Enter the number assigned to your organization by the Federal agency."]
["Fill In\nUnique #","Organization Name (Legal Name):","Organization Name","Fill In","Fill In","Fill In","OrganizationName","Global or\nForward-populated","globLib:OrganizationNameDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a","Fill In",60,"Field","Enter the legal name of the applicant that will undertake the assistance activity."]
[]
["Fill In\nUnique #","Telephone Number:","Telephone Number","Fill In","Fill In","Fill In","PhoneNumber","Global or\nForward-populated","globLib:TelephoneNumberDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a","Fill In",25,"Field","Enter the daytime Telephone Number. This field is required."]
["Fill In\nUnique #","Project Name:","Project Name","Fill In","Fill In","Fill In","ProjectName","Global or\nForward-populated","globLib:ProjectNameDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a","Fill In",60,"Field","Enter the name of the project."]
["Fill In\nUnique #","Project Title:","Project Title","Fill In","Fill In","Fill In","ProjectTitle","Global or\nForward-populated","globLib:ProjectTitleDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a","Fill In",200,"Field","Enter a brief, descriptive title of the project."]
["Fill In\nUnique #","Social Security Number :","Social Security Number ","Fill In","Fill In","Fill In","SocialSecurityNumber","Global or\nForward-populated","globLib:SocialSecurityNumberDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","SSN format validation","AN","n/a",11,11,"Field","Enter a 9-digit Social Security Number. Disclosure of SSN is voluntary.  Please see the application package instructions for the agency’s authority and routine uses of the data."]
["Fill In\nUnique #","Title:","Title","Fill In","Fill In","Fill In","Title","Global or\nForward-populated","globLib:HumanTitleDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a","Fill In",45,"Field","Enter the position title."]
["Fill In\nUnique #","Type of Applicant:","Type of Applicant","Fill In","Fill In","Fill In","TypeofApplicant","Global or\nForward-populated","globLib:ApplicantTypeCodeDataType","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","LIST","A.  State Government&&\nB.  County Government&&\nC.  City or Township Government&&\nD.  Special District Government&&\nE.  Regional Organization&&\nF.  U.S. Territory or Possession&&\nG.  Independent School District&&\nH.  Public/State Controlled Institution of \n      Higher Education&&\nI.    Indian/Native American Tribal \n      Government (Federally Recognized)&&\nJ.   Indian/Native American Tribal&& \n     Government (Other than Federally \n     Recognized)&&\nK.  Indian/Native American Tribally \n     Designated Organization&&\nL.  Public/Indian Housing Authority&&\nM.  Nonprofit with 501C3 IRS Status (Other \n      than Institution of Higher Education)&&\nN.   Nonprofit without 501C3 IRS Status \n      (Other than Institution of Higher \n      Education)&&\nO.   Private Institution of Higher Education&&\nP.   Individual&&\nQ.   For-Profit Organization (Other than \n      Small Business)&&\nR.   Small Business&&\nS.   Hispanic-serving Institution&&\nT.   Historically Black Colleges and \n      Universities (HBCUs)&&\nU.   Tribally Controlled Colleges and \n      Universities (TCCUs)&&\nV.   Alaska Native and Native Hawaiian \n      Serving Institutions&&\nW.  Non-domestic (non-US) Entity&&\nX.   Other (specify)&&","Fill In",82,"Popup","Select the appropriate applicant type code."]
[]
["DATA ELEMENTS THAT MAY BE PRE-POPULATED FROM THE APPLICATION PACKAGE"]
["Fill In\nUnique #","Agency Name:","Agency Name","Yes","1","1","AgencyName","Pre-populated","globLib:AgencyNameDataType","SubmissionDef.AgencyName","n/a","AN","n/a",1,60,"Field","Pre-populated from the Application cover sheet."]
["Fill In\nUnique #","CFDA Number:","CFDA Number","No","0","1","CFDANumber","Pre-populated","globLib:CFDANumberDataType","SubmissionDef.CFDANumber","n/a","AN","n/a",0,15,"Field","Pre-populated from the Application cover sheet."]
["Fill In\nUnique #","CFDA/Program Title:","CFDA/Program Title","No","0","1","CFDAProgramTitle","Pre-populated","globLib:CFDATitleDataType","SubmissionDef.CFDATitle","n/a","AN","n/a",0,120,"Field","Pre-populated from the Application cover sheet."]
["Fill In\nUnique #","Competition Identification Number:","Competition Number","Yes","1","1","CompetitionIdentificationNumber","Pre-populated","globLib:CompetitionIDDataType","SubmissionDef.field_CompetitionID","n/a","AN","n/a",1,40,"Field","Pre-populated from the Application cover sheet."]
["Fill In\nUnique #","Competition Identification Title:","Competition Title","Yes","1","1","CompetitionIdentificationTitle","Pre-populated","globLib:CompetitionIDTitleDataType","SubmissionDef.field_CompetitionIDTitle","n/a","AN","n/a",1,255,"Field","Pre-populated from the Application cover sheet."]
["Fill In\nUnique #","Funding Opportunity Number:","Opportuntity Number","Yes","1","1","FundingOpportunityNumber","Pre-populated","globLib:OpportunityIDDataType","SubmissionDef.OpportunityID","n/a","AN","n/a",1,40,"Field","Pre-populated from the Application cover sheet."]
["Fill In\nUnique #","Funding Opportunity Title:","Opportunity Title","Yes","1","1","FundingOpportunityTitle","Pre-populated","globLib:OpportunityTitleDataType","SubmissionDef.OpportunityIDTitle","n/a","AN","n/a",1,255,"Field","Pre-populated from the Application cover sheet."]
[]
["DATA ELEMENTS THAT ARE POPULATED AFTER SUBMISSION TO GRANTS.GOV (POST-POPULATED)"]
["Fill In\nUnique #","AOR Signature:","AOR Signature","Yes","1","1","AORSignature","Post-Populated","globLib:SignatureDataType","n/a","n/a","AN","n/a",1,144,"Label","Completed by Grants.gov upon submission."]
["Fill In\nUnique #","Date Received:","Date Received","Yes","1","1","DateReceived","Post-Populated","globLib:DateReceivedDataType","n/a","n/a","DATE","n/a","n/a","n/a","Label","Completed by Grants.gov upon submission."]
["Fill In\nUnique #","Date Signed:","Date Signed","Yes","1","1","DateSigned","Post-Populated","globLib:DateSignedDataType","n/a","n/a","DATE","n/a","n/a","n/a","Label","Completed by Grants.gov upon submission."]
[]
["DATA ELEMENT GROUPS"]
["Address Group"]
["Fill In\nUnique #","Address Group Label","n/a","Fill In","Fill In","Fill In","Fill In","Global","globLib:AddressDataType","n/a","n/a","n/a","n/a","n/a","n/a","Label","Fill In or n/a"]
["Fill In\nUnique #","Street1:","Street1","Yes",1,1,"Street1","Global or\nForward-populated","globLib:Street1","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a",1,55,"Field","Enter the first line of the Street Address. This field is required."]
["Fill In\nUnique #","Street2:","Street2","No",0,1,"Street2","Global or\nForward-populated","globLib:Street2","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a",0,55,"Field","Enter the second line of the Street Address."]
["Fill In\nUnique #","City:","City","Yes",1,1,"City","Global or\nForward-populated","globLib:City","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a",1,35,"Field","Enter the City. This field is required."]
["Fill In\nUnique #","County:","County","No",0,1,"County","Global or\nForward-populated","globLib:County","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a",0,30,"Field","Enter the County."]
["Fill In\nUnique #","State:","State","No",0,1,"State","Global or\nForward-populated","globLib:State","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","Conditionally required if Country is US then active.  If Country is not US, then inactive","LIST","50 US States, US possessions, territories, military codes",0,55,"Popup","Select the state, US possession or military code from the provided list.  This field is required if Country is the United States."]
["Fill In\nUnique #","Province:","Province","No",0,1,"Province","Global or\nForward-populated","globLib:Province","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","If Country is US then inactive.  If Country is not US, then active","AN","n/a",0,30,"Field","Enter the Province.  "]
["Fill In\nUnique #","Country:","Country","Yes",1,1,"Country","Global or\nForward-populated","globLib:Country","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","LIST","ISO 3166 Country Code List",1,49,"Popup","Select the Country from the provided list.  This field is required."]
["Fill In\nUnique #","Zip / Postal Code:","Zip / Postal Code","No",0,1,"ZipCode","Global or\nForward-populated","globLib:ZipPostalCode","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","Conditionally required if Country is US then required. If Country is not US, then optional.","AN","n/a",0,30,"Field","Enter the Postal Code (e.g., ZIP code).  This field is required if Country is the United States. "]
[]
["Human Name Group"]
["Fill In\nUnique #","Human Name Group Label","n/a","Fill In","Fill In","Fill In","Fill In","Global","globLib:HumanNameDataType","n/a","n/a","n/a","n/a","n/a","n/a","Label","Fill In or n/a"]
["Fill In\nUnique #","Prefix:","Prefix","No",0,1,"Prefix","Global or\nForward-populated","globLib:PrefixName","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","LIST","Mr.&&Mrs.&&Miss&&Ms.&&Dr.&&Rev.&&Prof.",0,10,"Combobox","Select the Prefix from the provided list or enter a new Prefix not provided on the list."]
["Fill In\nUnique #","First Name:","First Name","Yes",1,1,"FirstName","Global or\nForward-populated","globLib:FirstName","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a",1,35,"Field","Enter the First Name. This field is required."]
["Fill In\nUnique #","Middle Name:","Middle Name","No",0,1,"MiddleName","Global or\nForward-populated","globLib:MiddleName","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a",0,25,"Field","Enter the Middle Name."]
["Fill In\nUnique #","Last Name:","Last Name","Yes",1,1,"LastName","Global or\nForward-populated","globLib:LastName","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","AN","n/a",1,60,"Field","Enter the Last Name. This field is required."]
["Fill In\nUnique #","Suffix:","Suffix","No",0,1,"Suffix","Global or\nForward-populated","globLib:SuffixName","If Field Type [8] = Forward-populated\nthen Fill In source, else n/a","n/a","LIST","Jr.&&Sr.&&M.D.&&Ph.D",0,10,"Combobox","Select the Suffix from the provided list or enter a new Suffix not provided on the list."]
[]
["GENERAL DATA ELEMENT FORMATS"]
["Fill In\nUnique #","ALPHANUMERIC field template\nFill In Field Label","Fill In","Fill In","Fill In","Fill In","Fill In","Agency-specific","n/a","n/a","Fill In","AN","n/a","Fill In","Fill In","Field","Fill In"]
["Fill In\nUnique #","BUTTON template\nFill In Button Label","Fill In","n/a","n/a","n/a","n/a","Agency-specific","n/a","n/a","Fill In","n/a","n/a","n/a","n/a","Button","Fill In"]
["Fill In\nUnique #","DATE field template\nFill In Field Label","Fill In","Fill In","Fill In","Fill In","Fill In","Agency-specific","n/a","n/a","Fill In","DATE","n/a","n/a","n/a","Field","Enter the date in the format MM/DD/YYYY.  "]
["Fill In\nUnique #","DEGREE EARNED  template\nFill In Field Label","Fill In","Fill In","Fill In","Fill In","Fill In","Global","globLib:EducationDegreeDataType","n/a","Fill In","AN","n/a","Fill In",50,"Field","Enter the highest degree earned."]
["Fill In\nUnique #","DOLLAR AMOUNT template\nFill In Field Label","Fill In","Fill In","Fill In","Fill In","Fill In","Agency-specific","globLib:BudgetAmountDataType","n/a"," \nFill In","$","n/a",{"v":0,"d":"0.00"},999999999999.99,"Field","Enter the dollar amount."]
["Fill In\nUnique #","DOLLAR AMOUNT TOTAL template\nFill In Field Label","Fill In","Fill In","Fill In","Fill In","Fill In","Agency-specific","globLib:BudgetTotalAmountDataType","n/a"," \nFill In","$","n/a",{"v":0,"d":"0.00"},9999999999999.99,"Field","Enter the total dollar amount."]
["Fill In\nUnique #","FILE ATTACHMENT template\nFill In Field Label","Fill In","No","0","1","Fill In","Global","globLib:SingleAttachmentDataType","n/a","Fill In","FILE","n/a","n/a","n/a","Single_File","Attach a file using the appropriate buttons."]
["Fill In\nUnique #","FILE ATTACHMENT template\nFill In Field Label","Fill In","Yes","1","1","Fill In","Global","globLib:SingleAttachmentDataType","n/a","Fill In","FILE","n/a","n/a","n/a","Single_File","Attach a file using the appropriate buttons.  This attachment is required."]
["Fill In\nUnique #","MULTIPLE FILE ATTACHMENT\nFill In Field Label","Fill In","No","0","1","Fill In","Global","globLib:MultipleAttachmentDataType","n/a","Fill In","MULTIFILE","n/a","n/a","n/a","Multi_file","Attach file(s) using the appropriate buttons."]
["Fill In\nUnique #","MULTIPLE FILE ATTACHMENT\nFill In Field Label","Fill In","Yes","1","1","Fill In","Global","globLib:MultipleAttachmentDataType","n/a","Fill In","MULTIFILE","n/a","n/a","n/a","Multi_file","Attach file(s) using the appropriate buttons.  Attachments are required."]
["Fill In\nUnique #","NUMERIC WITHOUT DECIMALS\nfield template\nFill In Field Label","Fill In","Fill In","Fill In","Fill In","Fill In","Agency-specific","n/a","n/a","Fill In","INTEGER","n/a","Fill In","Fill In","Field","Fill In"]
["Fill In\nUnique #","NUMERIC WITH DECIMALS\n field template\nFill In Field Label","Fill In","Fill In","Fill In","Fill In","Fill In","Agency-specific","n/a","n/a","Fill In","DECIMAL(2)","n/a","Fill In","Fill In","Field","Fill In"]
["Fill In\nUnique #","LABEL template\nFill In Label from form","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Label","Fill In or n/a"]
["Fill In\nUnique #","LIST field template\nFill In Field Label","Fill In","Fill In","Fill In","Fill In","Fill In","Agency Specific","n/a","n/a","Fill In","LIST","Fill In","Fill In","Fill In","Popup","Fill In"]
["Fill In\nUnique #","CHECKBOX template\nFill In Option 1 Field Label","Fill In","Fill In","Fill In","Fill In","Fill In","Agency-specific","globLib:YesNoDataType","n/a","Fill In","n/a","n/a","n/a","n/a","Check","Check to select."]
["Fill In\nUnique #","CHECKBOX template\nFill In Option 2 Field Label","Fill In","Fill In","Fill In","Fill In","Fill In","Agency-specific","globLib:YesNoDataType","n/a","Fill In","n/a","n/a","n/a","n/a","Check","Check to select."]
["RADIO GROUP OPTIONAL"]
["Fill In\nUnique #","RADIO GROUP HEADER\nFill In Radio Group Label","n/a","No",0,1,"Fill In","Radio Group","n/a","Fill in Radio Group Name\n(may be same as Field Label)","Fill In","LIST","n/a","n/a","n/a","Radio Group","Fill in or n/a"]
["Fill In\nUnique #","Fill in Radio Group\nOption 1 Label","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","n/a","n/a","n/a","Radio","Click to select option."]
["Fill In\nUnique #","Fill in Radio Group\nOption 2 Label","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","n/a","n/a","n/a","Radio","Click to select option."]
["RADIO GROUP REQUIRED"]
["Fill In\nUnique #","RADIO GROUP HEADER\nFill In Radio Group Label","n/a","Yes",1,1,"Fill In","Radio Group","n/a","Fill in Radio Group Name\n(may be same as Field Label)","Fill In","LIST","n/a","n/a","n/a","Radio Group","One selection is required."]
["Fill In\nUnique #","Fill in Radio Group\nOption 1 Label","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","n/a","n/a","n/a","Radio","Click to select option."]
["Fill In\nUnique #","Fill in Radio Group\nOption 2 Label","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","n/a","n/a","n/a","Radio","Click to select option."]
[]
["Fill In\nUnique #","PERCENT WITH DECIMALS\nFill In Field Label","Fill In","Fill In","Fill In","Fill In","Fill In","Agency-specific","globLib:PercentDecimalDataType","n/a"," \nFill In","DECIMAL(2)","n/a","0.00",{"v":100,"d":"100.00"},"Field","Enter in the percentage with decimals."]
["Fill In\nUnique #","PERCENT WITHOUT DECIMALS\nFill In Field Label","Fill In","Fill In","Fill In","Fill In","Fill In","Agency-specific","globLib:PercentIntegerDataType","n/a"," \nFill In","INTEGER","n/a",0,100,"Field","Enter in the percentage as a whole number."]
["Fill In\nUnique #","YEAR field template\nFill In Field Label","Fill In","Fill In","Fill In","Fill In","Fill In","Agency-specific","n/a","n/a","Fill In","YEAR","n/a","4","4","Field","Fill In"]
["YES/NO OPTIONAL"]
["Fill In\nUnique #","YES/NO RADIO GROUP HEADER\nFill In Field Label","n/a","No",0,1,"Fill In","Radio Group","globLib:YesNoDataType","Fill in Radio Group Name\n(may be same as Field Label)","n/a","LIST","n/a","n/a","n/a","Radio Group","Fill in or n/a"]
["Fill In\nUnique #","Yes","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","Yes","n/a","n/a","Radio","Click to select option."]
["Fill In\nUnique #","No","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","No","n/a","n/a","Radio","Click to select option."]
["YES/NO REQUIRED"]
["Fill In\nUnique #","YES/NO RADIO GROUP HEADER\nFill In Field Label","n/a","Yes",1,1,"Fill In","Radio Group","globLib:YesNoDataType","Fill in Radio Group Name\n(may be same as Field Label)","n/a","LIST","n/a","n/a","n/a","Radio Group","A selection is required."]
["Fill In\nUnique #","Yes","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","Yes","n/a","n/a","Radio","Click to select option."]
["Fill In\nUnique #","No","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","No","n/a","n/a","Radio","Click to select option."]
["YES/NO/OTHER OPTIONAL"]
["Fill In\nUnique #","YES/NO/OTHER RADIO GROUPHEADER\nFill In Field Label","n/a","No",0,1,"Fill In","Radio Group","globLib:YesNoOtherDataType","Fill in Radio Group Name\n(may be same as Field Label)","n/a","LIST","n/a","n/a","n/a","Radio Group","Fill in or n/a"]
["Fill In\nUnique #","Yes","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","Yes","n/a","n/a","Radio","Click to select option."]
["Fill In\nUnique #","No","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","No","n/a","n/a","Radio","Click to select option."]
["Fill In\nUnique #","Other","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","Other","n/a","n/a","Radio","Click to select option."]
["YES/NO/OTHER REQUIRED"]
["Fill In\nUnique #","YES/NO/OTHER RADIO GROUP HEADER\nFill In Field Label","n/a","Yes",1,1,"Fill In","Radio Group","globLib:YesNoOtherDataType","Fill in Radio Group Name\n(may be same as Field Label)","n/a","LIST","n/a","n/a","n/a","Radio Group","A selection is required."]
["Fill In\nUnique #","Yes","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","Yes","n/a","n/a","Radio","Click to select option."]
["Fill In\nUnique #","No","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","No","n/a","n/a","Radio","Click to select option."]
["Fill In\nUnique #","Other","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","Other","n/a","n/a","Radio","Click to select option."]
["YES/NO/NOT APPLICABLE OPTIONAL"]
["Fill In\nUnique #","YES/NO/NA RADIO GROUP HEADER\nFill In Field Label","n/a","No",0,1,"Fill In","Radio Group","globLib:YesNoNotApplicableDataType","Fill in Radio Group Name\n(may be same as Field Label)","n/a","LIST","n/a","n/a","n/a","Radio Group","Fill in or n/a"]
["Fill In\nUnique #","Yes","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","Yes","n/a","n/a","Radio","Click to select option."]
["Fill In\nUnique #","No","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","No","n/a","n/a","Radio","Click to select option."]
["Fill In\nUnique #","Not Applicable","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","Not Applicable","n/a","n/a","Radio","Click to select option."]
["YES/NO/NOT APPLICABLE REQUIRED"]
["Fill In\nUnique #","YES/NO/NA RADIO GROUP HEADER\nFill In Field Label","n/a","Yes",1,1,"Fill In","Radio Group","globLib:YesNoNotApplicableDataType","Fill in Radio Group Name\n(may be same as Field Label)","n/a","LIST","n/a","n/a","n/a","Radio Group","A selection is required."]
["Fill In\nUnique #","Yes","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","Yes","n/a","n/a","Radio","Click to select option."]
["Fill In\nUnique #","No","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","No","n/a","n/a","Radio","Click to select option."]
["Fill In\nUnique #","Not Applicable","Fill In","No","0","1","n/a","Radio Group","n/a","Fill in Radio Group Name","Fill In","n/a","Not Applicable","n/a","n/a","Radio","Click to select option."]