“This query is used to get the person number of employees who are eligible in a compensation workforce plan.”
This query selects the PERSON_NUMBER from the CMP_CWB_PERSON_INFO table for individuals included in a...
“This query is used to get the display name of the line manager assigned to an employee.”
This query selects the DISPLAY_NAME of a manager from PER_PERSON_NAMES_F who is assigned as...
This query is used to get the rounded rate amount of a salary pay component for an active employee assignment.”
This query selects the RATE_AMOUNT from CMP_SALARY_PAY_COMPONENTS and rounds the value to two decimal places using...
“This query is used to get the value of the fifty percent field from the market composites table in character format.”
This query selects the FIFTY_PERCENT column from the CMP_MKT_COMPOSITES table and converts the value...
“This query is used to get the person number of employees who have a primary active assignment and valid global name records.”
This query selects the PERSON_NUMBER from PER_ALL_PEOPLE_F for individuals classified as employees. It joins PER_ALL_ASSIGNMENTS_M to...
“This query is used to get the start date of an employee’s period of service.”
This query selects the DATE_START from PER_PERIODS_OF_SERVICE and formats it as DD-MON-YYYY using the TO_CHAR function. It joins PER_ALL_PEOPLE_F with PER_ALL_ASSIGNMENTS_F to identify the...
“This query is used to get the document number of purchase orders that are not in incomplete or cancelled status.
This query selects the SEGMENT1 column from the PO_HEADERS_ALL table, which typically represents the purchase order number....
This query is used to get a concatenated value consisting of an external worker data value and its associated currency code.”
This query selects data from the CMP_EXTERNAL_WORKER_DATA table. It concatenates the VALUE1 column with...
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.
This query selects the EFFECTIVE_START_DATE from PAY_ELEMENT_ENTRY_VALUES_F and calculates a new date by adding 12...
This query gets the display name of the active line manager assigned to an employee based on the current system date.
This query selects the DISPLAY_NAME of a manager from PER_PERSON_NAMES_F who is assigned as...