SPB_MET_PREF_VW

(SQL View)
 Index Back

Analysis Metric Definition Tbl

Analysis Metric Definition Table for Graphs

SELECT B.RECNAME , A.SPB_METRIC_CODE , A.DESCR , A.SPB_AGGREGATE , A.SPB_METRIC_YN FROM PS_SPB_METRIC_DFN A , PSRECDEFN B WHERE A.SPB_METRIC_YN IN ( SELECT F.FIELDNAME FROM PSRECFIELD F WHERE F.RECNAME = B.RECNAME) AND A.SPB_METRIC_YN <> ' '

  • Related Language Record: SPB_MEPEF_LG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    2 SPB_METRIC_CODE Character(18) VARCHAR2(18) NOT NULL Metric Code

    Prompt Table: SPB_METRIC_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 SPB_AGGREGATE Character(3) VARCHAR2(3) NOT NULL Aggregate
    AMT=Currency Amount
    AVG=Average
    CNT=Count
    DAY=Day
    PCT=Percentage
    TIM=Time
    TOT=Total
    5 SPB_METRIC_YN Character(18) VARCHAR2(18) NOT NULL Field Name