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_POSTING_CONTENTS_TL

Object Details

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

This table stores the translatable text for the posting stored in IRC_POSTING_CONTENTS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IRC_POSTING_CONTENTS_TL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	POSTING_CONTENT_ID LANGUAGE
SYS_IL0000202590C00006$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000202590C00008$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000202590C00009$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000202590C00010$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000202590C00011$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000202590C00012$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000202590C00013$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000202590C00014$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000202590C00015$$	LOB	UNIQUE	APPS_TS_TX_DATA
IRC_POSTING_CONTENTS_TL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LANGUAGE NAME
IRC_POSTING_CON_TL_CTX	DOMAIN	NONUNIQUE		NAME

Columns

Name	Datatype	Length	Mandatory	Comments
POSTING_CONTENT_ID	NUMBER	(15)	Yes	Primary Key Column.
LANGUAGE	VARCHAR2	(4)	Yes	One row for each installed language.
SOURCE_LANGUAGE	VARCHAR2	(4)	Yes	Source language.
NAME	VARCHAR2	(240)	Yes	The name of the Job Posting Content.
ORG_NAME	VARCHAR2	(240)		Organization name.
ORG_DESCRIPTION	CLOB	(4000)		A written description introducing a Department or Division of the Customer to the Position Seeker.
JOB_TITLE	VARCHAR2	(240)		The discretionary Job / Position Title that a manager has 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 of the Job / Position.
JOB_REQUIREMENTS	CLOB	(4000)		A summary of the required or desired competencies, education and / or qualifications for the Job / Position.
ADDITIONAL_DETAILS	CLOB	(4000)		Text detail that a Manager would has the facility to enter.
HOW_TO_APPLY	CLOB	(4000)		A summary that outlines to the Position Seeker how to apply or express interest in a specific Job Posting.
BENEFIT_INFO	CLOB	(4000)		Information about the benefits that a person will receive.
IMAGE_URL	CLOB	(4000)		The URL of an image.
IMAGE_URL_ALT	CLOB	(4000)		The ALT text of the image.

Query Text

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


SELECT POSTING_CONTENT_ID
,      LANGUAGE
,      SOURCE_LANGUAGE
,      NAME
,      ORG_NAME
,      ORG_DESCRIPTION
,      JOB_TITLE
,      BRIEF_DESCRIPTION
,      DETAILED_DESCRIPTION
,      JOB_REQUIREMENTS
,      ADDITIONAL_DETAILS
,      HOW_TO_APPLY
,      BENEFIT_INFO
,      IMAGE_URL
,      IMAGE_URL_ALT
FROM HR.IRC_POSTING_CONTENTS_TL;

Dependencies

[top of page]

HR.IRC_POSTING_CONTENTS_TL does not reference any database object

HR.IRC_POSTING_CONTENTS_TL is referenced by following:

APPS: IRC_POSTING_CONTENTS_TL