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 - PSP Tables and Views

TABLE - PSP.PSP_ADJUSTMENT_CONTROL_TABLE
TABLE - PSP.PSP_ADJUSTMENT_LINES
TABLE - PSP.PSP_ADJUSTMENT_LINES_ARCH
TABLE - PSP.PSP_ADJUSTMENT_LINES_HISTORY
TABLE - PSP.PSP_AUTO_ACCTS
TABLE - PSP.PSP_AUTO_BYPASS
TABLE - PSP.PSP_AUTO_FILL_DATES
TABLE - PSP.PSP_AUTO_LOOKUPS
TABLE - PSP.PSP_AUTO_NA_BYPASS
TABLE - PSP.PSP_AUTO_PARAMS
TABLE - PSP.PSP_AUTO_RULES
TABLE - PSP.PSP_AUTO_SEGMENTS
TABLE - PSP.PSP_CLEARING_ACCOUNT
TABLE - PSP.PSP_DEFAULT_LABOR_SCHEDULES
TABLE - PSP.PSP_DISTRIBUTION_INTERFACE
TABLE - PSP.PSP_DISTRIBUTION_LINES
TABLE - PSP.PSP_DISTRIBUTION_LINES_ARCH
TABLE - PSP.PSP_DISTRIBUTION_LINES_HISTORY
TABLE - PSP.PSP_EFFORT_ERRORS
TABLE - PSP.PSP_EFFORT_MESSAGES
TABLE - PSP.PSP_EFFORT_REPORTS
TABLE - PSP.PSP_EFFORT_REPORT_DETAILS
TABLE - PSP.PSP_EFFORT_REPORT_ELEMENTS
TABLE - PSP.PSP_EFFORT_REPORT_PERIODS
TABLE - PSP.PSP_EFFORT_REPORT_TEMPLATES
TABLE - PSP.PSP_EFF_REPORTS
TABLE - PSP.PSP_EFF_REPORT_APPROVALS
TABLE - PSP.PSP_EFF_REPORT_DETAILS
TABLE - PSP.PSP_ELEMENT_GROUPS
TABLE - PSP.PSP_ELEMENT_TYPES
TABLE - PSP.PSP_ELEMENT_TYPE_ACCOUNTS
TABLE - PSP.PSP_ENC_CHANGED_ASG_HISTORY
TABLE - PSP.PSP_ENC_CHANGED_ASSIGNMENTS
TABLE - PSP.PSP_ENC_CHANGED_SCHEDULES
TABLE - PSP.PSP_ENC_CHANGED_SCH_HISTORY
TABLE - PSP.PSP_ENC_CONTROLS
TABLE - PSP.PSP_ENC_ELEMENTS
TABLE - PSP.PSP_ENC_END_DATES
TABLE - PSP.PSP_ENC_LINES
TABLE - PSP.PSP_ENC_LINES_ARCH
TABLE - PSP.PSP_ENC_LINES_HISTORY
TABLE - PSP.PSP_ENC_PAYROLLS
TABLE - PSP.PSP_ENC_PAYROLL_ASSIGNMENTS
TABLE - PSP.PSP_ENC_SETUP_OPTIONS
TABLE - PSP.PSP_ENC_SUMMARY_LINES
TABLE - PSP.PSP_ENC_SUMMARY_LINES_ARCH
TABLE - PSP.PSP_ER_APPROVALS
TABLE - PSP.PSP_EXTERNAL_EFFORT_LINES
TABLE - PSP.PSP_GROUP_ELEMENT_LIST
TABLE - PSP.PSP_LAYOUT_OPTIONS
TABLE - PSP.PSP_MATRIX_DRIVER
TABLE - PSP.PSP_MATRIX_DRIVER2
TABLE - PSP.PSP_MATRIX_DRIVER3
TABLE - PSP.PSP_ORGANIZATION_ACCOUNTS
TABLE - PSP.PSP_PAYROLL_CONTROLS
TABLE - PSP.PSP_PAYROLL_INTERFACE
TABLE - PSP.PSP_PAYROLL_LINES
TABLE - PSP.PSP_PAYROLL_SOURCES
TABLE - PSP.PSP_PAYROLL_SUB_LINES
TABLE - PSP.PSP_PRE_GEN_DIST_LINES
TABLE - PSP.PSP_PRE_GEN_DIST_LINES_ARCH
TABLE - PSP.PSP_PRE_GEN_DIST_LINES_HISTORY
TABLE - PSP.PSP_REPORT_DETAILS
TABLE - PSP.PSP_REPORT_ERRORS
TABLE - PSP.PSP_REPORT_PERIOD_FREQUENCY_B
TABLE - PSP.PSP_REPORT_PERIOD_FREQUENCY_TL
TABLE - PSP.PSP_REPORT_TEMPLATES
TABLE - PSP.PSP_REPORT_TEMPLATES_H
TABLE - PSP.PSP_REPORT_TEMPLATE_DETAILS
TABLE - PSP.PSP_REPORT_TEMPLATE_DETAILS_H
TABLE - PSP.PSP_REP_ORG_DLS
TABLE - PSP.PSP_SCHEDULES
TABLE - PSP.PSP_SCHEDULE_HIERARCHY
TABLE - PSP.PSP_SCHEDULE_LINES
TABLE - PSP.PSP_SCH_PERIOD_TOTAL
TABLE - PSP.PSP_SELECTED_PERSONS_T
TABLE - PSP.PSP_SUB_LINE_REASONS
TABLE - PSP.PSP_SUMMARY_LINES
TABLE - PSP.PSP_SUMMARY_LINES_ARCH
TABLE - PSP.PSP_TEMPLATE_AWARDS
TABLE - PSP.PSP_TEMPLATE_ORGANIZATIONS
TABLE - PSP.PSP_TEMPLATE_PROJECTS
TABLE - PSP.PSP_TEMP_DEST_SUMLINES
TABLE - PSP.PSP_TEMP_ORIG_LINES
TABLE - PSP.PSP_TEMP_ORIG_SUMLINES
TABLE - PSP.PSP_UPGRADE_115
VIEW - APPS.PSP_ACCOUNTS_ELEMENTS_V
VIEW - APPS.PSP_ACCOUNTS_ORGANIZATIONS_V
VIEW - APPS.PSP_ADJUSTMENT_COMBO_V
VIEW - APPS.PSP_ASG_SCHEDULE_V
VIEW - APPS.PSP_ASSIGNMENTS_V
VIEW - APPS.PSP_AUTO_ACCTS_V
VIEW - APPS.PSP_AUTO_FILL_BEGIN_DATES_V
VIEW - APPS.PSP_AUTO_FILL_END_DATES_V
VIEW - APPS.PSP_AUTO_NA_BYPASS_V
VIEW - APPS.PSP_AUTO_PARAMS_V
VIEW - APPS.PSP_BATCH_NAMES_V
VIEW - APPS.PSP_DEFAULT_LABOR_SCHEDULES_V
VIEW - APPS.PSP_DEST_ACCT_LINES_V
VIEW - APPS.PSP_DISTRIBUTION_BATCH_NAME_V
VIEW - APPS.PSP_DISTRIBUTION_INTERFACE_V
VIEW - APPS.PSP_DISTRIBUTION_INTERFACE_V2
VIEW - APPS.PSP_EFFORT_MESSAGES_V
VIEW - APPS.PSP_EFFORT_REPORT_ELEMENTS_V
VIEW - APPS.PSP_EFFORT_REPORT_PERIODS_V
VIEW - APPS.PSP_ELEMENT_GROUPS_V
VIEW - APPS.PSP_ELEMENT_GROUP_V
VIEW - APPS.PSP_ELEMENT_TYPES_V
VIEW - APPS.PSP_ELEMENT_TYPE_ACCOUNTS_V
VIEW - APPS.PSP_EMPLOYEES_V
VIEW - APPS.PSP_ENC_EFFECTIVE_DATE_V
VIEW - APPS.PSP_ENC_ELEMENTS_V
VIEW - APPS.PSP_ENC_END_DATES_V
VIEW - APPS.PSP_ENC_END_DATE_ORG_V
VIEW - APPS.PSP_ENC_PAYROLLS_V
VIEW - APPS.PSP_ENC_PAYROLL_ASSIGNMENT_V
VIEW - APPS.PSP_GROUP_ELEMENT_LIST_V
VIEW - APPS.PSP_LOOKUPS
VIEW - APPS.PSP_MATRIX_DRIVER2_V
VIEW - APPS.PSP_MATRIX_DRIVER3_V
VIEW - APPS.PSP_MATRIX_DRIVER_V
VIEW - APPS.PSP_ORGANIZATION_ACCOUNTS_V
VIEW - APPS.PSP_ORGANIZATION_SCHEDULES_V
VIEW - APPS.PSP_ORIG_ACCT_LINES_V
VIEW - APPS.PSP_ORIG_LINE_DETAILS_V
VIEW - APPS.PSP_PAYROLL_BATCH_NAMES_V
VIEW - APPS.PSP_PAYROLL_INTERFACE_V
VIEW - APPS.PSP_PAYROLL_SOURCE_TYPES_V
VIEW - APPS.PSP_REP_DEF_CHG_V
VIEW - APPS.PSP_REP_DEF_LOV_V
VIEW - APPS.PSP_REP_DIST_PRJ_V
VIEW - APPS.PSP_REP_ENC_DEF_V
VIEW - APPS.PSP_REP_ENC_SSP_V
VIEW - APPS.PSP_REP_SCH_EMP_V
VIEW - APPS.PSP_REP_SSP_CHG1_V
VIEW - APPS.PSP_REP_SSP_CHG_V
VIEW - APPS.PSP_SCHEDULES_V
VIEW - APPS.PSP_SCHEDULE_HIERARCHY_V

Table: PSP_ADJUSTMENT_CONTROL_TABLE

Description: Stores one record for each batch adjusted
Primary Key: PSP_ADJUSTMENT_CONTROL_PK
  1. ADJUSTMENT_BATCH_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_ADJUSTMENT_CONTROL_TABLE.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
PSP_ADJUSTMENT_CONTROL_TABLE.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_ADJUSTMENT_LINES.BATCH_NAME PSP_ADJUSTMENT_CONTROL_TABLE
PSP_ADJUSTMENT_LINES_HISTORY.ADJUSTMENT_BATCH_NAME PSP_ADJUSTMENT_CONTROL_TABLE

[top of page]

PSP.PSP_ADJUSTMENT_CONTROL_TABLE does not reference any database object

PSP.PSP_ADJUSTMENT_CONTROL_TABLE is referenced by following:

APPS
SYNONYM - PSP_ADJUSTMENT_CONTROL_TABLE
TRIGGER - PSP_ADJUSTMENT_CONTROL_TAB_WHO

[top of page]

Table: PSP_ADJUSTMENT_LINES

Description: Stores the original lines and the new lines to be transferred
Primary Key: PSP_ADJUSTMENT_LINES_PK
  1. ADJUSTMENT_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_ADJUSTMENT_LINES.EXPENDITURE_TYPE PA_EXPENDITURE_TYPES
PSP_ADJUSTMENT_LINES.EFFORT_REPORT_ID
PSP_ADJUSTMENT_LINES.VERSION_NUM 		PSP_EFFORT_REPORTS
PSP_ADJUSTMENT_LINES.SUMMARY_LINE_ID PSP_SUMMARY_LINES
PSP_ADJUSTMENT_LINES.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
PSP_ADJUSTMENT_LINES.GL_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
PSP_ADJUSTMENT_LINES.PROJECT_ID PA_PROJECTS_ALL
PSP_ADJUSTMENT_LINES.EXPENDITURE_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
PSP_ADJUSTMENT_LINES.TASK_ID PA_TASKS
PSP_ADJUSTMENT_LINES.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
PSP_ADJUSTMENT_LINES.PAYROLL_CONTROL_ID PSP_PAYROLL_CONTROLS
PSP_ADJUSTMENT_LINES.SOURCE_TYPE
PSP_ADJUSTMENT_LINES.STATUS_CODE 		PSP_PAYROLL_SOURCES
PSP_ADJUSTMENT_LINES.TIME_PERIOD_ID PER_TIME_PERIODS
PSP_ADJUSTMENT_LINES.BATCH_NAME PSP_ADJUSTMENT_CONTROL_TABLE
PSP_ADJUSTMENT_LINES.SUSPENSE_ORG_ACCOUNT_ID PSP_ORGANIZATION_ACCOUNTS

[top of page]

PSP.PSP_ADJUSTMENT_LINES does not reference any database object

PSP.PSP_ADJUSTMENT_LINES is referenced by following:

APPS
SYNONYM - PSP_ADJUSTMENT_LINES
TRIGGER - PSP_ADJUSTMENT_LINES_WHO

[top of page]

Table: PSP_ADJUSTMENT_LINES_ARCH

Description: Stores the archived Adjustment Lines History
Primary Key: PSP_ADJUSTMENT_LINES_ARCH_PK
  1. ADJUSTMENT_LINE_ID

[top of page]

PSP.PSP_ADJUSTMENT_LINES_ARCH does not reference any database object

PSP.PSP_ADJUSTMENT_LINES_ARCH is referenced by following:

APPS
SYNONYM - PSP_ADJUSTMENT_LINES_ARCH
TRIGGER - PSP_ADJUSTMENT_LINES_ARCH_WHO

[top of page]

Table: PSP_ADJUSTMENT_LINES_HISTORY

Description: Stores adjusted lines that are successfully transferred
Primary Key: PSP_ADJUSTMENT_LINES_HIST_PK
  1. ADJUSTMENT_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_ADJUSTMENT_LINES_HISTORY.PAYROLL_CONTROL_ID PSP_PAYROLL_CONTROLS
PSP_ADJUSTMENT_LINES_HISTORY.EXPENDITURE_TYPE PA_EXPENDITURE_TYPES
PSP_ADJUSTMENT_LINES_HISTORY.EXPENDITURE_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
PSP_ADJUSTMENT_LINES_HISTORY.SUSPENSE_ORG_ACCOUNT_ID PSP_ORGANIZATION_ACCOUNTS
PSP_ADJUSTMENT_LINES_HISTORY.EFFORT_REPORT_ID
PSP_ADJUSTMENT_LINES_HISTORY.VERSION_NUM 		PSP_EFFORT_REPORTS
PSP_ADJUSTMENT_LINES_HISTORY.SUMMARY_LINE_ID PSP_SUMMARY_LINES
PSP_ADJUSTMENT_LINES_HISTORY.ADJUSTMENT_BATCH_NAME PSP_ADJUSTMENT_CONTROL_TABLE
PSP_ADJUSTMENT_LINES_HISTORY.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
PSP_ADJUSTMENT_LINES_HISTORY.SOURCE_TYPE
PSP_ADJUSTMENT_LINES_HISTORY.SOURCE_CODE 		PSP_PAYROLL_SOURCES
PSP_ADJUSTMENT_LINES_HISTORY.TIME_PERIOD_ID PER_TIME_PERIODS
PSP_ADJUSTMENT_LINES_HISTORY.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
PSP_ADJUSTMENT_LINES_HISTORY.GL_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
PSP_ADJUSTMENT_LINES_HISTORY.PROJECT_ID PA_PROJECTS_ALL
PSP_ADJUSTMENT_LINES_HISTORY.TASK_ID PA_TASKS

[top of page]

PSP.PSP_ADJUSTMENT_LINES_HISTORY does not reference any database object

PSP.PSP_ADJUSTMENT_LINES_HISTORY is referenced by following:

APPS
SYNONYM - PSP_ADJUSTMENT_LINES_HISTORY
TRIGGER - PSP_ADJUSTMENT_LINES_HISTO_WHO

[top of page]

Table: PSP_AUTO_ACCTS

Description: Stores one record for every auto-population expenditure type and General Ledger account segment having defined rules
Primary Key: ACCT_ID_PK
  1. ACCT_ID
Primary Key: PSP_AUTO_ACCTS_PK
  1. ACCT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_AUTO_ACCTS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
PSP_AUTO_ACCTS.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_AUTO_PARAMS.ACCT_ID PSP_AUTO_ACCTS
PSP_AUTO_RULES.ACCT_ID PSP_AUTO_ACCTS

[top of page]

PSP.PSP_AUTO_ACCTS does not reference any database object

PSP.PSP_AUTO_ACCTS is referenced by following:

APPS
SYNONYM - PSP_AUTO_ACCTS
TRIGGER - PSP_AUTO_ACCTS_WHO

[top of page]

Table: PSP_AUTO_BYPASS

Description: Stores expenditure types that will be skipped by the auto-population process
Primary Key: PSP_AUTO_BYPASS_PK
  1. EXPENDITURE_TYPE
  2. BUSINESS_GROUP_ID
  3. SET_OF_BOOKS_ID
Primary Key: SYS_C0029028
  1. EXPENDITURE_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_AUTO_BYPASS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
PSP_AUTO_BYPASS.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS

[top of page]

PSP.PSP_AUTO_BYPASS does not reference any database object

PSP.PSP_AUTO_BYPASS is referenced by following:

APPS
SYNONYM - PSP_AUTO_BYPASS
TRIGGER - PSP_AUTO_BYPASS_WHO

[top of page]

Table: PSP_AUTO_FILL_DATES

Description: Contains auto-fill rules for begin and end dates
Primary Key: PSP_AUTO_FILL_DATES_PK
  1. DATE_TYPE

[top of page]

PSP.PSP_AUTO_FILL_DATES does not reference any database object

PSP.PSP_AUTO_FILL_DATES is referenced by following:

APPS
SYNONYM - PSP_AUTO_FILL_DATES
TRIGGER - PSP_AUTO_FILL_DATES_WHO

[top of page]

Table: PSP_AUTO_LOOKUPS

Description: Stores lookup codes and their descriptions used in the auto-population module of Labor Distribution
Primary Key: LOOKUP_ID_PK
  1. LOOKUP_ID
Primary Key: PSP_AUTO_LOOKUPS_PK1
  1. LOOKUP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_AUTO_LOOKUPS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_AUTO_PARAMS.LOOKUP_ID PSP_AUTO_LOOKUPS

[top of page]

PSP.PSP_AUTO_LOOKUPS does not reference any database object

PSP.PSP_AUTO_LOOKUPS is referenced by following:

APPS
SYNONYM - PSP_AUTO_LOOKUPS
TRIGGER - PSP_AUTO_LOOKUPS_WHO

[top of page]

Table: PSP_AUTO_NA_BYPASS

Description: Natural Account By-pass table for Auto-population
Primary Key: PSP_AUTO_NA_BYPASS_PK
  1. NATURAL_ACCOUNT
  2. SEGMENT_NUM
  3. BUSINESS_GROUP_ID
  4. SET_OF_BOOKS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_AUTO_NA_BYPASS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
PSP_AUTO_NA_BYPASS.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS

[top of page]

PSP.PSP_AUTO_NA_BYPASS does not reference any database object

PSP.PSP_AUTO_NA_BYPASS is referenced by following:

APPS
SYNONYM - PSP_AUTO_NA_BYPASS
TRIGGER - PSP_AUTO_NA_BYPASS_WHO

[top of page]

Table: PSP_AUTO_PARAMS

Description: Stores one record for each parameter for each natural account or expenditure type record used in the auto-population module of Labor Distribution
Primary Key: ACCT_PARAM_PK
  1. ACCT_ID
  2. PARAM_LINE_NUM
Primary Key: PSP_AUTO_PARAMS_PK1
  1. ACCT_ID
  2. PARAM_LINE_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_AUTO_PARAMS.ACCT_ID PSP_AUTO_ACCTS
PSP_AUTO_PARAMS.LOOKUP_ID PSP_AUTO_LOOKUPS

[top of page]

PSP.PSP_AUTO_PARAMS does not reference any database object

PSP.PSP_AUTO_PARAMS is referenced by following:

APPS
SYNONYM - PSP_AUTO_PARAMS
TRIGGER - PSP_AUTO_PARAMS_WHO

[top of page]

Table: PSP_AUTO_RULES

Description: Stores rules associated with population of expenditure type or General Ledger account segment
Primary Key: PSP_AUTO_RULES_PK
  1. RULE_ID
Primary Key: RULE_ID_PK
  1. RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_AUTO_RULES.ACCT_ID PSP_AUTO_ACCTS

[top of page]

PSP.PSP_AUTO_RULES does not reference any database object

PSP.PSP_AUTO_RULES is referenced by following:

APPS
SYNONYM - PSP_AUTO_RULES
TRIGGER - PSP_AUTO_RULES_WHO

[top of page]

Table: PSP_AUTO_SEGMENTS

Description: Stores Natural Account segment used for auto-population, for each business group and set of books combination
Primary Key: PSP_AUTO_SEGMENTS_PK
  1. SEGMENT_NUMBER
  2. BUSINESS_GROUP_ID
  3. SET_OF_BOOKS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_AUTO_SEGMENTS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
PSP_AUTO_SEGMENTS.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS

[top of page]

PSP.PSP_AUTO_SEGMENTS does not reference any database object

PSP.PSP_AUTO_SEGMENTS is referenced by following:

APPS
SYNONYM - PSP_AUTO_SEGMENTS
TRIGGER - PSP_AUTO_SEGMENTS_WHO

[top of page]

Table: PSP_CLEARING_ACCOUNT

Description: Stores clearing account required by Labor Distribution
Primary Key: PSP_CLEARING_ACCOUNT_PK
  1. BUSINESS_GROUP_ID
  2. SET_OF_BOOKS_ID
  3. REVERSING_GL_CCID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_CLEARING_ACCOUNT.REVERSING_GL_CCID GL_CODE_COMBINATIONS
PSP_CLEARING_ACCOUNT.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS

[top of page]

PSP.PSP_CLEARING_ACCOUNT does not reference any database object

PSP.PSP_CLEARING_ACCOUNT is referenced by following:

APPS
SYNONYM - PSP_CLEARING_ACCOUNT
TRIGGER - PSP_CLEARING_ACCOUNT_WHO

[top of page]

Table: PSP_DEFAULT_LABOR_SCHEDULES

Description: Stores default labor schedules to be used when there are no schedules defined for an employee
Primary Key: PSP_DEFAULT_LABOR_SCHEDULES_PK
  1. ORG_SCHEDULE_ID
Primary Key: PSP_DEFAULT_LABOR_SCHEDULES_U1
  1. ORGANIZATION_ID
  2. SCHEDULE_BEGIN_DATE
  3. GL_CODE_COMBINATION_ID
  4. PROJECT_ID
  5. EXPENDITURE_ORGANIZATION_ID
  6. EXPENDITURE_TYPE
  7. TASK_ID
  8. AWARD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_DEFAULT_LABOR_SCHEDULES.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
PSP_DEFAULT_LABOR_SCHEDULES.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
PSP_DEFAULT_LABOR_SCHEDULES.GL_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
PSP_DEFAULT_LABOR_SCHEDULES.PROJECT_ID PA_PROJECTS_ALL
PSP_DEFAULT_LABOR_SCHEDULES.EXPENDITURE_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
PSP_DEFAULT_LABOR_SCHEDULES.EXPENDITURE_TYPE PA_EXPENDITURE_TYPES
PSP_DEFAULT_LABOR_SCHEDULES.TASK_ID PA_TASKS
PSP_DEFAULT_LABOR_SCHEDULES.PROJECT_ID PA_PROJECTS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_DISTRIBUTION_LINES.ORG_SCHEDULE_ID PSP_DEFAULT_LABOR_SCHEDULES
PSP_DISTRIBUTION_LINES_HISTORY.SCHEDULE_LINE_ID PSP_DEFAULT_LABOR_SCHEDULES

[top of page]

PSP.PSP_DEFAULT_LABOR_SCHEDULES does not reference any database object

PSP.PSP_DEFAULT_LABOR_SCHEDULES is referenced by following:

APPS
SYNONYM - PSP_DEFAULT_LABOR_SCHEDULES

[top of page]

Table: PSP_DISTRIBUTION_INTERFACE

Description: Contains distribution lines from pre-generated sources, such as timecards
Primary Key: PSP_DISTRIBUTION_INTERFACE_PK
  1. DISTRIBUTION_INTERFACE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_DISTRIBUTION_INTERFACE.TIME_PERIOD_ID PER_TIME_PERIODS
PSP_DISTRIBUTION_INTERFACE.GL_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
PSP_DISTRIBUTION_INTERFACE.PROJECT_ID PA_PROJECTS_ALL
PSP_DISTRIBUTION_INTERFACE.EXPENDITURE_TYPE PA_EXPENDITURE_TYPES
PSP_DISTRIBUTION_INTERFACE.EXPENDITURE_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
PSP_DISTRIBUTION_INTERFACE.TASK_ID PA_TASKS
PSP_DISTRIBUTION_INTERFACE.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_PRE_GEN_DIST_LINES.DISTRIBUTION_INTERFACE_ID PSP_DISTRIBUTION_INTERFACE
PSP_PRE_GEN_DIST_LINES_HISTORY.DISTRIBUTION_INTERFACE_ID PSP_DISTRIBUTION_INTERFACE

[top of page]

PSP.PSP_DISTRIBUTION_INTERFACE does not reference any database object

PSP.PSP_DISTRIBUTION_INTERFACE is referenced by following:

APPS
SYNONYM - PSP_DISTRIBUTION_INTERFACE
TRIGGER - PSP_DISTRIBUTION_INTERFACE_WHO

[top of page]

Table: PSP_DISTRIBUTION_LINES

Description: Stores distributed Oracle and non-Oracle payroll sublines not yet transferred to General Ledger or Grants Accounting
Primary Key: PSP_DISTRIBUTION_LINES_PK
  1. DISTRIBUTION_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_DISTRIBUTION_LINES.PAYROLL_SUB_LINE_ID PSP_PAYROLL_SUB_LINES
PSP_DISTRIBUTION_LINES.EFFORT_REPORT_ID
PSP_DISTRIBUTION_LINES.VERSION_NUM 		PSP_EFFORT_REPORTS
PSP_DISTRIBUTION_LINES.SCHEDULE_LINE_ID PSP_SCHEDULE_LINES
PSP_DISTRIBUTION_LINES.SUMMARY_LINE_ID PSP_SUMMARY_LINES
PSP_DISTRIBUTION_LINES.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
PSP_DISTRIBUTION_LINES.ELEMENT_ACCOUNT_ID PSP_ELEMENT_TYPE_ACCOUNTS
PSP_DISTRIBUTION_LINES.ORG_SCHEDULE_ID PSP_DEFAULT_LABOR_SCHEDULES
PSP_DISTRIBUTION_LINES.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS

[top of page]

PSP.PSP_DISTRIBUTION_LINES does not reference any database object

PSP.PSP_DISTRIBUTION_LINES is referenced by following:

APPS
SYNONYM - PSP_DISTRIBUTION_LINES

[top of page]

Table: PSP_DISTRIBUTION_LINES_ARCH

Description: Stores archived Distribution Lines History
Primary Key: PSP_DISTRIBUTION_LINES_ARCH_PK
  1. DISTRIBUTION_LINE_ID

[top of page]

PSP.PSP_DISTRIBUTION_LINES_ARCH does not reference any database object

PSP.PSP_DISTRIBUTION_LINES_ARCH is referenced by following:

APPS
SYNONYM - PSP_DISTRIBUTION_LINES_ARCH

[top of page]

Table: PSP_DISTRIBUTION_LINES_HISTORY

Description: Stores distributed Oracle and non-Oracle payroll sublines not yet transferred to General Ledger or Grants Accounting
Primary Key: PSP_DISTRIBUTION_LINES_HIST_PK
  1. DISTRIBUTION_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_DISTRIBUTION_LINES_HISTORY.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
PSP_DISTRIBUTION_LINES_HISTORY.PAYROLL_SUB_LINE_ID PSP_PAYROLL_SUB_LINES
PSP_DISTRIBUTION_LINES_HISTORY.SUMMARY_LINE_ID PSP_SUMMARY_LINES
PSP_DISTRIBUTION_LINES_HISTORY.SCHEDULE_LINE_ID PSP_SCHEDULE_LINES
PSP_DISTRIBUTION_LINES_HISTORY.ELEMENT_ACCOUNT_ID PSP_ELEMENT_TYPE_ACCOUNTS
PSP_DISTRIBUTION_LINES_HISTORY.SCHEDULE_LINE_ID PSP_DEFAULT_LABOR_SCHEDULES
PSP_DISTRIBUTION_LINES_HISTORY.EFFORT_REPORT_ID
PSP_DISTRIBUTION_LINES_HISTORY.VERSION_NUM 		PSP_EFFORT_REPORTS
PSP_DISTRIBUTION_LINES_HISTORY.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS

[top of page]

PSP.PSP_DISTRIBUTION_LINES_HISTORY does not reference any database object

PSP.PSP_DISTRIBUTION_LINES_HISTORY is referenced by following:

APPS
SYNONYM - PSP_DISTRIBUTION_LINES_HISTORY

[top of page]

Table: PSP_EFFORT_ERRORS

Description: Contains data for the Warning Report
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_EFFORT_ERRORS.TEMPLATE_ID PSP_EFFORT_REPORT_TEMPLATES

[top of page]

PSP.PSP_EFFORT_ERRORS does not reference any database object

PSP.PSP_EFFORT_ERRORS is referenced by following:

APPS
SYNONYM - PSP_EFFORT_ERRORS

[top of page]

Table: PSP_EFFORT_MESSAGES

Description: Contains standard Certify and Review messages
Primary Key: PSP_EFFORT_MESSAGES_PK
  1. EFFORT_REPORT_MESSAGE_TYPE
  2. MESSAGE_ID

[top of page]

PSP.PSP_EFFORT_MESSAGES does not reference any database object

PSP.PSP_EFFORT_MESSAGES is referenced by following:

APPS
SYNONYM - PSP_EFFORT_MESSAGES
TRIGGER - PSP_EFFORT_MESSAGES_WHO

[top of page]

Table: PSP_EFFORT_REPORTS

Description: Contains effort reports for employees for a specified time period
Primary Key: PSP_EFFORT_REPORTS_PK
  1. EFFORT_REPORT_ID
  2. VERSION_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_EFFORT_REPORTS.TEMPLATE_ID PSP_EFFORT_REPORT_TEMPLATES
PSP_EFFORT_REPORTS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
PSP_EFFORT_REPORTS.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_ADJUSTMENT_LINES.EFFORT_REPORT_ID
PSP_ADJUSTMENT_LINES.VERSION_NUM 		PSP_EFFORT_REPORTS
PSP_ADJUSTMENT_LINES_HISTORY.EFFORT_REPORT_ID
PSP_ADJUSTMENT_LINES_HISTORY.VERSION_NUM 		PSP_EFFORT_REPORTS
PSP_DISTRIBUTION_LINES.EFFORT_REPORT_ID
PSP_DISTRIBUTION_LINES.VERSION_NUM 		PSP_EFFORT_REPORTS
PSP_DISTRIBUTION_LINES_HISTORY.EFFORT_REPORT_ID
PSP_DISTRIBUTION_LINES_HISTORY.VERSION_NUM 		PSP_EFFORT_REPORTS
PSP_EFFORT_REPORT_DETAILS.EFFORT_REPORT_ID
PSP_EFFORT_REPORT_DETAILS.VERSION_NUM 		PSP_EFFORT_REPORTS
PSP_ER_APPROVALS.EFFORT_REPORT_ID
PSP_ER_APPROVALS.VERSION_NUM 		PSP_EFFORT_REPORTS
PSP_PRE_GEN_DIST_LINES.EFFORT_REPORT_ID
PSP_PRE_GEN_DIST_LINES.VERSION_NUM 		PSP_EFFORT_REPORTS

[top of page]

PSP.PSP_EFFORT_REPORTS does not reference any database object

PSP.PSP_EFFORT_REPORTS is referenced by following:

APPS
SYNONYM - PSP_EFFORT_REPORTS
TRIGGER - PSP_EFFORT_REPORTS_WHO

[top of page]

Table: PSP_EFFORT_REPORT_DETAILS

Description: Contains assorted details by charging account for a given effort report
Primary Key: PSP_EFFORT_DETAILS_PK
  1. EFFORT_REPORT_ID
  2. VERSION_NUM
  3. EFFORT_REPORT_LINE_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_EFFORT_REPORT_DETAILS.EFFORT_REPORT_ID
PSP_EFFORT_REPORT_DETAILS.VERSION_NUM 		PSP_EFFORT_REPORTS
PSP_EFFORT_REPORT_DETAILS.ELEMENT_TYPE_ID PSP_EFFORT_REPORT_ELEMENTS
PSP_EFFORT_REPORT_DETAILS.GL_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
PSP_EFFORT_REPORT_DETAILS.PROJECT_ID PA_PROJECTS_ALL
PSP_EFFORT_REPORT_DETAILS.EXPENDITURE_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
PSP_EFFORT_REPORT_DETAILS.ELEMENT_TYPE_ID PA_EXPENDITURE_TYPES
PSP_EFFORT_REPORT_DETAILS.TASK_ID PA_TASKS

[top of page]

PSP.PSP_EFFORT_REPORT_DETAILS does not reference any database object

PSP.PSP_EFFORT_REPORT_DETAILS is referenced by following:

APPS
SYNONYM - PSP_EFFORT_REPORT_DETAILS
TRIGGER - PSP_EFFORT_REPORT_DETAILS_WHO

[top of page]

Table: PSP_EFFORT_REPORT_ELEMENTS

Description: Stores elements to be included in effort reports
Primary Key: PSP_EFFORT_REPORT_ELEMENTS_PK
  1. ELEMENT_TYPE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_EFFORT_REPORT_DETAILS.ELEMENT_TYPE_ID PSP_EFFORT_REPORT_ELEMENTS

[top of page]

PSP.PSP_EFFORT_REPORT_ELEMENTS does not reference any database object

PSP.PSP_EFFORT_REPORT_ELEMENTS is referenced by following:

APPS
SYNONYM - PSP_EFFORT_REPORT_ELEMENTS
TRIGGER - PSP_EFFORT_REPORT_ELEMENTS_WHO

[top of page]

Table: PSP_EFFORT_REPORT_PERIODS

Description: Contains predefined standard period names
Primary Key: PSP_EFFORT_REPORT_PERIODS_PK
  1. EFFORT_REPORT_PERIOD_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_EFFORT_REPORT_TEMPLATES.EFFORT_REPORT_PERIOD_NAME PSP_EFFORT_REPORT_PERIODS

[top of page]

PSP.PSP_EFFORT_REPORT_PERIODS does not reference any database object

PSP.PSP_EFFORT_REPORT_PERIODS is referenced by following:

APPS
SYNONYM - PSP_EFFORT_REPORT_PERIODS
TRIGGER - PSP_EFFORT_REPORT_PERIODS_WHO

[top of page]

Table: PSP_EFFORT_REPORT_TEMPLATES

Description: Contains effort report criteria and template information
Primary Key: PSP_EFFORT_REPORT_TEMPLATES_PK
  1. TEMPLATE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_EFFORT_REPORT_TEMPLATES.EFFORT_REPORT_PERIOD_NAME PSP_EFFORT_REPORT_PERIODS
PSP_EFFORT_REPORT_TEMPLATES.PEOPLE_GROUP_ID PAY_PEOPLE_GROUPS
PSP_EFFORT_REPORT_TEMPLATES.GL_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
PSP_EFFORT_REPORT_TEMPLATES.ELEMENT_TYPE_ID PA_EXPENDITURE_TYPES
PSP_EFFORT_REPORT_TEMPLATES.TASK_ID PA_TASKS
PSP_EFFORT_REPORT_TEMPLATES.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
PSP_EFFORT_REPORT_TEMPLATES.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_EFFORT_ERRORS.TEMPLATE_ID PSP_EFFORT_REPORT_TEMPLATES
PSP_EFFORT_REPORTS.TEMPLATE_ID PSP_EFFORT_REPORT_TEMPLATES
PSP_TEMPLATE_AWARDS.TEMPLATE_ID PSP_EFFORT_REPORT_TEMPLATES
PSP_TEMPLATE_ORGANIZATIONS.TEMPLATE_ID PSP_EFFORT_REPORT_TEMPLATES
PSP_TEMPLATE_PROJECTS.TEMPLATE_ID PSP_EFFORT_REPORT_TEMPLATES

[top of page]

PSP.PSP_EFFORT_REPORT_TEMPLATES does not reference any database object

PSP.PSP_EFFORT_REPORT_TEMPLATES is referenced by following:

APPS
SYNONYM - PSP_EFFORT_REPORT_TEMPLATES
TRIGGER - PSP_EFFORT_REPORT_TEMPLATE_WHO

[top of page]

Table: PSP_EFF_REPORTS

Description:
Primary Key: PSP_EFF_REPORT_PK
  1. EFFORT_REPORT_ID

[top of page]

PSP.PSP_EFF_REPORTS does not reference any database object

PSP.PSP_EFF_REPORTS is referenced by following:

APPS
SYNONYM - PSP_EFF_REPORTS
TRIGGER - PSP_EFF_REPORTS_WHO

[top of page]

Table: PSP_EFF_REPORT_APPROVALS

Description:
Primary Key: PSP_EFF_REPORT_APPROVALS_PK
  1. EFFORT_REPORT_APPROVAL_ID

[top of page]

PSP.PSP_EFF_REPORT_APPROVALS does not reference any database object

PSP.PSP_EFF_REPORT_APPROVALS is referenced by following:

APPS
SYNONYM - PSP_EFF_REPORT_APPROVALS
TRIGGER - PSP_EFF_REPORT_APPROVALS_WHO

[top of page]

Table: PSP_EFF_REPORT_DETAILS

Description:
Primary Key: PSP_EFF_REPORT_DETAILS_PK
  1. EFFORT_REPORT_ID
  2. EFFORT_REPORT_DETAIL_ID

[top of page]

PSP.PSP_EFF_REPORT_DETAILS does not reference any database object

PSP.PSP_EFF_REPORT_DETAILS is referenced by following:

APPS
SYNONYM - PSP_EFF_REPORT_DETAILS
TRIGGER - PSP_EFF_REPORT_DETAILS_WHO

[top of page]

Table: PSP_ELEMENT_GROUPS

Description: Contains element groups defined for Labor Distribution
Primary Key: PSP_ELEMENT_GROUPS_PK
  1. ELEMENT_GROUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_SCHEDULE_HIERARCHY.ELEMENT_GROUP_ID PSP_ELEMENT_GROUPS

[top of page]

PSP.PSP_ELEMENT_GROUPS does not reference any database object

PSP.PSP_ELEMENT_GROUPS is referenced by following:

APPS
SYNONYM - PSP_ELEMENT_GROUPS
TRIGGER - PSP_ELEMENT_GROUPS_WHO

[top of page]

Table: PSP_ELEMENT_TYPES

Description: Stores element types imported from Oracle HRMS
Primary Key: PSP_ELEMENT_TYPES_PK
  1. ELEMENT_TYPE_ID
  2. START_DATE_ACTIVE
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_ELEMENT_TYPE_ACCOUNTS.ELEMENT_TYPE_ID
PSP_ELEMENT_TYPE_ACCOUNTS.START_DATE_ACTIVE 		PSP_ELEMENT_TYPES
PSP_GROUP_ELEMENT_LIST.ELEMENT_TYPE_ID
PSP_GROUP_ELEMENT_LIST.START_DATE_ACTIVE 		PSP_ELEMENT_TYPES

[top of page]

PSP.PSP_ELEMENT_TYPES does not reference any database object

PSP.PSP_ELEMENT_TYPES is referenced by following:

APPS
SYNONYM - PSP_ELEMENT_TYPES
TRIGGER - PSP_ELEMENT_TYPES_WHO

[top of page]

Table: PSP_ELEMENT_TYPE_ACCOUNTS

Description: Stores global elements accounts
Primary Key: PSP_ELEMENT_TYPE_ACCOUNTS_PK
  1. ELEMENT_ACCOUNT_ID
Primary Key: PSP_ELEMENT_TYPE_ACCOUNTS_U1
  1. ELEMENT_TYPE_ID
  2. START_DATE_ACTIVE
  3. GL_CODE_COMBINATION_ID
  4. PROJECT_ID
  5. EXPENDITURE_ORGANIZATION_ID
  6. EXPENDITURE_TYPE
  7. TASK_ID
  8. AWARD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_ELEMENT_TYPE_ACCOUNTS.ELEMENT_TYPE_ID
PSP_ELEMENT_TYPE_ACCOUNTS.START_DATE_ACTIVE 		PSP_ELEMENT_TYPES
PSP_ELEMENT_TYPE_ACCOUNTS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
PSP_ELEMENT_TYPE_ACCOUNTS.GL_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
PSP_ELEMENT_TYPE_ACCOUNTS.PROJECT_ID PA_PROJECTS_ALL
PSP_ELEMENT_TYPE_ACCOUNTS.EXPENDITURE_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
PSP_ELEMENT_TYPE_ACCOUNTS.EXPENDITURE_TYPE PA_EXPENDITURE_TYPES
PSP_ELEMENT_TYPE_ACCOUNTS.TASK_ID PA_TASKS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_DISTRIBUTION_LINES.ELEMENT_ACCOUNT_ID PSP_ELEMENT_TYPE_ACCOUNTS
PSP_DISTRIBUTION_LINES_HISTORY.ELEMENT_ACCOUNT_ID PSP_ELEMENT_TYPE_ACCOUNTS

[top of page]

PSP.PSP_ELEMENT_TYPE_ACCOUNTS does not reference any database object

PSP.PSP_ELEMENT_TYPE_ACCOUNTS is referenced by following:

APPS
SYNONYM - PSP_ELEMENT_TYPE_ACCOUNTS

[top of page]

Table: PSP_ENC_CHANGED_ASG_HISTORY

Description: This table contains the changed assignment records sucessfully processed by Update Encumbrance process. These records have been moved from PSP_ENC_CHANGED_ASSIGNMENTS.

[top of page]

PSP.PSP_ENC_CHANGED_ASG_HISTORY does not reference any database object

PSP.PSP_ENC_CHANGED_ASG_HISTORY is referenced by following:

APPS
SYNONYM - PSP_ENC_CHANGED_ASG_HISTORY

[top of page]

Table: PSP_ENC_CHANGED_ASSIGNMENTS

Description: This table captures all the changed assignments, used for Encumbrance Update process.
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_ENC_CHANGED_ASSIGNMENTS.PAYROLL_ID %

[top of page]

PSP.PSP_ENC_CHANGED_ASSIGNMENTS does not reference any database object

PSP.PSP_ENC_CHANGED_ASSIGNMENTS is referenced by following:

APPS
SYNONYM - PSP_ENC_CHANGED_ASSIGNMENTS

[top of page]

Table: PSP_ENC_CHANGED_SCHEDULES

Description: To log all the Account ID's which have been modified through Org Account Setup forms.

[top of page]

PSP.PSP_ENC_CHANGED_SCHEDULES does not reference any database object

PSP.PSP_ENC_CHANGED_SCHEDULES is referenced by following:

APPS
SYNONYM - PSP_ENC_CHANGED_SCHEDULES

[top of page]

Table: PSP_ENC_CHANGED_SCH_HISTORY

Description: To maintain history of Setup form changes

[top of page]

PSP.PSP_ENC_CHANGED_SCH_HISTORY does not reference any database object

PSP.PSP_ENC_CHANGED_SCH_HISTORY is referenced by following:

APPS
SYNONYM - PSP_ENC_CHANGED_SCH_HISTORY

[top of page]

Table: PSP_ENC_CONTROLS

Description: Stores one record for each time period batch
Primary Key: PSP_ENC_CONTROLS_PK
  1. ENC_CONTROL_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_ENC_SUMMARY_LINES.ENC_SUMMARY_LINE_ID PSP_ENC_CONTROLS

[top of page]

PSP.PSP_ENC_CONTROLS does not reference any database object

PSP.PSP_ENC_CONTROLS is referenced by following:

APPS
SYNONYM - PSP_ENC_CONTROLS
TRIGGER - PSP_ENC_CONTROLS_WHO

[top of page]

Table: PSP_ENC_ELEMENTS

Description: Stores information about Earnings, Regular, and Recurring elements
Primary Key: PSP_ENC_ELEMENTS_PK
  1. ENC_ELEMENT_ID

[top of page]

PSP.PSP_ENC_ELEMENTS does not reference any database object

PSP.PSP_ENC_ELEMENTS is referenced by following:

APPS
SYNONYM - PSP_ENC_ELEMENTS
TRIGGER - PSP_ENC_ELEMENTS_WHO

[top of page]

Table: PSP_ENC_END_DATES

Description: Stores information about default encumbrance period end dates
Primary Key: ORG_DATE
  1. ORGANIZATION_ID
  2. EFF_START_DATE
  3. EFF_END_DATE
Primary Key: PSP_ENC_END_DATES_PK
  1. ENC_END_DATE_ID

[top of page]

PSP.PSP_ENC_END_DATES does not reference any database object

PSP.PSP_ENC_END_DATES is referenced by following:

APPS
SYNONYM - PSP_ENC_END_DATES
TRIGGER - PSP_ENC_END_DATES_WHO

[top of page]

Table: PSP_ENC_LINES

Description: Stores encumbrance lines created by the Create Encumbrance and Update Encumbrance processes
Primary Key: PSP_ENC_LINES_PK
  1. ENC_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_ENC_LINES.PAYROLL_ID PSP_ENC_PAYROLLS
PSP_ENC_LINES.ENC_LINE_ID PSP_ENC_SUMMARY_LINES

[top of page]

PSP.PSP_ENC_LINES does not reference any database object

PSP.PSP_ENC_LINES is referenced by following:

APPS
SYNONYM - PSP_ENC_LINES
TRIGGER - PSP_ENC_LINES_WHO

[top of page]

Table: PSP_ENC_LINES_ARCH

Description: Stores archived Encumbrance Lines from the Encumbrance Lines History
Primary Key: PSP_ENC_LINES_ARCH_PK
  1. ENC_LINE_ID

[top of page]

PSP.PSP_ENC_LINES_ARCH does not reference any database object

PSP.PSP_ENC_LINES_ARCH is referenced by following:

APPS
SYNONYM - PSP_ENC_LINES_ARCH
TRIGGER - PSP_ENC_LINES_ARCH_WHO

[top of page]

Table: PSP_ENC_LINES_HISTORY

Description: Stores successful encumbrance lines transferred to General Ledger and Grants Accounting
Primary Key: PSP_ENC_LINES_HIST_PK
  1. ENC_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_ENC_LINES_HISTORY.ENC_LINE_ID PSP_ENC_SUMMARY_LINES

[top of page]

PSP.PSP_ENC_LINES_HISTORY does not reference any database object

PSP.PSP_ENC_LINES_HISTORY is referenced by following:

APPS
SYNONYM - PSP_ENC_LINES_HISTORY
TRIGGER - PSP_ENC_LINES_HISTORY_WHO

[top of page]

Table: PSP_ENC_PAYROLLS

Description: Stores encumbrance related payrolls
Primary Key: PEL_UK
  1. PAYROLL_ID
Primary Key: PSP_ENC_PAYROLLS_PK
  1. ENC_PAYROLL_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_ENC_LINES.PAYROLL_ID PSP_ENC_PAYROLLS
PSP_ENC_PAYROLL_ASSIGNMENTS.ENC_PAYROLL_ID PSP_ENC_PAYROLLS

[top of page]

PSP.PSP_ENC_PAYROLLS does not reference any database object

PSP.PSP_ENC_PAYROLLS is referenced by following:

APPS
SYNONYM - PSP_ENC_PAYROLLS
TRIGGER - PSP_ENC_PAYROLLS_WHO

[top of page]

Table: PSP_ENC_PAYROLL_ASSIGNMENTS

Description: Stores all assignments related to an encumbrance payroll
Primary Key: PSP_ENC_PAYROLL_ASSIGNMENTS_PK
  1. ENC_PAYROLL_ASSIGNMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_ENC_PAYROLL_ASSIGNMENTS.ENC_PAYROLL_ID PSP_ENC_PAYROLLS

[top of page]

PSP.PSP_ENC_PAYROLL_ASSIGNMENTS does not reference any database object

PSP.PSP_ENC_PAYROLL_ASSIGNMENTS is referenced by following:

APPS
SYNONYM - PSP_ENC_PAYROLL_ASSIGNMENTS
TRIGGER - PSP_ENC_PAYROLL_ASSIGNMENT_WHO

[top of page]

Table: PSP_ENC_SETUP_OPTIONS

Description: Stores all encumbrance related setup options
Primary Key: PSP_ENC_SETUP_OPTIONS_PK
  1. ENC_SETUP_OPTION_ID

[top of page]

PSP.PSP_ENC_SETUP_OPTIONS does not reference any database object

PSP.PSP_ENC_SETUP_OPTIONS is referenced by following:

APPS
SYNONYM - PSP_ENC_SETUP_OPTIONS
TRIGGER - PSP_ENC_SETUP_OPTIONS_WHO

[top of page]

Table: PSP_ENC_SUMMARY_LINES

Description: Stores summary of all summarized encumbrance lines
Primary Key: PSP_ENC_SUMMARY_LINES_PK
  1. ENC_SUMMARY_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_ENC_SUMMARY_LINES.ENC_SUMMARY_LINE_ID PSP_ENC_CONTROLS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_ENC_LINES.ENC_LINE_ID PSP_ENC_SUMMARY_LINES
PSP_ENC_LINES_HISTORY.ENC_LINE_ID PSP_ENC_SUMMARY_LINES

[top of page]

PSP.PSP_ENC_SUMMARY_LINES does not reference any database object

PSP.PSP_ENC_SUMMARY_LINES is referenced by following:

APPS
SYNONYM - PSP_ENC_SUMMARY_LINES
TRIGGER - PSP_ENC_SUMMARY_LINES_WHO

[top of page]

Table: PSP_ENC_SUMMARY_LINES_ARCH

Description: Stores the archived summary lines from summarized encumbrance lines
Primary Key: PSP_ENC_SUMMARY_LINES_ARCH_PK
  1. ENC_SUMMARY_LINE_ID

[top of page]

PSP.PSP_ENC_SUMMARY_LINES_ARCH does not reference any database object

PSP.PSP_ENC_SUMMARY_LINES_ARCH is referenced by following:

APPS
SYNONYM - PSP_ENC_SUMMARY_LINES_ARCH
TRIGGER - PSP_ENC_SUMMARY_LINES_ARCH_WHO

[top of page]

Table: PSP_ER_APPROVALS

Description: Contains identifier and password of the supervisor who certifies a given effort report
Primary Key: PSP_ER_APPROVALS_PK
  1. EFFORT_REPORT_ID
  2. VERSION_NUM
  3. APPROVING_PERSON_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_ER_APPROVALS.EFFORT_REPORT_ID
PSP_ER_APPROVALS.VERSION_NUM 		PSP_EFFORT_REPORTS

[top of page]

PSP.PSP_ER_APPROVALS does not reference any database object

PSP.PSP_ER_APPROVALS is referenced by following:

APPS
SYNONYM - PSP_ER_APPROVALS
TRIGGER - PSP_ER_APPROVALS_WHO

[top of page]

Table: PSP_EXTERNAL_EFFORT_LINES

Description:
Primary Key: PSP_EXTERNAL_EFFORT_LINES_PK
  1. EXTERNAL_EFFORT_LINE_ID

[top of page]

PSP.PSP_EXTERNAL_EFFORT_LINES does not reference any database object

PSP.PSP_EXTERNAL_EFFORT_LINES is referenced by following:

APPS
SYNONYM - PSP_EXTERNAL_EFFORT_LINES
TRIGGER - PSP_EXTERNAL_EFFORT_LINES_WHO

[top of page]

Table: PSP_GROUP_ELEMENT_LIST

Description: Intersection table of PSP_ELEMENT_GROUPS and PSP_ELEMENT_TYPES
Primary Key: PSP_GROUP_ELEMENT_LIST_PK
  1. ELEMENT_GROUP_ID
  2. ELEMENT_TYPE_ID
  3. START_DATE_ACTIVE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_GROUP_ELEMENT_LIST.ELEMENT_TYPE_ID
PSP_GROUP_ELEMENT_LIST.START_DATE_ACTIVE 		PSP_ELEMENT_TYPES

[top of page]

PSP.PSP_GROUP_ELEMENT_LIST does not reference any database object

PSP.PSP_GROUP_ELEMENT_LIST is referenced by following:

APPS
SYNONYM - PSP_GROUP_ELEMENT_LIST
TRIGGER - PSP_GROUP_ELEMENT_LIST_WHO

[top of page]

Table: PSP_LAYOUT_OPTIONS

Description:
Primary Key: PSP_LAYOUT_OPTIONS_PK
  1. REPORT_TEMPLATE_CODE
  2. LAYOUT_LOOKUP_TYPE
  3. LAYOUT_LOOKUP_CODE

[top of page]

PSP.PSP_LAYOUT_OPTIONS does not reference any database object

PSP.PSP_LAYOUT_OPTIONS is referenced by following:

APPS
SYNONYM - PSP_LAYOUT_OPTIONS
TRIGGER - PSP_LAYOUT_OPTIONS_WHO

[top of page]

Table: PSP_MATRIX_DRIVER

Description: Supports the matrix functionality in the Schedule Lines window

[top of page]

PSP.PSP_MATRIX_DRIVER does not reference any database object

PSP.PSP_MATRIX_DRIVER is referenced by following:

APPS
SYNONYM - PSP_MATRIX_DRIVER

[top of page]

Table: PSP_MATRIX_DRIVER2

Description: Supports the matrix functionality in the Monthly Schedule Summary
Primary Key: PSP_MATRIX_DRIVER2_PK
  1. SCHEDULE_LINE_ID
  2. PERIOD

[top of page]

PSP.PSP_MATRIX_DRIVER2 does not reference any database object

PSP.PSP_MATRIX_DRIVER2 is referenced by following:

APPS
SYNONYM - PSP_MATRIX_DRIVER2

[top of page]

Table: PSP_MATRIX_DRIVER3

Description: Contains data that is to be displayed in the Payroll Period Schedule Summary window
Primary Key: PSP_MATRIX_DRIVER3_PK
  1. SCHEDULE_LINE_ID
  2. PERIOD

[top of page]

PSP.PSP_MATRIX_DRIVER3 does not reference any database object

PSP.PSP_MATRIX_DRIVER3 is referenced by following:

APPS
SYNONYM - PSP_MATRIX_DRIVER3

[top of page]

Table: PSP_ORGANIZATION_ACCOUNTS

Description: Stores default and suspense accounts for organizations
Primary Key: PSP_ORGANIZATION_ACCOUNTS_PK
  1. ORGANIZATION_ACCOUNT_ID
Primary Key: PSP_ORGANIZATION_ACCOUNTS_U1
  1. ORGANIZATION_ID
  2. ACCOUNT_TYPE_CODE
  3. START_DATE_ACTIVE
  4. GL_CODE_COMBINATION_ID
  5. PROJECT_ID
  6. EXPENDITURE_ORGANIZATION_ID
  7. EXPENDITURE_TYPE
  8. TASK_ID
  9. AWARD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_ORGANIZATION_ACCOUNTS.ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
PSP_ORGANIZATION_ACCOUNTS.GL_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
PSP_ORGANIZATION_ACCOUNTS.PROJECT_ID PA_PROJECTS_ALL
PSP_ORGANIZATION_ACCOUNTS.EXPENDITURE_TYPE PA_EXPENDITURE_TYPES
PSP_ORGANIZATION_ACCOUNTS.TASK_ID PA_TASKS
PSP_ORGANIZATION_ACCOUNTS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_ADJUSTMENT_LINES.SUSPENSE_ORG_ACCOUNT_ID PSP_ORGANIZATION_ACCOUNTS
PSP_ADJUSTMENT_LINES_HISTORY.SUSPENSE_ORG_ACCOUNT_ID PSP_ORGANIZATION_ACCOUNTS
PSP_PRE_GEN_DIST_LINES.SUSPENSE_ORG_ACCOUNT_ID PSP_ORGANIZATION_ACCOUNTS
PSP_PRE_GEN_DIST_LINES_HISTORY.SUSPENSE_ORG_ACCOUNT_ID PSP_ORGANIZATION_ACCOUNTS

[top of page]

PSP.PSP_ORGANIZATION_ACCOUNTS does not reference any database object

PSP.PSP_ORGANIZATION_ACCOUNTS is referenced by following:

APPS
SYNONYM - PSP_ORGANIZATION_ACCOUNTS
TRIGGER - PSP_ORGANIZATION_ACCOUNTS_OVN
TRIGGER - PSP_ORGANIZATION_ACCOUNTS_WHO

[top of page]

Table: PSP_PAYROLL_CONTROLS

Description: Contains information for all imported payroll transactions
Primary Key: PSP_PAYROLL_CONTROLS_PK
  1. PAYROLL_CONTROL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_PAYROLL_CONTROLS.SOURCE_TYPE
PSP_PAYROLL_CONTROLS.PAYROLL_SOURCE_CODE 		PSP_PAYROLL_SOURCES
PSP_PAYROLL_CONTROLS.TIME_PERIOD_ID PER_TIME_PERIODS
PSP_PAYROLL_CONTROLS.PAYROLL_ACTION_ID PAY_PAYROLL_ACTIONS
PSP_PAYROLL_CONTROLS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
PSP_PAYROLL_CONTROLS.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_ADJUSTMENT_LINES.PAYROLL_CONTROL_ID PSP_PAYROLL_CONTROLS
PSP_ADJUSTMENT_LINES_HISTORY.PAYROLL_CONTROL_ID PSP_PAYROLL_CONTROLS
PSP_PAYROLL_LINES.PAYROLL_CONTROL_ID PSP_PAYROLL_CONTROLS
PSP_PRE_GEN_DIST_LINES.PAYROLL_CONTROL_ID PSP_PAYROLL_CONTROLS
PSP_PRE_GEN_DIST_LINES_HISTORY.PAYROLL_CONTROL_ID PSP_PAYROLL_CONTROLS
PSP_SUMMARY_LINES.PAYROLL_CONTROL_ID PSP_PAYROLL_CONTROLS

[top of page]

PSP.PSP_PAYROLL_CONTROLS does not reference any database object

PSP.PSP_PAYROLL_CONTROLS is referenced by following:

APPS
SYNONYM - PSP_PAYROLL_CONTROLS
TRIGGER - PSP_PAYROLL_CONTROLS_WHO

[top of page]

Table: PSP_PAYROLL_INTERFACE

Description: Contains non-Oracle payroll sublines information to be imported to Labor Distribution
Primary Key: PSP_PAYROLL_INTERFACE_PK
  1. BATCH_NAME
  2. PAYROLL_INTERFACE_ID
Primary Key: PSP_PAYROLL_INTERFACE_U1
  1. ASSIGNMENT_ID
  2. PAYROLL_PERIOD_ID
  3. ELEMENT_TYPE_ID
  4. SUB_LINE_START_DATE
  5. SUB_LINE_END_DATE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_PAYROLL_INTERFACE.PAYROLL_PERIOD_ID PER_TIME_PERIODS
PSP_PAYROLL_INTERFACE.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS

[top of page]

PSP.PSP_PAYROLL_INTERFACE does not reference any database object

PSP.PSP_PAYROLL_INTERFACE is referenced by following:

APPS
SYNONYM - PSP_PAYROLL_INTERFACE
TRIGGER - PSP_PAYROLL_INTERFACE_WHO

[top of page]

Table: PSP_PAYROLL_LINES

Description: Contains information on each payroll line imported from Oracle Payroll and non-Oracle payroll sources
Primary Key: PSP_PAYROLL_LINES_PK
  1. PAYROLL_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_PAYROLL_LINES.PAYROLL_CONTROL_ID PSP_PAYROLL_CONTROLS
PSP_PAYROLL_LINES.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
PSP_PAYROLL_LINES.COST_ID PAY_COSTS
PSP_PAYROLL_LINES.COST_ALLOCATION_KEYFLEX_ID PAY_COST_ALLOCATION_KEYFLEX
PSP_PAYROLL_LINES.GL_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_PAYROLL_SUB_LINES.PAYROLL_LINE_ID PSP_PAYROLL_LINES

[top of page]

PSP.PSP_PAYROLL_LINES does not reference any database object

PSP.PSP_PAYROLL_LINES is referenced by following:

APPS
SYNONYM - PSP_PAYROLL_LINES
TRIGGER - PSP_PAYROLL_LINES_WHO

[top of page]

Table: PSP_PAYROLL_SOURCES

Description: Stores payroll source codes for payroll source types
Primary Key: PSP_PAYROLL_SOURCES_PK
  1. SOURCE_TYPE
  2. SOURCE_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_ADJUSTMENT_LINES.SOURCE_TYPE
PSP_ADJUSTMENT_LINES.STATUS_CODE 		PSP_PAYROLL_SOURCES
PSP_ADJUSTMENT_LINES_HISTORY.SOURCE_TYPE
PSP_ADJUSTMENT_LINES_HISTORY.SOURCE_CODE 		PSP_PAYROLL_SOURCES
PSP_PAYROLL_CONTROLS.SOURCE_TYPE
PSP_PAYROLL_CONTROLS.PAYROLL_SOURCE_CODE 		PSP_PAYROLL_SOURCES

[top of page]

PSP.PSP_PAYROLL_SOURCES does not reference any database object

PSP.PSP_PAYROLL_SOURCES is referenced by following:

APPS
SYNONYM - PSP_PAYROLL_SOURCES
TRIGGER - PSP_PAYROLL_SOURCES_WHO

[top of page]

Table: PSP_PAYROLL_SUB_LINES

Description: Contains information where payroll amount in a payroll line is split into more than one subline
Primary Key: PSP_PAYROLL_SUB_LINES_PK
  1. PAYROLL_SUB_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_PAYROLL_SUB_LINES.PAYROLL_LINE_ID PSP_PAYROLL_LINES
PSP_PAYROLL_SUB_LINES.ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
PSP_PAYROLL_SUB_LINES.JOB_ID PER_JOBS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_DISTRIBUTION_LINES.PAYROLL_SUB_LINE_ID PSP_PAYROLL_SUB_LINES
PSP_DISTRIBUTION_LINES_HISTORY.PAYROLL_SUB_LINE_ID PSP_PAYROLL_SUB_LINES
PSP_SUB_LINE_REASONS.PAYROLL_SUB_LINE_ID PSP_PAYROLL_SUB_LINES

[top of page]

PSP.PSP_PAYROLL_SUB_LINES does not reference any database object

PSP.PSP_PAYROLL_SUB_LINES is referenced by following:

APPS
SYNONYM - PSP_PAYROLL_SUB_LINES
TRIGGER - PSP_PAYROLL_SUB_LINES_WHO

[top of page]

Table: PSP_PRE_GEN_DIST_LINES

Description: Stores pre-generated distribution lines that are not yet transferred to General Ledger or Grants Accounting
Primary Key: PSP_PRE_GEN_DIST_LINES_PK
  1. PRE_GEN_DIST_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_PRE_GEN_DIST_LINES.DISTRIBUTION_INTERFACE_ID PSP_DISTRIBUTION_INTERFACE
PSP_PRE_GEN_DIST_LINES.TIME_PERIOD_ID PER_TIME_PERIODS
PSP_PRE_GEN_DIST_LINES.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
PSP_PRE_GEN_DIST_LINES.GL_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
PSP_PRE_GEN_DIST_LINES.PROJECT_ID PA_PROJECTS_ALL
PSP_PRE_GEN_DIST_LINES.EXPENDITURE_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
PSP_PRE_GEN_DIST_LINES.EXPENDITURE_TYPE PA_EXPENDITURE_TYPES
PSP_PRE_GEN_DIST_LINES.TASK_ID PA_TASKS
PSP_PRE_GEN_DIST_LINES.SUSPENSE_ORG_ACCOUNT_ID PSP_ORGANIZATION_ACCOUNTS
PSP_PRE_GEN_DIST_LINES.EFFORT_REPORT_ID
PSP_PRE_GEN_DIST_LINES.VERSION_NUM 		PSP_EFFORT_REPORTS
PSP_PRE_GEN_DIST_LINES.SUMMARY_LINE_ID PSP_SUMMARY_LINES
PSP_PRE_GEN_DIST_LINES.PAYROLL_CONTROL_ID PSP_PAYROLL_CONTROLS

[top of page]

PSP.PSP_PRE_GEN_DIST_LINES does not reference any database object

PSP.PSP_PRE_GEN_DIST_LINES is referenced by following:

APPS
SYNONYM - PSP_PRE_GEN_DIST_LINES

[top of page]

Table: PSP_PRE_GEN_DIST_LINES_ARCH

Description: Stores archived pre-generated distribution lines present in the history tables
Primary Key: PSP_PRE_GEN_DIST_LINES_ARCH_PK
  1. PRE_GEN_DIST_LINE_ID

[top of page]

PSP.PSP_PRE_GEN_DIST_LINES_ARCH does not reference any database object

PSP.PSP_PRE_GEN_DIST_LINES_ARCH is referenced by following:

APPS
SYNONYM - PSP_PRE_GEN_DIST_LINES_ARCH

[top of page]

Table: PSP_PRE_GEN_DIST_LINES_HISTORY

Description: Stores pre-generated distribution lines that are successfully transferred to General Ledger and Grants Accounting
Primary Key: PSP_PRE_GEN_DIST_LINES_HIST_PK
  1. PRE_GEN_DIST_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_PRE_GEN_DIST_LINES_HISTORY.DISTRIBUTION_INTERFACE_ID PSP_DISTRIBUTION_INTERFACE
PSP_PRE_GEN_DIST_LINES_HISTORY.PAYROLL_CONTROL_ID PSP_PAYROLL_CONTROLS
PSP_PRE_GEN_DIST_LINES_HISTORY.TIME_PERIOD_ID PER_TIME_PERIODS
PSP_PRE_GEN_DIST_LINES_HISTORY.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
PSP_PRE_GEN_DIST_LINES_HISTORY.GL_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
PSP_PRE_GEN_DIST_LINES_HISTORY.PROJECT_ID PA_PROJECTS_ALL
PSP_PRE_GEN_DIST_LINES_HISTORY.EXPENDITURE_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
PSP_PRE_GEN_DIST_LINES_HISTORY.EXPENDITURE_TYPE PA_EXPENDITURE_TYPES
PSP_PRE_GEN_DIST_LINES_HISTORY.TASK_ID PA_TASKS
PSP_PRE_GEN_DIST_LINES_HISTORY.SUSPENSE_ORG_ACCOUNT_ID PSP_ORGANIZATION_ACCOUNTS
PSP_PRE_GEN_DIST_LINES_HISTORY.SUMMARY_LINE_ID PSP_SUMMARY_LINES

[top of page]

PSP.PSP_PRE_GEN_DIST_LINES_HISTORY does not reference any database object

PSP.PSP_PRE_GEN_DIST_LINES_HISTORY is referenced by following:

APPS
SYNONYM - PSP_PRE_GEN_DIST_LINES_HISTORY

[top of page]

Table: PSP_REPORT_DETAILS

Description:
Primary Key: PSP_REPORT_DETAILS_PK
  1. REPORT_DETAIL_ID

[top of page]

PSP.PSP_REPORT_DETAILS does not reference any database object

PSP.PSP_REPORT_DETAILS is referenced by following:

APPS
SYNONYM - PSP_REPORT_DETAILS
TRIGGER - PSP_REPORT_DETAILS_WHO

[top of page]

Table: PSP_REPORT_ERRORS

Description: Contains data for the Warning Report
Primary Key: PSP_REPORT_ERRORS_PK
  1. ERROR_SEQUENCE_ID
  2. REQUEST_ID

[top of page]

PSP.PSP_REPORT_ERRORS does not reference any database object

PSP.PSP_REPORT_ERRORS is referenced by following:

APPS
SYNONYM - PSP_REPORT_ERRORS

[top of page]

Table: PSP_REPORT_PERIOD_FREQUENCY_B

Description: Stores user defined or seeded period frequencies used in effort report templates.
Primary Key: PSP_REPORT_PERIOD_FREQ_B_PK
  1. PERIOD_FREQUENCY_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_REPORT_PERIOD_FREQUENCY_TL.PERIOD_FREQUENCY_ID PSP_REPORT_PERIOD_FREQUENCY_B

[top of page]

PSP.PSP_REPORT_PERIOD_FREQUENCY_B does not reference any database object

PSP.PSP_REPORT_PERIOD_FREQUENCY_B is referenced by following:

APPS
SYNONYM - PSP_REPORT_PERIOD_FREQUENCY_B
TRIGGER - PSP_REPORT_PERIOD_FREQUENC_WHO

[top of page]

Table: PSP_REPORT_PERIOD_FREQUENCY_TL

Description: The translation table for psp_report_period_frequency
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_REPORT_PERIOD_FREQUENCY_TL.PERIOD_FREQUENCY_ID PSP_REPORT_PERIOD_FREQUENCY_B

[top of page]

PSP.PSP_REPORT_PERIOD_FREQUENCY_TL does not reference any database object

PSP.PSP_REPORT_PERIOD_FREQUENCY_TL is referenced by following:

APPS
TRIGGER - PSP_REPORT_PERIOD_FR041249_WHO
SYNONYM - PSP_REPORT_PERIOD_FREQUENCY_TL

[top of page]

Table: PSP_REPORT_TEMPLATES

Description: Stores details of Effort report template
Primary Key: PSP_REPORT_TEMPLATES_PK
  1. TEMPLATE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_REPORT_TEMPLATE_DETAILS.TEMPLATE_ID PSP_REPORT_TEMPLATES

[top of page]

PSP.PSP_REPORT_TEMPLATES does not reference any database object

PSP.PSP_REPORT_TEMPLATES is referenced by following:

APPS
SYNONYM - PSP_REPORT_TEMPLATES
TRIGGER - PSP_REPORT_TEMPLATES_WHO

[top of page]

Table: PSP_REPORT_TEMPLATES_H

Description: Stores history details of Effort report template
Primary Key: PSP_REPORT_TEMPLATES_H_PK
  1. REQUEST_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_REPORT_TEMPLATE_DETAILS_H.REQUEST_ID PSP_REPORT_TEMPLATES_H

[top of page]

PSP.PSP_REPORT_TEMPLATES_H does not reference any database object

PSP.PSP_REPORT_TEMPLATES_H is referenced by following:

APPS
SYNONYM - PSP_REPORT_TEMPLATES_H

[top of page]

Table: PSP_REPORT_TEMPLATE_DETAILS

Description: Stores details records of Effort report templates
Primary Key: PSP_REPORT_TEMPLATE_DETAILS_PK
  1. TEMPLATE_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_REPORT_TEMPLATE_DETAILS.TEMPLATE_ID PSP_REPORT_TEMPLATES

[top of page]

PSP.PSP_REPORT_TEMPLATE_DETAILS does not reference any database object

PSP.PSP_REPORT_TEMPLATE_DETAILS is referenced by following:

APPS
SYNONYM - PSP_REPORT_TEMPLATE_DETAILS
TRIGGER - PSP_REPORT_TEMPLATE_DETAIL_WHO

[top of page]

Table: PSP_REPORT_TEMPLATE_DETAILS_H

Description: Stores historyf records of Effort report templates details
Primary Key: PSP_RPT_TEMPLATE_DETAILS_H_PK
  1. REQUEST_ID
  2. TEMPLATE_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_REPORT_TEMPLATE_DETAILS_H.REQUEST_ID PSP_REPORT_TEMPLATES_H

[top of page]

PSP.PSP_REPORT_TEMPLATE_DETAILS_H does not reference any database object

PSP.PSP_REPORT_TEMPLATE_DETAILS_H is referenced by following:

APPS
SYNONYM - PSP_REPORT_TEMPLATE_DETAILS_H

[top of page]

Table: PSP_REP_ORG_DLS

Description: Contains data to be displayed in Organizational Default Labor Schedules report
Primary Key: PSP_REP_ORG_DLS_UK
  1. ORG_DLS_LINE_ID

[top of page]

PSP.PSP_REP_ORG_DLS does not reference any database object

PSP.PSP_REP_ORG_DLS is referenced by following:

APPS
SYNONYM - PSP_REP_ORG_DLS
TRIGGER - PSP_REP_ORG_DLS_WHO

[top of page]

Table: PSP_SCHEDULES

Description: Stores schedules corresponding to assignments in Oracle Human Resources
Primary Key: PSP_SCHEDULES_PK
  1. ASSIGNMENT_ID
  2. BUSINESS_GROUP_ID
  3. SET_OF_BOOKS_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_SCHEDULE_HIERARCHY.ASSIGNMENT_ID
PSP_SCHEDULE_HIERARCHY.BUSINESS_GROUP_ID
PSP_SCHEDULE_HIERARCHY.SET_OF_BOOKS_ID 		PSP_SCHEDULES

[top of page]

PSP.PSP_SCHEDULES does not reference any database object

PSP.PSP_SCHEDULES is referenced by following:

APPS
SYNONYM - PSP_SCHEDULES

[top of page]

Table: PSP_SCHEDULE_HIERARCHY

Description: Stores schedule hierarchy level information about the schedule
Primary Key: PSP_SCHEDULES_HIERARCHY_PK
  1. SCHEDULE_HIERARCHY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_SCHEDULE_HIERARCHY.ASSIGNMENT_ID
PSP_SCHEDULE_HIERARCHY.BUSINESS_GROUP_ID
PSP_SCHEDULE_HIERARCHY.SET_OF_BOOKS_ID 		PSP_SCHEDULES
PSP_SCHEDULE_HIERARCHY.ELEMENT_GROUP_ID PSP_ELEMENT_GROUPS
PSP_SCHEDULE_HIERARCHY.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
PSP_SCHEDULE_HIERARCHY.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_SCHEDULE_LINES.SCHEDULE_HIERARCHY_ID PSP_SCHEDULE_HIERARCHY

[top of page]

PSP.PSP_SCHEDULE_HIERARCHY does not reference any database object

PSP.PSP_SCHEDULE_HIERARCHY is referenced by following:

APPS
SYNONYM - PSP_SCHEDULE_HIERARCHY

[top of page]

Table: PSP_SCHEDULE_LINES

Description: Stores schedule lines associated with a particular schedule
Primary Key: PSP_SCHEDULE_LINES_PK
  1. SCHEDULE_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_SCHEDULE_LINES.SCHEDULE_HIERARCHY_ID PSP_SCHEDULE_HIERARCHY
PSP_SCHEDULE_LINES.GL_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
PSP_SCHEDULE_LINES.PROJECT_ID PA_PROJECTS_ALL
PSP_SCHEDULE_LINES.EXPENDITURE_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
PSP_SCHEDULE_LINES.EXPENDITURE_TYPE PA_EXPENDITURE_TYPES
PSP_SCHEDULE_LINES.TASK_ID PA_TASKS
PSP_SCHEDULE_LINES.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
PSP_SCHEDULE_LINES.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_DISTRIBUTION_LINES.SCHEDULE_LINE_ID PSP_SCHEDULE_LINES
PSP_DISTRIBUTION_LINES_HISTORY.SCHEDULE_LINE_ID PSP_SCHEDULE_LINES

[top of page]

PSP.PSP_SCHEDULE_LINES does not reference any database object

PSP.PSP_SCHEDULE_LINES is referenced by following:

APPS
SYNONYM - PSP_SCHEDULE_LINES

[top of page]

Table: PSP_SCH_PERIOD_TOTAL

Description:

[top of page]

PSP.PSP_SCH_PERIOD_TOTAL does not reference any database object

PSP.PSP_SCH_PERIOD_TOTAL is referenced by following:

APPS
SYNONYM - PSP_SCH_PERIOD_TOTAL

[top of page]

Table: PSP_SELECTED_PERSONS_T

Description:

[top of page]

PSP.PSP_SELECTED_PERSONS_T does not reference any database object

PSP.PSP_SELECTED_PERSONS_T is referenced by following:

APPS
SYNONYM - PSP_SELECTED_PERSONS_T

[top of page]

Table: PSP_SUB_LINE_REASONS

Description: Stores reasons for creating payroll sublines from payroll lines
Primary Key: PSP_SUB_LINE_REASONS_PK
  1. PAYROLL_SUB_LINE_ID
  2. REASON_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_SUB_LINE_REASONS.PAYROLL_SUB_LINE_ID PSP_PAYROLL_SUB_LINES

[top of page]

PSP.PSP_SUB_LINE_REASONS does not reference any database object

PSP.PSP_SUB_LINE_REASONS is referenced by following:

APPS
SYNONYM - PSP_SUB_LINE_REASONS
TRIGGER - PSP_SUB_LINE_REASONS_WHO

[top of page]

Table: PSP_SUMMARY_LINES

Description: Stores summarized distribution lines
Primary Key: PSP_SUMMARY_LINES_PK
  1. SUMMARY_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_SUMMARY_LINES.PAYROLL_CONTROL_ID PSP_PAYROLL_CONTROLS
PSP_SUMMARY_LINES.EXPENDITURE_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
PSP_SUMMARY_LINES.EXPENDITURE_TYPE PA_EXPENDITURE_TYPES
PSP_SUMMARY_LINES.TASK_ID PA_TASKS
PSP_SUMMARY_LINES.TIME_PERIOD_ID PER_TIME_PERIODS
PSP_SUMMARY_LINES.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
PSP_SUMMARY_LINES.GL_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
PSP_SUMMARY_LINES.PROJECT_ID PA_PROJECTS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
PSP_ADJUSTMENT_LINES.SUMMARY_LINE_ID PSP_SUMMARY_LINES
PSP_ADJUSTMENT_LINES_HISTORY.SUMMARY_LINE_ID PSP_SUMMARY_LINES
PSP_DISTRIBUTION_LINES.SUMMARY_LINE_ID PSP_SUMMARY_LINES
PSP_DISTRIBUTION_LINES_HISTORY.SUMMARY_LINE_ID PSP_SUMMARY_LINES
PSP_PRE_GEN_DIST_LINES.SUMMARY_LINE_ID PSP_SUMMARY_LINES
PSP_PRE_GEN_DIST_LINES_HISTORY.SUMMARY_LINE_ID PSP_SUMMARY_LINES

[top of page]

PSP.PSP_SUMMARY_LINES does not reference any database object

PSP.PSP_SUMMARY_LINES is referenced by following:

APPS
SYNONYM - PSP_SUMMARY_LINES
TRIGGER - PSP_SUMMARY_LINES_WHO

[top of page]

Table: PSP_SUMMARY_LINES_ARCH

Description: Stores archived Summary Lines
Primary Key: PSP_SUMMARY_LINES_ARCH_PK
  1. SUMMARY_LINE_ID

[top of page]

PSP.PSP_SUMMARY_LINES_ARCH does not reference any database object

PSP.PSP_SUMMARY_LINES_ARCH is referenced by following:

APPS
SYNONYM - PSP_SUMMARY_LINES_ARCH
TRIGGER - PSP_SUMMARY_LINES_ARCH_WHO

[top of page]

Table: PSP_TEMPLATE_AWARDS

Description: Stores multiple awards based on given selection criteria
Primary Key: PSP_TEMPLATE_AWARDS_PK
  1. TEMPLATE_ID
  2. AWARD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_TEMPLATE_AWARDS.TEMPLATE_ID PSP_EFFORT_REPORT_TEMPLATES

[top of page]

PSP.PSP_TEMPLATE_AWARDS does not reference any database object

PSP.PSP_TEMPLATE_AWARDS is referenced by following:

APPS
SYNONYM - PSP_TEMPLATE_AWARDS
TRIGGER - PSP_TEMPLATE_AWARDS_WHO

[top of page]

Table: PSP_TEMPLATE_ORGANIZATIONS

Description: Stores multiple organizations based on given selection criteria
Primary Key: PSP_TEMPLATE_ORGANIZATIONS_PK
  1. TEMPLATE_ID
  2. EXPENDITURE_ORGANIZATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_TEMPLATE_ORGANIZATIONS.TEMPLATE_ID PSP_EFFORT_REPORT_TEMPLATES
PSP_TEMPLATE_ORGANIZATIONS.EXPENDITURE_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS

[top of page]

PSP.PSP_TEMPLATE_ORGANIZATIONS does not reference any database object

PSP.PSP_TEMPLATE_ORGANIZATIONS is referenced by following:

APPS
SYNONYM - PSP_TEMPLATE_ORGANIZATIONS
TRIGGER - PSP_TEMPLATE_ORGANIZATIONS_WHO

[top of page]

Table: PSP_TEMPLATE_PROJECTS

Description: Stores multiple projects based on given selection criteria
Primary Key: PSP_TEMPLATE_PROJECTS_PK
  1. TEMPLATE_ID
  2. PROJECT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PSP_TEMPLATE_PROJECTS.TEMPLATE_ID PSP_EFFORT_REPORT_TEMPLATES
PSP_TEMPLATE_PROJECTS.PROJECT_ID PA_PROJECTS_ALL

[top of page]

PSP.PSP_TEMPLATE_PROJECTS does not reference any database object

PSP.PSP_TEMPLATE_PROJECTS is referenced by following:

APPS
SYNONYM - PSP_TEMPLATE_PROJECTS
TRIGGER - PSP_TEMPLATE_PROJECTS_WHO

[top of page]

Table: PSP_TEMP_DEST_SUMLINES

Description: Stores lines grouped by General Ledger or Grants Management accounts
Primary Key: PSP_TEMP_DEST_SUMLINES_PK
  1. ACCT_GROUP_ID
  2. RUN_ID

[top of page]

PSP.PSP_TEMP_DEST_SUMLINES does not reference any database object

PSP.PSP_TEMP_DEST_SUMLINES is referenced by following:

APPS
SYNONYM - PSP_TEMP_DEST_SUMLINES

[top of page]

Table: PSP_TEMP_ORIG_LINES

Description: Stores lines matching the selection criteria
Primary Key: PSP_TEMP_ORIG_LINES_PK
  1. RUN_ID
  2. ORIG_LINE_ID

[top of page]

PSP.PSP_TEMP_ORIG_LINES does not reference any database object

PSP.PSP_TEMP_ORIG_LINES is referenced by following:

APPS
SYNONYM - PSP_TEMP_ORIG_LINES

[top of page]

Table: PSP_TEMP_ORIG_SUMLINES

Description: Stores lines grouped by General Ledger and Grants Management accounts
Primary Key: PSP_TEMP_ORIG_SUMLINES_PK
  1. RUN_ID
  2. ACCT_GROUP_ID

[top of page]

PSP.PSP_TEMP_ORIG_SUMLINES does not reference any database object

PSP.PSP_TEMP_ORIG_SUMLINES is referenced by following:

APPS
SYNONYM - PSP_TEMP_ORIG_SUMLINES

[top of page]

Table: PSP_UPGRADE_115

Description: Log tables for upgrde program

[top of page]

PSP.PSP_UPGRADE_115 does not reference any database object

PSP.PSP_UPGRADE_115 is referenced by following:

APPS
SYNONYM - PSP_UPGRADE_115

[top of page]

View: PSP_ACCOUNTS_ELEMENTS_V

[top of page]

APPS.PSP_ACCOUNTS_ELEMENTS_V references the following:

APPS
VIEW - PSP_ELEMENT_TYPE_ACCOUNTS_V
PACKAGE - PSP_ORGANIZATION_ACCOUNTS_PKG

APPS.PSP_ACCOUNTS_ELEMENTS_V is not referenced by any database object

[top of page]

View: PSP_ACCOUNTS_ORGANIZATIONS_V

[top of page]

APPS.PSP_ACCOUNTS_ORGANIZATIONS_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - PSP_ORGANIZATION_ACCOUNTS_PKG
VIEW - PSP_ORGANIZATION_ACCOUNTS_V

APPS.PSP_ACCOUNTS_ORGANIZATIONS_V is not referenced by any database object

[top of page]

View: PSP_ADJUSTMENT_COMBO_V

[top of page]

APPS.PSP_ADJUSTMENT_COMBO_V references the following:

APPS
SYNONYM - PSP_ADJUSTMENT_LINES_HISTORY
SYNONYM - PSP_DISTRIBUTION_LINES_HISTORY
SYNONYM - PSP_PAYROLL_LINES
SYNONYM - PSP_PAYROLL_SUB_LINES
SYNONYM - PSP_PRE_GEN_DIST_LINES_HISTORY

APPS.PSP_ADJUSTMENT_COMBO_V is not referenced by any database object

[top of page]

View: PSP_ASG_SCHEDULE_V

[top of page]

APPS.PSP_ASG_SCHEDULE_V references the following:

APPS
SYNONYM - PSP_SCHEDULES

APPS.PSP_ASG_SCHEDULE_V is not referenced by any database object

[top of page]

View: PSP_ASSIGNMENTS_V

[top of page]

APPS.PSP_ASSIGNMENTS_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PAY_PAYROLLS_F
SYNONYM - PER_ALL_ASSIGNMENTS_F
VIEW - PER_ASSIGNMENTS_F2
SYNONYM - PER_ASSIGNMENT_STATUS_TYPES
VIEW - PER_PEOPLE_F
APPS.PSP_ASSIGNMENTS_V is referenced by following:

APPS
VIEW - PSP_SCHEDULES_V

[top of page]

View: PSP_AUTO_ACCTS_V

[top of page]

APPS.PSP_AUTO_ACCTS_V references the following:

APPS
SYNONYM - PSP_AUTO_ACCTS
SYNONYM - PSP_AUTO_RULES

APPS.PSP_AUTO_ACCTS_V is not referenced by any database object

[top of page]

View: PSP_AUTO_FILL_BEGIN_DATES_V

[top of page]

APPS.PSP_AUTO_FILL_BEGIN_DATES_V references the following:

APPS
SYNONYM - PSP_AUTO_FILL_DATES

APPS.PSP_AUTO_FILL_BEGIN_DATES_V is not referenced by any database object

[top of page]

View: PSP_AUTO_FILL_END_DATES_V

[top of page]

APPS.PSP_AUTO_FILL_END_DATES_V references the following:

APPS
SYNONYM - PSP_AUTO_FILL_DATES

APPS.PSP_AUTO_FILL_END_DATES_V is not referenced by any database object

[top of page]

View: PSP_AUTO_NA_BYPASS_V

[top of page]

APPS.PSP_AUTO_NA_BYPASS_V references the following:

APPS
SYNONYM - PSP_AUTO_NA_BYPASS

APPS.PSP_AUTO_NA_BYPASS_V is not referenced by any database object

[top of page]

View: PSP_AUTO_PARAMS_V

[top of page]

APPS.PSP_AUTO_PARAMS_V references the following:

APPS
SYNONYM - PSP_AUTO_LOOKUPS
SYNONYM - PSP_AUTO_PARAMS

APPS.PSP_AUTO_PARAMS_V is not referenced by any database object

[top of page]

View: PSP_BATCH_NAMES_V

[top of page]

APPS.PSP_BATCH_NAMES_V references the following:

APPS
SYNONYM - PSP_PAYROLL_CONTROLS

APPS.PSP_BATCH_NAMES_V is not referenced by any database object

[top of page]

View: PSP_DEFAULT_LABOR_SCHEDULES_V

[top of page]

APPS.PSP_DEFAULT_LABOR_SCHEDULES_V references the following:

APPS
SYNONYM - GMS_AWARDS_ALL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS
SYNONYM - PSP_DEFAULT_LABOR_SCHEDULES
PACKAGE - PSP_ORGANIZATION_ACCOUNTS_PKG
APPS.PSP_DEFAULT_LABOR_SCHEDULES_V is referenced by following:

APPS
VIEW - PSP_ORGANIZATION_SCHEDULES_V

[top of page]

View: PSP_DEST_ACCT_LINES_V

[top of page]

APPS.PSP_DEST_ACCT_LINES_V references the following:

APPS
SYNONYM - PSP_ELEMENT_GROUPS
PACKAGE - PSP_GENERAL
PACKAGE - PSP_ORGANIZATION_ACCOUNTS_PKG
SYNONYM - PSP_TEMP_DEST_SUMLINES

APPS.PSP_DEST_ACCT_LINES_V is not referenced by any database object

[top of page]

View: PSP_DISTRIBUTION_BATCH_NAME_V

[top of page]

APPS.PSP_DISTRIBUTION_BATCH_NAME_V references the following:

APPS
SYNONYM - PSP_DISTRIBUTION_INTERFACE
PACKAGE - PSP_GENERAL

APPS.PSP_DISTRIBUTION_BATCH_NAME_V is not referenced by any database object

[top of page]

View: PSP_DISTRIBUTION_INTERFACE_V

[top of page]

APPS.PSP_DISTRIBUTION_INTERFACE_V references the following:

APPS
SYNONYM - PSP_DISTRIBUTION_INTERFACE
PACKAGE - PSP_GENERAL
PACKAGE - PSP_ORGANIZATION_ACCOUNTS_PKG

APPS.PSP_DISTRIBUTION_INTERFACE_V is not referenced by any database object

[top of page]

View: PSP_DISTRIBUTION_INTERFACE_V2

[top of page]

APPS.PSP_DISTRIBUTION_INTERFACE_V2 references the following:

APPS
SYNONYM - PSP_DISTRIBUTION_INTERFACE

APPS.PSP_DISTRIBUTION_INTERFACE_V2 is not referenced by any database object

[top of page]

View: PSP_EFFORT_MESSAGES_V

[top of page]

APPS.PSP_EFFORT_MESSAGES_V references the following:

APPS
SYNONYM - PSP_EFFORT_MESSAGES

APPS.PSP_EFFORT_MESSAGES_V is not referenced by any database object

[top of page]

View: PSP_EFFORT_REPORT_ELEMENTS_V

[top of page]

APPS.PSP_EFFORT_REPORT_ELEMENTS_V references the following:

APPS
VIEW - PSP_ELEMENT_TYPES_V

APPS.PSP_EFFORT_REPORT_ELEMENTS_V is not referenced by any database object

[top of page]

View: PSP_EFFORT_REPORT_PERIODS_V

[top of page]

APPS.PSP_EFFORT_REPORT_PERIODS_V references the following:

APPS
SYNONYM - PSP_EFFORT_REPORT_PERIODS

APPS.PSP_EFFORT_REPORT_PERIODS_V is not referenced by any database object

[top of page]

View: PSP_ELEMENT_GROUPS_V

[top of page]

APPS.PSP_ELEMENT_GROUPS_V references the following:

APPS
SYNONYM - PSP_ELEMENT_GROUPS

APPS.PSP_ELEMENT_GROUPS_V is not referenced by any database object

[top of page]

View: PSP_ELEMENT_GROUP_V

[top of page]

APPS.PSP_ELEMENT_GROUP_V references the following:

APPS
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PSP_ELEMENT_GROUPS
SYNONYM - PSP_ELEMENT_TYPES
VIEW - PSP_ELEMENT_TYPES_V
SYNONYM - PSP_GROUP_ELEMENT_LIST

APPS.PSP_ELEMENT_GROUP_V is not referenced by any database object

[top of page]

View: PSP_ELEMENT_TYPES_V

[top of page]

APPS.PSP_ELEMENT_TYPES_V references the following:

APPS
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PSP_ELEMENT_TYPES
APPS.PSP_ELEMENT_TYPES_V is referenced by following:

APPS
VIEW - PSP_EFFORT_REPORT_ELEMENTS_V
VIEW - PSP_ELEMENT_GROUP_V

[top of page]

View: PSP_ELEMENT_TYPE_ACCOUNTS_V

[top of page]

APPS.PSP_ELEMENT_TYPE_ACCOUNTS_V references the following:

APPS
SYNONYM - GMS_AWARDS_ALL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS
SYNONYM - PSP_ELEMENT_TYPE_ACCOUNTS
PACKAGE - PSP_ORGANIZATION_ACCOUNTS_PKG
APPS.PSP_ELEMENT_TYPE_ACCOUNTS_V is referenced by following:

APPS
VIEW - PSP_ACCOUNTS_ELEMENTS_V

[top of page]

View: PSP_EMPLOYEES_V

[top of page]

APPS.PSP_EMPLOYEES_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PER_PEOPLE_F

APPS.PSP_EMPLOYEES_V is not referenced by any database object

[top of page]

View: PSP_ENC_EFFECTIVE_DATE_V

[top of page]

APPS.PSP_ENC_EFFECTIVE_DATE_V references the following:

APPS
SYNONYM - PSP_ENC_SETUP_OPTIONS

APPS.PSP_ENC_EFFECTIVE_DATE_V is not referenced by any database object

[top of page]

View: PSP_ENC_ELEMENTS_V

[top of page]

APPS.PSP_ENC_ELEMENTS_V references the following:

APPS
SYNONYM - FF_FORMULAS_F
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PAY_INPUT_VALUES_F
SYNONYM - PSP_ENC_ELEMENTS

APPS.PSP_ENC_ELEMENTS_V is not referenced by any database object

[top of page]

View: PSP_ENC_END_DATES_V

[top of page]

APPS.PSP_ENC_END_DATES_V references the following:

APPS
SYNONYM - PSP_ENC_END_DATES
APPS.PSP_ENC_END_DATES_V is referenced by following:

APPS
PACKAGE BODY - PSP_ENC_CREATE_LINES

[top of page]

View: PSP_ENC_END_DATE_ORG_V

[top of page]

APPS.PSP_ENC_END_DATE_ORG_V references the following:

APPS
SYNONYM - PSP_ENC_END_DATES

APPS.PSP_ENC_END_DATE_ORG_V is not referenced by any database object

[top of page]

View: PSP_ENC_PAYROLLS_V

[top of page]

APPS.PSP_ENC_PAYROLLS_V references the following:

APPS
SYNONYM - PSP_ENC_PAYROLLS
PACKAGE - PSP_GENERAL

APPS.PSP_ENC_PAYROLLS_V is not referenced by any database object

[top of page]

View: PSP_ENC_PAYROLL_ASSIGNMENT_V

[top of page]

APPS.PSP_ENC_PAYROLL_ASSIGNMENT_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PAY_PAYROLLS_F
SYNONYM - PER_ALL_ASSIGNMENTS_F
SYNONYM - PER_ALL_PEOPLE_F
VIEW - PER_ASSIGNMENTS_F
SYNONYM - PER_ASSIGNMENT_STATUS_TYPES
VIEW - PER_PEOPLE_F
SYNONYM - PSP_ENC_PAYROLLS
SYNONYM - PSP_ENC_PAYROLL_ASSIGNMENTS
APPS.PSP_ENC_PAYROLL_ASSIGNMENT_V is referenced by following:

APPS
PACKAGE BODY - PSP_ENC_CREATE_LINES

[top of page]

View: PSP_GROUP_ELEMENT_LIST_V

[top of page]

APPS.PSP_GROUP_ELEMENT_LIST_V references the following:

APPS
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PSP_ELEMENT_TYPES
SYNONYM - PSP_GROUP_ELEMENT_LIST

APPS.PSP_GROUP_ELEMENT_LIST_V is not referenced by any database object

[top of page]

View: PSP_LOOKUPS

[top of page]

APPS.PSP_LOOKUPS references the following:

APPS
SYNONYM - FND_LOOKUP_TYPES
SYNONYM - FND_LOOKUP_VALUES
APPS.PSP_LOOKUPS is referenced by following:

APPS
PACKAGE BODY - PSP_GENERAL
VIEW - PSP_PAYROLL_SOURCE_TYPES_V
PACKAGE BODY - PSP_PSPENEXR_XMLP_PKG
PACKAGE BODY - PSP_PSPRCDLS_XMLP_PKG
PACKAGE BODY - PSP_PSPRCLSL_XMLP_PKG
PACKAGE BODY - PSP_PSPRCPGD_XMLP_PKG
PACKAGE BODY - PSP_PSPRCSLD_XMLP_PKG

[top of page]

View: PSP_MATRIX_DRIVER2_V

[top of page]

APPS.PSP_MATRIX_DRIVER2_V references the following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS
SYNONYM - PSP_MATRIX_DRIVER2
PACKAGE - PSP_MATRIX_DRIVER2_PKG
PACKAGE - PSP_ORGANIZATION_ACCOUNTS_PKG
SYNONYM - PSP_SCHEDULE_LINES

APPS.PSP_MATRIX_DRIVER2_V is not referenced by any database object

[top of page]

View: PSP_MATRIX_DRIVER3_V

[top of page]

APPS.PSP_MATRIX_DRIVER3_V references the following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS
SYNONYM - PSP_MATRIX_DRIVER3
PACKAGE - PSP_MATRIX_DRIVER3_PKG
PACKAGE - PSP_ORGANIZATION_ACCOUNTS_PKG
SYNONYM - PSP_SCHEDULE_LINES

APPS.PSP_MATRIX_DRIVER3_V is not referenced by any database object

[top of page]

View: PSP_MATRIX_DRIVER_V

[top of page]

APPS.PSP_MATRIX_DRIVER_V references the following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS
SYNONYM - PSP_MATRIX_DRIVER
PACKAGE - PSP_MATRIX_DRIVER_PKG
PACKAGE - PSP_ORGANIZATION_ACCOUNTS_PKG
SYNONYM - PSP_SCHEDULE_LINES

APPS.PSP_MATRIX_DRIVER_V is not referenced by any database object

[top of page]

View: PSP_ORGANIZATION_ACCOUNTS_V

[top of page]

APPS.PSP_ORGANIZATION_ACCOUNTS_V references the following:

APPS
SYNONYM - GMS_AWARDS_ALL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS
SYNONYM - PSP_ORGANIZATION_ACCOUNTS
PACKAGE - PSP_ORGANIZATION_ACCOUNTS_PKG
APPS.PSP_ORGANIZATION_ACCOUNTS_V is referenced by following:

APPS
VIEW - PSP_ACCOUNTS_ORGANIZATIONS_V

[top of page]

View: PSP_ORGANIZATION_SCHEDULES_V

[top of page]

APPS.PSP_ORGANIZATION_SCHEDULES_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
VIEW - PSP_DEFAULT_LABOR_SCHEDULES_V
PACKAGE - PSP_ORGANIZATION_ACCOUNTS_PKG

APPS.PSP_ORGANIZATION_SCHEDULES_V is not referenced by any database object

[top of page]

View: PSP_ORIG_ACCT_LINES_V

[top of page]

APPS.PSP_ORIG_ACCT_LINES_V references the following:

APPS
SYNONYM - PSP_ELEMENT_GROUPS
PACKAGE - PSP_GENERAL
SYNONYM - PSP_TEMP_ORIG_SUMLINES

APPS.PSP_ORIG_ACCT_LINES_V is not referenced by any database object

[top of page]

View: PSP_ORIG_LINE_DETAILS_V

[top of page]

APPS.PSP_ORIG_LINE_DETAILS_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
VIEW - PAY_PAYROLLS_X
SYNONYM - PER_TIME_PERIODS
PACKAGE - PSP_GENERAL
SYNONYM - PSP_PAYROLL_CONTROLS
SYNONYM - PSP_PAYROLL_SOURCES
SYNONYM - PSP_TEMP_ORIG_LINES

APPS.PSP_ORIG_LINE_DETAILS_V is not referenced by any database object

[top of page]

View: PSP_PAYROLL_BATCH_NAMES_V

[top of page]

APPS.PSP_PAYROLL_BATCH_NAMES_V references the following:

APPS
PACKAGE - PSP_GENERAL
SYNONYM - PSP_PAYROLL_INTERFACE

APPS.PSP_PAYROLL_BATCH_NAMES_V is not referenced by any database object

[top of page]

View: PSP_PAYROLL_INTERFACE_V

[top of page]

APPS.PSP_PAYROLL_INTERFACE_V references the following:

APPS
PACKAGE - PSP_GENERAL
SYNONYM - PSP_PAYROLL_INTERFACE

APPS.PSP_PAYROLL_INTERFACE_V is not referenced by any database object

[top of page]

View: PSP_PAYROLL_SOURCE_TYPES_V

[top of page]

APPS.PSP_PAYROLL_SOURCE_TYPES_V references the following:

APPS
VIEW - PSP_LOOKUPS
SYNONYM - PSP_PAYROLL_SOURCES

APPS.PSP_PAYROLL_SOURCE_TYPES_V is not referenced by any database object

[top of page]

View: PSP_REP_DEF_CHG_V

[top of page]

APPS.PSP_REP_DEF_CHG_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
VIEW - PER_ASSIGNMENTS_F
SYNONYM - PSP_ADJUSTMENT_LINES_HISTORY
SYNONYM - PSP_DISTRIBUTION_LINES_HISTORY
SYNONYM - PSP_ORGANIZATION_ACCOUNTS
SYNONYM - PSP_PAYROLL_CONTROLS
SYNONYM - PSP_PAYROLL_LINES
SYNONYM - PSP_PAYROLL_SUB_LINES

APPS.PSP_REP_DEF_CHG_V is not referenced by any database object

[top of page]

View: PSP_REP_DEF_LOV_V

[top of page]

APPS.PSP_REP_DEF_LOV_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - PSP_ADJUSTMENT_LINES_HISTORY
SYNONYM - PSP_DISTRIBUTION_LINES_HISTORY
SYNONYM - PSP_ORGANIZATION_ACCOUNTS

APPS.PSP_REP_DEF_LOV_V is not referenced by any database object

[top of page]

View: PSP_REP_DIST_PRJ_V

[top of page]

APPS.PSP_REP_DIST_PRJ_V references the following:

APPS
SYNONYM - PSP_ADJUSTMENT_LINES_HISTORY
SYNONYM - PSP_DISTRIBUTION_LINES_HISTORY
SYNONYM - PSP_PAYROLL_CONTROLS
SYNONYM - PSP_PAYROLL_LINES
SYNONYM - PSP_PAYROLL_SUB_LINES
SYNONYM - PSP_SUMMARY_LINES

APPS.PSP_REP_DIST_PRJ_V is not referenced by any database object

[top of page]

View: PSP_REP_ENC_DEF_V

[top of page]

APPS.PSP_REP_ENC_DEF_V references the following:

APPS
SYNONYM - PSP_ENC_CONTROLS
SYNONYM - PSP_ENC_LINES
SYNONYM - PSP_ENC_LINES_HISTORY

APPS.PSP_REP_ENC_DEF_V is not referenced by any database object

[top of page]

View: PSP_REP_ENC_SSP_V

[top of page]

APPS.PSP_REP_ENC_SSP_V references the following:

APPS
SYNONYM - PSP_ENC_CONTROLS
SYNONYM - PSP_ENC_LINES
SYNONYM - PSP_ENC_LINES_HISTORY

APPS.PSP_REP_ENC_SSP_V is not referenced by any database object

[top of page]

View: PSP_REP_SCH_EMP_V

[top of page]

APPS.PSP_REP_SCH_EMP_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
VIEW - PER_ASSIGNMENTS_F
SYNONYM - PSP_SCHEDULES
SYNONYM - PSP_SCHEDULE_HIERARCHY
SYNONYM - PSP_SCHEDULE_LINES
APPS.PSP_REP_SCH_EMP_V is referenced by following:

APPS
PACKAGE BODY - PSP_ORG_DLS_PKG

[top of page]

View: PSP_REP_SSP_CHG1_V

[top of page]

APPS.PSP_REP_SSP_CHG1_V references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - PER_ALL_ASSIGNMENTS_F
SYNONYM - PER_TIME_PERIODS
SYNONYM - PSP_ADJUSTMENT_LINES_HISTORY
SYNONYM - PSP_DEFAULT_LABOR_SCHEDULES
SYNONYM - PSP_DISTRIBUTION_LINES_HISTORY
SYNONYM - PSP_ELEMENT_TYPE_ACCOUNTS
SYNONYM - PSP_ORGANIZATION_ACCOUNTS
SYNONYM - PSP_PAYROLL_CONTROLS
SYNONYM - PSP_PAYROLL_LINES
SYNONYM - PSP_PAYROLL_SUB_LINES
SYNONYM - PSP_PRE_GEN_DIST_LINES_HISTORY
SYNONYM - PSP_SCHEDULE_LINES

APPS.PSP_REP_SSP_CHG1_V is not referenced by any database object

[top of page]

View: PSP_REP_SSP_CHG_V

[top of page]

APPS.PSP_REP_SSP_CHG_V references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - PER_ALL_ASSIGNMENTS_F
SYNONYM - PSP_ADJUSTMENT_LINES_HISTORY
SYNONYM - PSP_DISTRIBUTION_LINES_HISTORY
SYNONYM - PSP_ORGANIZATION_ACCOUNTS
SYNONYM - PSP_PRE_GEN_DIST_LINES_HISTORY
SYNONYM - PSP_SUMMARY_LINES

APPS.PSP_REP_SSP_CHG_V is not referenced by any database object

[top of page]

View: PSP_SCHEDULES_V

[top of page]

APPS.PSP_SCHEDULES_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PER_PEOPLE_F
VIEW - PSP_ASSIGNMENTS_V
SYNONYM - PSP_SCHEDULES

APPS.PSP_SCHEDULES_V is not referenced by any database object

[top of page]

View: PSP_SCHEDULE_HIERARCHY_V

[top of page]

APPS.PSP_SCHEDULE_HIERARCHY_V references the following:

APPS
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PSP_ELEMENT_GROUPS
SYNONYM - PSP_SCHEDULE_HIERARCHY

APPS.PSP_SCHEDULE_HIERARCHY_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract