eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.HRFV_APPLICANT_DETAILS

Object Details

Object Name:	HRFV_APPLICANT_DETAILS
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Applicant detailed information.

[View Source]

Columns

Name	Datatype	Length	Mandatory
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)

Query Text

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;

Dependencies

[top of page]

APPS.HRFV_APPLICANT_DETAILS references the following:

APPS: HRI_BPL_PERSON_TYPE - show dependent code; HR_ALL_ORGANIZATION_UNITS_TL; HR_ALL_POSITIONS_F_TL; HR_BIS - show dependent code; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL_TL; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PAY_PEOPLE_GROUPS; PER_ALL_PEOPLE_F; PER_ALL_VACANCIES; PER_APPLICATIONS; PER_ASSIGNMENTS_F; PER_ASSIGNMENT_STATUS_TYPES; PER_ASSIGNMENT_STATUS_TYPES_TL; PER_ASS_STATUS_TYPE_AMENDS; PER_ASS_STATUS_TYPE_AMENDS_TL; PER_GRADES_TL; PER_JOBS_TL; PER_PEOPLE_X; PER_PERIODS_OF_SERVICE; PER_PERSON_TYPES; PER_RECRUITMENT_ACTIVITIES

APPS.HRFV_APPLICANT_DETAILS is not referenced by any database object