PQH Tables (124)

PQH - Public Sector HR — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
PQH_ACCOMMODATIONS_F 99 Information Related to Accomodation
PQH_ASSIGN_ACCOMMODATIONS_F 85 Information Related to Accomodation Assigned
PQH_ATTRIBUTES 21 ATTRIBUTE stores the information about attributes being used in transactions.
PQH_ATTRIBUTES_TL 10 Attribute information used in transactions. Stores translated values.
PQH_ATTRIBUTE_RANGES 23 PQH_ATTRIBUTE_RANGES stores routing / authorization rules for transaction categories.
PQH_BDGT_CMMTMNT_ELMNTS 17 Elements for computing commitments for a budget
PQH_BDGT_POOL_REALLOCTIONS 18 Resource reallocation information for position
PQH_BDGT_POOL_REALLOCTIONS_EFC 5 This is a Copy of PQH_BDGT_POOL_REALLOCATIONS table populated by EFC (Euro as functinoal currency) process.
PQH_BUDGETS 32 Stores information on budgets
PQH_BUDGETS_EFC 3 This is a Copy of PQH_BUDGETS table populated by EFC (Euro as functinoal currency) process.
PQH_BUDGET_DETAILS 26 Budget Details for hr entities
PQH_BUDGET_DETAILS_EFC 9 This is a Copy of PQH_BUDGET_DETAILS table populated by EFC (Euro as functinoal currency) process.
PQH_BUDGET_ELEMENTS 10 Element wise distribution of budget
PQH_BUDGET_FUND_SRCS 15 Budget Cost Allocation information
PQH_BUDGET_GL_FLEX_MAPS 10 Mapping Cost allocation with GL code combinations
PQH_BUDGET_PERIODS 22 Period details for budget
PQH_BUDGET_PERIODS_EFC 9 This is a Copy of PQH_BUDGET_PERIODS table populated by EFC (Euro as functinoal currency) process.
PQH_BUDGET_POOLS 15 Reallocation pool for a budget version and for a specific budget mesurement unit
PQH_BUDGET_SETS 21 Grouping of elements with default distribution
PQH_BUDGET_SETS_EFC 9 This is a Copy of PQH_BUDGET_SETS table populated by EFC (Euro as functinoal currency) process.
PQH_BUDGET_VERSIONS 21 Budget for a date range
PQH_BUDGET_VERSIONS_EFC 9 This is a Copy of PQH_BUDGET_VERSIONS table populated by EFC (Euro as functinoal currency) process.
PQH_COPY_ENTITY_ATTRIBS 43 Criteria and Change list for mass process functionality is stored
PQH_COPY_ENTITY_CONTEXTS 12 Adjusting Display/criteria/change to Application/Legislation/Responsibility
PQH_COPY_ENTITY_FUNCTIONS 14 For a context Pre / Post and event functions for table is listed
PQH_COPY_ENTITY_PREFS 10 User preference of including dependent entity associated with the transaction
PQH_COPY_ENTITY_RESULTS 208 Transaction entity which holds process data
PQH_COPY_ENTITY_TXNS 21 Batch details for Mass Processes
PQH_CORPS_DEFINITIONS 95 Corp Definition
PQH_CORPS_EXTRA_INFO 71 Corp Extra Information details
PQH_CORPS_INFO_TYPES 12 Corp Extra Information Types
PQH_CRITERIA_RATE_DEFN 55 Table to store different criteria rate definitions.
PQH_CRITERIA_RATE_DEFN_TL 10 Table to store translatable information for a criteria rate definition.
PQH_CRITERIA_RATE_ELEMENTS 13 Define elements that take their rate value from a criteria rate definition.
PQH_CRITERIA_RATE_FACTORS 13 This is a child table of pqh_criteria_rate_defn table. Values will exist in this table if the rate_calculation_method of a criteria rate def
PQH_DE_CASE_GROUPS 21 De - Case Groups
PQH_DE_INS_END_REASONS 12
PQH_DE_LEVEL_CODES 11 DE - Level Codes
PQH_DE_LEVEL_NUMBERS 9 DE - Level Numbers
PQH_DE_OPERATIONS 9 DE - Operations
PQH_DE_RESULT_SETS 10 DE - Result Sets
PQH_DE_TATIGKEIT_DETAILS 9 DE - Tatigkeit Details
PQH_DE_WRKPLC_VLDTNS 11 DE - Workplace Validations
PQH_DE_WRKPLC_VLDTN_JOBFTRS 11 DE - Workplace Validation jobfeatures
PQH_DE_WRKPLC_VLDTN_JOBS 11 DE - Workplace Validation jobdetails
PQH_DE_WRKPLC_VLDTN_LVLNUMS 11 DE - Workplace Validation Level Numbers
PQH_DE_WRKPLC_VLDTN_OPS 12 DE - Workplace Validation operations
PQH_DE_WRKPLC_VLDTN_VERS 22 DE - Workplace Validation Versions
PQH_DFLT_BUDGET_ELEMENTS 10 Budget elements for the budget set
PQH_DFLT_BUDGET_SETS 9 Grouping of elements and funding sources
PQH_DFLT_FUND_SRCS 15 Cost allocation information for budget elements
PQH_DOCUMENTS_F 18 Document management Table; for mainly for self service pdf print
PQH_DOCUMENT_ATTRIBUTES_F 12 Mapping attributes of document with known transaction attributes
PQH_ELEMENT_COMMITMENTS 13 Element Commitment for a specific period
PQH_ELEMENT_COMMITMENTS_EFC 4 This is a Copy of PQH_ELEMENT_COMMITMENTS table populated by EFC (Euro as functinoal currency) process.
PQH_FR_EMP_STAT_SITUATIONS 52 Holds the statutory situations for a civil servant in French Public Sector
PQH_FR_GLOBAL_INDICES_F 15 French global Indices
PQH_FR_STAT_SITUATIONS 38 Stores details on Statutory Situations
PQH_FR_STAT_SITUATION_RULES 15 Stores details on Statutory Situation Criteria
PQH_FR_VALIDATIONS 23 Table that keeps the details regarding the validations available for a person.
PQH_FR_VALIDATION_EVENTS 13 Table that keeps the details regarding the events for a particular validations.
PQH_FR_VALIDATION_PERIODS 19 Table that keeps the period details for a particular validation of an individual
PQH_FYI_NOTIFY 14 FYI Notification Details
PQH_GL_INTERFACE 24 Interface entity containing budget and commitment information used to post to GL
PQH_GL_INTERFACE_EFC 5 This is a Copy of PQH_GL_INTERFACE table populated by EFC (Euro as functinoal currency) process.
PQH_GMS_EXCESS 14
PQH_PA_WHATIF_RESULTS 29 Stores the comparative results of the current and the ?What If? benefits.
PQH_POSITION_TRANSACTIONS 149 POSITION_TRANSACTION is used to maintain and create positions. Each transaction needs to be approved by pre-identified approvers. On approva
PQH_PROCESS_LOG 48 Log table
PQH_PTE_SHADOW 62 Copy of the Position Transaction Table. This is used for position transaction refresh.
PQH_PTX_DPF_DF 30 Deployment factors for Position Transaction records are stored until the transaction is applied to PER_DEPLOYMENT_FACTORS
PQH_PTX_DPF_DF_SHADOW 30 Deployment factors shadow for Position Transaction
PQH_PTX_EXTRA_INFO 62 Extra information details for Position transaction.
PQH_PTX_INFO_TYPES 12 Internal Use
PQH_PTX_SHADOW 147 Position Extra information shadow used for refreshing position transaction extra information.
PQH_RATE_ELEMENT_RELATIONS 14 Rate Element Relations
PQH_RATE_FACTOR_ON_ELMNTS 14 Table to store information about where rate factors values used to calculate a criteria rate definition must be recorded on a element
PQH_RATE_MATRIX_NODES 17 Table to store the nodes in a rate matrix hierarchy
PQH_RATE_MATRIX_RATES_F 18 Datetracked table to store the rate value associated with each node in a rate matrix hierarchy.
PQH_REF_TEMPLATES 11 Lists copy and reference templates for a template
PQH_ROLES 42 Roles used for position control workflow and security
PQH_ROLE_EXTRA_INFO 75
PQH_ROLE_INFO_TYPES 16
PQH_ROLE_TEMPLATES 11 Tempalte for a transaction category attached to a role
PQH_ROUTING_CATEGORIES 17 Transaction Routing Information
PQH_ROUTING_HISTORY 28 Keeps track of each hop during the routing / approver process. It also has some pre-identified attributes stored with new values
PQH_ROUTING_HIST_ATTRIBS 19 Attribute values for each step of routing
PQH_ROUTING_LISTS 9 Routing list used for position controlled workflow
PQH_ROUTING_LIST_MEMBERS 13 Roles and role users that constitute the routing list
PQH_RT_MATRIX_NODE_VALUES 24 Table to store criteria values for a particular rate matrix node.
PQH_RULES 12 Configurable business rules
PQH_RULE_ATTRIBUTES 11 Details regarding the attributes for which the rule is mapped is stored.
PQH_RULE_SETS 20 Set of one or more configurable business rule
PQH_RULE_SETS_TL 11 Translated Rule set information
PQH_SITUATIONS 79 Situation Information
PQH_SPECIAL_ATTRIBUTES 16 Identifies attributes with special functions
PQH_SS_APPROVAL_HISTORY 17 Self Service Transaction History - Approval History
PQH_SS_PRINT_DATA 10 Temporary table to hold value for SS pdf printing
PQH_SS_PRINT_LABEL_TEMP 12 Temporary Table to process Document Labels for display on Doc Management
PQH_SS_STEP_HISTORY 54 Self Service Transaction History - Step History
PQH_SS_TRANSACTION_HISTORY 19 Self Service Transaction History - Transaction History
PQH_SS_VALUE_HISTORY 12 Self Service Transaction History - Item Value History
PQH_TABLE_ROUTE 17 Table information for dynamic queries
PQH_TABLE_ROUTE_TL 10 Translated Table Information
PQH_TEMPLATES 18 Position control data security
PQH_TEMPLATES_TL 10 Translation for Templates
PQH_TEMPLATE_ATTRIBUTES 13 List of attributes and their security level that are defined for a template
PQH_TJR_SHADOW 41 Transaction Job Requirements Shadow Table
PQH_TRANSACTION_CATEGORIES 27 Setup information to allow selective routing of transactions
PQH_TRANSACTION_CATEGORIES_TL 10 Transalation for Transaction Category
PQH_TRANSACTION_TEMPLATES 11 Task templates which determines the type/security of a transaction is stored here
PQH_TXN_CATEGORY_ATTRIBUTES 20 Intersection entity between transaction category and table attributes
PQH_TXN_CATEGORY_DOCUMENTS 9 Intersection entity between transaction category and documents. Also hold the type associated with the document in the transaction category
PQH_TXN_JOB_REQUIREMENTS 41 Transaction table for per_job_requirements ( part of position control )
PQH_WIZARD_CANVASES 21 Store Navigational details for Wizard forms
PQH_WORKSHEETS 18 Transaction data for working on budget version
PQH_WORKSHEET_BDGT_ELMNTS 10 Element wise distribution of measurement units
PQH_WORKSHEET_BUDGET_SETS 21 Budget set wise distribution of worksheet
PQH_WORKSHEET_BUDGET_SETS_EFC 9 This is a Copy of PQH_WORKSHEET_BUDGET_SETS table populated by EFC (Euro as functinoal currency) process.
PQH_WORKSHEET_DETAILS 35 Work table of Hr entities for Budget information
PQH_WORKSHEET_DETAILS_EFC 9 This is a Copy of PQH_WORKSHEET_DETAILS table populated by EFC (Euro as functinoal currency) process.
PQH_WORKSHEET_FUND_SRCS 15 cost allocation for the budget element
PQH_WORKSHEET_PERIODS 23 Period wise details of transaction data for budget version
PQH_WORKSHEET_PERIODS_EFC 9 This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process.