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_PROGUGAI_ADI_V

Object Details

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

View Type

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

Assessment Progression/UnitGrade/AssessmentItem WebADI View

[View Source]

Columns

Name	Datatype	Length	Comments
PERSON_NUMBER	VARCHAR2	(30)	Person Number
PERSON_NAME	VARCHAR2	(363)	Person Name
ANONYMOUS_ID	VARCHAR2	(30)	Anonymous Identifier
COURSE_CD	VARCHAR2	(6)	Course Code
COURSE_TYPE	VARCHAR2	(10)	Course Type
RESPONSIBLE_ORG_UNIT_CD	VARCHAR2	(30)	Organisational Unit Responsibility
UNIT_SET_CD	VARCHAR2	(10)	Unit Set Code
PRG_ALTERNATE_CD	VARCHAR2	(10)	Progression Alternate Code
PRG_CAL_TYPE	VARCHAR2	(10)	Progression Calendar Type
PRG_CI_SEQUENCE_NUMBER	NUMBER		Progression Sequence Number
PROGRESSION_OUTCOME_TYPE	VARCHAR2	(10)	Progression Outcome Type
YOP_GRADE	VARCHAR2	(10)	YOP Grade
YOP_MARK	NUMBER		YOP Mark
UNIT_CD	VARCHAR2	(10)	Unit Code
SUA_VERSION_NUMBE	NUMBER		Version Number
TEACH_CAL_TYPE	VARCHAR2	(10)	Teaching Calendar Type
TEACH_CI_SEQUENCE_NUMBER	NUMBER		Teaching Sequence Number
UOO_ID	NUMBER		Unit Offering Option Identifier
LOCATION_CD	VARCHAR2	(10)	Location Code
GRADING_PERIOD_CD	VARCHAR2	(30)	Grading Period Code
GRADING_SCHEMA_CD	VARCHAR2	(10)	Grading Schema Code
GS_VERSION_NUMBER	NUMBER		Grading Schema Version Number
UNIT_GRADE	VARCHAR2	(5)	Unit Grade
UNIT_MARK	NUMBER		Unit Mark
FINALISED_OUTCOME_INDICATOR	VARCHAR2	(1)	Finalised Outcome Indicator
ASSESSMENT_ID	NUMBER		Assessment Identifier
ASSESSMENT_TYPE	VARCHAR2	(10)	Assessment Type
AI_GRADING_SCHEMA_CD	VARCHAR2	(10)	Assessment Item Grading Schema Code
AI_GS_VERSION_NUMBER	NUMBER		Version Number
AI_MARK	NUMBER		Mark
AI_GRADE	VARCHAR2	(5)	Grade
RECORD_TYPE	VARCHAR2	(4)	Record Type
UNIT_CLASS	VARCHAR2	(10)	Unit Class
REFERENCE	VARCHAR2	(4000)	Reference

Query Text

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


SELECT PERSON_NUMBER
,      PERSON_NAME
,      ANONYMOUS_ID
,      COURSE_CD
,      COURSE_TYPE
,      RESPONSIBLE_ORG_UNIT_CD
,      UNIT_SET_CD
,      PRG_ALTERNATE_CD
,      PRG_CAL_TYPE
,      PRG_CI_SEQUENCE_NUMBER
,      PROGRESSION_OUTCOME_TYPE
,      YOP_GRADE
,      YOP_MARK
,      UNIT_CD
,      SUA_VERSION_NUMBE
,      TEACH_CAL_TYPE
,      TEACH_CI_SEQUENCE_NUMBER
,      UOO_ID
,      LOCATION_CD
,      GRADING_PERIOD_CD
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
,      UNIT_GRADE
,      UNIT_MARK
,      FINALISED_OUTCOME_INDICATOR
,      ASSESSMENT_ID
,      ASSESSMENT_TYPE
,      AI_GRADING_SCHEMA_CD
,      AI_GS_VERSION_NUMBER
,      AI_MARK
,      AI_GRADE
,      RECORD_TYPE
,      UNIT_CLASS
,      REFERENCE
FROM APPS.IGS_AS_PROGUGAI_ADI_V;

Dependencies

[top of page]

APPS.IGS_AS_PROGUGAI_ADI_V references the following:

APPS: FND_DATE - show dependent code; HZ_PARTIES; IGS_AS_ANON_ID_PS; IGS_AS_ASSESSMNT_ITM_ALL; IGS_AS_GEN_003 - show dependent code; IGS_AS_GRD_SCH_GRADE; IGS_AS_SU_ATMPT_ITM; IGS_AS_SU_SETATMPT; IGS_AS_SU_STMPTOUT_ALL; IGS_CA_INST_ALL; IGS_CA_INST_REL; IGS_CA_TYPE; IGS_EN_GEN_015 - show dependent code; IGS_EN_STDNT_PS_ATT_ALL; IGS_EN_STDNT_PS_ATT_SV; IGS_EN_SU_ATTEMPT_ALL; IGS_EN_SU_ATTEMPT_SV; IGS_EN_UNIT_SET; IGS_EN_UNIT_SET_CAT; IGS_HE_EN_SUSA; IGS_PR_OU_TYPE_ALL; IGS_PR_STDNT_PR_OU_ALL; IGS_PS_VER_ALL

APPS.IGS_AS_PROGUGAI_ADI_V is not referenced by any database object