[Home] [Help] [Dependency Information]

VIEW: APPS.HRBV_PEOPLE_ASSIGNMENT

Object Details

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view

Shared HRMS base view on PER_ALL_PEOPLE_F f and PER_ASSIGNMENTS_F for use in Discoverer shared HRMS end user layer

[View Source]

Columns

Query Text

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

SELECT RECORD_START_DATE
,      RECORD_END_DATE
,      PERSON_START_DATE
,      PERSON_END_DATE
,      PERSON_NAME
,      ORDER_NAME
,      EMPLOYEE_NUMBER
,      TITLE
,      MIDDLE_NAMES
,      PREFERRED_NAME
,      FIRST_NAME
,      LAST_NAME
,      PREFIX
,      SUFFIX
,      GENDER
,      PREVIOUS_LAST_NAME
,      REGISTERED_DISABLED
,      DATE_OF_BIRTH
,      TOWN_OF_BIRTH
,      MARITAL_STATUS
,      NATIONALITY
,      NATIONAL_IDENTIFIER
,      APPLICANT_NUMBER
,      CONTINGENT_NUMBER
,      EMAIL_ADDRESS
,      MAIL_DESTINATION
,      SECOND_PASSPORT
,      OFFICE_NUMBER
,      INTERNAL_LOCATION
,      MAILSTOP
,      WORK_SCHEDULE
,      WORK_TELEPHONE
,      FTE_CAPACITY
,      RESUME_EXISTS
,      RESUME_LAST_UPDATED
,      CURRENT_APPLICANT_FLAG
,      CURRENT_EMPLOYEE_FLAG
,      CURRENT_EMP_OR_APL_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
,      BACKGROUND_CHECK_STATUS
,      BACKGROUND_DATE_CHECK
,      REHIRE_AUTHORIZOR
,      REHIRE_RECOMMENDATION
,      REHIRE_REASON
,      BLOOD_TYPE
,      LAST_MEDICAL_TEST_BY
,      LAST_MEDICAL_TEST_DATE
,      ORIGINAL_DATE_OF_HIRE
,      COORD_BEN_MED_PLN_NO
,      COORD_BEN_NO_CVG_FLAG
,      COORD_BEN_MED_PL_NAME
,      COORD_BEN_MED_INSR_CRR_NAME
,      COORD_BEN_MED_INSR_CRR_IDENT
,      COORD_BEN_MED_EXT_ER
,      COORD_BEN_MED_CVG_STRT_DT
,      COORD_BEN_MED_CVG_END_DT
,      DPDNT_ADOPTION_DATE
,      DPDNT_VLNTRY_SVCE_FLAG
,      RECEIPT_OF_DEATH_CERT_DATE
,      USES_TOBACCO_FLAG
,      _DF:APD
,      ASSIGNMENT_START_DATE
,      ASSIGNMENT_END_DATE
,      ASSIGNMENT_NUMBER
,      ASSIGNMENT_TITLE
,      ASSIGNMENT_SEQUENCE
,      DATE_PROBATION_END
,      CHANGE_REASON
,      INTERNAL_ADDRESS_LINE
,      PROJECT_TITLE
,      TIME_NORMAL_START
,      TIME_NORMAL_FINISH
,      NOTICE_PERIOD
,      NOTICE_PERIOD_UOM
,      WORK_AT_HOME
,      BARGAINING_UNIT
,      LABOUR_UNION_MEMBER_FLAG
,      PERIOD_OF_PLACEMENT_DATE_START
,      PROBATION_PERIOD
,      PROBATION_UNIT
,      SAL_REVIEW_PERIOD
,      SAL_REVIEW_PERIOD_FREQUENCY
,      PERF_REVIEW_PERIOD
,      PERF_REVIEW_PERIOD_FREQUENCY
,      PRIMARY_FLAG
,      MANAGER_FLAG
,      EMPLOYEE_CATEGORY
,      ASSIGNMENT_TYPE
,      ASSIGNMENT_CATEGORY
,      EMPLOYMENT_CATEGORY
,      NORMAL_HOURS
,      NORMAL_HOURS_FREQUENCY
,      SOURCE_TYPE
,      _DF:AAD
,      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
,      FAST_PATH_EMPLOYEE_CODE
,      ON_MILITARY_SERVICE_CODE
,      VENDOR_EMPLOYEE_NUMBER
,      VENDOR_ASSIGNMENT_NUMBER
,      JOB_POST_SOURCE_NAME
,      CHANGE_REASON_CODE
,      NOTICE_PERIOD_UOM_CODE
,      WORK_AT_HOME_CODE
,      BARGAINING_UNIT_CODE
,      HOURLY_SALARIED_CODE
,      LABOUR_UNION_MEMBER_FLAG_CODE
,      PROBATION_UNIT_CODE
,      SAL_REVIEW_PERIOD_FREQ_CODE
,      PERF_REVIEW_PERIOD_FREQ_CODE
,      PRIMARY_FLAG_CODE
,      MANAGER_FLAG_CODE
,      EMPLOYMENT_CATEGORY_CODE
,      ASSIGNMENT_TYPE_CODE
,      FREQUENCY_CODE
,      SOURCE_TYPE_CODE
,      PEO_BUSINESS_GROUP_ID
,      PERSON_ID
,      GLOBAL_PERSON_ID
,      PARTY_ID
,      PERSON_TYPE_ID
,      PEO_COMMENT_ID
,      PEO_VENDOR_ID
,      BENEFIT_GROUP_ID
,      ASSIGNMENT_ID
,      ASG_BUSINESS_GROUP_ID
,      ASSIGNMENT_STATUS_TYPE_ID
,      GRADE_ID
,      JOB_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      PAYROLL_ID
,      PERIOD_OF_SERVICE_ID
,      POSITION_ID
,      PEOPLE_GROUP_ID
,      SOFT_CODING_KEYFLEX_ID
,      PAY_BASIS_ID
,      SUPERVISOR_ID
,      VACANCY_ID
,      RECRUITER_ID
,      PERSON_REFERRED_BY_ID
,      RECRUITMENT_ACTIVITY_ID
,      SPECIAL_CEILING_STEP_ID
,      SOURCE_ORGANIZATION_ID
,      APPLICATION_ID
,      ASG_COMMENT_ID
,      DEFAULT_CODE_COMB_ID
,      SET_OF_BOOKS_ID
,      CONTRACT_ID
,      COLLECTIVE_AGREEMENT_ID
,      CAGR_ID_FLEX_NUM
,      CAGR_GRADE_DEF_ID
,      ESTABLISHMENT_ID
,      ASG_VENDOR_ID
,      PEO_LAST_UPDATE_DATE
,      PEO_LAST_UPDATED_BY
,      PEO_LAST_UPDATE_LOGIN
,      PEO_CREATED_BY
,      PEO_CREATION_DATE
,      ASG_LAST_UPDATE_DATE
,      ASG_LAST_UPDATED_BY
,      ASG_LAST_UPDATE_LOGIN
,      ASG_CREATED_BY
,      ASG_CREATION_DATE
,      BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_PEOPLE_ASSIGNMENT;

Dependencies

[top of page]

APPS

HR_BIS - show dependent code

HR_GENERAL - show dependent code

HR_SECURITY - show dependent code

PER_ALL_PEOPLE_F

PER_ASSIGNMENTS_F

APPS.HRBV_PEOPLE_ASSIGNMENT is not referenced by any database object