[Home] [Help] [Dependency Information]
Object Name: | IGSFV_UC_APPLICANT_RESULTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_UC_APPLICANT_RESULTS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Full View for Applicant Examination Results
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICANT_RESULT_IDENTIFIER | NUMBER | Yes | Unique Record Identifier | |
UCAS_APPLICANT_NUMBER | NUMBER | (8) | UCAS application number | |
ENQUIRY_NUMBER | NUMBER | Clearing enquiry number | ||
EXAM_LEVEL | VARCHAR2 | (2) | Yes | Examination level |
EXAM_YEAR | VARCHAR2 | (4) | Yes | Examination year |
SITTING | VARCHAR2 | (1) | Yes | Sitting |
_LA:SITTING_DESC | CHAR | (55) | ||
AWARDING_BODY | VARCHAR2 | (1) | Yes | Awarding body |
PREDICTED_RESULT | VARCHAR2 | (2) | Predicted result | |
RESULT_IN_OFFER | VARCHAR2 | (2) | Result stated in conditional offer | |
EBL_RESULT | VARCHAR2 | (2) | Result declared by exam board | |
EBL_AMENDED_RESULT | VARCHAR2 | (2) | Amended result declared by exam board | |
CLAIMED_RESULT | VARCHAR2 | (2) | Applicant claimed result | |
IMPORTED_FLAG | VARCHAR2 | (1) | Yes | Record imported from UCAS ('Y' Yes, 'N' No) |
OSS_PERSON_IDENTIFIER | NUMBER | (15) | OSS Person Identifier | |
OSS_PERSON_NUMBER | VARCHAR2 | (30) | OSS Person Number | |
OSS_PERSON_NAME | VARCHAR2 | (360) | OSS Person Name | |
SUBJECT_CODE | VARCHAR2 | (6) | Yes | Subject abbreviation |
SUBJECT_TITLE | VARCHAR2 | (45) | Subject Title | |
AWARDING_BODY_NAME | VARCHAR2 | (30) | Awarding Body Name | |
APPLICANT_IDENTIFIER | NUMBER | Yes | Unique applicant identifier | |
SUBJECT_IDENTIFIER | NUMBER | Yes | Subject Identifier | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
CREATION_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICANT_RESULT_IDENTIFIER
, UCAS_APPLICANT_NUMBER
, ENQUIRY_NUMBER
, EXAM_LEVEL
, EXAM_YEAR
, SITTING
, _LA:SITTING_DESC
, AWARDING_BODY
, PREDICTED_RESULT
, RESULT_IN_OFFER
, EBL_RESULT
, EBL_AMENDED_RESULT
, CLAIMED_RESULT
, IMPORTED_FLAG
, OSS_PERSON_IDENTIFIER
, OSS_PERSON_NUMBER
, OSS_PERSON_NAME
, SUBJECT_CODE
, SUBJECT_TITLE
, AWARDING_BODY_NAME
, APPLICANT_IDENTIFIER
, SUBJECT_IDENTIFIER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_UC_APPLICANT_RESULTS;
APPS.IGSFV_UC_APPLICANT_RESULTS is not referenced by any database object
|
|
|