PSP Tables (86)

PSP - Labor Distribution — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
PSP_ADJUSTMENT_CONTROL_TABLE 38 Stores one record for each batch adjusted
PSP_ADJUSTMENT_LINES 56 Stores the original lines and the new lines to be transferred
PSP_ADJUSTMENT_LINES_ARCH 58 Stores the archived Adjustment Lines History
PSP_ADJUSTMENT_LINES_HISTORY 58 Stores adjusted lines that are successfully transferred
PSP_AUTO_ACCTS 16 Stores one record for every auto-population expenditure type and General Ledger account segment having defined rules
PSP_AUTO_BYPASS 8 Stores expenditure types that will be skipped by the auto-population process
PSP_AUTO_FILL_DATES 11 Contains auto-fill rules for begin and end dates
PSP_AUTO_LOOKUPS 16 Stores lookup codes and their descriptions used in the auto-population module of Labor Distribution
PSP_AUTO_NA_BYPASS 9 Natural Account By-pass table for Auto-population
PSP_AUTO_PARAMS 10 Stores one record for each parameter for each natural account or expenditure type record used in the auto-population module of Labor Distrib
PSP_AUTO_RULES 9 Stores rules associated with population of expenditure type or General Ledger account segment
PSP_AUTO_SEGMENTS 8 Stores Natural Account segment used for auto-population, for each business group and set of books combination
PSP_CLEARING_ACCOUNT 11 Stores clearing account required by Labor Distribution
PSP_DEFAULT_LABOR_SCHEDULES 37 Stores default labor schedules to be used when there are no schedules defined for an employee
PSP_DISTRIBUTION_INTERFACE 48 Contains distribution lines from pre-generated sources, such as timecards
PSP_DISTRIBUTION_LINES 47 Stores distributed Oracle and non-Oracle payroll sublines not yet transferred to General Ledger or Grants Accounting
PSP_DISTRIBUTION_LINES_ARCH 48 Stores archived Distribution Lines History
PSP_DISTRIBUTION_LINES_HISTORY 48 Stores distributed Oracle and non-Oracle payroll sublines not yet transferred to General Ledger or Grants Accounting
PSP_EFFORT_ERRORS 5 Contains data for the Warning Report
PSP_EFFORT_MESSAGES 9 Contains standard Certify and Review messages
PSP_EFFORT_REPORTS 21 Contains effort reports for employees for a specified time period
PSP_EFFORT_REPORT_DETAILS 17 Contains assorted details by charging account for a given effort report
PSP_EFFORT_REPORT_ELEMENTS 26 Stores elements to be included in effort reports
PSP_EFFORT_REPORT_PERIODS 13 Contains predefined standard period names
PSP_EFFORT_REPORT_TEMPLATES 47 Contains effort report criteria and template information
PSP_EFF_REPORTS 25 Contains effort report process request information
PSP_EFF_REPORT_APPROVALS 57 Contains effort report approval details for the workflow processes started
PSP_EFF_REPORT_DETAILS 86 Contains assorted details by charging account for a given effort report
PSP_ELEMENT_GROUPS 28 Contains element groups defined for Labor Distribution
PSP_ELEMENT_TYPES 28 Stores element types imported from Oracle HRMS
PSP_ELEMENT_TYPE_ACCOUNTS 37 Stores global elements accounts
PSP_ENC_CHANGED_ASG_HISTORY 12 This table contains the changed assignment records sucessfully processed by Update Encumbrance process. These records have been moved from
PSP_ENC_CHANGED_ASSIGNMENTS 10 This table captures all the changed assignments, used for Encumbrance Update process.
PSP_ENC_CHANGED_SCHEDULES 4 To log all the Account ID's which have been modified through Org Account Setup forms.
PSP_ENC_CHANGED_SCH_HISTORY 5 To maintain history of Setup form changes
PSP_ENC_CONTROLS 37 Stores one record for each time period batch
PSP_ENC_ELEMENTS 12 Stores information about Earnings, Regular, and Recurring elements
PSP_ENC_END_DATES 31 Stores information about default encumbrance period end dates
PSP_ENC_LINES 61 Stores encumbrance lines created by the Create Encumbrance and Update Encumbrance processes
PSP_ENC_LINES_ARCH 58 Stores archived Encumbrance Lines from the Encumbrance Lines History
PSP_ENC_LINES_HISTORY 58 Stores successful encumbrance lines transferred to General Ledger and Grants Accounting
PSP_ENC_PAYROLLS 26 Stores encumbrance related payrolls
PSP_ENC_PAYROLL_ASSIGNMENTS 10 Stores all assignments related to an encumbrance payroll
PSP_ENC_SETUP_OPTIONS 10 Stores all encumbrance related setup options
PSP_ENC_SUMMARY_LINES 74 Stores summary of all summarized encumbrance lines
PSP_ENC_SUMMARY_LINES_ARCH 73 Stores the archived summary lines from summarized encumbrance lines
PSP_ER_APPROVALS 9 Contains identifier and password of the supervisor who certifies a given effort report
PSP_EXTERNAL_EFFORT_LINES 37 Stores effort report lines information imported from external/custom processes
PSP_GROUP_ELEMENT_LIST 24 Intersection table of PSP_ELEMENT_GROUPS and PSP_ELEMENT_TYPES
PSP_LAYOUT_OPTIONS 15 Contains effort report template layout sorting/summarization/approval by details
PSP_MATRIX_DRIVER 5 Supports the matrix functionality in the Schedule Lines window
PSP_MATRIX_DRIVER2 3 Supports the matrix functionality in the Monthly Schedule Summary
PSP_MATRIX_DRIVER3 3 Contains data that is to be displayed in the Payroll Period Schedule Summary window
PSP_ORGANIZATION_ACCOUNTS 39 Stores default and suspense accounts for organizations
PSP_PAYROLL_CONTROLS 39 Contains information for all imported payroll transactions
PSP_PAYROLL_INTERFACE 47 Contains non-Oracle payroll sublines information to be imported to Labor Distribution
PSP_PAYROLL_LINES 30 Contains information on each payroll line imported from Oracle Payroll and non-Oracle payroll sources
PSP_PAYROLL_SOURCES 25 Stores payroll source codes for payroll source types
PSP_PAYROLL_SUB_LINES 37 Contains information where payroll amount in a payroll line is split into more than one subline
PSP_PRE_GEN_DIST_LINES 43 Stores pre-generated distribution lines that are not yet transferred to General Ledger or Grants Accounting
PSP_PRE_GEN_DIST_LINES_ARCH 45 Stores archived pre-generated distribution lines present in the history tables
PSP_PRE_GEN_DIST_LINES_HISTORY 45 Stores pre-generated distribution lines that are successfully transferred to General Ledger and Grants Accounting
PSP_REPORT_DETAILS 73 Contains detail level information for effort reports created before migrating to OA
PSP_REPORT_ERRORS 31 Contains data for the Warning Report
PSP_REPORT_PERIOD_FREQUENCY_B 12 Stores user defined or seeded period frequencies used in effort report templates.
PSP_REPORT_PERIOD_FREQUENCY_TL 10 The translation table for psp_report_period_frequency
PSP_REPORT_TEMPLATES 26 Stores details of Effort report template
PSP_REPORT_TEMPLATES_H 74 Stores history details of Effort report template
PSP_REPORT_TEMPLATE_DETAILS 14 Stores details records of Effort report templates
PSP_REPORT_TEMPLATE_DETAILS_H 13 Stores historyf records of Effort report templates details
PSP_REP_ORG_DLS 15 Contains data to be displayed in Organizational Default Labor Schedules report
PSP_SCHEDULES 26 Stores schedules corresponding to assignments in Oracle Human Resources
PSP_SCHEDULE_HIERARCHY 12 Stores schedule hierarchy level information about the schedule
PSP_SCHEDULE_LINES 39 Stores schedule lines associated with a particular schedule
PSP_SCH_PERIOD_TOTAL 5
PSP_SELECTED_PERSONS_T 4 Contains list of person, assignments processed by a create effort report process
PSP_SUB_LINE_REASONS 8 Stores reasons for creating payroll sublines from payroll lines
PSP_SUMMARY_LINES 69 Stores summarized distribution lines
PSP_SUMMARY_LINES_ARCH 68 Stores archived Summary Lines
PSP_TEMPLATE_AWARDS 8 Stores multiple awards based on given selection criteria
PSP_TEMPLATE_ORGANIZATIONS 8 Stores multiple organizations based on given selection criteria
PSP_TEMPLATE_PROJECTS 8 Stores multiple projects based on given selection criteria
PSP_TEMP_DEST_SUMLINES 30 Stores lines grouped by General Ledger or Grants Management accounts
PSP_TEMP_ORIG_LINES 31 Stores lines matching the selection criteria
PSP_TEMP_ORIG_SUMLINES 27 Stores lines grouped by General Ledger and Grants Management accounts
PSP_UPGRADE_115 6 Log tables for upgrde program