CAF_CONFIG_ID_TYPERTBL=Real Time Bottom Line
SYS=System
USER=User Defined
RTBL_CAF_IDT_VW(SQL View) |
Index Back |
|---|
| SELECT CAF_CONFIG_ID %Concat ' (' %Concat CAF_CONFIG_TYPE %Concat ')' AS CAF_CONFIG_ID_TYPE ,CAF_CONFIG_TITLE ,CAF_CONFIG_ID ,CAF_CONFIG_TYPE FROM %Table(CAF_CONFIG_TBL) WHERE EFF_STATUS='A' AND CAF_OBJECTOWNERID='FRTB' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAF_CONFIG_ID_TYPE |
Character(34) | VARCHAR2(34) NOT NULL | Analysis ID |
| 2 | CAF_CONFIG_TITLE | Character(80) | VARCHAR2(80) NOT NULL | Analysis Title |
| 3 | CAF_CONFIG_ID | Character(30) | VARCHAR2(30) NOT NULL | Analysis ID |
| 4 | CAF_CONFIG_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Analysis Type
RTBL=Real Time Bottom Line SYS=System USER=User Defined |