RB_RULE_UOM_VW

(SQL View)
Index Back

Commitment Unit Of Mesaure

Viwe used for getting unit of measure for commiement rule

SELECT unit_of_measure , descr FROM PS_UNITS_TBL WHERE unit_of_measure IN ('DYS','WKS','MTS','YRS')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
CS=Case
EA=Each
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description