[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_SUA_H_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AS_SUA_H_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | A unique student information system identification number, typically incorporating a check digit, used to identify a particular person. | |
COURSE_CD | VARCHAR2 | (6) | This field describes the course code. DETYA element reference 307. | |
UNIT_CD | VARCHAR2 | (10) | The code used to identify the unit. | |
VERSION_NUMBER | NUMBER | Version number is used to uniquely identify each version of a unit. | ||
CAL_TYPE | VARCHAR2 | (10) | This field is the name of a type of teaching calendar within the university. Examples- SEM-1, YR-LONG. | |
CI_SEQUENCE_NUMBER | NUMBER | (6) | This field uniquely identifies the calendar instance. | |
HIST_START_DT | DATE | The effective start date and time of this history record. | ||
HIST_END_DT | DATE | The effective end date and time of this history record. | ||
HIST_WHO | NUMBER | (15) | The Oracle username of the person who created the history record. | |
LOCATION_CD | VARCHAR2 | (10) | This field is the location name or code. The location represents a geographical location and is used to indicate where units are offered. | |
UNIT_CLASS | VARCHAR2 | (10) | This field describes the code that uniquely identifies the unit class. | |
ENROLLED_DT | DATE | This field describes the date on which the enrolment in the unit took effect. If this date is not set, the student has not confirmed their enrolment in the unit attempt. | ||
UNIT_ATTEMPT_STATUS | VARCHAR2 | (30) | This field describes the system-defined unit attempt statuses. | |
ADMINISTRATIVE_UNIT_STATUS | VARCHAR2 | (10) | This field describes institution-defined administrative statuses. Examples- Withdrawn Early, Withdrawn Late. | |
DISCONTINUED_DT | DATE | This field describes the date on which the discontinuation of the unit attempt took effect. | ||
DCNT_REASON_CD | VARCHAR2 | (10) | ||
RULE_WAIVED_DT | DATE | This field describes the date on which a failed rule applying to the unit attempt was waived. | ||
RULE_WAIVED_PERSON_ID | NUMBER | This field describes the person who waived the unit rule applicable to the unit attempt. | ||
RULE_WAIVED_PERSON_NUMBER | VARCHAR2 | (30) | ||
NO_ASSESSMENT_IND | VARCHAR2 | (1) | An indicator which specifies whether or not the student is seeking a formal grade for the student unit attempt. Setting the checkbox -ticked- signifies that the student is simply auditing the unit and will not be formally assessed. | |
SUP_UNIT_CD | VARCHAR2 | (10) | This field describes the superior unit code of the unit version being attempted. | |
SUP_VERSION_NUMBER | NUMBER | This field describes the superior unit version number of the unit version being attempted. | ||
EXAM_LOCATION_CD | VARCHAR2 | (10) | This field describes the code that uniquely identifies an examination location. | |
ALTERNATIVE_TITLE | VARCHAR2 | (90) | This field describes the alternative title for the student unit attempt. This alternative title will override the title contained in the unit table. | |
OVERRIDE_ENROLLED_CP | NUMBER | This field describes the credit point value which applies to the student unit attempt. This value will override that contained in the unit entity. | ||
OVERRIDE_EFTSU | NUMBER | This field describes the EFTSU figure entered as an override for the particular student unit attempt. This figure will be used by the system as a 'base EFTSU' whenever calculating EFTSU. | ||
OVERRIDE_ACHIEVABLE_CP | NUMBER | This field describes the credit point value which applies to the student unit attempt. This value will override that contained in the unit entity. | ||
OVERRIDE_OUTCOME_DUE_DT | DATE | This field describes an override for the due date of the outcome. Normally dates in the teaching period calendar would govern when an outcome is due for a student unit attempt. In situations where a student may have been granted a deferred or supplementary assessment this date may be extended allowing extra time. Check within the assessments sub-system. | ||
OVERRIDE_CREDIT_REASON | VARCHAR2 | (4000) | This field describes the reason for overriding the credit point value. | |
ENR_METHOD_TYPE | VARCHAR2 | (10) | ||
GRADING_SCHEMA_CODE | VARCHAR2 | (10) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
DEG_AUD_DETAIL_ID | NUMBER | Degree Audit Detail Id | ||
UOO_ID | NUMBER | (7) | Unit Section identifier | |
CORE_INDICATOR_CODE | VARCHAR2 | (4000) | The core indicator indicates whether a student unit attempt is Core, Optional, Elective or null. |
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
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, LOCATION_CD
, UNIT_CLASS
, ENROLLED_DT
, UNIT_ATTEMPT_STATUS
, ADMINISTRATIVE_UNIT_STATUS
, DISCONTINUED_DT
, DCNT_REASON_CD
, RULE_WAIVED_DT
, RULE_WAIVED_PERSON_ID
, RULE_WAIVED_PERSON_NUMBER
, NO_ASSESSMENT_IND
, SUP_UNIT_CD
, SUP_VERSION_NUMBER
, EXAM_LOCATION_CD
, ALTERNATIVE_TITLE
, OVERRIDE_ENROLLED_CP
, OVERRIDE_EFTSU
, OVERRIDE_ACHIEVABLE_CP
, OVERRIDE_OUTCOME_DUE_DT
, OVERRIDE_CREDIT_REASON
, ENR_METHOD_TYPE
, GRADING_SCHEMA_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DEG_AUD_DETAIL_ID
, UOO_ID
, CORE_INDICATOR_CODE
FROM APPS.IGS_AS_SUA_H_V;
|
|
|