STAT_ALL_VW

(SQL View)
 Index Back

View of all Statistics Codes

All Statistics Code with the most current effective date, in STAT_TBL.

SELECT a.setid , a.statistics_code , a.descr , a.descrshort , a.unit_of_measure FROM PS_STAT_TBL a WHERE a.effdt = ( SELECT MAX(b.effdt) FROM PS_STAT_TBL b WHERE a.setid = b.setid AND a.statistics_code = b.statistics_code)

  • Related Language Record: STAT_ALL_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

    Prompt Table: STAT_TBL

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL