SP_APR_PL_SR_VW

(SQL View)
 Index Back

Progress Log view

Progress Log view

SELECT A.BUSINESS_UNIT , G.DESCR , A.PLOG_ID , A.PERSON_ID , C.NAME , A.PLOG_STATUS , A.VENDOR_ID , B.NAME1 , D.SP_BILL_METHOD , A.CREATION_DT , A.PERSON_ID FROM PS_SPA_PLOG_HDR A , PS_VENDOR B , PS_SPB_PERSON_TBL C , PS_SPA_TIME_TMPL D , PS_SET_CNTRL_GROUP E , PS_SET_CNTRL_GROUP F , PS_BUS_UNIT_TBL_FS G WHERE A.VENDOR_ID = B.VENDOR_ID AND C.PERSON_ID= A.PERSON_ID AND A.BUSINESS_UNIT = F.SETCNTRLVALUE AND F.REC_GROUP_ID = 'SP_12' AND D.SETID = F.SETID AND D.TE_TEMPLATE_ID = A.TEMPLATE_ID AND D.SPA_TEMPLATE_TYPE = 'D' AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_SPA_TIME_TMPL D1 WHERE D1.EFFDT <= %CurrentDateIn AND D1.EFF_STATUS = 'A' AND D.SETID = D1.SETID AND D.TE_TEMPLATE_ID = D1.TE_TEMPLATE_ID AND D.SPA_TEMPLATE_TYPE = D1.SPA_TEMPLATE_TYPE) AND D.EFF_STATUS = 'A' AND E.REC_GROUP_ID = 'FS_38' AND E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.SETID = B.SETID AND G.BUSINESS_UNIT = A.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 PLOG_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
4 SPA_CONTRACTOR Character(30) VARCHAR2(30) NOT NULL Service Provider
5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 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
7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
8 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
9 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
10 CREATION_DT Date(10) DATE Creation Date
11 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID