Results for “registered_disabled”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
HRIFV_US_PERDTL is a read-only Oracle EBS view owned by the APPS schema and shipped as part of the HRI (Human Resources Intelligence) product family, the reporting and analytics layer built on top of Oracle HRMS. The object is validated and available in both EBS 12.1.1 and 12.2.2. Its purpose is to present person-level detail records that are specific to the United States legislative context. The "US" token in the name reflects that the view restricts its result set to business groups whose legislation code is 'US', while "PERDTL" denotes person detail.
The view is intended primarily for reporting, data extraction, and downstream integration where a flattened, decoded representation of United States statutory person attributes is required. Unlike the underlying PER_PEOPLE_F table, which stores flexfield segments as raw coded values, HRIFV_US_PERDTL resolves those codes into meaningful lookup meanings and exposes the National Identifier under the business-friendly alias SOCIAL_SECURITY_NUMBER. This is a frequently searched attribute; users looking for a person's social security number in an HRI or US HRMS reporting context are typically directed to this column.
Because the view is defined WITH READ ONLY, it cannot be used as a DML target. It also inherits Oracle HRMS security semantics through its dependency on the HR_SECURITY package and related constructs, meaning rows returned to a session are filtered according to the business group and security profile of the querying user.
Underlying Base Objects
The view is defined over two principal data sources joined in its SQL text:
- PER_BUSINESS_GROUPS (aliased BGR) — supplies BUSINESS_GROUP_NAME and is used to constrain the result set to United States business groups via the predicate
BGR.LEGISLATION_CODE = 'US', joined onPEO.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID. - PER_PEOPLE_F (aliased PEO) — the effective-dated date-tracked people view that supplies person name, employee number, national identifier, and the United States person information flexfield segments (PER_INFORMATION1 through PER_INFORMATION9).
Supporting program units documented as referenced base objects include FND_DATE (used for canonical-to-date conversion of the I-9 expiry date), HR_GENERAL (used for lookup decoding via DECODE_LOOKUP), HR_BIS, HR_PERSON_NAME, and HR_SECURITY. The view is additionally governed by the profile option accessor HR_GENERAL.GET_BUSINESS_GROUP_ID, which restricts rows to the session's current business group when that profile is populated. The DESCRIPTIVE_FLEXFIELD column carries the descriptor string '_DF:PER:PER_PEOPLE:PEO', identifying the flexfield context from which the US person information segments are sourced.
Key Columns
- BUSINESS_GROUP_NAME — name of the US business group to which the person belongs.
- PERSON_NAME, PERSON_ID — the person's full name and the primary key identifier in PER_PEOPLE_F.
- EFFECTIVE_START_DATE, EFFECTIVE_END_DATE — the date-tracked validity range of the person row.
- EMPLOYEE_NUMBER — the assigned employee number.
- SOCIAL_SECURITY_NUMBER — mapped directly from PEO.NATIONAL_IDENTIFIER; the US national identifier, commonly accessed when users search for a person's social security number.
- ETHNIC_ORIGIN — decoded from PER_INFORMATION1 using the US_ETHNIC_GROUP lookup.
- I9, I9_EXPIRY_DATE — the I-9 eligibility flag (YES_NO lookup) and its expiry date, converted with FND_DATE.CANONICAL_TO_DATE.
- VISA_TYPE — decoded from PER_INFORMATION4 using the US_VISA_TYPE lookup.
- VIETNAM_VETS_STATUS — decoded from PER_INFORMATION5 using the US_VETERAN_STATUS lookup.
- STUDENT — YES_NO flag from PER_INFORMATION6.
- NEW_HIRE_STATUS — decoded from PER_INFORMATION7 using the US_NEW_HIRE_STATUS lookup.
- EXCLUSION_REASON — raw value from PER_INFORMATION8, typically related to new-hire reporting exclusions.
- CHILD_SUPPORT_OBLIGATION — YES_NO flag from PER_INFORMATION9.
- REGISTERED_DISABLED — YES_NO decoding of the REGISTERED_DISABLED_FLAG.
- BUSINESS_GROUP_ID — organizational identifier of the business group.
Common Use Cases and Queries
Typical use cases include US new-hire reporting, I-9 and visa compliance tracking, veteran and disability status reporting, and ad hoc extracts requiring decoded statutory attributes. A representative query retrieving a person's social security number and related US details is:
SELECT person_name, employee_number, social_security_number, i9, i9_expiry_date, visa_type, new_hire_status FROM apps.hrifv_us_perdtl WHERE employee_number = :emp_num;
To list all persons in a business group with their decoded ethnic origin and child support obligation:
SELECT business_group_name, person_name, ethnic_origin, child_support_obligation FROM apps.hrifv_us_perdtl WHERE business_group_name = :bg_name ORDER BY person_name;
For compliance monitoring of I-9 expiry:
SELECT person_name, employee_number, i9, i9_expiry_date FROM apps.hrifv_us_perdtl WHERE i9 = 'Yes' AND i9_expiry_date BETWEEN SYSDATE AND SYSDATE + 90 ORDER BY i9_expiry_date;
Because the view is read-only and secured, users must have the appropriate HRMS security profile and responsibility to see rows; queries executed outside a US business group context return no data. The effective dating of PER_PEOPLE_F means each row represents a dated version of the person record, so consumers should consider date filters when the current record is intended.
-
Registered Disabled
-
Registered Disabled
-
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 →
-
View: HRFV_PERSONAL_DETAILS 12.2.2
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 →
-
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: 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 →
-
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 →
-
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.BEN_DSBLD_RT_D 12.2.2
-
VIEW: APPS.BEN_DSBLD_RT_D 12.1.1
-
View: BEN_DSBLD_RT_D 12.1.1
APPS.BEN_DSBLD_RT_D·↳ BEN_DSBLD_RT_F·↳ BEN_VRBL_RT_PRFL_F·↳ FND_GLOBAL·Explore BEN module →
-
View: BEN_DSBLD_RT_D 12.2.2
APPS.BEN_DSBLD_RT_D·↳ BEN_DSBLD_RT_F·↳ BEN_VRBL_RT_PRFL_F·↳ FND_USER·Explore BEN module →
-
This view identifies which disabled criteria is included or excluded from an eligibility profile.
APPS.BENBV_ELIG_DSBLD_PRTE_V·↳ BEN_ELIG_DSBLD_PRTE_F·↳ HR_BIS·Explore BEN module →
-
This view identifies which disabled criteria is included or excluded from an eligibility profile.
APPS.BENBV_ELIG_DSBLD_PRTE_V·↳ BEN_ELIG_DSBLD_PRTE_F·↳ HR_BIS·Explore BEN module →
-
- Retrofitted
APPS.BEN_ELIG_DSBLD_STAT_CVG_D·↳ BEN_DPNT_CVG_ELIGY_PRFL_F·↳ BEN_ELIG_DSBLD_STAT_CVG_F·↳ FF_FORMULAS_F·Explore BEN module →
-
- Retrofitted
APPS.BEN_ELIG_DSBLD_STAT_CVG_D·↳ BEN_DPNT_CVG_ELIGY_PRFL_F·↳ BEN_ELIG_DSBLD_STAT_CVG_F·↳ FF_FORMULAS_F·Explore BEN module →
-
This view identifies the applicable disabled statuses which contact must have, to be eligible for a participant to designate a him or her for coverage
APPS.BENBV_ELIG_DSBLD_STAT_CVG_V·↳ BEN_ELIG_DSBLD_STAT_CVG_F·↳ HR_BIS·Explore BEN module →
-
VIEW: APPS.HRIFV_US_PERDTL 12.2.2
-
VIEW: APPS.HRBV_PEOPLE 12.1.1
-
VIEW: APPS.HRBV_PEOPLE 12.2.2
-
VIEW: APPS.HRIFV_US_PERDTL 12.1.1
-
This view identifies the applicable disabled statuses which contact must have, to be eligible for a participant to designate a him or her for coverage
APPS.BENBV_ELIG_DSBLD_STAT_CVG_V·↳ BEN_ELIG_DSBLD_STAT_CVG_F·↳ HR_BIS·Explore BEN module →
-
VIEW: APPS.PER_ALL_PEOPLE_D 12.2.2
-
VIEW: APPS.PER_ALL_PEOPLE_D 12.1.1
-
VIEW: APPS.PER_PEOPLE_V2 12.1.1
-
A list of items that a user can use in an advanced find window.
-
A list of items that a user can use in an advanced find window.
-
VIEW: APPS.PER_PEOPLE_V2 12.2.2