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_AS_VAH_CONF

Object Details

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

Program Type View Academic History Configuration

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_VAH_CONF_PK	NORMAL	UNIQUE	APPS_TS_SEED	CONFIGURATION_ID
IGS_AS_VAH_CONF_U1	NORMAL	UNIQUE	APPS_TS_SEED	COURSE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
CONFIGURATION_ID	NUMBER		Yes	Sequence generated primary key
COURSE_TYPE	VARCHAR2	(10)		Stores the display configuration for a specific course type.
DISPLAY_ORDER_FLAG	VARCHAR2	(1)	Yes	Defines the order in which the history information is displayed. If true, the student's current or most recent career/program is displayed first in reverse chronological order otherwise the display is in chronological order.Default 'N'
START_NOTE_FLAG	VARCHAR2	(1)	Yes	Determines whether or not the Start of Career/Program note is enabled and displayed Default 'N'
PROGRAM_REGION_FLAG	VARCHAR2	(1)	Yes	Determines if the Basis of Admissions or the Record of Learning and Achievement region is displayed.Default 'N'
TEST_SCORE_FLAG	VARCHAR2	(1)	Yes	Determines whether or not the test scores are displayed.Default 'N'
SUM_ADV_STND_FLAG	VARCHAR2	(1)	Yes	Determines whether or not the Summary of Advanced Standing is displayed.Default 'N'
ADMISSION_NOTE_FLAG	VARCHAR2	(1)	Yes	Determines whether or not the Basis of Admissions note is enabled and displayed.Default 'N'
TERM_REGION_FLAG	VARCHAR2	(1)	Yes	Determines if the Term Details Region is displayed.Default 'Y'
UNIT_DETAILS_FLAG	VARCHAR2	(1)	Yes	Determines whether or not the Institution Unit Details are displayed.Default 'Y'
UNIT_NOTE_FLAG	VARCHAR2	(1)	Yes	Determines whether or not the Unit Notes are enabled and displayed.Default 'N'
ADV_STND_UNIT_FLAG	VARCHAR2	(1)	Yes	Determines whether or not Advanced Standing Units are displayed.Default 'N'
ADV_STND_UNIT_LEVEL_FLAG	VARCHAR2	(1)	Yes	Determines whether or not Advanced Standing Unit Level details are displayed.Default 'N'
STATISTICS_FLAG	VARCHAR2	(1)	Yes	Determines whether or not the Statistical Details or Year of Program Results are displayed.Default 'N'
CLASS_RANK_FLAG	VARCHAR2	(1)	Yes	Determines whether or not the Class Rank is displayed.Default 'N'
INTERMISSION_FLAG	VARCHAR2	(1)	Yes	Determines whether or not Intermission details are displayed.Default 'N'
SPECIAL_REQ_FLAG	VARCHAR2	(1)	Yes	Determines whether or not Special Requirements are displayed.Default 'N'
PERIOD_NOTE_FLAG	VARCHAR2	(1)	Yes	Determines whether or not the Term Note is enabled and displayed.Default 'N'
UNIT_SET_FLAG	VARCHAR2	(1)	Yes	Determines whether or not Unit Set details are displayed.Default 'N'
AWARDS_FLAG	VARCHAR2	(1)	Yes	Determines whether or not the Awards region is displayed.Default 'N'
PROG_COMPLETION_FLAG	VARCHAR2	(1)	Yes	Determines whether or not the Program Completion details are displayed.Default 'N'
DEGREE_NOTE_FLAG	VARCHAR2	(1)	Yes	Determines whether or not the Degree Note is enabled and displayed.Default 'N'
END_NOTE_FLAG	VARCHAR2	(1)	Yes	Determines whether or not the End of Career Note is enabled and displayed.Default 'N'
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
UNT_LVL_MARKS_FLAG	VARCHAR2	(1)		Determines whether or not the Unit Level marks are displayed

Query Text

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


SELECT CONFIGURATION_ID
,      COURSE_TYPE
,      DISPLAY_ORDER_FLAG
,      START_NOTE_FLAG
,      PROGRAM_REGION_FLAG
,      TEST_SCORE_FLAG
,      SUM_ADV_STND_FLAG
,      ADMISSION_NOTE_FLAG
,      TERM_REGION_FLAG
,      UNIT_DETAILS_FLAG
,      UNIT_NOTE_FLAG
,      ADV_STND_UNIT_FLAG
,      ADV_STND_UNIT_LEVEL_FLAG
,      STATISTICS_FLAG
,      CLASS_RANK_FLAG
,      INTERMISSION_FLAG
,      SPECIAL_REQ_FLAG
,      PERIOD_NOTE_FLAG
,      UNIT_SET_FLAG
,      AWARDS_FLAG
,      PROG_COMPLETION_FLAG
,      DEGREE_NOTE_FLAG
,      END_NOTE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      UNT_LVL_MARKS_FLAG
FROM IGS.IGS_AS_VAH_CONF;

Dependencies

[top of page]

IGS.IGS_AS_VAH_CONF does not reference any database object

IGS.IGS_AS_VAH_CONF is referenced by following:

APPS: IGS_AS_VAH_CONF