Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

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 Supplemental Regulations Library screen.

Input File Template

Download the following template CSV file from the Deltek Support Center site at https://deltek.custhelp.com: CTMDFAR.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 DFAR_ID Clause Number Character 25 Required
2 DFAR_TITLE Title Character 256 Required 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 #$%"

3 AGENCY_CD Agency Character 15 Optional
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 DFAR_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 DFAR_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.