[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
BEN.BEN_CWB_PERSON_INFO_EFC does not reference any database object
BEN.BEN_CWB_PERSON_INFO_EFC is referenced by following:
|
|
|