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

VIEW: APPS.IGS_UC_UVINSTITUTION_2003

Object Details
Object Name: IGS_UC_UVINSTITUTION_2003
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_UC_UVINSTITUTION_2003
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 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 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 new applicant labels,1 - 1 label,2 - 2 labels
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
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
FROM APPS.IGS_UC_UVINSTITUTION_2003;

Dependencies

[top of page]

APPS.IGS_UC_UVINSTITUTION_2003 references the following:

SchemaAPPS
SynonymIGS_UC_UINST_INTS
APPS.IGS_UC_UVINSTITUTION_2003 is referenced by following:

SchemaAPPS
SynonymIGS_UC_U_UVINSTITUTION_2003