[Home] [Help] [Dependency Information]
Object Name: | IGS_EN_SUA_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_EN_SUA_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 |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
PERSON_ID | NUMBER | (15) | Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value. | |
PERSON_NUMBER | VARCHAR2 | (30) | Person Identifier. | |
COURSE_CD | VARCHAR2 | (6) | 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) | The code of a unit in which the student is enrolled. A list of values is available. See also Element 354 of the Higher Education Student Data Collection Documentation 1997, DETYA. | |
VERSION_NUMBER | NUMBER | (3) | The version number of the unit in which the student is enrolled. The version number defaults to the current version upon entry of the unit code. | |
CAL_TYPE | VARCHAR2 | (10) | Units are offered in teaching calendars. For example SEM - 1 semester 1 , SEM - 2 semester 2 and YR-LONG a year long teaching period). | |
CI_SEQUENCE_NUMBER | NUMBER | (6) | The system generated sequence number of the calendar instance ??? Which clanedar instance? | |
ACAD_ALTERNATE_CODE | VARCHAR2 | (4000) | The alternative title of the Academic Calendar in which the student is enrolled | |
TEACH_ALTERNATE_CODE | VARCHAR2 | (4000) | The alternate code of the teaching period in which the unit attempt is enrolled. | |
LOCATION_CD | VARCHAR2 | (10) | The location, typically a campus, from where the student's unit is offered. A list of values is available. | |
UNIT_CLASS | VARCHAR2 | (10) | The code of the class associated with the unit in which the student is enrolled. A list of values is available. | |
CI_START_DT | DATE | The start date of which calendar instnance ??? Teaching period? | ||
CI_END_DT | DATE | The end date of which calendar instnance ??? Teaching calendar? | ||
UOO_ID | NUMBER | (7) | The unique identifier for a unit offering option. | |
ENROLLED_DT | DATE | The date on which the student enrolled in the unit. | ||
UNIT_ATTEMPT_STATUS | VARCHAR2 | (30) | Unit attempt status is a system derived value and will be one of the following- UNCONFIRMed, ENROLLED, DISCONTINued, COMPLETED, or INVALID. | |
ADMINISTRATIVE_UNIT_STATUS | VARCHAR2 | (10) | The administrative unit status AUS attached to a discontinued unit. Examples of AUS may include WE - withdrawn early, WL - withdrawn Late, WF, Withdrawn Fail. When a unit is discontinued an AUS is defaulted based on pre-determined discontinuation date critieria. The default AUS can be over-ridden. AUS are instiution defined. | |
DISCONTINUED_DT | DATE | The date on which the student discontinued enrolment in the unit. | ||
RULE_WAIVED_DT | DATE | The date on which a unit enrolment rule pre-requisite, co-requisite so on was waived thereby permitting enrolment in the context unit. | ||
RULE_WAIVED_PERSON_ID | NUMBER | (15) | The identification number of a staff member authorised to waive unit enrolment rules pre-requisite, co-requsite so on Use the Find Person Form to search for the person's ID. | |
RULE_WAIVED_PERSON_NUMBER | VARCHAR2 | (30) | ||
NO_ASSESSMENT_IND | VARCHAR2 | (1) | An indicator which specifies whether or not the student is to be assessed in the unit and receive a formal grade. Setting the indicator ticked means that the student is not to be assessed. | |
SUP_UNIT_CD | VARCHAR2 | (10) | The code of a superior unit in which the student is enrolled. A list of values is available. The superior unit must be linked to one or more sub-unit enrolments. See also Element 354 of the Higher Education Student Data Collection Documentation 1997, DETYA. | |
SUP_VERSION_NUMBER | NUMBER | (3) | The version number of the suoerior unit in which the student is enrolled. The version number defaults to the current version upon entry of the unit code. | |
EXAM_LOCATION_CD | VARCHAR2 | (10) | The code of an examination centre nominated by the student as their examination location for this particular unit. This codes over-rides any different examination location nominated for thestudent's course attempt as a whole. A list of values is avaialbe. | |
ALTERNATIVE_TITLE | VARCHAR2 | (90) | The alternative title of the Academic Calendar in which the student is enrolled. ??? Check ??? | |
OVERRIDE_ENROLLED_CP | NUMBER | (6) | Functionality not in Phase 1 | |
OVERRIDE_EFTSU | NUMBER | (7) | Functionality not in Phase 1 | |
OVERRIDE_ACHIEVABLE_CP | NUMBER | (6) | Functionality not in Phase 1 | |
OVERRIDE_OUTCOME_DUE_DT | DATE | Functionality not in Phase 1 | ||
OVERRIDE_CREDIT_REASON | VARCHAR2 | (2000) | Functionality not in Phase 1 | |
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 | |
ADMINISTRATIVE_PRIORITY | NUMBER | The priority given by the administration to a given waitlist. | ||
WAITLIST_DT | DATE | The date on which the student was put on to a waitlist. | ||
WAITLIST_MANUAL_IND | VARCHAR2 | (1) | Indicator column, says whether the waitlist position is modified manually or by system | |
DCNT_REASON_CD | VARCHAR2 | (10) | The code which describes the reason for discontinuation of the program by the student. | |
GS_VERSION_NUMBER | NUMBER | (3) | Grading schema version number | |
ENR_METHOD_TYPE | VARCHAR2 | (10) | Enrollment method type | |
FAILED_UNIT_RULE | VARCHAR2 | (30) | Failed unit rule | |
CART | VARCHAR2 | (1) | Indicates whether the unit attempt is added to the cart or not. | |
RSV_SEAT_EXT_ID | NUMBER | (15) | Indicates the Reserve Seating Priority and Preference used for Enrollment | |
ORG_UNIT_CD | VARCHAR2 | (30) | Captures the oganization code for the student unit attempt | |
SESSION_ID | NUMBER | Contains the session identifier in which unit attempt is added | ||
GRADING_SCHEMA_CODE | VARCHAR2 | (10) | Grading schema code | |
DEG_AUD_DETAIL_ID | NUMBER | Degree Audit Detail Id | ||
STUDENT_CAREER_TRANSCRIPT | VARCHAR2 | (1) | ||
STUDENT_CAREER_STATISTICS | VARCHAR2 | (1) | ||
SUBTITLE | VARCHAR2 | (90) | This field stores the Subtitle of the Unit Code | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Standard Descriptive Flex field Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE16 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE17 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE18 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE19 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
ATTRIBUTE20 | VARCHAR2 | (150) | Standard Descriptive Flex field Column | |
WLST_PRIORITY_WEIGHT_NUM | NUMBER | Sum of waitlist priority weights the student satisfied, when moved into waitlist queue. | ||
WLST_PREFERENCE_WEIGHT_NUM | NUMBER | Sum of waitlist preference weights the student satisfied, when moved into waitlist queue. | ||
CORE_INDICATOR_CODE | VARCHAR2 | (30) | The core indicator indicates whether a student unit attempt is Core, Optional, Elective or null. | |
UPD_AUDIT_FLAG | VARCHAR2 | (1) | Indicates if this unit has been audited | |
SS_SOURCE_IND | VARCHAR2 | (1) | Indicates if swap page created this unit attempt |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PERSON_ID
, PERSON_NUMBER
, COURSE_CD
, UNIT_CD
, VERSION_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, ACAD_ALTERNATE_CODE
, TEACH_ALTERNATE_CODE
, LOCATION_CD
, UNIT_CLASS
, 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
, 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
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ADMINISTRATIVE_PRIORITY
, WAITLIST_DT
, WAITLIST_MANUAL_IND
, DCNT_REASON_CD
, GS_VERSION_NUMBER
, ENR_METHOD_TYPE
, FAILED_UNIT_RULE
, CART
, RSV_SEAT_EXT_ID
, ORG_UNIT_CD
, SESSION_ID
, GRADING_SCHEMA_CODE
, DEG_AUD_DETAIL_ID
, STUDENT_CAREER_TRANSCRIPT
, STUDENT_CAREER_STATISTICS
, SUBTITLE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, WLST_PRIORITY_WEIGHT_NUM
, WLST_PREFERENCE_WEIGHT_NUM
, CORE_INDICATOR_CODE
, UPD_AUDIT_FLAG
, SS_SOURCE_IND
FROM APPS.IGS_EN_SUA_V;
|
|
|