Input File Information
Use this information as a guide in creating an input file that you can upload to Costpoint using the Import FAR/Supplemental Regulation Files subtask of the Manage FAR Library screen.
Input File Excel Template
For Costpoint 2025.x and later releases, you can download the Excel template file specifically designed for this preprocessor from the Costpoint Preprocessor Guides page on the Deltek Learning Hub.
For Costpoint 8.1, the input file is available on the Developer Resources page in the Costpoint Information Center.
Excel templates for the other Costpoint preprocessors can be found in these same locations.
Input File Layout
The first row in every file is reserved for column headings. The program does not read the first row.
Column No | Column Name | Field Name | Data Type | Data Length | Required / Optional | Defaulting Information | Contents |
|---|---|---|---|---|---|---|---|
1 | FAR_ID | FAR Clause or Provision Number | Character | 25 | Required | ||
2 | FAR_TITLE | Title | Character | 256 | Required | If the FAR number is supplied in the input file, Costpoint checks if that number exists on the Manage FAR Library screen and defaults its corresponding Title. If the FAR number does not exist or is not provided in the input file, Costpoint accepts the title in the input file. | To include special characters, enclose the whole Title text with double quotation marks. For example: "This title has special characters #$%" |
3 | FAR_TYPE | FAR Type (Clause/Provision) | Character | 1 | Required | C (Clause) or P (Provision) | |
4 | SOURCE_CD | Source | Character | 1 | Optional | U | U (User) or S (System) |
5 | REQ_FL | Required | Character | 1 | Optional | N | Y or N |
6 | INCLUDE_FL | Included | Character | 1 | Optional | Null | I (IBR) or F (Full Text) |
7 | RISK_LVL_FL | Risk Level | Character | 1 | Optional | Null | H (High), M (Medium), or L (Low) |
8 | FAR_DESC | Description | Character | 100,000 | Optional | If you are adding special characters or double quotation marks, enclose the whole Description text with double quotation marks. For example: "special characters #$%" "Adding these quotes "" within this description" "Adding these quotes "" and special characters #$% within this description" If you are adding new lines, enclose this field in double quotation marks. For example: "first line second line" | |
9 | EDIT_FL | Editable | Character | 1 | Optional | N | Y or N |
10 | EFFECT_DT | Effective Date | Date | Date | Optional | Format date as yyyy-mm-dd. | |
11 | SHOW_LOOKUP_FL | Show in Lookup | Character | 1 | Optional | Y | Y or N |
12 | FAR_NOTES | Notes | Character | 256 | Optional | ||
13 | SUBCNTR_FLOW_FL | Subcontract Flow-down | Character | 1 | Optional | Null | O (Optional), Y (Required), or N (Not Required) |
14 | SUBCNTR_NOTES | Subcontract Notes | Character | 256 | Optional | ||
15 | MITIGATION_TYPE | Mitigation Type | Character | 1 | Optional | Null | P (Price) or C (Cost Impact) |
16 | MITIGATION_NOTES | Mitigation Notes | Character | 256 | Optional | ||
17 | ADDED_DT | Added Date | Date | Date | Optional | Format date as yyyy-mm-dd. |