[Home] [Help] [Dependency Information]
Object Name: | IGSFV_DISCONTINUATION_REASONS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_DISCONTINUATION_REASONS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Describes the user defined reason codes for dropping the units.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DISCONTINUATION_REASON_CODE | VARCHAR2 | (10) | Yes | Identifies the reason for the discontinuation of the student program/unit attempt |
DESCRIPTION | VARCHAR2 | (60) | Yes | Describes the reason for the discontinuation of the student program/unit attempt. |
DEFAULT_INDICATOR | VARCHAR2 | (1) | Yes | Indicator that specifies whether the discontinuation reason code is the default reason. Setting the indicator will make the reason code appear as the default reason for all student program/unit attempt discontinuations. |
S_DISCONTINUATION_REASON_TYPE | VARCHAR2 | (30) | Identifies the system-defined reason type for the discontinuation of the student program/unit attempt. For example 'TRANSFER' is used whereas student program attempt is discontinued by the program transfer process. | |
SYSTEM_DEFAULT_INDICATOR | VARCHAR2 | (1) | Yes | Indicates the institution-defined discontinuation reason code that will be used by system functionality to automatically set the reason code from a system-defined discontinuation reason type mapping. |
CLOSED_INDICATOR | VARCHAR2 | (1) | Yes | Indicator that specifies whether the discontinuation reason is open or closed. Setting the checkbox to 'closed' prevents use of the discontinuation reason in new or modified student course attempt discontinuation records. |
COMMENTS | VARCHAR2 | (2000) | Text-based facility for entering additional information details about the discontinuation reason code. | |
DCNT_PROGRAM_INDICATOR | VARCHAR2 | (1) | Indicator that identifies the corresponding discontinuation reason code applicable to a program. A discontinuation reason is applicable to a program if this is selected. | |
DCNT_UNIT_INDICATOR | VARCHAR2 | (1) | Indicator that identifies the corresponding discontinuation reason code applicable to a unit in general. A discontinuation reason is applicable to a unit if this is selected. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT DISCONTINUATION_REASON_CODE
, DESCRIPTION
, DEFAULT_INDICATOR
, S_DISCONTINUATION_REASON_TYPE
, SYSTEM_DEFAULT_INDICATOR
, CLOSED_INDICATOR
, COMMENTS
, DCNT_PROGRAM_INDICATOR
, DCNT_UNIT_INDICATOR
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_DISCONTINUATION_REASONS;
APPS.IGSFV_DISCONTINUATION_REASONS is not referenced by any database object
|
|
|