FND Design Data [Home] [Help]

Table: PSP_DISTRIBUTION_LINES_HISTORY

Product: PSP - Labor Distribution
Description: Stores distributed Oracle and non-Oracle payroll sublines not yet transferred to General Ledger or Grants Accounting
Implementation/DBA Data: TablePSP.PSP_DISTRIBUTION_LINES_HISTORY
Primary Key: PSP_DISTRIBUTION_LINES_HIST_PK
  1. ColumnDISTRIBUTION_LINE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PSP_DISTRIBUTION_LINES_HISTORY FK Joins to TableHR_ALL_ORGANIZATION_UNITS PSP_DISTRIBUTION_LINES_HISTORY.BUSINESS_GROUP_ID
PSP_DISTRIBUTION_LINES_HISTORY FK Joins to TablePSP_PAYROLL_SUB_LINES PSP_DISTRIBUTION_LINES_HISTORY.PAYROLL_SUB_LINE_ID
PSP_DISTRIBUTION_LINES_HISTORY FK Joins to TablePSP_SUMMARY_LINES PSP_DISTRIBUTION_LINES_HISTORY.SUMMARY_LINE_ID
PSP_DISTRIBUTION_LINES_HISTORY FK Joins to TablePSP_SCHEDULE_LINES PSP_DISTRIBUTION_LINES_HISTORY.SCHEDULE_LINE_ID
PSP_DISTRIBUTION_LINES_HISTORY FK Joins to TablePSP_ELEMENT_TYPE_ACCOUNTS PSP_DISTRIBUTION_LINES_HISTORY.ELEMENT_ACCOUNT_ID
PSP_DISTRIBUTION_LINES_HISTORY FK Joins to TablePSP_DEFAULT_LABOR_SCHEDULES PSP_DISTRIBUTION_LINES_HISTORY.SCHEDULE_LINE_ID
PSP_DISTRIBUTION_LINES_HISTORY FK Joins to TablePSP_EFFORT_REPORTS PSP_DISTRIBUTION_LINES_HISTORY.EFFORT_REPORT_ID
PSP_DISTRIBUTION_LINES_HISTORY.VERSION_NUM
PSP_DISTRIBUTION_LINES_HISTORY FK Joins to TableGL_SETS_OF_BOOKS PSP_DISTRIBUTION_LINES_HISTORY.SET_OF_BOOKS_ID