EOATT_CFG_A_DTL(SQL Table) |
Index Back |
---|---|
File Server DetailsComments and Attachments View only Framework File Attachment Server Detail Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EOATT_CONFIG_ID | Character(20) | VARCHAR2(20) NOT NULL | Configuration ID |
2 | EOATT_SERVER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
One of type ftp or DB, marks each registered attachment server.
D=Database server F=FTP server U=URL Server |
3 | EOATT_DFLT_SERVER | Character(1) | VARCHAR2(1) NOT NULL |
Default Server
Y/N Table Edit Default Value: Y |
4 | EOATT_FTPSRV_LOGIN | Character(24) | VARCHAR2(24) NOT NULL | Login name for attachment ftp servers |
5 | EOATT_FTPSRV_PWD | Character(100) | VARCHAR2(100) NOT NULL | Password for attachment ftp servers |
6 | EOATT_ATT_SRV_NAME | Character(254) | VARCHAR2(254) NOT NULL | Name of attachment server, if it is an ftp server; name of the database record which holds attached files, if attachments are to be stored in the database |
7 | EOATT_SERVER_PATH | Character(254) | VARCHAR2(254) NOT NULL | For attached files already uploaded to an ftp server, the path under the ftp root directory in which the file is to be found. |
8 | EOATT_URL_ID | Character(30) | VARCHAR2(30) NOT NULL | URL Identifier |