[Home] [Help] [Dependency Information]
Object Name: | IGS_AV_STND_UNIT_CREDIT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AV_STND_UNIT_CREDIT_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
IGS_AV_STND_UNIT_CREDIT_V describes the amount of credit granted by different institutions for advanced standing units and unit levels. And it also indicates version number of the course against which the advanced standing is approved or granted.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | Describes the ID that uniquely identifies a person | |
COURSE_CD | VARCHAR2 | (6) | Describes the program against the advanced standing that is approved or granted | |
VERSION_NUMBER | NUMBER | (3) | Describes the version number of the program against the advanced standing that is approved or granted | |
S_ADV_STND_TYPE | VARCHAR2 | (10) | Describes the type of advanced standing, for example, credit, preclusion. | |
EXEMPTION_INSTITUTION_CD | VARCHAR2 | (30) | Describes the institution, if the qualification forming the basis for the exemption was obtained. This maps onto DETYA element 368, exempt-inst | |
CREDIT | NUMBER | Describes the amount of credit given to the student in this program attempt | ||
CREATED_BY | NUMBER | Standard Who column | ||
CREATION_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
DEG_AUD_DETAIL_ID | NUMBER | Degree Audit Detail Id |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, COURSE_CD
, VERSION_NUMBER
, S_ADV_STND_TYPE
, EXEMPTION_INSTITUTION_CD
, CREDIT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DEG_AUD_DETAIL_ID
FROM APPS.IGS_AV_STND_UNIT_CREDIT_V;
|
|
|