eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGS.IGS_UC_MV_UVINST

Object Details

Object Name:	IGS_UC_MV_UVINST
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_UC_MV_UVINST
Subobject Name:
Status:	VALID

This view allows the institution to maintain some of its own institution details kept by UCAS - OBSOLETE

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
TIMESTAMP	DATE			Time stamp - date and time of last change
UPDATER	VARCHAR2	(17)		ID of last updater
INSTTYPE	VARCHAR2	(1)		A - Route A only institution , B - Route B only institution, C - Route A and B institution
INSTSHORTNAME	VARCHAR2	(5)		e.g. ABRDN
INSTNAME	VARCHAR2	(20)		e.g. Aberdeen
INSTFULLNAME	VARCHAR2	(60)		Full Name
SWITCHBOARDTELNO	VARCHAR2	(20)		0-9 and hyphen
DECISIONCARDS	VARCHAR2	(1)		Space - No decision docs , A - Online decision cards, B - D1 documents (D4 Clearing)
RECORDCARDS	VARCHAR2	(1)		Space - No record cards, 1 - 1 record card, 2 - 2 record cards
LABELS	VARCHAR2	(1)		Space - No new applicant labels, 1 - 1 label , l2 - 2 labels
WEEKLYMOVLISTSEQ	VARCHAR2	(1)		Space - no list, A - alpha, B - course/alpha, D - faculty/alpha , E - faculty/course/alpha, N - appno, P - course/appno, R - faculty/appno , T - faculty/course/appno
WEEKLYMOVPAGING	VARCHAR2	(1)		Space - no list, N - no paging major key change, Y - paging at major key change
FORMSEQ	VARCHAR2	(1)		A, B, D, E, N, P, R or T
EBLREQUIRED	VARCHAR2	(1)		Space - No EBL required, A - EBL1, EBL2, EBL3 required , N - No EBL required, P - EBL2, EBL3 only , R - EBL3 only
EBLMEDIA1OR2	VARCHAR2	(1)		Space - No EBL1/2, L - EBL printed, T - EBL on magnetic tape
EBLMEDIA3	VARCHAR2	(1)		Space - No EBL3, L - EBL printed, O - EBL Online (MARVIN *R records), T - EBL on magnetic tape (Obsolete value)
EBL1OR2MERGED	VARCHAR2	(1)		Space - No EBL1/2, N - EBL1 and EBL2 separate, Y - EBL1 and EBL2 merged
EBL1OR2BOARDGROUP	VARCHAR2	(1)		Space - No EBL1/2, F - EBL1/2 fully combined, S - EBL1/2 separate boards
EBL3BOARDGROUP	VARCHAR2	(1)		Space - No EBL3, C - EBL3 combined boards, F - EBL3 fully combined boards, S - EBL3 separate boards
EBLNCAPP	VARCHAR2	(1)		Space - no EBL required, N - None Committed applicants excluded, Y -None Committed applicants required
EBLMAJORKEY1	VARCHAR2	(1)		Space - major key not required, C - Course, F - Faculty, G - Grouped June category, J - June category, S - Sex Y - Year of entry
EBLMAJORKEY2	VARCHAR2	(1)		Space - not required , C, F, G, J, S, Y as EBLMajorKey1
EBLMAJORKEY3	VARCHAR2	(1)		As EBLMajorKey2
EBLMINORKEY1	VARCHAR2	(1)		Space - minor key not required , C, F, G, J, S, Y as EBLMajorKey1
EBLMINORKEY2	VARCHAR2	(1)		Space - not required , C, F, G, J, S, Y as EBLMajorKey1
EBLMINORKEY3	VARCHAR2	(1)		As EBLMinorKey2
EBLFINALKEY	VARCHAR2	(1)		Space - no EBL required, A - Alpha, B - Board ref(centre), N - Application reference number
ODL1	VARCHAR2	(1)		Space - no ODL1, A - alpha, B - course/alpha, D - faculty/alpha, E - faculty/course/alpha, N - appno, P - course/appno, R - faculty/appno, T - faculty/course/appno
ODL1A	VARCHAR2	(1)		Space - no ODL1A , A, B, D, E, N, P, R, T as ODL1
ODL2	VARCHAR2	(1)		Space - no ODL2 , A, B, D, E, N, P, R, T as ODL1
ODL3	VARCHAR2	(1)		Space - no ODL3 , A, B, D, E, N, P, R, T as ODL1
ODLSUMMER	VARCHAR2	(1)		Space - no Summer ODL , A, B, D, E, N, P, R, T as ODL1
ODLROUTEB	VARCHAR2	(1)		Space - no Route B ODL , A, B, D, E, N, P, R, T as ODL1
MONTHLYSEQ	VARCHAR2	(1)		Space - no monthly info/movement , A, B, D, E, N, P, R, T as ODL1
MONTHLYPAPER	VARCHAR2	(1)		Space - no monthly info/movement , 1 - 1-part paper , 2 - 2-part paper
MONTHLYPAGE	VARCHAR2	(1)		Space - no monthly info/movement , N - No paging at major key change , Y - Paging at major key change
MONTHLYTYPE	VARCHAR2	(1)		Space - no monthly info/movement, I - information list, M - movement list
JUNELISTSEQ	VARCHAR2	(1)		Space - no June lists , A - alpha, B - course/alpha, D - faculty/alpha, E - faculty/course/alpha, N - appno, P - course/appno, R - faculty/appno, T - faculty/course/appno, X - faculty/course/cat/appno
JUNELABELS	VARCHAR2	(1)		Space - no June labels, A - alpha, B - course/alpha, D - faculty/alpha, E - faculty/course/alpha, N - appno, P - course/appno, R - faculty/appno, T - faculty/course/appno
JUNENUMLABELS	VARCHAR2	(1)		Space - no labels, 1 - 1 set label , s2 - 2 sets labels
COURSEANALYSIS	VARCHAR2	(1)		Space - No D3 decision docs , 1 - Monthly in course order , 2 - Fortnightly in course order , 3 - Monthly in faculty order , 4 - Fortnightly in faculty order
CAMPUSUSED	VARCHAR2	(1)		Space - Campus codes not used , C - Campus codes used
D3DOCSREQUIRED	VARCHAR2	(1)		Space - No D3 decision docs , N - No D3 decision docs , Y - D3 decision docs required
CLEARINGACCEPTCOPYFORM	VARCHAR2	(1)		Space - No Application form copy , Y - Application form for Clearing Accept
ONLINEMESSAGE	VARCHAR2	(48)		Message for this user
ETHNICLISTSEQ	VARCHAR2	(1)		Space - no June labels, A - alpha, B - course/alpha , D - faculty/alpha, E - faculty/course/alpha, N - appnoP - course/appno, R - faculty/appno, T - faculty/course/appno
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 TIMESTAMP
,      UPDATER
,      INSTTYPE
,      INSTSHORTNAME
,      INSTNAME
,      INSTFULLNAME
,      SWITCHBOARDTELNO
,      DECISIONCARDS
,      RECORDCARDS
,      LABELS
,      WEEKLYMOVLISTSEQ
,      WEEKLYMOVPAGING
,      FORMSEQ
,      EBLREQUIRED
,      EBLMEDIA1OR2
,      EBLMEDIA3
,      EBL1OR2MERGED
,      EBL1OR2BOARDGROUP
,      EBL3BOARDGROUP
,      EBLNCAPP
,      EBLMAJORKEY1
,      EBLMAJORKEY2
,      EBLMAJORKEY3
,      EBLMINORKEY1
,      EBLMINORKEY2
,      EBLMINORKEY3
,      EBLFINALKEY
,      ODL1
,      ODL1A
,      ODL2
,      ODL3
,      ODLSUMMER
,      ODLROUTEB
,      MONTHLYSEQ
,      MONTHLYPAPER
,      MONTHLYPAGE
,      MONTHLYTYPE
,      JUNELISTSEQ
,      JUNELABELS
,      JUNENUMLABELS
,      COURSEANALYSIS
,      CAMPUSUSED
,      D3DOCSREQUIRED
,      CLEARINGACCEPTCOPYFORM
,      ONLINEMESSAGE
,      ETHNICLISTSEQ
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_UC_MV_UVINST;

Dependencies

[top of page]

IGS.IGS_UC_MV_UVINST does not reference any database object

IGS.IGS_UC_MV_UVINST is referenced by following:

APPS: IGS_UC_MV_UVINST