ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9B79D2E0530100007F1FF2 PER Business Group Y select pbg.name value, hla.location_code description from per_business_groups pbg, hr_locations_all hla where pbg.location_id=hla.location_id(+) order by pbg.name US 768F99B5EC472895CD7AD06175A82484 select haouv.name business_group, ppst.name hierarchy_name, ppst.version_number hierarchy_version, level hierarchy_level, lpad(' ',(level-1)*3)||hapft.name position_name, hapft.name position, haouv2.name position_organization, pjv.name position_job, pgv.name position_grade, hla.location_code position_location, pap.fte, nvl(pap.max_persons,1) budgeted_headcount, ( select count(*) from per_all_assignments_f paaf, per_assignment_status_types past where pap.position_id=paaf.position_id and sysdate between paaf.effective_start_date and paaf.effective_end_date and paaf.primary_flag='Y' and paaf.assignment_type='E' and paaf.assignment_status_type_id=past.assignment_status_type_id and past.per_system_status='ACTIVE_ASSIGN' ) actual_headcount, nvl(pap.max_persons,1)-( select count(*) from per_all_assignments_f paaf, per_assignment_status_types past where pap.position_id=paaf.position_id and sysdate between paaf.effective_start_date and paaf.effective_end_date and paaf.primary_flag='Y' and paaf.assignment_type='E' and paaf.assignment_status_type_id=past.assignment_status_type_id and past.per_system_status='ACTIVE_ASSIGN' ) vacancy_count, ( select listagg(papf.full_name,', ') within group (order by papf.full_name) from per_all_assignments_f paaf, per_assignment_status_types past, per_all_people_f papf where pap.position_id=paaf.position_id and sysdate between paaf.effective_start_date and paaf.effective_end_date and paaf.primary_flag='Y' and paaf.assignment_type='E' and paaf.assignment_status_type_id=past.assignment_status_type_id and past.per_system_status='ACTIVE_ASSIGN' and paaf.person_id=papf.person_id and sysdate between papf.effective_start_date and papf.effective_end_date ) incumbents, pap.date_effective position_start_date, pap.date_end position_end_date, xxen_util.meaning(pap.status,'POSITION_STATUS',800) position_status from hr_all_organization_units_vl haouv, per_pos_structure_versions ppsv, per_pos_structure_elements ppse, (select hapf.* from hr_all_positions_f hapf where sysdate between hapf.effective_start_date and hapf.effective_end_date) pap, hr_all_positions_f_tl hapft, hr_all_organization_units_vl haouv2, per_jobs_vl pjv, per_grades_vl pgv, hr_locations_all hla, ( select ppst.*, ppsv.version_number, ppsv.pos_structure_version_id from per_position_structures ppst, per_pos_structure_versions ppsv where ppst.position_structure_id=ppsv.position_structure_id and sysdate between ppsv.date_from and nvl(ppsv.date_to,sysdate) ) ppst where 1=1 and ppst.business_group_id=haouv.organization_id and ppst.pos_structure_version_id=ppsv.pos_structure_version_id and ppsv.pos_structure_version_id=ppse.pos_structure_version_id and ppse.subordinate_position_id=pap.position_id and pap.position_id=hapft.position_id and hapft.language=userenv('lang') and pap.organization_id=haouv2.organization_id and pap.job_id=pjv.job_id(+) and pap.entry_grade_id=pgv.grade_id(+) and pap.location_id=hla.location_id(+) start with ppse.parent_position_id not in (select ppse2.subordinate_position_id from per_pos_structure_elements ppse2 where ppse2.pos_structure_version_id=ppsv.pos_structure_version_id) connect by prior ppse.subordinate_position_id=ppse.parent_position_id and prior ppse.pos_structure_version_id=ppse.pos_structure_version_id order siblings by hapft.name Y AR PER تقرير التدرج الوظيفي (بتنسيق XML) Imported from BI Publisher Description: التدرج الوظيفي Application: الموارد البشرية Source: تقرير التدرج الوظيفي (بتنسيق XML) Short Name: PERRPRPH_XML DB package: PER_PERRPRPH_XMLP_PKG D PER Positionshierarchie Imported from BI Publisher Description: Positionshierarchie Application: Human Resources Source: Positionshierarchie (XML) Short Name: PERRPRPH_XML DB package: PER_PERRPRPH_XMLP_PKG E PER Jerarquía de Posiciones Imported from BI Publisher Description: Jerarquía de posiciones Application: Human Resources Source: Jerarquía de Posiciones (XML) Short Name: PERRPRPH_XML DB package: PER_PERRPRPH_XMLP_PKG F PER Etat des hiérarchies de postes Imported from BI Publisher Description: Hiérarchie des postes Application: Human Resources Source: Etat des hiérarchies de postes (XML) Short Name: PERRPRPH_XML DB package: PER_PERRPRPH_XMLP_PKG I PER Rapporto Gerarchia posizione Imported from BI Publisher Description: Gerarchia posizione Application: Human Resources Source: Rapporto Gerarchia posizione (XML) Short Name: PERRPRPH_XML DB package: PER_PERRPRPH_XMLP_PKG JA PER 職階階層レポート Imported from BI Publisher Description: 職階階層 Application: Human Resources Source: 職階階層レポート(XML) Short Name: PERRPRPH_XML DB package: PER_PERRPRPH_XMLP_PKG KO PER Position 계층 보고서 Imported from BI Publisher Description: Position 계층 Application: HR Source: Position 계층 보고서(XML) Short Name: PERRPRPH_XML DB package: PER_PERRPRPH_XMLP_PKG PTB PER Relatório de Hierarquias da Posição Imported from BI Publisher Description: Hierarquia da Posição Application: Human Resources Source: Relatório de Hierarquias da Posição (XML) Short Name: PERRPRPH_XML DB package: PER_PERRPRPH_XMLP_PKG RU PER Отчет по иерархии штатных единиц Imported from BI Publisher Description: Иерархия штатных единиц Application: Персонал Source: Отчет по иерархии штатных единиц (XML) Short Name: PERRPRPH_XML DB package: PER_PERRPRPH_XMLP_PKG S PER Tjänstehierarki - rapport Imported from BI Publisher Description: Tjänstehierarki Application: Human Resources Source: Tjänstehierarki - rapport (XML) Short Name: PERRPRPH_XML DB package: PER_PERRPRPH_XMLP_PKG TR PER Pozisyon Hiyerarşi Raporu Imported from BI Publisher Description: Pozisyon Hiyerarşisi Application: İnsan Kaynakları Source: Pozisyon Hiyerarşi Raporu (XML) Short Name: PERRPRPH_XML DB package: PER_PERRPRPH_XMLP_PKG US PER Position Hierarchy Position hierarchy showing the reporting structure of positions with hierarchy level, organization, job, grade, location, budgeted vs actual headcount, vacancy count, and current incumbent names. Useful for position control, staffing analysis, and org chart construction. ZHS PER 职位层次结构报表 Imported from BI Publisher Description: 职位层次结构 Application: 人力资源管理系统 Source: 职位层次结构报表 (XML) Short Name: PERRPRPH_XML DB package: PER_PERRPRPH_XMLP_PKG BI Publisher Enginatics 1=1 1 10 1=1 haouv.name=:business_group LOV PER Business Group 8E2FF36EDE9B79D2E0530100007F1FF2 Y select pbg.name value, hla.location_code description from per_business_groups pbg, hr_locations_all hla where pbg.location_id=hla.location_id(+) order by pbg.name AR تاريخ الفعالية تاريخ الفعالية D Gültigkeitsdatum Gültigkeitsdatum E Fecha en Vigor Fecha en vigor F Date de validité Date de validité I Data validità Data di validità JA 有効日 有効日 KO 유효 일자 유효 일자 PTB Data de Efetivação Data de Efetivação RU Дата действия Дата действия S Giltighetsdatum Giltighetsdatum TR Geçerlilik Tarihi Geçerlilik Tarihi US Business Group ZHS 有效日期 有效日期 2 20 1=1 ppst.name=:hierarchy_name LOV custom Y select distinct ppst.name value, null description from per_position_structures ppst, per_pos_structure_versions ppsv where ppst.position_structure_id=ppsv.position_structure_id and sysdate between ppsv.date_from and nvl(ppsv.date_to,sysdate) order by ppst.name AR هيكل المناصب هيكل المناصب D Positionsstruktur Positionsstruktur E Estructura de la Posición Estructura de la posición F Structure du poste Structure du poste I Struttura posizione Struttura della posizione JA 職階体系 職階体系 KO Position 구조 Position 구조 PTB Estrutura da Posição Estrutura da Posição RU Структура штат. ед. Структура штат. ед. S Tjänstestruktur Tjänstestruktur TR Pozisyon Yapısı Pozisyon Yapısı US Hierarchy Name ZHS 职位结构 职位结构