| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CAF_CONFIG_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Analysis Type
RTBL=Real Time Bottom Line
SYS=System
USER=User Defined
|
| 2 |
CAF_CONFIG_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Analysis ID
|
| 3 |
CAF_FACTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Factor ID
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: I
|
| 5 |
CAF_FACTOR_NAME |
Character(48) |
VARCHAR2(48) NOT NULL |
Factor Name
|
| 6 |
CAF_FACTOR_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Factor Type
AC=Application Class
CH=Chart
CP=Component
FL=Field List
GD=Grid
HT=HTML
PG=Pivot Grid Pagelet
PQ=PS Query Pagelet
UL=URL
Default Value: HT
|
| 7 |
CAF_DESCR_LONG |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 8 |
CAF_FCT_HANDLER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Factor Handler
Prompt Table:
CAF_HNDLR_F_VW
|
| 9 |
CAF_FCT_HNDLR_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Factor Handler Parameter
|
| 10 |
CAF_ENT_KEY_MAP |
Character(254) |
VARCHAR2(254) NOT NULL |
Entity Key Map
|
| 11 |
CAF_MODE_USED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in Mode
A=Analysis
B=Both
C=Comparison
Default Value: B
|
| 12 |
CAF_WIDTH |
Number(5,0) |
INTEGER NOT NULL |
Width
|
| 13 |
CAF_WIDTH_1 |
Number(5,0) |
INTEGER NOT NULL |
Chart Width
|
| 14 |
CAF_HEIGHT |
Number(5,0) |
INTEGER NOT NULL |
Height
|
| 15 |
CAF_HEIGHT_1 |
Number(5,0) |
INTEGER NOT NULL |
Chart Height
|
| 16 |
CAF_NUMBER |
Number(5,0) |
INTEGER NOT NULL |
Maximum Rows
|
| 17 |
MENUNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table:
PSMENUDEFN
|
| 18 |
PNLGRPNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Component Name
Prompt Table:
PRCSPNLGRP_VW2
|
| 19 |
PNLNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table:
PRCSPNLNAME_VW2
|
| 20 |
MENU_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Menu Action
Prompt Table:
CAF_MENU_ACT_VW
|
| 21 |
PTPPB_PAGELET_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Pagelet ID
Prompt Table:
%EDITTABLE2
|
| 22 |
CAF_CHART_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Chart Type
0=2D Bar
1=2D Stacked Bar
13=2D Horizontal Bar
4=2D Line
6=2D Pie
7=3D Bar
8=3D Stacked Bar
9=3D Pie
Default Value: 0
|
| 23 |
CAF_CHART_LEGEND |
Character(1) |
VARCHAR2(1) NOT NULL |
Legend
0=Left
1=Right
2=Top
3=Bottom
N=...None
Default Value: N
|
| 24 |
CAF_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record Name
Prompt Table:
PSRECDEFN
|
| 25 |
CAF_FIELDNAME_1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Data X Axis
Prompt Table:
CAF_FCT_FLD_VW
|
| 26 |
CAF_FIELDNAME_2 |
Character(18) |
VARCHAR2(18) NOT NULL |
Data Y Axis
Prompt Table:
CAF_FCT_FLD_VW
|
| 27 |
CAF_FIELDNAME_3 |
Character(18) |
VARCHAR2(18) NOT NULL |
Data Series
Prompt Table:
CAF_FCT_FLD_VW
|
| 28 |
CAF_FIELDNAME_4 |
Character(18) |
VARCHAR2(18) NOT NULL |
Data Hints
Prompt Table:
CAF_FCT_FLD_VW
|
| 29 |
CAF_TEXT_1 |
Character(80) |
VARCHAR2(80) NOT NULL |
Text
|
| 30 |
CAF_TEXT_2 |
Character(80) |
VARCHAR2(80) NOT NULL |
Text
|
| 31 |
CAF_TEXT_3 |
Character(80) |
VARCHAR2(80) NOT NULL |
Text
|
| 32 |
CAF_TEXT254_1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Text
|
| 33 |
CAF_TEXT254_2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Text
|
| 34 |
CAF_TEXT_LONG |
Long Character |
CLOB |
Comment
|