[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_PS_SCH_INT_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_PS_SCH_INT_ALL
|
| Subobject Name: | |
| Status: | VALID |
Contains scheduling information that is used for exporting and importing to the third party scheduling interface. Each row in this table represents each occurrence. Unit Section information for record in this table can be obtained by using the IGS_PS_SCH_USEC_INT_ALL table.The corresponding production table is IGS_PS_USEC_OCCURS_ALL.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Export and Import Schedule details for Unit section Occurrence
Category: BUSINESS_ENTITY IGS_UNIT
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_PS_SCH_INT_ALL_PK | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 INT_OCCURS_ID
|
| IGS_PS_SCH_INT_ALL_U2 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
INT_USEC_ID
UNIT_SECTION_OCCURRENCE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CALENDAR_TYPE | VARCHAR2 | (10) | Type of calendar used for scheduling - Obsolete | |
| SEQUENCE_NUMBER | NUMBER | (6) | Sequence number of the unit section for that a scheduling is planned - Obsolete | |
| TRANSACTION_TYPE | VARCHAR2 | (10) | Yes | Transaction type for scheduling interface. Values are: REQUEST, UPDATE, CANCEL |
| UNIT_SECTION_OCCURRENCE_ID | NUMBER | (10) | Yes | Unique identifier for each unit section occurrence. |
| UNIT_CD | VARCHAR2 | (10) | Code of the unit - Obsolete | |
| VERSION_NUMBER | NUMBER | (3) | Version number of the unit for that the scheduling is planned - Obsolete | |
| UNIT_TITLE | VARCHAR2 | (90) | The name of the unit that is offered - Obsolete | |
| OWNER_ORG_UNIT_CD | VARCHAR2 | (30) | Identifier for the owner of the organizational unit section - Obsolete | |
| UNIT_CLASS | VARCHAR2 | (10) | Time and mode of availability of a class - Obsolete | |
| MONDAY | VARCHAR2 | (1) | Indicator to show if a Unit section occurrence can be scheduled on Monday or not. | |
| TUESDAY | VARCHAR2 | (1) | Indicator to show if a Unit section occurrence can be scheduled on Tuesday or not. | |
| WEDNESDAY | VARCHAR2 | (1) | Indicator to show if a Unit section occurrence can be scheduled Wednesday or not. | |
| THURSDAY | VARCHAR2 | (1) | Indicator to show if a Unit section occurrence can be scheduled Thursday or not. | |
| FRIDAY | VARCHAR2 | (1) | Indicator to show if a Unit section occurrence can be scheduled Friday or not. | |
| SATURDAY | VARCHAR2 | (1) | Indicator to show if a Unit section occurrence can be scheduled Saturday or not. | |
| SUNDAY | VARCHAR2 | (1) | Indicator to show if a Unit section occurrence can be scheduled Sunday or not. | |
| UNIT_SECTION_START_DATE | DATE | Start date of the unit section - Obsolete | ||
| UNIT_SECTION_END_DATE | DATE | End date of the unit section - Obsolete | ||
| START_TIME | DATE | Start time of the unit section occurrence. | ||
| END_TIME | DATE | End time of the unit section occurrence. | ||
| ENROLLMENT_MAXIMUM | NUMBER | (6) | Maximum number of enrollments for the unit section that can be done - Obsolete | |
| ENROLLMENT_ACTUAL | NUMBER | (6) | Actual number of enrollments for the unit section -Obsolete | |
| INSTRUCTOR_ID | NUMBER | (15) | Unique identifier of the lead instructor. | |
| SURNAME | VARCHAR2 | (150) | Surname of the lead instructor. | |
| BUILDING_CODE | NUMBER | (10) | Scheduled Building Identifier-Obsolete | |
| ROOM_CODE | NUMBER | (10) | Scheduled Room Identifier-Obsolete | |
| LOCATION_CD | VARCHAR2 | (10) | Code of the place where the unit offering is made - Obsolete | |
| UNIT_SEC_CROSS_UNIT_SEC_ID | NUMBER | Unique identifier for cross-listed unit section occurrence - Obsolete | ||
| UOO_ID | NUMBER | (7) | Unique identifier of unit section - Obsolete | |
| SCHEDULE_STATUS | VARCHAR2 | (30) | Status of the unit section occurrence schedule. Values are: PROCESSING, ERROR, TBA, SCHEDULED, CANCELLED, USER_CANCEL, USER_UPDATE | |
| ERROR_TEXT | VARCHAR2 | (2000) | Error message that is output after the scheduler runs. | |
| TRANSACTION_ID | NUMBER | Unique identifier for transactions with scheduler - Obsolete | ||
| ORG_ID | NUMBER | (15) | Operating unit identifier | |
| INT_OCCURS_ID | NUMBER | Yes | Unique identifier for a unit section occurrence in the Scheduler Interface. | |
| INT_USEC_ID | NUMBER | Unique identifier for a Unit Section in the Scheduler Interface. | ||
| GIVEN_NAMES | VARCHAR2 | (150) | The given names of the lead instructor | |
| MIDDLE_NAME | VARCHAR2 | (60) | Middle name of the lead instructor | |
| DEDICATED_BUILDING_CODE | NUMBER | (10) | Dedicated Building Identifier-Obsolete | |
| DEDICATED_ROOM_CODE | NUMBER | (10) | Dedicated Room Identifier-Obsolete | |
| PREFERRED_BUILDING_CODE | NUMBER | (10) | Preferred Building Identifier-Obsolete | |
| PREFERRED_ROOM_CODE | NUMBER | (10) | Preferred Room Identifier-Obsolete | |
| TBA_STATUS | VARCHAR2 | (1) | To Be Announced Unit Section Occurrence. If the value is 'Y' then it is to be announced unit section occurrence. | |
| USO_START_DATE | DATE | Unit Section Occurrence Start Date | ||
| USO_END_DATE | DATE | Unit Section Occurrence End Date | ||
| 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 | |
| BUILDING_ID | NUMBER | (10) | Scheduled Building Identifier. | |
| ROOM_ID | NUMBER | (10) | Scheduled Room Identifier. | |
| DEDICATED_BUILDING_ID | NUMBER | (10) | Dedicated Building Identifier. | |
| DEDICATED_ROOM_ID | NUMBER | (10) | Dedicated Room Identifier. | |
| PREFERRED_BUILDING_ID | NUMBER | (10) | Preferred Building Identifier. | |
| PREFERRED_ROOM_ID | NUMBER | (10) | Preferred Room Identifier. | |
| PREFERRED_REGION_CODE | VARCHAR2 | (30) | User Preferred Region Code for the unit section occurrence. E.g. North Campus ,South Campus. | |
| ABORT_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the occurrence is ABORTED. |
| IMPORT_DONE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the occurrence has been imported to production. |
| OCCURRENCE_IDENTIFIER | VARCHAR2 | (30) | Unique identity for an occurrence within a unit section. |
Cut, paste (and edit) the following text to query this object:
SELECT CALENDAR_TYPE
, SEQUENCE_NUMBER
, TRANSACTION_TYPE
, UNIT_SECTION_OCCURRENCE_ID
, UNIT_CD
, VERSION_NUMBER
, UNIT_TITLE
, OWNER_ORG_UNIT_CD
, UNIT_CLASS
, MONDAY
, TUESDAY
, WEDNESDAY
, THURSDAY
, FRIDAY
, SATURDAY
, SUNDAY
, UNIT_SECTION_START_DATE
, UNIT_SECTION_END_DATE
, START_TIME
, END_TIME
, ENROLLMENT_MAXIMUM
, ENROLLMENT_ACTUAL
, INSTRUCTOR_ID
, SURNAME
, BUILDING_CODE
, ROOM_CODE
, LOCATION_CD
, UNIT_SEC_CROSS_UNIT_SEC_ID
, UOO_ID
, SCHEDULE_STATUS
, ERROR_TEXT
, TRANSACTION_ID
, ORG_ID
, INT_OCCURS_ID
, INT_USEC_ID
, GIVEN_NAMES
, MIDDLE_NAME
, DEDICATED_BUILDING_CODE
, DEDICATED_ROOM_CODE
, PREFERRED_BUILDING_CODE
, PREFERRED_ROOM_CODE
, TBA_STATUS
, USO_START_DATE
, USO_END_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, BUILDING_ID
, ROOM_ID
, DEDICATED_BUILDING_ID
, DEDICATED_ROOM_ID
, PREFERRED_BUILDING_ID
, PREFERRED_ROOM_ID
, PREFERRED_REGION_CODE
, ABORT_FLAG
, IMPORT_DONE_FLAG
, OCCURRENCE_IDENTIFIER
FROM IGS.IGS_PS_SCH_INT_ALL;
IGS.IGS_PS_SCH_INT_ALL does not reference any database object
IGS.IGS_PS_SCH_INT_ALL is referenced by following:
APPS
IGS_PS_SCH_INT_ALL
|
|
|
|