| # |
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_ACTION_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Action ID
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: I
|
| 5 |
CAF_ACTION_NAME |
Character(48) |
VARCHAR2(48) NOT NULL |
Action Name
|
| 6 |
CAF_ACTION_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
Action Level
C=Analysis
D=Factor Data
E=Entity
ES=Selected Entities
F=Factor
FS=Common Factors
|
| 7 |
CAF_ACTION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Action Type
A=App Class
C=Component
F=Filter
Default Value: C
|
| 8 |
CAF_ACT_HANDLER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Action Handler
Prompt Table:
CAF_HNDLR_A_VW
|
| 9 |
CAF_ACT_HNDLR_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Action Handler Parameter
|
| 10 |
CAF_FACTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Factor ID
Prompt Table:
CAF_FACTOR_TBL
|
| 11 |
CAF_CONFIG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Configure Action
Y/N Table Edit
|
| 12 |
CAF_ENT_KEY_MAP |
Character(254) |
VARCHAR2(254) NOT NULL |
Key Map
|
| 13 |
CAF_MODE_USED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in Mode
A=Analysis
B=Both
C=Comparison
Default Value: B
|
| 14 |
CAF_NAVIGATE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Navigation Type
M=Modal
N=New Page
R=Replace Page
Default Value: M
|
| 15 |
MENUNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table:
PSMENUDEFN
|
| 16 |
BARNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Bar Name
Prompt Table:
PRCSBARNAME_VW
|
| 17 |
ITEMNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Item Name
Prompt Table:
PSMENUITEM_VW2
|
| 18 |
ITEMPANELNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Panel Name
Prompt Table:
BPW_MENUPNL_VW
|
| 19 |
MENU_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Menu Action
A=Add
C=Correction
E=Data Entry
L=Update/Display All
U=Update
Default Value: U
|
| 20 |
FILTER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Filter criteria identification
Prompt Table:
CAF_FLTRDEFN_VW
|