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]

TABLE: IGS.IGS_EN_CAT_PRC_STEP_ALL

Object Details

Object Name:	IGS_EN_CAT_PRC_STEP_ALL
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_EN_CAT_PRC_STEP_ALL
Subobject Name:
Status:	VALID

IGS_EN_CAT_PRC_STEP_ALL describes a step within an enrollment procedure and the sequence that it must be performed. This step will be selected from one of the available system-defined enrollment steps.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_CAT_PRC_STEP_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ENROLMENT_CAT S_STUDENT_COMM_TYPE ENR_METHOD_TYPE S_ENROLMENT_STEP_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
ENROLMENT_CAT	VARCHAR2	(10)	Yes	Describes the types of enrolment procedure.
S_STUDENT_COMM_TYPE	VARCHAR2	(10)	Yes	System defined type of student. The allowable types are NEW - students commencing a program, RETURN - students continuing with program and ALL encompassing both NEW and RETURNing students.
ENR_METHOD_TYPE	VARCHAR2	(10)	Yes	Describes the type of enrolment method used for enrolling.
S_ENROLMENT_STEP_TYPE	VARCHAR2	(30)	Yes	Describes the type code allocated to the enrolment step.
STEP_ORDER_NUM	NUMBER	(3)		Describes the sequence in that the enrolment procedure step is performed.
MANDATORY_STEP_IND	VARCHAR2	(1)		Describes whether the step is a mandatory step within the enrolment collection process for the relevant enrolment category detail. -Obsolete
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
ORG_ID	NUMBER	(15)		Operating unit identifier

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_ORDER_NUM
,      MANDATORY_STEP_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM IGS.IGS_EN_CAT_PRC_STEP_ALL;

Dependencies

[top of page]

IGS.IGS_EN_CAT_PRC_STEP_ALL does not reference any database object

IGS.IGS_EN_CAT_PRC_STEP_ALL is referenced by following:

APPS: IGS_EN_CAT_PRC_STEP_ALL