eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: HR.PER_BF_BALANCE_TYPES

Object Details

Object Name:	PER_BF_BALANCE_TYPES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_BF_BALANCE_TYPES
Subobject Name:
Status:	VALID

Types of balances that can be held

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_BF_BALANCE_TYPES_PK

BALANCE_TYPE_ID

Unique Key: PER_BF_BALANCE_TYPES_UK1

DISPLAYED_NAME
BUSINESS_GROUP_ID

Unique Key: PER_BF_BALANCE_TYPES_UK2

INTERNAL_NAME
BUSINESS_GROUP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_BF_BALANCE_TYPES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BALANCE_TYPE_ID
PER_BF_BALANCE_TYPES_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DISPLAYED_NAME BUSINESS_GROUP_ID
PER_BF_BALANCE_TYPES_UK2	NORMAL	UNIQUE	APPS_TS_TX_IDX	INTERNAL_NAME BUSINESS_GROUP_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_BF_BALANCE_TYPES		HR_ALL_ORGANIZATION_UNITS	PER_BF_BALANCE_TYPES BUSINESS_GROUP_ID
PER_BF_BALANCE_AMOUNTS		PER_BF_BALANCE_TYPES	PER_BF_BALANCE_AMOUNTS BALANCE_TYPE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BALANCE_TYPE_ID	NUMBER	(15)	Yes	System Generated Unique Identifer for this row
INPUT_VALUE_ID	NUMBER	(9)		FK to pay_input_values_f
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	FK to HR_ALL_ORGANIZATION_UNITS
DISPLAYED_NAME	VARCHAR2	(30)	Yes	Balance type name that is displayed for users to see.
INTERNAL_NAME	VARCHAR2	(30)	Yes	Internal name of the balance
UOM	VARCHAR2	(30)		Unit of Measure for the balance
CURRENCY	VARCHAR2	(15)		Currency of the balance, if the UOM is money.
CATEGORY	VARCHAR2	(30)		Allows groupings of balance types for reporting purposes
DATE_FROM	DATE			Date the type is valid from
DATE_TO	DATE			Date the type is valid until
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	System generated version of row
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column

Query Text

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


SELECT BALANCE_TYPE_ID
,      INPUT_VALUE_ID
,      BUSINESS_GROUP_ID
,      DISPLAYED_NAME
,      INTERNAL_NAME
,      UOM
,      CURRENCY
,      CATEGORY
,      DATE_FROM
,      DATE_TO
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_BF_BALANCE_TYPES;

Dependencies

[top of page]

HR.PER_BF_BALANCE_TYPES does not reference any database object

HR.PER_BF_BALANCE_TYPES is referenced by following:

HR: PER_BF_BALANCE_TYPES#