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_USEC_REF

Object Details

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

IGS_PS_USEC_REF captures the relation between unit sections and unit section reference codes.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PS_USEC_REF_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	UNIT_SECTION_REFERENCE_ID
IGS_PS_USEC_REF_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	UOO_ID

Columns

Name	Datatype	Length	Mandatory	Comments
UNIT_SECTION_REFERENCE_ID	NUMBER		Yes	Unique identifier for the relation between unit sections and unit section reference code.
UOO_ID	NUMBER	(7)	Yes	Unique identifier for unit section.
SHORT_TITLE	VARCHAR2	(40)		Short title for unit section reference.
SUBTITLE	VARCHAR2	(80)		Obsolete- Subtitle for unit section reference.
SUBTITLE_MODIFIABLE_FLAG	VARCHAR2	(1)		Subtitle modifiable flag for unit section reference.
CLASS_SCHEDULE_EXCLUSION_FLAG	VARCHAR2	(1)		Class schedule exclusion flag for the unit section.
REGISTRATION_EXCLUSION_FLAG	VARCHAR2	(1)		Obsolete-Registration exclusion flag for the unit section reference.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield segment
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
RECORD_EXCLUSION_FLAG	VARCHAR2	(1)		Excludes unit section from displaying in self service records windows and on transcripts and excludes unit section from GPA calculation
TITLE	VARCHAR2	(90)		Title for the unit section
SUBTITLE_ID	NUMBER			The field is foreign key to IGS_PS_UNIT_SUBTITLE. Indicates the subtitle identifier for subtitle associated with the unit.

Query Text

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


SELECT UNIT_SECTION_REFERENCE_ID
,      UOO_ID
,      SHORT_TITLE
,      SUBTITLE
,      SUBTITLE_MODIFIABLE_FLAG
,      CLASS_SCHEDULE_EXCLUSION_FLAG
,      REGISTRATION_EXCLUSION_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RECORD_EXCLUSION_FLAG
,      TITLE
,      SUBTITLE_ID
FROM IGS.IGS_PS_USEC_REF;

Dependencies

[top of page]

IGS.IGS_PS_USEC_REF does not reference any database object

IGS.IGS_PS_USEC_REF is referenced by following:

APPS: IGS_PS_USEC_REF