eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

Oracle eBusiness Suite Technical Reference

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - HRI Tables and Views

TABLE - HRI.EDW_HR_AGE_AGE_BAND_LSTG
TABLE - HRI.EDW_HR_AGE_AGE_BAND_LTC
TABLE - HRI.EDW_HR_AGE_BAND_A_LTC
TABLE - HRI.EDW_HR_AGE_BAND_M
TABLE - HRI.EDW_HR_ASCH_ASG_CHNG_LSTG
TABLE - HRI.EDW_HR_ASCH_ASG_CHNG_LTC
TABLE - HRI.EDW_HR_ASGN_ASSGNMNT_LSTG
TABLE - HRI.EDW_HR_ASGN_ASSGNMNT_LTC
TABLE - HRI.EDW_HR_ASG_CHNG_A_LTC
TABLE - HRI.EDW_HR_ASG_CHNG_M
TABLE - HRI.EDW_HR_ASSGNMNT_A_LTC
TABLE - HRI.EDW_HR_ASSGNMNT_M
TABLE - HRI.EDW_HR_GRADE_A_LTC
TABLE - HRI.EDW_HR_GRADE_M
TABLE - HRI.EDW_HR_GRD_GRADES_LSTG
TABLE - HRI.EDW_HR_GRD_GRADES_LTC
TABLE - HRI.EDW_HR_JOBS_A_LTC
TABLE - HRI.EDW_HR_JOBS_M
TABLE - HRI.EDW_HR_JOB_JOBS_LSTG
TABLE - HRI.EDW_HR_JOB_JOBS_LTC
TABLE - HRI.EDW_HR_MVMNT_TYP_A_LTC
TABLE - HRI.EDW_HR_MVMNT_TYP_M
TABLE - HRI.EDW_HR_MVMT_GAIN_1_LSTG
TABLE - HRI.EDW_HR_MVMT_GAIN_1_LTC
TABLE - HRI.EDW_HR_MVMT_GAIN_2_LSTG
TABLE - HRI.EDW_HR_MVMT_GAIN_2_LTC
TABLE - HRI.EDW_HR_MVMT_GAIN_3_LSTG
TABLE - HRI.EDW_HR_MVMT_GAIN_3_LTC
TABLE - HRI.EDW_HR_MVMT_LOSS_1_LSTG
TABLE - HRI.EDW_HR_MVMT_LOSS_1_LTC
TABLE - HRI.EDW_HR_MVMT_LOSS_2_LSTG
TABLE - HRI.EDW_HR_MVMT_LOSS_2_LTC
TABLE - HRI.EDW_HR_MVMT_LOSS_3_LSTG
TABLE - HRI.EDW_HR_MVMT_LOSS_3_LTC
TABLE - HRI.EDW_HR_MVMT_MVMNTS_LSTG
TABLE - HRI.EDW_HR_MVMT_MVMNTS_LTC
TABLE - HRI.EDW_HR_MVMT_RCTMNT_1_LSTG
TABLE - HRI.EDW_HR_MVMT_RCTMNT_1_LTC
TABLE - HRI.EDW_HR_MVMT_RCTMNT_2_LSTG
TABLE - HRI.EDW_HR_MVMT_RCTMNT_2_LTC
TABLE - HRI.EDW_HR_MVMT_RCTMNT_3_LSTG
TABLE - HRI.EDW_HR_MVMT_RCTMNT_3_LTC
TABLE - HRI.EDW_HR_MVMT_SPRTN_1_LSTG
TABLE - HRI.EDW_HR_MVMT_SPRTN_1_LTC
TABLE - HRI.EDW_HR_MVMT_SPRTN_2_LSTG
TABLE - HRI.EDW_HR_MVMT_SPRTN_2_LTC
TABLE - HRI.EDW_HR_MVMT_SPRTN_3_LSTG
TABLE - HRI.EDW_HR_MVMT_SPRTN_3_LTC
TABLE - HRI.EDW_HR_PERM_ASSIGN_LSTG
TABLE - HRI.EDW_HR_PERM_ASSIGN_LTC
TABLE - HRI.EDW_HR_PERM_SPSR1_L10_LSTG
TABLE - HRI.EDW_HR_PERM_SPSR1_L10_LTC
TABLE - HRI.EDW_HR_PERM_SPSR1_L11_LSTG
TABLE - HRI.EDW_HR_PERM_SPSR1_L11_LTC
TABLE - HRI.EDW_HR_PERM_SPSR1_L12_LSTG
TABLE - HRI.EDW_HR_PERM_SPSR1_L12_LTC
TABLE - HRI.EDW_HR_PERM_SPSR1_L13_LSTG
TABLE - HRI.EDW_HR_PERM_SPSR1_L13_LTC
TABLE - HRI.EDW_HR_PERM_SPSR1_L14_LSTG
TABLE - HRI.EDW_HR_PERM_SPSR1_L14_LTC
TABLE - HRI.EDW_HR_PERM_SPSR1_L15_LSTG
TABLE - HRI.EDW_HR_PERM_SPSR1_L15_LTC
TABLE - HRI.EDW_HR_PERM_SPSR1_L1_LSTG
TABLE - HRI.EDW_HR_PERM_SPSR1_L1_LTC
TABLE - HRI.EDW_HR_PERM_SPSR1_L2_LSTG
TABLE - HRI.EDW_HR_PERM_SPSR1_L2_LTC
TABLE - HRI.EDW_HR_PERM_SPSR1_L3_LSTG
TABLE - HRI.EDW_HR_PERM_SPSR1_L3_LTC
TABLE - HRI.EDW_HR_PERM_SPSR1_L4_LSTG
TABLE - HRI.EDW_HR_PERM_SPSR1_L4_LTC
TABLE - HRI.EDW_HR_PERM_SPSR1_L5_LSTG
TABLE - HRI.EDW_HR_PERM_SPSR1_L5_LTC
TABLE - HRI.EDW_HR_PERM_SPSR1_L6_LSTG
TABLE - HRI.EDW_HR_PERM_SPSR1_L6_LTC
TABLE - HRI.EDW_HR_PERM_SPSR1_L7_LSTG
TABLE - HRI.EDW_HR_PERM_SPSR1_L7_LTC
TABLE - HRI.EDW_HR_PERM_SPSR1_L8_LSTG
TABLE - HRI.EDW_HR_PERM_SPSR1_L8_LTC
TABLE - HRI.EDW_HR_PERM_SPSR1_L9_LSTG
TABLE - HRI.EDW_HR_PERM_SPSR1_L9_LTC
TABLE - HRI.EDW_HR_PERSON_A_LTC
TABLE - HRI.EDW_HR_PERSON_M
TABLE - HRI.EDW_HR_POSITION_A_LTC
TABLE - HRI.EDW_HR_POSITION_M
TABLE - HRI.EDW_HR_PRSN_TYP_A_LTC
TABLE - HRI.EDW_HR_PRSN_TYP_M
TABLE - HRI.EDW_HR_PSTN_POSITION_LSTG
TABLE - HRI.EDW_HR_PSTN_POSITION_LTC
TABLE - HRI.EDW_HR_PTYP_PRSN_TYP_LSTG
TABLE - HRI.EDW_HR_PTYP_PRSN_TYP_LTC
TABLE - HRI.EDW_HR_RACT_ACTIVITY_LSTG
TABLE - HRI.EDW_HR_RACT_ACTIVITY_LTC
TABLE - HRI.EDW_HR_RACT_ACT_TYPE_LSTG
TABLE - HRI.EDW_HR_RACT_ACT_TYPE_LTC
TABLE - HRI.EDW_HR_REASON_A_LTC
TABLE - HRI.EDW_HR_REASON_M
TABLE - HRI.EDW_HR_REC_ACT_A_LTC
TABLE - HRI.EDW_HR_REC_ACT_M
TABLE - HRI.EDW_HR_RQN_VCNCY_A_LTC
TABLE - HRI.EDW_HR_RQN_VCNCY_M
TABLE - HRI.EDW_HR_RQVC_REQUISTN_LSTG
TABLE - HRI.EDW_HR_RQVC_REQUISTN_LTC
TABLE - HRI.EDW_HR_RQVC_VACANCY_LSTG
TABLE - HRI.EDW_HR_RQVC_VACANCY_LTC
TABLE - HRI.EDW_HR_RSON_REASONS_LSTG
TABLE - HRI.EDW_HR_RSON_REASONS_LTC
TABLE - HRI.EDW_HR_SERVICE_A_LTC
TABLE - HRI.EDW_HR_SERVICE_M
TABLE - HRI.EDW_HR_SRVC_SRV_BAND_LSTG
TABLE - HRI.EDW_HR_SRVC_SRV_BAND_LTC
TABLE - HRI.EDW_ORGANIZATION_A_LTC
TABLE - HRI.EDW_ORGANIZATION_M
TABLE - HRI.EDW_ORGA_BUSINESS_GRP_LSTG
TABLE - HRI.EDW_ORGA_BUSINESS_GRP_LTC
TABLE - HRI.EDW_ORGA_LEG_ENTITY_LSTG
TABLE - HRI.EDW_ORGA_LEG_ENTITY_LTC
TABLE - HRI.EDW_ORGA_OPER_UNIT_LSTG
TABLE - HRI.EDW_ORGA_OPER_UNIT_LTC
TABLE - HRI.EDW_ORGA_ORG_LSTG
TABLE - HRI.EDW_ORGA_ORG_LTC
TABLE - HRI.EDW_ORGA_TREE1_LVL1_LSTG
TABLE - HRI.EDW_ORGA_TREE1_LVL1_LTC
TABLE - HRI.EDW_ORGA_TREE1_LVL2_LSTG
TABLE - HRI.EDW_ORGA_TREE1_LVL2_LTC
TABLE - HRI.EDW_ORGA_TREE1_LVL3_LSTG
TABLE - HRI.EDW_ORGA_TREE1_LVL3_LTC
TABLE - HRI.EDW_ORGA_TREE1_LVL4_LSTG
TABLE - HRI.EDW_ORGA_TREE1_LVL4_LTC
TABLE - HRI.EDW_ORGA_TREE1_LVL5_LSTG
TABLE - HRI.EDW_ORGA_TREE1_LVL5_LTC
TABLE - HRI.EDW_ORGA_TREE1_LVL6_LSTG
TABLE - HRI.EDW_ORGA_TREE1_LVL6_LTC
TABLE - HRI.EDW_ORGA_TREE1_LVL7_LSTG
TABLE - HRI.EDW_ORGA_TREE1_LVL7_LTC
TABLE - HRI.EDW_ORGA_TREE1_LVL8_LSTG
TABLE - HRI.EDW_ORGA_TREE1_LVL8_LTC
TABLE - HRI.HRI_AGE_BANDS
TABLE - HRI.HRI_DBI_DR_WMV_CHGS
TABLE - HRI.HRI_DBI_TOT_WMV_CHGS
TABLE - HRI.HRI_EDW_CMPSTN_SNPSHT_DTS
TABLE - HRI.HRI_EDW_DAILY_SALARY_DETAILS
TABLE - HRI.HRI_EDW_EVENT_HRCHYS
TABLE - HRI.HRI_EDW_EVENT_HRCHY_CMBNS
TABLE - HRI.HRI_EDW_PERIOD_OF_SERVICE
TABLE - HRI.HRI_EDW_USER_EVENTS
TABLE - HRI.HRI_EDW_USER_PERSON_TYPES
TABLE - HRI.HRI_GEN_HRCHY_SUMMARY
TABLE - HRI.HRI_INV_SPRTN_RSNS
TABLE - HRI.HRI_JOB_CATEGORY_SETS
TABLE - HRI.HRI_MAP_SUP_WRKFC_ASG
TABLE - HRI.HRI_ORG_HRCHY_SUMMARY
TABLE - HRI.HRI_ORG_PARAMS
TABLE - HRI.HRI_ORG_PARAM_LIST
TABLE - HRI.HRI_PERSON_TYPE_CMBNS
TABLE - HRI.HRI_PRIMARY_HRCHYS
TABLE - HRI.HRI_RECRUITMENT_STAGES
TABLE - HRI.HRI_SERVICE_BANDS
TABLE - HRI.HRI_SUPV_HRCHY_SUMMARY
TABLE - HRI.HR_EDW_WRK_ACTVTY_F
TABLE - HRI.HR_EDW_WRK_ACTVTY_FSTG
TABLE - HRI.HR_EDW_WRK_CMPSTN_F
TABLE - HRI.HR_EDW_WRK_CMPSTN_FSTG
TABLE - HRI.HR_EDW_WRK_RCTMNT_F
TABLE - HRI.HR_EDW_WRK_RCTMNT_FSTG
TABLE - HRI.HR_EDW_WRK_SPRTN_F
TABLE - HRI.HR_EDW_WRK_SPRTN_FSTG
VIEW - APPS.EDWBV_HR_AGE_AGE_BAND_LCV
VIEW - APPS.EDWBV_HR_ASCH_ASG_CHNG_LCV
VIEW - APPS.EDWBV_HR_ASGN_ASSGNMNT_LCV
VIEW - APPS.EDWBV_HR_GRD_GRADES_LCV
VIEW - APPS.EDWBV_HR_JOB_JOBS_LCV
VIEW - APPS.EDWBV_HR_MVMT_GAIN_1_LCV
VIEW - APPS.EDWBV_HR_MVMT_GAIN_2_LCV
VIEW - APPS.EDWBV_HR_MVMT_GAIN_3_LCV
VIEW - APPS.EDWBV_HR_MVMT_LOSS_1_LCV
VIEW - APPS.EDWBV_HR_MVMT_LOSS_2_LCV
VIEW - APPS.EDWBV_HR_MVMT_LOSS_3_LCV
VIEW - APPS.EDWBV_HR_MVMT_MVMNTS_LCV
VIEW - APPS.EDWBV_HR_MVMT_RCTMNT_1_LCV
VIEW - APPS.EDWBV_HR_MVMT_RCTMNT_2_LCV
VIEW - APPS.EDWBV_HR_MVMT_RCTMNT_3_LCV
VIEW - APPS.EDWBV_HR_MVMT_SPRTN_1_LCV
VIEW - APPS.EDWBV_HR_MVMT_SPRTN_2_LCV
VIEW - APPS.EDWBV_HR_MVMT_SPRTN_3_LCV
VIEW - APPS.EDWBV_HR_PERM_ASSIGN_LCV
VIEW - APPS.EDWBV_HR_PERM_SPSR1_L10_LCV
VIEW - APPS.EDWBV_HR_PERM_SPSR1_L11_LCV
VIEW - APPS.EDWBV_HR_PERM_SPSR1_L12_LCV
VIEW - APPS.EDWBV_HR_PERM_SPSR1_L13_LCV
VIEW - APPS.EDWBV_HR_PERM_SPSR1_L14_LCV
VIEW - APPS.EDWBV_HR_PERM_SPSR1_L15_LCV
VIEW - APPS.EDWBV_HR_PERM_SPSR1_L1_LCV
VIEW - APPS.EDWBV_HR_PERM_SPSR1_L2_LCV
VIEW - APPS.EDWBV_HR_PERM_SPSR1_L3_LCV
VIEW - APPS.EDWBV_HR_PERM_SPSR1_L4_LCV
VIEW - APPS.EDWBV_HR_PERM_SPSR1_L5_LCV
VIEW - APPS.EDWBV_HR_PERM_SPSR1_L6_LCV
VIEW - APPS.EDWBV_HR_PERM_SPSR1_L7_LCV
VIEW - APPS.EDWBV_HR_PERM_SPSR1_L8_LCV
VIEW - APPS.EDWBV_HR_PERM_SPSR1_L9_LCV
VIEW - APPS.EDWBV_HR_PSTN_POSITION_LCV
VIEW - APPS.EDWBV_HR_PTYP_PRSN_TYP_LCV
VIEW - APPS.EDWBV_HR_RACT_ACTIVITY_LCV
VIEW - APPS.EDWBV_HR_RACT_ACT_TYPE_LCV
VIEW - APPS.EDWBV_HR_RQVC_REQUISTN_LCV
VIEW - APPS.EDWBV_HR_RQVC_VACANCY_LCV
VIEW - APPS.EDWBV_HR_RSON_REASONS_LCV
VIEW - APPS.EDWBV_HR_SRVC_SRV_BAND_LCV
VIEW - APPS.EDWBV_ORGA_BUSINESS_GRP_LCV
VIEW - APPS.EDWBV_ORGA_LEG_ENTITY_LCV
VIEW - APPS.EDWBV_ORGA_OPER_UNIT_LCV
VIEW - APPS.EDWBV_ORGA_ORG_LCV
VIEW - APPS.EDWBV_ORGA_TREE1_LVL1_LCV
VIEW - APPS.EDWBV_ORGA_TREE1_LVL2_LCV
VIEW - APPS.EDWBV_ORGA_TREE1_LVL3_LCV
VIEW - APPS.EDWBV_ORGA_TREE1_LVL4_LCV
VIEW - APPS.EDWBV_ORGA_TREE1_LVL5_LCV
VIEW - APPS.EDWBV_ORGA_TREE1_LVL6_LCV
VIEW - APPS.EDWBV_ORGA_TREE1_LVL7_LCV
VIEW - APPS.EDWBV_ORGA_TREE1_LVL8_LCV
VIEW - APPS.EDW_HR_AGE_AGE_BAND_LCV
VIEW - APPS.EDW_HR_AGE_BAND_FKV
VIEW - APPS.EDW_HR_ASCH_ASG_CHNG_LCV
VIEW - APPS.EDW_HR_ASGN_ASSGNMNT_LCV
VIEW - APPS.EDW_HR_GRD_GRADES_LCV
VIEW - APPS.EDW_HR_JOB_JOBS_LCV
VIEW - APPS.EDW_HR_MVMT_GAIN_1_LCV
VIEW - APPS.EDW_HR_MVMT_GAIN_2_LCV
VIEW - APPS.EDW_HR_MVMT_GAIN_3_LCV
VIEW - APPS.EDW_HR_MVMT_LOSS_1_LCV
VIEW - APPS.EDW_HR_MVMT_LOSS_2_LCV
VIEW - APPS.EDW_HR_MVMT_LOSS_3_LCV
VIEW - APPS.EDW_HR_MVMT_MVMNTS_LCV
VIEW - APPS.EDW_HR_MVMT_RCTMNT_1_LCV
VIEW - APPS.EDW_HR_MVMT_RCTMNT_2_LCV
VIEW - APPS.EDW_HR_MVMT_RCTMNT_3_LCV
VIEW - APPS.EDW_HR_MVMT_SPRTN_1_LCV
VIEW - APPS.EDW_HR_MVMT_SPRTN_2_LCV
VIEW - APPS.EDW_HR_MVMT_SPRTN_3_LCV
VIEW - APPS.EDW_HR_PERM_ASSIGN_LCV
VIEW - APPS.EDW_HR_PERM_SPSR1_L10_LCV
VIEW - APPS.EDW_HR_PERM_SPSR1_L11_LCV
VIEW - APPS.EDW_HR_PERM_SPSR1_L12_LCV
VIEW - APPS.EDW_HR_PERM_SPSR1_L13_LCV
VIEW - APPS.EDW_HR_PERM_SPSR1_L14_LCV
VIEW - APPS.EDW_HR_PERM_SPSR1_L15_LCV
VIEW - APPS.EDW_HR_PERM_SPSR1_L1_LCV
VIEW - APPS.EDW_HR_PERM_SPSR1_L2_LCV
VIEW - APPS.EDW_HR_PERM_SPSR1_L3_LCV
VIEW - APPS.EDW_HR_PERM_SPSR1_L4_LCV
VIEW - APPS.EDW_HR_PERM_SPSR1_L5_LCV
VIEW - APPS.EDW_HR_PERM_SPSR1_L6_LCV
VIEW - APPS.EDW_HR_PERM_SPSR1_L7_LCV
VIEW - APPS.EDW_HR_PERM_SPSR1_L8_LCV
VIEW - APPS.EDW_HR_PERM_SPSR1_L9_LCV
VIEW - APPS.EDW_HR_PRSN_TYP_FKV
VIEW - APPS.EDW_HR_PSTN_POSITION_LCV
VIEW - APPS.EDW_HR_PTYP_PRSN_TYP_LCV
VIEW - APPS.EDW_HR_RACT_ACTIVITY_LCV
VIEW - APPS.EDW_HR_RACT_ACT_TYPE_LCV
VIEW - APPS.EDW_HR_REC_ACT_FKV
VIEW - APPS.EDW_HR_RQN_VCNCY_FKV
VIEW - APPS.EDW_HR_RQVC_REQUISTN_LCV
VIEW - APPS.EDW_HR_RQVC_VACANCY_LCV
VIEW - APPS.EDW_HR_RSON_REASONS_LCV
VIEW - APPS.EDW_HR_SERVICE_FKV
VIEW - APPS.EDW_HR_SRVC_SRV_BAND_LCV
VIEW - APPS.EDW_ORGA_BUSINESS_GRP_LCV
VIEW - APPS.EDW_ORGA_LEG_ENTITY_LCV
VIEW - APPS.EDW_ORGA_OPER_UNIT_LCV
VIEW - APPS.EDW_ORGA_ORG_LCV
VIEW - APPS.EDW_ORGA_TREE1_LVL1_LCV
VIEW - APPS.EDW_ORGA_TREE1_LVL2_LCV
VIEW - APPS.EDW_ORGA_TREE1_LVL3_LCV
VIEW - APPS.EDW_ORGA_TREE1_LVL4_LCV
VIEW - APPS.EDW_ORGA_TREE1_LVL5_LCV
VIEW - APPS.EDW_ORGA_TREE1_LVL6_LCV
VIEW - APPS.EDW_ORGA_TREE1_LVL7_LCV
VIEW - APPS.EDW_ORGA_TREE1_LVL8_LCV
VIEW - APPS.HRIBV_ASGMVORGHRCHY
VIEW - APPS.HRIBV_ORG_HRCHY
VIEW - APPS.HRIBV_ORG_HRCHY_ROLLUP
VIEW - APPS.HRIBV_SUPV_HRCHY_ROLLUP_X
VIEW - APPS.HRIBV_SUPV_HRCHY_X
VIEW - APPS.HRIBV_TRNCNTR_HRCHY
VIEW - APPS.HRIBV_TRNCNTR_HRCHY_ROLLUP
VIEW - APPS.HRICV_HR_BIMONTH
VIEW - APPS.HRICV_HR_DAY
VIEW - APPS.HRICV_HR_MONTH
VIEW - APPS.HRICV_HR_QUARTER
VIEW - APPS.HRICV_HR_SEMIYEAR
VIEW - APPS.HRICV_HR_YEAR
VIEW - APPS.HRIFV_GRADE_RATES_BG
VIEW - APPS.HRIFV_PEREIT
VIEW - APPS.HRIFV_SAL_PRO
VIEW - APPS.HRIFV_US_EMPASGDTL_EMPXASG
VIEW - APPS.HRIFV_US_FEDREP_GEN_HRCHY
VIEW - APPS.HRIFV_US_FEDREP_GEN_H_LOCEXP
VIEW - APPS.HRIFV_US_PERDTL
VIEW - APPS.HRI_CL_AGE_BAND_X_V
VIEW - APPS.HRI_CL_ASGSTYP_BX_V
VIEW - APPS.HRI_CL_BUDPQH_H_V
VIEW - APPS.HRI_CL_CMPBEN_OBJ_X_V
VIEW - APPS.HRI_CL_CMPTNC_BX_V
VIEW - APPS.HRI_CL_EDU_ESTBMNT_V
VIEW - APPS.HRI_CL_EDU_EST_CAND_V
VIEW - APPS.HRI_CL_EDU_QUAL_AWRDBDY_V
VIEW - APPS.HRI_CL_EDU_QUAL_CAT_HX_V
VIEW - APPS.HRI_CL_EDU_QUAL_TITLE_V
VIEW - APPS.HRI_CL_EDU_QUAL_TYPE_V
VIEW - APPS.HRI_CL_EMPCAT_X_V
VIEW - APPS.HRI_CL_GB_ETHNC_X_V
VIEW - APPS.HRI_CL_GENDER_X_V
VIEW - APPS.HRI_CL_GRADE_BX_V
VIEW - APPS.HRI_CL_GRADE_TOTAL_V
VIEW - APPS.HRI_CL_JOB_BX_V
VIEW - APPS.HRI_CL_JOB_CAT_X_V
VIEW - APPS.HRI_CL_LOW_BAND_X_V
VIEW - APPS.HRI_CL_LOW_TOTAL_V
VIEW - APPS.HRI_CL_ORG_BGR_BX_V
VIEW - APPS.HRI_CL_ORG_CC_MGR_SUPH_V
VIEW - APPS.HRI_CL_ORG_CC_V
VIEW - APPS.HRI_CL_ORG_HRCYVRSN_BX_V
VIEW - APPS.HRI_CL_ORG_HRCY_BX_V
VIEW - APPS.HRI_CL_ORG_HR_HX_V
VIEW - APPS.HRI_CL_ORG_HR_H_V
VIEW - APPS.HRI_CL_ORG_INHV_H_V
VIEW - APPS.HRI_CL_ORG_SRHL_V
VIEW - APPS.HRI_CL_PDG_TOTAL_V
VIEW - APPS.HRI_CL_PER_CCMGR_V
VIEW - APPS.HRI_CL_PER_EMP_HX_V
VIEW - APPS.HRI_CL_PER_HIRMGR_HX_V
VIEW - APPS.HRI_CL_PER_HX_V
VIEW - APPS.HRI_CL_PER_RECMGR_HX_V
VIEW - APPS.HRI_CL_PER_SUP_HX_V
VIEW - APPS.HRI_CL_PER_USER_HX_V
VIEW - APPS.HRI_CL_PER_USRDR_H_V
VIEW - APPS.HRI_CL_PER_V
VIEW - APPS.HRI_CL_POSITION_HRCYVRSN_BX_V
VIEW - APPS.HRI_CL_POSITION_HX_V
VIEW - APPS.HRI_CL_POSITION_INHV_H_V
VIEW - APPS.HRI_CL_POSITION_TOTAL_V
VIEW - APPS.HRI_CL_PRF_RTNG_X_V
VIEW - APPS.HRI_CL_PTY_NONPTU_B_V
VIEW - APPS.HRI_CL_RECACT_SRCNAME_V
VIEW - APPS.HRI_CL_RECACT_TYPE_X_V
VIEW - APPS.HRI_CL_RQNVAC_PROFAREA_X_V
VIEW - APPS.HRI_CL_RQNVAC_REQSTN_BX_V
VIEW - APPS.HRI_CL_RQNVAC_VACCAT_X_V
VIEW - APPS.HRI_CL_RQNVAC_VACNCY_BX_V
VIEW - APPS.HRI_CL_RQNVAC_VACNCY_HX_V
VIEW - APPS.HRI_CL_RQNVAC_VACNCY_H_V
VIEW - APPS.HRI_CL_RQNVAC_VAC_STAT_X_V
VIEW - APPS.HRI_CL_RSN_SAL_X_V
VIEW - APPS.HRI_CL_RSN_SEP_X_V
VIEW - APPS.HRI_CL_RSN_TOTAL_V
VIEW - APPS.HRI_CL_TRAVEL_PERCENT_X_V
VIEW - APPS.HRI_CL_US_ETHNC_X_V
VIEW - APPS.HRI_CL_WAC_GAINTYP_X_V
VIEW - APPS.HRI_CL_WAC_LOSSTYP_X_V
VIEW - APPS.HRI_CL_WAC_SEPCAT_X_V
VIEW - APPS.HRI_CL_WAC_TOTAL_V
VIEW - APPS.HRI_CL_WMT_X_V
VIEW - APPS.HRI_CL_WORK_AT_HOME_X_V
VIEW - APPS.HRI_GRD_LOV_V
VIEW - APPS.HRI_JOB_LOV_V
VIEW - APPS.HRI_LOC_LOV_V
VIEW - APPS.HRI_ORG_LOV_V
VIEW - APPS.HR_EDWBV_WRK_ACTVTY_FCV
VIEW - APPS.HR_EDWBV_WRK_CMPSTN_FCV
VIEW - APPS.HR_EDWBV_WRK_RCTMNT_FCV
VIEW - APPS.HR_EDWBV_WRK_SPRTN_FCV
VIEW - APPS.HR_EDW_WRK_ACTVTY_FCV
VIEW - APPS.HR_EDW_WRK_CMPSTN_FCV
VIEW - APPS.HR_EDW_WRK_RCTMNT_FCV
VIEW - APPS.HR_EDW_WRK_SPRTN_FCV

Table: EDW_HR_AGE_AGE_BAND_LSTG

Description:

Foreign Key Column	Foreign Table
HRI_ORG_PARAM_LIST.ORG_PARAM_ID	HRI_ORG_PARAMS
HRI_ORG_PARAM_LIST.ORG_PARAM_ID	HRI_ORG_PARAMS


Copyright (c) 2001 - 2005, Oracle	- Use Restricted by Contract

Oracle eBusiness Suite Technical Reference

eTRM - HRI Tables and Views

Table: EDW_HR_AGE_AGE_BAND_LSTG

Table: EDW_HR_AGE_AGE_BAND_LTC

Table: EDW_HR_AGE_BAND_A_LTC

Table: EDW_HR_AGE_BAND_M

Primary Key: EDW_HR_AGE_BAND_M_PK

Table: EDW_HR_ASCH_ASG_CHNG_LSTG

Table: EDW_HR_ASCH_ASG_CHNG_LTC

Table: EDW_HR_ASGN_ASSGNMNT_LSTG

Table: EDW_HR_ASGN_ASSGNMNT_LTC

Table: EDW_HR_ASG_CHNG_A_LTC

Table: EDW_HR_ASG_CHNG_M

Primary Key: EDW_HR_ASG_CHNG_M_PK

Table: EDW_HR_ASSGNMNT_A_LTC

Table: EDW_HR_ASSGNMNT_M

Primary Key: EDW_HR_ASSGNMNT_M_PK

Table: EDW_HR_GRADE_A_LTC

Table: EDW_HR_GRADE_M

Primary Key: EDW_HR_GRADE_M_PK

Table: EDW_HR_GRD_GRADES_LSTG

Table: EDW_HR_GRD_GRADES_LTC

Table: EDW_HR_JOBS_A_LTC

Table: EDW_HR_JOBS_M

Primary Key: EDW_HR_JOBS_M_PK

Table: EDW_HR_JOB_JOBS_LSTG

Table: EDW_HR_JOB_JOBS_LTC

Table: EDW_HR_MVMNT_TYP_A_LTC

Table: EDW_HR_MVMNT_TYP_M

Primary Key: EDW_HR_MVMNT_TYP_M_PK

Table: EDW_HR_MVMT_GAIN_1_LSTG

Table: EDW_HR_MVMT_GAIN_1_LTC

Table: EDW_HR_MVMT_GAIN_2_LSTG

Table: EDW_HR_MVMT_GAIN_2_LTC

Table: EDW_HR_MVMT_GAIN_3_LSTG

Table: EDW_HR_MVMT_GAIN_3_LTC

Table: EDW_HR_MVMT_LOSS_1_LSTG

Table: EDW_HR_MVMT_LOSS_1_LTC

Table: EDW_HR_MVMT_LOSS_2_LSTG

Table: EDW_HR_MVMT_LOSS_2_LTC

Table: EDW_HR_MVMT_LOSS_3_LSTG

Table: EDW_HR_MVMT_LOSS_3_LTC

Table: EDW_HR_MVMT_MVMNTS_LSTG

Table: EDW_HR_MVMT_MVMNTS_LTC

Table: EDW_HR_MVMT_RCTMNT_1_LSTG

Table: EDW_HR_MVMT_RCTMNT_1_LTC

Table: EDW_HR_MVMT_RCTMNT_2_LSTG

Table: EDW_HR_MVMT_RCTMNT_2_LTC

Table: EDW_HR_MVMT_RCTMNT_3_LSTG

Table: EDW_HR_MVMT_RCTMNT_3_LTC

Table: EDW_HR_MVMT_SPRTN_1_LSTG

Table: EDW_HR_MVMT_SPRTN_1_LTC

Table: EDW_HR_MVMT_SPRTN_2_LSTG

Table: EDW_HR_MVMT_SPRTN_2_LTC

Table: EDW_HR_MVMT_SPRTN_3_LSTG

Table: EDW_HR_MVMT_SPRTN_3_LTC

Table: EDW_HR_PERM_ASSIGN_LSTG

Table: EDW_HR_PERM_ASSIGN_LTC

Table: EDW_HR_PERM_SPSR1_L10_LSTG

Table: EDW_HR_PERM_SPSR1_L10_LTC

Table: EDW_HR_PERM_SPSR1_L11_LSTG

Table: EDW_HR_PERM_SPSR1_L11_LTC

Table: EDW_HR_PERM_SPSR1_L12_LSTG

Table: EDW_HR_PERM_SPSR1_L12_LTC

Table: EDW_HR_PERM_SPSR1_L13_LSTG

Table: EDW_HR_PERM_SPSR1_L13_LTC

Table: EDW_HR_PERM_SPSR1_L14_LSTG

Table: EDW_HR_PERM_SPSR1_L14_LTC

Table: EDW_HR_PERM_SPSR1_L15_LSTG

Table: EDW_HR_PERM_SPSR1_L15_LTC

Table: EDW_HR_PERM_SPSR1_L1_LSTG

Table: EDW_HR_PERM_SPSR1_L1_LTC

Table: EDW_HR_PERM_SPSR1_L2_LSTG

Table: EDW_HR_PERM_SPSR1_L2_LTC

Table: EDW_HR_PERM_SPSR1_L3_LSTG

Table: EDW_HR_PERM_SPSR1_L3_LTC

Table: EDW_HR_PERM_SPSR1_L4_LSTG

Table: EDW_HR_PERM_SPSR1_L4_LTC

Table: EDW_HR_PERM_SPSR1_L5_LSTG

Table: EDW_HR_PERM_SPSR1_L5_LTC