GHR — US Federal Human Resources
69 documented tables · 53 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
GHR_PAY_PLANS |
Defines the Pay Plans | hub |
GHR_ROUTING_GROUPS |
Routing Group information | hub-leaning |
GHR_COMPLAINTS2 |
GHR_COMPLAINTS2 table is a master table containing complaint details from various persons in the system. | hub-leaning |
GHR_PA_REQUESTS |
Stores all the information about the Request to Personnel Action. | hub |
GHR_NATURE_OF_ACTIONS |
This table holds a list of nature of action codes. | hub |
GHR_FAMILIES |
GHR_FAMILIES holds information about a family. | hub |
GHR_GROUPBOXES |
Groupboxes defined to be used by workflow | hub |
GHR_COMPLAINTS |
GHR_COMPLAINTS holds information for processing a complaint. | hub-leaning |
GHR_COMPL_CLAIMS |
Stores Claim Information for a given Complaint. | hub-leaning |
GHR_POIS |
Contains information related to Personnel Office Identifier | hub |
GHR_PA_DATA_FIELDS |
This table holds the fields that are available on the request for personnel action form and the extra informat | hub-leaning |
GHR_ROUTING_LISTS |
Routing List details | hub-leaning |
GHR_BREAKDOWN_CRITERIA |
Holds the criteria used to run the breakdown report. | hub-leaning |
GHR_COMPL_CA_HEADERS |
Stores the Corrective Action Header information for a given Complaint. | satellite-leaning |
GHR_PA_REQUEST_INFO_TYPES |
Defines information types to be used in Extra Information. | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
GHR_API |
API | 17 | 75 packages |
GHR_HISTORY_API |
API | 15 | 59 packages |
GHR_PA_REMARKS_API |
API | 3 | 14 packages |
GHR_SF52_API |
API | 8 | 11 packages |
GHR_PERSON_EXTRA_INFO_API |
API | 2 | 9 packages |
GHR_PAR_EXTRA_INFO_API |
API | 3 | 9 packages |
GHR_POSITION_EXTRA_INFO_API |
API | 2 | 7 packages |
GHR_ELEMENT_API |
API | 2 | 5 packages |
GHR_POSITION_API |
API | 2 | 1 packages |
GHR_PDH_API |
API | 1 | 1 packages |