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_CPD_EXT_V

Object Details

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

View Type

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

Describes the Enrollment Category Eligibility Validation Extension

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Rowid
IGS_EN_CPD_EXT_ID	NUMBER	(15)	Yes	System generated number to uniquely identify the Eligibility setup.
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.
STEP_MEANING	VARCHAR2	(80)	Yes	Meaning of the step type defined.
STEP_GROUP_TYPE	VARCHAR2	(10)		Defines whether the group of the validation step. For example, person, program orUnit.
RULE_APPLICABLE_IND	VARCHAR2	(1)		Describes the Rule applicable indicator.
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.
RUD_SEQUENCE_NUMBER	NUMBER	(6)		Sequence number of a system rule
SELECT_GROUP	NUMBER	(6)		Contains the rule group number
S_RETURN_TYPE	VARCHAR2	(20)		Rule return Type
RULE_DESCRIPTION	VARCHAR2	(255)		Holds the definition of the rule as it will be used in the implementation
RULE_TEXT	VARCHAR2	(4000)		Holds the text of the defined rule.
DEFINED_LAMP	VARCHAR2	(9)		Displays whether rule is defined or not.
STUD_AUDIT_LIM	NUMBER	(2)		Maximum number of audit units a given student can enroll.
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 ROW_ID
,      IGS_EN_CPD_EXT_ID
,      ENROLMENT_CAT
,      ENR_METHOD_TYPE
,      S_STUDENT_COMM_TYPE
,      STEP_ORDER_NUM
,      S_ENROLMENT_STEP_TYPE
,      STEP_MEANING
,      STEP_GROUP_TYPE
,      RULE_APPLICABLE_IND
,      NOTIFICATION_FLAG
,      S_RULE_CALL_CD
,      RUL_SEQUENCE_NUMBER
,      RUD_SEQUENCE_NUMBER
,      SELECT_GROUP
,      S_RETURN_TYPE
,      RULE_DESCRIPTION
,      RULE_TEXT
,      DEFINED_LAMP
,      STUD_AUDIT_LIM
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_EN_CPD_EXT_V;

Dependencies

[top of page]

APPS.IGS_EN_CPD_EXT_V references the following:

APPS: IGS_EN_CPD_EXT; IGS_LOOKUPS_VIEW; IGS_RU_CALL; IGS_RU_DESCRIPTION; IGS_RU_GEN_003 - show dependent code

APPS.IGS_EN_CPD_EXT_V is referenced by following:

APPS: IGS_EN_ELGBL_PROGRAM - show dependent code; IGS_EN_IVR_PUB - show dependent code