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

TABLE: HR.PAY_BATCH_CONTROL_TOTALS

Object Details
Object Name: PAY_BATCH_CONTROL_TOTALS
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 20
PCT Used:
Primary Key: PAY_BATCH_CONTROL_TOTALS_PK
  1. ColumnBATCH_CONTROL_ID
Indexes
Index Type Uniqueness Tablespace Column
PAY_BATCH_CONTROL_TOTALS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_CONTROL_ID
PAY_BATCH_CONTROL_TOTALS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_BATCH_CONTROL_TOTALS PAY_BATCH_CONTROL_TOTALS_FK1 TablePAY_BATCH_HEADERS PAY_BATCH_CONTROL_TOTALS BATCH_ID
Columns
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.
Query Text

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;

Dependencies

[top of page]

HR.PAY_BATCH_CONTROL_TOTALS does not reference any database object

HR.PAY_BATCH_CONTROL_TOTALS is referenced by following:

SchemaHR
ViewPAY_BATCH_CONTROL_TOTALS#