CDM_DIST_NODE

(SQL Table)
Index Back

Content Dist Mgr - Dist Node

This 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