Table: PER_ASS_STATUS_TYPE_AMENDS

Product:	PER - Human Resources
Description:	User amendments to predefined assignment status types.
Implementation/DBA Data:	HR.PER_ASS_STATUS_TYPE_AMENDS

Primary Key: PER_ASS_STATUS_TYPE_AMENDS_PK

1. ASS_STATUS_TYPE_AMEND_ID

Primary Key: PER_ASS_STATUS_TYPE_AMENDS_UK2

1. USER_STATUS
2. BUSINESS_GROUP_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_ASS_STATUS_TYPE_AMENDS		PER_ASSIGNMENT_STATUS_TYPES	PER_ASS_STATUS_TYPE_AMENDS.ASSIGNMENT_STATUS_TYPE_ID
PER_ASS_STATUS_TYPE_AMENDS		HR_ALL_ORGANIZATION_UNITS	PER_ASS_STATUS_TYPE_AMENDS.BUSINESS_GROUP_ID