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: HR.PER_BF_PROCESSED_ASSIGNMENTS#

Source

View Text - Preformatted


select PROCESSED_ASSIGNMENT_ID PROCESSED_ASSIGNMENT_ID, PAYROLL_RUN_ID PAYROLL_RUN_ID, ASSIGNMENT_ID ASSIGNMENT_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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, BPA_ATTRIBUTE_CATEGORY BPA_ATTRIBUTE_CATEGORY, BPA_ATTRIBUTE1 BPA_ATTRIBUTE1, BPA_ATTRIBUTE2 BPA_ATTRIBUTE2, BPA_ATTRIBUTE3 BPA_ATTRIBUTE3, BPA_ATTRIBUTE4 BPA_ATTRIBUTE4, BPA_ATTRIBUTE5 BPA_ATTRIBUTE5, BPA_ATTRIBUTE6 BPA_ATTRIBUTE6, BPA_ATTRIBUTE7 BPA_ATTRIBUTE7, BPA_ATTRIBUTE8 BPA_ATTRIBUTE8, BPA_ATTRIBUTE9 BPA_ATTRIBUTE9, BPA_ATTRIBUTE10 BPA_ATTRIBUTE10, BPA_ATTRIBUTE11 BPA_ATTRIBUTE11, BPA_ATTRIBUTE12 BPA_ATTRIBUTE12, BPA_ATTRIBUTE13 BPA_ATTRIBUTE13, BPA_ATTRIBUTE14 BPA_ATTRIBUTE14, BPA_ATTRIBUTE15 BPA_ATTRIBUTE15, BPA_ATTRIBUTE16 BPA_ATTRIBUTE16, BPA_ATTRIBUTE17 BPA_ATTRIBUTE17, BPA_ATTRIBUTE18 BPA_ATTRIBUTE18, BPA_ATTRIBUTE19 BPA_ATTRIBUTE19, BPA_ATTRIBUTE20 BPA_ATTRIBUTE20, BPA_ATTRIBUTE21 BPA_ATTRIBUTE21, BPA_ATTRIBUTE22 BPA_ATTRIBUTE22, BPA_ATTRIBUTE23 BPA_ATTRIBUTE23, BPA_ATTRIBUTE24 BPA_ATTRIBUTE24, BPA_ATTRIBUTE25 BPA_ATTRIBUTE25, BPA_ATTRIBUTE26 BPA_ATTRIBUTE26, BPA_ATTRIBUTE27 BPA_ATTRIBUTE27, BPA_ATTRIBUTE28 BPA_ATTRIBUTE28, BPA_ATTRIBUTE29 BPA_ATTRIBUTE29, BPA_ATTRIBUTE30 BPA_ATTRIBUTE30 from "HR"."PER_BF_PROCESSED_ASSIGNMENTS"

View Text - HTML Formatted

SELECT PROCESSED_ASSIGNMENT_ID PROCESSED_ASSIGNMENT_ID
, PAYROLL_RUN_ID PAYROLL_RUN_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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
, BPA_ATTRIBUTE_CATEGORY BPA_ATTRIBUTE_CATEGORY
, BPA_ATTRIBUTE1 BPA_ATTRIBUTE1
, BPA_ATTRIBUTE2 BPA_ATTRIBUTE2
, BPA_ATTRIBUTE3 BPA_ATTRIBUTE3
, BPA_ATTRIBUTE4 BPA_ATTRIBUTE4
, BPA_ATTRIBUTE5 BPA_ATTRIBUTE5
, BPA_ATTRIBUTE6 BPA_ATTRIBUTE6
, BPA_ATTRIBUTE7 BPA_ATTRIBUTE7
, BPA_ATTRIBUTE8 BPA_ATTRIBUTE8
, BPA_ATTRIBUTE9 BPA_ATTRIBUTE9
, BPA_ATTRIBUTE10 BPA_ATTRIBUTE10
, BPA_ATTRIBUTE11 BPA_ATTRIBUTE11
, BPA_ATTRIBUTE12 BPA_ATTRIBUTE12
, BPA_ATTRIBUTE13 BPA_ATTRIBUTE13
, BPA_ATTRIBUTE14 BPA_ATTRIBUTE14
, BPA_ATTRIBUTE15 BPA_ATTRIBUTE15
, BPA_ATTRIBUTE16 BPA_ATTRIBUTE16
, BPA_ATTRIBUTE17 BPA_ATTRIBUTE17
, BPA_ATTRIBUTE18 BPA_ATTRIBUTE18
, BPA_ATTRIBUTE19 BPA_ATTRIBUTE19
, BPA_ATTRIBUTE20 BPA_ATTRIBUTE20
, BPA_ATTRIBUTE21 BPA_ATTRIBUTE21
, BPA_ATTRIBUTE22 BPA_ATTRIBUTE22
, BPA_ATTRIBUTE23 BPA_ATTRIBUTE23
, BPA_ATTRIBUTE24 BPA_ATTRIBUTE24
, BPA_ATTRIBUTE25 BPA_ATTRIBUTE25
, BPA_ATTRIBUTE26 BPA_ATTRIBUTE26
, BPA_ATTRIBUTE27 BPA_ATTRIBUTE27
, BPA_ATTRIBUTE28 BPA_ATTRIBUTE28
, BPA_ATTRIBUTE29 BPA_ATTRIBUTE29
, BPA_ATTRIBUTE30 BPA_ATTRIBUTE30
FROM "HR"."PER_BF_PROCESSED_ASSIGNMENTS"