PV_INTEGRATE(SQL Table) |
Index Back |
---|---|
Backbone Intelink Setup8/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 |