DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGS_EN_CPD_EXT

Object Details
Object Name: IGS_EN_CPD_EXT
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_EN_CPD_EXT
Subobject Name:
Status: VALID

View Type

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


Describes the Enrollment Category Procedure Details


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID.
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.
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.
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
,      NOTIFICATION_FLAG
,      S_RULE_CALL_CD
,      RUL_SEQUENCE_NUMBER
,      STUD_AUDIT_LIM
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_EN_CPD_EXT;

Dependencies

[top of page]

APPS.IGS_EN_CPD_EXT references the following:

SchemaAPPS
SynonymIGS_EN_CPD_EXT_ALL
APPS.IGS_EN_CPD_EXT is referenced by following:

SchemaAPPS
Package BodyIGS_EN_ADD_UNITS_API - show dependent code
Package BodyIGS_EN_CPD_EXT_PKG - show dependent code
ViewIGS_EN_CPD_EXT_V
Package BodyIGS_EN_ELGBL_PERSON - show dependent code
Package BodyIGS_EN_ELGBL_PROGRAM - show dependent code
Package BodyIGS_EN_ELGBL_UNIT - show dependent code
Package BodyIGS_EN_ELGB_OVR_UOO_PKG - show dependent code
Package BodyIGS_EN_ENROLL_WLST - show dependent code
PL/SQL PackageIGS_EN_ENROLL_WLST - show dependent code
Package BodyIGS_EN_GEN_011 - show dependent code
Package BodyIGS_EN_GEN_015 - show dependent code
Package BodyIGS_EN_GEN_016 - show dependent code
Package BodyIGS_EN_IVR_PUB - show dependent code
Package BodyIGS_EN_PLAN_UTILS - show dependent code
Package BodyIGS_EN_VAL_SUA - show dependent code
Package BodyIGS_SS_ENR_DETAILS - show dependent code
Package BodyIGS_SS_EN_WRAPPERS - show dependent code