[Home] [Help] [Dependency Information]
Object Name: | IGS_PR_STU_ACAD_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_PR_STU_ACAD_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | Yes | Person Id to identify the student |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person Number of the student |
COURSE_CD | VARCHAR2 | (6) | Yes | Program Code of the program attempt of the student |
COURSE_TYPE | VARCHAR2 | (10) | Yes | Program type of the program attempt of the student |
ACAD_CAL_TYPE | VARCHAR2 | (10) | Yes | Academic Calendar Type |
ACAD_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Instance of the Academic Calendar |
ACAD_ALTERNATE_CODE | VARCHAR2 | (10) | Alternate Code of the Academic Calendar | |
ACAD_DESCRIPTION | VARCHAR2 | (30) | Description of the Academic Calendar | |
LOAD_CAL_TYPE | VARCHAR2 | (10) | Yes | Load Calendar Type |
LOAD_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Instance of the Load Calendar |
LOAD_ALTERNATE_CODE | VARCHAR2 | (10) | Alternate Code of the Load Calendar | |
LOAD_DESCRIPTION | VARCHAR2 | (30) | Description of the Load Calendar | |
LOAD_START_DT | DATE | Yes | Start Date of the Load Calendar | |
LOAD_END_DT | DATE | Yes | End Date of the Load Calendar | |
STAT_TYPE | VARCHAR2 | (50) | Yes | Statistic Type |
STAT_TYPE_DESC | VARCHAR2 | (90) | Yes | Description of the Statistic Type |
TERM_GPA | NUMBER | GPA for the given term | ||
TERM_GPA_CP | NUMBER | GPA Credit Point for the given term | ||
TERM_GPA_QP | NUMBER | GPA Quality Point for the given term | ||
TERM_EARNED_CP | NUMBER | Earned Credit Point for the given term | ||
TERM_ATTEMPTED_CP | NUMBER | Attempted Point for the given term | ||
CUM_GPA | NUMBER | Cumulative GPA | ||
CUM_GPA_CP | NUMBER | Cumulative GPA Credit Point | ||
CUM_GPA_QP | NUMBER | Cumulative GPA Quality Point | ||
CUM_EARNED_CP | NUMBER | Cumulative Earned Credit Point | ||
CUM_ATTEMPTED_CP | NUMBER | Cumulative Attempted Credit Point | ||
CLASS_STANDING | VARCHAR2 | (4000) | Class Standing | |
PREDICTIVE_CLASS_STANDING | VARCHAR2 | (4000) | Predictive Class Standing | |
ATTENDANCE_TYPE | VARCHAR2 | (4000) | Attendance Type | |
ENRL_ANTCP_COMPL_DT | DATE | Estimated Completion Date |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, PERSON_NUMBER
, COURSE_CD
, COURSE_TYPE
, ACAD_CAL_TYPE
, ACAD_SEQUENCE_NUMBER
, ACAD_ALTERNATE_CODE
, ACAD_DESCRIPTION
, LOAD_CAL_TYPE
, LOAD_SEQUENCE_NUMBER
, LOAD_ALTERNATE_CODE
, LOAD_DESCRIPTION
, LOAD_START_DT
, LOAD_END_DT
, STAT_TYPE
, STAT_TYPE_DESC
, TERM_GPA
, TERM_GPA_CP
, TERM_GPA_QP
, TERM_EARNED_CP
, TERM_ATTEMPTED_CP
, CUM_GPA
, CUM_GPA_CP
, CUM_GPA_QP
, CUM_EARNED_CP
, CUM_ATTEMPTED_CP
, CLASS_STANDING
, PREDICTIVE_CLASS_STANDING
, ATTENDANCE_TYPE
, ENRL_ANTCP_COMPL_DT
FROM APPS.IGS_PR_STU_ACAD_V;
APPS.IGS_PR_STU_ACAD_V is not referenced by any database object
|
|
|