This topic applies only if you are upgrading from a version earlier than P6 Professional 8.2.
The following table illustrates the risks data field mapping when upgrading from P6 Professional database (version 6.2.1 through 7.0 SP3) to P6 Professional 8.x.
Note: Some fields will migrate to text fields instead new fields because certain fields no longer correspond. The new text fields are noted below.
Risks Fields Migration Table
Name | P6 Professional database (version 6.2.1 through 7.0 SP3) Risks Fields | P6 Professional 8.x Risks Field |
---|---|---|
Risk ID | risk_id | risk_id |
| risk_id | risk_code (PROJRISK appended with risk_id) |
Risk Name | risk_name | risk_name |
Risk Description | risk_descr | risk_desc |
Risk Status | status_code | status_code |
Risk Category ID | risk_type_id | risk_type_id |
Risk Control | risk_control | cause (with 'Risk Control' heading) |
Risk UDFs | table_name | table_name |
Applies to WBS | wbs_id | cause (with 'Applies to WBS' <WBS name> heading) |
Applies to Resource | rsrc_id | rsrc_id |
Responsible Manager | obs_id | cause (with 'Responsible Manager' <OBS name> heading) |
Priority | priority_type | cause (with 'Priority' <priority_type> heading) |
Project ID | proj_id | proj_id |
Date Identified | add_date | add_date |
Impact Date | impact_date | cause (with 'Impact Date' <add_date in mmm-dd-yyyy format > heading) |
Probability | prbly_pct | cause (with 'Probability' <prbly_pct> heading) |
Impact - Labor Units | impact_work_qty | cause (with 'Impact - Labor Units' <impact_work_qty> - 2 decimals heading) |
Impact - Nonlabor Units | impact_equip_qty | cause (with 'Impact - Nonlabor Units' <impact_equip_qty> - 2 decimals heading) |
Impact - Material Units | impact_mat_qty | cause (with 'Impact - Material Units' <impact_mat_qty> - 2 decimals heading) |
Impact - Expenses | Impact_expense_cost | cause (with 'Impact - Expenses' <impact_expense_cost> - 2 decimals heading) |
Risk Control | risk_control | cause (with 'Risk Control'<risk_control> heading) |
Risk Category | risk_type | risk_type |
Risk Category Sequence ID | seq_num | seq_num |