[Home] [Help] [Dependency Information]
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 |
A public view which may be useful for custom reporting or other data
requirements.
Describes the teaching calendars for the give load calendar
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 |
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;
|
|
|