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

TABLE: IGS.IGS_PS_UNIT_DSCP

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


IGS_PS_UNIT_DSCP describes the discipline areas in a unit that is taught. If required a percentage allocation can be used across multiple discipline groups.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_PS_UNIT_DSCP_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUNIT_CD
ColumnVERSION_NUMBER
ColumnDISCIPLINE_GROUP_CD
IGS_PS_UNIT_DSCP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDISCIPLINE_GROUP_CD
Columns
Name Datatype Length Mandatory Comments
UNIT_CD VARCHAR2 (10) Yes Code of the unit to that a discipline group is allocated.
VERSION_NUMBER NUMBER (3) Yes Version number of the unit to that a discipline group is allocated.
DISCIPLINE_GROUP_CD VARCHAR2 (4) Yes Discipline group code. Discipline groups are used to classify units of study in terms of the subject matter being taught and or researched.
PERCENTAGE NUMBER (5) Yes Describes the percentage allocation of unit discipline for a unit.
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 UNIT_CD
,      VERSION_NUMBER
,      DISCIPLINE_GROUP_CD
,      PERCENTAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_PS_UNIT_DSCP;

Dependencies

[top of page]

IGS.IGS_PS_UNIT_DSCP does not reference any database object

IGS.IGS_PS_UNIT_DSCP is referenced by following:

SchemaAPPS
SynonymIGS_PS_UNIT_DSCP