[Home] [Help] [Dependency Information]
Object Name: | HRI_RECRUITMENT_STAGES |
---|---|
Object Type: | TABLE |
Owner: | HRI |
FND Design Data: | HRI.HRI_RECRUITMENT_STAGES |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSIGNMENT_ID | NUMBER | Yes | ||
ASSIGNMENT_START_DATE | DATE | Yes | ||
BUSINESS_GROUP_ID | NUMBER | |||
ASSIGNMENT_TYPE | VARCHAR2 | (30) | ||
APPLICATION_ID | NUMBER | |||
PERSON_ID | NUMBER | |||
GAIN_TYPE | VARCHAR2 | (30) | ||
SUCCESS | NUMBER | |||
APPLICATION_DATE | DATE | |||
APPLICATION_END_DATE | DATE | |||
PLANNED_START_DATE | DATE | |||
APPLICATION_REASON | VARCHAR2 | (30) | ||
APPLICATION_SUCCESS | NUMBER | |||
INTERVIEW1_DATE | DATE | |||
INTERVIEW1_REASON | VARCHAR2 | (30) | ||
INTERVIEW1_SUCCESS | NUMBER | |||
INTERVIEW2_DATE | DATE | |||
INTERVIEW2_REASON | VARCHAR2 | (30) | ||
INTERVIEW2_SUCCESS | NUMBER | |||
OFFER_DATE | DATE | |||
OFFER_REASON | VARCHAR2 | (30) | ||
OFFER_SUCCESS | NUMBER | |||
ACCEPT_DATE | DATE | |||
ACCEPT_REASON | VARCHAR2 | (30) | ||
ACCEPT_SUCCESS | NUMBER | |||
HIRE_DATE | DATE | |||
HIRE_REASON | VARCHAR2 | (30) | ||
TERMINATION_DATE | DATE | |||
TERMINATION_REASON | VARCHAR2 | (30) | ||
SEPARATION_DATE | DATE | |||
SEPARATION_REASON | VARCHAR2 | (30) | ||
HEADCOUNT_VALUE | NUMBER | |||
FTE_VALUE | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
CREATION_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | |||
CREATED_BY | NUMBER | |||
LAST_UPDATED_BY | NUMBER | |||
CURRENT_STAGE | VARCHAR2 | (30) | ||
CURRENT_STAGE_DATE | DATE | |||
CURRENT_STAGE_REASON | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_ID
, ASSIGNMENT_START_DATE
, BUSINESS_GROUP_ID
, ASSIGNMENT_TYPE
, APPLICATION_ID
, PERSON_ID
, GAIN_TYPE
, SUCCESS
, APPLICATION_DATE
, APPLICATION_END_DATE
, PLANNED_START_DATE
, APPLICATION_REASON
, APPLICATION_SUCCESS
, INTERVIEW1_DATE
, INTERVIEW1_REASON
, INTERVIEW1_SUCCESS
, INTERVIEW2_DATE
, INTERVIEW2_REASON
, INTERVIEW2_SUCCESS
, OFFER_DATE
, OFFER_REASON
, OFFER_SUCCESS
, ACCEPT_DATE
, ACCEPT_REASON
, ACCEPT_SUCCESS
, HIRE_DATE
, HIRE_REASON
, TERMINATION_DATE
, TERMINATION_REASON
, SEPARATION_DATE
, SEPARATION_REASON
, HEADCOUNT_VALUE
, FTE_VALUE
, LAST_UPDATE_DATE
, CREATION_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, LAST_UPDATED_BY
, CURRENT_STAGE
, CURRENT_STAGE_DATE
, CURRENT_STAGE_REASON
FROM HRI.HRI_RECRUITMENT_STAGES;
HRI.HRI_RECRUITMENT_STAGES does not reference any database object
HRI.HRI_RECRUITMENT_STAGES is referenced by following:
|
|
|