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_BLK_SUA_INTS

Object Details

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

Contains the Student Unit Attempt information to be imported into the IGS_EN_SI_ATTEMPT_ALL table for current unit attempts. Rows in this table must correspond to a batch in IGS_EN_BAT_SUA_INTS.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Student 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_BLK_SUA_INTS_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	UPLOAD_ID
IGS_EN_BLK_SUA_INTS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID
IGS_EN_BLK_SUA_INTS_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PERSON_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
UPLOAD_ID	NUMBER		Yes	A value to uniquely identify each record in the interface table. To be generated from a sequence
BATCH_ID	NUMBER		Yes	Batch id to run for a group of unit attempt uploads
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person number associated with student
PROGRAM_CD	VARCHAR2	(6)	Yes	Program code for student's program attempt
PROGRAM_VER_NUM	NUMBER	(3)	Yes	Program version
UNIT_CD	VARCHAR2	(10)	Yes	Unit code
UNIT_VER_NUM	NUMBER	(3)	Yes	Unit version
LOCATION_CD	VARCHAR2	(10)	Yes	Location code
UNIT_CLASS	VARCHAR2	(10)	Yes	Unit class/section
ALTERNATE_CD	VARCHAR2	(10)	Yes	Alternate code for calendar instance. Valid values are alternate codes for active teaching calendar instances
STATUS_FLAG	VARCHAR2	(1)	Yes	Valid values are"S" - attempt successful"E" - error"U" - unprocessed"R" - ready for processing
AUDIT_FLAG	VARCHAR2	(1)		Audit indicator
GRADING_SCH_CD	VARCHAR2	(10)		Grading schema code
GRADING_SCH_VER_NUM	NUMBER	(3)		Grading schema version
VARIABLE_CR_POINT	NUMBER	(6)		Variable credit points
UNIT_SEC_SUB_TITLE	VARCHAR2	(90)		Unit section sub title
ERROR_TXT	VARCHAR2	(2000)		Error text from registration update process
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 who column for concurrent program
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard who column for concurrent program
PROGRAM_ID	NUMBER	(15)		Standard who column for concurrent program
PROGRAM_UPDATE_DATE	DATE			Standard who column for concurrent program
CORE_INDICATOR_CODE	VARCHAR2	(30)		The core indicator indicates whether a student unit attempt is Core, Optional, Elective or null.
UPDATE_CORE_FLAG	VARCHAR2	(1)		Valid values are Y=Yes or NULL

Query Text

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


SELECT UPLOAD_ID
,      BATCH_ID
,      PERSON_NUMBER
,      PROGRAM_CD
,      PROGRAM_VER_NUM
,      UNIT_CD
,      UNIT_VER_NUM
,      LOCATION_CD
,      UNIT_CLASS
,      ALTERNATE_CD
,      STATUS_FLAG
,      AUDIT_FLAG
,      GRADING_SCH_CD
,      GRADING_SCH_VER_NUM
,      VARIABLE_CR_POINT
,      UNIT_SEC_SUB_TITLE
,      ERROR_TXT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CORE_INDICATOR_CODE
,      UPDATE_CORE_FLAG
FROM IGS.IGS_EN_BLK_SUA_INTS;

Dependencies

[top of page]

IGS.IGS_EN_BLK_SUA_INTS does not reference any database object

IGS.IGS_EN_BLK_SUA_INTS is referenced by following:

APPS: IGS_EN_BLK_SUA_INTS