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.PAY_BALANCE_DIMENSIONS

Object Details

Object Name:	PAY_BALANCE_DIMENSIONS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_BALANCE_DIMENSIONS
Subobject Name:
Status:	VALID

PAY_BALANCE_DIMENSIONS defines the scope of a particular balance value.
The scope includes the time span to cover (Year to Date, Quarter to Date etc),
the level of the balance (Group, Person or Assignment) and any further
contextual restrictions.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: PAY_BALANCE_DIMENSIONS_PK

BALANCE_DIMENSION_ID

Unique Key: PAY_BALANCE_DIMENSIONS_UK2

DIMENSION_NAME
BUSINESS_GROUP_ID
LEGISLATION_CODE

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_BALANCE_DIMENSIONS_PK	NORMAL	UNIQUE	APPS_TS_SEED	BALANCE_DIMENSION_ID
PAY_BALANCE_DIMENSIONS_UK2	NORMAL	UNIQUE	APPS_TS_SEED	DIMENSION_NAME BUSINESS_GROUP_ID LEGISLATION_CODE
PAY_BALANCE_DIMENSIONS_FK1	NORMAL	NONUNIQUE	APPS_TS_SEED	ROUTE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PAY_BALANCE_DIMENSIONS	FF_ROUTES	PAY_BALANCE_DIMENSIONS ROUTE_ID
PAY_BAL_ATTRIBUTE_DEFAULTS	PAY_BALANCE_DIMENSIONS	PAY_BAL_ATTRIBUTE_DEFAULTS BALANCE_DIMENSION_ID
PAY_DEFINED_BALANCES	PAY_BALANCE_DIMENSIONS	PAY_DEFINED_BALANCES BALANCE_DIMENSION_ID
PAY_DIMENSION_ROUTES	PAY_BALANCE_DIMENSIONS	PAY_DIMENSION_ROUTES RUN_DIMENSION_ID
PAY_DIMENSION_ROUTES	PAY_BALANCE_DIMENSIONS	PAY_DIMENSION_ROUTES BALANCE_DIMENSION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BALANCE_DIMENSION_ID	NUMBER	(9)	Yes	System-generated primary key column.
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	VARCHAR2	(30)		Foreign key to FND_TERRITORIES.
ROUTE_ID	NUMBER	(15)	Yes	Foreign key to FF_ROUTES.
DATABASE_ITEM_SUFFIX	VARCHAR2	(80)	Yes	Suffix to use when generating a database item (eg _ASG_PTD).
DIMENSION_NAME	VARCHAR2	(80)	Yes	User Name.
DIMENSION_TYPE	VARCHAR2	(1)	Yes	Controls whether latest balance is created and if so, what type, person or assignment level.
DESCRIPTION	VARCHAR2	(240)		User Description.
FEED_CHECKING_CODE	VARCHAR2	(61)		PL/SQL function to determine whether the Run Result Value should feed the balance.
LEGISLATION_SUBGROUP	VARCHAR2	(30)		Further identifies the legislation of startup data.
PAYMENTS_FLAG	VARCHAR2	(30)		One dimension only can be marked as being the PAYMENTS dimension.
EXPIRY_CHECKING_CODE	VARCHAR2	(61)		PL/SQL function which checks if latest balances should be reset.
EXPIRY_CHECKING_LEVEL	VARCHAR2	(1)		Controls balance expiry strategy.
FEED_CHECKING_TYPE	VARCHAR2	(1)		Controls feed checking strategy.
DIMENSION_LEVEL	VARCHAR2	(30)		The level or group that the dimension describes
PERIOD_TYPE	VARCHAR2	(30)		The period for which the dimension totals
ASG_ACTION_BALANCE_DIM_ID	NUMBER	(9)		Used to calculate assignment contributions to group balance in rollback of group level run balances.
DATABASE_ITEM_FUNCTION	VARCHAR2	(256)		Use the balance function to retrieve balance value
SAVE_RUN_BALANCE_ENABLED	VARCHAR2	(30)		In conjunction with save_run_balance_enabled on pay_balance_categories_f, indicates whether run balances should be stored for defined balances with this dimension.
START_DATE_CODE	VARCHAR2	(61)		PL/SQL function which determines the start date for a dynamic period
APPLICATION_ID	NUMBER	(9)		Indicates which, non Payroll, application owns the record.

Query Text

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


SELECT BALANCE_DIMENSION_ID
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      ROUTE_ID
,      DATABASE_ITEM_SUFFIX
,      DIMENSION_NAME
,      DIMENSION_TYPE
,      DESCRIPTION
,      FEED_CHECKING_CODE
,      LEGISLATION_SUBGROUP
,      PAYMENTS_FLAG
,      EXPIRY_CHECKING_CODE
,      EXPIRY_CHECKING_LEVEL
,      FEED_CHECKING_TYPE
,      DIMENSION_LEVEL
,      PERIOD_TYPE
,      ASG_ACTION_BALANCE_DIM_ID
,      DATABASE_ITEM_FUNCTION
,      SAVE_RUN_BALANCE_ENABLED
,      START_DATE_CODE
,      APPLICATION_ID
FROM HR.PAY_BALANCE_DIMENSIONS;

Dependencies

[top of page]

HR.PAY_BALANCE_DIMENSIONS does not reference any database object

HR.PAY_BALANCE_DIMENSIONS is referenced by following:

APPS: PAY_BALANCE_DIMENSIONS; PAY_PBD_MNT_TL_ARD; PAY_PBD_MNT_TL_ARI; PAY_PBD_MNT_TL_ARU
PUBLIC: PAY_BALANCE_DIMENSIONS