SPF_PL_PGC7_VW

(SQL View)
Index Back

Progress Log Fluid Approvals.

View created to show the line details in the page composer line Details section on the line page in Progress Log Fluid Approvals.

SELECT A.BUSINESS_UNIT , A.PLOG_ID , A.LINE_NBR , A.DISTRIB_LINE_NUM , A.PL_LINE_STATUS , A.ACTIVITY_ID , A.WORK_ORDER_ID , A.APPROVAL_OPRID , A.APPROVAL_DT , A.APPR_RATINGS , A.APPR_RATING_NUM , A.PERCENT_COMPLETE ,' ' , A.UNIT_OF_MEASURE , A.PL_RATE , A.PL_RATE_BSE , A.QUANTITY , A.SP_BILL_AMOUNT , A.COMPLETE_DATE , A.PERCENT_POAMOUNT ,' ' , A.TE_INVOICE_FLG , A.INVOICE_ID , A.INVOICE_LINE , A.INV_LINE_STATUS , A.SP_BILL_AMOUNT_BSE , A.CURRENCY_CD_BASE , A.RATE_DIV , A.RATE_MULT , A.RT_TYPE , A.SP_MSP_PERCENT , A.SP_MSP_FEE , A.SP_MSP_FEE_BSE , A.PC_DISTRIB_STATUS , ' ' , ' ' , 0 ,A.CURRENCY_CD ,A.RATE_EFFDT ,' ' FROM PS_SPA_PLOG_DTL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PLOG_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
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 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
7 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
8 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.
9 APPROVAL_DT Date(10) DATE Date of Approval
10 APPR_RATINGS Character(1) VARCHAR2(1) NOT NULL Approver ratings of contractor.
E=Excellent
F=Fair
G=Good
N=None
P=Poor
11 APPR_RATING_NUM Number(4,2) DECIMAL(3,2) NOT NULL Performance Rating
12 PERCENT_COMPLETE Number(6,2) DECIMAL(5,2) NOT NULL % Complete
13 SP_PERC_COMPLETE Character(20) VARCHAR2(20) NOT NULL Created For Progress Log Fluid Approvals
14 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
15 PL_RATE Number(15,4) DECIMAL(14,4) NOT NULL Progress Log Rate
16 PL_RATE_BSE Number(15,4) DECIMAL(14,4) NOT NULL Progress Log Rate Base
17 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
18 SP_BILL_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Billable Amount
19 COMPLETE_DATE Date(10) DATE To save the task execution complete date
20 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.
21 SPF_PERCENT_POAMT Character(30) VARCHAR2(30) NOT NULL Created For Progress Log Fluid Approvals
22 TE_INVOICE_FLG Character(1) VARCHAR2(1) NOT NULL Time and expense invoiced flag
N=No
Y=Yes
23 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
24 INVOICE_LINE Number(5,0) INTEGER NOT NULL Invoice Line
25 INV_LINE_STATUS Character(4) VARCHAR2(4) NOT NULL Invoice Line Status
1=Generated
10=Adjusted by Ent Approver
11=Adjusted by Enterprise
2=Approved by Enterprise
3=Submitted to Enterprise
4=Denied by Enterprise
5=Submitted to Supplier
6=Approved by Supplier
7=Denied by Supplier
8=Canceled
9=Adjusted by Supplier
26 SP_BILL_AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Time and Expense amount reported in the base currency
27 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
28 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
29 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
30 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.
31 SP_MSP_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL MSP percent
32 SP_MSP_FEE Signed Number(28,3) DECIMAL(26,3) NOT NULL Managed Service Provider Fee
33 SP_MSP_FEE_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Managed Service Provider Fee (Base Currency)
34 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged
35 SP_WO_REMAINDER Character(30) VARCHAR2(30) NOT NULL Created For Progress Log Fluid Approvals
36 SP_TOTAL_POAMOUNT Character(30) VARCHAR2(30) NOT NULL Created For Progress Log Fluid Approvals
37 SP_REM_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Created For Progress Log Fluid Approvals
38 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
39 RATE_EFFDT Date(10) DATE Rate Effective Date
40 SP_COMPLETE_DT Character(30) VARCHAR2(30) NOT NULL Created For Progress Log Fluid Approvals