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_DA_SETUP

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_DA_SETUP_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	S_CONTROL_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
S_CONTROL_NUM	NUMBER	(1)	Yes	Primary Key, default to 1
PROGRAM_DEFINITION_IND	VARCHAR2	(1)	Yes	Determines what program information is sent to third party software
DEFAULT_STUDENT_ID_TYPE	VARCHAR2	(30)		Determines what student id value is sent to third party software
DEFAULT_INST_ID_TYPE	VARCHAR2	(30)		Determines what institution id value is sent to third party software
DEFAULT_ADDRESS_TYPE	VARCHAR2	(30)	Yes	Determines what address information is sent to third party software
WIF_MAJOR_UNIT_SET_CAT	VARCHAR2	(10)	Yes	Determines what unit set values are displayed for WIF majors in self service
WIF_MINOR_UNIT_SET_CAT	VARCHAR2	(10)	Yes	Determines what unit set values are displayed for WIF minors in self service
WIF_TRACK_UNIT_SET_CAT	VARCHAR2	(10)	Yes	Determines what unit set values are displayed for WIF tracks in self service
WIF_UNIT_SET_TITLE	VARCHAR2	(30)	Yes	Determines what unit set titles are displayed for WIF unit sets in self service
THIRD_PARTY_OPTIONS	VARCHAR2	(30)	Yes	Determines which request features are displayed in request template configuration
ADVISOR_RELATIONSHIP_IND	VARCHAR2	(1)	Yes	Determines whether or not advisors can only see student records in the advisor"s group - Obsolete
DISPLAY_CONTAINER_IND	VARCHAR2	(1)	Yes	Determines whether or not to display the content container containing a link to the third party software
CONTAINER_TITLE	VARCHAR2	(100)		Contains the title to be displayed in the content container
LINK_TEXT	VARCHAR2	(100)		Contains the link text to be displayed in the content container
LINK_URL	VARCHAR2	(256)		Contains the URL to the third party software
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 S_CONTROL_NUM
,      PROGRAM_DEFINITION_IND
,      DEFAULT_STUDENT_ID_TYPE
,      DEFAULT_INST_ID_TYPE
,      DEFAULT_ADDRESS_TYPE
,      WIF_MAJOR_UNIT_SET_CAT
,      WIF_MINOR_UNIT_SET_CAT
,      WIF_TRACK_UNIT_SET_CAT
,      WIF_UNIT_SET_TITLE
,      THIRD_PARTY_OPTIONS
,      ADVISOR_RELATIONSHIP_IND
,      DISPLAY_CONTAINER_IND
,      CONTAINER_TITLE
,      LINK_TEXT
,      LINK_URL
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_DA_SETUP;

Dependencies

[top of page]

IGS.IGS_DA_SETUP does not reference any database object

IGS.IGS_DA_SETUP is referenced by following:

APPS: IGS_DA_SETUP