| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 LEAD_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
|
| 2 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 3 |
SETID_PROV_GRP |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 4 |
PROVIDER_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Identification number for the provider group.
Prompt Table:
RF_PROVIDER_GRP
Set Control Field: BUSINESS_UNIT
|
| 5 |
ASSIGNED_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
This is a field to store assignment information.
Prompt Table:
RD_PERSON
Set Control Field: BUSINESS_UNIT
|
| 6 |
RC_CALL_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Outbound Marketing
CB=Call Back
CL=Close
NC=No Contact
|
| 7 |
RC_CALLBACK_DATE |
Date(10) |
DATE |
Outbound Marketing
|
| 8 |
RC_CALLBACK_TIME |
Time(15) |
TIMESTAMP |
Outbound Marketing field holding the time for a Prospect to be called back.
|
| 9 |
RC_REASON |
Character(2) |
VARCHAR2(2) NOT NULL |
Outbound Marketing
NA=Not Available
NR=No Response
WN=Wrong Number
|
| 10 |
RC_FINAL_DISPOSTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Outbound Marketing final disposition status field
DN=Do Not Call Again
GC=To Capture an Order
GL=Generate a Lead
NI=Not Interested
SA=Sale
SE=Send Collateral by Email
SM=Send Collateral by Mail
|
| 11 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 12 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 13 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 14 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 15 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 16 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|
| 17 |
DONE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Done Flag
|
| 18 |
RC_BS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Branch Script Status. It is ether Valid or Invalid.
C=Completed
P=Processing
S=Started
|
| 19 |
RT_USR_DISPOSTN |
Character(5) |
VARCHAR2(5) NOT NULL |
User disposition
Prompt Table:
RT_USR_DISPOSTN
|
| 20 |
LEAD_RATING |
Character(2) |
VARCHAR2(2) NOT NULL |
Used by Sales Force Automation to indicate the value (rating) of a lead, i.e. whether it's a Hot Lead or a Cold Lead.
Prompt Table:
RT_LE_RATE_VW
|
| 21 |
LEAD_RATE_CATEGORY |
Character(4) |
VARCHAR2(4) NOT NULL |
Lead Rating Category field indicates whether a particular lead rating is Qualified, Unqualified, etc.
QUAL=Qualified
UNQU=Unqualified
|
| 22 |
CAPTURE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Field use to store the capture ID in order capture.
|
| 23 |
SENT_TO_OCI_AGENT |
Character(1) |
VARCHAR2(1) NOT NULL |
indicator when Order Capture Agent has been sent this Prospect
|
| 24 |
RC_CALLBACK_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telemarketing Call Back phone number
|
| 25 |
RC_CB_PHONE_EXT |
Character(6) |
VARCHAR2(6) NOT NULL |
Telemarketing Call Back Phone Extensions
|
| 26 |
RC_CB_PHONE_TYPE |
Number(6,0) |
INTEGER NOT NULL |
Telemarketing Callback Phone Type
Prompt Table:
RC_CB_PHTYPE_VW
|
| 27 |
RC_CALLED_PHONE |
Character(40) |
VARCHAR2(40) NOT NULL |
Telemarketing Called Phone Number used in callback.
|
| 28 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Country Code values.
|