VIEW: BEN.BEN_PRTT_ENRT_CTFN_PRVDD_F#

Source

View Text - Preformatted

select PRTT_ENRT_CTFN_PRVDD_ID PRTT_ENRT_CTFN_PRVDD_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ENRT_CTFN_RQD_FLAG ENRT_CTFN_RQD_FLAG, PRTT_ENRT_ACTN_ID PRTT_ENRT_ACTN_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID, PCS_ATTRIBUTE_CATEGORY PCS_ATTRIBUTE_CATEGORY, PCS_ATTRIBUTE1 PCS_ATTRIBUTE1, PCS_ATTRIBUTE2 PCS_ATTRIBUTE2, PCS_ATTRIBUTE3 PCS_ATTRIBUTE3, PCS_ATTRIBUTE4 PCS_ATTRIBUTE4, PCS_ATTRIBUTE5 PCS_ATTRIBUTE5, PCS_ATTRIBUTE6 PCS_ATTRIBUTE6, PCS_ATTRIBUTE7 PCS_ATTRIBUTE7, PCS_ATTRIBUTE8 PCS_ATTRIBUTE8, PCS_ATTRIBUTE9 PCS_ATTRIBUTE9, PCS_ATTRIBUTE10 PCS_ATTRIBUTE10, PCS_ATTRIBUTE11 PCS_ATTRIBUTE11, PCS_ATTRIBUTE12 PCS_ATTRIBUTE12, PCS_ATTRIBUTE13 PCS_ATTRIBUTE13, PCS_ATTRIBUTE14 PCS_ATTRIBUTE14, PCS_ATTRIBUTE15 PCS_ATTRIBUTE15, PCS_ATTRIBUTE16 PCS_ATTRIBUTE16, PCS_ATTRIBUTE17 PCS_ATTRIBUTE17, PCS_ATTRIBUTE18 PCS_ATTRIBUTE18, PCS_ATTRIBUTE19 PCS_ATTRIBUTE19, PCS_ATTRIBUTE20 PCS_ATTRIBUTE20, PCS_ATTRIBUTE21 PCS_ATTRIBUTE21, PCS_ATTRIBUTE22 PCS_ATTRIBUTE22, PCS_ATTRIBUTE23 PCS_ATTRIBUTE23, PCS_ATTRIBUTE24 PCS_ATTRIBUTE24, PCS_ATTRIBUTE25 PCS_ATTRIBUTE25, PCS_ATTRIBUTE26 PCS_ATTRIBUTE26, PCS_ATTRIBUTE27 PCS_ATTRIBUTE27, PCS_ATTRIBUTE28 PCS_ATTRIBUTE28, PCS_ATTRIBUTE29 PCS_ATTRIBUTE29, PCS_ATTRIBUTE30 PCS_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, ENRT_CTFN_TYP_CD ENRT_CTFN_TYP_CD, ENRT_CTFN_RECD_DT ENRT_CTFN_RECD_DT, ENRT_CTFN_DND_DT ENRT_CTFN_DND_DT, ENRT_R_BNFT_CTFN_CD ENRT_R_BNFT_CTFN_CD from "BEN"."BEN_PRTT_ENRT_CTFN_PRVDD_F"

View Text - HTML Formatted

SELECT PRTT_ENRT_CTFN_PRVDD_ID PRTT_ENRT_CTFN_PRVDD_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ENRT_CTFN_RQD_FLAG ENRT_CTFN_RQD_FLAG
, PRTT_ENRT_ACTN_ID PRTT_ENRT_ACTN_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID
, PCS_ATTRIBUTE_CATEGORY PCS_ATTRIBUTE_CATEGORY
, PCS_ATTRIBUTE1 PCS_ATTRIBUTE1
, PCS_ATTRIBUTE2 PCS_ATTRIBUTE2
, PCS_ATTRIBUTE3 PCS_ATTRIBUTE3
, PCS_ATTRIBUTE4 PCS_ATTRIBUTE4
, PCS_ATTRIBUTE5 PCS_ATTRIBUTE5
, PCS_ATTRIBUTE6 PCS_ATTRIBUTE6
, PCS_ATTRIBUTE7 PCS_ATTRIBUTE7
, PCS_ATTRIBUTE8 PCS_ATTRIBUTE8
, PCS_ATTRIBUTE9 PCS_ATTRIBUTE9
, PCS_ATTRIBUTE10 PCS_ATTRIBUTE10
, PCS_ATTRIBUTE11 PCS_ATTRIBUTE11
, PCS_ATTRIBUTE12 PCS_ATTRIBUTE12
, PCS_ATTRIBUTE13 PCS_ATTRIBUTE13
, PCS_ATTRIBUTE14 PCS_ATTRIBUTE14
, PCS_ATTRIBUTE15 PCS_ATTRIBUTE15
, PCS_ATTRIBUTE16 PCS_ATTRIBUTE16
, PCS_ATTRIBUTE17 PCS_ATTRIBUTE17
, PCS_ATTRIBUTE18 PCS_ATTRIBUTE18
, PCS_ATTRIBUTE19 PCS_ATTRIBUTE19
, PCS_ATTRIBUTE20 PCS_ATTRIBUTE20
, PCS_ATTRIBUTE21 PCS_ATTRIBUTE21
, PCS_ATTRIBUTE22 PCS_ATTRIBUTE22
, PCS_ATTRIBUTE23 PCS_ATTRIBUTE23
, PCS_ATTRIBUTE24 PCS_ATTRIBUTE24
, PCS_ATTRIBUTE25 PCS_ATTRIBUTE25
, PCS_ATTRIBUTE26 PCS_ATTRIBUTE26
, PCS_ATTRIBUTE27 PCS_ATTRIBUTE27
, PCS_ATTRIBUTE28 PCS_ATTRIBUTE28
, PCS_ATTRIBUTE29 PCS_ATTRIBUTE29
, PCS_ATTRIBUTE30 PCS_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
, ENRT_CTFN_TYP_CD ENRT_CTFN_TYP_CD
, ENRT_CTFN_RECD_DT ENRT_CTFN_RECD_DT
, ENRT_CTFN_DND_DT ENRT_CTFN_DND_DT
, ENRT_R_BNFT_CTFN_CD ENRT_R_BNFT_CTFN_CD
FROM "BEN"."BEN_PRTT_ENRT_CTFN_PRVDD_F"