| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
ABORT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Abort Process Flag
|
| 3 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 5 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 6 |
DBNAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Database Name
|
| 7 |
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
|
| 8 |
DIRTY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Dirty Flag
|
| 9 |
EMPLID_FROM |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 10 |
EMPLID_TO |
Character(11) |
VARCHAR2(11) NOT NULL |
EmplID
|
| 11 |
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 12 |
OPERPSWD |
Character(32) |
VARCHAR2(32) NOT NULL |
An user's password
|
| 13 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 14 |
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
|
| 15 |
PV_BB_CF_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Combination Edits
Y/N Table Edit
Default Value: N
|
| 16 |
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
|
| 17 |
PV_BB_ITEM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Items
Y/N Table Edit
Default Value: N
|
| 18 |
PV_BB_MFG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Manufacturers
Y/N Table Edit
Default Value: N
|
| 19 |
PV_BB_SETID_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process SetIDs
Y/N Table Edit
Default Value: N
|
| 20 |
PV_BB_USER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Users
Y/N Table Edit
Default Value: N
|
| 21 |
PV_BB_VNDR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Suppliers
Y/N Table Edit
Default Value: N
|
| 22 |
PV_DBLINK |
Character(1) |
VARCHAR2(1) NOT NULL |
Link Type
E=FDM
H=HRMS
O=Other
|
| 23 |
PV_DBLINK_NAME |
Character(60) |
VARCHAR2(60) NOT NULL |
Database Link Name
|
| 24 |
PV_DELETE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Selected
N=Replace Common Keys
Y=Replace All
|
| 25 |
PV_RECNAME_FLDLST |
Character(15) |
VARCHAR2(15) NOT NULL |
Fieldlist Recname
|
| 26 |
PV_SERVER_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Same Server?
|
| 27 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 28 |
RECNAME_SOURCE |
Character(15) |
VARCHAR2(15) NOT NULL |
Source Recname
|
| 29 |
RECNAME_TARGET |
Character(15) |
VARCHAR2(15) NOT NULL |
Target Recname
|
| 30 |
PV_CUSTOM_SQL |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom SQL?
Y/N Table Edit
Default Value: N
|
| 31 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 32 |
SERVER |
Character(254) |
VARCHAR2(254) NOT NULL |
Server Address
|
| 33 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 34 |
SUBRECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Subrecord (Table) Name
|
| 35 |
TABLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name
|
| 36 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 37 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 38 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 39 |
WHERE_CLAUSE3 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 40 |
SQL_STMT_254 |
Character(254) |
VARCHAR2(254) NOT NULL |
An internal work field that contains SQL text that is to be utilized in treasury application p
|
| 41 |
SQL_STMT |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|