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 - GHR Tables and Views

TABLE - HR.GHR_BREAKDOWN_CRITERIA
TABLE - HR.GHR_BREAKDOWN_RESULTS
TABLE - HR.GHR_COMPLAINTS2
TABLE - HR.GHR_COMPL_ADRS
TABLE - HR.GHR_COMPL_AGENCY_APPEALS
TABLE - HR.GHR_COMPL_AGENCY_COSTS
TABLE - HR.GHR_COMPL_APPEALS
TABLE - HR.GHR_COMPL_BASES
TABLE - HR.GHR_COMPL_CA_DETAILS
TABLE - HR.GHR_COMPL_CA_HEADERS
TABLE - HR.GHR_COMPL_CLAIMS
TABLE - HR.GHR_COMPL_INCIDENTS
TABLE - HR.GHR_COMPL_PEOPLE
TABLE - HR.GHR_CPDF_TEMP
TABLE - HR.GHR_DUAL_ACTIONS
TABLE - HR.GHR_DUAL_PROC_METHODS
TABLE - HR.GHR_DUTY_STATIONS_F
TABLE - HR.GHR_EVENTS
TABLE - HR.GHR_EVENT_HISTORY
TABLE - HR.GHR_FAMILIES
TABLE - HR.GHR_GROUPBOXES
TABLE - HR.GHR_GROUPBOX_USERS
TABLE - HR.GHR_INTERFACE
TABLE - HR.GHR_LOCALITY_PAY_AREAS_F
TABLE - HR.GHR_MASS_ACTIONS_PREVIEW
TABLE - HR.GHR_MASS_AWARDS
TABLE - HR.GHR_MASS_AWARD_CRITERIA_COLS
TABLE - HR.GHR_MASS_AWARD_CRITERIA_VALS
TABLE - HR.GHR_MASS_REALIGNMENT
TABLE - HR.GHR_MASS_SALARIES
TABLE - HR.GHR_MASS_SALARY_CRITERIA
TABLE - HR.GHR_MASS_SALARY_CRITERIA_EXT
TABLE - HR.GHR_MASS_TRANSFERS
TABLE - HR.GHR_MASS_TRANSFER_CRITERIA
TABLE - HR.GHR_MTS_TEMP
TABLE - HR.GHR_NATURE_OF_ACTIONS
TABLE - HR.GHR_NOAC_LAS
TABLE - HR.GHR_NOAC_REMARKS
TABLE - HR.GHR_NOA_FAMILIES
TABLE - HR.GHR_NOA_FAM_PROC_METHODS
TABLE - HR.GHR_PAYROLL
TABLE - HR.GHR_PAY_PLANS
TABLE - HR.GHR_PAY_PLAN_WAITING_PERIODS
TABLE - HR.GHR_PA_DATA_FIELDS
TABLE - HR.GHR_PA_HISTORY
TABLE - HR.GHR_PA_INTERFACE_ERR_DTLS
TABLE - HR.GHR_PA_REMARKS
TABLE - HR.GHR_PA_REQUESTS
TABLE - HR.GHR_PA_REQUEST_EI_SHADOW
TABLE - HR.GHR_PA_REQUEST_EXTRA_INFO
TABLE - HR.GHR_PA_REQUEST_INFO_TYPES
TABLE - HR.GHR_PA_REQUEST_SHADOW
TABLE - HR.GHR_PA_ROUTING_HISTORY
TABLE - HR.GHR_PD_CLASSIFICATIONS
TABLE - HR.GHR_PD_ROUTING_HISTORY
TABLE - HR.GHR_PERF_CERT
TABLE - HR.GHR_PLAN_SERVICE_AREAS_F
TABLE - HR.GHR_POIS
TABLE - HR.GHR_POSITION_DESCRIPTIONS
TABLE - HR.GHR_POS_INTERFACE_ERR_DTLS
TABLE - HR.GHR_PREMIUM_PAY_INDICATORS
TABLE - HR.GHR_PROCESS_LOG
TABLE - HR.GHR_REMARKS
TABLE - HR.GHR_RESTRICTED_PROC_METHODS
TABLE - HR.GHR_RIF_CRITERIA
TABLE - HR.GHR_RIF_REGISTERS
TABLE - HR.GHR_ROUTING_GROUPS
TABLE - HR.GHR_ROUTING_LISTS
TABLE - HR.GHR_ROUTING_LIST_MEMBERS
VIEW - APPS.GHR_ADDRESSES_H_V
VIEW - APPS.GHR_ASSIGNMENTS_H_V
VIEW - APPS.GHR_ASSIGNMENT_EXTRA_INFO_H_V
VIEW - APPS.GHR_BREAKDOWN_V
VIEW - APPS.GHR_CLAIM_SOURCE_V
VIEW - APPS.GHR_DUTY_STATIONS_D
VIEW - APPS.GHR_DUTY_STATIONS_V
VIEW - APPS.GHR_ELEMENT_ENTRIES_H_V
VIEW - APPS.GHR_ELEMENT_ENTRIES_V
VIEW - APPS.GHR_ELEMENT_ENTRY_VALUES_H_V
VIEW - APPS.GHR_EVENT_HISTORY_V
VIEW - APPS.GHR_GBX_ROLES
VIEW - APPS.GHR_GBX_UR
VIEW - APPS.GHR_INFO_TYPE_SECURITY_RIT_V
VIEW - APPS.GHR_MASS_AWARDS_PREVIEW_V
VIEW - APPS.GHR_MASS_REAL_POS_INFO_V
VIEW - APPS.GHR_MT_ADDRESSES_V
VIEW - APPS.GHR_MT_ANALYSIS_CRITERIA_V
VIEW - APPS.GHR_MT_ASSIGNMENTS_F_V
VIEW - APPS.GHR_MT_ASSIGNMENT_EI_V
VIEW - APPS.GHR_MT_ELEMENT_ENTRIES_V
VIEW - APPS.GHR_MT_INTERFACE_V
VIEW - APPS.GHR_MT_MISC_V
VIEW - APPS.GHR_MT_PEOPLE_EI_V
VIEW - APPS.GHR_MT_PEOPLE_F_V
VIEW - APPS.GHR_MT_POSITIONS_V
VIEW - APPS.GHR_MT_POSITION_DEFINITIONS_V
VIEW - APPS.GHR_MT_POSITION_EI_V
VIEW - APPS.GHR_PA_REMARKS_V
VIEW - APPS.GHR_PA_REQUESTS_V
VIEW - APPS.GHR_PA_REQUESTS_V1
VIEW - APPS.GHR_PA_ROUTING_HISTORY_V
VIEW - APPS.GHR_PD_CLASSIFICATIONS_V1
VIEW - APPS.GHR_PD_CLASSIFICATIONS_V2
VIEW - APPS.GHR_PD_COVERSHEET_V
VIEW - APPS.GHR_PEOPLE_EXTRA_INFO_H_V
VIEW - APPS.GHR_PEOPLE_H_V
VIEW - APPS.GHR_PEOPLE_V
VIEW - APPS.GHR_PERSON_ANALYSES_H_V
VIEW - APPS.GHR_PERSON_SUMMARY_V
VIEW - APPS.GHR_POIS_V
VIEW - APPS.GHR_POSITIONS_H_V
VIEW - APPS.GHR_POSITIONS_V
VIEW - APPS.GHR_POSITION_DESCRIPTIONS_V
VIEW - APPS.GHR_POSITION_EXTRA_INFO_H_V
VIEW - APPS.GHR_PROCESS_LOG_V
VIEW - APPS.GHR_PROCESS_LOG_V2
VIEW - APPS.GHR_SF113_V
VIEW - APPS.GHR_SS_ASG_CHG_DATES_V
VIEW - APPS.GHR_SS_POS_CHG_DATES_V
VIEW - APPS.GHR_SS_PRSNL_CHG_DATES_V
VIEW - APPS.GHR_SS_SAL_CHG_DATES_V

Table: GHR_BREAKDOWN_CRITERIA

Description: Holds the criteria used to run the breakdown report.
Primary Key: GHR_BREAKDOWN_CRITERIA_PK
  1. BREAKDOWN_CRITERIA_ID
Primary Key: GHR_BREAKDOWN_CRITERIA_UK
  1. NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_BREAKDOWN_RESULTS.BREAKDOWN_CRITERIA_ID GHR_BREAKDOWN_CRITERIA

[top of page]

HR.GHR_BREAKDOWN_CRITERIA does not reference any database object

HR.GHR_BREAKDOWN_CRITERIA is referenced by following:

HR
VIEW - GHR_BREAKDOWN_CRITERIA#

[top of page]

Table: GHR_BREAKDOWN_RESULTS

Description: GHR_BREAKDOWN_RESULTS is a temporary table used to produce thebreakdown report
Primary Key: GHR_BREAKDOWN_RESULTS_PK
  1. SESSION_ID
  2. BREAKDOWN_RESULT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_BREAKDOWN_RESULTS.BREAKDOWN_CRITERIA_ID GHR_BREAKDOWN_CRITERIA

[top of page]

HR.GHR_BREAKDOWN_RESULTS does not reference any database object

HR.GHR_BREAKDOWN_RESULTS is referenced by following:

HR
VIEW - GHR_BREAKDOWN_RESULTS#

[top of page]

Table: GHR_COMPLAINTS2

Description: GHR_COMPLAINTS2 table is a master table containing complaint details from various persons in the system.
Primary Key: GHR_COMPLAINTS2_PK
  1. COMPLAINT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_COMPL_ADRS.COMPLAINT_ID GHR_COMPLAINTS2
GHR_COMPL_AGENCY_APPEALS.COMPLAINT_ID GHR_COMPLAINTS2
GHR_COMPL_APPEALS.COMPLAINT_ID GHR_COMPLAINTS2
GHR_COMPL_CA_HEADERS.COMPLAINT_ID GHR_COMPLAINTS2
GHR_COMPL_CLAIMS.COMPLAINT_ID GHR_COMPLAINTS2
GHR_COMPL_PEOPLE.COMPLAINT_ID GHR_COMPLAINTS2

[top of page]

HR.GHR_COMPLAINTS2 does not reference any database object

HR.GHR_COMPLAINTS2 is referenced by following:

HR
VIEW - GHR_COMPLAINTS2#

[top of page]

Table: GHR_COMPL_ADRS

Description: Stores Alternate Dispute Resolution details for a given Complaint.
Primary Key: GHR_COMPL_ADRS_PK
  1. COMPL_ADR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_COMPL_ADRS.COMPLAINT_ID GHR_COMPLAINTS2

[top of page]

HR.GHR_COMPL_ADRS does not reference any database object

HR.GHR_COMPL_ADRS is referenced by following:

HR
VIEW - GHR_COMPL_ADRS#

[top of page]

Table: GHR_COMPL_AGENCY_APPEALS

Description: Stores Agency Appeals for a given Complaint.
Primary Key: GHR_COMPL_AGENCY_APPEALS_PK
  1. COMPL_AGENCY_APPEAL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_COMPL_AGENCY_APPEALS.COMPLAINT_ID GHR_COMPLAINTS2

[top of page]

HR.GHR_COMPL_AGENCY_APPEALS does not reference any database object

HR.GHR_COMPL_AGENCY_APPEALS is referenced by following:

HR
VIEW - GHR_COMPL_AGENCY_APPEALS#

[top of page]

Table: GHR_COMPL_AGENCY_COSTS

Description: Stores Compliant Agency Costs Information

[top of page]

HR.GHR_COMPL_AGENCY_COSTS does not reference any database object

HR.GHR_COMPL_AGENCY_COSTS is referenced by following:

HR
VIEW - GHR_COMPL_AGENCY_COSTS#

[top of page]

Table: GHR_COMPL_APPEALS

Description: Stores Complainant Appeals for a given Complaint.
Primary Key: GHR_COMPL_APPEALS_PK
  1. COMPL_APPEAL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_COMPL_APPEALS.COMPLAINT_ID GHR_COMPLAINTS2

[top of page]

HR.GHR_COMPL_APPEALS does not reference any database object

HR.GHR_COMPL_APPEALS is referenced by following:

HR
VIEW - GHR_COMPL_APPEALS#

[top of page]

Table: GHR_COMPL_BASES

Description: Stores Issues and Basis for a given Complaint.
Primary Key: GHR_COMPL_BASES_PK
  1. COMPL_BASIS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_COMPL_BASES.COMPL_CLAIM_ID GHR_COMPL_CLAIMS

[top of page]

HR.GHR_COMPL_BASES does not reference any database object

HR.GHR_COMPL_BASES is referenced by following:

HR
VIEW - GHR_COMPL_BASES#

[top of page]

Table: GHR_COMPL_CA_DETAILS

Description: Stores the Corrective Action Details for a given
Primary Key: GHR_COMPL_CA_DETAILS_PK
  1. COMPL_CA_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_COMPL_CA_DETAILS.COMPL_CA_HEADER_ID GHR_COMPL_CA_HEADERS

[top of page]

HR.GHR_COMPL_CA_DETAILS does not reference any database object

HR.GHR_COMPL_CA_DETAILS is referenced by following:

HR
VIEW - GHR_COMPL_CA_DETAILS#

[top of page]

Table: GHR_COMPL_CA_HEADERS

Description: Stores the Corrective Action Header information for a given Complaint.
Primary Key: GHR_COMPL_CA_HEADERS_PK
  1. COMPL_CA_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_COMPL_CA_HEADERS.COMPLAINT_ID GHR_COMPLAINTS2
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_COMPL_CA_DETAILS.COMPL_CA_HEADER_ID GHR_COMPL_CA_HEADERS

[top of page]

HR.GHR_COMPL_CA_HEADERS does not reference any database object

HR.GHR_COMPL_CA_HEADERS is referenced by following:

HR
VIEW - GHR_COMPL_CA_HEADERS#

[top of page]

Table: GHR_COMPL_CLAIMS

Description: Stores Claim Information for a given Complaint.
Primary Key: GHR_COMPL_CLAIMS_PK
  1. COMPL_CLAIM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_COMPL_CLAIMS.COMPLAINT_ID GHR_COMPLAINTS2
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_COMPL_BASES.COMPL_CLAIM_ID GHR_COMPL_CLAIMS
GHR_COMPL_INCIDENTS.COMPL_CLAIM_ID GHR_COMPL_CLAIMS

[top of page]

HR.GHR_COMPL_CLAIMS does not reference any database object

HR.GHR_COMPL_CLAIMS is referenced by following:

HR
VIEW - GHR_COMPL_CLAIMS#

[top of page]

Table: GHR_COMPL_INCIDENTS

Description: Stores Incident Information for a given Basis.
Primary Key: GHR_COMPL_INCIDENTS_PK
  1. COMPL_INCIDENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_COMPL_INCIDENTS.COMPL_CLAIM_ID GHR_COMPL_CLAIMS

[top of page]

HR.GHR_COMPL_INCIDENTS does not reference any database object

HR.GHR_COMPL_INCIDENTS is referenced by following:

HR
VIEW - GHR_COMPL_INCIDENTS#

[top of page]

Table: GHR_COMPL_PEOPLE

Description: Stores the People associated to a given Complaint.
Primary Key: GHR_COMPL_PEOPLE_PK
  1. COMPL_PERSON_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_COMPL_PEOPLE.COMPLAINT_ID GHR_COMPLAINTS2

[top of page]

HR.GHR_COMPL_PEOPLE does not reference any database object

HR.GHR_COMPL_PEOPLE is referenced by following:

HR
VIEW - GHR_COMPL_PEOPLE#

[top of page]

Table: GHR_CPDF_TEMP

Description: GHR_CPDF_TEMP temporarily stores information required to generatevarious CPDF reports.

[top of page]

HR.GHR_CPDF_TEMP does not reference any database object

HR.GHR_CPDF_TEMP is referenced by following:

HR
VIEW - GHR_CPDF_TEMP#

[top of page]

Table: GHR_DUAL_ACTIONS

Description: Stores First NOAs and all its associated second NOAs that can beprocessed in a dual action.
Primary Key: GHR_DUAL_ACTIONS_PK
  1. FIRST_NOA_ID
  2. SECOND_NOA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_DUAL_ACTIONS.FIRST_NOA_ID GHR_NATURE_OF_ACTIONS
GHR_DUAL_ACTIONS.SECOND_NOA_ID GHR_NATURE_OF_ACTIONS
GHR_DUAL_ACTIONS.NOA_FAMILY_CODE GHR_FAMILIES

[top of page]

HR.GHR_DUAL_ACTIONS does not reference any database object

HR.GHR_DUAL_ACTIONS is referenced by following:

HR
VIEW - GHR_DUAL_ACTIONS#

[top of page]

Table: GHR_DUAL_PROC_METHODS

Description: Stores the process method for the first and the second noa codes.
Primary Key: GHR_DUAL_PROC_METHODS_PK
  1. DUAL_OVERLAP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_DUAL_PROC_METHODS.NOA_FAMILY_CODE GHR_FAMILIES

[top of page]

HR.GHR_DUAL_PROC_METHODS does not reference any database object

HR.GHR_DUAL_PROC_METHODS is referenced by following:

HR
VIEW - GHR_DUAL_PROC_METHODS#

[top of page]

Table: GHR_DUTY_STATIONS_F

Description: This table holds information about duty stations.
Primary Key: GHR_DUTY_STATIONS_F_PK
  1. DUTY_STATION_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Primary Key: GHR_DUTY_STATIONS_F_UK
  1. DUTY_STATION_CODE
  2. EFFECTIVE_END_DATE
  3. EFFECTIVE_START_DATE

[top of page]

HR.GHR_DUTY_STATIONS_F does not reference any database object

HR.GHR_DUTY_STATIONS_F is referenced by following:

HR
VIEW - GHR_DUTY_STATIONS_F#

[top of page]

Table: GHR_EVENTS

Description: This table stores various events.
Primary Key: GHR_EVENTS_PK
  1. EVENT_ID
Primary Key: GHR_EVENTS_UK
  1. CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_EVENTS.GHR_EVENTS_PA_REQUEST_ID GHR_PA_REQUESTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_EVENT_HISTORY.EVENT_ID GHR_EVENTS

[top of page]

HR.GHR_EVENTS does not reference any database object

HR.GHR_EVENTS is referenced by following:

HR
VIEW - GHR_EVENTS#

[top of page]

Table: GHR_EVENT_HISTORY

Description: It stores various events happening during RPA process and definition of Position.
Primary Key: GHR_EVENT_HISTORY_PK
  1. EVENT_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_EVENT_HISTORY.EVENT_ID GHR_EVENTS

[top of page]

HR.GHR_EVENT_HISTORY does not reference any database object

HR.GHR_EVENT_HISTORY is referenced by following:

HR
VIEW - GHR_EVENT_HISTORY#

[top of page]

Table: GHR_FAMILIES

Description: GHR_FAMILIES holds information about a family.
Primary Key: GHR_FAMILIES_PK
  1. NOA_FAMILY_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_DUAL_ACTIONS.NOA_FAMILY_CODE GHR_FAMILIES
GHR_DUAL_PROC_METHODS.NOA_FAMILY_CODE GHR_FAMILIES
GHR_NOA_FAMILIES.NOA_FAMILY_CODE GHR_FAMILIES
GHR_NOA_FAM_PROC_METHODS.NOA_FAMILY_CODE GHR_FAMILIES
GHR_PA_REQUESTS.NOA_FAMILY_CODE GHR_FAMILIES
GHR_PA_REQUEST_INFO_TYPES.NOA_FAMILY_CODE GHR_FAMILIES
GHR_PA_ROUTING_HISTORY.NOA_FAMILY_CODE GHR_FAMILIES

[top of page]

HR.GHR_FAMILIES does not reference any database object

HR.GHR_FAMILIES is referenced by following:

HR
VIEW - GHR_FAMILIES#

[top of page]

Table: GHR_GROUPBOXES

Description: Groupboxes defined to be used by workflow
Primary Key: GHR_GROUPBOXES_PK
  1. GROUPBOX_ID
Primary Key: GHR_GROUPBOXES_UK1
  1. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_GROUPBOXES.ROUTING_GROUP_ID GHR_ROUTING_GROUPS
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_GROUPBOX_USERS.GROUPBOX_ID GHR_GROUPBOXES
GHR_PA_ROUTING_HISTORY.GROUPBOX_ID GHR_GROUPBOXES
GHR_PD_ROUTING_HISTORY.GROUPBOX_ID GHR_GROUPBOXES
GHR_POIS.GROUPBOX_ID GHR_GROUPBOXES
GHR_ROUTING_LIST_MEMBERS.GROUPBOX_ID GHR_GROUPBOXES

[top of page]

HR.GHR_GROUPBOXES does not reference any database object

HR.GHR_GROUPBOXES is referenced by following:

HR
VIEW - GHR_GROUPBOXES#

[top of page]

Table: GHR_GROUPBOX_USERS

Description: Defines the members of the Groupbox
Primary Key: GHR_GROUPBOX_USERS_PK
  1. GROUPBOX_USER_ID
Primary Key: GHR_GROUPBOX_USERS_UK
  1. GROUPBOX_ID
  2. USER_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_GROUPBOX_USERS.GROUPBOX_ID GHR_GROUPBOXES

[top of page]

HR.GHR_GROUPBOX_USERS does not reference any database object

HR.GHR_GROUPBOX_USERS is referenced by following:

HR
VIEW - GHR_GROUPBOX_USERS#

[top of page]

Table: GHR_INTERFACE

Description: This is a genreal purpose table for various interfaces with Federal HRsystem.
Primary Key: GHR_INTERFACE_PK
  1. INTERFACE_ID

[top of page]

HR.GHR_INTERFACE does not reference any database object

HR.GHR_INTERFACE is referenced by following:

HR
VIEW - GHR_INTERFACE#

[top of page]

Table: GHR_LOCALITY_PAY_AREAS_F

Description: This table stores information about locality pay areas.
Primary Key: GHR_LOCALITY_PAY_AREAS_F_PK
  1. LOCALITY_PAY_AREA_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Primary Key: GHR_LOCALITY_PAY_AREAS_F_UK
  1. LOCALITY_PAY_AREA_CODE
  2. EFFECTIVE_END_DATE
  3. EFFECTIVE_START_DATE

[top of page]

HR.GHR_LOCALITY_PAY_AREAS_F does not reference any database object

HR.GHR_LOCALITY_PAY_AREAS_F is referenced by following:

HR
VIEW - GHR_LOCALITY_PAY_AREAS_F#

[top of page]

Table: GHR_MASS_ACTIONS_PREVIEW

Description: This table is used to show the Employee/Position detail to the user based on the selection criteria
Primary Key: GHR_MASS_ACTIONS_PREVIEW_PK
  1. MASS_ACTION_PREVIEW_ID

[top of page]

HR.GHR_MASS_ACTIONS_PREVIEW does not reference any database object

HR.GHR_MASS_ACTIONS_PREVIEW is referenced by following:

HR
VIEW - GHR_MASS_ACTIONS_PREVIEW#

[top of page]

Table: GHR_MASS_AWARDS

Description: Used to store the details of the Mass Award
Primary Key: GHR_MASS_AWARDS_PK
  1. MASS_AWARD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_MASS_AWARDS.NATURE_OF_ACTION_ID GHR_NATURE_OF_ACTIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_MASS_AWARD_CRITERIA_VALS.MASS_AWARD_ID GHR_MASS_AWARDS

[top of page]

HR.GHR_MASS_AWARDS does not reference any database object

HR.GHR_MASS_AWARDS is referenced by following:

HR
VIEW - GHR_MASS_AWARDS#

[top of page]

Table: GHR_MASS_AWARD_CRITERIA_COLS

Description: Used to store the Selection Criteria items used in Mass Awards
Primary Key: GHR_MASS_AWARD_CRITERIA_CO_PK
  1. MASS_AWARD_CRITERIA_COL_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_MASS_AWARD_CRITERIA_VALS.MASS_AWARD_CRITERIA_COL_ID GHR_MASS_AWARD_CRITERIA_COLS

[top of page]

HR.GHR_MASS_AWARD_CRITERIA_COLS does not reference any database object

HR.GHR_MASS_AWARD_CRITERIA_COLS is referenced by following:

HR
VIEW - GHR_MASS_AWARD_CRITERIA_COLS#

[top of page]

Table: GHR_MASS_AWARD_CRITERIA_VALS

Description: Used to store the values for the selection criteria in the Mass Awards
Primary Key: GHR_MASS_AWARD_CRITERIA_VA_PK
  1. MASS_AWARD_CRITERIA_VAL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_MASS_AWARD_CRITERIA_VALS.MASS_AWARD_ID GHR_MASS_AWARDS
GHR_MASS_AWARD_CRITERIA_VALS.MASS_AWARD_CRITERIA_COL_ID GHR_MASS_AWARD_CRITERIA_COLS

[top of page]

HR.GHR_MASS_AWARD_CRITERIA_VALS does not reference any database object

HR.GHR_MASS_AWARD_CRITERIA_VALS is referenced by following:

HR
VIEW - GHR_MASS_AWARD_CRITERIA_VALS#

[top of page]

Table: GHR_MASS_REALIGNMENT

Description: This table is used to store criteria for mass realignment.
Primary Key: GHR_MASS_REALIGNMENT_PK
  1. MASS_REALIGNMENT_ID
Primary Key: GHR_MASS_REALIGNMENT_UK
  1. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_MASS_REALIGNMENT.OLD_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
GHR_MASS_REALIGNMENT.NEW_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
GHR_MASS_REALIGNMENT.OLD_ORG_STRUCTURE_VERSION_ID PER_ORG_STRUCTURE_VERSIONS
GHR_MASS_REALIGNMENT.OLD_POS_STRUCTURE_VERSION_ID PER_POS_STRUCTURE_VERSIONS
GHR_MASS_REALIGNMENT.TARGET_PERSONNEL_OFFICE_ID GHR_POIS
GHR_MASS_REALIGNMENT.PERSONNEL_OFFICE_ID GHR_POIS
GHR_MASS_REALIGNMENT.TARGET_POSITION_ORG_ID HR_ALL_ORGANIZATION_UNITS
GHR_MASS_REALIGNMENT.PA_REQUEST_ID GHR_PA_REQUESTS

[top of page]

HR.GHR_MASS_REALIGNMENT does not reference any database object

HR.GHR_MASS_REALIGNMENT is referenced by following:

HR
VIEW - GHR_MASS_REALIGNMENT#

[top of page]

Table: GHR_MASS_SALARIES

Description: This table stores the criteria and status for mass salary action.
Primary Key: GHR_MASS_SALARIES_PK
  1. MASS_SALARY_ID
Primary Key: GHR_MASS_SALARIES_UK
  1. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_MASS_SALARIES.PA_REQUEST_ID GHR_PA_REQUESTS
GHR_MASS_SALARIES.ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
GHR_MASS_SALARIES.PERSONNEL_OFFICE_ID GHR_POIS
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_MASS_SALARY_CRITERIA.MASS_SALARY_ID GHR_MASS_SALARIES

[top of page]

HR.GHR_MASS_SALARIES does not reference any database object

HR.GHR_MASS_SALARIES is referenced by following:

HR
VIEW - GHR_MASS_SALARIES#

[top of page]

Table: GHR_MASS_SALARY_CRITERIA

Description: Thsi table stores the additional criteria for a mass salary action.
Primary Key: GHR_MASS_SALARY_CRITERIA_PK
  1. MASS_SALARY_CRITERIA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_MASS_SALARY_CRITERIA.MASS_SALARY_ID GHR_MASS_SALARIES
GHR_MASS_SALARY_CRITERIA.PAY_PLAN GHR_PAY_PLANS

[top of page]

HR.GHR_MASS_SALARY_CRITERIA does not reference any database object

HR.GHR_MASS_SALARY_CRITERIA is referenced by following:

HR
VIEW - GHR_MASS_SALARY_CRITERIA#

[top of page]

Table: GHR_MASS_SALARY_CRITERIA_EXT

Description:

[top of page]

HR.GHR_MASS_SALARY_CRITERIA_EXT does not reference any database object

HR.GHR_MASS_SALARY_CRITERIA_EXT is referenced by following:

HR
VIEW - GHR_MASS_SALARY_CRITERIA_EXT#

[top of page]

Table: GHR_MASS_TRANSFERS

Description: This table stores the additional criteria for a mass transfer action.
Primary Key: GHR_MASS_TRANSFERS_PK
  1. MASS_TRANSFER_ID
Primary Key: GHR_MASS_TRANSFERS_UK
  1. NAME
  2. TRANSFER_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_MASS_TRANSFERS.OLD_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
GHR_MASS_TRANSFERS.OLD_ORG_STRUCTURE_VERSION_ID PER_ORG_STRUCTURE_VERSIONS
GHR_MASS_TRANSFERS.OLD_POS_STRUCTURE_VERSION_ID PER_POS_STRUCTURE_VERSIONS
GHR_MASS_TRANSFERS.PERSONNEL_OFFICE_ID GHR_POIS
GHR_MASS_TRANSFERS.PA_REQUEST_ID GHR_PA_REQUESTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_MASS_TRANSFER_CRITERIA.MASS_TRANSFER_ID GHR_MASS_TRANSFERS

[top of page]

HR.GHR_MASS_TRANSFERS does not reference any database object

HR.GHR_MASS_TRANSFERS is referenced by following:

HR
VIEW - GHR_MASS_TRANSFERS#

[top of page]

Table: GHR_MASS_TRANSFER_CRITERIA

Description: This table stores the additional criteria for a mass transfer action.
Primary Key: GHR_MASS_TRANSFER_CRITERIA_PK
  1. MASS_TRANSFER_CRITERIA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_MASS_TRANSFER_CRITERIA.MASS_TRANSFER_ID GHR_MASS_TRANSFERS

[top of page]

HR.GHR_MASS_TRANSFER_CRITERIA does not reference any database object

HR.GHR_MASS_TRANSFER_CRITERIA is referenced by following:

HR
VIEW - GHR_MASS_TRANSFER_CRITERIA#

[top of page]

Table: GHR_MTS_TEMP

Description: Table Used for MTS

[top of page]

HR.GHR_MTS_TEMP does not reference any database object

HR.GHR_MTS_TEMP is referenced by following:

HR
VIEW - GHR_MTS_TEMP#

[top of page]

Table: GHR_NATURE_OF_ACTIONS

Description: This table holds a list of nature of action codes.
Primary Key: GHR_NATURE_OF_ACTIONS_PK
  1. NATURE_OF_ACTION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_DUAL_ACTIONS.FIRST_NOA_ID GHR_NATURE_OF_ACTIONS
GHR_DUAL_ACTIONS.SECOND_NOA_ID GHR_NATURE_OF_ACTIONS
GHR_MASS_AWARDS.NATURE_OF_ACTION_ID GHR_NATURE_OF_ACTIONS
GHR_NOAC_LAS.NATURE_OF_ACTION_ID GHR_NATURE_OF_ACTIONS
GHR_NOAC_REMARKS.NATURE_OF_ACTION_ID GHR_NATURE_OF_ACTIONS
GHR_NOA_FAMILIES.NATURE_OF_ACTION_ID GHR_NATURE_OF_ACTIONS
GHR_PA_HISTORY.NATURE_OF_ACTION_ID GHR_NATURE_OF_ACTIONS
GHR_PA_REQUESTS.FIRST_NOA_ID GHR_NATURE_OF_ACTIONS
GHR_PA_REQUESTS.SECOND_NOA_ID GHR_NATURE_OF_ACTIONS
GHR_PA_ROUTING_HISTORY.NATURE_OF_ACTION_ID GHR_NATURE_OF_ACTIONS
GHR_PA_ROUTING_HISTORY.SECOND_NATURE_OF_ACTION_ID GHR_NATURE_OF_ACTIONS

[top of page]

HR.GHR_NATURE_OF_ACTIONS does not reference any database object

HR.GHR_NATURE_OF_ACTIONS is referenced by following:

HR
VIEW - GHR_NATURE_OF_ACTIONS#

[top of page]

Table: GHR_NOAC_LAS

Description: Stores NOA and the associated Legal Authorities
Primary Key: GHR_NOAC_LAS_PK
  1. NOAC_LA_ID
Primary Key: GHR_NOAC_LAS_UK
  1. LAC_LOOKUP_CODE
  2. NATURE_OF_ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_NOAC_LAS.NATURE_OF_ACTION_ID GHR_NATURE_OF_ACTIONS

[top of page]

HR.GHR_NOAC_LAS does not reference any database object

HR.GHR_NOAC_LAS is referenced by following:

HR
VIEW - GHR_NOAC_LAS#

[top of page]

Table: GHR_NOAC_REMARKS

Description: Stores NOA and the associated Remarks
Primary Key: GHR_NOAC_REMARKS_PK
  1. NOAC_REMARK_ID
Primary Key: GHR_NOAC_REMARKS_UK
  1. REMARK_ID
  2. NATURE_OF_ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_NOAC_REMARKS.NATURE_OF_ACTION_ID GHR_NATURE_OF_ACTIONS
GHR_NOAC_REMARKS.REMARK_ID GHR_REMARKS

[top of page]

HR.GHR_NOAC_REMARKS does not reference any database object

HR.GHR_NOAC_REMARKS is referenced by following:

HR
VIEW - GHR_NOAC_REMARKS#

[top of page]

Table: GHR_NOA_FAMILIES

Description: Stores Families and associated NOAs
Primary Key: GHR_NOA_FAMILIES_PK
  1. NOA_FAMILY_CODE
  2. NATURE_OF_ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_NOA_FAMILIES.NOA_FAMILY_CODE GHR_FAMILIES
GHR_NOA_FAMILIES.NATURE_OF_ACTION_ID GHR_NATURE_OF_ACTIONS

[top of page]

HR.GHR_NOA_FAMILIES does not reference any database object

HR.GHR_NOA_FAMILIES is referenced by following:

HR
VIEW - GHR_NOA_FAMILIES#

[top of page]

Table: GHR_NOA_FAM_PROC_METHODS

Description: This table is intersection between families and personnel actions.
Primary Key: GHR_NOA_FAM_PROC_METHODS_PK
  1. NOA_FAMILY_CODE
  2. PA_DATA_FIELD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_NOA_FAM_PROC_METHODS.PA_DATA_FIELD_ID GHR_PA_DATA_FIELDS
GHR_NOA_FAM_PROC_METHODS.NOA_FAMILY_CODE GHR_FAMILIES

[top of page]

HR.GHR_NOA_FAM_PROC_METHODS does not reference any database object

HR.GHR_NOA_FAM_PROC_METHODS is referenced by following:

HR
VIEW - GHR_NOA_FAM_PROC_METHODS#

[top of page]

Table: GHR_PAYROLL

Description: This table is used by payroll interface to get data for SF113A report.
Primary Key: GHR_PAYROLL_PK
  1. PAYROLL_ID

[top of page]

HR.GHR_PAYROLL does not reference any database object

HR.GHR_PAYROLL is referenced by following:

HR
VIEW - GHR_PAYROLL#

[top of page]

Table: GHR_PAY_PLANS

Description: Defines the Pay Plans
Primary Key: GHR_PAY_PLANS_PK
  1. PAY_PLAN
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_PAY_PLANS.EQUIVALENT_PAY_PLAN GHR_PAY_PLANS
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_MASS_SALARY_CRITERIA.PAY_PLAN GHR_PAY_PLANS
GHR_PAY_PLANS.EQUIVALENT_PAY_PLAN GHR_PAY_PLANS
GHR_PAY_PLAN_WAITING_PERIODS.PAY_PLAN GHR_PAY_PLANS
GHR_PA_REQUESTS.FROM_PAY_PLAN GHR_PAY_PLANS
GHR_PA_REQUESTS.TO_PAY_PLAN GHR_PAY_PLANS
GHR_PD_CLASSIFICATIONS.PAY_PLAN GHR_PAY_PLANS

[top of page]

HR.GHR_PAY_PLANS does not reference any database object

HR.GHR_PAY_PLANS is referenced by following:

HR
VIEW - GHR_PAY_PLANS#

[top of page]

Table: GHR_PAY_PLAN_WAITING_PERIODS

Description: Defines the waiting period of the Pay Plans
Primary Key: GHR_PAY_PLAN_WAITING_PERIOD_PK
  1. PAY_PLAN
  2. FROM_STEP
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_PAY_PLAN_WAITING_PERIODS.PAY_PLAN GHR_PAY_PLANS

[top of page]

HR.GHR_PAY_PLAN_WAITING_PERIODS does not reference any database object

HR.GHR_PAY_PLAN_WAITING_PERIODS is referenced by following:

HR
VIEW - GHR_PAY_PLAN_WAITING_PERIODS#

[top of page]

Table: GHR_PA_DATA_FIELDS

Description: This table holds the fields that are available on the request for personnel action form and the extra information.
Primary Key: GHR_PA_DATA_FIELDS_PK
  1. PA_DATA_FIELD_ID
Primary Key: GHR_PA_DATA_FIELDS_UK1
  1. NAME
Primary Key: GHR_PA_DATA_FIELDS_UK2
  1. FORM_BLOCK_NAME
  2. FORM_FIELD_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_NOA_FAM_PROC_METHODS.PA_DATA_FIELD_ID GHR_PA_DATA_FIELDS
GHR_RESTRICTED_PROC_METHODS.PA_DATA_FIELD_ID GHR_PA_DATA_FIELDS

[top of page]

HR.GHR_PA_DATA_FIELDS does not reference any database object

HR.GHR_PA_DATA_FIELDS is referenced by following:

HR
VIEW - GHR_PA_DATA_FIELDS#

[top of page]

Table: GHR_PA_HISTORY

Description: Stores the history of all the transations performed on certain tables.
Primary Key: GHR_PA_HISTORY_PK
  1. PA_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_PA_HISTORY.NATURE_OF_ACTION_ID GHR_NATURE_OF_ACTIONS
GHR_PA_HISTORY.PA_REQUEST_ID GHR_PA_REQUESTS
GHR_PA_HISTORY.ALTERED_PA_REQUEST_ID GHR_PA_REQUESTS

[top of page]

HR.GHR_PA_HISTORY does not reference any database object

HR.GHR_PA_HISTORY is referenced by following:

HR
VIEW - GHR_PA_HISTORY#

[top of page]

Table: GHR_PA_INTERFACE_ERR_DTLS

Description:

[top of page]

HR.GHR_PA_INTERFACE_ERR_DTLS does not reference any database object

HR.GHR_PA_INTERFACE_ERR_DTLS is referenced by following:

HR
VIEW - GHR_PA_INTERFACE_ERR_DTLS#

[top of page]

Table: GHR_PA_REMARKS

Description: Stores Remark codes for the Personnel Action
Primary Key: GHR_PA_REMARKS_PK
  1. PA_REMARK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_PA_REMARKS.PA_REQUEST_ID GHR_PA_REQUESTS
GHR_PA_REMARKS.REMARK_ID GHR_REMARKS

[top of page]

HR.GHR_PA_REMARKS does not reference any database object

HR.GHR_PA_REMARKS is referenced by following:

HR
VIEW - GHR_PA_REMARKS#

[top of page]

Table: GHR_PA_REQUESTS

Description: Stores all the information about the Request to Personnel Action.
Primary Key: GHR_PA_REQUESTS_PK
  1. PA_REQUEST_ID
Primary Key: GHR_PA_REQUESTS_UK1
  1. PA_NOTIFICATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_PA_REQUESTS.NOA_FAMILY_CODE GHR_FAMILIES
GHR_PA_REQUESTS.ROUTING_GROUP_ID GHR_ROUTING_GROUPS
GHR_PA_REQUESTS.FIRST_NOA_PA_REQUEST_ID GHR_PA_REQUESTS
GHR_PA_REQUESTS.SECOND_NOA_PA_REQUEST_ID GHR_PA_REQUESTS
GHR_PA_REQUESTS.ALTERED_PA_REQUEST_ID GHR_PA_REQUESTS
GHR_PA_REQUESTS.FROM_PAY_PLAN GHR_PAY_PLANS
GHR_PA_REQUESTS.FIRST_NOA_ID GHR_NATURE_OF_ACTIONS
GHR_PA_REQUESTS.SECOND_NOA_ID GHR_NATURE_OF_ACTIONS
GHR_PA_REQUESTS.TO_PAY_PLAN GHR_PAY_PLANS
GHR_PA_REQUESTS.TO_JOB_ID PER_JOBS
GHR_PA_REQUESTS.TO_GRADE_ID PER_GRADES
GHR_PA_REQUESTS.TO_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
GHR_PA_REQUESTS.PERSONNEL_OFFICE_ID GHR_POIS
GHR_PA_REQUESTS.GHR_PA_REQUESTS_PA_REQUEST_ID GHR_PA_REQUEST_SHADOW
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_EVENTS.GHR_EVENTS_PA_REQUEST_ID GHR_PA_REQUESTS
GHR_MASS_REALIGNMENT.PA_REQUEST_ID GHR_PA_REQUESTS
GHR_MASS_SALARIES.PA_REQUEST_ID GHR_PA_REQUESTS
GHR_MASS_TRANSFERS.PA_REQUEST_ID GHR_PA_REQUESTS
GHR_PA_HISTORY.PA_REQUEST_ID GHR_PA_REQUESTS
GHR_PA_HISTORY.ALTERED_PA_REQUEST_ID GHR_PA_REQUESTS
GHR_PA_REMARKS.PA_REQUEST_ID GHR_PA_REQUESTS
GHR_PA_REQUESTS.FIRST_NOA_PA_REQUEST_ID GHR_PA_REQUESTS
GHR_PA_REQUESTS.SECOND_NOA_PA_REQUEST_ID GHR_PA_REQUESTS
GHR_PA_REQUESTS.ALTERED_PA_REQUEST_ID GHR_PA_REQUESTS
GHR_PA_REQUEST_EI_SHADOW.PA_REQUEST_ID GHR_PA_REQUESTS
GHR_PA_REQUEST_EXTRA_INFO.PA_REQUEST_ID GHR_PA_REQUESTS
GHR_PA_ROUTING_HISTORY.PA_REQUEST_ID GHR_PA_REQUESTS

[top of page]

HR.GHR_PA_REQUESTS does not reference any database object

HR.GHR_PA_REQUESTS is referenced by following:

HR
VIEW - GHR_PA_REQUESTS#

[top of page]

Table: GHR_PA_REQUEST_EI_SHADOW

Description: Stores all the columns of the corresponding record ofGHR_PA_REQUEST_EXTRA_INFO.
Primary Key: GHR_PA_REQUEST_EI_SHADOW_PK
  1. PA_REQUEST_EXTRA_INFO_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_PA_REQUEST_EI_SHADOW.PA_REQUEST_ID GHR_PA_REQUESTS
GHR_PA_REQUEST_EI_SHADOW.INFORMATION_TYPE GHR_PA_REQUEST_INFO_TYPES

[top of page]

HR.GHR_PA_REQUEST_EI_SHADOW does not reference any database object

HR.GHR_PA_REQUEST_EI_SHADOW is referenced by following:

HR
VIEW - GHR_PA_REQUEST_EI_SHADOW#

[top of page]

Table: GHR_PA_REQUEST_EXTRA_INFO

Description: Stores additional information based on information types.
Primary Key: GHR_PA_REQUEST_EXTRA_INFO_PK
  1. PA_REQUEST_EXTRA_INFO_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_PA_REQUEST_EXTRA_INFO.PA_REQUEST_ID GHR_PA_REQUESTS
GHR_PA_REQUEST_EXTRA_INFO.INFORMATION_TYPE GHR_PA_REQUEST_INFO_TYPES

[top of page]

HR.GHR_PA_REQUEST_EXTRA_INFO does not reference any database object

HR.GHR_PA_REQUEST_EXTRA_INFO is referenced by following:

HR
VIEW - GHR_PA_REQUEST_EXTRA_INFO#

[top of page]

Table: GHR_PA_REQUEST_INFO_TYPES

Description: Defines information types to be used in Extra Information.
Primary Key: GHR_PA_REQUEST_INFO_TYPES_PK
  1. INFORMATION_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_PA_REQUEST_INFO_TYPES.NOA_FAMILY_CODE GHR_FAMILIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_PA_REQUEST_EI_SHADOW.INFORMATION_TYPE GHR_PA_REQUEST_INFO_TYPES
GHR_PA_REQUEST_EXTRA_INFO.INFORMATION_TYPE GHR_PA_REQUEST_INFO_TYPES

[top of page]

HR.GHR_PA_REQUEST_INFO_TYPES does not reference any database object

HR.GHR_PA_REQUEST_INFO_TYPES is referenced by following:

HR
VIEW - GHR_PA_REQUEST_INFO_TYPES#

[top of page]

Table: GHR_PA_REQUEST_SHADOW

Description: Stores all the columns of the corresponding record of GHR_PA_REQUESTS.
Primary Key: GHR_PA_REQUEST_SHADOW_PK
  1. PA_REQUEST_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_PA_REQUESTS.GHR_PA_REQUESTS_PA_REQUEST_ID GHR_PA_REQUEST_SHADOW

[top of page]

HR.GHR_PA_REQUEST_SHADOW does not reference any database object

HR.GHR_PA_REQUEST_SHADOW is referenced by following:

HR
VIEW - GHR_PA_REQUEST_SHADOW#

[top of page]

Table: GHR_PA_ROUTING_HISTORY

Description: Routing History details of the PA Request
Primary Key: GHR_PA_ROUTING_HISTORY_PK
  1. PA_ROUTING_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_PA_ROUTING_HISTORY.PA_REQUEST_ID GHR_PA_REQUESTS
GHR_PA_ROUTING_HISTORY.ROUTING_LIST_ID GHR_ROUTING_LISTS
GHR_PA_ROUTING_HISTORY.GROUPBOX_ID GHR_GROUPBOXES
GHR_PA_ROUTING_HISTORY.NATURE_OF_ACTION_ID GHR_NATURE_OF_ACTIONS
GHR_PA_ROUTING_HISTORY.SECOND_NATURE_OF_ACTION_ID GHR_NATURE_OF_ACTIONS
GHR_PA_ROUTING_HISTORY.NOA_FAMILY_CODE GHR_FAMILIES

[top of page]

HR.GHR_PA_ROUTING_HISTORY does not reference any database object

HR.GHR_PA_ROUTING_HISTORY is referenced by following:

HR
VIEW - GHR_PA_ROUTING_HISTORY#

[top of page]

Table: GHR_PD_CLASSIFICATIONS

Description: Classification details of a Position Description.
Primary Key: GHR_PD_CLASSIFICATIONS_PK
  1. PD_CLASSIFICATION_ID
Primary Key: GHR_PD_CLASSIFICATIONS_UK
  1. POSITION_DESCRIPTION_ID
  2. CLASS_GRADE_BY
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_PD_CLASSIFICATIONS.POSITION_DESCRIPTION_ID GHR_POSITION_DESCRIPTIONS
GHR_PD_CLASSIFICATIONS.PAY_PLAN GHR_PAY_PLANS

[top of page]

HR.GHR_PD_CLASSIFICATIONS does not reference any database object

HR.GHR_PD_CLASSIFICATIONS is referenced by following:

HR
VIEW - GHR_PD_CLASSIFICATIONS#

[top of page]

Table: GHR_PD_ROUTING_HISTORY

Description: Routing History details of Position Description
Primary Key: GHR_PD_ROUTING_HISTORY_PK
  1. PD_ROUTING_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_PD_ROUTING_HISTORY.POSITION_DESCRIPTION_ID GHR_POSITION_DESCRIPTIONS
GHR_PD_ROUTING_HISTORY.ROUTING_LIST_ID GHR_ROUTING_LISTS
GHR_PD_ROUTING_HISTORY.GROUPBOX_ID GHR_GROUPBOXES

[top of page]

HR.GHR_PD_ROUTING_HISTORY does not reference any database object

HR.GHR_PD_ROUTING_HISTORY is referenced by following:

HR
VIEW - GHR_PD_ROUTING_HISTORY#

[top of page]

Table: GHR_PERF_CERT

Description: Performance Certification table

[top of page]

HR.GHR_PERF_CERT does not reference any database object

HR.GHR_PERF_CERT is referenced by following:

HR
VIEW - GHR_PERF_CERT#

[top of page]

Table: GHR_PLAN_SERVICE_AREAS_F

Description: Stores information about the health plan availability in the particular state or duty station.
Primary Key: GHR_PLAN_SERVICE_AREAS_F_PK
  1. PLAN_SERVICE_AREA_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE

[top of page]

HR.GHR_PLAN_SERVICE_AREAS_F does not reference any database object

HR.GHR_PLAN_SERVICE_AREAS_F is referenced by following:

HR
VIEW - GHR_PLAN_SERVICE_AREAS_F#

[top of page]

Table: GHR_POIS

Description: Contains information related to Personnel Office Identifier
Primary Key: GHR_POIS_PK
  1. PERSONNEL_OFFICE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_POIS.GROUPBOX_ID GHR_GROUPBOXES
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_MASS_REALIGNMENT.TARGET_PERSONNEL_OFFICE_ID GHR_POIS
GHR_MASS_REALIGNMENT.PERSONNEL_OFFICE_ID GHR_POIS
GHR_MASS_SALARIES.PERSONNEL_OFFICE_ID GHR_POIS
GHR_MASS_TRANSFERS.PERSONNEL_OFFICE_ID GHR_POIS
GHR_PA_REQUESTS.PERSONNEL_OFFICE_ID GHR_POIS

[top of page]

HR.GHR_POIS does not reference any database object

HR.GHR_POIS is referenced by following:

HR
VIEW - GHR_POIS#

[top of page]

Table: GHR_POSITION_DESCRIPTIONS

Description: Federal Position Description details
Primary Key: GHR_POSITION_DESCRIPTIONS_PK
  1. POSITION_DESCRIPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_POSITION_DESCRIPTIONS.ROUTING_GROUP_ID GHR_ROUTING_GROUPS
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_PD_CLASSIFICATIONS.POSITION_DESCRIPTION_ID GHR_POSITION_DESCRIPTIONS
GHR_PD_ROUTING_HISTORY.POSITION_DESCRIPTION_ID GHR_POSITION_DESCRIPTIONS

[top of page]

HR.GHR_POSITION_DESCRIPTIONS does not reference any database object

HR.GHR_POSITION_DESCRIPTIONS is referenced by following:

HR
VIEW - GHR_POSITION_DESCRIPTIONS#

[top of page]

Table: GHR_POS_INTERFACE_ERR_DTLS

Description:

[top of page]

HR.GHR_POS_INTERFACE_ERR_DTLS does not reference any database object

HR.GHR_POS_INTERFACE_ERR_DTLS is referenced by following:

HR
VIEW - GHR_POS_INTERFACE_ERR_DTLS#

[top of page]

Table: GHR_PREMIUM_PAY_INDICATORS

Description: It holds a list of premium pay indicators.
Primary Key: GHR_PREMIUM_PAY_INDICATORS_PK
  1. CODE

[top of page]

HR.GHR_PREMIUM_PAY_INDICATORS does not reference any database object

HR.GHR_PREMIUM_PAY_INDICATORS is referenced by following:

HR
VIEW - GHR_PREMIUM_PAY_INDICATORS#

[top of page]

Table: GHR_PROCESS_LOG

Description: It contains log information about various batch process.
Primary Key: GHR_PROCESS_LOG_PK
  1. PROCESS_LOG_ID

[top of page]

HR.GHR_PROCESS_LOG does not reference any database object

HR.GHR_PROCESS_LOG is referenced by following:

HR
VIEW - GHR_PROCESS_LOG#

[top of page]

Table: GHR_REMARKS

Description: It holds a list of remarks that are used to enter against arequest for personnel action.
Primary Key: GHR_REMARKS_PK
  1. REMARK_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_NOAC_REMARKS.REMARK_ID GHR_REMARKS
GHR_PA_REMARKS.REMARK_ID GHR_REMARKS

[top of page]

HR.GHR_REMARKS does not reference any database object

HR.GHR_REMARKS is referenced by following:

HR
VIEW - GHR_REMARKS#

[top of page]

Table: GHR_RESTRICTED_PROC_METHODS

Description: It is intersection between a restricted form and personel actiondata fields
Primary Key: GHR_RESTRICTED_PROC_METHODS_PK
  1. PA_DATA_FIELD_ID
  2. RESTRICTED_FORM
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_RESTRICTED_PROC_METHODS.PA_DATA_FIELD_ID GHR_PA_DATA_FIELDS

[top of page]

HR.GHR_RESTRICTED_PROC_METHODS does not reference any database object

HR.GHR_RESTRICTED_PROC_METHODS is referenced by following:

HR
VIEW - GHR_RESTRICTED_PROC_METHODS#

[top of page]

Table: GHR_RIF_CRITERIA

Description: It holds the criteria used to retrieve people to producea reduction in force (RIF) register.
Primary Key: GHR_RIF_CRITERIA_PK
  1. RIF_CRITERIA_ID
Primary Key: GHR_RIF_CRITERIA_UK
  1. NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_RIF_REGISTERS.RIF_CRITERIA_ID GHR_RIF_CRITERIA

[top of page]

HR.GHR_RIF_CRITERIA does not reference any database object

HR.GHR_RIF_CRITERIA is referenced by following:

HR
VIEW - GHR_RIF_CRITERIA#

[top of page]

Table: GHR_RIF_REGISTERS

Description: It is a temporary table used to list the people whomatch the criteria.
Primary Key: GHR_RIF_REGISTERS_PK
  1. RIF_REGISTER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_RIF_REGISTERS.RIF_CRITERIA_ID GHR_RIF_CRITERIA

[top of page]

HR.GHR_RIF_REGISTERS does not reference any database object

HR.GHR_RIF_REGISTERS is referenced by following:

HR
VIEW - GHR_RIF_REGISTERS#

[top of page]

Table: GHR_ROUTING_GROUPS

Description: Routing Group information
Primary Key: GHR_ROUTING_GROUPS_PK
  1. ROUTING_GROUP_ID
Primary Key: GHR_ROUTING_GROUPS_UK
  1. NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_GROUPBOXES.ROUTING_GROUP_ID GHR_ROUTING_GROUPS
GHR_PA_REQUESTS.ROUTING_GROUP_ID GHR_ROUTING_GROUPS
GHR_POSITION_DESCRIPTIONS.ROUTING_GROUP_ID GHR_ROUTING_GROUPS
GHR_ROUTING_LISTS.ROUTING_GROUP_ID GHR_ROUTING_GROUPS

[top of page]

HR.GHR_ROUTING_GROUPS does not reference any database object

HR.GHR_ROUTING_GROUPS is referenced by following:

HR
VIEW - GHR_ROUTING_GROUPS#

[top of page]

Table: GHR_ROUTING_LISTS

Description: Routing List details
Primary Key: GHR_ROUTING_LISTS_PK
  1. ROUTING_LIST_ID
Primary Key: GHR_ROUTING_LISTS_UK1
  1. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_ROUTING_LISTS.ROUTING_GROUP_ID GHR_ROUTING_GROUPS
Foreign Keys to this table:
Foreign Key Column Foreign Table
GHR_PA_ROUTING_HISTORY.ROUTING_LIST_ID GHR_ROUTING_LISTS
GHR_PD_ROUTING_HISTORY.ROUTING_LIST_ID GHR_ROUTING_LISTS
GHR_ROUTING_LIST_MEMBERS.ROUTING_LIST_ID GHR_ROUTING_LISTS

[top of page]

HR.GHR_ROUTING_LISTS does not reference any database object

HR.GHR_ROUTING_LISTS is referenced by following:

HR
VIEW - GHR_ROUTING_LISTS#

[top of page]

Table: GHR_ROUTING_LIST_MEMBERS

Description: Routing List members detail
Primary Key: GHR_ROUTING_LIST_MEMBERS_PK
  1. ROUTING_LIST_MEMBER_ID
Primary Key: GHR_ROUTING_LIST_MEMBERS_UK
  1. ROUTING_LIST_ID
  2. SEQ_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
GHR_ROUTING_LIST_MEMBERS.ROUTING_LIST_ID GHR_ROUTING_LISTS
GHR_ROUTING_LIST_MEMBERS.GROUPBOX_ID GHR_GROUPBOXES

[top of page]

HR.GHR_ROUTING_LIST_MEMBERS does not reference any database object

HR.GHR_ROUTING_LIST_MEMBERS is referenced by following:

HR
VIEW - GHR_ROUTING_LIST_MEMBERS#

[top of page]

View: GHR_ADDRESSES_H_V

[top of page]

APPS.GHR_ADDRESSES_H_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - GHR_GENERAL
SYNONYM - GHR_PA_HISTORY

APPS.GHR_ADDRESSES_H_V is not referenced by any database object

[top of page]

View: GHR_ASSIGNMENTS_H_V

[top of page]

APPS.GHR_ASSIGNMENTS_H_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - GHR_GENERAL
SYNONYM - GHR_PA_HISTORY

APPS.GHR_ASSIGNMENTS_H_V is not referenced by any database object

[top of page]

View: GHR_ASSIGNMENT_EXTRA_INFO_H_V

[top of page]

APPS.GHR_ASSIGNMENT_EXTRA_INFO_H_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - GHR_GENERAL
SYNONYM - GHR_PA_HISTORY

APPS.GHR_ASSIGNMENT_EXTRA_INFO_H_V is not referenced by any database object

[top of page]

View: GHR_BREAKDOWN_V

[top of page]

APPS.GHR_BREAKDOWN_V references the following:

APPS
SYNONYM - GHR_BREAKDOWN_RESULTS
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.GHR_BREAKDOWN_V is not referenced by any database object

[top of page]

View: GHR_CLAIM_SOURCE_V

[top of page]

APPS.GHR_CLAIM_SOURCE_V references the following:

APPS
SYNONYM - GHR_COMPLAINTS2
SYNONYM - GHR_COMPL_APPEALS

APPS.GHR_CLAIM_SOURCE_V is not referenced by any database object

[top of page]

View: GHR_DUTY_STATIONS_D

[top of page]

APPS.GHR_DUTY_STATIONS_D references the following:

APPS
SYNONYM - FND_USER
SYNONYM - GHR_DUTY_STATIONS_F

APPS.GHR_DUTY_STATIONS_D is not referenced by any database object

[top of page]

View: GHR_DUTY_STATIONS_V

[top of page]

APPS.GHR_DUTY_STATIONS_V references the following:

APPS
SYNONYM - GHR_DUTY_STATIONS_F

APPS.GHR_DUTY_STATIONS_V is not referenced by any database object

[top of page]

View: GHR_ELEMENT_ENTRIES_H_V

[top of page]

APPS.GHR_ELEMENT_ENTRIES_H_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - GHR_GENERAL
SYNONYM - GHR_PA_HISTORY

APPS.GHR_ELEMENT_ENTRIES_H_V is not referenced by any database object

[top of page]

View: GHR_ELEMENT_ENTRIES_V

[top of page]

APPS.GHR_ELEMENT_ENTRIES_V references the following:

APPS
SYNONYM - FND_SESSIONS
SYNONYM - PAY_ELEMENT_ENTRIES_F
SYNONYM - PAY_ELEMENT_LINKS_F
SYNONYM - PAY_ELEMENT_TYPES_F

APPS.GHR_ELEMENT_ENTRIES_V is not referenced by any database object

[top of page]

View: GHR_ELEMENT_ENTRY_VALUES_H_V

[top of page]

APPS.GHR_ELEMENT_ENTRY_VALUES_H_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - GHR_GENERAL
SYNONYM - GHR_PA_HISTORY

APPS.GHR_ELEMENT_ENTRY_VALUES_H_V is not referenced by any database object

[top of page]

View: GHR_EVENT_HISTORY_V

[top of page]

APPS.GHR_EVENT_HISTORY_V references the following:

APPS
SYNONYM - GHR_EVENTS
SYNONYM - GHR_EVENT_HISTORY

APPS.GHR_EVENT_HISTORY_V is not referenced by any database object

[top of page]

View: GHR_GBX_ROLES

[top of page]

APPS.GHR_GBX_ROLES references the following:

APPS
SYNONYM - GHR_GROUPBOXES

APPS.GHR_GBX_ROLES is not referenced by any database object

[top of page]

View: GHR_GBX_UR

[top of page]

APPS.GHR_GBX_UR references the following:

APPS
SYNONYM - FND_USER
SYNONYM - GHR_GROUPBOXES
SYNONYM - GHR_GROUPBOX_USERS

APPS.GHR_GBX_UR is not referenced by any database object

[top of page]

View: GHR_INFO_TYPE_SECURITY_RIT_V

[top of page]

APPS.GHR_INFO_TYPE_SECURITY_RIT_V references the following:

APPS
SYNONYM - GHR_PA_REQUEST_INFO_TYPES
SYNONYM - PER_INFO_TYPE_SECURITY

APPS.GHR_INFO_TYPE_SECURITY_RIT_V is not referenced by any database object

[top of page]

View: GHR_MASS_AWARDS_PREVIEW_V

[top of page]

APPS.GHR_MASS_AWARDS_PREVIEW_V references the following:

APPS
SYNONYM - GHR_PA_REQUESTS
SYNONYM - GHR_PA_REQUEST_EXTRA_INFO

APPS.GHR_MASS_AWARDS_PREVIEW_V is not referenced by any database object

[top of page]

View: GHR_MASS_REAL_POS_INFO_V

[top of page]

APPS.GHR_MASS_REAL_POS_INFO_V references the following:

APPS
SYNONYM - GHR_MASS_REALIGNMENT

APPS.GHR_MASS_REAL_POS_INFO_V is not referenced by any database object

[top of page]

View: GHR_MT_ADDRESSES_V

[top of page]

APPS.GHR_MT_ADDRESSES_V references the following:

APPS
SYNONYM - GHR_INTERFACE

APPS.GHR_MT_ADDRESSES_V is not referenced by any database object

[top of page]

View: GHR_MT_ANALYSIS_CRITERIA_V

[top of page]

APPS.GHR_MT_ANALYSIS_CRITERIA_V references the following:

APPS
SYNONYM - GHR_INTERFACE
APPS.GHR_MT_ANALYSIS_CRITERIA_V is referenced by following:

APPS
VIEW - GHR_MT_INTERFACE_V

[top of page]

View: GHR_MT_ASSIGNMENTS_F_V

[top of page]

APPS.GHR_MT_ASSIGNMENTS_F_V references the following:

APPS
SYNONYM - GHR_INTERFACE
APPS.GHR_MT_ASSIGNMENTS_F_V is referenced by following:

APPS
VIEW - GHR_MT_INTERFACE_V

[top of page]

View: GHR_MT_ASSIGNMENT_EI_V

[top of page]

APPS.GHR_MT_ASSIGNMENT_EI_V references the following:

APPS
SYNONYM - GHR_INTERFACE
APPS.GHR_MT_ASSIGNMENT_EI_V is referenced by following:

APPS
VIEW - GHR_MT_INTERFACE_V

[top of page]

View: GHR_MT_ELEMENT_ENTRIES_V

[top of page]

APPS.GHR_MT_ELEMENT_ENTRIES_V references the following:

APPS
SYNONYM - GHR_INTERFACE
APPS.GHR_MT_ELEMENT_ENTRIES_V is referenced by following:

APPS
VIEW - GHR_MT_INTERFACE_V

[top of page]

View: GHR_MT_INTERFACE_V

[top of page]

APPS.GHR_MT_INTERFACE_V references the following:

APPS
PACKAGE - FND_DATE
VIEW - GHR_MT_ANALYSIS_CRITERIA_V
VIEW - GHR_MT_ASSIGNMENTS_F_V
VIEW - GHR_MT_ASSIGNMENT_EI_V
VIEW - GHR_MT_ELEMENT_ENTRIES_V
VIEW - GHR_MT_MISC_V
VIEW - GHR_MT_PEOPLE_EI_V
VIEW - GHR_MT_PEOPLE_F_V
VIEW - GHR_MT_POSITIONS_V
VIEW - GHR_MT_POSITION_EI_V

APPS.GHR_MT_INTERFACE_V is not referenced by any database object

[top of page]

View: GHR_MT_MISC_V

[top of page]

APPS.GHR_MT_MISC_V references the following:

APPS
SYNONYM - GHR_INTERFACE
APPS.GHR_MT_MISC_V is referenced by following:

APPS
VIEW - GHR_MT_INTERFACE_V

[top of page]

View: GHR_MT_PEOPLE_EI_V

[top of page]

APPS.GHR_MT_PEOPLE_EI_V references the following:

APPS
SYNONYM - GHR_INTERFACE
APPS.GHR_MT_PEOPLE_EI_V is referenced by following:

APPS
VIEW - GHR_MT_INTERFACE_V

[top of page]

View: GHR_MT_PEOPLE_F_V

[top of page]

APPS.GHR_MT_PEOPLE_F_V references the following:

APPS
SYNONYM - GHR_INTERFACE
APPS.GHR_MT_PEOPLE_F_V is referenced by following:

APPS
VIEW - GHR_MT_INTERFACE_V

[top of page]

View: GHR_MT_POSITIONS_V

[top of page]

APPS.GHR_MT_POSITIONS_V references the following:

APPS
SYNONYM - GHR_INTERFACE
APPS.GHR_MT_POSITIONS_V is referenced by following:

APPS
VIEW - GHR_MT_INTERFACE_V

[top of page]

View: GHR_MT_POSITION_DEFINITIONS_V

[top of page]

APPS.GHR_MT_POSITION_DEFINITIONS_V references the following:

APPS
SYNONYM - GHR_INTERFACE

APPS.GHR_MT_POSITION_DEFINITIONS_V is not referenced by any database object

[top of page]

View: GHR_MT_POSITION_EI_V

[top of page]

APPS.GHR_MT_POSITION_EI_V references the following:

APPS
SYNONYM - GHR_INTERFACE
APPS.GHR_MT_POSITION_EI_V is referenced by following:

APPS
VIEW - GHR_MT_INTERFACE_V

[top of page]

View: GHR_PA_REMARKS_V

[top of page]

APPS.GHR_PA_REMARKS_V references the following:

APPS
SYNONYM - GHR_PA_REMARKS
SYNONYM - GHR_REMARKS

APPS.GHR_PA_REMARKS_V is not referenced by any database object

[top of page]

View: GHR_PA_REQUESTS_V

[top of page]

APPS.GHR_PA_REQUESTS_V references the following:

APPS
SYNONYM - GHR_FAMILIES
SYNONYM - GHR_NATURE_OF_ACTIONS
SYNONYM - GHR_PA_REQUESTS

APPS.GHR_PA_REQUESTS_V is not referenced by any database object

[top of page]

View: GHR_PA_REQUESTS_V1

[top of page]

APPS.GHR_PA_REQUESTS_V1 references the following:

APPS
SYNONYM - GHR_FAMILIES
SYNONYM - GHR_NATURE_OF_ACTIONS
SYNONYM - GHR_PA_REQUESTS
SYNONYM - GHR_ROUTING_GROUPS

APPS.GHR_PA_REQUESTS_V1 is not referenced by any database object

[top of page]

View: GHR_PA_ROUTING_HISTORY_V

[top of page]

APPS.GHR_PA_ROUTING_HISTORY_V references the following:

APPS
SYNONYM - GHR_FAMILIES
SYNONYM - GHR_GROUPBOXES
SYNONYM - GHR_NATURE_OF_ACTIONS
SYNONYM - GHR_PA_ROUTING_HISTORY
SYNONYM - GHR_ROUTING_LISTS

APPS.GHR_PA_ROUTING_HISTORY_V is not referenced by any database object

[top of page]

View: GHR_PD_CLASSIFICATIONS_V1

[top of page]

APPS.GHR_PD_CLASSIFICATIONS_V1 references the following:

APPS
SYNONYM - GHR_PD_CLASSIFICATIONS

APPS.GHR_PD_CLASSIFICATIONS_V1 is not referenced by any database object

[top of page]

View: GHR_PD_CLASSIFICATIONS_V2

[top of page]

APPS.GHR_PD_CLASSIFICATIONS_V2 references the following:

APPS
VIEW - FND_COMMON_LOOKUPS
PACKAGE - FND_GLOBAL
SYNONYM - GHR_PAY_PLANS
SYNONYM - GHR_PD_CLASSIFICATIONS

APPS.GHR_PD_CLASSIFICATIONS_V2 is not referenced by any database object

[top of page]

View: GHR_PD_COVERSHEET_V

[top of page]

APPS.GHR_PD_COVERSHEET_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - GHR_PA_REQUESTS
PACKAGE - GHR_PD_COVERSHEET_DATA
SYNONYM - GHR_POSITION_DESCRIPTIONS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PER_POSITION_EXTRA_INFO
- HR_POSITIONS_X
- PER_PEOPLE_X

APPS.GHR_PD_COVERSHEET_V is not referenced by any database object

[top of page]

View: GHR_PEOPLE_EXTRA_INFO_H_V

[top of page]

APPS.GHR_PEOPLE_EXTRA_INFO_H_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - GHR_GENERAL
SYNONYM - GHR_PA_HISTORY

APPS.GHR_PEOPLE_EXTRA_INFO_H_V is not referenced by any database object

[top of page]

View: GHR_PEOPLE_H_V

[top of page]

APPS.GHR_PEOPLE_H_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - GHR_GENERAL
SYNONYM - GHR_PA_HISTORY

APPS.GHR_PEOPLE_H_V is not referenced by any database object

[top of page]

View: GHR_PEOPLE_V

[top of page]

APPS.GHR_PEOPLE_V references the following:

APPS
SYNONYM - GHR_PA_REQUESTS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
- PER_PEOPLE_F

APPS.GHR_PEOPLE_V is not referenced by any database object

[top of page]

View: GHR_PERSON_ANALYSES_H_V

[top of page]

APPS.GHR_PERSON_ANALYSES_H_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - GHR_GENERAL
SYNONYM - GHR_PA_HISTORY

APPS.GHR_PERSON_ANALYSES_H_V is not referenced by any database object

[top of page]

View: GHR_PERSON_SUMMARY_V

[top of page]

APPS.GHR_PERSON_SUMMARY_V references the following:

APPS
SYNONYM - FND_SESSIONS
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PER_ASSIGNMENT_STATUS_TYPES
- PER_ASSIGNMENTS_F
- PER_PEOPLE_F

APPS.GHR_PERSON_SUMMARY_V is not referenced by any database object

[top of page]

View: GHR_POIS_V

[top of page]

APPS.GHR_POIS_V references the following:

APPS
SYNONYM - GHR_GROUPBOXES
SYNONYM - GHR_POIS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
- PER_PEOPLE_F

APPS.GHR_POIS_V is not referenced by any database object

[top of page]

View: GHR_POSITIONS_H_V

[top of page]

APPS.GHR_POSITIONS_H_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - GHR_GENERAL
SYNONYM - GHR_PA_HISTORY

APPS.GHR_POSITIONS_H_V is not referenced by any database object

[top of page]

View: GHR_POSITIONS_V

[top of page]

APPS.GHR_POSITIONS_V references the following:

APPS
PACKAGE - GHR_API
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
- PER_POSITIONS

APPS.GHR_POSITIONS_V is not referenced by any database object

[top of page]

View: GHR_POSITION_DESCRIPTIONS_V

[top of page]

APPS.GHR_POSITION_DESCRIPTIONS_V references the following:

APPS
SYNONYM - GHR_POSITION_DESCRIPTIONS

APPS.GHR_POSITION_DESCRIPTIONS_V is not referenced by any database object

[top of page]

View: GHR_POSITION_EXTRA_INFO_H_V

[top of page]

APPS.GHR_POSITION_EXTRA_INFO_H_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - GHR_GENERAL
SYNONYM - GHR_PA_HISTORY

APPS.GHR_POSITION_EXTRA_INFO_H_V is not referenced by any database object

[top of page]

View: GHR_PROCESS_LOG_V

[top of page]

APPS.GHR_PROCESS_LOG_V references the following:

APPS
SYNONYM - GHR_PROCESS_LOG

APPS.GHR_PROCESS_LOG_V is not referenced by any database object

[top of page]

View: GHR_PROCESS_LOG_V2

[top of page]

APPS.GHR_PROCESS_LOG_V2 references the following:

APPS
SYNONYM - GHR_PROCESS_LOG

APPS.GHR_PROCESS_LOG_V2 is not referenced by any database object

[top of page]

View: GHR_SF113_V

[top of page]

APPS.GHR_SF113_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PER_ASSIGNMENT_STATUS_TYPES
SYNONYM - PER_GRADES
SYNONYM - PER_GRADE_DEFINITIONS
- PER_PEOPLE_F
- PER_ASSIGNMENTS_F

APPS.GHR_SF113_V is not referenced by any database object

[top of page]

View: GHR_SS_ASG_CHG_DATES_V

[top of page]

APPS.GHR_SS_ASG_CHG_DATES_V references the following:

APPS
SYNONYM - GHR_PA_HISTORY
SYNONYM - PAY_ELEMENT_ENTRIES_F
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PER_ALL_ASSIGNMENTS_F
SYNONYM - PER_ASSIGNMENT_EXTRA_INFO
PACKAGE - PQP_FEDHR_USPAY_INT_UTILS

APPS.GHR_SS_ASG_CHG_DATES_V is not referenced by any database object

[top of page]

View: GHR_SS_POS_CHG_DATES_V

[top of page]

APPS.GHR_SS_POS_CHG_DATES_V references the following:

APPS
SYNONYM - GHR_PA_HISTORY
SYNONYM - HR_ALL_POSITIONS_F
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - PER_POSITION_EXTRA_INFO
- PER_ASSIGNMENTS_F2

APPS.GHR_SS_POS_CHG_DATES_V is not referenced by any database object

[top of page]

View: GHR_SS_PRSNL_CHG_DATES_V

[top of page]

APPS.GHR_SS_PRSNL_CHG_DATES_V references the following:

APPS
SYNONYM - GHR_PA_HISTORY
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_PEOPLE_EXTRA_INFO

APPS.GHR_SS_PRSNL_CHG_DATES_V is not referenced by any database object

[top of page]

View: GHR_SS_SAL_CHG_DATES_V

[top of page]

APPS.GHR_SS_SAL_CHG_DATES_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - PAY_ELEMENT_ENTRIES_F
SYNONYM - PAY_ELEMENT_TYPES_F
PACKAGE - PQP_FEDHR_USPAY_INT_UTILS
- PER_ASSIGNMENTS_F2

APPS.GHR_SS_SAL_CHG_DATES_V is not referenced by any database object

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