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

VIEW: APPS.IGSBV_HIGH_EDU_PRG_GROUPS

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

View Type

A Business Intelligence System view


This is a base view, which describes a grouping of programs,which are used for a variety of purposes within the system.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROGRAM_GROUP_CODE VARCHAR2 (10) Yes Unique identifier for a group of programs.
PROGRAM_GROUP_DESCRIPTION VARCHAR2 (60) Yes Description of the program group.
RESP_ORG_UNIT_CODE VARCHAR2 (30)
Code to identify the organization unit responsible for the program group.
RESP_ORG_UNIT_START_DATE DATE

Start date of the organizational unit responsible for the program group.
PROGRAM_GROUP_TYPE VARCHAR2 (10) Yes Unique identifier for the institution defined type of program group. Each program group must be assigned a program group type.
PROGRAM_CLOSED_INDICATOR VARCHAR2 (1) Yes Indicator, which specifies if the program group is open or closed. If the program group is closed it cannot be used in new or modified program group membership records.
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 PROGRAM_GROUP_CODE
,      PROGRAM_GROUP_DESCRIPTION
,      RESP_ORG_UNIT_CODE
,      RESP_ORG_UNIT_START_DATE
,      PROGRAM_GROUP_TYPE
,      PROGRAM_CLOSED_INDICATOR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_HIGH_EDU_PRG_GROUPS;

Dependencies

[top of page]

APPS.IGSBV_HIGH_EDU_PRG_GROUPS references the following:

SchemaAPPS
SynonymIGS_PS_GRP_ALL

APPS.IGSBV_HIGH_EDU_PRG_GROUPS is not referenced by any database object