ORDENT_UNIT_VW (SQL View)	Index Back
Unit Conversion View Determine common units that can be converted to

ORDENT_UNIT_VW

(SQL View)

Unit Conversion View

Determine common units that can be converted to

SELECT U.UNIT_OF_MEASURE , U.UNIT_OF_MEASURE_TO , U.CONVERSION_RATE , 'Y' , 0 FROM PS_UNITS_CVT_TBL U

# 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.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

2 UNIT_OF_MEASURE_TO Character(3) VARCHAR2(3) NOT NULL Unit of Measure To

3 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate

4 MATCH Character(1) VARCHAR2(1) NOT NULL Match
N=Remit Not Included
R=Remit Only
Y=Remit Included

5 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter

#	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. MHR=Muti Hourly PER=Percentage SQF=Square Footage
2	UNIT_OF_MEASURE_TO	Character(3)	VARCHAR2(3) NOT NULL	Unit of Measure To
3	CONVERSION_RATE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate
4	MATCH	Character(1)	VARCHAR2(1) NOT NULL	Match N=Remit Not Included R=Remit Only Y=Remit Included
5	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter