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_UNITASS_ITEM_L7R

Object Details

Object Name:	IGS_PS_UNITASS_ITEM_L7R
Object Type:	TABLE
Owner:	IGS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory
UNIT_SECTION_ASS_ITEM_ID	NUMBER		Yes
UOO_ID	NUMBER	(7)	Yes
ASS_ID	NUMBER	(10)	Yes
SEQUENCE_NUMBER	NUMBER	(6)	Yes
CI_START_DT	DATE		Yes
CI_END_DT	DATE		Yes
UNIT_CLASS	VARCHAR2	(10)
UNIT_MODE	VARCHAR2	(10)
LOCATION_CD	VARCHAR2	(10)
DUE_DT	DATE
REFERENCE	VARCHAR2	(30)
DFLT_ITEM_IND	VARCHAR2	(1)	Yes
LOGICAL_DELETE_DT	DATE
ACTION_DT	DATE
EXAM_CAL_TYPE	VARCHAR2	(10)
EXAM_CI_SEQUENCE_NUMBER	NUMBER	(6)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
GRADING_SCHEMA_CD	VARCHAR2	(10)	Yes
GS_VERSION_NUMBER	NUMBER	(3)	Yes
RELEASE_DATE	DATE
DESCRIPTION	VARCHAR2	(180)
US_ASS_ITEM_GROUP_ID	NUMBER	(15)
MIDTERM_MANDATORY_TYPE_CODE	VARCHAR2	(30)
MIDTERM_WEIGHT_QTY	NUMBER	(6)
FINAL_MANDATORY_TYPE_CODE	VARCHAR2	(30)
FINAL_WEIGHT_QTY	NUMBER	(6)

Query Text

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


SELECT UNIT_SECTION_ASS_ITEM_ID
,      UOO_ID
,      ASS_ID
,      SEQUENCE_NUMBER
,      CI_START_DT
,      CI_END_DT
,      UNIT_CLASS
,      UNIT_MODE
,      LOCATION_CD
,      DUE_DT
,      REFERENCE
,      DFLT_ITEM_IND
,      LOGICAL_DELETE_DT
,      ACTION_DT
,      EXAM_CAL_TYPE
,      EXAM_CI_SEQUENCE_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
,      RELEASE_DATE
,      DESCRIPTION
,      US_ASS_ITEM_GROUP_ID
,      MIDTERM_MANDATORY_TYPE_CODE
,      MIDTERM_WEIGHT_QTY
,      FINAL_MANDATORY_TYPE_CODE
,      FINAL_WEIGHT_QTY
FROM IGS.IGS_PS_UNITASS_ITEM_L7R;

Dependencies

[top of page]

IGS.IGS_PS_UNITASS_ITEM_L7R does not reference any database object

IGS.IGS_PS_UNITASS_ITEM_L7R is referenced by following:

APPS: IGS_PS_UNITASS_ITEM_L7R