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_DEFAULT_POSTINGS_TL

Object Details

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

This table stores the translatable text for the default posting stored in IRC_DEFAULT_POSTINGS

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IRC_DEFAULT_POSTINGS_TL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	DEFAULT_POSTING_ID LANGUAGE
SYS_IL0000202673C00005$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000202673C00007$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000202673C00008$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000202673C00009$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000202673C00010$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000202673C00011$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000202673C00012$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000202673C00013$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
DEFAULT_POSTING_ID	NUMBER	(15)	Yes	Primary Key.
LANGUAGE	VARCHAR2	(4)	Yes	The language that the default posting is in.
SOURCE_LANGUAGE	VARCHAR2	(4)	Yes	The source language the default posting was first copied from.
ORG_NAME	VARCHAR2	(240)		Organization name.
ORG_DESCRIPTION	CLOB	(4000)		A written desciption introducing a Department or Division of the Customer to the Postion Seeker.
JOB_TITLE	VARCHAR2	(240)		The discretionary Job / Position Title that a Manager would have the facility to enter.
BRIEF_DESCRIPTION	CLOB	(4000)		A brief statement outlining the duties, purpose and conditions for the Job / Position.
DETAILED_DESCRIPTION	CLOB	(4000)		A detailed statement of the duties, purposes and conditions for the Job / Position.
JOB_REQUIREMENTS	CLOB	(4000)		A summary of the required or desired competencies, education and / or qualificaitons for the Job / Position.
ADDITIONAL_DETAILS	CLOB	(4000)		Text detail that a Manager would have the facility to enter.
HOW_TO_APPLY	CLOB	(4000)		A summary that oulines to the Position Seeker how to apply or express an interest in a specific Job Posting.
IMAGE_URL	CLOB	(4000)		The URL of an image.
IMAGE_URL_ALT	CLOB	(4000)		The ALT test of the image.

Query Text

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


SELECT DEFAULT_POSTING_ID
,      LANGUAGE
,      SOURCE_LANGUAGE
,      ORG_NAME
,      ORG_DESCRIPTION
,      JOB_TITLE
,      BRIEF_DESCRIPTION
,      DETAILED_DESCRIPTION
,      JOB_REQUIREMENTS
,      ADDITIONAL_DETAILS
,      HOW_TO_APPLY
,      IMAGE_URL
,      IMAGE_URL_ALT
FROM HR.IRC_DEFAULT_POSTINGS_TL;

Dependencies

[top of page]

HR.IRC_DEFAULT_POSTINGS_TL does not reference any database object

HR.IRC_DEFAULT_POSTINGS_TL is referenced by following:

APPS: IRC_DEFAULT_POSTINGS_TL