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_LINES

Object Details

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

PAY_BATCH_LINES holds the lines of data for each Batch Element Entry
batch that is to be uploaded 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_LINES_PK

BATCH_LINE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_BATCH_LINES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_LINE_ID
PAY_BATCH_LINES_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID
PAY_BATCH_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ELEMENT_TYPE_ID
PAY_BATCH_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID BATCH_ID
PAY_BATCH_LINES_N3	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER("ELEMENT_NAME")
PAY_BATCH_LINES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID ASSIGNMENT_ID EFFECTIVE_DATE
PAY_BATCH_LINES_N51	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_NUMBER

Foreign Keys

Table		Foreign Table	Foreign Key Column
PAY_BATCH_LINES		PAY_BATCH_HEADERS	PAY_BATCH_LINES BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_LINE_ID	NUMBER	(15)	Yes	Surrogate primary key.
COST_ALLOCATION_KEYFLEX_ID	NUMBER	(9)		Foreign key to PAY_COST_ALLOCATION_KEYFLEX.
ELEMENT_TYPE_ID	NUMBER	(9)		Foreign key to PAY_ELEMENT_TYPES.
ASSIGNMENT_ID	NUMBER	(10)		Foreign key to PER_ASSIGNMENTS.
BATCH_ID	NUMBER	(15)	Yes	Foreign key to PAY_BATCH_HEADERS.
BATCH_LINE_STATUS	VARCHAR2	(30)	Yes	Status of line, see domain.
ASSIGNMENT_NUMBER	VARCHAR2	(30)		Assignment number.
BATCH_SEQUENCE	NUMBER	(9)		Batch sequence number.
CONCATENATED_SEGMENTS	VARCHAR2	(240)		Key flexfield segment column.
EFFECTIVE_DATE	DATE			Effective end date.
ELEMENT_NAME	VARCHAR2	(80)		The element name.
ENTRY_TYPE	VARCHAR2	(1)		Type of entry.
REASON	VARCHAR2	(80)		Holds the meaning, not the code.
SEGMENT1	VARCHAR2	(60)		Key flexfield segment
SEGMENT2	VARCHAR2	(60)		Key flexfield segment
SEGMENT3	VARCHAR2	(60)		Key flexfield segment
SEGMENT4	VARCHAR2	(60)		Key flexfield segment
SEGMENT5	VARCHAR2	(60)		Key flexfield segment
SEGMENT6	VARCHAR2	(60)		Key flexfield segment
SEGMENT7	VARCHAR2	(60)		Key flexfield segment
SEGMENT8	VARCHAR2	(60)		Key flexfield segment
SEGMENT9	VARCHAR2	(60)		Key flexfield segment
SEGMENT10	VARCHAR2	(60)		Key flexfield segment
SEGMENT11	VARCHAR2	(60)		Key flexfield segment
SEGMENT12	VARCHAR2	(60)		Key flexfield segment
SEGMENT13	VARCHAR2	(60)		Key flexfield segment
SEGMENT14	VARCHAR2	(60)		Key flexfield segment
SEGMENT15	VARCHAR2	(60)		Key flexfield segment
SEGMENT16	VARCHAR2	(60)		Key flexfield segment
SEGMENT17	VARCHAR2	(60)		Key flexfield segment
SEGMENT18	VARCHAR2	(60)		Key flexfield segment
SEGMENT19	VARCHAR2	(60)		Key flexfield segment
SEGMENT20	VARCHAR2	(60)		Key flexfield segment
SEGMENT21	VARCHAR2	(60)		Key flexfield segment column.
SEGMENT22	VARCHAR2	(60)		Key flexfield segment column.
SEGMENT23	VARCHAR2	(60)		Key flexfield segment column.
SEGMENT24	VARCHAR2	(60)		Key flexfield segment column.
SEGMENT25	VARCHAR2	(60)		Key flexfield segment column.
SEGMENT26	VARCHAR2	(60)		Key flexfield segment column.
SEGMENT27	VARCHAR2	(60)		Key flexfield segment column.
SEGMENT28	VARCHAR2	(60)		Key flexfield segment column.
SEGMENT29	VARCHAR2	(60)		Key flexfield segment column.
SEGMENT30	VARCHAR2	(60)		Key flexfield segment column.
VALUE_1	VARCHAR2	(80)		Element input-values.
VALUE_2	VARCHAR2	(80)		Element input-values.
VALUE_3	VARCHAR2	(80)		Element input-values.
VALUE_4	VARCHAR2	(80)		Element input-values.
VALUE_5	VARCHAR2	(80)		Element input-values.
VALUE_6	VARCHAR2	(80)		Element input-values.
VALUE_7	VARCHAR2	(80)		Element input-values.
VALUE_8	VARCHAR2	(80)		Element input-values.
VALUE_9	VARCHAR2	(80)		Element input-values.
VALUE_10	VARCHAR2	(80)		Element input-values.
VALUE_11	VARCHAR2	(80)		Element input-values.
VALUE_12	VARCHAR2	(80)		Element input-values.
VALUE_13	VARCHAR2	(80)		Element input-values.
VALUE_14	VARCHAR2	(80)		Element input-values.
VALUE_15	VARCHAR2	(80)		Element input-values.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield column.
EFFECTIVE_START_DATE	DATE			Effective start date.
EFFECTIVE_END_DATE	DATE			Effective end date.
OBJECT_VERSION_NUMBER	NUMBER	(9)		System-generated version of row. Increments by one with each update.
ENTRY_INFORMATION_CATEGORY	VARCHAR2	(30)		Developer descriptive flexfield column.
ENTRY_INFORMATION1	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION2	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION3	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION4	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION5	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION6	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION7	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION8	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION9	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION10	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION11	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION12	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION13	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION14	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION15	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION16	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION17	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION19	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION21	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION22	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION23	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION24	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION25	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION26	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION27	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION28	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION29	VARCHAR2	(150)		Developer descriptive flexfield column.
ENTRY_INFORMATION30	VARCHAR2	(150)		Developer descriptive flexfield column.
DATE_EARNED	DATE			Date the entry was earned.
PERSONAL_PAYMENT_METHOD_ID	NUMBER	(9)		Used to identify third party payments
SUBPRIORITY	NUMBER	(9)		Subpriority for the entry.

Query Text

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


SELECT BATCH_LINE_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      ELEMENT_TYPE_ID
,      ASSIGNMENT_ID
,      BATCH_ID
,      BATCH_LINE_STATUS
,      ASSIGNMENT_NUMBER
,      BATCH_SEQUENCE
,      CONCATENATED_SEGMENTS
,      EFFECTIVE_DATE
,      ELEMENT_NAME
,      ENTRY_TYPE
,      REASON
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      VALUE_1
,      VALUE_2
,      VALUE_3
,      VALUE_4
,      VALUE_5
,      VALUE_6
,      VALUE_7
,      VALUE_8
,      VALUE_9
,      VALUE_10
,      VALUE_11
,      VALUE_12
,      VALUE_13
,      VALUE_14
,      VALUE_15
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      OBJECT_VERSION_NUMBER
,      ENTRY_INFORMATION_CATEGORY
,      ENTRY_INFORMATION1
,      ENTRY_INFORMATION2
,      ENTRY_INFORMATION3
,      ENTRY_INFORMATION4
,      ENTRY_INFORMATION5
,      ENTRY_INFORMATION6
,      ENTRY_INFORMATION7
,      ENTRY_INFORMATION8
,      ENTRY_INFORMATION9
,      ENTRY_INFORMATION10
,      ENTRY_INFORMATION11
,      ENTRY_INFORMATION12
,      ENTRY_INFORMATION13
,      ENTRY_INFORMATION14
,      ENTRY_INFORMATION15
,      ENTRY_INFORMATION16
,      ENTRY_INFORMATION17
,      ENTRY_INFORMATION18
,      ENTRY_INFORMATION19
,      ENTRY_INFORMATION20
,      ENTRY_INFORMATION21
,      ENTRY_INFORMATION22
,      ENTRY_INFORMATION23
,      ENTRY_INFORMATION24
,      ENTRY_INFORMATION25
,      ENTRY_INFORMATION26
,      ENTRY_INFORMATION27
,      ENTRY_INFORMATION28
,      ENTRY_INFORMATION29
,      ENTRY_INFORMATION30
,      DATE_EARNED
,      PERSONAL_PAYMENT_METHOD_ID
,      SUBPRIORITY
FROM HR.PAY_BATCH_LINES;

Dependencies

[top of page]

HR.PAY_BATCH_LINES does not reference any database object

HR.PAY_BATCH_LINES is referenced by following:

HR: PAY_BATCH_LINES#