[Home] [Help] [Dependency Information]
Object Name: | IGS_CA_INST_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_CA_INST_ALL |
Subobject Name: | |
Status: | VALID |
IGS_CA_INST_ALL describes an instance of a calendar type. This table is modified to capture the enrollment method type related to self service.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_CA_INST_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CAL_TYPE
SEQUENCE_NUMBER |
IGS_CA_INST_ALL_U3 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CAL_TYPE
START_DT END_DT |
IGS_CA_INST_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CAL_STATUS |
IGS_CA_INST_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CAL_TYPE
PRIOR_CI_SEQUENCE_NUMBER |
IGS_CA_INST_ALL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ALTERNATE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAL_TYPE | VARCHAR2 | (10) | Yes | Name of a type of calendar used within the organization. |
SEQUENCE_NUMBER | NUMBER | (6) | Yes | Unique identifier for the calendar instance. |
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. | |
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. | |
CAL_STATUS | VARCHAR2 | (10) | Yes | Status of the calendar instance, that indicates the level of activity of the calendar. Each status is mapped to one of the system statuses of ACTIVE, INACTIVE, or PLANNED. |
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 enrolments, uni tand course offerings and is displayed in relevant forms and reports. | |
SUP_CAL_STATUS_DIFFER_IND | VARCHAR2 | (1) | Yes | System-set indicator that specifies if the status of a calendar instance differs from the status of any of its superior calendar instances. |
PRIOR_CI_SEQUENCE_NUMBER | NUMBER | (6) | Unique identifier for a prior calendar instance. Set when calendar instance is the result of a rolled over calendar. | |
ORG_ID | NUMBER | (15) | Operating unit identifier. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
SS_DISPLAYED | VARCHAR2 | (1) | Indicates whether the load calendar is to be displayed to self service users or not. | |
DESCRIPTION | VARCHAR2 | (30) | Description for the Calendar Instance | |
IVR_DISPLAY_IND | VARCHAR2 | (1) | To indicate if the calendar is to be displayed in IVR | |
TERM_INSTRUCTION_TIME | NUMBER | Term Instructional Time of the Load calendar instance, measured in weeks. | ||
PLANNING_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the load calendar is available for planning or not. Default Value 'N' |
SCHEDULE_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the load calendar is available for schedule or not. Default Value 'N' |
ADMIN_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the load calendar is available for searching/scheduling in self-service or not for admin and faculty. Default Value 'N' |
Cut, paste (and edit) the following text to query this object:
SELECT CAL_TYPE
, SEQUENCE_NUMBER
, START_DT
, END_DT
, CAL_STATUS
, ALTERNATE_CODE
, SUP_CAL_STATUS_DIFFER_IND
, PRIOR_CI_SEQUENCE_NUMBER
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SS_DISPLAYED
, DESCRIPTION
, IVR_DISPLAY_IND
, TERM_INSTRUCTION_TIME
, PLANNING_FLAG
, SCHEDULE_FLAG
, ADMIN_FLAG
FROM IGS.IGS_CA_INST_ALL;
IGS.IGS_CA_INST_ALL does not reference any database object
IGS.IGS_CA_INST_ALL is referenced by following:
|
|
|