[Home] [Help] [Dependency Information]
Object Name: | IGS_EN_NOTE_TYPE |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_EN_NOTE_TYPE |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
This view maintains all the note types that are associated with each system specific enrolment note type for example academic type of enrolment.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ORG_ID | NUMBER | (15) | Operating Unit Identifier. | |
ENR_NOTE_TYPE | VARCHAR2 | (10) | Yes | An institution-defined note type relating to a student course attempt. |
DESCRIPTION | VARCHAR2 | (60) | Yes | The description of an institution-defined note type relating to a student course attempt. |
S_ENR_NOTE_TYPE | VARCHAR2 | (30) | A system-defined note type relating to a student course attempt. | |
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 ROW_ID
, ORG_ID
, ENR_NOTE_TYPE
, DESCRIPTION
, S_ENR_NOTE_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_EN_NOTE_TYPE;
|
|
|