CAF_CONFIG_TYPERTBL=Real Time Bottom Line
SYS=System
USER=User Defined
CAF_CONFIG_IDCAF_FACTOR_IDRTBL_CAF_FAC_VW(SQL View) |
Index Back |
|---|
| SELECT A.CAF_CONFIG_TYPE , A.CAF_CONFIG_ID , A.CAF_FACTOR_ID , A.CAF_FACTOR_NAME FROM PS_CAF_FACTOR_TBL A , PS_CAF_CONFIG_TBL C WHERE A.CAF_CONFIG_TYPE = C.CAF_CONFIG_TYPE AND A.CAF_CONFIG_ID = C.CAF_CONFIG_ID AND A.EFF_STATUS = 'A' AND C.CAF_CONFIG_TYPE <> 'SYS' AND C.CAF_CMP_HANDLER_ID = 'PS_ANALYSIS_COMPARISON_HANDLER' AND C.EFF_STATUS = 'A' AND (A.CAF_FACTOR_TYPE = 'PG' OR A.CAF_FACTOR_TYPE = 'PQ' OR A.CAF_FACTOR_TYPE = 'OB') AND A.CAF_FACTOR_ID NOT IN ( SELECT B.CAF_FACTOR_ID FROM PS_RTBL_CAF_MAPREG B WHERE A.CAF_CONFIG_ID = B.CAF_CONFIG_ID) |
| # | 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_FACTOR_NAME | Character(48) | VARCHAR2(48) NOT NULL | Factor Name |