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.
Description: | Information Related to Accomodation |
---|
HR.PQH_ACCOMMODATIONS_F does not reference any database object
HR.PQH_ACCOMMODATIONS_F is referenced by following:
Description: | Information Related to Accomodation Assigned |
---|
HR.PQH_ASSIGN_ACCOMMODATIONS_F does not reference any database object
HR.PQH_ASSIGN_ACCOMMODATIONS_F is referenced by following:
Description: | ATTRIBUTE stores the information about attributes being used in transactions. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_ATTRIBUTES.MASTER_ATTRIBUTE_ID | PQH_ATTRIBUTES |
PQH_ATTRIBUTES.MASTER_TABLE_ROUTE_ID | PQH_TABLE_ROUTE |
Foreign Key Column | Foreign Table |
---|---|
PQH_ATTRIBUTES.MASTER_ATTRIBUTE_ID | PQH_ATTRIBUTES |
PQH_ATTRIBUTE_RANGES.ATTRIBUTE_ID | PQH_ATTRIBUTES |
PQH_DOCUMENT_ATTRIBUTES_F.ATTRIBUTE_ID | PQH_ATTRIBUTES |
PQH_ROUTING_HIST_ATTRIBS.ATTRIBUTE_ID | PQH_ATTRIBUTES |
PQH_TEMPLATE_ATTRIBUTES.ATTRIBUTE_ID | PQH_ATTRIBUTES |
PQH_TXN_CATEGORY_ATTRIBUTES.ATTRIBUTE_ID | PQH_ATTRIBUTES |
HR.PQH_ATTRIBUTES does not reference any database object
HR.PQH_ATTRIBUTES is referenced by following:
Description: | Attribute information used in transactions. Stores translated values. |
---|
HR.PQH_ATTRIBUTES_TL does not reference any database object
HR.PQH_ATTRIBUTES_TL is referenced by following:
Description: | PQH_ATTRIBUTE_RANGES stores routing / authorization rules for transaction categories. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_ATTRIBUTE_RANGES.ATTRIBUTE_ID | PQH_ATTRIBUTES |
PQH_ATTRIBUTE_RANGES.ROUTING_LIST_MEMBER_ID | PQH_ROUTING_LIST_MEMBERS |
PQH_ATTRIBUTE_RANGES.ROUTING_CATEGORY_ID | PQH_ROUTING_CATEGORIES |
HR.PQH_ATTRIBUTE_RANGES does not reference any database object
HR.PQH_ATTRIBUTE_RANGES is referenced by following:
Description: | Elements for computing commitments for a budget |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_BDGT_CMMTMNT_ELMNTS.DFLT_ELMNT_FREQUENCY | PER_TIME_PERIOD_TYPES |
HR.PQH_BDGT_CMMTMNT_ELMNTS does not reference any database object
HR.PQH_BDGT_CMMTMNT_ELMNTS is referenced by following:
Description: | Resource reallocation information for position |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_BDGT_POOL_REALLOCTIONS.POOL_ID | PQH_BUDGET_POOLS |
HR.PQH_BDGT_POOL_REALLOCTIONS does not reference any database object
HR.PQH_BDGT_POOL_REALLOCTIONS is referenced by following:
Description: | This is a Copy of PQH_BDGT_POOL_REALLOCATIONS table populated by EFC (Euro as functinoal currency) process. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_BDGT_POOL_REALLOCTIONS_EFC.EFC_ACTION_ID | HR_EFC_ACTIONS |
HR.PQH_BDGT_POOL_REALLOCTIONS_EFC does not reference any database object
HR.PQH_BDGT_POOL_REALLOCTIONS_EFC is referenced by following:
Description: | Stores information on budgets |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGETS.PERIOD_SET_NAME | PAY_CALENDARS |
PQH_BUDGETS.BUDGET_UNIT1_ID | PER_SHARED_TYPES |
PQH_BUDGETS.BUDGET_UNIT2_ID | PER_SHARED_TYPES |
PQH_BUDGETS.BUDGET_UNIT3_ID | PER_SHARED_TYPES |
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGET_VERSIONS.BUDGET_ID | PQH_BUDGETS |
PQH_WORKSHEETS.BUDGET_ID | PQH_BUDGETS |
HR.PQH_BUDGETS does not reference any database object
HR.PQH_BUDGETS is referenced by following:
Description: | This is a Copy of PQH_BUDGETS table populated by EFC (Euro as functinoal currency) process. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGETS_EFC.EFC_ACTION_ID | HR_EFC_ACTIONS |
HR.PQH_BUDGETS_EFC does not reference any database object
HR.PQH_BUDGETS_EFC is referenced by following:
Description: | Budget Details for hr entities |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGET_DETAILS.ORGANIZATION_ID | HR_ALL_ORGANIZATION_UNITS |
PQH_BUDGET_DETAILS.BUDGET_VERSION_ID | PQH_BUDGET_VERSIONS |
PQH_BUDGET_DETAILS.JOB_ID | PER_JOBS |
PQH_BUDGET_DETAILS.GRADE_ID | PER_GRADES |
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGET_PERIODS.BUDGET_DETAIL_ID | PQH_BUDGET_DETAILS |
PQH_WORKSHEET_DETAILS.BUDGET_DETAIL_ID | PQH_BUDGET_DETAILS |
HR.PQH_BUDGET_DETAILS does not reference any database object
HR.PQH_BUDGET_DETAILS is referenced by following:
Description: | This is a Copy of PQH_BUDGET_DETAILS table populated by EFC (Euro as functinoal currency) process. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGET_DETAILS_EFC.EFC_ACTION_ID | HR_EFC_ACTIONS |
HR.PQH_BUDGET_DETAILS_EFC does not reference any database object
HR.PQH_BUDGET_DETAILS_EFC is referenced by following:
Description: | Element wise distribution of budget |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGET_ELEMENTS.BUDGET_SET_ID | PQH_BUDGET_SETS |
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGET_FUND_SRCS.BUDGET_ELEMENT_ID | PQH_BUDGET_ELEMENTS |
HR.PQH_BUDGET_ELEMENTS does not reference any database object
HR.PQH_BUDGET_ELEMENTS is referenced by following:
Description: | Budget Cost Allocation information |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGET_FUND_SRCS.BUDGET_ELEMENT_ID | PQH_BUDGET_ELEMENTS |
PQH_BUDGET_FUND_SRCS.COST_ALLOCATION_KEYFLEX_ID | PAY_COST_ALLOCATION_KEYFLEX |
HR.PQH_BUDGET_FUND_SRCS does not reference any database object
HR.PQH_BUDGET_FUND_SRCS is referenced by following:
Description: | Mapping Cost allocation with GL code combinations |
---|
HR.PQH_BUDGET_GL_FLEX_MAPS does not reference any database object
HR.PQH_BUDGET_GL_FLEX_MAPS is referenced by following:
Description: | Period details for budget |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGET_PERIODS.BUDGET_DETAIL_ID | PQH_BUDGET_DETAILS |
PQH_BUDGET_PERIODS.START_TIME_PERIOD_ID | PER_TIME_PERIODS |
PQH_BUDGET_PERIODS.END_TIME_PERIOD_ID | PER_TIME_PERIODS |
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGET_SETS.BUDGET_PERIOD_ID | PQH_BUDGET_PERIODS |
HR.PQH_BUDGET_PERIODS does not reference any database object
HR.PQH_BUDGET_PERIODS is referenced by following:
Description: | This is a Copy of PQH_BUDGET_PERIODS table populated by EFC (Euro as functinoal currency) process. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGET_PERIODS_EFC.EFC_ACTION_ID | HR_EFC_ACTIONS |
HR.PQH_BUDGET_PERIODS_EFC does not reference any database object
HR.PQH_BUDGET_PERIODS_EFC is referenced by following:
Description: | Reallocation pool for a budget version and for a specific budget mesurement unit |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGET_POOLS.BUDGET_VERSION_ID | PQH_BUDGET_VERSIONS |
PQH_BUDGET_POOLS.BUDGET_UNIT_ID | PER_SHARED_TYPES |
Foreign Key Column | Foreign Table |
---|---|
PQH_BDGT_POOL_REALLOCTIONS.POOL_ID | PQH_BUDGET_POOLS |
HR.PQH_BUDGET_POOLS does not reference any database object
HR.PQH_BUDGET_POOLS is referenced by following:
Description: | Grouping of elements with default distribution |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGET_SETS.DFLT_BUDGET_SET_ID | PQH_DFLT_BUDGET_SETS |
PQH_BUDGET_SETS.BUDGET_PERIOD_ID | PQH_BUDGET_PERIODS |
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGET_ELEMENTS.BUDGET_SET_ID | PQH_BUDGET_SETS |
HR.PQH_BUDGET_SETS does not reference any database object
HR.PQH_BUDGET_SETS is referenced by following:
Description: | This is a Copy of PQH_BUDGET_SETS table populated by EFC (Euro as functinoal currency) process. |
---|
HR.PQH_BUDGET_SETS_EFC does not reference any database object
HR.PQH_BUDGET_SETS_EFC is referenced by following:
Description: | Budget for a date range |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGET_VERSIONS.BUDGET_ID | PQH_BUDGETS |
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGET_DETAILS.BUDGET_VERSION_ID | PQH_BUDGET_VERSIONS |
PQH_BUDGET_POOLS.BUDGET_VERSION_ID | PQH_BUDGET_VERSIONS |
PQH_ELEMENT_COMMITMENTS.BUDGET_VERSION_ID | PQH_BUDGET_VERSIONS |
PQH_WORKSHEETS.BUDGET_VERSION_ID | PQH_BUDGET_VERSIONS |
HR.PQH_BUDGET_VERSIONS does not reference any database object
HR.PQH_BUDGET_VERSIONS is referenced by following:
Description: | This is a Copy of PQH_BUDGET_VERSIONS table populated by EFC (Euro as functinoal currency) process. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGET_VERSIONS_EFC.EFC_ACTION_ID | HR_EFC_ACTIONS |
HR.PQH_BUDGET_VERSIONS_EFC does not reference any database object
HR.PQH_BUDGET_VERSIONS_EFC is referenced by following:
Description: | Criteria and Change list for mass process functionality is stored |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_COPY_ENTITY_ATTRIBS.COPY_ENTITY_TXN_ID | PQH_COPY_ENTITY_TXNS |
HR.PQH_COPY_ENTITY_ATTRIBS does not reference any database object
HR.PQH_COPY_ENTITY_ATTRIBS is referenced by following:
Description: | Adjusting Display/criteria/change to Application/Legislation/Responsibility |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_COPY_ENTITY_FUNCTIONS.CONTEXT | PQH_COPY_ENTITY_CONTEXTS |
PQH_COPY_ENTITY_TXNS.CONTEXT | PQH_COPY_ENTITY_CONTEXTS |
PQH_SPECIAL_ATTRIBUTES.CONTEXT | PQH_COPY_ENTITY_CONTEXTS |
HR.PQH_COPY_ENTITY_CONTEXTS does not reference any database object
HR.PQH_COPY_ENTITY_CONTEXTS is referenced by following:
Description: | For a context Pre / Post and event functions for table is listed |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_COPY_ENTITY_FUNCTIONS.TABLE_ROUTE_ID | PQH_TABLE_ROUTE |
PQH_COPY_ENTITY_FUNCTIONS.CONTEXT | PQH_COPY_ENTITY_CONTEXTS |
HR.PQH_COPY_ENTITY_FUNCTIONS does not reference any database object
HR.PQH_COPY_ENTITY_FUNCTIONS is referenced by following:
Description: | User preference of including dependent entity associated with the transaction |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_COPY_ENTITY_PREFS.COPY_ENTITY_TXN_ID | PQH_COPY_ENTITY_TXNS |
PQH_COPY_ENTITY_PREFS.TABLE_ROUTE_ID | PQH_TABLE_ROUTE |
HR.PQH_COPY_ENTITY_PREFS does not reference any database object
HR.PQH_COPY_ENTITY_PREFS is referenced by following:
Description: | Transaction entity which holds process data |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_COPY_ENTITY_RESULTS.COPY_ENTITY_TXN_ID | PQH_COPY_ENTITY_TXNS |
PQH_COPY_ENTITY_RESULTS.SRC_COPY_ENTITY_RESULT_ID | PQH_COPY_ENTITY_RESULTS |
Foreign Key Column | Foreign Table |
---|---|
PQH_COPY_ENTITY_RESULTS.SRC_COPY_ENTITY_RESULT_ID | PQH_COPY_ENTITY_RESULTS |
HR.PQH_COPY_ENTITY_RESULTS does not reference any database object
HR.PQH_COPY_ENTITY_RESULTS is referenced by following:
Description: | Batch details for Mass Processes |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_COPY_ENTITY_TXNS.TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
PQH_COPY_ENTITY_TXNS.TXN_CATEGORY_ATTRIBUTE_ID | PQH_TXN_CATEGORY_ATTRIBUTES |
PQH_COPY_ENTITY_TXNS.CONTEXT | PQH_COPY_ENTITY_CONTEXTS |
PQH_COPY_ENTITY_TXNS.CONTEXT_BUSINESS_GROUP_ID | HR_ALL_ORGANIZATION_UNITS |
PQH_COPY_ENTITY_TXNS.WF_TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
Foreign Key Column | Foreign Table |
---|---|
PQH_COPY_ENTITY_ATTRIBS.COPY_ENTITY_TXN_ID | PQH_COPY_ENTITY_TXNS |
PQH_COPY_ENTITY_PREFS.COPY_ENTITY_TXN_ID | PQH_COPY_ENTITY_TXNS |
PQH_COPY_ENTITY_RESULTS.COPY_ENTITY_TXN_ID | PQH_COPY_ENTITY_TXNS |
HR.PQH_COPY_ENTITY_TXNS does not reference any database object
HR.PQH_COPY_ENTITY_TXNS is referenced by following:
Description: | Corp Definition |
---|
HR.PQH_CORPS_DEFINITIONS does not reference any database object
HR.PQH_CORPS_DEFINITIONS is referenced by following:
Description: | Corp Extra Information details |
---|
HR.PQH_CORPS_EXTRA_INFO does not reference any database object
HR.PQH_CORPS_EXTRA_INFO is referenced by following:
Description: | Corp Extra Information Types |
---|
HR.PQH_CORPS_INFO_TYPES does not reference any database object
HR.PQH_CORPS_INFO_TYPES is referenced by following:
Description: | Table to store different criteria rate definitions. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_CRITERIA_RATE_DEFN.BUSINESS_GROUP_ID | HR_ALL_ORGANIZATION_UNITS |
Foreign Key Column | Foreign Table |
---|---|
PQH_CRITERIA_RATE_ELEMENTS.CRITERIA_RATE_DEFN_ID | PQH_CRITERIA_RATE_DEFN |
PQH_CRITERIA_RATE_FACTORS.CRITERIA_RATE_DEFN_ID | PQH_CRITERIA_RATE_DEFN |
PQH_CRITERIA_RATE_FACTORS.PARENT_CRITERIA_RATE_DEFN_ID | PQH_CRITERIA_RATE_DEFN |
PQH_RATE_MATRIX_RATES_F.CRITERIA_RATE_DEFN_ID | PQH_CRITERIA_RATE_DEFN |
HR.PQH_CRITERIA_RATE_DEFN does not reference any database object
HR.PQH_CRITERIA_RATE_DEFN is referenced by following:
Description: | Table to store translatable information for a criteria rate definition. |
---|
HR.PQH_CRITERIA_RATE_DEFN_TL does not reference any database object
HR.PQH_CRITERIA_RATE_DEFN_TL is referenced by following:
Description: | Define elements that take their rate value from a criteria rate definition. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_CRITERIA_RATE_ELEMENTS.CRITERIA_RATE_DEFN_ID | PQH_CRITERIA_RATE_DEFN |
PQH_CRITERIA_RATE_ELEMENTS.BUSINESS_GROUP_ID | HR_ALL_ORGANIZATION_UNITS |
Foreign Key Column | Foreign Table |
---|---|
PQH_RATE_ELEMENT_RELATIONS.CRITERIA_RATE_ELEMENT_ID | PQH_CRITERIA_RATE_ELEMENTS |
HR.PQH_CRITERIA_RATE_ELEMENTS does not reference any database object
HR.PQH_CRITERIA_RATE_ELEMENTS is referenced by following:
Description: | 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 defn is ADD_TO/ PERCENT / SUM. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_CRITERIA_RATE_FACTORS.CRITERIA_RATE_DEFN_ID | PQH_CRITERIA_RATE_DEFN |
PQH_CRITERIA_RATE_FACTORS.PARENT_CRITERIA_RATE_DEFN_ID | PQH_CRITERIA_RATE_DEFN |
PQH_CRITERIA_RATE_FACTORS.BUSINESS_GROUP_ID | HR_ALL_ORGANIZATION_UNITS |
HR.PQH_CRITERIA_RATE_FACTORS does not reference any database object
HR.PQH_CRITERIA_RATE_FACTORS is referenced by following:
Description: | De - Case Groups |
---|
HR.PQH_DE_CASE_GROUPS does not reference any database object
HR.PQH_DE_CASE_GROUPS is referenced by following:
Description: |
---|
HR.PQH_DE_INS_END_REASONS does not reference any database object
HR.PQH_DE_INS_END_REASONS is referenced by following:
Description: | DE - Level Codes |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_DE_LEVEL_CODES.LEVEL_NUMBER_ID | % |
HR.PQH_DE_LEVEL_CODES does not reference any database object
HR.PQH_DE_LEVEL_CODES is referenced by following:
Description: | DE - Level Numbers |
---|
HR.PQH_DE_LEVEL_NUMBERS does not reference any database object
HR.PQH_DE_LEVEL_NUMBERS is referenced by following:
Description: | DE - Operations |
---|
HR.PQH_DE_OPERATIONS does not reference any database object
HR.PQH_DE_OPERATIONS is referenced by following:
Description: | DE - Result Sets |
---|
HR.PQH_DE_RESULT_SETS does not reference any database object
HR.PQH_DE_RESULT_SETS is referenced by following:
Description: | DE - Tatigkeit Details |
---|
HR.PQH_DE_TATIGKEIT_DETAILS does not reference any database object
HR.PQH_DE_TATIGKEIT_DETAILS is referenced by following:
Description: | DE - Workplace Validations |
---|
HR.PQH_DE_WRKPLC_VLDTNS does not reference any database object
HR.PQH_DE_WRKPLC_VLDTNS is referenced by following:
Description: | DE - Workplace Validation jobfeatures |
---|
HR.PQH_DE_WRKPLC_VLDTN_JOBFTRS does not reference any database object
HR.PQH_DE_WRKPLC_VLDTN_JOBFTRS is referenced by following:
Description: | DE - Workplace Validation jobdetails |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_DE_WRKPLC_VLDTN_JOBS.WRKPLC_VLDTN_OP_ID | PQH_DE_WRKPLC_VLDTN_OPS |
HR.PQH_DE_WRKPLC_VLDTN_JOBS does not reference any database object
HR.PQH_DE_WRKPLC_VLDTN_JOBS is referenced by following:
Description: | DE - Workplace Validation Level Numbers |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_DE_WRKPLC_VLDTN_LVLNUMS.WRKPLC_VLDTN_VER_ID | PQH_DE_WRKPLC_VLDTN_VERS |
HR.PQH_DE_WRKPLC_VLDTN_LVLNUMS does not reference any database object
HR.PQH_DE_WRKPLC_VLDTN_LVLNUMS is referenced by following:
Description: | DE - Workplace Validation operations |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_DE_WRKPLC_VLDTN_OPS.WRKPLC_VLDTN_VER_ID | PQH_DE_WRKPLC_VLDTN_VERS |
Foreign Key Column | Foreign Table |
---|---|
PQH_DE_WRKPLC_VLDTN_JOBS.WRKPLC_VLDTN_OP_ID | PQH_DE_WRKPLC_VLDTN_OPS |
HR.PQH_DE_WRKPLC_VLDTN_OPS does not reference any database object
HR.PQH_DE_WRKPLC_VLDTN_OPS is referenced by following:
Description: | DE - Workplace Validation Versions |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_DE_WRKPLC_VLDTN_LVLNUMS.WRKPLC_VLDTN_VER_ID | PQH_DE_WRKPLC_VLDTN_VERS |
PQH_DE_WRKPLC_VLDTN_OPS.WRKPLC_VLDTN_VER_ID | PQH_DE_WRKPLC_VLDTN_VERS |
HR.PQH_DE_WRKPLC_VLDTN_VERS does not reference any database object
HR.PQH_DE_WRKPLC_VLDTN_VERS is referenced by following:
Description: | Budget elements for the budget set |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_DFLT_BUDGET_ELEMENTS.DFLT_BUDGET_SET_ID | PQH_DFLT_BUDGET_SETS |
Foreign Key Column | Foreign Table |
---|---|
PQH_DFLT_FUND_SRCS.DFLT_BUDGET_ELEMENT_ID | PQH_DFLT_BUDGET_ELEMENTS |
HR.PQH_DFLT_BUDGET_ELEMENTS does not reference any database object
HR.PQH_DFLT_BUDGET_ELEMENTS is referenced by following:
Description: | Grouping of elements and funding sources |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_DFLT_BUDGET_SETS.BUSINESS_GROUP_ID | HR_ALL_ORGANIZATION_UNITS |
Foreign Key Column | Foreign Table |
---|---|
PQH_BUDGET_SETS.DFLT_BUDGET_SET_ID | PQH_DFLT_BUDGET_SETS |
PQH_DFLT_BUDGET_ELEMENTS.DFLT_BUDGET_SET_ID | PQH_DFLT_BUDGET_SETS |
PQH_WORKSHEET_BUDGET_SETS.DFLT_BUDGET_SET_ID | PQH_DFLT_BUDGET_SETS |
HR.PQH_DFLT_BUDGET_SETS does not reference any database object
HR.PQH_DFLT_BUDGET_SETS is referenced by following:
Description: | Cost allocation information for budget elements |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_DFLT_FUND_SRCS.DFLT_BUDGET_ELEMENT_ID | PQH_DFLT_BUDGET_ELEMENTS |
PQH_DFLT_FUND_SRCS.COST_ALLOCATION_KEYFLEX_ID | PAY_COST_ALLOCATION_KEYFLEX |
HR.PQH_DFLT_FUND_SRCS does not reference any database object
HR.PQH_DFLT_FUND_SRCS is referenced by following:
Description: | Document management Table; for mainly for self service pdf print |
---|
HR.PQH_DOCUMENTS_F does not reference any database object
HR.PQH_DOCUMENTS_F is referenced by following:
Description: | Mapping attributes of document with known transaction attributes |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_DOCUMENT_ATTRIBUTES_F.ATTRIBUTE_ID | PQH_ATTRIBUTES |
HR.PQH_DOCUMENT_ATTRIBUTES_F does not reference any database object
HR.PQH_DOCUMENT_ATTRIBUTES_F is referenced by following:
Description: | Element Commitment for a specific period |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_ELEMENT_COMMITMENTS.BUDGET_VERSION_ID | PQH_BUDGET_VERSIONS |
HR.PQH_ELEMENT_COMMITMENTS does not reference any database object
HR.PQH_ELEMENT_COMMITMENTS is referenced by following:
Description: | This is a Copy of PQH_ELEMENT_COMMITMENTS table populated by EFC (Euro as functinoal currency) process. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_ELEMENT_COMMITMENTS_EFC.EFC_ACTION_ID | HR_EFC_ACTIONS |
HR.PQH_ELEMENT_COMMITMENTS_EFC does not reference any database object
HR.PQH_ELEMENT_COMMITMENTS_EFC is referenced by following:
Description: | Holds the statutory situations for a civil servant in French Public Sector |
---|
HR.PQH_FR_EMP_STAT_SITUATIONS does not reference any database object
HR.PQH_FR_EMP_STAT_SITUATIONS is referenced by following:
Description: | French global Indices |
---|
HR.PQH_FR_GLOBAL_INDICES_F does not reference any database object
HR.PQH_FR_GLOBAL_INDICES_F is referenced by following:
Description: | Stores details on Statutory Situations |
---|
HR.PQH_FR_STAT_SITUATIONS does not reference any database object
HR.PQH_FR_STAT_SITUATIONS is referenced by following:
Description: | Stores details on Statutory Situation Criteria |
---|
HR.PQH_FR_STAT_SITUATION_RULES does not reference any database object
HR.PQH_FR_STAT_SITUATION_RULES is referenced by following:
Description: | Table that keeps the details regarding the validations available for a person. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_FR_VALIDATION_EVENTS.VALIDATION_ID | PQH_FR_VALIDATIONS |
PQH_FR_VALIDATION_PERIODS.VALIDATION_ID | PQH_FR_VALIDATIONS |
HR.PQH_FR_VALIDATIONS does not reference any database object
HR.PQH_FR_VALIDATIONS is referenced by following:
Description: | Table that keeps the details regarding the events for a particular validations. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_FR_VALIDATION_EVENTS.VALIDATION_ID | PQH_FR_VALIDATIONS |
HR.PQH_FR_VALIDATION_EVENTS does not reference any database object
HR.PQH_FR_VALIDATION_EVENTS is referenced by following:
Description: | Table that keeps the period details for a particular validation of an individual |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_FR_VALIDATION_PERIODS.VALIDATION_ID | PQH_FR_VALIDATIONS |
HR.PQH_FR_VALIDATION_PERIODS does not reference any database object
HR.PQH_FR_VALIDATION_PERIODS is referenced by following:
Description: | FYI Notification Details |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_FYI_NOTIFY.TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
HR.PQH_FYI_NOTIFY does not reference any database object
HR.PQH_FYI_NOTIFY is referenced by following:
Description: | Interface entity containing budget and commitment information used to post to GL |
---|
HR.PQH_GL_INTERFACE does not reference any database object
HR.PQH_GL_INTERFACE is referenced by following:
Description: | This is a Copy of PQH_GL_INTERFACE table populated by EFC (Euro as functinoal currency) process. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_GL_INTERFACE_EFC.EFC_ACTION_ID | HR_EFC_ACTIONS |
HR.PQH_GL_INTERFACE_EFC does not reference any database object
HR.PQH_GL_INTERFACE_EFC is referenced by following:
Description: |
---|
HR.PQH_GMS_EXCESS does not reference any database object
HR.PQH_GMS_EXCESS is referenced by following:
Description: | Stores the comparative results of the current and the ?What If? benefits. |
---|
HR.PQH_PA_WHATIF_RESULTS does not reference any database object
HR.PQH_PA_WHATIF_RESULTS is referenced by following:
Description: | POSITION_TRANSACTION is used to maintain and create positions. Each transaction needs to be approved by pre-identified approvers. On approval these transactions are applied to database.Each transaction can have a combination of one or more |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_POSITION_TRANSACTIONS.ENTRY_GRADE_ID | PER_GRADES |
PQH_POSITION_TRANSACTIONS.AVAILABILITY_STATUS_ID | PER_SHARED_TYPES |
PQH_POSITION_TRANSACTIONS.PAY_BASIS_ID | PER_PAY_BASES |
PQH_POSITION_TRANSACTIONS.WF_TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
PQH_POSITION_TRANSACTIONS.LOCATION_ID | HR_LOCATIONS_ALL |
PQH_POSITION_TRANSACTIONS.JOB_ID | PER_JOBS |
PQH_POSITION_TRANSACTIONS.POSITION_DEFINITION_ID | PER_POSITION_DEFINITIONS |
PQH_POSITION_TRANSACTIONS.BUSINESS_GROUP_ID | HR_ALL_ORGANIZATION_UNITS |
PQH_POSITION_TRANSACTIONS.ORGANIZATION_ID | HR_ALL_ORGANIZATION_UNITS |
Foreign Key Column | Foreign Table |
---|---|
PQH_PTX_DPF_DF.POSITION_TRANSACTION_ID | PQH_POSITION_TRANSACTIONS |
PQH_PTX_EXTRA_INFO.POSITION_TRANSACTION_ID | PQH_POSITION_TRANSACTIONS |
PQH_PTX_SHADOW.POSITION_TRANSACTION_ID | PQH_POSITION_TRANSACTIONS |
PQH_TXN_JOB_REQUIREMENTS.POSITION_TRANSACTION_ID | PQH_POSITION_TRANSACTIONS |
PQH_WORKSHEET_DETAILS.POSITION_TRANSACTION_ID | PQH_POSITION_TRANSACTIONS |
HR.PQH_POSITION_TRANSACTIONS does not reference any database object
HR.PQH_POSITION_TRANSACTIONS is referenced by following:
Description: | Log table |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_PROCESS_LOG.MASTER_PROCESS_LOG_ID | PQH_PROCESS_LOG |
PQH_PROCESS_LOG.TXN_TABLE_ROUTE_ID | PQH_TABLE_ROUTE |
Foreign Key Column | Foreign Table |
---|---|
PQH_PROCESS_LOG.MASTER_PROCESS_LOG_ID | PQH_PROCESS_LOG |
HR.PQH_PROCESS_LOG does not reference any database object
HR.PQH_PROCESS_LOG is referenced by following:
Description: | Copy of the Position Transaction Table. This is used for position transaction refresh. |
---|
HR.PQH_PTE_SHADOW does not reference any database object
HR.PQH_PTE_SHADOW is referenced by following:
Description: | Deployment factors for Position Transaction records are stored until the transaction is applied to PER_DEPLOYMENT_FACTORS |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_PTX_DPF_DF.POSITION_TRANSACTION_ID | PQH_POSITION_TRANSACTIONS |
PQH_PTX_DPF_DF.DEPLOYMENT_FACTOR_ID | PER_DEPLOYMENT_FACTORS |
HR.PQH_PTX_DPF_DF does not reference any database object
HR.PQH_PTX_DPF_DF is referenced by following:
Description: | Deployment factors shadow for Position Transaction |
---|
HR.PQH_PTX_DPF_DF_SHADOW does not reference any database object
HR.PQH_PTX_DPF_DF_SHADOW is referenced by following:
Description: | Extra information details for Position transaction. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_PTX_EXTRA_INFO.POSITION_TRANSACTION_ID | PQH_POSITION_TRANSACTIONS |
HR.PQH_PTX_EXTRA_INFO does not reference any database object
HR.PQH_PTX_EXTRA_INFO is referenced by following:
Description: | Internal Use |
---|
HR.PQH_PTX_INFO_TYPES does not reference any database object
HR.PQH_PTX_INFO_TYPES is referenced by following:
Description: | Position Extra information shadow used for refreshing position transaction extra information. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_PTX_SHADOW.POSITION_TRANSACTION_ID | PQH_POSITION_TRANSACTIONS |
HR.PQH_PTX_SHADOW does not reference any database object
HR.PQH_PTX_SHADOW is referenced by following:
Description: | Rate Element Relations |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_RATE_ELEMENT_RELATIONS.CRITERIA_RATE_ELEMENT_ID | PQH_CRITERIA_RATE_ELEMENTS |
PQH_RATE_ELEMENT_RELATIONS.BUSINESS_GROUP_ID | HR_ALL_ORGANIZATION_UNITS |
HR.PQH_RATE_ELEMENT_RELATIONS does not reference any database object
HR.PQH_RATE_ELEMENT_RELATIONS is referenced by following:
Description: | Table to store information about where rate factors values used to calculate a criteria rate definition must be recorded on a element |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_RATE_FACTOR_ON_ELMNTS.CRITERIA_RATE_ELEMENT_ID | % |
PQH_RATE_FACTOR_ON_ELMNTS.CRITERIA_RATE_FACTOR_ID | % |
PQH_RATE_FACTOR_ON_ELMNTS.BUSINESS_GROUP_ID | HR_ALL_ORGANIZATION_UNITS |
HR.PQH_RATE_FACTOR_ON_ELMNTS does not reference any database object
HR.PQH_RATE_FACTOR_ON_ELMNTS is referenced by following:
Description: | Table to store the nodes in a rate matrix hierarchy |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_RATE_MATRIX_RATES_F.RATE_MATRIX_NODE_ID | PQH_RATE_MATRIX_NODES |
PQH_RT_MATRIX_NODE_VALUES.RATE_MATRIX_NODE_ID | PQH_RATE_MATRIX_NODES |
HR.PQH_RATE_MATRIX_NODES does not reference any database object
HR.PQH_RATE_MATRIX_NODES is referenced by following:
Description: | Datetracked table to store the rate value associated with each node in a rate matrix hierarchy. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_RATE_MATRIX_RATES_F.RATE_MATRIX_NODE_ID | PQH_RATE_MATRIX_NODES |
PQH_RATE_MATRIX_RATES_F.CRITERIA_RATE_DEFN_ID | PQH_CRITERIA_RATE_DEFN |
HR.PQH_RATE_MATRIX_RATES_F does not reference any database object
HR.PQH_RATE_MATRIX_RATES_F is referenced by following:
Description: | Lists copy and reference templates for a template |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_REF_TEMPLATES.PARENT_TEMPLATE_ID | PQH_TEMPLATES |
PQH_REF_TEMPLATES.BASE_TEMPLATE_ID | PQH_TEMPLATES |
HR.PQH_REF_TEMPLATES does not reference any database object
HR.PQH_REF_TEMPLATES is referenced by following:
Description: | Roles used for position control workflow and security |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_ROLES.BUSINESS_GROUP_ID | HR_ALL_ORGANIZATION_UNITS |
Foreign Key Column | Foreign Table |
---|---|
PQH_ROLE_EXTRA_INFO.ROLE_ID | PQH_ROLES |
PQH_ROLE_TEMPLATES.ROLE_ID | PQH_ROLES |
PQH_ROUTING_CATEGORIES.OVERRIDE_ROLE_ID | PQH_ROLES |
PQH_ROUTING_HISTORY.FORWARDED_TO_ROLE_ID | PQH_ROLES |
PQH_ROUTING_HISTORY.FORWARDED_BY_ROLE_ID | PQH_ROLES |
PQH_ROUTING_LIST_MEMBERS.ROLE_ID | PQH_ROLES |
HR.PQH_ROLES does not reference any database object
HR.PQH_ROLES is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_ROLE_EXTRA_INFO.INFORMATION_TYPE | % |
PQH_ROLE_EXTRA_INFO.ROLE_ID | PQH_ROLES |
HR.PQH_ROLE_EXTRA_INFO does not reference any database object
HR.PQH_ROLE_EXTRA_INFO is referenced by following:
Description: |
---|
HR.PQH_ROLE_INFO_TYPES does not reference any database object
HR.PQH_ROLE_INFO_TYPES is referenced by following:
Description: | Tempalte for a transaction category attached to a role |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_ROLE_TEMPLATES.ROLE_ID | PQH_ROLES |
PQH_ROLE_TEMPLATES.TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
PQH_ROLE_TEMPLATES.TEMPLATE_ID | PQH_TEMPLATES |
HR.PQH_ROLE_TEMPLATES does not reference any database object
HR.PQH_ROLE_TEMPLATES is referenced by following:
Description: | Transaction Routing Information |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_ROUTING_CATEGORIES.ROUTING_LIST_ID | PQH_ROUTING_LISTS |
PQH_ROUTING_CATEGORIES.TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
PQH_ROUTING_CATEGORIES.POSITION_STRUCTURE_ID | PER_POSITION_STRUCTURES |
PQH_ROUTING_CATEGORIES.OVERRIDE_ROLE_ID | PQH_ROLES |
Foreign Key Column | Foreign Table |
---|---|
PQH_ATTRIBUTE_RANGES.ROUTING_CATEGORY_ID | PQH_ROUTING_CATEGORIES |
PQH_ROUTING_HISTORY.ROUTING_CATEGORY_ID | PQH_ROUTING_CATEGORIES |
HR.PQH_ROUTING_CATEGORIES does not reference any database object
HR.PQH_ROUTING_CATEGORIES is referenced by following:
Description: | Keeps track of each hop during the routing / approver process. It also has some pre-identified attributes stored with new values |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_ROUTING_HISTORY.ROUTING_CATEGORY_ID | PQH_ROUTING_CATEGORIES |
PQH_ROUTING_HISTORY.TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
PQH_ROUTING_HISTORY.FORWARDED_BY_MEMBER_ID | PQH_ROUTING_LIST_MEMBERS |
PQH_ROUTING_HISTORY.FORWARDED_TO_MEMBER_ID | PQH_ROUTING_LIST_MEMBERS |
PQH_ROUTING_HISTORY.POS_STRUCTURE_VERSION_ID | PER_POS_STRUCTURE_VERSIONS |
PQH_ROUTING_HISTORY.FORWARDED_TO_ROLE_ID | PQH_ROLES |
PQH_ROUTING_HISTORY.FORWARDED_BY_ROLE_ID | PQH_ROLES |
Foreign Key Column | Foreign Table |
---|---|
PQH_ROUTING_HIST_ATTRIBS.ROUTING_HISTORY_ID | PQH_ROUTING_HISTORY |
HR.PQH_ROUTING_HISTORY does not reference any database object
HR.PQH_ROUTING_HISTORY is referenced by following:
Description: | Attribute values for each step of routing |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_ROUTING_HIST_ATTRIBS.ROUTING_HISTORY_ID | PQH_ROUTING_HISTORY |
PQH_ROUTING_HIST_ATTRIBS.ATTRIBUTE_ID | PQH_ATTRIBUTES |
HR.PQH_ROUTING_HIST_ATTRIBS does not reference any database object
HR.PQH_ROUTING_HIST_ATTRIBS is referenced by following:
Description: | Routing list used for position controlled workflow |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_ROUTING_CATEGORIES.ROUTING_LIST_ID | PQH_ROUTING_LISTS |
PQH_ROUTING_LIST_MEMBERS.ROUTING_LIST_ID | PQH_ROUTING_LISTS |
HR.PQH_ROUTING_LISTS does not reference any database object
HR.PQH_ROUTING_LISTS is referenced by following:
Description: | Roles and role users that constitute the routing list |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_ROUTING_LIST_MEMBERS.ROLE_ID | PQH_ROLES |
PQH_ROUTING_LIST_MEMBERS.ROUTING_LIST_ID | PQH_ROUTING_LISTS |
Foreign Key Column | Foreign Table |
---|---|
PQH_ATTRIBUTE_RANGES.ROUTING_LIST_MEMBER_ID | PQH_ROUTING_LIST_MEMBERS |
PQH_ROUTING_HISTORY.FORWARDED_BY_MEMBER_ID | PQH_ROUTING_LIST_MEMBERS |
PQH_ROUTING_HISTORY.FORWARDED_TO_MEMBER_ID | PQH_ROUTING_LIST_MEMBERS |
HR.PQH_ROUTING_LIST_MEMBERS does not reference any database object
HR.PQH_ROUTING_LIST_MEMBERS is referenced by following:
Description: | Table to store criteria values for a particular rate matrix node. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_RT_MATRIX_NODE_VALUES.RATE_MATRIX_NODE_ID | PQH_RATE_MATRIX_NODES |
HR.PQH_RT_MATRIX_NODE_VALUES does not reference any database object
HR.PQH_RT_MATRIX_NODE_VALUES is referenced by following:
Description: | Configurable business rules |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_RULES.RULE_SET_ID | PQH_RULE_SETS |
HR.PQH_RULES does not reference any database object
HR.PQH_RULES is referenced by following:
Description: | Details regarding the attributes for which the rule is mapped is stored. |
---|
HR.PQH_RULE_ATTRIBUTES does not reference any database object
HR.PQH_RULE_ATTRIBUTES is referenced by following:
Description: | Set of one or more configurable business rule |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_RULE_SETS.REFERENCED_RULE_SET_ID | PQH_RULE_SETS |
PQH_RULE_SETS.ORGANIZATION_ID | HR_ALL_ORGANIZATION_UNITS |
PQH_RULE_SETS.BUSINESS_GROUP_ID | HR_ALL_ORGANIZATION_UNITS |
PQH_RULE_SETS.ORGANIZATION_STRUCTURE_ID | PER_ORGANIZATION_STRUCTURES |
Foreign Key Column | Foreign Table |
---|---|
PQH_RULES.RULE_SET_ID | PQH_RULE_SETS |
PQH_RULE_SETS.REFERENCED_RULE_SET_ID | PQH_RULE_SETS |
HR.PQH_RULE_SETS does not reference any database object
HR.PQH_RULE_SETS is referenced by following:
Description: | Translated Rule set information |
---|
HR.PQH_RULE_SETS_TL does not reference any database object
HR.PQH_RULE_SETS_TL is referenced by following:
Description: | Situation Information |
---|
HR.PQH_SITUATIONS does not reference any database object
HR.PQH_SITUATIONS is referenced by following:
Description: | Identifies attributes with special functions |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_SPECIAL_ATTRIBUTES.TXN_CATEGORY_ATTRIBUTE_ID | PQH_TXN_CATEGORY_ATTRIBUTES |
PQH_SPECIAL_ATTRIBUTES.CONTEXT | PQH_COPY_ENTITY_CONTEXTS |
HR.PQH_SPECIAL_ATTRIBUTES does not reference any database object
HR.PQH_SPECIAL_ATTRIBUTES is referenced by following:
Description: | Self Service Transaction History - Approval History |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_SS_APPROVAL_HISTORY.USER_NAME | FND_USER |
HR.PQH_SS_APPROVAL_HISTORY does not reference any database object
HR.PQH_SS_APPROVAL_HISTORY is referenced by following:
Description: | Temporary table to hold value for SS pdf printing |
---|
HR.PQH_SS_PRINT_DATA does not reference any database object
HR.PQH_SS_PRINT_DATA is referenced by following:
Description: | Temporary Table to process Document Labels for display on Doc Management |
---|
HR.PQH_SS_PRINT_LABEL_TEMP does not reference any database object
HR.PQH_SS_PRINT_LABEL_TEMP is referenced by following:
Description: | Self Service Transaction History - Step History |
---|
HR.PQH_SS_STEP_HISTORY does not reference any database object
HR.PQH_SS_STEP_HISTORY is referenced by following:
Description: | Self Service Transaction History - Transaction History |
---|
HR.PQH_SS_TRANSACTION_HISTORY does not reference any database object
HR.PQH_SS_TRANSACTION_HISTORY is referenced by following:
Description: | Self Service Transaction History - Item Value History |
---|
HR.PQH_SS_VALUE_HISTORY does not reference any database object
HR.PQH_SS_VALUE_HISTORY is referenced by following:
Description: | Table information for dynamic queries |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_TABLE_ROUTE.SHADOW_TABLE_ROUTE_ID | PQH_TABLE_ROUTE |
Foreign Key Column | Foreign Table |
---|---|
PQH_ATTRIBUTES.MASTER_TABLE_ROUTE_ID | PQH_TABLE_ROUTE |
PQH_COPY_ENTITY_FUNCTIONS.TABLE_ROUTE_ID | PQH_TABLE_ROUTE |
PQH_COPY_ENTITY_PREFS.TABLE_ROUTE_ID | PQH_TABLE_ROUTE |
PQH_PROCESS_LOG.TXN_TABLE_ROUTE_ID | PQH_TABLE_ROUTE |
PQH_TABLE_ROUTE.SHADOW_TABLE_ROUTE_ID | PQH_TABLE_ROUTE |
PQH_TRANSACTION_CATEGORIES.CONSOLIDATED_TABLE_ROUTE_ID | PQH_TABLE_ROUTE |
PQH_TRANSACTION_CATEGORIES.MASTER_TABLE_ROUTE_ID | PQH_TABLE_ROUTE |
PQH_TXN_CATEGORY_ATTRIBUTES.TRANSACTION_TABLE_ROUTE_ID | PQH_TABLE_ROUTE |
HR.PQH_TABLE_ROUTE does not reference any database object
HR.PQH_TABLE_ROUTE is referenced by following:
Description: | Translated Table Information |
---|
HR.PQH_TABLE_ROUTE_TL does not reference any database object
HR.PQH_TABLE_ROUTE_TL is referenced by following:
Description: | Position control data security |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_TEMPLATES.TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
Foreign Key Column | Foreign Table |
---|---|
PQH_REF_TEMPLATES.PARENT_TEMPLATE_ID | PQH_TEMPLATES |
PQH_REF_TEMPLATES.BASE_TEMPLATE_ID | PQH_TEMPLATES |
PQH_ROLE_TEMPLATES.TEMPLATE_ID | PQH_TEMPLATES |
PQH_TEMPLATE_ATTRIBUTES.TEMPLATE_ID | PQH_TEMPLATES |
PQH_TRANSACTION_TEMPLATES.TEMPLATE_ID | PQH_TEMPLATES |
HR.PQH_TEMPLATES does not reference any database object
HR.PQH_TEMPLATES is referenced by following:
Description: | Translation for Templates |
---|
HR.PQH_TEMPLATES_TL does not reference any database object
HR.PQH_TEMPLATES_TL is referenced by following:
Description: | List of attributes and their security level that are defined for a template |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_TEMPLATE_ATTRIBUTES.ATTRIBUTE_ID | PQH_ATTRIBUTES |
PQH_TEMPLATE_ATTRIBUTES.TEMPLATE_ID | PQH_TEMPLATES |
HR.PQH_TEMPLATE_ATTRIBUTES does not reference any database object
HR.PQH_TEMPLATE_ATTRIBUTES is referenced by following:
Description: | Transaction Job Requirements Shadow Table |
---|
HR.PQH_TJR_SHADOW does not reference any database object
HR.PQH_TJR_SHADOW is referenced by following:
Description: | Setup information to allow selective routing of transactions |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_TRANSACTION_CATEGORIES.CONSOLIDATED_TABLE_ROUTE_ID | PQH_TABLE_ROUTE |
PQH_TRANSACTION_CATEGORIES.MASTER_TABLE_ROUTE_ID | PQH_TABLE_ROUTE |
Foreign Key Column | Foreign Table |
---|---|
PQH_COPY_ENTITY_TXNS.TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
PQH_COPY_ENTITY_TXNS.WF_TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
PQH_FYI_NOTIFY.TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
PQH_POSITION_TRANSACTIONS.WF_TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
PQH_ROLE_TEMPLATES.TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
PQH_ROUTING_CATEGORIES.TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
PQH_ROUTING_HISTORY.TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
PQH_TEMPLATES.TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
PQH_TRANSACTION_TEMPLATES.TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
PQH_TXN_CATEGORY_ATTRIBUTES.TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
PQH_WORKSHEETS.WF_TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
HR.PQH_TRANSACTION_CATEGORIES does not reference any database object
HR.PQH_TRANSACTION_CATEGORIES is referenced by following:
Description: | Transalation for Transaction Category |
---|
HR.PQH_TRANSACTION_CATEGORIES_TL does not reference any database object
HR.PQH_TRANSACTION_CATEGORIES_TL is referenced by following:
Description: | Task templates which determines the type/security of a transaction is stored here |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_TRANSACTION_TEMPLATES.TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
PQH_TRANSACTION_TEMPLATES.TEMPLATE_ID | PQH_TEMPLATES |
HR.PQH_TRANSACTION_TEMPLATES does not reference any database object
HR.PQH_TRANSACTION_TEMPLATES is referenced by following:
Description: | Intersection entity between transaction category and table attributes |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_TXN_CATEGORY_ATTRIBUTES.TRANSACTION_TABLE_ROUTE_ID | PQH_TABLE_ROUTE |
PQH_TXN_CATEGORY_ATTRIBUTES.ATTRIBUTE_ID | PQH_ATTRIBUTES |
PQH_TXN_CATEGORY_ATTRIBUTES.TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
Foreign Key Column | Foreign Table |
---|---|
PQH_COPY_ENTITY_TXNS.TXN_CATEGORY_ATTRIBUTE_ID | PQH_TXN_CATEGORY_ATTRIBUTES |
PQH_SPECIAL_ATTRIBUTES.TXN_CATEGORY_ATTRIBUTE_ID | PQH_TXN_CATEGORY_ATTRIBUTES |
HR.PQH_TXN_CATEGORY_ATTRIBUTES does not reference any database object
HR.PQH_TXN_CATEGORY_ATTRIBUTES is referenced by following:
Description: | Intersection entity between transaction category and documents. Also hold the type associated with the document in the transaction category context. |
---|
HR.PQH_TXN_CATEGORY_DOCUMENTS does not reference any database object
HR.PQH_TXN_CATEGORY_DOCUMENTS is referenced by following:
Description: | Transaction table for per_job_requirements ( part of position control ) |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_TXN_JOB_REQUIREMENTS.JOB_REQUIREMENT_ID | PER_JOB_REQUIREMENTS |
PQH_TXN_JOB_REQUIREMENTS.POSITION_TRANSACTION_ID | PQH_POSITION_TRANSACTIONS |
PQH_TXN_JOB_REQUIREMENTS.BUSINESS_GROUP_ID | HR_ALL_ORGANIZATION_UNITS |
PQH_TXN_JOB_REQUIREMENTS.ANALYSIS_CRITERIA_ID | PER_ANALYSIS_CRITERIA |
PQH_TXN_JOB_REQUIREMENTS.JOB_ID | PER_JOBS |
HR.PQH_TXN_JOB_REQUIREMENTS does not reference any database object
HR.PQH_TXN_JOB_REQUIREMENTS is referenced by following:
Description: | Store Navigational details for Wizard forms |
---|
HR.PQH_WIZARD_CANVASES does not reference any database object
HR.PQH_WIZARD_CANVASES is referenced by following:
Description: | Transaction data for working on budget version |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_WORKSHEETS.BUDGET_ID | PQH_BUDGETS |
PQH_WORKSHEETS.BUDGET_VERSION_ID | PQH_BUDGET_VERSIONS |
PQH_WORKSHEETS.WF_TRANSACTION_CATEGORY_ID | PQH_TRANSACTION_CATEGORIES |
Foreign Key Column | Foreign Table |
---|---|
PQH_WORKSHEET_DETAILS.WORKSHEET_ID | PQH_WORKSHEETS |
HR.PQH_WORKSHEETS does not reference any database object
HR.PQH_WORKSHEETS is referenced by following:
Description: | Element wise distribution of measurement units |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_WORKSHEET_BDGT_ELMNTS.WORKSHEET_BUDGET_SET_ID | PQH_WORKSHEET_BUDGET_SETS |
Foreign Key Column | Foreign Table |
---|---|
PQH_WORKSHEET_FUND_SRCS.WORKSHEET_BDGT_ELMNT_ID | PQH_WORKSHEET_BDGT_ELMNTS |
HR.PQH_WORKSHEET_BDGT_ELMNTS does not reference any database object
HR.PQH_WORKSHEET_BDGT_ELMNTS is referenced by following:
Description: | Budget set wise distribution of worksheet |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_WORKSHEET_BUDGET_SETS.WORKSHEET_PERIOD_ID | PQH_WORKSHEET_PERIODS |
PQH_WORKSHEET_BUDGET_SETS.DFLT_BUDGET_SET_ID | PQH_DFLT_BUDGET_SETS |
Foreign Key Column | Foreign Table |
---|---|
PQH_WORKSHEET_BDGT_ELMNTS.WORKSHEET_BUDGET_SET_ID | PQH_WORKSHEET_BUDGET_SETS |
HR.PQH_WORKSHEET_BUDGET_SETS does not reference any database object
HR.PQH_WORKSHEET_BUDGET_SETS is referenced by following:
Description: | This is a Copy of PQH_WORKSHEET_BUDGET_SETS table populated by EFC (Euro as functinoal currency) process. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_WORKSHEET_BUDGET_SETS_EFC.EFC_ACTION_ID | HR_EFC_ACTIONS |
HR.PQH_WORKSHEET_BUDGET_SETS_EFC does not reference any database object
HR.PQH_WORKSHEET_BUDGET_SETS_EFC is referenced by following:
Description: | Work table of Hr entities for Budget information |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_WORKSHEET_DETAILS.ORGANIZATION_ID | HR_ALL_ORGANIZATION_UNITS |
PQH_WORKSHEET_DETAILS.BUDGET_DETAIL_ID | PQH_BUDGET_DETAILS |
PQH_WORKSHEET_DETAILS.POSITION_TRANSACTION_ID | PQH_POSITION_TRANSACTIONS |
PQH_WORKSHEET_DETAILS.JOB_ID | PER_JOBS |
PQH_WORKSHEET_DETAILS.GRADE_ID | PER_GRADES |
PQH_WORKSHEET_DETAILS.WORKSHEET_ID | PQH_WORKSHEETS |
PQH_WORKSHEET_DETAILS.PARENT_WORKSHEET_DETAIL_ID | PQH_WORKSHEET_DETAILS |
Foreign Key Column | Foreign Table |
---|---|
PQH_WORKSHEET_DETAILS.PARENT_WORKSHEET_DETAIL_ID | PQH_WORKSHEET_DETAILS |
PQH_WORKSHEET_PERIODS.WORKSHEET_DETAIL_ID | PQH_WORKSHEET_DETAILS |
HR.PQH_WORKSHEET_DETAILS does not reference any database object
HR.PQH_WORKSHEET_DETAILS is referenced by following:
Description: | This is a Copy of PQH_WORKSHEET_DETAILS table populated by EFC (Euro as functinoal currency) process. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_WORKSHEET_DETAILS_EFC.EFC_ACTION_ID | HR_EFC_ACTIONS |
HR.PQH_WORKSHEET_DETAILS_EFC does not reference any database object
HR.PQH_WORKSHEET_DETAILS_EFC is referenced by following:
Description: | cost allocation for the budget element |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_WORKSHEET_FUND_SRCS.WORKSHEET_BDGT_ELMNT_ID | PQH_WORKSHEET_BDGT_ELMNTS |
PQH_WORKSHEET_FUND_SRCS.COST_ALLOCATION_KEYFLEX_ID | PAY_COST_ALLOCATION_KEYFLEX |
HR.PQH_WORKSHEET_FUND_SRCS does not reference any database object
HR.PQH_WORKSHEET_FUND_SRCS is referenced by following:
Description: | Period wise details of transaction data for budget version |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_WORKSHEET_PERIODS.WORKSHEET_DETAIL_ID | PQH_WORKSHEET_DETAILS |
PQH_WORKSHEET_PERIODS.START_TIME_PERIOD_ID | PER_TIME_PERIODS |
PQH_WORKSHEET_PERIODS.END_TIME_PERIOD_ID | PER_TIME_PERIODS |
Foreign Key Column | Foreign Table |
---|---|
PQH_WORKSHEET_BUDGET_SETS.WORKSHEET_PERIOD_ID | PQH_WORKSHEET_PERIODS |
HR.PQH_WORKSHEET_PERIODS does not reference any database object
HR.PQH_WORKSHEET_PERIODS is referenced by following:
Description: | This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process. |
---|
Foreign Key Column | Foreign Table |
---|---|
PQH_WORKSHEET_PERIODS_EFC.EFC_ACTION_ID | HR_EFC_ACTIONS |
HR.PQH_WORKSHEET_PERIODS_EFC does not reference any database object
HR.PQH_WORKSHEET_PERIODS_EFC is referenced by following:
APPS.PQH_ATTRIBUTE_RANGES_V1 is not referenced by any database object
APPS.PQH_ATTRIBUTE_RANGES_V2 is not referenced by any database object
APPS.PQH_ATTRIBUTE_RANGES_V3 is not referenced by any database object
APPS.PQH_ATTRIBUTE_RANGES_V4 is not referenced by any database object
APPS.PQH_BDGT_CMMTMNT_ELMNTS_V is not referenced by any database object
APPS.PQH_BDGT_POOL_REALLOCTIONS_V is not referenced by any database object
APPS.PQH_BDGT_REALLOC_FOLDERS_V is not referenced by any database object
APPS.PQH_BUDGET_DETAILS_V is not referenced by any database object
APPS.PQH_BUDGET_POOLS_V is not referenced by any database object
APPS.PQH_COPY_ENTITY_CONTEXTS_V is not referenced by any database object
APPS.PQH_COPY_ENTITY_POSITIONS_V is not referenced by any database object
APPS.PQH_COPY_ENTITY_POSUPD_V is not referenced by any database object
APPS.PQH_COPY_ENTITY_PREFS_V is not referenced by any database object
APPS.PQH_CORPS_CAREER_PATHS_V is not referenced by any database object
APPS.PQH_CORPS_DEFINITIONS_V is not referenced by any database object
APPS.PQH_CORPS_DOCUMENTS_V is not referenced by any database object
APPS.PQH_CORPS_EXAMS_V is not referenced by any database object
APPS.PQH_CORPS_FILERES_V is not referenced by any database object
APPS.PQH_CORPS_GRADES_V is not referenced by any database object
APPS.PQH_CORPS_NATURE_HGRID_V is not referenced by any database object
APPS.PQH_CORPS_ORGANIZATIONS_V is not referenced by any database object
APPS.PQH_CORPS_RULES_V is not referenced by any database object
APPS.PQH_CORPS_TRAININGS_V is not referenced by any database object
APPS.PQH_DE_CS_GRADES_V is not referenced by any database object
APPS.PQH_ENTITY_ELEMENT_TYPES_V is not referenced by any database object
APPS.PQH_FR_CAGR_ENTITLEMENTS_V is not referenced by any database object
APPS.PQH_FR_STAT_SITUATIONS_V is not referenced by any database object
APPS.PQH_INFO_TYPE_SECURITY_RIT_V is not referenced by any database object
APPS.PQH_ORGANIZATION_BUDGETS_V is not referenced by any database object
APPS.PQH_PC_ORG_HIERARCHIES_V is not referenced by any database object
APPS.PQH_PC_ORG_SUMMARY_V is not referenced by any database object
APPS.PQH_POSITION_BUDGETS_V is not referenced by any database object
APPS.PQH_POSITION_ELEMENT_TYPES_V is not referenced by any database object
APPS.PQH_POSITION_EXTRA_INFO_V is not referenced by any database object
APPS.PQH_POSITION_ROLES_V is not referenced by any database object
APPS.PQH_POSITION_TRANSACTIONS_V is not referenced by any database object
APPS.PQH_PTX_HISTORY_V is not referenced by any database object
APPS.PQH_REALLOC_FOLDER_TXN_V is not referenced by any database object
APPS.PQH_REALLOC_TXN_DETAILS_V is not referenced by any database object
APPS.PQH_REALLOC_TXN_PERIODS_V is not referenced by any database object
APPS.PQH_REF_TEMPLATES_V is not referenced by any database object
APPS.PQH_ROLES_V is not referenced by any database object
APPS.PQH_ROLE_PEOPLE_V is not referenced by any database object
APPS.PQH_ROLE_TEMPLATES_V is not referenced by any database object
APPS.PQH_ROLE_USERS_V is not referenced by any database object
APPS.PQH_ROLE_USERS_V1 is not referenced by any database object
APPS.PQH_ROUTING_CATEGORIES_V is not referenced by any database object
APPS.PQH_ROUTING_HISTORY_V is not referenced by any database object
APPS.PQH_ROUTING_HIST_ATTRIBS_V is not referenced by any database object
APPS.PQH_RULES_V is not referenced by any database object
APPS.PQH_RULE_SETS_V is not referenced by any database object
APPS.PQH_RULE_SETS_VL is not referenced by any database object
APPS.PQH_SPECIAL_ATTRIBUTES_V is not referenced by any database object
APPS.PQH_TEMPLATES_V is not referenced by any database object
APPS.PQH_TEMPLATES_VL is not referenced by any database object
APPS.PQH_TEMPLATE_ATTRIBUTES_V is not referenced by any database object
APPS.PQH_TRANSACTIONS_V is not referenced by any database object
APPS.PQH_TRANSACTION_CATEGORIES_V is not referenced by any database object
APPS.PQH_TRANSACTION_CATEGORIES_VL is not referenced by any database object
APPS.PQH_TRANSACTION_TEMPLATES_V is not referenced by any database object
APPS.PQH_TXN_CATEGORY_ATTRIBUTES_V is not referenced by any database object
APPS.PQH_TXN_JOB_REQUIREMENTS_V is not referenced by any database object
APPS.PQH_WORKSHEET_ORGANIZATIONS_V is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |