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]

VIEW: BEN.BEN_ACTY_BASE_RT_F#

Object Details

Object Name:	BEN_ACTY_BASE_RT_F#
Object Type:	VIEW
Owner:	BEN
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ACTY_BASE_RT_ID	NUMBER	(15)	Yes
EFFECTIVE_START_DATE	DATE		Yes
EFFECTIVE_END_DATE	DATE		Yes
USE_TO_CALC_NET_FLX_CR_FLAG	VARCHAR2	(30)	Yes
ASN_ON_ENRT_FLAG	VARCHAR2	(30)	Yes
ABV_MX_ELCN_VAL_ALWD_FLAG	VARCHAR2	(30)	Yes
BLW_MN_ELCN_ALWD_FLAG	VARCHAR2	(30)	Yes
DSPLY_ON_ENRT_FLAG	VARCHAR2	(30)	Yes
USE_CALC_ACTY_BS_RT_FLAG	VARCHAR2	(30)	Yes
USES_DED_SCHED_FLAG	VARCHAR2	(30)	Yes
USES_VARBL_RT_FLAG	VARCHAR2	(30)	Yes
VSTG_SCHED_APLS_FLAG	VARCHAR2	(30)	Yes
PROC_EACH_PP_DFLT_FLAG	VARCHAR2	(30)	Yes
PRDCT_FLX_CR_WHEN_ELIG_FLAG	VARCHAR2	(30)	Yes
NO_STD_RT_USED_FLAG	VARCHAR2	(30)	Yes
USES_PYMT_SCHED_FLAG	VARCHAR2	(30)	Yes
VAL_OVRID_ALWD_FLAG	VARCHAR2	(30)	Yes
DFLT_FLAG	VARCHAR2	(30)	Yes
NO_MX_ELCN_VAL_DFND_FLAG	VARCHAR2	(30)	Yes
ENTR_VAL_AT_ENRT_FLAG	VARCHAR2	(30)	Yes
NO_MN_ELCN_VAL_DFND_FLAG	VARCHAR2	(30)	Yes
ONLY_ONE_BAL_TYP_ALWD_FLAG	VARCHAR2	(30)	Yes
ENTR_ANN_VAL_FLAG	VARCHAR2	(30)	Yes
OIPLIP_ID	NUMBER	(15)
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
ELE_RQD_FLAG	VARCHAR2	(30)	Yes
ONE_ANN_PYMT_CD	VARCHAR2	(30)
PRORT_MN_ANN_ELCN_VAL_CD	VARCHAR2	(30)
PRORT_MN_ANN_ELCN_VAL_RL	NUMBER	(15)
PRORT_MX_ANN_ELCN_VAL_CD	VARCHAR2	(30)
PRORT_MX_ANN_ELCN_VAL_RL	NUMBER	(15)
ABR_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ABR_ATTRIBUTE1	VARCHAR2	(150)
ABR_ATTRIBUTE2	VARCHAR2	(150)
ABR_ATTRIBUTE3	VARCHAR2	(150)
ABR_ATTRIBUTE4	VARCHAR2	(150)
ABR_ATTRIBUTE5	VARCHAR2	(150)
ABR_ATTRIBUTE6	VARCHAR2	(150)
ABR_ATTRIBUTE7	VARCHAR2	(150)
ABR_ATTRIBUTE8	VARCHAR2	(150)
ABR_ATTRIBUTE9	VARCHAR2	(150)
ABR_ATTRIBUTE10	VARCHAR2	(150)
ABR_ATTRIBUTE11	VARCHAR2	(150)
ABR_ATTRIBUTE12	VARCHAR2	(150)
ABR_ATTRIBUTE13	VARCHAR2	(150)
ABR_ATTRIBUTE14	VARCHAR2	(150)
ABR_ATTRIBUTE15	VARCHAR2	(150)
ABR_ATTRIBUTE16	VARCHAR2	(150)
ABR_ATTRIBUTE17	VARCHAR2	(150)
ABR_ATTRIBUTE18	VARCHAR2	(150)
ABR_ATTRIBUTE19	VARCHAR2	(150)
ABR_ATTRIBUTE20	VARCHAR2	(150)
ABR_ATTRIBUTE21	VARCHAR2	(150)
ABR_ATTRIBUTE22	VARCHAR2	(150)
ABR_ATTRIBUTE23	VARCHAR2	(150)
ABR_ATTRIBUTE24	VARCHAR2	(150)
ABR_ATTRIBUTE25	VARCHAR2	(150)
ABR_ATTRIBUTE26	VARCHAR2	(150)
ABR_ATTRIBUTE27	VARCHAR2	(150)
ABR_ATTRIBUTE28	VARCHAR2	(150)
ABR_ATTRIBUTE29	VARCHAR2	(150)
ABR_ATTRIBUTE30	VARCHAR2	(150)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
OBJECT_VERSION_NUMBER	NUMBER	(9)
ACTY_TYP_CD	VARCHAR2	(30)
RNDG_RL	NUMBER	(15)
PRTL_MO_EFF_DT_DET_RL	NUMBER	(15)
NAME	VARCHAR2	(240)
RT_TYP_CD	VARCHAR2	(30)
BNFT_RT_TYP_CD	VARCHAR2	(30)
TX_TYP_CD	VARCHAR2	(30)
PRTL_MO_DET_MTHD_RL	NUMBER	(15)
PARNT_CHLD_CD	VARCHAR2	(30)
VAL_CALC_RL	NUMBER	(15)
RT_MLT_CD	VARCHAR2	(30)
PARNT_ACTY_BASE_RT_ID	NUMBER	(15)
RCRRG_CD	VARCHAR2	(30)
MN_ELCN_VAL	NUMBER
MX_ELCN_VAL	NUMBER
NNMNTRY_UOM	VARCHAR2	(30)
VAL	NUMBER
INCRMT_ELCN_VAL	NUMBER
RNDG_CD	VARCHAR2	(30)
PRTL_MO_DET_MTHD_CD	VARCHAR2	(30)
ACTY_BASE_RT_STAT_CD	VARCHAR2	(30)
PROCG_SRC_CD	VARCHAR2	(30)
DFLT_VAL	NUMBER
FRGN_ERG_DED_TYP_CD	VARCHAR2	(30)
FRGN_ERG_DED_NAME	VARCHAR2	(180)
FRGN_ERG_DED_IDENT	VARCHAR2	(90)
PRTL_MO_EFF_DT_DET_CD	VARCHAR2	(30)
ANN_MN_ELCN_VAL	NUMBER
ANN_MX_ELCN_VAL	NUMBER
RT_USG_CD	VARCHAR2	(30)
LWR_LMT_VAL	NUMBER
LWR_LMT_CALC_RL	NUMBER	(15)
UPR_LMT_VAL	NUMBER
UPR_LMT_CALC_RL	NUMBER	(15)
SUBJ_TO_IMPTD_INCM_FLAG	VARCHAR2	(30)
WSH_RL_DY_MO_NUM	NUMBER	(15)
INPUT_VALUE_ID	NUMBER	(9)
ELEMENT_TYPE_ID	NUMBER	(15)
CMBN_PLIP_ID	NUMBER	(15)
PGM_ID	NUMBER	(15)
PL_ID	NUMBER	(15)
OIPL_ID	NUMBER	(15)
PLIP_ID	NUMBER	(15)
PTIP_ID	NUMBER	(15)
CMBN_PTIP_ID	NUMBER	(15)
CMBN_PTIP_OPT_ID	NUMBER	(15)
COMP_LVL_FCTR_ID	NUMBER	(15)
VSTG_FOR_ACTY_RT_ID	NUMBER	(15)
PTD_COMP_LVL_FCTR_ID	NUMBER	(15)
CLM_COMP_LVL_FCTR_ID	NUMBER	(15)
ACTL_PREM_ID	NUMBER	(15)
ASMT_TO_USE_CD	VARCHAR2	(30)
DET_PL_YTD_CNTRS_CD	VARCHAR2	(30)
TTL_COMP_LVL_FCTR_ID	NUMBER	(15)
COST_ALLOCATION_KEYFLEX_ID	NUMBER	(15)
ALWS_CHG_CD	VARCHAR2	(30)
ELE_ENTRY_VAL_CD	VARCHAR2	(30)
INPUT_VA_CALC_RL	NUMBER	(15)
PAY_RATE_GRADE_RULE_ID	NUMBER	(15)
ORDR_NUM	NUMBER	(15)
OPT_ID	NUMBER	(15)
SUB_ACTY_TYP_CD	VARCHAR2	(30)
RATE_PERIODIZATION_CD	VARCHAR2	(30)
RATE_PERIODIZATION_RL	NUMBER
MN_MX_ELCN_RL	NUMBER	(15)
MAPPING_TABLE_NAME	VARCHAR2	(60)
MAPPING_TABLE_PK_ID	NUMBER	(15)
CONTEXT_PGM_ID	NUMBER	(15)
CONTEXT_PL_ID	NUMBER	(15)
CONTEXT_OPT_ID	NUMBER	(15)
CURRENCY_DET_CD	VARCHAR2	(30)
ELEMENT_DET_RL	NUMBER	(15)
ABR_SEQ_NUM	NUMBER	(15)
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT ACTY_BASE_RT_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      USE_TO_CALC_NET_FLX_CR_FLAG
,      ASN_ON_ENRT_FLAG
,      ABV_MX_ELCN_VAL_ALWD_FLAG
,      BLW_MN_ELCN_ALWD_FLAG
,      DSPLY_ON_ENRT_FLAG
,      USE_CALC_ACTY_BS_RT_FLAG
,      USES_DED_SCHED_FLAG
,      USES_VARBL_RT_FLAG
,      VSTG_SCHED_APLS_FLAG
,      PROC_EACH_PP_DFLT_FLAG
,      PRDCT_FLX_CR_WHEN_ELIG_FLAG
,      NO_STD_RT_USED_FLAG
,      USES_PYMT_SCHED_FLAG
,      VAL_OVRID_ALWD_FLAG
,      DFLT_FLAG
,      NO_MX_ELCN_VAL_DFND_FLAG
,      ENTR_VAL_AT_ENRT_FLAG
,      NO_MN_ELCN_VAL_DFND_FLAG
,      ONLY_ONE_BAL_TYP_ALWD_FLAG
,      ENTR_ANN_VAL_FLAG
,      OIPLIP_ID
,      BUSINESS_GROUP_ID
,      ELE_RQD_FLAG
,      ONE_ANN_PYMT_CD
,      PRORT_MN_ANN_ELCN_VAL_CD
,      PRORT_MN_ANN_ELCN_VAL_RL
,      PRORT_MX_ANN_ELCN_VAL_CD
,      PRORT_MX_ANN_ELCN_VAL_RL
,      ABR_ATTRIBUTE_CATEGORY
,      ABR_ATTRIBUTE1
,      ABR_ATTRIBUTE2
,      ABR_ATTRIBUTE3
,      ABR_ATTRIBUTE4
,      ABR_ATTRIBUTE5
,      ABR_ATTRIBUTE6
,      ABR_ATTRIBUTE7
,      ABR_ATTRIBUTE8
,      ABR_ATTRIBUTE9
,      ABR_ATTRIBUTE10
,      ABR_ATTRIBUTE11
,      ABR_ATTRIBUTE12
,      ABR_ATTRIBUTE13
,      ABR_ATTRIBUTE14
,      ABR_ATTRIBUTE15
,      ABR_ATTRIBUTE16
,      ABR_ATTRIBUTE17
,      ABR_ATTRIBUTE18
,      ABR_ATTRIBUTE19
,      ABR_ATTRIBUTE20
,      ABR_ATTRIBUTE21
,      ABR_ATTRIBUTE22
,      ABR_ATTRIBUTE23
,      ABR_ATTRIBUTE24
,      ABR_ATTRIBUTE25
,      ABR_ATTRIBUTE26
,      ABR_ATTRIBUTE27
,      ABR_ATTRIBUTE28
,      ABR_ATTRIBUTE29
,      ABR_ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      ACTY_TYP_CD
,      RNDG_RL
,      PRTL_MO_EFF_DT_DET_RL
,      NAME
,      RT_TYP_CD
,      BNFT_RT_TYP_CD
,      TX_TYP_CD
,      PRTL_MO_DET_MTHD_RL
,      PARNT_CHLD_CD
,      VAL_CALC_RL
,      RT_MLT_CD
,      PARNT_ACTY_BASE_RT_ID
,      RCRRG_CD
,      MN_ELCN_VAL
,      MX_ELCN_VAL
,      NNMNTRY_UOM
,      VAL
,      INCRMT_ELCN_VAL
,      RNDG_CD
,      PRTL_MO_DET_MTHD_CD
,      ACTY_BASE_RT_STAT_CD
,      PROCG_SRC_CD
,      DFLT_VAL
,      FRGN_ERG_DED_TYP_CD
,      FRGN_ERG_DED_NAME
,      FRGN_ERG_DED_IDENT
,      PRTL_MO_EFF_DT_DET_CD
,      ANN_MN_ELCN_VAL
,      ANN_MX_ELCN_VAL
,      RT_USG_CD
,      LWR_LMT_VAL
,      LWR_LMT_CALC_RL
,      UPR_LMT_VAL
,      UPR_LMT_CALC_RL
,      SUBJ_TO_IMPTD_INCM_FLAG
,      WSH_RL_DY_MO_NUM
,      INPUT_VALUE_ID
,      ELEMENT_TYPE_ID
,      CMBN_PLIP_ID
,      PGM_ID
,      PL_ID
,      OIPL_ID
,      PLIP_ID
,      PTIP_ID
,      CMBN_PTIP_ID
,      CMBN_PTIP_OPT_ID
,      COMP_LVL_FCTR_ID
,      VSTG_FOR_ACTY_RT_ID
,      PTD_COMP_LVL_FCTR_ID
,      CLM_COMP_LVL_FCTR_ID
,      ACTL_PREM_ID
,      ASMT_TO_USE_CD
,      DET_PL_YTD_CNTRS_CD
,      TTL_COMP_LVL_FCTR_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      ALWS_CHG_CD
,      ELE_ENTRY_VAL_CD
,      INPUT_VA_CALC_RL
,      PAY_RATE_GRADE_RULE_ID
,      ORDR_NUM
,      OPT_ID
,      SUB_ACTY_TYP_CD
,      RATE_PERIODIZATION_CD
,      RATE_PERIODIZATION_RL
,      MN_MX_ELCN_RL
,      MAPPING_TABLE_NAME
,      MAPPING_TABLE_PK_ID
,      CONTEXT_PGM_ID
,      CONTEXT_PL_ID
,      CONTEXT_OPT_ID
,      CURRENCY_DET_CD
,      ELEMENT_DET_RL
,      ABR_SEQ_NUM
,      ZD_EDITION_NAME
FROM BEN.BEN_ACTY_BASE_RT_F#;

Dependencies

[top of page]

BEN.BEN_ACTY_BASE_RT_F# references the following:

BEN: BEN_ACTY_BASE_RT_F

BEN.BEN_ACTY_BASE_RT_F# is referenced by following:

APPS: BEN_ACTY_BASE_RT_F; BEN_ACTY_BASE_RT_F+; BEN_ACTY_BASE_RT_F_WHO