VIEW: BEN.BEN_LE_CLSN_N_RSTR#

Source

View Text - Preformatted

select BKUP_TBL_ID BKUP_TBL_ID, BKUP_TBL_TYP_CD BKUP_TBL_TYP_CD, PER_IN_LER_ID PER_IN_LER_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, ENRT_CVG_STRT_DT ENRT_CVG_STRT_DT, ENRT_CVG_THRU_DT ENRT_CVG_THRU_DT, BNFT_AMT BNFT_AMT, BNFT_NNMNTRY_UOM BNFT_NNMNTRY_UOM, BNFT_ORDR_NUM BNFT_ORDR_NUM, BNFT_TYP_CD BNFT_TYP_CD, COMP_LVL_CD COMP_LVL_CD, ENRT_MTHD_CD ENRT_MTHD_CD, ENRT_OVRID_RSN_CD ENRT_OVRID_RSN_CD, ENRT_OVRID_THRU_DT ENRT_OVRID_THRU_DT, ENRT_OVRIDN_FLAG ENRT_OVRIDN_FLAG, ERLST_DEENRT_DT ERLST_DEENRT_DT, NO_LNGR_ELIG_FLAG NO_LNGR_ELIG_FLAG, ORGNL_ENRT_DT ORGNL_ENRT_DT, PRTT_ENRT_RSLT_STAT_CD PRTT_ENRT_RSLT_STAT_CD, PRTT_IS_CVRD_FLAG PRTT_IS_CVRD_FLAG, SSPNDD_FLAG SSPNDD_FLAG, UOM UOM, ADDL_INSTRN_TXT ADDL_INSTRN_TXT, AMT_DSGD_VAL AMT_DSGD_VAL, AMT_DSGD_UOM AMT_DSGD_UOM, DSGN_STRT_DT DSGN_STRT_DT, DSGN_THRU_DT DSGN_THRU_DT, PCT_DSGD_NUM PCT_DSGD_NUM, PRMRY_CNTNGNT_CD PRMRY_CNTNGNT_CD, CVG_PNDG_FLAG CVG_PNDG_FLAG, CVRD_FLAG CVRD_FLAG, ELIG_FLAG ELIG_FLAG, OVRDN_FLAG OVRDN_FLAG, CVG_STRT_DT CVG_STRT_DT, CVG_THRU_DT CVG_THRU_DT, ELIG_STRT_DT ELIG_STRT_DT, ELIG_THRU_DT ELIG_THRU_DT, OVRDN_THRU_DT OVRDN_THRU_DT, RT_STRT_DT RT_STRT_DT, RT_END_DT RT_END_DT, DSPLY_ON_ENRT_FLAG DSPLY_ON_ENRT_FLAG, RT_OVRIDN_FLAG RT_OVRIDN_FLAG, ACTY_REF_PERD_CD ACTY_REF_PERD_CD, ACTY_TYP_CD ACTY_TYP_CD, ANN_RT_VAL ANN_RT_VAL, BNFT_RT_TYP_CD BNFT_RT_TYP_CD, CMCD_REF_PERD_CD CMCD_REF_PERD_CD, CMCD_RT_VAL CMCD_RT_VAL, ELCNS_MADE_DT ELCNS_MADE_DT, MLT_CD MLT_CD, PRTT_RT_VAL_STAT_CD PRTT_RT_VAL_STAT_CD, RT_OVRIDN_THRU_DT RT_OVRIDN_THRU_DT, RT_VAL RT_VAL, TX_TYP_CD TX_TYP_CD, INELG_RSN_CD INELG_RSN_CD, RT_COMP_REF_AMT RT_COMP_REF_AMT, RT_CMBN_AGE_N_LOS_VAL RT_CMBN_AGE_N_LOS_VAL, RT_COMP_REF_UOM RT_COMP_REF_UOM, RT_AGE_VAL RT_AGE_VAL, RT_LOS_VAL RT_LOS_VAL, RT_HRS_WKD_VAL RT_HRS_WKD_VAL, RT_HRS_WKD_BNDRY_PERD_CD RT_HRS_WKD_BNDRY_PERD_CD, RT_AGE_UOM RT_AGE_UOM, RT_LOS_UOM RT_LOS_UOM, RT_PCT_FL_TM_VAL RT_PCT_FL_TM_VAL, RT_FRZ_LOS_FLAG RT_FRZ_LOS_FLAG, RT_FRZ_AGE_FLAG RT_FRZ_AGE_FLAG, RT_FRZ_CMP_LVL_FLAG RT_FRZ_CMP_LVL_FLAG, RT_FRZ_PCT_FL_TM_FLAG RT_FRZ_PCT_FL_TM_FLAG, RT_FRZ_HRS_WKD_FLAG RT_FRZ_HRS_WKD_FLAG, RT_FRZ_COMB_AGE_AND_LOS_FLAG RT_FRZ_COMB_AGE_AND_LOS_FLAG, AGE_UOM AGE_UOM, AGE_VAL AGE_VAL, CMBN_AGE_N_LOS_VAL CMBN_AGE_N_LOS_VAL, COMP_REF_AMT COMP_REF_AMT, COMP_REF_UOM COMP_REF_UOM, DPNT_OTHER_PL_CVRD_RL_FLAG DPNT_OTHER_PL_CVRD_RL_FLAG, DSTR_RSTCN_FLAG DSTR_RSTCN_FLAG, FRZ_AGE_FLAG FRZ_AGE_FLAG, FRZ_CMP_LVL_FLAG FRZ_CMP_LVL_FLAG, FRZ_COMB_AGE_AND_LOS_FLAG FRZ_COMB_AGE_AND_LOS_FLAG, FRZ_HRS_WKD_FLAG FRZ_HRS_WKD_FLAG, FRZ_LOS_FLAG FRZ_LOS_FLAG, FRZ_PCT_FL_TM_FLAG FRZ_PCT_FL_TM_FLAG, HRS_WKD_BNDRY_PERD_CD HRS_WKD_BNDRY_PERD_CD, HRS_WKD_VAL HRS_WKD_VAL, LOS_UOM LOS_UOM, LOS_VAL LOS_VAL, NO_MX_PRTN_OVRID_THRU_FLAG NO_MX_PRTN_OVRID_THRU_FLAG, OVRID_SVC_DT OVRID_SVC_DT, PCT_FL_TM_VAL PCT_FL_TM_VAL, PL_HGHLY_COMPD_FLAG PL_HGHLY_COMPD_FLAG, PL_KEY_EE_FLAG PL_KEY_EE_FLAG, PL_WVD_FLAG PL_WVD_FLAG, PRTN_END_DT PRTN_END_DT, PRTN_OVRIDN_FLAG PRTN_OVRIDN_FLAG, PRTN_OVRIDN_RSN_CD PRTN_OVRIDN_RSN_CD, PRTN_OVRIDN_THRU_DT PRTN_OVRIDN_THRU_DT, PRTN_STRT_DT PRTN_STRT_DT, WAIT_PERD_CMPLTN_DT WAIT_PERD_CMPLTN_DT, WV_CTFN_TYP_CD WV_CTFN_TYP_CD, WV_PRTN_RSN_CD WV_PRTN_RSN_CD, PERSON_ID PERSON_ID, PL_ID PL_ID, LER_ID LER_ID, PTIP_ID PTIP_ID, PLIP_ID PLIP_ID, OTHR_PL_ENRLD_ID OTHR_PL_ENRLD_ID, PGM_ID PGM_ID, ELIG_PER_ID ELIG_PER_ID, OPT_ID OPT_ID, ORGANIZATION_ID ORGANIZATION_ID, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID, PERSON_TTEE_ID PERSON_TTEE_ID, ELIG_PER_ELCTBL_CHC_ID ELIG_PER_ELCTBL_CHC_ID, PERSON_DPNT_ID PERSON_DPNT_ID, ELEMENT_ENTRY_VALUE_ID ELEMENT_ENTRY_VALUE_ID, PER_IN_LER_ENDED_ID PER_IN_LER_ENDED_ID, CVG_AMT_CALC_MTHD_ID CVG_AMT_CALC_MTHD_ID, TTEE_PERSON_ID TTEE_PERSON_ID, ENRT_RT_ID ENRT_RT_ID, ACTY_BASE_RT_ID ACTY_BASE_RT_ID, OIPL_ID OIPL_ID, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID, PL_TYP_ID PL_TYP_ID, ACTL_PREM_ID ACTL_PREM_ID, PRTT_ENRT_RSLT_SSPNDD_ID PRTT_ENRT_RSLT_SSPNDD_ID, ASSIGNMENT_ID ASSIGNMENT_ID, ENRT_BNFT_ID ENRT_BNFT_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, DPNT_PERSON_ID DPNT_PERSON_ID, ONCE_R_CNTUG_CD ONCE_R_CNTUG_CD, DPNT_OTHR_PL_CVRD_RL_FLAG DPNT_OTHR_PL_CVRD_RL_FLAG, MUST_ENRL_ANTHR_PL_ID MUST_ENRL_ANTHR_PL_ID, PL_ORDR_NUM PL_ORDR_NUM, PLIP_ORDR_NUM PLIP_ORDR_NUM, PTIP_ORDR_NUM PTIP_ORDR_NUM, OIPL_ORDR_NUM OIPL_ORDR_NUM, BNF_PERSON_ID BNF_PERSON_ID, RPLCS_SSPNDD_RSLT_ID RPLCS_SSPNDD_RSLT_ID, VAL VAL, STD_PREM_VAL STD_PREM_VAL, STD_PREM_UOM STD_PREM_UOM, LCR_ATTRIBUTE_CATEGORY LCR_ATTRIBUTE_CATEGORY, LCR_ATTRIBUTE1 LCR_ATTRIBUTE1, LCR_ATTRIBUTE2 LCR_ATTRIBUTE2, LCR_ATTRIBUTE3 LCR_ATTRIBUTE3, LCR_ATTRIBUTE4 LCR_ATTRIBUTE4, LCR_ATTRIBUTE5 LCR_ATTRIBUTE5, LCR_ATTRIBUTE6 LCR_ATTRIBUTE6, LCR_ATTRIBUTE7 LCR_ATTRIBUTE7, LCR_ATTRIBUTE8 LCR_ATTRIBUTE8, LCR_ATTRIBUTE9 LCR_ATTRIBUTE9, LCR_ATTRIBUTE10 LCR_ATTRIBUTE10, LCR_ATTRIBUTE11 LCR_ATTRIBUTE11, LCR_ATTRIBUTE12 LCR_ATTRIBUTE12, LCR_ATTRIBUTE13 LCR_ATTRIBUTE13, LCR_ATTRIBUTE14 LCR_ATTRIBUTE14, LCR_ATTRIBUTE15 LCR_ATTRIBUTE15, LCR_ATTRIBUTE16 LCR_ATTRIBUTE16, LCR_ATTRIBUTE17 LCR_ATTRIBUTE17, LCR_ATTRIBUTE18 LCR_ATTRIBUTE18, LCR_ATTRIBUTE19 LCR_ATTRIBUTE19, LCR_ATTRIBUTE20 LCR_ATTRIBUTE20, LCR_ATTRIBUTE21 LCR_ATTRIBUTE21, LCR_ATTRIBUTE22 LCR_ATTRIBUTE22, LCR_ATTRIBUTE23 LCR_ATTRIBUTE23, LCR_ATTRIBUTE24 LCR_ATTRIBUTE24, LCR_ATTRIBUTE25 LCR_ATTRIBUTE25, LCR_ATTRIBUTE26 LCR_ATTRIBUTE26, LCR_ATTRIBUTE27 LCR_ATTRIBUTE27, LCR_ATTRIBUTE28 LCR_ATTRIBUTE28, LCR_ATTRIBUTE29 LCR_ATTRIBUTE29, LCR_ATTRIBUTE30 LCR_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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "BEN"."BEN_LE_CLSN_N_RSTR"

View Text - HTML Formatted

SELECT BKUP_TBL_ID BKUP_TBL_ID
, BKUP_TBL_TYP_CD BKUP_TBL_TYP_CD
, PER_IN_LER_ID PER_IN_LER_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, ENRT_CVG_STRT_DT ENRT_CVG_STRT_DT
, ENRT_CVG_THRU_DT ENRT_CVG_THRU_DT
, BNFT_AMT BNFT_AMT
, BNFT_NNMNTRY_UOM BNFT_NNMNTRY_UOM
, BNFT_ORDR_NUM BNFT_ORDR_NUM
, BNFT_TYP_CD BNFT_TYP_CD
, COMP_LVL_CD COMP_LVL_CD
, ENRT_MTHD_CD ENRT_MTHD_CD
, ENRT_OVRID_RSN_CD ENRT_OVRID_RSN_CD
, ENRT_OVRID_THRU_DT ENRT_OVRID_THRU_DT
, ENRT_OVRIDN_FLAG ENRT_OVRIDN_FLAG
, ERLST_DEENRT_DT ERLST_DEENRT_DT
, NO_LNGR_ELIG_FLAG NO_LNGR_ELIG_FLAG
, ORGNL_ENRT_DT ORGNL_ENRT_DT
, PRTT_ENRT_RSLT_STAT_CD PRTT_ENRT_RSLT_STAT_CD
, PRTT_IS_CVRD_FLAG PRTT_IS_CVRD_FLAG
, SSPNDD_FLAG SSPNDD_FLAG
, UOM UOM
, ADDL_INSTRN_TXT ADDL_INSTRN_TXT
, AMT_DSGD_VAL AMT_DSGD_VAL
, AMT_DSGD_UOM AMT_DSGD_UOM
, DSGN_STRT_DT DSGN_STRT_DT
, DSGN_THRU_DT DSGN_THRU_DT
, PCT_DSGD_NUM PCT_DSGD_NUM
, PRMRY_CNTNGNT_CD PRMRY_CNTNGNT_CD
, CVG_PNDG_FLAG CVG_PNDG_FLAG
, CVRD_FLAG CVRD_FLAG
, ELIG_FLAG ELIG_FLAG
, OVRDN_FLAG OVRDN_FLAG
, CVG_STRT_DT CVG_STRT_DT
, CVG_THRU_DT CVG_THRU_DT
, ELIG_STRT_DT ELIG_STRT_DT
, ELIG_THRU_DT ELIG_THRU_DT
, OVRDN_THRU_DT OVRDN_THRU_DT
, RT_STRT_DT RT_STRT_DT
, RT_END_DT RT_END_DT
, DSPLY_ON_ENRT_FLAG DSPLY_ON_ENRT_FLAG
, RT_OVRIDN_FLAG RT_OVRIDN_FLAG
, ACTY_REF_PERD_CD ACTY_REF_PERD_CD
, ACTY_TYP_CD ACTY_TYP_CD
, ANN_RT_VAL ANN_RT_VAL
, BNFT_RT_TYP_CD BNFT_RT_TYP_CD
, CMCD_REF_PERD_CD CMCD_REF_PERD_CD
, CMCD_RT_VAL CMCD_RT_VAL
, ELCNS_MADE_DT ELCNS_MADE_DT
, MLT_CD MLT_CD
, PRTT_RT_VAL_STAT_CD PRTT_RT_VAL_STAT_CD
, RT_OVRIDN_THRU_DT RT_OVRIDN_THRU_DT
, RT_VAL RT_VAL
, TX_TYP_CD TX_TYP_CD
, INELG_RSN_CD INELG_RSN_CD
, RT_COMP_REF_AMT RT_COMP_REF_AMT
, RT_CMBN_AGE_N_LOS_VAL RT_CMBN_AGE_N_LOS_VAL
, RT_COMP_REF_UOM RT_COMP_REF_UOM
, RT_AGE_VAL RT_AGE_VAL
, RT_LOS_VAL RT_LOS_VAL
, RT_HRS_WKD_VAL RT_HRS_WKD_VAL
, RT_HRS_WKD_BNDRY_PERD_CD RT_HRS_WKD_BNDRY_PERD_CD
, RT_AGE_UOM RT_AGE_UOM
, RT_LOS_UOM RT_LOS_UOM
, RT_PCT_FL_TM_VAL RT_PCT_FL_TM_VAL
, RT_FRZ_LOS_FLAG RT_FRZ_LOS_FLAG
, RT_FRZ_AGE_FLAG RT_FRZ_AGE_FLAG
, RT_FRZ_CMP_LVL_FLAG RT_FRZ_CMP_LVL_FLAG
, RT_FRZ_PCT_FL_TM_FLAG RT_FRZ_PCT_FL_TM_FLAG
, RT_FRZ_HRS_WKD_FLAG RT_FRZ_HRS_WKD_FLAG
, RT_FRZ_COMB_AGE_AND_LOS_FLAG RT_FRZ_COMB_AGE_AND_LOS_FLAG
, AGE_UOM AGE_UOM
, AGE_VAL AGE_VAL
, CMBN_AGE_N_LOS_VAL CMBN_AGE_N_LOS_VAL
, COMP_REF_AMT COMP_REF_AMT
, COMP_REF_UOM COMP_REF_UOM
, DPNT_OTHER_PL_CVRD_RL_FLAG DPNT_OTHER_PL_CVRD_RL_FLAG
, DSTR_RSTCN_FLAG DSTR_RSTCN_FLAG
, FRZ_AGE_FLAG FRZ_AGE_FLAG
, FRZ_CMP_LVL_FLAG FRZ_CMP_LVL_FLAG
, FRZ_COMB_AGE_AND_LOS_FLAG FRZ_COMB_AGE_AND_LOS_FLAG
, FRZ_HRS_WKD_FLAG FRZ_HRS_WKD_FLAG
, FRZ_LOS_FLAG FRZ_LOS_FLAG
, FRZ_PCT_FL_TM_FLAG FRZ_PCT_FL_TM_FLAG
, HRS_WKD_BNDRY_PERD_CD HRS_WKD_BNDRY_PERD_CD
, HRS_WKD_VAL HRS_WKD_VAL
, LOS_UOM LOS_UOM
, LOS_VAL LOS_VAL
, NO_MX_PRTN_OVRID_THRU_FLAG NO_MX_PRTN_OVRID_THRU_FLAG
, OVRID_SVC_DT OVRID_SVC_DT
, PCT_FL_TM_VAL PCT_FL_TM_VAL
, PL_HGHLY_COMPD_FLAG PL_HGHLY_COMPD_FLAG
, PL_KEY_EE_FLAG PL_KEY_EE_FLAG
, PL_WVD_FLAG PL_WVD_FLAG
, PRTN_END_DT PRTN_END_DT
, PRTN_OVRIDN_FLAG PRTN_OVRIDN_FLAG
, PRTN_OVRIDN_RSN_CD PRTN_OVRIDN_RSN_CD
, PRTN_OVRIDN_THRU_DT PRTN_OVRIDN_THRU_DT
, PRTN_STRT_DT PRTN_STRT_DT
, WAIT_PERD_CMPLTN_DT WAIT_PERD_CMPLTN_DT
, WV_CTFN_TYP_CD WV_CTFN_TYP_CD
, WV_PRTN_RSN_CD WV_PRTN_RSN_CD
, PERSON_ID PERSON_ID
, PL_ID PL_ID
, LER_ID LER_ID
, PTIP_ID PTIP_ID
, PLIP_ID PLIP_ID
, OTHR_PL_ENRLD_ID OTHR_PL_ENRLD_ID
, PGM_ID PGM_ID
, ELIG_PER_ID ELIG_PER_ID
, OPT_ID OPT_ID
, ORGANIZATION_ID ORGANIZATION_ID
, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID
, PERSON_TTEE_ID PERSON_TTEE_ID
, ELIG_PER_ELCTBL_CHC_ID ELIG_PER_ELCTBL_CHC_ID
, PERSON_DPNT_ID PERSON_DPNT_ID
, ELEMENT_ENTRY_VALUE_ID ELEMENT_ENTRY_VALUE_ID
, PER_IN_LER_ENDED_ID PER_IN_LER_ENDED_ID
, CVG_AMT_CALC_MTHD_ID CVG_AMT_CALC_MTHD_ID
, TTEE_PERSON_ID TTEE_PERSON_ID
, ENRT_RT_ID ENRT_RT_ID
, ACTY_BASE_RT_ID ACTY_BASE_RT_ID
, OIPL_ID OIPL_ID
, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID
, PL_TYP_ID PL_TYP_ID
, ACTL_PREM_ID ACTL_PREM_ID
, PRTT_ENRT_RSLT_SSPNDD_ID PRTT_ENRT_RSLT_SSPNDD_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, ENRT_BNFT_ID ENRT_BNFT_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, DPNT_PERSON_ID DPNT_PERSON_ID
, ONCE_R_CNTUG_CD ONCE_R_CNTUG_CD
, DPNT_OTHR_PL_CVRD_RL_FLAG DPNT_OTHR_PL_CVRD_RL_FLAG
, MUST_ENRL_ANTHR_PL_ID MUST_ENRL_ANTHR_PL_ID
, PL_ORDR_NUM PL_ORDR_NUM
, PLIP_ORDR_NUM PLIP_ORDR_NUM
, PTIP_ORDR_NUM PTIP_ORDR_NUM
, OIPL_ORDR_NUM OIPL_ORDR_NUM
, BNF_PERSON_ID BNF_PERSON_ID
, RPLCS_SSPNDD_RSLT_ID RPLCS_SSPNDD_RSLT_ID
, VAL VAL
, STD_PREM_VAL STD_PREM_VAL
, STD_PREM_UOM STD_PREM_UOM
, LCR_ATTRIBUTE_CATEGORY LCR_ATTRIBUTE_CATEGORY
, LCR_ATTRIBUTE1 LCR_ATTRIBUTE1
, LCR_ATTRIBUTE2 LCR_ATTRIBUTE2
, LCR_ATTRIBUTE3 LCR_ATTRIBUTE3
, LCR_ATTRIBUTE4 LCR_ATTRIBUTE4
, LCR_ATTRIBUTE5 LCR_ATTRIBUTE5
, LCR_ATTRIBUTE6 LCR_ATTRIBUTE6
, LCR_ATTRIBUTE7 LCR_ATTRIBUTE7
, LCR_ATTRIBUTE8 LCR_ATTRIBUTE8
, LCR_ATTRIBUTE9 LCR_ATTRIBUTE9
, LCR_ATTRIBUTE10 LCR_ATTRIBUTE10
, LCR_ATTRIBUTE11 LCR_ATTRIBUTE11
, LCR_ATTRIBUTE12 LCR_ATTRIBUTE12
, LCR_ATTRIBUTE13 LCR_ATTRIBUTE13
, LCR_ATTRIBUTE14 LCR_ATTRIBUTE14
, LCR_ATTRIBUTE15 LCR_ATTRIBUTE15
, LCR_ATTRIBUTE16 LCR_ATTRIBUTE16
, LCR_ATTRIBUTE17 LCR_ATTRIBUTE17
, LCR_ATTRIBUTE18 LCR_ATTRIBUTE18
, LCR_ATTRIBUTE19 LCR_ATTRIBUTE19
, LCR_ATTRIBUTE20 LCR_ATTRIBUTE20
, LCR_ATTRIBUTE21 LCR_ATTRIBUTE21
, LCR_ATTRIBUTE22 LCR_ATTRIBUTE22
, LCR_ATTRIBUTE23 LCR_ATTRIBUTE23
, LCR_ATTRIBUTE24 LCR_ATTRIBUTE24
, LCR_ATTRIBUTE25 LCR_ATTRIBUTE25
, LCR_ATTRIBUTE26 LCR_ATTRIBUTE26
, LCR_ATTRIBUTE27 LCR_ATTRIBUTE27
, LCR_ATTRIBUTE28 LCR_ATTRIBUTE28
, LCR_ATTRIBUTE29 LCR_ATTRIBUTE29
, LCR_ATTRIBUTE30 LCR_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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "BEN"."BEN_LE_CLSN_N_RSTR"