[Home] [Help] [Dependency Information]
Object Name: | IGS_EN_SU_ATTEMPT_SV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_EN_SU_ATTEMPT_SV |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view contains the secured rows in the student unit attempt table.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
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 applies to 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. | |
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. | ||
ADMINISTRATIVE_PRIORITY | NUMBER | The priority given by the administration to a waitlist. | ||
WAITLIST_DT | DATE | The date on which a student is put onto a waitlist. | ||
WAITLIST_MANUAL_IND | VARCHAR2 | (1) | Indicates whether waitlist position is changed manually. Allowable Values Y-Manually changed, N-System changed | |
DCNT_REASON_CD | VARCHAR2 | (10) | The code which describes the reason for discontinuation of a program by the student. | |
ORG_ID | NUMBER | (15) | Operating Unit Identifier. | |
PERSON_ID | NUMBER | (15) | Yes | Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value. |
COURSE_CD | VARCHAR2 | (6) | Yes | A code used to identify the course in which the student is enrolled |
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 calendar within 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 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 |
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 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 status |
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 seekinga formal grade for the student unit attempt. Setting the checkbox ticked signifies that the student is simply auditing the unit andwill 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. | |
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 appliesto the student unit attempt. This value will override that contained in the unit entity. | |
GRADING_SCHEMA_CODE | VARCHAR2 | (10) | Grading Schema Code | |
GS_VERSION_NUMBER | NUMBER | (3) | Grading schema version number | |
ENR_METHOD_TYPE | VARCHAR2 | (10) | Enrollment method type used to enroll in the subject | |
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 Organization unit code for the student unit attempt. | |
SESSION_ID | NUMBER | Session Identifier | ||
SUBTITLE | VARCHAR2 | (90) | Sub title | |
DEG_AUD_DETAIL_ID | NUMBER | Degree Audit Detail ID | ||
STUDENT_CAREER_TRANSCRIPT | VARCHAR2 | (1) | Indicates whether to include the Unit attempt as part of Career transcript. | |
STUDENT_CAREER_STATISTICS | VARCHAR2 | (1) | Indicates whether to include the Unit attempt as part of Career Statistics. | |
CORE_INDICATOR_CODE | VARCHAR2 | (30) | The core indicator indicates whether a student unit attempt is Core, Optional, Elective or null. | |
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. | ||
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
, 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
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ADMINISTRATIVE_PRIORITY
, WAITLIST_DT
, WAITLIST_MANUAL_IND
, DCNT_REASON_CD
, ORG_ID
, PERSON_ID
, COURSE_CD
, 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
, GRADING_SCHEMA_CODE
, GS_VERSION_NUMBER
, ENR_METHOD_TYPE
, FAILED_UNIT_RULE
, CART
, RSV_SEAT_EXT_ID
, ORG_UNIT_CD
, SESSION_ID
, SUBTITLE
, DEG_AUD_DETAIL_ID
, STUDENT_CAREER_TRANSCRIPT
, STUDENT_CAREER_STATISTICS
, CORE_INDICATOR_CODE
, 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
, UPD_AUDIT_FLAG
, SS_SOURCE_IND
FROM APPS.IGS_EN_SU_ATTEMPT_SV;
|
|
|