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_PERSON_ACAD_TRANSCRIPTS

Object Details

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

View Type

A Business Intelligence System view

Contains Person transcript details

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
_LA:TRANSCRIPT_TYPE	CHAR	(65)		This indicates if the Transcript is Official or Unofficial
_LA:TRANSCRIPT_STATUS	CHAR	(69)		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
ENTERED_GPA	VARCHAR2	(30)		Grade point average for the institution
CONVERTED_GPA	VARCHAR2	(30)		Grade point average for the institution as per the institutions GPA scale type
_LA:TERM_TYPE	VARCHAR2	(10)		Tells the type of attendance mode Q - Quarter, S - Semester, T - Trimester
CORE_CURRICULUM_VALUE	CHAR	(53)		This value indicates the level a student has attained in high school toward the 'core curriculum'
RANK_IN_CLASS	NUMBER	(5)		Rank in class
CLASS_SIZE	NUMBER	(5)		Class size
APPROXIMATE_RANK_INDICATOR	VARCHAR2	(1)		Indicator to show Approximate Rank(Y or N)
WEIGHTED_RANK_INDICATOR	VARCHAR2	(1)		Indicator to show Weighted Rank(Y or N)
DECILE_RANK	NUMBER			Docile rank
QUARTILE_RANK	NUMBER			Quartile rank
QUINTILE_RANK	NUMBER			Quartile rank
PERCENTILE_RANK	NUMBER			Percentile rank
OVERRIDE_INDICATOR	VARCHAR2	(1)		Override Indicator column to indicate manual override of formula values for Percentile, Docile, Quartile and Quintile.
OVERRIDE_DATE	DATE			Date on which override has been done.
PERSON_NUMBER	VARCHAR2	(30)	Yes	The identification number of the student who is studying.
INSTITUTION_NAME	VARCHAR2	(360)	Yes	Institution Name in which the student is studying.
ENTERED_GRADE_SCALE_TYPE	VARCHAR2	(10)	Yes	Grade point average scale type for the entered GPA
ENTERED_GRADE_SCALE_TYPE_DESC	VARCHAR2	(30)	Yes	Description of grade point average scale type for the entered GPA
TRANSCRIPT_SOURCE	VARCHAR2	(10)	Yes	Transcript source
TRANSCRIPT_SOURCE_DESC	VARCHAR2	(30)	Yes	Description of transcript source
OVERRIDE_PERSON_NUMBER	VARCHAR2	(30)		The identification number of the person who has done the override. The person should be a staff/admin member.
CONVERTED_GRADE_SCALE_TYP	VARCHAR2	(10)	Yes	Grade point average for the institution as per the institutions GPA scale type
CONVERTED_GRADE_SCALE_TYP_DESC	VARCHAR2	(30)	Yes	Description of grade point average for the institution as per the institutions GPA scale type
TRANSCRIPT_ID	NUMBER	(15)	Yes	Unique identifier for the transcript details
EDUCATION_ID	NUMBER	(15)	Yes	Academic history identifier
ENTERED_GS_ID	NUMBER	(15)	Yes	Grade point average scale type for the entered GPA
TRANSCRIPT_SOURCE_ID	NUMBER	(15)	Yes	Transcript source
OVERRIDE_ID	NUMBER	(15)		Identification Number of the person who has done the override. The person should be a staff/admin member.
CONV_GS_ID	NUMBER	(15)	Yes	Grade point average for the institution as per the institutions GPA scale type
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 _LA:TRANSCRIPT_TYPE
,      _LA:TRANSCRIPT_STATUS
,      DATE_OF_ISSUE
,      DATE_OF_RECEIPT
,      ENTERED_GPA
,      CONVERTED_GPA
,      _LA:TERM_TYPE
,      CORE_CURRICULUM_VALUE
,      RANK_IN_CLASS
,      CLASS_SIZE
,      APPROXIMATE_RANK_INDICATOR
,      WEIGHTED_RANK_INDICATOR
,      DECILE_RANK
,      QUARTILE_RANK
,      QUINTILE_RANK
,      PERCENTILE_RANK
,      OVERRIDE_INDICATOR
,      OVERRIDE_DATE
,      PERSON_NUMBER
,      INSTITUTION_NAME
,      ENTERED_GRADE_SCALE_TYPE
,      ENTERED_GRADE_SCALE_TYPE_DESC
,      TRANSCRIPT_SOURCE
,      TRANSCRIPT_SOURCE_DESC
,      OVERRIDE_PERSON_NUMBER
,      CONVERTED_GRADE_SCALE_TYP
,      CONVERTED_GRADE_SCALE_TYP_DESC
,      TRANSCRIPT_ID
,      EDUCATION_ID
,      ENTERED_GS_ID
,      TRANSCRIPT_SOURCE_ID
,      OVERRIDE_ID
,      CONV_GS_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_PERSON_ACAD_TRANSCRIPTS;

Dependencies

[top of page]

APPS.IGSFV_PERSON_ACAD_TRANSCRIPTS references the following:

APPS: HZ_EDUCATION; HZ_PARTIES; IGS_AD_CODE_CLASSES; IGS_AD_TRANSCRIPT

APPS.IGSFV_PERSON_ACAD_TRANSCRIPTS is not referenced by any database object