[Home] [Help] [Dependency Information]
Object Name: | IGS_UC_UVCOURSE_2003 |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_UC_UVCOURSE_2003 |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COURSE | VARCHAR2 | (6) | Course Code | |
CAMPUS | VARCHAR2 | (1) | Campus Code | |
TIMESTAMP | DATE | Time stamp - date and time of last change | ||
UPDATER | VARCHAR2 | (17) | ID of last updater | |
FACULTY | VARCHAR2 | (1) | Faculty Code | |
SHORTTITLE | VARCHAR2 | (20) | Short Title | |
LONGTITLE | VARCHAR2 | (100) | Long Title | |
VALIDCURR | VARCHAR2 | (1) | D - Discontinued, R - Running, Null - Invalid | |
VALIDDEFER | VARCHAR2 | (1) | D - Discontinued, R - Running, Null - Invalid | |
TERM1START | DATE | First term start date | ||
TERM1END | DATE | First term end date | ||
TERM2START | DATE | Second term start date | ||
TERM2END | DATE | Second term end date | ||
TERM3START | DATE | Third term start date | ||
TERM3END | DATE | Third term end date | ||
TERM4START | DATE | Fouth term start date | ||
TERM4END | DATE | Fouth term end date | ||
JOINTADMISSION | VARCHAR2 | (1) | Joint admission indicator | |
OPENEXTRA | VARCHAR2 | (1) | Open for extra indicator |
Cut, paste (and edit) the following text to query this object:
SELECT COURSE
, CAMPUS
, TIMESTAMP
, UPDATER
, FACULTY
, SHORTTITLE
, LONGTITLE
, VALIDCURR
, VALIDDEFER
, TERM1START
, TERM1END
, TERM2START
, TERM2END
, TERM3START
, TERM3END
, TERM4START
, TERM4END
, JOINTADMISSION
, OPENEXTRA
FROM APPS.IGS_UC_UVCOURSE_2003;
|
|
|