Input File Information

Input File Templates

Download the template CSV file (PRPPREP_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 will not read the first row.

PROJ.CSV - Basic Project Information

Column No	Column Name	Field Name	Type Data	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 Mods

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 Revenue Info

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	Y,N
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

PROJ_BILL_INFO.CSV - Project Bill Info

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

PROJ_CUST_SETUP.CSV - Project Bill Info - 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
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 - Proj/Acct/Orgs

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 - Govt Contract

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

PROJ_WAWF_INFO – Project WAWF Information

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 - Project Labor Categories

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 PLCs

Column No	Column Name	Costpoint Field Name	Data Type		"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 - Empl Work Force

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 - Vend Work Force

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

PROJ_VEND_EMPL.CSV - Project Vendor Employee Work Force

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
	VEND_EMPL_ID	Vendor Employee	Character	12	R	I

PROJ_EMPL_LAB_CAT.CSV - Assign PLC to Employee Work Force

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	BILL_LAB_CAT_CD	PLC	Character	6	R	I
5	DFLT_FL	Default PLC	Character	1	R	I

PROJ_VEND_LAB_CAT.CSV - Assign PLC to Vendor Work Force

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	BILL_LAB_CAT_CD	PLC	Character	6	R	I
5	DFLT_FL	Default PLC	Character	1	R	I

PROJ_VEND_EMPL_PLC.CSV - Assign PLC to Vendor Employee Work Force

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
5	BILL_LAB_CAT_CD	PLC	Character	6	R	I
6	DFLT_FL	Defaults	Character	1	R	I

PROJ_LAB_CAT_MAP.CSV - Linked GLCs

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_SCH.CSV - Project PLC Rates

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

PROJ_EMPL_RT_SCH.CSV - Empl/Vend PLC Rates

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.

LAB_CAT_RT_SCH.CSV - Project Labor Categories - 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	PLC	Character	6	R	I
3	BILL_RT_AMT	Rate	Character	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.

TM_RT_ORDER.CSV - Def Rate Seq

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	Sequence	Number	10	R	I
5	SRCE_PROJ_ID	Source Project	Character	30	O

CEIL_DIR_CST.CSV - Dir Cost Ceil

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 R/B/A	Character	10	R	I	R, B, A, N
5	CEIL_AMT	Ceiling Amount	Number	10	R	I

CEIL_DIR_HRS.CSV Dir Hours Ceil

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	Character	10	R	I

CEIL_BURDEN_CST.CSV Burd Cost Ceil

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 R/B/A	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 Method	Number	10	R	I
9	ACCT_ID	Account	Character	15	R	I

EMPL_CEIL.CSV - Empl Hour Ceil

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 - Vend Hour Ceil

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 Bill Info - Detail Levels 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 Name (Invoice)	Character	30	R	I
4	SPPRT_SCH_ FRMT_CD		Character	6	O

OVRIDE_MLT_ON_DIR.CSV - Mult Ovrd

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	IS_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 R/G/B/A	Character	1	R	I	R, B, G, or A

OVRIDE_FEE_ON_DIR.CSV - Cost Fee Ovrd

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 R/B/A	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,8	O	I

OVRIDE_FEE_ON_BURD.CSV Burd Fee Ovrd

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 R/B/A	Character	1	R	I	R.B,A
6	OVRIDE_FEE_ RT	Fee Percent	Number	10	R	I	0 - 1

EMPL_PROJ_TS_DFLT.CSV - Employee Project TS Defaults

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

LAB_ACCT_GRP_DFLT.CSV - Labor-Grp Project-Acct-Grp TS Defaults

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

EMPL_ACCT_GRP_DFLT.CSV - Employee Project/Account Group Timesheets

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
4	ACCT_ID	Account	Character	15	O
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

PROJ_TS_DFLT.CSV - Project Timesheet Defaults

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	Employee	Character	30	O
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	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

PROJ_RPT_ID.CSV - Alternate Reporting

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

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

ERROR MESSAGES AND VALIDATION DETAIL

Error Messages

Table Name	Costpoint Screen Name	Column Name	Costpoint Field Name	Error Message(s)	Error Message Help
PROJ	Basic Project Information	USER_ID		User ID is required	Verify that a User ID exists in the input file.
PROJ	Basic Project Information	USER_ID		User ID is invalid	Determine that the User ID has been set up in the database and in the Users screen (Administration\Maintain\User).
PROJ	Basic Project Information	DFLT_PROJ_ID		Project ID is invalid	Confirm that the Project ID exists in the Basic Project Information screen (Project\Maintain\Project User Flow).
PROJ	Basic Project Information	PROJ_ID	Project	Invalid Project ID, no further validation	Validate the format of the project ID. The Project ID should consist of whole numbers and/or letters separated by a period. Symbols and spaces are not allowed.
PROJ	Basic Project Information	PROJ_ID	Project	Top Level Project Length is Invalid	Determine whether the length of the top-level project is equal to the segment length defined for level one in the Project Settings screen.
PROJ	Basic Project Information	PROJ_ID	Project	Project Structure is Invalid	Verify that all project levels have segment lengths consistent with the project structure entered in the Project Levels subtask in the Project User Flow (Projects\Maintain\Projects). For example, a project has a top level identified as "1000," the first second level is identified as "1000.001," and the next second level project is identified as "1000.02." This is invalid because the second level of the project must be equal in length.
PROJ	Basic Project Information	PROJ_ID	Project	Parent project does not exist	Ensure that all parent projects exist. The related upper level project must exist if lower levels of that project are in the input file.
PROJ	Basic Project Information	PROJ_ID	Project	Project ID is required	Confirm that the Project ID exists in the input file.
PROJ	Basic Project Information	PROJ_ID	Project	Project already exists	Check for duplicate project IDs in the Basic Project Information screen (Projects\Maintain\Projects), or in the PROJ.CSV file. Each project ID must be unique in the database.
PROJ	Basic Project Information	PROJ_TYPE_DC	Project Type	Project Type is required	Verify the existence of the Project Type. If a default project has not been assigned, the Project Type must exist in the input file.
PROJ	Basic Project Information	PROJ_TYPE_DC	Project Type	Proj Type is invalid	Validate the Project Type in the input file. The Project Type in the input file must exist in the Project Types screen.
PROJ	Basic Project Information	PROJ_NAME	Name	Project Name is required	Ensure that the Project Name is in the input file.
PROJ	Basic Project Information	BILL_PROJ_FL	Billable Project	Billable Flag is invalid.	Confirm that the Billable Flag is "Y" or "N."
PROJ	Basic Project Information	ORG_ID	Owning Organization	Owning Organization is required	Verify the existence of the Owning Organization in the input file. If a default project is assigned to the project, then the Owning Organization is determined by the default project .
PROJ	Basic Project Information	ORG_ID	Owning Organization	Owning Organization is invalid	Validate the Owning Organization from the input file in the Organization Structures and Organization Elements screens.
PROJ	Basic Project Information	CEIL_F_CST_ RBA_CD	Funding Info, Cost Ceiling Code	Ceiling Code is invalid.	Verify the Funded Cost Ceiling Code is valid. Valid Ceiling Codes are "R" (Revenue), "B" (Billing), "A" (Both Revenue and Billing), and "N" (None).
PROJ	Basic Project Information	CEIL_F_FEE_ RBA_CD	Funding Info, Fee Ceiling Code	Ceiling Code is invalid.	Verify the Funded Fee Ceiling Code is valid. Valid Ceiling Codes are "R" (Revenue), "B" (Billing), "A" (Both Revenue and Billing), and "N" (None).
PROJ	Basic Project Information	CEIL_F_TOT_ RBA_CD	Funding Info, Total Ceiling Code	Ceiling Code is invalid.	Verify the Funded Total Ceiling Code is valid. Valid Ceiling Codes are "R" (Revenue), "B" (Billing), "A" (Both Revenue and Billing), and "N" (None).
PROJ	Basic Project Information	CEIL_V_CST_ RBA_CD	Value Info, Cost Ceiling Code	Ceiling Code is invalid.	Verify the Contract Value Cost Ceiling Code is valid. Valid Ceiling Codes are "R" (Revenue), "B" (Billing), "A" (Both Revenue and Billing), and "N" (None).
PROJ	Basic Project Information	CEIL_V_FEE_ RBA_CD	Value Info, Fee Ceiling Code	Ceiling Code is invalid.	Verify the Contract Value Fee Ceiling Code is valid. Valid Ceiling Codes are "R" (Revenue), "B" (Billing), "A" (Both Revenue and Billing), and "N" (None).
PROJ	Basic Project Information	CEIL_V_TOT_ RBA_CD	Value Info, Total Ceiling Code	Ceiling Code is invalid.	Verify the Contract Value Total Ceiling Code is valid. Valid Ceiling Codes are "R" (Revenue), "B" (Billing), "A" (Both Revenue and Billing), and "N" (None).
PROJ	Basic Project Information	EMPL_ID	Project Manager (ID)	Project Manager is invalid	Validate the Employee ID in the input file. The Employee ID must exist in the Employee Info screen.
PROJ	Basic Project Information	CUST_ID	Customer	Customer is invalid.	Confirm that the Customer identified in the input file exists in the Customers (Accounting\Maintain\Customers) screen.
PROJ	Basic Project Information	S_PROJ_RPT_ DC	Project Classification	Project Classification is required.	Determine that a Project Classification exists for all projects in the input file. If you have assigned a default project, the project classification is automatically included in the data.
PROJ	Basic Project Information	S_PROJ_RPT_ DC	Project Classification	Project Classification is invalid.	Validate the Project Classification in the input file. Valid classifications are BID & PROPOSAL, COMMON INV, DIRECT PROJECT, INDIRECT, INTER-CO MULTI, INTER-COMPANY, IR&D, and WORK IN PROCESS. These are predefined in the system.
PROJ	Basic Project Information	PROJ_WORK_ FRC_FL	Project Work Force Required	Project Work Force Required Flag is invalid.	Ensure that the Project Work Force Required flag is set to either "Y" or "N."
PROJ	Basic Project Information	ACCT_GRP_CD	Account Group	Project Account Group is required	Determine whether a valid project account group is included in the input file for each project.
PROJ	Basic Project Information	ACCT_GRP_CD	Account Group	Project Account Group is invalid.	Validate the Project Account Group in the input file. Project account groups are set up in the Project Account Groups screen.
PROJ	Basic Project Information	PROJ_ABBRV_ CD	Project Abbreviation	Project Abbreviation is already used for another project	Verify that the value in the Project Abbreviation field is unique system-wide. Project Abbreviations are set up in the Basic Project Information screen.
PROJ	Basic Project Information	ACTIVE_FL	Active	Active Flag is invalid	Determine that the Active Flag is "Y" or "N."
PROJ	Basic Project Information	ACCT_GRP_FL	Account Group - Allow Edit	Account Group - Allow Edit is invalid	Determine that the Account Group - Allow Edit flag is "Y "or "N."
PROJ	Basic Project Information	PROJ_RPT_DC_FL	Project Classification - Allow Edit	Project Classification - Allow Edit is invalid	Determine that the Project Classification - Allow Edit flag is "Y" or "N."
PROJ	Basic Project Information	PROJ_TYPE_FL	Project Type - Allow Edit	Project Type - Allow Edit is invalid	Determine sure that the Project Type - Allow Edit flag is "Y" or "N."
PROJ	Basic Project Information	ORG_ID_FL	Owning Organization - Allow Edit	Owning Organization - Allow Edit is invalid	Determine that the Owning Organization - Allow Edit flag is "Y" or "N."
PROJ	Basic Project Information	EMPL_ID_FL	Project Manager - Allow Edit	Project Manager - Allow Edit is invalid	Determine that the Project Manager - Allow Edit flag is "Y" or "N."
PROJ	Basic Project Information	CUST_ID_FL	Customer - Allow Edit	Customer - Allow Edit is invalid	Determine that the Customer - Allow Edit flag is "Y" or "N."
PROJ	Basic Project Information	FUND_SRCE_FL	Funding Source - Allow Edit	Funding Source - Allow Edit is invalid	Determine that the Funding Source - Allow Edit flag is "Y" or "N."
PROJ	Basic Project Information	PRIME_CONTR_FL	Prime Contract No - Allow Edit	Prime Contract No - Allow Edit is invalid	Determine that the Prime Contract No - Allow Edit flag is "Y" or "N."
PROJ	Basic Project Information	SUB_CONTR_FL	Subcontractor No - Allow Edit	Subcontractor No - Allow Edit is invalid	Determine that the Subcontractor No - Allow Edit flag is "Y" or "N."
PROJ	Basic Project Information	PO_NO_FL	Purchase Order No - Allow Edit	Purchase Order No - Allow Edit is invalid	Determine that the Purchase Order No - Allow Edit flag is "Y" or "N."
PROJ	Basic Project Information	DMS_DPS_FL	DPAS Purchasing Rating - Allow Edit	DPAS Purchasing Rating - Allow Edit is invalid	Determine that the DPAS Purchasing Rating - Allow Edit is "Y" or "N."
PROJ	Basic Project Information	ICS_FL	Incurred Cost Submission Code - Allow Edit	Incurred Cost Submission Code - Allow Edit is invalid	Determine that the Incurred Cost Submission Code - Allow Edit is "Y" or "N."
PROJ	Basic Project Information	CONTR_ST_ MMDD_FL	Contract Year - Allow Edit	Contract Year - Allow Edit is invalid	Determine that the Contract Year - Allow Edit is "Y" or "N."
PROJ	Basic Project Information	COM_FL	Apply Cost of Money Rates - Allow Edit	Apply Cost of Money Rates - Allow Edit is invalid	Determine that the Apply Cost of Money Rates - Allow Edit is "Y" or "N."
PROJ	Basic Project Information	CAS_FL	CAS Covered	CAS Covered is invalid	Determine that the CAS Covered flag is "Y" or "N."
PROJ	Basic Project Information	EDIT_WORK_ FRC_FL	Project Work Force Required - Allow Edit	Project Work Force Required - Allow Edit is invalid	Determine that the Project Work Force Required - Allow Edit flag is "Y" or "N."
PROJ	Basic Project Information	DFLT_ORG_ ENTRY_FL	Default to Owning Org	Default to Owning Org Flag is invalid	Determine that the Default to Owning Org flag is "Y" or "N."
PROJ	Basic Project Information	DFLT_ORG_ ENTRY_FL	Default to Owning Org	Must be "N" when Allow Charging is set to "N."	The default to Owning Org flag must be set to "N" if the Allow Charging Flag is set to "N."
PROJ	Basic Project Information	TOP_LVL_WRK_FRC_FL	Use Top Level Work Force	Use Top Level Work Force Flag is invalid	Ensure that the Use Top Level Work Force field contains a value of "Y" or "N" in the input file.
PROJ	Basic Project Information	ALLOW_ CHARGES_FL	Allow Charging	Allow Charging Flag is invalid	Ensure that the Allow Charging field contains a value of "Y" or "N" in the input file.
PROJ	Basic Project Information	LIMIT_ORGS_ FL	Limit Orgs	Limit Orgs Flag is invalid	Verify that the Limit Orgs field contains a value of "Y" or "N" in the input file.
PROJ	Basic Project Information	LIMIT_ORGS_ FL	Limit Orgs	Limit Orgs Flag must be "N" when Validating by Orgs is turned off	You cannot set this field to "Y" in the input file if the Validate Project Charging by Organizations checkbox is unchecked in the Project Settings screen.
PROJ	Basic Project Information	LIMIT_ORGS_ FL	Limit Orgs	Must be "N" when Allow Charging is set to "N."	Verify that the Limit Orgs flag is set to "N" if the Allow Charging flag is set to "N."
PROJ	Basic Project Information	LIMIT_ACCTS_FL	Limit Accounts	Limit Accounts Flag is invalid	Verify that the Limit Accounts field contains a value of "Y" or "N."
PROJ	Basic Project Information	LIMIT_ACCTS_FL	Limit Accounts	'Must be 'N' when Allow Charging is set to 'N'	Verify that the Limit Accounts checkbox is set to "N" if the Allow Charging checkbox is set to "N."
PROJ	Basic Project Information	LIMIT_AO_FL	Limit which orgs can charge specific Accts	Limit which orgs can charge specific Accts Flag is invalid	Verify that the Limit Which Orgs Can Charge Specific Accts field contains a "Y" or "N" in the input file.
PROJ	Basic Project Information	LIMIT_AO_FL	Limit which orgs can charge specific Accts	Limit which orgs can charge specific Accts Flag is invalid	Verify that the Limit Which Orgs Can Charge Specific Acct's field in the input file is set to "Y" only if both the Limit Accounts and Limit Orgs Fields are set to "N" in the input file.
PROJ	Basic Project Information	LIMIT_AO_FL	Limit which orgs can charge specific Accts	Must be "N" when Allow Charging is set to "N."	Verify that the Limit Which Orgs Can Charge Specific Accts field contains a value of "N" if the value in the Allow Charging field is "N" in the input file.
PROJ	Basic Project Information	COM_APPLIC_ FL	Apply Cost of Money Rates	Apply Cost of Money Rates flag is invalid	Verify that the Apply Cost of Money Rates field in the input file contains a value of "Y" or "N."
PROJ	Basic Project Information	PURGED_FL	Purged	Flag is invalid	Verify that the Purged field in the input file contains a value of "Y" or "N."
PROJ	Basic Project Information	MAIL_STATE_ DC	State/Province	State/Province is invalid.	Validate the State/Province Code field in the input file. The value entered in this field should exist in the States and Provinces screen (Administration\Maintain\Codes).
PROJ	Basic Project Information	POSTAL_CD	Zip Code	Postal Code is invalid.	Validate the Postal Code field in the input file. The value entered must exist in the Postal Codes screen (Administration\Maintain\Codes).
PROJ	Basic Project Information	COUNTRY_CD	Country	The Country Code is invalid	Validate the Country Code field in the input file. The value entered must exist in the States and Provinces screen (Administration\Maintain\Codes).
PROJ	Basic Project Information	COUNTRY_CD	Country	Country Code is Required	Verify that a valid Country Code exists in the input file if a State Code is assigned.
PROJ	Basic Project Information	COUNTRY_CD	Country	Country Code/State Code combination is invalid	Verify that a valid Country Code and State Code fields exist in the States and Provinces (Administration\Maintain\Codes) screen.
PROJ	Basic Project Information	LW_DOC_CD	Lien Waiver Doc Code	The Lien Waiver Document Code is invalid	Validate the Waiver Doc Code field in the input file. The Waiver Doc Code must exist in the Lien Waiver Document Names screen.
PROJ	Basic Project Information	TC_PROJ_FL	Export Project	Export Project Classification is required	Export Project Classification must be "T," "E," "B," or "N."
PROJ	Basic Project Information	TC_PROJ_FL	Export Project	Export Project Flag must be ‘T’, ‘E’, ‘B’, or ‘N’	Make sure that the Export Project Flag is set to "T," "E," "B," or "N."
PROJ	Basic Project Information	COBRA_WBS	Cobra Mapping Value	The Cobra Mapping Value exceeds the maximum number of characters allowed	Make sure that the Cobra Mapping Value in the input file does not have more than 59 characters.
PROJ	Basic Project Information	COBRA_FL	Cobra Project Flag	The Cobra Project Flag must be 'Y' or 'N'	Make sure that the Cobra Project Flag is set to "Y" or "N" in the input file.
PROJ	Basic Project Information	COBRA_FL	Cobra Project Flag	The Cobra Project Flag is required	Verify that there is a value for the Cobra Project Flag in the input file. The value must be "Y" or "N."
PROJ_MOD	Mods	USER_ID		User ID is not valid	Validate the User ID field in the input file. The value for the User ID field must exists in the Users screen (Administration\ Maintain\User).
PROJ_MOD	Mods	PROJ_ID	Project	Project ID does not exist	Verify the Project ID in the input file. The Project ID must exist in the Basic Project Information screen (Projects\Maintain\Projects\Project User Flow) or the PROJ.CSV file.
PROJ_MOD	Mods	PROJ_END_DT	Period of Performance End Date	The End Date must be greater than the Start Date	Verify that the End Date field is later than the Start Date field.
PROJ_MOD	Mods	PROJ_V_CST_ AMT	Value Modifications - Cost Contract Value	Cost is required	Verify that an amount exists for the Contract Value Cost field exists in the input file.
PROJ_MOD	Mods	PROJ_V_FEE_ AMT	Value Modifications - Fee % Contract Value	Fee is required	Verify that an amount exists for the Contract Value Fee field exists in the input file.
PROJ_MOD	Mods	PROJ_F_CST_ AMT	Funding Modifications - Cost Funded Value	Cost is required	Verify that an amount exists for the Funded Value Cost field in the input file.
PROJ_MOD	Mods	PROJ_F_FEE_ AMT	Funding Modifications - Fee % Funded Value	Fee is required	Verify that an amount exists for the Funded Value Fee field in the input file.
PROJ_MOD	Mods	PROJ_MOD_ID	ID	Modification ID already exists for this project.	Verify that the Modification ID is does not already exist for this project in the Mods (Projects\Maintain\Projects\Project User Flow) screen or elsewhere in the PROJ_MOD.CSV file.
PROJ_MOD	Mods	DELIV_UNITS_QTY	Number of Units to Deliver	Number of Units to Deliver is required	Verify that the Number of Units to Deliver field contains an amount. The input file should contain a zero if there are no units to deliver for this modification.
PROJ_MOD	Mods	EST_UNIT_CST_AMT	Estimated Cost Per Unit	Estimated Cost per Unit is required	Verify that the Estimated Cost Per Unit field contains a zero. The field should contain a zero if there is no estimated cost per unit for this modification.
PROJ_MOD	Mods	UNIT_PRICE_ AMT	Price Per Unit	Price per Unit is required	Verify that the Price Per Unit field contains a value. This field will contain a zero if there is no price per unit for this modification.
PROJ_MOD	Mods	UNIT_PRICE_ AMT	Price Per Unit	The Price per Unit cannot be negative	Verify that the Price per Unit field contains a positive number.
PROJ_MOD	Mods	CLIN_ID	CLIN	CLIN ID is invalid.	Validate the CLIN ID field entered for this project. The CLIN ID entered must exist in the CLINs subtask of the Basic Project Information screen (Projects\Maintain\Projects\Project User Flow).
PROJ_MOD	Mods	EFFECT_DT	Effective Date	Effective Date is Required	Confirm that the Effective Date field exists in the input file or the Default Project.
PROJ_REV_ SETUP	Revenue Info	USER_ID		User ID is not valid	Verify that the User ID in the input file exists in the Users screen (Administration\Maintain \Users).
PROJ_REV_ SETUP	Revenue Info	DFLT_PROJ_ID		Project ID is invalid	Validate the Default Project ID in the input file. The Default Project ID must exist in the Revenue Information subtask of the Basic Project Information screen (Projects\Maintain\Projects\Project User Flow).
PROJ_REV_ SETUP	Revenue Info	PROJ_ID	Project	Project ID is invalid	Validate the Project ID field in the input file. The Project ID must exist in either the Basic Project Information screen (Projects\Maintain\Projects\Project User Flow) or the PROJ.CSV file.
PROJ_REV_ SETUP	Revenue Info	PROJ_ID	Project	Revenue is already set up for this project at this or another level.	Determine that the Project ID does not already exist at any level of the project in the Revenue Information subtask of the Basic Project Information screen (Projects\Maintain\Projects\Project User Flow).
PROJ_REV_ SETUP	Revenue Info	PROJ_ID	Project	Only Billable Projects may have Revenue Setup	Verify that the Billable Project field contains a value in the input file in the Project Basic Information screen (Projects\Maintain\Projects\Project User Flow), or is set to "Y" in the PROJ.CSV file.
PROJ_REV_ SETUP	Revenue Info	S_REV_ FORMULA_CD	Revenue Formula	Revenue Formula is not valid	Validate the Revenue Formula Code field in the input file. (See the "Revenue Formula Validation Detail" section.)
PROJ_REV_ SETUP	Revenue Info	AT_RISK_FL	Allow Revenue to Exceed Value	At Risk Flag is invalid	Verify that the At Risk field in the input file contains a "Y" or "N."
PROJ_REV_ SETUP	Revenue Info	AT_RISK_AMT	By How Much?	At Risk amount must be zero if At Risk Flag is set to "N."	Ensure that the At Risk Amount field contains a value of zero if At Risk Flag is set to "N."
PROJ_REV_ SETUP	Revenue Info	REV_CALC_ AMT	(The name changes depending on the revenue formula. See the "Revenue Formula Validation Detail" section.)	Calc Amt must be zero for this Revenue Formula	Verify that the Calc Amount field is appropriate for the Revenue Formula assigned to this project (See the "Revenue Formula Validation Detail" section.)
PROJ_REV_ SETUP	Revenue Info	REV_TO_OWN_ORG_FL	Post Revenue to the Owning or Performing	Organization Owning or Performing Org Flag is invalid	Make sure that the Post Revenue to owning or performing organization field is valid. Valid entries are "O" (Owning) and "P" (Performing).
PROJ_REV_ SETUP	Revenue Info	UNITS_FL	Calculate Revenue on Units	Units Flag must be N for this Revenue Formula	Verify that the Calculate Revenue on Units field is valid for the Revenue Formula assigned. (See the "Revenue Formula Validation Detail" section.)
PROJ_REV_ SETUP	Revenue Info	REV_CALC1_ AMT	(The name changes based on the revenue formula. See the "Revenue Formula Validation Detail" section.)	Calc1 Amt must be zero for this Revenue Formula	Verify that the Calc1 Amount field is appropriate for the Revenue Formula assigned to this project. (See the "Revenue Formula Validation Detail" section.)
PROJ_REV_ SETUP	Revenue Info	REV_CALC2_ AMT	(The name changes based on the revenue formula. See the "Revenue Formula Validation Detail" section.)	Calc2 Amt must be zero for this Revenue Formula	Verify that the Calc2 Amount field is appropriate for the Revenue Formula assigned to this project. (See the "Revenue Formula Validation Detail" section.)
PROJ_BILL_ INFO	Project Bill Info	USER_ID		User ID is not valid	Validate the User ID field in the input file. The User ID must be established in the Users screen (Administration\Maintain\Users).
PROJ_BILL_ INFO	Project Bill Info	DFLT_PROJ_ID		Project ID does not exist	Ensure that the Default Project ID field exists in the input file or the Basic Project Information screen (Projects\Maintain\Projects\Project User Flow).
PROJ_BILL_ INFO	Project Bill Info	INVC_PROJ_ID	Project	Project ID does not exist	Validate that the project ID exists in either the Basic Project Information screen (Projects\Maintain\Projects\Project User Flow) or the PROJ.CSV file.
PROJ_BILL_ INFO	Project Bill Info	INVC_PROJ_ID	Project	Project does not exist in the PROJ_CUST_SETUP.CSV file.	Determine that at least one customer is identified for every new project added to the Project Bill Information (Projects\Maintain\Projects\Project User Flow) screen. Verify that this project exists at least once in the PROJ_CUST_SETUP.CSV file.
PROJ_BILL_ INFO	Project Bill Info	INVC_PROJ_ID	Project	Invoice Project already exists	Ensure that the invoice project does not already exist in the Project Bill Information (Projects\Maintain\Projects\Project User Flow) screen or in the PROJ_BILL_INFO.CSV file.
PROJ_BILL_ INFO	Project Bill Info	INVC_PROJ_ID	Project	This Project is not Billable	Verify that the Billable Project checkbox is selected for this project in the Basic Project Information screen (Projects\Maintain\Projects\Project User Flow), or is set to "Y" in the PROJ.CSV file.
PROJ_BILL_ INFO	Project Bill Info	INVC_PROJ_ID	Project	Billing is already setup at another level of the project	Verify that the invoice project has not already been set up at another level of the project.
PROJ_BILL_ INFO	Project Bill Info	S_BILL_ FORMULA_CD	Formula	Billing Formula is not Valid	Verify that the Billing Formula Code is valid. (See the "Billing Formula Validation Detail" section.)
PROJ_BILL_ INFO	Project Bill Info	S_BILL_ FORMULA_CD	Formula	Billing formula must be "1443"	Verify that the Billing Formula is consistent with the format. If the format is for "1443," the formula must be "1443."
PROJ_BILL_ INFO	Project Bill Info	BILL_CALC_ AMT	(The name changes depending on the billing formula. See the "Billing Formula Validation Detail" section.)	Calc Amt must be zero for this Billing Formula	Verify that the calc amount is appropriate for the Billing Formula assigned to this project. (See the "Billing Formula Validation Detail" section.)
PROJ_BILL_ INFO	Project Bill Info	CASH_BASIS_ FL	Bill Cost Incurred on Cash Basis	Cash Basis Flag is invalid	Ensure that the Cash Basis checkbox in the input file is set to "Y" or "N."
PROJ_BILL_ INFO	Project Bill Info	S_RTNGE_ BASIS_CD	Retainage - Basis for Calculation	Retainage Basis is invalid	Verify that the Basis for Retainage field contains a value of TOT, FEE, or HRS in the input file.
PROJ_BILL_ INFO	Project Bill Info	RTNGE_PCT_RT	Retainage - Percentage	Retainage Percent is required	Verify that the Retainage Percent field contains a value in the input file.
PROJ_BILL_ INFO	Project Bill Info	CUST_TERMS_KEY		Customer Terms Key is invalid	Verify that the Customer Terms Key exists in the CUST_TERMS table. To view valid Customer Terms Keys and their descriptions, execute the following script in SQLTALK:SELECT CUST_TERMS_KEY, CUST_TERMS_DC FROM CUST_TERMS;
PROJ_BILL_ INFO	Project Bill Info	INCM_STATE_ CD	Income State	Income State is invalid	Verify that the Income State field contains a value in the input file that exists in the STATE table. The State Codes are predefined and cannot be changed. To view valid Income State Codes and their descriptions, execute the following script in SQLTALK:SELECT STATE_CD, STATE_NAME FROM STATE;
PROJ_BILL_ INFO	Project Bill Info	BILL_CYCLE_ CD	Billing Cycle	The Billing Cycle is Required	Verify that a valid Billing Cycle exists in the input file or the default project. This field is required if the Use Billing Cycles checkbox is selected in the Billing Settings screen.
PROJ_BILL_ INFO	Project Bill Info	BILL_CYCLE_ CD	Billing Cycle	Billing Cycle is invalid	Determine that the Billing Cycle code in the input file has been set up in the Billing Cycles screen.
PROJ_BILL_ INFO	Project Bill Info	BILL_GRP_CD	Billing User Group	The User Group is Required	Verify the a Billing User Group code exists in the input file if the Assign Bills to User Groups checkbox is selected in the Billing Settings screen.
PROJ_BILL_ INFO	Project Bill Info	BILL_GRP_CD	Billing User Group	Billing User Group is invalid	Verify that the Billing Group in the input file exists in the Billing User Groups screen.
PROJ_BILL_ INFO	Project Bill Info	BILL_FRMT_CD	Generic Billing Format	Generic Format Code is required	Determine that a Generic Format Code exists in the input file when the Generic Billing Format Type field is set to "Generic."
PROJ_BILL_ INFO	Project Bill Info	BILL_FRMT_CD	Generic Billing Format	Billing Format Code is invalid	Verify that the Billing Format entered in the input file has been set up in the Generic Billing Formats screen (Projects\Maintain\Billing).
PROJ_BILL_ INFO	Project Bill Info	BILL_FRMT_CD	Generic Billing Format	Generic Format Code is not allowed.	Verify that a Generic Format Code exists in the input file only when the Generic Billing Format Type is "Generic."
PROJ_BILL_ INFO	Project Bill Info	SPPRT_SCH_ FRMT_CD	Supporting Schedule Format	Supporting Schedule does not exist	Verify that the Billing Supporting Schedule entered in the input file has been set up in the Supporting Schedule Formats screen.
PROJ_BILL_ INFO	Project Bill Info	PARTL_BILL_ TRN_FL	Allow Transactions To Be Partially Billed	Allow Transactions to be Partially Billed Flag is invalid	Verify that the Allow Transactions to be Partially Billed field contains "Y" or "N" in the input file.
PROJ_BILL_ INFO	Project Bill Info	S_WHEN_ RETAIN_CD	Retainage - Withhold On	Retainage - Withhold On basis is required	Verify that the Withhold On field contains a value in the input file if the Retainage - Basis for Calculation field is set to "Y." Valid values for the Withhold On field are: "EACH," "FINAL" (Final Based on Contract Value), and "FINALF" (Final Based on Funded Value).
PROJ_BILL_ INFO	Project Bill Info	ALLOW_USER_EDIT_FL	Allow User to Edit Bills	Allow User to Edit Bills Flag is invalid	Verify that the Allow User to Edit Bills field is set to "Y" or "N" in the input file.
PROJ_BILL_ INFO	Project Bill Info	S_1035_TYPE	Government 1035 Format Information - Print Cost Plus/Fixed Price Format or Print	Using T&M Format Format Type is Required	Confirm that the Format Type field contains a value in the input file if the Billing Format code is 1035. Valid entries for the Format Type field are: "CP" (Print Cost Plus or Fixed Price Format) and "TM" (Print Using T&M Format).
PROJ_BILL_ INFO	Project Billing Info	ACCT_LVL_ 1035_NO	Roll Up Accounts to Level	Rollup Account Level Number is Required	Verify the a level number of "1" to "8" in the Account level box if the Billing Format entered in the input file is 1035.
PROJ_BILL_ INFO	Project Billing Info	S_BILL_FRMT_TYPE	Format	Format Type does not exist	Validate the Billing Format Type field in the input file. Valid entries are "1035" (Govt 1035), "GENRIC" (Generic) and "1443" (Govt 1443).
PROJ_BILL_ INFO	Project Billing Info	BILL_RMT_ ADDR_CD	Remittance Address	Remittance Address Code does not exist	Verify that the Remittance Address field in the input file exists in the Remittance Addresses screen (Projects\Maintain\Billings).
PROJ_BILL_ INFO	Project Billing Info	BILL_PMT_ ADDR_CD	Payment Office	Payment Office Code does not exist	Verify that the Remittance Address field in the input file exists in the Government Payment Offices screen.
PROJ_BILL_ INFO	Project Bill Info	S_INVT_BILL_ CD	Bill Inventory Issues As (Cost, Units, Accounts)	Bill Inventory Code is not valid	Verify that the Bill Inventory Code is valid. Valid entries are "C" (Cost), "U" (Units), and "A" (Account).
PROJ_BILL_ INFO	Project Bill Info	PRICE_CATLG_CD	Catalog	Price Catalog does not exist	Verify that the Price Catalog has been set up in the Price Catalogs screen (Materials\Maintain\Price Catalogs).
PROJ_BILL_ INFO	Project Bill Info	PRICE_CATLG_CD	Catalog	Catalog is not allowed	Ensure that the Catalog field is in the input file only if the Units or Account radio button is selected. These radio buttons are in the Bill Inventory Issues As group box of the Other Info subtask in the Project Billing Information screen (Projects\Maintain\Billing).
PROJ_BILL_ INFO	Project Bill Info	CLIN_ID	CLIN	CLIN or Catalog Code is Required	Verify that the Price Catalog field is populated in the input file if Bill Inventory Issues As "A" (Account) or "U" (Unit). If either of these radio buttons are selected, a Price Catalog or CLIN is required.
PROJ_BILL_ INFO	Project Bill Info	CLIN_ID	CLIN	CLIN ID is not allowed	CLIN ID is allowed only if Billing Inventory Issues is set to "U" (Units) or "A" (Account).
PROJ_BILL_ INFO	Project Bill Info	CLIN_ID	CLIN	You may not enter both CLIN and Catalog	When Billing Inventory Issues is "A" (Account) or "U" (Unit), a Price Catalog or CLIN is required. You cannot enter a CLIN and a Price Catalog for the same project.
PROJ_BILL_ INFO	Project Bill Info	CLIN_ID	CLIN	CLIN ID does not exist	Validate the CLIN ID in the CLINs screen (Projects\Maintain\Project).
PROJ_BILL_ INFO	Project Bill Info	PROGRESS_ PMT_RT	Rates - Progress Payment	Rate must be between 0 and 100%	Verify that the rate in the Progress Payment field is between 0 and 100% in the Rates group box of the 1443 Info subtask in the Project Billing Information screen (Projects\Maintain\Billing).
PROJ_BILL_ INFO	Project Bill Info	LIQUID_RT	Rates - Liquidation	Rate must be between 0 and 100%	Verify that the rate in the Liquidation field is between 0 and 100% in the Rates group box of the 1443 Info subtask in the Project Billing Information screen (Projects\Maintain\Billing).
PROJ_BILL_ INFO	Project Bill Info	S_CONTR_ PRICE_CD	Contract Info - Price Basis	Price Basis Code is not valid	Verify that the Contract Price Code is valid in the 1443 Info tab of the Project Billing Information screen (Projects\Maintain\Billing). Valid entries are "CC" (Contract Cost), "CV" (Contract Value), "FC" (Funded Cost), "FV" (Funded Value), and "O" (Other).
PROJ_BILL_ INFO	Project Bill Info	CONTR_ OVRIDE_AMT	Other	Amount Not allowed for this Price Basis Code	Non-zero amounts are allowed only if the Contract Price Code is "O" (Other).
PROJ_BILL_ INFO	Project Bill Info	POP_FL	Limit Transactions to Period of Performance	Limit to Period of Performance Flag is invalid	Verify that the Limit Transactions to Period of Performance is set to "Y" or "N" in the input file.
PROJ_BILL_ INFO	Project Bill Info	CONTR_ADDR_CD	Contract Info - Address	Address does not exist	Validate the Address Code field entered in the input file. The Address Code must exist in the Contractor Addresses screen.
PROJ_BILL_ INFO	Project Bill Info	PAY_WHEN_ PAID_FL	Pay When Paid	Pay when Paid Flag is invalid	Verify that the Pay When Paid flag is "Y" or "N" in the input file.
PROJ_BILL_ INFO	Project Bill Info	ALLOW_USER_ADJ_FL	Allow User to Adjust Transactions in Open Billing Detail	Allow User to Adj Open Bill Det'l Flag is invalid	Verify that the Allow Users to Adjust Transactions in Open Billing Detail field in the input file contains "Y" or "N."
PROJ_BILL_ INFO	Project Bill Info	BILL_CALC1_ AMT	(The name changes depending on the billing formula. See the "Billing Formula Validation Detail" section.)	Calc Amt must be zero for this Billing Formula	Verify that the Calc Amount is appropriate for the Billing Formula assigned to this project (see the "Billing Formula Validation Detail" section.)
PROJ_BILL_ INFO	Project Bill Info	INCL_LAB_ MLTPLR_FL	Include Labor Multiplier in Billing Rate	Include Labor Multiplier in Bill Rate Flag is invalid	Verify that the Include Labor Multiplier in Billing Rate field flag is "Y" or "N."
PROJ_BILL_ INFO	Project Bill Info	INCL_LAB_ MLTPLR_FL	Include Labor Multiplier in Billing Rate	Include Labor Multiplier in Bill Rate Flag is invalid	Confirm that the Include Labor Multiplier in Billing Rate is set to "Y" in the input file only if the billing formula for the project uses a multiplier. Billing formulas that use a multiplier are: "CIMR" (Labor Cost times Multiplier Plus Non Labor times Multiplier - Hours) and "RSMNLM" (Rate Schedule times Multiplier plus Non Labor Cost times Multiplier).
PROJ_BILL_ INFO	Project Bill Info	S_CRNCY_CD	Billing Currency	Billing Currency Code does not exist	Verify that the Billing Currency Code in the input file exists in the Currencies screen.
PROJ_BILL_ INFO	Project Bill Info	RT_GRP_ID	Rate Group	Required for this Billing Currency	Confirm that the Rate Group field exists in the input file if the Billing Currency and Functional Currency fields do not match. The Rate Group entered must exist in the Exchange Rate Groups screen.
PROJ_BILL_ INFO	Project Bill Info	RT_GRP_ID	Rate Group	Must be NULL for this Billing Currency	Ensure that the Rate Group field is NULL in the input file if the Billing Currency and the Functional Currency fields are the same.
PROJ_BILL_ INFO	Project Bill Info	RT_GRP_ID	Rate Group	Rate Group is not valid	Verify that the Rate Group in the input file exists in the Exchange Rate Groups screen with the functional currency as the Currency From and the billing currency as the Currency To.
PROJ_BILL_ INFO	Project Bill Info	FREEZE_RT_FL	Freeze Multicurrency Rate	Freeze Multicurrency Rate Flag is not valid	Verify that the Freeze Multicurrency Rate field is set to "Y" or "N" and is valid. The Billing Currency can be set to "Y" only if the Billing Currency does not match the Functional Currency.
PROJ_BILL_ INFO	Project Bill Info	TRN_CRNCY_ FL	Use Transactional Currency Billing	Use Transactional Currency Billing Flag is invalid	Verify that the Use Transactional Currency Billing field is set to "Y" or "N" in the input file. Use Transactional Currency Billing can be set to "Y" only if the Billing Currency does not match the Functional Currency and the Billing Formula is "LLR" (Loaded Labor Rate) or "LLRCINL" (Loaded Labor Rate Plus Cost Incurred on Non Labor - T&M).
PROJ_CUST_ SETUP	Project Bill Info - Customers Subtask	PROJ_ID	Project	Project must exist in PROJ_BILL_ INFO.CSV	Confirm that this project ID is included in the PROJ_BILL_INFO.CSV file or exists in the Project Bill Information screen (Projects\Maintain\Billing).
PROJ_CUST_ SETUP	Project Bill Info - Customers Subtask	CUST_ID	Customer	Customer is required	Verify that a Customer Name exists in the PROJ_CUST_ SETUP.CSV file.
PROJ_CUST_ SETUP	Project Bill Info - Customers Subtask	CUST_ID	Customer	Customer is invalid	Validate the Customer Name field in the Customers screen (Accounting\Maintain\Customers).
PROJ_CUST_ SETUP	Project Bill Info - Customers Subtask	CUST_ID	Customer	This Project/Customer already exists	Verify that the Customer Name exists only once for this project in the PROJ_CUST_ SETUP.CSV file.
PROJ_CUST_ SETUP	Project Bill Info - Customers Subtask	ADDR_DC	Address Code	Address Code is required	Verify that an Address Code exists in the PROJ_CUST_ SETUP.CSV file.
PROJ_CUST_ SETUP	Project Bill Info - Customers Subtask	ADDR_DC	Address Code	Address Code is invalid	Verify that the Address Code in the input file has been assigned to this customer in the Customers screen (Accounting\Maintain\Customers) with the Bill Code set to "Y" (Yes) or "D" (Default).
PROJ_CUST_ SETUP	Project Bill Info - Customers Subtask	PCT_CNTRB_RT	% of Project Responsibility	% of Project Responsibility is required	Verify that a value exists for the % of Project Responsibility field.
PROJ_CUST_ SETUP	Project Bill Info - Customers Subtask	PCT_CNTRB_RT	% of Project Responsibility	% of Project Responsibility must be greater than zero.	Confirm that the % of Project Responsibility totals 100% for all the customers of this project.
PROJ_CUST_ SETUP	Project Bill Info - Customers Subtask	PCT_CNTRB_RT	% of Project Responsibility	% of Project Responsibility must total 100% for this project	Make sure that the % of Project Responsibility is greater than zero.
PROJ_ORG_ ACCT	Proj/Acct/Orgs	USER_ID		User ID is not valid	Validate the User ID field in the input file. The User ID must exist in the Users screen (Administration\Maintain\Users).
PROJ_ORG_ ACCT	Proj/Acct/Orgs	PROJ_ID	Project	Project ID does not exist	Validate the Project ID in the input file. The Project ID must exist in either the Basic Project Information screen (Projects\Maintain\Projects) or the PROJ.CSV file.
PROJ_ORG_ ACCT	Proj/Acct/Orgs	ORG_ID	Organization	The Account/Org Combination does not exist	Verify that the Account and Org are linked in the Account/Org Links screen (Projects\Maintain\Projects\Project User Flow) and that the Active field is selected in the Basic Info screen.
PROJ_ORG_ ACCT	Proj/Acct/Orgs	ACCT_ID	Account	The Account/Org Combination does not exist	Verify that the Account and Org are linked in the Account/Org Links screen (Projects\Maintain\Projects\Project User Flow) and that the Active field is selected in the Basic Info screen.
PROJ_ORG_ ACCT	Proj/Acct/Orgs	ACCT_ID	Account	This Project/Account/Org already exists.	Confirm that the Project/Account/Org combination does not already exist in the Project/Account/Orgs screen (Projects\Maintain\Projects\Project User Flow), or in the PROJ_ORG_ ACCT.CSV file.
PROJ_ORG_ ACCT	Proj/Acct/Orgs	ACCT_ID	Account	This Account is not part of the project's account group	Validate the Account in the input file. The Account must exists in the Project Account Groups screen for this project.
PROJ_ORG_ ACCT	Proj/Acct/Orgs	ACTIVE_FL	Active	Active Flag is invalid	Verify that the Active field in the input file contains a "Y" or "N."
PROJ_ORG_ ACCT	Proj/Acct/Orgs	REF_STRUC_1_ ID	REF 1	REF 1 does not exist	Validate the Reference Number in the Reference Structures and Reference Elements screens.
PROJ_ORG_ ACCT	Proj/Acct/Orgs	REF_STRUC_2_ ID	REF 2	REF 2 does not exist	Verify that the Reference Number has been set up in the Reference Structures and Reference Elements screens.
PROJ_GOVT_ CONTR	Govt Contract	USER_ID		User ID is not valid	Validate the User ID in the Users (Administration\Maintain\Users) screen.
PROJ_GOVT_ CONTR	Govt Contract	DFLT_PROJ_ID		Project ID does not exist	Verify that the Project ID exists in the PROJ.CSV file or the Project Basic Information screen (Projects\Maintain\Projects).
PROJ_GOVT_ CONTR	Govt Contract	PROJ_ID	Project	Project ID does not exist	Verify that the Project ID exists in the PROJ.CSV file or the Project Basic Information screen (Projects\Maintain\Projects).
PROJ_GOVT_ CONTR	Govt Contract	PROJ_ID	Project	Project already exists	Ensure that the Project ID does not already exist in the Govt Contract Info screen(Projects\Maintain\Projects\Project User Flow), or in the PROJ_GOVT_CONTR.CSV file.
PROJ_GOVT_ CONTR	Govt Contract	CST_ACCT_STD_FL	CAS Covered	CAS Covered Flag is invalid	Verify that the CAS Covered field contains "Y" or "N" in the input file.
PROJ_GOVT_ CONTR	Govt Contract	S_ICS_CD	Incurred Cost Submission Code	Incurred Cost Submission Code is required	Verify that the Incurred Cost Submission Code exists in the input file if the Require Incurred Cost Submission Code for all Projects checkbox is selected in the Project Settings screen.
PROJ_GOVT_ CONTR	Govt Contract	S_ICS_CD	Incurred Cost Submission Code	Incurred Cost Submission Code is invalid	Verify that the Incurred Cost Submission Code is in the S_ICS table.
PROJ_GOVT_ CONTR	Govt Contract	WD_PLC_FL	Use PLC for Wage Determination	Use PLC for Wage Det. Flag is invalid	Verify that the Use PLC for Wage Determination field is "Y" or "N."
PROJ_GOVT_ CONTR	Govt Contract	WD_PLC_FL	Use PLC for Wage Determination	Use PLC for Wage Determination Flag may not be 'Y' if project level is not equal to 1	Ensure that the Use PLC for Wage Determination field is not set to "Y" if project level is not equal to "1."
PROJ_LAB_ CAT	Assign PLCs	USER_ID		User ID is not valid	Validate the User ID field in the Users screen (Adminsitration\Maintain\Users).
PROJ_LAB_ CAT	Assign PLCs	PROJ_ID	Project	Project ID does not exist	Make sure that the Project ID exists in either the Project Basic Information screen (Projects\Maintain\Projects) or the PROJ.CSV file.
PROJ_LAB_ CAT	Assign PLCs	BILL_LAB_CAT_CD	PLC	PLC does not exist	Validate the PLC in the Project Labor Categories (PLC) screen (Projects\Maintain\Labor Categories).
PROJ_LAB_ CAT	Assign PLCs	BILL_LAB_CAT_CD	PLC	Project/PLC already exists	Verify that this PLC is not already assigned to this project in the Assign PLCs screen (Projects\Maintain\Projects\Proje t User Flow) or the PROJ_LAB_CAT.CSV file
PROJ_LAB_ CAT	Assign PLCs	COBRA_RSRC	Cobra Mapping Value	The Cobra Mapping Value exceeds the maximum number of characters allowed	Make sure that the Cobra Mapping Value does not have more than 59 characters in the input file.
PROJ_EMPL	Empl Work Force	USER_ID		User ID is not valid	Verify that the User ID exists in the Users screen (Adminstration\Maintain\Users).
PROJ_EMPL	Empl Work Force	PROJ_ID	Project	Project ID does not exist	Ensure that the Project ID exists in either the Project Basic Information screen (Projects\Maintain\Projects) or the PROJ.CSV file. Note: Costpoint will use this information only if the Project Work Force Required checkbox is selected in the Project Basic Information screen (Projects\Maintain\Projects), or is "Y" in the PROJ.CSV file. Also, the information will not be used if the Use Top Level Work Force checkbox is selected in the Project Basic Information screen (Projects\Maintain\Projects) or is "Y" in the PROJ.CSV file, and the Project ID is not a top-level project.
PROJ_EMPL	Empl Work Force	EMPL_ID	Employees	Employee does not exist	Make sure that the Employee ID has been set up in the Employee Info and the Salary Info and History screens (People\Maintain\Employee User Flow).
PROJ_EMPL	Empl Work Force	EMPL_ID		Employee is already assigned to the Project	Verify that the Employee has not already been assigned to the project in the Empl Work Force screen (Projects\Maintain\Projects\Project User Flow) or in the PROJ_EMPL.CSV file.
PROJ_EMPL	Empl Work Force	OT_AUTH_FL	Overtime Authorized for Employees	Overtime Authorized for Empl's Flag is invalid	Verify that the Overtime Authorized for Employees checkbox is set to "Y" or "N."
PROJ_EMPL	Empl Work Force	OT_AUTH_FL	Overtime Authorized for Employees	All Flags must be the same for this Project	Ensure that all employees assigned to a project work force must be either authorized for overtime or not authorized for overtime. You cannot have some employees authorized for overtime and others not authorized for overtime on the same project.
PROJ_VEND	Vend Work Force	USER_ID		User ID is not valid	Verify that the User ID exists in the Database and in the Users screen (Administration\Maintain\Users).
PROJ_VEND	Vend Work Force	PROJ_ID	Project	Project ID does not exist	Make sure that the Project ID exists in either the Basic Project Information screen (Projects\Maintain\Projects) or the PROJ.CSV file.
PROJ_VEND	Vend Work Force	VEND_ID	Vendor	Vendor does not exist	Make sure that the Vendor ID exists the Vendors screen (Accounting\Maintain\Vendors). Note: Costpoint will use this information only if the Project Work Force Required checkbox is selected in the Project Basic Information screen (Projects\Maintain\Projects), or is "Y" in the PROJ.CSV file. Also, the information will not be used if the Use Top Level Work Force checkbox is selected in the Project Basic Information (Project\Maintain\Projects) screen or is "Y" in the PROJ.CSV file, and the Project ID is not a top level.
PROJ_VEND	Vend Work Force	VEND_ID	Vendor	Vendor is already assigned to the Project	Ensure that the Vendor ID is not already assigned to the project in the Vend Work Force screen (Projects\Maintain\Projects\Project User Flow) or in the PROJ_VEND.CSV file.
PROJ_VEND_EMPL	Project Vendor Employee Work Force	USER_ID		User ID is not valid	Make sure that the User ID has been set up in the Database and in the Maintain Users screen.
PROJ_VEND_EMPL	Project Vendor Employee Work Force	PROJ_ID	Project	Project ID does not exist	Make sure that the Project ID exists in either the Basic Info screen or the PROJ.CSV file.
PROJ_VEND_EMPL	Project Vendor Employee Work Force	VEND_ID	Vendor	Vendor does not exist	Make sure that the Vendor has been set up in the Maintain Vendors screen. Note: Costpoint will use this information only if the Project Work Force Required checkbox is selected in the Basic Info screen, or is "Y" in the PROJ.CSV file. Also, the information will not be used if the Use Top Level Work Force checkbox is selected in the Basic Info screen or is "Y" in the PROJ.CSV file, and the project ID is not a top level.
PROJ_VEND_EMPL	Project Vendor Employee Work Force	VEND_ID	Vendor	Vendor is already assigned to the Project	Make sure that the Vendor has not already been assigned to the Project in the Project Vendor Work Force screen or in the PROJ_VEND.CSV file.
PROJ_VEND_EMPL	Project Vendor Employee Work Force	VEND_EMPL_ID	Vendor Employee	Vendor Employee does not exist	The Vendor Employee must exist in the Maintain Vendor Employee screen.
PROJ_WAWF_ INFO	Project WAWF Information	PROJ_ID	Project	Project ID is not billable	Make sure that the Project ID exists in either the Project Billing Info screen or the PROJ_BILL_INFO.CSV file.
PROJ_WAWF_ INFO	Project WAWF Information	WAWF_SEND_ CAGE_CD	CAGE Code	CAGE Code does not exist	Make sure that the CAGE Code has been set up in the Maintain WAWF Billing Settings screen.
PROJ_WAWF_ INFO	Project WAWF Information	WAWF_INVC_ TYPE_CD	Invoice Type	Invoice Type code is not valid	Verify that the Invoice Type code is valid. Valid entries are "CV" (Cost Voucher), "SCV" (Summary Cost Voucher), "CI" (Commercial Invoice), "2N1" (2N1), Combo (Combo), and "PPR" (Progress Payment).
PROJ_WAWF_ INFO	Project WAWF Information	WAWF_LAST_ INVC_FL	Final Invoice	Final Invoice flag is not valid	Verify that the Final Invoice flag is "Y" or "N."
PROJ_WAWF_ INFO	Project WAWF Information	WAWF_LAST_ SHIP_FL	Final Shipment	Final Shipment flag is not valid	Verify that the Final Shipment flag is "Y" or "N."
PROJ_WAWF_ INFO	Project WAWF Information	WAWF_CERT_ FL	Construction Certificate, Certification, Certificate of Conformance	Construction Certificate, Certification, or Certificate of Conformance flag is not valid	Verify that the Construction Certificate, Certification, or Certificate of Conformance flag is "Y" or "N."
PROJ_WAWF_ INFO	Project WAWF Information	WAWF_SUPPLY_SVC_CD	Type	Type code is not valid	Verify that the Type code is valid. Valid entries are "SPL" (Supplies) and "SVC" (Services).
PROJ_WAWF_ INFO	Project WAWF Information	WAWF_ INSPECT_PT_ CD	Inspection Point	Inspection Point code is not valid	Verify that the Inspection Point code is valid. Valid entries are "S" (Source), "D" (Destination), and "T" (Other).
PROJ_WAWF_ INFO	Project WAWF Information	WAWF_ACCEPT_PT_CD	Acceptance Point	Acceptance Point code is not valid	Verify that the Acceptance Point code is valid. Valid entries are "S" (Source), "D" (Destination), and "T" (Other).
PROJ_WAWF_ INFO	Project WAWF Information	WAWF_FOB_CD	FOB	FOB code is not valid	Verify that the FOB code is valid. Valid entries are "S" (Source), "D" (Destination), and "T" (Other).
PROJ_WAWF_ INFO	Project WAWF Information	WAWF_ARP_FL	Alternate Release Procedure	Alternate Release Procedure flag is not valid	Verify that the Alternate Release Procedure flag is "Y" or "N."
PROJ_WAWF_ INFO	Project WAWF Information	WAWF_DELIV_FL	Delivery On Invoice	Delivery On Invoice flag is not valid	Verify that the Delivery On Invoice flag is "Y" or "N."
PROJ_WAWF_ INFO	Project WAWF Information	WAWF_FMS_FL	FMS	FMS flag is not valid	Verify that the FMS flag is "Y" or "N."
PROJ_WAWF_ INFO	Project WAWF Information	WAWF_CLIN_ MAP_CD	CLIN Mapping Method	CLIN Mapping Code is not valid.	Verify that the CLIN Mapping Code is valid. Valid entries are "G" (Generic Billing Format) or "C" (Default CLIN).
PROJ_WAWF_ INFO	Project WAWF Information	WAWF_DFLT_ CLIN_ID	Default CLIN	The Default CLIN is required.	If the WAWF_CLIN_MAP_CD = "C," a CLIN must be entered.
PROJ_EMPL_ LAB_CAT	Assign PLC to Employee Work Force	USER_ID		User ID is not valid	Ensure that the User ID exists in the database and in the Users screen (Administration\Maintain\Users).
PROJ_EMPL_ LAB_CAT	Assign PLC to Employee Work Force	PROJ_ID	Project	Project ID does not exist	Make sure that the Project ID exists in either the Project Basic Information (Projects\Maintain\Projects) screen or the PROJ.CSV file.
PROJ_EMPL_ LAB_CAT	Assign PLC to Employee Work Force	EMPL_ID	Employee	Employee is not valid	Verify that the Employee ID is assigned to the Empl Work Force in the Project Basic Information screen (Projects\Maintain\Projects\Project User Flow), or the PROJ_EMPL.CSV file.
PROJ_EMPL_ LAB_CAT	Assign PLC to Employee Work Force	BILL_LAB_CAT_CD	PLC	PLC is not valid	Ensure that the PLC has been assigned to the project in the Assign PLCs screen (Projects\Maintain\Projects\Project User Flow), or the PROJ_LAB_CAT.CSV file
PROJ_EMPL_ LAB_CAT	Assign PLC to Employee Work Force	BILL_LAB_CAT_CD	PLC	This Employee/PLC has already been assigned to this Project	Verify that the project does not already have this Employee/PLC combination assigned in the Assign PLC to Employee Work Force subtask of the Empl Work Force screen (Projects\Maintain\Projects\Project User Flow), or the PROJ_EMPL_LAB_ CAT.CSV file.
PROJ_EMPL_ LAB_CAT	Assign PLC to Employee Work Force	DFLT_FL	Defaults	A Default must be setup for each Employee	Validate that one PLC for a given employee/project combination must have a "Y" in the Default field. PLCs with an "N" will not default, but will be available for Lookup when you are entering employee timesheets.
PROJ_VEND_ LAB_CAT	Assign PLC to Vendor Work Force	USER_ID		User ID is not valid	Ensure that the User ID exists in the database and in the Users screen (Administration\Maintain\Users).
PROJ_VEND_ LAB_CAT	Assign PLC to Vendor Work Force	PROJ_ID	Project	Project ID does not exist	Verify that the Project ID exists in either the Project Basic Information (Projects\Maintain\Projects) screen or the PROJ.CSV file.
PROJ_VEND_ LAB_CAT	Assign PLC to Vendor Work Force	VEND_ID	Vendor	Vendor is not valid	Verify that the Vendor ID is assigned to the Vendor Work Force in the Vend Work Force subtask of the Project Basic Information screen (Projects\Maintain\Projects), or the PROJ_VEND.CSV file.
PROJ_VEND_ LAB_CAT	Assign PLC to Vendor Work Force	BILL_LAB_CAT_CD	PLC	PLC is not valid	Verify that the PLC has been assigned to the Project in the Assign PLCs screen (Projects\Maintain\Projects\Project User Flow), or the PROJ_LAB_CAT.CSV file.
PROJ_VEND_ LAB_CAT	Assign PLC to Vendor Work Force	BILL_LAB_CAT_CD	PLC	This Vendor/PLC has already been assigned to this Project	Verify that the Project ID does not already have this Vendor/PLC combination assigned in the Assign PLC to Vendor Work Force subtask of the Vend Work Force screen (Projects\maintain\Projects\Project User Flow), or the PROJ_VEND_LAB_ CAT.CSV file.
PROJ_VEND_ LAB_CAT	Assign PLC to Vendor Work Force	DFLT_FL	Defaults	A Default must be setup for each Vendor	Ensure that one PLC within each Vendor/Project combination has a "Y" in the Default field.
BILL_LAB_ CAT	Project Labor Categories (PLC)	BILL_LAB_CAT_CD	Lab Cat	PLC is required	Verify that a PLC exists in the BILL_LAB_CAT.CSV file.
BILL_LAB_ CAT	Project Labor Categories (PLC)	BILL_LAB_CAT_DESC	Description	Description is required	Verify that a PLC Description exists in the BILL_LAB_CAT.CSV file.
PROJ_LAB_ CAT_MAP	Linked GLCs	USER_ID		User ID is not valid	Verify that the User ID exists in the database and in the Users screen (Administration\Maintain\Users).
PROJ_LAB_ CAT_MAP	Linked GLCs	PROJ_ID	Project	Project ID does not exist	Verify that the Project ID exists in either the Project Basic Information screen (Projects\Maintain\Projects) or the PROJ.CSV file.
PROJ_LAB_ CAT_MAP	Linked GLCs	GENL_LAB_ CAT_CD	GLC	GLC does not exist	Verify that the GLC has been set up in the General Labor Categories screen.
PROJ_LAB_ CAT_MAP	Linked GLCs	GENL_LAB_ CAT_CD	GLC	This Project/GLC already exists	Verify that the GLC has been assigned only once for this project.
PROJ_LAB_ CAT_MAP	Linked GLCs	DF_BILL_LAB_CAT_CD	PLC	PLC is not valid	Make sure that the PLC has been assigned to the Project in the Assign PLCs screen (Projects\Maintain\Projects\Project User Flow), or the PROJ_LAB_CAT.CSV file.
PROJ_LAB_ CAT_RT_SC	Project PLC Rates	USER_ID		User ID is not valid	Verify that the User ID has been set up in the database and in the Users screen (Administration\Maintain\Users).
PROJ_LAB_ CAT_RT_SC	Project PLC Rates	PROJ_ID	Project	Project ID does not exist	Verify that the Project ID exists in either the Basic Project Information screen (Projects\Maintain\Projects) or the PROJ.CSV file.
PROJ_LAB_ CAT_RT_SC	Project PLC Rates	BILL_LAB_CAT_CD	PLC	PLC is not assigned to the Project	Make sure that the PLC has been assigned to the Assign PLCs (Projects\Maintain\Projects\Project User Flow) screen, or the PROJ_LAB_CAT.CSV file.
PROJ_LAB_ CAT_RT_SC	Project PLC Rates	BILL_LAB_CAT_CD	PLC	PLC is not valid	Make sure that the PLC has been set up in the Project Labor Categories screen (Projects\maintain\Projects\Project User Flow) or in the BILL_LAB_CAT.CSV file.
PROJ_LAB_ CAT_RT_SC	Project PLC Rates	BILL_RT_AMT	Rate	Must be zero when Rate Type is "A" (Actual) or "S" (Standard).	Verify that the Billing Rate is valid. If the Rate Type is "Actual" or "Standard," the Billing Rate must be zero.
PROJ_LAB_ CAT_RT_SC	Project PLC Rates	BILL_RT_AMT	Rate	Rate is required	Verify that a Bill Rate exists in the input file.
PROJ_LAB_ CAT_RT_SC	Project PLC Rates	S_BILL_RT_ TYPE_CD	Rate Type	Rate Type is Required	Validate the Rate Type field.
PROJ_LAB_ CAT_RT_SC	Project PLC Rates	S_BILL_RT_ TYPE_CD	Rate Type	Rate Type is not Valid	Ensure that the Rate Type is valid. Valid values for the Rate Type field are "A" (Actual), "B" (Billing), "C" (Ceiling), "S" (Standard), and "T" (Transactional).
PROJ_LAB_ CAT_RT_SC	Project PLC Rates	START_DT	Starting Date	Two rates have been specified for the same time frame	Verify that the PLC/Starting Date/Ending Date combination is valid. The Starting Date and Ending Date fields for the same PLC/Project combination cannot overlap.
PROJ_LAB_ CAT_RT_SC	Project PLC Rates	START_DT	Starting Date	Invalid Start Date	Ensure that a Starting Date exists in the input file and that it is a valid date.
PROJ_LAB_ CAT_RT_SC	Project PLC Rates	END_DT	Ending Date	Two rates have been specified for the same time frame	Verify that the Starting Date and Ending Date fields are valid. You cannot have the same PLC/Project combination with overlapping Starting and Ending dates.
PROJ_LAB_ CAT_RT_SC	Project PLC Rates	END_DT	Ending Date	Invalid End Date	Ensure that an Ending Date exists in the input file and that it is a valid date.
PROJ_EMPL_ RT_SCH	Empl/Vend PLC Rates	USER_ID		User ID is not valid	Validate the User ID has been set up in the database and in the Users screen (Adminsitration\Maintain\Users).
PROJ_EMPL_ RT_SCH	Empl/Vend PLC Rates	USER_ID		User ID is required	Verify that a User ID exists in the input file.
PROJ_EMPL_ RT_SCH	Empl/Vend PLC Rates	PROJ_ID	Project	Project ID does not exist	Verify that the Project ID exists in either the Basic Project Information screen (Projects\Maintain\Projects) or the PROJ.CSV file.
PROJ_EMPL_ RT_SCH	Empl/Vend PLC Rates	EMPL_ID	Employee	Employee does not exist in the Project Work Force	If the Project Work Force Required checkbox is selected in the Basic Project Information screen (Projects\Maintain\Projects) or the PROJ.CSV file. The employee must be part of the work force for this project in the Empl Work Force screen (Projects\Maintain\Projects\Project User Flow) or the PROJ_EMPL.CSV file.
PROJ_EMPL_ RT_SCH	Empl/Vend PLC Rates	S_BILL_RT_ TYPE_CD	Rate Type	Rate Type is Required	Ensure that the Rate Type exists.
LAB_CAT_RT_SCH	Project PLC Rates	USER_ID		User ID is not valid	Verify that the User ID exists in the database and the Users screen (Administration\Maintain\Users).
LAB_CAT_RT_SCH	Project PLC Rates	BILL_LAB_CAT_CD	Lab Cat	PLC already exists	Make sure that the PLC is set up only once in either the Project Labor Categories screen, or in the LAB_CAT_RT_SCH.CSV file.
LAB_CAT_RT_SCH	Project PLC Rates	END_DT	Ending Date	The End Date must be greater than the Start Date	Verify that the End Date is later than the Start Date.
TM_RT_ ORDER	Def Rate Seq	USER_ID		User ID is not valid	Verify that the User ID exists in the database and in the Users screen (Administration\Maintain\Users)
TM_RT_ ORDER	Def Rate Seq	PROJ_ID	Project	Project ID does not exist	Ensure that the Project ID exists in either the Basic Project Information screen or the PROJ.CSV file.
TM_RT_ ORDER	Def Rate Seq	S_BILL_RT_TBL_CD	Rate Table	Rate Table is not valid	Verify that the Rate Table field contains one of the following values: "C" (Project Labor Categories), "PC" (Project PLC Rates), "PEC" (Project PLC Rates By Employee), or "PVC" (Project PLC Rates By Vendor).
TM_RT_ ORDER	Def Rate Seq	SEQ_NO	Seq No	Sequence Number already exists	Ensure that the Sequence number does not already exist for this Project.
TM_RT_ ORDER	Def Rate Seq	SRCE_PROJ_ID	Source Project	Project ID does not exist	Make sure that the Project ID exists in either the Basic Project Information screen (Projects\Maintain\Projects) or the PROJ.CSV file.
TM_RT_ ORDER	Def Rate Seq	SRCE_PROJ_ID	Source Project	Source Project is required for this Rate Table	Verify that a Source Project is entered in the Rate Table if the value selected is: "PC" (Project PLC Rates), "PEC" (Project PLC Rates By Employee), or "PVC" (Project PLC Rates By Vendor).
TM_RT_ ORDER	Def Rate Seq	SRCE_PROJ_ID	Source Project	Source Project must be NULL for this Rate Table	Verify that a Source Project is not entered if the Rate Table is "C" (Setup Project Labor Categories).
CEIL_DIR_CST	Dir Cost Ceil	USER_ID		User ID is not valid	Verify that the User ID exists in the database and in the Users screen (Administration\Maintain\Users).
CEIL_DIR_CST	Dir Cost Ceil	PROJ_ID	Project	Project ID does not exist	Verify that the Project ID exists in either the Basic Project Information screen (Projects\Maintain\Project) or the PROJ.CSV file.
CEIL_DIR_CST	Dir Cost Ceil	PROJ_ID	Project	This is a soft warning: Delete this validation. Revenue Formula must exist	Validate that a revenue formula for this project has been set up in the Revenue Info screen (Projects\Maintain\Projects\Project User Flow) or in the BASIC_REVENUE_ INFO.CSV file.
CEIL_DIR_CST	Dir Cost Ceil	ACCT_ID	Account	Account is not valid	Validate the account in the Project Account Groups screen that is assigned to this project.
CEIL_DIR_CST	Dir Cost Ceil	ACCT_ID	Account	Ceiling for this Account already exists for this Project	Verify that a ceiling has not already been set up for this Account/Project combination in the Dir Cost Ceil screen (Projects\Maintain\Projects\Project User Flow), or the CEIL_DIR_CST.CSV file.
CEIL_DIR_CST	Dir Cost Ceil	S_RBA_CD	Apply to (RBA)	Apply To (RBA) code is not valid	Verify that the Apply To R/B/A code is valid. Valid entries are "R" (Revenue), "B" (Billing), "A" (Both), and N (Neither).
CEIL_DIR_CST	Dir Cost Ceil	CEIL_AMT	Ceiling Amount	The Ceiling Amount may not be negative	Verify that the number entered in the Ceiling Amount field is a positive number.
CEIL_DIR_HRS	Dir Hour Ceil	USER_ID		User ID is not valid	Verify that the User ID exists in the database and in the Users screen (Administration\Maintain\Users).
CEIL_DIR_HRS	Dir Hour Ceil	PROJ_ID	Project	Project ID does not exist	Ensure that the Project ID exists in either the Basic Project Information screen (Projects\Maintain\Projects) or the PROJ.CSV file.
CEIL_DIR_HRS	Dir Hour Ceil	BILL_LAB_CAT_CD	Labor Cat	PLC is not valid	If this Project exists in the Assign PLCs screen (Projects\Maintain\Project\Project User Flow) or in the PROJ_LAB_CAT.CSV, the PLC is valid only if it is assigned to the project in the Assign PLCs screen (Projects\Maintain\Project\Project User Flow) or the PROJ_LAB_CAT.CSV file. If the project does not exist in the Assign PLCs screen (Projects\Maintain\Project\Project User Flow) or the PROJ_LAB_CAT.CSV file, it must exist in the Project Labor Categories screen (Projects\Maintain\Labor Categories) or the BILL_LAB_CAT.CSV file.
CEIL_DIR_HRS	Dir Hour Ceil	BILL_LAB_CAT_CD	Labor Cat	PLC already exists for this Project	Verify that a ceiling has not already been set up for this PLC/Project combination in the Dir Hour Ceil screen (Projects\Maintain\Projects\Project User Flow), or the CEIL_DIR_HRS.CSV file.
CEIL_DIR_HRS	Dir Hour Ceil	CEIL_HRS	Hours Ceiling	The Hours Ceiling may not be negative	Verify that the amount entered in the Hours Ceiling field is a positive number.
CEIL_BURDEN_CST	Burd Cost Ceil	USER_ID		User ID is not valid	Verify that the User ID exists in the database and in the Users screen (Administration\Maintain\Users).
CEIL_BURDEN_CST	Burd Cost Ceil	PROJ_ID	Project	Project ID does not exist	Verify that the Project ID exists in either the Basic Project Information screen (Projects\Maintain\Projects) or the PROJ.CSV file.
CEIL_BURDEN_CST	Burd Cost Ceil	FY_CD	Fiscal Year	Fiscal Year is not valid	Verify that the Fiscal Year exists and has a status of "Open" in the Fiscal Years screen.
CEIL_BURDEN_CST	Burd Cost Ceil	POOL_NO	Pool	Pool Number does not exist for this Fiscal Year	Verify that the Pool Number exists for this fiscal year in the Cost Pools screen (Projects\Maintain\Allocations) with a group number equal to "1."
CEIL_BURDEN_CST	Burd Cost Ceil	S_RBA_CD	Apply to (RBA)	Apply To (RBA) code is not valid	Verify that the Apply To R/B/A code is valid. Valid entries are "R" (Revenue), "B" (Billing), "A" (Both), and "N" (Neither).
CEIL_BURDEN_CST	Burd Cost Ceil	S_CEIL_TYPE_ CD	C/O/F	C/O/F Code is not valid	Verify that the C/O/F Code is valid. Valid entries are "C" (Ceiling), "O" (Override), and "F" (Fixed).
CEIL_BURDEN_CST	Burd Cost Ceil	S_CEIL_TYPE_ CD	C/O/F	Duplicate Project/Fiscal Year/Pool Number/Account	Validate that you do not have a duplicate Project/Fiscal Year/Pool Number/Account combination already set up in the Burd Cost Ceil screen (Projects\Maintain\Projects\Project User Flow), or the CEIL_BURDEN_CST.CSV file. A duplicate Project/Fiscal Year/Pool Number/Account is allowed only when one record has a Ceiling Type of "O" (Override) and another record has a Ceiling Type of "C" (Ceiling).
CEIL_BURDEN_CST	Burd Cost Ceil	CEIL_RT	Rate Ceiling	Rate Ceiling cannot be negative	Verify that the Rate Ceiling is a positive number.
CEIL_BURDEN_CST	Burd Cost Ceil	CEIL_COM_RT	COM Ceiling	COM Ceiling cannot be negative	Verify that the COM Ceiling is a positive number.
CEIL_BURDEN_CST	Burd Cost Ceil	ACCT_ID	Account	Account does not exist	Verify that the account exists in the Accounts screen (Accounting\Maintain\General Ledger). Note: Ceilings will be applied only if the account is set up in the base of the pool in the Cost Pool screen (Projects\Maintain\Allocations).
EMPL_CEIL	Empl Hour Ceil	USER_ID		User ID is not valid	Verify that the User ID exists in the Database and in the Users screen (Administration\Maintain\Users).
EMPL_CEIL	Empl Hour Ceil	PROJ_ID	Project	Project ID does not exist	Validate the Project ID in either the Project Basic Information screen (Projects\Maintain\Projects) or the PROJ.CSV file.
EMPL_CEIL	Empl Hour Ceil	BILL_LAB_CAT_CD	Labor Cat	PLC does not exist	If the Project Work Force Required checkbox is selected in the Project Basic Information screen (Projects\Maintain\Projects), or if it is set to "Y" in the PROJ.CSV file, the PLC must be assigned in the Empl Work Force screen (Projects\Maintain\Projects\Project User Flow) or the PROJ_EMPL_LAB_ CAT.CSV file. If the Project Work Force Required checkbox is unchecked and the project exists in the Assign PLCs screen (Projects\Maintain\Projects\Project User Flow) or the PROJ_LAB_CAT.CSV file, the PLC must exist in the Assign PLCs screen (Projects\Maintain\Projects\Project User Flow) or the PROJ_LAB_CAT.CSV file. If the project does not exist, the PLC must exist in the Project Labor Categories (PLC) screen (Projects\Maintain\Labor Categories)or the BILL_LAB_CAT.CSV file. Also, if the Use Top Level Work Force checkbox is selected in the Basic Projects Information screen (Projects\Maintain\Projects) or is "Y" in the PROJ.CSV file, substitute the top level project for the project for the above validations.
EMPL_CEIL	Empl Hour Ceil	EMPL_ID	Employee	Employee does not exist	If the Project Work Force Required checkbox is unchecked or set to "N" in the PROJ.CSV file, the employee must be set up in the Employee Info screen. If the Project Work Force Required checkbox is selected or set to "Y" in the PROJ.CSV file, the employee must be set up in the Empl Work Force screen (Projects\Maintain\Projects\Project User Flow), or the PROJ.EMPL.CSV file for the project. Also, if the Use Top Level Work Force checkbox is selected in the Basic Project Information screen (Projects\Maintain\Projects) or is "Y" in the PROJ.CSV file, then for the above validations, substitute the top level project for the project.
EMPL_CEIL	Empl Hour Ceil	EMPL_ID		Project/Employee/PLC already exists	Verify that the PLC has not already been set up for this Employee/Project combination.
EMPL_CEIL	Empl Hour Ceil	CEIL_HRS	Hours Ceiling	Hours Ceiling cannot be negative	Verify that the Hours Ceiling is a positive number.
VEND_CEIL	Vend Hour Ceil	USER_ID		User ID is not valid	Verify that the User ID exists in the database and in the Users screen (Administration\Maintain\Users).
VEND_CEIL	Vend Hour Ceil	PROJ_ID	Project	Project ID does not exist	Verify that the Project ID exists in either the Basic Project Information screen (Projects\Maintain\Projects) or the PROJ.CSV file.
VEND_CEIL	Vend Hour Ceil	BILL_LAB_CAT_CD	Labor Cat	PLC does not exist	If the Project Work Force Required checkbox is selected in the Basic Project Information (Projects\Maintain\Projects) screen, or if it is set to "Y" in the PROJ.CSV file, the PLC must be assigned in the Vendor Work Force screen (Projects\Maintain\Projects\Project User Flow) or the PROJ_VEND_LAB_ CAT.CSV file. If the Project Work Force Required checkbox is unchecked and the project exists in the Assign PLCs screen (Projects\Maintain\Projects\Project User Flow) or the PROJ_LAB_CAT.CSV file, the PLC must exist in the Assign PLCs screen (Projects\Maintain\Projects\Project User Flow) or the PROJ_LAB_CAT.CSV file. If the project does not exist, the PLC must exist in the Project Labor Categories screen (Projects\Maintain\Labor Categories) or the BILL_LAB_CAT.CSV file. Also, if the Use Top Level Work Force checkbox is selected in the Basic Project Information screen (Projects\Maintain\Projects) or the PROJ.CSV file, substitute the top level project for the project for the above validations.
VEND_CEIL	Vend Hour Ceil	VEND_ID	Vendor	Vendor does not exist	Verify that the vendor has been set up in the Vendors screen (Accounting\Maintain\Vendors).
VEND_CEIL	Vend Hour Ceil	VEND_ID	Vendor	Project/Vendor/PLC already exists	Verify that the PLC has not already been set up for this Vendor/Project combination.
VEND_CEIL	Vend Hour Ceil	CEIL_HRS	Hours Ceiling	Hours Ceiling cannot be negative	Verify that the Hours Ceiling is a positive number.
PROJ_BILL_ INFO_SCH	Project Bill Info - Detail Levels subtask	USER_ID		User ID is not valid	Verify that the User ID exists in the database and in the Users screen (Administration\Maintain\Users).
PROJ_BILL_ INFO_SCH	Project Bill Info - Detail Levels subtask	PROJ_ID	Project	Project ID must be a child of the Invoice Proj ID	Verify that the Project ID is a child of the invoice project.
PROJ_BILL_ INFO_SCH	Project Bill Info - Detail Levels subtask	INVC_PROJ_ID	Project (Invoice)	Invoice Project does not exist in Proj Bill Info	Verify that the invoice project has been set up in the Project Bill Info screen (Projects\Maintain\Projects\Project User Flow), or the PROJ_BILL_INFO.CSV file.
PROJ_BILL_ INFO_SCH	Project Bill Info - Detail Levels subtask	INVC_PROJ_ID	Project (Invoice)	Project already exists	Verify that the Project ID has not already been set up for this invoice project in the Supporting Schedule Format field in the Formats subtask of the Project Bill Info screen (Projects\Maintain\Projects\Project User Flow), or the PROJ_BILL_INFO_ SCH.CSV file.
PROJ_BILL_ INFO_SCH	Project Bill Info - Detail Levels subtask	SPPRT_SCH_ FRMT_CD		Supporting Schedule Code is not valid	Verify that the Supporting Schedule Code is the same code assigned to the invoice project in the Project Bill Info screen (Projects\Maintain\Projects\Project User Flow), or the PROJ_BILL_INFO.CSV file.
OVRIDE_ MLT_ON_DIR	Mult Ovrd	USER_ID		User ID is not valid	Verify that the User ID exists in the database and in the Users screen(Administration\Maintain\Users).
OVRIDE_ MLT_ON_DIR	Mult Ovrd	PROJ_ID	Project	Project ID does not exist	Verify that the Project ID exists in either the Basic Project Information screen (Projects\Maintain\Projects) or the PROJ.CSV file.
OVRIDE_ MLT_ON_DIR	Mult Ovrd	S_ACCT_ID	Starting Account	Starting Account does not exist	Verify that the Account has been set up in the Accounts screen (Accounting\Maintain\General Ledger).
OVRIDE_ MLT_ON_DIR	Mult Ovrd	END_ACCT_ID	Ending Account	Ending Account does not exist	Validate that the Account in the Accounts screen (Accounting\Maintain\General Ledger).
OVRIDE_ MLT_ON_DIR	Mult Ovrd	OVRIDE_MLT_RT		Multiplier Starting and Ending Accounts Overlap	Check for overlapping values.
OVRIDE_ MLT_ON_DIR	Mult Ovrd	S_RBA_CD )	Apply to R/G/B/A	Apply to Code is not Valid	Verify that the Apply to R/B/G/A code is valid. Valid entries are "R" (Revenue), "B" (Billing), "G" (Goal), and "A" (All).
OVRIDE_FEE_ON_DIR	Cost Fee Ovrd	USER_ID		User ID is not valid	Verify that the User ID exists in the database and in the Users screen (Administration\Maintain\Users).
OVRIDE_FEE_ON_DIR	Cost Fee Ovrd	PROJ_ID	Project	Project ID does not exist	Verify that the Project ID exists in either the Basic Project Information screen (Projects\Maintain\Projects) or the PROJ.CSV file.
OVRIDE_FEE_ON_DIR	Cost Fee Ovrd	ACCT_ID	Account	The Acct must have a valid function in the Account Group	Verify that the Account has been set up in the Project Account Groups screen for the account group that was assigned to the project in the Basic Project Information screen (Projects\Maintain\Projects) or the PROJ.CSV file.
OVRIDE_FEE_ON_DIR	Cost Fee Ovrd	ACCT_ID	Account	Account already exists for this Project	Make sure that this Account does not already exist for this project in the Cost Fee Ovrd screen (Projects\Maintain\Projects\Project User Flow), or the OVRIDE_FEE_ON_ DIR. CSV file.
OVRIDE_FEE_ON_DIR	Cost Fee Ovrd	S_RBA_CD	Apply to R/B/A	Apply To R/B/A code is not valid	Verify that the Apply To R/B/A code is valid. Valid entries are "R" (Revenue), "B" (Billing), "A" (Both), and "N" (Neither).
OVRIDE_FEE_ON_BURD	Burd Fee Ovrd	USER_ID		User ID is not valid	Verify that the User ID exists in the database and in the Users screen(Administration\Maintain\Users).
OVRIDE_FEE_ON_BURD	Burd Fee Ovrd	PROJ_ID	Project	Project ID does not exist	Verify that the Project ID exists in either the Basic Project Information screen (Projects\Maintain\Projects) or the PROJ.CSV file.
OVRIDE_FEE_ON_BURD	Burd Fee Ovrd	FY_CD	Fiscal Year	Fiscal Year is not valid	Verify that the Fiscal Year has been set up in the Fiscal Years screen.
OVRIDE_FEE_ON_BURD	Burd Fee Ovrd	POOL_NO	Pool	Pool Number does not exist for this Fiscal Year	Verify that the Pool Number exists for this fiscal year in the Cost Pools screen (Projects\Maintain\Allocations) with a group number equal to "1."
OVRIDE_FEE_ON_BURD	Burd Fee Ovrd	POOL_NO	Pool	Duplicate Project/Fiscal Year/Pool Number	Verify that the Fiscal Year/Pool Number combination has not already been set up for this Project in the Burd Fee Ovrd screen (Projects\Maintain\Projects\Project User Flow), or the OVRIDE_FEE_ON_ BURD.CSV file.
OVRIDE_FEE_ON_BURD	Burd Fee Ovrd	S_RBA_CD	Apply to R/B/A	Apply To R/B/A code is not valid	Verify that the Apply to R/B/A code is valid. Valid entries are "R" (Revenue), "B"(Billing), and "A" (Both).
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	USER_ID		User ID is not valid	Verify that the User ID exists in the database and in the Users screen(Administration\Maintain\Users).
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	EMPL_ID	Employee	Not valid when using Union Functionality	You cannot add records to this table if the Enable Union Functionality checkbox is selected in the Labor Settings screen.
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	EMPL_ID	Employee	Employee does not exist	Validate the Employee in the Basic Info screen (People\Maintain\Employee).
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	PROJ_ID	Project	Project ID does not exist	Validate the Project ID in either the Basic Project Information screen or the PROJ.CSV file. Note: If you wish to apply the defaults for this employee to all projects, enter an asterisk (*) in the PROJ_ID column.
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	PROJ_ID	Project	Default already exists for this Employee/Project	Verify that a default has not already been set up for this Employee/Project combination in the Employee Project TS Defaults screen or the EMPL_PROJ_TS_ DFLT.CSV file.
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	APPLY_LOWER_LVL_FL	Apply to Lower Levels	Apply to lower levels flag is not valid	Verify that the Apply to Lower Levels checkbox is "Y" or "N." Also, if the Project is = * (asterisk) in the input file, the Apply to Lower Levels flag must be "N."
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	ACCT_ID	Account	Account must be Active and Project Required.	Make sure that the Account ID has been set up in the Accounts screen (Accouning\Maintain\Accounts) with the Project Required and the Active checkboxes both selected.
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	ACCT_ID	Account	Project/Account combination does not exist or is not a member of the PAG	If the Limit Accounts checkbox is selected in the Basic Project Information screen or is set to "Y" in the PROJ.CSV file, you must set up the project/account wildcard in the Project Account screen. If the Limit Accounts checkbox is not selected in the Basic Project Information screen or is set to "N" in the PROJ.CSV file, the Account must exist in the Account Group that is assigned to the project.
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	ORG_ID	Organization	Organization is not valid	Verify the Organization in the Organization Structures (Accounting\Maintain\Organizations)and Organization Elements (Accounting\Maintain\Organizations) screens with the Active checkbox selected.
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	ORG_ID	Organization	Account/Org combination does not exist	Validate the link of the Account and the Organization in the Account/Organization Links screen (Accounting\Maintain\Organizations) and that the Active checkbox is selected.
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	ORG_ID	Organization	Project/Org combination does not exist	When the Organizations checkbox in the Limit group box is selected in the Basic Project Information screen (Projects\Maintain\Projects) or is set to "Y" in the PROJ.CSV file, the Project /Organization Links screen (Projects\Maintain\Projects) must contain a link for the Project and Organization.
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	ORG_ID	Organization	Project/Account/Org combination does not exist	When the Limit Which Orgs Can Charge Specific Accts checkbox is selected in the Basic Project Information (Projects\Maintain\Projects) screen or is set to "Y" in the PROJ.CSV file. The Project/Account/Organization/Ref 1/Ref 2 combination must exist in the Project/Account/Organization Links screen (Projects\Maintain\Projects)or the PROJ_ORG_ ACCT.CSV file.
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	REF1_ID	Reference 1	REF 1 does not exist	Verify that the Reference Number has been set up in the Reference Structures and Reference Elements screens.
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	REF2_ID	Reference 2	REF 2 does not exist	Verify that the Reference Number has been set up in the Reference Structures and Reference Elements screens.
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	REG_PAY_TYPE	Regular Pay Type	Pay Type is not valid	Verify that the regular pay type has been set up as a valid Pay Type Code in the Pay Types (People\Configure\Labor)screen.
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	GENL_LAB_ CAT_CD	GLC	GLC does not exist	Validate the GLC in the General Labor Categories screen (People\Configure\Labor).
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	LAB_LOC_CD	Labor Location	Labor Location does not exist	Validate the Labor Location code in the Labor Locations/Locals screen (People\Configure\Labor).
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	WORK_COMP_CD	Worker's Comp	Worker's Comp Code does not exist	Validate the Workers' Compensation Code in the Workers' Compensation Codes screen (People\Configure\Work-Related Injuries-Illnesses).
EMPL_PROJ_ TS_DFLT	Employee Project TS Defaults	BILL_LAB_CAT_CD	PLC	PLC does not exist	Validate the PLC in the Project Labor Categories (PLCs) screen (Projects\Maintain\Labor Categories).
LAB_ACCT_ GRP_DFLT	Labor-Grp-Project-Acct-Grp TS Defaults	USER_ID		User ID is not valid	Verify that the User ID exists in the database and in the Users screen(Administration\Maintain\Users).
LAB_ACCT_ GRP_DFLT	Labor-Grp-Project-Acct-Grp TS Defaults	ACCT_GRP_CD	Project Account Group	Project Account Group does not exist	Validate the Project Account Group in the Project Account Groups screen.
LAB_ACCT_ GRP_DFLT	Labor-Grp-Project-Acct-Grp TS Defaults	LAB_GRP_TYPE	Labor Group	Labor Group does not exist	Validate the Labor Group Code in the Labor Groups/Unions screen (People\Configure\Labor).
LAB_ACCT_ GRP_DFLT	Labor-Grp-Project-Acct-Grp TS Defaults	LAB_GRP_TYPE	Labor Group	Labor Group/ Project Account Group already exists	Verify that the Project Account Group/Labor Group combination does not already exist in the Labor-Grp-Project-Acct-Grp TS Defaults screen in or the LAB_ACCT_ GRP_DFLT.CSV file.
LAB_ACCT_ GRP_DFLT	Labor-Grp-Project-Acct-Grp TS Defaults	ACCT_ID	Account	Account must be a member of the Project Account Group	Verify that the Account ID has been set up for the appropriate account group in the Project Account Groups screen with a function of LABOR, NON-LABOR, UNALLOW-LABOR, or UNALLOW NON-LABR.
LAB_ACCT_ GRP_DFLT	Labor-Grp-Project-Acct-Grp TS Defaults	ORG_ID	Organization	The Account/Org Combination does not exist	Validate that the Account is linked to the Organization in the Account/Organization Links screen (Accounting\Maintain\Organizations) and that the Active field is selected.
LAB_ACCT_ GRP_DFLT	Labor-Grp-Project-Acct-Grp TS Defaults	REF1_ID	Reference 1	REF 1 does not exist	Verify that the Reference Number has been set up in the Reference Structures and Reference Elements screens.
LAB_ACCT_ GRP_DFLT	Labor-Grp-Project-Acct-Grp TS Defaults	REF2_ID	Reference 2	REF 2 does not exist	Verify that the Reference Number has been set up in the Reference Structures and Reference Elements screens.
LAB_ACCT_ GRP_DFLT	Labor-Grp-Project-Acct-Grp TS Defaults	REG_PAY_TYPE	Regular Pay Type	Pay Type is not valid	Verify that the Regular Pay Type has been set up as a valid Pay Type Code in the Pay Types screen (People\Configure\Pay Types).
LAB_ACCT_ GRP_DFLT	Labor-Grp-Project-Acct-Grp TS Defaults	GENL_LAB_ CAT_CD	GLC	GLC does not exist	Verify that the GLC has been set up in the General Labor Categories screen (People\Configure\Labor).
LAB_ACCT_ GRP_DFLT	Labor-Grp-Project-Acct-Grp TS Defaults	LAB_LOC_CD	Labor Location	Labor Location does not exist	Verify that the Labor Location Code has been set up in the Labor Locations/Locals screen (People\Configure\Labor).
LAB_ACCT_ GRP_DFLT	Labor-Grp-Project-Acct-Grp TS Defaults	WORK_COMP_CD	Worker's Comp	Worker's Comp Code does not exist	Verify that the WC Code has been set up in the Workers' Compensation Codes screen (People\Configure\Work-Related Injuries-Illnessess).
LAB_ACCT_ GRP_DFLT	Labor-Grp-Project-Acct-Grp TS Defaults	BILL_LAB_CAT_CD	PLC	PLC does not exist	Verify that the PLC has been set up in the Project Labor Categories (PLCs) screen (Projects\Maintain\Labor Categories).
EMPL_ACCT_GRP_DFLT	Employee Project/Account-Group Timesheet	USER_ID		User ID is not valid	Verify that the User ID exists in the database and in the Users screen(Administration\Maintain\Users).
EMPL_ACCT_GRP_DFLT	Employee Project/Account-Group Timesheet	EMPL_ID	Employee	Not valid when using Union Functionality	You cannot add records to this table if the Enable Union Functionality checkbox is selected in the Labor Settings screen.
EMPL_ACCT_GRP_DFLT	Employee Project/Account-Group Timesheet	EMPL_ID	Employee	Employee does not exist	Validate the employee has been set up in the Employee User Flow screen (People\Maintain\Employee).
EMPL_ACCT_GRP_DFLT	Employee Project/Account-Group Timesheet	ACCT_GRP_CD	Project Account Group	Project Account Group does not exist	Verify that the project account group has been set up in the Project Account Groups screen.
EMPL_ACCT_GRP_DFLT	Employee Project/Account-Group Timesheet	ACCT_GRP_CD	Project Account Group	Employee/Project Account Group already exists	Verify that the Employee/Project Account Group combination does not already exist in the Employee Project/Account Group Timesheet screen (People\Maintain\Timesheet Defaults), or the EMPL_ACCT_ GRP_DFLT.CSV file.
EMPL_ACCT_GRP_DFLT	Employee Project/Account-Group Timesheet	ACCT_ID	Account	Account must be a member of the Project Account Group	Verify that the Account ID has been set up for the appropriate account group in the Project Account Groups screen with a function of LABOR, NON-LABOR, UNALLOW-LABOR, or UNALLOW NON-LABR.
EMPL_ACCT_GRP_DFLT	Employee Project/Account-Group Timesheet	ORG_ID	Organization	The Account/Org Combination does not exist	Verify that the Account is linked to the Organization in the Account/Organization Links screen (Accounting\Maintain\Organizations) and that the Active field is selected.
EMPL_ACCT_GRP_DFLT	Employee Project/Account-Group Timesheet	REF1_ID	Reference 1	REF 1 does not exist	Verify that the Reference Number has been set up in the Reference Structures and Reference Elements screens.
EMPL_ACCT_GRP_DFLT	Employee Project/Account-Group Timesheet	REF2_ID	Reference 2	REF 2 does not exist	Verify that the Reference Number has been set up in the Reference Structures and Reference Elements screens.
EMPL_ACCT_GRP_DFLT	Employee Project/Account-Group Timesheet	REG_PAY_TYPE	Regular Pay Type	Pay Type is not valid	Verify that the Regular Pay Type has been set up as a valid Pay Type Code in the Pay Types screen (People\Configure\Labor).
EMPL_ACCT_GRP_DFLT	Employee Project/Account-Group Timesheet	GENL_LAB_ CAT_CD	GLC	GLC does not exist	Verify that the GLC has been set up in the General Labor Categories screen (People\Configure\Labor).
EMPL_ACCT_GRP_DFLT	Employee Project/Account-Group Timesheet	LAB_LOC_CD	Labor Location	Labor Location does not exist	Verify that the Labor Location Code has been set up in the Labor Locations/Locals screen (People\Configure\Labor).
EMPL_ACCT_GRP_DFLT	Employee Project/Account-Group Timesheet	WORK_COMP_CD	Worker's Comp	Worker's Comp Code does not exist	Verify that the WC Code has been set up in the Workers' Compensation Codes screen (People\Configure\Work-Related Injuries-Illnessess).
EMPL_ACCT_GRP_DFLT	Employee Project/Account-Group Timesheet	BILL_LAB_CAT_CD	PLC	PLC does not exist	Verify that the PLC has been set up in the Project Labor Categories (PLCs) screen (Projects\Maintain\Labor Categories).
PROJ_TS_ DFLT	Project Timesheet Defaults	USER_ID		User ID is not valid	Verify that the User ID exists in the database and in the Users screen(Administration\Maintain\Users).
PROJ_TS_ DFLT	Project Timesheet Defaults	DFLT_PROJ_ID		Project ID does not exist	Validate the Project ID in the Project Basic Information screen (Projects\Maintain\Projects).
PROJ_TS_ DFLT	Project Timesheet Defaults	PROJ_ID	Project	Project ID does not exist	Verify that the Project ID exists in either the Project Basic Information screen (Projects\Maintain\Projects) or the PROJ.CSV file.
PROJ_TS_ DFLT	Project Timesheet Defaults	PROJ_ID	Project	Project already exists	Verify that the project does not already exist in the Project Timesheet Defaults screen (Projects\Maintain\Timesheet Defaults)or the PROJ_TS_DFLT.CSV file.
PROJ_TS_ DFLT	Project Timesheet Defaults	APPLY_LOWER_LVL_FL	Apply to Lower Levels	Apply to lower levels flag is not valid	Verify that the Apply to Lower Levels flag is "Y" or "N."
PROJ_TS_ DFLT	Project Timesheet Defaults	ORG_ID	Organization	Organization is not valid	Verify that the Organization has been set up in the Organization Elements screen (Accounting\Maintain\Organizations). Also, if the Organizations checkbox is selected in the Limit group box of the Project Basic Information screen (Projects\Maintain\Project) or if it is set to "Y" in the PROJ.CSV file for this Project, then the Project/Organization combination must exist in the Project/Organization Links screen(Projects\Maintain\Project).
PROJ_TS_ DFLT	Project Timesheet Defaults	ORG_ID	Organization	Account/Org combination is not valid	Verify that the Account is linked to the Organization in the Account/Organization Links screen (Accounting\Maintain\Organizations) and that the Active field is selected. Also, if the Limit Which Orgs Can Charge Specific Accts checkbox is selected in the Project Basic Information screen (Projects\Maintain\Project) or is set to "Y" in the PROJ.CSV file, the Project/Account/ Org/Ref 1/Ref 2 combination must exist with the Active field selected in the Project/Account/Organization Links screen (Projects\Maintain\Project), or the PROJ_ORG_ ACCT.CSV file.
PROJ_TS_ DFLT	Project Timesheet Defaults	ACCT_ID	Account	Account is not valid	Verify that the Account ID has been set up in the Accounts screen (Accounting\Maintain\Accounts) with the Project Required and the Active checkboxes both selected.
PROJ_TS_ DFLT	Project Timesheet Defaults	ACCT_ID	Account	Project/Account combination does not exist or is not a member of the PAG	If the Accounts checkbox in the Limit group box of the Project Basic Information screen (Projects\Maintain\Project) is selected or is set to " " in the PROJ.CSV file, the Project/Account combination must exist in the Project/Account Links screen (Projects\Maintain\Project). If it is set to "N," the Account must exist in the project account group that is assigned to the project.
PROJ_TS_ DFLT	Project Timesheet Defaults	REF1_ID	Reference 1	REF 1 does not exist	Verify that the Reference Number has been set up in the Reference Structures and Reference Elements screens.
PROJ_TS_ DFLT	Project Timesheet Defaults	REF2_ID	Reference 2	REF 2 does not exist	Verify that the Reference Number has been set up in the Reference Structures and Reference Elements screens.
PROJ_TS_ DFLT	Project Timesheet Defaults	REG_PAY_TYPE	Regular Pay Type	Pay Type is not valid	Verify that the Regular Pay Type has been set up as a valid Pay Type Code in the Pay Types screen (People\Configure\Labor).
PROJ_TS_ DFLT	Project Timesheet Defaults	GENL_LAB_ CAT_CD	GLC	GLC does not exist	Verify that the GLC has been set up in the General Labor Categories screen (People\Configure\Labor).
PROJ_TS_ DFLT	Project Timesheet Defaults	LAB_LOC_CD Labor	Location Labor	Location does not exist	Verify that the Labor Location Code has been set up in the Labor Locations/Locals screen (People\Configure\Labor).
PROJ_TS_ DFLT	Project Timesheet Defaults	WORK_COMP_CD	Worker's Comp	Worker's Comp Code does not exist	Verify that the WC Code has been set up in the Workers' Compensation Codes screen (People\Configure\Work-Related Injuries-Illnessess).
PROJ_TS_ DFLT	Project Timesheet Defaults	BILL_LAB_CAT_CD	PLC	PLC does not exist	Verify that the PLC has been set up in the Project Labor Categories (PLCs) screen (Projects\Maintain\Labor Categories).

Revenue Formula Validation Detail

Revenue Formula	Revenue Formula Description	Allow Calc Rev On Units	Allow Calc Amt	Description	Allow Calc1 Amt	Description	Allow Calc2 Amt	Description
ETC	Cost Incurred Using Estimate To Complete	N	Y	Est To Complete	N		N
CPFH	Fee on Hours Plus Cost Incurred	Y	Y	Fee on Hours	N		N
CPFC	Cost Plus Fee On Cost	Y	Y	Labor Fee Pct.	Y	Non-Labor Fee	N
BACKLOG	Contract Value Less Backlog	N	Y	Backlog	N		N
NONE	Do Not Compute	N	N		N		N
CVPC	Contract Value Times Percent Complete	N	Y	Pct. Complete	N		N
ETBBR	Equal To Billings Before Retainage	N	N		N		N
ETBAR	Equal To Billings After Retainage	N	N		N		N
ETPL	Equal To Project Ledger Sales	N	N		N		N
ETD	Equal To Deliveries	N	N		N		N
ITDCPFC	ITD Fee on Cost	Y	Y	Labor Fee Pct.	Y	Non-Labor Fee
LLR	Loaded Labor Rate	Y	N		N		N
LLRCINL	Loaded Labor Rate Plus Cost Incurred On Non-labor (T&M)	Y	N		N		N
LLRCINLB	Loaded Labor Plus Non-labor Plus Burden on Non-labor	Y	N		N		N
LLRCINBF	Loaded Labor Plus Non-Labor W/Burden W/Fee	Y	Y	Fee Percent	N		N
FAYTD	Fixed Amount Year To Date	N	Y	YTD Revenue	N		N
FAMTD	Fixed Amount Month To Date	N	Y	MTD Revenue	N		N
FACTD	Fixed Amount Contract To Date	N	Y	CTD Revenue	N		N
UNIT	Unit Revenue Only	Y	N		N		N
LLRFNLBF	Loaded Labor Rate W/Fee Plus Non-Labor W/Burden W/Fee	Y	Y	Labor Fee Pct.	Y	Non-Labor Fee	N
CIMR	Labor Cost times Multiplier plus Non-labor times Multiplier (Hours)	Y	Y	Labor Multiplier	Y	Non-Labor	N
CVPCVSE	Contract Value Times % Complete Vs. Rate Schedule	Y	Y	Pct Complete	Y	Labor Multiplier	Y	Non-Labor
RSMNLM	Rate Schedule times Multiplier Plus Non-labor times Multiplier	Y	Y	Labor Multiplier	Y	Non-Labor	N
LLRBFNBF	Loaded Labor Rate W/Burden W/Fee Plus Non-Labor W/Burden W/Fee	Y	Y	Labor Fee Pct.	Y	Non-Labor Fee	N
CPFCCMF	Cost Plus Fee on Cost Current Month Fee	Y	Y	Labor Fee Pct.	Y	Non-Labor Fee	N
COSTIMR	Labor Cost Times Multiplier Plus Non-Labor Times Multiplier (Cost)	Y	Y	Labor Multiplier	Y	Non-Labor	N
EAC	Cost Incurred using Estimate At Completion	N	Y	Est At Comp	N		N

Billing Formula Validation Detail

Billing Formula	Billing Formula Description	Allow Calc Amt	Calc Description	Allow Calc1 Amt	Description
CPFH	Cost Incurred Plus Fee On Hours	Y	Fee On Hours	N
CPFC	Cost Incurred Plus Fee On Cost	Y	Fee Percent	N
CPFCAF	Cost Incurred Plus Fee On Cost Plus Award Fee	Y	Fee Percent	N
CPFHAF	Cost Incurred Plus Fee On Hours Plus Award Fee	Y	Fee On Hours	N
LLR	Loaded Labor Rate	N		N
LLRCINL	Loaded Labor Rate Plus Cost Incurred On Non-labor (T&M)	N		N
LLRCINLB	Loaded Labor Plus Non-labor Plus Burden On Non-labor	N		N
LLRCINBF	Loaded Labor Plus Non-labor W/Burden W/Fee	Y	Fee Percent	N
UNIT	Unit Price Transactions Only	N		N
CIMR	Labor Cost times Multiplier plus Non-labor times Multiplier (Hours)	Y	Labor Multiplier	Y	Non-Labor Multiplier
1443	Progress Payment	N		N
RSMNLM	Rate Schedule Times Multiplier Plus Non-Labor Cost Times Multiplier	Y	Labor Multiplier	Y	Non-Labor Multiplier
RSBFNLBF	Loaded Labor Rate w/Burden w/Fee plus Non-labor w/Burden w/Fee	Y	Labor Fee Percent	Y	Non-Labor Fee Percent
LLRFNLBF	LLR W/Fee Plus Non-Labor W/Burden W/Fee	Y	Labor Fee Percent	Y	Non-Labor Fee Percent
MANUAL	Manual Bills with Unbilled Detail	N		N
COSTIMR	Labor Cost Times Multiplier Plus Non-Labor Times Multiplier (Cost)	Y	Labor Multiplier	Y	Non-Labor Multiplier
NONE	Enter Bill Manually	N		N

Top of Page