[Home] [Help] [Dependency Information]
Object Name: | BEN_CWB_PERSON_INFO_EFC# |
---|---|
Object Type: | VIEW |
Owner: | BEN |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_PER_IN_LER_ID | NUMBER | (15) | Yes | |
EFC_ACTION_ID | NUMBER | (15) | Yes | |
PERSON_ID | NUMBER | (15) | Yes | |
GRD_MIN_VAL | NUMBER | |||
GRD_MAX_VAL | NUMBER | |||
GRD_MID_POINT | NUMBER | |||
BASE_SALARY | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (30) | ||
BASE_SALARY_CURRENCY | VARCHAR2 | (30) | ||
PREV_SAL_CURRENCY | VARCHAR2 | (15) | ||
SALARY_1_YEAR_AGO | NUMBER | |||
SALARY_1_YEAR_AGO_CURRENCY | VARCHAR2 | (15) | ||
SALARY_2_YEAR_AGO | NUMBER | |||
SALARY_2_YEAR_AGO_CURRENCY | VARCHAR2 | (15) | ||
SALARY_3_YEAR_AGO | NUMBER | |||
SALARY_3_YEAR_AGO_CURRENCY | VARCHAR2 | (15) | ||
SALARY_4_YEAR_AGO | NUMBER | |||
SALARY_4_YEAR_AGO_CURRENCY | VARCHAR2 | (15) | ||
SALARY_5_YEAR_AGO | NUMBER | |||
SALARY_5_YEAR_AGO_CURRENCY | VARCHAR2 | (15) | ||
PREV_SAL | NUMBER | |||
MKT_CURRENCY | VARCHAR2 | (15) | ||
MKT_MIN_SALARY | NUMBER | |||
MKT_MID_SALARY | NUMBER | |||
MKT_MAX_SALARY | NUMBER |
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#;
|
|
|