[Home] [Help] [Dependency Information]
Object Name: | HRFV_APPLICANT_DETAILS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Applicant detailed information.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
APPLICANT_NAME | VARCHAR2 | (240) | ||
APPLICANT_TYPE | VARCHAR2 | (4000) | ||
APPLICANT_NUMBER | VARCHAR2 | (30) | ||
APPLICATION_STATUS | VARCHAR2 | (80) | ||
VACANCY_NAME | VARCHAR2 | (30) | ||
APPLICATION_START_DATE | DATE | |||
APPLICATION_END_DATE | DATE | |||
RECORD_START_DATE | DATE | |||
RECORD_END_DATE | DATE | |||
PERSON_START_DATE | DATE | Yes | ||
PERSON_END_DATE | DATE | Yes | ||
ASSIGNMENT_START_DATE | DATE | Yes | ||
ASSIGNMENT_END_DATE | DATE | Yes | ||
CURRENT_EMPLOYEE_FLAG | VARCHAR2 | (4000) | ||
SUCCESSFUL_APPLICANT_FLAG | VARCHAR2 | (4000) | ||
APPLICATION_COMMENTS | CLOB | (4000) | ||
SYSTEM_PERSON_TYPE | VARCHAR2 | (80) | Yes | |
EMPLOYEE_PERSON_TYPE | VARCHAR2 | (4000) | ||
APPLICANT_PERSON_TYPE | VARCHAR2 | (4000) | ||
USER_CONCAT_PERSON_TYPE | VARCHAR2 | (4000) | ||
CURRENT_EMPLOYER | VARCHAR2 | (30) | ||
PROJECTED_HIRE_DATE | DATE | |||
HIRE_DATE | DATE | |||
ORIGINAL_DATE_OF_HIRE | DATE | |||
ASSIGNMENT_NUMBER | VARCHAR2 | (30) | ||
ASSIGNMENT_TYPE | VARCHAR2 | (4000) | ||
ASSIGNMENT_TYPE_CODE | VARCHAR2 | (1) | Yes | |
EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
RECRUITMENT_ACTIVITY_NAME | VARCHAR2 | (30) | ||
EMPLOYEE_REFFERAL | VARCHAR2 | (4000) | ||
REFERRING_EMPLOYEE_NAME | VARCHAR2 | (240) | ||
REFERRING_EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
SOURCE_TYPE | VARCHAR2 | (4000) | ||
JOB_POST_SOURCE_NAME | VARCHAR2 | (240) | ||
USER_ASSIGNMENT_STATUS | VARCHAR2 | (80) | ||
PER_SYSTEM_ASSIGNMENT_STATUS | VARCHAR2 | (4000) | ||
PAY_SYSTEM_ASSIGNMENT_STATUS | VARCHAR2 | (4000) | ||
SOURCE_ORGANIZATION_NAME | VARCHAR2 | (240) | ||
SUPERVISOR_NAME | VARCHAR2 | (240) | ||
SUPERVISOR_NUMBER | VARCHAR2 | (30) | ||
RECRUITER_NAME | VARCHAR2 | (240) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | ||
POSITION_NAME | VARCHAR2 | (240) | ||
JOB_NAME | VARCHAR2 | (700) | ||
LOCATION_NAME | VARCHAR2 | (60) | ||
GRADE_NAME | VARCHAR2 | (240) | ||
PEOPLE_GROUP | VARCHAR2 | (240) | ||
TITLE | VARCHAR2 | (30) | ||
MIDDLE_NAMES | VARCHAR2 | (60) | ||
PREFERRED_NAME | VARCHAR2 | (80) | ||
FIRST_NAME | VARCHAR2 | (150) | ||
LAST_NAME | VARCHAR2 | (150) | Yes | |
PREFIX | VARCHAR2 | (30) | ||
SUFFIX | VARCHAR2 | (30) | ||
CURRENT_EMPLOYEE_FLAG_CODE | VARCHAR2 | (30) | ||
SUCCESSFUL_APPLICANT_FLAG_CODE | VARCHAR2 | (30) | ||
SOURCE_TYPE_CODE | VARCHAR2 | (30) | ||
SYSTEM_PERSON_TYPE_CODE | VARCHAR2 | (30) | Yes | |
PER_SYSTEM_ASS_STATUS_CODE | VARCHAR2 | (30) | ||
PAY_SYSTEM_ASS_STATUS_CODE | VARCHAR2 | (1) | ||
APPLICANT_TYPE_CODE | VARCHAR2 | (1) | ||
_DF:PASG | CHAR | (27) | ||
_DF:PAPL | CHAR | (28) | ||
_DF:PP | CHAR | (22) | ||
_DF:PDF | CHAR | (31) | ||
APPLICATION_ID | NUMBER | (15) | ||
PERSON_ID | NUMBER | (10) | Yes | |
ASSIGNMENT_ID | NUMBER | (10) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
GRADE_ID | NUMBER | (15) | ||
JOB_ID | NUMBER | (15) | ||
LOCATION_ID | NUMBER | (15) | ||
ORGANIZATION_ID | NUMBER | (15) | Yes | |
PEOPLE_GROUP_ID | NUMBER | (15) | ||
POSITION_ID | NUMBER | (15) | ||
RECRUITER_ID | NUMBER | (10) | ||
RECRUITMENT_ACTIVITY_ID | NUMBER | (15) | ||
REFERRING_EMPLOYEE_ID | NUMBER | (10) | ||
SUPERVISOR_ID | NUMBER | (10) | ||
VACANCY_ID | NUMBER | (15) | ||
PARTY_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, APPLICANT_NAME
, APPLICANT_TYPE
, APPLICANT_NUMBER
, APPLICATION_STATUS
, VACANCY_NAME
, APPLICATION_START_DATE
, APPLICATION_END_DATE
, RECORD_START_DATE
, RECORD_END_DATE
, PERSON_START_DATE
, PERSON_END_DATE
, ASSIGNMENT_START_DATE
, ASSIGNMENT_END_DATE
, CURRENT_EMPLOYEE_FLAG
, SUCCESSFUL_APPLICANT_FLAG
, APPLICATION_COMMENTS
, SYSTEM_PERSON_TYPE
, EMPLOYEE_PERSON_TYPE
, APPLICANT_PERSON_TYPE
, USER_CONCAT_PERSON_TYPE
, CURRENT_EMPLOYER
, PROJECTED_HIRE_DATE
, HIRE_DATE
, ORIGINAL_DATE_OF_HIRE
, ASSIGNMENT_NUMBER
, ASSIGNMENT_TYPE
, ASSIGNMENT_TYPE_CODE
, EMPLOYEE_NUMBER
, RECRUITMENT_ACTIVITY_NAME
, EMPLOYEE_REFFERAL
, REFERRING_EMPLOYEE_NAME
, REFERRING_EMPLOYEE_NUMBER
, SOURCE_TYPE
, JOB_POST_SOURCE_NAME
, USER_ASSIGNMENT_STATUS
, PER_SYSTEM_ASSIGNMENT_STATUS
, PAY_SYSTEM_ASSIGNMENT_STATUS
, SOURCE_ORGANIZATION_NAME
, SUPERVISOR_NAME
, SUPERVISOR_NUMBER
, RECRUITER_NAME
, ORGANIZATION_NAME
, POSITION_NAME
, JOB_NAME
, LOCATION_NAME
, GRADE_NAME
, PEOPLE_GROUP
, TITLE
, MIDDLE_NAMES
, PREFERRED_NAME
, FIRST_NAME
, LAST_NAME
, PREFIX
, SUFFIX
, CURRENT_EMPLOYEE_FLAG_CODE
, SUCCESSFUL_APPLICANT_FLAG_CODE
, SOURCE_TYPE_CODE
, SYSTEM_PERSON_TYPE_CODE
, PER_SYSTEM_ASS_STATUS_CODE
, PAY_SYSTEM_ASS_STATUS_CODE
, APPLICANT_TYPE_CODE
, _DF:PASG
, _DF:PAPL
, _DF:PP
, _DF:PDF
, APPLICATION_ID
, PERSON_ID
, ASSIGNMENT_ID
, BUSINESS_GROUP_ID
, GRADE_ID
, JOB_ID
, LOCATION_ID
, ORGANIZATION_ID
, PEOPLE_GROUP_ID
, POSITION_ID
, RECRUITER_ID
, RECRUITMENT_ACTIVITY_ID
, REFERRING_EMPLOYEE_ID
, SUPERVISOR_ID
, VACANCY_ID
, PARTY_ID
FROM APPS.HRFV_APPLICANT_DETAILS;
APPS.HRFV_APPLICANT_DETAILS is not referenced by any database object
|
|
|