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

Source

View Text - Preformatted


select PYRL_RT_ID PYRL_RT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ORDR_NUM ORDR_NUM, EXCLD_FLAG EXCLD_FLAG, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID, PAYROLL_ID PAYROLL_ID, PR_ATTRIBUTE_CATEGORY PR_ATTRIBUTE_CATEGORY, PR_ATTRIBUTE1 PR_ATTRIBUTE1, PR_ATTRIBUTE2 PR_ATTRIBUTE2, PR_ATTRIBUTE3 PR_ATTRIBUTE3, PR_ATTRIBUTE4 PR_ATTRIBUTE4, PR_ATTRIBUTE5 PR_ATTRIBUTE5, PR_ATTRIBUTE6 PR_ATTRIBUTE6, PR_ATTRIBUTE7 PR_ATTRIBUTE7, PR_ATTRIBUTE8 PR_ATTRIBUTE8, PR_ATTRIBUTE9 PR_ATTRIBUTE9, PR_ATTRIBUTE10 PR_ATTRIBUTE10, PR_ATTRIBUTE11 PR_ATTRIBUTE11, PR_ATTRIBUTE12 PR_ATTRIBUTE12, PR_ATTRIBUTE13 PR_ATTRIBUTE13, PR_ATTRIBUTE14 PR_ATTRIBUTE14, PR_ATTRIBUTE15 PR_ATTRIBUTE15, PR_ATTRIBUTE16 PR_ATTRIBUTE16, PR_ATTRIBUTE17 PR_ATTRIBUTE17, PR_ATTRIBUTE18 PR_ATTRIBUTE18, PR_ATTRIBUTE19 PR_ATTRIBUTE19, PR_ATTRIBUTE20 PR_ATTRIBUTE20, PR_ATTRIBUTE21 PR_ATTRIBUTE21, PR_ATTRIBUTE22 PR_ATTRIBUTE22, PR_ATTRIBUTE23 PR_ATTRIBUTE23, PR_ATTRIBUTE24 PR_ATTRIBUTE24, PR_ATTRIBUTE25 PR_ATTRIBUTE25, PR_ATTRIBUTE26 PR_ATTRIBUTE26, PR_ATTRIBUTE27 PR_ATTRIBUTE27, PR_ATTRIBUTE28 PR_ATTRIBUTE28, PR_ATTRIBUTE29 PR_ATTRIBUTE29, PR_ATTRIBUTE30 PR_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_PYRL_RT_F"

View Text - HTML Formatted

SELECT PYRL_RT_ID PYRL_RT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ORDR_NUM ORDR_NUM
, EXCLD_FLAG EXCLD_FLAG
, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID
, PAYROLL_ID PAYROLL_ID
, PR_ATTRIBUTE_CATEGORY PR_ATTRIBUTE_CATEGORY
, PR_ATTRIBUTE1 PR_ATTRIBUTE1
, PR_ATTRIBUTE2 PR_ATTRIBUTE2
, PR_ATTRIBUTE3 PR_ATTRIBUTE3
, PR_ATTRIBUTE4 PR_ATTRIBUTE4
, PR_ATTRIBUTE5 PR_ATTRIBUTE5
, PR_ATTRIBUTE6 PR_ATTRIBUTE6
, PR_ATTRIBUTE7 PR_ATTRIBUTE7
, PR_ATTRIBUTE8 PR_ATTRIBUTE8
, PR_ATTRIBUTE9 PR_ATTRIBUTE9
, PR_ATTRIBUTE10 PR_ATTRIBUTE10
, PR_ATTRIBUTE11 PR_ATTRIBUTE11
, PR_ATTRIBUTE12 PR_ATTRIBUTE12
, PR_ATTRIBUTE13 PR_ATTRIBUTE13
, PR_ATTRIBUTE14 PR_ATTRIBUTE14
, PR_ATTRIBUTE15 PR_ATTRIBUTE15
, PR_ATTRIBUTE16 PR_ATTRIBUTE16
, PR_ATTRIBUTE17 PR_ATTRIBUTE17
, PR_ATTRIBUTE18 PR_ATTRIBUTE18
, PR_ATTRIBUTE19 PR_ATTRIBUTE19
, PR_ATTRIBUTE20 PR_ATTRIBUTE20
, PR_ATTRIBUTE21 PR_ATTRIBUTE21
, PR_ATTRIBUTE22 PR_ATTRIBUTE22
, PR_ATTRIBUTE23 PR_ATTRIBUTE23
, PR_ATTRIBUTE24 PR_ATTRIBUTE24
, PR_ATTRIBUTE25 PR_ATTRIBUTE25
, PR_ATTRIBUTE26 PR_ATTRIBUTE26
, PR_ATTRIBUTE27 PR_ATTRIBUTE27
, PR_ATTRIBUTE28 PR_ATTRIBUTE28
, PR_ATTRIBUTE29 PR_ATTRIBUTE29
, PR_ATTRIBUTE30 PR_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_PYRL_RT_F"