Status Summary Report - File Layout and Data Mapping

The default file names for the Status Summary report are:

Excel: posnStatusSummaryrpt<####_#####>.xlsx
PDF: posnStatusSummary<YYYY-MM-DD####_#####>.pdf

The following table shows the columns, column names, descriptions, and data sources or valid values for the Status Summary 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 Status Summary Report 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 Status Summary Report page.
B	JOB CLASS	The job classification code associated with the position.	Retrieved from the Job Class field in the Position section of the Position Detail page.
C	CLASS DESCRIPTION	The full title of the job class code.	Retrieved from the Title field on the live or Future Job Classes reference table
D	POSITION	The unique code that identifies the position within its job class.	Retrieved from the Position field in the Position section of the Position Detail page.
E	POSITION DESCRIPTION	The descriptive name of the position,	Retrieved from the Position Title field in the Position section of the Position Detail page.
F	LOCATION	The location code indicating where the position is based.	Retrieved from the Location field in the Position section of the Position Detail page.
G	LOCATION DESCRIPTION	The description of the location code.	Retrieved from the Building Name field on the Location Table page.
H	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.
I	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.
J	AUTHORIZED FTE	The total FTE approved for the position.	Retrieved from the Authorized FTE field in the FTE section on the Position Detail page.
K	FILLED FTE	The FTE currently occupied by the employee.	Retrieved from the Filled FTE field in the FTE section on the Position Detail page.
L	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.
M	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.
N	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.
O	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.
P	POSTING 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.