[Home] [Help] [Dependency Information]
Object Name: | IRC_INTERVIEW_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
This table stores the interview details including status, category, notes shared among interviewers, notes to candidate, feedback of the interviewers and the result of the interview.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IRC_INTERVIEW_DETAILS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EVENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERVIEW_DETAILS_ID | NUMBER | (15) | Yes | Primary key |
STATUS | VARCHAR2 | (30) | Interview Status | |
FEEDBACK | VARCHAR2 | (4000) | Feedback on completion of interview | |
NOTES | VARCHAR2 | (4000) | Notes shared among interviewers | |
NOTES_TO_CANDIDATE | VARCHAR2 | (4000) | Notes to candidate | |
CATEGORY | VARCHAR2 | (30) | Interview Category | |
RESULT | VARCHAR2 | (30) | Result of the interview | |
IID_INFORMATION_CATEGORY | VARCHAR2 | (30) | Developer Descriptive Flexfield Structure defining column | |
IID_INFORMATION1 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
IID_INFORMATION2 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
IID_INFORMATION3 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
IID_INFORMATION4 | VARCHAR2 | (240) | Developer descriptive flexfield column | |
IID_INFORMATION5 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
IID_INFORMATION6 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
IID_INFORMATION7 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
IID_INFORMATION8 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
IID_INFORMATION9 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
IID_INFORMATION10 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
IID_INFORMATION11 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
IID_INFORMATION12 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
IID_INFORMATION13 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
IID_INFORMATION14 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
IID_INFORMATION15 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
IID_INFORMATION16 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
IID_INFORMATION17 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
IID_INFORMATION18 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
IID_INFORMATION19 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
IID_INFORMATION20 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
CREATED_BY | NUMBER | (15) | Standard WHO Column | |
CREATION_DATE | DATE | Standard WHO Column | ||
LAST_UPDATE_DATE | DATE | Standard WHO Column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
START_DATE | DATE | Yes | Start Date of interview | |
END_DATE | DATE | Yes | End Date of interview | |
EVENT_ID | NUMBER | (15) | Foreign key to PER_EVENTS | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | System-generated version of row. Increments by one with each update |
Cut, paste (and edit) the following text to query this object:
SELECT INTERVIEW_DETAILS_ID
, STATUS
, FEEDBACK
, NOTES
, NOTES_TO_CANDIDATE
, CATEGORY
, RESULT
, IID_INFORMATION_CATEGORY
, IID_INFORMATION1
, IID_INFORMATION2
, IID_INFORMATION3
, IID_INFORMATION4
, IID_INFORMATION5
, IID_INFORMATION6
, IID_INFORMATION7
, IID_INFORMATION8
, IID_INFORMATION9
, IID_INFORMATION10
, IID_INFORMATION11
, IID_INFORMATION12
, IID_INFORMATION13
, IID_INFORMATION14
, IID_INFORMATION15
, IID_INFORMATION16
, IID_INFORMATION17
, IID_INFORMATION18
, IID_INFORMATION19
, IID_INFORMATION20
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, START_DATE
, END_DATE
, EVENT_ID
, OBJECT_VERSION_NUMBER
FROM HR.IRC_INTERVIEW_DETAILS;
HR.IRC_INTERVIEW_DETAILS does not reference any database object
HR.IRC_INTERVIEW_DETAILS is referenced by following:
|
|
|