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

TABLE: IGS.IGS_CO_OU_CO_ALL

Object Details
Object Name: IGS_CO_OU_CO_ALL
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_CO_OU_CO_ALL
Subobject Name:
Status: VALID


IGS_CO_OU_CO describes link between person and correspondence item.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_CO_OU_CO_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ID
ColumnCORRESPONDENCE_TYPE
ColumnREFERENCE_NUMBER
ColumnISSUE_DT
IGS_CO_OU_CO_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCORRESPONDENCE_TYPE
ColumnREFERENCE_NUMBER
IGS_CO_OU_CO_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnADDR_TYPE
IGS_CO_OU_CO_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRACKING_ID
IGS_CO_OU_CO_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREFERENCE_NUMBER
Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (15) Yes Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
CORRESPONDENCE_TYPE VARCHAR2 (10) Yes The code of an institution-defined type of correspondence. Correspondence types can include system generated documents such as enrollments windows, fee invoices, and certificates of results, together with non-system generated documents.
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 that is the sent date can differ.
ADDR_TYPE VARCHAR2 (30)
Describes the address type to which the outgoing correspondence was sent
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 which creates the correspondence item.
COMMENTS VARCHAR2 (2000)
Contains any comments associated with the outgoing correspondence
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
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 enter the 'sent date.'
UNKNOWN_RETURN_DT DATE

Describes the date on which the correspondence was returned to sender. It indicates that the recipient no longer resides at the address to which the correspondence was sent.
LETTER_REFERENCE_NUMBER NUMBER (10)
Add letter reference number
SPL_SEQUENCE_NUMBER NUMBER (10)
Add Person letter sequence number
ORG_ID NUMBER (15)
Operating Unit Identifier
Query Text

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


SELECT PERSON_ID
,      CORRESPONDENCE_TYPE
,      REFERENCE_NUMBER
,      ISSUE_DT
,      ADDR_TYPE
,      TRACKING_ID
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      DT_SENT
,      UNKNOWN_RETURN_DT
,      LETTER_REFERENCE_NUMBER
,      SPL_SEQUENCE_NUMBER
,      ORG_ID
FROM IGS.IGS_CO_OU_CO_ALL;

Dependencies

[top of page]

IGS.IGS_CO_OU_CO_ALL does not reference any database object

IGS.IGS_CO_OU_CO_ALL is referenced by following:

SchemaAPPS
SynonymIGS_CO_OU_CO_ALL