Results for “hire_date”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
HRFV_TIME_IN_SERVICE_ANALYSIS is an APPS-owned business view template in the Oracle E-Business Suite Human Resources (PER) module, documented as VALID in ETRM for both 12.1.1 and 12.2.2. It is a flexfield-generated business view template: Oracle's flexfield view generation mechanism derives concrete, effective-dated reporting views from this template so that customers and integrators can expose descriptive flexfield context and segment columns alongside a stable set of descriptive attributes. Its principal purpose is to consolidate, into a single queryable object, the tenure measures that Oracle HR calculates through the HR_DISCOVERER package — service in the enterprise, organization, position, job, grade, and location — together with the assignment, person, and organizational context needed to interpret those measures.
The view is intended for reporting and integration rather than for transactional maintenance. It provides a denormalized, human-readable projection of assignment tenure suitable for operational HR reporting, headcount and retention analysis, and downstream extracts feeding data warehouses or third-party HR analytics tools. The object name searched by the user, "months_in_job", is exposed here as a column derived from the time-in-service computation, which is why this view is commonly returned when that term is searched.
Underlying Base Objects
The documented view is defined over the following base objects: PER_ALL_ASSIGNMENTS_F, PER_PERIODS_OF_SERVICE, PER_PEOPLE_X, HR_ALL_ORGANIZATION_UNITS_TL (referenced twice, once for the assignment organization and once for the business group), HR_LOCATIONS_ALL_TL, PER_JOBS_TL, PER_POSITIONS/HR_ALL_POSITIONS_F_TL, and PER_GRADES_TL. Tenure values are not stored; they are computed at runtime by calling HR_DISCOVERER.TIME_IN, which internally relies on HR_GENERAL and HR_BIS, and row-level access is filtered through HR_SECURITY and HR_PERSON_NAME.
PER_ALL_ASSIGNMENTS_F is the driving table, joined to PER_PERIODS_OF_SERVICE on PERIOD_OF_SERVICE_ID and to PER_PEOPLE_X on PERSON_ID. Job, position, grade, and location are attached through outer joins, so an assignment lacking any of those attributes still appears with a null descriptive name. The translated tables (HR_ALL_ORGANIZATION_UNITS_TL, HR_LOCATIONS_ALL_TL) are restricted to the session language, and the view is further limited to employee assignments via ASSIGNMENT_TYPE = 'E' and to rows whose effective dates include the current date, excluding terminated periods of service.
Key Columns
- BUSINESS_GROUP_NAME, PERSON_NAME, EMPLOYEE_NUMBER — organizational and identifying context for the assignment.
- MONTHS_IN_SERVICE, MONTHS_IN_ORGANIZATION, MONTHS_IN_POSITION, MONTHS_IN_JOB, MONTHS_IN_GRADE, MONTHS_IN_LOCATION — tenure measures returned by HR_DISCOVERER.TIME_IN, each expressing completed months in the corresponding dimension.
- ASSIGNMENT_NUMBER, ASSIGNMENT_ID — assignment-level keys for joining to PER_ALL_ASSIGNMENTS_F and related objects.
- ORGANIZATION_NAME, JOB_NAME, POSITION_NAME, GRADE_NAME, LOCATION_NAME — descriptive names for the current assignment components.
- HIRE_DATE, TERMINATION_DATE — start date and actual termination date from PER_PERIODS_OF_SERVICE.
- BUSINESS_GROUP_ID, GRADE_ID, JOB_ID, LOCATION_ID, ORGANIZATION_ID, PERSON_ID, POSITION_ID — surrogate keys supporting integration joins.
Common Use Cases and Queries
Typical scenarios include identifying employees approaching a tenure milestone, comparing time-in-job against time-in-grade for promotion eligibility, and extracting assignment tenure into a warehouse.
- Retrieve employees with more than sixty months in their current job:
SELECT person_name, employee_number, job_name, months_in_job FROM apps.hrfv_time_in_service_analysis WHERE months_in_job > 60 ORDER BY months_in_job DESC;
- Compare tenure across dimensions for a business group, and join back to PER_ALL_ASSIGNMENTS_F on ASSIGNMENT_ID for additional attributes. Because tenure is computed per row and HR_SECURITY restricts results to the querying user's security profile, performance is best served by filtering on business group or organization before aggregating.
-
Business view template from which the flexfield view is generated.
APPS.HRFV_TIME_IN_SERVICE_ANALYSIS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_ALL_POSITIONS_F_TL·↳ HR_BIS·Explore PER module →
-
Stock Account information.
APPS.BEN_CWB_EQUITY_EDGE_ACT_INFO_V·↳ BEN_ELIG_PER_ELCTBL_CHC·↳ BEN_ENRT_RT·↳ BEN_PER_IN_LER·Explore BEN module →
-
View: PAY_JP_ITWB_EMP_ASS_V 12.2.2
This view is used for Japanese localization only.
APPS.PAY_JP_ITWB_EMP_ASS_V·↳ FND_DATE·↳ PAY_ACTION_INFORMATION·Explore PAY module →
-
Business view template from which the flexfield view is generated.
APPS.HRFV_TIME_IN_SERVICE_ANALYSIS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_ALL_POSITIONS_F_TL·↳ HR_BIS·Explore PER module →
-
Hungary Absence Report View
APPS.PER_HU_ABSENCE_REPORT_V·↳ PAY_ACTION_INFORMATION·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_PAYROLL_ACTIONS·Explore PER module →
-
Hungary Absence Report View
APPS.PER_HU_ABSENCE_REPORT_V·↳ PAY_ACTION_INFORMATION·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_PAYROLL_ACTIONS·Explore PER module →
-
View: PAY_KR_ASG_ACTIONS_V 12.2.2
APPS.PAY_KR_ASG_ACTIONS_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_INFORMATION·↳ HR_PERSON_NAME·Explore PAY module →
-
Ceridian Source 100 payroll interface view
APPS.HR_CERIDIAN_ASSIGNMENT_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_ORGANIZATION_UNITS·Explore PER module →
-
Ceridian Source 100 payroll interface view
APPS.HR_CERIDIAN_ASSIGNMENT_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_ORGANIZATION_UNITS·Explore PER module →
-
View: HRFV_HIRES 12.2.2
Business view template from which the flexfield view is generated.
APPS.HRFV_HIRES·↳ HRI_BPL_PERSON_TYPE·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_ALL_POSITIONS_F_TL·Explore PER module →
-
View: PER_JP_WRKREG_EMP_V 12.2.2
This view is used for Japanese localization only.
APPS.PER_JP_WRKREG_EMP_V·↳ FND_DATE·↳ PAY_ACTION_INFORMATION·Explore PER module →
-
View: HRFV_HIRES 12.1.1
Business view template from which the flexfield view is generated.
APPS.HRFV_HIRES·↳ FND_GLOBAL·↳ HRI_BPL_PERSON_TYPE·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PER module →
-
View: PAY_CA_EOY_RL1_REG_V 12.2.2
APPS.PAY_CA_EOY_RL1_REG_V·↳ FF_ARCHIVE_ITEMS·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_CA_ARCHIVE_UTILS·Explore PAY module →
-
Ceridian Source 500 payroll interface view
APPS.HR_CERIDIAN_500_EMPLOYEE_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_CERIDIAN·Explore PER module →
-
PAY_ZA_TAX_REGISTERS is used for the South African Tax Register Report.
-
Ceridian Source 100 payroll interface view
APPS.HR_CERIDIAN_EMPLOYEE_ONLY_V·↳ FND_PROFILE·↳ HR_CERIDIAN·↳ HR_CERIDIAN_SPOUSE_V·Explore PER module →
-
Stock Detail Report.
APPS.BEN_CWB_REPT_STOCK_DETAIL_V·↳ BENUTILS·↳ BEN_ACTY_BASE_RT_F·↳ BEN_CWB_HRCHY·Explore BEN module →
-
View: PER_JP_EMPDET_EMP_V 12.2.2
This view is used for Japanese localization only.
APPS.PER_JP_EMPDET_EMP_V·↳ FND_DATE·↳ FND_NUMBER·↳ PAY_ACTION_INFORMATION·Explore PER module →
-
View: PER_ASSIGNMENTS_V3 12.2.2
Used to support user interface
APPS.PER_ASSIGNMENTS_V3·↳ FND_ID_FLEX_STRUCTURES·↳ FND_SESSIONS·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →
-
APPS.HXC_RESOURCE_INFORMATION_V·↳ FND_GLOBAL·↳ HR_API·↳ HR_GENERAL·Explore HXC module →
-
View is used in Employment Certificate Web ADI Report.
APPS.PER_HU_EMPLOYMENT_CERT_V·↳ PAY_ACTION_INFORMATION·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_PAYROLL_ACTIONS·Explore PER module →
-
View is used in Employment Certificate Web ADI Report.
APPS.PER_HU_EMPLOYMENT_CERT_V·↳ PAY_ACTION_INFORMATION·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_PAYROLL_ACTIONS·Explore PER module →
-
View: PAY_CA_EOY_RL1_REG_V 12.1.1
APPS.PAY_CA_EOY_RL1_REG_V·↳ FF_ARCHIVE_ITEMS·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_CA_ARCHIVE_UTILS·Explore PAY module →
-
View: HR_ADP_EMPLOYEE_V 12.1.1
ADP payroll interface view
APPS.HR_ADP_EMPLOYEE_V·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·↳ HR_ADP_SPOUSE_V·Explore PER module →
-
View: PER_PEOPLE_V7 12.1.1
Used to support user interface
APPS.PER_PEOPLE_V7·↳ FND_GLOBAL·↳ HR_API·↳ HR_GENERAL·Explore PER module →
-
View: HRFV_PERSONAL_DETAILS 12.1.1
Business view template from which the flexfield view is generated.
APPS.HRFV_PERSONAL_DETAILS·↳ FND_LANGUAGES·↳ FND_TERRITORIES_TL·↳ HRI_BPL_PERSON_TYPE·Explore PER module →
-
View: PAY_KR_ASG_ACTIONS_V 12.1.1
APPS.PAY_KR_ASG_ACTIONS_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_INFORMATION·↳ HR_PERSON_NAME·Explore PAY module →
-
View: PER_ASSIGNMENTS_V3 12.1.1
Used to support user interface
APPS.PER_ASSIGNMENTS_V3·↳ FND_ID_FLEX_STRUCTURES·↳ FND_SESSIONS·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →
-
APPS.HRIFV_US_EMPASGDTL_EMPXASG·↳ FND_DATE·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_BIS·Explore HRI module →
-
APPS.HRIFV_US_EMPASGDTL_EMPXASG·↳ FND_DATE·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_BIS·Explore HRI module →
-
View: HRU_JP_CREATE_EDUC_ADD 12.1.1
This view is Japanaes specific.
-
APPS.HXC_RESOURCE_INFORMATION_V·↳ HR_API·↳ HR_GENERAL·↳ HR_LOCATIONS·Explore HXC module →
-
Business view template from which the flexfield view is generated.
APPS.HRFV_PERSON_ASSIGNMENT_HISTORY·↳ FND_TERRITORIES_TL·↳ HRI_BPL_PERSON_TYPE·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PER module →
-
View: PER_PEOPLE_V 12.1.1
Used to support user interface
APPS.PER_PEOPLE_V·↳ BEN_BENFTS_GRP·↳ FND_GLOBAL·↳ FND_LANGUAGES_VL·Explore PER module →
-
Business view template from which the flexfield view is generated.
APPS.HRFV_PERSON_ASSIGNMENT_HISTORY·↳ FND_TERRITORIES_TL·↳ HRI_BPL_PERSON_TYPE·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PER module →
-
Ceridian Source 500 payroll interface view
APPS.HR_CERIDIAN_500_EMPLOYEE_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_CERIDIAN·Explore PER module →
-
Stock Account information.
APPS.BEN_CWB_EQUITY_EDGE_ACT_INFO_V·↳ BEN_ELIG_PER_ELCTBL_CHC·↳ BEN_ENRT_RT·↳ BEN_PER_IN_LER·Explore BEN module →
-
PAY_ZA_TAX_REGISTERS is used for the South African Tax Register Report.
-
Ceridian Source 100 payroll interface view
APPS.HR_CERIDIAN_EMPLOYEE_ONLY_V·↳ FND_PROFILE·↳ HR_CERIDIAN·↳ HR_CERIDIAN_SPOUSE_V·Explore PER module →
-
View: PER_CONTRACTS_V2 12.2.2
Used by Manage Contracts form.
APPS.PER_CONTRACTS_V2·↳ FND_ATTACHMENT_UTIL_PKG·↳ FND_SESSIONS·↳ HR_GENERAL·Explore PER module →
-
View: HR_EDW_WRK_RCTMNT_FCV 12.1.1
APPS.HR_EDW_WRK_RCTMNT_FCV·↳ EDW_HR_AGE_BAND_PKG·↳ EDW_HR_PRSN_TYP_PKG·↳ EDW_HR_REC_ACT_PKG·Explore HRI module →
-
View: BEN_PEOPLE_RSLT_V 12.2.2
Used to support user interface
APPS.BEN_PEOPLE_RSLT_V·↳ BEN_BENFTS_GRP·↳ BEN_PRTT_ENRT_RSLT_F·↳ BEN_PRTT_PREM_F·Explore BEN module →
-
View: BEN_PEOPLE_RSLT_V 12.1.1
Used to support user interface
APPS.BEN_PEOPLE_RSLT_V·↳ BEN_BENFTS_GRP·↳ BEN_PRTT_ENRT_RSLT_F·↳ BEN_PRTT_PREM_F·Explore BEN module →
-
View: PAY_JP_IWHT_EMP_V 12.2.2
This view is used for Japanese localization only.
APPS.PAY_JP_IWHT_EMP_V·↳ FND_DATE·↳ FND_NUMBER·↳ PAY_ACTION_INFORMATION·Explore PAY module →
-
View: PER_PEOPLE_V 12.2.2
Used to support user interface
APPS.PER_PEOPLE_V·↳ BEN_BENFTS_GRP·↳ FND_LANGUAGES_VL·↳ FND_SESSIONS·Explore PER module →
-
Stock Detail Report.
APPS.BEN_CWB_REPT_STOCK_DETAIL_V·↳ BENUTILS·↳ BEN_ACTY_BASE_RT_F·↳ BEN_CWB_HRCHY·Explore BEN module →
-
APPS.PAY_JP_WL_EMPLOYEE_DETAILS_V·↳ FND_DATE·↳ FND_NUMBER·↳ PAY_ACTION_INFORMATION·Explore PAY module →
-
View: HR_ADP_EMPLOYEE_V 12.2.2
ADP payroll interface view
APPS.HR_ADP_EMPLOYEE_V·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·↳ HR_ADP_SPOUSE_V·Explore PER module →