[Home] [Help] [Dependency Information]
Object Name: | IRCFV_CAND_SCHOOL_COLL_ATT |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Shows the candidate entered school/college attendance, with (if they exist) associated education qualifications.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CANDIDATE_NAME | VARCHAR2 | (450) | ||
QUALIFICATION_TITLE | VARCHAR2 | (120) | ||
GRADE_ATTAINED | VARCHAR2 | (100) | ||
AWARDED_DATE | DATE | |||
SCHOOL_OR_COLLEGE_NAME | VARCHAR2 | (255) | ||
QUALIFICATION_CATEGORY | VARCHAR2 | (4000) | ||
QUALIFICATION_TYPE_NAME | VARCHAR2 | (150) | ||
_DF:QUAL | CHAR | (30) | ||
_DF:ATT | CHAR | (41) | ||
QUALIFICATION_CATEGORY_CODE | VARCHAR2 | (30) | ||
QUALIFICATION_ID | NUMBER | (9) | ||
PARTY_ID | NUMBER | (15) | Yes | |
QUALIFICATION_TYPE_ID | NUMBER | (9) | ||
ATTENDANCE_ID | NUMBER | (9) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT CANDIDATE_NAME
, QUALIFICATION_TITLE
, GRADE_ATTAINED
, AWARDED_DATE
, SCHOOL_OR_COLLEGE_NAME
, QUALIFICATION_CATEGORY
, QUALIFICATION_TYPE_NAME
, _DF:QUAL
, _DF:ATT
, QUALIFICATION_CATEGORY_CODE
, QUALIFICATION_ID
, PARTY_ID
, QUALIFICATION_TYPE_ID
, ATTENDANCE_ID
FROM APPS.IRCFV_CAND_SCHOOL_COLL_ATT;
APPS.IRCFV_CAND_SCHOOL_COLL_ATT is not referenced by any database object
|
|
|