USING THE DATA ANALYSIS TEMPLATE TOOLKIT | V03R24 | ||
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: o It gives you the ability to view the Grants.gov Global Library of standard fields and their attributes o It gives you the ability to utilize pre-formatted templates to be used as rows in your form's Data Analysis Template (DAT). Now 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. | ||
IS IT A FORM TITLE, SECTION HEADER, OR LABEL? | |||
YES. Copy the Label row template into your DAT. Look 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. |
|||
NO. Then it must be a data entry field. | |||
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. IS THE ELEMENT PART OF A NAME OR ADDRESS? YES. 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. |
|||
NO. IS THE ELEMENT A GLOBAL DATA ELEMENT? A 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. |
|||
YES. Copy the element's template into your DAT. Click 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. |
|||
NO. THEN THE ELEMENT MUST BE AGENCY-SPECIFIC. Determine 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. |
|||
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. |
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. | |||||
[I] | Form Category | Select the most appropriate form category. | |||||
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 column is 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. | |||||
- If the field is optional, conditional, or "Required if" then enter "No" in this column. | |||||||
- If the field is calculated (see BUSINESS RULES [11]) and all fields involved in the calculation are optional, enter “No” in this column. | |||||||
- 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. | |||||||
- 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. | |||||
- Enter 0 if the field is optional. | |||||||
- 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. | |||||
- 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: | |||||
Pre-populated | - Field will be populated with data from the application package. See Global Index Section II for a list of qualifying fields. | ||||||
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. | ||||||
Forward-populated | - Field will be populated with data from the application cover page (e.g., SF424, SF424 (R&R)) or - Field will be populated with data entered earlier in the form. |
||||||
Global | - Field is a global data element that is not forward-populated or a global data element group. | ||||||
Agency Specific | - Field is unique to your agency. Enter values in ALL columns in this DAT as indicated by the instructions. | ||||||
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. | ||||
If Post-Populated | - Pre-formatted for your convenience. No action required. | ||||||
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.) | ||||||
If Global | - If "Global" was selected in Field Type [8] column, enter n/a. | ||||||
If Agency Specific | - Pre-formatted for your convenience. No action required. | ||||||
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: | |||||
- 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. | |||||||
- Is a calculation required for this field (e.g., Total = 15-1 + 15-2 + 15-3 + 15-4) | |||||||
- Is this field conditionally required (e.g., Required if 3-1 is Yes) | |||||||
- NOTE: Grants.gov does not enforce business rules across forms. | |||||||
- 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. | |||||
- The format of each list item should be <id>: <description>. Use && to separate each value (e.g. MD: Maryland&& VA: Virginia) | |||||||
- For Minimum # of Characters [14] and Maximum # of Characters [15], enter the character count for the shortest and longest values in the list | |||||||
- 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 the selection, the field will automatically be filled with the default value. |
|||||||
- Enter n/a if a list of values does not apply. | |||||||
- 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 |
- 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. | |||||
- If the Data Type [12] is INTEGER, $, or DECIMAL(2), enter the minimum value for the field including decimals where applicable (e.g. enter "5000" if the value cannot be less than 5000.) |
|||||||
- If the Data Type [12] is LIST, FILE, MULTIFILE or DATE, enter "n/a" in this column. | |||||||
- 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 |
- If the Data Type [12] is AN, enter the maximum number of characters that may be entered into a field (maximum field length.) | |||||
- If the Data Type [12] is INTEGER, $, or DECIMAL(2), enter the maximum value for the field including decimals where applicable (e.g. enter "10,000" if the value cannot be more than 10,000.) |
|||||||
- If the Data Type [12] is LIST, FILE, MULTIFILE, or DATE, enter "n/a" in this column. | |||||||
- 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: |
|||||
- Start all help tips with "Enter the…" or "Select the…" or "Pre-populated from the…" or "Click to select…" | |||||||
- 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. | |||||||
- If the field has a certain format, then the tip should contain text describing the required format. | |||||||
- If a Radio Group is required, then the help tip on the Radio Group Header should state "One selection is required." | |||||||
FORM INFORMATION | ||
Form Name / Title | ED-900E Calculation of Estimated Relocation and Land Acquisition Expenses | |
Form Number | ED_900E | |
Version Number | 1.0 | |
Version Date | ||
Description | ||
OMB Control Number | 0610-0994 | |
OMB Expiration Date | XX/XX/20XX | |
Form Family (select all that apply) |
X | SF-424 Family |
SF-424 R&R Family | ||
SF-424 Individual Family | ||
X | SF-424 Mandatory Family | |
SF-424 Short Organizational Family | ||
Form Category (select the most appropriate category) |
Cover Sheet | |
X | Certification and Assurance | |
Survey | ||
Budget Form | ||
Key Contacts and Personal Data | ||
Attachments | ||
Miscellaneous | ||
ADDITIONAL FORM REQUIREMENTS (not indicated on the FORM DAT) | ||
FORM TITLE: | ED-900E Calculation of Estimated Relocation and Land Acquisition Expenses | |||||||||||||||
[1] | [2] |
[3] |
[4] |
[5] |
[6] |
[7] |
[8] |
[9] | [10] |
[11] |
[12] | [13] | [14] | [15] |
[16] |
[17] |
Field # | Field Label |
Short Field Label |
Required? | Minimum Occurrences |
Maximum Occurrences |
Agency Field Name |
Field Type | Global Library Field Name |
Field Type Source |
Business Rules | Data Type | List of Values |
Min # of Chars or Min Value |
Max # of Chars or Max Value |
Field Implementation |
Help Tip |
1.0 | OMB Number: 0610-0994 Expiration Date: XX/XX/20XX |
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.1 | ED-900E – Calculation of Estimated Relocation and Land Acquisition Expenses | 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.2 | a. Are relocation expenses part of the proposed project's EDA budget? | Relocation Expenses | Yes | 1 | 1 | RelocationExpenses | Radio Group | globLib:YesNoDataType | RelocationExpenses | n/a | LIST | n/a | n/a | n/a | Radio Group | Are relocation expenses part of the proposed project's EDA budget? This field is required. |
1.2.1 | Yes | Yes | No | 0 | 1 | n/a | Radio Group | n/a | RelocationExpenses | n/a | n/a | Yes | n/a | n/a | Radio | Select this option. |
1.2.2 | No | No | No | 0 | 1 | n/a | Radio Group | n/a | RelocationExpenses | n/a | n/a | No | n/a | n/a | Radio | Select this option. |
1.3 | b. Will the proposed project cause the displacement of individuals, families, businesses or farms? | Displacement | Yes | 1 | 1 | Displacement | Radio Group | globLib:YesNoDataType | Displacement | n/a | LIST | n/a | n/a | n/a | Radio Group | Will the proposed project cause the displacement of individuals, families, businesses or farms? This field is required. |
1.3.1 | Yes | Yes | No | 0 | 1 | n/a | Radio Group | n/a | Displacement | n/a | n/a | Yes | n/a | n/a | Radio | Select this option. |
1.3.2 | No | No | No | 0 | 1 | n/a | Radio Group | n/a | Displacement | n/a | n/a | No | n/a | n/a | Radio | Select this option. |
1.3.3 | If Yes, explain how relocation procedures will comply with the Uniform Relocation Assistance and Real Property Acquisition Policies Act of 1990 (13 C.F.R. § 302.5 ; see Certification #11 on Form SF-424D, 'Assurances - Construction Programs', for an explanation of this requirement.) | Explanation | No | 0 | 1 | Explanation | Agency-specific | n/a | n/a | Required if Displacement is Yes, otherwise disabled. | AN | n/a | 0 | 4000 | Field | If Yes, explain how relocation procedures will comply with the Uniform Relocation Assistance and Real Property Acquisition Policies Act of 1990 (13 C.F.R. § 302.5) |
1.4 | All applicants must complete the "Calculation of Estimated Relocation and Land Acquisition Expenses" form (below), and enter the estimated total for "costs incidental to land acquisition" (line item 1) on line item 3 ("relocation expenses and payments") of Form SF-424C, 'Budget Information - Construction Programs.' This is separate from the estimated purchase price of the 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.1 | ITEM 1. COSTS INCIDENTAL TO LAND ACQUISITION - ESTIMATES | 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.1.1 | Number of land transactions involved (including options, easements and rights-of-way): | 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.1.2 | Recording fees, transfer taxes, surveys, appraisals, title search and similar expenses-Section 303(1) | Recording fees | No | 0 | 1 | RecordingFees | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.1.3 | Penalty costs-Section 303(2) | Penalty costs | No | 0 | 1 | PenaltyCosts | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.1.4 | Real Property taxes-Section 303(3) | Real Property taxes | No | 0 | 1 | RealPropertyTaxes | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.1.5 | Litigation expenses-Section 304(a) | Litigation expenses | No | 0 | 1 | LitigationExpenses | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.1.6 | Total - Estimated costs incidental to transfer of title | Total costs transfer of title | No | 0 | 1 | TotalCostsTransferTitle | Agency-specific | globLib:BudgetAmountDataType | n/a | Read Only Field: Sum of 2.1.2 - 2.1.5 | $ | n/a | 0.00 | 999999999999.99 | Field | This is a calculated field. |
2.2 | ITEM 2. RELOCATION - ESTIMATES | 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.2.a | a. TENANTS - Estimates: Number of Claims | 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.2.a.1 | (1) Moving Expenses: | 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.2.a.1.1 | Actual Expenses-Section 202(a)(1) | Moving Actual Expenses | No | 0 | 1 | ActualExpenses | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.a.1.2 | In lieu payments-Section 202(b) | Moving In lieu payments | No | 0 | 1 | InLieuPayments | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.a.1.3 | Total - Moving Expenses | Moving Total | No | 0 | 1 | Total | Agency-specific | globLib:BudgetAmountDataType | n/a | Read Only Field: Sum of 2.2.a.1.1 + 2.2.a.1.2 | $ | n/a | 0.00 | 999999999999.99 | Field | This is a calculated field. |
2.2.a.2 | (2) Replacement housing payments: | 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.2.a.2.1 | Rental payments-Section 204(1) | Rental payments | No | 0 | 1 | RentalPayments | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.a.2.2 | Down payment-Section 204(2) | Down payment | No | 0 | 1 | DownPayment | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.a.2.3 | Total - Replacement housing payments | Total - Replacement housing payments | No | 0 | 1 | TotalHousing | Agency-specific | globLib:BudgetAmountDataType | n/a | Read Only Field: Sum of 2.2.a.2.1 + 2.2.a.2.2 | $ | n/a | 0.00 | 999999999999.99 | Field | This is a calculated field. |
2.2.a.2.4 | Total - Estimated Tenants | Total - Estimated Tenants | No | 0 | 1 | TotalEstimatedTenants | Agency-specific | globLib:BudgetAmountDataType | n/a | Read Only Field: Sum of 2.2.a.1.3 + 2.2.a.2.3 | $ | n/a | 0.00 | 999999999999.99 | Field | This is a calculated field. |
2.2.b | b. OWNER-OCCUPANTS - Estimates: Number of Claims | 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.2.b.1 | (1) Moving Expenses: | 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.2.b.1.1 | Actual Expenses-Section 202(a)(1) | Moving Actual Expenses | No | 0 | 1 | ActualExpenses | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.b.1.2 | In lieu payments-Section 202(b) | Moving In lieu payments | No | 0 | 1 | InLieuPayments | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.b.1.3 | Total - Moving Expenses | Moving Total | No | 0 | 1 | Total | Agency-specific | globLib:BudgetAmountDataType | n/a | Read Only Field: Sum of 2.2.b.1.1 + 2.2.b.1.2 | $ | n/a | 0.00 | 999999999999.99 | Field | This is a calculated field. |
2.2.b.2 | (2) Replacement housing payments: | 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.2.b.2.1 | Purchase payments-Section 203(a)(1) | Purchase payments | No | 0 | 1 | PurchasePayments | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.b.2.2 | Reasonable replacement costs-Section 203(a)(1)(A) | Replacement costs | No | 0 | 1 | ReplacementCosts | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.b.2.3 | Increased interest costs-Section 203(a)(1)(B) | Increased interest costs | No | 0 | 1 | IncreasedInterestCosts | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.b.2.4 | Closing costs-Section 203(a)(1)(C) | Closing costs | No | 0 | 1 | ClosingCosts | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.b.2.5 | Rental payments-Section 204(1) | Rental payments | No | 0 | 1 | RentalPayments | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.b.2.6 | Down payment-Section 204(2) | Down payment | No | 0 | 1 | DownPayment | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.b.2.7 | Total - Replacement housing payments | Total - Replacement housing payments | No | 0 | 1 | TotalHousing | Agency-specific | globLib:BudgetAmountDataType | n/a | Read Only Field: Sum of 2.2.b.2.1 - 2.2.b.2.6 | $ | n/a | 0.00 | 999999999999.99 | Field | This is a calculated field. |
2.2.b.2.8 | Total - Estimated Owner-Occupants | Total - Estimated Owner-Occupants | No | 0 | 1 | TotalEstimatedOwner | Agency-specific | globLib:BudgetAmountDataType | n/a | Read Only Field: Sum of 2.2.b.1.3+ 2.2.b.2.7 | $ | n/a | 0.00 | 999999999999.99 | Field | This is a calculated field. |
2.2.c | c. BUSINESS - Estimates: Number of Claims | 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.2.c.1 | Moving Expenses: | 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.2.c.1.1 | Actual Expenses-Section 202(a)(1) | Moving Actual Expenses | No | 0 | 1 | ActualExpenses | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.c.1.2 | Actual loss of tangible personal property-Section 202(a)(2) | Moving Loss of personal property | No | 0 | 1 | LossPersonalProperty | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.c.1.3 | Actual searching expenses-Section 202(a)(3) | Moving Searching expenses | No | 0 | 1 | SearchingExpenses | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.c.1.4 | In lieu payments-Section 202(c) | Moving In lieu payments | No | 0 | 1 | InLieuPayments | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.c.1.5 | Total - Estimated Business | Total - Estimated Business | No | 0 | 1 | Total | Agency-specific | globLib:BudgetAmountDataType | n/a | Read Only Field: Sum of 2.2.c.1.1 - 2.2.c.1.4 | $ | n/a | 0.00 | 999999999999.99 | Field | This is a calculated field. |
2.2.d | d. NONPROFIT ORGANIZATIONS - Estimates: Number of Claims | 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.2.d.1 | Moving Expenses: | 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.2.d.1.1 | Actual Expenses-Section 202(a)(1) | Moving Actual Expenses | No | 0 | 1 | ActualExpenses | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.d.1.2 | Actual loss of tangible personal property-Section 202(a)(2) | Moving Loss of personal property | No | 0 | 1 | LossPersonalProperty | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.d.1.3 | Actual searching expenses-Section 202(a)(3) | Moving Searching expenses | No | 0 | 1 | SearchingExpenses | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.d.1.4 | In lieu payments-Section 202(c) | Moving In lieu payments | No | 0 | 1 | InLieuPayments | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.d.1.5 | Total - Estimated Nonprofit Organizations | Total - Estimated Nonprofit Organizations | No | 0 | 1 | Total | Agency-specific | globLib:BudgetAmountDataType | n/a | Read Only Field: Sum of 2.2.d.1.1 - 2.2.d.1.4 | $ | n/a | 0.00 | 999999999999.99 | Field | This is a calculated field. |
2.2.e | e. FARM OPERATIONS - Estimates: Number of Claims | 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.2.e.1 | Moving Expenses: | 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.2.e.1.1 | Actual Expenses-Section 202(a)(1) | Moving Actual Expenses | No | 0 | 1 | ActualExpenses | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.e.1.2 | Actual loss of tangible personal property-Section 202(a)(2) | Moving Loss of personal property | No | 0 | 1 | LossPersonalProperty | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.e.1.3 | Actual searching expenses-Section 202(a)(3) | Moving Searching expenses | No | 0 | 1 | SearchingExpenses | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.e.1.4 | In lieu payments-Section 202(c) | Moving In lieu payments | No | 0 | 1 | InLieuPayments | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.e.1.5 | Total - Estimated Farm Operations | Total - Estimated Farm Operations | No | 0 | 1 | Total | Agency-specific | globLib:BudgetAmountDataType | n/a | Read Only Field: Sum of 2.2.e.1.1 - 2.2.e.1.4 | $ | n/a | 0.00 | 999999999999.99 | Field | This is a calculated field. |
2.2.f | f. ADVISORY SERVICES - Estimates: Number of Claims | 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.2.f.1 | Total - Expenses of grantee/borrower-Section 205 | Total expenses of grantee | No | 0 | 1 | TotalExpenses | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.g | g. ADMINISTRATION - Estimates: Number of Claims | 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.2.g.1 | Contracting with individual, firm, association, or corporation-Section 212 | Contracting with individual, firm, association, or corporation-Section 212 | No | 0 | 1 | ContractingSec212 | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.g.2 | Agreement w/ Federal or State government agency or instrumentality- Section 212 | Agreement w/ Federal or State government agency or instrumentality- Section 212 | No | 0 | 1 | AgreementGovernment | Agency-specific | globLib:BudgetAmountDataType | n/a | n/a | $ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
2.2.g.3 | Total - Estimated Administration | Total - Estimated Administration | No | 0 | 1 | Total | Agency-specific | globLib:BudgetAmountDataType | n/a | Read Only Field: Sum of 2.2.g.1 + 2.2.g.2 | $ | n/a | 0.00 | 999999999999.99 | Field | This is a calculated field. |
2.3 | ITEM 3. GRAND TOTAL | 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.3.1 | Enter the sum of Items 1 and 2 (parts (a) through (g)) in this Item | 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.3.2 | GRAND TOTAL RELOCATION EXPENSES | Grand total | No | 0 | 1 | GrandTotal | Agency-specific | globLib:BudgetAmountDataType | n/a | Read Only Field: Sum of 2.1.6 + 2.2.a.2.4 + 2.2.b.2.8 + 2.2.c.1.5 + 2.2.d.1.5 + 2.2.e.1.5 + 2.2.f.1 + 2.2.g.3 | $ | n/a | 0.00 | 999999999999.99 | Field | This is a calculated field. |
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 Label |
Short Field Label |
Required? | Minimum Occurrences |
Maximum Occurrences |
Agency Field Name |
Field Type | Global Library Field Name |
Field Type Source |
Business Rules | Data Type | List of Values |
Min # of Chars or Min Value |
Max # of Chars or Max Value |
Field Implementation |
Help Tip |
GLOBAL DATA ELEMENTS | ||||||||||||||||
Fill In Unique # |
Agency Name: | Agency Name | Fill In | Fill In | Fill In | AgencyName | Global or Forward-populated |
globLib:AgencyNameDataType | If Field Type [8] = Forward-populated then Fill In source, else n/a |
n/a | AN | n/a | Fill In | 60 | Field | Enter the name of the Federal Agency. |
Fill In Unique # |
Applicant ID: | Applicant ID | Fill In | Fill In | Fill In | ApplicantID | Global or Forward-populated |
globLib:ApplicantIDDataType | If Field Type [8] = Forward-populated then 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 Unique # |
CFDA Number: | CFDA Number | Fill In | Fill In | Fill In | CFDANumber | Global | globLib:CFDANumberDataType | If Field Type [8] = Forward-populated then 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 Unique # |
CFDA/Program Title: | CFDA/Program Title | Fill In | Fill In | Fill In | CFDAProgramTitle | Global | globLib:CFDATitleDataType | If Field Type [8] = Forward-populated then 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 Unique # |
Congressional District: Applicant: | Applicant District | Fill In | Fill In | Fill In | CongressionalDistrictApplicant | Global or Forward-populated |
globLib:CongressionalDistrictDataType | If Field Type [8] = Forward-populated then 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. If outside the US, enter 00-000. |
Fill In Unique # |
Congressional District: Program/Project: | Program District | Fill In | Fill In | Fill In | CongressionalDistrictProgramProject | Global or Forward-populated |
globLib:CongressionalDistrictDataType | If Field Type [8] = Forward-populated then 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. If all districts in a state are affected, enter "all" for the district number. Example: MD-all for all congressional districts in Maryland. If nationwide (all districts in all states), enter US-all. If the program/project is outside the US, enter 00-000. |
Fill In Unique # |
Country: | Country | Fill In | Fill In | Fill In | Country | Global or Forward-populated |
globLib:CountryDataType | If Field Type [8] = Forward-populated then 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 Unique # |
Department Name: | Department Name | Fill In | Fill In | Fill In | DepartmentName | Global or Forward-populated |
globLib:DepartmentNameDataType | If Field Type [8] = Forward-populated then 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 Unique # |
Division Name: | Division Name | Fill In | Fill In | Fill In | DivisionName | Global or Forward-populated |
globLib:DivisionNameDataType | If Field Type [8] = Forward-populated then 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 Unique # |
DUNS Number: | DUNS Number | Fill In | Fill In | Fill In | DUNSNumber | Global or Forward-populated |
globLib:DUNSIDDataType | If Field Type [8] = Forward-populated then 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 Unique # |
Email: | Fill In | Fill In | Fill In | Global or Forward-populated |
globLib:EmailDataType | If Field Type [8] = Forward-populated then Fill In source, else n/a |
E-mail validation | AN | n/a | Fill In | 60 | Field | Enter a valid Email Address. | ||
Fill In Unique # |
Employer/Taxpayer Identification Number (EIN/TIN): | EIN/TIN | Fill In | Fill In | Fill In | EmployerTaxpayerIdentificationNumber | Global or Forward-populated |
globLib:EmployerIDDataType | If Field Type [8] = Forward-populated then 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 Unique # |
Fax: | Fax | Fill In | Fill In | Fill In | Fax | Global or Forward-populated |
globLib:TelephoneNumberDataType | If Field Type [8] = Forward-populated then Fill In source, else n/a |
n/a | AN | n/a | Fill In | 25 | Field | Enter the Fax Number. |
Fill In Unique # |
Federal Award Identifier: | Federal Award Identifier | Fill In | Fill In | Fill In | FederalAwardIdentifier | Global or Forward-populated |
globLib:ProjectAwardNumberDataType | If Field Type [8] = Forward-populated then 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 Unique # |
Federal Entity Identifier: | Federal Entity Identifier | Fill In | Fill In | Fill In | FederalEntityIdentifier | Global or Forward-populated |
globLib:FederalIDDataType | If Field Type [8] = Forward-populated then 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 Unique # |
Organization Name (Legal Name): | Organization Name | Fill In | Fill In | Fill In | OrganizationName | Global or Forward-populated |
globLib:OrganizationNameDataType | If Field Type [8] = Forward-populated then 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 Unique # |
Telephone Number: | Telephone Number | Fill In | Fill In | Fill In | PhoneNumber | Global or Forward-populated |
globLib:TelephoneNumberDataType | If Field Type [8] = Forward-populated then 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 Unique # |
Project Name: | Project Name | Fill In | Fill In | Fill In | ProjectName | Global or Forward-populated |
globLib:ProjectNameDataType | If Field Type [8] = Forward-populated then Fill In source, else n/a |
n/a | AN | n/a | Fill In | 60 | Field | Enter the name of the project. |
Fill In Unique # |
Project Title: | Project Title | Fill In | Fill In | Fill In | ProjectTitle | Global or Forward-populated |
globLib:ProjectTitleDataType | If Field Type [8] = Forward-populated then 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 Unique # |
Social Security Number : | Social Security Number | Fill In | Fill In | Fill In | SocialSecurityNumber | Global or Forward-populated |
globLib:SocialSecurityNumberDataType | If Field Type [8] = Forward-populated then 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 Unique # |
Title: | Title | Fill In | Fill In | Fill In | Title | Global or Forward-populated |
globLib:HumanTitleDataType | If Field Type [8] = Forward-populated then Fill In source, else n/a |
n/a | AN | n/a | Fill In | 45 | Field | Enter the position title. |
Fill In Unique # |
Type of Applicant: | Type of Applicant | Fill In | Fill In | Fill In | TypeofApplicant | Global or Forward-populated |
globLib:ApplicantTypeCodeDataType | If Field Type [8] = Forward-populated then Fill In source, else n/a |
n/a | LIST | A. State Government&& B. County Government&& C. City or Township Government&& D. Special District Government&& E. Regional Organization&& F. U.S. Territory or Possession&& G. Independent School District&& H. Public/State Controlled Institution of Higher Education&& I. Indian/Native American Tribal Government (Federally Recognized)&& J. Indian/Native American Tribal&& Government (Other than Federally Recognized)&& K. Indian/Native American Tribally Designated Organization&& L. Public/Indian Housing Authority&& M. Nonprofit with 501C3 IRS Status (Other than Institution of Higher Education)&& N. Nonprofit without 501C3 IRS Status (Other than Institution of Higher Education)&& O. Private Institution of Higher Education&& P. Individual&& Q. For-Profit Organization (Other than Small Business)&& R. Small Business&& S. Hispanic-serving Institution&& T. Historically Black Colleges and Universities (HBCUs)&& U. Tribally Controlled Colleges and Universities (TCCUs)&& V. Alaska Native and Native Hawaiian Serving Institutions&& W. Non-domestic (non-US) Entity&& X. Other (specify)&& |
0 if optional, 15 if required | 82 | Popup | Select the appropriate applicant type code. |
DATA ELEMENTS THAT MAY BE PRE-POPULATED FROM THE APPLICATION PACKAGE | ||||||||||||||||
Fill In Unique # |
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 Unique # |
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 Unique # |
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 Unique # |
Competition Identification Number: | Competition Number | No | 0 | 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 Unique # |
Competition Identification Title: | Competition Title | No | 0 | 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 Unique # |
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. This field is required. |
Fill In Unique # |
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. This field is required. |
DATA ELEMENTS THAT ARE POPULATED AFTER SUBMISSION TO GRANTS.GOV (POST-POPULATED) | ||||||||||||||||
Fill In Unique # |
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 Unique # |
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 Unique # |
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 Unique # |
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 Unique # |
Street1: | Street1 | Yes | 1 | 1 | Street1 | Global or Forward-populated |
globLib:Street1 | If Field Type [8] = Forward-populated then 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 Unique # |
Street2: | Street2 | No | 0 | 1 | Street2 | Global or Forward-populated |
globLib:Street2 | If Field Type [8] = Forward-populated then Fill In source, else n/a |
n/a | AN | n/a | 0 | 55 | Field | Enter the second line of the Street Address. |
Fill In Unique # |
City: | City | Yes | 1 | 1 | City | Global or Forward-populated |
globLib:City | If Field Type [8] = Forward-populated then Fill In source, else n/a |
n/a | AN | n/a | 1 | 35 | Field | Enter the City. This field is required. |
Fill In Unique # |
County: | County | No | 0 | 1 | County | Global or Forward-populated |
globLib:County | If Field Type [8] = Forward-populated then Fill In source, else n/a |
n/a | AN | n/a | 0 | 30 | Field | Enter the County. |
Fill In Unique # |
State: | State | No | 0 | 1 | State | Global or Forward-populated |
globLib:State | If Field Type [8] = Forward-populated then 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 Unique # |
Province: | Province | No | 0 | 1 | Province | Global or Forward-populated |
globLib:Province | If Field Type [8] = Forward-populated then 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 Unique # |
Country: | Country | Yes | 1 | 1 | Country | Global or Forward-populated |
globLib:Country | If Field Type [8] = Forward-populated then 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 Unique # |
Zip / Postal Code: | Zip / Postal Code | No | 0 | 1 | ZipCode | Global or Forward-populated |
globLib:ZipPostalCode | If Field Type [8] = Forward-populated then 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 Unique # |
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 Unique # |
Prefix: | Prefix | No | 0 | 1 | Prefix | Global or Forward-populated |
globLib:PrefixName | If Field Type [8] = Forward-populated then 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 Unique # |
First Name: | First Name | Yes | 1 | 1 | FirstName | Global or Forward-populated |
globLib:FirstName | If Field Type [8] = Forward-populated then Fill In source, else n/a |
n/a | AN | n/a | 1 | 35 | Field | Enter the First Name. This field is required. |
Fill In Unique # |
Middle Name: | Middle Name | No | 0 | 1 | MiddleName | Global or Forward-populated |
globLib:MiddleName | If Field Type [8] = Forward-populated then Fill In source, else n/a |
n/a | AN | n/a | 0 | 25 | Field | Enter the Middle Name. |
Fill In Unique # |
Last Name: | Last Name | Yes | 1 | 1 | LastName | Global or Forward-populated |
globLib:LastName | If Field Type [8] = Forward-populated then Fill In source, else n/a |
n/a | AN | n/a | 1 | 60 | Field | Enter the Last Name. This field is required. |
Fill In Unique # |
Suffix: | Suffix | No | 0 | 1 | Suffix | Global or Forward-populated |
globLib:SuffixName | If Field Type [8] = Forward-populated then 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 Unique # |
ALPHANUMERIC field template Fill 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 Unique # |
BUTTON template Fill 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 Unique # |
DATE field template Fill 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 Unique # |
DEGREE EARNED template Fill 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 Unique # |
DOLLAR AMOUNT template Fill In Field Label |
Fill In | Fill In | Fill In | Fill In | Fill In | Agency-specific | globLib:BudgetAmountDataType | n/a | Fill In |
$ | n/a | 0.00 | 999999999999.99 | Field | Enter the dollar amount. |
Fill In Unique # |
DOLLAR AMOUNT TOTAL template Fill In Field Label |
Fill In | Fill In | Fill In | Fill In | Fill In | Agency-specific | globLib:BudgetTotalAmountDataType | n/a | Fill In |
$ | n/a | 0.00 | 10000000000000.00 | Field | Enter the total dollar amount. |
Fill In Unique # |
FILE ATTACHMENT template Fill In Field Label |
Fill In | No | 0 | 1 | Fill In | Global | att:AttachedFileDataType | n/a | Fill In | FILE | n/a | n/a | n/a | Single_File | Attach a file using the appropriate buttons. |
Fill In Unique # |
FILE ATTACHMENT template Fill In Field Label |
Fill In | Yes | 1 | 1 | Fill In | Global | att:AttachedFileDataType | 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 Unique # |
MULTIPLE FILE ATTACHMENT Fill In Field Label |
Fill In | No | 0 | 1 | Fill In | Global | att:AttachmentGroupMin0Max100DataType | n/a | Fill In | MULTIFILE | n/a | n/a | n/a | Multi_file | Attach file(s) using the appropriate buttons. |
Fill In Unique # |
NUMERIC WITHOUT DECIMALS field template Fill 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 Unique # |
NUMERIC WITH DECIMALS field template Fill 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 Unique # |
LABEL template Fill 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 Unique # |
LIST field template Fill 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 Unique # |
CHECKBOX template Fill 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 Unique # |
CHECKBOX template Fill 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 Unique # |
RADIO GROUP HEADER Fill In Radio Group Label |
Fill In | No | 0 | 1 | Fill In | Radio Group | n/a | Fill in Radio Group Name (may be same as Field Label) |
Fill In | LIST | n/a | n/a | n/a | Radio Group | Fill in or n/a |
Fill In Unique # |
Fill in Radio Group Option 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 | Select this option. |
Fill In Unique # |
Fill in Radio Group Option 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 | Select this option. |
RADIO GROUP REQUIRED | ||||||||||||||||
Fill In Unique # |
RADIO GROUP HEADER Fill In Radio Group Label |
Fill In | Yes | 1 | 1 | Fill In | Radio Group | n/a | Fill in Radio Group Name (may be same as Field Label) |
Fill In | LIST | n/a | n/a | n/a | Radio Group | One selection is required. |
Fill In Unique # |
Fill in Radio Group Option 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 | Select this option. |
Fill In Unique # |
Fill in Radio Group Option 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 | Select this option. |
Fill In Unique # |
PERCENT WITH DECIMALS Fill In Field Label |
Fill In | Fill In | Fill In | Fill In | Fill In | Agency-specific | globLib:PercentDecimalDataType | n/a | Fill In |
DECIMAL(2) | n/a | 0.00 | 100.00 | Field | Enter in the percentage with decimals. |
Fill In Unique # |
PERCENT WITHOUT DECIMALS Fill In Field Label |
Fill In | Fill In | Fill In | Fill In | Fill In | Agency-specific | globLib:PercentIntegerDataType | n/a | Fill In |
INTEGER | n/a | 0 | 100 | Field | Enter in the percentage as a whole number. |
Fill In Unique # |
YEAR field template Fill 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 Unique # |
YES/NO RADIO GROUP HEADER Fill In Field Label |
Fill In | No | 0 | 1 | Fill In | Radio Group | globLib:YesNoDataType | Fill in Radio Group Name (may be same as Field Label) |
n/a | LIST | n/a | n/a | n/a | Radio Group | Fill in or n/a |
Fill In Unique # |
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 | Select this option for Yes. |
Fill In Unique # |
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 | Select this option for No. |
YES/NO REQUIRED | ||||||||||||||||
Fill In Unique # |
YES/NO RADIO GROUP HEADER Fill In Field Label |
Fill In | Yes | 1 | 1 | Fill In | Radio Group | globLib:YesNoDataType | Fill in Radio Group Name (may be same as Field Label) |
n/a | LIST | n/a | n/a | n/a | Radio Group | A selection is required. |
Fill In Unique # |
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 | Select this option for Yes. |
Fill In Unique # |
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 | Select this option for No. |
YES/NO/OTHER OPTIONAL | ||||||||||||||||
Fill In Unique # |
YES/NO/OTHER RADIO GROUPHEADER Fill In Field Label |
Fill In | No | 0 | 1 | Fill In | Radio Group | globLib:YesNoOtherDataType | Fill in Radio Group Name (may be same as Field Label) |
n/a | LIST | n/a | n/a | n/a | Radio Group | Fill in or n/a |
Fill In Unique # |
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 | Select this option for Yes. |
Fill In Unique # |
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 | Select this option for No. |
Fill In Unique # |
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 | Select this option for Other. |
YES/NO/OTHER REQUIRED | ||||||||||||||||
Fill In Unique # |
YES/NO/OTHER RADIO GROUP HEADER Fill In Field Label |
Fill In | Yes | 1 | 1 | Fill In | Radio Group | globLib:YesNoOtherDataType | Fill in Radio Group Name (may be same as Field Label) |
n/a | LIST | n/a | n/a | n/a | Radio Group | A selection is required. |
Fill In Unique # |
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 | Select this option for Yes. |
Fill In Unique # |
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 | Select this option for No. |
Fill In Unique # |
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 | Select this option for Other. |
YES/NO/NOT APPLICABLE OPTIONAL | ||||||||||||||||
Fill In Unique # |
YES/NO/NA RADIO GROUP HEADER Fill In Field Label |
Fill In | No | 0 | 1 | Fill In | Radio Group | globLib:YesNoNotApplicableDataType | Fill in Radio Group Name (may be same as Field Label) |
n/a | LIST | n/a | n/a | n/a | Radio Group | Fill in or n/a |
Fill In Unique # |
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 | Select this option for Yes. |
Fill In Unique # |
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 | Select this option for No. |
Fill In Unique # |
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 | Select this option for Not Applicable. |
YES/NO/NOT APPLICABLE REQUIRED | ||||||||||||||||
Fill In Unique # |
YES/NO/NA RADIO GROUP HEADER Fill In Field Label |
Fill In | Yes | 1 | 1 | Fill In | Radio Group | globLib:YesNoNotApplicableDataType | Fill in Radio Group Name (may be same as Field Label) |
n/a | LIST | n/a | n/a | n/a | Radio Group | A selection is required. |
Fill In Unique # |
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 | Select this option for Yes. |
Fill In Unique # |
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 | Select this option for No. |
Fill In Unique # |
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 | Select this option for Not Applicable. |
File Type | application/vnd.ms-excel |
Author | Northrop Grumman User |
File Modified | 2015-06-19 |
File Created | 2005-01-06 |