[Home] [Help] [Dependency Information]
Object Name: | IGS_CO_INTERAC_HIST |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_CO_INTERAC_HIST |
Subobject Name: | |
Status: | VALID |
Interaction History
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_CO_INTERAC_HIST_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
IGS_CO_INTERAC_HIST_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DOCUMENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | (15) | Yes | Request ID |
STUDENT_ID | NUMBER | (15) | Yes | Student Identifier |
DOCUMENT_ID | NUMBER | (15) | Yes | Document ID |
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) | Sequence Number | |
COMP_STATUS | VARCHAR2 | (20) | Obsolete | |
CAL_TYPE | VARCHAR2 | (10) | Calendar Type | |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Calendar Sequence Number | |
DATE_SENT | DATE | Obsolete | ||
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 | |
DELIVERY_TYPE | VARCHAR2 | (30) | Yes | Delivery Type |
REQUESTED_DATE | DATE | Yes | Requested Date | |
VERSION_ID | NUMBER | Version Number of the Document Content Item that was sent as correspondence letter to the person. This is a new column and the upgrade script will default 1 for all the existing records in the table. |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, STUDENT_ID
, DOCUMENT_ID
, DOCUMENT_TYPE
, SYS_LTR_CODE
, ADM_APPLICATION_NUMBER
, NOMINATED_COURSE_CD
, SEQUENCE_NUMBER
, COMP_STATUS
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, DATE_SENT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DELIVERY_TYPE
, REQUESTED_DATE
, VERSION_ID
FROM IGS.IGS_CO_INTERAC_HIST;
IGS.IGS_CO_INTERAC_HIST does not reference any database object
IGS.IGS_CO_INTERAC_HIST is referenced by following:
|
|
|