[Home] [Help]
[Dependency Information]
[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;
APPS
HZ_PARTIES
IGS_CA_GEN_001
- show dependent code
IGS_EN_GEN_014
- show dependent code
IGS_EN_SU_ATTEMPT
APPS
IGS_AD_GEN_002
- show dependent code
IGS_AS_PRC_TRANSCRPT
- show dependent code
|
|
|
|