PV_INTEGRATE

(SQL Table)
Index Back

Backbone Intelink Setup

8/30/07 - JK - Added Record Description.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PV_DBLINK Character(1) VARCHAR2(1) NOT NULL Link Type
E=FDM
H=HRMS
O=Other
2 PV_SERVER_SW Character(1) VARCHAR2(1) NOT NULL Same Server?

Y/N Table Edit

Default Value: N

3 SERVER Character(254) VARCHAR2(254) NOT NULL Server Address
4 DBTYPE Character(1) VARCHAR2(1) NOT NULL Database Type
0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/UNIX
5=AllBase
6=Sybase
7=Microsoft
8=DB2/400
5 DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
6 PV_DBLINK_NAME Character(60) VARCHAR2(60) NOT NULL Database Link Name