CAF_CONFIG_TYPERTBL=Real Time Bottom Line
SYS=System
USER=User Defined
Default Value: USER
CAF_CONFIG_IDPrompt Table: CAF_CONFIG_VW
Prompt Table: PSMENUDEFN
Prompt Table: CAF_OBJOWNID_VW
CAF_CONFIG_VW(SQL View) |
Index Back |
|---|
| SELECT CAF_CONFIG_TYPE , CAF_CONFIG_ID , CAF_CONFIG_TITLE , CAF_ENTITY_NAME , CAF_CMP_MENUNAME , CAF_OBJECTOWNERID FROM PS_CAF_CONFIG_TBL WHERE EFF_STATUS = 'A' |
| # | 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_CONFIG_TITLE | Character(80) | VARCHAR2(80) NOT NULL | Analysis Title |
| 4 | CAF_ENTITY_NAME | Character(80) | VARCHAR2(80) NOT NULL | Entity Label |
| 5 | CAF_CMP_MENUNAME | Character(30) | VARCHAR2(30) NOT NULL |
Display Menu Name
Prompt Table: PSMENUDEFN |
| 6 | CAF_OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL |
Additional valid values are from OBJECTOWNERID
Prompt Table: CAF_OBJOWNID_VW |