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

TABLE: IGS.IGS_PS_USEC_AS

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


IGS_PS_USEC_AS captures the relation between unit sections and assessments done in it.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_PS_USEC_AS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUNIT_SECTION_ASSESSMENT_ID
IGS_PS_USEC_AS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUOO_ID
ColumnFINAL_EXAM_DATE
ColumnLOCATION_CD
ColumnBUILDING_CODE
ColumnROOM_CODE
Columns
Name Datatype Length Mandatory Comments
UNIT_SECTION_ASSESSMENT_ID NUMBER
Yes Unique identifier for the relation between unit sections and assessments.
UOO_ID NUMBER (7) Yes Unit section identifier
FINAL_EXAM_DATE DATE

Date of the final examination
EXAM_START_TIME DATE
Yes Examination start time
EXAM_END_TIME DATE

Examination end time
LOCATION_CD VARCHAR2 (10) Yes Unique identifier for the location
BUILDING_CODE NUMBER

Building code
ROOM_CODE NUMBER

Room code
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_SECTION_ASSESSMENT_ID
,      UOO_ID
,      FINAL_EXAM_DATE
,      EXAM_START_TIME
,      EXAM_END_TIME
,      LOCATION_CD
,      BUILDING_CODE
,      ROOM_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_PS_USEC_AS;

Dependencies

[top of page]

IGS.IGS_PS_USEC_AS does not reference any database object

IGS.IGS_PS_USEC_AS is referenced by following:

SchemaAPPS
SynonymIGS_PS_USEC_AS