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_AS_DUE_DT_SUMRY

Object Details

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

IGS_AS_DUE_DT_SUMRY describes assessment due dates summary.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_DUE_DT_SUMRY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SESSION_ID	NUMBER		Yes	Describes session Identifier within the selected examination calendar.
AT_ID	NUMBER	(9)		Attempt identifier
UNIT_CD	VARCHAR2	(10)	Yes	Unit code
VERSION_NUMBER	NUMBER	(3)	Yes	Version number
CAL_TYPE	VARCHAR2	(10)	Yes	Calendar type
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Calendar instance sequence number
OWNER_ORG_UNIT_CD	VARCHAR2	(30)	Yes	Unit code from owning organization unit
OWNER_OU_START_DT	DATE			Start date of owning organization unit
UNIT_MODE	VARCHAR2	(10)	Yes	Unit mode
ASS_ID	NUMBER	(10)	Yes	Assessment Identifier
WEEK_ENDING_DT	DATE		Yes	Week ending date
BASE_COUNT	NUMBER			Base count of number of attempts
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
EXPECTED_OVERDUE_COUNT	NUMBER			Expected over due count
ONE_WEEK_EXTENSION_COUNT	NUMBER			Count of one week extensions
TWO_WEEK_EXTENSION_COUNT	NUMBER			Count of two week extensions
THREE_WEEK_PLUS_EXTNSN_COUNT	NUMBER			Count of three week extensions
RECEIVED_COUNT	NUMBER			Received count
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record.
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program.

Query Text

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


SELECT SESSION_ID
,      AT_ID
,      UNIT_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      OWNER_ORG_UNIT_CD
,      OWNER_OU_START_DT
,      UNIT_MODE
,      ASS_ID
,      WEEK_ENDING_DT
,      BASE_COUNT
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      EXPECTED_OVERDUE_COUNT
,      ONE_WEEK_EXTENSION_COUNT
,      TWO_WEEK_EXTENSION_COUNT
,      THREE_WEEK_PLUS_EXTNSN_COUNT
,      RECEIVED_COUNT
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_AS_DUE_DT_SUMRY;

Dependencies

[top of page]

IGS.IGS_AS_DUE_DT_SUMRY does not reference any database object

IGS.IGS_AS_DUE_DT_SUMRY is referenced by following:

APPS: IGS_AS_DUE_DT_SUMRY