Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: BEN.BEN_CWB_PERSON_RATES_EFC

Object Details
Object Name: BEN_CWB_PERSON_RATES_EFC
Object Type: TABLE
Owner: BEN
Subobject Name:
Status: VALID


Table for supporting EFC conversion of monetary columns in BEN_CWB_PERSON_RATES table


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BEN_CWB_PERSON_RATES_EFC_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_RATE_ID
ColumnEFC_ACTION_ID
Columns
Name Datatype Length Mandatory Comments
PERSON_RATE_ID NUMBER (15) Yes Reference to BEN_CWB_PERSON_RATES
EFC_ACTION_ID NUMBER (15) Yes References EFC Process table
WS_MN_VAL NUMBER

Minimum value for worksheet amount
WS_MX_VAL NUMBER

Maximum value for worksheet amount
WS_VAL NUMBER

Worksheet value
ELIG_SAL_VAL NUMBER

Eligible salary Value
STAT_SAL_VAL NUMBER

State salary value
OTH_COMP_VAL NUMBER

Other Compensation value
TOT_COMP_VAL NUMBER

Total Compensatoin Value
MISC1_VAL NUMBER

Miscellaneous 1 Value
MISC2_VAL NUMBER

Miscellaneous 2 Value
MISC3_VAL NUMBER

Miscellaneous 3 Value
REC_MN_VAL NUMBER

Minimum value for recommended amount
REC_MX_VAL NUMBER

Maximum value for recommended amount
REC_VAL NUMBER

Recommended amount
PL_UOM VARCHAR2 (30)
Unit of measure for the Plan
CURRENCY VARCHAR2 (30)
Currency
Query Text

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


SELECT PERSON_RATE_ID
,      EFC_ACTION_ID
,      WS_MN_VAL
,      WS_MX_VAL
,      WS_VAL
,      ELIG_SAL_VAL
,      STAT_SAL_VAL
,      OTH_COMP_VAL
,      TOT_COMP_VAL
,      MISC1_VAL
,      MISC2_VAL
,      MISC3_VAL
,      REC_MN_VAL
,      REC_MX_VAL
,      REC_VAL
,      PL_UOM
,      CURRENCY
FROM BEN.BEN_CWB_PERSON_RATES_EFC;

Dependencies

[top of page]

BEN.BEN_CWB_PERSON_RATES_EFC does not reference any database object

BEN.BEN_CWB_PERSON_RATES_EFC is referenced by following:

SchemaBEN
ViewBEN_CWB_PERSON_RATES_EFC#