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

VIEW: APPS.IGS_PR_ACAD_YEAR_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view contains the details of a Student Program Attempt within a Year of Program with earned credit point values.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_NUMBER VARCHAR2 (30) Yes Unique identification number for this party
PERSON_ID NUMBER (15) Yes Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
COURSE_CD VARCHAR2 (6) Yes A code used to identify the course in which the student is enrolled.See also Element 307 Higher Education Student Data Collection Documentation 1997, DETYA.
UNIT_SET_CD VARCHAR2 (10) Yes Unit set code
UNIT_SET_CD_VERSION NUMBER (3) Yes Version Number of the Unit Set Code.
GRAD_SCH_GRADE VARCHAR2 (10)
Grading schema grade
MARK NUMBER (6)
Marks
EARNED_CP NUMBER

Earned credit points
Query Text

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


SELECT PERSON_NUMBER
,      PERSON_ID
,      COURSE_CD
,      UNIT_SET_CD
,      UNIT_SET_CD_VERSION
,      GRAD_SCH_GRADE
,      MARK
,      EARNED_CP
FROM APPS.IGS_PR_ACAD_YEAR_V;

Dependencies

[top of page]

APPS.IGS_PR_ACAD_YEAR_V references the following:

SchemaAPPS
PL/SQL PackageFND_DATE - show dependent code
SynonymHZ_PARTIES
SynonymIGS_AS_SU_SETATMPT
PL/SQL PackageIGS_EN_GEN_015 - show dependent code
ViewIGS_EN_STDNT_PS_ATT
ViewIGS_EN_SU_ATTEMPT
ViewIGS_EN_UNIT_SET
SynonymIGS_EN_UNIT_SET_CAT
SynonymIGS_HE_EN_SUSA
PL/SQL PackageIGS_PR_ACAD_DETAILS - show dependent code

APPS.IGS_PR_ACAD_YEAR_V is not referenced by any database object