DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.PAY_ADJUST_BATCH_LINES

Object Details
Object Name: PAY_ADJUST_BATCH_LINES
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.PAY_ADJUST_BATCH_LINES
Subobject Name:
Status: VALID


This table holds the batch line information for a balance upload batch


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_ADJUST_BATCH_LINES_PK
  1. ColumnBATCH_LINE_ID
Indexes
Index Type Uniqueness Tablespace Column
PAY_ADJUST_BATCH_LINES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_LINE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_ADJUST_BATCH_LINES PAY_ADJUST_BATCH_LINES_FK2 TablePAY_ADJUST_BATCH_GROUPS PAY_ADJUST_BATCH_LINES BATCH_GROUP_ID
PAY_ADJUST_BATCH_LINES PAY_ADJUST_BATCH_LINES_FK1 TablePAY_BALANCE_BATCH_HEADERS PAY_ADJUST_BATCH_LINES BATCH_ID
Columns
Name Datatype Length Mandatory Comments
BATCH_LINE_ID NUMBER
Yes Primary Key
BATCH_ID NUMBER
Yes This column is Foriegn key to PAY_BALANCE_BATCH_HEADERS
BATCH_LINE_STATUS VARCHAR2 (30) Yes Status of the Batch line
BATCH_GROUP_ID NUMBER
Yes Foreign Key to PAY_BATCH_GROUPS
BATCH_LINE_SEQUENCE NUMBER

Batch line sequence
ASSIGNMENT_ID NUMBER
Yes Foreign key to PER_ALL_ASSIGNMENTS_F
ELEMENT_LINK_ID NUMBER (9)
Foreign Key to PAY_ELEMENT_LINKS_F
INPUT_VALUE_ID1 NUMBER

Foreign Key to PAY_INPUT_VALUES_F
INPUT_VALUE_ID2 NUMBER

Foreign Key to PAY_INPUT_VALUES_F
INPUT_VALUE_ID3 NUMBER

Foreign Key to PAY_INPUT_VALUES_F
INPUT_VALUE_ID4 NUMBER

Foreign Key to PAY_INPUT_VALUES_F
INPUT_VALUE_ID5 NUMBER

Foreign Key to PAY_INPUT_VALUES_F
INPUT_VALUE_ID6 NUMBER

Foreign Key to PAY_INPUT_VALUES_F
INPUT_VALUE_ID7 NUMBER

Foreign Key to PAY_INPUT_VALUES_F
INPUT_VALUE_ID8 NUMBER

Foreign Key to PAY_INPUT_VALUES_F
INPUT_VALUE_ID9 NUMBER

Foreign Key to PAY_INPUT_VALUES_F
INPUT_VALUE_ID10 NUMBER

Foreign Key to PAY_INPUT_VALUES_F
INPUT_VALUE_ID11 NUMBER

Foreign Key to PAY_INPUT_VALUES_F
INPUT_VALUE_ID12 NUMBER

Foreign Key to PAY_INPUT_VALUES_F
INPUT_VALUE_ID13 NUMBER

Foreign Key to PAY_INPUT_VALUES_F
INPUT_VALUE_ID14 NUMBER

Foreign Key to PAY_INPUT_VALUES_F
INPUT_VALUE_ID15 NUMBER

Foreign Key to PAY_INPUT_VALUES_F
ENTRY_VALUE1 VARCHAR2 (60)
Adjustment Value
ENTRY_VALUE2 VARCHAR2 (60)
Adjustment Value
ENTRY_VALUE3 VARCHAR2 (60)
Adjustment Value
ENTRY_VALUE4 VARCHAR2 (60)
Adjustment Value
ENTRY_VALUE5 VARCHAR2 (60)
Adjustment Value
ENTRY_VALUE6 VARCHAR2 (60)
Adjustment Value
ENTRY_VALUE7 VARCHAR2 (60)
Adjustment Value
ENTRY_VALUE8 VARCHAR2 (60)
Adjustment Value
ENTRY_VALUE9 VARCHAR2 (60)
Adjustment Value
ENTRY_VALUE10 VARCHAR2 (60)
Adjustment Value
ENTRY_VALUE11 VARCHAR2 (60)
Adjustment Value
ENTRY_VALUE12 VARCHAR2 (60)
Adjustment Value
ENTRY_VALUE13 VARCHAR2 (60)
Adjustment Value
ENTRY_VALUE14 VARCHAR2 (60)
Adjustment Value
ENTRY_VALUE15 VARCHAR2 (60)
Adjustment Value
BALANCE_ADJ_COST_FLAG VARCHAR2 (30)
Costed Flag
COST_ALLOCATION_KEYFLEX_ID NUMBER

Cost Allocation Key flexfield Id
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive Flexfield Attribute category
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield Attribute
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield Attribute
RUN_TYPE_ID NUMBER

Foreign Key to PAY_RUN_TYPES
ORIGINAL_ENTRY_ID NUMBER

Foreign key to PAY_ELEMENT_ENTRIES_F
TAX_UNIT_ID NUMBER

Tax Unit id
ELEMENT_TYPE_ID NUMBER (9)
Foreign Key to PAY_ELEMENT_TYPES_F
Query Text

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


SELECT BATCH_LINE_ID
,      BATCH_ID
,      BATCH_LINE_STATUS
,      BATCH_GROUP_ID
,      BATCH_LINE_SEQUENCE
,      ASSIGNMENT_ID
,      ELEMENT_LINK_ID
,      INPUT_VALUE_ID1
,      INPUT_VALUE_ID2
,      INPUT_VALUE_ID3
,      INPUT_VALUE_ID4
,      INPUT_VALUE_ID5
,      INPUT_VALUE_ID6
,      INPUT_VALUE_ID7
,      INPUT_VALUE_ID8
,      INPUT_VALUE_ID9
,      INPUT_VALUE_ID10
,      INPUT_VALUE_ID11
,      INPUT_VALUE_ID12
,      INPUT_VALUE_ID13
,      INPUT_VALUE_ID14
,      INPUT_VALUE_ID15
,      ENTRY_VALUE1
,      ENTRY_VALUE2
,      ENTRY_VALUE3
,      ENTRY_VALUE4
,      ENTRY_VALUE5
,      ENTRY_VALUE6
,      ENTRY_VALUE7
,      ENTRY_VALUE8
,      ENTRY_VALUE9
,      ENTRY_VALUE10
,      ENTRY_VALUE11
,      ENTRY_VALUE12
,      ENTRY_VALUE13
,      ENTRY_VALUE14
,      ENTRY_VALUE15
,      BALANCE_ADJ_COST_FLAG
,      COST_ALLOCATION_KEYFLEX_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      RUN_TYPE_ID
,      ORIGINAL_ENTRY_ID
,      TAX_UNIT_ID
,      ELEMENT_TYPE_ID
FROM HR.PAY_ADJUST_BATCH_LINES;

Dependencies

[top of page]

HR.PAY_ADJUST_BATCH_LINES does not reference any database object

HR.PAY_ADJUST_BATCH_LINES is referenced by following:

SchemaHR
ViewPAY_ADJUST_BATCH_LINES#