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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.HR_PERSON_DELTA_SYNC

Object Details

Object Name:	HR_PERSON_DELTA_SYNC
Object Type:	TABLE
Owner:	HR
Subobject Name:
Status:	VALID

HR_PERSON_DELTA_SYNC holds the delta sync(RIR) information for the Person in HR HelpDesk.Regular Incremental Refresh(RIR) XML message for Person is generated with this information,in XML Gateway.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
EMPLOYEE_NUMBER	VARCHAR2	(30)	Employee/Contingent Worker Number.
USER_PERSON_TYPE	VARCHAR2	(60)	User Person Type eg Employee,Ex-Employee
DATE_OF_BIRTH	DATE		Date of Birth.
TOWN_OF_BIRTH	VARCHAR2	(90)	Town of Birth.
COUNTRY_OF_BIRTH	VARCHAR2	(90)	Country Of Birth.
BUSINESS_GROUP_ID	NUMBER	(15)	Business Group Id.
DATE_OF_DEATH	DATE		Date of Death.
ORIGINAL_DATE_OF_HIRE	DATE		Original Date of Hire.
EFFECTIVE_START_DATE	DATE		Effective Start Date of the Employee/Contingent Worker.
SEX	VARCHAR2	(30)	Sex.
MARITAL_STATUS	VARCHAR2	(30)	Marital Status.
FULL_NAME	VARCHAR2	(240)	Concatenation of last name, title, first name, middle names and the name the person is known by.
PRE_NAME_ADJUNCT	VARCHAR2	(30)	Name prefix.
SUFFIX	VARCHAR2	(30)	Suffix after the surname e.g. Sr., Jr., III
TITLE	VARCHAR2	(30)	Title e.g. Mr, Mrs, Dr.
LAST_NAME	VARCHAR2	(150)	Last name of the person, (surname, family name).
FIRST_NAME	VARCHAR2	(150)	First name of person.
MIDDLE_NAMES	VARCHAR2	(90)	Middle names.
ADDRESS_TYPE	VARCHAR2	(30)	Address Type.
DATE_FROM	DATE		Start date at the address.
COUNTRY	VARCHAR2	(60)	Country.
ADDRESS_LINE1	VARCHAR2	(240)	The first line of the address.
ADDRESS_LINE2	VARCHAR2	(240)	The second line of the address.
ADDRESS_LINE3	VARCHAR2	(240)	The third line of the address.
TOWN_OR_CITY	VARCHAR2	(30)	Town or city name.
TELEPHONE_NUMBER_1	VARCHAR2	(60)	Telephone number for the address.
REGION_1	VARCHAR2	(120)	Primary region in which the address is located.
REGION_2	VARCHAR2	(120)	Sub region of region 1 in which the address is located.
POSTAL_CODE	VARCHAR2	(30)	National code to identify addresses in a specific country.
EMAIL_ADDRESS	VARCHAR2	(240)	Holds actual email identifier.
PHONE_TYPE	VARCHAR2	(30)	Phone Type.
PHONE_NUMBER	VARCHAR2	(60)	Telephone Number in any format.
NATIONALITY	VARCHAR2	(30)	Nationality.
NATIONAL_IDENTIFIER	VARCHAR2	(30)	Number by which a person is identified in a given legislation.
STATUS	VARCHAR2	(6)	Status of the message eg Queued,Sent
EFFECTIVE_STATUS_DATE	DATE		Effective Status Date.
LAST_UPDATE_DATE	DATE		Last Update Date.
RECORD_KEY	VARCHAR2	(150)	Record Key

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

HR.HR_PERSON_DELTA_SYNC does not reference any database object

HR.HR_PERSON_DELTA_SYNC is referenced by following:

APPS: HR_PERSON_DELTA_SYNC