VIEW: BEN.BEN_PRTT_ENRT_ACTN_F#

Source

View Text - Preformatted

select PRTT_ENRT_ACTN_ID PRTT_ENRT_ACTN_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, RQD_FLAG RQD_FLAG, ACTN_TYP_ID ACTN_TYP_ID, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID, PER_IN_LER_ID PER_IN_LER_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PEA_ATTRIBUTE_CATEGORY PEA_ATTRIBUTE_CATEGORY, PEA_ATTRIBUTE1 PEA_ATTRIBUTE1, PEA_ATTRIBUTE2 PEA_ATTRIBUTE2, PEA_ATTRIBUTE3 PEA_ATTRIBUTE3, PEA_ATTRIBUTE4 PEA_ATTRIBUTE4, PEA_ATTRIBUTE5 PEA_ATTRIBUTE5, PEA_ATTRIBUTE6 PEA_ATTRIBUTE6, PEA_ATTRIBUTE7 PEA_ATTRIBUTE7, PEA_ATTRIBUTE8 PEA_ATTRIBUTE8, PEA_ATTRIBUTE9 PEA_ATTRIBUTE9, PEA_ATTRIBUTE10 PEA_ATTRIBUTE10, PEA_ATTRIBUTE11 PEA_ATTRIBUTE11, PEA_ATTRIBUTE12 PEA_ATTRIBUTE12, PEA_ATTRIBUTE13 PEA_ATTRIBUTE13, PEA_ATTRIBUTE14 PEA_ATTRIBUTE14, PEA_ATTRIBUTE15 PEA_ATTRIBUTE15, PEA_ATTRIBUTE16 PEA_ATTRIBUTE16, PEA_ATTRIBUTE17 PEA_ATTRIBUTE17, PEA_ATTRIBUTE18 PEA_ATTRIBUTE18, PEA_ATTRIBUTE19 PEA_ATTRIBUTE19, PEA_ATTRIBUTE20 PEA_ATTRIBUTE20, PEA_ATTRIBUTE21 PEA_ATTRIBUTE21, PEA_ATTRIBUTE22 PEA_ATTRIBUTE22, PEA_ATTRIBUTE23 PEA_ATTRIBUTE23, PEA_ATTRIBUTE24 PEA_ATTRIBUTE24, PEA_ATTRIBUTE25 PEA_ATTRIBUTE25, PEA_ATTRIBUTE26 PEA_ATTRIBUTE26, PEA_ATTRIBUTE27 PEA_ATTRIBUTE27, PEA_ATTRIBUTE28 PEA_ATTRIBUTE28, PEA_ATTRIBUTE29 PEA_ATTRIBUTE29, PEA_ATTRIBUTE30 PEA_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, CMPLTD_DT CMPLTD_DT, DUE_DT DUE_DT, PL_BNF_ID PL_BNF_ID, ELIG_CVRD_DPNT_ID ELIG_CVRD_DPNT_ID from "BEN"."BEN_PRTT_ENRT_ACTN_F"

View Text - HTML Formatted

SELECT PRTT_ENRT_ACTN_ID PRTT_ENRT_ACTN_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, RQD_FLAG RQD_FLAG
, ACTN_TYP_ID ACTN_TYP_ID
, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID
, PER_IN_LER_ID PER_IN_LER_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEA_ATTRIBUTE_CATEGORY PEA_ATTRIBUTE_CATEGORY
, PEA_ATTRIBUTE1 PEA_ATTRIBUTE1
, PEA_ATTRIBUTE2 PEA_ATTRIBUTE2
, PEA_ATTRIBUTE3 PEA_ATTRIBUTE3
, PEA_ATTRIBUTE4 PEA_ATTRIBUTE4
, PEA_ATTRIBUTE5 PEA_ATTRIBUTE5
, PEA_ATTRIBUTE6 PEA_ATTRIBUTE6
, PEA_ATTRIBUTE7 PEA_ATTRIBUTE7
, PEA_ATTRIBUTE8 PEA_ATTRIBUTE8
, PEA_ATTRIBUTE9 PEA_ATTRIBUTE9
, PEA_ATTRIBUTE10 PEA_ATTRIBUTE10
, PEA_ATTRIBUTE11 PEA_ATTRIBUTE11
, PEA_ATTRIBUTE12 PEA_ATTRIBUTE12
, PEA_ATTRIBUTE13 PEA_ATTRIBUTE13
, PEA_ATTRIBUTE14 PEA_ATTRIBUTE14
, PEA_ATTRIBUTE15 PEA_ATTRIBUTE15
, PEA_ATTRIBUTE16 PEA_ATTRIBUTE16
, PEA_ATTRIBUTE17 PEA_ATTRIBUTE17
, PEA_ATTRIBUTE18 PEA_ATTRIBUTE18
, PEA_ATTRIBUTE19 PEA_ATTRIBUTE19
, PEA_ATTRIBUTE20 PEA_ATTRIBUTE20
, PEA_ATTRIBUTE21 PEA_ATTRIBUTE21
, PEA_ATTRIBUTE22 PEA_ATTRIBUTE22
, PEA_ATTRIBUTE23 PEA_ATTRIBUTE23
, PEA_ATTRIBUTE24 PEA_ATTRIBUTE24
, PEA_ATTRIBUTE25 PEA_ATTRIBUTE25
, PEA_ATTRIBUTE26 PEA_ATTRIBUTE26
, PEA_ATTRIBUTE27 PEA_ATTRIBUTE27
, PEA_ATTRIBUTE28 PEA_ATTRIBUTE28
, PEA_ATTRIBUTE29 PEA_ATTRIBUTE29
, PEA_ATTRIBUTE30 PEA_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
, CMPLTD_DT CMPLTD_DT
, DUE_DT DUE_DT
, PL_BNF_ID PL_BNF_ID
, ELIG_CVRD_DPNT_ID ELIG_CVRD_DPNT_ID
FROM "BEN"."BEN_PRTT_ENRT_ACTN_F"