[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PER_PREV_JOB_EXTRA_INFO |
|---|---|
| Object Type: | TABLE |
| Owner: | HR |
| FND Design Data: |  PER.PER_PREV_JOB_EXTRA_INFO
|
| Subobject Name: | |
| Status: | VALID |
Extra information for Jobs held with previous employers
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PER_PREV_JOB_EXTRA_INFO_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PREVIOUS_JOB_EXTRA_INFO_ID
|
| PER_PREV_JOB_EXTRA_INFO_FK | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PREVIOUS_JOB_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PREVIOUS_JOB_EXTRA_INFO_ID | NUMBER | (15) | Yes | This is the Surrogate ID for Previous Job record |
| PREVIOUS_JOB_ID | NUMBER | (15) | Yes | This is the FK of the Previous Job to which previous job extra info record applies |
| INFORMATION_TYPE | VARCHAR2 | (40) | Yes | Information type for this extra job information |
| PJI_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Attribute Category | |
| PJI_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PJI_INFORMATION_CATEGORY | VARCHAR2 | (30) | Developer Descriptive Flexfield Information Category | |
| PJI_INFORMATION1 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION2 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION3 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION4 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION5 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION6 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION7 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION8 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION9 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION10 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION11 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION12 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION13 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION14 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION15 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION16 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION17 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION18 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION19 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION20 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION21 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION22 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION23 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION24 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION25 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION26 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION27 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION28 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION29 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
| PJI_INFORMATION30 | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT PREVIOUS_JOB_EXTRA_INFO_ID
, PREVIOUS_JOB_ID
, INFORMATION_TYPE
, PJI_ATTRIBUTE_CATEGORY
, PJI_ATTRIBUTE1
, PJI_ATTRIBUTE2
, PJI_ATTRIBUTE3
, PJI_ATTRIBUTE4
, PJI_ATTRIBUTE5
, PJI_ATTRIBUTE6
, PJI_ATTRIBUTE7
, PJI_ATTRIBUTE8
, PJI_ATTRIBUTE9
, PJI_ATTRIBUTE10
, PJI_ATTRIBUTE11
, PJI_ATTRIBUTE12
, PJI_ATTRIBUTE13
, PJI_ATTRIBUTE14
, PJI_ATTRIBUTE15
, PJI_ATTRIBUTE16
, PJI_ATTRIBUTE17
, PJI_ATTRIBUTE18
, PJI_ATTRIBUTE19
, PJI_ATTRIBUTE20
, PJI_ATTRIBUTE21
, PJI_ATTRIBUTE22
, PJI_ATTRIBUTE23
, PJI_ATTRIBUTE24
, PJI_ATTRIBUTE25
, PJI_ATTRIBUTE26
, PJI_ATTRIBUTE27
, PJI_ATTRIBUTE28
, PJI_ATTRIBUTE29
, PJI_ATTRIBUTE30
, PJI_INFORMATION_CATEGORY
, PJI_INFORMATION1
, PJI_INFORMATION2
, PJI_INFORMATION3
, PJI_INFORMATION4
, PJI_INFORMATION5
, PJI_INFORMATION6
, PJI_INFORMATION7
, PJI_INFORMATION8
, PJI_INFORMATION9
, PJI_INFORMATION10
, PJI_INFORMATION11
, PJI_INFORMATION12
, PJI_INFORMATION13
, PJI_INFORMATION14
, PJI_INFORMATION15
, PJI_INFORMATION16
, PJI_INFORMATION17
, PJI_INFORMATION18
, PJI_INFORMATION19
, PJI_INFORMATION20
, PJI_INFORMATION21
, PJI_INFORMATION22
, PJI_INFORMATION23
, PJI_INFORMATION24
, PJI_INFORMATION25
, PJI_INFORMATION26
, PJI_INFORMATION27
, PJI_INFORMATION28
, PJI_INFORMATION29
, PJI_INFORMATION30
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR.PER_PREV_JOB_EXTRA_INFO;
HR.PER_PREV_JOB_EXTRA_INFO does not reference any database object
HR.PER_PREV_JOB_EXTRA_INFO is referenced by following:
HR
PER_PREV_JOB_EXTRA_INFO#
|
|
|
|