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_SS_ACAD_HISTORY

Object Details

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

Stores the Academic History details for an Online Admission Application

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_SS_ACAD_HISTORY_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SS_ACAD_HISTORY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SS_ACAD_HISTORY_ID	NUMBER	(15)	Yes	Online Academic History Identifier ( SS_ACAD_HISTORY_S )
PERSON_ID	NUMBER	(15)	Yes	Person id
INSTITUTION_CD	VARCHAR2	(60)	Yes	Institution Code
CURRENT_INST	VARCHAR2	(1)	Yes	Current Institution Indicator (Y/N )
PROGRAM_TYPE_ATTEMPTED	VARCHAR2	(10)		Degree Attempted
PROGRAM_TYPE_EARNED	VARCHAR2	(60)		Degree Earned
COMMENTS	VARCHAR2	(240)		Comments
COURSE_MAJOR	VARCHAR2	(60)		Program Code
START_DATE	DATE			Start Date
END_DATE	DATE			End Date
PLANNED_COMPLETION_DATE	DATE			Planned Completion Date
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE			Standard Who Column
CREATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
STATUS	VARCHAR2	(30)	Yes	Inserted/Updated/Transferred
SELFREP_INST_GPA	VARCHAR2	(30)		Self reported GPA
SELFREP_GRADING_SCALE_ID	NUMBER	(15)		Self reported gpa - grading scale id

Query Text

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


SELECT SS_ACAD_HISTORY_ID
,      PERSON_ID
,      INSTITUTION_CD
,      CURRENT_INST
,      PROGRAM_TYPE_ATTEMPTED
,      PROGRAM_TYPE_EARNED
,      COMMENTS
,      COURSE_MAJOR
,      START_DATE
,      END_DATE
,      PLANNED_COMPLETION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      STATUS
,      SELFREP_INST_GPA
,      SELFREP_GRADING_SCALE_ID
FROM IGS.IGS_SS_ACAD_HISTORY;

Dependencies

[top of page]

IGS.IGS_SS_ACAD_HISTORY does not reference any database object

IGS.IGS_SS_ACAD_HISTORY is referenced by following:

APPS: IGS_SS_ACAD_HISTORY