[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 20 |
PCT Used: |
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 |
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 |
---|
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 |
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;
HR.PAY_BALANCE_BATCH_LINES does not reference any database object
HR.PAY_BALANCE_BATCH_LINES is referenced by following:
|
|
|