| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Committed Date | Committed date of items that are over-committed | Plan Exception Details.Committed Date | COMMITTED_DATE | COMMITTED_DATE | 122668 |
| Committed Date - Day | | Plan Exception Details.Committed Date | | COMMITTED_DATE_DAY | 170781 |
| Committed Date - Month | | Plan Exception Details.Committed Date | | COMMITTED_DATE_MONTH | 170783 |
| Committed Date - Quarter | | Plan Exception Details.Committed Date | | COMMITTED_DATE_QUARTER | 170785 |
| Committed Date - Year | | Plan Exception Details.Committed Date | | COMMITTED_DATE_YEAR | 170787 |
| Compression Days | Number of days compressed | Plan Exception Details.Compression Days | COMPRESSION_DAYS | COMPRESSION_DAYS | 122974 |
| Created By | | Plan Exception Details.Created By | CREATED_BY | CREATED_BY | 124704 |
| Creation Date | | Plan Exception Details.Creation Date | CREATION_DATE | CREATION_DATE | 126130 |
| Creation Date - Day | | Plan Exception Details.Creation Date | | CREATION_DATE_DAY | 172289 |
| Creation Date - Month | | Plan Exception Details.Creation Date | | CREATION_DATE_MONTH | 172743 |
| Creation Date - Quarter | | Plan Exception Details.Creation Date | | CREATION_DATE_QUARTER | 173197 |
| Creation Date - Year | | Plan Exception Details.Creation Date | | CREATION_DATE_YEAR | 173651 |
| Demand Date | | Plan Exception Details.Demand Date | DEMAND_DATE | DEMAND_DATE | 129089 |
| Demand Date - Day | | Plan Exception Details.Demand Date | | DEMAND_DATE_DAY | 176067 |
| Demand Date - Month | | Plan Exception Details.Demand Date | | DEMAND_DATE_MONTH | 176071 |
| Demand Date - Quarter | | Plan Exception Details.Demand Date | | DEMAND_DATE_QUARTER | 176075 |
| Demand Date - Year | | Plan Exception Details.Demand Date | | DEMAND_DATE_YEAR | 176079 |
| Department Code | | Plan Exception Details.Department Code | DEPARTMENT_CODE | DEPARTMENT_CODE | 129151 |
| Department Id | Department identifier | Plan Exception Details.Department Id | DEPARTMENT_ID | DEPARTMENT_ID | 129171 |
| End Item | | Plan Exception Details.End Item | END_ITEM | END_ITEM | 272982 |
| End Order Number | | Plan Exception Details.End Order Number | END_ORDER_NUMBER | END_ORDER_NUMBER | 133162 |
| Exception Detail Id | Exception detail identifier | Plan Exception Details.Exception Detail Id | EXCEPTION_DETAIL_ID | EXCEPTION_DETAIL_ID | 133766 |
| Exception Type | Indicate the type of exception | Plan Exception Details.Exception Type | EXCEPTION_TYPE | EXCEPTION_TYPE | 133770 |
| Expire Date | Lot expiration date | Plan Exception Details.Expire Date | EXPIRE_DATE | EXPIRE_DATE | 134100 |
| Expire Date - Day | | Plan Exception Details.Expire Date | | EXPIRE_DATE_DAY | 179379 |
| Expire Date - Month | | Plan Exception Details.Expire Date | | EXPIRE_DATE_MONTH | 179381 |
| Expire Date - Quarter | | Plan Exception Details.Expire Date | | EXPIRE_DATE_QUARTER | 179383 |
| Expire Date - Year | | Plan Exception Details.Expire Date | | EXPIRE_DATE_YEAR | 179385 |
| From Date | Earliest effective date for the specification. | Plan Exception Details.From Date | FROM_DATE | FROM_DATE | 134741 |
| From Date - Day | | Plan Exception Details.From Date | | FROM_DATE_DAY | 180463 |
| From Date - Month | | Plan Exception Details.From Date | | FROM_DATE_MONTH | 180465 |
| From Date - Quarter | | Plan Exception Details.From Date | | FROM_DATE_QUARTER | 180467 |
| From Date - Year | | Plan Exception Details.From Date | | FROM_DATE_YEAR | 180469 |
| Inventory Item Id | Inventory item identifier | Plan Exception Details.Inventory Item Id | INVENTORY_ITEM_ID | INVENTORY_ITEM_ID | 137229 |
| Item | | Plan Exception Details.Item | ITEM | ITEM | 272981 |
| Item Number | | Plan Exception Details.Item Number | ITEM_NUMBER | ITEM_NUMBER | 272980 |
| Last Update Date | | Plan Exception Details.Last Update Date | LAST_UPDATE_DATE | LAST_UPDATE_DATE | 140666 |
| Last Update Date - Day | | Plan Exception Details.Last Update Date | | LAST_UPDATE_DATE_DAY | 183692 |
| Last Update Date - Month | | Plan Exception Details.Last Update Date | | LAST_UPDATE_DATE_MONTH | 184120 |
| Last Update Date - Quarter | | Plan Exception Details.Last Update Date | | LAST_UPDATE_DATE_QUARTER | 184548 |
| Last Update Date - Year | | Plan Exception Details.Last Update Date | | LAST_UPDATE_DATE_YEAR | 184976 |
| Last Updated By | | Plan Exception Details.Last Updated By | LAST_UPDATED_BY | LAST_UPDATED_BY | 139329 |
| Line Id | The number of the Line ID that is associated to the enrollment through OM or OTA. | Plan Exception Details.Line Id | LINE_ID | LINE_ID | 144639 |
| Line Name | Name of manufacturing line | Plan Exception Details.Line Name | LINE_NAME | LINE_NAME | 144694 |
| Lot Number | Code for the lot. | Plan Exception Details.Lot Number | LOT_NUMBER | LOT_NUMBER | 145892 |
| Order Date | | Plan Exception Details.Order Date | ORDER_DATE | ORDER_DATE | 149826 |
| Order Date - Day | | Plan Exception Details.Order Date | | ORDER_DATE_DAY | 187154 |
| Order Date - Month | | Plan Exception Details.Order Date | | ORDER_DATE_MONTH | 187156 |
| Order Date - Quarter | | Plan Exception Details.Order Date | | ORDER_DATE_QUARTER | 187158 |
| Order Date - Year | | Plan Exception Details.Order Date | | ORDER_DATE_YEAR | 187160 |
| Order Number | | Plan Exception Details.Order Number | ORDER_NUMBER | ORDER_NUMBER | 149874 |
| Organization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Plan Exception Details.Organization Code | ORGANIZATION_CODE | ORGANIZATION_CODE | 150088 |
| Organization Id | | Plan Exception Details.Organization Id | ORGANIZATION_ID | ORGANIZATION_ID | 150344 |
| Organization Name | | Plan Exception Details.Organization Name | ORGANIZATION_NAME | ORGANIZATION_NAME | 150642 |
| Plan Demand Id | Plan demand identifier | Plan Exception Details.Plan Demand Id | PLAN_DEMAND_ID | PLAN_DEMAND_ID | 154276 |
| Plan Name | Name of MPS, MRP, or MPS plan | Plan Exception Details.Plan Name | PLAN_NAME | PLAN_NAME | 154309 |
| Plan Supply Id | Plan supply identifier | Plan Exception Details.Plan Supply Id | PLAN_SUPPLY_ID | PLAN_SUPPLY_ID | 154339 |
| Planning Group | | Plan Exception Details.Planning Group | PLANNING_GROUP | PLANNING_GROUP | 154245 |
| Project Id | Identifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects. | Plan Exception Details.Project Id | PROJECT_ID | PROJECT_ID | 156468 |
| Project Number | | Plan Exception Details.Project Number | PROJECT_NUMBER | PROJECT_NUMBER | 156639 |
| Quantity | Item quantity | Plan Exception Details.Quantity | QUANTITY | QUANTITY | 157275 |
| Resource Code | | Plan Exception Details.Resource Code | RESOURCE_CODE | RESOURCE_CODE | 158956 |
| Resource Id | The unique identifier of the resource. | Plan Exception Details.Resource Id | RESOURCE_ID | RESOURCE_ID | 159021 |
| Supply Type | Indicate the type of supply | Plan Exception Details.Supply Type | SUPPLY_TYPE | SUPPLY_TYPE | 164355 |
| Task Id | Identifier of the task from which costs are collected, summarized, and transferred from Oracle Projects. This column is only populated if the costs were summarized by task. | Plan Exception Details.Task Id | TASK_ID | TASK_ID | 164591 |
| Task Number | User-defined number that uniquely identifies the task within a project. It is recommended to number tasks based on the wbs since that is how tasks are ordered in some reports. | Plan Exception Details.Task Number | TASK_NUMBER | TASK_NUMBER | 164666 |
| To Date | Latest effective date for the specification. | Plan Exception Details.To Date | TO_DATE | TO_DATE | 165448 |
| To Date - Day | | Plan Exception Details.To Date | | TO_DATE_DAY | 192222 |
| To Date - Month | | Plan Exception Details.To Date | | TO_DATE_MONTH | 192224 |
| To Date - Quarter | | Plan Exception Details.To Date | | TO_DATE_QUARTER | 192226 |
| To Date - Year | | Plan Exception Details.To Date | | TO_DATE_YEAR | 192228 |
| To Project Id | To project identifier | Plan Exception Details.To Project Id | TO_PROJECT_ID | TO_PROJECT_ID | 165488 |
| To Project Number | | Plan Exception Details.To Project Number | TO_PROJECT_NUMBER | TO_PROJECT_NUMBER | 165490 |
| To Task Id | To task identifier | Plan Exception Details.To Task Id | TO_TASK_ID | TO_TASK_ID | 165501 |
| To Task Number | | Plan Exception Details.To Task Number | TO_TASK_NUMBER | TO_TASK_NUMBER | 165503 |
| Utilization Percent | Resource utilization percent | Plan Exception Details.Utilization Percent | UTILIZATION_PERCENT | UTILIZATION_PERCENT | 167079 |
| Committed Date | Committed date of items that are over-committed | Plan Exception Details.Committed Date | COMMITTED_DATE | COMMITTED_DATE | 122668 |
| Committed Date - Day | | Plan Exception Details.Committed Date | | COMMITTED_DATE_DAY | 170781 |
| Committed Date - Month | | Plan Exception Details.Committed Date | | COMMITTED_DATE_MONTH | 170783 |
| Committed Date - Quarter | | Plan Exception Details.Committed Date | | COMMITTED_DATE_QUARTER | 170785 |
| Committed Date - Year | | Plan Exception Details.Committed Date | | COMMITTED_DATE_YEAR | 170787 |
| Compression Days | Number of days compressed | Plan Exception Details.Compression Days | COMPRESSION_DAYS | COMPRESSION_DAYS | 122974 |
| Created By | | Plan Exception Details.Created By | CREATED_BY | CREATED_BY | 124704 |
| Creation Date | | Plan Exception Details.Creation Date | CREATION_DATE | CREATION_DATE | 126130 |
| Creation Date - Day | | Plan Exception Details.Creation Date | | CREATION_DATE_DAY | 172289 |
| Creation Date - Month | | Plan Exception Details.Creation Date | | CREATION_DATE_MONTH | 172743 |
| Creation Date - Quarter | | Plan Exception Details.Creation Date | | CREATION_DATE_QUARTER | 173197 |
| Creation Date - Year | | Plan Exception Details.Creation Date | | CREATION_DATE_YEAR | 173651 |
| Demand Date | | Plan Exception Details.Demand Date | DEMAND_DATE | DEMAND_DATE | 129089 |
| Demand Date - Day | | Plan Exception Details.Demand Date | | DEMAND_DATE_DAY | 176067 |
| Demand Date - Month | | Plan Exception Details.Demand Date | | DEMAND_DATE_MONTH | 176071 |
| Demand Date - Quarter | | Plan Exception Details.Demand Date | | DEMAND_DATE_QUARTER | 176075 |
| Demand Date - Year | | Plan Exception Details.Demand Date | | DEMAND_DATE_YEAR | 176079 |
| Department Code | | Plan Exception Details.Department Code | DEPARTMENT_CODE | DEPARTMENT_CODE | 129151 |
| Department Id | Department identifier | Plan Exception Details.Department Id | DEPARTMENT_ID | DEPARTMENT_ID | 129171 |
| End Item | | Plan Exception Details.End Item | END_ITEM | END_ITEM | 272982 |
| End Order Number | | Plan Exception Details.End Order Number | END_ORDER_NUMBER | END_ORDER_NUMBER | 133162 |
| Exception Detail Id | Exception detail identifier | Plan Exception Details.Exception Detail Id | EXCEPTION_DETAIL_ID | EXCEPTION_DETAIL_ID | 133766 |
| Exception Type | Indicate the type of exception | Plan Exception Details.Exception Type | EXCEPTION_TYPE | EXCEPTION_TYPE | 133770 |
| Expire Date | Lot expiration date | Plan Exception Details.Expire Date | EXPIRE_DATE | EXPIRE_DATE | 134100 |
| Expire Date - Day | | Plan Exception Details.Expire Date | | EXPIRE_DATE_DAY | 179379 |
| Expire Date - Month | | Plan Exception Details.Expire Date | | EXPIRE_DATE_MONTH | 179381 |
| Expire Date - Quarter | | Plan Exception Details.Expire Date | | EXPIRE_DATE_QUARTER | 179383 |
| Expire Date - Year | | Plan Exception Details.Expire Date | | EXPIRE_DATE_YEAR | 179385 |
| From Date | Earliest effective date for the specification. | Plan Exception Details.From Date | FROM_DATE | FROM_DATE | 134741 |
| From Date - Day | | Plan Exception Details.From Date | | FROM_DATE_DAY | 180463 |
| From Date - Month | | Plan Exception Details.From Date | | FROM_DATE_MONTH | 180465 |
| From Date - Quarter | | Plan Exception Details.From Date | | FROM_DATE_QUARTER | 180467 |
| From Date - Year | | Plan Exception Details.From Date | | FROM_DATE_YEAR | 180469 |
| Inventory Item Id | Inventory item identifier | Plan Exception Details.Inventory Item Id | INVENTORY_ITEM_ID | INVENTORY_ITEM_ID | 137229 |
| Item | | Plan Exception Details.Item | ITEM | ITEM | 272981 |
| Item Number | | Plan Exception Details.Item Number | ITEM_NUMBER | ITEM_NUMBER | 272980 |
| Last Update Date | | Plan Exception Details.Last Update Date | LAST_UPDATE_DATE | LAST_UPDATE_DATE | 140666 |
| Last Update Date - Day | | Plan Exception Details.Last Update Date | | LAST_UPDATE_DATE_DAY | 183692 |
| Last Update Date - Month | | Plan Exception Details.Last Update Date | | LAST_UPDATE_DATE_MONTH | 184120 |
| Last Update Date - Quarter | | Plan Exception Details.Last Update Date | | LAST_UPDATE_DATE_QUARTER | 184548 |
| Last Update Date - Year | | Plan Exception Details.Last Update Date | | LAST_UPDATE_DATE_YEAR | 184976 |
| Last Updated By | | Plan Exception Details.Last Updated By | LAST_UPDATED_BY | LAST_UPDATED_BY | 139329 |
| Line Id | The number of the Line ID that is associated to the enrollment through OM or OTA. | Plan Exception Details.Line Id | LINE_ID | LINE_ID | 144639 |
| Line Name | Name of manufacturing line | Plan Exception Details.Line Name | LINE_NAME | LINE_NAME | 144694 |
| Lot Number | Code for the lot. | Plan Exception Details.Lot Number | LOT_NUMBER | LOT_NUMBER | 145892 |
| Order Date | | Plan Exception Details.Order Date | ORDER_DATE | ORDER_DATE | 149826 |
| Order Date - Day | | Plan Exception Details.Order Date | | ORDER_DATE_DAY | 187154 |
| Order Date - Month | | Plan Exception Details.Order Date | | ORDER_DATE_MONTH | 187156 |
| Order Date - Quarter | | Plan Exception Details.Order Date | | ORDER_DATE_QUARTER | 187158 |
| Order Date - Year | | Plan Exception Details.Order Date | | ORDER_DATE_YEAR | 187160 |
| Order Number | | Plan Exception Details.Order Number | ORDER_NUMBER | ORDER_NUMBER | 149874 |
| Organization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Plan Exception Details.Organization Code | ORGANIZATION_CODE | ORGANIZATION_CODE | 150088 |
| Organization Id | | Plan Exception Details.Organization Id | ORGANIZATION_ID | ORGANIZATION_ID | 150344 |
| Organization Name | | Plan Exception Details.Organization Name | ORGANIZATION_NAME | ORGANIZATION_NAME | 150642 |
| Plan Demand Id | Plan demand identifier | Plan Exception Details.Plan Demand Id | PLAN_DEMAND_ID | PLAN_DEMAND_ID | 154276 |
| Plan Name | Name of MPS, MRP, or MPS plan | Plan Exception Details.Plan Name | PLAN_NAME | PLAN_NAME | 154309 |
| Plan Supply Id | Plan supply identifier | Plan Exception Details.Plan Supply Id | PLAN_SUPPLY_ID | PLAN_SUPPLY_ID | 154339 |
| Planning Group | | Plan Exception Details.Planning Group | PLANNING_GROUP | PLANNING_GROUP | 154245 |
| Project Id | Identifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects. | Plan Exception Details.Project Id | PROJECT_ID | PROJECT_ID | 156468 |
| Project Number | | Plan Exception Details.Project Number | PROJECT_NUMBER | PROJECT_NUMBER | 156639 |
| Quantity | Item quantity | Plan Exception Details.Quantity | QUANTITY | QUANTITY | 157275 |
| Resource Code | | Plan Exception Details.Resource Code | RESOURCE_CODE | RESOURCE_CODE | 158956 |
| Resource Id | The unique identifier of the resource. | Plan Exception Details.Resource Id | RESOURCE_ID | RESOURCE_ID | 159021 |
| Supply Type | Indicate the type of supply | Plan Exception Details.Supply Type | SUPPLY_TYPE | SUPPLY_TYPE | 164355 |
| Task Id | Identifier of the task from which costs are collected, summarized, and transferred from Oracle Projects. This column is only populated if the costs were summarized by task. | Plan Exception Details.Task Id | TASK_ID | TASK_ID | 164591 |
| Task Number | User-defined number that uniquely identifies the task within a project. It is recommended to number tasks based on the wbs since that is how tasks are ordered in some reports. | Plan Exception Details.Task Number | TASK_NUMBER | TASK_NUMBER | 164666 |
| To Date | Latest effective date for the specification. | Plan Exception Details.To Date | TO_DATE | TO_DATE | 165448 |
| To Date - Day | | Plan Exception Details.To Date | | TO_DATE_DAY | 192222 |
| To Date - Month | | Plan Exception Details.To Date | | TO_DATE_MONTH | 192224 |
| To Date - Quarter | | Plan Exception Details.To Date | | TO_DATE_QUARTER | 192226 |
| To Date - Year | | Plan Exception Details.To Date | | TO_DATE_YEAR | 192228 |
| To Project Id | To project identifier | Plan Exception Details.To Project Id | TO_PROJECT_ID | TO_PROJECT_ID | 165488 |
| To Project Number | | Plan Exception Details.To Project Number | TO_PROJECT_NUMBER | TO_PROJECT_NUMBER | 165490 |
| To Task Id | To task identifier | Plan Exception Details.To Task Id | TO_TASK_ID | TO_TASK_ID | 165501 |
| To Task Number | | Plan Exception Details.To Task Number | TO_TASK_NUMBER | TO_TASK_NUMBER | 165503 |
| Utilization Percent | Resource utilization percent | Plan Exception Details.Utilization Percent | UTILIZATION_PERCENT | UTILIZATION_PERCENT | 167079 |