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_CPD_EXT_ALL

Object Details

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

Contains the enrollment eligibility setup information.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_CPD_EXT_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	IGS_EN_CPD_EXT_ID
IGS_EN_CPD_EXT_ALL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ENROLMENT_CAT ENR_METHOD_TYPE ORG_ID S_ENROLMENT_STEP_TYPE S_STUDENT_COMM_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
IGS_EN_CPD_EXT_ID	NUMBER	(15)	Yes	System generated number to uniquely identify the Eligibility setup.
ORG_ID	NUMBER	(15)		Organization Identifier for the enrollment Eligibility setup extension details.
ENROLMENT_CAT	VARCHAR2	(10)	Yes	The Enrollment Category used for eligibility setup.
ENR_METHOD_TYPE	VARCHAR2	(10)	Yes	The Enrollment Method Type used for eligibility setup.
S_STUDENT_COMM_TYPE	VARCHAR2	(10)	Yes	The Student Commencement Type used for eligibility setup.
STEP_ORDER_NUM	NUMBER	(3)	Yes	The order in which the eligibility steps should be validated for a given enrollment category, method type and student commencement type.
S_ENROLMENT_STEP_TYPE	VARCHAR2	(30)	Yes	The Eligibility step type used for eligibility setup.
NOTIFICATION_FLAG	VARCHAR2	(10)	Yes	Define notification flag i.e. WARN or DENY the user when the validation fails.
S_RULE_CALL_CD	VARCHAR2	(10)		The rule call code to the rules engine which is holding the rule defined.
RUL_SEQUENCE_NUMBER	NUMBER	(6)		Rule Sequence Number to identify the rule set up.
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
STUD_AUDIT_LIM	NUMBER	(2)		Maximum number of audit units a given student can enroll.

Query Text

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


SELECT IGS_EN_CPD_EXT_ID
,      ORG_ID
,      ENROLMENT_CAT
,      ENR_METHOD_TYPE
,      S_STUDENT_COMM_TYPE
,      STEP_ORDER_NUM
,      S_ENROLMENT_STEP_TYPE
,      NOTIFICATION_FLAG
,      S_RULE_CALL_CD
,      RUL_SEQUENCE_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      STUD_AUDIT_LIM
FROM IGS.IGS_EN_CPD_EXT_ALL;

Dependencies

[top of page]

IGS.IGS_EN_CPD_EXT_ALL does not reference any database object

IGS.IGS_EN_CPD_EXT_ALL is referenced by following:

APPS: IGS_EN_CPD_EXT_ALL