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

Object Details

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

This table stores the additional information about the application like no of attempts for the assesment linked to the application, whether the recruiter has marked the applicant qualified or not etc

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IRC_ASSIGNMENT_DETAILS_F_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_DETAILS_ID
IRC_ASSIGNMENT_DETAILS_F_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE DETAILS_VERSION

Columns

Name	Datatype	Length	Mandatory	Comments
ASSIGNMENT_DETAILS_ID	NUMBER	(15)	Yes	System-generated primary key column.
ASSIGNMENT_ID	NUMBER	(15)	Yes	Foreign key to PER_ALL_ASSIGNMENTS_F.
EFFECTIVE_START_DATE	DATE		Yes	Effective start date.
EFFECTIVE_END_DATE	DATE		Yes	Effective end date.
DETAILS_VERSION	NUMBER	(15)	Yes	Version of the assignment details with in the effective date range.
LATEST_DETAILS	VARCHAR2	(30)	Yes	Flag to identify the latest assignment details with in the effective date range.
ATTEMPT_ID	NUMBER	(15)		Foreign key to OTA_ATTEMPTS.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column.
CREATION_DATE	DATE		Yes	Standard WHO column.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	System-generated version of row. Increments by one with each update.
QUALIFIED	VARCHAR2	(30)		Qualified Flag
CONSIDERED	VARCHAR2	(30)		Considered

Query Text

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


SELECT ASSIGNMENT_DETAILS_ID
,      ASSIGNMENT_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      DETAILS_VERSION
,      LATEST_DETAILS
,      ATTEMPT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      QUALIFIED
,      CONSIDERED
FROM HR.IRC_ASSIGNMENT_DETAILS_F;

Dependencies

[top of page]

HR.IRC_ASSIGNMENT_DETAILS_F does not reference any database object

HR.IRC_ASSIGNMENT_DETAILS_F is referenced by following:

APPS: IRC_ASSIGNMENT_DETAILS_F; IRC_ASSIGNMENT_DETAILS_F_WHO