FND Design Data [Home] [Help]

Table: PER_SECONDARY_ASS_STATUSES

Product: PER - Human Resources
Description: Secondary assignment statuses used for information and reporting.
Implementation/DBA Data: TableHR.PER_SECONDARY_ASS_STATUSES
Primary Key: PER_SECONDARY_ASS_STATUSES_PK
  1. ColumnSECONDARY_ASS_STATUS_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_SECONDARY_ASS_STATUSES FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_SECONDARY_ASS_STATUSES.BUSINESS_GROUP_ID
PER_SECONDARY_ASS_STATUSES FK Joins to TablePER_ASSIGNMENT_STATUS_TYPES PER_SECONDARY_ASS_STATUSES.ASSIGNMENT_STATUS_TYPE_ID