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.IGS_DA_XML_ORIGINALCOURSE_V

Object Details

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

XML element OriginalCourseType (child of CourseType). Gets the original Unit/(course) information for Units Transferred from other institutions.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
COURSE_SUBJECT_ABBREVIATION	VARCHAR2	(4000)		Contains the subject code for the course.
COURSE_NUMBER	VARCHAR2	(4000)		Contains the number level for the course.
COURSE_TITLE	VARCHAR2	(80)	Yes	Contains the title of the course.
COURSE_SESSION	VARCHAR2	(30)	Yes	Contains the term information in which the course was taken.
COURSE_CREDIT_VALUE	NUMBER	(7)		Contains the credit that may be earned for the course.
COURSE_CREDIT_EARNED	NUMBER	(7)		Contains the earned credit hours for the course.
COURSE_GPA_CREDIT_HOURS	NUMBER			Contains the credit hours used for GPA calculations.
COURSE_QUALITY_POINTS_EARNED	NUMBER	(7)		Contains the quality points earned for the course.
COURSE_ACADEMIC_GRADE	VARCHAR2	(10)		Contains the grade earned for the course.
COURSE_OUTCOME	CHAR	(0)		Contains the outcome for the grade associated with the course.
COURSE_REPEAT_INDICATOR	CHAR	(1)		Contains an indicator that signifies that the course was repeated.
COURSE_PSUEDO_CODE	CHAR	(0)		Contains an indicator determining whether or not the course is a dummy or real course.
COURSE_ATTRIBUTE_CODE	CHAR	(0)		Contains condition codes used to further define course.
COURSE_FLAG_CODE	CHAR	(0)		Contains three-character code used to match degree program requirements in the degree audit processing
BATCH_ID	NUMBER		Yes	Contains the OSS generated Batch ID for tracking purposes.
PERSON_ID	NUMBER	(15)	Yes	Describes the details of the person ID code that is being passed.
INSTITUTION_CD	VARCHAR2	(30)	Yes	Describes an institution from which the transfer evaluation will be limited. The Institution is composed of the EntityID type. See this type for institution details.
AV_STND_UNIT_ID	NUMBER	(15)	Yes	Identities the Advanced Standing Unit Details.

Query Text

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


SELECT COURSE_SUBJECT_ABBREVIATION
,      COURSE_NUMBER
,      COURSE_TITLE
,      COURSE_SESSION
,      COURSE_CREDIT_VALUE
,      COURSE_CREDIT_EARNED
,      COURSE_GPA_CREDIT_HOURS
,      COURSE_QUALITY_POINTS_EARNED
,      COURSE_ACADEMIC_GRADE
,      COURSE_OUTCOME
,      COURSE_REPEAT_INDICATOR
,      COURSE_PSUEDO_CODE
,      COURSE_ATTRIBUTE_CODE
,      COURSE_FLAG_CODE
,      BATCH_ID
,      PERSON_ID
,      INSTITUTION_CD
,      AV_STND_UNIT_ID
FROM APPS.IGS_DA_XML_ORIGINALCOURSE_V;

Dependencies

[top of page]

APPS.IGS_DA_XML_ORIGINALCOURSE_V references the following:

APPS: IGS_AD_TERM_DETAILS; IGS_AD_TERM_UNITDTLS; IGS_AV_STND_UNIT_ALL; IGS_DA_RQST; IGS_DA_XML_PKG - show dependent code

APPS.IGS_DA_XML_ORIGINALCOURSE_V is not referenced by any database object