[Home] [Help] [Dependency Information]
Object Name: | IGS_EN_METHOD_TYPE |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_EN_METHOD_TYPE |
Subobject Name: | |
Status: | VALID |
Describes the available method types that students can be enrolled to. For example, online, ivrs, batch key. This table is modified to capture the enrollment method type related to self service.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_EN_METHOD_TYPE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ENR_METHOD_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ENR_METHOD_TYPE | VARCHAR2 | (10) | Yes | Describes the type of enrolment method used for enrolling. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Describes the enrolment method type. |
CLOSED_IND | VARCHAR2 | (1) | Yes | Describes whether the enrolment method type is closed. |
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 | |
SELF_SERVICE | VARCHAR2 | (1) | Indicates whether the enrollment method type can be used in Self Service or not. | |
IVR_DISPLAY_IND | VARCHAR2 | (1) | To indicate if the enrollment method type is applicable for enrollment using IVR - Obsolete | |
BULK_JOB_IND | VARCHAR2 | (1) | Possible values are 'Y' and 'N'. If the column contains a value of 'Y' then the associated Method Type would be considered as the default Method Type by the Bulk Jobs in the Enrollment Sub system. | |
TRANSFER_FLAG | VARCHAR2 | (1) | Yes | Transfer flag |
DFLT_TRANS_DETAILS_FLAG | VARCHAR2 | (1) | Yes | Default the transfer approved date and effective term flag |
Cut, paste (and edit) the following text to query this object:
SELECT ENR_METHOD_TYPE
, DESCRIPTION
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SELF_SERVICE
, IVR_DISPLAY_IND
, BULK_JOB_IND
, TRANSFER_FLAG
, DFLT_TRANS_DETAILS_FLAG
FROM IGS.IGS_EN_METHOD_TYPE;
IGS.IGS_EN_METHOD_TYPE does not reference any database object
IGS.IGS_EN_METHOD_TYPE is referenced by following:
|
|
|