FND Design Data [Home] [Help]

Table: PER_ASS_STATUS_TYPE_AMENDS

Product: PER - Human Resources
Description: User amendments to predefined assignment status types.
Implementation/DBA Data: TableHR.PER_ASS_STATUS_TYPE_AMENDS
Primary Key: PER_ASS_STATUS_TYPE_AMENDS_PK
  1. ColumnASS_STATUS_TYPE_AMEND_ID
Primary Key: PER_ASS_STATUS_TYPE_AMENDS_UK2
  1. ColumnUSER_STATUS
  2. ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_ASS_STATUS_TYPE_AMENDS FK Joins to TablePER_ASSIGNMENT_STATUS_TYPES PER_ASS_STATUS_TYPE_AMENDS.ASSIGNMENT_STATUS_TYPE_ID
PER_ASS_STATUS_TYPE_AMENDS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_ASS_STATUS_TYPE_AMENDS.BUSINESS_GROUP_ID