Position LDPR Query

Area(s) of Analysis
Agency Detail - Position
position-01-code.doc
Date Submitted
Contact Full Name
Leah Hynes
Agency
Department of Natural Resources
Phone number
526-1078
Email
leah.hynes@dnr.mo.gov
Description

This query will give you which LDPRs are the defaults for certain positions or vice versa. I use this query before I expire an LDPR to make sure that it is not someone's default. If it is someone's default, I will not expire the LDPR until HR changes the default. This query uses an agency view of the BKG_PHST table.

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.