SPA_MNG_PL_VW(SQL View) |
Index Back |
---|---|
Manage Progress Logs ViewThis view fetches Progress Log details for Mass Approvals |
SELECT A.BUSINESS_UNIT , A.PLOG_ID , A.LINE_NBR , A.PL_LINE_STATUS , A.WORK_ORDER_ID , A.APPROVAL_OPRID , A.SP_BILL_AMOUNT , A.PERCENT_POAMOUNT , MAX(B.SEQNUM) , C.OPRALIASTYPE , E.APPR_RATINGS FROM PS_SPA_PLOG_DTL A , PS_SPA_PLOG_HIST B ,PSOPRALIAS C ,PS_SPA_PLOG_HDR D ,PS_BUS_UNIT_TBL_SP E WHERE A.PLOG_ID = B.PLOG_ID AND A.LINE_NBR = B.LINE_NBR AND D.PLOG_ID = A.PLOG_ID AND C.OPRID = D.CREATED_BY_USER AND E.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.BUSINESS_UNIT = A.BUSINESS_UNIT GROUP BY A.BUSINESS_UNIT, A.PLOG_ID, A.LINE_NBR, A.APPROVAL_OPRID, A.PL_LINE_STATUS, A.WORK_ORDER_ID, A.SP_BILL_AMOUNT, A.PERCENT_POAMOUNT, C.OPRALIASTYPE, E.APPR_RATINGS |
# | 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 | 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 |
5 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
6 | APPROVAL_OPRID | Character(30) | VARCHAR2(30) NOT NULL | A system generated value that reflects the operator that approved a given transaction. |
7 | SP_BILL_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Billable Amount |
8 | 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. |
9 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
10 | OPRALIASTYPE | Character(3) | VARCHAR2(3) NOT NULL | User ID Type |
11 | APPR_RATINGS | Character(1) | VARCHAR2(1) NOT NULL |
Approver ratings of contractor.
E=Excellent F=Fair G=Good N=None P=Poor |