[Home] [Help] [Dependency Information]
Object Name: | IGS_PR_ACAD_PROGRAM_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_PR_ACAD_PROGRAM_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view contains the details Student Program Attempts, containing statistics information including GPA and Credit Point figures.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person Identifier |
PERSON_ID | NUMBER | (15) | Yes | Person Identifier |
FULL_NAME | VARCHAR2 | (450) | Person full name | |
PROGRAM_CD | VARCHAR2 | (6) | Yes | Program code |
PROGRAM_VERSION_NUMBER | NUMBER | (3) | Yes | Program version number |
PROGRAM_TITLE | VARCHAR2 | (90) | Yes | Program title |
PROGRAM_TYPE | VARCHAR2 | (10) | Yes | Program type |
PROGRAM_TYPE_DESCRIPTION | VARCHAR2 | (60) | Yes | Description for program |
RESPONSIBLE_ORG_UNIT_CD | VARCHAR2 | (30) | Yes | Responsible organization Unit code |
RESPONSIBLE_ORG_UNIT_DESC | VARCHAR2 | (360) | Yes | Responsible organization Unit code description |
PRIMARY_PROGRAM_TYPE | VARCHAR2 | (10) | Primary Program Type | |
START_DT | DATE | Start date | ||
PROGRAM_ATTEMPT_STATUS | VARCHAR2 | (30) | Program attempt status | |
DISCONTINUED_DT | DATE | Discontinued Date | ||
DISCONTINUATION_REASON_CD | VARCHAR2 | (10) | Reason for discontinuation | |
DISCONTINUATION_DESCRIPTION | VARCHAR2 | (60) | Description for discontinuation reason | |
COURSE_RQRMNTS_COMPLETE_DT | DATE | Course completion date | ||
CUMULATIVE_ATTEMPTED_CREDIT | NUMBER | Cumulative attempted credit points | ||
CUMULATIVE_EARNED_CREDIT | NUMBER | Cumulative earned credit points | ||
CUMULATIVE_GRADE_POINTS | NUMBER | Cumulative grade points | ||
CUMULATIVE_GPA | NUMBER | Cumulative Grade point average | ||
AWARD_CD | VARCHAR2 | (10) | Award code | |
AWARD_TITLE | VARCHAR2 | (90) | Award Title | |
CONFERRAL_DT | DATE | Conferral Date | ||
HONOURS_LEVEL | VARCHAR2 | (3) | No longer in use | |
HONOURS_LEVEL_DESCRIPTION | VARCHAR2 | (60) | No longer in use |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_NUMBER
, PERSON_ID
, FULL_NAME
, PROGRAM_CD
, PROGRAM_VERSION_NUMBER
, PROGRAM_TITLE
, PROGRAM_TYPE
, PROGRAM_TYPE_DESCRIPTION
, RESPONSIBLE_ORG_UNIT_CD
, RESPONSIBLE_ORG_UNIT_DESC
, PRIMARY_PROGRAM_TYPE
, START_DT
, PROGRAM_ATTEMPT_STATUS
, DISCONTINUED_DT
, DISCONTINUATION_REASON_CD
, DISCONTINUATION_DESCRIPTION
, COURSE_RQRMNTS_COMPLETE_DT
, CUMULATIVE_ATTEMPTED_CREDIT
, CUMULATIVE_EARNED_CREDIT
, CUMULATIVE_GRADE_POINTS
, CUMULATIVE_GPA
, AWARD_CD
, AWARD_TITLE
, CONFERRAL_DT
, HONOURS_LEVEL
, HONOURS_LEVEL_DESCRIPTION
FROM APPS.IGS_PR_ACAD_PROGRAM_V;
APPS.IGS_PR_ACAD_PROGRAM_V is not referenced by any database object
|
|
|