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

TABLE: HR.HR_ORGANIZATION_DELTA_SYNC

Object Details
Object Name: HR_ORGANIZATION_DELTA_SYNC
Object Type: TABLE
Owner: HR
Subobject Name:
Status: VALID


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


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_ID NUMBER (15)
Business Group Id.
ORGANIZATION_ID NUMBER (15)
Organization Id.
BUSINESS_GROUP_NAME VARCHAR2 (240)
Name of the Organization.
EFFECTIVE_DATE DATE

Effective Date of the Organization.
EFFECTIVE_STATUS VARCHAR2 (10)
Effective Status of the Organization eg Active/Inactive.
COMPANY NUMBER (15)
Company.
SETID_LOCATION NUMBER (15)
Location of the Setid.
LOCATION_ID NUMBER (15)
Location Id.
MANAGER_ID NUMBER (10)
Manager Id .
MANAGER_FULL_NAME VARCHAR2 (240)
Manager Full Name.
LAST_UPDATE_DATE DATE

Last Update Date.
STATUS VARCHAR2 (10)
Status of the message eg Queued,Sent
EFFECTIVE_STATUS_DATE DATE

Effective Status Date.
EVENT_KEY VARCHAR2 (50)
Event Key.
Query Text

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


SELECT BUSINESS_GROUP_ID
,      ORGANIZATION_ID
,      BUSINESS_GROUP_NAME
,      EFFECTIVE_DATE
,      EFFECTIVE_STATUS
,      COMPANY
,      SETID_LOCATION
,      LOCATION_ID
,      MANAGER_ID
,      MANAGER_FULL_NAME
,      LAST_UPDATE_DATE
,      STATUS
,      EFFECTIVE_STATUS_DATE
,      EVENT_KEY
FROM HR.HR_ORGANIZATION_DELTA_SYNC;

Dependencies

[top of page]

HR.HR_ORGANIZATION_DELTA_SYNC does not reference any database object

HR.HR_ORGANIZATION_DELTA_SYNC is referenced by following:

SchemaHR
ViewHR_ORGANIZATION_DELTA_SYNC#