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.IGSFV_STUD_PRG_PRE_ENROLLMENTS

Object Details

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

View Type

A Business Intelligence System view

This entity describes enrollment which will occur or has occurred for student program attempt

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_IDENTIFIER	NUMBER	(15)	Yes	Describes the ID that uniquely identifies a person
PERSON_NUMBER	VARCHAR2	(30)	Yes	Describes the ID code that uniquely identifies a person.
PERSON_NAME	VARCHAR2	(360)	Yes	Full Name of the Person.
PROGRAM_CODE	VARCHAR2	(6)	Yes	Describes the program code.
PROGRAM_TITLE	VARCHAR2	(90)	Yes	Title of the program code
CALENDAR_TYPE	VARCHAR2	(10)	Yes	An abbreviated name of a type of calendar used within the university. For example, academic, semester one.
CAL_INST_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Uniquely identifies the calendar instance.
CALENDAR_START_DATE	DATE		Yes	Start Date of Calendar Instance
CALENDAR_END_DATE	DATE		Yes	End Date of Calendar Instance
CALENDAR_INSTANCE_DESC	VARCHAR2	(30)		Description for calendar instance
ENROLMENT_CATEGORY	VARCHAR2	(10)	Yes	Describes the types of enrollment procedure
ENROLMENT_CATEGORY_DESC	VARCHAR2	(60)	Yes	The description of an institution defined code used to describe an enrollment category. Enrollment Categories are used to define the processes and procedures involved in the enrollment of particular groups of students.
ENROLLED_DATE	DATE			Date of enrollment
ENR_FORM_DUE_DATE	DATE			Describes the date on which a student must have their enrollment window returned either by mail or by performing their enrollment to be eligible to enroll.
ENR_PACKAGE_PROD_DATE	DATE			Describes the date on which to produce the students enrollment package
ENR_FORM_RECEIVED_DATE	DATE			Describes the date on which the student's enrollment window was received
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

Query Text

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


SELECT PERSON_IDENTIFIER
,      PERSON_NUMBER
,      PERSON_NAME
,      PROGRAM_CODE
,      PROGRAM_TITLE
,      CALENDAR_TYPE
,      CAL_INST_SEQUENCE_NUMBER
,      CALENDAR_START_DATE
,      CALENDAR_END_DATE
,      CALENDAR_INSTANCE_DESC
,      ENROLMENT_CATEGORY
,      ENROLMENT_CATEGORY_DESC
,      ENROLLED_DATE
,      ENR_FORM_DUE_DATE
,      ENR_PACKAGE_PROD_DATE
,      ENR_FORM_RECEIVED_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_STUD_PRG_PRE_ENROLLMENTS;

Dependencies

[top of page]

APPS.IGSFV_STUD_PRG_PRE_ENROLLMENTS references the following:

APPS: HZ_PARTIES; IGS_AS_SC_ATMPT_ENR; IGS_CA_INST_ALL; IGS_EN_ENROLMENT_CAT; IGS_EN_STDNT_PS_ATT_ALL; IGS_PS_VER_ALL

APPS.IGSFV_STUD_PRG_PRE_ENROLLMENTS is not referenced by any database object