[Home] [Help] [Dependency Information]
Object Name: | PAY_BATCH_CONTROL_TOTALS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_BATCH_CONTROL_TOTALS |
Subobject Name: | |
Status: | VALID |
PAY_BATCH_CONTROL_TOTALS holds user defined information about control
totals that are used to validate batch data during the Batch Element
Entry process. This process is also known as PAYLINK.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 20 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_BATCH_CONTROL_TOTALS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | BATCH_CONTROL_ID |
PAY_BATCH_CONTROL_TOTALS_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BATCH_ID |
Table | |
Foreign Table | Foreign Key Column | PAY_BATCH_CONTROL_TOTALS | PAY_BATCH_HEADERS | PAY_BATCH_CONTROL_TOTALS BATCH_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_CONTROL_ID | NUMBER | (15) | Yes | Surrogate primary key. |
BATCH_ID | NUMBER | (15) | Yes | Foreign key to PAY_BATCH_HEADERS. |
CONTROL_STATUS | VARCHAR2 | (30) | Yes | Control status. |
CONTROL_TOTAL | VARCHAR2 | (30) | Value of total to be checked against calculated value. | |
CONTROL_TYPE | VARCHAR2 | (30) | User defined lookup value for CONTROL_TYPE. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | System-generated version of row. Increments by one with each update. |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_CONTROL_ID
, BATCH_ID
, CONTROL_STATUS
, CONTROL_TOTAL
, CONTROL_TYPE
, OBJECT_VERSION_NUMBER
FROM HR.PAY_BATCH_CONTROL_TOTALS;
HR.PAY_BATCH_CONTROL_TOTALS does not reference any database object
HR.PAY_BATCH_CONTROL_TOTALS is referenced by following:
|
|
|