Research on Position History & Sample Report

Area(s) of Analysis: 
Agency Detail - Position History
Microsoft Office document icon Download (45.5 KB)
Date Submitted: 
Contact Full Name: 
Randall Hutton
Office of Administration
Phone Number: 

This report includes preliminary research on position history. A sample report includes the history of one position for FY03. To complete a final report, users would still have to join the result table from this series of four queries to other warehouse tables to get information such as employee name and position long descriptions. Users might need the number of authorized FTE at the end of FY03 (available on BKG_PSAT). Users would also need to do an additional query to list out the positions that were vacant for the whole year as they are not reflected in this data.


The Office of Administration has not tested the source code for any of these Access or FOCUS AdHoc Reports. The Office of Administration is providing the source code as a service and will not accept responsibility for any inaccuracies. The Office of Administration will also not support the code. Please contact the developer of the code for further information.