Batch Status Summary Report - File Layout and Data Mapping

The default file names for the Batch Status Summary report are:

Excel: batchStatusSummaryrpt<####_####>.xlsx
PDF: batchStatusSummary<YYYY-MM-DD####_#####>.pdf

The following table shows the columns, column names, descriptions, and data sources or valid values for the Batch Status Summary report.

Column	Column Name	Description	Data Source or Valid Values
A	YEAR	The fiscal year associated with the batch position.	Retrieved from the Fiscal Year field on the Batch Position Control page.
B	JOB CLASS	The job classification code associated with the position.	Retrieved from the Job Class field in the Position section of the Edit Batch Position page. This is limited to job classes already under Position Control.
C	CLASS DESCRIPTION	The full title of the job class code.	Retrieved from the Title field on the Job Class page.
D	POSITION	The unique code that identifies the position within its job class.	Retrieved from the Position field in the Position section of the Edit Batch Position page.
E	POSITION DESCRIPTION	The descriptive name of the position.	Retrieved from the Position Title field in the Position section of the Edit Batch Position page.
F	LOCATION	The location code indicating where the position is based.	Retrieved from the Location field in the Position section of the Edit Batch Position page.
G	LOCATION DESCRIPTION	The description of the location code.	Retrieved from the Building Name field on the Location Table 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 Edit Batch Position page.
I	POSITION TYPE DESCRIPTION	The short description of the position type code.	Retrieved from the read-only description beside the Position Type field in the Position section of the Edit Batch Position page.
J	AUTHORIZED FTE	The total FTE approved for the position.	Retrieved from the Authorized FTE field in the FTE section on the Edit Batch Position page.
K	FILLED FTE	The FTE currently occupied by the employee.	Retrieved from the Filled FTE field in the FTE section on the Edit Batch Position page.
L	AVAILABLE FTE	The FTE remaining to be filled, calculated as Authorized FTE minus Filled FTE.	Retrieved from the Available FTE field in the FTE section on the Edit Batch Position page.