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_PE_PRG_CTXT_V

Object Details

Object Name:	IGS_EN_PE_PRG_CTXT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_EN_PE_PRG_CTXT_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.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Identifier.
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.
COURSE_ATTEMPT_STATUS	VARCHAR2	(30)		The student course attempt status is a system derived value and wil lbe one of the following: UNCONFIRMED, INACTIVE, ENROLLED, DISCONTINUED ,INTERMITTED, LAPSED or COMPLETED. Under certain circumstances a course may also have been DELETED.
FULL_NAME	VARCHAR2	(450)		The concatenated name of the person's first , middle and last name.
SEX	VARCHAR2	(30)		This gives the code for sex of the person.
SEX_MEANING	VARCHAR2	(80)		This field describes the meaning of the sex code . for example M-male so on.
BIRTH_DT	DATE			This field gives the date of birth for the person.
API_PERSON_ID	VARCHAR2	(20)		This field gives the alternate ID for a person with the given person ID.
DECEASED_IND	VARCHAR2	(1)		This is an indicator which specifies wether the person is alive or deceased.It is checked to indicate a deceased person.
ENCUMBERED_IND	VARCHAR2	(4000)		This is an indicator which specifies wether the student is having any fee holds or not. By checking it the student record will be checked for fee holds.
COURSE_TITLE	VARCHAR2	(90)	Yes	The title or full name of the course. DETYA element 308.
COURSE_CD_VERSION	VARCHAR2	(47)		A number signifying the version of the course in which the studen 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 is offered. Institution-defined attendance modes may include, for example, N -On Campus , F -Off Campus and M -Multi-modal.See also Element 329 Higher Education Student Data Collection Documentation 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 is offered. 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.
COMMENCEMENT_DT	DATE			The date on which the student commenced the curren tcourse for the first time. See Element 328 Higher EducationStudent Data Collection Documentation 1997, DETYA.
DISCONTINUATION_REASON_CD	VARCHAR2	(10)		Identifies the primary reason behind the discontinuation of the student's course attempt.
CORRESPONDENCE_CAT	VARCHAR2	(10)		The Correspondence Category applicable to the student's course attempt. Correspondence categories are used to define the set of system generated and non-system oiginated correspondence items which will be sent to the student.
EXAM_LOCATION_CD	VARCHAR2	(10)		The code of an examination centre nominated by the student as their default examination location. This location is overridden if the student nominates a different location for a specific unit.
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.
FUNDING_SOURCE	VARCHAR2	(10)		The Funding Source applicable to the student's course attempt.A majority of students are funded from the Commonwealth operating grant, however an increasing number of students are self-funded or paid for by industry.
PUBLISH_OUTCOMES_IND	VARCHAR2	(1)	Yes	An indicator which specifies whether the student is to have their results published in the press and/or on public notice-boards. The indicator defaults to Y ticked . De-selecting the indicator suppresses publication of results except in a forma lcertificate of results or academic transcript.
PROVISIONAL_IND	VARCHAR2	(1)	Yes	An indicator which specifies whether the student's admission and enrolment in the course is provisional. Setting the checkbox ticked indicates that the course candidature is provisional. The indicator is maintained manually.
SELF_HELP_GROUP_IND	VARCHAR2	(1)	Yes	An indicator which specifies whether the student wishes to participate in a self-help group for their enrolled course attempt.Setting the checkbox ticked includes the student in the self-help group. De-selecting the checkbox removes the student from the self-help group listing.
DISCONTINUED_DT	DATE			The effective date on which the student's course attempt was discontinued.
LAPSED_DT	DATE			This field describes the date on which the student course attemp tstatus was changed to lapsed.
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

Query Text

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


SELECT PERSON_ID
,      PERSON_NUMBER
,      COURSE_CD
,      VERSION_NUMBER
,      COURSE_ATTEMPT_STATUS
,      FULL_NAME
,      SEX
,      SEX_MEANING
,      BIRTH_DT
,      API_PERSON_ID
,      DECEASED_IND
,      ENCUMBERED_IND
,      COURSE_TITLE
,      COURSE_CD_VERSION
,      CAL_TYPE
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      COMMENCEMENT_DT
,      DISCONTINUATION_REASON_CD
,      CORRESPONDENCE_CAT
,      EXAM_LOCATION_CD
,      FEE_CAT
,      FUNDING_SOURCE
,      PUBLISH_OUTCOMES_IND
,      PROVISIONAL_IND
,      SELF_HELP_GROUP_IND
,      DISCONTINUED_DT
,      LAPSED_DT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_EN_PE_PRG_CTXT_V;

Dependencies

[top of page]

APPS.IGS_EN_PE_PRG_CTXT_V references the following:

APPS: IGS_EN_GEN_003 - show dependent code; IGS_EN_GEN_007 - show dependent code; IGS_EN_STDNT_PS_ATT_SV; IGS_PE_PERSON_V; IGS_PS_VER

APPS.IGS_EN_PE_PRG_CTXT_V is not referenced by any database object