About the Statistical Data Mart (SDM)

(EHRI-SDM)

The Statistical Data Mart (EHRI-SDM),which was established in 2010 and uses data from the Enterprise Human Resources Initiative (EHRI), is the Federal Government's primary source of detailed information about its employees.

The SDM is an automated file covering about 96 percent of all Federal civilian non-Postal Executive Branch employees. The data elements in SDM include those reflected on the employee's Standard Form 50, Notification of Personnel Action. The SDM system includes information about individuals such as date of birth, sex, race/national origin (maintained along with disabled data under strict precautions to protect identification of individuals in personnel records), service computation date, tenure, educational level, veterans preference, geographic location of duty, pay plan, grade, salary, occupational series, and supervisory status.

Dynamic and Status Files are extracted from the Statistical Data Mart (SDM), we have provided a brief description below of each of these files.

1. The Dynamics File records personnel actions such as the hiring and separating of employees. It includes all Executive Branch agencies except the U.S. Postal Service, the Postal Rate Commission, the Central Intelligence Agency, the National Security Agency, the Office of the Director of National Intelligence, the Tennessee Valley Authority, the White House Office, the Office of the Vice President, the Board of Governors of the Federal Reserve System, and the Defense Intelligence Agency.

   Other exclusions include: Non appropriated fund employees in Defense activities, Commissioned Corps employees, and Foreign Nationals employed outside of the U.S. or its territories.

2. The Status File records demographic information, job information, the agency of employment and location of employees, and other aspects of the on-board Federal workforce. It contains the same agencies as the Dynamics File except the Status File also includes data from the Federal Bureau of Investigation prior to FY 2007.