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_BATCH_HEADERS

Object Details

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

PAY_BATCH_HEADERS holds the batch header information for each Batch
Element Entry batch of data that is to be loaded into Oracle HRMS by
the Batch Element Entry process.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Primary Key: PAY_BATCH_HEADERS_PK

BATCH_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_BATCH_HEADERS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PAY_BATCH_CONTROL_TOTALS		PAY_BATCH_HEADERS	PAY_BATCH_CONTROL_TOTALS BATCH_ID
PAY_BATCH_LINES		PAY_BATCH_HEADERS	PAY_BATCH_LINES BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(15)	Yes	Surrogate primary key.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business group identifier.
BATCH_NAME	VARCHAR2	(30)	Yes	Name of the batch (non-unique).
BATCH_STATUS	VARCHAR2	(30)	Yes	Shows the status the batch is currently in.
ACTION_IF_EXISTS	VARCHAR2	(30)		What action should the process perform if the entry already exists.
BATCH_REFERENCE	VARCHAR2	(30)		User defined reference for batch.
BATCH_SOURCE	VARCHAR2	(150)		Free format specification of batch source.
COMMENTS	VARCHAR2	(2000)		Batch header comment.
DATE_EFFECTIVE_CHANGES	VARCHAR2	(30)		Type of Date Effective change.
PURGE_AFTER_TRANSFER	VARCHAR2	(30)		Indicates if the batch lines should be automatically purged after transfer.
REJECT_IF_FUTURE_CHANGES	VARCHAR2	(30)		Indicates if the batch lines should be rejected if future changes already exist.
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	NUMBER	(9)		System-generated version of row. Increments by one with each update.
REJECT_IF_RESULTS_EXISTS	VARCHAR2	(30)		Indicates if the batch line should be rolled back if run result exist.
PURGE_AFTER_ROLLBACK	VARCHAR2	(30)		Indicates if the batch line should be purged after rollback.
REJECT_ENTRY_NOT_REMOVED	VARCHAR2	(30)		Indicates if the batch line's transfer status should not be reverted to unprocessed if there is no entry found or entry not removed.
ROLLBACK_ENTRY_UPDATES	VARCHAR2	(30)		Indicates whether or not to rollback the updates on the entry made by the Batch Element Entry transfer process.
BATCH_TYPE	VARCHAR2	(30)		Holds the batch type information for this batch.

Query Text

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


SELECT BATCH_ID
,      BUSINESS_GROUP_ID
,      BATCH_NAME
,      BATCH_STATUS
,      ACTION_IF_EXISTS
,      BATCH_REFERENCE
,      BATCH_SOURCE
,      COMMENTS
,      DATE_EFFECTIVE_CHANGES
,      PURGE_AFTER_TRANSFER
,      REJECT_IF_FUTURE_CHANGES
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      REJECT_IF_RESULTS_EXISTS
,      PURGE_AFTER_ROLLBACK
,      REJECT_ENTRY_NOT_REMOVED
,      ROLLBACK_ENTRY_UPDATES
,      BATCH_TYPE
FROM HR.PAY_BATCH_HEADERS;

Dependencies

[top of page]

HR.PAY_BATCH_HEADERS does not reference any database object

HR.PAY_BATCH_HEADERS is referenced by following:

APPS: PAY_BATCH_HEADERS; PAY_BATCH_HEADERS_OVN; PAY_BATCH_HEADERS_WHO; SET_HXT_BATCH_STATES_INS
PUBLIC: PAY_BATCH_HEADERS