SCD_AVAL_KPI_VW

(SQL View)
 Index Back

Available KPI Definitions

SELECT A.SCD_KPI_DEF_ID ,A.SCD_KPI_DEF_NAME ,A.SCD_KPI_TYPE ,B.XLATLONGNAME ,A.SCD_KPI_CATEGORY ,A.SCD_USE_PR_HIS_FLG ,C.SCD_KPI_CAT_DESC ,B.EFFDT FROM PS_SCD_KPI_DEF A ,PSXLATITEM B ,PS_SCD_KPI_CAT C WHERE B.FIELDNAME = 'SCD_KPI_TYPE' AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PSXLATITEM D WHERE B.FIELDNAME = D.FIELDNAME AND B.FIELDVALUE = D.FIELDVALUE AND D.EFFDT=B.EFFDT AND D.EFFDT <= %CurrentDateIn) AND A.SCD_KPI_DEF_STATUS ='AV' AND A.SCD_KPI_TYPE = B.FIELDVALUE AND A.SCD_KPI_CATEGORY = C.SCD_KPI_CATEGORY

SELECT A.SCD_KPI_DEF_ID ,A.SCD_KPI_DEF_NAME ,A.SCD_KPI_TYPE ,B.XLATLONGNAME ,A.SCD_KPI_CATEGORY ,A.SCD_USE_PR_HIS_FLG ,C.SCD_KPI_CAT_DESC ,A.SCD_KPI_DEF_DESC ,B.EFFDT FROM PS_SCD_KPI_DEF A ,PSXLATITEM B ,PS_SCD_KPI_CAT C WHERE B.FIELDNAME = 'SCD_KPI_TYPE' AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PSXLATITEM D WHERE B.FIELDNAME = D.FIELDNAME AND B.FIELDVALUE = D.FIELDVALUE AND D.EFFDT=B.EFFDT AND D.EFFDT <= %CurrentDateIn) AND A.SCD_KPI_DEF_STATUS ='AV' AND A.SCD_KPI_TYPE = B.FIELDVALUE AND A.SCD_KPI_CATEGORY = C.SCD_KPI_CATEGORY

  • Related Language Record: SCD_AVA_KPI_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCD_KPI_DEF_ID Character(10) VARCHAR2(10) NOT NULL KPI ID
    2 SCD_KPI_DEF_NAME Character(30) VARCHAR2(30) NOT NULL KPI Name
    3 SCD_KPI_TYPE Character(2) VARCHAR2(2) NOT NULL KPI Type
    MA=Manual
    QR=Query
    4 SCD_TYPE_XLATLNNAM Character(30) VARCHAR2(30) NOT NULL Field to hold the KPI Type long translation name
    5 SCD_KPI_CATEGORY Character(15) VARCHAR2(15) NOT NULL KPI Category
    6 SCD_USE_PR_HIS_FLG Character(1) VARCHAR2(1) NOT NULL Flag to indicate if procurement history is used
    N=No
    Y=Yes

    Y/N Table Edit

    7 SCD_KPI_CAT_DESC Character(45) VARCHAR2(45) NOT NULL KPI Category Description
    8 SCD_KPI_DEF_DESC Long Character(1000) VARCHAR2(1000) KPI Description
    9 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date