FND Design Data [Home] [Help]

Table: PSP_DEFAULT_LABOR_SCHEDULES

Product: PSP - Labor Distribution
Description: Stores default labor schedules to be used when there are no schedules defined for an employee
Implementation/DBA Data: TablePSP.PSP_DEFAULT_LABOR_SCHEDULES
Primary Key: PSP_DEFAULT_LABOR_SCHEDULES_PK
  1. ColumnORG_SCHEDULE_ID
Primary Key: PSP_DEFAULT_LABOR_SCHEDULES_U1
  1. ColumnORGANIZATION_ID
  2. ColumnSCHEDULE_BEGIN_DATE
  3. ColumnGL_CODE_COMBINATION_ID
  4. ColumnPROJECT_ID
  5. ColumnEXPENDITURE_ORGANIZATION_ID
  6. ColumnEXPENDITURE_TYPE
  7. ColumnTASK_ID
  8. ColumnAWARD_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PSP_DEFAULT_LABOR_SCHEDULES FK Joins to TableGL_SETS_OF_BOOKS PSP_DEFAULT_LABOR_SCHEDULES.SET_OF_BOOKS_ID
PSP_DEFAULT_LABOR_SCHEDULES FK Joins to TableHR_ALL_ORGANIZATION_UNITS PSP_DEFAULT_LABOR_SCHEDULES.BUSINESS_GROUP_ID
PSP_DEFAULT_LABOR_SCHEDULES FK Joins to TableGL_CODE_COMBINATIONS PSP_DEFAULT_LABOR_SCHEDULES.GL_CODE_COMBINATION_ID
PSP_DEFAULT_LABOR_SCHEDULES FK Joins to TablePA_PROJECTS_ALL PSP_DEFAULT_LABOR_SCHEDULES.PROJECT_ID
PSP_DEFAULT_LABOR_SCHEDULES FK Joins to TableHR_ALL_ORGANIZATION_UNITS PSP_DEFAULT_LABOR_SCHEDULES.EXPENDITURE_ORGANIZATION_ID
PSP_DEFAULT_LABOR_SCHEDULES FK Joins to TablePA_EXPENDITURE_TYPES PSP_DEFAULT_LABOR_SCHEDULES.EXPENDITURE_TYPE
PSP_DEFAULT_LABOR_SCHEDULES FK Joins to TablePA_TASKS PSP_DEFAULT_LABOR_SCHEDULES.TASK_ID
PSP_DEFAULT_LABOR_SCHEDULES FK Joins to TablePA_PROJECTS_ALL PSP_DEFAULT_LABOR_SCHEDULES.PROJECT_ID
TablePSP_DISTRIBUTION_LINES FK Joins to PSP_DEFAULT_LABOR_SCHEDULES PSP_DISTRIBUTION_LINES.ORG_SCHEDULE_ID
TablePSP_DISTRIBUTION_LINES_HISTORY FK Joins to PSP_DEFAULT_LABOR_SCHEDULES PSP_DISTRIBUTION_LINES_HISTORY.SCHEDULE_LINE_ID