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_ALL_RECRUITING_SITES

Object Details

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

This contains a list of iRecruitment web sites. The applicants will be able to log onto each of these sites. Each site may have for example different style or layout, or be for a different division of the company. Different sites can be made available for internal applicants and external applicants.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000244039C00008$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000244039C00009$$	LOB	UNIQUE	APPS_TS_TX_DATA
IRC_ALL_RECRUITING_SITES_PK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECRUITING_SITE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RECRUITING_SITE_ID	NUMBER	(15)	Yes	Primary Key
SITE_NAME	VARCHAR2	(240)		Obsolete
DATE_FROM	DATE			The date the recruiting site can be used from.
DATE_TO	DATE			The date the recruiting site can be used to.
INTERNAL	VARCHAR2	(30)	Yes	Not currently used
EXTERNAL	VARCHAR2	(30)	Yes	Not currently used
THIRD_PARTY	VARCHAR2	(30)	Yes	Specifies if the site is a third party site.
REDIRECTION_URL	CLOB	(4000)		Obsolete
POSTING_URL	CLOB	(4000)		Obsolete
POSTING_USERNAME	VARCHAR2	(240)		The username need to gain access to the site.
POSTING_PASSWORD	VARCHAR2	(240)		The password for the posting site
POSTING_COST	NUMBER			Cost of the posting.
POSTING_COST_PERIOD	VARCHAR2	(30)		Period that the posting cost is for.
POSTING_COST_CURRENCY	VARCHAR2	(30)		Currency of the posting cost.
STYLESHEET	VARCHAR2	(4000)		The location of the stylesheet - this allows other DTDs to be supported.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure defining column.
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE16	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE17	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE18	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE19	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE20	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE21	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE22	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE23	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE24	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE25	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE26	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE27	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE28	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE29	VARCHAR2	(240)		Descriptive Flexfield Column
ATTRIBUTE30	VARCHAR2	(240)		Descriptive Flexfield Column
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	The position which the default posting is for
INTERNAL_NAME	VARCHAR2	(240)	Yes	Internal Name

Query Text

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


SELECT RECRUITING_SITE_ID
,      SITE_NAME
,      DATE_FROM
,      DATE_TO
,      INTERNAL
,      EXTERNAL
,      THIRD_PARTY
,      REDIRECTION_URL
,      POSTING_URL
,      POSTING_USERNAME
,      POSTING_PASSWORD
,      POSTING_COST
,      POSTING_COST_PERIOD
,      POSTING_COST_CURRENCY
,      STYLESHEET
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      INTERNAL_NAME
FROM HR.IRC_ALL_RECRUITING_SITES;

Dependencies

[top of page]

HR.IRC_ALL_RECRUITING_SITES does not reference any database object

HR.IRC_ALL_RECRUITING_SITES is referenced by following:

APPS: IRC_ALL_RECRUITING_SITES; IRC_ALL_RECRUITING_SITES_WHO