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

TABLE: HR.HR_JOBCODE_DELTA_SYNC

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


HR_JOBCODE_DELTA_SYNC holds the delta sync(RIR) information for the Job Code in HR HelpDesk.Regular Incremental Refresh(RIR) XML message for Job Code 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
SETID NUMBER (15)
Set Id.
JOBCODE NUMBER (15)
Job Code.
EFFDT DATE

Effective Date.
EFF_STATUS VARCHAR2 (8)
Effective Status eg.Active,Inactive.
DESCR VARCHAR2 (700)
Description.
STATUS VARCHAR2 (6)
Status of the message eg Queued,Sent.
EFFECTIVE_STATUS_DATE DATE

Effective Status Date.
LAST_UPDATE_DATE DATE

Last Update Date.
EVENT_KEY VARCHAR2 (240)
Event Key.
Query Text

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


SELECT SETID
,      JOBCODE
,      EFFDT
,      EFF_STATUS
,      DESCR
,      STATUS
,      EFFECTIVE_STATUS_DATE
,      LAST_UPDATE_DATE
,      EVENT_KEY
FROM HR.HR_JOBCODE_DELTA_SYNC;

Dependencies

[top of page]

HR.HR_JOBCODE_DELTA_SYNC does not reference any database object

HR.HR_JOBCODE_DELTA_SYNC is referenced by following:

SchemaAPPS
SynonymHR_JOBCODE_DELTA_SYNC