[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HRFV_PERSON_ASSIGNMENT_HISTORY |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PER.HRFV_PERSON_ASSIGNMENT_HISTORY
|
| Subobject Name: | |
| Status: | VALID |
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
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
| RECORD_START_DATE | DATE | |||
| RECORD_END_DATE | DATE | |||
| PERSON_START_DATE | DATE | Yes | ||
| PERSON_END_DATE | DATE | Yes | ||
| ASSIGNMENT_START_DATE | DATE | Yes | ||
| ASSIGNMENT_END_DATE | DATE | Yes | ||
| PERSON_NAME | VARCHAR2 | (240) | ||
| EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
| MIDDLE_NAMES | VARCHAR2 | (60) | ||
| PREFERRED_NAME | VARCHAR2 | (80) | ||
| FIRST_NAME | VARCHAR2 | (150) | ||
| LAST_NAME | VARCHAR2 | (150) | Yes | |
| TITLE | VARCHAR2 | (30) | ||
| PREFIX | VARCHAR2 | (30) | ||
| SUFFIX | VARCHAR2 | (30) | ||
| GENDER | VARCHAR2 | (4000) | ||
| PREVIOUS_LAST_NAME | VARCHAR2 | (150) | ||
| COLLECTIVE_AGREEMENT_NAME | VARCHAR2 | (80) | ||
| REGISTERED_DISABLED | VARCHAR2 | (4000) | ||
| DATE_OF_BIRTH | DATE | |||
| 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) | ||
| CONTINGENT_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) | ||
| CURRENT_CONTINGENT_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) | ||
| PERSON_TYPE | VARCHAR2 | (80) | Yes | |
| EMPLOYEE_PERSON_TYPE | VARCHAR2 | (4000) | ||
| APPLICANT_PERSON_TYPE | VARCHAR2 | (4000) | ||
| CONTINGENT_PERSON_TYPE | VARCHAR2 | (4000) | User Contingent Person Type | |
| USER_CONCAT_PERSON_TYPE | VARCHAR2 | (4000) | ||
| HIRE_DATE | DATE | |||
| ORIGINAL_DATE_OF_HIRE | DATE | Original date of hire. | ||
| WORK_TELEPHONE_NUMBER | VARCHAR2 | (60) | ||
| _DF:PERSON | CHAR | (22) | ||
| ASSIGNMENT_NUMBER | VARCHAR2 | (30) | ||
| NORMAL_START_TIME | VARCHAR2 | (5) | ||
| NORMAL_END_TIME | VARCHAR2 | (5) | ||
| PRIMARY_FLAG | VARCHAR2 | (4000) | ||
| INTERNAL_ADDRESS | VARCHAR2 | (80) | ||
| ASSIGNMENT_TYPE | VARCHAR2 | (4000) | ||
| USER_ASSIGNMENT_STATUS | VARCHAR2 | (80) | ||
| PER_SYSTEM_ASSIGNMENT_STATUS | VARCHAR2 | (4000) | ||
| PAY_SYSTEM_ASSIGNMENT_STATUS | VARCHAR2 | (4000) | ||
| MANAGER_FLAG | VARCHAR2 | (4000) | ||
| EMPLOYMENT_CATEGORY | VARCHAR2 | (4000) | ||
| WORKING_HOURS_AMOUNT | NUMBER | (22) | ||
| WORKING_HOURS_FREQUENCY | VARCHAR2 | (4000) | ||
| CHANGE_REASON | VARCHAR2 | (30) | ||
| SOURCE_TYPE | VARCHAR2 | (4000) | ||
| SUPERVISOR_NAME | VARCHAR2 | (240) | ||
| SUPERVISOR_NUMBER | VARCHAR2 | (30) | ||
| SALARY_BASIS | VARCHAR2 | (30) | ||
| ASSIGNMENT_ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | |
| POSITION_NAME | VARCHAR2 | (240) | ||
| JOB_NAME | VARCHAR2 | (700) | ||
| LOCATION_NAME | VARCHAR2 | (60) | ||
| GRADE_NAME | VARCHAR2 | (240) | ||
| PEOPLE_GROUP | VARCHAR2 | (240) | ||
| PAYROLL_NAME | VARCHAR2 | (80) | ||
| RECRUITMENT_ACTIVITY_NAME | VARCHAR2 | (30) | ||
| VACANCY_NAME | VARCHAR2 | (30) | ||
| _KF:PEO_GRP | CHAR | (15) | ||
| _DF:ASG | CHAR | (27) | ||
| GENDER_CODE | VARCHAR2 | (30) | ||
| REGISTERED_DISABLED_FLAG_CODE | VARCHAR2 | (30) | ||
| MARITAL_STATUS_CODE | VARCHAR2 | (30) | ||
| NATIONALITY_CODE | VARCHAR2 | (30) | ||
| EXPENSE_CHECK_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) | ||
| CURRENT_CONTINGENT_FLAG_CODE | VARCHAR2 | (30) | ||
| STUDENT_STATUS_CODE | VARCHAR2 | (30) | ||
| PRIMARY_FLAG_CODE | VARCHAR2 | (30) | Yes | |
| ASSIGNMENT_TYPE_CODE | VARCHAR2 | (1) | Yes | |
| PER_SYSTEM_STATUS_CODE | VARCHAR2 | (30) | ||
| PAY_SYSTEM_STATUS_CODE | VARCHAR2 | (1) | ||
| MANAGER_FLAG_CODE | VARCHAR2 | (30) | ||
| EMPLOYMENT_CATEGORY_CODE | VARCHAR2 | (30) | ||
| FAST_PATH_EMPLOYEE_CODE | VARCHAR2 | (30) | ||
| ON_MILITARY_SERVICE_CODE | VARCHAR2 | (30) | ||
| FREQUENCY_CODE | VARCHAR2 | (30) | ||
| SOURCE_TYPE_CODE | VARCHAR2 | (30) | ||
| SYSTEM_PERSON_TYPE_CODE | VARCHAR2 | (30) | Yes | |
| APPLICATION_ID | NUMBER | (15) | ||
| ASSIGNMENT_ID | NUMBER | (10) | Yes | |
| ASSIGNMENT_ORGANIZATION_ID | NUMBER | (15) | Yes | |
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
| GRADE_ID | NUMBER | (15) | ||
| JOB_ID | NUMBER | (15) | ||
| LOCATION_ID | NUMBER | (15) | ||
| PAYROLL_ID | NUMBER | (9) | ||
| PERIOD_OF_SERVICE_ID | NUMBER | (15) | ||
| PEOPLE_GROUP_ID | NUMBER | (15) | ||
| PERSON_ID | NUMBER | (10) | Yes | |
| PERSON_TYPE_ID | NUMBER | (15) | Yes | |
| POSITION_ID | NUMBER | (15) | ||
| RECRUITMENT_ACTIVITY_ID | NUMBER | (15) | ||
| SALARY_BASIS_ID | NUMBER | (9) | ||
| SUPERVISOR_ID | NUMBER | (10) | ||
| VACANCY_ID | NUMBER | (15) | ||
| COLLECTIVE_AGREEMENT_ID | NUMBER | (9) | ||
| PEO_LAST_UPDATE_DATE | DATE | Last Update Date WHO column from per_all_people_f | ||
| ASG_LAST_UPDATE_DATE | DATE | Last Update Date WHO column from per_all_assignments_f | ||
| PEO_LAST_UPDATED_BY | NUMBER | (15) | ||
| ASG_LAST_UPDATED_BY | NUMBER | (15) |
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;
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
|
|
|
|