Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

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.HRI_AGE_BANDS
TABLE - HRI.HRI_GEN_HRCHY_SUMMARY
TABLE - HRI.HRI_INV_SPRTN_RSNS
TABLE - HRI.HRI_JOB_CATEGORY_SETS
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
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_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_JOB_BX_V
VIEW - APPS.HRI_CL_JOB_CAT_X_V
VIEW - APPS.HRI_CL_ORG_BGR_BX_V
VIEW - APPS.HRI_CL_ORG_HRCY_BX_V
VIEW - APPS.HRI_CL_ORG_HR_HX_V
VIEW - APPS.HRI_CL_PER_EMP_HX_V
VIEW - APPS.HRI_CL_PER_HIRMGR_HX_V
VIEW - APPS.HRI_CL_PER_RECMGR_HX_V
VIEW - APPS.HRI_CL_PER_SUP_HX_V
VIEW - APPS.HRI_CL_POSITION_HX_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_VACNCY_H_V
VIEW - APPS.HRI_CL_RSN_SAL_X_V
VIEW - APPS.HRI_CL_RSN_SEP_X_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_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

Table: HRI_AGE_BANDS

Description:
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
BAND_MIN_TOTAL_MONTHS NUMBER

BAND_MAX_TOTAL_MONTHS NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

[top of page]

HRI.HRI_AGE_BANDS does not reference any database object

HRI.HRI_AGE_BANDS is referenced by following:

HRI
VIEW - HRI_AGE_BANDS#

[top of page]

Table: HRI_GEN_HRCHY_SUMMARY

Description: Generic Hierarchy Summary Table
Primary Key: HRI_GEN_HRCHY_SUMMARY_PK
  1. HIERARCHY_ID
  2. HIERARCHY_VERSION_ID
  3. HIERARCHY_NODE_ID
  4. SUB_HIERARCHY_NODE_ID
Comments

Collected Table for the Generic Organization Hierarchy, the table is populated by the concurrent process 'HRI Load All Generic Hierarchy Versions'.

Indexes
Index Type Tablespace Column
HRI_GEN_HRCHY_SUMMARY_N4 NONUNIQUE APPS_TS_SUMMARY HIERARCHY_ID
HIERARCHY_VERSION_ID
HIERARCHY_NODE_ID
SUB_HIERARCHY_NODE_ID
HRI_GEN_HRCHY_SUMMARY_N5 NONUNIQUE APPS_TS_SUMMARY HIERARCHY_ID
HIERARCHY_VERSION_ID
HIERARCHY_NODE_ID
ENTITY_ID
SUB_ENTITY_ID
SUB_HIERARCHY_NODE_ID
Columns
Name Datatype Length Mandatory Comments
HIERARCHY_ID NUMBER (15) Y Hierarhcy Id
HIERARCHY_VERSION_ID NUMBER (15) Y Hierarchy Version Id
BUSINESS_GROUP_ID NUMBER (9) Y Business Group Id
HIERARCHY_NODE_ID NUMBER (15) Y Parent Hierarchy Node Id
ENTITY_ID VARCHAR2 (255) Y Parent Entity Id
ENTITY_LEVEL NUMBER (4) Y Parent Entity Level
NODE_TYPE VARCHAR2 (30) Y Parent Node Type
SUB_ENTITY_BG_ID NUMBER (9) Y Child Entity Bg Id
SUB_ENTITY_ID VARCHAR2 (255) Y Child Entity Id
SUB_HIERARCHY_NODE_ID NUMBER (15) Y Child Hierarchy Node Id
SUB_ENTITY_LEVEL NUMBER (4) Y Child Entity Level
SUB_NODE_TYPE VARCHAR2 (30) Y Child Node Type
CREATION_DATE DATE
Y Standard WHO Column
CREATED_BY NUMBER (15) Y Standard WHO Column
LAST_UPDATE_DATE DATE
Y Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column

[top of page]

HRI.HRI_GEN_HRCHY_SUMMARY does not reference any database object

HRI.HRI_GEN_HRCHY_SUMMARY is referenced by following:

HRI
VIEW - HRI_GEN_HRCHY_SUMMARY#

[top of page]

Table: HRI_INV_SPRTN_RSNS

Description:
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
HRI_INV_SPRTN_RSNS_U1 UNIQUE APPS_TS_SUMMARY REASON
Columns
Name Datatype Length Mandatory Comments
REASON VARCHAR2 (30) Y
TERMINATION_TYPE VARCHAR2 (30)
UPDATE_ALLOWED_FLAG VARCHAR2 (30)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

CREATED_BY NUMBER

LAST_UPDATE_DATE DATE

[top of page]

HRI.HRI_INV_SPRTN_RSNS does not reference any database object

HRI.HRI_INV_SPRTN_RSNS is referenced by following:

HRI
VIEW - HRI_INV_SPRTN_RSNS#

[top of page]

Table: HRI_JOB_CATEGORY_SETS

Description:
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
JOB_CATEGORY_SET NUMBER

MEMBER_LOOKUP_CODE VARCHAR2 (30)
OTHER_LOOKUP_CODE VARCHAR2 (30)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

LAST_UPDATED_BY NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

[top of page]

HRI.HRI_JOB_CATEGORY_SETS does not reference any database object

HRI.HRI_JOB_CATEGORY_SETS is referenced by following:

HRI
VIEW - HRI_JOB_CATEGORY_SETS#

[top of page]

Table: HRI_ORG_HRCHY_SUMMARY

Description:
Primary Key: HRI_ORG_HRCHY_SUMMARY_PK
  1. ORG_STRUCTURE_VERSION_ID
  2. ORGANIZATION_ID
  3. SUB_ORGANIZATION_ID
Comments

Collected Table for the Organization Hierarchy, the table is populated by the concurrent process 'HRI Load All Generic Hierarchy Versions'

Indexes
Index Type Tablespace Column
HRI_ORG_HRCHY_SUMMARY_U1 UNIQUE APPS_TS_SUMMARY ORG_STRUCTURE_VERSION_ID
ORGANIZATION_ID
SUB_ORGANIZATION_ID
HRI_ORG_HRCHY_SUMMARY_N1 NONUNIQUE APPS_TS_SUMMARY ORG_STRUCTURE_VERSION_ID
ORGANIZATION_ID
SUB_ORG_RELATIVE_LEVEL
HRI_ORG_HRCHY_SUMMARY_N2 NONUNIQUE APPS_TS_SUMMARY ORG_STRUCTURE_VERSION_ID
SUB_ORGANIZATION_ID
HRI_ORG_HRCHY_SUMMARY_N3 NONUNIQUE APPS_TS_SUMMARY ORG_STRUCTURE_VERSION_ID
ORGANIZATION_LEVEL
HRI_ORG_HRCHY_SUMMARY_N4 NONUNIQUE APPS_TS_SUMMARY ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
ORG_STRUCTURE_VERSION_ID NUMBER (15) Y Organization Structure Version Id
ORG_BUSINESS_GROUP_ID NUMBER (15)
Organization Business Group Id
ORGANIZATION_ID NUMBER (15) Y Organization Id
ORGANIZATION_LEVEL NUMBER (15) Y Organization Level
SUB_ORG_BUSINESS_GROUP_ID NUMBER (15)
Subordinate Organization Business Group Id
SUB_ORGANIZATION_ID NUMBER (15) Y Subordinate Organization Id
SUB_ORGANIZATION_LEVEL NUMBER (15) Y Subordinate Organization Level
CREATED_BY NUMBER (15) Y Standard WHO Column
CREATION_DATE DATE
Y Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO Column
LAST_UPDATE_DATE DATE
Y Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
LAST_PTNTL_CHANGE DATE

Standard WHO Column
ORGANIZATION_STRUCTURE_ID NUMBER
Y Organization Structure Id
SUB_ORG_RELATIVE_LEVEL NUMBER
Y Subordinate Organization Relative Level

[top of page]

HRI.HRI_ORG_HRCHY_SUMMARY does not reference any database object

HRI.HRI_ORG_HRCHY_SUMMARY is referenced by following:

HRI
VIEW - HRI_ORG_HRCHY_SUMMARY#

[top of page]

Table: HRI_ORG_PARAMS

Description: BIS Organization Parameters Header
Primary Key: HRI_ORG_PARAMS_PK
  1. ORG_PARAM_ID
Primary Key: HRI_ORG_PARAMS_UK1
  1. ORGANIZATION_PROCESS
  2. ORGANIZATION_ID
  3. ORGANIZATION_STRUCTURE_ID
Primary Key: ORP_PK
  1. ORG_PARAM_ID
Primary Key: ORP_UK
  1. ORGANIZATION_PROCESS
  2. ORGANIZATION_ID
  3. ORGANIZATION_STRUCTURE_ID
Foreign Keys to this table:
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
Comments

Collected Table of Organizations used within BIS Report Parameters.

Indexes
Index Type Tablespace Column
HRI_ORG_PARAMS_PK UNIQUE APPS_TS_SUMMARY ORG_PARAM_ID
HRI_ORG_PARAMS_UK1 UNIQUE APPS_TS_SUMMARY ORGANIZATION_PROCESS
ORGANIZATION_ID
ORGANIZATION_STRUCTURE_ID
Columns
Name Datatype Length Mandatory Comments
CREATED_BY NUMBER (15) Y Standard WHO Column
CREATION_DATE DATE
Y Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
ORG_PARAM_ID NUMBER
Y Organization Parameter Id
ORGANIZATION_STRUCTURE_ID NUMBER (15) Y Organization Structure Id
ORGANIZATION_ID NUMBER (15) Y Organization Id
ORGANIZATION_PROCESS VARCHAR2 (4) Y Organization Process
LAST_UPDATE_DATE DATE
Y Standard WHO Column

[top of page]

HRI.HRI_ORG_PARAMS does not reference any database object

HRI.HRI_ORG_PARAMS is referenced by following:

HRI
VIEW - HRI_ORG_PARAMS#

[top of page]

Table: HRI_ORG_PARAM_LIST

Description: BIS Organization Parameters List
Primary Key: HRI_ORG_PARAM_LIST_PK
  1. ORG_PARAM_ID
  2. ORGANIZATION_ID_GROUP
  3. ORGANIZATION_ID_CHILD
Primary Key: OPL_PK
  1. ORGANIZATION_ID_CHILD
  2. ORG_PARAM_ID
  3. ORGANIZATION_ID_GROUP
Foreign Keys from this table:
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
Comments

Collected Table of Organizations used within BIS Report Parameters.

Indexes
Index Type Tablespace Column
HRI_ORG_PARAM_LIST_PK UNIQUE APPS_TS_SUMMARY ORG_PARAM_ID
ORGANIZATION_ID_GROUP
ORGANIZATION_ID_CHILD
Columns
Name Datatype Length Mandatory Comments
ORG_PARAM_ID NUMBER
Y Organization Parameter Id
ORGANIZATION_ID_GROUP NUMBER (15) Y Organization Id Group
ORGANIZATION_ID_CHILD NUMBER (15) Y Organization Child Id
LAST_UPDATE_DATE DATE
Y Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
CREATED_BY NUMBER (15) Y Standard WHO Column
CREATION_DATE DATE
Y Standard WHO Column

[top of page]

HRI.HRI_ORG_PARAM_LIST does not reference any database object

HRI.HRI_ORG_PARAM_LIST is referenced by following:

HRI
VIEW - HRI_ORG_PARAM_LIST#

[top of page]

Table: HRI_PERSON_TYPE_CMBNS

Description:
Primary Key: HRI_PERSON_TYPE_CMBNS_PK
  1. PERSON_TYPE_PK
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
PERSON_TYPE_PK VARCHAR2 (2000) Y
PERSON_ID NUMBER

EFFECTIVE_DATE DATE

EMPLOYEE VARCHAR2 (80)
APPLICANT VARCHAR2 (80)
PERMANENT VARCHAR2 (80)
FIXED_TERM_UPPER VARCHAR2 (80)
FIXED_TERM_LOWER VARCHAR2 (80)
INTERN VARCHAR2 (80)
EX_EMPLOYEE VARCHAR2 (80)
EX_APPLICANT VARCHAR2 (80)
DEPENDENT VARCHAR2 (80)
BENEFICIARY VARCHAR2 (80)
RETIREE VARCHAR2 (80)
CONTACT VARCHAR2 (80)
SURVIVING_FAMILY_MEMBER VARCHAR2 (80)
SURVIVING_SPOUSE VARCHAR2 (80)
FORMER_FAMILY_MEMBER VARCHAR2 (80)
FORMER_SPOUSE VARCHAR2 (80)
OTHER VARCHAR2 (80)
PARTICIPANT VARCHAR2 (80)
EMPLOYEE_STUDENT VARCHAR2 (80)
CONSULTANT VARCHAR2 (80)
AGENCY VARCHAR2 (80)
SELF_EMPLOYED VARCHAR2 (80)
CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

LAST_UPDATE_DATE DATE

[top of page]

HRI.HRI_PERSON_TYPE_CMBNS does not reference any database object

HRI.HRI_PERSON_TYPE_CMBNS is referenced by following:

HRI
VIEW - HRI_PERSON_TYPE_CMBNS#

[top of page]

Table: HRI_PRIMARY_HRCHYS

Description:
Primary Key: HRI_PRIMARY_HRCHYS_PK
  1. ORGANIZATION_ID
  2. ORGANIZATION_STRUCTURE_ID
  3. ORG_STRUCTURE_VERSION_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_STRUCTURE_ID NUMBER
Y
ORG_STRUCTURE_VERSION_ID NUMBER
Y
ORGANIZATION_ID NUMBER
Y
PARENT_ORGANIZATION_ID NUMBER

ORGANIZATION_LEVEL NUMBER

BUSINESS_GROUP_ID NUMBER

ORG_LAST_UPDATED DATE

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

[top of page]

HRI.HRI_PRIMARY_HRCHYS does not reference any database object

HRI.HRI_PRIMARY_HRCHYS is referenced by following:

HRI
VIEW - HRI_PRIMARY_HRCHYS#

[top of page]

Table: HRI_RECRUITMENT_STAGES

Description:
Primary Key: HRI_RECRUITMENT_STAGES_PK
  1. ASSIGNMENT_ID
  2. ASSIGNMENT_START_DATE
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ID NUMBER
Y
ASSIGNMENT_START_DATE DATE
Y
BUSINESS_GROUP_ID NUMBER

ASSIGNMENT_TYPE VARCHAR2 (30)
APPLICATION_ID NUMBER

PERSON_ID NUMBER

GAIN_TYPE VARCHAR2 (30)
SUCCESS NUMBER

APPLICATION_DATE DATE

APPLICATION_END_DATE DATE

PLANNED_START_DATE DATE

APPLICATION_REASON VARCHAR2 (30)
APPLICATION_SUCCESS NUMBER

INTERVIEW1_DATE DATE

INTERVIEW1_REASON VARCHAR2 (30)
INTERVIEW1_SUCCESS NUMBER

INTERVIEW2_DATE DATE

INTERVIEW2_REASON VARCHAR2 (30)
INTERVIEW2_SUCCESS NUMBER

OFFER_DATE DATE

OFFER_REASON VARCHAR2 (30)
OFFER_SUCCESS NUMBER

ACCEPT_DATE DATE

ACCEPT_REASON VARCHAR2 (30)
ACCEPT_SUCCESS NUMBER

HIRE_DATE DATE

HIRE_REASON VARCHAR2 (30)
TERMINATION_DATE DATE

TERMINATION_REASON VARCHAR2 (30)
SEPARATION_DATE DATE

SEPARATION_REASON VARCHAR2 (30)
HEADCOUNT_VALUE NUMBER

FTE_VALUE NUMBER

LAST_UPDATE_DATE DATE

CREATION_DATE DATE

LAST_UPDATE_LOGIN NUMBER

CREATED_BY NUMBER

LAST_UPDATED_BY NUMBER

CURRENT_STAGE VARCHAR2 (30)
CURRENT_STAGE_DATE DATE

CURRENT_STAGE_REASON VARCHAR2 (30)

[top of page]

HRI.HRI_RECRUITMENT_STAGES does not reference any database object

HRI.HRI_RECRUITMENT_STAGES is referenced by following:

HRI
VIEW - HRI_RECRUITMENT_STAGES#

[top of page]

Table: HRI_SERVICE_BANDS

Description:
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
BAND_MIN_TOTAL_YEARS NUMBER

BAND_MIN_TOTAL_MONTHS NUMBER

BAND_MIN_TOTAL_WEEKS NUMBER

BAND_MIN_TOTAL_DAYS NUMBER

BAND_MAX_TOTAL_YEARS NUMBER

BAND_MAX_TOTAL_MONTHS NUMBER

BAND_MAX_TOTAL_WEEKS NUMBER

BAND_MAX_TOTAL_DAYS NUMBER

DAYS_TO_MONTH NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

[top of page]

HRI.HRI_SERVICE_BANDS does not reference any database object

HRI.HRI_SERVICE_BANDS is referenced by following:

HRI
VIEW - HRI_SERVICE_BANDS#

[top of page]

Table: HRI_SUPV_HRCHY_SUMMARY

Description: Supervisor Hierarchy Summary Table
Primary Key: HRI_SUPV_HRCHY_SUMMARY_PK
  1. SUPV_BUSINESS_GROUP_ID
  2. SUPV_PERSON_ID
  3. SUPV_ASSIGNMENT_ID
  4. SUB_PERSON_ID
  5. SUB_ASSIGNMENT_ID
Comments

Collected Table for the Supervisor Hierarchy, the table is populated by the concurrent process 'HRI Load Supervisor Hierarchy History'.

Indexes
Index Type Tablespace Column
HRI_SUPV_HRCHY_SUMMARY_U1 UNIQUE APPS_TS_SUMMARY SUPV_BUSINESS_GROUP_ID
SUPV_PERSON_ID
SUPV_ASSIGNMENT_ID
SUB_PERSON_ID
SUB_ASSIGNMENT_ID
HRI_SUPV_HRCHY_SUMMARY_N1 NONUNIQUE APPS_TS_SUMMARY SUPV_ASSIGNMENT_ID
HRI_SUPV_HRCHY_SUMMARY_N3 NONUNIQUE APPS_TS_SUMMARY SUPV_PERSON_ID
HRI_SUPV_HRCHY_SUMMARY_N4 NONUNIQUE APPS_TS_SUMMARY SUPV_LEVEL
HRI_SUPV_HRCHY_SUMMARY_N5 NONUNIQUE APPS_TS_SUMMARY SUB_BUSINESS_GROUP_ID
HRI_SUPV_HRCHY_SUMMARY_N6 NONUNIQUE APPS_TS_SUMMARY SUB_PERSON_ID
HRI_SUPV_HRCHY_SUMMARY_N7 NONUNIQUE APPS_TS_SUMMARY SUB_ASSIGNMENT_ID
HRI_SUPV_HRCHY_SUMMARY_N8 NONUNIQUE APPS_TS_SUMMARY SUB_LEVEL
Columns
Name Datatype Length Mandatory Comments
SUPV_BUSINESS_GROUP_ID NUMBER (15) Y Business Group ID of the Supervisor
SUPV_PERSON_ID NUMBER (15) Y Person ID of the Supervisor
SUPV_ASSIGNMENT_ID NUMBER (15) Y Assignment ID of the Supervisor
SUPV_LEVEL NUMBER (15) Y Level of the Supervisor in the Supervisor Hierarchy
SUB_BUSINESS_GROUP_ID NUMBER (15) Y Business Group ID of the Supervised Person Assignment
SUB_PERSON_ID NUMBER (15) Y Person ID of the Supervised Person Assignment
SUB_ASSIGNMENT_ID NUMBER (15) Y Assignment ID of the Supervised Person Assignment
SUB_PRIMARY_ASG_FLAG VARCHAR2 (1) Y Primary Assignment Flag of the Supervised Person Assignment
SUB_LEVEL NUMBER (15) Y Level of the Subordinate in the Supervisor Hierarchy
CREATION_DATE DATE
Y Standard WHO Column
CREATED_BY NUMBER (15) Y Standard WHO Column
LAST_UPDATE_DATE DATE
Y Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
SUPV_LAST_PTNTL_CHANGE DATE

Supv Last Ptntl Change
SUB_LAST_PTNTL_CHANGE DATE

Last Ptntl Change Date

[top of page]

HRI.HRI_SUPV_HRCHY_SUMMARY does not reference any database object

HRI.HRI_SUPV_HRCHY_SUMMARY is referenced by following:

HRI
VIEW - HRI_SUPV_HRCHY_SUMMARY#

[top of page]

View: HRIBV_ASGMVORGHRCHY

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view

This business view shows all employee assignment organization changes for all organization hierarchies in which the organization the assignment is moving from appears.

Columns
Name Datatype Length Mandatory Comments
MOVE_TYPE VARCHAR2 (4000)
GAIN_TYPE VARCHAR2 (4000)
LOSS_TYPE VARCHAR2 (4000)
ORGANIZATION_HRCHY_NAME VARCHAR2 (30)
ORG_HIERARCHY_VERSION NUMBER

TOP_ORGANIZATION_NAME VARCHAR2 (240)
ORGANIZATION_NAME VARCHAR2 (240)
OTHER_ORGANIZATION_NAME VARCHAR2 (240)
FROM_ORGANIZATION_NAME VARCHAR2 (240)
TO_ORGANIZATION_NAME VARCHAR2 (240)
EMPLOYEE_NAME VARCHAR2 (240)
ASSIGNMENT_NUMBER VARCHAR2 (30)
CHANGE_DATE DATE

ASG_EFFECTIVE_START_DATE DATE

ASG_EFFECTIVE_END_DATE DATE

OTHER_ASG_EFFECTIVE_START_DATE DATE

OTHER_ASG_EFFECTIVE_END_DATE DATE

HIERARCHY_VERSION_DATE_FROM DATE

HIERARCHY_VERSION_DATE_TO DATE

HIERARCHY_VERSION_DATE_TO_NN DATE

MOVE_TYPE_CODE VARCHAR2 (15)
GAIN_TYPE_CODE VARCHAR2 (8)
LOSS_TYPE_CODE VARCHAR2 (8)
ORGANIZATION_STRUCTURE_ID NUMBER (15)
ORG_STRUCTURE_VERSION_ID NUMBER (15)
PARENT_ORG_ID NUMBER (15)
ASSIGNMENT_ID NUMBER (10)
ORGANIZATION_ID NUMBER (15)
BUSINESS_GROUP_ID NUMBER (15)
PERSON_ID NUMBER (10)
OTHER_ORGANIZATION_ID NUMBER (15)
OTHER_BUSINESS_GROUP_ID NUMBER (15)
ORGANIZATION_FROM_ID NUMBER (15)
ORGANIZATION_TO_ID NUMBER (15)

[top of page]

APPS.HRIBV_ASGMVORGHRCHY references the following:

APPS
SYNONYM - HRI_ORG_HRCHY_SUMMARY
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_ORGANIZATION_STRUCTURES
SYNONYM - PER_ORG_STRUCTURE_VERSIONS
- PER_ASSIGNMENTS_F

APPS.HRIBV_ASGMVORGHRCHY is not referenced by any database object

[top of page]

View: HRIBV_ORG_HRCHY

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view

This view allows Organization Include Subordinate queries for all Organization Hierarchy Versions.

Columns
Name Datatype Length Mandatory Comments
HIERARCHY_NAME VARCHAR2 (30) Y
HRCHY_PRIMARY_FLAG VARCHAR2 (4000)
HRCHY_PRIMARY_FLAG_CODE VARCHAR2 (30)
HIERARCHY_VERSION NUMBER
Y
HIERARCHY_VERSION_DATE_FROM DATE
Y
HIERARCHY_VERSION_DATE_TO DATE

ORGANIZATION_NAME VARCHAR2 (240) Y
ORGANIZATION_LEVEL NUMBER (15) Y
SUB_ORGANIZATION_NAME VARCHAR2 (240) Y
SUB_ORGANIZATION_LEVEL NUMBER (15) Y
HRCHY_VERSION_DATE_TO_NN DATE

This is the Hierachy Version Date To column that has been converted to the date '31-DEC-4712' if the value is null
ORG_HIERARCHY_ID NUMBER (15) Y
ORG_HRCHY_VERSION_ID NUMBER
Y
ORG_BUSINESS_GROUP_ID NUMBER (15)
ORGANIZATION_ID NUMBER (15) Y
SUB_ORG_BUSINESS_GROUP_ID NUMBER (15)
SUB_ORGANIZATION_ID NUMBER (15) Y

[top of page]

APPS.HRIBV_ORG_HRCHY references the following:

APPS
SYNONYM - HRI_ORG_HRCHY_SUMMARY
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
SYNONYM - PER_ORGANIZATION_STRUCTURES
SYNONYM - PER_ORG_STRUCTURE_VERSIONS

APPS.HRIBV_ORG_HRCHY is not referenced by any database object

[top of page]

View: HRIBV_ORG_HRCHY_ROLLUP

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view

This view allows Organization Include Subordinate with Rollup queries for all Organization Hierarchy Versions.

Columns
Name Datatype Length Mandatory Comments
HIERARCHY_NAME VARCHAR2 (30) Y
HRCHY_PRIMARY_FLAG VARCHAR2 (4000)
HRCHY_PRIMARY_FLAG_CODE VARCHAR2 (30)
HIERARCHY_VERSION NUMBER
Y
HIERARCHY_VERSION_DATE_FROM DATE
Y
HIERARCHY_VERSION_DATE_TO DATE

ORGANIZATION_NAME VARCHAR2 (240) Y
ORGANIZATION_LEVEL NUMBER (15) Y
SUB_ORGANIZATION_NAME VARCHAR2 (240) Y
SUB_ORGANIZATION_LEVEL NUMBER (15) Y
SUB_RO_ORGANIZATION_LEVEL NUMBER (15) Y
HRCHY_VERSION_DATE_TO_NN DATE

This is the Hierachy Version Date To column that has been converted to the date '31-DEC-4712' if the value is null
ORG_HIERARCHY_ID NUMBER (15) Y
ORG_HRCHY_VERSION_ID NUMBER
Y
ORG_BUSINESS_GROUP_ID NUMBER (15)
ORGANIZATION_ID NUMBER (15) Y
SUB_ORG_BUSINESS_GROUP_ID NUMBER (15)
SUB_ORGANIZATION_ID NUMBER (15) Y
SUB_RO_ORG_BUSINESS_GROUP_ID NUMBER (15)
SUB_RO_ORGANIZATION_ID NUMBER (15) Y

[top of page]

APPS.HRIBV_ORG_HRCHY_ROLLUP references the following:

APPS
SYNONYM - HRI_ORG_HRCHY_SUMMARY
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
SYNONYM - PER_ORGANIZATION_STRUCTURES
SYNONYM - PER_ORG_STRUCTURE_VERSIONS

APPS.HRIBV_ORG_HRCHY_ROLLUP is not referenced by any database object

[top of page]

View: HRIBV_SUPV_HRCHY_ROLLUP_X

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view

This view allows Supervisor hierarchy Include Subordinate with Rollup queries for all current Supervisor Hierarchies.

Columns
Name Datatype Length Mandatory Comments
SUPERVISOR_BUSINESS_GROUP VARCHAR2 (240) Y Business Group of the Supervisor
SUPERVISOR_PERSON_NAME VARCHAR2 (240)
Person Name of the Supervisor
SUPERVISOR_LEVEL NUMBER (15) Y Level of the Supervisor in the Supervisor Hierarchy
SUPERVISOR_EMPLOYEE_NUMBER VARCHAR2 (30)
SUBORDINATE_PERSON_NAME VARCHAR2 (240)
Person Name of the Supervised Person Assignment
SUBORDINATE_EMPLOYEE_NUMBER VARCHAR2 (30)
SUBORDINATE_PRIMARY_ASG_FLAG VARCHAR2 (4000)
Primary Assignment Flag of the Supervised Person Assignment
SUBORD_PRIMARY_ASG_FLAG_CODE VARCHAR2 (1)
SUBORDINATE_LEVEL NUMBER (15) Y Level of the Supervised Person Assignment in the Supervisor Hierarchy
SUB_RO_LEVEL NUMBER (15) Y
SUPERVISOR_BUSINESS_GROUP_ID NUMBER (15) Y Business Group Identifier of the Supervisor
SUPERVISOR_PERSON_ID NUMBER (15) Y Person Identifier of the Supervisor
SUPERVISOR_ASSIGNMENT_ID NUMBER (15) Y
SUBORDINATE_BUSINESS_GROUP_ID NUMBER (15) Y
SUBORDINATE_PERSON_ID NUMBER (15) Y Person Identifier of the Supervised Person Assignment
SUBORDINATE_ASSIGNMENT_ID NUMBER (15) Y Assignment Identifier of the Supervised Person Assignment
SUB_RO_BUSINESS_GROUP_ID NUMBER (15) Y
SUB_RO_PERSON_ID NUMBER (15) Y
SUB_RO_ASSIGNMENT_ID NUMBER (15) Y

[top of page]

APPS.HRIBV_SUPV_HRCHY_ROLLUP_X references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
- PER_PEOPLE_X
- HRI_CS_SUPH_X_V

APPS.HRIBV_SUPV_HRCHY_ROLLUP_X is not referenced by any database object

[top of page]

View: HRIBV_SUPV_HRCHY_X

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view

This view allows Supervisor hierarchy Include Subordinate queries for all current Supervisor Hierarchies

Columns
Name Datatype Length Mandatory Comments
SUPERVISOR_BUSINESS_GROUP VARCHAR2 (240) Y Business Group of the Supervisor
SUPERVISOR_PERSON_NAME VARCHAR2 (240)
Person Name of the Supervisor
SUPERVISOR_LEVEL NUMBER (15) Y Level of the Supervisor in the Supervisor Hierarchy
SUPERVISOR_EMPLOYEE_NUMBER VARCHAR2 (30)
SUBORDINATE_PERSON_NAME VARCHAR2 (240)
Person Name of the Supervised Person Assignment
SUBORDINATE_EMPLOYEE_NUMBER VARCHAR2 (30)
SUBORDINATE_PRIMARY_ASG_FLAG VARCHAR2 (4000)
Primary Assignment Flag of the Supervised Person Assignment
SUBORD_PRIMARY_ASG_FLAG_CODE VARCHAR2 (1)
SUBORDINATE_LEVEL NUMBER (15) Y Level of the Supervised Person Assignment in the Supervisor Hierarchy
SUPERVISOR_BUSINESS_GROUP_ID NUMBER (15) Y Business Group Identifier of the Supervisor
SUPERVISOR_PERSON_ID NUMBER (15) Y Person Identifier of the Supervisor
SUPERVISOR_ASSIGNMENT_ID NUMBER (15) Y
SUBORDINATE_BUSINESS_GROUP_ID NUMBER (15) Y
SUBORDINATE_PERSON_ID NUMBER (15) Y Person Identifier of the Supervised Person Assignment
SUBORDINATE_ASSIGNMENT_ID NUMBER (15) Y Assignment Identifier of the Supervised Person Assignment

[top of page]

APPS.HRIBV_SUPV_HRCHY_X references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
- PER_PEOPLE_X
- HRI_CS_SUPH_X_V

APPS.HRIBV_SUPV_HRCHY_X is not referenced by any database object

[top of page]

View: HRIBV_TRNCNTR_HRCHY

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
HIERARCHY_NAME VARCHAR2 (30) Y
HRCHY_BUSINESS_GROUP_NAME VARCHAR2 (240) Y
HRCHY_PRIMARY_FLAG VARCHAR2 (4000)
HIERARCHY_VERSION NUMBER
Y
HIERARCHY_VERSION_DATE_FROM DATE
Y
HIERARCHY_VERSION_DATE_TO DATE

TRAINING_CENTER_NAME VARCHAR2 (240) Y
TRAINING_CENTER_LEVEL NUMBER (15) Y
SUB_TRAINING_CENTER_NAME VARCHAR2 (240) Y
SUB_TRAINING_CENTER_LEVEL NUMBER (15) Y
HRCHY_VERSION_DATE_TO_NN DATE

HRCHY_PRIMARY_FLAG_CODE VARCHAR2 (30)
TC_HIERARCHY_ID NUMBER (15) Y
TC_HRCHY_BUSINESS_GROUP_ID NUMBER (15)
TC_HRCHY_VERSION_ID NUMBER
Y
TC_BUSINESS_GROUP_ID NUMBER (15)
TRAINING_CENTER_ID NUMBER (15) Y
SUB_TC_BUSINESS_GROUP_ID NUMBER (15)
SUB_TRAINING_CENTER_ID NUMBER (15) Y

[top of page]

APPS.HRIBV_TRNCNTR_HRCHY references the following:

APPS
SYNONYM - HRI_ORG_HRCHY_SUMMARY
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
SYNONYM - HR_ORGANIZATION_INFORMATION
PACKAGE - OTA_GENERAL
SYNONYM - PER_ORGANIZATION_STRUCTURES
SYNONYM - PER_ORG_STRUCTURE_VERSIONS

APPS.HRIBV_TRNCNTR_HRCHY is not referenced by any database object

[top of page]

View: HRIBV_TRNCNTR_HRCHY_ROLLUP

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
HIERARCHY_NAME VARCHAR2 (30) Y
HRCHY_BUSINESS_GROUP_NAME VARCHAR2 (240) Y
HRCHY_PRIMARY_FLAG VARCHAR2 (4000)
HIERARCHY_VERSION NUMBER
Y
HIERARCHY_VERSION_DATE_FROM DATE
Y
HIERARCHY_VERSION_DATE_TO DATE

TRAINING_CENTER_NAME VARCHAR2 (240) Y
TRAINING_CENTER_LEVEL NUMBER (15) Y
SUB_TRAINING_CENTER_NAME VARCHAR2 (240) Y
SUB_TRAINING_CENTER_LEVEL NUMBER (15) Y
SUB_RO_TRAINING_CENTER_LEVEL NUMBER (15) Y
HRCHY_VERSION_DATE_TO_NN DATE

HRCHY_PRIMARY_FLAG_CODE VARCHAR2 (30)
TC_HIERARCHY_ID NUMBER (15) Y
TC_HRCHY_BUSINESS_GROUP_ID NUMBER (15)
TC_HRCHY_VERSION_ID NUMBER
Y
TC_BUSINESS_GROUP_ID NUMBER (15)
TRAINING_CENTER_ID NUMBER (15) Y
SUB_TC_BUSINESS_GROUP_ID NUMBER (15)
SUB_TRAINING_CENTER_ID NUMBER (15) Y
SUB_RO_TC_BUSINESS_GROUP_ID NUMBER (15)
SUB_RO_TRAINING_CENTER_ID NUMBER (15) Y

[top of page]

APPS.HRIBV_TRNCNTR_HRCHY_ROLLUP references the following:

APPS
SYNONYM - HRI_ORG_HRCHY_SUMMARY
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
SYNONYM - HR_ORGANIZATION_INFORMATION
PACKAGE - OTA_GENERAL
SYNONYM - PER_ORGANIZATION_STRUCTURES
SYNONYM - PER_ORG_STRUCTURE_VERSIONS

APPS.HRIBV_TRNCNTR_HRCHY_ROLLUP is not referenced by any database object

[top of page]

View: HRICV_HR_BIMONTH

Comments
Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (10)
VALUE DATE

PERIOD_SET_NAME CHAR (10)
PERIOD_NAME VARCHAR2 (56)
START_DATE DATE

END_DATE DATE

PERIOD_NO_IN_YEAR NUMBER

PERIOD_YEAR DATE

ORGANIZATION_ID VARCHAR2 (0)
ORGANIZATION_TYPE VARCHAR2 (0)

[top of page]

APPS.HRICV_HR_BIMONTH references the following:

- HR_API
- HR_LOOKUPS

APPS.HRICV_HR_BIMONTH is not referenced by any database object

[top of page]

View: HRICV_HR_DAY

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

HRICV_HR_DAY

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (10)
comment
VALUE DATE

comment
PERIOD_SET_NAME CHAR (6)
comment
PERIOD_NAME VARCHAR2 (10)
comment
START_DATE DATE

comment
END_DATE DATE

comment
PERIOD_NO_IN_YEAR NUMBER

comment
PERIOD_YEAR DATE

comment
ORGANIZATION_ID VARCHAR2 (0)
ORGANIZATION_TYPE VARCHAR2 (0)

[top of page]

APPS.HRICV_HR_DAY references the following:

APPS
SYNONYM - FND_NEW_MESSAGES

APPS.HRICV_HR_DAY is not referenced by any database object

[top of page]

View: HRICV_HR_MONTH

Comments
Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (10)
VALUE DATE

PERIOD_SET_NAME CHAR (8)
PERIOD_NAME VARCHAR2 (55)
START_DATE DATE

END_DATE DATE

PERIOD_NO_IN_YEAR NUMBER

PERIOD_YEAR DATE

ORGANIZATION_ID VARCHAR2 (0)
ORGANIZATION_TYPE VARCHAR2 (0)

[top of page]

APPS.HRICV_HR_MONTH references the following:

- HR_API
- HR_LOOKUPS

APPS.HRICV_HR_MONTH is not referenced by any database object

[top of page]

View: HRICV_HR_QUARTER

Comments
Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (10)
VALUE DATE

PERIOD_SET_NAME CHAR (10)
PERIOD_NAME VARCHAR2 (55)
START_DATE DATE

END_DATE DATE

PERIOD_NO_IN_YEAR NUMBER

PERIOD_YEAR DATE

ORGANIZATION_ID VARCHAR2 (0)
ORGANIZATION_TYPE VARCHAR2 (0)

[top of page]

APPS.HRICV_HR_QUARTER references the following:

- HR_API
- HR_LOOKUPS

APPS.HRICV_HR_QUARTER is not referenced by any database object

[top of page]

View: HRICV_HR_SEMIYEAR

Comments
Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (10)
VALUE DATE

PERIOD_SET_NAME CHAR (11)
PERIOD_NAME VARCHAR2 (56)
START_DATE DATE

END_DATE DATE

PERIOD_NO_IN_YEAR NUMBER

PERIOD_YEAR DATE

ORGANIZATION_ID VARCHAR2 (0)
ORGANIZATION_TYPE VARCHAR2 (0)

[top of page]

APPS.HRICV_HR_SEMIYEAR references the following:

- HR_API
- HR_LOOKUPS

APPS.HRICV_HR_SEMIYEAR is not referenced by any database object

[top of page]

View: HRICV_HR_YEAR

Comments
Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (10)
VALUE DATE

PERIOD_SET_NAME CHAR (7)
PERIOD_NAME VARCHAR2 (11)
START_DATE DATE

END_DATE DATE

PERIOD_NO_IN_YEAR NUMBER

PERIOD_YEAR DATE

ORGANIZATION_ID VARCHAR2 (0)
ORGANIZATION_TYPE VARCHAR2 (0)

[top of page]

APPS.HRICV_HR_YEAR references the following:

- HR_API
- HR_LOOKUPS

APPS.HRICV_HR_YEAR is not referenced by any database object

[top of page]

View: HRIFV_GRADE_RATES_BG

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view

This view shows all grades and their corresponding grade rates
if the grade does not have grade rates then null values are shown.
The view uses business group security on the grade business group id.

Columns
Name Datatype Length Mandatory Comments
GRADE_NAME VARCHAR2 (240)
GRADE_DATE_FROM DATE
Y
GRADE_DATE_TO DATE

GRADE_RULE_START_DATE DATE

GRADE_RULE_END_DATE DATE

GRADE_RATE_NAME VARCHAR2 (80)
UNIT_OF_MEASURE VARCHAR2 (4000)
GRADE_MAXIMUM VARCHAR2 (20)
GRADE_MID_VALUE VARCHAR2 (20)
GRADE_MINIMUM VARCHAR2 (20)
GRADE_RATE_VALUE VARCHAR2 (20)
GRADE_ANNUALIZATION_FACTOR NUMBER

PAY_BASIS_NAME VARCHAR2 (30) Y
_DF CHAR (21)
GRADE_RULE_ID NUMBER (15)
GRADE_ID NUMBER (15) Y
GRADE_DEFINITION_ID NUMBER (15) Y
GRADE_BUSINESS_GROUP_ID NUMBER (15) Y
GRADE_RATE_ID NUMBER (15)
GRADE_OR_SPINAL_POINT_ID NUMBER (15)
PAY_BASIS_ID NUMBER (9) Y

[top of page]

APPS.HRIFV_GRADE_RATES_BG references the following:

APPS
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
SYNONYM - PAY_GRADE_RULES_F
SYNONYM - PAY_RATES
SYNONYM - PER_GRADES
SYNONYM - PER_PAY_BASES

APPS.HRIFV_GRADE_RATES_BG is not referenced by any database object

[top of page]

View: HRIFV_PEREIT

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
PERSON_NAME VARCHAR2 (240)
INFORMATION_TYPE VARCHAR2 (40) Y
ACTIVE_INACTIVE VARCHAR2 (4000)
MULTIPLE_OCCURENCES VARCHAR2 (4000)
EXTRA_INFO_TYPE_DESCRIPTION VARCHAR2 (240)
LEGISLATION_CODE VARCHAR2 (30)
PERSON_EFFECTIVE_START_DATE DATE
Y
PERSON_EFFECTIVE_END_DATE DATE
Y
_DF:EIT_DF1 CHAR (33)
_DF:EIT_DF2 CHAR (33)
ACTIVE_INACTIVE_FLAG VARCHAR2 (30) Y
MULTIPLE_OCCURENCES_FLAG VARCHAR2 (30) Y
PERSON_EXTRA_INFO_ID NUMBER (15) Y
PERSON_ID NUMBER (10) Y
BUSINESS_GROUP_ID NUMBER (15) Y

[top of page]

APPS.HRIFV_PEREIT references the following:

APPS
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PER_PEOPLE_EXTRA_INFO
SYNONYM - PER_PEOPLE_INFO_TYPES
- PER_PEOPLE_F

APPS.HRIFV_PEREIT is not referenced by any database object

[top of page]

View: HRIFV_SAL_PRO

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240) Y
PERSON_NAME VARCHAR2 (240)
EMPLOYEE_NUMBER VARCHAR2 (30)
ASSIGNMENT_NUMBER VARCHAR2 (30)
SALARY_AMOUNT NUMBER

ANNUALIZATION_FACTOR NUMBER

ANNUAL_SALARY NUMBER

CURRENCY VARCHAR2 (15)
EFFECTIVE_FROM_DATE DATE

EFFECTIVE_TO_DATE DATE

LAST_CHANGE_DATE DATE

SALARY_CHANGE_REASON VARCHAR2 (4000)
APPROVED VARCHAR2 (4000)
GRADE_ANNUALIZATION_FACTOR NUMBER

WORKING_HOURS_AMOUNT NUMBER (22)
WORKING_HOURS_FREQUENCY VARCHAR2 (30)
PAYROLL VARCHAR2 (80) Y
NUMBER_PER_FISCAL_YEAR NUMBER (15) Y
PAY_BASIS VARCHAR2 (4000)
RANKING NUMBER

MULTIPLE_COMPONENTS VARCHAR2 (4000)
SALARY_BASIS VARCHAR2 (30) Y
_DF:PAY_PROPOSALS CHAR (29)
EFFECTIVE_TO_DATE_NN DATE

CURRENCY_CODE VARCHAR2 (15)
APPROVED_CODE VARCHAR2 (30)
PAY_BASIS_CODE VARCHAR2 (30) Y
MULTIPLE_COMPONENTS_CODE VARCHAR2 (30)
ASSIGNMENT_ID NUMBER (10) Y
PERSON_ID NUMBER (10) Y
BUSINESS_GROUP_ID NUMBER (15) Y
ORGANIZATION_ID NUMBER (15) Y
LOCATION_ID NUMBER (15)
JOB_ID NUMBER (15)
GRADE_ID NUMBER (15)
POSITION_ID NUMBER (15)
PAYROLL_ID NUMBER (9) Y
PAY_PROPOSAL_ID NUMBER (15) Y
PERFORMANCE_REVIEW_ID NUMBER (15)
EVENT_ID NUMBER (15)
PAY_BASIS_ID NUMBER (9) Y
INPUT_VALUE_ID NUMBER (9) Y
RATE_ID NUMBER (15)
ELEMENT_TYPE_ID NUMBER (9) Y
ASG_LAST_UPDATE_DATE DATE

PEO_LAST_UPDATE_DATE DATE

PRO_LAST_UPDATE_DATE DATE

PRO_NEXT_LAST_UPDATE_DATE DATE

PIV_LAST_UPDATE_DATE DATE

PET_LAST_UPDATE_DATE DATE

PAY_LAST_UPDATE_DATE DATE

TPT_LAST_UPDATE_DATE DATE

ASG_LAST_UPDATED_BY NUMBER (15)
PRO_LAST_UPDATED_BY NUMBER (15)

[top of page]

APPS.HRIFV_SAL_PRO references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PAY_INPUT_VALUES_F
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_PAY_BASES
SYNONYM - PER_PAY_PROPOSALS
SYNONYM - PER_PERIODS_OF_SERVICE
SYNONYM - PER_TIME_PERIOD_TYPES
- PER_ASSIGNMENTS_F
- PAY_PAYROLLS_F

APPS.HRIFV_SAL_PRO is not referenced by any database object

[top of page]

View: HRIFV_US_EMPASGDTL_EMPXASG

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240) Y
RECORD_START_DATE DATE

RECORD_END_DATE DATE

EMPLOYEE_START_DATE DATE
Y
EMPLOYEE_END_DATE DATE
Y
ASSIGNMENT_START_DATE DATE
Y
ASSIGNMENT_END_DATE DATE
Y
EMPLOYEE_NAME VARCHAR2 (240)
EMPLOYEE_NUMBER VARCHAR2 (30)
MIDDLE_NAMES VARCHAR2 (60)
PREFERRED_NAME VARCHAR2 (80)
FIRST_NAME VARCHAR2 (150)
LAST_NAME VARCHAR2 (150) Y
GENDER VARCHAR2 (4000)
PREVIOUS_LAST_NAME VARCHAR2 (150)
REGISTERED_DISABLED VARCHAR2 (4000)
TOWN_OF_BIRTH VARCHAR2 (90)
REGION_OF_BIRTH VARCHAR2 (90)
COUNTRY_OF_BIRTH VARCHAR2 (90)
DATE_OF_BIRTH DATE

MARITAL_STATUS VARCHAR2 (4000)
NATIONALITY VARCHAR2 (4000)
NATIONAL_IDENTIFIER VARCHAR2 (30)
APPLICANT_NUMBER VARCHAR2 (30)
EMAIL_ADDRESS VARCHAR2 (240)
MAIL_DESTINATION VARCHAR2 (4000)
SECOND_PASSPORT VARCHAR2 (4000)
OFFICE_NUMBER VARCHAR2 (45)
INTERNAL_LOCATION VARCHAR2 (45)
MAILSTOP VARCHAR2 (45)
WORK_SCHEDULE VARCHAR2 (30)
FTE_CAPACITY NUMBER (5)
RESUME_EXISTS VARCHAR2 (4000)
RESUME_LAST_UPDATED DATE

CURRENT_APPLICANT_FLAG VARCHAR2 (4000)
CURRENT_EMPLOYEE_FLAG VARCHAR2 (4000)
DATE_EMPLOYEE_DATA_VERIFIED DATE

DATE_OF_DEATH DATE

FAST_PATH_EMPLOYEE VARCHAR2 (4000)
HOLD_APPLICATION_UNTIL DATE

HONORS VARCHAR2 (45)
ON_MILITARY_SERVICE VARCHAR2 (4000)
PROJECTED_START_DATE DATE

STUDENT_STATUS VARCHAR2 (4000)
HIRE_DATE DATE

ORIGINAL_DATE_OF_HIRE DATE

ASSIGNMENT_TITLE VARCHAR2 (30)
ASSIGNMENT_NUMBER VARCHAR2 (30)
NORMAL_START_TIME VARCHAR2 (5)
NORMAL_END_TIME VARCHAR2 (5)
PRIMARY_FLAG VARCHAR2 (4000)
INTERNAL_ADDRESS VARCHAR2 (80)
MANAGER_FLAG VARCHAR2 (4000)
EMPLOYMENT_CATEGORY VARCHAR2 (4000)
WORKING_HOURS_AMOUNT NUMBER (22)
WORKING_HOURS_FREQUENCY VARCHAR2 (4000)
ETHNIC_ORIGIN VARCHAR2 (4000)
I9 VARCHAR2 (4000)
I9_EXPIRY_DATE DATE

VISA_TYPE VARCHAR2 (4000)
VIETNAM_VETS_STATUS VARCHAR2 (4000)
STUDENT VARCHAR2 (4000)
NEW_HIRE_STATUS VARCHAR2 (4000)
EXCLUSION_REASON VARCHAR2 (150)
CHILD_SUPPORT_OBLIGATION VARCHAR2 (4000)
SOCIAL_SECURITY_NUMBER VARCHAR2 (30)
USER_ASSIGNMENT_STATUS VARCHAR2 (80)
PER_SYSTEM_ASSIGNMENT_STATUS VARCHAR2 (4000)
PAY_SYSTEM_ASSIGNMENT_STATUS VARCHAR2 (4000)
_DF:ASG CHAR (27)
_DF:PEO CHAR (22)
GENDER_CODE VARCHAR2 (30)
REGISTERED_DISABLED_CODE VARCHAR2 (30)
MARITAL_STATUS_CODE VARCHAR2 (30)
NATIONALITY_CODE VARCHAR2 (30)
MAIL_DESTINATION_CODE VARCHAR2 (30)
SECOND_PASSPORT_CODE VARCHAR2 (30)
RESUME_EXISTS_CODE VARCHAR2 (30)
CURRENT_APPLICANT_CODE VARCHAR2 (30)
CURRENT_EMPLOYEE_CODE VARCHAR2 (30)
FAST_PATH_EMPLOYEE_CODE VARCHAR2 (30)
ON_MILITARY_SERVICE_CODE VARCHAR2 (30)
STUDENT_STATUS_CODE VARCHAR2 (30)
PRIMARY_FLAG_CODE VARCHAR2 (30) Y
MANAGER_FLAG_CODE VARCHAR2 (30)
EMPLOYMENT_CATEGORY_CODE VARCHAR2 (30)
WORKING_HOURS_FREQUENCY_CODE VARCHAR2 (30)
ETHNIC_ORIGIN_CODE VARCHAR2 (150)
I9_CODE VARCHAR2 (150)
VISA_TYPE_CODE VARCHAR2 (150)
VIETNAM_VETS_STATUS_CODE VARCHAR2 (150)
STUDENT_CODE VARCHAR2 (150)
NEW_HIRE_STATUS_CODE VARCHAR2 (150)
CHILD_SUPPORT_OBLIGATION_CODE VARCHAR2 (150)
PER_SYSTEM_ASGN_STATUS_CODE VARCHAR2 (30)
PAY_SYSTEM_ASGN_STATUS_CODE VARCHAR2 (1)
PERSON_ID NUMBER (10) Y
BUSINESS_GROUP_ID NUMBER (15) Y
BENEFIT_GROUP_ID NUMBER (15)
PERSON_TYPE_ID NUMBER (15) Y
PERSON_COMMENT_ID NUMBER (15)
ASSIGNMENT_ID NUMBER (10) Y
GRADE_ID NUMBER (15)
JOB_ID NUMBER (15)
LOCATION_ID NUMBER (15)
ORGANIZATION_ID NUMBER (15) Y
PAYROLL_ID NUMBER (9)
PERIOD_OF_SERVICE_ID NUMBER (15)
PEOPLE_GROUP_ID NUMBER (15)
POSITION_ID NUMBER (15)
RECRUITMENT_ACTIVITY_ID NUMBER (15)
SALARY_BASIS_ID NUMBER (9)
SUPERVISOR_ID NUMBER (10)
SPECIAL_CEILING_STEP_ID NUMBER (15)
ASSIGNMENT_COMMENT_ID NUMBER (15)
SET_OF_BOOKS_ID NUMBER (15)
COLLECTIVE_AGREEMENT_ID NUMBER (9)
CONTRACT_ID NUMBER (9)
VACANCY_ID NUMBER (15)
RECRUITER_ID NUMBER (10)
PERSON_REFERRED_BY_ID NUMBER (10)
SOURCE_ORGANIZATION_ID NUMBER (15)

[top of page]

APPS.HRIFV_US_EMPASGDTL_EMPXASG references the following:

APPS
PACKAGE - FND_DATE
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_ASSIGNMENT_STATUS_TYPES
SYNONYM - PER_ASSIGNMENT_STATUS_TYPES_TL
SYNONYM - PER_ASS_STATUS_TYPE_AMENDS
SYNONYM - PER_ASS_STATUS_TYPE_AMENDS_TL
SYNONYM - PER_PERIODS_OF_SERVICE
- PER_ASSIGNMENTS_F
- PER_BUSINESS_GROUPS

APPS.HRIFV_US_EMPASGDTL_EMPXASG is not referenced by any database object

[top of page]

View: HRIFV_US_FEDREP_GEN_HRCHY

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
HIERARCHY_NAME VARCHAR2 (80)
HIERARCHY_TYPE VARCHAR2 (4000)
HIERARCHY_TYPE_CODE VARCHAR2 (30)
HIERARCHY_VERSION_NUMBER NUMBER (9)
HIERARCHY_VERSION_DATE_FROM DATE

HIERARCHY_VERSION_DATE_TO DATE

HIER_VERSION_DATE_TO_NN DATE

HIER_VERSION_STATUS_CODE VARCHAR2 (30)
HIER_VERSION_STATUS VARCHAR2 (4000)
ENTITY_LEVEL NUMBER (4)
NODE_TYPE_CODE VARCHAR2 (30)
NODE_TYPE VARCHAR2 (4000)
NODE_NAME VARCHAR2 (240)
NODE_LONG_NAME VARCHAR2 (760)
SUB_ENTITY_LEVEL NUMBER (4)
SUB_NODE_TYPE_CODE VARCHAR2 (30)
SUB_NODE_TYPE VARCHAR2 (4000)
SUB_NODE_NAME VARCHAR2 (60)
SUB_NODE_LONG_NAME VARCHAR2 (760)
_DF:HRCY CHAR (29)
_DF:HRCYVER CHAR (38)
_DF:PAR CHAR (35)
_DF:LOC CHAR (22)
HIERARCHY_ID NUMBER (15)
HIERARCHY_VERSION_ID NUMBER (15)
BUSINESS_GROUP_ID NUMBER (9)
ENTITY_ID VARCHAR2 (255)
HIERARCHY_NODE_ID NUMBER (15)
SUB_ENTITY_BG_ID NUMBER (9)
SUB_ENTITY_ID VARCHAR2 (255)
SUB_HIERARCHY_NODE_ID NUMBER (15)

[top of page]

APPS.HRIFV_US_FEDREP_GEN_HRCHY references the following:

APPS
SYNONYM - HRI_GEN_HRCHY_SUMMARY
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_LOCATIONS_ALL_TL
SYNONYM - HR_LOCATION_EXTRA_INFO
SYNONYM - HR_ORGANIZATION_INFORMATION
SYNONYM - PER_GEN_HIERARCHY
SYNONYM - PER_GEN_HIERARCHY_NODES
SYNONYM - PER_GEN_HIERARCHY_VERSIONS

APPS.HRIFV_US_FEDREP_GEN_HRCHY is not referenced by any database object

[top of page]

View: HRIFV_US_FEDREP_GEN_H_LOCEXP

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
LOCATION_NAME VARCHAR2 (60) Y
LOCATION_DESCRIPTION VARCHAR2 (240)
ADDRESS_LINE_1 VARCHAR2 (240)
ADDRESS_LINE_2 VARCHAR2 (240)
ADDRESS_LINE_3 VARCHAR2 (240)
CITY VARCHAR2 (30)
COUNTY VARCHAR2 (120)
STATE_NAME VARCHAR2 (4000)
STATE_CODE VARCHAR2 (120)
COUNTRY VARCHAR2 (60)
ZIP_CODE VARCHAR2 (30)
INACTIVE_DATE DATE

ADDRESS_STYLE VARCHAR2 (7)
DEFAULT_TAX_CODE VARCHAR2 (15)
_DF CHAR (24)
LOCATION_ID NUMBER (15) Y
BUSINESS_GROUP_ID NUMBER (15)

[top of page]

APPS.HRIFV_US_FEDREP_GEN_H_LOCEXP references the following:

APPS
SYNONYM - HRI_GEN_HRCHY_SUMMARY
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_LOCATIONS_ALL_TL

APPS.HRIFV_US_FEDREP_GEN_H_LOCEXP is not referenced by any database object

[top of page]

View: HRIFV_US_PERDTL

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240) Y
PERSON_NAME VARCHAR2 (240)
EFFECTIVE_START_DATE DATE
Y
EFFECTIVE_END_DATE DATE
Y
EMPLOYEE_NUMBER VARCHAR2 (30)
SOCIAL_SECURITY_NUMBER VARCHAR2 (30)
ETHNIC_ORIGIN VARCHAR2 (4000)
I9 VARCHAR2 (4000)
I9_EXPIRY_DATE DATE

VISA_TYPE VARCHAR2 (4000)
VIETNAM_VETS_STATUS VARCHAR2 (4000)
STUDENT VARCHAR2 (4000)
NEW_HIRE_STATUS VARCHAR2 (4000)
EXCLUSION_REASON VARCHAR2 (150)
CHILD_SUPPORT_OBLIGATION VARCHAR2 (4000)
REGISTERED_DISABLED VARCHAR2 (4000)
_DF CHAR (22)
BUSINESS_GROUP_ID NUMBER (15) Y
PERSON_ID NUMBER (10) Y

[top of page]

APPS.HRIFV_US_PERDTL references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
- PER_BUSINESS_GROUPS
- PER_PEOPLE_F

APPS.HRIFV_US_PERDTL is not referenced by any database object

[top of page]

View: HRI_CL_ASGSTYP_BX_V

Comments
View Type

A Business Intelligence System view

List of values for all Assignment Status Types.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER (9) Y
VALUE VARCHAR2 (80)
DATE_FROM DATE

DATE_TO DATE

BUSINESS_GROUP_ID NUMBER

PAY_SYSTEM_STATUS VARCHAR2 (1)
PER_SYSTEM_STATUS VARCHAR2 (30)
PRIMARY_FLAG VARCHAR2 (30) Y
DEFAULT_FLAG VARCHAR2 (30) Y
VALID_CODE VARCHAR2 (30)

[top of page]

APPS.HRI_CL_ASGSTYP_BX_V references the following:

APPS
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
SYNONYM - PER_ASSIGNMENT_STATUS_TYPES
SYNONYM - PER_ASSIGNMENT_STATUS_TYPES_TL
SYNONYM - PER_ASS_STATUS_TYPE_AMENDS
SYNONYM - PER_ASS_STATUS_TYPE_AMENDS_TL

APPS.HRI_CL_ASGSTYP_BX_V is not referenced by any database object

[top of page]

View: HRI_CL_BUDPQH_H_V

Comments
View Type

A Business Intelligence System view

List of values for PQH Budgets.

Columns
Name Datatype Length Mandatory Comments
VALUE VARCHAR2 (30) Y
ID NUMBER (15) Y
START_DATE DATE
Y
END_DATE DATE
Y
BUSINESS_GROUP_ID NUMBER (15)

[top of page]

APPS.HRI_CL_BUDPQH_H_V references the following:

APPS
PACKAGE - HR_BIS
SYNONYM - PQH_BUDGETS

APPS.HRI_CL_BUDPQH_H_V is not referenced by any database object

[top of page]

View: HRI_CL_CMPBEN_OBJ_X_V

Comments
View Type

A Business Intelligence System view

iRecruitment list of current (sysdate) compensation object lookups.

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (30)
VALUE VARCHAR2 (80)
DESCRIPTION VARCHAR2 (240)
ENABLED_FLAG VARCHAR2 (1)
START_DATE DATE

END_DATE DATE

[top of page]

APPS.HRI_CL_CMPBEN_OBJ_X_V references the following:

APPS
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_CMPBEN_OBJ_X_V is not referenced by any database object

[top of page]

View: HRI_CL_CMPTNC_BX_V

Comments
View Type

A Business Intelligence System view

List of current (sysdate) competence names,with business group filter.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER

VALUE VARCHAR2 (700)
DATE_FROM DATE

DATE_TO DATE

BUSINESS_GROUP_ID NUMBER

[top of page]

APPS.HRI_CL_CMPTNC_BX_V references the following:

APPS
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
SYNONYM - PER_COMPETENCES
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_CMPTNC_BX_V is not referenced by any database object

[top of page]

View: HRI_CL_EDU_ESTBMNT_V

Comments
View Type

A Business Intelligence System view

List of education establishments entered into the HRMS system.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER

VALUE VARCHAR2 (160)

[top of page]

APPS.HRI_CL_EDU_ESTBMNT_V references the following:

APPS
SYNONYM - PER_ESTABLISHMENTS
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_EDU_ESTBMNT_V is not referenced by any database object

[top of page]

View: HRI_CL_EDU_EST_CAND_V

Comments
View Type

A Business Intelligence System view

List of education establishments entered (free text) by candidates

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (255)
VALUE VARCHAR2 (255)

[top of page]

APPS.HRI_CL_EDU_EST_CAND_V references the following:

APPS
SYNONYM - PER_ESTABLISHMENT_ATTENDANCES
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_EDU_EST_CAND_V is not referenced by any database object

[top of page]

View: HRI_CL_EDU_QUAL_AWRDBDY_V

Comments
View Type

A Business Intelligence System view

List of qualification awarding bodies entered in the HRMS system.

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (100)
VALUE VARCHAR2 (100)

[top of page]

APPS.HRI_CL_EDU_QUAL_AWRDBDY_V references the following:

APPS
SYNONYM - PER_QUALIFICATIONS
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_EDU_QUAL_AWRDBDY_V is not referenced by any database object

[top of page]

View: HRI_CL_EDU_QUAL_CAT_HX_V

Comments
View Type

A Business Intelligence System view

List of all the current (SYSDATE) qualification categories with HR Security.

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (30)
VALUE VARCHAR2 (80)
START_DATE DATE

END_DATE DATE

ENABLED_FLAG VARCHAR2 (1)

[top of page]

APPS.HRI_CL_EDU_QUAL_CAT_HX_V references the following:

APPS
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_EDU_QUAL_CAT_HX_V is not referenced by any database object

[top of page]

View: HRI_CL_EDU_QUAL_TITLE_V

Comments
View Type

A Business Intelligence System view

A list of all the qualification titles in the HRMS system, no security.

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (120)
VALUE VARCHAR2 (120)

[top of page]

APPS.HRI_CL_EDU_QUAL_TITLE_V references the following:

APPS
SYNONYM - PER_QUALIFICATIONS
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_EDU_QUAL_TITLE_V is not referenced by any database object

[top of page]

View: HRI_CL_EDU_QUAL_TYPE_V

Comments
View Type

A Business Intelligence System view

A list of all the qualification types entered into the HRMS system, no security.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER

VALUE VARCHAR2 (150)
CATEGORY VARCHAR2 (30)
RANK NUMBER

[top of page]

APPS.HRI_CL_EDU_QUAL_TYPE_V references the following:

APPS
SYNONYM - PER_QUALIFICATION_TYPES
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_EDU_QUAL_TYPE_V is not referenced by any database object

[top of page]

View: HRI_CL_EMPCAT_X_V

Comments
View Type

A Business Intelligence System view

A list of all the current (SYSDATE) iRecruitment Employment Category lookup codes and meanings

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (30)
VALUE VARCHAR2 (80)
DESCRIPTION VARCHAR2 (240)
ENABLED_FLAG VARCHAR2 (1)
START_DATE DATE

END_DATE DATE

[top of page]

APPS.HRI_CL_EMPCAT_X_V references the following:

APPS
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_EMPCAT_X_V is not referenced by any database object

[top of page]

View: HRI_CL_GB_ETHNC_X_V

Comments
Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (30)
VALUE VARCHAR2 (80)
DATE_FROM DATE

DATE_TO DATE

VALID_CODE VARCHAR2 (1)

[top of page]

APPS.HRI_CL_GB_ETHNC_X_V references the following:

APPS
PACKAGE - HR_GENERAL
PUBLIC
SYNONYM - DUAL
- HR_API
- DUAL
- HR_LOOKUPS

APPS.HRI_CL_GB_ETHNC_X_V is not referenced by any database object

[top of page]

View: HRI_CL_GENDER_X_V

Comments
Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (30)
VALUE VARCHAR2 (80)
DATE_FROM DATE

DATE_TO DATE

VALID_CODE VARCHAR2 (1)

[top of page]

APPS.HRI_CL_GENDER_X_V references the following:

APPS
PACKAGE - HR_GENERAL
PUBLIC
SYNONYM - DUAL
- HR_API
- DUAL
- HR_LOOKUPS

APPS.HRI_CL_GENDER_X_V is not referenced by any database object

[top of page]

View: HRI_CL_GRADE_BX_V

Comments
View Type

A Business Intelligence System view

List of values for current HR Grades.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER

VALUE VARCHAR2 (240)
START_DATE DATE

END_DATE DATE

BUSINESS_GROUP_ID NUMBER

[top of page]

APPS.HRI_CL_GRADE_BX_V references the following:

APPS
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
SYNONYM - PER_GRADES
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_GRADE_BX_V is not referenced by any database object

[top of page]

View: HRI_CL_JOB_BX_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER

VALUE VARCHAR2 (700)
START_DATE DATE

END_DATE DATE

BUSINESS_GROUP_ID NUMBER

[top of page]

APPS.HRI_CL_JOB_BX_V references the following:

APPS
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
SYNONYM - PER_JOBS
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_JOB_BX_V is not referenced by any database object

[top of page]

View: HRI_CL_JOB_CAT_X_V

Comments
Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (30)
VALUE VARCHAR2 (80)
DATE_FROM DATE

DATE_TO DATE

VALID_CODE VARCHAR2 (1)

[top of page]

APPS.HRI_CL_JOB_CAT_X_V references the following:

APPS
PACKAGE - HR_GENERAL
PUBLIC
SYNONYM - DUAL
- HR_API
- DUAL
- HR_LOOKUPS

APPS.HRI_CL_JOB_CAT_X_V is not referenced by any database object

[top of page]

View: HRI_CL_ORG_BGR_BX_V

Comments
View Type

A Business Intelligence System view

List of values for all Business Groups.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER

VALUE VARCHAR2 (240)
DATE_FROM DATE

DATE_TO DATE

RESPONSIBILITY_ID NUMBER

[top of page]

APPS.HRI_CL_ORG_BGR_BX_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
SYNONYM - HR_ORGANIZATION_INFORMATION
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_ORG_BGR_BX_V is not referenced by any database object

[top of page]

View: HRI_CL_ORG_HRCY_BX_V

Comments
View Type

A Business Intelligence System view

List of values for HR Organization Hierarchies, (restricts to hierarchies in a business group, but shows all global hierarchies).

Columns
Name Datatype Length Mandatory Comments
ID NUMBER (15) Y
VALUE VARCHAR2 (30) Y
START_DATE DATE

END_DATE DATE

RESPONSIBILITY_ID NUMBER

PRIMARY_STRUCTURE_FLAG VARCHAR2 (30)
BUSINESS_GROUP_ID NUMBER (15)

[top of page]

APPS.HRI_CL_ORG_HRCY_BX_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HRI_OLTP_VIEW_SECURITY
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
- HRI_CL_ORG_HRCY_N_V

APPS.HRI_CL_ORG_HRCY_BX_V is not referenced by any database object

[top of page]

View: HRI_CL_ORG_HR_HX_V

Comments
View Type

A Business Intelligence System view

List of values for current HR Organizations. (Based on HR_ORGANIZATION_UNITS - implements hr security & Business Group Security)

Columns
Name Datatype Length Mandatory Comments
ID NUMBER

VALUE VARCHAR2 (240)
START_DATE DATE

END_DATE DATE

RESPONSIBILITY_ID NUMBER

BUSINESS_GROUP_ID NUMBER

[top of page]

APPS.HRI_CL_ORG_HR_HX_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
SYNONYM - HR_ORGANIZATION_INFORMATION
PACKAGE - HR_SECURITY
PUBLIC
SYNONYM - DUAL
- HR_ORGANIZATION_UNITS
- DUAL

APPS.HRI_CL_ORG_HR_HX_V is not referenced by any database object

[top of page]

View: HRI_CL_PER_EMP_HX_V

Comments
View Type

A Business Intelligence System view

List of values for current Employees with HR Security.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER

VALUE VARCHAR2 (240)
START_DATE DATE

END_DATE DATE

BUSINESS_GROUP_ID NUMBER

CURRENT_EMPLOYEE_FLAG VARCHAR2 (30)
CURRENT_APPLICANT_FLAG VARCHAR2 (30)
CURRENT_EMP_OR_APL_FLAG VARCHAR2 (30)
PERSON_TYPE_ID NUMBER

COMMENT_ID NUMBER

[top of page]

APPS.HRI_CL_PER_EMP_HX_V references the following:

APPS
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
PUBLIC
SYNONYM - DUAL
- PER_PEOPLE_X
- DUAL

APPS.HRI_CL_PER_EMP_HX_V is not referenced by any database object

[top of page]

View: HRI_CL_PER_HIRMGR_HX_V

Comments
View Type

A Business Intelligence System view

List of Hiring Managers who are current (sysdate) employees, with HRMS security.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER

VALUE VARCHAR2 (240)
START_DATE DATE

END_DATE DATE

BUSINESS_GROUP_ID NUMBER

[top of page]

APPS.HRI_CL_PER_HIRMGR_HX_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PER_ALL_VACANCIES
PUBLIC
SYNONYM - DUAL
- DUAL
- PER_PEOPLE_F

APPS.HRI_CL_PER_HIRMGR_HX_V is not referenced by any database object

[top of page]

View: HRI_CL_PER_RECMGR_HX_V

Comments
View Type

A Business Intelligence System view

List of Recruiters who are current (sysdate) employees, with HRMS security.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER

VALUE VARCHAR2 (240)
START_DATE DATE

END_DATE DATE

PARTY_ID NUMBER

[top of page]

APPS.HRI_CL_PER_RECMGR_HX_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PER_ALL_VACANCIES
PUBLIC
SYNONYM - DUAL
- DUAL
- PER_PEOPLE_F

APPS.HRI_CL_PER_RECMGR_HX_V is not referenced by any database object

[top of page]

View: HRI_CL_PER_SUP_HX_V

Comments
View Type

A Business Intelligence System view

List of values for current Supervisors with HR Security.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER

VALUE VARCHAR2 (240)
DATE_FROM DATE

DATE_TO DATE

BUSINESS_GROUP_ID NUMBER

CURRENT_EMPLOYEE_FLAG VARCHAR2 (30)
CURRENT_APPLICANT_FLAG VARCHAR2 (30)
CURRENT_EMP_OR_APL_FLAG VARCHAR2 (30)
PERSON_TYPE_ID NUMBER

COMMENT_ID NUMBER

[top of page]

APPS.HRI_CL_PER_SUP_HX_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
PUBLIC
SYNONYM - DUAL
- PER_ASSIGNMENTS_X
- DUAL
- PER_PEOPLE_X

APPS.HRI_CL_PER_SUP_HX_V is not referenced by any database object

[top of page]

View: HRI_CL_POSITION_HX_V

Comments
View Type

A Business Intelligence System view

List of values for current Positions.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER

VALUE VARCHAR2 (240)
START_DATE DATE

END_DATE DATE

BUSINESS_GROUP_ID NUMBER

ORGANIZATION_ID NUMBER

JOB_ID NUMBER

POSITION_DEFINITION_ID NUMBER

[top of page]

APPS.HRI_CL_POSITION_HX_V references the following:

APPS
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PUBLIC
SYNONYM - DUAL
- PER_POSITIONS
- DUAL

APPS.HRI_CL_POSITION_HX_V is not referenced by any database object

[top of page]

View: HRI_CL_PRF_RTNG_X_V

Comments
Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (30)
VALUE VARCHAR2 (80)
DATE_FROM DATE

DATE_TO DATE

VALID_CODE VARCHAR2 (1)

[top of page]

APPS.HRI_CL_PRF_RTNG_X_V references the following:

APPS
PACKAGE - HR_GENERAL
PUBLIC
SYNONYM - DUAL
- HR_API
- DUAL
- HR_LOOKUPS

APPS.HRI_CL_PRF_RTNG_X_V is not referenced by any database object

[top of page]

View: HRI_CL_PTY_NONPTU_B_V

Comments
View Type

A Business Intelligence System view

List of values for Person Types (not using Person type usages).

Columns
Name Datatype Length Mandatory Comments
USER_PERSON_TYPE VARCHAR2 (80) Y
DEFAULT_FLAG VARCHAR2 (30) Y
SYSTEM_PERSON_TYPE VARCHAR2 (30) Y
PERSON_TYPE_ID NUMBER (15) Y
BUSINESS_GROUP_ID NUMBER (15) Y

[top of page]

APPS.HRI_CL_PTY_NONPTU_B_V references the following:

APPS
PACKAGE - HR_BIS
SYNONYM - PER_PERSON_TYPES
SYNONYM - PER_PERSON_TYPES_TL

APPS.HRI_CL_PTY_NONPTU_B_V is not referenced by any database object

[top of page]

View: HRI_CL_RECACT_SRCNAME_V

Comments
View Type

A Business Intelligence System view

List of Recruitment Activity Source Names.

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (240)
VALUE VARCHAR2 (240)
START_DATE DATE

END_DATE DATE

BUSINESS_GROUP_ID NUMBER

[top of page]

APPS.HRI_CL_RECACT_SRCNAME_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - PER_ALL_ASSIGNMENTS_F
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_RECACT_SRCNAME_V is not referenced by any database object

[top of page]

View: HRI_CL_RECACT_TYPE_X_V

Comments
View Type

A Business Intelligence System view

List of current (sysdate) recruitment activity types.

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (30)
VALUE VARCHAR2 (80)
START_DATE DATE

END_DATE DATE

ENABLED_FLAG VARCHAR2 (1)

[top of page]

APPS.HRI_CL_RECACT_TYPE_X_V references the following:

APPS
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_RECACT_TYPE_X_V is not referenced by any database object

[top of page]

View: HRI_CL_RQNVAC_PROFAREA_X_V

Comments
View Type

A Business Intelligence System view

iRecruitment, list of current (sysdate) professional area lookups.

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (30)
VALUE VARCHAR2 (80)
DESCRIPTION VARCHAR2 (240)
ENABLED_FLAG VARCHAR2 (1)
START_DATE DATE

END_DATE DATE

[top of page]

APPS.HRI_CL_RQNVAC_PROFAREA_X_V references the following:

APPS
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_RQNVAC_PROFAREA_X_V is not referenced by any database object

[top of page]

View: HRI_CL_RQNVAC_VACNCY_H_V

Comments
View Type

A Business Intelligence System view

List of all vacancy names, with HRMS security.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER

VALUE VARCHAR2 (30)
START_DATE DATE

END_DATE DATE

BUSINESS_GROUP_ID NUMBER

[top of page]

APPS.HRI_CL_RQNVAC_VACNCY_H_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PUBLIC
SYNONYM - DUAL
- DUAL
- PER_VACANCIES

APPS.HRI_CL_RQNVAC_VACNCY_H_V is not referenced by any database object

[top of page]

View: HRI_CL_RSN_SAL_X_V

Comments
Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (30)
VALUE VARCHAR2 (80)
DATE_FROM DATE

DATE_TO DATE

VALID_CODE VARCHAR2 (1)

[top of page]

APPS.HRI_CL_RSN_SAL_X_V references the following:

APPS
PACKAGE - HR_GENERAL
PUBLIC
SYNONYM - DUAL
- HR_API
- DUAL
- HR_LOOKUPS

APPS.HRI_CL_RSN_SAL_X_V is not referenced by any database object

[top of page]

View: HRI_CL_RSN_SEP_X_V

Comments
View Type

A Business Intelligence System view

List of values for current valid Separation Reasons.

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (30)
VALUE VARCHAR2 (4000)
DATE_FROM DATE

DATE_TO DATE

ORDER_BY VARCHAR2 (80)
VALID_CODE VARCHAR2 (1)

[top of page]

APPS.HRI_CL_RSN_SEP_X_V references the following:

APPS
PACKAGE - HRI_OLTP_VIEW_MESSAGE
SYNONYM - HRI_UNASSIGNED
PACKAGE - HR_GENERAL
- HR_STANDARD_LOOKUPS

APPS.HRI_CL_RSN_SEP_X_V is not referenced by any database object

[top of page]

View: HRI_CL_TRAVEL_PERCENT_X_V

Comments
View Type

A Business Intelligence System view

iRecruitment, list of travel willingness lookup

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (30)
VALUE VARCHAR2 (80)
DESCRIPTION VARCHAR2 (240)
ENABLED_FLAG VARCHAR2 (1)
START_DATE DATE

END_DATE DATE

[top of page]

APPS.HRI_CL_TRAVEL_PERCENT_X_V references the following:

APPS
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_TRAVEL_PERCENT_X_V is not referenced by any database object

[top of page]

View: HRI_CL_US_ETHNC_X_V

Comments
Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (30)
VALUE VARCHAR2 (80)
DATE_FROM DATE

DATE_TO DATE

VALID_CODE VARCHAR2 (1)

[top of page]

APPS.HRI_CL_US_ETHNC_X_V references the following:

APPS
PACKAGE - HR_GENERAL
PUBLIC
SYNONYM - DUAL
- HR_API
- DUAL
- HR_LOOKUPS

APPS.HRI_CL_US_ETHNC_X_V is not referenced by any database object

[top of page]

View: HRI_CL_WAC_GAINTYP_X_V

Comments
View Type

A Business Intelligence System view

List of values for Gain Types.

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (30)
VALUE VARCHAR2 (80)
DATE_FROM DATE

DATE_TO DATE

VALID_CODE VARCHAR2 (1)

[top of page]

APPS.HRI_CL_WAC_GAINTYP_X_V references the following:

APPS
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_WAC_GAINTYP_X_V is not referenced by any database object

[top of page]

View: HRI_CL_WAC_LOSSTYP_X_V

Comments
View Type

A Business Intelligence System view

List of values for Loss Types.

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (30)
VALUE VARCHAR2 (80)
DATE_FROM DATE

DATE_TO DATE

VALID_CODE VARCHAR2 (1)

[top of page]

APPS.HRI_CL_WAC_LOSSTYP_X_V references the following:

APPS
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_WAC_LOSSTYP_X_V is not referenced by any database object

[top of page]

View: HRI_CL_WAC_SEPCAT_X_V

Comments
View Type

A Business Intelligence System view

List of values for Separation Categories.

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (30)
VALUE VARCHAR2 (80)
START_DATE DATE

END_DATE DATE

ORDER_BY VARCHAR2 (80)
VALID_CODE VARCHAR2 (1)

[top of page]

APPS.HRI_CL_WAC_SEPCAT_X_V references the following:

APPS
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_WAC_SEPCAT_X_V is not referenced by any database object

[top of page]

View: HRI_CL_WMT_X_V

Comments
View Type

A Business Intelligence System view

List of values for current valid Workforce Measurements Types.

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (30) Y
VALUE VARCHAR2 (80) Y
DATE_FROM DATE

DATE_TO DATE

VALID_CODE VARCHAR2 (1) Y

[top of page]

APPS.HRI_CL_WMT_X_V references the following:

APPS
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS

APPS.HRI_CL_WMT_X_V is not referenced by any database object

[top of page]

View: HRI_CL_WORK_AT_HOME_X_V

Comments
View Type

A Business Intelligence System view

iRecruitment, list of work at home lookups.

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (30)
VALUE VARCHAR2 (80)
DESCRIPTION VARCHAR2 (240)
ENABLED_FLAG VARCHAR2 (1)
START_DATE DATE

END_DATE DATE

[top of page]

APPS.HRI_CL_WORK_AT_HOME_X_V references the following:

APPS
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HRI_CL_WORK_AT_HOME_X_V is not referenced by any database object

[top of page]

View: HRI_GRD_LOV_V

Comments
View Type

A Business Intelligence System view

List if values for Grade

Columns
Name Datatype Length Mandatory Comments
GRADE_ID NUMBER (15) Y
GRADE_NAME VARCHAR2 (240)

[top of page]

APPS.HRI_GRD_LOV_V references the following:

APPS
PACKAGE - HR_BIS
SYNONYM - PER_GRADES
SYNONYM - PER_GRADES_TL

APPS.HRI_GRD_LOV_V is not referenced by any database object

[top of page]

View: HRI_JOB_LOV_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
JOB_ID NUMBER

JOB_NAME VARCHAR2 (700)

[top of page]

APPS.HRI_JOB_LOV_V references the following:

APPS
PACKAGE - HR_BIS
SYNONYM - PER_JOBS
SYS
TABLE - DUAL

APPS.HRI_JOB_LOV_V is not referenced by any database object

[top of page]

View: HRI_LOC_LOV_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
LOCATION_ID NUMBER (15) Y
LOCATION_NAME VARCHAR2 (60) Y

[top of page]

APPS.HRI_LOC_LOV_V references the following:

APPS
PACKAGE - HR_BIS
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_LOCATIONS_ALL_TL

APPS.HRI_LOC_LOV_V is not referenced by any database object

[top of page]

View: HRI_ORG_LOV_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view

This view contains the definition of the organization List of Values.

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15) Y
ORGANIZATION_NAME VARCHAR2 (240) Y

[top of page]

APPS.HRI_ORG_LOV_V references the following:

APPS
PACKAGE - HRBISORGPARAMS
SYNONYM - HRI_ORG_PARAM_LIST
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
- HR_ORGANIZATION_UNITS

APPS.HRI_ORG_LOV_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract