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

VIEW: APPS.PER_PREVIOUS_EMPLOYERS_V

Object Details
Object Name: PER_PREVIOUS_EMPLOYERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_PREVIOUS_EMPLOYERS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PREVIOUS_EMPLOYER_ID NUMBER (15) Yes Surogate ID for a Previous Employer record
BUSINESS_GROUP_ID NUMBER (15)
Business group under which this previous employer record is defined
PERSON_ID NUMBER (15)
This is the FK of the person to which previous employer record applies
PARTY_ID NUMBER (15)
This is the FK of the party to which the previous employer record applies
START_DATE DATE

Start date for the previous employer record
END_DATE DATE

End date of the previous employer record
PERIOD_YEARS NUMBER (2)
The whole number of years at the previous employer
PERIOD_DAYS NUMBER (3)
The number of days on top of the whole year at the previous employer
EMPLOYER_NAME VARCHAR2 (240)
Identifier for the employer
EMPLOYER_COUNTRY VARCHAR2 (30)
Country of the Employer
D_EMPLOYER_COUNTRY VARCHAR2 (80)
Employer Country
EMPLOYER_ADDRESS VARCHAR2 (4000)
Employer Address
EMPLOYER_TYPE VARCHAR2 (30)
Employer type
D_EMPLOYER_TYPE VARCHAR2 (80)
Employer type
EMPLOYER_SUBTYPE VARCHAR2 (30)
Employer Subtype
D_EMPLOYER_SUBTYPE VARCHAR2 (80)
employer subtype
DESCRIPTION VARCHAR2 (4000)
Description
PEM_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Attribute Category
PEM_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flex Field
PEM_ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flex Field
PEM_INFORMATION_CATEGORY VARCHAR2 (30)
Developer Descriptive Flex field
PEM_INFORMATION1 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION2 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION3 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION4 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION5 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION6 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION7 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION8 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION9 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION10 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION11 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION12 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION13 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION14 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION15 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION16 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION17 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION18 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION19 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION20 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION21 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION22 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION23 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION24 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION25 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION26 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION27 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION28 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION29 VARCHAR2 (150)
Developer Descriptive Flex field
PEM_INFORMATION30 VARCHAR2 (150)
Developer Descriptive Flex field
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
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
PERIOD_MONTHS NUMBER (2)
Period in Months
ALL_ASSIGNMENTS VARCHAR2 (1)
All Assignments
Query Text

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


SELECT PREVIOUS_EMPLOYER_ID
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      PARTY_ID
,      START_DATE
,      END_DATE
,      PERIOD_YEARS
,      PERIOD_DAYS
,      EMPLOYER_NAME
,      EMPLOYER_COUNTRY
,      D_EMPLOYER_COUNTRY
,      EMPLOYER_ADDRESS
,      EMPLOYER_TYPE
,      D_EMPLOYER_TYPE
,      EMPLOYER_SUBTYPE
,      D_EMPLOYER_SUBTYPE
,      DESCRIPTION
,      PEM_ATTRIBUTE_CATEGORY
,      PEM_ATTRIBUTE1
,      PEM_ATTRIBUTE2
,      PEM_ATTRIBUTE3
,      PEM_ATTRIBUTE4
,      PEM_ATTRIBUTE5
,      PEM_ATTRIBUTE6
,      PEM_ATTRIBUTE7
,      PEM_ATTRIBUTE8
,      PEM_ATTRIBUTE9
,      PEM_ATTRIBUTE10
,      PEM_ATTRIBUTE11
,      PEM_ATTRIBUTE12
,      PEM_ATTRIBUTE13
,      PEM_ATTRIBUTE14
,      PEM_ATTRIBUTE15
,      PEM_ATTRIBUTE16
,      PEM_ATTRIBUTE17
,      PEM_ATTRIBUTE18
,      PEM_ATTRIBUTE19
,      PEM_ATTRIBUTE20
,      PEM_ATTRIBUTE21
,      PEM_ATTRIBUTE22
,      PEM_ATTRIBUTE23
,      PEM_ATTRIBUTE24
,      PEM_ATTRIBUTE25
,      PEM_ATTRIBUTE26
,      PEM_ATTRIBUTE27
,      PEM_ATTRIBUTE28
,      PEM_ATTRIBUTE29
,      PEM_ATTRIBUTE30
,      PEM_INFORMATION_CATEGORY
,      PEM_INFORMATION1
,      PEM_INFORMATION2
,      PEM_INFORMATION3
,      PEM_INFORMATION4
,      PEM_INFORMATION5
,      PEM_INFORMATION6
,      PEM_INFORMATION7
,      PEM_INFORMATION8
,      PEM_INFORMATION9
,      PEM_INFORMATION10
,      PEM_INFORMATION11
,      PEM_INFORMATION12
,      PEM_INFORMATION13
,      PEM_INFORMATION14
,      PEM_INFORMATION15
,      PEM_INFORMATION16
,      PEM_INFORMATION17
,      PEM_INFORMATION18
,      PEM_INFORMATION19
,      PEM_INFORMATION20
,      PEM_INFORMATION21
,      PEM_INFORMATION22
,      PEM_INFORMATION23
,      PEM_INFORMATION24
,      PEM_INFORMATION25
,      PEM_INFORMATION26
,      PEM_INFORMATION27
,      PEM_INFORMATION28
,      PEM_INFORMATION29
,      PEM_INFORMATION30
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PERIOD_MONTHS
,      ALL_ASSIGNMENTS
FROM APPS.PER_PREVIOUS_EMPLOYERS_V;

Dependencies

[top of page]

APPS.PER_PREVIOUS_EMPLOYERS_V references the following:

SchemaAPPS
ViewFND_TERRITORIES_VL
PL/SQL PackageHR_GENERAL - show dependent code
SynonymPER_PREVIOUS_EMPLOYERS
APPS.PER_PREVIOUS_EMPLOYERS_V is referenced by following:

SchemaAPPS
Package BodyHR_PL_PREVIOUS_EMPLOYMENT_API - show dependent code
Package BodyPAY_SE_ARCHIVE_TETA - show dependent code
Package BodyPAY_SE_TRNA_ARCHIVE - show dependent code