PQH — Public Sector HR
124 documented tables · 69 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
PQH_TABLE_ROUTE |
Table information for dynamic queries | hub |
PQH_TRANSACTION_CATEGORIES |
Setup information to allow selective routing of transactions | hub |
PQH_ATTRIBUTES |
ATTRIBUTE stores the information about attributes being used in transactions. | hub |
PQH_BUDGETS |
Stores information on budgets | satellite-leaning |
PQH_DFLT_BUDGET_SETS |
Grouping of elements and funding sources | hub-leaning |
PQH_POSITION_TRANSACTIONS |
POSITION_TRANSACTION is used to maintain and create positions. Each transaction needs to be approved by pre-id | hub |
PQH_BUDGET_VERSIONS |
Budget for a date range | hub-leaning |
PQH_DE_WRKPLC_VLDTN_VERS |
DE - Workplace Validation Versions | hub-leaning |
PQH_COPY_ENTITY_TXNS |
Batch details for Mass Processes | satellite-leaning |
PQH_TEMPLATES |
Position control data security | hub |
PQH_ROLES |
Roles used for position control workflow and security | hub |
PQH_FR_VALIDATIONS |
Table that keeps the details regarding the validations available for a person. | hub-leaning |
PQH_RULE_SETS |
Set of one or more configurable business rule | satellite-leaning |
PQH_COPY_ENTITY_CONTEXTS |
Adjusting Display/criteria/change to Application/Legislation/Responsibility | hub-leaning |
PQH_CRITERIA_RATE_DEFN |
Table to store different criteria rate definitions. | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
PQH_COPY_ENTITY_TXNS_API |
API | 3 | 7 packages |
PQH_BUDGET_DETAILS_API |
API | 3 | 6 packages |
PQH_PROCESS_LOG_API |
API | 3 | 5 packages |
PQH_BUDGET_FUND_SRCS_API |
API | 3 | 4 packages |
PQH_WORKSHEET_DETAILS_API |
API | 4 | 4 packages |
PQH_BUDGET_SETS_API |
API | 3 | 4 packages |
PQH_BUDGET_PERIODS_API |
API | 3 | 4 packages |
PQH_BUDGET_ELEMENTS_API |
API | 3 | 4 packages |
PQH_BUDGETS_API |
API | 3 | 4 packages |
PQH_BUDGET_VERSIONS_API |
API | 3 | 4 packages |