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:

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

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.