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_CAT_PROCEDURE_STEP_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

IGS_EN_CAT_PROCEDURE_STEP-v performs the appropriate steps that have to be followed based on the enrollment procedure look up

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ENROLMENT_CAT	VARCHAR2	(10)	Yes	An enrollment category is used to group students who, for the purposes of enrollment, share common characteristics. By combining an enrollment category with an enrolment method type and student commencement type the set of enrollment steps, termed category procedure detail and category procedure steps, can be defined.
S_STUDENT_COMM_TYPE	VARCHAR2	(10)	Yes	A system-defined type of student. The allowable types are; New -students commencing a program, Return students continuing with a program and ALL -encompassing both New and Returning students.
ENR_METHOD_TYPE	VARCHAR2	(10)	Yes	An institution defined code that describes an enrollment method. Institutions may wish to define more than one enrollment method with different enrollment category procedure detail and different enrollment category procedure steps. For example, institutions may have a FACE2FACE enrollment method and an IVRS enrollment method.
S_ENROLMENT_STEP_TYPE	VARCHAR2	(30)	Yes	Describes the type code allocated to the enrollment step
STEP_GROUP_TYPE	VARCHAR2	(4000)		A system defined classification of enrollment steps. Enrollment steps relate either to the person, the student's program attempt or their unit enrolment. Person steps, if selected, are displayed in Part 1 of the record enrollments window, ENRF3000. program steps are displayed in Part 2, and unit steps are displayed in Part 3 of the window.
STEP_ORDER_NUM	NUMBER	(3)		Displays sequence of enrollment category procedure steps in the Record Enrolments window, ENRF3000 to be changed. Person Steps are displayed as buttons in Part 1 of the Record Enrollments window. Program steps are displayed as buttons or T- List items in Part 2 of ENRF3000. Unit steps are displayed as buttons or T- List items in Part 3 of ENRF3000.
MANDATORY_STEP_IND	VARCHAR2	(0)		Specifies whether it is mandatory to record a particular item of data as part of the enrollment process. Setting the indicator ticked highlights the particular button with Record Enrolment window, ENRF3000. No other system functionality is associated with the indicator. The user is not warned if mandatory data is not entered.
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 ENROLMENT_CAT
,      S_STUDENT_COMM_TYPE
,      ENR_METHOD_TYPE
,      S_ENROLMENT_STEP_TYPE
,      STEP_GROUP_TYPE
,      STEP_ORDER_NUM
,      MANDATORY_STEP_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_EN_CAT_PROCEDURE_STEP_V;

Dependencies

[top of page]

APPS.IGS_EN_CAT_PROCEDURE_STEP_V references the following:

APPS: IGS_EN_CAT_PRC_STEP; IGS_EN_GEN_003 - show dependent code

APPS.IGS_EN_CAT_PROCEDURE_STEP_V is not referenced by any database object