DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.PER_PREVIOUS_JOB_USAGES

Object Details
Object Name: PER_PREVIOUS_JOB_USAGES
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_PREVIOUS_JOB_USAGES
Subobject Name:
Status: VALID


Holds information about which previous jobs are relevant to a particular employee assignment. This can be important information when calculating entitlements such as grade or probation period.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PER_PREVIOUS_JOB_USAGES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPREVIOUS_JOB_USAGE_ID
PER_PREVIOUS_JOB_USAGES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_ID
PER_PREVIOUS_JOB_USAGES_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPREVIOUS_JOB_ID
Columns
Name Datatype Length Mandatory Comments
PREVIOUS_JOB_USAGE_ID NUMBER (15) Yes Surrogate Id for a Previous employer record
ASSIGNMENT_ID NUMBER (15) Yes This is the FK of the assignment to which previous job usage record applies
PREVIOUS_JOB_ID NUMBER (15)
This is the FK of the previous job to which previous job usage recod applies
START_DATE DATE

Start date of the job
END_DATE DATE

End date of the job
PERIOD_YEARS NUMBER (2)
The whole number of years at the previous job
PERIOD_DAYS NUMBER (3)
the number of days on top of the whole year at the previous employer
PJU_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield Attribute Category
PJU_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield
PJU_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield
PJU_INFORMATION_CATEGORY VARCHAR2 (30)
Developer Descriptive flexfield Information Category
PJU_INFORMATION1 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION2 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION3 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION4 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION5 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION6 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION7 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION8 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION9 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION10 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION11 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION12 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION13 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION14 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION15 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION16 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION17 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION18 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION19 VARCHAR2 (150)
Developer Descriptive flexfield
PJU_INFORMATION20 VARCHAR2 (150)
Developer Descriptive flexfield
OBJECT_VERSION_NUMBER NUMBER (9) Yes Used to store object version number
LAST_UPDATE_DATE DATE
Yes Standard WHO columns
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns
CREATED_BY NUMBER (15) Yes Standard WHO columns
CREATION_DATE DATE
Yes Standard WHO columns
PREVIOUS_EMPLOYER_ID NUMBER (15)
This is the FK of the Previous Employer to which previous job usage record applies
PERIOD_MONTHS NUMBER (2)
The whole number of months at the previous job
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PREVIOUS_JOB_USAGE_ID
,      ASSIGNMENT_ID
,      PREVIOUS_JOB_ID
,      START_DATE
,      END_DATE
,      PERIOD_YEARS
,      PERIOD_DAYS
,      PJU_ATTRIBUTE_CATEGORY
,      PJU_ATTRIBUTE1
,      PJU_ATTRIBUTE2
,      PJU_ATTRIBUTE3
,      PJU_ATTRIBUTE4
,      PJU_ATTRIBUTE5
,      PJU_ATTRIBUTE6
,      PJU_ATTRIBUTE7
,      PJU_ATTRIBUTE8
,      PJU_ATTRIBUTE9
,      PJU_ATTRIBUTE10
,      PJU_ATTRIBUTE11
,      PJU_ATTRIBUTE12
,      PJU_ATTRIBUTE13
,      PJU_ATTRIBUTE14
,      PJU_ATTRIBUTE15
,      PJU_ATTRIBUTE16
,      PJU_ATTRIBUTE17
,      PJU_ATTRIBUTE18
,      PJU_ATTRIBUTE19
,      PJU_ATTRIBUTE20
,      PJU_INFORMATION_CATEGORY
,      PJU_INFORMATION1
,      PJU_INFORMATION2
,      PJU_INFORMATION3
,      PJU_INFORMATION4
,      PJU_INFORMATION5
,      PJU_INFORMATION6
,      PJU_INFORMATION7
,      PJU_INFORMATION8
,      PJU_INFORMATION9
,      PJU_INFORMATION10
,      PJU_INFORMATION11
,      PJU_INFORMATION12
,      PJU_INFORMATION13
,      PJU_INFORMATION14
,      PJU_INFORMATION15
,      PJU_INFORMATION16
,      PJU_INFORMATION17
,      PJU_INFORMATION18
,      PJU_INFORMATION19
,      PJU_INFORMATION20
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PREVIOUS_EMPLOYER_ID
,      PERIOD_MONTHS
FROM HR.PER_PREVIOUS_JOB_USAGES;

Dependencies

[top of page]

HR.PER_PREVIOUS_JOB_USAGES does not reference any database object

HR.PER_PREVIOUS_JOB_USAGES is referenced by following:

SchemaHR
ViewPER_PREVIOUS_JOB_USAGES#