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 Contracts 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 Contracts screen are:

  • CNTRFAR.CSV (Contract FAR)
  • CNTRSREGS.CSV (Contract 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 Contracts.

Column No Column Name Field Name Data Type Data Length Required / Optional Defaulting Information Contents
1 CNTR_ID Contract ID Character 30 Optional If a value is not supplied in the input file, the Contract 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 CNTR_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 Contract 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 COMMENTS Comments Character 254 Optional
11 RISK_LVL_FL Risk Level Character 1 Optional H (High), M (Medium), or L (Low)
12 FAR_NOTES Notes Character 256 Optional
13 SUBCNTR_FLOW_FL Subcontract Flow-down Character 1 Optional O (Optional), Y (Required), or N (Not Required)

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 Contracts.

Column No Column Name Field Name Data Type Data Length Required / Optional Defaulting Information Contents
1 CNTR_ID Contract ID Character 30 Optional If a value is not supplied in the input file, the Contract 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 CNTR_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 Contract 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 COMMENTS Comments Character 254 Optional
11 RISK_LVL_FL Risk Level Character 1 Optional H (High), M (Medium), or L (Low)
12 DFAR_NOTES Notes Character 256 Optional
13 SUBCNTR_FLOW_FL Subcontract Flow-down Character 1 Optional O (Optional), Y (Required), or N (Not Required)