UPLOAD PROJECT INFORMATION - INPUT FILE INFORMATION

Input File Templates

Download the template CSV file (PJPPREP_V61_TEMPLATES.zip) from the Deltek e-Support site at https://deltek.custhelp.com.

You will 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.

PROJ.CSV - Basic Info (Projects » Project Setup » Project Master)

Column No

Column Name

Costpoint     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

 

Character

20

R

I

 

2

DFLT_PROJ_ID

 

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

20

O/D

 

 

48

SUBCTR_ID

Subcontractor No

Character

20

O/D

 

 

49

CUST_PO_ID

Purchase Order No

Character

20

O/D

 

 

50

DMS_DPS_CD

DPAS Purchasing Rating

Character

6

O

 

 

51

PURGED_FL

 

Character

1

O

 

Y, N

52

LAST_BUD_CO_ ID

 

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 Program

Character

1

R

I, D

Y, N

 

PROJ_MOD.CSV – Modifications (Projects » Project Setup » Controls)

Column No

Column Name

Costpoint     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

 

Character

20

R

I

 

2

PROJ_ID

Project

Character

30

R

I

 

3

PROJ_MOD_ DESC

 

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 should 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 should match the Microsoft Windows format defined in Control Panel/Regional Settings.

7

PROJ_V_CST_ AMT

Value Modifications - Cost

Number

14

R

I

 

8

PROJ_V_FEE_ AMT

Value Modifications - Fee

Number

14

R

I

 

9

PROJ_F_CST_ AMT

Funding Modifications - Cost

Number

14

R

I

 

10

PROJ_F_FEE_ AMT

Funding Modifications - Fee

Number

14

R

I

 

11

PROJ_MOD_ID

ID

Character

10

O/D

 

 

12

DELIV_UNITS_ QTY

Number of Units to Deliver

Number

14

R

I

 

13

EST_UNIT_CST_ AMT

Estimated Cost per Unit

Number

14

R

I

 

14

UNIT_PRICE_ AMT

Price per Unit

Number

14

R

I

 

15

CLIN_ID

CLIN

Character

10

O

 

 

16

EFFECT_DT

Effective Date

Date

10

R

I

Date format should match the Microsoft Windows format defined in Control Panel/Regional Settings.

 

PROJ_REV_SETUP.CSV – Basic Revenue Info (Projects » Project Setup » Revenue Setup)

Column No

Column Name

Costpoint 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

 

Character

20

R

I

 

2

DFLT_PROJ_ID

 

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

14

R

I, D

 

7

REV_CALC_ AMT

(The name changes based on the revenue formula.  See the "Revenue Formula Validation Detail" section.)

Number

14

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

14

O/D

 

 

11

REV_CALC2_ AMT

(The name changes based on the revenue formula.  See the "Revenue Formula Validation Detail" section.)

Number

14

O/D

 

 

12

LBR_MULT_RT

Goal Multiplier - Labor

Number

14

O/D

 

 

13

NLBR_MULT_ RT

Goal Multiplier - Non Labor

Number

14

O/D

 

 

14

DISC_TYPE_CD

Discount Method

Varchar

4

R

I, D

NONE, PLC, ACCT, CUST, PROJ

 

PROJ_BILL_INFO.CSV - Project Billing Info screen (Projects»Billing»Billing Master)

Column No

Column Name

Costpoint     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

 

Character

20

R

I

 

2

DFLT_PROJ_ID

 

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

10

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

 

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 should match the Microsoft Windows format defined in Control Panel/Regional Settings.

31

EST_CST_AMT

Estimate to Complete

Number

14

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

14

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

Number

14

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

10

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

 

PROJ_CUST_SETUP.CSV - Project Billing Info screen (Projects»Billing»Billing Master) - Customer(s) Subtask

Column No

Column Name

Costpoint     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

 

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

 

 

PROJ_ORG_ACCT.CSV - Maintain Valid Project/Account/Orgs (Projects » Project Setup » Project Master)

Column No

Column Name

Costpoint       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

 

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 - Government Contract Info (Projects » Project Setup » Project Master)

Column No

Column Name

Costpoint     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

 

Character

20

R

I

 

2

DFLT_PROJ_ID

 

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 should 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 should 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

 

 

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

 

PROJ_WAWF_INFO – Maintain Project WAWF Information (Projects » Project Setup » Project Master)

Column No

Column Name

Costpoint 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

 

Character

20

R

I

 

2

PROJ_ID

Project

Character

30

R

I

 

3

WAWF_SEND_CAGE_CD

CAGE Code

Character

5

R

I

 

4

WAWF_INVC_TYPE_CD

Invoice Type

Character

5

R

I

 

5

WAWF_SRCE_FILE_CD

File Source

Character

1

R

I

 

6

WAWF_ ADMIN_ID

Administration

Character

6

O

 

 

7

WAWF_PMT_OFFICE_ID

Payment Office

Character

6

O

 

 

8

WAWF_SHIP_TO_ID

Contracting Officer/Ship To

Character

6

O

 

 

9

WAWF_ MARK_DELIV_ID

Mark For Delivery

Character

6

O

 

 

10

WAWF_ INSPECT_ID

Inspect By

Character

6

O

 

 

11

WAWF_ LOCAL_PROC_ID

Local Processing Office

Character

6

O

 

 

12

WAWF_SHIP_FROM_ID

Ship From

Character

6

O

 

 

13

WAWF_ISSUE_ID

Issue By

Character

6

O

 

 

14

WAWF_TASK_ORDER_ID

Task Order

Character

30

O

 

 

15

WAWF_LAST_INVC_FL

Final Invoice

Character

1

O

 

 

16

WAWF_ ATTACHMENT

Attachment File Select

Character

100

O

 

 

17

WAWF_LAST_SHIP_FL

Final Shipment

Character

1

O

 

 

18

WAWF_ COMMENTS

Mark For Delivery Comments

Character

75

O

 

 

19

WAWF_2ND_ COMMENTS

Mark For Delivery Secondary Comments

Character

75

O

 

 

20

WAWF_CERT_FL

Construction Certificate, Certification, Certificate of Conformance

Character

1

O

 

 

21

WAWF_ SUPPLY_SVC_CD

Type

Character

3

R

I

 

22

WAWF_ INSPECT_PT_CD

Inspection Point

Character

1

R

I

 

23

WAWF_ ACCEPT_PT_ CD

Acceptance Point

Character

1

R

I

 

24

WAWF_FOB_ CD

FOB

Character

1

R

I

 

25

WAWF_ARP_ FL

Alternate Release Procedure

Character

1

O

 

 

26

WAWF_DELIV_FL

Delivery On Invoice

Character

1

O

 

 

27

WAWF_FMS_ FL

FMS

Character

1

O

 

 

28

WAWF_FIN_ INFO_DT

Date of Financial Info

DATE

7

O

 

 

29

MODIFIED_BY

 

Character

18

D

 

USER ID That imports the data.

30

TIME_STAMP

 

Date

7

D

 

System date and time of import.

31

ROWVERSION

 

Number

22

D

I

Input zero.

32

WAWF_CLIN_MAP_CD

CLIN Mapping Method

Character

1

R

I

 

33

WAWF_DFLT_CLIN_ID

Default CLIN

Character

10

R (if WAWF_CLIN_MAP_CD = "C" for default CLIN)

I

 

 

BILL_LAB_CAT.CSV - Set Up Project Labor Categories (PLC) (Projects » Project Setup » Project Labor)

Column No

Column Name

Costpoint     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

 

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.CSV – Assign PLC to Projects (Projects » Project Setup » Project Labor)

Column No

Column Name

Costpoint     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

 

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 - Project Employee Work Force (Projects » Project Setup » Project Labor)

Column No

Column Name

Costpoint     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

 

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 - Project Vendor Work Force (Projects » Project Setup » Project Labor)

Column No

Column Name

Costpoint     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

 

Character

20

R

I

 

2

PROJ_ID

Project

Character

30

R

I

 

3

VEND_ID

Vendor

Character

12

R

I

 

 

PROJ_VEND_EMPL.CSV - Project Vendor Employee Work Force (Projects » Project Setup » Project Labor)

Column No

Column Name

Costpoint     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

 

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 – Assign PLC to Employee Work Force (Projects » Project Setup » Project Labor)

Column No

Column Name

Costpoint     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

 

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 - Assign PLC to Vendor Work Force (Projects » Project Setup » Project Labor)

Column No

Column Name

Costpoint     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

 

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 - Assign PLC to Vendor Employee Work Force (Projects » Project Setup » Project Labor)

Column No

Column Name

Costpoint     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

 

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

 

4

BILL_LAB_CAT_CD

PLC

Character

6

R

I

 

5

DFLT_FL

Defaults

Character

1

R

I

 

 

PROJ_LAB_CAT_MAP.CSV - Link GLC to Project PLC (Projects » Project Setup » Project Labor)

Column No

Column Name

Costpoint     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

 

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 - Project PLC Rates (Projects » Project Setup » Project Labor)

Column No

Column Name

Costpoint    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

 

Character

20

R

I

 

2

PROJ_ID

Project

Character

30

R

I

 

3

BILL_LAB_CAT_CD

PLC

Character

6

R

I

 

4

BILL_RT_AMT

Rate

Number

10

R

I

 

5

S_BILL_RT_ TYPE_CD

Rate Type

Character

1

R

I

 

6

START_DT

Starting Date

Date

10

R

I

 

7

END_DT

Ending Date

Date

10

R

I

 

8

BILL_DISC_RT

Discount Percentage

Decimal

10, 4

O, D

R

If Discount Percentage is left blank, the system will insert 0.00.

 

PROJ_EMPL_RT_SCH.CSV -Project PLC Rates by Employee/Vendor (Projects » Project Setup » Project Labor)

Column No

Column Name

Costpoint     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

 

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

10

R

 

 

6

S_BILL_RT_ TYPE_CD

Rate Type

Character

1

R

 

 

7

START_DT

Starting Date

Date

10

O/D

I

Date format should match the Microsoft Windows format defined in Control Panel/Regional Settings.

8

END_DT

Ending Date

Date

10

O/D

I

Date format should match the Microsoft Windows format defined in Control Panel/Regional Settings.

9

BILL_DISC_RT

Discount Percentage

Decimal

10,4

O/D

I

If Discount Percentage is left blank, the system will insert "0.00."

 

LAB_CAT_RT_SCH.CSV - Set Up Project Labor Categories (PLC) (Projects » Project Setup » Project Labor) - Billing Rates Subtask

Column No

Column Name

Costpoint     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

 

Character

20

R

I

 

2

BILL_LAB_CAT_CD

Lab Cat

Character

6

R

I

 

3

BILL_RT_AMT

Rate

Number

10

R

I

 

4

START_DT

Starting Date

Date

10

O/D

I

Date format should match the Microsoft Windows format defined in Control Panel/Regional Settings.

5

END_DT

Ending Date

Date

10

O/D

I

Date format should match the Microsoft Windows format defined in Control Panel/Regional Settings.

6

BILL_DISC_RT

Discount Percentage

Decimal

10,4

O/D

I

If Discount Percentage is left blank, the system will insert 0.00.

 

TM_RT_ORDER.CSV - Define Rate Sequence (Projects » Project Setup » Revenue Setup)

Column No

Column Name

Costpoint     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

 

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

 

 

 

CEIL_DIR_CST.CSV - Project Direct Cost Ceilings (Projects » Project Setup » Project Ceilings)

Column No

Column Name

Costpoint     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

 

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

Ceiling Amount

Number

10

R

I

 

 

CEIL_DIR_HRS.CSV – Project Hours Ceilings (Projects » Project Setup » Project Ceilings)

Column No

Column Name

Costpoint     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

 

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 – Project Burden Cost Ceilings (Projects » Project Setup » Project Ceilings)

Column No

Column Name

Costpoint     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

 

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

10

R

I

 

8

CEIL_COM_RT

COM Ceiling

Number

10

R

I

 

9

ACCT_ID

Account

Character

15

R

I

 

 

EMPL_CEIL.CSV -Project Employee Hours Ceilings (Projects » Project Setup » Project Ceilings)

Column No

Column Name

Costpoint 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

 

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

10

R

I

 

 

VEND_CEIL.CSV - Project Vendor Hours Ceilings (Projects » Project Setup » Project Ceilings)

Column No

Column Name

Costpoint    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

 

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

10

R

I

 

 

PROJ_BILL_INFO_SCH.CSV - Project Billing Info screen (Projects»Billing»Billing Master) - Supporting Schedule Headers (Detail Bills) Subtask

Column No

Column Name

Costpoint    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

 

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

 

Character

6

O

 

 

 

OVRIDE_MLT_ON_DIR.CSV - Maintain Multiplier Overrides (Projects » Project Setup » Revenue Setup)

Column No

Column Name

Costpoint    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

 

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

R

I

 

6

S_RBA_CD

Apply to (RGBA)

Character

1

R

I

R, B, G, or A

 

OVRIDE_FEE_ON_DIR.CSV - Maintain Cost Fee Overrides (Projects » Project Setup » Revenue Setup)

Column No

Column Name

Costpoint 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

 

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

O

I

0 - 1

6

OVRIDE_FEE_HRS _AMT

Fee on Hours

Number

14,4

O

I

 

 

OVRIDE_FEE_ON_BURD.CSV – Maintain Burden Fee Overrides (Projects » Project Setup » Revenue Setup)

Column No

Column Name

Costpoint     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

 

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

R

I

0 - 1

 

EMPL_PROJ_TS_DFLT.CSV - Employee Project TS Defaults (People » Labor » Timesheet Default)

Column No

Column Name

Costpoint     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

 

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 - Labor-Grp Project-Acct-Grp TS Defaults (People » Labor » Timesheet Default)

Column No

Column Name

Costpoint     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

 

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 - Employee Project-Acct-Grp TS Defaults (People » Labor » Timesheet Default)

Column No

Column Name

Costpoint     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

 

Character

20

R

I

 

2

EMPL_ID

Employee

Character

12

R

I

 

3

ACCT_GRP_CD

Project Account Group

Character

3

R

I

 

 

ACCT_GRP_CD

 

 

 

 

 

 

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 - Project TS Defaults (People » Labor » Timesheet Default)

Column No

Column Name

Costpoint     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

 

Character

20

R

I

 

2

DFLT_PROJ_ID

 

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_RPT_ID.CSV - Alternate Reporting (Projects » Project Setup)

Column No

Column Name

Costpoint     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

 

Character

20

R

I

 

2

PROJ_RPT_ID

Project Report

Varchar

30

R

I

 

 

PROJ_RPT_DESC

Project Report Description

Varchar

25

R

I

 

3

MODIFIED_BY

 

Varchar2

18

D

 

The ID of the user that imports the data

4

TIME_STAMP

 

Date

7

D

 

System date and time of import

5

ROWVERSION

 

Number

22

D

 

Input zero

 

TOP_LVL_RPT.CSV - Alternate Reporting (Projects » Project Setup)

Column No

Column Name

Costpoint     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

 

Character

20

R

I

 

2

PROJ_RPT_ID

Project Report

Varchar

30

R

I

 

3

LVL_NO

Level Number

Smallint

 

R

I

 

4

LVL_DESC

Level Description

Varchar

30

R

I

 

5

LVL_LEN_NO

Level Length

Smallint

 

R

I

 

6

MODIFIED_BY

 

Varchar2

18

D

 

ID of the user that imports the data

7

TIME_STAMP

 

Date

7

D

 

System date and time of import

8

ROWVERSION

 

Number

22

D

 

Input zero

 

PROJ_RPT_PROJ.CSV - Alternate Reporting (Projects » Project Setup) - Link Projects subtask

 

Column No

Column Name

Costpoint     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

 

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

 

5

MODIFIED_BY

 

Varchar2

18

D

 

ID of the user that imports the data

6

TIME_STAMP

 

Date

7

D

 

System date and time of import

7

ROWVERSION

 

Number

22

D