| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
LEAD_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
Default Value: NEXT
|
| 4 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_RSF_NONVW
|
| 6 |
PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
Prompt Table:
RSF_USER_BU_VW
|
| 7 |
SALES_USER_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Sales User Name field
|
| 8 |
PERSON_ID_PARTNER |
Character(15) |
VARCHAR2(15) NOT NULL |
Partner Rep
Prompt Table:
RSF_PARNTCONTVW
|
| 9 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
|
| 10 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer ID
|
| 11 |
BO_ID_CUST |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field stores the Business Object ID for the customer.
|
| 12 |
ROLE_TYPE_ID_CUST |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the customer
Default Value: 2
Prompt Table:
RSF_BO_ROLTY_VW
|
| 13 |
BO_ID_SITE |
Number(31,0) |
DECIMAL(31) NOT NULL |
Business Object ID
Prompt Table:
RD_SITE_VW
|
| 14 |
ROLE_TYPE_ID_SITE |
Number(12,0) |
DECIMAL(12) NOT NULL |
Role Type ID
|
| 15 |
BO_ID_PERSON |
Number(31,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
| 16 |
ROLE_TYPE_ID_USER |
Number(12,0) |
DECIMAL(12) NOT NULL |
Self service user role type id
|
| 17 |
BO_ID_PARTNER |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID of Partner Company.
Prompt Table:
RSF_BO_PARTN_VW
|
| 18 |
ROLE_TYPE_ID_PART |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the partner
|
| 19 |
BO_ID_PART_CONT |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
This is the business object identifier for the partner contact.
|
| 20 |
ROLE_TYPE_ID_PARTC |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the partner contact
|
| 21 |
BO_ID_REFERRED_BY |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID of Referred By (for Partners).
|
| 22 |
ROLE_TYPE_ID_RFRL |
Number(12,0) |
DECIMAL(12) NOT NULL |
This field holds the role type identifier for the referred by business object.
Default Value: 5
|
| 23 |
BO_ID_CONTACT |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field indicates the Business Object ID for the contact.
|
| 24 |
NAME1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Generic 50 character name field for storing names.
|
| 25 |
SITE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Site Name
|
| 26 |
ROLE_TYPE_ID_WORK |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the customer
Default Value: 5
|
| 27 |
OPPORTUNITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Opportunity ID
|
| 28 |
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:
RSF_LE_RATE_VW
Set Control Field: BUSINESS_UNIT
|
| 29 |
LEAD_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Used by Sales Force Automation to keep the status of a Sales Lead.
AC=Accepted
CD=Closed - Duplicate
CL=Closed - Won
CO=Converted to Opportunity
DE=Deferred
IM=Imported
LO=Closed - Lost
NE=New
OP=Open
RE=Referred
RJ=Rejected
TB=Turnback
WO=Working
Default Value: NE
|
| 30 |
ASSIGN_GROUP |
Character(30) |
VARCHAR2(30) NOT NULL |
This field is used to specify assignment group name for Territory assignment.
Prompt Table:
RSF_ASSIGN_GRP
Set Control Field: BUSINESS_UNIT
|
| 31 |
TERRITORY_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Territory ID
Prompt Table:
RSF_TER_NODE_VW
|
| 32 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table:
RSF_OPR_TREE_VW
|
| 33 |
REGION_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the region id value.
Prompt Table:
RSF_REGION_VW
|
| 34 |
CUST_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer Setid
|
| 35 |
PROD_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Product SET ID
|
| 36 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 37 |
PRODUCT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
PRoduct Group
|
| 38 |
PROD_GRP_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Product Group SetID
|
| 39 |
FULFILL_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
FULFIL
|
| 40 |
SURVEY_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Survey SetID
|
| 41 |
LEAD_SOURCE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Used by Sales Force Automation to identify the source of a Sales Lead.
Prompt Table:
RSF_LE_SRC_VW
|
| 42 |
BUSINESS_UNIT_RA |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_RA_NONVW
|
| 43 |
RA_CAMPAIGN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id.
Prompt Table:
RSF_CAMPAIGN_VW
|
| 44 |
RA_CMPGN_WAVE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Used to uniquely identify a Marketing - Campaign Activity (wave) ID
Prompt Table:
RSF_CMPGN_WA_VW
|
| 45 |
LEAD_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Used by Sales Force Automation to indicate what type of Lead,
IN=Inquiry
LE=Lead
QU=Qualified Lead
TQ=Turnback Qualified Lead
TU=Turnback Lead
|
| 46 |
INDUSTRY_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Industry ID.
Prompt Table:
RSF_INDUSTRY_VW
|
| 47 |
EST_REVENUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The expected revenue (amount) associated with an Opportunity. This is particularly used for forecasting.
|
| 48 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Default Value: RSF_OPR_DEF_VW.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 49 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Default Value: INSTALLATION.DEF_CUR_RT_TYPE
Prompt Table:
RT_TYPE_TBL
|
| 50 |
CHNL_PARTNER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Unique identifier for a Channel Partner
Prompt Table:
RSF_CHNL_PRT_VW
|
| 51 |
ALLIANC_PARTNER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Alliance Partner
Prompt Table:
RSF_ALLNC_PRT_V
|
| 52 |
REFERRED_DT |
Date(10) |
DATE |
Referred Date
|
| 53 |
ACCEPTED_DT |
Date(10) |
DATE |
Accepted Date
|
| 54 |
REJECTED_DT |
Date(10) |
DATE |
Rejected Date
|
| 55 |
NEXT_ACTIVITY_DT |
Date(10) |
DATE |
Next Task Date
|
| 56 |
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.
Prompt Table:
RSF_ROLE_ADR_VW
|
| 57 |
CM_ID_ADDRESS |
Number(31,0) |
DECIMAL(31) NOT NULL |
Contact Method ID
|
| 58 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 59 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 60 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 61 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 62 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 63 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 64 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 65 |
NUM2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Number 2
|
| 66 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 67 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 68 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 69 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 70 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 71 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 72 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 73 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 74 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
Default Value: Y
|
| 75 |
ADDRESS1_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
ADDRESS1_AC
|
| 76 |
ADDRESS2_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
ADDRESS2_AC
|
| 77 |
ADDRESS3_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
ADDRESS3_AC
|
| 78 |
ADDRESS4_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
Alternate Character Address 4.
|
| 79 |
CITY_AC |
Character(30) |
VARCHAR2(30) NOT NULL |
CITY_AC
|
| 80 |
TIMEZONE |
Character(9) |
VARCHAR2(9) NOT NULL |
Time Zone
Prompt Table:
PSTIMEZONE
|
| 81 |
BILL_TO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A boolean that flags whether or not the customer is a valid Bill To customer.
Y/N Table Edit
Default Value: N
|
| 82 |
SOLD_TO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A boolean that flags whether or not the customer is a valid Sold To customer.
Y/N Table Edit
Default Value: N
|
| 83 |
SHIP_TO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag indicating that the customer or address is a valid Ship To customer or address.
Y/N Table Edit
Default Value: N
|
| 84 |
CLONEDFROM_LEAD_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
|
| 85 |
CLONEDTO_LEAD_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
|
| 86 |
RC_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 87 |
CASE_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
|
| 88 |
AGREEMENT_CODE |
Character(30) |
VARCHAR2(30) NOT NULL |
This field represents the agreement code (name) for an agreement
|
| 89 |
AGR_RENEWAL_NUM |
Number(4,0) |
SMALLINT NOT NULL |
This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
|
| 90 |
RC_PROSPECT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Outbound Marketing
Y/N Table Edit
Default Value: N
|
| 91 |
RC_PROSPECT_STAT |
Character(2) |
VARCHAR2(2) NOT NULL |
Prospect Status
A=Assigned
C=Callback
D=Done
N=New
R=Rejected
|
| 92 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 93 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 94 |
CNSMR_CNTCT_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Consumer Contact Row Seq#
|
| 95 |
CNSMR_CNTCT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Consumer Contact Row created?
Y/N Table Edit
Default Value: N
|
| 96 |
SALES_PRIORITY |
Character(3) |
VARCHAR2(3) NOT NULL |
Priority of sales lead and opportunity
1=1-One
2=2-Two
3=3-Three
4=4-Four
5=5-Five
6=6-Six
7=7-Seven
8=8-Eight
9=9-Nine
Default Value: 5
|
| 97 |
TEAM_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sales Team ID
Prompt Table:
RSF_TEAM_A_VW
|
| 98 |
CONV_FROM_TLM_DTTM |
DateTime(26) |
TIMESTAMP |
Convert from TeleSales Date and Time
|
| 99 |
OPRID_CONVERTED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Operator Id Converted By
|
| 100 |
STATUS_CHANGE_DATE |
DateTime(26) |
TIMESTAMP |
Status Change Date
|
| 101 |
LEAD_REJECT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
LEAD_REJECT_CD
Prompt Table:
RSF_LE_RJCT_A_V
|
| 102 |
REFERRAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used as an indicator for identifying referral type of leads.
Y/N Table Edit
Default Value: N
|
| 103 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 104 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 105 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 106 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 107 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 108 |
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.
|
| 109 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|
| 110 |
MARKET |
Character(3) |
VARCHAR2(3) NOT NULL |
Market
|
| 111 |
REJECTION_COMMENTS |
Long Character |
CLOB |
Rejection/Turnback Comments
|