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.IGS_DA_XML_ACADEMICPROGRAM_V

Object Details

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

XML element AcademicProgramSub view indexed by Degree Program view Provides the provides the DA specified program information
"SPA" -- Students Selected Degree Program
"WIF" -- What-if Program
"SPECIAL" -- Special Program

[View Source]

Columns

Name	Datatype	Length	Comments
PROGRAM_TYPE	VARCHAR2	(10)	Contains the type of the program being described.
PROGRAM_CODE	VARCHAR2	(30)	Contains the program.
PROGRAM_NAME	VARCHAR2	(240)	Contains the name of the program.
PROGRAM_DECLARED_DEGREE_DATE	CHAR	(0)	Contains the declared date of program completion.
PROGRAM_CATALOG_YEAR	VARCHAR2	(30)	Contains the catalog year of the program.
CLASS_STANDING	VARCHAR2	(4000)	Contains the standing within the program.
PROGRAM_COMPLETE_OVERRIDE	CHAR	(0)	Contains an indicator that the program is not considered to be complete even if the requirements have been met.
BATCH_ID	NUMBER	(15)	Contains the OSS generated Batch ID for tracking purposes.
PERSON_ID	NUMBER	(15)	Describes the details of the person ID code that is being passed.
IGS_DA_REQ_STDNTS_ID	NUMBER	(15)	Student ID
LOAD_CAL_TYPE	VARCHAR2	(10)	Load calendar type
LOAD_CI_SEQUENCE_NUMBER	NUMBER		Load calendar sequence number
SOURCE	VARCHAR2	(7)	Major1,2,3 - minor 1,2,3 - track 1,2,3

Query Text

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


SELECT PROGRAM_TYPE
,      PROGRAM_CODE
,      PROGRAM_NAME
,      PROGRAM_DECLARED_DEGREE_DATE
,      PROGRAM_CATALOG_YEAR
,      CLASS_STANDING
,      PROGRAM_COMPLETE_OVERRIDE
,      BATCH_ID
,      PERSON_ID
,      IGS_DA_REQ_STDNTS_ID
,      LOAD_CAL_TYPE
,      LOAD_CI_SEQUENCE_NUMBER
,      SOURCE
FROM APPS.IGS_DA_XML_ACADEMICPROGRAM_V;

Dependencies

[top of page]

APPS.IGS_DA_XML_ACADEMICPROGRAM_V references the following:

APPS: FND_LOOKUP_VALUES; IGS_CA_INST_ALL; IGS_CA_TEACH_TO_LOAD_V; IGS_DA_REQ_STDNTS; IGS_DA_REQ_WIF; IGS_DA_RQST; IGS_DA_SETUP; IGS_EN_STDNT_PS_ATT_ALL; IGS_EN_SU_ATTEMPT; IGS_PE_STAT_DETAILS; IGS_PR_GET_CLASS_STD - show dependent code; IGS_PS_STAT; IGS_PS_VER; IGS_PS_VER_ALL

APPS.IGS_DA_XML_ACADEMICPROGRAM_V is referenced by following:

APPS: IGS_DA_XML_PKG - show dependent code