[Home] [Help] [Dependency Information]
Object Name: | IGS_EN_DCNT_REASONCD |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_EN_DCNT_REASONCD |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
This view lists out all the codes that are associated with a discontinuation reason.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ORG_ID | NUMBER | (15) | Operating Unit Identifier. | |
DISCONTINUATION_REASON_CD | VARCHAR2 | (10) | Yes | A code that identifies the reason for the discontinuation of the student course attempt. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Describes the reason for the discontinuation of thestudent course attempt. |
DFLT_IND | VARCHAR2 | (1) | Yes | An indicator which specifies whether the discontinuation reasoncode is the default reason. Setting the indicator will make thereason code appear as the default reason for all student course attempt discontinuations. |
S_DISCONTINUATION_REASON_TYPE | VARCHAR2 | (30) | Identifies the system-defined reason type for the discontinuation of the student course attempt. For example 'TRANSFER' is used wherea student course attempt is discontinued by the course transfer process. | |
SYS_DFLT_IND | VARCHAR2 | (1) | Yes | Indicates the institution-defined discontinuation reason code thatwill be used by system functionality to automatically set the reasoncode from a system-defined discontinuation reason type mapping.Only one discontinuation reason code can be defined as a systemdefault for a system discontinuation reason type. |
CLOSED_IND | VARCHAR2 | (1) | Yes | An indicator which specifies whether the discontinuation reason is open or closed. Setting the checkbox to 'closed' ticked preventsuse of the discontinuation reason in new or modified student course attempt discontinuation records. |
COMMENTS | VARCHAR2 | (2000) | A text-based facility for recording additional information or details about the discontinuation reason code. | |
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 | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
DCNT_PROGRAM_IND | VARCHAR2 | (1) | An indicator which identifies the corresponding discontinuation reason code applicable to a course. A discontinuation reason is applicable to a course if this is selected checked. | |
DCNT_UNIT_IND | VARCHAR2 | (1) | An indicator which identifies the corresponding discontinuation reason code applicable to a unit in general. A discontinuation reason is applicable to a unit if this is selected checked. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ORG_ID
, DISCONTINUATION_REASON_CD
, DESCRIPTION
, DFLT_IND
, S_DISCONTINUATION_REASON_TYPE
, SYS_DFLT_IND
, CLOSED_IND
, COMMENTS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DCNT_PROGRAM_IND
, DCNT_UNIT_IND
FROM APPS.IGS_EN_DCNT_REASONCD;
|
|
|