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

VIEW: BEN.BEN_BATCH_RATE_INFO#

Object Details
Object Name: BEN_BATCH_RATE_INFO#
Object Type: VIEW
Owner: BEN
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_RT_ID NUMBER (15) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
BENEFIT_ACTION_ID NUMBER (15) Yes
ENRT_CVG_STRT_DT DATE

ENRT_CVG_THRU_DT DATE

ACTN_CD VARCHAR2 (30)
CLOSE_ACTN_ITM_DT DATE

PERSON_ID NUMBER (15) Yes
PGM_ID NUMBER (15)
PL_ID NUMBER (15)
OIPL_ID NUMBER (15)
BNFT_RT_TYP_CD VARCHAR2 (30)
DFLT_FLAG VARCHAR2 (30) Yes
VAL NUMBER (38)
TX_TYP_CD VARCHAR2 (30)
ACTY_TYP_CD VARCHAR2 (30)
MN_ELCN_VAL NUMBER (38)
MX_ELCN_VAL NUMBER (38)
INCRMT_ELCN_VAL NUMBER (38)
DFLT_VAL NUMBER (38)
RT_STRT_DT DATE

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY VARCHAR2 (15)
LAST_UPDATE_LOGIN VARCHAR2 (15)
CREATED_BY VARCHAR2 (15)
CREATION_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (9) Yes
OLD_VAL NUMBER

Query Text

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


SELECT BATCH_RT_ID
,      BUSINESS_GROUP_ID
,      BENEFIT_ACTION_ID
,      ENRT_CVG_STRT_DT
,      ENRT_CVG_THRU_DT
,      ACTN_CD
,      CLOSE_ACTN_ITM_DT
,      PERSON_ID
,      PGM_ID
,      PL_ID
,      OIPL_ID
,      BNFT_RT_TYP_CD
,      DFLT_FLAG
,      VAL
,      TX_TYP_CD
,      ACTY_TYP_CD
,      MN_ELCN_VAL
,      MX_ELCN_VAL
,      INCRMT_ELCN_VAL
,      DFLT_VAL
,      RT_STRT_DT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      OLD_VAL
FROM BEN.BEN_BATCH_RATE_INFO#;

Dependencies

[top of page]

BEN.BEN_BATCH_RATE_INFO# references the following:

SchemaBEN
TableBEN_BATCH_RATE_INFO
BEN.BEN_BATCH_RATE_INFO# is referenced by following:

SchemaAPPS
SynonymBEN_BATCH_RATE_INFO