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.HR_ASSIGNMENT_SET_CRITERIA

Object Details

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

HR_ASSIGNMENT_SET_CRITERIA identifies the individual criteria, in
sequence, that are used to define an assignment set. Each row
represents one logical condition, and taken collectively they define
an assignment set. These logical conditions make use of database
items, such as PER_AGE>30, and can be joined with AND/OR type logic.
They are compiled into an assignment set formula. The list of
assignments in the set are generated when the formula is executed, for
example, when the assignment set is referenced by a payroll run.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: HR_ASSIGNMENT_SET_CRITERIA_PK

LINE_NO
ASSIGNMENT_SET_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_ASSIGNMENT_SET_CRITERIA_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_NO ASSIGNMENT_SET_ID
HR_ASSIGNMENT_SET_CRITERIA_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_SET_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
HR_ASSIGNMENT_SET_CRITERIA		HR_ASSIGNMENT_SETS	HR_ASSIGNMENT_SET_CRITERIA ASSIGNMENT_SET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_NO	NUMBER	(15)	Yes	Sequence in which this condition should be used for the set.
ASSIGNMENT_SET_ID	NUMBER	(15)	Yes	Foreign key to HR_ASSIGNMENTS_SETS.
LEFT_OPERAND	VARCHAR2	(241)	Yes	Database item or text. Database item is prefixed online by &.
OPERATOR	VARCHAR2	(30)	Yes	How the left operand must relate to the right operand to succeed.
RIGHT_OPERAND	VARCHAR2	(241)	Yes	Database item or text. Database item is prefixed online by &.
LOGICAL	VARCHAR2	(30)		Logical link between this condition and the previous one (AND/OR).
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 LINE_NO
,      ASSIGNMENT_SET_ID
,      LEFT_OPERAND
,      OPERATOR
,      RIGHT_OPERAND
,      LOGICAL
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.HR_ASSIGNMENT_SET_CRITERIA;

Dependencies

[top of page]

HR.HR_ASSIGNMENT_SET_CRITERIA does not reference any database object

HR.HR_ASSIGNMENT_SET_CRITERIA is referenced by following:

APPS: HR_ASSIGNMENT_SET_CRITERIA; HR_ASSIGNMENT_SET_CRITERIA_WHO
PUBLIC: HR_ASSIGNMENT_SET_CRITERIA