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

VIEW: APPS.IGSBV_HOLD_TYPES

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

View Type

A Business Intelligence System view


Describes the user-defined hold types that might be applied to a person by the institution. For example, unpaid fees, failed academic progression check. These types contain one or more hold effects that are applied to the person.


[View Source]

Columns
Name Datatype Length Mandatory Comments
HOLD_TYPE VARCHAR2 (10) Yes Code of an institution-defined hold type incorporating one or more system hold effect types.
DESCRIPTION VARCHAR2 (60) Yes Description of an institution-defined hold type incorporating one or more system hold effect types.
SYSTEM_HOLD_CATEGORY VARCHAR2 (10) Yes Hold category of the hold type. The category may be academic or administrative.
NOTES VARCHAR2 (2000)
Text facility for entering additional information comments or details about the context institution-defined hold type.
CLOSED_INDICATOR VARCHAR2 (1) Yes Indicator that specifies whether the hold type is closed or open. Setting the checkbox to closed prevents further application of holds of this type.
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 HOLD_TYPE
,      DESCRIPTION
,      SYSTEM_HOLD_CATEGORY
,      NOTES
,      CLOSED_INDICATOR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_HOLD_TYPES;

Dependencies

[top of page]

APPS.IGSBV_HOLD_TYPES references the following:

SchemaAPPS
SynonymIGS_FI_ENCMB_TYPE_ALL

APPS.IGSBV_HOLD_TYPES is not referenced by any database object