[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_AS_SUA_INQ_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_AS_SUA_INQ_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) | Yes | This field describes the ID code that uniquely identifies a person. |
| COURSE_CD | VARCHAR2 | (6) | Yes | A code used to identify the course in which the student is enrolled. -See also Element 307 Higher Education Student Data Collection Documentation 1997, DETYA.- |
| UNIT_CD | VARCHAR2 | (10) | Yes | The code used to identify the unit. |
| VERSION_NUMBER | NUMBER | (3) | Yes | The version number of the unit. Students are normally enrolled in the current version. Prior versions are end-dated. |
| UNIT_VERSION | VARCHAR2 | (51) | The unique identifier of the unit. | |
| UNIT_TITLE | VARCHAR2 | (90) | The short name of the unit. | |
| ALT_ACAD_PERD | VARCHAR2 | (21) | Alternate codes of the academic period and teaching period. | |
| CAL_TYPE | VARCHAR2 | (10) | Yes | This field is the name of a type of teaching calendar within the university. Examples- SEM-1, YR-LONG. |
| CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | This field uniquely identifies the calendar instance. |
| ACAD_ALTERNATE_CODE | VARCHAR2 | (10) | student_unit_attempt.acad_alternate_code | |
| TEACH_ALTERNATE_CODE | VARCHAR2 | (10) | student_unit_attempt.teach_alternate_cd | |
| LOCATION_CD | VARCHAR2 | (10) | Yes | 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) | Yes | This field describes the code that uniquely identifies the unit class. |
| UNIT_MODE | VARCHAR2 | (10) | Yes | student_unit_attempt.unit_mode |
| CI_START_DT | DATE | Yes | This field describes the date from which an instance of a calendar is effective. | |
| CI_END_DT | DATE | Yes | This field is the date from which an instance of a calendar is no longer effective eg. teaching period Semester 1, 1999 may end on 30/06/1999. | |
| UOO_ID | NUMBER | (7) | Yes | The unique identifier for a unit offering option. |
| 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) | Yes | This field describes the system-defined unit attempt statices. |
| ADMINISTRATIVE_UNIT_STATUS | VARCHAR2 | (10) | This field describes institution-defined administrative statuses. Examples- WD-EARLY -Withdrawn Early-, WD-LATE -Withdrawn Late-. | |
| DISCONTINUED_DT | DATE | This field describes the date on which the discontinuation of the unit attempt took effect. | ||
| 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 | (15) | This field describes the person who waived the unit rule applicable to the unit attempt. | |
| NO_ASSESSMENT_IND | VARCHAR2 | (1) | Yes | 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 | (3) | 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. | |
| ENROLLED_CP | NUMBER | This field describes the enrolled credit point value which applies to the student unit attempt. | ||
| EFTSU | NUMBER | The Equivalent Full Time Student Unit -EFTSU- value for a student unit attempt. | ||
| ACHIEVABLE_CP | NUMBER | This field describes the achieved credit point value which applies to the student unit attempt. | ||
| OVERRIDE_OUTCOME_DUE_DT | DATE | *** Future functionality. 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. | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| OVERRIDE_CREDIT_REASON | VARCHAR2 | (2000) | This field describes the reason for overriding the achievable or enrolled credit point values. | |
| 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
, UNIT_VERSION
, UNIT_TITLE
, ALT_ACAD_PERD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, ACAD_ALTERNATE_CODE
, TEACH_ALTERNATE_CODE
, LOCATION_CD
, UNIT_CLASS
, UNIT_MODE
, CI_START_DT
, CI_END_DT
, UOO_ID
, ENROLLED_DT
, UNIT_ATTEMPT_STATUS
, ADMINISTRATIVE_UNIT_STATUS
, DISCONTINUED_DT
, RULE_WAIVED_DT
, RULE_WAIVED_PERSON_ID
, NO_ASSESSMENT_IND
, SUP_UNIT_CD
, SUP_VERSION_NUMBER
, EXAM_LOCATION_CD
, ENROLLED_CP
, EFTSU
, ACHIEVABLE_CP
, OVERRIDE_OUTCOME_DUE_DT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OVERRIDE_CREDIT_REASON
, DEG_AUD_DETAIL_ID
FROM APPS.IGS_AS_SUA_INQ_V;
APPS
IGS_AS_UNIT_CLASS
IGS_CA_GEN_001
- show dependent code
IGS_EN_GEN_014
- show dependent code
IGS_EN_STDNT_PS_ATT
IGS_EN_SU_ATTEMPT
IGS_IN_GEN_001
- show dependent code
IGS_PS_UNIT_OFR_OPT
IGS_PS_UNIT_VER_ALL
IGS_PS_USEC_CPS
APPS.IGS_AS_SUA_INQ_V is not referenced by any database object
|
|
|
|