[Home] [Help] [Dependency Information]

VIEW: APPS.HRFV_PERSON_ASSIGNMENT_HISTORY

Object Details

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

View Type

A Business Intelligence System view

This view shows past person and assignment information in a series of records for which each record has a unique person and assignment combination

[View Source]

Columns

Query Text

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

SELECT BUSINESS_GROUP_NAME
,      RECORD_START_DATE
,      RECORD_END_DATE
,      PERSON_START_DATE
,      PERSON_END_DATE
,      ASSIGNMENT_START_DATE
,      ASSIGNMENT_END_DATE
,      PERSON_NAME
,      EMPLOYEE_NUMBER
,      MIDDLE_NAMES
,      PREFERRED_NAME
,      FIRST_NAME
,      LAST_NAME
,      TITLE
,      PREFIX
,      SUFFIX
,      GENDER
,      PREVIOUS_LAST_NAME
,      COLLECTIVE_AGREEMENT_NAME
,      REGISTERED_DISABLED
,      DATE_OF_BIRTH
,      TOWN_OF_BIRTH
,      REGION_OF_BIRTH
,      COUNTRY_OF_BIRTH
,      MARITAL_STATUS
,      NATIONALITY
,      NATIONAL_IDENTIFIER
,      APPLICANT_NUMBER
,      CONTINGENT_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
,      CURRENT_CONTINGENT_FLAG
,      DATE_EMPLOYEE_DATA_VERIFIED
,      DATE_OF_DEATH
,      FAST_PATH_EMPLOYEE
,      HOLD_APPLICATION_UNTIL
,      HONORS
,      ON_MILITARY_SERVICE
,      PROJECTED_START_DATE
,      STUDENT_STATUS
,      PERSON_TYPE
,      EMPLOYEE_PERSON_TYPE
,      APPLICANT_PERSON_TYPE
,      CONTINGENT_PERSON_TYPE
,      USER_CONCAT_PERSON_TYPE
,      HIRE_DATE
,      ORIGINAL_DATE_OF_HIRE
,      WORK_TELEPHONE_NUMBER
,      _DF:PERSON
,      ASSIGNMENT_NUMBER
,      NORMAL_START_TIME
,      NORMAL_END_TIME
,      PRIMARY_FLAG
,      INTERNAL_ADDRESS
,      ASSIGNMENT_TYPE
,      USER_ASSIGNMENT_STATUS
,      PER_SYSTEM_ASSIGNMENT_STATUS
,      PAY_SYSTEM_ASSIGNMENT_STATUS
,      MANAGER_FLAG
,      EMPLOYMENT_CATEGORY
,      WORKING_HOURS_AMOUNT
,      WORKING_HOURS_FREQUENCY
,      CHANGE_REASON
,      SOURCE_TYPE
,      SUPERVISOR_NAME
,      SUPERVISOR_NUMBER
,      SALARY_BASIS
,      ASSIGNMENT_ORGANIZATION_NAME
,      POSITION_NAME
,      JOB_NAME
,      LOCATION_NAME
,      GRADE_NAME
,      PEOPLE_GROUP
,      PAYROLL_NAME
,      RECRUITMENT_ACTIVITY_NAME
,      VACANCY_NAME
,      _KF:PEO_GRP
,      _DF:ASG
,      GENDER_CODE
,      REGISTERED_DISABLED_FLAG_CODE
,      MARITAL_STATUS_CODE
,      NATIONALITY_CODE
,      EXPENSE_CHECK_ADDR_CODE
,      SECOND_PASSPORT_EXISTS_CODE
,      RESUME_EXISTS_CODE
,      CURRENT_APPLICANT_FLAG_CODE
,      CURRENT_EMPLOYEE_FLAG_CODE
,      CURRENT_CONTINGENT_FLAG_CODE
,      STUDENT_STATUS_CODE
,      PRIMARY_FLAG_CODE
,      ASSIGNMENT_TYPE_CODE
,      PER_SYSTEM_STATUS_CODE
,      PAY_SYSTEM_STATUS_CODE
,      MANAGER_FLAG_CODE
,      EMPLOYMENT_CATEGORY_CODE
,      FAST_PATH_EMPLOYEE_CODE
,      ON_MILITARY_SERVICE_CODE
,      FREQUENCY_CODE
,      SOURCE_TYPE_CODE
,      SYSTEM_PERSON_TYPE_CODE
,      APPLICATION_ID
,      ASSIGNMENT_ID
,      ASSIGNMENT_ORGANIZATION_ID
,      BUSINESS_GROUP_ID
,      GRADE_ID
,      JOB_ID
,      LOCATION_ID
,      PAYROLL_ID
,      PERIOD_OF_SERVICE_ID
,      PEOPLE_GROUP_ID
,      PERSON_ID
,      PERSON_TYPE_ID
,      POSITION_ID
,      RECRUITMENT_ACTIVITY_ID
,      SALARY_BASIS_ID
,      SUPERVISOR_ID
,      VACANCY_ID
,      COLLECTIVE_AGREEMENT_ID
,      PEO_LAST_UPDATE_DATE
,      ASG_LAST_UPDATE_DATE
,      PEO_LAST_UPDATED_BY
,      ASG_LAST_UPDATED_BY
FROM APPS.HRFV_PERSON_ASSIGNMENT_HISTORY;

Dependencies

[top of page]

APPS

FND_TERRITORIES_TL

HRI_BPL_PERSON_TYPE - show dependent code

HR_ALL_ORGANIZATION_UNITS_TL

HR_ALL_POSITIONS_F_TL

HR_BIS - show dependent code

HR_GENERAL - show dependent code

HR_LOCATIONS_ALL_TL

HR_SECURITY - show dependent code

PAY_ALL_PAYROLLS_F

PAY_PEOPLE_GROUPS

PER_ALL_PEOPLE_F

PER_ALL_VACANCIES

PER_ASSIGNMENTS_F

PER_ASSIGNMENT_STATUS_TYPES

PER_ASSIGNMENT_STATUS_TYPES_TL

PER_ASS_STATUS_TYPE_AMENDS

PER_ASS_STATUS_TYPE_AMENDS_TL

PER_COLLECTIVE_AGREEMENTS

PER_GRADES_TL

PER_JOBS_TL

PER_PAY_BASES

PER_PERIODS_OF_PLACEMENT

PER_PERIODS_OF_SERVICE

PER_PERSON_TYPES

PER_PERSON_TYPES_TL

PER_PHONES

PER_RECRUITMENT_ACTIVITIES

APPS.HRFV_PERSON_ASSIGNMENT_HISTORY is not referenced by any database object