[Home] [Help] [Dependency Information]
Object Name: | IGS_UC_MV_UVCOURSE |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_UC_MV_UVCOURSE |
Subobject Name: | |
Status: | VALID |
This table is used to update institutions course details. - OBSOLETE
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
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 | (10) | Short Title | |
LONGTITLE | VARCHAR2 | (50) | 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 | Fourth term start date | ||
TERM4END | DATE | Fourth term end date | ||
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 | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
JOINTADMISSION | VARCHAR2 | (1) | Indicates Joint Admissions Entity course. | |
OPENEXTRA | VARCHAR2 | (1) | Open 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
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, JOINTADMISSION
, OPENEXTRA
FROM IGS.IGS_UC_MV_UVCOURSE;
IGS.IGS_UC_MV_UVCOURSE does not reference any database object
IGS.IGS_UC_MV_UVCOURSE is referenced by following:
|
|
|