[Home] [Help] [Dependency Information]
Object Name: | IGSBV_CALENDAR_PERIODS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_CALENDAR_PERIODS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This is the base view for the entity Calendar Periods that describes an instance of a calendar type.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALENDAR_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_DATE | DATE | Yes | Start Date when the calendar instance becomes effective. | |
END_DATE | DATE | Yes | End Date when the calendar instance is no longer effective. | |
CALENDAR_STATUS | VARCHAR2 | (10) | Yes | Status of the calendar instance, that indicates the level of activity of the calendar. |
ALTERNATE_CODE | VARCHAR2 | (10) | Alternate short reference code for identifying a calendar instance. Alternate codes are mandatory for academic, admission progression, and teaching calendars. | |
DESCRIPTION | VARCHAR2 | (30) | Description of the Calendar Instance. | |
SELF_SERVICE_DISPLAYED | VARCHAR2 | (1) | Indicates whether the load calendar is displayed to self-service users. | |
IVR_ENABLED | VARCHAR2 | (1) | To indicate if the calendar is to be listed in IVR | |
PRIOR_CAL_INST_SEQ_NUM | NUMBER | (6) | Unique identifier for a prior calendar instance. Set when calendar instance is the result of a rolled over calendar. | |
SUPERIOR_CAL_STAT_DIFF_INDICAT | 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_ALTERNATE_CODE | VARCHAR2 | (10) | Alternate short reference code for identifying a calendar instance. | |
PRIOR_START_DATE | DATE | Start Date when the prior calendar instance becomes effective. | ||
PRIOR_END_DATE | DATE | End Date when the prior calendar instance becomes no longer effective. | ||
CALENDAR_DESCRIPTION | VARCHAR2 | (60) | Yes | Description of a calendar type used within the institution. |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT CALENDAR_TYPE
, SEQUENCE_NUMBER
, START_DATE
, END_DATE
, CALENDAR_STATUS
, ALTERNATE_CODE
, DESCRIPTION
, SELF_SERVICE_DISPLAYED
, IVR_ENABLED
, PRIOR_CAL_INST_SEQ_NUM
, SUPERIOR_CAL_STAT_DIFF_INDICAT
, PRIOR_ALTERNATE_CODE
, PRIOR_START_DATE
, PRIOR_END_DATE
, CALENDAR_DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_CALENDAR_PERIODS;
APPS.IGSBV_CALENDAR_PERIODS is not referenced by any database object
|
|
|