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 Template

Download the following template CSV file from the Deltek Support Center site at https://deltek.custhelp.com: CTMFAR.CSV. You need your regular login and password to download this file.

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.