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.PAY_OBJECT_GROUPS

Object Details

Object Name:	PAY_OBJECT_GROUPS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_OBJECT_GROUPS
Subobject Name:
Status:	VALID

PAY_OBJECT_GROUPS holds the association of assignments and
people for processing.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_OBJECT_GROUPS_PK

OBJECT_GROUP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_OBJECT_GROUPS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_GROUP_ID
PAY_OBJECT_GROUPS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_OBJECT_GROUP_ID
PAY_OBJECT_GROUPS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_ID SOURCE_TYPE

Foreign Keys

Table		Foreign Table	Foreign Key Column
PAY_OBJECT_GROUPS		PAY_GROUP_DEFINITIONS	PAY_OBJECT_GROUPS GROUP_DEFINITION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_GROUP_ID	NUMBER	(10)	Yes	System generated primary key
SOURCE_ID	NUMBER	(10)	Yes	Foreign Key to a table denoted by the SOURCE_TYPE
SOURCE_TYPE	VARCHAR2	(30)	Yes	Denotes the table from which the SOURCE_ID is from.
START_DATE	DATE		Yes	This is the start date for the Object Group
END_DATE	DATE		Yes	This is the End Date for the Object Group
PAYROLL_ID	NUMBER	(10)		Foreign Key to PAY_PAYROLLS_F
GROUP_DEFINITION_ID	NUMBER	(10)		Foreign Key to PAY_GROUP_DEFINITIONS
PARENT_OBJECT_GROUP_ID	NUMBER	(10)		Foreign Key to PAY_OBJECT_GROUPS
PERIOD_OF_SERVICE_ID	NUMBER	(9)		Foreign Key to PER_PERIODS_OF_SERVICE

Query Text

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


SELECT OBJECT_GROUP_ID
,      SOURCE_ID
,      SOURCE_TYPE
,      START_DATE
,      END_DATE
,      PAYROLL_ID
,      GROUP_DEFINITION_ID
,      PARENT_OBJECT_GROUP_ID
,      PERIOD_OF_SERVICE_ID
FROM HR.PAY_OBJECT_GROUPS;

Dependencies

[top of page]

HR.PAY_OBJECT_GROUPS does not reference any database object

HR.PAY_OBJECT_GROUPS is referenced by following:

APPS: PAY_OBJECT_GROUPS
PUBLIC: PAY_OBJECT_GROUPS