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

TABLE: HR.HR_WORKFORCE_DELTA_SYNC

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


HR_WORKFORCE_DELTA_SYNC holds the delta sync(RIR) information for the Workforce in HR HelpDesk.Regular Incremental Refresh(RIR) XML message for Workforce 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
EMPLOYEE_NUMBER VARCHAR2 (30)
Employee Number.
EMPL_RCD NUMBER (9)
Employee Record Number
ORIGINAL_DATE_OF_HIRE DATE

Original Date of Hire.
PROBATION_PERIOD NUMBER (22)
Duration of probation period.
EFFDT DATE

Effective Date.
ORGANIZATION_ID NUMBER (15)
Organization Id.
JOB_ID NUMBER (15)
Job Id.
ASSIGNMENT_STATUS_TYPE_ID NUMBER (9)
Assignment Status Type Id.
LOCATION_ID NUMBER (15)
Location Id.
EMPLOYMENT_CATEGORY VARCHAR2 (30)
User defined category. For example Full-Time Permanent or Part-Time Permanent. Known as Assignment Category.
BUSINESS_GROUP_ID NUMBER (15)
Business Group Id.
NORMAL_HOURS NUMBER (23)
Normal working hours.
FREQUENCY VARCHAR2 (30)
Frequency of normal working hours, - week, month, year.
GRADE_ID NUMBER (15)
Grade Id.
SUPERVISOR_ID NUMBER

Supervisor Id.
EFFECTIVE_START_DATE DATE

Effective Start date
EFFECTIVE_END_DATE DATE

Effective End Date
STEP_ID NUMBER (15)
Step Id
FINAL_PROCESS_DATE DATE

Final date for all payroll processing of this person.
ACCEPTED_TERMINATION_DATE DATE

Date when termination of employment was accepted.
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 (200)
Event Key.
Query Text

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


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

Dependencies

[top of page]

HR.HR_WORKFORCE_DELTA_SYNC does not reference any database object

HR.HR_WORKFORCE_DELTA_SYNC is referenced by following:

SchemaAPPS
SynonymHR_WORKFORCE_DELTA_SYNC