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

Source

View Text - Preformatted


select PREVIOUS_JOB_USAGE_ID PREVIOUS_JOB_USAGE_ID, ASSIGNMENT_ID ASSIGNMENT_ID, PREVIOUS_JOB_ID PREVIOUS_JOB_ID, START_DATE START_DATE, END_DATE END_DATE, PERIOD_YEARS PERIOD_YEARS, PERIOD_DAYS PERIOD_DAYS, PJU_ATTRIBUTE_CATEGORY PJU_ATTRIBUTE_CATEGORY, PJU_ATTRIBUTE1 PJU_ATTRIBUTE1, PJU_ATTRIBUTE2 PJU_ATTRIBUTE2, PJU_ATTRIBUTE3 PJU_ATTRIBUTE3, PJU_ATTRIBUTE4 PJU_ATTRIBUTE4, PJU_ATTRIBUTE5 PJU_ATTRIBUTE5, PJU_ATTRIBUTE6 PJU_ATTRIBUTE6, PJU_ATTRIBUTE7 PJU_ATTRIBUTE7, PJU_ATTRIBUTE8 PJU_ATTRIBUTE8, PJU_ATTRIBUTE9 PJU_ATTRIBUTE9, PJU_ATTRIBUTE10 PJU_ATTRIBUTE10, PJU_ATTRIBUTE11 PJU_ATTRIBUTE11, PJU_ATTRIBUTE12 PJU_ATTRIBUTE12, PJU_ATTRIBUTE13 PJU_ATTRIBUTE13, PJU_ATTRIBUTE14 PJU_ATTRIBUTE14, PJU_ATTRIBUTE15 PJU_ATTRIBUTE15, PJU_ATTRIBUTE16 PJU_ATTRIBUTE16, PJU_ATTRIBUTE17 PJU_ATTRIBUTE17, PJU_ATTRIBUTE18 PJU_ATTRIBUTE18, PJU_ATTRIBUTE19 PJU_ATTRIBUTE19, PJU_ATTRIBUTE20 PJU_ATTRIBUTE20, PJU_INFORMATION_CATEGORY PJU_INFORMATION_CATEGORY, PJU_INFORMATION1 PJU_INFORMATION1, PJU_INFORMATION2 PJU_INFORMATION2, PJU_INFORMATION3 PJU_INFORMATION3, PJU_INFORMATION4 PJU_INFORMATION4, PJU_INFORMATION5 PJU_INFORMATION5, PJU_INFORMATION6 PJU_INFORMATION6, PJU_INFORMATION7 PJU_INFORMATION7, PJU_INFORMATION8 PJU_INFORMATION8, PJU_INFORMATION9 PJU_INFORMATION9, PJU_INFORMATION10 PJU_INFORMATION10, PJU_INFORMATION11 PJU_INFORMATION11, PJU_INFORMATION12 PJU_INFORMATION12, PJU_INFORMATION13 PJU_INFORMATION13, PJU_INFORMATION14 PJU_INFORMATION14, PJU_INFORMATION15 PJU_INFORMATION15, PJU_INFORMATION16 PJU_INFORMATION16, PJU_INFORMATION17 PJU_INFORMATION17, PJU_INFORMATION18 PJU_INFORMATION18, PJU_INFORMATION19 PJU_INFORMATION19, PJU_INFORMATION20 PJU_INFORMATION20, 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, PREVIOUS_EMPLOYER_ID PREVIOUS_EMPLOYER_ID, PERIOD_MONTHS PERIOD_MONTHS from "HR"."PER_PREVIOUS_JOB_USAGES"

View Text - HTML Formatted

SELECT PREVIOUS_JOB_USAGE_ID PREVIOUS_JOB_USAGE_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, PREVIOUS_JOB_ID PREVIOUS_JOB_ID
, START_DATE START_DATE
, END_DATE END_DATE
, PERIOD_YEARS PERIOD_YEARS
, PERIOD_DAYS PERIOD_DAYS
, PJU_ATTRIBUTE_CATEGORY PJU_ATTRIBUTE_CATEGORY
, PJU_ATTRIBUTE1 PJU_ATTRIBUTE1
, PJU_ATTRIBUTE2 PJU_ATTRIBUTE2
, PJU_ATTRIBUTE3 PJU_ATTRIBUTE3
, PJU_ATTRIBUTE4 PJU_ATTRIBUTE4
, PJU_ATTRIBUTE5 PJU_ATTRIBUTE5
, PJU_ATTRIBUTE6 PJU_ATTRIBUTE6
, PJU_ATTRIBUTE7 PJU_ATTRIBUTE7
, PJU_ATTRIBUTE8 PJU_ATTRIBUTE8
, PJU_ATTRIBUTE9 PJU_ATTRIBUTE9
, PJU_ATTRIBUTE10 PJU_ATTRIBUTE10
, PJU_ATTRIBUTE11 PJU_ATTRIBUTE11
, PJU_ATTRIBUTE12 PJU_ATTRIBUTE12
, PJU_ATTRIBUTE13 PJU_ATTRIBUTE13
, PJU_ATTRIBUTE14 PJU_ATTRIBUTE14
, PJU_ATTRIBUTE15 PJU_ATTRIBUTE15
, PJU_ATTRIBUTE16 PJU_ATTRIBUTE16
, PJU_ATTRIBUTE17 PJU_ATTRIBUTE17
, PJU_ATTRIBUTE18 PJU_ATTRIBUTE18
, PJU_ATTRIBUTE19 PJU_ATTRIBUTE19
, PJU_ATTRIBUTE20 PJU_ATTRIBUTE20
, PJU_INFORMATION_CATEGORY PJU_INFORMATION_CATEGORY
, PJU_INFORMATION1 PJU_INFORMATION1
, PJU_INFORMATION2 PJU_INFORMATION2
, PJU_INFORMATION3 PJU_INFORMATION3
, PJU_INFORMATION4 PJU_INFORMATION4
, PJU_INFORMATION5 PJU_INFORMATION5
, PJU_INFORMATION6 PJU_INFORMATION6
, PJU_INFORMATION7 PJU_INFORMATION7
, PJU_INFORMATION8 PJU_INFORMATION8
, PJU_INFORMATION9 PJU_INFORMATION9
, PJU_INFORMATION10 PJU_INFORMATION10
, PJU_INFORMATION11 PJU_INFORMATION11
, PJU_INFORMATION12 PJU_INFORMATION12
, PJU_INFORMATION13 PJU_INFORMATION13
, PJU_INFORMATION14 PJU_INFORMATION14
, PJU_INFORMATION15 PJU_INFORMATION15
, PJU_INFORMATION16 PJU_INFORMATION16
, PJU_INFORMATION17 PJU_INFORMATION17
, PJU_INFORMATION18 PJU_INFORMATION18
, PJU_INFORMATION19 PJU_INFORMATION19
, PJU_INFORMATION20 PJU_INFORMATION20
, 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
, PREVIOUS_EMPLOYER_ID PREVIOUS_EMPLOYER_ID
, PERIOD_MONTHS PERIOD_MONTHS
FROM "HR"."PER_PREVIOUS_JOB_USAGES"