SPF_PL_PGC7_VW(SQL View) |
Index Back |
---|---|
Progress Log Fluid Approvals.View created to show the line details in the page composer line Details section on the line page in Progress Log Fluid Approvals. |
SELECT A.BUSINESS_UNIT , A.PLOG_ID , A.LINE_NBR , A.DISTRIB_LINE_NUM , A.PL_LINE_STATUS , A.ACTIVITY_ID , A.WORK_ORDER_ID , A.APPROVAL_OPRID , A.APPROVAL_DT , A.APPR_RATINGS , A.APPR_RATING_NUM , A.PERCENT_COMPLETE ,' ' , A.UNIT_OF_MEASURE , A.PL_RATE , A.PL_RATE_BSE , A.QUANTITY , A.SP_BILL_AMOUNT , A.COMPLETE_DATE , A.PERCENT_POAMOUNT ,' ' , A.TE_INVOICE_FLG , A.INVOICE_ID , A.INVOICE_LINE , A.INV_LINE_STATUS , A.SP_BILL_AMOUNT_BSE , A.CURRENCY_CD_BASE , A.RATE_DIV , A.RATE_MULT , A.RT_TYPE , A.SP_MSP_PERCENT , A.SP_MSP_FEE , A.SP_MSP_FEE_BSE , A.PC_DISTRIB_STATUS , ' ' , ' ' , 0 ,A.CURRENCY_CD ,A.RATE_EFFDT ,' ' FROM PS_SPA_PLOG_DTL A |
# | 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 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
5 | PL_LINE_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Progress Log Line Status
ADJ=Adjusted APR=Approved DEN=Denied HLD=Hold OPN=Open PND=Pending SUB=Submitted |
6 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
7 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
8 | APPROVAL_OPRID | Character(30) | VARCHAR2(30) NOT NULL | A system generated value that reflects the operator that approved a given transaction. |
9 | APPROVAL_DT | Date(10) | DATE | Date of Approval |
10 | APPR_RATINGS | Character(1) | VARCHAR2(1) NOT NULL |
Approver ratings of contractor.
E=Excellent F=Fair G=Good N=None P=Poor |
11 | APPR_RATING_NUM | Number(4,2) | DECIMAL(3,2) NOT NULL | Performance Rating |
12 | PERCENT_COMPLETE | Number(6,2) | DECIMAL(5,2) NOT NULL | % Complete |
13 | SP_PERC_COMPLETE | Character(20) | VARCHAR2(20) NOT NULL | Created For Progress Log Fluid Approvals |
14 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
15 | PL_RATE | Number(15,4) | DECIMAL(14,4) NOT NULL | Progress Log Rate |
16 | PL_RATE_BSE | Number(15,4) | DECIMAL(14,4) NOT NULL | Progress Log Rate Base |
17 | QUANTITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Interface |
18 | SP_BILL_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Billable Amount |
19 | COMPLETE_DATE | Date(10) | DATE | To save the task execution complete date |
20 | PERCENT_POAMOUNT | Number(3,0) | SMALLINT NOT NULL | Percentage of the total PO Amount. If specified, the amount to be paid (MS_AMOUNT) should be calculated. |
21 | SPF_PERCENT_POAMT | Character(30) | VARCHAR2(30) NOT NULL | Created For Progress Log Fluid Approvals |
22 | TE_INVOICE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Time and expense invoiced flag
N=No Y=Yes |
23 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
24 | INVOICE_LINE | Number(5,0) | INTEGER NOT NULL | Invoice Line |
25 | INV_LINE_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Invoice Line Status
1=Generated 10=Adjusted by Ent Approver 11=Adjusted by Enterprise 2=Approved by Enterprise 3=Submitted to Enterprise 4=Denied by Enterprise 5=Submitted to Supplier 6=Approved by Supplier 7=Denied by Supplier 8=Canceled 9=Adjusted by Supplier |
26 | SP_BILL_AMOUNT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Time and Expense amount reported in the base currency |
27 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
28 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
29 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
30 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
31 | SP_MSP_PERCENT | Number(6,2) | DECIMAL(5,2) NOT NULL | MSP percent |
32 | SP_MSP_FEE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Managed Service Provider Fee |
33 | SP_MSP_FEE_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Managed Service Provider Fee (Base Currency) |
34 | PC_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
PC Distribution Status
B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged |
35 | SP_WO_REMAINDER | Character(30) | VARCHAR2(30) NOT NULL | Created For Progress Log Fluid Approvals |
36 | SP_TOTAL_POAMOUNT | Character(30) | VARCHAR2(30) NOT NULL | Created For Progress Log Fluid Approvals |
37 | SP_REM_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Created For Progress Log Fluid Approvals |
38 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
39 | RATE_EFFDT | Date(10) | DATE | Rate Effective Date |
40 | SP_COMPLETE_DT | Character(30) | VARCHAR2(30) NOT NULL | Created For Progress Log Fluid Approvals |