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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.PER_ASSIGNMENT_STATUS_TYPES

Object Details

Object Name:	PER_ASSIGNMENT_STATUS_TYPES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_ASSIGNMENT_STATUS_TYPES
Subobject Name:
Status:	VALID

PER_ASSIGNMENT_STATUS_TYPES holds the definitions of statuses that
identify the status of an employee or applicant in a specific
assignment. USER_STATUS is the user-defined value that is displayed
online. PER_SYSTEM_STATUS and PAY_SYSTEM_STATUS are the internal
values used by the system to control hire and termination processing
and payroll processing. Statuses can be P(rimary), or S(econdary).
Primary statuses are part of the assignment record for an employee,
while secondary statuses are for information only. You can define any
number of user statuses for each PER_SYSTEM_STATUS, but only one may
be designated as the default for each system type. Valid
PER_SYSTEM_STATUS types for employees are ACTIVE_ASSIGN, SUSP_ASSIGN
or TERM_ASSIGN. Valid PER_SYSTEM_STATUS types for applicants are
ACTIVE_APL, OFFER or ACCEPTED.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_ASSIGNMENT_STATUS_TYPE_PK

ASSIGNMENT_STATUS_TYPE_ID

Unique Key: PER_ASSIGNMENT_STATUS_TYPE_UK2

USER_STATUS
BUSINESS_GROUP_ID
LEGISLATION_CODE

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_ASSIGNMENT_STATUS_TYPE_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_STATUS_TYPE_ID
PER_ASSIGNMENT_STATUS_TYPE_UK2	NORMAL	UNIQUE	APPS_TS_TX_IDX	USER_STATUS BUSINESS_GROUP_ID LEGISLATION_CODE

Foreign Keys

Table	Foreign Table	Foreign Key Column
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

Columns

Name	Datatype	Length	Mandatory	Comments
ASSIGNMENT_STATUS_TYPE_ID	NUMBER	(9)	Yes	System-generated primary key column.
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	VARCHAR2	(30)		The legislation to which the status type applies.
ACTIVE_FLAG	VARCHAR2	(30)	Yes	Indicates whether the status is currently available for use.
DEFAULT_FLAG	VARCHAR2	(30)	Yes	Indicates whether this is the default user status for the PER_SYSTEM_STATUS.
PRIMARY_FLAG	VARCHAR2	(30)	Yes	Indicates whether an assignment with this status is processed by Oracle HR.
USER_STATUS	VARCHAR2	(80)	Yes	User-defined status name.
PAY_SYSTEM_STATUS	VARCHAR2	(1)		Payroll status indicating whether the assignment is processed in payroll runs.
PER_SYSTEM_STATUS	VARCHAR2	(30)		HR status used extensively within the system to determine how the assignment is processed.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ASSIGNMENT_STATUS_TYPE_ID
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      ACTIVE_FLAG
,      DEFAULT_FLAG
,      PRIMARY_FLAG
,      USER_STATUS
,      PAY_SYSTEM_STATUS
,      PER_SYSTEM_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_ASSIGNMENT_STATUS_TYPES;

Dependencies

[top of page]

HR.PER_ASSIGNMENT_STATUS_TYPES does not reference any database object

HR.PER_ASSIGNMENT_STATUS_TYPES is referenced by following:

APPS: PER_ASSIGNMENT_STATUS_TYPES; PER_ASSIGNMENT_STATUS_TYPE_WHO
PUBLIC: PER_ASSIGNMENT_STATUS_TYPES