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

VIEW: APPS.IGS_EN_DCNT_REASONCD

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

View Type

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.


[View Source]

Columns
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.
Query Text

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;

Dependencies

[top of page]

APPS.IGS_EN_DCNT_REASONCD references the following:

SchemaAPPS
SynonymIGS_EN_DCNT_REASONCD_ALL
APPS.IGS_EN_DCNT_REASONCD is referenced by following:

SchemaAPPS
ViewIGS_EN_DCNT_REASONCD_V
Package BodyIGS_EN_DROP_UNITS_API - show dependent code
Package BodyIGS_EN_GEN_003 - show dependent code
Package BodyIGS_EN_GEN_008 - show dependent code
Package BodyIGS_EN_GEN_010 - show dependent code
Package BodyIGS_EN_GEN_012 - show dependent code
Package BodyIGS_EN_GEN_LEGACY - show dependent code
Package BodyIGS_EN_PLAN_UTILS - show dependent code
Package BodyIGS_EN_TRANSFER_APIS - show dependent code
Package BodyIGS_EN_VAL_DR - show dependent code
Package BodyIGS_EN_VAL_SCA - show dependent code
Package BodyIGS_EN_WORKFLOW - show dependent code
Package BodyIGS_FI_GEN_008 - show dependent code
PL/SQL PackageIGS_FI_GEN_008 - show dependent code
Package BodyIGS_IN_GEN_001 - show dependent code
Package BodyIGS_PR_GEN_004 - show dependent code
Package BodyIGS_SS_EN_WRAPPERS - show dependent code