VIEW: BEN.BEN_PL_BNF_F#

Source

View Text - Preformatted

select PL_BNF_ID PL_BNF_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PRMRY_CNTNGNT_CD PRMRY_CNTNGNT_CD, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID, PER_IN_LER_ID PER_IN_LER_ID, PBN_ATTRIBUTE_CATEGORY PBN_ATTRIBUTE_CATEGORY, PBN_ATTRIBUTE1 PBN_ATTRIBUTE1, PBN_ATTRIBUTE2 PBN_ATTRIBUTE2, PBN_ATTRIBUTE3 PBN_ATTRIBUTE3, PBN_ATTRIBUTE4 PBN_ATTRIBUTE4, PBN_ATTRIBUTE5 PBN_ATTRIBUTE5, PBN_ATTRIBUTE6 PBN_ATTRIBUTE6, PBN_ATTRIBUTE7 PBN_ATTRIBUTE7, PBN_ATTRIBUTE8 PBN_ATTRIBUTE8, PBN_ATTRIBUTE9 PBN_ATTRIBUTE9, PBN_ATTRIBUTE10 PBN_ATTRIBUTE10, PBN_ATTRIBUTE11 PBN_ATTRIBUTE11, PBN_ATTRIBUTE12 PBN_ATTRIBUTE12, PBN_ATTRIBUTE13 PBN_ATTRIBUTE13, PBN_ATTRIBUTE14 PBN_ATTRIBUTE14, PBN_ATTRIBUTE15 PBN_ATTRIBUTE15, PBN_ATTRIBUTE16 PBN_ATTRIBUTE16, PBN_ATTRIBUTE17 PBN_ATTRIBUTE17, PBN_ATTRIBUTE18 PBN_ATTRIBUTE18, PBN_ATTRIBUTE19 PBN_ATTRIBUTE19, PBN_ATTRIBUTE20 PBN_ATTRIBUTE20, PBN_ATTRIBUTE21 PBN_ATTRIBUTE21, PBN_ATTRIBUTE22 PBN_ATTRIBUTE22, PBN_ATTRIBUTE23 PBN_ATTRIBUTE23, PBN_ATTRIBUTE24 PBN_ATTRIBUTE24, PBN_ATTRIBUTE25 PBN_ATTRIBUTE25, PBN_ATTRIBUTE26 PBN_ATTRIBUTE26, PBN_ATTRIBUTE27 PBN_ATTRIBUTE27, PBN_ATTRIBUTE28 PBN_ATTRIBUTE28, PBN_ATTRIBUTE29 PBN_ATTRIBUTE29, PBN_ATTRIBUTE30 PBN_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, ORGANIZATION_ID ORGANIZATION_ID, BNF_PERSON_ID BNF_PERSON_ID, PCT_DSGD_NUM PCT_DSGD_NUM, TTEE_PERSON_ID TTEE_PERSON_ID, AMT_DSGD_VAL AMT_DSGD_VAL, AMT_DSGD_UOM AMT_DSGD_UOM, ADDL_INSTRN_TXT ADDL_INSTRN_TXT, DSGN_THRU_DT DSGN_THRU_DT, DSGN_STRT_DT DSGN_STRT_DT from "BEN"."BEN_PL_BNF_F"

View Text - HTML Formatted

SELECT PL_BNF_ID PL_BNF_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PRMRY_CNTNGNT_CD PRMRY_CNTNGNT_CD
, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID
, PER_IN_LER_ID PER_IN_LER_ID
, PBN_ATTRIBUTE_CATEGORY PBN_ATTRIBUTE_CATEGORY
, PBN_ATTRIBUTE1 PBN_ATTRIBUTE1
, PBN_ATTRIBUTE2 PBN_ATTRIBUTE2
, PBN_ATTRIBUTE3 PBN_ATTRIBUTE3
, PBN_ATTRIBUTE4 PBN_ATTRIBUTE4
, PBN_ATTRIBUTE5 PBN_ATTRIBUTE5
, PBN_ATTRIBUTE6 PBN_ATTRIBUTE6
, PBN_ATTRIBUTE7 PBN_ATTRIBUTE7
, PBN_ATTRIBUTE8 PBN_ATTRIBUTE8
, PBN_ATTRIBUTE9 PBN_ATTRIBUTE9
, PBN_ATTRIBUTE10 PBN_ATTRIBUTE10
, PBN_ATTRIBUTE11 PBN_ATTRIBUTE11
, PBN_ATTRIBUTE12 PBN_ATTRIBUTE12
, PBN_ATTRIBUTE13 PBN_ATTRIBUTE13
, PBN_ATTRIBUTE14 PBN_ATTRIBUTE14
, PBN_ATTRIBUTE15 PBN_ATTRIBUTE15
, PBN_ATTRIBUTE16 PBN_ATTRIBUTE16
, PBN_ATTRIBUTE17 PBN_ATTRIBUTE17
, PBN_ATTRIBUTE18 PBN_ATTRIBUTE18
, PBN_ATTRIBUTE19 PBN_ATTRIBUTE19
, PBN_ATTRIBUTE20 PBN_ATTRIBUTE20
, PBN_ATTRIBUTE21 PBN_ATTRIBUTE21
, PBN_ATTRIBUTE22 PBN_ATTRIBUTE22
, PBN_ATTRIBUTE23 PBN_ATTRIBUTE23
, PBN_ATTRIBUTE24 PBN_ATTRIBUTE24
, PBN_ATTRIBUTE25 PBN_ATTRIBUTE25
, PBN_ATTRIBUTE26 PBN_ATTRIBUTE26
, PBN_ATTRIBUTE27 PBN_ATTRIBUTE27
, PBN_ATTRIBUTE28 PBN_ATTRIBUTE28
, PBN_ATTRIBUTE29 PBN_ATTRIBUTE29
, PBN_ATTRIBUTE30 PBN_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
, ORGANIZATION_ID ORGANIZATION_ID
, BNF_PERSON_ID BNF_PERSON_ID
, PCT_DSGD_NUM PCT_DSGD_NUM
, TTEE_PERSON_ID TTEE_PERSON_ID
, AMT_DSGD_VAL AMT_DSGD_VAL
, AMT_DSGD_UOM AMT_DSGD_UOM
, ADDL_INSTRN_TXT ADDL_INSTRN_TXT
, DSGN_THRU_DT DSGN_THRU_DT
, DSGN_STRT_DT DSGN_STRT_DT
FROM "BEN"."BEN_PL_BNF_F"