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]

VIEW: APPS.IGS_CO_OU_CO_V

Object Details

Object Name:	IGS_CO_OU_CO_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_CO_OU_CO_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view joins all references for an outgoing correspondence item.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Identifier
PERSON_ID	NUMBER	(15)	Yes	Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number
CORRESPONDENCE_CAT	VARCHAR2	(4000)		The correspondence category applicable to the student's course attempt. Correspondence categories are used to define the set of system generated and non-system originated correspondence items that will be sent to the student.
CORRESPONDENCE_TYPE	VARCHAR2	(10)	Yes	The code of an institution-defined type of correspondence. Correspondence types can include system generated documents such as enrolment forms, 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
ISSUE_DT	DATE		Yes	Describes the date the outgoing correspondence was created. Particularly relevant to system-generated correspondence, if the issue date and the actual date of posting, sent date can differ.
DT_SENT	DATE			Describes the date a correspondence item was sent . For non-system generated correspondence, the 'sent date' defaults to the same date as the 'issue date.' For system generated correspondence, a batch job operates to record the 'sent date.'
UNKNOWN_RETURN_DT	DATE			Describes the date the correspondence was returned to sender. It indicates that the recipient no longer resides at the address the correspondence was sent.
ADDR_TYPE	VARCHAR2	(30)		Describes the address type to the outgoing correspondence that was sent
COMMENTS	VARCHAR2	(2000)		Comments
LETTER_REFERENCE_NUMBER	NUMBER	(10)		Letter Reference Number
SPL_SEQUENCE_NUMBER	NUMBER	(10)		Special Sequence Number
ADT_DESCRIPTION	VARCHAR2	(80)		The description of an institution-defined address type. An address type is a classification of addresses. Each address recorded in the system must be assigned an address type. Examples of address types include Home, Postal, and Campus.
TRACKING_ID	NUMBER	(6)		Links the outgoing correspondence to a tracking item. For system generated correspondence, the creation of a tracking ID is an parameter option of the job that creates the correspondence item.
CREATE_DT	DATE		Yes	Describes the date the correspondence item is created
ORIGINATOR_PERSON_ID	NUMBER	(15)		The identification number of the person who, either ran the job that created the system generated correspondence, or is the originator of, or responsible for, the non-system generated correspondence.
REQUEST_NUM	NUMBER	(9)		Contains the request number for the job that is run
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 for 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 calendar type of the calendar instance in the unit that is offered. Units can only be offered in instances of calendar types that are categorised as Teaching calendars. For example, SEM - 1 semester 1 teaching period, SEM - 2 semester 2 teaching period, and SUM summer teaching period.
CI_SEQUENCE_NUMBER	NUMBER			Unique identifier for the calendar instance
COURSE_CD	VARCHAR2	(6)		Unique identifier for the program
CV_VERSION_NUMBER	NUMBER			The version number of the program. There can only be one version of a program with a system status of Active and an unset Expiry Date.
UNIT_CD	VARCHAR2	(10)		The unique identifier of the unit
UV_VERSION_NUMBER	NUMBER			The version number of the unit. Students are normally enrolled in the current version. Prior versions are end-dated.
S_OTHER_REFERENCE_TYPE	VARCHAR2	(30)		The system defined other reference types. The other reference types are attached to this.
OTHER_REFERENCE	VARCHAR2	(60)		Any reference not specific to a calendar instance, program version or unit version.
OC_COMMENTS	VARCHAR2	(2000)		Contains any comments associated with the outgoing correspondence
CORI_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

Query Text

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


SELECT ROW_ID
,      PERSON_ID
,      PERSON_NUMBER
,      CORRESPONDENCE_CAT
,      CORRESPONDENCE_TYPE
,      REFERENCE_NUMBER
,      ISSUE_DT
,      DT_SENT
,      UNKNOWN_RETURN_DT
,      ADDR_TYPE
,      COMMENTS
,      LETTER_REFERENCE_NUMBER
,      SPL_SEQUENCE_NUMBER
,      ADT_DESCRIPTION
,      TRACKING_ID
,      CREATE_DT
,      ORIGINATOR_PERSON_ID
,      REQUEST_NUM
,      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
,      S_OTHER_REFERENCE_TYPE
,      OTHER_REFERENCE
,      OC_COMMENTS
,      CORI_COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_CO_OU_CO_V;

Dependencies

[top of page]

APPS.IGS_CO_OU_CO_V references the following:

APPS: IGS_CO_ADDR_TYPE; IGS_CO_GEN_001 - show dependent code; IGS_CO_ITM; IGS_CO_OU_CO; IGS_CO_OU_CO_REF; IGS_EN_GEN_003 - show dependent code; IGS_EN_GEN_007 - show dependent code; IGS_PE_PERSON

APPS.IGS_CO_OU_CO_V is referenced by following:

APPS: IGS_CO_GEN_001 - show dependent code; IGS_CO_GEN_002 - show dependent code