SPA_PL_PRCNT_VW

(SQL View)
 Index Back

Progress Log Percent View

'Percent' Progress Logs

SELECT D.WORK_ORDER_ID , H.BUSINESS_UNIT , D.PLOG_ID , D.LINE_NBR , E.PL_LINE_STATUS , D.PERCENT_COMPLETE , D.ACTIVITY_ID , D.PERCENT_POAMOUNT , D.COMPLETE_DATE , D.SP_BILL_AMOUNT , H.CREATION_DT , D.QUANTITY , D.UNIT_OF_MEASURE , D.PL_RATE , D.CURRENCY_CD FROM PS_SPA_PLOG_DTL D , PS_SPA_PLOG_HDR H , PS_SPA_PLOG_HIST E WHERE D.PLOG_ID = H.PLOG_ID AND D.BUSINESS_UNIT = H.BUSINESS_UNIT AND E.PLOG_ID = H.PLOG_ID AND E.BUSINESS_UNIT = H.BUSINESS_UNIT AND E.PLOG_ID = D.PLOG_ID AND E.BUSINESS_UNIT = D.BUSINESS_UNIT AND D.LINE_NBR = E.LINE_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID

Prompt Table: SPA_PL_WO_VW

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PLOG_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 PL_LINE_STATUS Character(3) VARCHAR2(3) NOT NULL Progress Log Line Status
ADJ=Adjusted
APR=Approved
DEN=Denied
HLD=Hold
OPN=Open
PND=Pending
SUB=Submitted
6 PERCENT_COMPLETE Number(6,2) DECIMAL(5,2) NOT NULL % Complete
7 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
8 PERCENT_POAMOUNT Number(3,0) SMALLINT NOT NULL Percentage of the total PO Amount. If specified, the amount to be paid (MS_AMOUNT) should be calculated.
9 COMPLETE_DATE Date(10) DATE To save the task execution complete date
10 SP_BILL_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Billable Amount
11 CREATION_DT Date(10) DATE Creation Date
12 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
13 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
14 PL_RATE Number(15,4) DECIMAL(14,4) NOT NULL Progress Log Rate
15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code