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

TABLE: HR.PAY_RETRO_NOTIF_REPORTS

Object Details
Object Name: PAY_RETRO_NOTIF_REPORTS
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.PAY_RETRO_NOTIF_REPORTS
Subobject Name:
Status: VALID


PAY_RETRO_NOTIF_REPORTS holds the raw data which drives the Retro-Notifications Report. It is populated during the Retro-Notification process.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PAY_RETRO_NOTIF_REPORTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnREPORT_ID
ColumnASSIGNMENT_ID
Columns
Name Datatype Length Mandatory Comments
REPORT_ID NUMBER (15)
RetroNotification unique identifier
PAYROLL_ID NUMBER (9)
Foreign key to PAY_PAYROLLS_F
REPORT_DATE DATE

Effective date of the report execution
ASSIGNMENT_ID NUMBER (10)
Foreign key to PER_ASSIGNMENTS_F
ELEMENT_ENTRY_ID NUMBER (15)
Foreign key to PAY_ELEMENT_ENTRIES_F
EVENT_GROUP_ID NUMBER (15)
Foreign key to PAY_EVENT_GROUPS
DATE_PROCESSED DATE

Report date processed
DATE_EARNED DATE

Report date earned
CHANGE_TYPE VARCHAR2 (30)
Type of event change processed
ASSIGNMENT_SET_ID NUMBER (15)
Id of generated assignment set
BUSINESS_GROUP_ID NUMBER (15)
Business Group identifier for the report
Query Text

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


SELECT REPORT_ID
,      PAYROLL_ID
,      REPORT_DATE
,      ASSIGNMENT_ID
,      ELEMENT_ENTRY_ID
,      EVENT_GROUP_ID
,      DATE_PROCESSED
,      DATE_EARNED
,      CHANGE_TYPE
,      ASSIGNMENT_SET_ID
,      BUSINESS_GROUP_ID
FROM HR.PAY_RETRO_NOTIF_REPORTS;

Dependencies

[top of page]

HR.PAY_RETRO_NOTIF_REPORTS does not reference any database object

HR.PAY_RETRO_NOTIF_REPORTS is referenced by following:

SchemaHR
ViewPAY_RETRO_NOTIF_REPORTS#