[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_SCH_USEC_INT_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_SCH_USEC_INT_ALL |
Subobject Name: | |
Status: | VALID |
Contains the high-level unit section information used for scheduling. The occurrences of the unit section can be obtained by cross-reference to the IGS_PS_SCH_INT_ALL table.The corresponding production table is IGS_PS_UNIT_OFR_OPT_ALL.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Export and Import Scheduling Unit Section Detail
Category: BUSINESS_ENTITY IGS_UNIT
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_SCH_USEC_INT_ALL_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | INT_USEC_ID |
IGS_PS_SCH_USEC_INT_ALL_U2 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
UOO_ID
TRANSACTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INT_USEC_ID | NUMBER | Yes | Unique identifier for each Unit Section in the Scheduler Interface | |
CALENDAR_TYPE | VARCHAR2 | (10) | Type of calendar used for scheduling. | |
SEQUENCE_NUMBER | NUMBER | (6) | Sequence number of the unit section for that a scheduling is planned. | |
UNIT_CD | VARCHAR2 | (10) | Code of the unit. | |
VERSION_NUMBER | NUMBER | (3) | Version number of the unit for that the scheduling is planned. | |
UNIT_TITLE | VARCHAR2 | (90) | The name of the unit that is offered. | |
OWNER_ORG_UNIT_CD | VARCHAR2 | (30) | Identifier for the owner of the organizational unit section. | |
UNIT_CLASS | VARCHAR2 | (10) | Time and mode of availability of a class. | |
UNIT_SECTION_START_DATE | DATE | Start date of the unit section. | ||
UNIT_SECTION_END_DATE | DATE | End date of the unit section. | ||
UNIT_SECTION_STATUS | VARCHAR2 | (30) | Status of the unit section occurrence. For example, planned , inactive. | |
ENROLLMENT_MAXIMUM | NUMBER | (6) | Maximum number of enrollments for the unit section. | |
ENROLLMENT_ACTUAL | NUMBER | (6) | Actual number of enrollments for the unit section. | |
LOCATION_CD | VARCHAR2 | (10) | Code of the location where the unit section is held. | |
CAL_START_DT | DATE | Yes | Start Date of the Calendar Period | |
CAL_END_DT | DATE | Yes | End Date of the Calendar Period | |
UOO_ID | NUMBER | (7) | Yes | Unique identifier of unit section. |
TRANSACTION_ID | NUMBER | No Longer Used | ||
ORG_ID | NUMBER | (15) | Operating unit identifier | |
ENROLLMENT_EXPECTED | NUMBER | (6) | Enrollment Expected at unit section level. | |
OVERRIDE_ENROLLMENT_MAX | NUMBER | (6) | Maximum Enrollment Number at unit section level. | |
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 | |
IMPORT_DONE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the section has been imported to production. |
INT_PAT_ID | NUMBER | Unique identifier for a Unit Offering Pattern in scheduling interface. | ||
ABORT_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the section is ABORTED. |
CALL_NUMBER | NUMBER | Call Number value in the production table. | ||
SUBTITLE | VARCHAR2 | (90) | Subtitle of the unit section if exists else subtitle of the corresponding unit. | |
ORG_UNIT_DESCRIPTION | VARCHAR2 | (90) | Description of the organizational unit. | |
TEACHING_CAL_ALTERNATE_CODE | VARCHAR2 | (10) | Alternate code for the teaching calendar instance. |
Cut, paste (and edit) the following text to query this object:
SELECT INT_USEC_ID
, CALENDAR_TYPE
, SEQUENCE_NUMBER
, UNIT_CD
, VERSION_NUMBER
, UNIT_TITLE
, OWNER_ORG_UNIT_CD
, UNIT_CLASS
, UNIT_SECTION_START_DATE
, UNIT_SECTION_END_DATE
, UNIT_SECTION_STATUS
, ENROLLMENT_MAXIMUM
, ENROLLMENT_ACTUAL
, LOCATION_CD
, CAL_START_DT
, CAL_END_DT
, UOO_ID
, TRANSACTION_ID
, ORG_ID
, ENROLLMENT_EXPECTED
, OVERRIDE_ENROLLMENT_MAX
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, IMPORT_DONE_FLAG
, INT_PAT_ID
, ABORT_FLAG
, CALL_NUMBER
, SUBTITLE
, ORG_UNIT_DESCRIPTION
, TEACHING_CAL_ALTERNATE_CODE
FROM IGS.IGS_PS_SCH_USEC_INT_ALL;
IGS.IGS_PS_SCH_USEC_INT_ALL does not reference any database object
IGS.IGS_PS_SCH_USEC_INT_ALL is referenced by following:
|
|
|