Results for “exclusion_reason”
40 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
HRFV_US_PERSONAL_DETAILS is an APPS-owned, VALID business view template within the PER (Human Resources) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. As its description states, it is the "business view template from which the flexfield view is generated," meaning it defines the column projection, joins, and descriptive flexfield (DFF) context that Oracle uses to materialize a delivered flexfield view exposing United States person-level personal details. Because the view filters on BGR.LEGISLATION_CODE = 'US', it is scoped strictly to US business groups. The view is exposed with the WITH READ ONLY clause, so it supports query and reporting workloads only and cannot be used for DML. It is intended for reporting, extracts, and integration scenarios where a flat, denormalized projection of personal information is required, rather than as a transactional entry point.
Underlying Base Objects
The view is defined over a small set of base objects and packages documented in ETRM 12.2.2:
- PER_BUSINESS_GROUPS (VIEW): aliased
BGR; suppliesBUSINESS_GROUP_NAME,ORGANIZATION_ID, andLEGISLATION_CODE. The join restricts results to US business groups. - PER_PEOPLE_X (VIEW): aliased
PEO; the primary source of person attributes, including name components, national identifier, and thePER_INFORMATION1throughPER_INFORMATION9DFF segments. - HR_BIS (PACKAGE): provides
BIS_DECODE_LOOKUPandGET_SEC_PROFILE_BG_ID; the latter enforces business group security by restricting rows to the session's authorized business group. - FND_DATE (PACKAGE): provides
CANONICAL_TO_DATEfor the I9 expiry date. - HR_GENERAL, HR_PERSON_NAME, HR_SECURITY (PACKAGES): referenced base objects supporting name handling and security enforcement.
The security predicate PEO.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PEO.BUSINESS_GROUP_ID) ensures data is filtered according to the user's security profile.
Key Columns
- BUSINESS_GROUP_NAME / BUSINESS_GROUP_ID: the US business group owning the person record.
- PERSON_NAME, FIRST_NAME, LAST_NAME, PREFIX, SUFFIX, PREFERRED_NAME: name components sourced from PER_PEOPLE_X.
- MIDDLE_NAMES: the person's middle name(s); this is the column matched by the search term "middle_names."
- EMPLOYEE_NUMBER, SOCIAL_SECURITY_NUMBER, TITLE: identifier and job title attributes.
- ETHNIC_ORIGIN, I9, I9_EXPIRY_DATE, VISA_TYPE, VIETNAM_VETS_STATUS, STUDENT, NEW_HIRE_STATUS, EXCLUSION_REASON, CHILD_SUPPORT_OBLIGATION: decoded US legislative DFF segments derived from
PER_INFORMATION1–PER_INFORMATION9viaBIS_DECODE_LOOKUP. - "_DF": the descriptive flexfield context token
'_DF:PER:PER_PEOPLE:PEO', identifying the DFF source structure. - PERSON_ID: the unique person identifier, used as the join key to other HR entities.
Common Use Cases and Queries
Typical scenarios include US headcount and personal-detail reporting, I-9 and visa compliance extracts, and integration feeds requiring decoded DFF values. A simple query retrieving middle names and related attributes follows:
SELECT PERSON_ID, EMPLOYEE_NUMBER, LAST_NAME, FIRST_NAME, MIDDLE_NAMES FROM APPS.HRFV_US_PERSONAL_DETAILS WHERE MIDDLE_NAMES IS NOT NULL;SELECT BUSINESS_GROUP_NAME, PERSON_NAME, MIDDLE_NAMES, SOCIAL_SECURITY_NUMBER FROM APPS.HRFV_US_PERSONAL_DETAILS WHERE EMPLOYEE_NUMBER = :emp_num;SELECT PERSON_NAME, I9, I9_EXPIRY_DATE, VISA_TYPE FROM APPS.HRFV_US_PERSONAL_DETAILS WHERE I9 = 'Y' AND I9_EXPIRY_DATE < SYSDATE + 30;
Because the view is read-only and security-filtered, queries automatically inherit the caller's business group security profile, making it suitable for both ad hoc reporting and scheduled concurrent program extracts.
-
Business view template from which the flexfield view is generated.
APPS.HRFV_US_PERSONAL_DETAILS·↳ FND_DATE·↳ HR_BIS·↳ HR_GENERAL·Explore PER module →
-
Stores contracts that are excluded from delinquency reports
-
View: HRIFV_US_PERDTL 12.1.1
APPS.HRIFV_US_PERDTL·↳ FND_DATE·↳ HR_BIS·↳ HR_GENERAL·Explore HRI module →
-
View: HRIFV_US_PERDTL 12.2.2
APPS.HRIFV_US_PERDTL·↳ FND_DATE·↳ HR_BIS·↳ HR_GENERAL·Explore HRI module →
-
Business view template from which the flexfield view is generated.
APPS.HRFV_US_PERSONAL_DETAILS·↳ FND_DATE·↳ HR_BIS·↳ HR_GENERAL·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: APPS.HRIFV_US_PERDTL 12.2.2
-
VIEW: APPS.HRIFV_US_PERDTL 12.1.1
-
VIEW: APPS.HRIFV_US_PERDTL 12.2.2
-
VIEW: APPS.HRIFV_US_PERDTL 12.1.1
-
PACKAGE: APPS.IEX_IEH_PVT 12.2.2
-
PACKAGE: APPS.IEX_IEH_PVT 12.1.1
-
eTRM - HRI Tables and Views 12.2.2
Supervisor Hierarchy Summary Table
-
eTRM - IEX Tables and Views 12.2.2
xdo requested history for Collections
-
eTRM - HRI Tables and Views 12.1.1
-
eTRM - PER Tables and Views 12.2.2
Table to store NQF Training info for a person
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person