[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
IGS.IGS_AS_VAH_CONF does not reference any database object
IGS.IGS_AS_VAH_CONF is referenced by following:
|
|
|