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_CA_LOAD_TO_TEACH_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

Describes the teaching calendars for the give load calendar

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LOAD_CAL_TYPE	VARCHAR2	(10)	Yes	Name of a type calendar used within the institution. For example, ACAD-YR, SEM-1, LOAD-1.
LOAD_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique identifier of the calendar instance
LOAD_START_DT	DATE		Yes	Date from that a calendar instance becomes effective. For example, the calendar instance Semester 1 1999 may commence on 1/3/1999.
LOAD_END_DT	DATE		Yes	Date from that a calendar instance is no longer effective. For example, the calendar instance Semester 1 1999 may end on 11/6/1999.
LOAD_ALTERNATE_CODE	VARCHAR2	(10)		Alternate short reference code for identifying a calendar instance. Alternate codes are mandatory for academic, admission progression, and teaching calendars. The code is used to facilitate mass keying of enrollment, unit and course offerings and is displayed in relevant forms and reports.
LOAD_CAL_DESCRIPTION	VARCHAR2	(30)		Description of the load calendar instance
TEACH_CAL_TYPE	VARCHAR2	(10)	Yes	Institution-defined name of a type of calendar used within the organization. Units can only be offered in instances of calendar types that are categorized as TEACHING calendars.
TEACH_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique identifier for a prior calendar instance. Set when calendar instance is the result of a rolled over calendar.
TEACH_START_DT	DATE		Yes	The Start date.
TEACH_END_DT	DATE		Yes	The End Date.
TEACH_ALTERNATE_CODE	VARCHAR2	(10)		Describes the alternate code.
TEACH_CAL_DESCRIPTION	VARCHAR2	(30)		Description of the teach calendar instance

Query Text

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


SELECT LOAD_CAL_TYPE
,      LOAD_CI_SEQUENCE_NUMBER
,      LOAD_START_DT
,      LOAD_END_DT
,      LOAD_ALTERNATE_CODE
,      LOAD_CAL_DESCRIPTION
,      TEACH_CAL_TYPE
,      TEACH_CI_SEQUENCE_NUMBER
,      TEACH_START_DT
,      TEACH_END_DT
,      TEACH_ALTERNATE_CODE
,      TEACH_CAL_DESCRIPTION
FROM APPS.IGS_CA_LOAD_TO_TEACH_V;

Dependencies

[top of page]

APPS.IGS_CA_LOAD_TO_TEACH_V references the following:

APPS: IGS_CA_INST; IGS_CA_INST_REL; IGS_CA_TYPE; IGS_ST_DFT_LOAD_APPO

APPS.IGS_CA_LOAD_TO_TEACH_V is referenced by following:

APPS: IGF_AP_GEN - show dependent code; IGF_SP_AWARD - show dependent code; IGF_SP_GEN_001 - show dependent code; IGS_AS_SLIST_ADI_V; IGS_EN_ELGBL_PROGRAM - show dependent code; IGS_EN_ELGBL_UNIT - show dependent code; IGS_EN_GEN_004 - show dependent code; IGS_EN_GEN_016 - show dependent code; IGS_EN_GEN_017 - show dependent code; IGS_EN_GEN_018 - show dependent code; IGS_EN_IVR_PUB - show dependent code; IGS_EN_NSC_PKG - show dependent code; IGS_EN_PRC_LOAD - show dependent code; IGS_EN_SS_SCHEDULE_DISP_V; IGS_EN_SUA_API - show dependent code; IGS_EN_SUA_LGCY_PUB - show dependent code; IGS_EN_SU_ATTEMPT_PKG - show dependent code; IGS_EN_TIMESLOTS - show dependent code; IGS_EN_VAL_BULKRULE - show dependent code; IGS_FI_1098T_EXTRACT_DATA - show dependent code; IGS_FI_PRC_FEE_ROLLV - show dependent code; IGS_FI_PRC_STDNT_DPSTS - show dependent code; IGS_PR_CP_GPA - show dependent code; IGS_PS_CAL_RSR_VAL - show dependent code; IGS_PS_GEN_008 - show dependent code; IGS_PS_RLOVR_FAC_TSK - show dependent code; IGS_PS_UNIT_OFR_OPT_PKG - show dependent code; IGS_PS_VALIDATE_LGCY_PKG - show dependent code; IGS_PT_GEN_PKG - show dependent code; IGS_SS_EN_WRAPPERS - show dependent code