SAM II Financial SAM II HR/Payroll SAM II Data Warehouse
SAM II
bar

HR AdHoc Access Reports


Areas of Analysis: Agency Detail - Position History

bullet   Research on Position History & Sample Report     Get Source Code

get word viewer

 


Date Submitted:
8/5/04
Contact Person:
Stephanie Brooks
Agency:
Office of Administration
Phone Number:
526-2713
Email Address:
Stephanie.Brooks@oa.mo.gov
Brief Description of Report:
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.

AdHoc Access Reports Home Go to AdHoc Access Reports Home

Home    Missouri State Home    OA Home    Privacy    Advanced Search