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

TABLE: HR.PER_BF_BALANCE_TYPES_EFC

Object Details
Object Name: PER_BF_BALANCE_TYPES_EFC
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_BF_BALANCE_TYPES_EFC
Subobject Name:
Status: VALID


This table only contains a subset of the columns from the base table.
It contains a copy of the NCU (National Currency Unit) and currency code
values prior to EFC. This table is only maintained by the EFC process.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_BF_BALANCE_TYPES_EFC_PK
  1. ColumnBALANCE_TYPE_ID
  2. ColumnEFC_ACTION_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_BF_BALANCE_TYPES_EFC_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBALANCE_TYPE_ID
ColumnEFC_ACTION_ID
Columns
Name Datatype Length Mandatory Comments
BALANCE_TYPE_ID NUMBER (9) Yes Refer to column comment on base table.
EFC_ACTION_ID NUMBER (15) Yes Refer to column comment on base table.
CURRENCY VARCHAR2 (15)
Refer to column comment on base table.
Query Text

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


SELECT BALANCE_TYPE_ID
,      EFC_ACTION_ID
,      CURRENCY
FROM HR.PER_BF_BALANCE_TYPES_EFC;

Dependencies

[top of page]

HR.PER_BF_BALANCE_TYPES_EFC does not reference any database object

HR.PER_BF_BALANCE_TYPES_EFC is referenced by following:

SchemaHR
ViewPER_BF_BALANCE_TYPES_EFC#