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_OFFER_STATUS_HISTORY

Object Details

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

This table stores the history of the status changes made to a job offer. For example, when an offer is created it may be in PENDING status and once it is approved it is in APPROVED status. If the manager extends the offer to the applicant, it will be in EXTENDED status. Similary, it can go into a HOLD, REJECT or CLOSED status as well.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IRC_OFFER_STATUS_HISTORY_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	OFFER_STATUS_HISTORY_ID
IRC_OFFER_STATUS_HISTORY_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OFFER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OFFER_STATUS_HISTORY_ID	NUMBER	(15)	Yes	Primary Key Column
OFFER_ID	NUMBER	(15)	Yes	Foreign Key To Offers
STATUS_CHANGE_DATE	DATE		Yes	Date Offer Status Change
LAST_UPDATE_DATE	DATE		Yes	Date Offer Last Updated
CREATED_BY	NUMBER	(15)	Yes	User Id of Creator
LAST_UPDATED_BY	NUMBER	(15)	Yes	User Id of last user to update the offer version
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
OFFER_STATUS	VARCHAR2	(30)	Yes	Status Of Offer Version
CHANGE_REASON	VARCHAR2	(30)		Reason for status Change - Accepted or Declined
DECLINE_REASON	VARCHAR2	(30)		Applicant Decline Reason
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object Version Number
CREATION_DATE	DATE		Yes	Creation Date

Query Text

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


SELECT OFFER_STATUS_HISTORY_ID
,      OFFER_ID
,      STATUS_CHANGE_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OFFER_STATUS
,      CHANGE_REASON
,      DECLINE_REASON
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
FROM HR.IRC_OFFER_STATUS_HISTORY;

Dependencies

[top of page]

HR.IRC_OFFER_STATUS_HISTORY does not reference any database object

HR.IRC_OFFER_STATUS_HISTORY is referenced by following:

APPS: IRC_OFFER_STATUS_HISTORY; IRC_OFFER_STATUS_HISTORY_WHO