Standard Column Sets
You can use the following predefined standard column sets. You can also modify these column sets to meet your reporting needs.
Suggestion: We suggest that you do not modify standard column sets directly, since other reports may depend on the standard definitions. Instead, use AutoCopy to make a copy of the standard column set whose definition you want to change. Then, modify the copy as needed before using it in your report definition.
PTD VARIANCE: Includes actual, budget, variance, and variance percentage for the current period only.
QTD VARIANCE: Includes actual, budget, variance, and variance percentage for the current quarter only.
PTD, QTD, YTD VARIANCE: Includes actual, budget, variance, and variance percentage for the current period, quarter-to-date, and year-to-date. Amounts are in thousands.
PTD, QTD, YTD ACTUAL: Includes actual current period, quarter-to-date, and year-to-date.
MONTHLY ACTUAL: Includes monthly actuals for each month of the fiscal year plus a year-to-date total. Amounts are in thousands.
MONTHLY BUDGET: Includes monthly budget amounts for each month of the fiscal year plus a year-to-date total. Amounts are in thousands.
QUARTERLY ACTUAL: Includes quarterly actuals for each quarter of the fiscal year plus a year-to-date total.
QUARTERLY BUDGET : Includes quarterly budget amounts for each quarter of the fiscal year plus a year-to-date total.
ROLLING MONTHLY: Includes actual amounts for the current month and the preceding 11 months. Amounts are in thousands.
ROLLING QUARTERLY: Includes actual amounts for the current quarter and the preceding 4 quarters. Amounts are in thousands.
MONTHLY COMPARATIVE YTD: Includes current year-to-date and prior period year-to-date.
QUARTERLY COMPARATIVE YTD: Includes year-to-date balance for the current quarter and the previous three quarters.
ANNUAL COMPARATIVE QTD, YTD : Includes actual amounts for the current quarter, prior year same quarter, variance, and variance percentage. Also includes actual amounts for current year-to-date, prior year-to-date, variance, and variance percentage.
FUNDS AVAILABLE: Includes year-to-date funds available based on posted actuals, budgets, and encumbrances. Also includes total budget for year and the percentage of total budget remaining. You can use this column set to show your obligations for encumbrance reports.
See Also
Copying Report Objects