RB_RULE_UOM_VW(SQL View) |
Index Back |
---|---|
Commitment Unit Of MesaureViwe 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 |