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

Object Details

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

Rounding errors occur with some entities where individual and total
values are stored separately.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: HR_EFC_ROUNDING_ERRORS_PK

EFC_ROUNDING_ERROR_ID

Unique Key: HR_EFC_ROUNDING_ERRORS_UK01

EFC_ACTION_ID
SOURCE_ID
SOURCE_TABLE
SOURCE_COLUMN

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_EFC_ROUNDING_ERRORS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	EFC_ROUNDING_ERROR_ID
HR_EFC_ROUNDING_ERRORS_UK01	NORMAL	UNIQUE	APPS_TS_TX_IDX	EFC_ACTION_ID SOURCE_ID SOURCE_TABLE SOURCE_COLUMN

Columns

Name	Datatype	Length	Mandatory	Comments
EFC_ROUNDING_ERROR_ID	NUMBER	(15)	Yes	Surrogate Primary Key.
EFC_ACTION_ID	NUMBER	(15)	Yes	Foreign Key to HR_EFC_ACTIONS.
SOURCE_ID	NUMBER	(15)	Yes	The value of the surrogate primary key ID value for the source table.
SOURCE_TABLE	VARCHAR2	(30)	Yes	Name of the table which has been adjusted.
SOURCE_COLUMN	VARCHAR2	(30)	Yes	Name of the column in the SOURCE_TABLE which has been adjusted.
ROUNDING_AMOUNT	NUMBER		Yes	The difference between the pre- and post- value on the source table column.
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 EFC_ROUNDING_ERROR_ID
,      EFC_ACTION_ID
,      SOURCE_ID
,      SOURCE_TABLE
,      SOURCE_COLUMN
,      ROUNDING_AMOUNT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.HR_EFC_ROUNDING_ERRORS;

Dependencies

[top of page]

HR.HR_EFC_ROUNDING_ERRORS does not reference any database object

HR.HR_EFC_ROUNDING_ERRORS is referenced by following:

APPS: HR_EFC_ROUNDING_ERRORS; HR_EFC_ROUNDING_ERRORS_WHO
PUBLIC: HR_EFC_ROUNDING_ERRORS