CAF_CONFIG_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 Default Value: USER |
| 2 | CAF_CONFIG_ID |
Character(30) | VARCHAR2(30) NOT NULL | Analysis ID |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: I |
| 4 | CAF_CONFIG_TITLE | Character(80) | VARCHAR2(80) NOT NULL | Analysis Title |
| 5 | CAF_DESCR_LONG | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 6 | CAF_CMP_HANDLER_ID | Character(30) | VARCHAR2(30) NOT NULL |
Analysis Handler
Prompt Table: CAF_HNDLR_C_VW |
| 7 | CAF_CMP_HNDLR_PARM | Character(254) | VARCHAR2(254) NOT NULL | Analysis Handler Parameter |
| 8 | CAF_ENT_HANDLER_ID | Character(30) | VARCHAR2(30) NOT NULL |
Entity Handler
Prompt Table: CAF_HNDLR_E_VW |
| 9 | CAF_ENT_HNDLR_PARM | Character(254) | VARCHAR2(254) NOT NULL | Entity Handler Parameter |
| 10 | CAF_CMP_MENUNAME | Character(30) | VARCHAR2(30) NOT NULL |
Display Menu Name
Prompt Table: PSMENUDEFN |
| 11 | CAF_ENTITY_NAME | Character(80) | VARCHAR2(80) NOT NULL | Entity Label |
| 12 | CAF_ENTITY_NAME2 | Character(80) | VARCHAR2(80) NOT NULL | Entity Label (Plural) |
| 13 | CAF_ENT_KEY_REC | Character(15) | VARCHAR2(15) NOT NULL |
Entity Record Name
Prompt Table: PSRECDEFN |
| 14 | CAF_ENT_DESCR_FLD | Character(18) | VARCHAR2(18) NOT NULL |
Description Field
Prompt Table: CAF_ENT_FLD_VW |
| 15 | CAF_ENT_KEY_SEP | Character(4) | VARCHAR2(4) NOT NULL | Key Separator |
| 16 | CAF_FACTOR_LABEL | Character(80) | VARCHAR2(80) NOT NULL | Factor Label |
| 17 | CAF_FACTOR_LABEL2 | Character(80) | VARCHAR2(80) NOT NULL | Factor Label (Plural) |
| 18 | CAF_HAS_MODE_A_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Support Analysis Mode
Y/N Table Edit Default Value: Y |
| 19 | CAF_HAS_GRPACT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Support Entity Group Actions
Y/N Table Edit Default Value: Y |
| 20 | CAF_HAS_FLGENT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Support Flagged Entity
Y/N Table Edit Default Value: Y |
| 21 | CAF_OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL |
Additional valid values are from OBJECTOWNERID
Prompt Table: CAF_OBJOWNID_VW |