[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_SUAH_LOAD_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AS_SUAH_LOAD_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Used to create effective student unit attempt history records in recognition of back dating enrollment and discontinuation dates.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | Person identifier | |
COURSE_CD | VARCHAR2 | (6) | Program code | |
UNIT_CD | VARCHAR2 | (10) | Unit code | |
VERSION_NUMBER | NUMBER | Unit version number | ||
CAL_TYPE | VARCHAR2 | (10) | Calendar type | |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Calendar instance sequence number | |
EFFECTIVE_START_DT | DATE | Calendar instance effective start date | ||
EFFECTIVE_END_DT | DATE | Calendar instance effective end date | ||
UNIT_ATTEMPT_STATUS | VARCHAR2 | (10) | 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) | Standard Who column | |
CREATION_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | 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 | ||
DEG_AUD_DETAIL_ID | NUMBER | Degree Audit Details | ||
UOO_ID | NUMBER | (7) | Unit Section identifier |
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
, EFFECTIVE_START_DT
, EFFECTIVE_END_DT
, 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
, DEG_AUD_DETAIL_ID
, UOO_ID
FROM APPS.IGS_AS_SUAH_LOAD_V;
APPS.IGS_AS_SUAH_LOAD_V is not referenced by any database object
|
|
|