[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_EN_SUA_WLST_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_EN_SUA_WLST_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) | Yes | Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value. |
| TITLE_NAME | VARCHAR2 | (450) | The title of a person . for example - Mr,Ms and so on. | |
| 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 CollectionDocumentation 1997, DETYA. |
| PROGRAM_TITLE | VARCHAR2 | (90) | Yes | Title of the program attempted by student |
| UNIT_CD | VARCHAR2 | (10) | Yes | The code used to identify the unit. |
| VERSION_NUMBER | NUMBER | (3) | Yes | Version number is used to uniquely identify each version of a unit. |
| CAL_TYPE | VARCHAR2 | (10) | Yes | This field is the name of a type of teaching calendarwithin the university. Examples- SEM-1, YR-LONG. |
| CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | This field uniquely identifies the calendar instance. |
| 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 unitclass. |
| 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 nolonger effective example- teaching period Semester 1, 1999 may end on30/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 statuses.. |
| 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 he 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 anexamination location. | |
| ALTERNATIVE_TITLE | VARCHAR2 | (90) | This field describes the alternative title for the student unit attempt. This alternative title will override the title contained inthe unit table example- it would appear on the student's transcript. | |
| OVERRIDE_ENROLLED_CP | NUMBER | (6) | This field describes the enrolled credit point value which applies to the student unit attempt. This value will override that contained in the unit entity. | |
| OVERRIDE_EFTSU | NUMBER | (7) | 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 | (6) | This field describes the achievable credit point value which appliesto the student unit attempt. This value will override that contained in the unit entity. | |
| OVERRIDE_OUTCOME_DUE_DT | DATE | *** Future functionality. | ||
| OVERRIDE_CREDIT_REASON | VARCHAR2 | (2000) | This field describes the reason for overriding the achievable or enrolled credit point values. | |
| ADMINISTRATIVE_PRIORITY | NUMBER | The priority of the waitlist given by the administration on which the student was put. | ||
| WAITLIST_DT | DATE | The date on which the student was put in 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) | Discontinution reason code | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| REQUEST_ID | NUMBER | (15) | Request identifier of last concurrent program to update this record. | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Application identifier of last concurrent program to update this record. | |
| PROGRAM_ID | NUMBER | (15) | Program identifier of last concurrent program to update this record. | |
| PROGRAM_UPDATE_DATE | DATE | Last update date of this record by a concurrent program. | ||
| 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 | |
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | |
| CART | VARCHAR2 | (1) | ||
| RSV_SEAT_EXT_ID | NUMBER | (15) | ||
| ORG_UNIT_CD | VARCHAR2 | (30) | Captures the organization code for the sudent 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) | Condition used to check if the Student Career Transcript should be part of the strudent's final Transcript. | |
| STUDENT_CAREER_STATISTICS | VARCHAR2 | (1) | Condition used to check if the Student Career Statistics should be part of the strudent's final Transcript. | |
| 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. | |
| SUBTITLE | VARCHAR2 | (90) | Subtitle of the unit attempt | |
| 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) | Yes | Indicates if this unit has been audited |
| SS_SOURCE_IND | VARCHAR2 | (1) | Yes | Indicates if swap page created this unit attempt |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PERSON_ID
, TITLE_NAME
, COURSE_CD
, PROGRAM_TITLE
, UNIT_CD
, VERSION_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, 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
, 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
, ADMINISTRATIVE_PRIORITY
, WAITLIST_DT
, WAITLIST_MANUAL_IND
, DCNT_REASON_CD
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, GS_VERSION_NUMBER
, ENR_METHOD_TYPE
, FAILED_UNIT_RULE
, PERSON_NUMBER
, CART
, RSV_SEAT_EXT_ID
, ORG_UNIT_CD
, SESSION_ID
, GRADING_SCHEMA_CODE
, DEG_AUD_DETAIL_ID
, STUDENT_CAREER_TRANSCRIPT
, STUDENT_CAREER_STATISTICS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, SUBTITLE
, WLST_PRIORITY_WEIGHT_NUM
, WLST_PREFERENCE_WEIGHT_NUM
, CORE_INDICATOR_CODE
, UPD_AUDIT_FLAG
, SS_SOURCE_IND
FROM APPS.IGS_EN_SUA_WLST_V;
APPS
IGS_EN_STDNT_PS_ATT
IGS_EN_SU_ATTEMPT_SV
IGS_PE_PERSON_BASE_V
IGS_PS_VER
APPS.IGS_EN_SUA_WLST_V is not referenced by any database object
|
|
|
|