“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...