[Home] [Help] [Dependency Information]
Object Name: | IRCFV_CANDIDATE_QUALFICATIONS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Shows the candidate entered qualifications.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
APPS.IRCFV_CANDIDATE_QUALFICATIONS is not referenced by any database object
|
|
|