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: PER_PREVIOUS_JOBS_V

Product:	PER - Human Resources
Description:	Based on per_previous_jobs
Implementation/DBA Data:	APPS.PER_PREVIOUS_JOBS_V

View Text

SELECT PJO.PREVIOUS_JOB_ID
, PJO.PREVIOUS_EMPLOYER_ID
, PJO.START_DATE
, PJO.END_DATE
, PJO.PERIOD_YEARS
, PJO.PERIOD_DAYS
, PJO.JOB_NAME
, PJO.EMPLOYMENT_CATEGORY
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('EMPLOYEE_CATG'
, PJO.EMPLOYMENT_CATEGORY)
, 1
, 80) D_EMPLOYMENT_CATEGORY
, PJO.DESCRIPTION
, PJO.PJO_ATTRIBUTE_CATEGORY
, PJO.PJO_ATTRIBUTE1
, PJO.PJO_ATTRIBUTE2
, PJO.PJO_ATTRIBUTE3
, PJO.PJO_ATTRIBUTE4
, PJO.PJO_ATTRIBUTE5
, PJO.PJO_ATTRIBUTE6
, PJO.PJO_ATTRIBUTE7
, PJO.PJO_ATTRIBUTE8
, PJO.PJO_ATTRIBUTE9
, PJO.PJO_ATTRIBUTE10
, PJO.PJO_ATTRIBUTE11
, PJO.PJO_ATTRIBUTE12
, PJO.PJO_ATTRIBUTE13
, PJO.PJO_ATTRIBUTE14
, PJO.PJO_ATTRIBUTE15
, PJO.PJO_ATTRIBUTE16
, PJO.PJO_ATTRIBUTE17
, PJO.PJO_ATTRIBUTE18
, PJO.PJO_ATTRIBUTE19
, PJO.PJO_ATTRIBUTE20
, PJO.PJO_ATTRIBUTE21
, PJO.PJO_ATTRIBUTE22
, PJO.PJO_ATTRIBUTE23
, PJO.PJO_ATTRIBUTE24
, PJO.PJO_ATTRIBUTE25
, PJO.PJO_ATTRIBUTE26
, PJO.PJO_ATTRIBUTE27
, PJO.PJO_ATTRIBUTE28
, PJO.PJO_ATTRIBUTE29
, PJO.PJO_ATTRIBUTE30
, PJO.PJO_INFORMATION_CATEGORY
, PJO.PJO_INFORMATION1
, PJO.PJO_INFORMATION2
, PJO.PJO_INFORMATION3
, PJO.PJO_INFORMATION4
, PJO.PJO_INFORMATION5
, PJO.PJO_INFORMATION6
, PJO.PJO_INFORMATION7
, PJO.PJO_INFORMATION8
, PJO.PJO_INFORMATION9
, PJO.PJO_INFORMATION10
, PJO.PJO_INFORMATION11
, PJO.PJO_INFORMATION12
, PJO.PJO_INFORMATION13
, PJO.PJO_INFORMATION14
, PJO.PJO_INFORMATION15
, PJO.PJO_INFORMATION16
, PJO.PJO_INFORMATION17
, PJO.PJO_INFORMATION18
, PJO.PJO_INFORMATION19
, PJO.PJO_INFORMATION20
, PJO.PJO_INFORMATION21
, PJO.PJO_INFORMATION22
, PJO.PJO_INFORMATION23
, PJO.PJO_INFORMATION24
, PJO.PJO_INFORMATION25
, PJO.PJO_INFORMATION26
, PJO.PJO_INFORMATION27
, PJO.PJO_INFORMATION28
, PJO.PJO_INFORMATION29
, PJO.PJO_INFORMATION30
, PJO.OBJECT_VERSION_NUMBER
, PJO.LAST_UPDATE_DATE
, PJO.LAST_UPDATED_BY
, PJO.LAST_UPDATE_LOGIN
, PJO.CREATED_BY
, PJO.CREATION_DATE
, PJO.PERIOD_MONTHS
, PJO.ALL_ASSIGNMENTS
FROM PER_PREVIOUS_JOBS PJO

Columns

Name
PREVIOUS_JOB_ID
PREVIOUS_EMPLOYER_ID
START_DATE
END_DATE
PERIOD_YEARS
PERIOD_DAYS
JOB_NAME
EMPLOYMENT_CATEGORY
D_EMPLOYMENT_CATEGORY
DESCRIPTION
PJO_ATTRIBUTE_CATEGORY
PJO_ATTRIBUTE1
PJO_ATTRIBUTE2
PJO_ATTRIBUTE3
PJO_ATTRIBUTE4
PJO_ATTRIBUTE5
PJO_ATTRIBUTE6
PJO_ATTRIBUTE7
PJO_ATTRIBUTE8
PJO_ATTRIBUTE9
PJO_ATTRIBUTE10
PJO_ATTRIBUTE11
PJO_ATTRIBUTE12
PJO_ATTRIBUTE13
PJO_ATTRIBUTE14
PJO_ATTRIBUTE15
PJO_ATTRIBUTE16
PJO_ATTRIBUTE17
PJO_ATTRIBUTE18
PJO_ATTRIBUTE19
PJO_ATTRIBUTE20
PJO_ATTRIBUTE21
PJO_ATTRIBUTE22
PJO_ATTRIBUTE23
PJO_ATTRIBUTE24
PJO_ATTRIBUTE25
PJO_ATTRIBUTE26
PJO_ATTRIBUTE27
PJO_ATTRIBUTE28
PJO_ATTRIBUTE29
PJO_ATTRIBUTE30
PJO_INFORMATION_CATEGORY
PJO_INFORMATION1
PJO_INFORMATION2
PJO_INFORMATION3
PJO_INFORMATION4
PJO_INFORMATION5
PJO_INFORMATION6
PJO_INFORMATION7
PJO_INFORMATION8
PJO_INFORMATION9
PJO_INFORMATION10
PJO_INFORMATION11
PJO_INFORMATION12
PJO_INFORMATION13
PJO_INFORMATION14
PJO_INFORMATION15
PJO_INFORMATION16
PJO_INFORMATION17
PJO_INFORMATION18
PJO_INFORMATION19
PJO_INFORMATION20
PJO_INFORMATION21
PJO_INFORMATION22
PJO_INFORMATION23
PJO_INFORMATION24
PJO_INFORMATION25
PJO_INFORMATION26
PJO_INFORMATION27
PJO_INFORMATION28
PJO_INFORMATION29
PJO_INFORMATION30
OBJECT_VERSION_NUMBER
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
PERIOD_MONTHS
ALL_ASSIGNMENTS