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.
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 4,000 Optional
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.
4 AGENCY_CD Agency Character 15 Optional
5 SUBCNTR_DFAR_DESC Description from Contract Character 4,000 Optional
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