BUSINESS_UNITPLOG_IDLINE_NBRADJ=Adjusted
APR=Approved
DEN=Denied
HLD=Hold
LDN=Line Denied
LPD=Line Pending
OPN=Open
PND=Pending
SUB=Submitted
F=Fixed Amount
M=Milestone
P=Percentage
R=Rate Based
SPF_PL_PGC2_VW(SQL View) |
Index Back |
|---|---|
Progress Log Fluid ApprovalsView created to show the Line page Summary data in page composer for Progress Log Fluid Approvals |
| SELECT A.Business_unit , A.PLOG_ID ,D.LINE_NBR , A.PLOG_STATUS , A.TEMPLATE_ID , A.CREATION_DT , A.COMMENTS , A.VENDOR_ID , A.CREATED_BY_USER , B.NAME1 , C.DESCR ,D.SP_BILL_AMOUNT ,D.CURRENCY_CD ,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_PLOG_DTL D ,PS_SPA_TIME_TMPL E WHERE A.VENDOR_ID = B.VENDOR_ID AND A.Business_unit = C.Business_unit AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PLOG_ID = D.PLOG_ID 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 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | 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 |
| 5 | TEMPLATE_ID | Character(30) | VARCHAR2(30) NOT NULL | Project Template |
| 6 | CREATION_DT | Date(10) | DATE | Creation Date |
| 7 | COMMENTS | Long Character | CLOB | Comment |
| 8 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 9 | CREATED_BY_USER | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 10 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 11 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 12 | SP_BILL_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Billable Amount |
| 13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 14 | 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 |
| 15 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Template Description |
| 16 | SP_CREATION_DT | Character(30) | VARCHAR2(30) NOT NULL | Created For Progress Log Fluid Approvals |