SPF_WO_RATE_ACT

(SQL Table)
Index Back

Work Order Activities

Work Order Rate Based Activities ************************************************************************************ Date Initials Ref. No. Description 03/26/08 SWA 1729032002 Changed the Edit type to promt for UNIT_OF_MEASURE field.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_SP_NONVW

2 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: SPF_WO_ACT_VW

4 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: SPF_UOM_VW

5 PL_RATE Number(15,4) DECIMAL(14,4) NOT NULL Progress Log Rate
6 PL_RATE_BSE Number(15,4) DECIMAL(14,4) NOT NULL Progress Log Rate Base
7 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
8 SP_BILL_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Billable Amount
9 SP_BILL_AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Time and Expense amount reported in the base currency
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
12 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
13 RATE_EFFDT Date(10) DATE Rate Effective Date
14 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
15 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier