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_SPL_CONS_APPL

Object Details

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

IGS_AS_SPL_CONS_APPL describes occurrence of an application for special consideration.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_SPL_CONS_APPL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD UOO_ID ASS_ID CREATION_DT RECEIVED_DT
IGS_AS_SPL_CONS_APPL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SPCL_CONSIDERATION_CAT
IGS_AS_SPL_CONS_APPL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SPCL_CONSIDERATION_OUTCOME
IGS_AS_SPL_CONS_APPL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOUGHT_OUTCOME

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	A unique student information system identification number, typically incorporating a check digit, used to identify a particular person.
COURSE_CD	VARCHAR2	(6)	Yes	A code used to identify the program in which the student is enrolled.
UNIT_CD	VARCHAR2	(10)	Yes	The code used to identify the unit that special consideration application is being recorded.
CAL_TYPE	VARCHAR2	(10)	Yes	The teaching calendar that applies to the student unit attempt for the special consideration application is being made.
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	The teaching calendar sequence number.
ASS_ID	NUMBER	(10)	Yes	The unit assessment item ID for which the special consideration application is being recorded.
CREATION_DT	DATE		Yes	The date the assessment item was allocated to the student unit attempt.
RECEIVED_DT	DATE		Yes	The date the application for special consideration was received.
SPCL_CONSIDERATION_CAT	VARCHAR2	(10)	Yes	The category assigned to the special consideration application. A category typically identifies the basis for the application, and the degree to which the student is affected by the circumstance. For example, Meidcal, unable to complete.
SOUGHT_OUTCOME	VARCHAR2	(10)		The code used to identify the special consideration outcome that the student has identified as the desired result of their application. For example, successful application, speical examination granted.
SPCL_CONSIDERATION_OUTCOME	VARCHAR2	(10)		The result of the special consideration application. For example, unsuccessful application.
ESTIMATED_PROCESSING_DAYS	NUMBER	(2)		The expected number of days that it will take to process the special consideration application.
TRACKING_ID	NUMBER	(9)		The special consideration application tracking ID number.
COMMENTS	VARCHAR2	(2000)		A text facility for entering any additional comments associated with the special consideration application.
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
UOO_ID	NUMBER	(7)	Yes	Unit Section identifier
NOTIFIED_DATE	DATE			Date to indicate when a special consideration application outcome notification l

Query Text

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


SELECT PERSON_ID
,      COURSE_CD
,      UNIT_CD
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      ASS_ID
,      CREATION_DT
,      RECEIVED_DT
,      SPCL_CONSIDERATION_CAT
,      SOUGHT_OUTCOME
,      SPCL_CONSIDERATION_OUTCOME
,      ESTIMATED_PROCESSING_DAYS
,      TRACKING_ID
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      UOO_ID
,      NOTIFIED_DATE
FROM IGS.IGS_AS_SPL_CONS_APPL;

Dependencies

[top of page]

IGS.IGS_AS_SPL_CONS_APPL does not reference any database object

IGS.IGS_AS_SPL_CONS_APPL is referenced by following:

APPS: IGS_AS_SPL_CONS_APPL