eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: PER_ASSIGNMENT_STATUS_TYPES

Product:	PER - Human Resources
Description:	Predefined and user defined assignment status types.
Implementation/DBA Data:	HR.PER_ASSIGNMENT_STATUS_TYPES

Primary Key: PER_ASSIGNMENT_STATUS_TYPE_PK

ASSIGNMENT_STATUS_TYPE_ID

Primary Key: PER_ASSIGNMENT_STATUS_TYPE_UK2

USER_STATUS
BUSINESS_GROUP_ID
LEGISLATION_CODE

Foreign Keys

Table	Foreign Table	Foreign Key Column
IRC_ASSIGNMENT_STATUSES	PER_ASSIGNMENT_STATUS_TYPES	IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_STATUS_TYPE_ID
PAY_STATUS_PROCESSING_RULES_F	PER_ASSIGNMENT_STATUS_TYPES	PAY_STATUS_PROCESSING_RULES_F.ASSIGNMENT_STATUS_TYPE_ID
PER_ALL_ASSIGNMENTS_F	PER_ASSIGNMENT_STATUS_TYPES	PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID
PER_ASS_STATUS_TYPE_AMENDS	PER_ASSIGNMENT_STATUS_TYPES	PER_ASS_STATUS_TYPE_AMENDS.ASSIGNMENT_STATUS_TYPE_ID
PER_LETTER_REQUEST_LINES	PER_ASSIGNMENT_STATUS_TYPES	PER_LETTER_REQUEST_LINES.ASSIGNMENT_STATUS_TYPE_ID
PER_SECONDARY_ASS_STATUSES	PER_ASSIGNMENT_STATUS_TYPES	PER_SECONDARY_ASS_STATUSES.ASSIGNMENT_STATUS_TYPE_ID