[Home] [Help] [Dependency Information]

VIEW: APPS.HRFV_US_PERSONAL_DETAILS

Object Details

Object Name:	HRFV_US_PERSONAL_DETAILS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HRFV_US_PERSONAL_DETAILS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view shows US specific information about US people. Use
PERSONAL DETAILS to see generic information about all people.

[View Source]

Columns

Query Text

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

SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      EMPLOYEE_NUMBER
,      SOCIAL_SECURITY_NUMBER
,      PREFIX
,      SUFFIX
,      FIRST_NAME
,      LAST_NAME
,      PREFERRED_NAME
,      MIDDLE_NAMES
,      TITLE
,      ETHNIC_ORIGIN
,      I9
,      I9_EXPIRY_DATE
,      VISA_TYPE
,      VIETNAM_VETS_STATUS
,      STUDENT
,      NEW_HIRE_STATUS
,      EXCLUSION_REASON
,      CHILD_SUPPORT_OBLIGATION
,      _DF
,      BUSINESS_GROUP_ID
,      PERSON_ID
FROM APPS.HRFV_US_PERSONAL_DETAILS;

Dependencies

[top of page]

APPS

FND_DATE - show dependent code

HR_BIS - show dependent code

HR_GENERAL - show dependent code

HR_PERSON_NAME - show dependent code

HR_SECURITY - show dependent code

PER_BUSINESS_GROUPS

PER_PEOPLE_X

PUBLIC

HRFV_US_PERSONAL_DETAILS