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_LGY_SUSA_INT

Object Details

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

Contains the Student Unit Set (or Year of Program) information to be imported into the IGS_AS_SU_SETATMPT 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 Set
Category: BUSINESS_ENTITY IGS_STUDENT_PROGRAM

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_LGY_SUSA_INT_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	LEGACY_EN_SUSA_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_SUSA_INT_ID	NUMBER	(15)	Yes	Unique identifier of the EN Student unit set attempt record.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person number of the student
PROGRAM_CD	VARCHAR2	(6)	Yes	The program in which the unit set is being attempted.
UNIT_SET_CD	VARCHAR2	(10)	Yes	The unit set code which is being attempted. Unit sets comprise lists of units or rules which constitute a logical set of units. It will be used to represent concepts such as majors, minors, strands, streams, years of program and lists.
US_VERSION_NUMBER	NUMBER	(3)	Yes	The version number of the unit set that is being attempted.
SELECTION_DT	DATE			The date the student selected the unit set. There may be multiple attempts of a unit set by a student over time.
STUDENT_CONFIRMED_IND	VARCHAR2	(1)		Indicates if or not the student has confirmed their attempt at the unit set.
END_DT	DATE			The date on which the student unit set attempt was ended.
PARENT_UNIT_SET_CD	VARCHAR2	(10)		The parent unit set code. If required it indicates that the unit set in context is a subordinate to another unit set. The parent unit set must be included as part of the student unit set attempt. Must be an uppercase value.
PRIMARY_SET_IND	VARCHAR2	(1)		If the primary set indicator is set it indicates that the unit set is the primary set. Primary unit sets display on official notification. Administrative unit sets cannot be primary sets.
VOLUNTARY_END_IND	VARCHAR2	(1)		Indicates if the ending of the unit set attempt was voluntary. If not, the student was removed due to a progression breach or other administrative reason.
AUTHORISED_PERSON_NUMBER	VARCHAR2	(30)		The person number of the staff member who authorized the unit set. Must be STAFF member.
AUTHORISED_ON	DATE			The date on which the unit set was authorized.
OVERRIDE_TITLE	VARCHAR2	(90)		The override title of the unit set, replacing the standard title.
RQRMNTS_COMPLETE_IND	VARCHAR2	(1)		Indicates if the student has completed the requirements of the unit set. This can be set by either the system or manually, as indicated by the source type.
RQRMNTS_COMPLETE_DT	DATE			The date on which the unit set requirements was completed.
S_COMPLETED_SOURCE_TYPE	VARCHAR2	(10)		The source of the completion flag. It can be either system applied or manually applied. Valid values of SYSTEM and MANUAL.
CATALOG_CAL_ALTERNATE_CODE	VARCHAR2	(10)		The catalogue calendar of the unit set attempt. Must be valid LOAD or ACADEMIC calendar instance.
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

Query Text

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


SELECT BATCH_ID
,      LEGACY_EN_SUSA_INT_ID
,      PERSON_NUMBER
,      PROGRAM_CD
,      UNIT_SET_CD
,      US_VERSION_NUMBER
,      SELECTION_DT
,      STUDENT_CONFIRMED_IND
,      END_DT
,      PARENT_UNIT_SET_CD
,      PRIMARY_SET_IND
,      VOLUNTARY_END_IND
,      AUTHORISED_PERSON_NUMBER
,      AUTHORISED_ON
,      OVERRIDE_TITLE
,      RQRMNTS_COMPLETE_IND
,      RQRMNTS_COMPLETE_DT
,      S_COMPLETED_SOURCE_TYPE
,      CATALOG_CAL_ALTERNATE_CODE
,      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
FROM IGS.IGS_EN_LGY_SUSA_INT;

Dependencies

[top of page]

IGS.IGS_EN_LGY_SUSA_INT does not reference any database object

IGS.IGS_EN_LGY_SUSA_INT is referenced by following:

APPS: IGS_EN_LGY_SUSA_INT