[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_SUAH_EFFECTIVE_H_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AS_SUAH_EFFECTIVE_H_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is used to create effective student unit attempt history
records in recognition of backdating enrolment and discontinuation
dates.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | Person identifier | |
COURSE_CD | VARCHAR2 | (6) | Course 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 | |
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 | |
EFFECTIVE_START_DT | DATE | Effective start date | ||
EFFECTIVE_END_DT | DATE | Effective end date | ||
LOCATION_CD | VARCHAR2 | (10) | Location code | |
UNIT_CLASS | VARCHAR2 | (10) | Unit class | |
ENROLLED_DT | DATE | Enrolled date | ||
UNIT_ATTEMPT_STATUS | VARCHAR2 | (10) | Unit attempt status | |
ADMINISTRATIVE_UNIT_STATUS | VARCHAR2 | (10) | Administrative unit status | |
DISCONTINUED_DT | DATE | Discontinuation date | ||
RULE_WAIVED_DT | DATE | Rule waived date | ||
RULE_WAIVED_PERSON_ID | NUMBER | Person who waived the rule | ||
NO_ASSESSMENT_IND | VARCHAR2 | (1) | Indicator that says if assessment in done or not | |
EXAM_LOCATION_CD | VARCHAR2 | (10) | Examination location code | |
SUP_UNIT_CD | VARCHAR2 | (10) | Superior unit code of the unit version being attempted | |
SUP_VERSION_NUMBER | NUMBER | Superior unit version of the unit version being attempted | ||
ALTERNATIVE_TITLE | VARCHAR2 | (90) | Alternative title | |
OVERRIDE_ENROLLED_CP | NUMBER | Override enrolled credit points | ||
OVERRIDE_EFTSU | NUMBER | Override EFTSU figure | ||
OVERRIDE_ACHIEVABLE_CP | NUMBER | Override achievable credit points | ||
OVERRIDE_OUTCOME_DUE_DT | DATE | Override outcome due date | ||
OVERRIDE_CREDIT_REASON | VARCHAR2 | (4000) | Override credit reason | |
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
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, EFFECTIVE_START_DT
, EFFECTIVE_END_DT
, LOCATION_CD
, UNIT_CLASS
, ENROLLED_DT
, UNIT_ATTEMPT_STATUS
, ADMINISTRATIVE_UNIT_STATUS
, DISCONTINUED_DT
, RULE_WAIVED_DT
, RULE_WAIVED_PERSON_ID
, NO_ASSESSMENT_IND
, EXAM_LOCATION_CD
, SUP_UNIT_CD
, SUP_VERSION_NUMBER
, ALTERNATIVE_TITLE
, OVERRIDE_ENROLLED_CP
, OVERRIDE_EFTSU
, OVERRIDE_ACHIEVABLE_CP
, OVERRIDE_OUTCOME_DUE_DT
, OVERRIDE_CREDIT_REASON
, UOO_ID
FROM APPS.IGS_AS_SUAH_EFFECTIVE_H_V;
|
|
|