PGM_TIME_UOM_VW

(SQL View)
 Index Back

UOM Prompt View

Prompt view for Unit of Measure data item. The view shows only the UOM's that are applicable for time based resources like labor and Asset. It is based on the definitions at the BU level.

SELECT B.BUSINESS_UNIT , U.UNIT_OF_MEASURE , U.DESCR , U.DESCRSHORT FROM PS_UNITS_TBL U , PS_BUS_UNIT_TBL_PC B WHERE B.UOM_HOURS = U.UNIT_OF_MEASURE OR B.DAYS_UOM = U.UNIT_OF_MEASURE

  • Related Language Record: PGM_TIM_UOM_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Default Value: OPR_DEF_TBL_PC.UNIT_OF_MEASURE

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description