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: IGF.IGF_AP_TD_ITEM_MST_ALL

Object Details

Object Name:	IGF_AP_TD_ITEM_MST_ALL
Object Type:	TABLE
Owner:	IGF
FND Design Data:	IGF.IGF_AP_TD_ITEM_MST_ALL
Subobject Name:
Status:	VALID

Holds the To Do Items

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_AP_TD_ITEM_MST_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TODO_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
TODO_NUMBER	NUMBER	(15)	Yes	Holds primary key column
ITEM_CODE	VARCHAR2	(10)	Yes	Holds the To do item code
CI_CAL_TYPE	VARCHAR2	(10)		Instance of calendar Type
CI_SEQUENCE_NUMBER	NUMBER	(15)		Sequence number of calendar Type Instance
DESCRIPTION	VARCHAR2	(30)	Yes	Holds the description of the ToDo Item
CORSP_MESG	VARCHAR2	(240)		Correspondence message to be sent to student for this todo item
CAREER_ITEM	VARCHAR2	(30)	Yes	Indicates whether this todo item is a career item. A career todo item is one which needs to be satisfied only once by the student through out his career.It cannot be tied to an award year.
REQUIRED_FOR_APPLICATION	VARCHAR2	(30)		Denotes whether fulfillment of this todo item is mandatory for the Completion of Application Processing.
FREQ_ATTEMPT	NUMBER	(15)		Indicates the frequency at which the correspondence should be sent to the student
MAX_ATTEMPT	NUMBER	(15)		Indicates the max number of time a correspondence should be sent to the student
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
ORG_ID	NUMBER	(15)		Operating unit identifier
SYSTEM_TODO_TYPE_CODE	VARCHAR2	(30)		System To Do Type
APPLICATION_CODE	VARCHAR2	(30)		Institutional Application to which the to do item is linked to
DISPLAY_IN_SS_FLAG	VARCHAR2	(1)		Indicates whether the to do item is displayed to the student in self service
SS_INSTRUCTION_TXT	VARCHAR2	(4000)		Instruction text that the student views in his to do list.
ALLOW_ATTACHMENT_FLAG	VARCHAR2	(1)		Indicates whether the student can attach documents to the to do item
DOCUMENT_URL_TXT	VARCHAR2	(240)		A URL pointing to a document that the student has to download and fill to complete the to do item

Query Text

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


SELECT TODO_NUMBER
,      ITEM_CODE
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      DESCRIPTION
,      CORSP_MESG
,      CAREER_ITEM
,      REQUIRED_FOR_APPLICATION
,      FREQ_ATTEMPT
,      MAX_ATTEMPT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      SYSTEM_TODO_TYPE_CODE
,      APPLICATION_CODE
,      DISPLAY_IN_SS_FLAG
,      SS_INSTRUCTION_TXT
,      ALLOW_ATTACHMENT_FLAG
,      DOCUMENT_URL_TXT
FROM IGF.IGF_AP_TD_ITEM_MST_ALL;

Dependencies

[top of page]

IGF.IGF_AP_TD_ITEM_MST_ALL does not reference any database object

IGF.IGF_AP_TD_ITEM_MST_ALL is referenced by following:

APPS: IGF_AP_TD_ITEM_MST_ALL