FND Design Data [Home] [Help]

Table: PSP_PAYROLL_SUB_LINES

Product: PSP - Labor Distribution
Description: Contains information where payroll amount in a payroll line is split into more than one subline
Implementation/DBA Data: TablePSP.PSP_PAYROLL_SUB_LINES
Primary Key: PSP_PAYROLL_SUB_LINES_PK
  1. ColumnPAYROLL_SUB_LINE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PSP_PAYROLL_SUB_LINES FK Joins to TablePSP_PAYROLL_LINES PSP_PAYROLL_SUB_LINES.PAYROLL_LINE_ID
PSP_PAYROLL_SUB_LINES FK Joins to TableHR_ALL_ORGANIZATION_UNITS PSP_PAYROLL_SUB_LINES.ORGANIZATION_ID
PSP_PAYROLL_SUB_LINES FK Joins to TablePER_JOBS PSP_PAYROLL_SUB_LINES.JOB_ID
TablePSP_DISTRIBUTION_LINES FK Joins to PSP_PAYROLL_SUB_LINES PSP_DISTRIBUTION_LINES.PAYROLL_SUB_LINE_ID
TablePSP_DISTRIBUTION_LINES_HISTORY FK Joins to PSP_PAYROLL_SUB_LINES PSP_DISTRIBUTION_LINES_HISTORY.PAYROLL_SUB_LINE_ID
TablePSP_SUB_LINE_REASONS FK Joins to PSP_PAYROLL_SUB_LINES PSP_SUB_LINE_REASONS.PAYROLL_SUB_LINE_ID