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 Subcontracts screen.
Input File Templates
Download the template CSV files from the Deltek Support Center site at https://deltek.custhelp.com. The template CSV files that you can use for the Manage Subcontracts screen are:
- SUBCNTRFAR.CSV (Subcontract FAR)
- SUBCNTRSREGS.CSV (Subcontract Supplemental Regulations)
You need your regular login and password to download these files.
Input File Layout
The first row in every file is reserved for column headings. The program does not read the first row.
FAR Clause/Provision regulation type
Use the following input file layout when you select the FAR Clause/Provision regulation type on the Import FAR/Supplemental Regulation Files subtask of Manage Subcontracts.
| Column No | Column Name | Field Name | Data Type | Data Length | Required / Optional | Defaulting Information | Contents |
|---|---|---|---|---|---|---|---|
| 1 | SUBCNTR_ID | Subcontract ID | Character | 30 | Optional | If a value is not supplied in the input file, the Subcontract ID specified on the screen defaults. | |
| 2 | FAR_ID | FAR Number | Character | 25 | Required only if Title is not supplied in the input file. | ||
| 3 | FAR_TITLE | Title | Character | 256 | Optional | 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 #$%" |
| 4 | FAR_TYPE | FAR Type (Clause/Provision) | Character | 1 | 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 Clause or Provision value. If the FAR number does not exist and the FAR type is not provided in the input file, Costpoint indicates in the error report that the FAR type is required. | C, P, or U |
| 5 | SUBCNTR_FAR_DESC | Description from Contract | 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" |
|
| 6 | EFFECT_DT | Effective Date | Date | Date | Optional | Format date as yyyy-mm-dd. | |
| 7 | APPLIC_FL | Applicable to Subcontract | Character | 1 | Optional | If a value is not supplied in the input file, Y defaults. | Y or N |
| 8 | PAGE_NO | Page No | Number | 10 | Optional | ||
| 9 | PAGE_REF_ID | Page Reference No | Character | 10 | Optional | ||
| 10 | SEND_PO | Send to PO | Character | 1 | Required | If a value is not supplied in the input file, N defaults. | Y or N |
| 11 | COMMENTS | Comments | Character | 254 | Optional | ||
| 12 | INCLUDE_FL | Included | Character | 1 | Optional | Null | I (IBR) or F (Full Text) |
| 13 | RISK_LVL_FL | Risk Level | Character | 1 | Optional | H (High), M (Medium), or L (Low) | |
| 14 | FAR_NOTES | Notes | Character | 256 | Optional | ||
| 15 | SUBCNTR_NOTES | Subcontract Notes | Character | 256 | Optional |
Supplemental Regulation regulation type
Use the following input file layout when you select the Supplemental Regulation regulation type on the Import FAR/Supplemental Regulation Files subtask of Manage Subcontracts.
| Column No | Column Name | Field Name | Data Type | Data Length | Required / Optional | Defaulting Information | Contents |
|---|---|---|---|---|---|---|---|
| 1 | SUBCNTR_ID | Subcontract ID | Character | 30 | Optional | If a value is not supplied in the input file, the Subcontract ID specified on the screen defaults. | |
| 2 | DFAR_ID | Clause Number | Character | 25 | Required | ||
| 3 | DFAR_TITLE | Title | Character | 256 | Optional | If the clause number is supplied in the input file, Costpoint checks if that number exists on the Manage Supplemental Regulations Library screen and defaults its corresponding Title. If the clause 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 #$%" |
| 4 | AGENCY_CD | Agency | Character | 15 | Optional | ||
| 5 | SUBCNTR_DFAR_DESC | Description from Contract | 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" |
|
| 6 | EFFECT_DT | Effective Date | Date | Date | Optional | Format date as yyyy-mm-dd. | |
| 7 | APPLIC_FL | Applicable to Subcontract | Character | 1 | Optional | If a value is not supplied in the input file, Y defaults. | Y or N |
| 8 | PAGE_NO | Page No | Number | 10 | Optional | ||
| 9 | PAGE_REF_ID | Page Reference No | Character | 10 | Optional | ||
| 10 | SEND_PO | Send to PO | Character | 1 | Required | If a value is not supplied in the input file, N defaults. | Y or N |
| 11 | COMMENTS | Comments | Character | 254 | Optional | ||
| 12 | INCLUDE_FL | Included | Character | 1 | Optional | Null | I (IBR) or F (Full Text) |
| 13 | RISK_LVL_FL | Risk Level | Character | 1 | Optional | H (High), M (Medium), or L (Low) | |
| 14 | DFAR_NOTES | Notes | Character | 256 | Optional | ||
| 15 | SUBCNTR_NOTES | Subcontract Notes | Character | 256 | Optional |