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_BALANCE_BATCH_LINES

Object Details

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

PAY_BALANCE_BATCH_LINES holds the initial upload information to use
for each defined balance.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	20
PCT Used:

Primary Key: PAY_BALANCE_BATCH_LINES_PK

BATCH_LINE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_BALANCE_BATCH_LINES_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	BATCH_LINE_ID
PAY_BALANCE_BATCH_LINES_N50	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID BALANCE_TYPE_ID
PAY_BALANCE_BATCH_LINES_N51	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID ASSIGNMENT_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PAY_BALANCE_BATCH_LINES		PAY_BALANCE_BATCH_HEADERS	PAY_BALANCE_BATCH_LINES BATCH_ID
PAY_TEMP_BALANCE_ADJUSTMENTS		PAY_BALANCE_BATCH_LINES	PAY_TEMP_BALANCE_ADJUSTMENTS BATCH_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ASSIGNMENT_ID	NUMBER	(10)		Foreign key to PER_ASSIGNMENTS.
BALANCE_DIMENSION_ID	NUMBER	(9)		Foreign key to PAY_BALANCE_DIMENSIONS.
BALANCE_TYPE_ID	NUMBER	(9)		Foreign key to PAY_BALANCE_TYPES.
PAYROLL_ACTION_ID	NUMBER	(9)		Foreign key to PAY_PAYROLL_ACTIONS.
BATCH_ID	NUMBER	(9)	Yes	Foreign key to balance batch headers.
BATCH_LINE_ID	NUMBER	(9)	Yes	Primary key.
BATCH_LINE_STATUS	VARCHAR2	(30)	Yes	Status of each balance batch line in the upload process.
VALUE	NUMBER		Yes	The balance value to upload.
ASSIGNMENT_NUMBER	VARCHAR2	(30)		Identifies the assignment for the balance value. Alternatively use the ASSIGNMENT_ID.
BALANCE_NAME	VARCHAR2	(80)		Identifies the balance to upload by name. Alternatively use the BALANCE_TYPE_ID.
DIMENSION_NAME	VARCHAR2	(80)		Identifies the balance dimension by name. Alternatively use the BALANCE_TYPE_ID.
GRE_NAME	VARCHAR2	(60)		Government Reporting Entity name.
JURISDICTION_CODE	VARCHAR2	(30)		Jurisdiction code.
ORIGINAL_ENTRY_ID	NUMBER	(15)		Context of element entry id.
TAX_UNIT_ID	NUMBER	(15)		Foreign key to HR_ORGANIZATION_UNITS (ORGANIZATION_ID).
SOURCE_ID	NUMBER	(15)		Context of Source id
SOURCE_TEXT	VARCHAR2	(60)		Context of Source Text
RUN_TYPE_NAME	VARCHAR2	(80)		Description of Run Type.
RUN_TYPE_ID	NUMBER	(9)		Foreign key to PAY_RUN_TYPES_F.
UPLOAD_DATE	DATE			Date of upload for the individual line.
SOURCE_NUMBER	NUMBER			Context of Source Number
SOURCE_TEXT2	VARCHAR2	(60)		Context of Source Text2

Query Text

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


SELECT ASSIGNMENT_ID
,      BALANCE_DIMENSION_ID
,      BALANCE_TYPE_ID
,      PAYROLL_ACTION_ID
,      BATCH_ID
,      BATCH_LINE_ID
,      BATCH_LINE_STATUS
,      VALUE
,      ASSIGNMENT_NUMBER
,      BALANCE_NAME
,      DIMENSION_NAME
,      GRE_NAME
,      JURISDICTION_CODE
,      ORIGINAL_ENTRY_ID
,      TAX_UNIT_ID
,      SOURCE_ID
,      SOURCE_TEXT
,      RUN_TYPE_NAME
,      RUN_TYPE_ID
,      UPLOAD_DATE
,      SOURCE_NUMBER
,      SOURCE_TEXT2
FROM HR.PAY_BALANCE_BATCH_LINES;

Dependencies

[top of page]

HR.PAY_BALANCE_BATCH_LINES does not reference any database object

HR.PAY_BALANCE_BATCH_LINES is referenced by following:

HR: PAY_BALANCE_BATCH_LINES#