SERVER_IDD=Database server
F=FTP server
U=URL Server
Default Value: F
N=Not currently active server
Y=Currently active server
Default Value: N
Default Value: 0
PV_ATT_SERVERS(SQL Table) |
Index Back |
|---|---|
Main table for file att serverMain table which holds all the information for configured file attachment servers. Stores both ftp and database server settings. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SERVER_ID |
Number(4,0) | SMALLINT NOT NULL | File Server ID |
| 2 | 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 Default Value: F |
| 3 | ATT_FTPSRV_LOGIN | Character(24) | VARCHAR2(24) NOT NULL | Login name for attachment ftp servers |
| 4 | ATT_FTPSRV_PASSWD | Character(254) | VARCHAR2(254) NOT NULL | Password for attachment ftp servers |
| 5 | 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 |
| 6 | 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. |
| 7 | DEFAULT_SERVER_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Marks which attachment server is currently active. Only one server is allowed to be marked "Y", all others must be "N".
N=Not currently active server Y=Currently active server Default Value: N |
| 8 | PV_URL_ID | Character(30) | VARCHAR2(30) NOT NULL | URL Identifier |
| 9 | ENCRYPTED | Number(1,0) | SMALLINT NOT NULL |
Encrypted Flag
Default Value: 0 |