Importing PCI Details

To import PCI Details from a file rather than entering them manually, press the [Import] button in the PCI Details section when creating a new PCI. This button only appears for unposted PCIs. The following pop-up will then appear.

The CMDetail Import pop-up screen

Check the 'Delete existing imported records' box to remove any temporary data previously uploaded using this import tool. This option does not delete or overwrite any existing records in the system. Press the [Choose File] button to search for the PCI Import file. See the below section for details on what this file should contain.

After the file has been uploaded, press the [Upload] button.

A validation screen will then appear. If there are any errors caused by the import, then they will appear here. Press the [Revalidate] button after correcting any errors to check the file again. Once there are no more errors, press the [Accept] button to pull the validated records into the PCI Detail section.

PCI Import File Details

The import file should be uploaded in the following layout. The file must be in TXT or CSV format.

The format for all PCI Import files.

The following table gives information for all PCI Import file fields.

	Column Name	Description	Required	Type	Length
1	CMDI_COMP_CODE	A valid CMiC company code	Yes	Varchar2	10
2	CMDI_CHG_CODE	PCI Code (should match with code from PCI Header record)	Yes	Varchar2	10
3	CMDI_MAST_JOB_CODE	A valid CMiC job code	Yes	Varchar2	10
4	CMDI_JOB_CODE	This is the job in the detail of the change order and may be a sub-job of the job in the header	Yes	Varchar2	10
5	CMDI_SC_VEN_CODE	Subcontract Vendor Code - required if a subcontract is related to the change	No	Varchar2	8
6	CMDI_SC_CONT_CODE	Subcontract Code - required if a subcontract is related to the change	No	Varchar2	20
7	CMDI_PHS_CODE	Must be a valid phase code for the job	Yes	Varchar2	16
8	CMDI_CAT_CODE	Must be a valid category for the job	Yes	Varchar2	16
9	CMDI_REF_NAME	This field populates the Long Description column displayed in the PCI Details screen	No	Varchar2	4000
10	CMDI_BUDG_WM_CODE	A valid WM code must be entered	No	Varchar2	2
11	CMDI_BILL_CODE	Bill Code – required if External or OBC class PCI and a Job Billing type job, otherwise it is optional	No	Varchar2	50
12	CMDI_SC_CHG_CODE	Subcontract change code - required if a subcontract is related to the change	No	Varchar2	12
13	CMDI_SC_TASK_CODE	Subcontract change task code - required if a subcontract change code is entered	No	Varchar2	16
14	CMDI_DAYS_IMPACT	The impact of the change in Number of Days	No	Num	10
15	CMDI_ACT_CODE	Activity Code	No	Varchar2	10
16	CMDI_PHS_UNIT	Phase Quantity - leave blank if not required	No	Num	16, 8
17	CMDI_BUDG_QTY	Budget Quantity related to Change order – may be left blank if not applicable	No	Num	16, 8
18	CMDI_BUDG_EST_UNIT_RATE	Estimated Rate	No	Num	16, 4
19	CMDI_EST_BUDG_AMT	Estimated Amount	No	Num	18, 2
20	CMDI_BUDG_QUOTED_UNIT_RATE	Quoted Rate	No	Num	16, 4
21	CMDI_QUOTED_BUDG_AMT	Quoted Amount	No	Num	18, 2
22	CMDI_BUDG_UNIT_RATE	Budgeted (Final) Rate	No	Num	16, 4
23	CMDI_BUDG_AMT	Enter the Budget (Final) Amount	No	Num	18, 2
24	CMDI_BILL_UNIT	Optional billing units are added here	No	Num	10, 3
25	CMDI_BILL_UNIT_RATE	Billing Rate	No	Num	18, 4
26	CMDI_BILL_AMT	Required if External or OBC class PCI and a Job Billing type job- if left blank it will be 0	No	Num	18, 2
27	CMDI_STATUS_CODE	Change Order Status – must be a valid CMiC change order status code; *if left blank it will be updated with the status from the header on editing the PCI	No	Varchar2	10
28	CMDI_OWNER_CHG_CODE	Owner Change Order Number if required	No	Varchar2	20
29	CMDI_WBSV_CODE1	WBS Code 1 Value	No	Varchar2	10
30	CMDI_WBSV_CODE2	WBS Code 2 Value	No	Varchar2	10
31	CMDI_WBSV_CODE3	WBS Code 3 Value	No	Varchar2	10
32	CMDI_WBSV_CODE4	WBS Code 4 Value	No	Varchar2	10
33	CMDI_CLV_VALUE_CODE1	Classifier Value 1	No	Varchar2	16
34	CMDI_CLV_VALUE_CODE2	Classifier Value 2	No	Varchar2	16
35	CMDI_CLV_VALUE_CODE3	Classifier Value 3	No	Varchar2	16
36	CMDI_CLV_VALUE_CODE4	Classifier Value 4	No	Varchar2	16
37	CMDI_CLV_VALUE_CODE5	Classifier Value 5	No	Varchar2	16
38	CMDI_CLV_VALUE_CODE6	Classifier Value 6	No	Varchar2	16
39	CMDI_DFLT_BILL_CODE_FLAG	The values for this column can be set to "Y", "N", or null. When the value for this column is set to "Y" for a line item, the Default Bill Code checkbox will be set to checked for that line. If the value is set to "N" or null (null will be considered as "N" in applicable cases), the Default Bill Code checkbox will be unchecked for that line.	No	Varchar2