PGM_TIM_UOM_LVW

(SQL View)
 Index Back

UOM Prompt Language 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 , L.LANGUAGE_CD , L.DESCR , L.DESCRSHORT FROM PS_UNITS_TBL U , PS_BUS_UNIT_TBL_PC B , PS_UNITS_TBL_LANG L WHERE (B.UOM_HOURS = U.UNIT_OF_MEASURE OR B.DAYS_UOM = U.UNIT_OF_MEASURE) AND U.UNIT_OF_MEASURE = L.UNIT_OF_MEASURE

  • Related Language Record for PGM_TIME_UOM_VW

    • # 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
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description