Status Detail Report - File Layout and Data Mapping

The default file names for the Status Detail report are:

Excel: posnStatusDetailrpt<####_#####>.xlsx
PDF: posnStatusDetail<YYYY-MM-DD####_#####>.pdf

The following table shows the columns, column names, descriptions, and data sources or valid values for the Status Detail 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 Detail 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 Detail Report page.
B	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.
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 depending on dates.
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	EMPLOYEE NUMBER	The employee’s identification (ID) number. This field is blank if the position is not filled.	Retrieved from the Employee Number field on the Occupants as of [date] page.
K	NAME	The employee’s name. This field displays "POS NOT FILLED" if there is no current occupant.	Retrieved from the Name field on the Occupants as of [date] page.
L	OCCUPANT STATUS	The occupant’s relationship to the position.	Valid values: Current Occupant Pending Vacancy Pending Filled Retrieved from the Status field on the Occupants as of [date] page.
M	AUTHORIZED FTE	The total FTE approved for the position.	Retrieved from the Authorized FTE field in the FTE section on the Position Detail page.
N	FILLED FTE	The FTE currently occupied by the employee.	Retrieved from the Filled 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	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.
S	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.
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 Status Detail Report page.	Retrieved from User Defined Field 1 on the Position Status Detail 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 Status Detail Report page.	Retrieved from User Defined Field 2 on the Position Status Detail Report page.
V	(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 Status Detail Report page.	Retrieved from User Defined Field 3 on the Position Status Detail Report page.
W	(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 Status Detail Report page.	Retrieved from User Defined Field 4 on the Position Status Detail Report page.
X	(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 Status Detail Report page.	Retrieved from User Defined Field 5 on the Position Status Detail Report page.
Y	(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 Status Detail Report page.	Retrieved from User Defined Field 6 on the Position Status Detail Report page.
Z	(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 Status Detail Report page.	Retrieved from User Defined Field 7 on the Position Status Detail Report page.
AA	(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 Status Detail Report page.	Retrieved from User Defined Field 8 on the Position Status Detail Report page.
AB	(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 Status Detail Report page.	Retrieved from User Defined Field 9 on the Position Status Detail Report page.
AC	(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 Status Detail Report page.	Retrieved from User Defined Field 10 on the Position Status Detail Report page.