[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_UNIT_OFR_PAT_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_UNIT_OFR_PAT_ALL |
Subobject Name: | |
Status: | VALID |
IGS_PS_UNIT_OFR_PAT_ALL describes the offering pattern of a unit offering option.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_UNIT_OFR_PAT_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
UNIT_CD
VERSION_NUMBER CAL_TYPE CI_SEQUENCE_NUMBER |
IGS_PS_UNIT_OFR_PAT_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CAL_TYPE
CI_SEQUENCE_NUMBER CI_START_DT CI_END_DT |
IGS_PS_UNIT_OFR_PAT_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DELETE_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_CD | VARCHAR2 | (10) | Yes | Unit code the unit offering pattern applies to. A unit code is an institution-defined unique identifier of unit of study. |
VERSION_NUMBER | NUMBER | (3) | Yes | Version of the unit the unit offering pattern applies to. Students are normally enrolled in the current version. Prior versions of the unit are end-dated. |
CAL_TYPE | VARCHAR2 | (10) | Yes | Calendar type of the calendar instance in that the unit is offered. Units can only be offered in instances of calendars categorized as Teaching calendars. |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Sequence number of the calendar instance for the unit offering pattern. The sequence number is the unique identifier of the calendar instance. |
CI_START_DT | DATE | Yes | Start date of the teaching calendar instance that applies to the unit offering pattern. It is the date from that the calendar instance becomes effective. | |
CI_END_DT | DATE | Yes | 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,might end on 30/6/96. | |
WAITLIST_ALLOWED | VARCHAR2 | (1) | Indicator to show whether waitlist is allowed for the unit or not. | |
MAX_STUDENTS_PER_WAITLIST | NUMBER | (6) | Maximum number of students who can be waitlisted is shown. | |
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 | |
REQUEST_ID | NUMBER | (15) | Request identifier of last concurrent program to update this record. | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Application identifier of last concurrent program to update this record. | |
PROGRAM_ID | NUMBER | (15) | Program identifier of last concurrent program to update this record. | |
PROGRAM_UPDATE_DATE | DATE | Last update date of this record by a concurrent program. | ||
ORG_ID | NUMBER | (15) | Operating unit identifier | |
DELETE_FLAG | VARCHAR2 | (1) | Delete flag denotes whether this unit offering pattern is logically deleted or not. | |
ABORT_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the Unit Offering Pattern is ABORTED. |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_CD
, VERSION_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, CI_START_DT
, CI_END_DT
, WAITLIST_ALLOWED
, MAX_STUDENTS_PER_WAITLIST
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, DELETE_FLAG
, ABORT_FLAG
FROM IGS.IGS_PS_UNIT_OFR_PAT_ALL;
IGS.IGS_PS_UNIT_OFR_PAT_ALL does not reference any database object
IGS.IGS_PS_UNIT_OFR_PAT_ALL is referenced by following:
|
|
|