| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
ROW_COUNT_1 |
Number(12,0) |
DECIMAL(12) NOT NULL |
Row counter
|
| 4 |
ROW_COUNT_2 |
Number(12,0) |
DECIMAL(12) NOT NULL |
Row counter
|
| 5 |
ROW_COUNT_3 |
Number(12,0) |
DECIMAL(12) NOT NULL |
Row counter
|
| 6 |
ROW_COUNT_4 |
Number(12,0) |
DECIMAL(12) NOT NULL |
Row counter
|
| 7 |
ROW_COUNT_5 |
Number(12,0) |
DECIMAL(12) NOT NULL |
Row counter
|
| 8 |
ROW_COUNT_6 |
Number(12,0) |
DECIMAL(12) NOT NULL |
Row counter
|
| 9 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field for Hiding Groups
|
| 10 |
RBTACCTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Unique service account indentifier
|
| 11 |
BO_ID |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
| 12 |
RBTCUST_BO_ID |
Number(31,0) |
DECIMAL(31) NOT NULL |
Customer BO ID
|
| 13 |
ROLE_TYPE_ID_CUST |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the customer
|
| 14 |
RBTCONT_BO_ID |
Number(31,0) |
DECIMAL(31) NOT NULL |
Contact BO ID
|
| 15 |
ROLE_TYPE_ID_CNTCT |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the contact
|
| 16 |
BO_ID_MGR |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Manager BO_ID for Change Management
|
| 17 |
BO_ID_2 |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID 2
|
| 18 |
BO_REL_ID |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Relationship ID of a Business Object
|
| 19 |
RSEC_PROFILE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
A unique identifier of security profile for application security.
|
| 20 |
RSEC_MEMBER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Security Membership ID for application security membership definition.
|
| 21 |
RSEC_VIEW_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Unique identifier of a view list used in application security.
|
| 22 |
PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
|
| 23 |
RSEC_REL_SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The related synchronization id stores the syncid of the primary record of the security object. This field is used in creating the security list record.
|
| 24 |
RSEC_LIST_COUNT |
Number(15,0) |
DECIMAL(15) NOT NULL |
This field is used to store the count of all the list members in a security list table. The security list tables can be either membership or view privilege list tables.
|
| 25 |
RBTSTDATE |
Date(10) |
DATE |
Start Date
|
| 26 |
PROFILE_CM_SEQ |
Number(31,0) |
DECIMAL(31) NOT NULL |
The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.
|
| 27 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 28 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 29 |
CM_ID |
Number(31,0) |
DECIMAL(31) NOT NULL |
Contact Method ID
|