GHR Views (53)

GHR - US Federal Human Resources — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`GHR_ADDRESSES_H_V`	Mapping of GHR_PA_HISTORY columns to PER_ADDRESSES.
`GHR_ASSIGNMENTS_H_V`	Mapping of GHR_PA_HISTORY columns to PER_ASSIGNMENTS_F.
`GHR_ASSIGNMENT_EXTRA_INFO_H_V`	Mapping of GHR_PA_HISTORY columns to PER_ASSIGNMENTS_EXTRA_INFO.
`GHR_BREAKDOWN_V`	This view is used by Break Down form.
`GHR_CLAIM_SOURCE_V`	This view is used by the EEOC Claims Form
`GHR_COMPLAINTS_V`	This view is use by the form.
`GHR_DUTY_STATIONS_D`	This views holds information about duty stations.
`GHR_DUTY_STATIONS_V`	This view makes self reference to get expanded duty station name.
`GHR_ELEMENT_ENTRIES_H_V`	Mapping of GHR_PA_HISTORY columns to PAY_ELEMENT_ENTRIES_F.
`GHR_ELEMENT_ENTRIES_V`	This view holds the Element Entries info for GHR Elements
`GHR_ELEMENT_ENTRY_VALUES_H_V`	Mapping of GHR_PA_HISTORY columns to PAY_ELEMENT_ENTRY_VALUES_F.
`GHR_EVENT_HISTORY_V`	This view is based GHR_EVENT_HISTORY table.
`GHR_GBX_ROLES`	View for WF Bulk synchonization of Groupboxes
`GHR_GBX_UR`	View for WF Bulk synchonization of Groupbox Users
`GHR_INFO_TYPE_SECURITY_RIT_V`	This view is used for validating information type eligible for a given responsibility.
`GHR_MASS_AWARDS_PREVIEW_V`	This view holds the Mass Award Preview Information.
`GHR_MASS_REAL_POS_INFO_V`	This form is used by Mass Realignment for Position Information.
`GHR_MT_ADDRESSES_V`	This views is used by mass transfer in and out processes for datatransfer.
`GHR_MT_ANALYSIS_CRITERIA_V`	This views is used by mass transfer in and out processes for datatransfer.
`GHR_MT_ASSIGNMENTS_F_V`	This views is used by mass transfer in and out processes for datatransfer.
`GHR_MT_ASSIGNMENT_EI_V`	This views is used by mass transfer in and out processes for datatransfer.
`GHR_MT_ELEMENT_ENTRIES_V`	This views is used by mass transfer in and out processes for datatransfer.
`GHR_MT_INTERFACE_V`	This views is used by mass transfer in and out processes for datatransfer.
`GHR_MT_MISC_V`	This views is used by mass transfer in and out processes for datatransfer.
`GHR_MT_PEOPLE_EI_V`	This views is used by mass transfer in and out processes for datatransfer.
`GHR_MT_PEOPLE_F_V`	This views is used by mass transfer in and out processes for datatransfer.
`GHR_MT_POSITIONS_V`	This views is used by mass transfer in and out processes for datatransfer.
`GHR_MT_POSITION_DEFINITIONS_V`	This views is used by mass transfer in and out processes for datatransfer.
`GHR_MT_POSITION_EI_V`	This views is used by mass transfer in and out processes for datatransfer.
`GHR_PA_REMARKS_V`	GHR_PA_REMARKS_V is a view based on GHR_PA_REMARKS for use bythe form.
`GHR_PA_REQUESTS_V`	GHR_PA_REQUESTS_V is a view based on GHR_PA_REQUESTS for use by the form.
`GHR_PA_REQUESTS_V1`	This view holds the RPA and NPA information.
`GHR_PA_ROUTING_HISTORY_V`	Personnel Action (PA) Routing History deatils view
`GHR_PD_CLASSIFICATIONS_V1`	Position Description Classifications view details
`GHR_PD_CLASSIFICATIONS_V2`	Position Description Classifications view details
`GHR_PD_COVERSHEET_V`	Position Description Coversheet details
`GHR_PEOPLE_EXTRA_INFO_H_V`	Mapping of GHR_PA_HISTORY columns to PER_PEOPLE_EXTRA_INFO.
`GHR_PEOPLE_H_V`	Mapping of GHR_PA_HISTORY columns to PER_ALL_PEOPLE_F.
`GHR_PEOPLE_V`	This view is based on table PER_PEOPLE_F
`GHR_PERSON_ANALYSES_H_V`	Mapping of GHR_PA_HISTORY columns to PER_PERSON_ANALYSES.
`GHR_PERSON_SUMMARY_V`	Contains the Person Summary information.
`GHR_POIS_V`	GHR_POIS_V is based on secure view PER_PEOPLE_V and used by POI form.
`GHR_POSITIONS_H_V`	Mapping of GHR_PA_HISTORY columns to HR_ALL_POSITIONS_F.
`GHR_POSITIONS_V`	GHR_PA_POSITIONS_V is a view based on PER_POSITIONS to help give alist of values to be selected on PA request form.
`GHR_POSITION_DESCRIPTIONS_V`	Position Description deatils
`GHR_POSITION_EXTRA_INFO_H_V`	Mapping of GHR_PA_HISTORY columns to PER_POSITION_EXTRA_INFO.
`GHR_PROCESS_LOG_V`	This view is based on GHR_PROCESS_LOG table and is used by process logform.
`GHR_PROCESS_LOG_V2`	This view is based on GHR_PROCESS_LOG table and is used by process logform.
`GHR_SF113_V`	This view is used to generate SF-113A report.
`GHR_SS_ASG_CHG_DATES_V`	This view is used by Fed SS Views
`GHR_SS_POS_CHG_DATES_V`	This view is used by Fed SS Views
`GHR_SS_PRSNL_CHG_DATES_V`
`GHR_SS_SAL_CHG_DATES_V`