[Home] [Help] [Dependency Information]
Object Name: | IGS_PR_ACAD_UNIT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_PR_ACAD_UNIT_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view contains Student Unit Attempt details with statistics and grades.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person Identifier |
PERSON_ID | NUMBER | (15) | Yes | Person Identifier |
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. |
COURSE_TYPE | VARCHAR2 | (10) | Yes | Program Type |
UNIT_CD | VARCHAR2 | (10) | Yes | Unit Code |
VERSION_NUMBER | NUMBER | (3) | Yes | Unit version number |
TEACH_CAL_TYPE | VARCHAR2 | (10) | Yes | Teaching calendar type |
TEACH_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Teaching calendar identifier |
TEACH_DESCRIPTION | VARCHAR2 | (30) | Teaching calendar description | |
TEACH_ALTERNATE_CODE | VARCHAR2 | (10) | Teaching calendar alternate code | |
UNIT_ATTEMPT_STATUS | VARCHAR2 | (30) | Yes | Unit Attempt Status |
TITLE | VARCHAR2 | (4000) | Title | |
LOCATION_CD | VARCHAR2 | (10) | Yes | Location code |
UNIT_CLASS | VARCHAR2 | (10) | Yes | Location Class |
UOO_ID | NUMBER | (7) | Yes | The unique identifier of the unit offering option. |
CALL_NUMBER | NUMBER | This is the unique identifier needed to support interactive voice registration. | ||
LOAD_CAL_TYPE | VARCHAR2 | (10) | Yes | Load calendar |
LOAD_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Load calendar unique identifier |
LOAD_DESCRIPTION | VARCHAR2 | (30) | Load calendar description | |
LOAD_ALTERNATE_CODE | VARCHAR2 | (10) | Alternate code for load calendar | |
YEAR_OF_PROGRAM | VARCHAR2 | (4000) | Program year | |
MARK | NUMBER | Marks | ||
GRADE | VARCHAR2 | (4000) | Grade | |
GPA | NUMBER | Grade point average | ||
GPA_CP | NUMBER | Grade point average credit points | ||
GPA_QP | NUMBER | Grade point average | ||
EARNED_CP | NUMBER | Earned credit points | ||
ATTEMPTED_CP | NUMBER | Attempted credit points | ||
STATISTICS_FLAG | VARCHAR2 | (1) | Statistic flag | |
TRANSFERRED_FLAG | VARCHAR2 | (1) | Transferred flag |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_NUMBER
, PERSON_ID
, COURSE_CD
, COURSE_TYPE
, UNIT_CD
, VERSION_NUMBER
, TEACH_CAL_TYPE
, TEACH_CI_SEQUENCE_NUMBER
, TEACH_DESCRIPTION
, TEACH_ALTERNATE_CODE
, UNIT_ATTEMPT_STATUS
, TITLE
, LOCATION_CD
, UNIT_CLASS
, UOO_ID
, CALL_NUMBER
, LOAD_CAL_TYPE
, LOAD_CI_SEQUENCE_NUMBER
, LOAD_DESCRIPTION
, LOAD_ALTERNATE_CODE
, YEAR_OF_PROGRAM
, MARK
, GRADE
, GPA
, GPA_CP
, GPA_QP
, EARNED_CP
, ATTEMPTED_CP
, STATISTICS_FLAG
, TRANSFERRED_FLAG
FROM APPS.IGS_PR_ACAD_UNIT_V;
APPS.IGS_PR_ACAD_UNIT_V is not referenced by any database object
|
|
|