PRFPS¶
Overview¶
The PRFPS capability provides project budget postings and job group analysis from the Avero PRFPS extension. Budget entries are tracked by project, account, and period with breakdowns by entry type — resource, machine, item, and G/L — for plan-versus-actual financial reporting.
Semantic Model Tables¶
Dimensions¶
| Table | Description |
|---|---|
| Project Entry Type | Classifies each budget line as resource, machine, item, GL, or revenue for drill-down analysis |
Facts¶
| Fact Table | Description |
|---|---|
| Project Budgets | Budget entries per project, account, and period — amounts, usage, sales, and profit by entry type |
Key Measures (8)¶
Project Budgets (8)¶
Project Budget Amount, Project Budget GL Usage, Project Budget Item Usage, Project Budget Machine Usage, Project Budget Profit, Project Budget Resource Usage, Project Budget Sales, Project Budget Usage
Use Cases¶
- Budget tracking — Monitor project budget entries by entry type (resource, machine, item, GL) and compare against actuals
- Budget variance — Compare budget amounts to actual project ledger entries for variance analysis
- Cost type analysis — Break down budgeted costs by resource, item, machine, and G/L usage categories