DBA Data[Home] [Help] [Dependency Information]

TABLE: IGS.IGS_UC_MV_UVCRS_VAC

Object Details
Object Name: IGS_UC_MV_UVCRS_VAC
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_UC_MV_UVCRS_VAC
Subobject Name:
Status: VALID


This table allows an institution to see its own course keywords. It also allows the institution to activate or deactivate any row. - OBSOLETE


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
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
CLUPDATED VARCHAR2 (1)
Y - Updated not yet notified
CLDATE DATE

Vacancies updated date
VACSTATUS VARCHAR2 (1)
Y - Open to all applicants, N - Closed, O - Overseas only (not applicable to an option)
NOVAC VARCHAR2 (2)
Number of vacancies or GI for group intake
SCORE NUMBER (2)
00 - 30
RBFULL VARCHAR2 (1)
Null - Open, F - Full
SCOTVAC VARCHAR2 (6)
Up to 6 grades of A,B or C
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT COURSE
,      CAMPUS
,      TIMESTAMP
,      UPDATER
,      CLUPDATED
,      CLDATE
,      VACSTATUS
,      NOVAC
,      SCORE
,      RBFULL
,      SCOTVAC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_UC_MV_UVCRS_VAC;

Dependencies

[top of page]

IGS.IGS_UC_MV_UVCRS_VAC does not reference any database object

IGS.IGS_UC_MV_UVCRS_VAC is referenced by following:

SchemaAPPS
SynonymIGS_UC_MV_UVCRS_VAC