FND Design Data [Home] [Help]

Table: PSP_EFFORT_REPORTS

Product: PSP - Labor Distribution
Description: Contains effort reports for employees for a specified time period
Implementation/DBA Data: TablePSP.PSP_EFFORT_REPORTS
Primary Key: PSP_EFFORT_REPORTS_PK
  1. ColumnEFFORT_REPORT_ID
  2. ColumnVERSION_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
PSP_EFFORT_REPORTS FK Joins to TablePSP_EFFORT_REPORT_TEMPLATES PSP_EFFORT_REPORTS.TEMPLATE_ID
PSP_EFFORT_REPORTS FK Joins to TableGL_SETS_OF_BOOKS_11I PSP_EFFORT_REPORTS.SET_OF_BOOKS_ID
PSP_EFFORT_REPORTS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PSP_EFFORT_REPORTS.BUSINESS_GROUP_ID
TablePSP_ADJUSTMENT_LINES FK Joins to PSP_EFFORT_REPORTS PSP_ADJUSTMENT_LINES.EFFORT_REPORT_ID
PSP_ADJUSTMENT_LINES.VERSION_NUM
TablePSP_ADJUSTMENT_LINES_HISTORY FK Joins to PSP_EFFORT_REPORTS PSP_ADJUSTMENT_LINES_HISTORY.EFFORT_REPORT_ID
PSP_ADJUSTMENT_LINES_HISTORY.VERSION_NUM
TablePSP_DISTRIBUTION_LINES FK Joins to PSP_EFFORT_REPORTS PSP_DISTRIBUTION_LINES.EFFORT_REPORT_ID
PSP_DISTRIBUTION_LINES.VERSION_NUM
TablePSP_DISTRIBUTION_LINES_HISTORY FK Joins to PSP_EFFORT_REPORTS PSP_DISTRIBUTION_LINES_HISTORY.EFFORT_REPORT_ID
PSP_DISTRIBUTION_LINES_HISTORY.VERSION_NUM
TablePSP_EFFORT_REPORT_DETAILS FK Joins to PSP_EFFORT_REPORTS PSP_EFFORT_REPORT_DETAILS.EFFORT_REPORT_ID
PSP_EFFORT_REPORT_DETAILS.VERSION_NUM
TablePSP_ER_APPROVALS FK Joins to PSP_EFFORT_REPORTS PSP_ER_APPROVALS.EFFORT_REPORT_ID
PSP_ER_APPROVALS.VERSION_NUM
TablePSP_PRE_GEN_DIST_LINES FK Joins to PSP_EFFORT_REPORTS PSP_PRE_GEN_DIST_LINES.EFFORT_REPORT_ID
PSP_PRE_GEN_DIST_LINES.VERSION_NUM