GHR Tables (69)
GHR - US Federal Human Resources — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
GHR_BREAKDOWN_CRITERIA |
14 | Holds the criteria used to run the breakdown report. |
GHR_BREAKDOWN_RESULTS |
13 | GHR_BREAKDOWN_RESULTS is a temporary table used to produce thebreakdown report |
GHR_COMPLAINTS2 |
165 | GHR_COMPLAINTS2 table is a master table containing complaint details from various persons in the system. |
GHR_COMPL_ADRS |
16 | Stores Alternate Dispute Resolution details for a given Complaint. |
GHR_COMPL_AGENCY_APPEALS |
34 | Stores Agency Appeals for a given Complaint. |
GHR_COMPL_AGENCY_COSTS |
14 | Stores Compliant Agency Costs Information |
GHR_COMPL_APPEALS |
38 | Stores Complainant Appeals for a given Complaint. |
GHR_COMPL_BASES |
13 | Stores Issues and Basis for a given Complaint. |
GHR_COMPL_CA_DETAILS |
18 | Stores the Corrective Action Details for a given |
GHR_COMPL_CA_HEADERS |
28 | Stores the Corrective Action Header information for a given Complaint. |
GHR_COMPL_CLAIMS |
16 | Stores Claim Information for a given Complaint. |
GHR_COMPL_INCIDENTS |
13 | Stores Incident Information for a given Basis. |
GHR_COMPL_PEOPLE |
12 | Stores the People associated to a given Complaint. |
GHR_CPDF_TEMP |
255 | GHR_CPDF_TEMP temporarily stores information required to generatevarious CPDF reports. |
GHR_DUAL_ACTIONS |
9 | Stores First NOAs and all its associated second NOAs that can beprocessed in a dual action. |
GHR_DUAL_PROC_METHODS |
11 | Stores the process method for the first and the second noa codes. |
GHR_DUTY_STATIONS_F |
19 | This table holds information about duty stations. |
GHR_EVENTS |
15 | This table stores various events. |
GHR_EVENT_HISTORY |
13 | It stores various events happening during RPA process and definition of Position. |
GHR_FAMILIES |
16 | GHR_FAMILIES holds information about a family. |
GHR_GROUPBOXES |
11 | Groupboxes defined to be used by workflow |
GHR_GROUPBOX_USERS |
14 | Defines the members of the Groupbox |
GHR_INTERFACE |
185 | This is a genreal purpose table for various interfaces with Federal HRsystem. |
GHR_LOCALITY_PAY_AREAS_F |
15 | This table stores information about locality pay areas. |
GHR_MASS_ACTIONS_PREVIEW |
117 | This table is used to show the Employee/Position detail to the user based on the selection criteria |
GHR_MASS_AWARDS |
11 | Used to store the details of the Mass Award |
GHR_MASS_AWARD_CRITERIA_COLS |
10 | Used to store the Selection Criteria items used in Mass Awards |
GHR_MASS_AWARD_CRITERIA_VALS |
11 | Used to store the values for the selection criteria in the Mass Awards |
GHR_MASS_REALIGNMENT |
38 | This table is used to store criteria for mass realignment. |
GHR_MASS_SALARIES |
37 | This table stores the criteria and status for mass salary action. |
GHR_MASS_SALARY_CRITERIA |
10 | Thsi table stores the additional criteria for a mass salary action. |
GHR_MASS_SALARY_CRITERIA_EXT |
9 | |
GHR_MASS_TRANSFERS |
30 | This table stores the additional criteria for a mass transfer action. |
GHR_MASS_TRANSFER_CRITERIA |
8 | This table stores the additional criteria for a mass transfer action. |
GHR_MTS_TEMP |
10 | Table Used for MTS |
GHR_NATURE_OF_ACTIONS |
14 | This table holds a list of nature of action codes. |
GHR_NOAC_LAS |
15 | Stores NOA and the associated Legal Authorities |
GHR_NOAC_REMARKS |
14 | Stores NOA and the associated Remarks |
GHR_NOA_FAMILIES |
11 | Stores Families and associated NOAs |
GHR_NOA_FAM_PROC_METHODS |
14 | This table is intersection between families and personnel actions. |
GHR_PAYROLL |
11 | This table is used by payroll interface to get data for SF113A report. |
GHR_PAY_PLANS |
11 | Defines the Pay Plans |
GHR_PAY_PLAN_WAITING_PERIODS |
10 | Defines the waiting period of the Pay Plans |
GHR_PA_DATA_FIELDS |
15 | This table holds the fields that are available on the request for personnel action form and the extra information. |
GHR_PA_HISTORY |
216 | Stores the history of all the transations performed on certain tables. |
GHR_PA_INTERFACE_ERR_DTLS |
31 | |
GHR_PA_REMARKS |
16 | Stores Remark codes for the Personnel Action |
GHR_PA_REQUESTS |
234 | Stores all the information about the Request to Personnel Action. |
GHR_PA_REQUEST_EI_SHADOW |
38 | Stores all the columns of the corresponding record ofGHR_PA_REQUEST_EXTRA_INFO. |
GHR_PA_REQUEST_EXTRA_INFO |
65 | Stores additional information based on information types. |
GHR_PA_REQUEST_INFO_TYPES |
17 | Defines information types to be used in Extra Information. |
GHR_PA_REQUEST_SHADOW |
62 | Stores all the columns of the corresponding record of GHR_PA_REQUESTS. |
GHR_PA_ROUTING_HISTORY |
31 | Routing History details of the PA Request |
GHR_PD_CLASSIFICATIONS |
13 | Classification details of a Position Description. |
GHR_PD_ROUTING_HISTORY |
26 | Routing History details of Position Description |
GHR_PERF_CERT |
16 | Performance Certification table |
GHR_PLAN_SERVICE_AREAS_F |
12 | Stores information about the health plan availability in the particular state or duty station. |
GHR_POIS |
17 | Contains information related to Personnel Office Identifier |
GHR_POSITION_DESCRIPTIONS |
54 | Federal Position Description details |
GHR_POS_INTERFACE_ERR_DTLS |
31 | |
GHR_PREMIUM_PAY_INDICATORS |
13 | It holds a list of premium pay indicators. |
GHR_PROCESS_LOG |
10 | It contains log information about various batch process. |
GHR_REMARKS |
13 | It holds a list of remarks that are used to enter against arequest for personnel action. |
GHR_RESTRICTED_PROC_METHODS |
12 | It is intersection between a restricted form and personel actiondata fields |
GHR_RIF_CRITERIA |
14 | It holds the criteria used to retrieve people to producea reduction in force (RIF) register. |
GHR_RIF_REGISTERS |
63 | It is a temporary table used to list the people whomatch the criteria. |
GHR_ROUTING_GROUPS |
8 | Routing Group information |
GHR_ROUTING_LISTS |
9 | Routing List details |
GHR_ROUTING_LIST_MEMBERS |
10 | Routing List members detail |