[Home] [Help] [Dependency Information]
Object Name: | IGS_CA_INST_ALT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_CA_INST_ALT_V |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAL_TYPE | VARCHAR2 | (10) | Yes | The calendar type of the calendar instance in which the unit is offered. Units can only be offered in instances of calendar types that are categorised as TEACHING calendars. Examples include SEM - 1 (semester 1 teaching period), SEM - 2 (semester 2 teaching period) and SUM (summer teaching period). |
SEQUENCE_NUMBER | NUMBER | (6) | Yes | The unique identifier for the calendar instance. |
START_DT | DATE | Yes | The date from which a calendar instance becomes effective. For example, the calendar instance Semester 1 1999 may commence on 1/3/1999. | |
END_DT | DATE | Yes | The date from which a calendar instance is no longer effective. For example, the calendar instance Semester 1 1999 may end on 11/6/1999. | |
CAL_STATUS | VARCHAR2 | (10) | Yes | The status of the calendar instance, which indicates the level of activity of the calendar. Each status is mapped to one of the system statuses of ACTIVE, INACTIVE or PLANNED. |
S_CAL_STATUS | VARCHAR2 | (30) | Yes | The preset code for a system-defined calendar instance status. Each institution-defined calendar status is mapped to a system status. |
ALTERNATE_CODE | VARCHAR2 | (10) | The alternate short reference code for identifying a teaching or academic calendar instance. This code is used for mass keying of enrolments and unit/course offerings. | |
DESCRIPTION | VARCHAR2 | (60) | Yes | The description of a type of calendar used within the institution. Examples are STANDARD ACADEMIC YEAR, SEMESTER 1 TEACHING PERIOD, TRIMESTER 2 TEACHING PERIOD and ENROLMENT PERIOD 1. |
S_CAL_CAT | VARCHAR2 | (30) | Yes | A system-defined categorisation of calendar types. Each calendar type is assigned a calendar category to enable the system to determine associated functionality for each type of calendar. For example, the system recognises that units can only be offered in instances of TEACHING calendars. |
ABBREVIATION | VARCHAR2 | (30) | The abbreviated description of a type of calendar used within the institution. Examples are ACAD YEAR ( standard academic year), SEMESTER 1 (semester 1 teaching period), TRIMESTER 2 (trimester 2 teaching period) and ENROLMENT 1 (enrolment period 1). period 1). | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT CAL_TYPE
, SEQUENCE_NUMBER
, START_DT
, END_DT
, CAL_STATUS
, S_CAL_STATUS
, ALTERNATE_CODE
, DESCRIPTION
, S_CAL_CAT
, ABBREVIATION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_CA_INST_ALT_V;
|
|
|