eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: BEN.BEN_PGM_DPNT_CVG_CTFN_F#

Source

View Text - Preformatted


select PGM_DPNT_CVG_CTFN_ID PGM_DPNT_CVG_CTFN_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PGM_ID PGM_ID, LACK_CTFN_SSPND_ENRT_FLAG LACK_CTFN_SSPND_ENRT_FLAG, PFD_FLAG PFD_FLAG, DPNT_CVG_CTFN_TYP_CD DPNT_CVG_CTFN_TYP_CD, RQD_FLAG RQD_FLAG, RLSHP_TYP_CD RLSHP_TYP_CD, PGC_ATTRIBUTE_CATEGORY PGC_ATTRIBUTE_CATEGORY, PGC_ATTRIBUTE1 PGC_ATTRIBUTE1, PGC_ATTRIBUTE2 PGC_ATTRIBUTE2, PGC_ATTRIBUTE3 PGC_ATTRIBUTE3, PGC_ATTRIBUTE4 PGC_ATTRIBUTE4, PGC_ATTRIBUTE5 PGC_ATTRIBUTE5, PGC_ATTRIBUTE6 PGC_ATTRIBUTE6, PGC_ATTRIBUTE7 PGC_ATTRIBUTE7, PGC_ATTRIBUTE8 PGC_ATTRIBUTE8, PGC_ATTRIBUTE9 PGC_ATTRIBUTE9, PGC_ATTRIBUTE10 PGC_ATTRIBUTE10, PGC_ATTRIBUTE11 PGC_ATTRIBUTE11, PGC_ATTRIBUTE12 PGC_ATTRIBUTE12, PGC_ATTRIBUTE13 PGC_ATTRIBUTE13, PGC_ATTRIBUTE14 PGC_ATTRIBUTE14, PGC_ATTRIBUTE15 PGC_ATTRIBUTE15, PGC_ATTRIBUTE16 PGC_ATTRIBUTE16, PGC_ATTRIBUTE17 PGC_ATTRIBUTE17, PGC_ATTRIBUTE18 PGC_ATTRIBUTE18, PGC_ATTRIBUTE19 PGC_ATTRIBUTE19, PGC_ATTRIBUTE20 PGC_ATTRIBUTE20, PGC_ATTRIBUTE21 PGC_ATTRIBUTE21, PGC_ATTRIBUTE22 PGC_ATTRIBUTE22, PGC_ATTRIBUTE23 PGC_ATTRIBUTE23, PGC_ATTRIBUTE24 PGC_ATTRIBUTE24, PGC_ATTRIBUTE25 PGC_ATTRIBUTE25, PGC_ATTRIBUTE26 PGC_ATTRIBUTE26, PGC_ATTRIBUTE27 PGC_ATTRIBUTE27, PGC_ATTRIBUTE28 PGC_ATTRIBUTE28, PGC_ATTRIBUTE29 PGC_ATTRIBUTE29, PGC_ATTRIBUTE30 PGC_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, CTFN_RQD_WHEN_RL CTFN_RQD_WHEN_RL from "BEN"."BEN_PGM_DPNT_CVG_CTFN_F"

View Text - HTML Formatted

SELECT PGM_DPNT_CVG_CTFN_ID PGM_DPNT_CVG_CTFN_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PGM_ID PGM_ID
, LACK_CTFN_SSPND_ENRT_FLAG LACK_CTFN_SSPND_ENRT_FLAG
, PFD_FLAG PFD_FLAG
, DPNT_CVG_CTFN_TYP_CD DPNT_CVG_CTFN_TYP_CD
, RQD_FLAG RQD_FLAG
, RLSHP_TYP_CD RLSHP_TYP_CD
, PGC_ATTRIBUTE_CATEGORY PGC_ATTRIBUTE_CATEGORY
, PGC_ATTRIBUTE1 PGC_ATTRIBUTE1
, PGC_ATTRIBUTE2 PGC_ATTRIBUTE2
, PGC_ATTRIBUTE3 PGC_ATTRIBUTE3
, PGC_ATTRIBUTE4 PGC_ATTRIBUTE4
, PGC_ATTRIBUTE5 PGC_ATTRIBUTE5
, PGC_ATTRIBUTE6 PGC_ATTRIBUTE6
, PGC_ATTRIBUTE7 PGC_ATTRIBUTE7
, PGC_ATTRIBUTE8 PGC_ATTRIBUTE8
, PGC_ATTRIBUTE9 PGC_ATTRIBUTE9
, PGC_ATTRIBUTE10 PGC_ATTRIBUTE10
, PGC_ATTRIBUTE11 PGC_ATTRIBUTE11
, PGC_ATTRIBUTE12 PGC_ATTRIBUTE12
, PGC_ATTRIBUTE13 PGC_ATTRIBUTE13
, PGC_ATTRIBUTE14 PGC_ATTRIBUTE14
, PGC_ATTRIBUTE15 PGC_ATTRIBUTE15
, PGC_ATTRIBUTE16 PGC_ATTRIBUTE16
, PGC_ATTRIBUTE17 PGC_ATTRIBUTE17
, PGC_ATTRIBUTE18 PGC_ATTRIBUTE18
, PGC_ATTRIBUTE19 PGC_ATTRIBUTE19
, PGC_ATTRIBUTE20 PGC_ATTRIBUTE20
, PGC_ATTRIBUTE21 PGC_ATTRIBUTE21
, PGC_ATTRIBUTE22 PGC_ATTRIBUTE22
, PGC_ATTRIBUTE23 PGC_ATTRIBUTE23
, PGC_ATTRIBUTE24 PGC_ATTRIBUTE24
, PGC_ATTRIBUTE25 PGC_ATTRIBUTE25
, PGC_ATTRIBUTE26 PGC_ATTRIBUTE26
, PGC_ATTRIBUTE27 PGC_ATTRIBUTE27
, PGC_ATTRIBUTE28 PGC_ATTRIBUTE28
, PGC_ATTRIBUTE29 PGC_ATTRIBUTE29
, PGC_ATTRIBUTE30 PGC_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
, CTFN_RQD_WHEN_RL CTFN_RQD_WHEN_RL
FROM "BEN"."BEN_PGM_DPNT_CVG_CTFN_F"