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_DTL

Object Details

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

IGS_EN_CAT_PRC_DTL describes the detail of enrollment procedure type. This detail includes breaking the procedure down into new and returning elements.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_CAT_PRC_DTL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ENROLMENT_CAT S_STUDENT_COMM_TYPE ENR_METHOD_TYPE
IGS_EN_CAT_PRC_DTL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENR_METHOD_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
ENROLMENT_CAT	VARCHAR2	(10)	Yes	Enrolment category is used to group students who, for the purposes of enrolment, share common characteristics.
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	Institution-defined code that defines an enrolment method.
PRODUCE_PACKAGE_IND	VARCHAR2	(1)		Indicator that specifies whether an enrolment package is produced for the selected enrolment category, enrolment method type, and student type combination. -Obsolete
PERSON_ADD_ALLOW_IND	VARCHAR2	(1)	Yes	Indicator that specifies whether for the selected enrolment category, enrolment method type, and student type combination, it is permissible to add a new student to the database through the enrolment process.
COURSE_ADD_ALLOW_IND	VARCHAR2	(1)	Yes	Indicator that specifies whether for the selected Enrolment Category, Enrolment Method Type, and Student Type combination, it is permissible to add a new student program attempt through the enrolment process.
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
CONFIG_MIN_CP_VALDN	VARCHAR2	(10)		Field to store the configuration of Minimum Credit Point Validation. Can be 'MINCPREACH' or 'DATEALIASREACH' or 'NONE'
ENFORCE_DATE_ALIAS	VARCHAR2	(10)		Date Alias of Enforcement

Query Text

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


SELECT ENROLMENT_CAT
,      S_STUDENT_COMM_TYPE
,      ENR_METHOD_TYPE
,      PRODUCE_PACKAGE_IND
,      PERSON_ADD_ALLOW_IND
,      COURSE_ADD_ALLOW_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CONFIG_MIN_CP_VALDN
,      ENFORCE_DATE_ALIAS
FROM IGS.IGS_EN_CAT_PRC_DTL;

Dependencies

[top of page]

IGS.IGS_EN_CAT_PRC_DTL does not reference any database object

IGS.IGS_EN_CAT_PRC_DTL is referenced by following:

APPS: IGS_EN_CAT_PRC_DTL