[Home] [Help] [Dependency Information]
Object Name: | IGS_PR_MILESTONE_TYP |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PR_MILESTONE_TYP |
Subobject Name: | |
Status: | VALID |
IGS_PR_MILESTONE_TYP describes the types of milestones that can be recorded against a research candidate.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PR_MILESTONE_TYP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | MILESTONE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MILESTONE_TYPE | VARCHAR2 | (10) | Yes | Describes the set of institution-defined type used to describe milestones. Examples are six monthly report, literature review report, project selection, conference presentation, draft thesis available, and miscellaneous. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Provides an explanation of the milestone types |
NTFCTN_IMMINENT_DAYS | NUMBER | (3) | The number of days prior to a milestone due date of this type to trigger notification of the imminent milestone. | |
NTFCTN_REMINDER_DAYS | NUMBER | (3) | The number of days after a milestone due date of this type to trigger a reminder notification. | |
NTFCTN_RE_REMINDER_DAYS | NUMBER | (3) | Number of days after a previous reminder for a milestone of the type to trigger another reminder notice. | |
CLOSED_IND | VARCHAR2 | (1) | Yes | Indicates and specifies if the milestone type is open or closed. Selecting the checkbox to 'closed' prevents use of the milestone type in new or modified records in other parts of the system. |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT MILESTONE_TYPE
, DESCRIPTION
, NTFCTN_IMMINENT_DAYS
, NTFCTN_REMINDER_DAYS
, NTFCTN_RE_REMINDER_DAYS
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_PR_MILESTONE_TYP;
IGS.IGS_PR_MILESTONE_TYP does not reference any database object
IGS.IGS_PR_MILESTONE_TYP is referenced by following:
|
|
|