Table: PSP_ER_APPROVALS | Oracle EBS ETRM Search

Table: PSP_ER_APPROVALS 12.1.1 satellite-leaning

owner PSP·PSP - Labor Distribution·9 columns

Contains identifier and password of the supervisor who certifies a given effort report

PSP.PSP_ER_APPROVALS·Explore PSP module →

Table: PSP_EFFORT_REPORT_DETAILS 12.1.1 link

owner PSP·PSP - Labor Distribution·17 columns

Contains assorted details by charging account for a given effort report

PSP.PSP_EFFORT_REPORT_DETAILS·Explore PSP module →

Table: PSP_EFFORT_REPORT_DETAILS 12.2.2 link

owner PSP·PSP - Labor Distribution·17 columns

Contains assorted details by charging account for a given effort report

PSP.PSP_EFFORT_REPORT_DETAILS·Explore PSP module →

Table: PSP_ER_APPROVALS 12.2.2 satellite-leaning

owner PSP·PSP - Labor Distribution·9 columns

Contains identifier and password of the supervisor who certifies a given effort report

PSP.PSP_ER_APPROVALS·Explore PSP module →

Table: PSP_EFFORT_REPORTS 12.1.1 hub-leaning

owner PSP·PSP - Labor Distribution·21 columns

Contains effort reports for employees for a specified time period

PSP.PSP_EFFORT_REPORTS·Explore PSP module →

Table: PSP_PRE_GEN_DIST_LINES_ARCH 12.1.1 standalone

owner PSP·PSP - Labor Distribution·45 columns

Stores archived pre-generated distribution lines present in the history tables

PSP.PSP_PRE_GEN_DIST_LINES_ARCH·Explore PSP module →

Table: PSP_PRE_GEN_DIST_LINES_HISTORY 12.2.2 link

owner PSP·PSP - Labor Distribution·45 columns

Stores pre-generated distribution lines that are successfully transferred to General Ledger and Grants Accounting

PSP.PSP_PRE_GEN_DIST_LINES_HISTORY·Explore PSP module →

Table: PSP_DISTRIBUTION_LINES 12.1.1 link

owner PSP·PSP - Labor Distribution·47 columns

Stores distributed Oracle and non-Oracle payroll sublines not yet transferred to General Ledger or Grants Accounting

PSP.PSP_DISTRIBUTION_LINES·Explore PSP module →

Table: PSP_ADJUSTMENT_LINES 12.1.1 link

owner PSP·PSP - Labor Distribution·56 columns

Stores the original lines and the new lines to be transferred

PSP.PSP_ADJUSTMENT_LINES·Explore PSP module →

Table: PSP_EFFORT_REPORTS 12.2.2 hub-leaning

owner PSP·PSP - Labor Distribution·21 columns

Contains effort reports for employees for a specified time period

PSP.PSP_EFFORT_REPORTS·Explore PSP module →

Table: PSP_PRE_GEN_DIST_LINES 12.1.1 link

owner PSP·PSP - Labor Distribution·43 columns

Stores pre-generated distribution lines that are not yet transferred to General Ledger or Grants Accounting

PSP.PSP_PRE_GEN_DIST_LINES·Explore PSP module →

Table: PSP_PRE_GEN_DIST_LINES_ARCH 12.2.2 standalone

owner PSP·PSP - Labor Distribution·45 columns

Stores archived pre-generated distribution lines present in the history tables

PSP.PSP_PRE_GEN_DIST_LINES_ARCH·Explore PSP module →

Table: PSP_PRE_GEN_DIST_LINES 12.2.2 link

owner PSP·PSP - Labor Distribution·43 columns

Stores pre-generated distribution lines that are not yet transferred to General Ledger or Grants Accounting

PSP.PSP_PRE_GEN_DIST_LINES·Explore PSP module →

Table: PSP_ADJUSTMENT_LINES_ARCH 12.1.1 standalone

owner PSP·PSP - Labor Distribution·58 columns

Stores the archived Adjustment Lines History

PSP.PSP_ADJUSTMENT_LINES_ARCH·Explore PSP module →

Table: PSP_ADJUSTMENT_LINES_ARCH 12.2.2 standalone

owner PSP·PSP - Labor Distribution·58 columns

Stores the archived Adjustment Lines History

PSP.PSP_ADJUSTMENT_LINES_ARCH·Explore PSP module →

Table: PSP_DISTRIBUTION_LINES_HISTORY 12.2.2 link

owner PSP·PSP - Labor Distribution·48 columns

Stores distributed Oracle and non-Oracle payroll sublines not yet transferred to General Ledger or Grants Accounting

PSP.PSP_DISTRIBUTION_LINES_HISTORY·Explore PSP module →

Table: PSP_ADJUSTMENT_LINES_HISTORY 12.2.2 link

owner PSP·PSP - Labor Distribution·58 columns

Stores adjusted lines that are successfully transferred

PSP.PSP_ADJUSTMENT_LINES_HISTORY·Explore PSP module →

Table: PSP_ADJUSTMENT_LINES 12.2.2 link

owner PSP·PSP - Labor Distribution·56 columns

Stores the original lines and the new lines to be transferred

PSP.PSP_ADJUSTMENT_LINES·Explore PSP module →

Table: PSP_PRE_GEN_DIST_LINES_HISTORY 12.1.1 link

owner PSP·PSP - Labor Distribution·45 columns

Stores pre-generated distribution lines that are successfully transferred to General Ledger and Grants Accounting

PSP.PSP_PRE_GEN_DIST_LINES_HISTORY·Explore PSP module →

Table: PSP_DISTRIBUTION_LINES 12.2.2 link

owner PSP·PSP - Labor Distribution·47 columns

Stores distributed Oracle and non-Oracle payroll sublines not yet transferred to General Ledger or Grants Accounting

PSP.PSP_DISTRIBUTION_LINES·Explore PSP module →

Table: PSP_DISTRIBUTION_LINES_HISTORY 12.1.1 link

owner PSP·PSP - Labor Distribution·48 columns

Stores distributed Oracle and non-Oracle payroll sublines not yet transferred to General Ledger or Grants Accounting

PSP.PSP_DISTRIBUTION_LINES_HISTORY·Explore PSP module →

Table: PSP_DISTRIBUTION_LINES_ARCH 12.2.2 standalone

owner PSP·PSP - Labor Distribution·48 columns

Stores archived Distribution Lines History

PSP.PSP_DISTRIBUTION_LINES_ARCH·Explore PSP module →

Table: PSP_DISTRIBUTION_LINES_ARCH 12.1.1 standalone

owner PSP·PSP - Labor Distribution·48 columns

Stores archived Distribution Lines History

PSP.PSP_DISTRIBUTION_LINES_ARCH·Explore PSP module →

Table: PSP_ADJUSTMENT_LINES_HISTORY 12.1.1 link

owner PSP·PSP - Labor Distribution·58 columns

Stores adjusted lines that are successfully transferred

PSP.PSP_ADJUSTMENT_LINES_HISTORY·Explore PSP module →

View: PSP_DISTRIBUTION_COMBO_V 12.1.1

PSP - Labor Distribution

Based on PSP_DISTRIBUTION_LINES_HISTORY, PSP_PRE_GEN_DIST_LINES_HISTORY, and PSP_ADJUSTMENT_LINES_HISTORY tables

Not implemented in this database·Explore PSP module →

View: PSP_DISTRIBUTION_COMBO_V 12.2.2

PSP - Labor Distribution

Based on PSP_DISTRIBUTION_LINES_HISTORY, PSP_PRE_GEN_DIST_LINES_HISTORY, and PSP_ADJUSTMENT_LINES_HISTORY tables

Not implemented in this database·Explore PSP module →

Results for “version_num”