This page (revision-17) was last changed on 26-Nov-2021 10:22 by Karen Parrott

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
17 26-Nov-2021 10:22 7 KB Karen Parrott to previous
16 26-Nov-2021 10:22 7 KB Karen Parrott to previous | to last
15 26-Nov-2021 10:22 7 KB kparrott to previous | to last
14 26-Nov-2021 10:22 7 KB RForbes to previous | to last
13 26-Nov-2021 10:22 7 KB JMyers to previous | to last
12 26-Nov-2021 10:22 7 KB JMyers to previous | to last
11 26-Nov-2021 10:22 7 KB JMyers to previous | to last
10 26-Nov-2021 10:22 7 KB JMyers to previous | to last
9 26-Nov-2021 10:22 6 KB JMyers to previous | to last
8 26-Nov-2021 10:22 7 KB JMyers to previous | to last
7 26-Nov-2021 10:22 7 KB JMyers to previous | to last
6 26-Nov-2021 10:22 7 KB JMyers to previous | to last
5 26-Nov-2021 10:22 7 KB JMyers to previous | to last
4 26-Nov-2021 10:22 6 KB JMyers to previous | to last
3 26-Nov-2021 10:22 6 KB JMyers to previous | to last
2 26-Nov-2021 10:22 6 KB JMyers to previous | to last
1 26-Nov-2021 10:22 6 KB JMyers to last

Page References

Incoming links Outgoing links
FINDING_RECORDS
FINDING_RECORDS

Version management

Difference between version and

At line 15 changed one line
In the example below a query can be performed on the IEAS to provide a list of employees that work in the same location.
In the example below a query can be performed on the IEAS to provide a list of employees that work in the same location.\\
[FindingRecords_01.jpg]
At line 19 changed 3 lines
To perform a query
1) Place your cursor in the Find Block/List
2) Click on the icon in the toolbar. A separate window will open. This window contains three fields that will need to be populated
To perform a query:
#Place your cursor in the Find Block/List
#Click on the flashlight icon in the toolbar. A separate window will open. This window contains four areas that will need to be populated
#*Field Prompt: This is the name of the field in which your query is being performed. In this example we will be doing a query based on employees that fall into a certain position.
#*Comparison Operator: The search is performed by comparing the Field prompt to the value indicated in the value field. The comparison operator determines the action of the comparison.
#*Value: This is the value of the Field prompt in which the query is being performed.
#*Filter by As Of Date: This toggle determines what records will be examined. If this toggle is enabled then only the current records will be examined. If the toggle is not turned on then every record that meets the criteria.
#Once the Query Criteria has been entered select “OK”. This opens another window displaying the query results. Scrolling with your cursor through each of these records the IEAS will change to reflect the highlighted employee
At line 23 changed one line
a. Field Prompt: This is the name of the field in which your query is being performed. In this example we will be doing a query based on employees that fall into a certain position.
When using the query function it is important to note that in most cases your cursor should be located in the Find Block/List in which you are trying to query from.
At line 25 changed one line
b. Comparison Operator: The search is performed by comparing the Field prompt to the value indicated in the value field. The comparison operator determines the action of the comparison.
%%information Note that while the Position field on IEAS is found on the P2K_HR_ASSIGNMENT_DETAILS it is the FIND_EEM that determines what record is displayed.%%
At line 27 changed one line
c. Value: This is the value of the Field prompt in which the query is being performed.
Screens that contain individual tables in the form like IPTR, IALS, IBSC, IPTL etc. can also be queried without using the find. In the example below two separate results occur when the same query is performed with the cursor in different locations on IPTR.
At line 29 changed 4 lines
d. Filter by As Of Date: This toggle determines what records will be examined. If this toggle is enabled then only the current records will be examined. If the toggle is not turned on then every record that meets the criteria will be included in the query results
3) Once the Query Criteria has been entered select “OK”. This opens another window displaying the query results. Scrolling with your cursor through each of these records the IEAS will change to reflect the highlighted employee
With the cursor in the IPTR Find Block/List: The query found all batches that contained employees that met the wage rate criteria.\\
[FindingRecords_02.jpg]\\
[FindingRecords_03.jpg]
At line 34 changed 10 lines
When using the query function it is important to note that in most cases your cursor should be located in the Find Block/List in which you are trying to query from. Note that while the Position field on IEAS is found on the P2K_HR_ASSIGNMENT_DETAILS it is the FIND_EEM that determines what record is displayed.
Screens that contain individual tables in the form like IPTR, IALS, IBSC, IPTL etc. can also be queried without using the find. In the example below two separate results occur when the same query is performed with the cursor in different locations on IPTR
The following query was performed on IPTR
With the cursor in the IPTR Find Block/List: The query found all batches that contained employees that met the wage rate criteria.
When the cursor was located on the PTR grid: Transaction records for employees that met the criteria in the current batch were displayed.\\
[FindingRecords_04.jpg]\\
[FindingRecords_05.jpg]
At line 46 removed one line
At line 48 removed 2 lines
When the cursor was located on the PTR grid: Transaction records for employees that met the criteria in the current batch were displayed.
At line 51 removed 3 lines
This page (revision-17) was last changed on 26-Nov-2021 10:22 by Karen ParrottTop