PV_INTEGRATE_DT(SQL Table) |
Index Back |
|---|
| # | 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 Default Value: PV_INTEGRATE.PV_DBLINK |
| 2 | RECNAME_TARGET |
Character(15) | VARCHAR2(15) NOT NULL |
Target Recname
Prompt Table: PV_RECDEFN_VW |
| 3 | PV_BB_DATA_GROUP | Character(1) | VARCHAR2(1) NOT NULL |
Control Data Group
1 - All Control Data
2 - SetID-Related Data
3 - Business Unit Data
4 - Items
5 - Vendors
6 - Manufacturers
7 - Users
8 - General Control Data
1=All Control Data 2=SetID Based Control Data 3=Business Unit Based Data 4=Item Based Data 5=Supplier Based Data 6=Manufacturer Based Data 7=Users-Related Control Data 8=Combo Edit Based Data 9=All Other Data Default Value: 9 |
| 4 | PV_DELETE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Delete Selected
N=Replace Common Keys Y=Replace All Default Value: N |
| 5 | PV_FIELD_OVERRIDES | Character(254) | VARCHAR2(254) NOT NULL | Override Fields |
| 6 | PV_CUSTOM_SQL | Character(1) | VARCHAR2(1) NOT NULL |
Custom SQL?
Y/N Table Edit |
| 7 | PV_OVERRIDE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Override
Y/N Table Edit Default Value: N |
| 8 | PV_RECNAME_FLDLST | Character(15) | VARCHAR2(15) NOT NULL |
Fieldlist Recname
Prompt Table: PV_RECDEFN_VW |
| 9 | RECNAME_SOURCE | Character(15) | VARCHAR2(15) NOT NULL |
Source Recname
Prompt Table: PV_RECDEFN_VW |