DBA Data[Home] [Help] [Dependency Information]

TABLE: IGF.IGF_AP_OUTCORR_WF

Object Details
Object Name: IGF_AP_OUTCORR_WF
Object Type: TABLE
Owner: IGF
FND Design Data: TableIGF.IGF_AP_OUTCORR_WF
Subobject Name:
Status: VALID


Holds the transaction numbers for correction ISIR records that are not initiated by the school. It is used to hold the data elements that are needed to build the message body for the notifications to be sent through work flow


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_AP_OUTCORR_WF_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOW_ID
Columns
Name Datatype Length Mandatory Comments
OW_ID NUMBER (15) Yes Sequence generated primary key identifier.
PERSON_NUMBER VARCHAR2 (30)
Holds the person number to whom the correction ISIR belongs
GIVEN_NAMES VARCHAR2 (301)
Name of the student to whom the correction ISIR belongs
TRANSACTION_NUMBER VARCHAR2 (13)
It is a unique identifier for an ISIR
ITEM_KEY VARCHAR2 (80)
Holds the value of the item key to attach the data attributes to the message body
CREATED_BY NUMBER (15)
Standard WHO Column
CREATION_DATE DATE

Standard WHO Column
LAST_UPDATED_BY NUMBER (15)
Standard WHO Column
LAST_UPDATE_DATE DATE

Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
Query Text

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


SELECT OW_ID
,      PERSON_NUMBER
,      GIVEN_NAMES
,      TRANSACTION_NUMBER
,      ITEM_KEY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGF.IGF_AP_OUTCORR_WF;

Dependencies

[top of page]

IGF.IGF_AP_OUTCORR_WF does not reference any database object

IGF.IGF_AP_OUTCORR_WF is referenced by following:

SchemaAPPS
SynonymIGF_AP_OUTCORR_WF