eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
Oracle eBusiness Suite Technical Reference
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®,
OracleDevConnect SM, Oracle® Discoverer,
Oracle® Expert, Oracle Financials®, OracleGOLD SM,
OracleIncident SM, OracleJSP,
OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURY SM,
OracleMetaLink SM, Oraclemetals SM, OracleMobile, Oracle Names®,
Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®,
Oracle OpenWorld®, OraclePLATINUM SM,
Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®,
Oracle Quality®, Oracle Secure Network Services®, OracleSILVER SM,
Oracle® SQL/Services, Oracle® SQL*TutorSM,
OracleSTERLING SM, 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
BREAKDOWN_CRITERIA_ID
Primary Key: GHR_BREAKDOWN_CRITERIA_UK
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:
APPS
SYNONYM - GHR_BREAKDOWN_CRITERIA
TRIGGER - GHR_BREAKDOWN_CRITERIA_WHO
PUBLIC
SYNONYM - 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
SESSION_ID
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:
APPS
SYNONYM - GHR_BREAKDOWN_RESULTS
TRIGGER - GHR_BREAKDOWN_RESULTS_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_COMPLAINTS2
TRIGGER - GHR_COMPLAINTS2_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_COMPL_ADRS
TRIGGER - GHR_COMPL_ADRS_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_COMPL_AGENCY_APPEALS
TRIGGER - GHR_COMPL_AGENCY_APPEALS_WHO
PUBLIC
SYNONYM - 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:
APPS
SYNONYM - GHR_COMPL_AGENCY_COSTS
TRIGGER - GHR_COMPL_AGENCY_COSTS_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_COMPL_APPEALS
TRIGGER - GHR_COMPL_APPEALS_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_COMPL_BASES
TRIGGER - GHR_COMPL_BASES_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_COMPL_CA_DETAILS
TRIGGER - GHR_COMPL_CA_DETAILS_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_COMPL_CA_HEADERS
TRIGGER - GHR_COMPL_CA_HEADERS_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_COMPL_CLAIMS
TRIGGER - GHR_COMPL_CLAIMS_WHO
PUBLIC
SYNONYM - GHR_COMPL_CLAIMS
[top of page]
Table: GHR_COMPL_INCIDENTS
Description: Stores Incident Information for a given Basis.
Primary Key: GHR_COMPL_INCIDENTS_PK
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:
APPS
SYNONYM - GHR_COMPL_INCIDENTS
TRIGGER - GHR_COMPL_INCIDENTS_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_COMPL_PEOPLE
TRIGGER - GHR_COMPL_PEOPLE_WHO
PUBLIC
SYNONYM - 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:
APPS
SYNONYM - GHR_CPDF_TEMP
TRIGGER - GHR_CPDF_TEMP_WHO
PUBLIC
SYNONYM - 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
FIRST_NOA_ID
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:
APPS
SYNONYM - GHR_DUAL_ACTIONS
TRIGGER - GHR_DUAL_ACTIONS_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_DUAL_PROC_METHODS
TRIGGER - GHR_DUAL_PROC_METHODS_WHO
PUBLIC
SYNONYM - 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
DUTY_STATION_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
Primary Key: GHR_DUTY_STATIONS_F_UK
DUTY_STATION_CODE
EFFECTIVE_END_DATE
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:
APPS
SYNONYM - GHR_DUTY_STATIONS_F
TRIGGER - GHR_DUTY_STATIONS_F_WHO
PUBLIC
SYNONYM - GHR_DUTY_STATIONS_F
[top of page]
Table: GHR_EVENTS
Description: This table stores various events.
Primary Key: GHR_EVENTS_PK
EVENT_ID
Primary Key: GHR_EVENTS_UK
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:
APPS
SYNONYM - GHR_EVENTS
TRIGGER - GHR_EVENTS_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_EVENT_HISTORY
TRIGGER - GHR_EVENT_HISTORY_WHO
PUBLIC
SYNONYM - GHR_EVENT_HISTORY
[top of page]
Table: GHR_FAMILIES
Description: GHR_FAMILIES holds information about a family.
Primary Key: GHR_FAMILIES_PK
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:
APPS
SYNONYM - GHR_FAMILIES
TRIGGER - GHR_FAMILIES_WHO
PUBLIC
SYNONYM - GHR_FAMILIES
[top of page]
Table: GHR_GROUPBOXES
Description: Groupboxes defined to be used by workflow
Primary Key: GHR_GROUPBOXES_PK
GROUPBOX_ID
Primary Key: GHR_GROUPBOXES_UK1
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:
APPS
SYNONYM - GHR_GROUPBOXES
TRIGGER - GHR_GROUPBOXES_AD
TRIGGER - GHR_GROUPBOXES_AD_STM
TRIGGER - GHR_GROUPBOXES_AI
TRIGGER - GHR_GROUPBOXES_AI_STM
TRIGGER - GHR_GROUPBOXES_AU
TRIGGER - GHR_GROUPBOXES_AU_STM
TRIGGER - GHR_GROUPBOXES_BI
TRIGGER - GHR_GROUPBOXES_WHO
PUBLIC
SYNONYM - GHR_GROUPBOXES
[top of page]
Table: GHR_GROUPBOX_USERS
Description: Defines the members of the Groupbox
Primary Key: GHR_GROUPBOX_USERS_PK
GROUPBOX_USER_ID
Primary Key: GHR_GROUPBOX_USERS_UK
GROUPBOX_ID
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:
APPS
SYNONYM - GHR_GROUPBOX_USERS
TRIGGER - GHR_GROUPBOX_USERS_AD
TRIGGER - GHR_GROUPBOX_USERS_AD_STM
TRIGGER - GHR_GROUPBOX_USERS_AI
TRIGGER - GHR_GROUPBOX_USERS_AI_STM
TRIGGER - GHR_GROUPBOX_USERS_AU
TRIGGER - GHR_GROUPBOX_USERS_AU_STM
TRIGGER - GHR_GROUPBOX_USERS_BI
TRIGGER - GHR_GROUPBOX_USERS_WHO
PUBLIC
SYNONYM - 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
INTERFACE_ID
[top of page]
HR.GHR_INTERFACE does not reference any database object
HR.GHR_INTERFACE is referenced by following:
APPS
SYNONYM - GHR_INTERFACE
TRIGGER - GHR_INTERFACE_WHO
PUBLIC
SYNONYM - 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
LOCALITY_PAY_AREA_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
Primary Key: GHR_LOCALITY_PAY_AREAS_F_UK
LOCALITY_PAY_AREA_CODE
EFFECTIVE_END_DATE
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:
APPS
SYNONYM - GHR_LOCALITY_PAY_AREAS_F
TRIGGER - GHR_LOCALITY_PAY_AREAS_F_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_MASS_ACTIONS_PREVIEW
TRIGGER - GHR_MASS_ACTIONS_PREVIEW_INS
TRIGGER - GHR_MASS_ACTIONS_PREVIEW_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_MASS_AWARDS
TRIGGER - GHR_MASS_AWARDS_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_MASS_AWARD_CRITERIA_COLS
TRIGGER - GHR_MASS_AWARD_CRITERIA_CO_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_MASS_AWARD_CRITERIA_VALS
TRIGGER - GHR_MASS_AWARD_CRITERIA_VA_WHO
PUBLIC
SYNONYM - 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
MASS_REALIGNMENT_ID
Primary Key: GHR_MASS_REALIGNMENT_UK
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:
APPS
SYNONYM - GHR_MASS_REALIGNMENT
TRIGGER - GHR_MASS_REALIGNMENT_WHO
PUBLIC
SYNONYM - 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
MASS_SALARY_ID
Primary Key: GHR_MASS_SALARIES_UK
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:
APPS
SYNONYM - GHR_MASS_SALARIES
TRIGGER - GHR_MASS_SALARIES_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_MASS_SALARY_CRITERIA
TRIGGER - GHR_MASS_SALARY_CRITERIA_WHO
PUBLIC
SYNONYM - GHR_MASS_SALARY_CRITERIA
[top of page]
Table: GHR_MASS_SALARY_CRITERIA_EXT
[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:
APPS
SYNONYM - GHR_MASS_SALARY_CRITERIA_EXT
TRIGGER - GHR_MASS_SALARY_CRITERIA_E_WHO
PUBLIC
SYNONYM - 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
MASS_TRANSFER_ID
Primary Key: GHR_MASS_TRANSFERS_UK
NAME
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:
APPS
SYNONYM - GHR_MASS_TRANSFERS
TRIGGER - GHR_MASS_TRANSFERS_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_MASS_TRANSFER_CRITERIA
TRIGGER - GHR_MASS_TRANSFER_CRITERIA_WHO
PUBLIC
SYNONYM - 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:
APPS
SYNONYM - GHR_MTS_TEMP
TRIGGER - GHR_MTS_TEMP_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_NATURE_OF_ACTIONS
TRIGGER - GHR_NATURE_OF_ACTIONS_WHO
PUBLIC
SYNONYM - 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
NOAC_LA_ID
Primary Key: GHR_NOAC_LAS_UK
LAC_LOOKUP_CODE
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:
APPS
SYNONYM - GHR_NOAC_LAS
TRIGGER - GHR_NOAC_LAS_WHO
PUBLIC
SYNONYM - GHR_NOAC_LAS
[top of page]
Table: GHR_NOAC_REMARKS
Description: Stores NOA and the associated Remarks
Primary Key: GHR_NOAC_REMARKS_PK
NOAC_REMARK_ID
Primary Key: GHR_NOAC_REMARKS_UK
REMARK_ID
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:
APPS
SYNONYM - GHR_NOAC_REMARKS
TRIGGER - GHR_NOAC_REMARKS_WHO
PUBLIC
SYNONYM - GHR_NOAC_REMARKS
[top of page]
Table: GHR_NOA_FAMILIES
Description: Stores Families and associated NOAs
Primary Key: GHR_NOA_FAMILIES_PK
NOA_FAMILY_CODE
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:
APPS
SYNONYM - GHR_NOA_FAMILIES
TRIGGER - GHR_NOA_FAMILIES_WHO
PUBLIC
SYNONYM - 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
NOA_FAMILY_CODE
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:
APPS
SYNONYM - GHR_NOA_FAM_PROC_METHODS
TRIGGER - GHR_NOA_FAM_PROC_METHODS_WHO
PUBLIC
SYNONYM - 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
PAYROLL_ID
[top of page]
HR.GHR_PAYROLL does not reference any database object
HR.GHR_PAYROLL is referenced by following:
APPS
SYNONYM - GHR_PAYROLL
TRIGGER - GHR_PAYROLL_WHO
PUBLIC
SYNONYM - GHR_PAYROLL
[top of page]
Table: GHR_PAY_PLANS
Description: Defines the Pay Plans
Primary Key: GHR_PAY_PLANS_PK
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:
APPS
SYNONYM - GHR_PAY_PLANS
TRIGGER - GHR_PAY_PLANS_WHO
PUBLIC
SYNONYM - 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
PAY_PLAN
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:
APPS
SYNONYM - GHR_PAY_PLAN_WAITING_PERIODS
TRIGGER - GHR_PAY_PLAN_WAITING_PERIO_WHO
PUBLIC
SYNONYM - 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
PA_DATA_FIELD_ID
Primary Key: GHR_PA_DATA_FIELDS_UK1
NAME
Primary Key: GHR_PA_DATA_FIELDS_UK2
FORM_BLOCK_NAME
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:
APPS
SYNONYM - GHR_PA_DATA_FIELDS
TRIGGER - GHR_PA_DATA_FIELDS_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_PA_HISTORY
TRIGGER - GHR_PA_HISTORY_WHO
PUBLIC
SYNONYM - GHR_PA_HISTORY
[top of page]
Table: GHR_PA_INTERFACE_ERR_DTLS
[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:
APPS
SYNONYM - GHR_PA_INTERFACE_ERR_DTLS
TRIGGER - GHR_PA_INTERFACE_ERR_DTLS_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_PA_REMARKS
TRIGGER - GHR_PA_REMARKS_WHO
PUBLIC
SYNONYM - 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
PA_REQUEST_ID
Primary Key: GHR_PA_REQUESTS_UK1
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:
APPS
SYNONYM - GHR_PA_REQUESTS
TRIGGER - GHR_PA_REQUESTS_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_PA_REQUEST_EI_SHADOW
TRIGGER - GHR_PA_REQUEST_EI_SHADOW_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_PA_REQUEST_EXTRA_INFO
TRIGGER - GHR_PA_REQUEST_EXTRA_INFO_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_PA_REQUEST_INFO_TYPES
TRIGGER - GHR_PA_REQUEST_INFO_TYPES_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_PA_REQUEST_SHADOW
TRIGGER - GHR_PA_REQUEST_SHADOW_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_PA_ROUTING_HISTORY
TRIGGER - GHR_PA_ROUTING_HISTORY_WHO
PUBLIC
SYNONYM - GHR_PA_ROUTING_HISTORY
[top of page]
Table: GHR_PD_CLASSIFICATIONS
Description: Classification details of a Position Description.
Primary Key: GHR_PD_CLASSIFICATIONS_PK
PD_CLASSIFICATION_ID
Primary Key: GHR_PD_CLASSIFICATIONS_UK
POSITION_DESCRIPTION_ID
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:
APPS
SYNONYM - GHR_PD_CLASSIFICATIONS
TRIGGER - GHR_PD_CLASSIFICATIONS_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_PD_ROUTING_HISTORY
TRIGGER - GHR_PD_ROUTING_HISTORY_WHO
PUBLIC
SYNONYM - 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:
APPS
SYNONYM - GHR_PERF_CERT
TRIGGER - GHR_PERF_CERT_WHO
PUBLIC
SYNONYM - 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
PLAN_SERVICE_AREA_ID
EFFECTIVE_START_DATE
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:
APPS
SYNONYM - GHR_PLAN_SERVICE_AREAS_F
TRIGGER - GHR_PLAN_SERVICE_AREAS_F_WHO
PUBLIC
SYNONYM - GHR_PLAN_SERVICE_AREAS_F
[top of page]
Table: GHR_POIS
Description: Contains information related to Personnel Office Identifier
Primary Key: GHR_POIS_PK
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:
APPS
SYNONYM - GHR_POIS
TRIGGER - GHR_POIS_WHO
PUBLIC
SYNONYM - GHR_POIS
[top of page]
Table: GHR_POSITION_DESCRIPTIONS
Description: Federal Position Description details
Primary Key: GHR_POSITION_DESCRIPTIONS_PK
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:
APPS
SYNONYM - GHR_POSITION_DESCRIPTIONS
TRIGGER - GHR_POSITION_DESCRIPTIONS_WHO
PUBLIC
SYNONYM - GHR_POSITION_DESCRIPTIONS
[top of page]
Table: GHR_POS_INTERFACE_ERR_DTLS
[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:
APPS
SYNONYM - GHR_POS_INTERFACE_ERR_DTLS
TRIGGER - GHR_POS_INTERFACE_ERR_DTLS_WHO
PUBLIC
SYNONYM - 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
CODE
[top of page]
HR.GHR_PREMIUM_PAY_INDICATORS does not reference any database object
HR.GHR_PREMIUM_PAY_INDICATORS is referenced by following:
APPS
SYNONYM - GHR_PREMIUM_PAY_INDICATORS
TRIGGER - GHR_PREMIUM_PAY_INDICATORS_WHO
PUBLIC
SYNONYM - 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
PROCESS_LOG_ID
[top of page]
HR.GHR_PROCESS_LOG does not reference any database object
HR.GHR_PROCESS_LOG is referenced by following:
APPS
SYNONYM - GHR_PROCESS_LOG
TRIGGER - GHR_PROCESS_LOG_INS
TRIGGER - GHR_PROCESS_LOG_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_REMARKS
TRIGGER - GHR_REMARKS_WHO
PUBLIC
SYNONYM - 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
PA_DATA_FIELD_ID
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:
APPS
SYNONYM - GHR_RESTRICTED_PROC_METHODS
TRIGGER - GHR_RESTRICTED_PROC_METHOD_WHO
PUBLIC
SYNONYM - 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
RIF_CRITERIA_ID
Primary Key: GHR_RIF_CRITERIA_UK
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:
APPS
SYNONYM - GHR_RIF_CRITERIA
TRIGGER - GHR_RIF_CRITERIA_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - GHR_RIF_REGISTERS
TRIGGER - GHR_RIF_REGISTERS_WHO
PUBLIC
SYNONYM - GHR_RIF_REGISTERS
[top of page]
Table: GHR_ROUTING_GROUPS
Description: Routing Group information
Primary Key: GHR_ROUTING_GROUPS_PK
ROUTING_GROUP_ID
Primary Key: GHR_ROUTING_GROUPS_UK
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:
APPS
SYNONYM - GHR_ROUTING_GROUPS
TRIGGER - GHR_ROUTING_GROUPS_WHO
PUBLIC
SYNONYM - GHR_ROUTING_GROUPS
[top of page]
Table: GHR_ROUTING_LISTS
Description: Routing List details
Primary Key: GHR_ROUTING_LISTS_PK
ROUTING_LIST_ID
Primary Key: GHR_ROUTING_LISTS_UK1
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:
APPS
SYNONYM - GHR_ROUTING_LISTS
TRIGGER - GHR_ROUTING_LISTS_WHO
PUBLIC
SYNONYM - GHR_ROUTING_LISTS
[top of page]
Table: GHR_ROUTING_LIST_MEMBERS
Description: Routing List members detail
Primary Key: GHR_ROUTING_LIST_MEMBERS_PK
ROUTING_LIST_MEMBER_ID
Primary Key: GHR_ROUTING_LIST_MEMBERS_UK
ROUTING_LIST_ID
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:
APPS
SYNONYM - GHR_ROUTING_LIST_MEMBERS
TRIGGER - GHR_ROUTING_LIST_MEMBERS_WHO
PUBLIC
SYNONYM - 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 referenced by following:
APPS
PACKAGE BODY - GHR_HISTORY_CONV_RG
PACKAGE - GHR_HISTORY_CONV_RG
PACKAGE - GHR_US_NFC_EXTRACTS
PACKAGE BODY - GHR_US_NFC_EXTRACTS
PUBLIC
SYNONYM - GHR_ADDRESSES_H_V
[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 referenced by following:
APPS
PACKAGE BODY - GHR_API
PACKAGE - GHR_HISTORY_CONV_RG
PACKAGE BODY - GHR_HISTORY_CONV_RG
PUBLIC
SYNONYM - GHR_ASSIGNMENTS_H_V
[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 referenced by following:
APPS
PACKAGE BODY - GHR_CPDF_EHRIS
PACKAGE BODY - GHR_HISTORY_CONV_RG
PACKAGE - GHR_HISTORY_CONV_RG
PACKAGE BODY - GHR_HISTORY_FETCH
PUBLIC
SYNONYM - GHR_ASSIGNMENT_EXTRA_INFO_H_V
[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 referenced by following:
PUBLIC
SYNONYM - GHR_BREAKDOWN_V
[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 referenced by following:
PUBLIC
SYNONYM - GHR_CLAIM_SOURCE_V
[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 referenced by following:
PUBLIC
SYNONYM - GHR_DUTY_STATIONS_D
[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 referenced by following:
APPS
PACKAGE BODY - GHR_CREATE_PTNL_LIFE_EVENTS
PACKAGE - GHR_MASS_ACTIONS_PKG
PACKAGE BODY - GHR_MASS_AWARDS_PKG
PACKAGE BODY - GHR_MASS_CHANGES
PACKAGE BODY - GHR_MTO_INT
PACKAGE - GHR_PA_REQUESTS_PKG
PACKAGE BODY - GHR_PA_REQUESTS_PKG
PACKAGE BODY - GHR_PER_SUM
PUBLIC
SYNONYM - GHR_DUTY_STATIONS_V
[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 referenced by following:
APPS
PACKAGE BODY - GHR_HISTORY_CONV_RG
PACKAGE - GHR_HISTORY_CONV_RG
PACKAGE BODY - GHR_HISTORY_FETCH
PUBLIC
SYNONYM - GHR_ELEMENT_ENTRIES_H_V
[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 referenced by following:
PUBLIC
SYNONYM - GHR_ELEMENT_ENTRIES_V
[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 referenced by following:
APPS
PACKAGE BODY - GHR_HISTORY_CONV_RG
PACKAGE - GHR_HISTORY_CONV_RG
PACKAGE BODY - GHR_HISTORY_FETCH
PUBLIC
SYNONYM - GHR_ELEMENT_ENTRY_VALUES_H_V
[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 referenced by following:
PUBLIC
SYNONYM - GHR_EVENT_HISTORY_V
[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 referenced by following:
PUBLIC
SYNONYM - GHR_GBX_ROLES
[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 referenced by following:
PUBLIC
SYNONYM - GHR_GBX_UR
[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 referenced by following:
PUBLIC
SYNONYM - GHR_INFO_TYPE_SECURITY_RIT_V
[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 referenced by following:
PUBLIC
SYNONYM - GHR_MASS_AWARDS_PREVIEW_V
[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 referenced by following:
APPS
PACKAGE BODY - GHR_MRE_PKG
PUBLIC
SYNONYM - GHR_MASS_REAL_POS_INFO_V
[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 referenced by following:
APPS
PACKAGE BODY - GHR_MTI_INT
PACKAGE BODY - GHR_MTO_INT
PUBLIC
SYNONYM - GHR_MT_ADDRESSES_V
[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
PACKAGE BODY - GHR_MTI_INT
PACKAGE BODY - GHR_MTO_INT
VIEW - GHR_MT_INTERFACE_V
PUBLIC
SYNONYM - GHR_MT_ANALYSIS_CRITERIA_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
PACKAGE BODY - GHR_MTO_INT
VIEW - GHR_MT_INTERFACE_V
PUBLIC
SYNONYM - GHR_MT_ASSIGNMENTS_F_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
PACKAGE BODY - GHR_MTO_INT
VIEW - GHR_MT_INTERFACE_V
PUBLIC
SYNONYM - GHR_MT_ASSIGNMENT_EI_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
PACKAGE BODY - GHR_MTI_INT_INSERT
PACKAGE - GHR_MTO_INT
PACKAGE BODY - GHR_MTO_INT
VIEW - GHR_MT_INTERFACE_V
PUBLIC
SYNONYM - GHR_MT_ELEMENT_ENTRIES_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 referenced by following:
APPS
PACKAGE BODY - GHR_MTI_APP
PUBLIC
SYNONYM - GHR_MT_INTERFACE_V
[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
PACKAGE BODY - GHR_MTI_INT_INSERT
PACKAGE - GHR_MTO_INT
PACKAGE BODY - GHR_MTO_INT
VIEW - GHR_MT_INTERFACE_V
PUBLIC
SYNONYM - GHR_MT_MISC_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
PACKAGE BODY - GHR_MTI_INT
PACKAGE BODY - GHR_MTO_INT
VIEW - GHR_MT_INTERFACE_V
PUBLIC
SYNONYM - GHR_MT_PEOPLE_EI_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
PACKAGE BODY - GHR_MTI_INT
PACKAGE BODY - GHR_MTI_INT_INSERT
PACKAGE BODY - GHR_MTO_INT
VIEW - GHR_MT_INTERFACE_V
PUBLIC
SYNONYM - GHR_MT_PEOPLE_F_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
PACKAGE BODY - GHR_MTO_INT
VIEW - GHR_MT_INTERFACE_V
PUBLIC
SYNONYM - GHR_MT_POSITIONS_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 referenced by following:
APPS
PACKAGE BODY - GHR_MTO_INT
PUBLIC
SYNONYM - GHR_MT_POSITION_DEFINITIONS_V
[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
PACKAGE BODY - GHR_MTO_INT
VIEW - GHR_MT_INTERFACE_V
PUBLIC
SYNONYM - GHR_MT_POSITION_EI_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 referenced by following:
PUBLIC
SYNONYM - GHR_PA_REMARKS_V
[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 referenced by following:
PUBLIC
SYNONYM - GHR_PA_REQUESTS_V
[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 referenced by following:
PUBLIC
SYNONYM - GHR_PA_REQUESTS_V1
[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 referenced by following:
PUBLIC
SYNONYM - GHR_PA_ROUTING_HISTORY_V
[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 referenced by following:
PUBLIC
SYNONYM - GHR_PD_CLASSIFICATIONS_V1
[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 referenced by following:
PUBLIC
SYNONYM - GHR_PD_CLASSIFICATIONS_V2
[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
VIEW - HR_POSITIONS_X
PACKAGE - HR_SECURITY
VIEW - PER_PEOPLE_X
SYNONYM - PER_POSITION_EXTRA_INFO
APPS.GHR_PD_COVERSHEET_V is referenced by following:
PUBLIC
SYNONYM - GHR_PD_COVERSHEET_V
[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 referenced by following:
APPS
PACKAGE BODY - GHR_FORMULA_FUNCTIONS
PACKAGE - GHR_HISTORY_CONV_RG
PACKAGE BODY - GHR_HISTORY_CONV_RG
PACKAGE BODY - GHR_HISTORY_FETCH
PUBLIC
SYNONYM - GHR_PEOPLE_EXTRA_INFO_H_V
[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 referenced by following:
APPS
PACKAGE BODY - GHR_HISTORY_CONV_RG
PACKAGE - GHR_HISTORY_CONV_RG
PUBLIC
SYNONYM - GHR_PEOPLE_H_V
[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
VIEW - PER_PEOPLE_F
APPS.GHR_PEOPLE_V is referenced by following:
PUBLIC
SYNONYM - GHR_PEOPLE_V
[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 referenced by following:
APPS
PACKAGE BODY - GHR_HISTORY_CONV_RG
PACKAGE - GHR_HISTORY_CONV_RG
PUBLIC
SYNONYM - GHR_PERSON_ANALYSES_H_V
[top of page]
View: GHR_PERSON_SUMMARY_V
[top of page]
APPS.GHR_PERSON_SUMMARY_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_SESSIONS
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PER_ASSIGNMENTS_F
SYNONYM - PER_ASSIGNMENT_STATUS_TYPES
VIEW - PER_PEOPLE_F
APPS.GHR_PERSON_SUMMARY_V is referenced by following:
PUBLIC
SYNONYM - GHR_PERSON_SUMMARY_V
[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
VIEW - PER_PEOPLE_F
APPS.GHR_POIS_V is referenced by following:
PUBLIC
SYNONYM - GHR_POIS_V
[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 referenced by following:
APPS
PACKAGE BODY - GHR_HISTORY_CONV_RG
PACKAGE - GHR_HISTORY_CONV_RG
PACKAGE BODY - GHR_VALIDATE_PERWSDPO
PUBLIC
SYNONYM - GHR_POSITIONS_H_V
[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
VIEW - PER_POSITIONS
APPS.GHR_POSITIONS_V is referenced by following:
PUBLIC
SYNONYM - GHR_POSITIONS_V
[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 referenced by following:
PUBLIC
SYNONYM - GHR_POSITION_DESCRIPTIONS_V
[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 referenced by following:
APPS
PACKAGE BODY - GHR_HISTORY_CONV_RG
PACKAGE - GHR_HISTORY_CONV_RG
PACKAGE BODY - GHR_HISTORY_FETCH
PUBLIC
SYNONYM - GHR_POSITION_EXTRA_INFO_H_V
[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 referenced by following:
PUBLIC
SYNONYM - GHR_PROCESS_LOG_V
[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 referenced by following:
PUBLIC
SYNONYM - GHR_PROCESS_LOG_V2
[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
VIEW - PER_ASSIGNMENTS_F
SYNONYM - PER_ASSIGNMENT_STATUS_TYPES
SYNONYM - PER_GRADES
SYNONYM - PER_GRADE_DEFINITIONS
VIEW - PER_PEOPLE_F
APPS.GHR_SF113_V is referenced by following:
APPS
PACKAGE BODY - GHR_SF113_A
PUBLIC
SYNONYM - GHR_SF113_V
[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 referenced by following:
PUBLIC
SYNONYM - GHR_SS_ASG_CHG_DATES_V
[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
VIEW - PER_ASSIGNMENTS_F2
SYNONYM - PER_POSITION_EXTRA_INFO
APPS.GHR_SS_POS_CHG_DATES_V is referenced by following:
PUBLIC
SYNONYM - GHR_SS_POS_CHG_DATES_V
[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 referenced by following:
PUBLIC
SYNONYM - GHR_SS_PRSNL_CHG_DATES_V
[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
VIEW - PER_ASSIGNMENTS_F2
PACKAGE - PQP_FEDHR_USPAY_INT_UTILS
APPS.GHR_SS_SAL_CHG_DATES_V is referenced by following:
PUBLIC
SYNONYM - GHR_SS_SAL_CHG_DATES_V
[top of page]