FND Design Data [Home] [Help]

Table: PSP_ELEMENT_TYPES

Product: PSP - Labor Distribution
Description: Stores element types imported from Oracle HRMS
Implementation/DBA Data: TablePSP.PSP_ELEMENT_TYPES
Primary Key: PSP_ELEMENT_TYPES_PK
  1. ColumnELEMENT_TYPE_ID
  2. ColumnSTART_DATE_ACTIVE
Foreign Keys
Table
Foreign Table Foreign Key Column
TablePSP_ELEMENT_TYPE_ACCOUNTS FK Joins to PSP_ELEMENT_TYPES PSP_ELEMENT_TYPE_ACCOUNTS.ELEMENT_TYPE_ID
PSP_ELEMENT_TYPE_ACCOUNTS.START_DATE_ACTIVE
TablePSP_GROUP_ELEMENT_LIST FK Joins to PSP_ELEMENT_TYPES PSP_GROUP_ELEMENT_LIST.ELEMENT_TYPE_ID
PSP_GROUP_ELEMENT_LIST.START_DATE_ACTIVE