PTSF_INDEX_VW

(SQL View)
 Index Back

RTI Index View

Real Time Indexing Search Definition View

SELECT A.PTSF_SBO_NAME ,A.DESCR100 ,CASE WHEN EXISTS ( SELECT 1 FROM PS_PTSF_DEPLOY_OBJ B WHERE A.PTSF_SBO_NAME = B.PTSF_OBJ_NAME AND B.PTSF_OBJ_TYPE = 'SBO') THEN 'D' ELSE 'U' END ,CASE WHEN EXISTS ( SELECT 1 FROM PS_PTSF_INDEX C WHERE A.PTSF_SBO_NAME = C.PTSF_INDEX_NAME AND C.PTSF_RTI = 'Y') THEN 'Y' WHEN NOT EXISTS ( SELECT 1 FROM PS_PTSF_INDEX D WHERE A.PTSF_SBO_NAME = D.PTSF_INDEX_NAME) THEN 'U' ELSE 'N' END FROM PSPTSF_SD A WHERE A.PTSF_SOURCE_TYPE IN ('Q', 'C', 'A') AND A.PTSF_SBO_NAME NOT IN ( SELECT PTSF_SBO_NAME FROM psptsf_add_prms WHERE PTSF_PARAM_NAME='ALLOW_RTI' AND PTSF_PARAM_VALUE='N' ) AND A.PTSF_SBO_NAME NOT IN ( SELECT PTSF_SBO_NAME FROM PS_PTRTIEXCLUDEDSD )

  • Related Language Record: PTSF_INDEX_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTSF_INDEX_NAME Character(65) VARCHAR2(65) NOT NULL Index Name
    2 PTSF_DESCR Character(100) VARCHAR2(100) NOT NULL Description
    3 PTSF_OBJ_STATUS Character(1) VARCHAR2(1) NOT NULL Deploy Status
    A=Auto Deployed
    D=Deployed
    U=Undeployed
    4 PTSF_RTI Character(1) VARCHAR2(1) NOT NULL Real Time Index
    N=Disabled
    U=Not Configured
    Y=Enabled