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_STDNT_PS_ATT_V

Object Details

Object Name:	IGS_EN_STDNT_PS_ATT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_EN_STDNT_PS_ATT_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_ID	NUMBER	(15)	Yes	Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Identifie.
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.
VERSION_NUMBER	NUMBER	(3)	Yes	A number signifying the version of the course in which the student enrols.
CAL_TYPE	VARCHAR2	(10)	Yes	The name of the calendar type in which the course is offered.It is usual for award courses to be offered in the standard academic calendar.
LOCATION_CD	VARCHAR2	(10)	Yes	The location, typically a campus, from where the student's course is offered.
ATTENDANCE_MODE	VARCHAR2	(2)	Yes	The institution-defined attendance modes in which the course isoffered. Institution-defined attendance modes may include, forexample, N -On Campus , F- Off Campus and M -Multi-modal .See also Element 329 Higher Education Student Data CollectionDocumentation 1997, DETYA.When displayed in the Student Course Attempt Inquiry-INQF1200 this field displays the derived attendance mode and attendancetype for ENROLLED courses.
ATTENDANCE_TYPE	VARCHAR2	(2)	Yes	The institution-defined attendance type in which the course isoffered. Institution-defined attendance types may include, forexample, F - Full-time and P- Part-time . See also Element 330 HigherEducation Student Data Collection Documentation 1997, DETYA.
COURSE_ATTEMPT_STATUS	VARCHAR2	(30)		The student course attempt status is a system derived value and wil be one of the following: UNCONFIRMED, INACTIVE, ENROLLED, DISCONTINUED,INTERMITTED, LAPSED or COMPLETED. Under certain circumstances a course may also have been DELETED.
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
FEE_ASS_IND	VARCHAR2	(1)		This is a flag to indicate the Fee Assessment of a Lookup Type.
FEE_CAT	VARCHAR2	(10)		The fee category applicable to the student's course attempt.Fee categories are used to define the set of fees and charges applicable to a student studying a particular course.
CURRENCY_CD	VARCHAR2	(15)		The currency codes in which fee assessments and payments may be made. If not defined, fee assessments default to the local currency.

Query Text

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


SELECT ROW_ID
,      PERSON_ID
,      PERSON_NUMBER
,      COURSE_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      COURSE_ATTEMPT_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      FEE_ASS_IND
,      FEE_CAT
,      CURRENCY_CD
FROM APPS.IGS_EN_STDNT_PS_ATT_V;

Dependencies

[top of page]

APPS.IGS_EN_STDNT_PS_ATT_V references the following:

APPS: IGS_EN_STDNT_PS_ATT; IGS_FI_FEE_CAT; IGS_LOOKUPS_VIEW; IGS_PE_PERSON_BASE_V

APPS.IGS_EN_STDNT_PS_ATT_V is not referenced by any database object