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_ADJUST_BATCH_GROUPS

Object Details

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

This table holds Batch Group information for balance upload batch.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_ADJUST_BATCH_GROUPS_PK

BATCH_GROUP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_ADJUST_BATCH_GROUPS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_GROUP_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PAY_ADJUST_BATCH_GROUPS		PAY_BALANCE_BATCH_HEADERS	PAY_ADJUST_BATCH_GROUPS BATCH_ID
PAY_ADJUST_BATCH_LINES		PAY_ADJUST_BATCH_GROUPS	PAY_ADJUST_BATCH_LINES BATCH_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_GROUP_ID	NUMBER		Yes	Primary Key
BATCH_ID	NUMBER		Yes	Foreign Key to table PAY_BALANCE_BATCH_HEADERS
BATCH_GROUP_STATUS	VARCHAR2	(30)	Yes	Status of the Batch Group
CONSOLIDATION_SET_ID	NUMBER			Foreign key to PAY_CONSOLIDATION_SETS
PAYROLL_ID	NUMBER		Yes	Payroll Id
EFFECTIVE_DATE	DATE		Yes	Effective Date
PREPAY_FLAG	VARCHAR2	(30)		Where prepayment process is run

Query Text

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


SELECT BATCH_GROUP_ID
,      BATCH_ID
,      BATCH_GROUP_STATUS
,      CONSOLIDATION_SET_ID
,      PAYROLL_ID
,      EFFECTIVE_DATE
,      PREPAY_FLAG
FROM HR.PAY_ADJUST_BATCH_GROUPS;

Dependencies

[top of page]

HR.PAY_ADJUST_BATCH_GROUPS does not reference any database object

HR.PAY_ADJUST_BATCH_GROUPS is referenced by following:

HR: PAY_ADJUST_BATCH_GROUPS#