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_AS_MSHT_SU_ATMPT

Object Details

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

IGS_AS_MSHT_SU_ATMPT describes student unit attempt contained on mark sheet and order in which student unit attempt appeared on hard-copy sheet.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_MSHT_SU_ATMPT_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD UOO_ID SHEET_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
SHEET_NUMBER	NUMBER	(6)	Yes	Describes the sheet number on which the student was printed
PERSON_ID	NUMBER	(15)	Yes	A unique student information system identification number, typically incorporating a check digit, used to identify a particular person.
COURSE_CD	VARCHAR2	(6)	Yes	The code that identifies the course in which the student is enrolled.
UNIT_CD	VARCHAR2	(10)	Yes	Describes the students enrolled unit code
CAL_TYPE	VARCHAR2	(10)	Yes	Describes the students enrolled teaching calendar type
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the students enrolled calendar sequence number
LOCATION_CD	VARCHAR2	(10)	Yes	Location code
UNIT_MODE	VARCHAR2	(10)	Yes	Unit mode
UNIT_CLASS	VARCHAR2	(10)	Yes	Unit class
STUDENT_SEQUENCE	NUMBER	(6)	Yes	Describes the student's place in the sequence of the original mark sheet. This is determined at the time of producing the mark sheet or adding new students to the end of the sheet.
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
UOO_ID	NUMBER	(7)	Yes	Unit Section identifier

Query Text

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


SELECT SHEET_NUMBER
,      PERSON_ID
,      COURSE_CD
,      UNIT_CD
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      LOCATION_CD
,      UNIT_MODE
,      UNIT_CLASS
,      STUDENT_SEQUENCE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      UOO_ID
FROM IGS.IGS_AS_MSHT_SU_ATMPT;

Dependencies

[top of page]

IGS.IGS_AS_MSHT_SU_ATMPT does not reference any database object

IGS.IGS_AS_MSHT_SU_ATMPT is referenced by following:

APPS: IGS_AS_MSHT_SU_ATMPT