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

TABLE: IGF.IGF_AP_ST_CORR_TEXT

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


Holds the Custom correspondence to each student


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_AP_ST_CORR_TEXT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCORSP_ID
Columns
Name Datatype Length Mandatory Comments
CORSP_ID NUMBER (15) Yes System generated primary key column.
BASE_ID NUMBER (15) Yes Unique identifier for student financial aid record
CUSTOM_TEXT VARCHAR2 (2000) Yes Custom correspondence message to be sent to student. The student will get letter which will have custom message along with the message text for each to do item present for the student.
RUN_DATE DATE

Holds the date on which the correspondence was run. This will be populated by the correspondence process
ACTIVE VARCHAR2 (1) Yes Indicates if the custom_text is active for the student. An active custom text is added to the student correspondence by correspondence process.
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
Query Text

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


SELECT CORSP_ID
,      BASE_ID
,      CUSTOM_TEXT
,      RUN_DATE
,      ACTIVE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGF.IGF_AP_ST_CORR_TEXT;

Dependencies

[top of page]

IGF.IGF_AP_ST_CORR_TEXT does not reference any database object

IGF.IGF_AP_ST_CORR_TEXT is referenced by following:

SchemaAPPS
SynonymIGF_AP_ST_CORR_TEXT