RCS_ATTACHMENTS_INT
This is an interface table for staging the attachment related information. Attachments information will be used to load the attachments to entities in bulk and thereafter data will be purged from this table.
Details
-
Schema: FUSION
-
Object owner: RCS
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
RCS_ATTACHMENTS_INT_PK |
ATTACHMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ATTACHMENT_ID | NUMBER | 18 | Yes | Attachment interface record unique identifier. | |
| LOAD_REQUEST_ID | NUMBER | 18 | Yes | Indicates the id of the job that loaded the rows into the interface table. | |
| ATTACHMENT_TYPE | VARCHAR2 | 5 | Yes | Indicates the type of attachment that needs to created. Valid values: File, Text, URL. | |
| ATTACHMENT_NAME | VARCHAR2 | 2048 | Yes | Indicates name of the attachment. | |
| ATTACHMENT_ZIP | VARCHAR2 | 80 | Identifies the .ZIP files that contains files for File type attachments. This column is designed to accept only the .ZIP file name and not a path. | ||
| DOCUMENT_ID | NUMBER | 18 | Value that uniquely identifies the UCM attached document. | ||
| ATTACHMENT_TITLE | VARCHAR2 | 80 | Indicates the title of attachment. | ||
| ATTACHMENT_DESCRIPTION | VARCHAR2 | 255 | Identifies the attachment description. | ||
| ENTITY_NAME | VARCHAR2 | 40 | Yes | Identifies the entity of attachment that needs to be created. | |
| CATEGORY_NAME | VARCHAR2 | 30 | Yes | Identifies the category of attachment that needs to be created. | |
| BATCH_ID | VARCHAR2 | 512 | An optional identifier, if provided while scheduling an import process is used to identify which interface table records will be picked up for processing. | ||
| USER_KEY1 | VARCHAR2 | 512 | Yes | User key input1 to retrieve the key value. | |
| USER_KEY2 | VARCHAR2 | 512 | User key input2 to retrieve the key value. | ||
| USER_KEY3 | VARCHAR2 | 512 | User key input3 to retrieve the key value. | ||
| USER_KEY4 | VARCHAR2 | 512 | User key input4 to retrieve the key value. | ||
| USER_KEY5 | VARCHAR2 | 512 | User key input5 to retrieve the key value. | ||
| STATUS | VARCHAR2 | 30 | Yes | Indicates the import status of the attachment interface record. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RCS_ATTACHMENTS_INT_N1 | Non Unique | Default | LOAD_REQUEST_ID |
| RCS_ATTACHMENTS_INT_U1 | Unique | Default | ATTACHMENT_ID |