SPF_PL_PGC3_VW

(SQL View)
 Index Back

Progress Log Fluid Approvals

View created to show the Header page Summary data in page composer for Progress Log Fluid Approvals

SELECT A.Business_unit , A.PLOG_ID , A.PLOG_STATUS , A.TEMPLATE_ID , A.CREATION_DT , A.COMMENTS , A.VENDOR_ID , A.CREATED_BY_USER , B.NAME1 , C.DESCR ,E.SP_BILL_METHOD ,E.DESCR AS DESCR1 ,' ' FROM PS_SPA_PLOG_HDR A , PS_VENDOR B ,PS_BUS_UNIT_TBL_FS C ,PS_SPA_TIME_TMPL E WHERE A.VENDOR_ID = B.VENDOR_ID AND A.Business_unit = C.Business_unit AND A.TEMPLATE_ID = E.TE_TEMPLATE_ID AND E.SPA_TEMPLATE_TYPE = 'D' AND E.EFFDT = ( SELECT P.EFFDT FROM PS_SPA_TIME_TMPL P WHERE E.SETID = P.SETID AND E.TE_TEMPLATE_ID = P.TE_TEMPLATE_ID AND E.SPA_TEMPLATE_TYPE = P.SPA_TEMPLATE_TYPE AND P.EFF_STATUS = 'A' AND P.EFFDT <= %CurrentDateIn)

# 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 PLOG_STATUS Character(3) VARCHAR2(3) NOT NULL Progress Log Status
ADJ=Adjusted
APR=Approved
DEN=Denied
HLD=Hold
LDN=Line Denied
LPD=Line Pending
OPN=Open
PND=Pending
SUB=Submitted
4 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template
5 CREATION_DT Date(10) DATE Creation Date
6 COMMENTS Long Character CLOB Comment
7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
8 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
9 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
11 SP_BILL_METHOD Character(1) VARCHAR2(1) NOT NULL Used in Service Based Workorders to identify the billing method.
F=Fixed Amount
M=Milestone
P=Percentage
R=Rate Based
12 DESCR1 Character(30) VARCHAR2(30) NOT NULL Template Description
13 SP_CREATION_DT Character(30) VARCHAR2(30) NOT NULL Created For Progress Log Fluid Approvals