3 Columns

This query is used to get the date that is 12 months after the effective start date of an element entry value associated with a payroll relationship group.
13 Mar

This query is used to get the date that is 12 months after the effective

Read More
This query gets the display name of the active line manager assigned to an employee based on the current system date.
13 Mar

This query gets the display name of the active line manager assigned to an employee

Read More
This query is used to get the person number of the active line manager assigned to an employee as of a specific effective date.
13 Mar

This query is used to get the person number of the active line manager assigned

Read More
This query is used to get the date that is 12 months after the effective start date of an element entry value associated with a payroll relationship group.
13 Mar

This query is used to get the date that is 12 months after the effective

Read More
This query retrieves the screen entry value of an element entry input value (Amount or Total Amount) associated with a payroll relationship group. 
13 Mar

This query retrieves the screen entry value of an element entry input value (Amount or

Read More
SQL to Get the screen entry value for a specific payroll element input value. 
26 Feb

SQL to Get the screen entry value for a specific payroll element input value. 

Read More
SQL to get the end date of the latest assigned payroll time period. 
26 Feb

SQL to get the end date of the latest assigned payroll time period. 

Read More
SQL Query to get Active Flex Value
26 Feb

SQL Query to get Active Flex Value

Read More
Get External Worker Value1 Data 
26 Feb

Get External Worker Value1 Data 

Read More