Results for “student_status”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
EDWBV_HR_PERM_ASSIGN_LCV is a database view belonging to the HRI — Human Resources Intelligence product family within Oracle E-Business Suite. In ETRM (E-Business Suite Technical Reference Manual) documentation this module is flagged as Obsolete, meaning Oracle no longer actively supports or ships it in current 12.1.1 / 12.2.2 environments. ETRM explicitly notes for this object: "Not implemented in this database." Consequently, in a stock or standard 12.1.1 / 12.2.2 installation the view will typically not exist; it appears only in older deployments where the HRI product or its associated EDW (Enterprise Data Warehouse) staging components were licensed and installed.
The view is a "permanent assignment" (PERM_ASSIGN) low-level conformed view, denoted by the LCV suffix (Load Conformed View). It exposes a person-centric assignment dimension intended for dimensional reporting and ETL into warehouse schemas. It converts transactional HR person and assignment records into a flattened, denormalised row suitable for star-schema loading.
Underlying Base Objects
ETRM documents no referenced base objects for this view. This is consistent with the view being defined entirely through inline SQL over synonyms and package calls rather than through a formal object dependency list. Inspection of the view text reveals references to core HR person data (aliased PEO, referencing PERSON_ID, FULL_NAME, EMPLOYEE_NUMBER, APPLICANT_NUMBER, BUSINESS_GROUP_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, etc.), a period-of-service style source (PPS, supplying DATE_START and ACTUAL_TERMINATION_DATE), a business group source (BGR.NAME), and an instance registry (INST.INSTANCE_CODE). It also calls the HRI_EDW_DIM_PERSON package functions GET_NEAREST_PARENT, IS_A_BUYER, IS_A_PLANNER, and IS_A_SALES_REP, plus HR_GENERAL.DECODE_LOOKUP.
Key Columns
- ASSIGNMENT_PK — composite key of PERSON_ID, INSTANCE_CODE, and a literal type tag ("EMPLOYEE-PERS").
- ALL_FK — constant 'ALL' pseudo-key used to drive an "all values" outer dimension row.
- SPRVSR_LVL1_FK — supervisor hierarchy key derived from TREE.SUB_PERSON_ID and TREE.SUB_LEVEL, with nearest-parent fallback.
- NAME / PERSON_DP / FULL_NAME / LAST_NAME / FIRST_NAME / MIDDLE_NAMES — person descriptive attributes.
- PERSON_NUM — employee or applicant number.
- BUSINESS_GROUP / ORGANIZATION_ID — legal employer context.
- START_DATE / END_DATE — assignment period boundaries.
- EMPLOYEE_FLAG / APPLICANT_FLAG / BUYER_FLAG / PLANNER_FLAG / SALES_REP_FLAG — role indicators decoded through the YES_NO lookup.
- SYS_GEN_FLAG — system-generated marker, hard-coded 'N'.
- SALESREP_ID / PLANNER_CODE — null placeholders for downstream role-specific keys.
- INSTANCE — source instance code for multi-instance consolidation.
Common Use Cases and Queries
The view supports HR workforce dimensional reporting and historical ETL. Typical usage filters on the instance and role flags, or joins the surrogate keys to supervisor or business-group dimensions.
SELECT person_id,
person_num,
full_name,
business_group,
start_date,
end_date,
employee_flag
FROM edwbv_hr_perm_assign_lcv
WHERE instance = :p_instance
AND employee_flag = 'Yes'
ORDER BY full_name;
Because ETRM classifies HRI as obsolete, teams migrating to 12.2.2 should plan to replace this view with standard HRMS extracts (PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F) or Oracle BI Applications HR subject areas before upgrading.
-
Lookup Type: STUDENT_STATUS 12.1.1
Student status
-
Lookup Type: STUDENT_STATUS 12.2.2
Student status
-
APPS.EDWBV_HR_PERM_ASSIGN_LCV·↳ EDW_LOCAL_INSTANCE·↳ FND_LANGUAGES·↳ FND_TERRITORIES_VL·Explore HRI module →
-
View: PER_PEOPLE_F 12.1.1
Secure view based on the corresponding _ALL_ table.
APPS.PER_PEOPLE_F·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PER module →
-
View: PER_ALL_PEOPLE_D 12.1.1
Used by Datetrack History
APPS.PER_ALL_PEOPLE_D·↳ FND_GLOBAL·↳ FND_USER·↳ HR_API·Explore PER module →
-
View: PER_ALL_PEOPLE_D 12.2.2
Used by Datetrack History
APPS.PER_ALL_PEOPLE_D·↳ FND_USER·↳ HR_API·↳ HR_GENERAL·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 →
-
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 →
-
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: PER_PEOPLE_F 12.2.2
Secure view based on the corresponding _ALL_ table.
APPS.PER_PEOPLE_F·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PER module →
-
View: HRU_JP_CREATE_EDUC_ADD 12.1.1
This view is Japanaes specific.
-
View: GHR_MT_PEOPLE_F_V 12.2.2
This views is used by mass transfer in and out processes for datatransfer.
-
View: PER_PEOPLE_X 12.2.2
Date-effective view.
APPS.PER_PEOPLE_X·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PER module →
-
View: PER_ALL_PEOPLE 12.1.1
Date-effective view.
APPS.PER_ALL_PEOPLE·↳ FND_SESSIONS·↳ HR_PERSON_NAME·↳ PER_ALL_PEOPLE_F·Explore PER module →
-
View: HR_EMPLOYEE_API_V 12.2.2
APPS.HR_EMPLOYEE_API_V·↳ PER_ADDRESSES·↳ PER_ALL_ASSIGNMENTS_F·↳ PER_ALL_PEOPLE_F·Explore PER module →
-
View: EDW_HR_PERM_ASSIGN_LCV 12.1.1
APPS.EDW_HR_PERM_ASSIGN_LCV·↳ EDWBV_HR_PERM_ASSIGN_LCV·↳ HRI_EDW_DIM_PERSON·↳ HR_GENERAL·Explore HRI 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.2.2
This view is Japanaes specific.
-
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: GHR_PEOPLE_H_V 12.1.1
Mapping of GHR_PA_HISTORY columns to PER_ALL_PEOPLE_F.
APPS.GHR_PEOPLE_H_V·↳ FND_DATE·↳ GHR_GENERAL·↳ GHR_PA_HISTORY·Explore GHR module →
-
View: PER_PEOPLE_V2 12.1.1
Used to support user interface
APPS.PER_PEOPLE_V2·↳ FND_GLOBAL·↳ FND_SESSIONS·↳ HR_API·Explore PER module →
-
View: PER_PEOPLE_X 12.1.1
Date-effective view.
APPS.PER_PEOPLE_X·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PER module →
-
View: PER_PEOPLE 12.2.2
Date-effective view.
APPS.PER_PEOPLE·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore PER module →
-
View: PER_PEOPLE 12.1.1
Date-effective view.
APPS.PER_PEOPLE·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore PER module →
-
View: PER_ALL_PEOPLE 12.2.2
Date-effective view.
APPS.PER_ALL_PEOPLE·↳ FND_SESSIONS·↳ HR_PERSON_NAME·↳ PER_ALL_PEOPLE_F·Explore PER module →
-
View: PER_PEOPLE_V2 12.2.2
Used to support user interface
APPS.PER_PEOPLE_V2·↳ FND_SESSIONS·↳ HR_API·↳ HR_GENERAL·Explore PER module →
-
View: GHR_MT_PEOPLE_F_V 12.1.1
This views is used by mass transfer in and out processes for datatransfer.
-
DateTracked table holding personal information for employees, applicants and other people.
-
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: GHR_PEOPLE_H_V 12.2.2
Mapping of GHR_PA_HISTORY columns to PER_ALL_PEOPLE_F.
APPS.GHR_PEOPLE_H_V·↳ FND_DATE·↳ GHR_GENERAL·↳ GHR_PA_HISTORY·Explore GHR 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: 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 →
-
View: PER_PEOPLE_V3 12.1.1
Used to support user interface
APPS.PER_PEOPLE_V3·↳ FND_GLOBAL·↳ FND_SESSIONS·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →
-
View: PER_PEOPLE_V3 12.2.2
Used to support user interface
APPS.PER_PEOPLE_V3·↳ FND_SESSIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PER module →
-
DateTracked table holding personal information for employees, applicants and other people.
-
View: HR_EMPLOYEE_API_V 12.1.1
APPS.HR_EMPLOYEE_API_V·↳ PER_ADDRESSES·↳ PER_ALL_ASSIGNMENTS_F·↳ PER_ALL_PEOPLE_F·Explore PER module →
-
View: EDW_HR_PERM_ASSIGN_LCV 12.2.2
Not implemented in this database·Explore HRI module →
-
Not implemented in this database·Explore HRI module →
-
VIEW: APPS.PER_ALL_PEOPLE_D 12.2.2
-
VIEW: APPS.PER_ALL_PEOPLE_D 12.1.1