FND Design Data [Home] [Help]

Table: PER_ASSIGNMENT_STATUS_TYPES

Product: PER - Human Resources
Description: Predefined and user defined assignment status types.
Implementation/DBA Data: TableHR.PER_ASSIGNMENT_STATUS_TYPES
Primary Key: PER_ASSIGNMENT_STATUS_TYPE_PK
  1. ColumnASSIGNMENT_STATUS_TYPE_ID
Primary Key: PER_ASSIGNMENT_STATUS_TYPE_UK2
  1. ColumnUSER_STATUS
  2. ColumnBUSINESS_GROUP_ID
  3. ColumnLEGISLATION_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
TableIRC_ASSIGNMENT_STATUSES FK Joins to PER_ASSIGNMENT_STATUS_TYPES IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_STATUS_TYPE_ID
TablePAY_STATUS_PROCESSING_RULES_F FK Joins to PER_ASSIGNMENT_STATUS_TYPES PAY_STATUS_PROCESSING_RULES_F.ASSIGNMENT_STATUS_TYPE_ID
TablePER_ALL_ASSIGNMENTS_F FK Joins to PER_ASSIGNMENT_STATUS_TYPES PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID
TablePER_ASS_STATUS_TYPE_AMENDS FK Joins to PER_ASSIGNMENT_STATUS_TYPES PER_ASS_STATUS_TYPE_AMENDS.ASSIGNMENT_STATUS_TYPE_ID
TablePER_LETTER_REQUEST_LINES FK Joins to PER_ASSIGNMENT_STATUS_TYPES PER_LETTER_REQUEST_LINES.ASSIGNMENT_STATUS_TYPE_ID
TablePER_SECONDARY_ASS_STATUSES FK Joins to PER_ASSIGNMENT_STATUS_TYPES PER_SECONDARY_ASS_STATUSES.ASSIGNMENT_STATUS_TYPE_ID