Position Table Report - File Layout and Data Mapping

The default file names for the Position Table report are:

Excel: posnTableReportrpt<####_#####>.xlsx
PDF: posnTableReport<YYYY-MM-DD####_#####>.pdf.

Fixed Columns

Columns 1-22 are always included.

The following table shows the columns, column names, descriptions, and data sources or valid values for the fixed columns in the Position Table report.

Column	Column Name	Description	Data Source or Valid Values
A	AS OF DATE	The date entered in the As of Date field on the Position Control page. The report returns position records with an effective date on or before the specified date, reflecting each position's state as of that date.	Retrieved from the As of Date field on the Position Control page.
B	EFFECTIVE DATE	The date the change takes effect.	Retrieved from the Effective Date field in the Position section on the Position Detail page.
C	JOB CLASS	The job classification code associated with the position.	Retrieved from the Job Class field on the live or Future Job Classes reference table depending on dates.
D	JOB CLASS TITLE	The full title of the job class code.	Retrieved from the Title field on the live or Future Job Classes reference table depending on dates.
E	POSITION	The unique code that identifies the position within its job class and fiscal year.	Retrieved from the Position field in the Position section on the Position Detail page.
F	POSITION TITLE	The descriptive name of the position,	Retrieved from the Position Title field in the Position section on the Position Detail page.
G	LOCATION	The location code indicating where the position is based.	Retrieved from the Location field in the Position section on the Position Detail page.
H	LOCATION DESCRIPTION	The description of the location code.	Retrieved from the Building Name field on the Location Table page.
I	POSITION STATUS	Indicates the current lifecycle state of the position.	Valid values: A-Active I-Inactive C-Close N-In Progress Retrieved from the Position Status field in the Position section on the Position Detail page.
J	APPROVAL STATUS	The current workflow state of the New Position request.	Valid values: O-Open A-Approved D-Denied N-Canceled C-Needs Correction X-Posted Retrieved from the Approval Status field in the General section of the Change Request page.
K	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 on the Position Detail page.
L	AUTHORIZED FTE	The total FTE approved for the position.	Retrieved from the Authorized FTE field in the FTE section on the Position Detail page.
M	FILLED FTE	The FTE currently occupied by employees actively assigned to the position.	Retrieved from the Filled FTE field in the FTE section on the Position Detail page.
N	AVAILABLE FTE	The FTE remaining to be filled, calculated as Authorized FTE minus Filled FTE minus any pending occupancy changes.	Retrieved from the Available FTE field in the FTE section on the Position Detail page.
O	PENDING ADJUSTMENT FTE	The FTE amount from Adjust FTE change requests submitted but not yet approved or applied.	Retrieved from the Pending Adjustment FTE field in the FTE section on the Position Detail page.
P	PENDING VACANCY FTE	The FTE that will become vacant when pending employee departures or position transfers are approved and take effect.	Retrieved from the Pending Vacancy FTE field in the FTE section on the Position Detail page.
Q	PENDING FILLED FTE	The FTE that will be occupied when pending employee assignments or position transfers are approved and take effect.	Retrieved from the Pending Filled FTE field in the FTE section on the Position Detail page.
R	POSTED FTE	The number of FTEs posted on an Applicant Tracking System (ATS) job board.	Retrieved from the Posting FTE field in the FTE section on the Position Detail page.
S	DEFAULT FTE	The standard FTE value applied automatically when a new occupant is assigned to the position.	Retrieved from the Default FTE field in the FTE section on the Position Detail page.
T	BUDGETED SALARY	The budgeted salary for the position.	Retrieved from the Budgeted field in the Salary section on the Position Detail page.
U	ACTUAL SALARY (AS OF LAST PAYROLL)	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.
V	PROJECTED SALARY (AS OF LAST PAYROLL)	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.

Include Account Columns (Optional)

Columns 23-28 are included when Include Accounts on Report is selected on the Position List Report page.

There are two variants depending on the account format:

Full account format

Columns 23-27 are displayed when Full Account Structure is enabled.

The following table shows the columns, column names, descriptions, and data sources or valid values for the account columns in the Position Table report when Full Account Structure is enabled.

Column	Column Name	Description	Data Source or Valid Values
W	ACCOUNT NUMBER	The full GL account number used to fund the position. Combines the organization and account into a single formatted string.	Retrieved from the Full Account field in the Funding section on the Position Control page.
X	ACCOUNT PERCENT	The percentage of the position's costs allocated to this account number.	Retrieved from the % field in the Funding section on the Position Control page.
Y	PROJECT	The project code identifying the funding source.	Retrieved from the Project field in the Project section on the Position Control page.
Z	PROJECT ACCOUNT	The account code associated with the project distribution line.	Retrieved from the Account field in the Project section on the Position Control page.
AA	PROJECT PERCENT	The percentage of the position's costs allocated to this project line.	Retrieved from the % field in the Project section on the Position Control page.

Budget-unit format

Columns 23-28 are displayed when the Budget-unit format is enabled.

The following table shows the columns, column names, descriptions, and data sources or valid values for the account columns in the Position Table report when the Budget-unit format is enabled.

Column	Column Name	Description	Data Source or Valid Values
W	BUDGET UNIT	The organization (budget unit) code used to fund the position.	Retrieved from the Budget Unit field in the Funding section on the Position Control page.
X	ACCOUNT	The account code associated with the budget unit distribution line.	Retrieved from the Account field in the Funding section on the Position Control page.
Y	ACCOUNT PERCENT	The percentage of the position's cost charged to the corresponding account or organization funding row.	Valid values are 0 to 1.00, where 1.00 represents 100%. Retrieved from the % field in the Funding section on the Position Control page.
Z	PROJECT	The project code identifying the funding source.	Retrieved from the Project field in the Project section on the Position Control page.
AA	PROJECT ACCOUNT	The account code associated with the project distribution line.	Retrieved from the Account field in the Project section on the Position Control page.
AB	PROJECT PERCENT	The percentage of the position's costs allocated to this project line.	Retrieved from the % field in the Project section on the Position Control page.

Include Comments Columns (Optional)

Columns 23-25 are included when Include Notes on Report is selected on the Position List Report page. The columns are appended starting at column 23 and are mutually exclusive with the Account columns in the layout.

The following table shows the columns, column names, descriptions, and data sources or valid values for the comments columns in the Position Table report.

Column	Column Name	Description	Data Source or Valid Values
W	REQUEST DATE	The date the position change request was entered into the system.	Retrieved from the Date Entered field in the General section of the Change Request page.
X	CHANGE TYPE	The category of change submitted in the position change request, such as Position Title Change, Location Change, Funding Change, or Adjust FTE.	Retrieved from the Change Type section on the Change Request page.
Y	CHANGE NOTES	The notes entered by the user describing the reason for or details of the position change request.	Retrieved from the Change Notes section on the Change Request page.

Column

Column Name

Description

Data Source or Valid Values

REQUEST DATE

The date the position change request was entered into the system.

Retrieved from the Date Entered field in the General section of the Change Request page.

CHANGE TYPE

The category of change submitted in the position change request, such as Position Title Change, Location Change, Funding Change, or Adjust FTE.

Retrieved from the Change Type section on the Change Request page.

CHANGE NOTES

The notes entered by the user describing the reason for or details of the position change request.

Retrieved from the Change Notes section on the Change Request page.

User-Defined Field Columns (Optional, up to 10 columns)

Up to 10 additional columns are appended after all preceding columns.

Subtotal Rows (xlsx format only)

When a sort field has totals enabled, a subtotal row is inserted after each group. The row contains:

Column 1: Label — TOTAL [code] [description] (e.g., TOTAL 100 Teacher)
Columns 12–19: FTE group sums (Authorized, Filled, Available, Pending Adjustment, Pending Vacancy, Pending Filled, Posted, Default FTE)
Columns 20–22: NULL (no salary totals)