| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
BO_ID |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
| 5 |
BO_ID_CM |
Number(31,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
| 6 |
CM_ID |
Number(31,0) |
DECIMAL(31) NOT NULL |
Contact Method ID
|
| 7 |
BO_REL_ID |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Relationship ID of a Business Object
|
| 8 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 9 |
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.
|
| 10 |
PROFILE_CM_SEQ_WK |
Number(31,0) |
DECIMAL(31) NOT NULL |
CM Profile Detail ID.............................................
|
| 11 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
|
| 12 |
COMPANYID |
Character(15) |
VARCHAR2(15) NOT NULL |
Company ID
|
| 13 |
SITE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
|
| 14 |
UPG_SITE_ID_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
Site ID Number
|
| 15 |
SITE_ID_OLD |
Character(15) |
VARCHAR2(15) NOT NULL |
Old site id
|
| 16 |
PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
|
| 17 |
NAME_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Business Object Name Type
|
| 18 |
START_DT |
Date(10) |
DATE |
Start date field to store start date value.
|
| 19 |
END_DT |
Date(10) |
DATE |
This field stores the end date values.
|
| 20 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer ID
|
| 21 |
CONTACT_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Customer Contact Type Code
|
| 22 |
ROLE_TYPE_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
Role Type ID
|
| 23 |
SRCH_GROUP_ID |
Number(6,0) |
INTEGER NOT NULL |
Search Group ID
|
| 24 |
REL_TYPE_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
Relationship Type ID
|
| 25 |
BO_REL_CATEGORY_ID |
Number(6,0) |
INTEGER NOT NULL |
Relationship Category ID
|
| 26 |
ROW_FIND |
Character(1) |
VARCHAR2(1) NOT NULL |
Find target row.
|
| 27 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 28 |
BO_ID_1 |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID 1
|
| 29 |
BO_ID_2 |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID 2
|
| 30 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 31 |
DRIVER_LICENCE |
Character(40) |
VARCHAR2(40) NOT NULL |
drivers license
|
| 32 |
DRIVER_L_STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Driver State
|
| 33 |
DRIVER_L_EXP_DATE |
Date(10) |
DATE |
DL Expiry Date
|
| 34 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Temp field.
|
| 35 |
SEARCH_DEFN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Search Definition ID
|
| 36 |
SEARCH_DOMAIN_ID |
Character(36) |
VARCHAR2(36) NOT NULL |
Search Domain ID
|
| 37 |
CM_USE_START_DT |
Date(10) |
DATE |
Contact Method Use Start Date
|
| 38 |
CM_USE_END_DT |
Date(10) |
DATE |
End date of a Contact Method Use
|
| 39 |
SEARCH_FIELD_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
Role Type ID
|
| 40 |
SITE_ID_2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
|
| 41 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number from Supply Chain Management.
Field size increased from 3 to 5 in CRM 8.95, as Supply Chain Management has increased the size to 5 in SCM 8.9 release.
|