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_EN_SS_SCHEDULE_DISP_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Unique Person identifier
PROGRAM_CD	VARCHAR2	(6)	Yes	Program code
VERSION_NUMBER	NUMBER	(3)	Yes	Version number of the program code
PROGRAM_TYPE	VARCHAR2	(10)	Yes	Program type of the program code
ATTENDANCE_TYPE	VARCHAR2	(4000)		Attendance type of the program offering
ATTENDANCE_TYPE_DESC	VARCHAR2	(4000)		Attendance type description
ATTENDANCE_MODE	VARCHAR2	(4000)		Attendance mode of the program offering
ATTENDANCE_MODE_DESC	VARCHAR2	(4000)		Attendance mode description
LOCATION_CD	VARCHAR2	(4000)		Location code of the program offering
LOCATION_CD_DESC	VARCHAR2	(4000)		Location code description
TERM_CAL_TYPE	VARCHAR2	(10)	Yes	Term calendar type
TERM_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Term calendar sequence number
TERM_DESCRIPTION	VARCHAR2	(30)		Term calendar instance description
TERM_START_DT	DATE		Yes	Term calendar start date
ACAD_CAL_TYPE	VARCHAR2	(10)	Yes	Academic calendar type
ACAD_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Academic calendar sequence number
ACADEMIC_DESCRIPTION	VARCHAR2	(30)		Academic calendar instance description
UNCONFORM_SUA	VARCHAR2	(1)		Indicator, says whether unconfirmed units exists in the given term calendar
APPLIED_MIN_CP	NUMBER			Minimum credit points setup applicable in the given term
APPLIED_MAX_CP	NUMBER			Maximum credit points setup applicable in the given term
INST_ATTENDANCE	VARCHAR2	(4000)		Institutional attendance type for the given student and term
INST_CP	VARCHAR2	(4000)		Institutional credit points for the given student and term
PRIMARY_PRG_TITLE	VARCHAR2	(4000)		Program or primary program title
SECONDARY_PRG_TITLE	VARCHAR2	(4000)		Concatenated titles of all the secondary programs in the given career
YEAR_OF_PROGRAM	VARCHAR2	(4000)		Current unit set for the given student program attempt
PRIMARY_PROGRAM_TYPE	VARCHAR2	(4000)		Primary program type for the given program attempt

Query Text

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


SELECT PERSON_ID
,      PROGRAM_CD
,      VERSION_NUMBER
,      PROGRAM_TYPE
,      ATTENDANCE_TYPE
,      ATTENDANCE_TYPE_DESC
,      ATTENDANCE_MODE
,      ATTENDANCE_MODE_DESC
,      LOCATION_CD
,      LOCATION_CD_DESC
,      TERM_CAL_TYPE
,      TERM_SEQUENCE_NUMBER
,      TERM_DESCRIPTION
,      TERM_START_DT
,      ACAD_CAL_TYPE
,      ACAD_SEQUENCE_NUMBER
,      ACADEMIC_DESCRIPTION
,      UNCONFORM_SUA
,      APPLIED_MIN_CP
,      APPLIED_MAX_CP
,      INST_ATTENDANCE
,      INST_CP
,      PRIMARY_PRG_TITLE
,      SECONDARY_PRG_TITLE
,      YEAR_OF_PROGRAM
,      PRIMARY_PROGRAM_TYPE
FROM APPS.IGS_EN_SS_SCHEDULE_DISP_V;

Dependencies

[top of page]

APPS.IGS_EN_SS_SCHEDULE_DISP_V references the following:

APPS: IGS_CA_INST; IGS_CA_INST_REL; IGS_CA_LOAD_TO_TEACH_V; IGS_CA_TYPE; IGS_EN_ELGBL_PROGRAM - show dependent code; IGS_EN_PRC_LOAD - show dependent code; IGS_EN_SPA_TERMS_API - show dependent code; IGS_EN_STDNT_PS_ATT; IGS_EN_SU_ATTEMPT; IGS_PS_VER; IGS_SS_ENR_DETAILS - show dependent code

APPS.IGS_EN_SS_SCHEDULE_DISP_V is not referenced by any database object