Research on Position History & Sample Report

Area(s) of Analysis
Agency Detail - Position History
position-description.doc
Date Submitted
Contact Full Name
Randall Hutton
Agency
Office of Administration
Phone number
522-9683
Email
Randall.Hutton@oa.mo.gov
Description

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.

DISCLAIMER:

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.