Siebel Tools Reference > Special-Purpose Applets and Controls > File Attachment Applets >

Configuring Attachment Tables

Attachment tables provide the underlying data storage for the attachment business components. Unlike the attachment business component, which can support purposes in addition to file engine functionality, the attachment table stores file engine data only.

Users will not populate the attachment table directly. Rather, users are provided with an initially empty attachment table, and populate it one file at a time using drag and drop or the browser dialog box in the corresponding file attachment applet.

Table 55 lists the columns that appear in an attachment table. Note that the columns whose names begin with FILE_ are required columns, and must be named as specified in the table. The User Name values can be the same as or different from those listed.

Table 55.  File Columns in an Attachment Table
Name
Default
User Name
Type
Physical Type
Length
FILE_AUTO_UPD_FLG
 
File Auto Upd Flg
Data (Public)
Character
1
FILE_DATE
 
File Date
Data (Public)
Date Time
 
FILE_DEFER_FLG
 
File Defer Flg
Data (Public)
Character
1
FILE_DOCK_REQ_FLG
 
File Dock Req Flg
Data (Public)
Character
1
FILE_DOCK_STAT_FLG
 
File Dock Stat Flg
Data (Public)
Character
1
FILE_EXT
 
File Ext
Data (Public)
Varchar
10
FILE_NAME
 
File Name
Data (Public)
Varchar
255
FILE_REV_NUM
0
File Rev Num
Data (Public)
Varchar
15
FILE_SIZE
 
File Size
Data (Public)
Number
22
FILE_SRC_PATH
 
File Src Path
Data (Public)
Varchar
255
FILE_SRC_TYPE
 
File Src Type
Data (Public)
Varchar
30

Various system columns not related to the file engine will also be present, such as CREATED, LAST_UPD_BY, and ROW_ID.

A table that has file engine columns must be flagged as such with a TRUE value in the File property of the corresponding table object definition.


 Siebel Tools Reference
 Published: 20 October 2003