Enlisted Employee Review (EER) Tracking In Process Query

Introduction

This query will provide the status of an EER as it progresses through work lists in DA. As long as the EER has been initiated and NOT clicked Final, it will be retrieved by the query.

Before You Begin

Access to this query is limited to users with the "CGSSCMD"- Command Self-Service User Role.

Procedure

Start Internet Explorer, sign into Direct-Access (note, see the Signing In topic in the Using Direct-Access section if you need help getting started) and follow these steps to complete this procedure.

Step	Action
1	Select menu items in the following order (note, see the Basic Navigation topic for help on using menus): Direct Access Content > People Tools > Query Manager > Use > Query Manager
2	The Query Manger will open. Complete the search criteria in the "Find an Existing Query". Enter all or part of the query name - CG_EMPL_REVW_TRACKING. Then, click the "Search Button"
3	Select the "Run" link for the CG_EMPL_REVW_TRACKING/Empl Rvw Tracking In Process query.
4	The query criteria input dialog will open in a new window. The new window will have 4 blocks to fill out. Use AUSCG for the Set ID. Enter the dept ID number of the unit you are checking the status of. Enter the begin month, ex. 11/01/2011. Enter the end month, ex. 11/30/2011. Queries should be limited to monthly queries. If a report is too big in size, DA will not be able to pull the information you are trying obtain.
5	Click the "View Results" button. The query will take some time to retrieve the information. Once the report populates, it is in Excel format and can be printed or downloaded and saved. The Worklist Name will show who has had the EER in their work list in DA. The work list status shows who still has this eval in their work list. This status will say either Open, Worked on Not on Worklist. The below information will be provided on the query (Note: Names and employee IDs have been "blanked out" in the image below):

Troubleshooting

1. A member assigned to my unit does not show up on my query.

a. Check the member's Dept ID, member may be assigned to a separate department.

b. The eval may not be initiated and saved in DA

c. The eval may be clicked Final.

2. I receive an error that states web site cannot be displayed. The size of the report is too big for DA to retrieve.

a. Try using a sub dept ID for your unit. This will minimize the amount of information DA is trying to retrieve. Try using a smaller date range, for example, 11/30/2011 to 11/30/2011.