Query Wage Code Hours
Explanation
This activity is used to analyse how many hours employees spend on
activities connected to different wage codes or wage types. You can view ,e.g., the summarized
number of hours employees are scheduled to work or who was present at work. You
can combine up to twelve wage types and wage codes. You can also perform
additions, subtractions and divisions in various calculations. It is possible to
save your queries so that you can use them at a later time.
Window
Wage Hours Analysis
Related Window Descriptions
Wage Hours Analysis
Procedure
- Open the Wage Hours Analysis window.
- In the From and To fields, enter the time period from
which data will be displayed.
- In the graphical organization tree, select a node for which you will
display data. The organization tree represents all companies and matrix
organizations that you can access. Nodes connected directly to the
Organization Tree (the root of the structure) at the top are eighter
entire companies or matrix organizations. If you expand them, you will see
their organization unit nodes.
- Select one of the options under Display Data From.
- Selected Unit will allow you to display data only from the
node you selected in step 3.
- Organization Branch will allow you to display data from the
selected node and all of its subordinate units.
- If you select the Summarize Employee Data check box, all records
registered by the same employee on a specific wage code will be merged
together.
- If you have a data selection template, you can load it by pressing
Load in the Data Selection Template area, and selecting a
relevant template.
If you don't have a selection template prepared, you will have to define
what data you want to display. To do this, use fields under the Employee
Data Selection area. In each of the 12 fields you can enter:
- Wage Code or Wage Type - for each wage code or type a new column
will be added to the table. This column will display the number of hours
registered by employees on this code during the time period specified in
step 2.
- Calculations - if you select any of the calculations, a column with
the result will appear in the table. Every data selection field can add
all preceeding fields or subtract/divide the last 2 fields. Remember
that fields are listed from top to bottom, and then from left to right.
- To populate the table with data that meet requirements specified in
previous steps, click Populate.
- Examine the data.
- You can right-click the table and click Graph in order to display
all currently selected records in form of a graph.
- If you would like to save data selection settings you prepared under
Employee Data Selection, you can save them as a data selection template.
To do so, click the Save button located under the Data Selection
Template area. A dialog box will appear.
- Enter the name for the template and press OK.