eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: HR.HR_PERSON_DELTA_SYNC#

Source

View Text - Preformatted


select EMPLOYEE_NUMBER EMPLOYEE_NUMBER, USER_PERSON_TYPE USER_PERSON_TYPE, DATE_OF_BIRTH DATE_OF_BIRTH, TOWN_OF_BIRTH TOWN_OF_BIRTH, COUNTRY_OF_BIRTH COUNTRY_OF_BIRTH, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, DATE_OF_DEATH DATE_OF_DEATH, ORIGINAL_DATE_OF_HIRE ORIGINAL_DATE_OF_HIRE, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, SEX SEX, MARITAL_STATUS MARITAL_STATUS, FULL_NAME FULL_NAME, PRE_NAME_ADJUNCT PRE_NAME_ADJUNCT, SUFFIX SUFFIX, TITLE TITLE, LAST_NAME LAST_NAME, FIRST_NAME FIRST_NAME, MIDDLE_NAMES MIDDLE_NAMES, ADDRESS_TYPE ADDRESS_TYPE, DATE_FROM DATE_FROM, COUNTRY COUNTRY, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, ADDRESS_LINE3 ADDRESS_LINE3, TOWN_OR_CITY TOWN_OR_CITY, TELEPHONE_NUMBER_1 TELEPHONE_NUMBER_1, REGION_1 REGION_1, REGION_2 REGION_2, POSTAL_CODE POSTAL_CODE, EMAIL_ADDRESS EMAIL_ADDRESS, PHONE_TYPE PHONE_TYPE, PHONE_NUMBER PHONE_NUMBER, NATIONALITY NATIONALITY, NATIONAL_IDENTIFIER NATIONAL_IDENTIFIER, STATUS STATUS, EFFECTIVE_STATUS_DATE EFFECTIVE_STATUS_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, RECORD_KEY RECORD_KEY from "HR"."HR_PERSON_DELTA_SYNC"

View Text - HTML Formatted

SELECT EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, USER_PERSON_TYPE USER_PERSON_TYPE
, DATE_OF_BIRTH DATE_OF_BIRTH
, TOWN_OF_BIRTH TOWN_OF_BIRTH
, COUNTRY_OF_BIRTH COUNTRY_OF_BIRTH
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, DATE_OF_DEATH DATE_OF_DEATH
, ORIGINAL_DATE_OF_HIRE ORIGINAL_DATE_OF_HIRE
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, SEX SEX
, MARITAL_STATUS MARITAL_STATUS
, FULL_NAME FULL_NAME
, PRE_NAME_ADJUNCT PRE_NAME_ADJUNCT
, SUFFIX SUFFIX
, TITLE TITLE
, LAST_NAME LAST_NAME
, FIRST_NAME FIRST_NAME
, MIDDLE_NAMES MIDDLE_NAMES
, ADDRESS_TYPE ADDRESS_TYPE
, DATE_FROM DATE_FROM
, COUNTRY COUNTRY
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, ADDRESS_LINE3 ADDRESS_LINE3
, TOWN_OR_CITY TOWN_OR_CITY
, TELEPHONE_NUMBER_1 TELEPHONE_NUMBER_1
, REGION_1 REGION_1
, REGION_2 REGION_2
, POSTAL_CODE POSTAL_CODE
, EMAIL_ADDRESS EMAIL_ADDRESS
, PHONE_TYPE PHONE_TYPE
, PHONE_NUMBER PHONE_NUMBER
, NATIONALITY NATIONALITY
, NATIONAL_IDENTIFIER NATIONAL_IDENTIFIER
, STATUS STATUS
, EFFECTIVE_STATUS_DATE EFFECTIVE_STATUS_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, RECORD_KEY RECORD_KEY
FROM "HR"."HR_PERSON_DELTA_SYNC"