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.

VIEW: BEN.BEN_POPL_YR_PERD#

Source

View Text - Preformatted


select POPL_YR_PERD_ID POPL_YR_PERD_ID, YR_PERD_ID YR_PERD_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PGM_ID PGM_ID, PL_ID PL_ID, ORDR_NUM ORDR_NUM, ACPT_CLM_RQSTS_THRU_DT ACPT_CLM_RQSTS_THRU_DT, PY_CLMS_THRU_DT PY_CLMS_THRU_DT, CPY_ATTRIBUTE_CATEGORY CPY_ATTRIBUTE_CATEGORY, CPY_ATTRIBUTE1 CPY_ATTRIBUTE1, CPY_ATTRIBUTE2 CPY_ATTRIBUTE2, CPY_ATTRIBUTE3 CPY_ATTRIBUTE3, CPY_ATTRIBUTE4 CPY_ATTRIBUTE4, CPY_ATTRIBUTE5 CPY_ATTRIBUTE5, CPY_ATTRIBUTE6 CPY_ATTRIBUTE6, CPY_ATTRIBUTE7 CPY_ATTRIBUTE7, CPY_ATTRIBUTE8 CPY_ATTRIBUTE8, CPY_ATTRIBUTE9 CPY_ATTRIBUTE9, CPY_ATTRIBUTE10 CPY_ATTRIBUTE10, CPY_ATTRIBUTE11 CPY_ATTRIBUTE11, CPY_ATTRIBUTE12 CPY_ATTRIBUTE12, CPY_ATTRIBUTE13 CPY_ATTRIBUTE13, CPY_ATTRIBUTE14 CPY_ATTRIBUTE14, CPY_ATTRIBUTE15 CPY_ATTRIBUTE15, CPY_ATTRIBUTE16 CPY_ATTRIBUTE16, CPY_ATTRIBUTE17 CPY_ATTRIBUTE17, CPY_ATTRIBUTE18 CPY_ATTRIBUTE18, CPY_ATTRIBUTE19 CPY_ATTRIBUTE19, CPY_ATTRIBUTE20 CPY_ATTRIBUTE20, CPY_ATTRIBUTE21 CPY_ATTRIBUTE21, CPY_ATTRIBUTE22 CPY_ATTRIBUTE22, CPY_ATTRIBUTE23 CPY_ATTRIBUTE23, CPY_ATTRIBUTE24 CPY_ATTRIBUTE24, CPY_ATTRIBUTE25 CPY_ATTRIBUTE25, CPY_ATTRIBUTE26 CPY_ATTRIBUTE26, CPY_ATTRIBUTE27 CPY_ATTRIBUTE27, CPY_ATTRIBUTE28 CPY_ATTRIBUTE28, CPY_ATTRIBUTE29 CPY_ATTRIBUTE29, CPY_ATTRIBUTE30 CPY_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_POPL_YR_PERD"

View Text - HTML Formatted

SELECT POPL_YR_PERD_ID POPL_YR_PERD_ID
, YR_PERD_ID YR_PERD_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PGM_ID PGM_ID
, PL_ID PL_ID
, ORDR_NUM ORDR_NUM
, ACPT_CLM_RQSTS_THRU_DT ACPT_CLM_RQSTS_THRU_DT
, PY_CLMS_THRU_DT PY_CLMS_THRU_DT
, CPY_ATTRIBUTE_CATEGORY CPY_ATTRIBUTE_CATEGORY
, CPY_ATTRIBUTE1 CPY_ATTRIBUTE1
, CPY_ATTRIBUTE2 CPY_ATTRIBUTE2
, CPY_ATTRIBUTE3 CPY_ATTRIBUTE3
, CPY_ATTRIBUTE4 CPY_ATTRIBUTE4
, CPY_ATTRIBUTE5 CPY_ATTRIBUTE5
, CPY_ATTRIBUTE6 CPY_ATTRIBUTE6
, CPY_ATTRIBUTE7 CPY_ATTRIBUTE7
, CPY_ATTRIBUTE8 CPY_ATTRIBUTE8
, CPY_ATTRIBUTE9 CPY_ATTRIBUTE9
, CPY_ATTRIBUTE10 CPY_ATTRIBUTE10
, CPY_ATTRIBUTE11 CPY_ATTRIBUTE11
, CPY_ATTRIBUTE12 CPY_ATTRIBUTE12
, CPY_ATTRIBUTE13 CPY_ATTRIBUTE13
, CPY_ATTRIBUTE14 CPY_ATTRIBUTE14
, CPY_ATTRIBUTE15 CPY_ATTRIBUTE15
, CPY_ATTRIBUTE16 CPY_ATTRIBUTE16
, CPY_ATTRIBUTE17 CPY_ATTRIBUTE17
, CPY_ATTRIBUTE18 CPY_ATTRIBUTE18
, CPY_ATTRIBUTE19 CPY_ATTRIBUTE19
, CPY_ATTRIBUTE20 CPY_ATTRIBUTE20
, CPY_ATTRIBUTE21 CPY_ATTRIBUTE21
, CPY_ATTRIBUTE22 CPY_ATTRIBUTE22
, CPY_ATTRIBUTE23 CPY_ATTRIBUTE23
, CPY_ATTRIBUTE24 CPY_ATTRIBUTE24
, CPY_ATTRIBUTE25 CPY_ATTRIBUTE25
, CPY_ATTRIBUTE26 CPY_ATTRIBUTE26
, CPY_ATTRIBUTE27 CPY_ATTRIBUTE27
, CPY_ATTRIBUTE28 CPY_ATTRIBUTE28
, CPY_ATTRIBUTE29 CPY_ATTRIBUTE29
, CPY_ATTRIBUTE30 CPY_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_POPL_YR_PERD"