The default file names for the Budget Tracking report are:
-
Excel: posnBudgetTrackingReportrpt<####_#####>.xlsx
-
PDF: posnBudgetTracking<YYYY-MM-DD####_####>.pdf
The following table shows the columns, column names, descriptions, and data sources or valid values for the Budget Tracking report.
|
Column |
Column Name |
Description |
Data Source or Valid Values |
|---|---|---|---|
|
A |
JOB CLASS |
The job classification code associated with the position. |
Retrieved from the live or Future Job Classes reference table depending on dates. |
|
B |
CLASS DESCRIPTION |
The full title of the job class code. |
Retrieved from the live or Future Job Classes reference table depending on dates. |
|
C |
POSITION |
The unique code that identifies the position within its job class and fiscal year. |
Retrieved from the Position field in the Position section of the Position Detail page. |
|
D |
POSITION DESCRIPTION |
The descriptive name of the position, |
Retrieved from the Position Title field in the Position section of the Position Detail page. |
|
E |
LOCATION |
The location code indicating where the position is based. |
Retrieved from the Location field in the Position section of the Position Detail page. |
|
F |
LOCATION DESCRIPTION |
The description of the location code.
|
Retrieved from the Building Name field on the Location Table page. |
|
G |
POSITION STATUS |
Indicates the current lifecycle state of the position. |
Retrieved from the Position Status field in the Position section of the Position Detail page. |
|
H |
POSITION TYPE |
A classification code that categorizes the position, for example, full-time or part-time. |
Retrieved from the Position Type field in the Position section of the Position Detail page. |
|
I |
BUDGETED SALARY |
The budgeted salary for the position. |
Retrieved from the Budgeted field in the Salary section on the Position Detail page. |
|
J |
ACTUAL SALARY |
The salary amount actually paid to the position's occupants as of the most recent payroll run. |
Retrieved from the Actual (as of last payroll) field in the Salary section on the Position Detail page. |
|
K |
PROJECTED SALARY |
The projected annual salary for the position's occupants, calculated as of the most recent payroll run. |
Retrieved from the Projected (as of last payroll) field in the Salary section on the Position Detail page. |
|
L |
(User Defined Field label) |
District-configured user-defined field. Only included if user-defined fields are enabled and Include User Defined Fields in PDF Report is selected on the Position Budget Tracking Report page. |
Retrieved from User Defined Field 1 on the Position Budget Tracking Report page. |
|
M |
(User Defined Field label) |
District-configured user-defined field. Only included if user-defined fields are enabled and Include User Defined Fields in PDF Report is selected on the Position Budget Tracking Report page. |
Retrieved from User Defined Field 2 on the Position Budget Tracking Report page. |
|
N |
(User Defined Field label) |
District-configured user-defined field. Only included if user-defined fields are enabled and Include User Defined Fields in PDF Report is selected on the Position Budget Tracking Report page. |
Retrieved from User Defined Field 3 on the Position Budget Tracking Report page. |
|
O |
(User Defined Field label) |
District-configured user-defined field. Only included if user-defined fields are enabled and Include User Defined Fields in PDF Report is selected on the Position Budget Tracking Report page. |
Retrieved from User Defined Field 4 on the Position Budget Tracking Report page. |
|
P |
(User Defined Field label) |
District-configured user-defined field. Only included if user-defined fields are enabled and Include User Defined Fields in PDF Report is selected on the Position Budget Tracking Report page. |
Retrieved from User Defined Field 5 on the Position Budget Tracking Report page. |
|
Q |
(User Defined Field label) |
District-configured user-defined field. Only included if user-defined fields are enabled and Include User Defined Fields in PDF Report is selected on the Position Budget Tracking Report page. |
Retrieved from User Defined Field 6 on the Position Budget Tracking Report page. |
|
R |
(User Defined Field label) |
District-configured user-defined field. Only included if user-defined fields are enabled and Include User Defined Fields in PDF Report is selected on the Position Budget Tracking Report page. |
Retrieved from User Defined Field 7 on the Position Budget Tracking Report page. |
|
S |
(User Defined Field label) |
District-configured user-defined field. Only included if user-defined fields are enabled and Include User Defined Fields in PDF Report is selected on the Position Budget Tracking Report page. |
Retrieved from User Defined Field 8 on the Position Budget Tracking Report page. |
|
T |
(User Defined Field label) |
District-configured user-defined field. Only included if user-defined fields are enabled and Include User Defined Fields in PDF Report is selected on the Position Budget Tracking Report page. |
Retrieved from User Defined Field 9 on the Position Budget Tracking Report page. |
|
U |
(User Defined Field label) |
District-configured user-defined field. Only included if user-defined fields are enabled and Include User Defined Fields in PDF Report is selected on the Position Budget Tracking Report page. |
Retrieved from User Defined Field 10 on the Position Budget Tracking Report page. |