SERVER_IDD=Database server
F=FTP server
U=URL Server
Default Value: F
CS_SERVERS_VW(SQL View) |
Index Back |
|---|---|
Prompt for Server IDPrompt table to show only FTP type servers for attachments. Date Initials Issue Description 01/09/2007 cel 1601618000 Added for new Prompt table for server_id (override server on scmt installation page) |
| SELECT SERVER_ID , SERVER_TYPE FROM PS_PV_ATT_SERVERS WHERE SERVER_TYPE IN ('F','U') |
| # | 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 |