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
Go to the Developer Resources page of the Costpoint Information Center to download the Excel template file specifically designed for this preprocessor. Templates for other Costpoint preprocessors are also available at the same location.
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. |