SPA_MNG_PL_VW

(SQL View)
Index Back

Manage Progress Logs View

This view fetches Progress Log details for Mass Approvals

SELECT A.BUSINESS_UNIT , A.PLOG_ID , A.LINE_NBR , A.PL_LINE_STATUS , A.WORK_ORDER_ID , A.APPROVAL_OPRID , A.SP_BILL_AMOUNT , A.PERCENT_POAMOUNT , MAX(B.SEQNUM) , C.OPRALIASTYPE , E.APPR_RATINGS FROM PS_SPA_PLOG_DTL A , PS_SPA_PLOG_HIST B ,PSOPRALIAS C ,PS_SPA_PLOG_HDR D ,PS_BUS_UNIT_TBL_SP E WHERE A.PLOG_ID = B.PLOG_ID AND A.LINE_NBR = B.LINE_NBR AND D.PLOG_ID = A.PLOG_ID AND C.OPRID = D.CREATED_BY_USER AND E.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.BUSINESS_UNIT = A.BUSINESS_UNIT GROUP BY A.BUSINESS_UNIT, A.PLOG_ID, A.LINE_NBR, A.APPROVAL_OPRID, A.PL_LINE_STATUS, A.WORK_ORDER_ID, A.SP_BILL_AMOUNT, A.PERCENT_POAMOUNT, C.OPRALIASTYPE, E.APPR_RATINGS

# 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 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
5 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
6 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.
7 SP_BILL_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Billable Amount
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 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
10 OPRALIASTYPE Character(3) VARCHAR2(3) NOT NULL User ID Type
11 APPR_RATINGS Character(1) VARCHAR2(1) NOT NULL Approver ratings of contractor.
E=Excellent
F=Fair
G=Good
N=None
P=Poor