[Home] [Help] [Dependency Information]
Object Name: | IGS_CO_TYPE |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_CO_TYPE |
Subobject Name: | |
Status: | VALID |
IGS_CO_TYPE describes available system-defined correspondence types. These types represent system-generated correspondence.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_CO_TYPE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CORRESPONDENCE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CORRESPONDENCE_TYPE | VARCHAR2 | (10) | Yes | The code of an institution-defined type of correspondence. Correspondence types may include system generated documents such as enrollment windows, fee invoices, and certificates of results, together with non-system generated documents such as university handbooks and teaching and learning materials. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Describes an institution-defined type of correspondence. Correspondence typescan include system generated documents such as enrollment windows, fee invoices, and certificates of results, together with non-system generated documents such as university handbooks and teaching and learning materials. |
JOB_APPLICATION_ID | NUMBER | (15) | Job Application Identifier | |
JOB_PROGRAM_ID | NUMBER | (15) | Job Program Identifier | |
SYS_GENERATED_IND | VARCHAR2 | (1) | Yes | Indicates and specifies if the correspondence type is system generated or non-system generated. Selecting the checkbox signifies that the correspondence type is system generated. System generated correspondence types must be linked to one or more correspondence type job outputs. |
CLOSED_IND | VARCHAR2 | (1) | Yes | Indicates and specifies if the correspondence type is open or closed. Selecting the checkbox closes the correspondence type and prevents further allocation of the type to new or modified correspondence categories. Closing a correspondence type does not stop the generation of correspondence items of this type. |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT CORRESPONDENCE_TYPE
, DESCRIPTION
, JOB_APPLICATION_ID
, JOB_PROGRAM_ID
, SYS_GENERATED_IND
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_CO_TYPE;
IGS.IGS_CO_TYPE does not reference any database object
IGS.IGS_CO_TYPE is referenced by following:
|
|
|