eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGS.IGS_PS_SCH_PAT_INT

Object Details

Object Name:	IGS_PS_SCH_PAT_INT
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_PS_SCH_PAT_INT
Subobject Name:
Status:	VALID

Contains Unit Pattern information to be exported to third party scheduling interface. This is not used if there are records at the section level.The corresponding production table is IGS_PS_UNIT_OFR_PAT_ALL.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Export Scheduling Unit Offering pattern Detail
Category: BUSINESS_ENTITY IGS_UNIT

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PS_SCH_PAT_INT_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	INT_PAT_ID
IGS_PS_SCH_PAT_INT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNIT_CD VERSION_NUMBER CALENDAR_TYPE SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
INT_PAT_ID	NUMBER		Yes	Unique Identifier for each Unit Offering Pattern in the Scheduler Interface.
TRANSACTION_ID	NUMBER		Yes	Identifier for a transaction in scheduling interface
CALENDAR_TYPE	VARCHAR2	(10)	Yes	Calendar Type for the Unit Offering Pattern.
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Sequence Number for the Unit Offering Pattern
TEACHING_CAL_ALTERNATE_CODE	VARCHAR2	(10)		Alternate Code corresponding to the teaching calendar instance.
START_DATE	DATE		Yes	Start Date for the teaching calendar instance.
END_DATE	DATE		Yes	End Date for the teaching calendar instance.
UNIT_CD	VARCHAR2	(10)	Yes	Unit Code corresponding to the Unit Offering Pattern.
VERSION_NUMBER	NUMBER	(6)	Yes	Unit Version corresponding to the Unit Offering Pattern.
ENROLLMENT_EXPECTED	NUMBER			Enrollment Expected for the unit version.
ENROLLMENT_MAXIMUM	NUMBER			Enrollment maximum for the unit version.
OVERRIDE_ENROLLMENT_MAXIMUM	NUMBER	(6)		Override Enrollment maximum for the unit version
UNIT_STATUS	VARCHAR2	(10)		Status of the Unit Version.
ABORT_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the Unit Offering Pattern is ABORTED.
IMPORT_DONE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the Unit Offering Pattern has been imported to production.
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.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INT_PAT_ID
,      TRANSACTION_ID
,      CALENDAR_TYPE
,      SEQUENCE_NUMBER
,      TEACHING_CAL_ALTERNATE_CODE
,      START_DATE
,      END_DATE
,      UNIT_CD
,      VERSION_NUMBER
,      ENROLLMENT_EXPECTED
,      ENROLLMENT_MAXIMUM
,      OVERRIDE_ENROLLMENT_MAXIMUM
,      UNIT_STATUS
,      ABORT_FLAG
,      IMPORT_DONE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_PS_SCH_PAT_INT;

Dependencies

[top of page]

IGS.IGS_PS_SCH_PAT_INT does not reference any database object

IGS.IGS_PS_SCH_PAT_INT is referenced by following:

APPS: IGS_PS_SCH_PAT_INT