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