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]

VIEW: APPS.IGSFV_STDNT_PAST_HIST

Object Details

Object Name:	IGSFV_STDNT_PAST_HIST
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_STDNT_PAST_HIST
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PAST_HISTORY_ID	NUMBER	(15)	Yes	Past history unique identifier
YEARS_OF_STUDY	NUMBER	(2)	Yes	Years of study
SUBJECT_ID	NUMBER	(15)	Yes	Past subject of study
SUBJECT_NAME	VARCHAR2	(10)	Yes	Name of the code
SUBJECT_DESC	VARCHAR2	(30)	Yes	Description of the code
HONORS	VARCHAR2	(1)		Honors degree
PERSON_ID	NUMBER	(15)	Yes	Person Identifier
PERSON_NUMBER	VARCHAR2	(30)	Yes	Unique identification number for this party
PERSON_NAME	VARCHAR2	(450)		The combination of title, first, middle, last, and suffix names.
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

Query Text

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


SELECT PAST_HISTORY_ID
,      YEARS_OF_STUDY
,      SUBJECT_ID
,      SUBJECT_NAME
,      SUBJECT_DESC
,      HONORS
,      PERSON_ID
,      PERSON_NUMBER
,      PERSON_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_STDNT_PAST_HIST;

Dependencies

[top of page]

APPS.IGSFV_STDNT_PAST_HIST references the following:

APPS: HZ_PARTIES; HZ_PERSON_PROFILES; IGS_AD_CODE_CLASSES; IGS_AD_PAST_HISTORY_ALL

APPS.IGSFV_STDNT_PAST_HIST is not referenced by any database object