| # |
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 |
CAF_SEQ_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Sequence
|
| 5 |
PTPG_UNIQPROMPFLD |
Character(30) |
VARCHAR2(30) NOT NULL |
Unique Prompt Name
Prompt Table:
CAF_FCT_PVPT_VW
|
| 6 |
CAF_PVPT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ValueType
C=Constant
G=Global Date
K=Key Field
P=My Personalization
|
| 7 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table:
CAF_PERSRECS_VW
|
| 8 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
PSRECFIELDDB
|
| 9 |
CAF_DATE_OPERATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Global Date Operation
0=Not Applicable
1=Global Date From
2=Global Date To
A=Day of Global Date From
B=Day of Global Date To
C=Month of Global Date From
D=Month of Global Date To
E=Year of Global Date From
F=Year of Global Date To
G=Day Difference
H=Month Difference
I=Year Difference
|
| 10 |
CAF_PVPT_CTE_STR |
Character(20) |
VARCHAR2(20) NOT NULL |
Prompt Constant Value
|
| 11 |
FIELDNAME2 |
Character(18) |
VARCHAR2(18) NOT NULL |
Fieldname 2
|