CAF_ACTION_TBL(SQL Table) |
Index Back |
---|
# | 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). |
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 |
19 | MENU_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Menu Action
Prompt Table: CAF_MENU_ACT_VW |
20 | FILTER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Filter criteria identification
Prompt Table: CAF_FLTRDEFN_VW |