Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - PQH Tables and Views

TABLE - HR.PQH_ACCOMMODATIONS_F

TABLE - HR.PQH_ASSIGN_ACCOMMODATIONS_F

TABLE - HR.PQH_ATTRIBUTES

TABLE - HR.PQH_ATTRIBUTES_TL

TABLE - HR.PQH_ATTRIBUTE_RANGES

TABLE - HR.PQH_BDGT_CMMTMNT_ELMNTS

TABLE - HR.PQH_BDGT_POOL_REALLOCTIONS

TABLE - HR.PQH_BDGT_POOL_REALLOCTIONS_EFC

TABLE - HR.PQH_BUDGETS

TABLE - HR.PQH_BUDGETS_EFC

TABLE - HR.PQH_BUDGET_DETAILS

TABLE - HR.PQH_BUDGET_DETAILS_EFC

TABLE - HR.PQH_BUDGET_ELEMENTS

TABLE - HR.PQH_BUDGET_FUND_SRCS

TABLE - HR.PQH_BUDGET_GL_FLEX_MAPS

TABLE - HR.PQH_BUDGET_PERIODS

TABLE - HR.PQH_BUDGET_PERIODS_EFC

TABLE - HR.PQH_BUDGET_POOLS

TABLE - HR.PQH_BUDGET_SETS

TABLE - HR.PQH_BUDGET_SETS_EFC

TABLE - HR.PQH_BUDGET_VERSIONS

TABLE - HR.PQH_BUDGET_VERSIONS_EFC

TABLE - HR.PQH_COPY_ENTITY_ATTRIBS

TABLE - HR.PQH_COPY_ENTITY_CONTEXTS

TABLE - HR.PQH_COPY_ENTITY_FUNCTIONS

TABLE - HR.PQH_COPY_ENTITY_PREFS

TABLE - HR.PQH_COPY_ENTITY_RESULTS

TABLE - HR.PQH_COPY_ENTITY_TXNS

TABLE - HR.PQH_CORPS_DEFINITIONS

TABLE - HR.PQH_CORPS_EXTRA_INFO

TABLE - HR.PQH_CORPS_INFO_TYPES

TABLE - HR.PQH_CRITERIA_RATE_DEFN

TABLE - HR.PQH_CRITERIA_RATE_DEFN_TL

TABLE - HR.PQH_CRITERIA_RATE_ELEMENTS

TABLE - HR.PQH_CRITERIA_RATE_FACTORS

TABLE - HR.PQH_DE_CASE_GROUPS

TABLE - HR.PQH_DE_INS_END_REASONS

TABLE - HR.PQH_DE_LEVEL_CODES

TABLE - HR.PQH_DE_LEVEL_NUMBERS

TABLE - HR.PQH_DE_OPERATIONS

TABLE - HR.PQH_DE_RESULT_SETS

TABLE - HR.PQH_DE_TATIGKEIT_DETAILS

TABLE - HR.PQH_DE_WRKPLC_VLDTNS

TABLE - HR.PQH_DE_WRKPLC_VLDTN_JOBFTRS

TABLE - HR.PQH_DE_WRKPLC_VLDTN_JOBS

TABLE - HR.PQH_DE_WRKPLC_VLDTN_LVLNUMS

TABLE - HR.PQH_DE_WRKPLC_VLDTN_OPS

TABLE - HR.PQH_DE_WRKPLC_VLDTN_VERS

TABLE - HR.PQH_DFLT_BUDGET_ELEMENTS

TABLE - HR.PQH_DFLT_BUDGET_SETS

TABLE - HR.PQH_DFLT_FUND_SRCS

TABLE - HR.PQH_DOCUMENTS_F

TABLE - HR.PQH_DOCUMENT_ATTRIBUTES_F

TABLE - HR.PQH_ELEMENT_COMMITMENTS

TABLE - HR.PQH_ELEMENT_COMMITMENTS_EFC

TABLE - HR.PQH_FR_EMP_STAT_SITUATIONS

TABLE - HR.PQH_FR_GLOBAL_INDICES_F

TABLE - HR.PQH_FR_STAT_SITUATIONS

TABLE - HR.PQH_FR_STAT_SITUATION_RULES

TABLE - HR.PQH_FR_VALIDATIONS

TABLE - HR.PQH_FR_VALIDATION_EVENTS

TABLE - HR.PQH_FR_VALIDATION_PERIODS

TABLE - HR.PQH_FYI_NOTIFY

TABLE - HR.PQH_GL_INTERFACE

TABLE - HR.PQH_GL_INTERFACE_EFC

TABLE - HR.PQH_GMS_EXCESS

TABLE - HR.PQH_PA_WHATIF_RESULTS

TABLE - HR.PQH_POSITION_TRANSACTIONS

TABLE - HR.PQH_PROCESS_LOG

TABLE - HR.PQH_PTE_SHADOW

TABLE - HR.PQH_PTX_DPF_DF

TABLE - HR.PQH_PTX_DPF_DF_SHADOW

TABLE - HR.PQH_PTX_EXTRA_INFO

TABLE - HR.PQH_PTX_INFO_TYPES

TABLE - HR.PQH_PTX_SHADOW

TABLE - HR.PQH_RATE_ELEMENT_RELATIONS

TABLE - HR.PQH_RATE_FACTOR_ON_ELMNTS

TABLE - HR.PQH_RATE_MATRIX_NODES

TABLE - HR.PQH_RATE_MATRIX_RATES_F

TABLE - HR.PQH_REF_TEMPLATES

TABLE - HR.PQH_ROLES

TABLE - HR.PQH_ROLE_EXTRA_INFO

TABLE - HR.PQH_ROLE_INFO_TYPES

TABLE - HR.PQH_ROLE_TEMPLATES

TABLE - HR.PQH_ROUTING_CATEGORIES

TABLE - HR.PQH_ROUTING_HISTORY

TABLE - HR.PQH_ROUTING_HIST_ATTRIBS

TABLE - HR.PQH_ROUTING_LISTS

TABLE - HR.PQH_ROUTING_LIST_MEMBERS

TABLE - HR.PQH_RT_MATRIX_NODE_VALUES

TABLE - HR.PQH_RULES

TABLE - HR.PQH_RULE_ATTRIBUTES

TABLE - HR.PQH_RULE_SETS

TABLE - HR.PQH_RULE_SETS_TL

TABLE - HR.PQH_SITUATIONS

TABLE - HR.PQH_SPECIAL_ATTRIBUTES

TABLE - HR.PQH_SS_APPROVAL_HISTORY

TABLE - HR.PQH_SS_PRINT_DATA

TABLE - HR.PQH_SS_PRINT_LABEL_TEMP

TABLE - HR.PQH_SS_STEP_HISTORY

TABLE - HR.PQH_SS_TRANSACTION_HISTORY

TABLE - HR.PQH_SS_VALUE_HISTORY

TABLE - HR.PQH_TABLE_ROUTE

TABLE - HR.PQH_TABLE_ROUTE_TL

TABLE - HR.PQH_TEMPLATES

TABLE - HR.PQH_TEMPLATES_TL

TABLE - HR.PQH_TEMPLATE_ATTRIBUTES

TABLE - HR.PQH_TJR_SHADOW

TABLE - HR.PQH_TRANSACTION_CATEGORIES

TABLE - HR.PQH_TRANSACTION_CATEGORIES_TL

TABLE - HR.PQH_TRANSACTION_TEMPLATES

TABLE - HR.PQH_TXN_CATEGORY_ATTRIBUTES

TABLE - HR.PQH_TXN_CATEGORY_DOCUMENTS

TABLE - HR.PQH_TXN_JOB_REQUIREMENTS

TABLE - HR.PQH_WIZARD_CANVASES

TABLE - HR.PQH_WORKSHEETS

TABLE - HR.PQH_WORKSHEET_BDGT_ELMNTS

TABLE - HR.PQH_WORKSHEET_BUDGET_SETS

TABLE - HR.PQH_WORKSHEET_BUDGET_SETS_EFC

TABLE - HR.PQH_WORKSHEET_DETAILS

TABLE - HR.PQH_WORKSHEET_DETAILS_EFC

TABLE - HR.PQH_WORKSHEET_FUND_SRCS

TABLE - HR.PQH_WORKSHEET_PERIODS

TABLE - HR.PQH_WORKSHEET_PERIODS_EFC

VIEW - APPS.PQH_ATTRIBUTES_VL

VIEW - APPS.PQH_ATTRIBUTE_RANGES_V1

VIEW - APPS.PQH_ATTRIBUTE_RANGES_V2

VIEW - APPS.PQH_ATTRIBUTE_RANGES_V3

VIEW - APPS.PQH_ATTRIBUTE_RANGES_V4

VIEW - APPS.PQH_BDGT_CMMTMNT_ELMNTS_V

VIEW - APPS.PQH_BDGT_POOL_REALLOCTIONS_V

VIEW - APPS.PQH_BDGT_REALLOC_FOLDERS_V

VIEW - APPS.PQH_BUDGETS_V

VIEW - APPS.PQH_BUDGET_DETAILS_V

VIEW - APPS.PQH_BUDGET_POOLS_V

VIEW - APPS.PQH_CMMTMNT_ENTITIES_V

VIEW - APPS.PQH_COPY_ENTITY_CONTEXTS_V

VIEW - APPS.PQH_COPY_ENTITY_POSITIONS_V

VIEW - APPS.PQH_COPY_ENTITY_POSUPD_V

VIEW - APPS.PQH_COPY_ENTITY_PREFS_V

VIEW - APPS.PQH_CORPS_CAREER_PATHS_V

VIEW - APPS.PQH_CORPS_DEFINITIONS_V

VIEW - APPS.PQH_CORPS_DOCUMENTS_V

VIEW - APPS.PQH_CORPS_EXAMS_V

VIEW - APPS.PQH_CORPS_FILERES_V

VIEW - APPS.PQH_CORPS_GRADES_V

VIEW - APPS.PQH_CORPS_NATURE_HGRID_V

VIEW - APPS.PQH_CORPS_ORGANIZATIONS_V

VIEW - APPS.PQH_CORPS_RULES_V

VIEW - APPS.PQH_CORPS_TRAININGS_V

VIEW - APPS.PQH_DE_CS_GRADES_V

VIEW - APPS.PQH_ENTITY_ELEMENT_TYPES_V

VIEW - APPS.PQH_FR_CAGR_ENTITLEMENTS_V

VIEW - APPS.PQH_FR_STAT_SITUATIONS_V

VIEW - APPS.PQH_INFO_TYPE_SECURITY_RIT_V

VIEW - APPS.PQH_ORGANIZATION_BUDGETS_V

VIEW - APPS.PQH_PC_ORG_HIERARCHIES_V

VIEW - APPS.PQH_PC_ORG_SUMMARY_V

VIEW - APPS.PQH_POSITION_BUDGETS_V

VIEW - APPS.PQH_POSITION_ELEMENT_TYPES_V

VIEW - APPS.PQH_POSITION_EXTRA_INFO_V

VIEW - APPS.PQH_POSITION_ROLES_V

VIEW - APPS.PQH_POSITION_TRANSACTIONS_V

VIEW - APPS.PQH_POSN_CTL_HIERARCHY_V

VIEW - APPS.PQH_PTX_HISTORY_V

VIEW - APPS.PQH_REALLOC_FOLDER_TXN_V

VIEW - APPS.PQH_REALLOC_TXN_DETAILS_V

VIEW - APPS.PQH_REALLOC_TXN_PERIODS_V

VIEW - APPS.PQH_REF_TEMPLATES_V

VIEW - APPS.PQH_ROLES_V

VIEW - APPS.PQH_ROLE_PEOPLE_V

VIEW - APPS.PQH_ROLE_TEMPLATES_V

VIEW - APPS.PQH_ROLE_USERS_V

VIEW - APPS.PQH_ROLE_USERS_V1

VIEW - APPS.PQH_ROUTING_CATEGORIES_V

VIEW - APPS.PQH_ROUTING_HISTORY_V

VIEW - APPS.PQH_ROUTING_HIST_ATTRIBS_V

VIEW - APPS.PQH_ROUTING_LIST_MEMBERS_V

VIEW - APPS.PQH_RULES_V

VIEW - APPS.PQH_RULE_SETS_V

VIEW - APPS.PQH_RULE_SETS_VL

VIEW - APPS.PQH_SPECIAL_ATTRIBUTES_V

VIEW - APPS.PQH_TABLE_ROUTE_VL

VIEW - APPS.PQH_TEMPLATES_V

VIEW - APPS.PQH_TEMPLATES_VL

VIEW - APPS.PQH_TEMPLATE_ATTRIBUTES_V

VIEW - APPS.PQH_TRANSACTIONS_V

VIEW - APPS.PQH_TRANSACTION_CATEGORIES_V

VIEW - APPS.PQH_TRANSACTION_CATEGORIES_VL

VIEW - APPS.PQH_TRANSACTION_TEMPLATES_V

VIEW - APPS.PQH_TXN_CATEGORY_ATTRIBUTES_V

VIEW - APPS.PQH_TXN_JOB_REQUIREMENTS_V

VIEW - APPS.PQH_WORKSHEET_ORGANIZATIONS_V

Table: PQH_ACCOMMODATIONS_F

Primary Key: PQH_ACCOMMODATIONS_F_PK

1. ACCOMMODATION_ID
2. EFFECTIVE_START_DATE
3. EFFECTIVE_END_DATE

Comments

Information Related to Accomodation

Indexes

Columns

[top of page]

HR.PQH_ACCOMMODATIONS_F does not reference any database object

HR.PQH_ACCOMMODATIONS_F is referenced by following:

HR

VIEW - PQH_ACCOMMODATIONS_F#

[top of page]

Table: PQH_ASSIGN_ACCOMMODATIONS_F

Primary Key: PQH_ASSIGN_ACCOMMODATIONS_PK

1. ASSIGNMENT_ACCO_ID
2. EFFECTIVE_START_DATE
3. EFFECTIVE_END_DATE

Comments

Information Related to Accomodation Assigned

Indexes

Columns

[top of page]

HR.PQH_ASSIGN_ACCOMMODATIONS_F does not reference any database object

HR.PQH_ASSIGN_ACCOMMODATIONS_F is referenced by following:

HR

VIEW - PQH_ASSIGN_ACCOMMODATIONS_F#

[top of page]

Table: PQH_ATTRIBUTES

Primary Key: PQH_ATTRIBUTES_PK

1. ATTRIBUTE_ID

Primary Key: PQH_ATTRIBUTES_UK

1. MASTER_TABLE_ROUTE_ID
2. COLUMN_NAME
3. LEGISLATION_CODE

Foreign Keys from this table:

Foreign Keys to this table:

Comments

ATTRIBUTE stores the information about attributes being used in transactions. Each attribute is associated with a template.

Indexes

Columns

[top of page]

HR.PQH_ATTRIBUTES does not reference any database object

HR.PQH_ATTRIBUTES is referenced by following:

HR

VIEW - PQH_ATTRIBUTES#

[top of page]

Table: PQH_ATTRIBUTES_TL

Primary Key: PQH_ATTRIBUTES_TL_PK

1. ATTRIBUTE_ID
2. LANGUAGE

Comments

Attribute information used in transactions. Stores translated values.

Indexes

Columns

[top of page]

HR.PQH_ATTRIBUTES_TL does not reference any database object

HR.PQH_ATTRIBUTES_TL is referenced by following:

HR

VIEW - PQH_ATTRIBUTES_TL#

[top of page]

Table: PQH_ATTRIBUTE_RANGES

Primary Key: PQH_ATTRIBUTE_RANGES_PK

1. ATTRIBUTE_RANGE_ID

Foreign Keys from this table:

Comments

PQH_ATTRIBUTE_RANGES stores routing / authorization rules for transaction categories.

Indexes

Columns

[top of page]

HR.PQH_ATTRIBUTE_RANGES does not reference any database object

HR.PQH_ATTRIBUTE_RANGES is referenced by following:

HR

VIEW - PQH_ATTRIBUTE_RANGES#

[top of page]

Table: PQH_BDGT_CMMTMNT_ELMNTS

Primary Key: PQH_BDGT_CMMTMNT_ELMNTS_PK

1. BDGT_CMMTMNT_ELMNT_ID

Foreign Keys from this table:

Comments

Elements for computing commitments for a budget

Primary Key: PQH_BDGT_CMMTMNT_ELMNTS_PK

1. BDGT_CMMTMNT_ELMNT_ID

Indexes

Columns

[top of page]

HR.PQH_BDGT_CMMTMNT_ELMNTS does not reference any database object

HR.PQH_BDGT_CMMTMNT_ELMNTS is referenced by following:

HR

VIEW - PQH_BDGT_CMMTMNT_ELMNTS#

[top of page]

Table: PQH_BDGT_POOL_REALLOCTIONS

Primary Key: PQH_BDGT_POOL_REALLOCTIONS

1. REALLOCATION_ID

Foreign Keys from this table:

Comments

Resource reallocation information for position

Primary Key: PQH_BDGT_POOL_REALLOCTIONS

1. REALLOCATION_ID

Indexes

Columns

[top of page]

HR.PQH_BDGT_POOL_REALLOCTIONS does not reference any database object

HR.PQH_BDGT_POOL_REALLOCTIONS is referenced by following:

HR

VIEW - PQH_BDGT_POOL_REALLOCTIONS#

[top of page]

Table: PQH_BDGT_POOL_REALLOCTIONS_EFC

Primary Key: PQH_BDGT_POOL_REALLOCT_EFC_PK

1. REALLOCATION_ID
2. EFC_ACTION_ID

Foreign Keys from this table:

Comments

This table only contains subset of columns from the base table. Contains a copy of NCU (National Curency unit) and currency code prior to EFC. This table is only maintainted by the EFC process.

Indexes

Columns

[top of page]

HR.PQH_BDGT_POOL_REALLOCTIONS_EFC does not reference any database object

HR.PQH_BDGT_POOL_REALLOCTIONS_EFC is referenced by following:

HR

VIEW - PQH_BDGT_POOL_REALLOCTIONS_EF#

[top of page]

Table: PQH_BUDGETS

Primary Key: PQH_BUDGETS_PK

1. BUDGET_ID

Primary Key: PQH_BUDGETS_UK

1. BUDGET_NAME

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Stores information on budgets

Primary Key: PQH_BUDGETS_PK

1. BUDGET_ID

Unique Key: PQH_BUDGETS_UK

1. BUDGET_NAME

Indexes

Columns

[top of page]

HR.PQH_BUDGETS does not reference any database object

HR.PQH_BUDGETS is referenced by following:

HR

VIEW - PQH_BUDGETS#

[top of page]

Table: PQH_BUDGETS_EFC

Primary Key: PQH_BUDGETS_EFC_PK

1. BUDGET_ID
2. EFC_ACTION_ID

Foreign Keys from this table:

Comments

This table only contains subset of columns from the base table. Contains a copy of NCU (National Curency unit) and currency code prior to EFC. This table is only maintainted by the EFC process.

Indexes

Columns

[top of page]

HR.PQH_BUDGETS_EFC does not reference any database object

HR.PQH_BUDGETS_EFC is referenced by following:

HR

VIEW - PQH_BUDGETS_EFC#

[top of page]

Table: PQH_BUDGET_DETAILS

Primary Key: PQH_BUDGET_DETAILS_PK

1. BUDGET_DETAIL_ID

Primary Key: PQH_BUDGET_DETAILS_UK

1. BUDGET_VERSION_ID
2. GRADE_ID
3. JOB_ID
4. ORGANIZATION_ID
5. POSITION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Budget Details for hr entities

Primary Key: PQH_BUDGET_DETAILS_PK

1. BUDGET_DETAIL_ID

Indexes

Columns

[top of page]

HR.PQH_BUDGET_DETAILS does not reference any database object

HR.PQH_BUDGET_DETAILS is referenced by following:

HR

VIEW - PQH_BUDGET_DETAILS#

[top of page]

Table: PQH_BUDGET_DETAILS_EFC

Primary Key: PQH_BUDGET_DETAILS_EFC_PK

1. BUDGET_DETAIL_ID
2. EFC_ACTION_ID

Foreign Keys from this table:

Comments

This table only contains subset of columns from the base table. Contains a copy of NCU (National Curency unit) and currency code prior to EFC. This table is only maintainted by the EFC process.

Indexes

Columns

[top of page]

HR.PQH_BUDGET_DETAILS_EFC does not reference any database object

HR.PQH_BUDGET_DETAILS_EFC is referenced by following:

HR

VIEW - PQH_BUDGET_DETAILS_EFC#

[top of page]

Table: PQH_BUDGET_ELEMENTS

Primary Key: PQH_BUDGET_ELEMENTS_PK

1. BUDGET_ELEMENT_ID

Primary Key: PQH_BUDGET_ELEMENTS_UK

1. BUDGET_SET_ID
2. ELEMENT_TYPE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Element wise distribution of budget

Primary Key: PQH_BUDGET_ELEMENTS_PK

1. BUDGET_ELEMENT_ID

Unique Key: PQH_BUDGET_ELEMENTS_UK

1. BUDGET_SET_ID
2. ELEMENT_TYPE_ID

Indexes

Columns

[top of page]

HR.PQH_BUDGET_ELEMENTS does not reference any database object

HR.PQH_BUDGET_ELEMENTS is referenced by following:

HR

VIEW - PQH_BUDGET_ELEMENTS#

[top of page]

Table: PQH_BUDGET_FUND_SRCS

Primary Key: PQH_BUDGET_FUND_SRCS_PK

1. BUDGET_FUND_SRC_ID

Primary Key: PQH_BUDGET_FUND_SRCS_UK

1. BUDGET_ELEMENT_ID
2. COST_ALLOCATION_KEYFLEX_ID

Foreign Keys from this table:

Comments

Budget Cost Allocation information

Primary Key: PQH_BUDGET_FUND_SRCS_PK

1. BUDGET_FUND_SRC_ID

Indexes

Columns

[top of page]

HR.PQH_BUDGET_FUND_SRCS does not reference any database object

HR.PQH_BUDGET_FUND_SRCS is referenced by following:

HR

VIEW - PQH_BUDGET_FUND_SRCS#

[top of page]

Table: PQH_BUDGET_GL_FLEX_MAPS

Primary Key: PQH_BUDGET_GL_FLEX_MAPS_PK

1. BUDGET_GL_FLEX_MAP_ID

Comments

Mapping Cost allocation with GL code combinations

Primary Key: PQH_BUDGET_GL_FLEX_MAPS_PK

1. BUDGET_GL_FLEX_MAP_ID

Indexes

Columns

[top of page]

HR.PQH_BUDGET_GL_FLEX_MAPS does not reference any database object

HR.PQH_BUDGET_GL_FLEX_MAPS is referenced by following:

HR

VIEW - PQH_BUDGET_GL_FLEX_MAPS#

[top of page]

Table: PQH_BUDGET_PERIODS

Primary Key: PQH_BUDGET_PERIODS_PK

1. BUDGET_PERIOD_ID

Primary Key: PQH_BUDGET_PERIODS_UK

1. BUDGET_DETAIL_ID
2. END_TIME_PERIOD_ID
3. START_TIME_PERIOD_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Period details for budget

Primary Key: PQH_BUDGET_PERIODS_PK

1. BUDGET_PERIOD_ID

Unique Key: PQH_BUDGET_PERIODS_UK

1. BUDGET_DETAIL_ID
2. START_TIME_PERIOD_ID
3. END_TIME_PERIOD_ID

Indexes

Columns

[top of page]

HR.PQH_BUDGET_PERIODS does not reference any database object

HR.PQH_BUDGET_PERIODS is referenced by following:

HR

VIEW - PQH_BUDGET_PERIODS#

[top of page]

Table: PQH_BUDGET_PERIODS_EFC

Primary Key: PQH_BUDGET_PERIODS_EFC_PK

1. BUDGET_PERIOD_ID
2. EFC_ACTION_ID

Foreign Keys from this table:

Comments

This table only contains subset of columns from the base table. Contains a copy of NCU (National Curency unit) and currency code prior to EFC. This table is only maintainted by the EFC process.

Indexes

Columns

[top of page]

HR.PQH_BUDGET_PERIODS_EFC does not reference any database object

HR.PQH_BUDGET_PERIODS_EFC is referenced by following:

HR

VIEW - PQH_BUDGET_PERIODS_EFC#

[top of page]

Table: PQH_BUDGET_POOLS

Primary Key: PQH_BUDGET_POOLS_PK

1. POOL_ID

Primary Key: PQH_BUDGET_POOLS_UK1

1. BUDGET_UNIT_ID
2. BUDGET_VERSION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Reallocation pool for a budget version and for a specific budget mesurement unit

Primary Key: PQH_BUDGET_POOLS_PK

1. POOL_ID

Indexes

Columns

[top of page]

HR.PQH_BUDGET_POOLS does not reference any database object

HR.PQH_BUDGET_POOLS is referenced by following:

HR

VIEW - PQH_BUDGET_POOLS#

[top of page]

Table: PQH_BUDGET_SETS

Primary Key: PQH_BUDGET_SETS_PK

1. BUDGET_SET_ID

Primary Key: PQH_BUDGET_SETS_UK

1. DFLT_BUDGET_SET_ID
2. BUDGET_PERIOD_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Grouping of elements with default distribution

Primary Key: PQH_BUDGET_SETS_PK

1. BUDGET_SET_ID

Unique Key: PQH_BUDGET_SETS_UK

1. DFLT_BUDGET_SET_ID
2. BUDGET_PERIOD_ID

Indexes

Columns

[top of page]

HR.PQH_BUDGET_SETS does not reference any database object

HR.PQH_BUDGET_SETS is referenced by following:

HR

VIEW - PQH_BUDGET_SETS#

[top of page]

Table: PQH_BUDGET_SETS_EFC

Primary Key: PQH_BUDGET_SETS_EFC_PK

1. BUDGET_SET_ID

Comments

This table only contains subset of columns from the base table. Contains a copy of NCU (National Curency unit) and currency code prior to EFC. This table is only maintainted by the EFC process.

Columns

[top of page]

HR.PQH_BUDGET_SETS_EFC does not reference any database object

HR.PQH_BUDGET_SETS_EFC is referenced by following:

HR

VIEW - PQH_BUDGET_SETS_EFC#

[top of page]

Table: PQH_BUDGET_VERSIONS

Primary Key: PQH_BUDGET_VERSIONS_PK

1. BUDGET_VERSION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Budget for a date range

Primary Key: PQH_BUDGET_VERSIONS_PK

1. BUDGET_VERSION_ID

Indexes

Columns

[top of page]

HR.PQH_BUDGET_VERSIONS does not reference any database object

HR.PQH_BUDGET_VERSIONS is referenced by following:

HR

VIEW - PQH_BUDGET_VERSIONS#

[top of page]

Table: PQH_BUDGET_VERSIONS_EFC

Primary Key: PQH_BUDGET_VERSIONS_EFC_PK

1. BUDGET_VERSION_ID
2. EFC_ACTION_ID

Foreign Keys from this table:

Comments

This table only contains subset of columns from the base table. Contains a copy of NCU (National Curency unit) and currency code prior to EFC. This table is only maintainted by the EFC process.

Indexes

Columns

[top of page]

HR.PQH_BUDGET_VERSIONS_EFC does not reference any database object

HR.PQH_BUDGET_VERSIONS_EFC is referenced by following:

HR

VIEW - PQH_BUDGET_VERSIONS_EFC#

[top of page]

Table: PQH_COPY_ENTITY_ATTRIBS

Primary Key: PQH_COPY_ENTITY_ATTRIBS_PK

1. COPY_ENTITY_ATTRIB_ID

Foreign Keys from this table:

Comments

PQH_COPY_ENTITY_ATTRIB stores criteria and change list for mass process functionality.

Primary Key: PQH_COPY_ENTITY_ATTRIBS_PK

1. COPY_ENTITY_ATTRIB_ID

Indexes

Columns

[top of page]

HR.PQH_COPY_ENTITY_ATTRIBS does not reference any database object

HR.PQH_COPY_ENTITY_ATTRIBS is referenced by following:

HR

VIEW - PQH_COPY_ENTITY_ATTRIBS#

[top of page]

Table: PQH_COPY_ENTITY_CONTEXTS

Primary Key: PQH_COPY_ENTITY_CONTEXTS_PK

1. CONTEXT

Primary Key: PQH_COPY_ENTITY_CONTEXTS_UK

1. APPLICATION_SHORT_NAME
2. LEGISLATION_CODE
3. RESPONSIBILITY_KEY

Foreign Keys to this table:

Comments

Adjusting Display/criteria/change to Application/Legislation/Responsibility

Indexes

Columns

[top of page]

HR.PQH_COPY_ENTITY_CONTEXTS does not reference any database object

HR.PQH_COPY_ENTITY_CONTEXTS is referenced by following:

HR

VIEW - PQH_COPY_ENTITY_CONTEXTS#

[top of page]

Table: PQH_COPY_ENTITY_FUNCTIONS

Primary Key: PQH_COPY_ENTITY_FUNCTIONS_PK

1. COPY_ENTITY_FUNCTION_ID

Foreign Keys from this table:

Comments

For a context Pre / Post and event functions for table is listed

Indexes

Columns

[top of page]

HR.PQH_COPY_ENTITY_FUNCTIONS does not reference any database object

HR.PQH_COPY_ENTITY_FUNCTIONS is referenced by following:

HR

VIEW - PQH_COPY_ENTITY_FUNCTIONS#

[top of page]

Table: PQH_COPY_ENTITY_PREFS

Primary Key: PQH_COPY_ENTITY_PREFS_PK

1. COPY_ENTITY_PREF_ID

Foreign Keys from this table:

Comments

User preference of including dependent entity associated with the transaction

Primary Key: PQH_COPY_ENTITY_PREFS_PK

1. COPY_ENTITY_PREF_ID

Indexes

Columns

[top of page]

HR.PQH_COPY_ENTITY_PREFS does not reference any database object

HR.PQH_COPY_ENTITY_PREFS is referenced by following:

HR

VIEW - PQH_COPY_ENTITY_PREFS#

[top of page]

Table: PQH_COPY_ENTITY_RESULTS

Primary Key: PQH_COPY_ENTITY_RESULTS_PK

1. COPY_ENTITY_RESULT_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Transaction entity which holds process data

Primary Key: PQH_COPY_ENTITY_RESULTS_PK

1. COPY_ENTITY_RESULT_ID

Indexes

Columns

[top of page]

HR.PQH_COPY_ENTITY_RESULTS does not reference any database object

HR.PQH_COPY_ENTITY_RESULTS is referenced by following:

HR

VIEW - PQH_COPY_ENTITY_RESULTS#

[top of page]

Table: PQH_COPY_ENTITY_TXNS

Primary Key: PQH_COPY_ENTITY_TXNS_PK

1. COPY_ENTITY_TXN_ID

Primary Key: PQH_COPY_ENTITY_TXNS_UK

1. TRANSACTION_CATEGORY_ID
2. CONTEXT_BUSINESS_GROUP_ID
3. DISPLAY_NAME

Foreign Keys from this table:

Foreign Keys to this table: