eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGS.IGS_EN_SU_ATTEMPT_ALL

Object Details

Object Name:	IGS_EN_SU_ATTEMPT_ALL
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_EN_SU_ATTEMPT_ALL
Subobject Name:
Status:	VALID

Describes a student's attempt at studying a particular unit offered by the university. This table is modified to capture the Organizational unit code for the student finance requirements.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_SU_ATTEMPT_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD UOO_ID
IGS_EN_SU_ATTEMPT_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD UNIT_CD VERSION_NUMBER CAL_TYPE CI_SEQUENCE_NUMBER LOCATION_CD UNIT_CLASS
IGS_EN_SU_ATTEMPT_ALL_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CART SESSION_ID
IGS_EN_SU_ATTEMPT_ALL_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPD_AUDIT_FLAG
IGS_EN_SU_ATTEMPT_ALL_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SS_SOURCE_IND
IGS_EN_SU_ATTEMPT_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNIT_CD VERSION_NUMBER CAL_TYPE CI_SEQUENCE_NUMBER LOCATION_CD UNIT_CLASS
IGS_EN_SU_ATTEMPT_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADMINISTRATIVE_UNIT_STATUS
IGS_EN_SU_ATTEMPT_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UOO_ID
IGS_EN_SU_ATTEMPT_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CAL_TYPE CI_SEQUENCE_NUMBER CI_START_DT CI_END_DT
IGS_EN_SU_ATTEMPT_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RULE_WAIVED_PERSON_ID
IGS_EN_SU_ATTEMPT_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUP_UNIT_CD SUP_VERSION_NUMBER
IGS_EN_SU_ATTEMPT_ALL_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXAM_LOCATION_CD

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
COURSE_CD	VARCHAR2	(6)	Yes	Code used to identify the program in that the student is enrolled. See also, element 307 higher education student data collection documentation 1997, DETYA.
UNIT_CD	VARCHAR2	(10)	Yes	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	Field is the name of a type of teaching calendar within the university. For example, SEM-1, YR-LONG.
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Uniquely identifies the calendar instance.
LOCATION_CD	VARCHAR2	(10)	Yes	Location name or code. The location represents a geographical location and is used to indicate if units are offered.
UNIT_CLASS	VARCHAR2	(10)	Yes	Describes the code that uniquely identifies the unit class.
CI_START_DT	DATE		Yes	Describes the date from that an instance of a calendar is effective.
CI_END_DT	DATE		Yes	Date from that an instance of a calendar is no longer effective. For example, teaching period Semester 1, 1999 may end on 30/06/1999.
UOO_ID	NUMBER	(7)	Yes	Unique identifier for a unit offering option.
ENROLLED_DT	DATE			Describes the date on that the enrolment in the unit took effect. If this date is not set, the student has not confirmed their enrolment in the unit attempt.
ORG_ID	NUMBER	(15)		Operating unit identifier
UNIT_ATTEMPT_STATUS	VARCHAR2	(30)	Yes	Describes the system-defined unit attempt statuses
ADMINISTRATIVE_UNIT_STATUS	VARCHAR2	(10)		Describes institution-defined administrative statuses. For example, WD-EARLY Withdrawn Early , WD-LATE Withdrawn Late .
DISCONTINUED_DT	DATE			Describes the date on that the discontinuation of the unit attempt took effect.
RULE_WAIVED_DT	DATE			Describes the date on that a failed rule applying to the unit attempt was waived.
RULE_WAIVED_PERSON_ID	NUMBER	(15)		Describes the person who waived the unit rule applicable to the unit attempt.
NO_ASSESSMENT_IND	VARCHAR2	(1)	Yes	Indicator that 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)		Describes the superior unit code of the unit version being attempted.
SUP_VERSION_NUMBER	NUMBER	(3)		Describes the superior unit version number of the unit version being attempted.
EXAM_LOCATION_CD	VARCHAR2	(10)		Describes the code that uniquely identifies an examination location.
ALTERNATIVE_TITLE	VARCHAR2	(90)		Describes the alternative title for the student unit attempt. This alternative title will override the title contained in the unit table. For example, it would appear on the student's transcript .
OVERRIDE_ENROLLED_CP	NUMBER	(6)		Describes the enrolled credit point value that applies to the student unit attempt. This value will override that contained in the unit entity.
OVERRIDE_EFTSU	NUMBER	(7)		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)		Describes the achievable credit point value that applies to the student unit attempt. This value will override that contained in the unit entity.
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.
OVERRIDE_CREDIT_REASON	VARCHAR2	(2000)		Describes the reason for overriding the achievable or enrolled credit point values.
ADMINISTRATIVE_PRIORITY	NUMBER			Priority given to the waitlist by the administration
WAITLIST_DT	DATE			Date on that the student is entered into the waitlist
DCNT_REASON_CD	VARCHAR2	(10)		Code that describes the reason for discontinuation from the program by the student.
GRADING_SCHEMA_CODE	VARCHAR2	(10)		Code that describes the grading schema for the program
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)		Holds the Version Number of the Grading Schema
ENR_METHOD_TYPE	VARCHAR2	(10)		Holds the Enrollment Method Type.
FAILED_UNIT_RULE	VARCHAR2	(30)		Field which will store the reason for failed validation for the INVALID unit attempts of the student.
DEG_AUD_DETAIL_ID	NUMBER			Degree Audit Details id
CART	VARCHAR2	(1)		Indicates whether the unit attempt is added to the cart or not.
ORG_UNIT_CD	VARCHAR2	(30)		Captures the Organization unit code for the student unit attempt.
RSV_SEAT_EXT_ID	NUMBER	(15)		Indicates the Reserve Seating Priority and Preference used for Enrollment
SUBTITLE	VARCHAR2	(90)		Sub title
SESSION_ID	NUMBER			Session 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.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Standard DFF Column
ATTRIBUTE1	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE2	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE3	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE4	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE5	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE6	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE7	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE8	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE9	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE10	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE11	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE12	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE13	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE14	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE15	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE16	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE17	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE18	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE19	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE20	VARCHAR2	(150)		Standard DFF Column
WAITLIST_MANUAL_IND	VARCHAR2	(1)		Indicates whether waitlist position is changed manually. Allowable Values Y-Manually changed, N-System changed
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 that the student has updated the audit flag to yes and audit permission Is created for this update.
SS_SOURCE_IND	VARCHAR2	(1)	Yes	Indicates if the unit attempt was created thru the Swap or Admin or planning. Values could be S/A/P/N.N indicates that this unit attempt is a normal cart unit attempt

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
,      ORG_ID
,      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
,      DCNT_REASON_CD
,      GRADING_SCHEMA_CODE
,      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
,      DEG_AUD_DETAIL_ID
,      CART
,      ORG_UNIT_CD
,      RSV_SEAT_EXT_ID
,      SUBTITLE
,      SESSION_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
,      WAITLIST_MANUAL_IND
,      WLST_PRIORITY_WEIGHT_NUM
,      WLST_PREFERENCE_WEIGHT_NUM
,      CORE_INDICATOR_CODE
,      UPD_AUDIT_FLAG
,      SS_SOURCE_IND
FROM IGS.IGS_EN_SU_ATTEMPT_ALL;

Dependencies

[top of page]

IGS.IGS_EN_SU_ATTEMPT_ALL does not reference any database object

IGS.IGS_EN_SU_ATTEMPT_ALL is referenced by following:

APPS: IGS_EN_SU_ATTEMPT_ALL