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.
Position LDPR Query
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.