| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
PIPELINE_SEG_BY |
Character(4) |
VARCHAR2(4) NOT NULL |
Show Pipeline By
IND=Industry
REGN=Region
SEG=Pipeline Segment
TERR=Territory
UNIT=Business Unit
USER=Sales User
|
| 3 |
PIPELINE_OPP_BY |
Character(4) |
VARCHAR2(4) NOT NULL |
Show Pipeline By
IND=Industry
OSTS=Opportunity Status
PER=Period
REGN=Region
SEG=Pipeline Segment
TERR=Territory
UNIT=Business Unit
USER=Sales User
|
| 4 |
PIPELINE_PROD_BY |
Character(4) |
VARCHAR2(4) NOT NULL |
Show Pipeline By
IND=Industry
OSTS=Opportunity Status
PER=Period
PGRP=Product Group
PRD=Product
REGN=Region
REVT=Revenue Type
SEG=Pipeline Segment
TERR=Territory
UNIT=Business Unit
USER=Sales User
|
| 5 |
PIPELINE_TYPE_SEG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is the label for the vertical, y-axis, of pipeline graph
O=Opportunity Count
R=Revenue
|
| 6 |
PIPELINE_TYPE_OPP |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales pipeline uses this field as yaxis descriptor for diplay by time period.
R=Revenue
S=Shadow
|
| 7 |
PIPELINE_TYPE_PROD |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales pipeline use this for display of pipeline by product.
R=Revenue
S=Shadow
U=Unit Count
|
| 8 |
TIMEFRAME_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Time Frame
Prompt Table:
RSF_TF_DEFN
|
| 9 |
PERIOD_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Period
Prompt Table:
RSF_TF_PD_PL_VW
|
| 10 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Prompt Table:
CURRENCY_CD_TBL
|
| 11 |
RSF_CHART_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Chart Type
BAR=Bar Chart
HBR=Horizontal Bar
HPBR=Horizontal Percent Bar
HSBR=Horizontal Stacked Bar
PBR=Percent Bar
SBR=Stacked Bar Chart
|
| 12 |
QUOTA_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Quota Type
M=Manager Quota
R=Rollup Quota
|