Review Reason Trend - Technical Specification
These are the mini-dashboards and Analytical Objects that are used to populate the Forecast Analysis dashboard
Mini-Dashboard | Analytical Object |
|---|---|
Forecasting | |
Review Reason Supply Planning | |
Recommended Orders Trend |
Forecasting
The data used to generate this mini-dashboard is based on the following:
These are the Review Types used:
• Actual vs Forecast outside of calculated Demand Standard Deviation 1(1)
• Outlier Adjustment applied (86)
• Tracking Signal - Actuals Greater than Forecast (138)
• Tracking Signal - Forecast Greater than Actuals (139)
Analytical Object | AO_PAI_ReviewReasonTrend_Forecasting | ||||||
Query Object | QO_PAI_ReviewReasonTrendForecast | ||||||
Data Source | PAI Advanced | ||||||
Cab File | SPM_PAI_Advanced.cab | ||||||
Query Object Primary Table | IPCS_REVIEW_BOARD | ||||||
Query Object Tables | IPCS_REVIEW_REASONS IPCS_REVIEW_BOARD IPCS_LOC_MASTER IPCS_PART_MASTER IPCS_PLANNER_CODES | ||||||
Parameters |
| ||||||
Predecessor Jobs | Archival | ||||||
Build Type | The following build types are supported: • Full | ||||||
Build Frequency | These build frequencies are supported: • Daily • Weekly • Monthly | ||||||
• Location • Part Number • Period • Planner Code • Review Reason | |||||||
|
Review Reason Supply Planning
The data used to generate this mini-dashboard is based on the following:
These are the Review Types used:
• Critically Short: Zero On Hand with Backorder (331)
• Critically Short Today (334)
• Critically Short (18)
• In Excess (19)
• Excess with host orders within Lead Time (329)
Analytical Object | AO_PAI_ReviewReasonTrend_SupplyPlanning | ||||||
Query Object | QO_PAI_ReviewReason_SupplyPlanning | ||||||
Data Source | PAI Advanced | ||||||
Cab File | SPM_PAI_Advanced.cab | ||||||
Query Object Primary Table | IPCS_REVIEW_BOARD | ||||||
Query Object Tables | IPCS_REVIEW_REASONS IPCS_REVIEW_BOARD IPCS_LOC_MASTER IPCS_PART_MASTER IPCS_PLANNER_CODES | ||||||
Parameters |
| ||||||
Predecessor Jobs | Archival | ||||||
Build Type | The following build types are supported: • Full | ||||||
Build Frequency | These build frequencies are supported: • Daily • Weekly • Monthly | ||||||
• Location • Part Number • Period • Planner Code • Review Reason | |||||||
|
Recommended Orders Trend
The data used to generate this mini-dashboard is based on the following:
These are the Review Types that are used:
• New Recommended Excess Recall Orders (332)
• New Recommended Repair Orders (323)
• New Recommended Replenishment Orders (324)
• New Recommended Balancing Orders (325)
• New Recommended Procurement Orders (326)
Analytical Object | AO_PAI_ReviewReasonTrend_ToDays | ||||||
Query Object | QO_PAI_ReviewReasonTrendToDays | ||||||
Data Source | PAI Advanced | ||||||
Cab File | SPM_PAI_Advanced.cab | ||||||
Query Object Primary Table | IPCS_REVIEW_BOARD | ||||||
Query Object Tables | IPCS_REVIEW_REASONS IPCS_REVIEW_BOARD IPCS_LOC_MASTER IPCS_PART_MASTER IPCS_PLANNER_CODES | ||||||
Parameters |
| ||||||
Predecessor Jobs | Archival | ||||||
Build Type | The following build types are supported: • Full | ||||||
Build Frequency | These build frequencies are supported: • Daily • Weekly • Monthly | ||||||
• Location • Part Number • Period • Planner Code • Review Reason | |||||||
|