[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_SUA_LOAD_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AS_SUA_LOAD_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Descibes the load on a student's attempt at studying a particular unit offered by the university.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | Yes | Person identifier |
COURSE_CD | VARCHAR2 | (6) | Yes | Course code |
UNIT_CD | VARCHAR2 | (10) | Yes | Unit code |
VERSION_NUMBER | NUMBER | (3) | Yes | Unit version number |
CAL_TYPE | VARCHAR2 | (10) | Yes | Calendar type |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Calendar instance sequence number |
UNIT_ATTEMPT_STATUS | VARCHAR2 | (30) | Yes | Unit attempt status |
FEE_ASS_IND | VARCHAR2 | (1) | Fee assessment indicator | |
ADMINISTRATIVE_UNIT_STATUS | VARCHAR2 | (10) | Administrative unit status | |
ENROLLED_DT | DATE | Enrolled date | ||
DISCONTINUED_DT | DATE | Discontinuation date | ||
LOAD_CAL_TYPE | VARCHAR2 | (10) | Yes | Load calendar type |
LOAD_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Load calendar instance sequence number |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
LOAD_INCURRED_IND | VARCHAR2 | (1) | Load incurred indicator | |
EFTSU | NUMBER | EFTSU | ||
CREDIT_POINTS | NUMBER | Credit points | ||
UOO_ID | NUMBER | (7) | Yes | Unit offering option ID of the enrolled unit |
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
, UNIT_CD
, VERSION_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, UNIT_ATTEMPT_STATUS
, FEE_ASS_IND
, ADMINISTRATIVE_UNIT_STATUS
, ENROLLED_DT
, DISCONTINUED_DT
, LOAD_CAL_TYPE
, LOAD_CI_SEQUENCE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LOAD_INCURRED_IND
, EFTSU
, CREDIT_POINTS
, UOO_ID
, DEG_AUD_DETAIL_ID
FROM APPS.IGS_AS_SUA_LOAD_V;
APPS.IGS_AS_SUA_LOAD_V is not referenced by any database object
|
|
|