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_DEFAULTS

Object Details

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

Holds default values that will get applied to UCAS application records being imported into OSS . This table will always hold 1 record at any time

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_UC_DEFAULTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SYSTEM_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
ACA_CAL_ALT_ID	VARCHAR2	(10)		Academic calendar Alternate Id - Obsolete
ACA_CAL_TYPE	VARCHAR2	(10)		Academic Calendar Type - Obsolete
ACA_CAL_SEQ_NO	NUMBER	(6)		Academic Calendar Sequence Number - Obsolete
ADM_CAL_ALT_ID	VARCHAR2	(10)		Academic calendar Alternate Id - Obsolete
ADM_CAL_TYPE	VARCHAR2	(10)		Admission Calendar Type - Obsolete
ADM_CAL_SEQ_NO	NUMBER	(6)		Admission Calendar Sequence Number - Obsolete
DEF_ACA_CAL_ALT_ID	VARCHAR2	(10)		Deferred Academic Calendar Alternate Id - Obsolete
DEF_ACA_CAL_TYPE	VARCHAR2	(10)		Deferred Academic Calendar Type - Obsolete
DEF_ACA_CAL_SEQ_NO	NUMBER	(6)		Deferred Academic Calendar Sequence Number - Obsolete
DEF_ADM_CAL_ALT_ID	VARCHAR2	(10)		Deferred Academic Calendar Alternate Id - Obsolete
DEF_ADM_CAL_TYPE	VARCHAR2	(10)		Deferred Admission Calendar Type - Obsolete
DEF_ADM_CAL_SEQ_NO	NUMBER	(6)		Deferred Admission Calendar Sequence Number - Obsolete
ADM_PROC_CAT	VARCHAR2	(10)		Case and Seed document: UC_UCCR009_APC Import Changes_3290860_C_DP2.doc - Obsolete
ADM_PROC_TYPE	VARCHAR2	(30)		Case and Seed document: UC_UCCR009_APC Import Changes_3290860_C_DP2.doc - Obsolete
CURRENT_INST_CODE	VARCHAR2	(3)		Current Institution code
UCAS_ID_FORMAT	VARCHAR2	(15)		9 digit UCAs Id format for future use
TEST_APP_NO	NUMBER	(8)		Application number to be used for testing offer conditions
TEST_CHOICE_NO	NUMBER	(2)		Application choice number to be used for testing offer conditions
TEST_TRANSACTION_TYPE	VARCHAR2	(2)		Transaction type to be used for testing offer conditions
COPY_UCAS_ID	VARCHAR2	(1)	Yes	Indicates the source of person number to be exported to OSS if auto-numbering is switched off in OSS . 'Y" indicates that the UCAS Id should be copied into person number . 'N' indicates that the customer will customize a stub routine to generate their own person number which will be exported to OSS
CREATED_BY	NUMBER	(15)	Yes	Standard WHO columns
CREATION_DATE	DATE		Yes	Standard WHO columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO columns
LAST_UPDATE_DATE	DATE		Yes	Standard WHO columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO columns
DECISION_MAKE_ID	NUMBER	(15)		The Unique Person Id assigned automatically to the application on creation
DECISION_REASON_ID	NUMBER	(15)		The unique Id Assigned to the decision reason code field of the admission application
OBSOLETE_OUTCOME_STATUS	VARCHAR2	(10)		User Admissions outcome status code with system status VOIDED
PENDING_OUTCOME_STATUS	VARCHAR2	(10)		User Admissions outcome status code with system status PENDING
REJECTED_OUTCOME_STATUS	VARCHAR2	(10)		User admissions outcome status code with system status REJECTED
SYSTEM_CODE	VARCHAR2	(1)	Yes	UCAS System Code
APPLICATION_TYPE	VARCHAR2	(30)		OSS Application Type
NI_NUMBER_ALT_PERS_TYPE	VARCHAR2	(10)		National Insurance Number Alternate Person ID Type
NAME	VARCHAR2	(10)		System Name
DESCRIPTION	VARCHAR2	(240)		System Description
UCAS_SECURITY_KEY	VARCHAR2	(6)		MARVIN File Name Security Key
CURRENT_CYCLE	NUMBER	(15)		Current Cycle for this system
CONFIGURED_CYCLE	NUMBER	(15)		Configured Cycle for this system
PREV_INST_LEFT_DATE	DATE			Used to hold the default Day and Month details, which are used to construct the Academic History's Effective to Date from the UCAS Year Left Previous Institution value. This column will be having the year component as dummy value of 1904

Query Text

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


SELECT ACA_CAL_ALT_ID
,      ACA_CAL_TYPE
,      ACA_CAL_SEQ_NO
,      ADM_CAL_ALT_ID
,      ADM_CAL_TYPE
,      ADM_CAL_SEQ_NO
,      DEF_ACA_CAL_ALT_ID
,      DEF_ACA_CAL_TYPE
,      DEF_ACA_CAL_SEQ_NO
,      DEF_ADM_CAL_ALT_ID
,      DEF_ADM_CAL_TYPE
,      DEF_ADM_CAL_SEQ_NO
,      ADM_PROC_CAT
,      ADM_PROC_TYPE
,      CURRENT_INST_CODE
,      UCAS_ID_FORMAT
,      TEST_APP_NO
,      TEST_CHOICE_NO
,      TEST_TRANSACTION_TYPE
,      COPY_UCAS_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DECISION_MAKE_ID
,      DECISION_REASON_ID
,      OBSOLETE_OUTCOME_STATUS
,      PENDING_OUTCOME_STATUS
,      REJECTED_OUTCOME_STATUS
,      SYSTEM_CODE
,      APPLICATION_TYPE
,      NI_NUMBER_ALT_PERS_TYPE
,      NAME
,      DESCRIPTION
,      UCAS_SECURITY_KEY
,      CURRENT_CYCLE
,      CONFIGURED_CYCLE
,      PREV_INST_LEFT_DATE
FROM IGS.IGS_UC_DEFAULTS;

Dependencies

[top of page]

IGS.IGS_UC_DEFAULTS does not reference any database object

IGS.IGS_UC_DEFAULTS is referenced by following:

APPS: IGS_UC_DEFAULTS