[Home] [Help] [Dependency Information]
Object Name: | IGS_UC_IVSTARZ2_2003_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_UC_IVSTARZ2_2003_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
From 2004, application clearing round information will be held in different Hercules views for different systems. This View selects the application clearing round information belonging to all the systems.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPNO | NUMBER | (22) | Application Number | |
ROUNDNO | NUMBER | (22) | Round Number - previously used in Central Clearing - should be null | |
TIMESTAMP | DATE | Time stamp - date and time of last change | ||
INST | VARCHAR2 | (3) | Institution Code | |
COURSE | VARCHAR2 | (6) | Course Code | |
CAMPUS | VARCHAR2 | (1) | Campus Code | |
FACULTY | VARCHAR2 | (1) | Faculty Code | |
ROUNDTYPE | VARCHAR2 | (1) | Previously used in Central Clearing, now only contains "F" (Form Request) | |
RESULT | VARCHAR2 | (1) | blank = Form request - (copy form printed), * = New form request (copy form not yet printed), I = Accepted at this institution, R = Rejected by institution, D = Declined by applicant, C = Cancelled by applicant, X = Form request cancelled by UCAS, ( Other values refer to Central Clearing, not running for 2000 Cycle) |
Cut, paste (and edit) the following text to query this object:
SELECT APPNO
, ROUNDNO
, TIMESTAMP
, INST
, COURSE
, CAMPUS
, FACULTY
, ROUNDTYPE
, RESULT
FROM APPS.IGS_UC_IVSTARZ2_2003_V;
|
|
|