[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_UC_INST_CONTROL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_UC_INST_CONTROL
|
| Subobject Name: | |
| Status: | VALID |
Holds the control information for the institution using UCAS sub-system. It synchronizes with UCAS view 'uvInstitution'
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| DATETIMESTAMP | DATE | Timestamp for synchronizing with UCAS - Obsolete | ||
| UPDATER | VARCHAR2 | (20) | No longer used | |
| INST_TYPE | VARCHAR2 | (1) | No longer used | |
| INST_SHORT_NAME | VARCHAR2 | (5) | Abbreviated institute name | |
| INST_NAME | VARCHAR2 | (20) | Institute name | |
| INST_FULL_NAME | VARCHAR2 | (100) | Institute full name | |
| SWITCHBOARD_TEL_NO | VARCHAR2 | (35) | Updateable with '0'-'9' and '-' | |
| DECISION_CARDS | VARCHAR2 | (1) | Coded number of Decision Cards | |
| RECORD_CARDS | VARCHAR2 | (1) | Coded number of Record Cards | |
| LABELS | VARCHAR2 | (1) | Coded number of new applicant labels | |
| WEEKLY_MOV_LIST_SEQ | VARCHAR2 | (1) | Order of weekly move lists | |
| WEEKLY_MOV_PAGING | VARCHAR2 | (1) | Pagination for weekly move lists | |
| FORM_SEQ | VARCHAR2 | (1) | Updateable coded order of forms | |
| EBL_REQUIRED | VARCHAR2 | (1) | Indicates Examination Board Listing requirement (EBL1,2,3 required, no EBL required etc.) | |
| EBL_MEDIA_1OR2 | VARCHAR2 | (1) | Media for EBL 1 / 2 | |
| EBL_MEDIA_3 | VARCHAR2 | (1) | Media for EBL 3 | |
| EBL_1OR2_MERGED | VARCHAR2 | (1) | Indicates if EBL1 & 2 are separate or merged | |
| EBL_1OR2_BOARD_GROUP | VARCHAR2 | (1) | Indicates if EBL 1 & 2 have separate boards | |
| EBL_3_BOARD_GROUP | VARCHAR2 | (1) | Indicates if EBL3 has a combined board | |
| EBL_NC_APP | VARCHAR2 | (1) | Indicate if non-committed applicants are excluded or required in EBL | |
| EBL_MAJOR_KEY1 | VARCHAR2 | (1) | Major key 1 for EBL | |
| EBL_MAJOR_KEY2 | VARCHAR2 | (1) | Major key 2 for EBL | |
| EBL_MAJOR_KEY3 | VARCHAR2 | (1) | Major key 3 for EBL | |
| EBL_MINOR_KEY1 | VARCHAR2 | (1) | Minor Key 1 for EBL | |
| EBL_MINOR_KEY2 | VARCHAR2 | (1) | Minor Key 2 for EBL | |
| EBL_MINOR_KEY3 | VARCHAR2 | (1) | Minor Key 3 for EBL | |
| EBL_FINAL_KEY | VARCHAR2 | (1) | Final key for EBL | |
| ODL1 | VARCHAR2 | (1) | Updateable coded order for Outstanding Decision List 1 | |
| ODL1A | VARCHAR2 | (1) | Updateable coded order for ODL1A | |
| ODL2 | VARCHAR2 | (1) | Updateable coded order for ODL2 | |
| ODL3 | VARCHAR2 | (1) | Updateable coded order for ODL3 | |
| ODL_SUMMER | VARCHAR2 | (1) | Updateable order for summer ODL | |
| ODL_ROUTE_B | VARCHAR2 | (1) | Updateable coded order for route B ODL | |
| MONTHLY_SEQ | VARCHAR2 | (1) | Order for monthly information | |
| MONTHLY_PAPER | VARCHAR2 | (1) | Number of parts for monthly information | |
| MONTHLY_PAGE | VARCHAR2 | (1) | Pagination for monthly information | |
| MONTHLY_TYPE | VARCHAR2 | (1) | Type of monthly information (null - none, I - information list, M - movement list) | |
| JUNE_LIST_SEQ | VARCHAR2 | (1) | Order for June list | |
| JUNE_LABELS | VARCHAR2 | (1) | Order for June labels | |
| JUNE_NUM_LABELS | VARCHAR2 | (1) | Number of June labels | |
| COURSE_ANALYSIS | VARCHAR2 | (1) | Frequency of decision documents | |
| CAMPUS_USED | VARCHAR2 | (1) | Indicates whether campus codes are used | |
| D3_DOC_REQUIRED | VARCHAR2 | (1) | Indicates if D3 decision documents required | |
| CLEARING_ACCEPT_COPY_FORM | VARCHAR2 | (1) | Updateable Accept copy of application form for clearing | |
| ONLINE_MESSAGE | VARCHAR2 | (48) | Message for the user | |
| ETHNIC_LIST_SEQ | VARCHAR2 | (1) | Updateable coded order for ethnic lists | |
| 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 | |
| STARX | VARCHAR2 | (1) | Indicates whether starx transaction is required or not |
Cut, paste (and edit) the following text to query this object:
SELECT DATETIMESTAMP
, UPDATER
, INST_TYPE
, INST_SHORT_NAME
, INST_NAME
, INST_FULL_NAME
, SWITCHBOARD_TEL_NO
, DECISION_CARDS
, RECORD_CARDS
, LABELS
, WEEKLY_MOV_LIST_SEQ
, WEEKLY_MOV_PAGING
, FORM_SEQ
, EBL_REQUIRED
, EBL_MEDIA_1OR2
, EBL_MEDIA_3
, EBL_1OR2_MERGED
, EBL_1OR2_BOARD_GROUP
, EBL_3_BOARD_GROUP
, EBL_NC_APP
, EBL_MAJOR_KEY1
, EBL_MAJOR_KEY2
, EBL_MAJOR_KEY3
, EBL_MINOR_KEY1
, EBL_MINOR_KEY2
, EBL_MINOR_KEY3
, EBL_FINAL_KEY
, ODL1
, ODL1A
, ODL2
, ODL3
, ODL_SUMMER
, ODL_ROUTE_B
, MONTHLY_SEQ
, MONTHLY_PAPER
, MONTHLY_PAGE
, MONTHLY_TYPE
, JUNE_LIST_SEQ
, JUNE_LABELS
, JUNE_NUM_LABELS
, COURSE_ANALYSIS
, CAMPUS_USED
, D3_DOC_REQUIRED
, CLEARING_ACCEPT_COPY_FORM
, ONLINE_MESSAGE
, ETHNIC_LIST_SEQ
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, STARX
FROM IGS.IGS_UC_INST_CONTROL;
IGS.IGS_UC_INST_CONTROL does not reference any database object
IGS.IGS_UC_INST_CONTROL is referenced by following:
APPS
IGS_UC_INST_CONTROL
|
|
|
|