[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_UNIT_OFR_OPT_GRD_SCHM_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_PS_UNIT_OFR_OPT_GRD_SCHM_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This entity store information of units that are offered for a calendar, they should also have an offering option and an offering pattern.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Unique identifier of the given view | |
UNIT_CD | VARCHAR2 | (10) | Yes | Unique identifier of the unit being offered |
VERSION_NUMBER | NUMBER | (3) | Yes | The version number of the unit being offered. Students are normally enrolled in the current version. Prior version are end dated. |
CAL_TYPE | VARCHAR2 | (10) | Yes | The calendar type in that the unit is offered. For example, include SEM-1, semester -1 teaching period and TRI-2, trimester-2 traning period and SUM, summer teaching period. Units can only be offered in instances of calendar types that are categorized as teaching calendars. |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | The sequence number of the calendar instance for the unit offering pattern. The sequence number is the unique ID identifier of the calendar instance. |
LOCATION_CD | VARCHAR2 | (10) | Yes | The institution-defined location code, typically of a campus, that a unit offering option is offered |
UNIT_CLASS | VARCHAR2 | (10) | Yes | The institution-defined code that identifies a unit class |
UOO_ID | NUMBER | (7) | Yes | The unique identifier for a unit offering option |
DSP_CI_START_DT | DATE | Yes | The start date of the teaching calendar instance that applies to the unit offering pattern. It is the date from that the calendar instance become effective. | |
DSP_CI_END_DT | DATE | Yes | The end date of the teaching calendar instance that applies to the unit offering pattern. It is the date from that the calendar instance is no longer effective. For example, teaching period semester -1, 1996 can end on 30/06/1996. | |
DSP_UNIT_STATUS | VARCHAR2 | (10) | Yes | The institution-defined status of a unit that maps to a system unit status |
DSP_TITLE | VARCHAR2 | (90) | Yes | The title of the unit |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, UNIT_CD
, VERSION_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, LOCATION_CD
, UNIT_CLASS
, UOO_ID
, DSP_CI_START_DT
, DSP_CI_END_DT
, DSP_UNIT_STATUS
, DSP_TITLE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_PS_UNIT_OFR_OPT_GRD_SCHM_V;
APPS.IGS_PS_UNIT_OFR_OPT_GRD_SCHM_V is not referenced by any database object
|
|
|