BLS CES Report - File Layout and Data Mapping

The default file names for the BLS CES report are:

Excel: BLS CES Report_<YYYY_MM>.xlsx
PDF: BLS CES Report_<YYYY_MM>.pdf

The PDF file contains a summary that shows the total number of employees, female employees, and faculty members, as well as individual employee details for easy verification.

The following table shows the columns, column names, descriptions, and data sources or valid values for the BLS CES report’s Excel file format.

Column	Column Name	Description	Data Source or Valid Values
A	REPORT YEAR	The reporting year of the CES data.	Retrieved from the Year field on the BLS CES Report page.
B	REPORT MONTH	The reporting month for the CES data.	Retrieved from the Month field on the BLS CES Report page.
C	EMPLOYEE NUMBER	The employee’s identification (ID) number.	Retrieved from the Employee Number field on the Employee Information page.
D	LAST NAME	The employee's last name.	Retrieved from the Last Name field on the Employee Information page.
E	FIRST NAME	The employee’s first name.	Retrieved from the First Name field on the Employee Information page.
F	MIDDLE INITIAL	The employee's middle initial.	Retrieved from the Middle Name field on the Employee Information page.
G	EMPLOYEE WAGES	The total gross wages paid to an employee for the entire pay period that includes the 12th day of each month in the reporting quarter.	The valid value is the total gross wages paid to an employee for the entire pay period that includes the 12th day of each month in the reporting quarter.
H	PAID ON 12TH OF MONTH	Indicates whether the employee was paid during the pay period that includes the 12th day of each month in the quarter.	Valid values: Y N
I	GENDER	The employee's gender.	Valid values: M - Male F - Female Retrieved from the Sex at Birth field on the Employee Information page.
J	FACULTY MEMBER	Indicates whether the employee is classified as a faculty member.	The valid value is N.