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_ACAD_TRANSCRIPT_TERMS

Object Details

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

View Type

A Business Intelligence System view

Contains transcript term details

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TERM	VARCHAR2	(30)	Yes	Term name
EFFECTIVE_START_DATE	DATE		Yes	Term starting date
EFFECTIVE_END_DATE	DATE		Yes	Term ending date
TOTAL_CREDIT_POINT_ATTEMPTED	NUMBER			Total credit points attempted
TOTAL_CREDIT_POINT_EARNED	NUMBER			Total credit points earned
TOTAL_UNIT_GRADE_POINT	NUMBER			Total unit grade points
TOTAL_GPA_UNITS	NUMBER			Total grade point average units
GRADE_POINT_AVERAGE	VARCHAR2	(30)		Grade point average
_LA:TRANSCRIPT_TYPE	CHAR	(64)		This indicates if the Transcript is Official or Unofficial
_LA:TRANSCRIPT_STATUS	CHAR	(68)		Transcript status. It can be final, Partial or Others.
DATE_OF_ISSUE	DATE			Date on which the transcript is issued
DATE_OF_RECEIPT	DATE			Date of receipt of transcript
TERM_DETAILS_ID	NUMBER	(15)	Yes	Unique identifier for the term details
TRANSCRIPT_ID	NUMBER	(15)	Yes	Transcript identifier
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 TERM
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      TOTAL_CREDIT_POINT_ATTEMPTED
,      TOTAL_CREDIT_POINT_EARNED
,      TOTAL_UNIT_GRADE_POINT
,      TOTAL_GPA_UNITS
,      GRADE_POINT_AVERAGE
,      _LA:TRANSCRIPT_TYPE
,      _LA:TRANSCRIPT_STATUS
,      DATE_OF_ISSUE
,      DATE_OF_RECEIPT
,      TERM_DETAILS_ID
,      TRANSCRIPT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_ACAD_TRANSCRIPT_TERMS;

Dependencies

[top of page]

APPS.IGSFV_ACAD_TRANSCRIPT_TERMS references the following:

APPS: IGS_AD_TERM_DETAILS; IGS_AD_TRANSCRIPT

APPS.IGSFV_ACAD_TRANSCRIPT_TERMS is not referenced by any database object