eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGS.IGS_CO_ITM_ALL

Object Details

Object Name:	IGS_CO_ITM_ALL
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_CO_ITM_ALL
Subobject Name:
Status:	VALID

IGS_CO_ITM describes correspondence items sent to students. These may be system-generated items or nonsystem-generated items that users have chosen to register against students.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_CO_ITM_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CORRESPONDENCE_TYPE REFERENCE_NUMBER
IGS_CO_ITM_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	REFERENCE_NUMBER
IGS_CO_ITM_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIGINATOR_PERSON_ID
IGS_CO_ITM_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COURSE_CD CV_VERSION_NUMBER
IGS_CO_ITM_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CAL_TYPE CI_SEQUENCE_NUMBER
IGS_CO_ITM_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNIT_CD UV_VERSION_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
CORRESPONDENCE_TYPE	VARCHAR2	(10)	Yes	The code of an institution-defined type of correspondence. Correspondence types can include system generated documents such as enrollmentwindows, fee invoices, and certificates of results, together with non-system generated documents such as university handbooks and teaching and learning materials.
REFERENCE_NUMBER	NUMBER	(6)	Yes	Describes a system generated reference number that identifies the correspondence item
CREATE_DT	DATE		Yes	Describes the date on which the correspondence item is created
S_JOB_NAME	VARCHAR2	(20)		Contains the name of the job producing the output
REQUEST_JOB_ID	NUMBER	(2)		Contains the job identifier of the output within a request. It allows the multiple instances of the same job name within a single request.
OUTPUT_NUM	NUMBER	(2)		Contains the number that identifies the request job output
REQUEST_JOB_RUN_ID	NUMBER	(10)		Contains an identifier for a job that has run within a request
CAL_TYPE	VARCHAR2	(10)		The abbreviated name of the type of calendar associated with, or used as a selection parameter for the job which produced the correspondence item.
CI_SEQUENCE_NUMBER	NUMBER	(6)		Describes the sequence number of the type of calendar associated with this correspondence item
COURSE_CD	VARCHAR2	(6)		The course code associated with, or used as a selection parameter for the job which produced the correspondence item.
CV_VERSION_NUMBER	NUMBER	(3)		Describes the version number of the course code associated with this correspondence item
UNIT_CD	VARCHAR2	(10)		The unit code associated with, or used as a selection parameter for the job which produced the correspondence item.
UV_VERSION_NUMBER	NUMBER	(3)		Describes the version number of the unit code associated with this correspondence item
COMMENTS	VARCHAR2	(2000)		A text facility for recording any comments associated with the correspondence item.
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
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record.
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program.
ORIGINATOR_PERSON_ID	NUMBER	(15)		The identification number of the person who, either ran the job which created the system generated correspondence, or is the originator of, or responsible for, the non-system generated correspondence.
REQUEST_NUM	NUMBER	(9)		This field contains the request number for which the job is run.
JOB_REQUEST_ID	NUMBER	(15)		Add concurrent manager review id
ORG_ID	NUMBER	(15)		Operating Unit Identifier

Query Text

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


SELECT CORRESPONDENCE_TYPE
,      REFERENCE_NUMBER
,      CREATE_DT
,      S_JOB_NAME
,      REQUEST_JOB_ID
,      OUTPUT_NUM
,      REQUEST_JOB_RUN_ID
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      COURSE_CD
,      CV_VERSION_NUMBER
,      UNIT_CD
,      UV_VERSION_NUMBER
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      ORIGINATOR_PERSON_ID
,      REQUEST_NUM
,      JOB_REQUEST_ID
,      ORG_ID
FROM IGS.IGS_CO_ITM_ALL;

Dependencies

[top of page]

IGS.IGS_CO_ITM_ALL does not reference any database object

IGS.IGS_CO_ITM_ALL is referenced by following:

APPS: IGS_CO_ITM_ALL