VIEW: HR.HR_WORKFORCE_DELTA_SYNC#

Source

View Text - Preformatted

select EMPLOYEE_NUMBER EMPLOYEE_NUMBER, EMPL_RCD EMPL_RCD, ORIGINAL_DATE_OF_HIRE ORIGINAL_DATE_OF_HIRE, PROBATION_PERIOD PROBATION_PERIOD, EFFDT EFFDT, ORGANIZATION_ID ORGANIZATION_ID, JOB_ID JOB_ID, ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID, LOCATION_ID LOCATION_ID, EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, NORMAL_HOURS NORMAL_HOURS, FREQUENCY FREQUENCY, GRADE_ID GRADE_ID, SUPERVISOR_ID SUPERVISOR_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, STEP_ID STEP_ID, FINAL_PROCESS_DATE FINAL_PROCESS_DATE, ACCEPTED_TERMINATION_DATE ACCEPTED_TERMINATION_DATE, STATUS STATUS, EFFECTIVE_STATUS_DATE EFFECTIVE_STATUS_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, EVENT_KEY EVENT_KEY from "HR"."HR_WORKFORCE_DELTA_SYNC"

View Text - HTML Formatted

SELECT EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, EMPL_RCD EMPL_RCD
, ORIGINAL_DATE_OF_HIRE ORIGINAL_DATE_OF_HIRE
, PROBATION_PERIOD PROBATION_PERIOD
, EFFDT EFFDT
, ORGANIZATION_ID ORGANIZATION_ID
, JOB_ID JOB_ID
, ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID
, LOCATION_ID LOCATION_ID
, EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, NORMAL_HOURS NORMAL_HOURS
, FREQUENCY FREQUENCY
, GRADE_ID GRADE_ID
, SUPERVISOR_ID SUPERVISOR_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, STEP_ID STEP_ID
, FINAL_PROCESS_DATE FINAL_PROCESS_DATE
, ACCEPTED_TERMINATION_DATE ACCEPTED_TERMINATION_DATE
, STATUS STATUS
, EFFECTIVE_STATUS_DATE EFFECTIVE_STATUS_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, EVENT_KEY EVENT_KEY
FROM "HR"."HR_WORKFORCE_DELTA_SYNC"