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: BEN.BEN_CWB_PERSON_INFO_EFC

Object Details

Object Name:	BEN_CWB_PERSON_INFO_EFC
Object Type:	TABLE
Owner:	BEN
Subobject Name:
Status:	VALID

Table for supporting EFC conversion of monetary columns in BEN_CWB_PERSON_INFO table

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BEN_CWB_PERSON_INFO_EFC_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	GROUP_PER_IN_LER_ID EFC_ACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_PER_IN_LER_ID	NUMBER	(15)	Yes	Person Life event
EFC_ACTION_ID	NUMBER	(15)	Yes	Reference to EFC process table
PERSON_ID	NUMBER	(15)	Yes	Reference to PER_ALL_PEOPLE_F table
GRD_MIN_VAL	NUMBER			Minimum rate for the grade
GRD_MAX_VAL	NUMBER			Maximum rate for the grade
GRD_MID_POINT	NUMBER			Mid point rate for the grade
BASE_SALARY	NUMBER			Base salary of the employee
CURRENCY_CODE	VARCHAR2	(30)		Currency code
BASE_SALARY_CURRENCY	VARCHAR2	(30)		Currency of the base salary
PREV_SAL_CURRENCY	VARCHAR2	(15)		Currency for the previous salary
SALARY_1_YEAR_AGO	NUMBER			Salary 1 year ago
SALARY_1_YEAR_AGO_CURRENCY	VARCHAR2	(15)		Currency for salary 1 year ago
SALARY_2_YEAR_AGO	NUMBER			Salary 2 years ago
SALARY_2_YEAR_AGO_CURRENCY	VARCHAR2	(15)		Currency for salary 2 years ago
SALARY_3_YEAR_AGO	NUMBER			Salary 3 years ago
SALARY_3_YEAR_AGO_CURRENCY	VARCHAR2	(15)		Currency for salary 3 years ago
SALARY_4_YEAR_AGO	NUMBER			Salary 4 years ago
SALARY_4_YEAR_AGO_CURRENCY	VARCHAR2	(15)		Currency for salary 4 years ago
SALARY_5_YEAR_AGO	NUMBER			Salary 5 years ago
SALARY_5_YEAR_AGO_CURRENCY	VARCHAR2	(15)		Currency for salary 5 years ago
PREV_SAL	NUMBER			Previous salary
MKT_CURRENCY	VARCHAR2	(15)		Currency for Market salary data
MKT_MIN_SALARY	NUMBER			Minimum salary from the market data
MKT_MID_SALARY	NUMBER			Mid point salary from the market data
MKT_MAX_SALARY	NUMBER			Maximum salary from the market data

Query Text

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


SELECT GROUP_PER_IN_LER_ID
,      EFC_ACTION_ID
,      PERSON_ID
,      GRD_MIN_VAL
,      GRD_MAX_VAL
,      GRD_MID_POINT
,      BASE_SALARY
,      CURRENCY_CODE
,      BASE_SALARY_CURRENCY
,      PREV_SAL_CURRENCY
,      SALARY_1_YEAR_AGO
,      SALARY_1_YEAR_AGO_CURRENCY
,      SALARY_2_YEAR_AGO
,      SALARY_2_YEAR_AGO_CURRENCY
,      SALARY_3_YEAR_AGO
,      SALARY_3_YEAR_AGO_CURRENCY
,      SALARY_4_YEAR_AGO
,      SALARY_4_YEAR_AGO_CURRENCY
,      SALARY_5_YEAR_AGO
,      SALARY_5_YEAR_AGO_CURRENCY
,      PREV_SAL
,      MKT_CURRENCY
,      MKT_MIN_SALARY
,      MKT_MID_SALARY
,      MKT_MAX_SALARY
FROM BEN.BEN_CWB_PERSON_INFO_EFC;

Dependencies

[top of page]

BEN.BEN_CWB_PERSON_INFO_EFC does not reference any database object

BEN.BEN_CWB_PERSON_INFO_EFC is referenced by following:

BEN: BEN_CWB_PERSON_INFO_EFC#