Core HR Archives - Thinkapace Consulting – Transforming Businesses with ERP

SQL to Fetch the Security profiles

SQL to Fetch the Security profiles

SQL to pull Employee Location

SQL to pull Employee Location

SQL to Pull the Global Transfer Records

SQL to Pull the Global Transfer Records

SQL to pull county, State, Zip from Vertex

SQL to pull county, State, Zip from Vertex

SQL to pull Position and Parent Position

SQL to pull Position and Parent Position

Select DISTINCT papf_empp.person_number employee_number,ppnf.first_name||’ ‘||ppnf.last_name employee_name,(select hapft.namefrom hr_all_positions_f hapf, HR_ALL_POSITIONS_F_TL...

SQL to Fetch the Action which action has been performed and when for the cancelled work relationship and Reverse Termination

SQL to Fetch the Action which action has been performed and when for the cancelled work relationship and Reverse Termination

Hire an Employee

Hire an Employee

1.Login:Open the environment URL. Enter ‘User Id’, ‘Password’ and click...

Terminate an Employee

Terminate an Employee

1.Login:Open the environment URL. Enter ‘User Id’, ‘Password’ and click...

SQL to pull the Terminated Employees

SQL to pull the Terminated Employees

SQL to Fetch the Address Change