DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGS_DA_XML_COURSE_V

Object Details
Object Name: IGS_DA_XML_COURSE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_DA_XML_COURSE_V
Subobject Name:
Status: VALID

View Type

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


XML element CourseType (child of CourseInstitution)
1)(SUA) Student Unit Attempt"s at local Institution.
Includes Units local institution Units and currently enrolled units.
Enrolled units can be excluded EIP Control feature code.
2) (AV) Advanced Standing of the Units
3) (ED) Transcript Units


[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 (4000)
Contains the title of the course.
COURSE_SESSION VARCHAR2 (30)
Contains the term information in which the course was taken.
COURSE_CREDIT_VALUE NUMBER

Contains the credit that may be earned for the course.
COURSE_CREDIT_EARNED NUMBER

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

Contains the quality points earned for the course.
COURSE_ACADEMIC_GRADE VARCHAR2 (4000)
Contains the grade earned for the course.
COURSE_OUTCOME VARCHAR2 (4000)
Contains the outcome for the grade associated with the course.
COURSE_REPEAT_INDICATOR VARCHAR2 (4000)
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

Contains the OSS generated Batch ID for tracking purposes.
PERSON_ID NUMBER (15)
Describes the details of the person ID code that is being passed.
INSTITUTION_CD VARCHAR2 (30)
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.
LOCAL_INSTITUTION_CD VARCHAR2 (30)
Describes the academic history of the student.
AV_STND_UNIT_ID NUMBER

Identities the Advanced Standing Unit Details.
UNIT_CD VARCHAR2 (10)
Unit Code
SOURCE VARCHAR2 (3)
Major1,2,3 - minor 1,2,3 - track 1,2,3
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
,      LOCAL_INSTITUTION_CD
,      AV_STND_UNIT_ID
,      UNIT_CD
,      SOURCE
FROM APPS.IGS_DA_XML_COURSE_V;

Dependencies

[top of page]

APPS.IGS_DA_XML_COURSE_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymHZ_EDUCATION
SynonymHZ_PARTIES
SynonymIGS_AD_TERM_DETAILS
SynonymIGS_AD_TERM_UNITDTLS
SynonymIGS_AD_TRANSCRIPT
SynonymIGS_AS_GRD_SCH_GRADE
SynonymIGS_AV_STND_UNIT_ALL
SynonymIGS_CA_INST_ALL
ViewIGS_CA_TEACH_TO_LOAD_V
SynonymIGS_DA_CNFG_REQ_TYP
SynonymIGS_DA_REQ_FTRS
SynonymIGS_DA_RQST
PL/SQL PackageIGS_DA_XML_PKG - show dependent code
ViewIGS_EN_STDNT_PS_ATT
SynonymIGS_EN_SU_ATTEMPT_ALL
ViewIGS_OR_INSTITUTION_V
SynonymIGS_PE_HZ_PARTIES
SynonymIGS_PS_PRG_UNIT_REL
ViewIGS_PS_UNIT_VER
SynonymIGS_PS_UNIT_VER_ALL
SynonymIGS_PS_VER_ALL
PL/SQL PackageIGS_SS_ENR_DETAILS - show dependent code

APPS.IGS_DA_XML_COURSE_V is not referenced by any database object