Results for “preferred_name”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
HRFV_GB_PERSONAL_DETAILS is a business view template maintained in the APPS schema under the PER (Human Resources) product family. It is a flexfield-derived view, meaning it is generated from a business view template rather than serving as a base transactional object. Its defining characteristic is the restriction of output to the United Kingdom legislative context: the WHERE clause filters records on BGR.LEGISLATION_CODE = 'GB', so only personal details belonging to GB business groups are exposed.
The view presents a flattened, denormalized projection of person-level descriptive and legislative attributes. Because it joins the business group definition to the person record, it provides report authors and integrators with a single object that combines organizational context (business group name) with individual demographics, statutory identifiers, and GB-specific flexfield attributes. It is read-only (defined WITH READ ONLY) and is typically consumed by Oracle Discoverer workbooks, BI Publisher reports, and inbound/outbound interfaces that must present GB statutory personal data without navigating the underlying PER schema directly. The _DF:PER:PER_PEOPLE:PEO column signals that the view is a flexfield view generated for the PER_PEOPLE entity, used by the flexfield view machinery to identify the source entity.
Underlying Base Objects
ETRM 12.2.2 documents the following referenced base objects: HR_BIS (package), HR_GENERAL (package), HR_PERSON_NAME (package), HR_SECURITY (package), PER_BUSINESS_GROUPS (view), and PER_PEOPLE_X (view).
The principal FROM-clause sources are PER_BUSINESS_GROUPS (aliased BGR) and PER_PEOPLE_X (aliased PEO), joined on PEO.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID. PER_PEOPLE_X is the effective-dated, date-tracked view of the PER_PEOPLE table, which is why the view exposes current person attributes without the caller managing date-tracked joins.
- HR_BIS — supplies
BIS_DECODE_LOOKUP(used to decode ETH_TYPE and YES_NO lookups) andGET_SEC_PROFILE_BG_ID(used for business group security filtering). - HR_SECURITY — underpins the security profile restriction applied through the NVL predicate on business group ID.
- HR_GENERAL and HR_PERSON_NAME — provide supporting person-name and general HR utilities referenced by the generated view template.
Key Columns
The view exposes twenty-one columns. The most significant include:
- MIDDLE_NAMES — the person's middle name or names, sourced from PER_PEOPLE_X.MIDDLE_NAMES. This is the column most frequently queried when users search for a person's middle name.
- PERSON_NAME, FIRST_NAME, LAST_NAME, PREFIX, SUFFIX, PREFERRED_NAME — the full name construction columns, mapping to FULL_NAME, FIRST_NAME, LAST_NAME, PRE_NAME_ADJUNCT, SUFFIX, and KNOWN_AS respectively.
- NI_NUMBER — the National Insurance identifier, mapped from NATIONAL_IDENTIFIER.
- ETHNIC_ORIGIN — decoded from PER_INFORMATION1 using the ETH_TYPE lookup.
- DIRECTOR, PENSIONER — Yes/No flags decoded from PER_INFORMATION2 and PER_INFORMATION4.
- WORK_PERMIT_NUMBER — PER_INFORMATION5.
- ADDL_PENSIONABLE_YEARS, ADDL_PENSIONABLE_MONTHS, ADDL_PENSIONABLE_DAYS — numeric conversions of PER_INFORMATION6, 7, and 8, used in GB pension calculations.
- NI_MULTIPLE_ASSIGNMENTS — Yes/No flag decoded from PER_INFORMATION9.
- BUSINESS_GROUP_ID, PERSON_ID — key identifiers supporting joins back to PER_PEOPLE and PER_ALL_PEOPLE_F.
Common Use Cases and Queries
Typical scenarios include GB statutory reporting, pension administration extracts, and person-name validation. A query retrieving middle names for GB employees:
SELECT PERSON_ID,
PERSON_NAME,
FIRST_NAME,
MIDDLE_NAMES,
LAST_NAME,
NI_NUMBER
FROM APPS.HRFV_GB_PERSONAL_DETAILS
WHERE UPPER(MIDDLE_NAMES) LIKE UPPER(:p_search || '%');
A pension extract joining additional pensionable service:
SELECT BUSINESS_GROUP_NAME, PERSON_NAME, NI_NUMBER, ADDL_PENSIONABLE_YEARS, ADDL_PENSIONABLE_MONTHS, ADDL_PENSIONABLE_DAYS, PENSIONER FROM APPS.HRFV_GB_PERSONAL_DETAILS WHERE BUSINESS_GROUP_ID = :p_bg_id;
Because the view is read-only and secured through HR_BIS.GET_SEC_PROFILE_BG_ID, queries execute within the caller's business group security profile, ensuring that only authorized GB business groups are returned. Report developers should join on PERSON_ID to PER_ALL_PEOPLE_F or PER_PERSON_NAMES_F when effective-date history is required, since the view reflects the current effective record.
-
Business view template from which the flexfield view is generated.
APPS.HRFV_GB_PERSONAL_DETAILS·↳ HR_BIS·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore PER module →
-
View: IGS_PR_DISPLAY_V 12.1.1
APPS.IGS_PR_DISPLAY_V·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·↳ IGS_GE_GEN_002·Explore IGS module →
-
View: IGS_AS_EXM_SUPRVISOR_V 12.1.1
APPS.IGS_AS_EXM_SUPRVISOR_V·↳ IGS_AS_EXM_SPRVSRTYP·↳ IGS_AS_EXM_SUPRVISOR·↳ IGS_EN_GEN_003·Explore IGS 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 →
-
View: ASF_PERSONS_QF_V 12.1.1
View for Person Quick Find
-
View: AMS_PERSONS_V 12.2.2
Information about parties such as people.
APPS.AMS_PERSONS_V·↳ HZ_CONTACT_POINTS·↳ HZ_PARTIES·Explore AMS module →
-
View: IGR_I_PERSON_V 12.1.1
Person View
APPS.IGR_I_PERSON_V·↳ IGS_AD_PROSPECT_V·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·Explore IGS module →
-
View: IGS_AV_STND_UNIT_V 12.1.1
APPS.IGS_AV_STND_UNIT_V·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·↳ IGS_AV_STND_UNIT·Explore IGS module →
-
View: IGS_AV_STND_UNIT_DTL_V 12.1.1
APPS.IGS_AV_STND_UNIT_DTL_V·↳ IGS_AV_STND_UNIT·↳ IGS_PE_PERSON_BASE_V·Explore IGS module →
-
Business view template from which the flexfield view is generated.
APPS.HRFV_GB_PERSONAL_DETAILS·↳ HR_BIS·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore PER 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 →
-
View: IGS_AD_ENQ_PERSON_V 12.1.1
Obsolete
APPS.IGS_AD_ENQ_PERSON_V·↳ IGS_AD_PROSPECT_V·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·Explore IGS 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: AMS_PERSONS_V 12.1.1
Information about parties such as people.
APPS.AMS_PERSONS_V·↳ HZ_CONTACT_POINTS·↳ HZ_PARTIES·Explore AMS module →
-
View: IGS_GR_VENUE_V 12.1.1
IGS_GR_VENUE_V is used to maintain venues.
APPS.IGS_GR_VENUE_V·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·↳ IGS_GR_VENUE·Explore IGS module →
-
View: IGS_SS_PERSON_SEARCH_V 12.1.1
The entity is used in Self Service to query for a Person
APPS.IGS_SS_PERSON_SEARCH_V·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·↳ IGS_PE_ALT_PERS_ID·Explore IGS module →
-
View: AMS_PARTIES_V 12.1.1
APPS.AMS_PARTIES_V·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore AMS module →
-
Relationships between entities
APPS.AMS_PERSON_RELATIONSHIPS_V·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore AMS 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: ASF_PERSONS_QF_V 12.2.2
View for Person Quick Find
-
View: IGF_AP_PERSON_V 12.1.1
APPS.IGF_AP_PERSON_V·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·↳ IGS_EN_GEN_003·Explore IGF module →
-
View: IGS_AD_SS_PERSON_V 12.1.1
This view retrieves the Person Information
APPS.IGS_AD_SS_PERSON_V·↳ FND_LOOKUP_VALUES·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore IGS module →
-
View: IGS_PE_PERSON_SV 12.1.1
IGS_PE_PERSON_SV is used to manipulate the secured information about persons stored in the database.
APPS.IGS_PE_PERSON_SV·↳ FND_LOOKUP_VALUES·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore IGS module →
-
View: IGS_AV_STND_UNIT_LVL_V 12.1.1
APPS.IGS_AV_STND_UNIT_LVL_V·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·↳ IGS_AV_STND_UNIT_LVL·Explore IGS module →
-
View: IGS_AD_SS_INTPER_V 12.1.1
INS Dependent details
APPS.IGS_AD_SS_INTPER_V·↳ FND_LOOKUP_VALUES·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore IGS module →
-
View: AMS_HZ_B2B_MAPPING_V 12.2.2
This view stores the mapping of ams_imp_source_lines table. This is used to populate the data from the data file.
APPS.AMS_HZ_B2B_MAPPING_V·↳ AMS_IMP_LIST_HEADERS_ALL·↳ AMS_IMP_SOURCE_LINES·Explore AMS module →
-
View: AMS_PARTIES_V 12.2.2
APPS.AMS_PARTIES_V·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore AMS module →
-
Relationships between entities
APPS.AMS_PERSON_RELATIONSHIPS_V·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore AMS 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 →
-
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.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 →
-
View: AMS_HZ_B2B_MAPPING_V 12.1.1
This view stores the mapping of ams_imp_source_lines table. This is used to populate the data from the data file.
APPS.AMS_HZ_B2B_MAPPING_V·↳ AMS_IMP_LIST_HEADERS_ALL·↳ AMS_IMP_SOURCE_LINES·Explore AMS module →
-
View: IGS_PE_PERSON_V 12.1.1
APPS.IGS_PE_PERSON_V·↳ FND_LOOKUP_VALUES·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore IGS module →
-
Business view template from which the flexfield view is generated.
APPS.HRFV_EMPLOYEE_ASSIGNMENTS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_ALL_POSITIONS_F_TL·↳ HR_BIS·Explore PER module →
-
Business view template from which the flexfield view is generated.
APPS.HRFV_EMPLOYEE_ASSIGNMENTS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_ALL_POSITIONS_F_TL·↳ HR_BIS·Explore PER module →
-
View: IGS_PE_PERSON 12.1.1
IGS_PE_PERSON is used to manipulate the information about persons stored in the database.
APPS.IGS_PE_PERSON·↳ FND_LOOKUP_VALUES·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore IGS module →
-
View: IGS_AV_STND_UNIT_LVL_V 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGS_AS_EXM_SUPRVISOR_V 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGS_AV_STND_UNIT_DTL_V 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGS_RC_I_PERSON_V 12.1.1
Person View
Not implemented in this database·Explore IGS module →
-
View: IGS_AV_STND_UNIT_V 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGS_AD_ENQ_PERSON_V 12.2.2
Obsolete
Not implemented in this database·Explore IGS module →
-
VIEW: APPS.IGS_PR_DISPLAY_V 12.1.1