BUSINESS_UNITPLOG_IDLINE_NBRSPF_PL_PGC6_VW(SQL View) |
Index Back |
|---|---|
Progress Log Fluid Approvals.View created to show the Line Summary in the Line page on top in Page composer in Progress Log Fluid Approvals. |
| SELECT A.BUSINESS_UNIT , A.PLOG_ID , A.LINE_NBR , A.ACTIVITY_ID , A.PERCENT_COMPLETE , A.SP_BILL_AMOUNT , A.CURRENCY_CD , B.WORK_ORDER_ID , B.WO_NAME ,B.WORK_ORDER_ID || ' / '|| A.ACTIVITY_ID AS Descr254 FROM PS_SPA_PLOG_DTL A , PS_SPF_WORDERREC B , PS_SPA_PLOG_HDR C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WORK_ORDER_ID = B.WORK_ORDER_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PLOG_ID = C.PLOG_ID AND A.ACTIVITY_ID <> ' ' UNION ALL SELECT A.BUSINESS_UNIT , A.PLOG_ID , A.LINE_NBR , A.ACTIVITY_ID , A.PERCENT_COMPLETE , A.SP_BILL_AMOUNT , A.CURRENCY_CD , B.WORK_ORDER_ID , B.WO_NAME ,B.WORK_ORDER_ID || ' / '|| %NumToChar(A.PERCENT_COMPLETE) || '%' AS Descr254 FROM PS_SPA_PLOG_DTL A , PS_SPF_WORDERREC B , PS_SPA_PLOG_HDR C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WORK_ORDER_ID = B.WORK_ORDER_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PLOG_ID = C.PLOG_ID AND A.PERCENT_COMPLETE <> 0 |
| # | 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 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 5 | PERCENT_COMPLETE | Number(6,2) | DECIMAL(5,2) NOT NULL | % Complete |
| 6 | SP_BILL_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Billable Amount |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 8 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 9 | WO_NAME | Character(30) | VARCHAR2(30) NOT NULL | Work Order Name |
| 10 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |