Input File Information

Use this information as a guide in creating an input file that you can upload to Costpoint using the Import Project Master Data screen.

Input File Excel Template

Go to the Developer Resources page of the Costpoint Information Center to download the Excel template file specifically designed for this preprocessor. Templates for other Costpoint preprocessors are also available at the same location.

Input File Layout

The first row in every file is reserved for column headings. The program does not read the first row.

Note: If your import files were created as .csv files out of SQL and have an encode type of UTF-8-BOM, you must change the input file encode type to UTF-8 so that Costpoint will recognize the file contents and proceed with the validation and import processes.

PROJ.CSV: Manage Project User Flow

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 DFLT_PROJ_ID Default Project Character 30 O
3 PROJ_ID Project Character 30 R I
4 PROJ_TYPE_DC Project Type Character 15 R I, D
5 PROJ_NAME Name Character 25 R I
6 BILL_PROJ_FL Billable Project Character 1 R I, D Y, N
7 TC_PROJ_FL Export Project Character 1 R I, D T, E, B, N
8 ORG_ID Owning Organization Character 20 R I, D
9 CEIL_F_CST_RBA_CD Funding Info, Cost Ceiling Code Character 1 R I, D R, B, A, N
10 CEIL_F_FEE_RBA_CD Funding Info, Fee Ceiling Code Character 1 R I, D R, B, A, N
11 CEIL_F_TOT_RBA_CD Funding Info, Total Ceiling Code Character 1 R I, D R, B, A, N
12 CEIL_V_CST_RBA_CD Value Info, Cost Ceiling Code Character 1 R I, D R, B, A, N
13 CEIL_V_FEE_RBA_CD Value Info, Fee Ceiling Code Character 1 R I, D R, B, A, N
14 CEIL_V_TOT_RBA_CD Value Info, Total Ceiling Code Character 1 R I, D R, B, A, N
15 EMPL_ID Project Manager (ID) Character 12 O
16 CUST_ID Customer Character 12 O
17 NOTES Notes Character 254 O
18 S_PROJ_RPT_DC Project Classification Character 15 R I, D BID & PROPOSAL, COMMON INV, DIRECT PROJECT, INDIRECT, INTER-CO MULTI, INTER-COMPANY, IR&D, WORK IN PROCESS
19 PROJ_WORK_FRC_FL Project Work Force Required Character 1 R I, D Y, N
20 ACCT_GRP_CD Account Group Character 3 R I, D
21 PROJ_ABBRV_CD Project Abbreviation Character 6 O/D
22 ACTIVE_FL Active Character 1 R I, D Y, N
23 ACCT_GRP_FL Account Group - Allow Edit Character 1 R I, D Y, N
24 PROJ_RPT_DC_FL Project Classification - Allow Edit Character 1 R I, D Y, N
25 PROJ_TYPE_FL Project Type - Allow Edit Character 1 R I, D Y, N
26 ORG_ID_FL Owning Organization - Allow Edit Character 1 R I, D Y, N
27 EMPL_ID_FL Project Manager - Allow Edit Character 1 R I, D Y, N
28 CUST_ID_FL Customer - Allow Edit Character 1 R I, D Y, N
29 FUND_SRCE_FL Funding Source - Allow Edit Character 1 R I, D Y, N
30 PRIME_CONTR_FL Prime Contract No - Allow Edit Character 1 R I, D Y, N
31 SUB_CONTR_FL Subcontractor No - Allow Edit Character 1 R I, D Y, N
32 PO_NO_FL Purchase Order No - Allow Edit Character 1 R I, D Y, N
33 DMS_DPS_FL DPAS Purchasing Rating - Allow Edit Character 1 R I, D Y, N
34 ICS_FL Incurred Cost Submission Code - Allow Edit Character 1 R I, D Y, N
35 CONTR_ST_MMDD_FL Contract Year - Allow Edit Character 1 R I, D Y, N
36 COM_FL Apply Cost of Money Rates - Allow Edit Character 1 R I, D Y, N
37 CAS_FL CAS Covered Character 1 R I, D Y, N
38 EDIT_WORK_FRC_FL Project Work Force Required - Allow Edit Character 1 R I, D Y, N
39 PROJ_MGR_NAME Project Manager (Name) Character 25 O/D
40 DFLT_ORG_ENTRY_FL Default to Owning Org Character 1 R I, D Y, N
41 TOP_LVL_WRK_FRC_FL Use Top Level Work Force Character 1 R I, D Y, N
42 ALLOW_CHARGES_FL Allow Charging Character 1 R I, D Y, N
43 LIMIT_ORGS_FL Limit Orgs Character 1 R I, D Y, N
44 LIMIT_ACCTS_FL Limit Accounts Character 1 R I, D Y, N
45 LIMIT_AO_FL Limit which orgs can charge specific Accts Character 1 R I, D Y, N
46 COM_APPLIC_FL Apply Cost of Money Rates Character 1 R I, D Y, N
47 PRIME_CONTR_ID Prime Contract No Character 30 O/D
48 SUBCTR_ID Subcontractor No Character 30 O/D
49 CUST_PO_ID Purchase Order No Character 30 O/D
50 DMS_DPS_CD DPAS Purchasing Rating Character 6 O
51 PURGED_FL Purged Flag Character 1 O Y, N
52 LAST_BUD_CO_ID Last Budget Change Order Number 10 O
53 PROJ_LN_1_ADR Address Line 1 Character 40 O
54 PROJ_LN_2_ADR Address Line 2 Character 40 O
55 PROJ_LN_3_ADR Address Line 3 Character 40 O
56 CITY_NAME City Character 25 O
57 MAIL_STATE_DC State/Province Character 15 O
58 POSTAL_CD Zip Code Character 10 O
59 COUNTRY_CD Country Character 8 O
60 PROJ_COUNTY_CD County Character 20 O
61 LW_DOC_CD Lien Waiver Doc Code Character 6 O
62 COBRA_WBS Cobra Mapping Value Character 59 O Any value up to 59 characters.
63 COBRA_FL Cobra Project Character 1 R I, D Y, N
64 SFT_FL Export to Shop Floor Time Character 1 O Y, N
65 MES_FL Export to Manufacturing Execution Character 1 O Y, N
66 SFT_EDIT_FL Export to Shop Floor Time – Allow Edit Character 1 O Y, N
67 MES_EDIT_FL Export to Manufacturing Execution – Allow Edit Character 1 O Y, N
68 ACRN_SHOW_MSG_FL ACRN Warnings With Modifications Changes Character 1 O/D Y, N
69 ACRN_MSG_EDIT_FL ACRN Warnings With Modifications Changes - Allow Edit Character 1 O/D Y, N
70 APPLY_SAL_CAP_FL Apply Salary Cap Character 1 O Y,N
71 SAL_CAP_EDIT_FL Apply Salary Cap - Allow Edit Character 1 O Y,N
72 SAL_CAP_CD Salary Cap Code Character 15 O
73 TASK_ORDER_NO Task Order No Character 50 O O
74 CNTR_ID CTM Contract ID Character 30 O O
75 OPP_ID CTM Opportunity ID Character 32 O O
76 TASK_ORDER_FL Task Order No - Allow Edit Character 1 O O Y,N
77 CNTR_ID_FL CTM Contract ID - Allow Edit Character 1 O O Y,N
78 OPP_ID_FL CTM Opportunity ID - Allow Edit Character 1 O O Y,N
79 TLNT_FL Export Project Work Force to Talent Character 1 O Y,N
80 TLNT_EDIT_FL Export Project Work Force to Talent - Allow Edit Character 1 O Y,N
81 AGENCY_ID_FL Agency ID - Allow Edit Character 1 R Y,N
82 COTR_NAME_FL Contract Officer - Allow Edit Character 1 R Y,N
83 ACO_NAME_FL Administrative Officer - Allow Edit Character 1 R Y,N
84 PCO_NAME_FL Procurement Officer - Allow Edit Character 1 R Y,N
85 CONT_REP_NAME_FL Contractor Representative - Allow Edit Character 1 R Y,N
86 CONT_REP_TITLE_FL Contractor Representative Title - Allow Edit Character 1 R Y,N
87 ACO_PHONE_ID_FL Administrative Contracting Officer Phone - Allow Edit Character 1 R Y,N
88 ACO_FAX_ID_FL Administrative Contracting Officer Fax - Allow Edit Character 1 R Y,N
89 ACO_EMAIL_ID_FL Administrative Contracting Officer Email Address - Allow Edit Character 1 R Y,N
90 CONT_REP_PHONE_ID_FL Contractor Representative Phone - Allow Edit Character 1 R Y,N
91 CONT_REP_FAX_ID_FL Contractor Representative Fax - Allow Edit Character 1 R Y,N
92 CONT_REP_EMAIL_ID_FL Contractor Representative Email Address - Allow Edit Character 1 R Y,N
93 STMT_OF_WORK_TX_FL Statement of Work - Allow Edit Character 1 R Y,N
94 PROJ_LONG_NAME Long Name Character 120 R I, D

PROJ_MOD.CSV: Manage Modifications

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 PROJ_MOD_DESC Project Modification Description Character 30 O/D
4 NOTES Notes Character 254 O/D
5 PROJ_START_DT Period of Performance Start Date Date 10 O Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.
6 PROJ_END_DT Period of Performance End Date Date 10 O Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.
7 PROJ_V_CST_AMT Value Modifications - Cost Number 17,2 R I
8 PROJ_V_FEE_AMT Value Modifications - Fee Number 17,2 R I
9 PROJ_F_CST_AMT Funding Modifications - Cost Number 17,2 R I
10 PROJ_F_FEE_AMT Funding Modifications - Fee Number 17,2 R I
11 PROJ_MOD_ID ID Character 10 O/D
12 DELIV_UNITS_QTY Number of Units to Deliver Number 22,8 R I
13 EST_UNIT_CST_AMT Estimated Cost per Unit Number 25,10 R I
14 UNIT_PRICE_AMT Price per Unit Number 25,10 R I
15 CLIN_ID CLIN Character 10 O
16 EFFECT_DT Effective Date Date 10 R/O I Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings. This column is required only if the User Must Enter option is selected on the Configure Project Settings screen. If Default System Date is selected instead, you can leave this column blank and the system date defaults in the modification effective date when project modifications are imported.
17 SUBCNTR_ID Subcontract ID Character 30 O

PROJ_REV_SETUP.CSV: Manage Revenue Information

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 DFLT_PROJ_ID Default Project Character 30 O
3 PROJ_ID Project Character 30 R I
4 S_REV_FORMULA_CD Revenue Formula Character 8 R I, D ETC, CPFH, CPFC, BACKLOG, NONE, CVPC, ETBBR, ETBAR, ETPL, ETD, LLR, LLRCINL, LLRCINLB, LLRCINBF, FAYTD, FAMTD, FACTD, UNIT, LLRFNLBF, CIMR, CVPCVSE, RSMNLM, LLRBFNBF, CPFCCMF, COSTIMR, EAC, ITDCPFC
5 AT_RISK_FL Allow Revenue to Exceed Contract Value Character 1 R I, D Y, N
6 AT_RISK_AMT Revenue Exceeds Contract Value By How Much? Number 17,2 R I, D
7 REV_CALC_AMT (The name changes based on the revenue formula. See the "Revenue Formula Validation Detail" section.) Number 19,4 R I, D
8 REV_TO_OWN_ORG_FL Post Revenue to Owning or Performing Org Character 1 R I, D O, P
9 UNITS_FL Calculate Revenue on Units Character 1 R I, D Y, N
10 REV_CALC1_AMT (The name changes based on the revenue formula. See the "Revenue Formula Validation Detail" section.) Number 19,4 O/D
11 REV_CALC2_AMT (The name changes based on the revenue formula. See the "Revenue Formula Validation Detail" section.) Number 19,4 O/D
12 LBR_MULT_RT Goal Multiplier - Labor Number 14,4 O/D
13 NLBR_MULT_RT Goal Multiplier - Non Labor Number 14,4 O/D
14 DISC_TYPE_CD Discount Method Varchar 4 R I, D NONE, PLC, ACCT, CUST, PROJ

PROJ_BILL_INFO.CSV: Manage Project Billing Information

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 DFLT_PROJ_ID Default Project Character 30 O
3 INVC_PROJ_ID Project Character 30 R I
4 S_BILL_FORMULA_CD Formula Character 8 O CPFH, CPFC, LLR, LLRCINL, LLRCINLB, LLRCINBF, UNIT, CIMR, COSTIMR 1443, RSMNLM, RSBFNLBF, LLRFNLBF, MANUAL, NONE.
5 BILL_CALC_AMT (The name changes based on the billing formula.  See the "Billing Formula Validation Detail" section.) Number 19,4 R I, D
6 CASH_BASIS_FL Bill Cost Incurred on Cash Basis Character 1 R I, D Y, N
7 S_RTNGE_BASIS_CD Retainage - Basis for Calculation Character 3 O TOT, FEE, HRS
8 RTNGE_PCT_RT Retainage - Percentage Number 5 R I, D
9 CUST_TERMS_KEY Synthetic Key (System Use) Number 10 O
10 INCM_STATE_CD Income State Character 2 O
11 BILL_CYCLE_CD Billing Cycle Character 6 O
12 BILL_GRP_CD Billing User Group Character 6 O
13 LAST_BILL_NO_ID Last Bill Number Character 15 O/D
14 BILL_FRMT_CD Generic Billing Format Character 6 O
15 SPPRT_SCH_FRMT_CD Supporting Schedule Format Character 6 O
16 PARTL_BILL_TRN_FL Allow Transactions To Be Partially Billed Character 1 R Y, N
17 S_WHEN_RETAIN_CD Retainage - Withhold On Character 6 O/D EACH, FINAL, FINALF
18 ALLOW_USER_EDIT_FL Allow User to Edit Bills Character 1 R I, D Y, N
19 S_1035_TYPE Government 1035 Format Information - Print Cost Plus/Fixed Price Format or Print Using T&M Format Character 3 O/D CP, TM
20 ACCT_LVL_1035_NO Roll Up Accounts to Level Number 1 O/D I, D Between 1 and 8
21 S_BILL_FRMT_TYPE Format Character 6 R I, D 1035, GENRIC, 1443
22 BILL_RMT_ADDR_CD Remittance Address Character 6 R
23 BILL_PMT_ADDR_CD Payment Office Character 6 O
24 BILL_DESC Bill Heading Character 254 O/D
25 S_INVT_BILL_CD Bill Inventory Issues As (Cost, Units, Accounts) Character 1 O/D I, D C, U, A
26 PRICE_CATLG_CD Catalog Character 10 O/D
27 CLIN_ID CLIN Character 10 O/D
28 PROGRESS_PMT_RT Rates - Progress Payment Number 5 O/D Between 0 and 100
29 LIQUID_RT Rates - Liquidation Number 5 R
30 INIT_AWARD_DT Initial Award Date Date 10 O Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.
31 EST_CST_AMT Estimate to Complete Number 17,2 O/D
32 S_CONTR_PRICE_CD Contract Info - Price Basis Character 2 O/D CC, CV, FC, FV, O
33 CONTR_OVRIDE_AMT Other Amount Number 17,2 O/D
34 CONTR_REP_NAME Contract Info - Rep Name Character 25 O/D
35 CONTR_REP_TITLE Contract Info - Rep Title Character 25 O/D
36 POP_FL Limit Transactions to Period of Performance Character 1 R I, D Y, N
37 CONTR_ADDR_CD Contract Info - Address Character 6 O
38 MAX_RTNGE_AMT Retainage - Maximum Amount (Functional Currency) Number 17,2 R I, D
39 PAY_WHEN_PAID_FL Pay When Paid Character 1 R I, D Y, N
40 ALLOW_USER_ADJ_FL Allow User to Adjust Transactions in Open Billing Detail Character 1 R I, D Y, N
41 BILL_CALC1_AMT (The name changes depending on the billing formula. See the "Billing Formula Validation Detail" section.) Number 19,4 R I, D
42 INCL_LAB_MLTPLR_FL Include Labor Multiplier in Billing Rate Character 1 O Y, N
43 S_CRNCY_CD Billing Currency Character 3 R I, D
44 RT_GRP_ID Rate Group Character 6 O
45 FREEZE_RT_FL Freeze Multicurrency Rate Character 1 R I, D Y, N
46 TRN_CRNCY_FL Use Transactional Currency Billing Character 1 O Y, N
47 BILL_PAID_SUB_FL Paid Subcontractor Flag Varchar 1 O Y, N
48 DISC_TYPE_CD Discount Method Varchar 4 R I, D NONE, PLC, ACCT, CUST, PROJ
49 DFLT_TM_PROJ_ID T&M Project Varchar 30 O Valid PROJ_ID from PROJ_LAB_CAT_RT_SC table.
50 BILL_DISC_RT Discount Percentage Decimal 5,4 O Number
51 SUBJ_BILL_WH_FL Subject to Billing Withholding Flag Character 1 R I, D Must be Y or N.
52 BILL_WH_CD Billing Withholding Code Character 10 O If not null, must be valid BILL_WH_CD from BILL_WH_CD table.
53 PROJ_V_TOT_AMT Value Info - Total Amount Number 17,2 O If not in the input file or left blank, Costpoint inserts 0.00.
54 PROJ_V_FEE_AMT Value Info - Fee Amount Number 17,2 O If not in the input file or left blank, Costpoint inserts 0.00.
55 PROJ_V_CST_AMT Value Info - Cost Amount Number 17,2 O If not in the input file or left blank, Costpoint inserts 0.00.
56 CEIL_F_CST_RBA_CD Funding Info - Cost Ceil Character 1 O B, N

If left blank, Costpoint inserts N.

57 CEIL_F_FEE_RBA_CD Funding Info - Fee Ceil Character 1 O B, N

If left blank, Costpoint inserts N.

58 CEIL_F_TOT_RBA_CD Funding Info - Total Ceil Character 1 O B, N

If left blank, Costpoint inserts N.

59 PROJ_F_TOT_AMT Funding Info -Total Amount Number 17,2 O If not in the input file or left blank, Costpoint inserts 0.00.
60 PROJ_F_FEE_AMT Funding Info - Fee Amount Number 17,2 O If not in the input file or left blank, Costpoint inserts 0.00.
61 PROJ_F_CST_AMT Funding Info - Cost Amount Number 17,2 O If not in the input file or left blank, Costpoint inserts 0.00.
62 MUX_MAX_RTNGE_AMT Retainage - Maximum Amount (Billing Currency) Number 17,2 O
63 FINAL_BILL_FL Final Billing Completed Flag Varchar 1 O Y, N
Note: If the SUBJ_BILL_WH_FL and BILL_WH_CD columns are not included in the input file, the project is set up with Subject to Withholding = N and no Billing Withholding Code.

PROJ_CUST_SETUP.CSV: Manage Project Billing Information - Customers Subtask

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 CUST_ID Customer Character 12 R I
4 ADDR_DC Address Code Character 10 R I
5 PCT_CNTRB_RT % of Project Responsibility Number 5 R I
6 BANK_ACCT_ABBRV Remittance Bank Varchar 6 O
7 IB_BANK_ID Intermediary Bank Varchar 15 O

PROJ_ORG_ACCT.CSV: Link Projects/Accounts/Organizations

Column No Column Name Field Name Data Type Data Length "R" (Required)/ "O" (Optional)/ "D" (Derived) Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 ORG_ID Organization Character 20 R I
4 ACCT_ID Account Character 15 R I
5 ACTIVE_FL Active Character 1 R I Y, N
6 REF_STRUC_1_ID REF 1 Character 20 O
7 REF_STRUC_2_ID REF 2 Character 20 O

PROJ_GOVT_CONTR.CSV: Manage Government Contract Information

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 DFLT_PROJ_ID Default Project Character 30 O
3 PROJ_ID Project Character 30 R I
4 CST_ACCT_STD_FL CAS Covered Character 1 R I, D Y, N
5 DMS_DPS_CD DPAS Purchasing Rating Character 6 O/D
6 CONTR_START_MMDD Contract Year - From - Month/Day Date 10 O Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.
7 CONTR_END_MMDD Contract Year - To - Month/Day Date 10 O Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.
8 FUND_SRCE_DESC Funding Source Character 30 O/D
9 S_ICS_CD Incurred Cost Submission Code Character 4 O
10 WD_PLC_FL Use PLC for Wage Determination Character 1 R I, D Y, N
11 COTR_NAME Contract Officer Character 30 O
12 ACO_NAME Admin. Officer Character 30 O
13 PCO_NAME Procurement Officer Character 30 O
14 STMT_OF_WORK_TX Statement of Work Long O This column is defined as a "CLOB" data type in Oracle and "text" data type in MSS. When data entry is done via Excel using this template, you may be able to enter a maximum of 32,767 characters only.  However, the actual database column can hold up to 2,147,483,647 characters.
15 AGENCY_ID Agency ID Character 8 O
16 ACO_PHONE_ID ACO Phone Character 25 O
17 ACO_FAX_ID ACO Fax Character 25 O
18 CONT_REP_NAME Contractor Rep Character 30 O
19 CONT_REP_PHONE_ID Contractor Representative - Phone Character 25 O
20 CONT_REP_FAX_ID Contractor Representative - Fax Character 25 O
21 CONT_REP_TITLE Cont Rep Title Character 30 O
22 GSA_PROJ_FL Include in Aggregate Volume Varchar 1 R I, D Y, N
23 GSA_EDIT_FL Allow Edit to Include in Aggregate Volume Varchar 1 R I, D Y, N
24 ACO_EMAIL_ID Administrative Contracting Officer Email Address Varchar 100 O
25 CONT_REP_EMAIL_ID Contractor Representative Email Address Varchar 100 O

PROJ_LAB_CAT.CSV: Link Project Labor Categories to Projects

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 BILL_LAB_CAT_CD PLC Character 6 R I
4 BILL_LAB_CAT_DESC Description Character 30 O/D
5 COBRA_RSRC Cobra Mapping Value Character 59 O Any value up to 59 characters.

PROJ_EMPL.CSV: Manage Employee Work Force

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 EMPL_ID Employees Character 12 R I
4 OT_AUTH_FL Overtime Authorized for Employees Character 1 R I Y, N

PROJ_VEND.CSV: Manage Vendor Work Force

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 VEND_ID Vendor Character 12 R I

PROJ_VEND_EMPL.CSV: Manage Vendor Employee Work Force

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 VEND_ID Vendor Character 12 R I
4 VEND_EMPL_ID Vendor Employee Character 12 R I

PROJ_EMPL_LAB_CAT.CSV: Manage Employee Work Force - Assign PLC to Employee Work Force subtask

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 EMPL_ID Employee Character 12 R I
4 BILL_LAB_CAT_CD PLC Character 6 R I
5 DFLT_FL Defaults Character 1 R I

PROJ_VEND_LAB_CAT.CSV: Manage Vendor Work Force - Assign PLC to Vendor Work Force subtask

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 VEND_ID Vendor Character 12 R I
4 BILL_LAB_CAT_CD PLC Character 6 R I
5 DFLT_FL Defaults Character 1 R I

PROJ_VEND_EMPL_PLC.CSV: Manage Vendor Employee Work Force - Assign PLC to Vendor Employee Work Force subtask

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 VEND_ID Vendor Character 12 R I
4 VEND_EMPL_ID Vendor Employee Character 12 R I
5 BILL_LAB_CAT_CD PLC Character 6 R I
6 DFLT_FL Defaults Character 1 R I

BILL_LAB_CAT.CSV: Manage Project Labor Categories (PLC)

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 BILL_LAB_CAT_CD Lab Cat Character 6 R I
3 BILL_LAB_CAT_DESC Description Character 30 R

PROJ_LAB_CAT_MAP.CSV: Link Project Labor Categories to Projects - Link GLC to Project PLC subtask

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 GENL_LAB_CAT_CD GLC Character 6 R I
4 DF_BILL_LAB_CAT_CD PLC Character 6 R I

PROJ_LAB_CAT_RT_SC.CSV: Link Project Labor Category Rates to Projects

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_LC_RT_KEY Synthetic Key (System Use) The system populates this field when a record is added.
3 PROJ_ID Project Character 30 R I
4 BILL_LAB_CAT_CD PLC Character 6 R I
5 BILL_RT_AMT Rate Number 19,4 R I
6 S_BILL_RT_TYPE_CD Rate Type Character 1 R I
7 START_DT Starting Date Date 10 R I
8 END_DT Ending Date Date 10 R I
9 BILL_DISC_RT Discount Percentage Decimal 5,4 O, D R If Discount Percentage is left blank, Costpoint inserts 0.00.

PROJ_EMPL_RT_SCH.CSV: Link PLC Rates to Employee/Vendor

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 EMPL_ID Employee Character 12 R
4 BILL_LAB_CAT_CD PLC Character 6 R
5 BILL_RT_AMT Rate Number 19,4 R
6 S_BILL_RT_TYPE_CD Rate Type Character 1 R
7 START_DT Starting Date Date 10 O/D I Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.
8 END_DT Ending Date Date 10 O/D I Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.
9 BILL_DISC_RT Discount Percentage Decimal 5,4 O/D I If Discount Percentage is left blank, Costpoint inserts 0.00.

LAB_CAT_RT_SCH.CSV: Manage Project Labor Categories (PLC) - Billing Rates subtask

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 BILL_LAB_CAT_CD Lab Cat Character 6 R I
3 BILL_RT_AMT Rate Number 19,4 R I
4 START_DT Starting Date Date 10 O/D I Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.
5 END_DT Ending Date Date 10 O/D I Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.
6 BILL_DISC_RT Discount Percentage Decimal 5,4 O/D I If Discount Percentage is left blank, Costpoint inserts 0.00.

TM_RT_ORDER.CSV: Manage Rate Sequence Orders

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 S_BILL_RT_TBL_CD Rate Table Character 6 R I C, PC, PEC, PVC
4 SEQ_NO Seq No Number 10 R I
5 SRCE_PROJ_ID Source Project Character 30 O
6 TM_RT_ORDER_KEY Synthetic Key (System Use) The system populates this field when a record is added.

CEIL_DIR_CST.CSV: Manage Direct Cost Ceilings

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 ACCT_ID Account Character 15 R I
4 S_RBA_CD Apply to (RBA) Character 1 R I R, B, A, N
5 CEIL_AMT Functional Currency Ceiling Amount Number 17,2 R I
6 MUX_CEIL_AMT Billing Currency Ceiling Amount Number 17,2 O

CEIL_DIR_HRS.CSV: Manage Hour Ceilings

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 BILL_LAB_CAT_CD Labor Cat Character 6 R I
4 CEIL_HRS Hours Ceiling Number 10 R I

CEIL_BURDEN_CST.CSV: Manage Burden Cost Ceilings

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 FY_CD Fiscal Year Character 6 R I
4 POOL_NO Pool Number 10 R I
5 S_RBA_CD Apply to (RBA) Character 1 R I R, B, A, N
6 S_CEIL_TYPE_CD C/O/F Character 1 R I C, O, F
7 CEIL_RT Rate Ceiling Number 14,8 R I
8 CEIL_COM_RT COM Ceiling Number 14,8 R I
9 ACCT_ID Account Character 15 R I

EMPL_CEIL.CSV: Manage Employee Hour Ceilings

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 BILL_LAB_CAT_CD Labor Cat Character 6 R I
4 EMPL_ID Employee Character 12 R I
5 CEIL_HRS Hours Ceiling Number 14,2 R I

VEND_CEIL.CSV: Manage Vendor Hour Ceilings

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 BILL_LAB_CAT_CD Labor Cat Character 6 R I
4 VEND_ID Vendor Character 12 R I
5 CEIL_HRS Hours Ceiling Number 14,2 R I

PROJ_BILL_INFO_SCH.CSV: Manage Project Billing Information - Detail Levels subtask

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 INVC_PROJ_ID Project (Invoice) Character 30 R I
4 SPPRT_SCH_FRMT_CD Support Schedule Format Code Character 6 O

OVRIDE_MLT_ON_DIR.CSV: Manage Multiplier Overrides

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 S_ACCT_ID Starting Account Character 15 R I
4 END_ACCT_ID Ending Account Character 15 R I
5 OVRIDE_MLT_RT Multiplier Number 14,4 R I
6 S_RBA_CD Apply to (RGBA) Character 1 R I R, B, G, or A

OVRIDE_FEE_ON_DIR.CSV: Manage Cost Fee Overrides

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 ACCT_ID Account Character 15 R I
4 S_RBA_CD Apply to (RBA) Character 1 R I R, B, A
5 OVRIDE_FEE_RT Fee Percent Number 10,8 O I 0 - 1
6 OVRIDE_FEE_HRS_AMT Functional Currency Fee on Hours Number 19,4 O I
7 MUX_OVRD_FEEHR_AMT Billing Currency Fee on Hours Number 19,4 O I

OVRIDE_FEE_ON_BURD.CSV: Manage Burden Fee Overrides

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_ID Project Character 30 R I
3 FY_CD Fiscal Year Character 6 R I
4 POOL_NO Pool Number 10 R I
5 S_RBA_CD Apply to (RBA) Character 1 R I R, B, or A
6 OVRIDE_FEE_RT Fee Percent Number 10,8 R I 0 - 1

EMPL_PROJ_TS_DFLT.CSV: Manage Employee Project Timesheet Defaults

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 EMPL_ID Employee Character 12 R I
3 PROJ_ID Project Character 30 R I
4 APPLY_LOWER_LVL_FL Apply to Lower Levels Character 1 R I Y, N
5 ACCT_ID Account Character 15 O
6 ORG_ID Organization Character 20 O
7 REF1_ID Reference 1 Character 20 O
8 REF2_ID Reference 2 Character 20 O
9 REG_PAY_TYPE Regular Pay Type Character 3 O
10 GENL_LAB_CAT_CD GLC Character 6 O
11 LAB_LOC_CD Labor Location Character 6 O
12 WORK_COMP_CD Worker's Comp Character 6 O
13 BILL_LAB_CAT_CD PLC Character 6 O
14 WH_STATE_CD W/H State Varchar 2 O State Code from STATE table.

LAB_ACCT_GRP­_DFLT.CSV: Manage Labor Group Proj-Acct-Group Timesheet Defaults

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 ACCT_GRP_CD Project Account Group Character 3 R I
3 LAB_GRP_TYPE Labor Group Character 3 R I
4 ACCT_ID Account Character 15 R I
5 ORG_ID Organization Character 20 O
6 REF1_ID Reference 1 Character 20 O
7 REF2_ID Reference 2 Character 20 O
8 REG_PAY_TYPE Regular Pay Type Character 3 O
9 GENL_LAB_CAT_CD GLC Character 6 O
10 LAB_LOC_CD Labor Location Character 6 R
11 WORK_COMP_

CD

Worker's Comp Character 6 O
12 BILL_LAB_CAT_CD PLC Character 6 O
13 WH_STATE_CD W/H State Varchar 2 O State Code from STATE table.

EMPL_ACCT_GRP_DFLT.CSV: Manage Employee Proj-Acct-Group Timesheet Defaults

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 EMPL_ID Employee Character 12 R I
3 ACCT_GRP_CD Project Account Group Character 3 R I
4 ACCT_ID Account Character 15 R I
5 ORG_ID Organization Character 20 O
6 REF1_ID Reference 1 Character 20 O
7 REF2_ID Reference 2 Character 20 O
8 REG_PAY_TYPE Regular Pay Type Character 3 O
9 GENL_LAB_CAT_CD GLC Character 6 O
10 LAB_LOC_CD Labor Location Character 6 O
11 WORK_COMP_CD Worker's Comp Character 6 O
12 BILL_LAB_CAT_CD PLC Character 6 O
13 WH_STATE_CD W/H State Varchar 2 O State Code from STATE table.

PROJ_TS_DFLT.CSV: Manage Project Timesheet Defaults

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 DFLT_PROJ_ID Default Project Character 30 O
3 PROJ_ID Project Character 30 R I
4 APPLY_LOWER_LVL_FL Apply to Lower Levels Character 1 R I
5 ORG_ID Organization Character 20 O
6 ACCT_ID Account Character 15 O
7 REF1_ID Reference 1 Character 20 O
8 REF2_ID Reference 2 Character 20 O
9 REG_PAY_TYPE Regular Pay Type Character 3 O
10 GENL_LAB_CAT_CD GLC Character 6 O
11 LAB_LOC_CD Labor Location Character 6 O
12 WORK_COMP_CD Worker's Comp Character 6 O
13 BILL_LAB_CAT_CD PLC Character 6 O
14 WH_STATE_CD W/H State Varchar 2 O State Code from STATE table.

PROJ_WAWF_INFO.CSV: Manage Project iRAPT Information

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 DFLT_PROJ_ID Default Project Character 30 O
3 PROJ_ID Project Character 30 R I
4 WAWF_SEND_CAGE_CD CAGE Code Character 5 R I
5 WAWF_INVC_TYPE_CD Invoice Type Character 5 R I
6 WAWF_SRCE_FILE_CD File Source Character 1 R I
7 WAWF_ADMIN_ID Administration Character 6 O
8 WAWF_PMT_OFFICE_ID Payment Office Character 6 O
9 WAWF_SHIP_TO_ID Contracting Officer/Ship To Character 6 O
10 WAWF_MARK_DELIV_ID Mark For Delivery Character 6 O
11 WAWF_INSPECT_ID Inspect By Character 6 O
12 WAWF_LOCAL_PROC_ID Local Processing Office Character 6 O
13 WAWF_SHIP_FROM_ID Ship From Character 6 O
14 WAWF_ISSUE_ID Issue By Character 6 O
15 WAWF_TASK_ORDER_ID Task Order Character 30 O
16 WAWF_LAST_INVC_FL Final Invoice Character 1 O
17 WAWF_ATTACHMENT Attachment File Select Character 100 O
18 WAWF_LAST_SHIP_FL Final Shipment Character 1 O
19 WAWF_COMMENTS Mark For Delivery Comments Character 75 O
20 WAWF_2ND_COMMENTS Mark For Delivery Secondary Comments Character 75 O
21 WAWF_CERT_FL Construction Certificate, Certification, Certificate of Conformance Character 1 O
22 WAWF_SUPPLY_SVC_CD Type Character 3 R I
23 WAWF_INSPECT_PT_CD Inspection Point Character 1 R I
24 WAWF_ACCEPT_PT_CD Acceptance Point Character 1 R I
25 WAWF_FOB_CD FOB Character 1 R I
26 WAWF_ARP_FL Alternate Release Procedure Character 1 O
27 WAWF_DELIV_FL Delivery On Invoice Character 1 O
28 WAWF_FMS_FL FMS Character 1 O
29 WAWF_FIN_INFO_DT Date of Financial Info DATE 7 O
30 WAWF_CLIN_MAP_CD CLIN Mapping Method Character 1 R I
31 WAWF_DFLT_CLIN Default CLIN Character 10 R (if WAWF_CLIN_MAP_CD = C for default CLIN) I
32 WAWF_MOCAS_FL MOCAS Pay System Varchar 1 R I
33 WAWF_INSPECT_OTHER Other Inspection Point Varchar 6 O
34 WAWF_ACCEPT_OTHER Other Acceptance Point Varchar 6 O
35 WAWF_PREV_REQ_NO Previous Progress Payment Request Number Varchar 8 O
36 WAWF_CAGE_EXT_CD CAGE Code Extension Character 6 O
37 WAWF_DISC_CLIN_FL Include Discounts and Taxes in CLIN Flag Character 1 R D
38 WAWF_UNIT_MAP_CD Mapping Method for Units Code Character 1 R D
39 INSPECT_EXT_CD iRAPT Inspected By Extension Code Character 6 O
40 LOCAL_PROC_EXT_CD Local Processing Office Extension Code Character 6 O
41 SHIP_FROM_EXT_CD Ship From Extension Code Character 6 O
42 SHIP_TO_EXT_CD iRAPT Ship To Extension Code Character 6 O
43 MARK_DELIV_EXT_CD iRAPT Mark for Delivery Extension Code Character 6 O
44 WAWF_ATTACHMENT_FL Use Invoice ID as Attachment Name (Y/N) Character 1 R D
45 WAWF_FAST_PAY_FL FastPay Invoice Flag (Y/N) Character 1 R D
46 WAWF_LN_HAUL_CD First Line Haul Mode Code Character 1 O
47 INSPECT_OTH_EXT_CD DoDAAC 3rd Party Inspection Extension Code Character 6 O
48 ACCEPT_OTH_EXT_CD DoDAAC 3rd Party Acceptance Extension Code Character 6 O

PROJ_RPT_ID.CSV: Manage Alternate Projects

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_RPT_ID Project Report Varchar 30 R I
3 PROJ_RPT_DESC Project Report Description Varchar 25 R I

TOP_LVL_RPT.CSV: Manage Alternate Projects

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_RPT_ID Project Report Varchar 30 R I
3 LVL_DESC Level Description Varchar 30 R I
4 LVL_LEN_NO Level Length Smallint R I
5 LVL_NO Level Number Smallint R I

PROJ_RPT_PROJ.CSV: Manage Alternate Projects - Selected Projects table window

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 USER_ID User ID Character 20 R I
2 PROJ_RPT_ID Project Report Varchar 30 R I
3 PROJ_ID Project Varchar 30 R I
4 INCL_SUBPROJ_FL Include Sub Project (Y/N) Varchar 1 R I

PROJ_ROLE_USER.CSV: Manage Project Roles

Column No Column Name Field Name Data Type Data Length Required / Optional / Derived Required In Input File (I) or Default Project (D) Contents
1 PROJ_ID Project ID Varchar 30 R I
2 ROLE_CD Role Code Varchar 15 R I
3 USER_ID User ID Varchar 20 R I
4 LOWER_LVL_FL Apply to Lower Project Levels Varchar 1 R I Y, N