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_EN_SUA_YEAR_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
COURSE_CD	VARCHAR2	(6)	Yes	A code used to identify the course in which the student is enrolled.See also Element 307 Higher Education Student Data Collection Documentation 1997, DETYA.
CRS_CAL_TYPE	VARCHAR2	(10)	Yes	Name of a type of academic calendar within the university. For example,ACAD-YEAR
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. Unit sets are used to represent concepts such as majors, minors, strands, streams and lists.
US_VERSION_NUMBER	NUMBER	(3)	Yes	Describes the unit set version number which is being attempted
UNIT_SET_TITLE	VARCHAR2	(90)	Yes	The title of a unit set. Unit sets comprise lists of units or rules which constitute a logical set of units. Unit sets are used torepresents concepts such as majors, minors, strands, streams,and lists.
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.
COMPLETION_DT	DATE			The date on which the unit set requirements were complete.
US_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the internal sequence number
UNIT_SET_CAT	VARCHAR2	(10)	Yes	The code of a category of unit set. Unit set categoriesare institution-defined and may include, for example, MAJOR,MINOR, STRAND, and STREAM.
UNIT_CD	VARCHAR2	(10)	Yes	The code used to identify the unit.
VERSION_NUMBER	NUMBER	(3)	Yes	Version number is used to uniquely identify each version of a unit.
UNIT_TITLE	VARCHAR2	(90)	Yes	Title of the unit
CAL_TYPE	VARCHAR2	(10)	Yes	This field is the name of a type of teaching calendar within the university. Examples- SEM-1, YR-LONG.
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	This field uniquely identifies the calendar instance.
CI_START_DT	DATE		Yes	This field describes the date from which an instance of a calendar is effective
LOCATION_CD	VARCHAR2	(10)	Yes	This field is the location name or code. The locationrepresents a geographical location and is used to indicate where units are offered.
UNIT_CLASS	VARCHAR2	(10)	Yes	This field describes the code that uniquely identifies the unit class
UNIT_ATTEMPT_STATUS	VARCHAR2	(30)	Yes	This field describes the system-defined unit attempt statuses..
UAS_MEANING	VARCHAR2	(80)	Yes	Description of the unit attempt status code
MARK	NUMBER			A numeric code that indicates the student's level of achievement in the unit attempt.
GRADE	VARCHAR2	(4000)		The grade which the student attained for this unit attempt.
PERIOD	VARCHAR2	(4000)		Concatenated field of load or term calendar alternate code and academic calendar alternate code
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
TEACH_CAL_DESCRIPTION	VARCHAR2	(30)		Teaching Calendar Description
UOO_ID	NUMBER	(7)	Yes	The unique identifier for a unit offering option.
CORE_INDICATOR_CODE	VARCHAR2	(30)		The core indicator indicates whether a student unit attempt is Core, Optional, Elective or null.

Query Text

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


SELECT PERSON_ID
,      COURSE_CD
,      CRS_CAL_TYPE
,      UNIT_SET_CD
,      US_VERSION_NUMBER
,      UNIT_SET_TITLE
,      SELECTION_DT
,      COMPLETION_DT
,      US_SEQUENCE_NUMBER
,      UNIT_SET_CAT
,      UNIT_CD
,      VERSION_NUMBER
,      UNIT_TITLE
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      CI_START_DT
,      LOCATION_CD
,      UNIT_CLASS
,      UNIT_ATTEMPT_STATUS
,      UAS_MEANING
,      MARK
,      GRADE
,      PERIOD
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TEACH_CAL_DESCRIPTION
,      UOO_ID
,      CORE_INDICATOR_CODE
FROM APPS.IGS_EN_SUA_YEAR_V;

Dependencies

[top of page]

APPS.IGS_EN_SUA_YEAR_V references the following:

APPS: IGS_AS_SU_SETATMPT; IGS_CA_GEN_001 - show dependent code; IGS_CA_INST; IGS_EN_GEN_014 - show dependent code; IGS_EN_GEN_015 - show dependent code; IGS_EN_PLAN_UTILS - show dependent code; IGS_EN_STDNT_PS_ATT; IGS_EN_SU_ATTEMPT; IGS_EN_UNIT_SET; IGS_EN_UNIT_SET_CAT; IGS_LOOKUPS_VIEW; IGS_PS_UNIT_VER

APPS.IGS_EN_SUA_YEAR_V is referenced by following:

APPS: IGS_AV_GEN_001 - show dependent code; IGS_EN_GEN_010 - show dependent code