eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.IGSFV_HIGH_EDU_PRG_STAGES

Object Details

Object Name:	IGSFV_HIGH_EDU_PRG_STAGES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_HIGH_EDU_PRG_STAGES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This is a full view, which describes program stages within a program version that are represented by a code. These stages are evaluated through relationships to rules within the rules sub-system and are measured through progression.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROGRAM_CODE	VARCHAR2	(6)	Yes	Unique identifier of a program to which the stage is attached.
PROGRAM_VERSION_NUMBER	NUMBER	(3)	Yes	Version number of a program to which the stage is attached.
PROGRAM_STAGE_TYPE	VARCHAR2	(10)	Yes	Identifies a program version's stage. A program can consist of one or many stages.
PROGRAM_STAGE_DESCRIPTION	VARCHAR2	(60)		Provides an explanation of the program stage.
PROGRAM_STAGE_COMMENTS	VARCHAR2	(2000)		Used to enter information about the context program stage.
PROGRAM_TITLE	VARCHAR2	(90)	Yes	Description of the program to which the stage is attached.
PROGRAM_STAGE_TYPE_DESCRIPTION	VARCHAR2	(60)	Yes	Description of a program stage type
PRG_STAGE_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the sequence number that uniquely identifies the program stage.
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_CODE
,      PROGRAM_VERSION_NUMBER
,      PROGRAM_STAGE_TYPE
,      PROGRAM_STAGE_DESCRIPTION
,      PROGRAM_STAGE_COMMENTS
,      PROGRAM_TITLE
,      PROGRAM_STAGE_TYPE_DESCRIPTION
,      PRG_STAGE_SEQUENCE_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_HIGH_EDU_PRG_STAGES;

Dependencies

[top of page]

APPS.IGSFV_HIGH_EDU_PRG_STAGES references the following:

APPS: IGS_PS_STAGE; IGS_PS_STAGE_TYPE; IGS_PS_VER_ALL

APPS.IGSFV_HIGH_EDU_PRG_STAGES is not referenced by any database object