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_ACRS_PTIP_CVG_F#

Source

View Text - Preformatted


select ACRS_PTIP_CVG_ID ACRS_PTIP_CVG_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, NAME NAME, MX_CVG_ALWD_AMT MX_CVG_ALWD_AMT, MN_CVG_ALWD_AMT MN_CVG_ALWD_AMT, PGM_ID PGM_ID, APC_ATTRIBUTE_CATEGORY APC_ATTRIBUTE_CATEGORY, APC_ATTRIBUTE1 APC_ATTRIBUTE1, APC_ATTRIBUTE2 APC_ATTRIBUTE2, APC_ATTRIBUTE3 APC_ATTRIBUTE3, APC_ATTRIBUTE4 APC_ATTRIBUTE4, APC_ATTRIBUTE5 APC_ATTRIBUTE5, APC_ATTRIBUTE6 APC_ATTRIBUTE6, APC_ATTRIBUTE7 APC_ATTRIBUTE7, APC_ATTRIBUTE8 APC_ATTRIBUTE8, APC_ATTRIBUTE9 APC_ATTRIBUTE9, APC_ATTRIBUTE10 APC_ATTRIBUTE10, APC_ATTRIBUTE11 APC_ATTRIBUTE11, APC_ATTRIBUTE12 APC_ATTRIBUTE12, APC_ATTRIBUTE13 APC_ATTRIBUTE13, APC_ATTRIBUTE14 APC_ATTRIBUTE14, APC_ATTRIBUTE15 APC_ATTRIBUTE15, APC_ATTRIBUTE16 APC_ATTRIBUTE16, APC_ATTRIBUTE17 APC_ATTRIBUTE17, APC_ATTRIBUTE18 APC_ATTRIBUTE18, APC_ATTRIBUTE19 APC_ATTRIBUTE19, APC_ATTRIBUTE20 APC_ATTRIBUTE20, APC_ATTRIBUTE21 APC_ATTRIBUTE21, APC_ATTRIBUTE22 APC_ATTRIBUTE22, APC_ATTRIBUTE23 APC_ATTRIBUTE23, APC_ATTRIBUTE24 APC_ATTRIBUTE24, APC_ATTRIBUTE25 APC_ATTRIBUTE25, APC_ATTRIBUTE26 APC_ATTRIBUTE26, APC_ATTRIBUTE27 APC_ATTRIBUTE27, APC_ATTRIBUTE28 APC_ATTRIBUTE28, APC_ATTRIBUTE29 APC_ATTRIBUTE29, APC_ATTRIBUTE30 APC_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 from "BEN"."BEN_ACRS_PTIP_CVG_F"

View Text - HTML Formatted

SELECT ACRS_PTIP_CVG_ID ACRS_PTIP_CVG_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, NAME NAME
, MX_CVG_ALWD_AMT MX_CVG_ALWD_AMT
, MN_CVG_ALWD_AMT MN_CVG_ALWD_AMT
, PGM_ID PGM_ID
, APC_ATTRIBUTE_CATEGORY APC_ATTRIBUTE_CATEGORY
, APC_ATTRIBUTE1 APC_ATTRIBUTE1
, APC_ATTRIBUTE2 APC_ATTRIBUTE2
, APC_ATTRIBUTE3 APC_ATTRIBUTE3
, APC_ATTRIBUTE4 APC_ATTRIBUTE4
, APC_ATTRIBUTE5 APC_ATTRIBUTE5
, APC_ATTRIBUTE6 APC_ATTRIBUTE6
, APC_ATTRIBUTE7 APC_ATTRIBUTE7
, APC_ATTRIBUTE8 APC_ATTRIBUTE8
, APC_ATTRIBUTE9 APC_ATTRIBUTE9
, APC_ATTRIBUTE10 APC_ATTRIBUTE10
, APC_ATTRIBUTE11 APC_ATTRIBUTE11
, APC_ATTRIBUTE12 APC_ATTRIBUTE12
, APC_ATTRIBUTE13 APC_ATTRIBUTE13
, APC_ATTRIBUTE14 APC_ATTRIBUTE14
, APC_ATTRIBUTE15 APC_ATTRIBUTE15
, APC_ATTRIBUTE16 APC_ATTRIBUTE16
, APC_ATTRIBUTE17 APC_ATTRIBUTE17
, APC_ATTRIBUTE18 APC_ATTRIBUTE18
, APC_ATTRIBUTE19 APC_ATTRIBUTE19
, APC_ATTRIBUTE20 APC_ATTRIBUTE20
, APC_ATTRIBUTE21 APC_ATTRIBUTE21
, APC_ATTRIBUTE22 APC_ATTRIBUTE22
, APC_ATTRIBUTE23 APC_ATTRIBUTE23
, APC_ATTRIBUTE24 APC_ATTRIBUTE24
, APC_ATTRIBUTE25 APC_ATTRIBUTE25
, APC_ATTRIBUTE26 APC_ATTRIBUTE26
, APC_ATTRIBUTE27 APC_ATTRIBUTE27
, APC_ATTRIBUTE28 APC_ATTRIBUTE28
, APC_ATTRIBUTE29 APC_ATTRIBUTE29
, APC_ATTRIBUTE30 APC_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
FROM "BEN"."BEN_ACRS_PTIP_CVG_F"