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.IRCFV_CANDIDATE_QUALFICATIONS

Object Details

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

View Type

A Business Intelligence System view

Shows the candidate entered qualifications.

[View Source]

Columns

Name	Datatype	Length	Mandatory
CANDIDATE_NAME	VARCHAR2	(450)
QUALIFICATION_TITLE	VARCHAR2	(120)
GRADE_ATTAINED	VARCHAR2	(100)
AWARDED_DATE	DATE
QUALIFICATION_CATEGORY	VARCHAR2	(4000)
QUALIFICATION_TYPE_NAME	VARCHAR2	(150)	Yes
QUALIFICATION_TYPE_RANK	NUMBER	(9)
QUALIFICATION_START_DATE	DATE
QUALIFICATION_END_DATE	DATE
PROJECTED_COMPLETION_DATE	DATE
GROUP_RANKING	VARCHAR2	(100)
QUALIFICATION_COMMENTS	VARCHAR2	(2000)
LICENSE_NUMBER	VARCHAR2	(60)
LICENSE_RESTRICTIONS	VARCHAR2	(255)
EXPIRY_DATE	DATE
TUITION_METHOD	VARCHAR2	(4000)
REIMBURSEMENT_ARRANGEMENTS	VARCHAR2	(2000)
TRAINING_COMPLETED_AMOUNT	NUMBER	(15)
TOTAL_TRAINING_AMOUNT	NUMBER	(15)
TRAINING_COMPLETED_UNITS	VARCHAR2	(100)
PROFESSIONAL_BODY_NAME	VARCHAR2	(80)
MEMBERSHIP_NUMBER	VARCHAR2	(80)
MEMBERSHIP_CATEGORY	VARCHAR2	(80)
SUBSCRIPTION_PAYMENT_METHOD	VARCHAR2	(80)
_DF	CHAR	(30)
QUALIFICATION_CATEGORY_CODE	VARCHAR2	(30)	Yes
TUITION_METHOD_CODE	VARCHAR2	(30)
QUALIFICATION_ID	NUMBER	(9)	Yes
PARTY_ID	NUMBER	(15)
QUALIFICATION_TYPE_ID	NUMBER	(9)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CANDIDATE_NAME
,      QUALIFICATION_TITLE
,      GRADE_ATTAINED
,      AWARDED_DATE
,      QUALIFICATION_CATEGORY
,      QUALIFICATION_TYPE_NAME
,      QUALIFICATION_TYPE_RANK
,      QUALIFICATION_START_DATE
,      QUALIFICATION_END_DATE
,      PROJECTED_COMPLETION_DATE
,      GROUP_RANKING
,      QUALIFICATION_COMMENTS
,      LICENSE_NUMBER
,      LICENSE_RESTRICTIONS
,      EXPIRY_DATE
,      TUITION_METHOD
,      REIMBURSEMENT_ARRANGEMENTS
,      TRAINING_COMPLETED_AMOUNT
,      TOTAL_TRAINING_AMOUNT
,      TRAINING_COMPLETED_UNITS
,      PROFESSIONAL_BODY_NAME
,      MEMBERSHIP_NUMBER
,      MEMBERSHIP_CATEGORY
,      SUBSCRIPTION_PAYMENT_METHOD
,      _DF
,      QUALIFICATION_CATEGORY_CODE
,      TUITION_METHOD_CODE
,      QUALIFICATION_ID
,      PARTY_ID
,      QUALIFICATION_TYPE_ID
FROM APPS.IRCFV_CANDIDATE_QUALFICATIONS;

Dependencies

[top of page]

APPS.IRCFV_CANDIDATE_QUALFICATIONS references the following:

APPS: HR_BIS - show dependent code; HZ_PERSON_PROFILES; IRC_NOTIFICATION_PREFERENCES; PER_QUALIFICATIONS; PER_QUALIFICATION_TYPES

APPS.IRCFV_CANDIDATE_QUALFICATIONS is not referenced by any database object