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]

VIEW: APPS.IGS_AS_UAI_ETISTD_EXAM_V

Object Details

Object Name:	IGS_AS_UAI_ETISTD_EXAM_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_AS_UAI_ETISTD_EXAM_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

IGS_AS_UAI_ETISTD_EXAM is created to supply the ETI (Student Exam Timetabling
Interface) system with information that it requires to determine which
student unit attempt assessment items to timetable.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EXAM_CAL_TYPE	VARCHAR2	(10)	Yes	Examination calendar type
EXAM_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Examination calendar instance sequence number
TEACH_CAL_TYPE	VARCHAR2	(10)	Yes	Teaching calendar type
TEACH_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Teaching calendar instance sequence number
ASS_ID	NUMBER	(10)	Yes	Assessment identifier
UNIT_CD	VARCHAR2	(10)	Yes	Unit code
REFERENCE	VARCHAR2	(30)		Reference for unit assessment item
PERSON_ID	NUMBER	(15)	Yes	Person identifier
OWNER_ORG_UNIT_CD	VARCHAR2	(30)	Yes	Owning organization code
RESPONSIBLE_ORG_UNIT_CD	VARCHAR2	(30)	Yes	Responsible organization unit code
SURNAME	VARCHAR2	(150)		Person surname
GIVEN_NAMES	VARCHAR2	(150)		Person given names
SPECIAL_NEEDS_IND	VARCHAR2	(1)		Special needs indicator
EXAM_LOCATION_CD	VARCHAR2	(20)		Examination location code
EXAMINATION_TYPE	VARCHAR2	(10)		Examination type
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
DEG_AUD_DETAIL_ID	NUMBER			Degree Audit Detail Id

Query Text

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


SELECT EXAM_CAL_TYPE
,      EXAM_CI_SEQUENCE_NUMBER
,      TEACH_CAL_TYPE
,      TEACH_CI_SEQUENCE_NUMBER
,      ASS_ID
,      UNIT_CD
,      REFERENCE
,      PERSON_ID
,      OWNER_ORG_UNIT_CD
,      RESPONSIBLE_ORG_UNIT_CD
,      SURNAME
,      GIVEN_NAMES
,      SPECIAL_NEEDS_IND
,      EXAM_LOCATION_CD
,      EXAMINATION_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DEG_AUD_DETAIL_ID
FROM APPS.IGS_AS_UAI_ETISTD_EXAM_V;

Dependencies

[top of page]

APPS.IGS_AS_UAI_ETISTD_EXAM_V references the following:

APPS: IGS_AS_ASSESSMNT_ITM; IGS_AS_GEN_002 - show dependent code; IGS_AS_GEN_003 - show dependent code; IGS_AS_SU_ATMPT_ITM; IGS_AS_UAI_EXAM_CI_INIT_V; IGS_AS_UNIT_CLASS; IGS_AS_VAL_UAI - show dependent code; IGS_CA_INST; IGS_CA_STAT; IGS_EN_GEN_003 - show dependent code; IGS_EN_GEN_007 - show dependent code; IGS_EN_GEN_014 - show dependent code; IGS_EN_STDNT_PS_ATT; IGS_EN_SU_ATTEMPT; IGS_PE_PERSON; IGS_PS_UNIT_STAT; IGS_PS_UNIT_VER; IGS_PS_VER

APPS.IGS_AS_UAI_ETISTD_EXAM_V is not referenced by any database object