CDM_DIST_NODE(SQL Table) |
Index Back |
|---|---|
Content Dist Mgr - Dist NodeThis table contains all the information to define a Content Distribution Node. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(15) | VARCHAR2(15) NOT NULL | Report Distribution Node Name | |
| 2 | PT_TRANSFR_PROTCOL | Character(15) | VARCHAR2(15) NOT NULL | Transfer Protocol |
| 3 | OPSYS | Character(1) | VARCHAR2(1) NOT NULL |
Operating System
0=DOS 1=NT/Win95 Client 2=Windows 3=OS/2 4=UNIX 5=VMS 6=MPE/XL 7=OS390 8=NT 9=OS/400 Default Value: 2 Prompt Table: CDM_OPSYS_VW |
| 4 | FTPID | Character(30) | VARCHAR2(30) NOT NULL | Network ID used for File Transfer Protocol |
| 5 | OPERPSWD | Character(32) | VARCHAR2(32) NOT NULL | An user's password |
| 6 | FTPADDRESS | Character(75) | VARCHAR2(75) NOT NULL | File Transfer Protocol site address |
| 7 | FTPDIRECTORY | Character(254) | VARCHAR2(254) NOT NULL | File Transfer Protocol directory |
| 8 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 9 | WINNETWORKPATH | Character(100) | VARCHAR2(100) NOT NULL | Windows NetWork Path |
| 10 | DIRLOCATION | Character(254) | VARCHAR2(254) NOT NULL | Directory Network Location |
| 11 | DESCRLONG | Long Character | CLOB | Long Description |
| 12 | URI_HOST | Character(75) | VARCHAR2(75) NOT NULL | URI Host |
| 13 | URI_PORT | Number(5,0) | INTEGER NOT NULL | URI Port |
| 14 | URI_QUERY | Character(100) | VARCHAR2(100) NOT NULL | URI Query |
| 15 | URI_RESOURCE | Character(100) | VARCHAR2(100) NOT NULL | URI Resource |
| 16 | URI_SCHEME | Character(5) | VARCHAR2(5) NOT NULL | URI Scheme |
| 17 | URI_RPT | Character(254) | VARCHAR2(254) NOT NULL | URI for Report |
| 18 | CDM_DIR_TEMPLATE | Character(254) | VARCHAR2(254) NOT NULL | File Transfer Protocol directory |
| 19 | PTCDMKEYE | Character(254) | VARCHAR2(254) NOT NULL | Encrypted Key |
| 20 | PTCDMSTRE | Character(254) | VARCHAR2(254) NOT NULL | Confirm Password |