OPRIDDEFAULT_FLAGDefault Value: N
N=No
Y=Yes
Default Value: N
S=Specify
U=Projects User Preferences
Default Value: U
Prompt Table: SP_BU_CA_NONVW
DRAF=1. Draft
RDY=2. Ready
H=01 - High
L=O3 - Low
M=02 - Medium
Prompt Table: CURRENCY_CD_TBL
GM_PE_RPIPE_PRS(SQL Table) |
Index Back |
|---|---|
REVENUE PIPLINE PRS TABLEPersonalization table for embedded analysis Revenue Pipeline |
| # | 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 | DEFAULT_FLAG |
Character(1) | VARCHAR2(1) NOT NULL |
Default
Default Value: N |
| 3 | MY_PROPOSAL | Character(1) | VARCHAR2(1) NOT NULL |
My Proposals
N=No Y=Yes Default Value: N |
| 4 | PC_BU_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
A flag to indicate where the Business Unit personalization filter will come from: User Preference or a Specified Value.
S=Specify U=Projects User Preferences Default Value: U |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_CA_NONVW |
| 6 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 7 | END_DT | Date(10) | DATE | End Date |
| 8 | SUBMIT_STATUS_PE | Character(4) | VARCHAR2(4) NOT NULL |
Status
DRAF=1. Draft RDY=2. Ready |
| 9 | CONF_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Confidence Level
H=01 - High L=O3 - Low M=02 - Medium |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |