[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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. |
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;
HR.IRC_DEFAULT_POSTINGS_TL does not reference any database object
HR.IRC_DEFAULT_POSTINGS_TL is referenced by following:
|
|
|