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 | DISTNODENAME | 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 |