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

TABLE: IGS.IGS_DA_OUT_PRG_USET

Object Details
Object Name: IGS_DA_OUT_PRG_USET
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_DA_OUT_PRG_USET
Subobject Name:
Status: VALID


IGS_DA_OUT_PRG_USET stores outgoing program unit set information on the programs found for the students selected in the request. --Obsolete


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_DA_OUT_PRG_USET_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
ColumnPERSON_ID
ColumnPROGRAM_SEQ_NUM
ColumnUNIT_SEQ_NUM
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER
Yes Identifies the parent request for data in the table.
PERSON_ID NUMBER (15) Yes Identifies student selected in request
PROGRAM_SEQ_NUM NUMBER
Yes Sequence id which serves as the "parent" program to its associated major(s), minor(s) and track/option(s).
UNIT_SEQ_NUM NUMBER
Yes Sequence id which helps to link the unit set code/version below to its associated information in this table
UNIT_SET_CODE VARCHAR2 (10)
Code of the student's requested or officially declared unit set.
UNIT_SET_VERSION NUMBER (3)
Version associated with the unit set code.
ORG_UNIT_SET_CODE VARCHAR2 (30)
Organizational unit responsible for the unit set code/version.
UNIT_SET_TITLE VARCHAR2 (90)
Title of unit set code/version.
UNIT_SET_CATEGORY VARCHAR2 (10)
Category of the unit set code/version can be major unit set, minor unit set, or track/option unit set. (Only those unit sets with the categories which were defined in the degree audit system profiles are listed in this table.
UNIT_SET_CATALOG VARCHAR2 (30)
Unit set catalog. References date for students requested or officially declared unit set(s) to identify the effective date(s) of the book which contains university-wide policy.
SELECTION_DATE DATE

If the parent program is for an officially declared program, date the unit set code/version above was selected by the student to be an officially declared unit set. This value is used to determine the unit set catalog.
PRIM_UNIT_SET VARCHAR2 (1)
If the parent program is for an officially declared program, indicates whether the unit set code/version above is the main one being officially pursued by the student.
PARENT_UNIT_SET_CODE VARCHAR2 (10)
Code for parent unit set associated with the unit set code/version.
PARENT_UNIT_SET_VERSION NUMBER (3)
Version associated with the parent unit set code.
PARENT_UNIT_SET_SEL_DATE DATE

If the parent program is for an officially declared program, date the parent unit set code/version was selected by the student to be an officially declared parent unit set.
UNIT_SET_COMPLETED VARCHAR2 (1)
If the parent program is for an officially declared program, indicates whether the unit set has been completed or not.Y indicates YES, N indicates NO.
UNIT_SET_COMP_DATE DATE

If the parent program is or an officially declared program, date the unit set was completed.
UNIT_SET_COMP_SOURCE VARCHAR2 (10)
Source of information that the unit set is complete.SYSTEM for system source, MANUAL for manual source.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Column Attribute cateogry
ATTRIBUTE1 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 1
ATTRIBUTE2 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 2
ATTRIBUTE3 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 9
ATTRIBUTE10 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 15
ATTRIBUTE16 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 16
ATTRIBUTE17 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 17
ATTRIBUTE18 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 18
ATTRIBUTE19 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 19
ATTRIBUTE20 VARCHAR2 (150)
Basic Unit Set Details Screen DDF Attribute 20
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
Query Text

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


SELECT BATCH_ID
,      PERSON_ID
,      PROGRAM_SEQ_NUM
,      UNIT_SEQ_NUM
,      UNIT_SET_CODE
,      UNIT_SET_VERSION
,      ORG_UNIT_SET_CODE
,      UNIT_SET_TITLE
,      UNIT_SET_CATEGORY
,      UNIT_SET_CATALOG
,      SELECTION_DATE
,      PRIM_UNIT_SET
,      PARENT_UNIT_SET_CODE
,      PARENT_UNIT_SET_VERSION
,      PARENT_UNIT_SET_SEL_DATE
,      UNIT_SET_COMPLETED
,      UNIT_SET_COMP_DATE
,      UNIT_SET_COMP_SOURCE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM IGS.IGS_DA_OUT_PRG_USET;

Dependencies

[top of page]

IGS.IGS_DA_OUT_PRG_USET does not reference any database object

IGS.IGS_DA_OUT_PRG_USET is referenced by following:

SchemaAPPS
SynonymIGS_DA_OUT_PRG_USET