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_H_ALL

Object Details

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

IGS_EN_SU_ATTEMPT_H_ALL describes the history of changes made to a student unit attempt, including changes to status, location, class, and others.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_SU_ATTEMPT_H_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD UOO_ID HIST_START_DT

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	Describes the program code. DEET element reference 307.
UNIT_CD	VARCHAR2	(10)	Yes	Code used to identify the unit
VERSION_NUMBER	NUMBER	(3)		Version number is used to uniquely identify each version of a unit
CAL_TYPE	VARCHAR2	(10)	Yes	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
HIST_START_DT	DATE		Yes	Effective start date and time of the history record
HIST_END_DT	DATE		Yes	Effective end date and time of the history record
HIST_WHO	NUMBER	(15)	Yes	Oracle username of the person who created the history record
LOCATION_CD	VARCHAR2	(10)		Location name or code. The location represents a geographical location and is used to indicate if units are offered.
UNIT_CLASS	VARCHAR2	(10)		Describes the code that uniquely identifies the unit class
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.
UNIT_ATTEMPT_STATUS	VARCHAR2	(10)		Describes the unit attempt status for the duration of the student unit attempt history.
ADMINISTRATIVE_UNIT_STATUS	VARCHAR2	(10)		Describes the administrative unit status for the duration of the student unit attempt history.
AUS_DESCRIPTION	VARCHAR2	(60)		Describes the administrative unit status
DISCONTINUED_DT	DATE			Describes the date discontinuation date for the duration of the student unit attempt history.
DCNT_REASON_CD	VARCHAR2	(10)		Code that describes the reason for discontinuation from the program by the student.
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)		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.
EXAM_LOCATION_CD	VARCHAR2	(10)		Describes the code that identifies if the examination was held for the student unit attempt.
ELO_DESCRIPTION	VARCHAR2	(60)		Description of the exam location
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.
ALTERNATIVE_TITLE	VARCHAR2	(90)		Describes the alternative title for the duration of the student unit attempt history.
OVERRIDE_ENROLLED_CP	NUMBER	(6)		Describes the override enrolled credit points for the duration of the student unit attempt history.
OVERRIDE_EFTSU	NUMBER	(7)		Describes the override EFTSU for the duration of the student unit attempt history.
OVERRIDE_ACHIEVABLE_CP	NUMBER	(6)		Describes the override achievable credit points for the duration of the student unit attempt history.
OVERRIDE_OUTCOME_DUE_DT	DATE			*** Future functionality.
OVERRIDE_CREDIT_REASON	VARCHAR2	(2000)		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
ORG_ID	NUMBER	(15)		Operating unit identifier
GRADING_SCHEMA_CODE	VARCHAR2	(10)		Holds the previous details of the Grading Schema Code
ENR_METHOD_TYPE	VARCHAR2	(10)		Enrollment Method Type
ADMINISTRATIVE_PRIORITY	NUMBER			Priority given to the waitlist by the administration
WAITLIST_DT	DATE			Date on that the student is entered into the waitlist
REQUEST_ID	NUMBER			Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER			Application identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER			Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program
CART	VARCHAR2	(240)		Indicates whether the unit attempt is added to the cart or not.
ORG_UNIT_CD	VARCHAR2	(240)		Captures the Organization unit code for the student unit attempt.
RSV_SEAT_EXT_ID	NUMBER			Indicates the Reserve Seating Priority and Preference used for Enrollment
GS_VERSION_NUMBER	NUMBER			Holds the Version Number of the Grading Schema
FAILED_UNIT_RULE	VARCHAR2	(240)		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
UOO_ID	NUMBER	(7)	Yes	The unique identifier for a unit offering option.
CORE_INDICATOR_CODE	VARCHAR2	(30)		The core indicator indicates whether a student unit attempt is Core, Optional, Elective or null.

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
,      HIST_START_DT
,      HIST_END_DT
,      HIST_WHO
,      LOCATION_CD
,      UNIT_CLASS
,      ENROLLED_DT
,      UNIT_ATTEMPT_STATUS
,      ADMINISTRATIVE_UNIT_STATUS
,      AUS_DESCRIPTION
,      DISCONTINUED_DT
,      DCNT_REASON_CD
,      RULE_WAIVED_DT
,      RULE_WAIVED_PERSON_ID
,      NO_ASSESSMENT_IND
,      EXAM_LOCATION_CD
,      ELO_DESCRIPTION
,      SUP_UNIT_CD
,      SUP_VERSION_NUMBER
,      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
,      ORG_ID
,      GRADING_SCHEMA_CODE
,      ENR_METHOD_TYPE
,      ADMINISTRATIVE_PRIORITY
,      WAITLIST_DT
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CART
,      ORG_UNIT_CD
,      RSV_SEAT_EXT_ID
,      GS_VERSION_NUMBER
,      FAILED_UNIT_RULE
,      DEG_AUD_DETAIL_ID
,      UOO_ID
,      CORE_INDICATOR_CODE
FROM IGS.IGS_EN_SU_ATTEMPT_H_ALL;

Dependencies

[top of page]

IGS.IGS_EN_SU_ATTEMPT_H_ALL does not reference any database object

IGS.IGS_EN_SU_ATTEMPT_H_ALL is referenced by following:

APPS: IGS_EN_SU_ATTEMPT_H_ALL