[Home] [Help] [Dependency Information]
Object Name: | IGS_CO_INTERACTION_HISTORY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_CO_INTERACTION_HISTORY_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Interaction History
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier | |
REQUEST_ID | NUMBER | (15) | Yes | Request Identifier for the Document sent to the Student |
STUDENT_ID | NUMBER | (15) | Yes | Student Identifier |
DOCUMENT_ID | NUMBER | (15) | Yes | Document Identifier |
DOCUMENT_NAME | VARCHAR2 | (240) | Yes | Document Name |
DOCUMENT_TYPE | VARCHAR2 | (10) | Yes | Document Type |
SYS_LTR_CODE | VARCHAR2 | (10) | Yes | System Letter Code of the Document |
ADM_APPLICATION_NUMBER | NUMBER | (2) | Admission Application Number | |
NOMINATED_COURSE_CD | VARCHAR2 | (6) | Nominated Course Code | |
SEQUENCE_NUMBER | NUMBER | (6) | Application Sequence Number | |
COMP_STATUS | VARCHAR2 | (20) | Completion Status | |
CAL_TYPE | VARCHAR2 | (10) | Award Calendar Type | |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Award Calendar Sequence Number | |
START_DT | DATE | Award Start Date | ||
END_DT | DATE | Award End Date | ||
ALTERNATE_CODE | VARCHAR2 | (10) | Alternate Code for Award Year | |
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 | |
REQUESTED_DATE | DATE | Yes | Requested Date | |
DELIVERY_TYPE | VARCHAR2 | (30) | Yes | Delivery Type |
SENT_DATE | VARCHAR2 | (240) | Sent Date And Time | |
RESEND_FLAG | VARCHAR2 | (1) | Indicates the resend status | |
VERSION_ID | NUMBER | Version Information of the content item, for which the correspondence was sent. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, REQUEST_ID
, STUDENT_ID
, DOCUMENT_ID
, DOCUMENT_NAME
, DOCUMENT_TYPE
, SYS_LTR_CODE
, ADM_APPLICATION_NUMBER
, NOMINATED_COURSE_CD
, SEQUENCE_NUMBER
, COMP_STATUS
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, START_DT
, END_DT
, ALTERNATE_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUESTED_DATE
, DELIVERY_TYPE
, SENT_DATE
, RESEND_FLAG
, VERSION_ID
FROM APPS.IGS_CO_INTERACTION_HISTORY_V;
|
|
|