To run a successful import, your CSV files must have a minimum set of data.
The tables here show the minimum content your CSV file needs to have to be imported successfully.
Minimum data requirements.
Projects (Tag Assignments) | Control Element Categories | WBS Templates | Tags | Rules of Credit Templates |
---|---|---|---|---|
Project Name | Name | Parent Code | Tag Category Name | |
Tag Category | Type | Name | Tag Name | |
Tag Code | Unit of Measure (if the type is quantity) | Code | Tag Code |
Cost Worksheet, WBS, Control Accounts and Work Packages | Control Elements | Schedule Activities | Direct Actuals |
---|---|---|---|
Parent Code | Control Account Code | Control Account Code | Control Element Name |
Name | Type | Name | Control Element Type |
Code | Name | Code | Control Account Code |
Type | Activity Weight | Item | |
Current Percent Complete | Actual | ||
Percent Complete Method | Post Date |
Contracts | Contract Pay Items | Payment Applications | Payment Applications Items | Payment Applications Status Change |
---|---|---|---|---|
Contract No. | Contract No. | Contract No. | Contract No. | Contract No. |
Name | Pay Item No. | Payment Application No. | Pay Item No. | Payment Application No. |
Downstream Org. | Name | Name | Payment Application No. | Status |
Contract Currency | Control Account | Payment Application Date | Requested Percent Complete | |
Default Control Account | Control Element | Internal Reporting Period No. | Requested Amount | |
Default Control Element | Original Contract | Retention Method | Accepted Percent Complete | |
Accepted Amount | ||||
Explanation |
Change Events | Change Events Items | Contract Changes | Contract Changes items |
---|---|---|---|
Event No. | Event No. | Contract No. | Contract No. |
Name | Item No. | Contract Change No. | Contract Change No. |
Status | Name | Name | Pay Item No. |
Event Date | Budget Impact | Contract Change Date | Name |
Cost Impact | Contract Change Status | Control Account | |
Contract No. | Contract Change Amount | Control Element | |
Pay Item No. | Contract Item | Contract Change Amount | |
Control Account | |||
Control Element | |||
Amount |