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

VIEW: APPS.POS_PER_PEOPLE_X_V

Object Details
Object Name: POS_PER_PEOPLE_X_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POS_PER_PEOPLE_X_V
ViewPOS.POS_PER_PEOPLE_X_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This is a view which retrieves the data related to an employee.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (10) Yes Person Id
EFFECTIVE_START_DATE DATE
Yes Effective Start Date
EFFECTIVE_END_DATE DATE
Yes Effective End Date
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign Key to HR_ORGANIZATION_UNITS
PERSON_TYPE_ID NUMBER (15) Yes Foreign Key to PER_PERSON_TYPES
LAST_NAME VARCHAR2 (150) Yes Last Name
START_DATE DATE
Yes Start Date for the person
APPLICANT_NUMBER VARCHAR2 (30)
Number assigned to person if classified as an applicant
COMMENT_ID NUMBER (15)
Foreign Key reference to remark
CURRENT_APPLICANT_FLAG VARCHAR2 (30)
Yes or null
CURRENT_EMP_OR_APL_FLAG VARCHAR2 (30)
yes or null
CURRENT_EMPLOYEE_FLAG VARCHAR2 (30)
Yes or null
DATE_EMPLOYEE_DATA_VERIFIED DATE

Date when employee last verified the data
DATE_OF_BIRTH DATE

Date of Birth
EMAIL_ADDRESS VARCHAR2 (240)
Email Address
EMPLOYEE_NUMBER VARCHAR2 (30)
Employee Number
EXPENSE_CHECK_SEND_TO_ADDRESS VARCHAR2 (30)
Mailing Address
FIRST_NAME VARCHAR2 (150)
First Name
FULL_NAME VARCHAR2 (240)
Full Name
KNOWN_AS VARCHAR2 (80)
Preferred Name
MARITAL_STATUS VARCHAR2 (30)
Marital Status
MIDDLE_NAMES VARCHAR2 (60)
Middle Names
NATIONALITY VARCHAR2 (30)
Nationality
NATIONAL_IDENTIFIER VARCHAR2 (30)
Number by which a person is identitied in a give legislation
PREVIOUS_LAST_NAME VARCHAR2 (150)
Previous Last Name
REGISTERED_DISABLED_FLAG VARCHAR2 (30)
Flag indicating if person is disabled
SEX VARCHAR2 (30)
Male or Female
TITLE VARCHAR2 (30)
Mr, Mrs or Dr
VENDOR_ID NUMBER (15)
Vendor Id
WORK_TELEPHONE VARCHAR2 (4000)
Work Phone Number
REQUEST_ID NUMBER (15)
Who Column
PROGRAM_APPLICATION_ID NUMBER (15)
Who Column
PROGRAM_ID NUMBER (15)
Who Column
PROGRAM_UPDATE_DATE DATE

Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flex
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flex
LAST_UPDATE_DATE DATE

Who Column
LAST_UPDATED_BY NUMBER (15)
Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Who Column
CREATED_BY NUMBER (15)
Who Column
CREATION_DATE DATE

Who Column
PER_INFORMATION_CATEGORY VARCHAR2 (30)
Developer Descriptive Flexfiled Column
PER_INFORMATION1 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION2 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION3 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION4 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION5 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION6 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION7 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION8 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION9 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION10 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION11 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION12 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION13 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION14 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION15 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION16 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION17 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION18 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION19 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
PER_INFORMATION20 VARCHAR2 (150)
Developer Descriptive Flexfiled Column
OBJECT_VERSION_NUMBER NUMBER (9)
System Generated Version of Row.
Query Text

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


SELECT PERSON_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      PERSON_TYPE_ID
,      LAST_NAME
,      START_DATE
,      APPLICANT_NUMBER
,      COMMENT_ID
,      CURRENT_APPLICANT_FLAG
,      CURRENT_EMP_OR_APL_FLAG
,      CURRENT_EMPLOYEE_FLAG
,      DATE_EMPLOYEE_DATA_VERIFIED
,      DATE_OF_BIRTH
,      EMAIL_ADDRESS
,      EMPLOYEE_NUMBER
,      EXPENSE_CHECK_SEND_TO_ADDRESS
,      FIRST_NAME
,      FULL_NAME
,      KNOWN_AS
,      MARITAL_STATUS
,      MIDDLE_NAMES
,      NATIONALITY
,      NATIONAL_IDENTIFIER
,      PREVIOUS_LAST_NAME
,      REGISTERED_DISABLED_FLAG
,      SEX
,      TITLE
,      VENDOR_ID
,      WORK_TELEPHONE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PER_INFORMATION_CATEGORY
,      PER_INFORMATION1
,      PER_INFORMATION2
,      PER_INFORMATION3
,      PER_INFORMATION4
,      PER_INFORMATION5
,      PER_INFORMATION6
,      PER_INFORMATION7
,      PER_INFORMATION8
,      PER_INFORMATION9
,      PER_INFORMATION10
,      PER_INFORMATION11
,      PER_INFORMATION12
,      PER_INFORMATION13
,      PER_INFORMATION14
,      PER_INFORMATION15
,      PER_INFORMATION16
,      PER_INFORMATION17
,      PER_INFORMATION18
,      PER_INFORMATION19
,      PER_INFORMATION20
,      OBJECT_VERSION_NUMBER
FROM APPS.POS_PER_PEOPLE_X_V;

Dependencies

[top of page]

APPS.POS_PER_PEOPLE_X_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_PEOPLE_X

APPS.POS_PER_PEOPLE_X_V is not referenced by any database object