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

VIEW: APPS.IGSBV_SYSTEM_HOLD_EFFECT_TYPES

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

View Type

A Business Intelligence System view


This entity describes the hold effects recognised by the system, and available for application to a student. e.g. Suppression of transcript, maximum enrolment load restriction.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SYSTEM_HOLD_EFFECT_TYPE VARCHAR2 (10) Yes System-defined hold effect used in the creation of institution-defined hold types.
APPLY_TO_PROGRAM_INDICATOR VARCHAR2 (1) Yes Indicator that specifies whether the system hold effect type must be applied to an existing student program attempt. Setting the indicator restricts the system hold effect type to an existing student program attempt.
CLOSED_INDICATOR VARCHAR2 (1) Yes Indicator that specifies if the system hold effect type is closed. Setting the checkbox prevents use of the system hold effect type in the creation of new or modified institution-defined hold types.
_LA:DESCRIPTION CHAR (67)
Description of system-defined hold effect used in the creation of institution-defined hold types.
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SYSTEM_HOLD_EFFECT_TYPE
,      APPLY_TO_PROGRAM_INDICATOR
,      CLOSED_INDICATOR
,      _LA:DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_SYSTEM_HOLD_EFFECT_TYPES;

Dependencies

[top of page]

APPS.IGSBV_SYSTEM_HOLD_EFFECT_TYPES references the following:

SchemaAPPS
SynonymIGS_EN_ENCMB_EFCTTYP

APPS.IGSBV_SYSTEM_HOLD_EFFECT_TYPES is not referenced by any database object