OPRIDPrompt Table: OPERATOR_VW
SCE_IDCAF_CONFIG_TYPERTBL=Real Time Bottom Line
SYS=System
USER=User Defined
CAF_SESSION_IDCAF_CONFIG_IDCAF_FACTOR_IDOBI=Obiee Report
PSQ=PSQuery
PVG=Pivot Grid
RTBL_CAF_AN_VW(SQL View) |
Index Back |
|---|
| SELECT OPRID , SCE_ID , CAF_CONFIG_TYPE , CAF_SESSION_ID , CAF_CONFIG_ID , CAF_FACTOR_ID , RTBL_REPT_TYPE , RTBL_PAGELET_ID FROM PS_RTBL_CAF_AN_PRS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW |
| 2 | SCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | ID |
| 3 | CAF_CONFIG_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Analysis Type
RTBL=Real Time Bottom Line SYS=System USER=User Defined |
| 4 | CAF_SESSION_ID |
Character(36) | VARCHAR2(36) NOT NULL | Session ID |
| 5 | CAF_CONFIG_ID |
Character(30) | VARCHAR2(30) NOT NULL | Analysis ID |
| 6 | CAF_FACTOR_ID |
Character(30) | VARCHAR2(30) NOT NULL | Factor ID |
| 7 | RTBL_REPT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Report Type
OBI=Obiee Report PSQ=PSQuery PVG=Pivot Grid |
| 8 | RTBL_PAGELET_ID | Character(30) | VARCHAR2(30) NOT NULL | Pagelet ID |