[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IRC_OFFERS |
|---|---|
| Object Type: | TABLE |
| Owner: | HR |
| FND Design Data: |  PER.IRC_OFFERS
|
| Subobject Name: | |
| Status: | VALID |
This table stores details about a job offer made to an applicant which may include job details, salary details and any other benefits that are applicable to the applicant.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IRC_OFFERS_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 OFFER_ID
|
| IRC_OFFERS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
APPLICANT_ASSIGNMENT_ID
OFFER_VERSION
|
| SYS_IL0000403743C00023$$ | LOB | UNIQUE |
APPS_TS_TX_DATA
|
|
| IRC_OFFERS_FK1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VACANCY_ID
|
| IRC_OFFERS_FK2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OFFER_ASSIGNMENT_ID
|
| IRC_OFFERS_U2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OFFER_STATUS
EXPIRY_DATE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| OFFER_ID | NUMBER | (15) | Yes | Primary Key Column |
| OFFER_VERSION | NUMBER | (15) | Yes | Version of the Offer starting at 1. |
| LATEST_OFFER | VARCHAR2 | (30) | Yes | Flag to identify the latest offer |
| CREATION_DATE | DATE | Yes | Creation Date | |
| LAST_UPDATE_DATE | DATE | Yes | Date when this row was 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 |
| DISCRETIONARY_JOB_TITLE | VARCHAR2 | (240) | Job Title that can be used instead of the Title against the Job Table | |
| OFFER_EXTENDED_METHOD | VARCHAR2 | (30) | Flag set when the offer is extended - SYSTEM/HARDCOPY | |
| RESPONDENT_ID | NUMBER | (15) | User Id of the person responding to the Offer Extension | |
| EXPIRY_DATE | DATE | Date the current Offer Version expires | ||
| PROPOSED_START_DATE | DATE | Proposed date of employee start | ||
| OFFER_LETTER_TRACKING_CODE | VARCHAR2 | (240) | Tracking code from shipping company | |
| OFFER_POSTAL_SERVICE | VARCHAR2 | (30) | Name of the company handling the delivery of offer | |
| OFFER_SHIPPING_DATE | DATE | Date Paper Offer was posted | ||
| VACANCY_ID | NUMBER | (15) | Yes | Vacancy Applied For |
| APPLICANT_ASSIGNMENT_ID | NUMBER | (15) | Yes | Applicant assignment for applicant |
| OFFER_ASSIGNMENT_ID | NUMBER | (15) | Yes | Offer asignment for applicant |
| ADDRESS_ID | NUMBER | (15) | Id of Address where the offer has to be sent | |
| TEMPLATE_ID | NUMBER | (15) | Id of letter template. Set to null if offer letter uploaded and overridden | |
| OFFER_LETTER | BLOB | (4000) | Offer letter either generated when Offer extended or uploaded by the Super user | |
| OFFER_LETTER_FILE_NAME | VARCHAR2 | (240) | Filename of the uploaded offer letter | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive flexfield column | |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | System generated version of row. Increments by 1 with each update. |
| OFFER_LETTER_FILE_TYPE | VARCHAR2 | (30) | Offer Letter File Type |
Cut, paste (and edit) the following text to query this object:
SELECT OFFER_ID
, OFFER_VERSION
, LATEST_OFFER
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OFFER_STATUS
, DISCRETIONARY_JOB_TITLE
, OFFER_EXTENDED_METHOD
, RESPONDENT_ID
, EXPIRY_DATE
, PROPOSED_START_DATE
, OFFER_LETTER_TRACKING_CODE
, OFFER_POSTAL_SERVICE
, OFFER_SHIPPING_DATE
, VACANCY_ID
, APPLICANT_ASSIGNMENT_ID
, OFFER_ASSIGNMENT_ID
, ADDRESS_ID
, TEMPLATE_ID
, OFFER_LETTER
, OFFER_LETTER_FILE_NAME
, 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
, OBJECT_VERSION_NUMBER
, OFFER_LETTER_FILE_TYPE
FROM HR.IRC_OFFERS;
HR.IRC_OFFERS does not reference any database object
HR.IRC_OFFERS is referenced by following:
APPS
IRC_OFFERS
IRC_OFFERS_WHO
|
|
|
|