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]

VIEW: APPS.IGS_UC_UVINSTITUTION_2004

Object Details

Object Name:	IGS_UC_UVINSTITUTION_2004
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_UC_UVINSTITUTION_2004
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	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 inst, B - Route B only inst, C - Route A&B inst.
INSTSHORTNAME	VARCHAR2	(5)	e.g. ABRDN
INSTNAME	VARCHAR2	(20)	e.g. Aberdeen
INSTFULLNAME	VARCHAR2	(100)	Full Name
SWITCHBOARDTELNO	VARCHAR2	(35)	0-9 and hyphen
DECISIONCARDS	VARCHAR2	(1)	Space - No decision docs, A - Online decision cards, B - D1 documents (D4 Clring)
RECORDCARDS	VARCHAR2	(1)	Space - No records cards, 1 - 1 record card, 2 - 2 record cards
LABELS	VARCHAR2	(1)	Space - No new applicant labels,1 - 1 label,2 - 2 labels
WEEKLYMOVLISTSEQ	VARCHAR2	(1)	Space - no list, A - alpha, B - course or alpha, D - faculty or alpha, E - faculty or course or alpha, N - appno, P - course or appno, R - faculty or appno, T - faculty or course or 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
EBLMEDIA1OR2	VARCHAR2	(1)	Space - No EBL1 or 2, L - EBL printed, T - EBL on mag tape
EBLMEDIA3	VARCHAR2	(1)	Space - No EBL3, L - EBL printed, O - EBL Online (MARVIN *R records), T - EBL on mag tape (Obsolete value)
EBL1OR2MERGED	VARCHAR2	(1)	Space - No EBL1 or 2, N - EBL1 and EBL2 separate, Y - EBL1 and EBL2 merged
EBL1OR2BOARDGROUP	VARCHAR2	(1)	Space - No EBL1 or 2, F - EBL1 or 2 fully combined, S - EBL1 or 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(center or cand), N - App-reference number
ODL1	VARCHAR2	(1)	Space - no ODL1, A - alpha , B - course or alpha, D - faculty or alpha, E - faculty or course or alpha, N - appno, P - course or appno, R - faculty or appno, T - faculty or course or 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 or movement. A, B, D, E, N, P, R, T as ODL1
MONTHLYPAPER	VARCHAR2	(1)	Space - no monthly info or movement. 1 - 1-part paper, 2 - 2-part paper
MONTHLYPAGE	VARCHAR2	(1)	Space - no monthly info or movement. N - No paging at major key change, Y - Paging at major key change
MONTHLYTYPE	VARCHAR2	(1)	Space - no monthly info or movement. I - information list, M - movement list
JUNELISTSEQ	VARCHAR2	(1)	Space - no June lists, A - alpha, B - course or alpha, D - faculty or alpha, E - faculty or course or alpha, N - appno, P - course or appno, R - faculty or appno, T - faculty or course or appno, X - faculty or course or cat or appno
JUNELABELS	VARCHAR2	(1)	Space - no June labels, A - alpha , B - course or alpha, D - faculty or alpha, E - faculty or course or alpha, N - appno, P - course or appno, R - faculty or appno, T - faculty or course or appno
JUNENUMLABELS	VARCHAR2	(1)	Space - no labels, 1 - 1 set labels, 2 - 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 or alpha, D - faculty or alpha, E - faculty or course or alpha, N - appno, P - course or appno, R - faculty or appno, T - faculty or course or appno
STARX	VARCHAR2	(1)	Indicates if Starx transaction is necessary or not

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
,      STARX
FROM APPS.IGS_UC_UVINSTITUTION_2004;

Dependencies

[top of page]

APPS.IGS_UC_UVINSTITUTION_2004 references the following:

APPS: IGS_UC_UINST_INTS

APPS.IGS_UC_UVINSTITUTION_2004 is referenced by following:

APPS: IGS_UC_U_UVINSTITUTION_2004