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


VIEW: APPS.HRFV_PERSONAL_DETAILS

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

View Type

A Business Intelligence System view


This view shows generic information about the people in
your enterprise.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240) Yes
PERSON_NAME VARCHAR2 (240)

EMPLOYEE_NUMBER VARCHAR2 (30)

TITLE VARCHAR2 (4000)
MIDDLE_NAMES VARCHAR2 (60)

PREFERRED_NAME VARCHAR2 (80)

FIRST_NAME VARCHAR2 (150)

LAST_NAME VARCHAR2 (150) Yes
PREFIX VARCHAR2 (30)
SUFFIX VARCHAR2 (30)
GENDER VARCHAR2 (4000)

PREVIOUS_LAST_NAME VARCHAR2 (150)

REGISTERED_DISABLED VARCHAR2 (4000)

DATE_OF_BIRTH DATE


AGE VARCHAR2 (40)
TOWN_OF_BIRTH VARCHAR2 (90)
REGION_OF_BIRTH VARCHAR2 (90)
COUNTRY_OF_BIRTH VARCHAR2 (80)
MARITAL_STATUS VARCHAR2 (4000)

NATIONALITY VARCHAR2 (4000)

NATIONAL_IDENTIFIER VARCHAR2 (30)

APPLICANT_NUMBER VARCHAR2 (30)

EMAIL_ADDRESS VARCHAR2 (240)

MAIL_DESTINATION VARCHAR2 (4000)

SECOND_PASSPORT VARCHAR2 (4000)

OFFICE_NUMBER VARCHAR2 (45)

INTERNAL_LOCATION VARCHAR2 (45)

MAILSTOP VARCHAR2 (45)

WORK_SCHEDULE VARCHAR2 (30)

FTE_CAPACITY NUMBER (5)

RESUME_EXISTS VARCHAR2 (4000)

RESUME_LAST_UPDATED DATE


CURRENT_APPLICANT_FLAG VARCHAR2 (4000)

CURRENT_EMPLOYEE_FLAG VARCHAR2 (4000)

DATE_EMPLOYEE_DATA_VERIFIED DATE


DATE_OF_DEATH DATE


FAST_PATH_EMPLOYEE VARCHAR2 (4000)

HOLD_APPLICATION_UNTIL DATE


HONORS VARCHAR2 (45)

ON_MILITARY_SERVICE VARCHAR2 (4000)

PROJECTED_START_DATE DATE


STUDENT_STATUS VARCHAR2 (4000)

HIRE_DATE DATE

ORIGINAL_DATE_OF_HIRE DATE

Original date of hire.
GENDER_CODE VARCHAR2 (30)
REGISTERED_DISABLED_FLAG_CODE VARCHAR2 (30)
MARITAL_STATUS_CODE VARCHAR2 (30)
NATIONALITY_CODE VARCHAR2 (30)
EXPENSE_CHECK_SEND_ADDR_CODE VARCHAR2 (30)
SECOND_PASSPORT_EXISTS_CODE VARCHAR2 (30)
RESUME_EXISTS_CODE VARCHAR2 (30)
CURRENT_APPLICANT_FLAG_CODE VARCHAR2 (30)
CURRENT_EMPLOYEE_FLAG_CODE VARCHAR2 (30)
FAST_PATH_EMPLOYEE_CODE VARCHAR2 (30)
ON_MILITARY_SERVICE_CODE VARCHAR2 (30)
STUDENT_STATUS_CODE VARCHAR2 (30)
PERSON_TYPE VARCHAR2 (80) Yes
EMPLOYEE_PERSON_TYPE VARCHAR2 (4000)
APPLICANT_PERSON_TYPE VARCHAR2 (4000)
USER_CONCAT_PERSON_TYPE VARCHAR2 (4000)
WORK_TELEPHONE_NUMBER VARCHAR2 (60)

CORRESPONDENCE_LANGUAGE VARCHAR2 (30)

SYSTEM_PERSON_TYPE_CODE VARCHAR2 (30) Yes
_DF CHAR (22)
BUSINESS_GROUP_ID NUMBER (15) Yes
PERSON_ID NUMBER (10) Yes
PERSON_TYPE_ID NUMBER (15) Yes
PEO_LAST_UPDATE_DATE DATE

Last Update Date WHO column from per_all_people_f
Query Text

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


SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      EMPLOYEE_NUMBER
,      TITLE
,      MIDDLE_NAMES
,      PREFERRED_NAME
,      FIRST_NAME
,      LAST_NAME
,      PREFIX
,      SUFFIX
,      GENDER
,      PREVIOUS_LAST_NAME
,      REGISTERED_DISABLED
,      DATE_OF_BIRTH
,      AGE
,      TOWN_OF_BIRTH
,      REGION_OF_BIRTH
,      COUNTRY_OF_BIRTH
,      MARITAL_STATUS
,      NATIONALITY
,      NATIONAL_IDENTIFIER
,      APPLICANT_NUMBER
,      EMAIL_ADDRESS
,      MAIL_DESTINATION
,      SECOND_PASSPORT
,      OFFICE_NUMBER
,      INTERNAL_LOCATION
,      MAILSTOP
,      WORK_SCHEDULE
,      FTE_CAPACITY
,      RESUME_EXISTS
,      RESUME_LAST_UPDATED
,      CURRENT_APPLICANT_FLAG
,      CURRENT_EMPLOYEE_FLAG
,      DATE_EMPLOYEE_DATA_VERIFIED
,      DATE_OF_DEATH
,      FAST_PATH_EMPLOYEE
,      HOLD_APPLICATION_UNTIL
,      HONORS
,      ON_MILITARY_SERVICE
,      PROJECTED_START_DATE
,      STUDENT_STATUS
,      HIRE_DATE
,      ORIGINAL_DATE_OF_HIRE
,      GENDER_CODE
,      REGISTERED_DISABLED_FLAG_CODE
,      MARITAL_STATUS_CODE
,      NATIONALITY_CODE
,      EXPENSE_CHECK_SEND_ADDR_CODE
,      SECOND_PASSPORT_EXISTS_CODE
,      RESUME_EXISTS_CODE
,      CURRENT_APPLICANT_FLAG_CODE
,      CURRENT_EMPLOYEE_FLAG_CODE
,      FAST_PATH_EMPLOYEE_CODE
,      ON_MILITARY_SERVICE_CODE
,      STUDENT_STATUS_CODE
,      PERSON_TYPE
,      EMPLOYEE_PERSON_TYPE
,      APPLICANT_PERSON_TYPE
,      USER_CONCAT_PERSON_TYPE
,      WORK_TELEPHONE_NUMBER
,      CORRESPONDENCE_LANGUAGE
,      SYSTEM_PERSON_TYPE_CODE
,      _DF
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      PERSON_TYPE_ID
,      PEO_LAST_UPDATE_DATE
FROM APPS.HRFV_PERSONAL_DETAILS;

Dependencies

[top of page]

APPS.HRFV_PERSONAL_DETAILS references the following:

SchemaAPPS
SynonymFND_LANGUAGES
SynonymFND_TERRITORIES_TL
PL/SQL PackageHRI_BPL_PERSON_TYPE - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_BIS - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_PEOPLE_F
SynonymPER_PERIODS_OF_SERVICE
SynonymPER_PERSON_TYPES
SynonymPER_PERSON_TYPES_TL
SynonymPER_PHONES

APPS.HRFV_PERSONAL_DETAILS is not referenced by any database object