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_LGCY_SUA_INT

Object Details

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

Contains the Student Unit Attempt (and optionally outcome) information to be imported into the IGS_EN_SU_ATTEMPT_ALL (and optionally IGS_AS_SU_STMPTOUT_ALL) table by the legacy data import process. Rows in this table must correspond to a batch in the IGS_EN_LGCY_BAT_INT table.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Legacy Unit Attempt
Category: BUSINESS_ENTITY IGS_STUDENT_UNIT

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_LGCY_SUA_INT_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	LEGACY_EN_SUA_INT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(15)	Yes	Batch Identifier, used to identify the set of records to be processed.
LEGACY_EN_SUA_INT_ID	NUMBER	(15)	Yes	Unique interface identifier for the student unit attempt
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person for which the enrollment is being done
PROGRAM_CD	VARCHAR2	(6)	Yes	Program code in which the enrollment is done
UNIT_CD	VARCHAR2	(10)	Yes	Unit code in which enrollment is done
VERSION_NUMBER	NUMBER	(3)		Version of the enrolled unit. Will be derived if not specified.
TEACH_CALENDAR_ALTERNATE_CODE	VARCHAR2	(10)	Yes	Alternate code of the teaching calendar in which enrollment exists.
LOCATION_CD	VARCHAR2	(10)	Yes	Location of the unit
UNIT_CLASS	VARCHAR2	(10)	Yes	Class for the unit.
ENROLLED_DT	DATE			Enrollment date.
WAITLISTED_DT	DATE			Date on which waitlisted.
DROPPED_IND	VARCHAR2	(1)		Indicator to signify whether the unit has been dropped
DISCONTINUED_DT	DATE			Date on which discontinuation has happened
ADMINISTRATIVE_UNIT_STATUS	VARCHAR2	(10)		Administrative unit status for discontinuation and drop
DCNT_REASON_CD	VARCHAR2	(10)		Reason code for discontinuation and drop
NO_ASSESSMENT_IND	VARCHAR2	(1)		Indicator to tell whether an assessment can happen
OVERRIDE_ENROLLED_CP	NUMBER	(6)		The overridden value of Enrolled Credit Points
OVERRIDE_ACHIEVABLE_CP	NUMBER	(6)		The overridden value of Achievable Credit Points
GRADING_SCHEMA_CODE	VARCHAR2	(10)		The Override Grading Schema Code for the Unit or Unit section.
GS_VERSION_NUMBER	NUMBER	(2)		The Override Grading Schema Version Number for the Unit or Unit section.
SUBTITLE	VARCHAR2	(90)		The subtitle of the unit attempt.
STUDENT_CAREER_TRANSCRIPT	VARCHAR2	(1)		Indicator to show if the unit should show on the transcript within the enrolled Career.
STUDENT_CAREER_STATISTICS	VARCHAR2	(1)		Indicator to show if the unit attempt should count towards Statistics of the enrolled Career.
TRANSFER_DT	DATE			The Date of Student Unit Attempt Transfer.
TRANSFER_PROGRAM_CD	VARCHAR2	(6)		The Source program from which the Unit section is transferred.
OUTCOME_DT	DATE			The date on which the outcome was finalized.
MARK	NUMBER	(6)		Marks secured by the student.
OUTCOME_GRADING_SCHEMA_CODE	VARCHAR2	(10)		The Grading Schema Code of the Student Unit Attempt Outcome.
OUTCOME_GS_VERSION_NUMBER	NUMBER	(3)		The Grading Schema Version Number of the Student Unit Attempt Outcome.
GRADE	VARCHAR2	(5)		The Grade of the Student Unit Attempt Outcome.
INCOMP_DEADLINE_DATE	DATE			The Incomplete Deadline Date.
INCOMP_DEFAULT_GRADE	VARCHAR2	(5)		The default Incomplete Grade.
INCOMP_DEFAULT_MARK	NUMBER	(6)		The default Incomplete Mark.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flex field structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE2	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE3	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE4	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE5	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE6	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE7	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE8	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE9	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE10	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE11	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE12	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE13	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE14	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE15	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE16	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE17	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE18	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE19	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE20	VARCHAR2	(150)		Attribute for descriptive flexfield
IMPORT_STATUS	VARCHAR2	(1)		Record's Import status
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
REQUEST_ID	NUMBER	(15)		Standard concurrent program who column
PROGRAM_ID	NUMBER	(15)		Standard concurrent program who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard concurrent program who column
PROGRAM_UPDATE_DATE	DATE			Standard concurrent program who column
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 BATCH_ID
,      LEGACY_EN_SUA_INT_ID
,      PERSON_NUMBER
,      PROGRAM_CD
,      UNIT_CD
,      VERSION_NUMBER
,      TEACH_CALENDAR_ALTERNATE_CODE
,      LOCATION_CD
,      UNIT_CLASS
,      ENROLLED_DT
,      WAITLISTED_DT
,      DROPPED_IND
,      DISCONTINUED_DT
,      ADMINISTRATIVE_UNIT_STATUS
,      DCNT_REASON_CD
,      NO_ASSESSMENT_IND
,      OVERRIDE_ENROLLED_CP
,      OVERRIDE_ACHIEVABLE_CP
,      GRADING_SCHEMA_CODE
,      GS_VERSION_NUMBER
,      SUBTITLE
,      STUDENT_CAREER_TRANSCRIPT
,      STUDENT_CAREER_STATISTICS
,      TRANSFER_DT
,      TRANSFER_PROGRAM_CD
,      OUTCOME_DT
,      MARK
,      OUTCOME_GRADING_SCHEMA_CODE
,      OUTCOME_GS_VERSION_NUMBER
,      GRADE
,      INCOMP_DEADLINE_DATE
,      INCOMP_DEFAULT_GRADE
,      INCOMP_DEFAULT_MARK
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      IMPORT_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      CORE_INDICATOR_CODE
FROM IGS.IGS_EN_LGCY_SUA_INT;

Dependencies

[top of page]

IGS.IGS_EN_LGCY_SUA_INT does not reference any database object

IGS.IGS_EN_LGCY_SUA_INT is referenced by following:

APPS: IGS_EN_LGCY_SUA_INT