FND Design Data [Home] [Help]

Table: PSP_PAYROLL_CONTROLS

Product: PSP - Labor Distribution
Description: Contains information for all imported payroll transactions
Implementation/DBA Data: TablePSP.PSP_PAYROLL_CONTROLS
Primary Key: PSP_PAYROLL_CONTROLS_PK
  1. ColumnPAYROLL_CONTROL_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PSP_PAYROLL_CONTROLS FK Joins to TablePSP_PAYROLL_SOURCES PSP_PAYROLL_CONTROLS.SOURCE_TYPE
PSP_PAYROLL_CONTROLS.PAYROLL_SOURCE_CODE
PSP_PAYROLL_CONTROLS FK Joins to TablePER_TIME_PERIODS PSP_PAYROLL_CONTROLS.TIME_PERIOD_ID
PSP_PAYROLL_CONTROLS FK Joins to TablePAY_PAYROLL_ACTIONS PSP_PAYROLL_CONTROLS.PAYROLL_ACTION_ID
PSP_PAYROLL_CONTROLS FK Joins to TableGL_SETS_OF_BOOKS PSP_PAYROLL_CONTROLS.SET_OF_BOOKS_ID
PSP_PAYROLL_CONTROLS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PSP_PAYROLL_CONTROLS.BUSINESS_GROUP_ID
TablePSP_ADJUSTMENT_LINES FK Joins to PSP_PAYROLL_CONTROLS PSP_ADJUSTMENT_LINES.PAYROLL_CONTROL_ID
TablePSP_ADJUSTMENT_LINES_HISTORY FK Joins to PSP_PAYROLL_CONTROLS PSP_ADJUSTMENT_LINES_HISTORY.PAYROLL_CONTROL_ID
TablePSP_PAYROLL_LINES FK Joins to PSP_PAYROLL_CONTROLS PSP_PAYROLL_LINES.PAYROLL_CONTROL_ID
TablePSP_PRE_GEN_DIST_LINES FK Joins to PSP_PAYROLL_CONTROLS PSP_PRE_GEN_DIST_LINES.PAYROLL_CONTROL_ID
TablePSP_PRE_GEN_DIST_LINES_HISTORY FK Joins to PSP_PAYROLL_CONTROLS PSP_PRE_GEN_DIST_LINES_HISTORY.PAYROLL_CONTROL_ID
TablePSP_SUMMARY_LINES FK Joins to PSP_PAYROLL_CONTROLS PSP_SUMMARY_LINES.PAYROLL_CONTROL_ID