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_NON_ENR_STDNT_OU_ASS_V

Object Details

Object Name:	IGS_EN_NON_ENR_STDNT_OU_ASS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_EN_NON_ENR_STDNT_OU_ASS_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
ROW_ID	ROWID	(10)
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Identifier.
PERSON_ID	NUMBER	(15)	Yes	Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
UNIT_CD	VARCHAR2	(10)	Yes	The code used to identify the unit which is the subject of the unit exclusion.
VERSION_NUMBER	NUMBER	(3)	Yes	This field describes the unit version number in which the student is enrolled.
CAL_TYPE	VARCHAR2	(10)	Yes	Calendar Type
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Calendar Instance sequence number
ACAD_ALTERNATE_CODE	VARCHAR2	(10)
TEACH_ALTERNATE_CODE	VARCHAR2	(10)
COURSE_CD	VARCHAR2	(6)		The course attempt course code of the student for whom the non-enrolled outcome is recorded. This field is optional and is normally only used if the relevant course attempt is known at the time of recording the non-enrolled outcome. A non-enrolled outcome can only be recorded if the student has at least one course attempt, of any status.
LOCATION_CD	VARCHAR2	(10)		The location code of the location where the unit is being offered.A location code is a institution-defined code of a physical location owned or used by the institution. Each location has alocation type, such as CAMPUS, which defines its use in the system.
UNIT_MODE	VARCHAR2	(10)		The unit mode of the unit attempt. A unit mode is an institution defined mode of offering a unit. Example on-campus,off-campus. A list of values is available.
UNIT_CLASS	VARCHAR2	(10)		The unit class of the unit attempt . A unit class is an institution-defined code that identifies a unit class.A list of values is available
S_GRADE_CREATION_METHOD_TYPE	VARCHAR2	(30)	Yes	This field describes the creation method which was used to load the grade. example Keying, Upload.
GRADING_SCHEMA_CD	VARCHAR2	(10)		This field gives the code for the creation method which was used to load the grade. example Keying, Upload.
GS_VERSION_NUMBER	NUMBER	(3)		This field describes the version number of the grading schema.
GRADE	VARCHAR2	(5)		A code which indicates the student's level of achievement in the unit attempt. A list of values is available.
MARK	NUMBER	(6)		A numeric code which indicates the student's level of achievement in the unit attempt.
RESOLVED_IND	VARCHAR2	(1)		An indicator which specifies whether or not the non-enrolled outcome has been resolved that is attributed to an enrolled student .This indicator provides the means to only report on non-enrolled outcomes which are still at issue. Setting this indicator ticked means the non-enrolled outcome has been resolved.
COMMENTS	VARCHAR2	(2000)		Any additional information or details about the outcome for a unit attempt in which the student is not enrolled.
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

Query Text

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


SELECT ROW_ID
,      PERSON_NUMBER
,      PERSON_ID
,      UNIT_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      ACAD_ALTERNATE_CODE
,      TEACH_ALTERNATE_CODE
,      COURSE_CD
,      LOCATION_CD
,      UNIT_MODE
,      UNIT_CLASS
,      S_GRADE_CREATION_METHOD_TYPE
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
,      GRADE
,      MARK
,      RESOLVED_IND
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TEACH_CAL_DESCRIPTION
FROM APPS.IGS_EN_NON_ENR_STDNT_OU_ASS_V;

Dependencies

[top of page]

APPS.IGS_EN_NON_ENR_STDNT_OU_ASS_V references the following:

APPS: HZ_PARTIES; IGS_AS_NON_ENR_STDOT; IGS_CA_GEN_001 - show dependent code; IGS_CA_INST_ALL; IGS_EN_GEN_014 - show dependent code

APPS.IGS_EN_NON_ENR_STDNT_OU_ASS_V is not referenced by any database object