VIEW: BEN.BEN_VRBL_RT_PRFL_F#

Source

View Text - Preformatted

select VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, NAME NAME, TX_TYP_CD TX_TYP_CD, VRBL_RT_TRTMT_CD VRBL_RT_TRTMT_CD, ACTY_REF_PERD_CD ACTY_REF_PERD_CD, MLT_CD MLT_CD, NO_MN_ELCN_VAL_DFND_FLAG NO_MN_ELCN_VAL_DFND_FLAG, NO_MX_ELCN_VAL_DFND_FLAG NO_MX_ELCN_VAL_DFND_FLAG, ASMT_TO_USE_CD ASMT_TO_USE_CD, VPF_ATTRIBUTE_CATEGORY VPF_ATTRIBUTE_CATEGORY, VPF_ATTRIBUTE1 VPF_ATTRIBUTE1, VPF_ATTRIBUTE2 VPF_ATTRIBUTE2, VPF_ATTRIBUTE3 VPF_ATTRIBUTE3, VPF_ATTRIBUTE4 VPF_ATTRIBUTE4, VPF_ATTRIBUTE5 VPF_ATTRIBUTE5, VPF_ATTRIBUTE6 VPF_ATTRIBUTE6, VPF_ATTRIBUTE7 VPF_ATTRIBUTE7, VPF_ATTRIBUTE8 VPF_ATTRIBUTE8, VPF_ATTRIBUTE9 VPF_ATTRIBUTE9, VPF_ATTRIBUTE10 VPF_ATTRIBUTE10, VPF_ATTRIBUTE11 VPF_ATTRIBUTE11, VPF_ATTRIBUTE12 VPF_ATTRIBUTE12, VPF_ATTRIBUTE13 VPF_ATTRIBUTE13, VPF_ATTRIBUTE14 VPF_ATTRIBUTE14, VPF_ATTRIBUTE15 VPF_ATTRIBUTE15, VPF_ATTRIBUTE16 VPF_ATTRIBUTE16, VPF_ATTRIBUTE17 VPF_ATTRIBUTE17, VPF_ATTRIBUTE18 VPF_ATTRIBUTE18, VPF_ATTRIBUTE19 VPF_ATTRIBUTE19, VPF_ATTRIBUTE20 VPF_ATTRIBUTE20, VPF_ATTRIBUTE21 VPF_ATTRIBUTE21, VPF_ATTRIBUTE22 VPF_ATTRIBUTE22, VPF_ATTRIBUTE23 VPF_ATTRIBUTE23, VPF_ATTRIBUTE24 VPF_ATTRIBUTE24, VPF_ATTRIBUTE25 VPF_ATTRIBUTE25, VPF_ATTRIBUTE26 VPF_ATTRIBUTE26, VPF_ATTRIBUTE27 VPF_ATTRIBUTE27, VPF_ATTRIBUTE28 VPF_ATTRIBUTE28, VPF_ATTRIBUTE29 VPF_ATTRIBUTE29, VPF_ATTRIBUTE30 VPF_ATTRIBUTE30, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACTY_TYP_CD ACTY_TYP_CD, RT_TYP_CD RT_TYP_CD, BNFT_RT_TYP_CD BNFT_RT_TYP_CD, INCRMNT_ELCN_VAL INCRMNT_ELCN_VAL, DFLT_ELCN_VAL DFLT_ELCN_VAL, MX_ELCN_VAL MX_ELCN_VAL, MN_ELCN_VAL MN_ELCN_VAL, VAL VAL, ALWYS_SUM_ALL_CVG_FLAG ALWYS_SUM_ALL_CVG_FLAG, ALWYS_CNT_ALL_PRTTS_FLAG ALWYS_CNT_ALL_PRTTS_FLAG, VAL_CALC_RL VAL_CALC_RL, VRBL_RT_PRFL_STAT_CD VRBL_RT_PRFL_STAT_CD, VRBL_USG_CD VRBL_USG_CD, RNDG_CD RNDG_CD, RNDG_RL RNDG_RL, LWR_LMT_VAL LWR_LMT_VAL, LWR_LMT_CALC_RL LWR_LMT_CALC_RL, UPR_LMT_VAL UPR_LMT_VAL, UPR_LMT_CALC_RL UPR_LMT_CALC_RL, ANN_MN_ELCN_VAL ANN_MN_ELCN_VAL, ANN_MX_ELCN_VAL ANN_MX_ELCN_VAL, OIPL_ID OIPL_ID, PL_ID PL_ID, PL_TYP_OPT_TYP_ID PL_TYP_OPT_TYP_ID, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID, RT_HRLY_SLRD_FLAG RT_HRLY_SLRD_FLAG, RT_PSTL_CD_FLAG RT_PSTL_CD_FLAG, RT_LBR_MMBR_FLAG RT_LBR_MMBR_FLAG, RT_LGL_ENTY_FLAG RT_LGL_ENTY_FLAG, RT_BENFTS_GRP_FLAG RT_BENFTS_GRP_FLAG, RT_WK_LOC_FLAG RT_WK_LOC_FLAG, RT_BRGNG_UNIT_FLAG RT_BRGNG_UNIT_FLAG, RT_AGE_FLAG RT_AGE_FLAG, RT_LOS_FLAG RT_LOS_FLAG, RT_PER_TYP_FLAG RT_PER_TYP_FLAG, RT_FL_TM_PT_TM_FLAG RT_FL_TM_PT_TM_FLAG, RT_EE_STAT_FLAG RT_EE_STAT_FLAG, RT_GRD_FLAG RT_GRD_FLAG, RT_PCT_FL_TM_FLAG RT_PCT_FL_TM_FLAG, RT_ASNT_SET_FLAG RT_ASNT_SET_FLAG, RT_HRS_WKD_FLAG RT_HRS_WKD_FLAG, RT_COMP_LVL_FLAG RT_COMP_LVL_FLAG, RT_ORG_UNIT_FLAG RT_ORG_UNIT_FLAG, RT_LOA_RSN_FLAG RT_LOA_RSN_FLAG, RT_PYRL_FLAG RT_PYRL_FLAG, RT_SCHEDD_HRS_FLAG RT_SCHEDD_HRS_FLAG, RT_PY_BSS_FLAG RT_PY_BSS_FLAG, RT_PRFL_RL_FLAG RT_PRFL_RL_FLAG, RT_CMBN_AGE_LOS_FLAG RT_CMBN_AGE_LOS_FLAG, RT_PRTT_PL_FLAG RT_PRTT_PL_FLAG, RT_SVC_AREA_FLAG RT_SVC_AREA_FLAG, RT_PPL_GRP_FLAG RT_PPL_GRP_FLAG, RT_DSBLD_FLAG RT_DSBLD_FLAG, RT_HLTH_CVG_FLAG RT_HLTH_CVG_FLAG, RT_POE_FLAG RT_POE_FLAG, RT_TTL_CVG_VOL_FLAG RT_TTL_CVG_VOL_FLAG, RT_TTL_PRTT_FLAG RT_TTL_PRTT_FLAG, RT_GNDR_FLAG RT_GNDR_FLAG, RT_TBCO_USE_FLAG RT_TBCO_USE_FLAG, ULTMT_UPR_LMT ULTMT_UPR_LMT, ULTMT_LWR_LMT ULTMT_LWR_LMT, ULTMT_UPR_LMT_CALC_RL ULTMT_UPR_LMT_CALC_RL, ULTMT_LWR_LMT_CALC_RL ULTMT_LWR_LMT_CALC_RL, RT_CNTNG_PRTN_PRFL_FLAG RT_CNTNG_PRTN_PRFL_FLAG, RT_CBR_QUALD_BNF_FLAG RT_CBR_QUALD_BNF_FLAG, RT_OPTD_MDCR_FLAG RT_OPTD_MDCR_FLAG, RT_LVG_RSN_FLAG RT_LVG_RSN_FLAG, RT_PSTN_FLAG RT_PSTN_FLAG, RT_COMPTNCY_FLAG RT_COMPTNCY_FLAG, RT_JOB_FLAG RT_JOB_FLAG, RT_QUAL_TITL_FLAG RT_QUAL_TITL_FLAG, RT_DPNT_CVRD_PL_FLAG RT_DPNT_CVRD_PL_FLAG, RT_DPNT_CVRD_PLIP_FLAG RT_DPNT_CVRD_PLIP_FLAG, RT_DPNT_CVRD_PTIP_FLAG RT_DPNT_CVRD_PTIP_FLAG, RT_DPNT_CVRD_PGM_FLAG RT_DPNT_CVRD_PGM_FLAG, RT_ENRLD_OIPL_FLAG RT_ENRLD_OIPL_FLAG, RT_ENRLD_PL_FLAG RT_ENRLD_PL_FLAG, RT_ENRLD_PLIP_FLAG RT_ENRLD_PLIP_FLAG, RT_ENRLD_PTIP_FLAG RT_ENRLD_PTIP_FLAG, RT_ENRLD_PGM_FLAG RT_ENRLD_PGM_FLAG, RT_PRTT_ANTHR_PL_FLAG RT_PRTT_ANTHR_PL_FLAG, RT_OTHR_PTIP_FLAG RT_OTHR_PTIP_FLAG, RT_NO_OTHR_CVG_FLAG RT_NO_OTHR_CVG_FLAG, RT_DPNT_OTHR_PTIP_FLAG RT_DPNT_OTHR_PTIP_FLAG, RT_PERF_RTNG_FLAG RT_PERF_RTNG_FLAG, RT_QUA_IN_GR_FLAG RT_QUA_IN_GR_FLAG, RT_ELIG_PRFL_FLAG RT_ELIG_PRFL_FLAG from "BEN"."BEN_VRBL_RT_PRFL_F"

View Text - HTML Formatted

SELECT VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, NAME NAME
, TX_TYP_CD TX_TYP_CD
, VRBL_RT_TRTMT_CD VRBL_RT_TRTMT_CD
, ACTY_REF_PERD_CD ACTY_REF_PERD_CD
, MLT_CD MLT_CD
, NO_MN_ELCN_VAL_DFND_FLAG NO_MN_ELCN_VAL_DFND_FLAG
, NO_MX_ELCN_VAL_DFND_FLAG NO_MX_ELCN_VAL_DFND_FLAG
, ASMT_TO_USE_CD ASMT_TO_USE_CD
, VPF_ATTRIBUTE_CATEGORY VPF_ATTRIBUTE_CATEGORY
, VPF_ATTRIBUTE1 VPF_ATTRIBUTE1
, VPF_ATTRIBUTE2 VPF_ATTRIBUTE2
, VPF_ATTRIBUTE3 VPF_ATTRIBUTE3
, VPF_ATTRIBUTE4 VPF_ATTRIBUTE4
, VPF_ATTRIBUTE5 VPF_ATTRIBUTE5
, VPF_ATTRIBUTE6 VPF_ATTRIBUTE6
, VPF_ATTRIBUTE7 VPF_ATTRIBUTE7
, VPF_ATTRIBUTE8 VPF_ATTRIBUTE8
, VPF_ATTRIBUTE9 VPF_ATTRIBUTE9
, VPF_ATTRIBUTE10 VPF_ATTRIBUTE10
, VPF_ATTRIBUTE11 VPF_ATTRIBUTE11
, VPF_ATTRIBUTE12 VPF_ATTRIBUTE12
, VPF_ATTRIBUTE13 VPF_ATTRIBUTE13
, VPF_ATTRIBUTE14 VPF_ATTRIBUTE14
, VPF_ATTRIBUTE15 VPF_ATTRIBUTE15
, VPF_ATTRIBUTE16 VPF_ATTRIBUTE16
, VPF_ATTRIBUTE17 VPF_ATTRIBUTE17
, VPF_ATTRIBUTE18 VPF_ATTRIBUTE18
, VPF_ATTRIBUTE19 VPF_ATTRIBUTE19
, VPF_ATTRIBUTE20 VPF_ATTRIBUTE20
, VPF_ATTRIBUTE21 VPF_ATTRIBUTE21
, VPF_ATTRIBUTE22 VPF_ATTRIBUTE22
, VPF_ATTRIBUTE23 VPF_ATTRIBUTE23
, VPF_ATTRIBUTE24 VPF_ATTRIBUTE24
, VPF_ATTRIBUTE25 VPF_ATTRIBUTE25
, VPF_ATTRIBUTE26 VPF_ATTRIBUTE26
, VPF_ATTRIBUTE27 VPF_ATTRIBUTE27
, VPF_ATTRIBUTE28 VPF_ATTRIBUTE28
, VPF_ATTRIBUTE29 VPF_ATTRIBUTE29
, VPF_ATTRIBUTE30 VPF_ATTRIBUTE30
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ACTY_TYP_CD ACTY_TYP_CD
, RT_TYP_CD RT_TYP_CD
, BNFT_RT_TYP_CD BNFT_RT_TYP_CD
, INCRMNT_ELCN_VAL INCRMNT_ELCN_VAL
, DFLT_ELCN_VAL DFLT_ELCN_VAL
, MX_ELCN_VAL MX_ELCN_VAL
, MN_ELCN_VAL MN_ELCN_VAL
, VAL VAL
, ALWYS_SUM_ALL_CVG_FLAG ALWYS_SUM_ALL_CVG_FLAG
, ALWYS_CNT_ALL_PRTTS_FLAG ALWYS_CNT_ALL_PRTTS_FLAG
, VAL_CALC_RL VAL_CALC_RL
, VRBL_RT_PRFL_STAT_CD VRBL_RT_PRFL_STAT_CD
, VRBL_USG_CD VRBL_USG_CD
, RNDG_CD RNDG_CD
, RNDG_RL RNDG_RL
, LWR_LMT_VAL LWR_LMT_VAL
, LWR_LMT_CALC_RL LWR_LMT_CALC_RL
, UPR_LMT_VAL UPR_LMT_VAL
, UPR_LMT_CALC_RL UPR_LMT_CALC_RL
, ANN_MN_ELCN_VAL ANN_MN_ELCN_VAL
, ANN_MX_ELCN_VAL ANN_MX_ELCN_VAL
, OIPL_ID OIPL_ID
, PL_ID PL_ID
, PL_TYP_OPT_TYP_ID PL_TYP_OPT_TYP_ID
, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID
, RT_HRLY_SLRD_FLAG RT_HRLY_SLRD_FLAG
, RT_PSTL_CD_FLAG RT_PSTL_CD_FLAG
, RT_LBR_MMBR_FLAG RT_LBR_MMBR_FLAG
, RT_LGL_ENTY_FLAG RT_LGL_ENTY_FLAG
, RT_BENFTS_GRP_FLAG RT_BENFTS_GRP_FLAG
, RT_WK_LOC_FLAG RT_WK_LOC_FLAG
, RT_BRGNG_UNIT_FLAG RT_BRGNG_UNIT_FLAG
, RT_AGE_FLAG RT_AGE_FLAG
, RT_LOS_FLAG RT_LOS_FLAG
, RT_PER_TYP_FLAG RT_PER_TYP_FLAG
, RT_FL_TM_PT_TM_FLAG RT_FL_TM_PT_TM_FLAG
, RT_EE_STAT_FLAG RT_EE_STAT_FLAG
, RT_GRD_FLAG RT_GRD_FLAG
, RT_PCT_FL_TM_FLAG RT_PCT_FL_TM_FLAG
, RT_ASNT_SET_FLAG RT_ASNT_SET_FLAG
, RT_HRS_WKD_FLAG RT_HRS_WKD_FLAG
, RT_COMP_LVL_FLAG RT_COMP_LVL_FLAG
, RT_ORG_UNIT_FLAG RT_ORG_UNIT_FLAG
, RT_LOA_RSN_FLAG RT_LOA_RSN_FLAG
, RT_PYRL_FLAG RT_PYRL_FLAG
, RT_SCHEDD_HRS_FLAG RT_SCHEDD_HRS_FLAG
, RT_PY_BSS_FLAG RT_PY_BSS_FLAG
, RT_PRFL_RL_FLAG RT_PRFL_RL_FLAG
, RT_CMBN_AGE_LOS_FLAG RT_CMBN_AGE_LOS_FLAG
, RT_PRTT_PL_FLAG RT_PRTT_PL_FLAG
, RT_SVC_AREA_FLAG RT_SVC_AREA_FLAG
, RT_PPL_GRP_FLAG RT_PPL_GRP_FLAG
, RT_DSBLD_FLAG RT_DSBLD_FLAG
, RT_HLTH_CVG_FLAG RT_HLTH_CVG_FLAG
, RT_POE_FLAG RT_POE_FLAG
, RT_TTL_CVG_VOL_FLAG RT_TTL_CVG_VOL_FLAG
, RT_TTL_PRTT_FLAG RT_TTL_PRTT_FLAG
, RT_GNDR_FLAG RT_GNDR_FLAG
, RT_TBCO_USE_FLAG RT_TBCO_USE_FLAG
, ULTMT_UPR_LMT ULTMT_UPR_LMT
, ULTMT_LWR_LMT ULTMT_LWR_LMT
, ULTMT_UPR_LMT_CALC_RL ULTMT_UPR_LMT_CALC_RL
, ULTMT_LWR_LMT_CALC_RL ULTMT_LWR_LMT_CALC_RL
, RT_CNTNG_PRTN_PRFL_FLAG RT_CNTNG_PRTN_PRFL_FLAG
, RT_CBR_QUALD_BNF_FLAG RT_CBR_QUALD_BNF_FLAG
, RT_OPTD_MDCR_FLAG RT_OPTD_MDCR_FLAG
, RT_LVG_RSN_FLAG RT_LVG_RSN_FLAG
, RT_PSTN_FLAG RT_PSTN_FLAG
, RT_COMPTNCY_FLAG RT_COMPTNCY_FLAG
, RT_JOB_FLAG RT_JOB_FLAG
, RT_QUAL_TITL_FLAG RT_QUAL_TITL_FLAG
, RT_DPNT_CVRD_PL_FLAG RT_DPNT_CVRD_PL_FLAG
, RT_DPNT_CVRD_PLIP_FLAG RT_DPNT_CVRD_PLIP_FLAG
, RT_DPNT_CVRD_PTIP_FLAG RT_DPNT_CVRD_PTIP_FLAG
, RT_DPNT_CVRD_PGM_FLAG RT_DPNT_CVRD_PGM_FLAG
, RT_ENRLD_OIPL_FLAG RT_ENRLD_OIPL_FLAG
, RT_ENRLD_PL_FLAG RT_ENRLD_PL_FLAG
, RT_ENRLD_PLIP_FLAG RT_ENRLD_PLIP_FLAG
, RT_ENRLD_PTIP_FLAG RT_ENRLD_PTIP_FLAG
, RT_ENRLD_PGM_FLAG RT_ENRLD_PGM_FLAG
, RT_PRTT_ANTHR_PL_FLAG RT_PRTT_ANTHR_PL_FLAG
, RT_OTHR_PTIP_FLAG RT_OTHR_PTIP_FLAG
, RT_NO_OTHR_CVG_FLAG RT_NO_OTHR_CVG_FLAG
, RT_DPNT_OTHR_PTIP_FLAG RT_DPNT_OTHR_PTIP_FLAG
, RT_PERF_RTNG_FLAG RT_PERF_RTNG_FLAG
, RT_QUA_IN_GR_FLAG RT_QUA_IN_GR_FLAG
, RT_ELIG_PRFL_FLAG RT_ELIG_PRFL_FLAG
FROM "BEN"."BEN_VRBL_RT_PRFL_F"