SPA_PLOG_HDR_VW

(SQL View)
 Index Back

Progress Logs for WO

This view fetches progress logs for a given WO

SELECT DISTINCT A.BUSINESS_UNIT , A.PLOG_ID , A.PERSON_ID , B.WORK_ORDER_ID , W.MRSC_PARENT_WOID , W.SUB_LINE FROM PS_SPA_PLOG_HDR A , PS_SPA_PLOG_DTL B , PS_SPF_WORDERREC W WHERE A.PLOG_ID = B.PLOG_ID AND B.BUSINESS_UNIT = W.BUSINESS_UNIT AND B.WORK_ORDER_ID = W.WORK_ORDER_ID

# 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 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
4 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
5 MRSC_PARENT_WOID Character(15) VARCHAR2(15) NOT NULL Multi Resource Parent WOID
6 SUB_LINE Character(1) VARCHAR2(1) NOT NULL Sub Line
N=No
Y=Yes