CAF_CONFIG_TYPERTBL=Real Time Bottom Line
SYS=System
USER=User Defined
Default Value: USER
CAF_CONFIG_IDPrompt Table: CAF_CONFIG_VW
CAF_FACTOR_IDCAF_ACTION_IDPrompt Table: C360_ACTION_VW
Prompt Table: C360_FILTER_VW
C360_FILTER_TBL(SQL Table) |
Index Back |
|---|---|
Comprehensive Customer View |
| # | 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 Default Value: USER |
| 2 | CAF_CONFIG_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Analysis ID
Prompt Table: CAF_CONFIG_VW |
| 3 | CAF_FACTOR_ID |
Character(30) | VARCHAR2(30) NOT NULL | Factor ID |
| 4 | CAF_ACTION_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Action ID
Prompt Table: C360_ACTION_VW |
| 5 | FILTER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Filter criteria identification
Prompt Table: C360_FILTER_VW |