[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
IGS.IGS_EN_CAT_PRC_DTL does not reference any database object
IGS.IGS_EN_CAT_PRC_DTL is referenced by following:
|
|
|