| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 4 |
EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
A user's E-mail address
|
| 5 |
EMPLID_FROM |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 6 |
EMPLID_TO |
Character(11) |
VARCHAR2(11) NOT NULL |
EmplID
|
| 7 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
PV_ROLEDEFN_VW
|
| 8 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 9 |
MULTILANG |
Number(1,0) |
SMALLINT NOT NULL |
Used to determine if user is Multi-Lingual
|
| 10 |
OPERPSWD |
Character(32) |
VARCHAR2(32) NOT NULL |
An user's password
|
| 11 |
PV_BB_ACTION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field determines the Type of Action to be taken to the control tables
1 = Replace All (Delete all and then Impose everything from 7.5)
2 = Update Existing and Add new
3 = Just Add new rows
1=Replace All Rows
2=Update Existing and Add Rows
3=Add Only New Rows
Default Value: 1
|
| 12 |
PV_BB_CF_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Combination Edits
Y/N Table Edit
Default Value: N
|
| 13 |
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: 1
|
| 14 |
PV_BB_ITEM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Items
Y/N Table Edit
Default Value: N
|
| 15 |
PV_BB_MFG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Manufacturers
Y/N Table Edit
Default Value: N
|
| 16 |
PV_BB_SETID_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process SetIDs
Y/N Table Edit
Default Value: N
|
| 17 |
PV_BB_USER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Users
Y/N Table Edit
Default Value: N
|
| 18 |
PV_BB_VNDR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Suppliers
Y/N Table Edit
Default Value: N
|
| 19 |
PV_DBLINK |
Character(1) |
VARCHAR2(1) NOT NULL |
Link Type
E=FDM
H=HRMS
O=Other
|
| 20 |
PV_OPRID_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
1964660001 - Changed the long translate value of the field.
A=EMPLID
C=Custom
E=Use Complete Emplid
|
| 21 |
PV_SYMBOLICID_MIXD |
Character(8) |
VARCHAR2(8) NOT NULL |
Access Profile Symbolic Id
Prompt Table:
PSACCESSPRFL
|
| 22 |
SERVER |
Character(254) |
VARCHAR2(254) NOT NULL |
Server Address
|
| 23 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 24 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code SetID
Prompt Table:
PV_JC_SETID_VW
|
| 25 |
LOCATION_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Location Set ID
Prompt Table:
SP_SETID_NONVW
|
| 26 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOC_LOCSET_VW
|
| 27 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
Prompt Table:
BUS_UNIT_TBL_PM
|