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


VIEW: APPS.PER_ALL_PEOPLE_D

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (10) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
LAST_NAME VARCHAR2 (150) Yes
DATE_LAST_VERIFIED DATE


BIRTH_DATE DATE


EMAIL VARCHAR2 (240)

EMPLOYEE_NUMBER VARCHAR2 (30)

MAIL_DESTINATION VARCHAR2 (80)

FIRST_NAME VARCHAR2 (150)

FULL_NAME VARCHAR2 (240)

KNOWN_AS VARCHAR2 (80)

MARITAL_STATUS VARCHAR2 (80)

MIDDLE_NAMES VARCHAR2 (60)

NATIONALITY VARCHAR2 (80)

SOCIAL_SECURITY_NUMBER VARCHAR2 (30)

PREVIOUS_LAST_NAME VARCHAR2 (150)

DISABLED VARCHAR2 (80)

SEX VARCHAR2 (80)

TITLE VARCHAR2 (80)

LAST_UPDATE_DATE DATE


LAST_UPDATED_BY VARCHAR2 (100)

WORK_SCHEDULE VARCHAR2 (80)
STUDENT_STATUS VARCHAR2 (80)
FTE_CAPACITY NUMBER (5)
ON_MILITARY_SERVICE VARCHAR2 (80)
SECOND_PASSPORT_EXISTS VARCHAR2 (80)
OFFICE_NUMBER VARCHAR2 (45)
INTERNAL_LOCATION VARCHAR2 (45)
MAILSTOP VARCHAR2 (45)
HONORS VARCHAR2 (45)
PRE_NAME_ADJUNCT VARCHAR2 (30)
HOLD_APPLICANT_DATE_UNTIL DATE

SUFFIX VARCHAR2 (30)
Query Text

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


SELECT PERSON_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      LAST_NAME
,      DATE_LAST_VERIFIED
,      BIRTH_DATE
,      EMAIL
,      EMPLOYEE_NUMBER
,      MAIL_DESTINATION
,      FIRST_NAME
,      FULL_NAME
,      KNOWN_AS
,      MARITAL_STATUS
,      MIDDLE_NAMES
,      NATIONALITY
,      SOCIAL_SECURITY_NUMBER
,      PREVIOUS_LAST_NAME
,      DISABLED
,      SEX
,      TITLE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      WORK_SCHEDULE
,      STUDENT_STATUS
,      FTE_CAPACITY
,      ON_MILITARY_SERVICE
,      SECOND_PASSPORT_EXISTS
,      OFFICE_NUMBER
,      INTERNAL_LOCATION
,      MAILSTOP
,      HONORS
,      PRE_NAME_ADJUNCT
,      HOLD_APPLICANT_DATE_UNTIL
,      SUFFIX
FROM APPS.PER_ALL_PEOPLE_D;

Dependencies

[top of page]

APPS.PER_ALL_PEOPLE_D references the following:

SchemaAPPS
SynonymFND_USER
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOOKUPS
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_PEOPLE_F
SynonymPER_PERSON_TYPES
SynonymPER_PERSON_TYPES_TL

APPS.PER_ALL_PEOPLE_D is not referenced by any database object