PER Views (700)

PER - Human Resources — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

ViewDescription
AME_TRANSACTION_TYPES_V List AME Transaction Types
BEN_BENEFICIARIES Date-effective view.
BEN_BENEFICIARIES_V Used to support user interface
BEN_BENEFICIARIES_X Date-effective view.
BEN_BENEFIT_CONTRIBUTIONS Date-effective view.
BEN_BENEFIT_CONTRIBUTIONS_D Used by Datetrack History
BEN_BENEFIT_CONTRIBUTIONS_X Date-effective view.
BEN_COVERED_DEPENDENTS Date-effective view.
BEN_COVERED_DEPENDENTS_V Used to support user interface
BEN_COVERED_DEPENDENTS_X Date-effective view.
EDWBV_HR_BUSINESS_GROUPS_LCV
EDWBV_HR_LEGAL_ENTITIES_LCV
EDWBV_HR_OPERATING_UNITS_LCV
EDWBV_ORGANIZATION_LCV
EDW_HR_BUSINESS_GROUPS_LCV
EDW_HR_LEGAL_ENTITIES_LCV
EDW_HR_OPERATING_UNITS_LCV
EDW_HR_PERSON_ASSIGNMENTS_LCV
EDW_HR_PERSON_PERSONS_LCV
EDW_ORGANIZATION_LCV
HRBV_BACKFEED_BALANCE_ELEMENTS
HRBV_ORGANIZATION_DESCENDENTS - Retrofitted
HRBV_POSITION_DESCENDENTS - Retrofitted
HRFV_ABSENCES Business view template from which the flexfield view is generated.
HRFV_ACCRUAL_PLAN_ENROLLMENTS Business view template from which the flexfield view is generated.
HRFV_ACCRUAL_VALUES Business view template from which the flexfield view is generated.
HRFV_ADA_DISABILITIES Business view template from which the flexfield view is generated.
HRFV_ADA_DIS_ACCOMMODATIONS Business view template from which the flexfield view is generated.
HRFV_ADDRESSES Business view template from which the flexfield view is generated.
HRFV_ASSIGNMENT_COSTS Business view template from which the flexfield view is generated.
HRFV_BACKFEED_BALANCE_AMOUNTS Business view template from which the flexfield view is generated.
HRFV_BACKFEED_PAYMENT_DETAILS Business view template from which the flexfield view is generated.
HRFV_BENEFIT_ENROLLMENTS Business view template from which the flexfield view is generated.
HRFV_BUSINESS_GROUPS Business view template from which the flexfield view is generated.
HRFV_COMPETENCE_PROFILES Business view template from which the flexfield view is generated.
HRFV_CONTACTS Business view template from which the flexfield view is generated.
HRFV_CURRENT_SALARIES Business view template from which the flexfield view is generated.
HRFV_DEF_BENEFIT_CONTRIBUTIONS Business view template from which the flexfield view is generated.
HRFV_DEPLOYMENT_FACTORS Business view template from which the flexfield view is generated.
HRFV_DETAILED_SPECIAL_INFO Business view template from which the flexfield view is generated.
HRFV_EMPLOYEE_ASSIGNMENTS Business view template from which the flexfield view is generated.
HRFV_GB_ADDRESSES Business view template from which the flexfield view is generated.
HRFV_GB_DIRECT_DEPOSITS Business view template from which the flexfield view is generated.
HRFV_GB_LOCATIONS Business view template from which the flexfield view is generated.
HRFV_GB_PERSONAL_DETAILS Business view template from which the flexfield view is generated.
HRFV_GRADES Business view template from which the flexfield view is generated.
HRFV_GRADE_HISTORY Business view template from which the flexfield view is generated.
HRFV_GRADE_RATES Business view template from which the flexfield view is generated.
HRFV_GRADE_RATE_ASGS_BG Business view template from which the flexfield view is generated.
HRFV_GRADE_SCALES Business view template from which the flexfield view is generated.
HRFV_GRADE_STEPS Business view template from which the flexfield view is generated.
HRFV_GRADE_STEP_PLACEMENTS Business view template from which the flexfield view is generated.
HRFV_GRD_PLACEMNT_PROG_PT_VALS Business view template from which the flexfield view is generated.
HRFV_GRD_STEP_PLACEMNT_HISTORY Business view template from which the flexfield view is generated.
HRFV_HIRES Business view template from which the flexfield view is generated.
HRFV_HR_ORGANIZATIONS Business view template from which the flexfield view is generated.
HRFV_JOBS Business view template from which the flexfield view is generated.
HRFV_JOB_AND_POS_REQUIREMENTS Business view template from which the flexfield view is generated.
HRFV_JOB_APPLICATIONS Business view template from which the flexfield view is generated.
HRFV_JOB_EVALUATIONS Business view template from which the flexfield view is generated.
HRFV_JOB_HISTORY Business view template from which the flexfield view is generated.
HRFV_LOCATIONS Business view template from which the flexfield view is generated.
HRFV_LOCATION_HISTORY Business view template from which the flexfield view is generated.
HRFV_MANPOWER_BUDGETS Business view template from which the flexfield view is generated.
HRFV_MOVEMENTS_SUMMARY Business view template from which the flexfield view is generated.
HRFV_OPERATING_UNITS Business view template from which the flexfield view is generated.
HRFV_ORGANIZATION_HIERARCHIES Business view template from which the flexfield view is generated.
HRFV_ORGANIZATION_HISTORY Business view template from which the flexfield view is generated.
HRFV_ORGANIZATION_ROLLUP Business view template from which the flexfield view is generated.
HRFV_ORG_CLASSIFICATIONS Business view template from which the flexfield view is generated.
HRFV_OSHA_REPORTABLE_INCIDENTS Business view template from which the flexfield view is generated.
HRFV_PAYROLLS Business view template from which the flexfield view is generated.
HRFV_PAY_METH_NOT_DIR_DEPOSITS Business view template from which the flexfield view is generated.
HRFV_PERSONAL_BACKGROUND_INFO Business view template from which the flexfield view is generated.
HRFV_PERSONAL_DETAILS Business view template from which the flexfield view is generated.
HRFV_PERSONAL_MEDICAL_INFO Business view template from which the flexfield view is generated.
HRFV_PERSONAL_REHIRE_INFO Business view template from which the flexfield view is generated.
HRFV_PERSON_AGE_ANALYSIS Business view template from which the flexfield view is generated.
HRFV_PERSON_ASSIGNMENT_HISTORY Business view template from which the flexfield view is generated.
HRFV_PERSON_SPECIAL_INFO Business view template from which the flexfield view is generated.
HRFV_PHONES Business view template from which the flexfield view is generated.
HRFV_POSITIONS Business view template from which the flexfield view is generated.
HRFV_POSITION_EVALUATIONS Business view template from which the flexfield view is generated.
HRFV_POSITION_HIERARCHIES Business view template from which the flexfield view is generated.
HRFV_POSITION_HISTORY Business view template from which the flexfield view is generated.
HRFV_PROBATIONS Business view template from which the flexfield view is generated.
HRFV_QUALIFICATIONS Business view template from which the flexfield view is generated.
HRFV_RECRUITMENT_ACTIVITIES Business view template from which the flexfield view is generated.
HRFV_REC_ACT_BY_VACANCIES Business view template from which the flexfield view is generated.
HRFV_REQUIRED_COMPETENCES Business view template from which the flexfield view is generated.
HRFV_REVIEWERS Business view template from which the flexfield view is generated.
HRFV_REVIEWS Business view template from which the flexfield view is generated.
HRFV_SALARIES Business view template from which the flexfield view is generated.
HRFV_SALARY_COMPONENTS Business view template from which the flexfield view is generated.
HRFV_SALARY_PRO Business view template from which the flexfield view is generated.
HRFV_SALARY_SURVEY_MAPPINGS Business view template from which the flexfield view is generated.
HRFV_SCHOOLS_AND_COLLEGES Business view template from which the flexfield view is generated.
HRFV_SCHOOL_COLL_ATTENDANCES Business view template from which the flexfield view is generated.
HRFV_SUBJECTS Business view template from which the flexfield view is generated.
HRFV_SUPERVISORS Business view template from which the flexfield view is generated.
HRFV_TERMINATIONS Business view template from which the flexfield view is generated.
HRFV_TIME_IN_SERVICE_ANALYSIS Business view template from which the flexfield view is generated.
HRFV_TRANSFERS_IN Business view template from which the flexfield view is generated.
HRFV_TRANSFERS_OUT Business view template from which the flexfield view is generated.
HRFV_US_ADDRESSES Business view template from which the flexfield view is generated.
HRFV_US_DIRECT_DEPOSITS Business view template from which the flexfield view is generated.
HRFV_US_JOBS Business view template from which the flexfield view is generated.
HRFV_US_LOCATIONS Business view template from which the flexfield view is generated.
HRFV_US_PERSONAL_DETAILS Business view template from which the flexfield view is generated.
HRFV_VACANCIES Business view template from which the flexfield view is generated.
HRFV_VALID_GRADES Business view template from which the flexfield view is generated.
HRFV_WORKFORCE_BUDGETS Business view template from which the flexfield view is generated.
HRU_JP_CREATE_EDUC_ADD This view is Japanaes specific.
HRU_SALARY_PROPOSALS Lists salary proposals including their components, also used to upload slary proposals via ADE.
HR_AAP_ORGANIZATIONS_V Used to support user interface
HR_ADMIN_LOV_V Hr Web Offers list of values view
HR_ADP_ACCRUAL_PLAN_V ADP payroll interface view
HR_ADP_ADDRESS_V ADP payroll interface view
HR_ADP_ASSIGNMENT_V ADP payroll interface view
HR_ADP_BENEFIT_V ADP payroll interface view
HR_ADP_CITY_TAX_V ADP payroll interface view
HR_ADP_COSTING_V ADP payroll interface view
HR_ADP_DEDUCTION_V ADP payroll interface view
HR_ADP_EFT_V ADP payroll interface view
HR_ADP_ELE_COSTING_V ADP payroll interface view
HR_ADP_EMPLOYEE_V ADP payroll interface view
HR_ADP_EMP_REF_V ADP payroll interface view
HR_ADP_FED_TAX_V ADP payroll interface view
HR_ADP_GRE_LIST_V ADP payroll interface view
HR_ADP_GTL_V ADP payroll interface view
HR_ADP_OAB_BENEFIT_V ADP payroll interface view
HR_ADP_PAYMENT_METHODS_V
HR_ADP_RESIDENT_STATE_TAX_V ADP payroll interface view
HR_ADP_SPOUSE_V ADP payroll interface view
HR_ADP_STATE_TAX_CODES_V ADP payroll interface view
HR_ADP_STATE_TAX_V ADP payroll interface view
HR_ADP_WORKERS_COMP_V ADP payroll interface view
HR_ADP_WORK_STATE_TAX_V ADP payroll interface view
HR_ALL_ORGANIZATION_UNITS_VL multi lingual view of organizations
HR_ALL_POSITIONS Date-effective view.
HR_ALL_POSITIONS_D Used by DateTrack history.
HR_ALL_POSITIONS_F_VL
HR_ALL_POSITIONS_V1 Date-effective view with reduced pl/sql functions for performance.
HR_ASSIGNMENT_NUM_LOV Used to support user interface
HR_ASSIGNMENT_SETS_V Used to support user interface
HR_ASSIGNMENT_SET_AMENDMENTS_V Used to support user interface
HR_ASSIGNMENT_SET_CRITERIA_V Used to support user interface
HR_ASSIGN_BASE_V Used to support user interface
HR_ASSIGN_LOV_V Used to support user interface
HR_ATH_DEPENDENT_V View to support Authoria Integration
HR_ATH_ELIGIBLE_ALL_PLANS_V View to support Authoria Integration
HR_ATH_EMPGROUP_V View to support Authoria Integration
HR_ATH_EMPLOYEE_V View to support Authoria Integration
HR_ATH_EMPLOYER_V View to support Authoria Integration
HR_ATH_ENROLL_ALL_PLANS_V View to support Authoria Integration
HR_AU_LEG_EMP_V
HR_BARGAINING_UNITS_V HR_BARGAINING_UNITS_V lists the organizations which have been identified as Bargaining Units.
HR_BENEFITS_CARRIERS_V Used to support user interface
HR_BILLING_LOCATIONS_PO_V Used to support user interface
HR_CALENDARS_V Used to support user interface
HR_CALENDAR_ENTITY_KEYS_V Used to support user interface
HR_CALENDAR_EXCEPTIONS_V Used to support user interface
HR_CALENDAR_USAGES_V Used to support user interface
HR_CAL_PEOPLE_KEYS_V Used to support user interface
HR_CA_CITIES_LOV_V View to retrieve data for web LOV for CA Cities.
HR_CA_CITY_BASE_V This dummy view contains one ID column for use by Object Navigator in creation of an LOV base Object.
HR_CA_TAX_UNITS_V
HR_CERIDIAN_500_ALT_RATES_V Ceridian Source 500 payroll interface view
HR_CERIDIAN_500_ASSIGNMENT_V Ceridian Source 500 payroll interface view
HR_CERIDIAN_500_BENEFIT_V Ceridian Source 500 payroll interface view
HR_CERIDIAN_500_DEDUCTION_V Ceridian Source 500 payroll interface view
HR_CERIDIAN_500_EFT_V Ceridian Source 500 payroll interface view
HR_CERIDIAN_500_EMPLOYEE_V Ceridian Source 500 payroll interface view
HR_CERIDIAN_500_MISC_V Ceridian Source 500 payroll interface view
HR_CERIDIAN_500_OAB_BENEFIT_V Ceridian Source 500 payroll interface view
HR_CERIDIAN_500_OAB_EE_V Ceridian Source 500 payroll interface view
HR_CERIDIAN_500_OAB_ER_V Ceridian Source 500 payroll interface view
HR_CERIDIAN_500_RESIDENT_TAX_V Ceridian Source 500 payroll interface view
HR_CERIDIAN_500_SELECTION_V Ceridian Source 500 payroll interface view
HR_CERIDIAN_500_SEL_PAYROLL_V Ceridian Source 500 payroll interface view
HR_CERIDIAN_500_SPOUSE_V Ceridian Source 500 payroll interface view
HR_CERIDIAN_500_WORK_TAX_V Ceridian Source 500 payroll interface view
HR_CERIDIAN_ASSIGNMENT_V Ceridian Source 100 payroll interface view
HR_CERIDIAN_BENEFIT_V Ceridian Source 100 payroll interface view
HR_CERIDIAN_DEDUCTION_V Ceridian Source 100 payroll interface view
HR_CERIDIAN_EFT_V Ceridian Source 100 payroll interface view
HR_CERIDIAN_EMPLOYEE_ONLY_V Ceridian Source 100 payroll interface view
HR_CERIDIAN_OAB_BENEFIT_V Ceridian Source 100 payroll interface view
HR_CERIDIAN_RESIDENT_TAX_V Ceridian Source 100 payroll interface view
HR_CERIDIAN_SECONDARY_STATE_V Ceridian Source 100 payroll interface view
HR_CERIDIAN_SPOUSE_V Ceridian Source 100 payroll interface view
HR_COMPANY_COST_CENTERS
HR_COMPANY_VS_V Used to support user interface
HR_COMPONENTLESS_PATTERNS_V Used to support user interface
HR_COST_CENTER_VS_V
HR_CURRENT_PEOPLE_LOV_V Used to support user interface.
HR_DE_ASG_TAX_BATCH_UPD_V Tax Batch update view
HR_DE_LIABILITY_PREMIUMS Displays Liability Premium Rates for a particular Internal and External Org(Liab Prov) relationship
HR_DE_ORGANIZATION_LINKS_V1 Displays all links of type 'DE_SOCIAL_INSURANCE' for an Internal organization
HR_DE_ORGANIZATION_LINKS_V2 Displays all links of type 'DE_LIABILITY_INSURANCE' for an Internal organization
HR_DE_ORGANIZATION_LINKS_V3 Displays all other misc links for an Internal organization
HR_DE_ORG_LINK_TYPES_MAPPING View on User table structure for mapping German Org_classes to Org_link_types
HR_DE_SOCIAL_INSURANCE_INFO_V View based on Element Entry tables for German Social Insurance records
HR_DE_SOCINS_PROV_DEFINITION_V View based on User tables for easy viewing of Social Insurance Provider Information
HR_DE_SOC_INS_ADD_INF_TYPES_V Holds organization info types for Germany
HR_DE_SOC_INS_CONTR_LVLS_V Holds contribution level information for German Insurance providers.
HR_DE_SOC_INS_ORG_INFO_V Holds information relating to German Insurance Providers.
HR_DE_TAX_EXEMPTIONS_V View for german Tax exemptions in the form of Elements
HR_DE_TAX_INFORMATION_V View for german Tax information in the form of Elements
HR_DE_TAX_OFFICES_LOV View for german Tax offices stored as Organizations
HR_DE_TAX_OFFICE_DEFINITION_V View based on User tables for easy viewing of Tax office(recorded as Orgs) Information
HR_DE_WORK_INCIDENTS_REPORT View for German Work Incidents reporting based on PER_WORK_INCIDENTS and server side functions
HR_DM_AOL_DOWN_V This view holds the AOL loader plus parameters used during the AOL download phase.
HR_DM_AOL_FILES_V This view holds the information about each AOL loader / configuration file / parameter set that has been used in the AOL download phase alon
HR_DM_EXP_ALL_ORG_UNITS_TL_V View to export Org information
HR_DM_EXP_ALL_ORG_UNITS_V View to export Org information
HR_DM_EXP_API_MODULES_V View to export hr_api_modules information
HR_DM_EXP_BEN_BATCH_PARAS_V View to export ben_batch_parameters
HR_DM_EXP_HR_LOC_ALL_TL_V View to export hr_locations_all_tl
HR_DM_EXP_HR_LOC_ALL_V View to export hr_locations_all
HR_DM_EXP_HR_ORG_INF_FLX_V View to export hr_org_inf_flx
HR_DM_EXP_MIGRATIONS_V View to export hr_dm_migrations
HR_DM_EXP_ORG_INFO_V View to export hr_organization_information
HR_DM_FND_USERS_V1 View on fnd_users
HR_DM_FND_USERS_V2 View on fnd_users
HR_DM_MIGRATIONS_V View to support DM UI - hr_dm_migrations
HR_DM_MIGRATION_RANGES_V View to support DM UI - hr_dm_migration_ranges
HR_DM_MIGRATION_REQUESTS_V View to support DM UI - hr_dm_migration_requests
HR_DM_MIGRATION_SUMMARY_V View to support DM UI
HR_DM_PHASES_V View to support DM UI - hr_dm_phases
HR_DM_PHASE_ITEMS_V View to support DM UI - hr_dm_phase_items
HR_DOCUMENT_TYPES_V Translated view of Document Types.
HR_DTR_APPLICATION_LIST_V Downtime Reduction application list view
HR_EMPLOYEE_API_V
HR_EMPLOYEE_ASSIGNMENTS_V
HR_EMPLOYERS_V HR_EMPLOYERS_V lists the organizations which have been identified as Employers.
HR_ESTABLISHMENTS_V Used to support user interface
HR_ESTAB_COLL_AGRS_V HR_ESTAB_COLL_AGRS_V lists the Collective Agreements applicable in an establishment
HR_FEDREP_V View for VETS/EEO on Generic Hierarchy
HR_FNDSCAUS_PERSON_LOV_V To support person lov in aol define user form (FNDSCAUS)
HR_FNDSCAUS_PERSON_V To support person lov in aol define user form (FNDSCAUS)
HR_FORM_CANVASES View of canvas definition and translated properties
HR_FORM_CANVASES_VL Translated view from HR_FORM_CANVASES_B and HR_FORM_CANVASES_TL
HR_FORM_DATA_GROUPS_VL Translated view from HR_FORM_DATA_GROUPS_B and HR_FORM_DATA_GROUPS_TL
HR_FORM_ITEMS View of item definitions and translated properties
HR_FORM_ITEMS_VL Translated view from HR_FORM_ITEMS_B and HR_FORM_ITEMS_TL
HR_FORM_TAB_PAGES View of tab page definitions and translated properties
HR_FORM_TAB_PAGES_VL Translated view of HR_FORM_TAB_PAGES_B and HR_FORM_TAB_PAGES_TL
HR_FORM_TEMPLATES View of form properties and template definition
HR_FORM_TEMPLATES_VL Translated view of HR_FORM_TEMPLATES_B and HR_FORM_TEMPLATES_TL
HR_FORM_WINDOWS View of window defintions and translated properties
HR_FORM_WINDOWS_VL Translated view of HR_FORM_WINDOWS_B and HR_FORM_WINDOWS_TL
HR_FR_ALTERNATE_LOOKUPS
HR_FR_ASSEDIC_CENTERS_V
HR_FR_COMPANIES_V
HR_FR_COMP_INSURANCE_PRVS_V
HR_FR_COMP_PENSION_PRVS_V
HR_FR_CPAM_V
HR_FR_ESTABLISHMENTS_V HR_FR_ESTABLISHMENTS_V lists the French organizations which have been identified as Establishments.
HR_FR_ESTAB_COLL_AGRS_V
HR_FR_ESTAB_DADS_FILES_V
HR_FR_ESTAB_DADS_TYPES_V
HR_FR_ESTAB_INSURANCE_PRVS_V
HR_FR_ESTAB_PENSION_PRVS_V
HR_FR_INSURANCE_PROVIDERS_V
HR_FR_OPACIF_V
HR_FR_OPCA_V
HR_FR_PENSION_GROUPS_V
HR_FR_PENSION_PROVIDERS_V
HR_FR_PENSION_PRV_GRP_V
HR_FR_URSSAF_CENTERS_V
HR_GRADE_BASE_V
HR_GRADE_JOB_BASE_V
HR_GRADE_JOB_LOV_V
HR_GRADE_JPG_BASE_V
HR_GRADE_JPG_LOV_V
HR_GRADE_LOV_V
HR_GRADE_POS_BASE_V
HR_GRADE_POS_LOV_V
HR_H2PI_ADDRESSES_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) addresses
HR_H2PI_ASSIGNMENTS_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for assignments
HR_H2PI_BG_AND_GRE_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for business groups and GREs
HR_H2PI_CITY_TAX_RULES_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US City Tax Rules
HR_H2PI_COST_ALLOCATIONS_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for cost allocations
HR_H2PI_COUNTY_TAX_RULES_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US county tax rules
HR_H2PI_ELEMENT_ENTRIES_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for element entries
HR_H2PI_ELEMENT_ENTRY_VALUES_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for element entry values
HR_H2PI_ELEMENT_LINKS_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for element links
HR_H2PI_ELEMENT_NAMES_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for element names
HR_H2PI_ELEMENT_TYPES_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for element types
HR_H2PI_EMPLOYEES_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for employees
HR_H2PI_FEDERAL_TAX_RULES_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US federal tax rules
HR_H2PI_HR_ORGANIZATIONS_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for HR organizations
HR_H2PI_INPUT_VALUES_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for input values
HR_H2PI_LOCATIONS_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for locations
HR_H2PI_ORGANIZATION_CLASS_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for organization classes
HR_H2PI_ORGANIZATION_INFO_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for organization info
HR_H2PI_ORG_PAYMENT_METHODS_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for organization payment methods
HR_H2PI_PATCH_STATUS_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for patch status
HR_H2PI_PAYMENT_METHODS_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for payment methods
HR_H2PI_PAYROLLS_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for payrolls
HR_H2PI_PAY_BASES_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for pay bases
HR_H2PI_PERIODS_OF_SERVICE_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for periods of service
HR_H2PI_SALARIES_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for salaries
HR_H2PI_STATE_TAX_RULES_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US state tax rules
HR_H2PI_US_CITY_NAMES_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US city names
HR_H2PI_US_MODIFIED_GEOCODES_V Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US midfied geocodes
HR_HEADQUARTERS_V Used to support user interface
HR_HIER_ASG_PEOPLE_V
HR_HIER_ORG_PEOPLE_V
HR_HIER_POS_PEOPLE_V People with position details and place in position hierarchy
HR_HIER_SUPER_PEOPLE_V View of people and assignments
HR_HK_LEGAL_EMPLOYER_V
HR_HK_MPF_TRUSTEE_V MPF Trustee view
HR_ITEM_PROPERTIES_VL Translated view of HR_ITEM_PROPERTIES_B and HR_ITEM_PROPERTIES_TL
HR_JOBS_LOV_V HR Web Offers List of Values view
HR_KR_ESTABLISHMENTS_V This view is used to validate PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID for Korea localization.
HR_LEGAL_ENTITIES Used in US localizations to reflect the common organization structure Legal Entity/Company/Tax Unit.
HR_LEG_LOOKUPS HRMS specific view based on FND_LOOKUP_TYPES and FND_LOOKUP_VALUES with legislation sensitivity.
HR_LOCATIONS HRMS Locations
HR_LOCATIONS_ALL_LOV_V HR Web Offers Location list of values view.
HR_LOCATIONS_ALL_PO_V Used to support user interface
HR_LOCATIONS_ALL_V
HR_LOCATIONS_ALL_VL
HR_LOCATIONS_LOV_V HR Web Offers list of values view.
HR_LOCATIONS_NO_JOIN USed to support user interface.
HR_LOCATIONS_V Used to support user interface
HR_LOC_BASE_V
HR_LOC_LOV_V
HR_LOOKUPS HRMS specific view based on FND_LOOKUP_TYPES and FND_LOOKUP_VALUES.
HR_NAVIGATION_UNITS_V The view is used in the "Define Navigation Units" form.
HR_NCU_CURRENCIES
HR_NUSJOB_BASE_V
HR_NUSJOB_LOV_V
HR_NZ_TAX_UNIT_V
HR_OPERATING_UNITS Information about operating units.
HR_ORGANIZATION_INFORMATION_V Used to support user interface
HR_ORGANIZATION_INFORMATION_V1 German HR Organization information view for ORG_INFORMATION_CONTEXT = 'DE_HR_ORG_INFO'
HR_ORGANIZATION_LOV_V HR Web Offers list of values view.
HR_ORGANIZATION_UNITS Secure view based on the corresponding _ALL_ table.
HR_ORGANIZATION_UNITS_V Used to support user interface
HR_ORGANIZATION_UNITS_V_TL Used to support MLS interface
HR_ORGANIZATION_VAC_LOV_V
HR_ORG_UNITS_NO_JOIN Used to support user interface for MLS
HR_OWNER_DEFINITIONS_V - Retrofitted
HR_PATTERN_BITS_V Used to support user interface
HR_PATTERN_CONSTRUCTIONS_V Used to support user interface
HR_PATTERN_EXCEPTIONS_V Used to support user interface
HR_PATTERN_PURPOSES_V Used to support user interface
HR_PAY_INTERFACE_OAB_OPTION_V Payroll interface toolkit view
HR_PAY_INTERFACE_OAB_VALUE1_V
HR_PAY_INTERFACE_OAB_VALUE2_V
HR_PAY_INTERFACE_OAB_VALUE_V Payroll interface toolkit view
HR_PERSON_LEGISLATION_V
HR_POSITIONS Date-effective view based on secured positions view.
HR_POSITIONS_F Secure view based on the corresponding _ALL_ table.
HR_POSITIONS_LOV_V Used to get list of value on Mass Move form.
HR_POSITIONS_V To support User Interface.
HR_POSITIONS_V1 To support User Interface.
HR_POSITIONS_X Date-effective view based on secured positions view.
HR_POSITION_API_V
HR_POS_BASE_V
HR_POS_LOV_V
HR_SCHEDULER_V Used to support user interface
HR_SG_LEG_ENT_V
HR_STANDARD_LOOKUPS HRMS specific view based on FND_LOOKUP_TYPES and FND_LOOKUP_VALUES.
HR_SUMMARY_ITEM_TYPE HR_SUMMARY_ITEM_TYPE will hold the name of each of the summary data items. In addition each item type stores the default SQL statement this
HR_SUMMARY_ITEM_TYPE_USAGE HR_SUMMARY_ITEM_TYPE_USAGE identifies the items that will be used by a template every time the GSP process is run.
HR_SUMMARY_ITEM_VALUE HR_SUMMARY_ITEM_VALUE stores the summary data values. The data item can either be stored as a numeric, date or text value.
HR_SUMMARY_KEY_TYPE HR_SUMMARY_KEY_TYPE stores all key types available to the GSP. When the GSP is run a SQL statement is constructed and run. It is possible to
HR_SUMMARY_KEY_TYPE2
HR_SUMMARY_KEY_TYPE_USAGE HR_SUMMARY_KEY_TYPE_USAGE stores records which identify the particular key types which should be included within the SQL statement generated
HR_SUMMARY_KEY_VALUE HR_SUMMARY_KEY_VALUE stores the values of the ''key types'' which identify the summary data items. For instance a total headcount data item
HR_SUMMARY_KEY_VALUES_BAND_V This view provides data from the HR_SUMMARY table for the Generic Summary Process forms.
HR_SUMMARY_KEY_VALUES_ESTAB_V View based on HR_SUMMARY_KEY_VALUE, HR_SUMMARY_KEY_TYPE and hr_all_organization_units.
HR_SUMMARY_KEY_VALUES_LOOKUP_V HR_SUMMARY_KEY_VALUES_LOOKUP_V is a join between HR_SUMMARY_KEY_VALUE and HR_SUMMARY_KEY_TYPE.
HR_SUMMARY_KEY_VALUES_V This holds the key types and values from HR_SUMMARY_KEY_VALUES and HR_SUMMARY_KEY_TYPES.
HR_SUMMARY_PARAMETER HR_SUMMARY_PARAMETER stores parameters which have been identified in the concurrent manager and have been passed to the GSP during a process
HR_SUMMARY_PROCESS_RUN HR_SUMMARY_PROCESS_RUN holds the details of each template that is run through the GSP.
HR_SUMMARY_RESTRICTION_TYPE HR_SUMMARY_RESTRICTION_TYPE stores all restrictions that can be applied to an item type.
HR_SUMMARY_RESTRICTION_USAGE HR_SUMMARY_RESTRICTION_USAGE holds records which identify the particular restrictions which should be included within the SQL statement gene
HR_SUMMARY_RESTRICTION_VALUE HR_SUMMARY_RESTRICTION_VALUE holds records for each restriction used by item type in a given template.
HR_SUMMARY_RUN
HR_SUMMARY_RUN_PARAMETER_VALUE
HR_SUMMARY_RUN_VALUES_V This is a join between HR_SUMMARY_PROCESS_RUN, HR_SUMMARY_ITEM_USAGE, HR_SUMMARY_ITEM_VALUE.
HR_SUMMARY_RUN_VALUES_X2_V This view provides the run values available in the HR_SUMMARY table
HR_SUMMARY_TEMPLATE HR_SUMMARY_TEMPLATE stores all the details of each template used by the GSP.
HR_SUMMARY_VALID_KEY_TYPE HR_SUMMARY_VALID_KEY_TYPE stores a record of those key types which may be used by a particular item type
HR_SUMMARY_VALID_RESTRICTION HR_SUMMARY_VALID_RESTRICTION stores the restrictions that apply to a single item type within a template.
HR_SUP_BASE_V Used to support user interface.
HR_SUP_LOV_V Used to support user interface.
HR_TAB_PAGE_PROPERTIES_VL
HR_TAX_UNITS_V Used to support user interface
HR_TEMPLATE_CANVASES View of template canvas definitions and translated properties
HR_TEMPLATE_ITEMS View of template item definition and translated properties
HR_TEMPLATE_ITEM_CONTEXTS View of template item definition and translated properties for a specific context
HR_TEMPLATE_TAB_PAGES View of template tab page definitions and translated properties
HR_TEMPLATE_WINDOWS View of template window definition and translated properties
HR_TERRITORIES_V Used to support user interface
HR_USAGE_EXCEPTIONS_V Used to support user interface
HR_USJOB_BASE_V US specific view Retrieve jobs and FLSA status
HR_USJOB_LOV_V US specific view Retrieve jobs and FLSA status
HR_USORG_BASE_V
HR_USORG_LOV_V
HR_US_CITIES_LOV_V View to retrieve data for web LOV for US Cities.
HR_US_CITY_BASE_V This dummy view contains one ID column for use by Object Navigator in creation of an LOV base Object.
HR_WINDOW_PROPERTIES_VL Translated view of HR_WINDOW_PROPERTIES_B and HR_WINDOW_PROPERTIES_TL
HR_WORKING_PERSON_LISTS_V Used to support user interface
HR_WORKSITE_V Used to support user interface
IRC_ALL_RECRUITING_SITES_VL This is the translated view for recruiting sites
IRC_DEFAULT_POSTINGS_VL
IRC_POSTING_CONTENTS_VL
IRC_REGISTERED_USERS
PAY_PAYAUTAX_AUS_INF_V
PAY_PAYAUTAX_SPR_ENT_V
PER_ABSENCE_ATTENDANCES_V Employee periods of absence.
PER_ABSENCE_ATTENDANCES_V2 List of employees by absence type.
PER_ABSENCE_ATTENDANCES_V3 History of periods of absence for employees.
PER_ABS_ATTENDANCE_TYPES_V User defined absence types.
PER_ABS_ATTENDANCE_TYPES_VL View of Absence Type Information in the user session language
PER_ADDRESSES_V Used to support user interface
PER_ALL_ASSIGNMENTS Date-effective view.
PER_ALL_ASSIGNMENTS_D Used by Datetrack History
PER_ALL_ASSIGNMENTS_V Used to support user interface
PER_ALL_ORGANIZATION_UNITS Unsecured version of PER_ORGANIZATION_UNITS.
PER_ALL_PEOPLE Date-effective view.
PER_ALL_PEOPLE_D Used by Datetrack History
PER_ALL_WORKFORCE_V View of employees, and contingent workers if profile option setup permits
PER_APPLICATIONS_V Used to support user interface
PER_APPRAISAL_TEMPLATES_V Used to support user interface
PER_APP_ASGS_V Used to support user interface
PER_ASSESSMENT_TYPES_V Used to support user interface
PER_ASSIGNMENTS Date-effective view.
PER_ASSIGNMENTS_F Secure view based on the corresponding _ALL_ table.
PER_ASSIGNMENTS_F2 Secure view based on the corresponding _ALL_ table.
PER_ASSIGNMENTS_V Used to support user interface
PER_ASSIGNMENTS_V10 Used to support user interface.
PER_ASSIGNMENTS_V11 Used to support user interface
PER_ASSIGNMENTS_V12 as of sysdate view
PER_ASSIGNMENTS_V13 Used to support user interface
PER_ASSIGNMENTS_V2 Used to support user interface
PER_ASSIGNMENTS_V3 Used to support user interface
PER_ASSIGNMENTS_V5 Used to support user interface
PER_ASSIGNMENTS_V7 Used to support user interface
PER_ASSIGNMENTS_V8 Used to support user interface
PER_ASSIGNMENTS_V9 Used to support user interface
PER_ASSIGNMENTS_X as of sysdate view
PER_ASSIGNMENT_BUDGET_VALUES Date effective view.
PER_ASSIGNMENT_BUDGET_VALUES_D Used by DateTrack history.
PER_ASSIGNMENT_BUDGET_VALUES_X Date-effective view.
PER_ASSIGNMENT_HISTORY_VIEW Used to support user interface
PER_ASSIGNMENT_INFO_TYPES_V Used to support user interface
PER_ASSIGNMENT_STATUS_LOV Used to support user interface
PER_ASSIGNMENT_STATUS_TYPES_V Used to support status types table and translated table
PER_BF_BALANCES_V
PER_BF_BALANCE_AMOUNTS_V
PER_BF_BALANCE_AMOUNTS_V2
PER_BF_BALANCE_ELEMENTS_V
PER_BF_BALANCE_TYPES_V
PER_BF_EMPLOYEE_RUN_DETAILS_V
PER_BF_ORG_RUN_DETAILS_V
PER_BF_PAYMENT_DETAILS_V
PER_BF_PAYMENT_DETAILS_V2
PER_BOOKINGS_V Used to support user interface
PER_BOOKINGS_V2 Used to support user interface
PER_BOOKINGS_V3 Used to support user interface
PER_BUDGETS_LOV Used to support user interface
PER_BUDGETS_V Used to support user interface
PER_BUDGET_ELEMENTS_V Used to support user interface
PER_BUDGET_VALUES_V Used to support user interface
PER_BUSINESS_GROUPS View based on HR_ORGANIZATION_UNITS and HR_ORGANIZATION that returns specific information for a Business Group.
PER_BUSINESS_GROUPS_PERF Performance view based on HR_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION
PER_CAGR_ENTITLEMENTS_V
PER_CAGR_ENTITLEMENTS_V2
PER_CAGR_ENTITLEMENT_ITEMS_V Used to suppor Collective Agreements Entitlement Item User Interface
PER_CAGR_ENTITLEMENT_LINES_D
PER_CAGR_ENTITLEMENT_LINES_V
PER_CAGR_ENTITLEMENT_RESULTS_V
PER_CAGR_REFERENCE_GRADES_V
PER_CALENDAR_ENTRIES_V Calendar entries
PER_CAL_ENTRY_VALUES_V Calendar Entry Values
PER_CAL_EVENT_ELIGIBILITY_V Calendar Event Eligibility
PER_CAL_ORG_HIER_VALUES_V per_cal_org_hier_values_v
PER_CAL_SCOPE_VALUES_V
PER_CHECKLIST_ITEMS_V
PER_COBRA_COVERAGE_BENEFITS Date-effective view.
PER_COBRA_COVERAGE_BENEFITS_D Used by Datetrack History
PER_COBRA_COVERAGE_BENEFITS_V Used to support user interface
PER_COBRA_COVERAGE_BENEFITS_X Date-effective view.
PER_COBRA_COVERAGE_STATUSES_V Used to support user interface
PER_COBRA_COV_ENROLLMENTS_V Used to support user interface
PER_COBRA_DEPENDENTS_V Used to support user interface
PER_COBRA_QFYING_EVENTS Date-effective view.
PER_COBRA_QFYING_EVENTS_X Date-effective view.
PER_COLLECTIVE_AGREEMENTS_V PER_COLLECTIVE_AGREEMENTS_V lists the information about Collective Agreements which may be negotiated between Employers and Bargaining Units
PER_COLL_AGREE_GRADES_V
PER_COMMON_LOOKUP_TYPES_V Used to support user interface
PER_COMPETENCES_V Used to support user interface
PER_COMPETENCES_VL
PER_COMPETENCE_ELEMENTS_V Used to support user interface
PER_COMPETENCE_ELEMENTS_V2 Used to support user interface
PER_COMPETENCE_ELEMENTS_V3 Used to support user interface
PER_COMPETENCE_ELEMENTS_V4 Used to support user interface
PER_COMPETENCE_LEVELS_V Used to support user interface
PER_CONTACT_EXTRA_INFO Used to support user interface
PER_CONTACT_EXTRA_INFO_D Used by DateTrack History.
PER_CONTACT_INFO_TYPES_VL Used to support user interface
PER_CONTACT_RELATIONSHIPS_V Used to support user interface
PER_CONTACT_RELATIONSHIPS_V1 Used to support the user-interface.
PER_CONTACT_RELATIONSHIPS_V2 Used to support user-interface.
PER_CONTRACTS Date-effective view.
PER_CONTRACTS_D Used by DateTrack history
PER_CONTRACTS_V2 Used by Manage Contracts form.
PER_CONTRACTS_X Date-effective view.
PER_CONT_WORKERS_CURRENT_X Date-effective view.
PER_CONT_WORKERS_X Date-effective view.
PER_DEFAULT_BUDGET_VALUES View based on HR_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION
PER_DEPLOYMENT_FACTORS_V Used to support user interface
PER_DISABILITIES_D Used by Datetrack History
PER_DISABILITIES_V Date effective view that brings back all disabilities for a person
PER_ELC_RESULTS_V View for the election candidates and results
PER_ELECTIONS_V View for the election information to support for elections form.
PER_ELECTION_CANDIDATES_V View for the election candidate information to support the elections form.
PER_ELECTION_CONSTITUENCYS_V View for the election constituencies to support the elections form.
PER_EMPLOYEES_CURRENT_X Date-effective view.
PER_EMPLOYEES_X Date-effective view.
PER_EMPLOYEE_BENEFITS_V Used to support user interface
PER_ESTABLISHMENTS_BASE_V Used to support user interface
PER_ESTABLISHMENTS_V Used to support user interface
PER_ESTABLISHMENT_ATTEND_V Used to support user interface
PER_ES_SOCIAL_SECURITY_V Used in the Social Security and Tax Forms
PER_ES_TAX_DETAILS_V Used in the Social Security and Tax Forms
PER_ES_TAX_SS_EMP_V Used in the Social Security and Tax Forms
PER_EVENTS_LOV_V Used to support user interface
PER_EVENTS_V Used to support user interface
PER_EVENTS_V2 Used to support user interface
PER_EVENTS_V3 Used to support user interface
PER_EXPANDED_ANALYSES_VIEW Used to support user interface
PER_EXPANDED_ANALYSES_VIEW2 Used to support user interface
PER_EXPANDED_ASSIGNMENTS_V1 Used to support user interface
PER_EXPANDED_ASSIGNMENTS_VIEW Used to support user interface
PER_EXPANDED_POSITIONS Used to support user interface
PER_EXPANDED_POSITIONS_V Used to support user interface
PER_FULL_SALARY_HISTORY_V Used to support user interface
PER_GEN_HIER_NODE_TYPES_V Supports UI for HRMS Calendar node types only
PER_GRADES_VL
PER_GRADE_SPINES Date-effective view.
PER_GRADE_SPINES_D Used by Datetrack History
PER_GRADE_SPINES_V Used to support user interface
PER_GRADE_SPINES_X Date-effective view.
PER_HEADCOUNT_PORTLET_V
PER_HIERARCHY_LOV Used to support user interface
PER_HU_ABSENCE_REPORT_V Hungary Absence Report View
PER_HU_EMPLOYMENT_CERT_V View is used in Employment Certificate Web ADI Report.
PER_INFO_TYPES_V Used to support user interface
PER_INFO_TYPE_SECURITY_AIT_V Join between Info type security and Assignment info types
PER_INFO_TYPE_SECURITY_CIT_V Join between Info type security and Contact info types
PER_INFO_TYPE_SECURITY_JIT_V Join between Info type security and Job info types
PER_INFO_TYPE_SECURITY_LIT_V Join between Info type security and Location info types
PER_INFO_TYPE_SECURITY_PIT_V Join between Info type security and People info types
PER_INFO_TYPE_SECURITY_POT_V Join between Info type security and Position info types
PER_JOBS_V Restricts on PER_JOBS table to only return Job that exist in the Default HR Job Group
PER_JOBS_VL
PER_JOB_API_V
PER_JOB_EVALUATIONS_V Used to support user interface
PER_JOB_GROUPS_V Gets Job Group and associated flexfield information
PER_JOB_POS_GRADES_LOV_V Used to support user interface
PER_JOB_REQUIREMENTS_V Used to support user interface
PER_JP_ADDRESS_CHANGES_V This view is used by Japanese statutory report (Notification for Address Change of National Pension Type 3 Insured).
PER_JP_BANK_LOOKUPS Concatenated view of PAY_JP_BANKS and PAY_JP_BANK_BRANCHES.
PER_JP_BANK_LOOKUP_V JP specific
PER_JP_CONTACT_RELATIONSHIPS_V This view is used by JP Contact List folder and JP Social Insurance and Income Tax on Dependent window.
PER_JP_EMPDET_ASSIGNMENTS_V This view is used for Japanese localization only.
PER_JP_EMPDET_CONTACT_INFO_V This view is used for Japanese localization only.
PER_JP_EMPDET_EDUCATION_DET_V This view is used for Japanese localization only.
PER_JP_EMPDET_EMP_V This view is used for Japanese localization only.
PER_JP_EMPDET_PHONE_V This view is used for Japanese localization only.
PER_JP_EMPDET_PREV_JOB_V This view is used for Japanese localization only.
PER_JP_EMPDET_QUALIFICATIONS_V This view is used for Japanese localization only.
PER_JP_POSTAL_CODE_LOV_V View used by the web lov attatched to the postal code segment of the JP address style
PER_JP_POSTAL_CODE_PAGE_V This view is used by the web page object (JP web LOV associated with the postal code segment)
PER_JP_SCHOOL_LOOKUPS_V This view is used to display Japanese school information.
PER_JP_SI_DEPENDENT_TRANSFER_V This view is used by Japanese statutory report (Notification of Health Insurance Dependents / National Pension Type 3 Insured)
PER_JP_SPECIAL_INFORMATION JP specific
PER_JP_WRKREG_EMP_V This view is used for Japanese localization only.
PER_JP_WRKREG_EXTRA_INFO_V This view is used for Japanese localization only.
PER_JP_WRKREG_JOB_V This view is used for Japanese localization only.
PER_JP_WRKREG_PREV_JOB_V This view is used for Japanese localization only.
PER_KR_ASSIGNMENTS_V KR specific
PER_KR_GRADES_V KR specific
PER_KR_GRADE_AMOUNT KR specific
PER_KR_GRADE_AMOUNT_X KR specific
PER_KR_G_POINTS_V KR specific
PER_KR_G_POINT_AMOUNT KR specific
PER_KR_G_POINT_AMOUNT_X KR specific
PER_KR_SECOND_STATUS_V KR specific
PER_LETTER_REQUESTS_V Used to support user interface
PER_LETTER_REQUEST_LINES_V Used to support user interface
PER_LETTER_REQ_LINES_LOV Used to support user interface
PER_LOOKUP_TYPE_USAGES_V Used to support user interface
PER_MANAGER_LOV Used to support user interface
PER_MASS_APP_ASSIGN_UPDATE_V Used to support Mass Assignment Update UI
PER_MASS_MOVES_V Used to support user interface
PER_MASS_UPDATE_ASSIGNMENT_V Used to support Mass Assignment Update UI
PER_MEDICAL_ASSESSMENTS_V Used to support user interface
PER_MM_ASSIGNMENTS_V Used to support user interface
PER_MM_POSITIONS_V Used to support user interface
PER_NL_ABSENCE_HISTORY_V Dutch Absence History View
PER_NL_WAO_LIST_V Dutch WAO List View
PER_ORGANIZATION_LOV Used to support user interface
PER_ORGANIZATION_STRUCTURES_V Used to support user interface
PER_ORGANIZATION_UNITS Lists information about Organization Units
PER_ORGANIZATION_UNITS_LOV Used to support user interface
PER_ORGANIZATION_UNITS_PERF - Retrofitted
PER_ORGANIZATION_UNITS_V Used to support user interface
PER_ORG_MANAGER_V
PER_ORG_NAME_LOV Used to support user interface
PER_ORG_STRUCTURES_LOV Used to support user interface
PER_ORG_STRUCTURE_ELEMENTS_V Used to support user interface
PER_ORG_STRUCTURE_ELEMENTS_V2 Used to support user interface
PER_ORG_STRUCTURE_VERSIONS_V Used to support user interface
PER_PAY_PROPOSALS_V Employee salary proposal and performance review information.
PER_PAY_PROPOSALS_V2 Used to support user-interface
PER_PEOPLE Date-effective view.
PER_PEOPLE_ASSIGNMENTS_V1 Used to support user interface
PER_PEOPLE_ASSIGNMENTS_VIEW Used to support user interface
PER_PEOPLE_F Secure view based on the corresponding _ALL_ table.
PER_PEOPLE_V Used to support user interface
PER_PEOPLE_V2 Used to support user interface
PER_PEOPLE_V3 Used to support user interface
PER_PEOPLE_V4 Used to support user interface
PER_PEOPLE_V7 Used to support user interface
PER_PEOPLE_X Date-effective view.
PER_PERFORMANCE_REVIEWS_V Used to support user-interface.
PER_PERIODS_OF_PLACEMENT_V Periods of placement for contingent workers
PER_PERIODS_OF_SERVICE_V Used to support user interface
PER_PERIODS_OF_SERVICE_V2 Used to support user interface
PER_PERIODS_OF_WORK_V Combined view of periods of service and periods of placement
PER_PERSON_DLVRY_METHODS_V Used to support user interface.
PER_PERSON_TYPES_V Used to support user interface
PER_PERSON_TYPE_USAGES Date-effective view.
PER_PERSON_TYPE_USAGES_D Used by DateTrack history
PER_PERSON_TYPE_USAGES_V Used to support user interface
PER_PERSON_TYPE_USAGES_X Date-effective view.
PER_POSITIONS Secure view based on the corresponding _ALL_ table.
PER_POSITIONS_LOV_V Used to support user interface
PER_POSITIONS_LOV_V2 Used to support user interface
PER_POSITIONS_V Used to support user interface
PER_POSITION_STRUCTURES_LOV Used to support user interface
PER_POSITION_STRUCTURES_V Used to support user interface
PER_POS_STRUCTURE_ELEMENTS_V Used to support user interface
PER_POS_STRUCTURE_ELEMENTS_V2 Used to support user interface
PER_POS_STRUCTURE_ELEMENTS_V3 Used to support user interface
PER_POS_STRUCTURE_VERSIONS_V Used to support user interface
PER_PREVIOUS_EMPLOYERS_V View Based on Per_previous_employers
PER_PREVIOUS_JOBS_V Based on per_previous_jobs
PER_PREVIOUS_JOB_USAGES_V Based on per_previous_job_usages table
PER_PREV_JOB_EXTRA_INFO_V based on per_prev_job_extra_info table
PER_PREV_JOB_INFO_TYPES_V Based on per_previous_job_info_types
PER_PROPOSAL_CATEGORY_TYPES_V HR Web Offer category types view
PER_PROPOSAL_OFFER_PARAGRAPH_V HR Web Offer offer paragraphs view
PER_PROPOSAL_QUESTIONS_ADV_V HR Web adv questions view
PER_PROPOSAL_QUESTION_MEMBER_V HR Web Offer question members view
PER_PROPOSAL_QUESTION_TYPES_V HR Web Offer question types view
PER_PROPOSAL_TEMPLATES_V HR Web Offer proposal template view
PER_QH_EIT_V View of person and assignment extra information used by People Management form
PER_QH_SIT_V View of special information types for a person, used by People Management form
PER_QUALIFICATIONS_V Used to support user interface
PER_QUALIFICATIONS_V2 Used to support user interface
PER_QUALIFICATIONS_VL mls view for qualifications
PER_QUALIFICATION_TYPES_V Used to support user interface
PER_QUALIFICATION_TYPES_VL multilingual view for qualification types
PER_QUICKPAINT_ASSIGNMENTS This view is used in the Quickpaint form to list the assignments upon which a quickpaint report will run
PER_RATING_LEVELS_V Used to support user interface
PER_RATING_LEVELS_VL To support MLS
PER_RATING_SCALES_V Used to support user interface
PER_RATING_SCALES_VL
PER_RECRUITER_LOV_V Used to support user interface
PER_RECRUITMENT_ACTIVITIES_V Used to support user interface
PER_RECRUITMENT_ACTIVITY_FOR_V Used to support user interface
PER_REFERRER_LOV_V Used to support user interface
PER_REQUISITIONS_V Used to support user interface
PER_RI_SETUP_SUB_TASKS_VL MLS view based on PER_RI_SETUP_SUB_TASKS table
PER_RI_SETUP_TASKS_VL MLS View based on PER_RI_SETUP_TASKS table
PER_RI_VIEW_REPORTS_VL MLS View based on PER_RI_VIEW_REPORTS table
PER_RI_WORKBENCH_ITEMS_VL MLS view based on PER_RI_WORKBENCH_ITEMS table
PER_ROLES_V
PER_ROLE_ROLES_V Used for WorkFlow Directory Service
PER_SALARY_SURVEYS_V Used to support user-interface
PER_SALARY_SURVEY_LINES_V Used to support user-interface.
PER_SALARY_SURVEY_MAPPINGS_V Used to support user-interface.
PER_SECONDARY_ASS_STATUSES_V Used to support user interface
PER_SECURITY_ORGANIZATIONS_V
PER_SECURITY_PROFILES_V Used to support user interface
PER_SECURITY_USERS_V Used to support user interface.
PER_SEC_PROFILE_ASSIGNMENTS_V Used to support user-interface.
PER_SHARED_TYPES_V1 Used to support user-interface.
PER_SHARED_TYPES_VL Used to support user-interface.
PER_SPECIAL_INFO_TYPES_V Used to support user interface
PER_SPECIAL_INFO_TYPES_V2 Used to support user interface