VIEW: BEN.BEN_PRTL_MO_RT_PRTN_VAL_F#

Source

View Text - Preformatted

select PRTL_MO_RT_PRTN_VAL_ID PRTL_MO_RT_PRTN_VAL_ID, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, RNDG_CD RNDG_CD, TO_DY_MO_NUM TO_DY_MO_NUM, FROM_DY_MO_NUM FROM_DY_MO_NUM, PCT_VAL PCT_VAL, STRT_R_STP_CVG_CD STRT_R_STP_CVG_CD, RNDG_RL RNDG_RL, PRTL_MO_PRORTN_RL PRTL_MO_PRORTN_RL, ACTL_PREM_ID ACTL_PREM_ID, CVG_AMT_CALC_MTHD_ID CVG_AMT_CALC_MTHD_ID, ACTY_BASE_RT_ID ACTY_BASE_RT_ID, PMRPV_ATTRIBUTE_CATEGORY PMRPV_ATTRIBUTE_CATEGORY, PMRPV_ATTRIBUTE1 PMRPV_ATTRIBUTE1, PMRPV_ATTRIBUTE2 PMRPV_ATTRIBUTE2, PMRPV_ATTRIBUTE3 PMRPV_ATTRIBUTE3, PMRPV_ATTRIBUTE4 PMRPV_ATTRIBUTE4, PMRPV_ATTRIBUTE5 PMRPV_ATTRIBUTE5, PMRPV_ATTRIBUTE6 PMRPV_ATTRIBUTE6, PMRPV_ATTRIBUTE7 PMRPV_ATTRIBUTE7, PMRPV_ATTRIBUTE8 PMRPV_ATTRIBUTE8, PMRPV_ATTRIBUTE9 PMRPV_ATTRIBUTE9, PMRPV_ATTRIBUTE10 PMRPV_ATTRIBUTE10, PMRPV_ATTRIBUTE11 PMRPV_ATTRIBUTE11, PMRPV_ATTRIBUTE12 PMRPV_ATTRIBUTE12, PMRPV_ATTRIBUTE13 PMRPV_ATTRIBUTE13, PMRPV_ATTRIBUTE14 PMRPV_ATTRIBUTE14, PMRPV_ATTRIBUTE15 PMRPV_ATTRIBUTE15, PMRPV_ATTRIBUTE16 PMRPV_ATTRIBUTE16, PMRPV_ATTRIBUTE17 PMRPV_ATTRIBUTE17, PMRPV_ATTRIBUTE18 PMRPV_ATTRIBUTE18, PMRPV_ATTRIBUTE19 PMRPV_ATTRIBUTE19, PMRPV_ATTRIBUTE20 PMRPV_ATTRIBUTE20, PMRPV_ATTRIBUTE21 PMRPV_ATTRIBUTE21, PMRPV_ATTRIBUTE22 PMRPV_ATTRIBUTE22, PMRPV_ATTRIBUTE23 PMRPV_ATTRIBUTE23, PMRPV_ATTRIBUTE24 PMRPV_ATTRIBUTE24, PMRPV_ATTRIBUTE25 PMRPV_ATTRIBUTE25, PMRPV_ATTRIBUTE26 PMRPV_ATTRIBUTE26, PMRPV_ATTRIBUTE27 PMRPV_ATTRIBUTE27, PMRPV_ATTRIBUTE28 PMRPV_ATTRIBUTE28, PMRPV_ATTRIBUTE29 PMRPV_ATTRIBUTE29, PMRPV_ATTRIBUTE30 PMRPV_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, NUM_DAYS_MONTH NUM_DAYS_MONTH, PRORATE_BY_DAY_TO_MON_FLAG PRORATE_BY_DAY_TO_MON_FLAG from "BEN"."BEN_PRTL_MO_RT_PRTN_VAL_F"

View Text - HTML Formatted

SELECT PRTL_MO_RT_PRTN_VAL_ID PRTL_MO_RT_PRTN_VAL_ID
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, RNDG_CD RNDG_CD
, TO_DY_MO_NUM TO_DY_MO_NUM
, FROM_DY_MO_NUM FROM_DY_MO_NUM
, PCT_VAL PCT_VAL
, STRT_R_STP_CVG_CD STRT_R_STP_CVG_CD
, RNDG_RL RNDG_RL
, PRTL_MO_PRORTN_RL PRTL_MO_PRORTN_RL
, ACTL_PREM_ID ACTL_PREM_ID
, CVG_AMT_CALC_MTHD_ID CVG_AMT_CALC_MTHD_ID
, ACTY_BASE_RT_ID ACTY_BASE_RT_ID
, PMRPV_ATTRIBUTE_CATEGORY PMRPV_ATTRIBUTE_CATEGORY
, PMRPV_ATTRIBUTE1 PMRPV_ATTRIBUTE1
, PMRPV_ATTRIBUTE2 PMRPV_ATTRIBUTE2
, PMRPV_ATTRIBUTE3 PMRPV_ATTRIBUTE3
, PMRPV_ATTRIBUTE4 PMRPV_ATTRIBUTE4
, PMRPV_ATTRIBUTE5 PMRPV_ATTRIBUTE5
, PMRPV_ATTRIBUTE6 PMRPV_ATTRIBUTE6
, PMRPV_ATTRIBUTE7 PMRPV_ATTRIBUTE7
, PMRPV_ATTRIBUTE8 PMRPV_ATTRIBUTE8
, PMRPV_ATTRIBUTE9 PMRPV_ATTRIBUTE9
, PMRPV_ATTRIBUTE10 PMRPV_ATTRIBUTE10
, PMRPV_ATTRIBUTE11 PMRPV_ATTRIBUTE11
, PMRPV_ATTRIBUTE12 PMRPV_ATTRIBUTE12
, PMRPV_ATTRIBUTE13 PMRPV_ATTRIBUTE13
, PMRPV_ATTRIBUTE14 PMRPV_ATTRIBUTE14
, PMRPV_ATTRIBUTE15 PMRPV_ATTRIBUTE15
, PMRPV_ATTRIBUTE16 PMRPV_ATTRIBUTE16
, PMRPV_ATTRIBUTE17 PMRPV_ATTRIBUTE17
, PMRPV_ATTRIBUTE18 PMRPV_ATTRIBUTE18
, PMRPV_ATTRIBUTE19 PMRPV_ATTRIBUTE19
, PMRPV_ATTRIBUTE20 PMRPV_ATTRIBUTE20
, PMRPV_ATTRIBUTE21 PMRPV_ATTRIBUTE21
, PMRPV_ATTRIBUTE22 PMRPV_ATTRIBUTE22
, PMRPV_ATTRIBUTE23 PMRPV_ATTRIBUTE23
, PMRPV_ATTRIBUTE24 PMRPV_ATTRIBUTE24
, PMRPV_ATTRIBUTE25 PMRPV_ATTRIBUTE25
, PMRPV_ATTRIBUTE26 PMRPV_ATTRIBUTE26
, PMRPV_ATTRIBUTE27 PMRPV_ATTRIBUTE27
, PMRPV_ATTRIBUTE28 PMRPV_ATTRIBUTE28
, PMRPV_ATTRIBUTE29 PMRPV_ATTRIBUTE29
, PMRPV_ATTRIBUTE30 PMRPV_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
, NUM_DAYS_MONTH NUM_DAYS_MONTH
, PRORATE_BY_DAY_TO_MON_FLAG PRORATE_BY_DAY_TO_MON_FLAG
FROM "BEN"."BEN_PRTL_MO_RT_PRTN_VAL_F"