SPA_TS_PGCHL_VW

(SQL View)
Index Back

sPro Timesheet Fluid Approval

View to display header information of lines for Services Timesheet Fluid Approval transaction.

SELECT A.BUSINESS_UNIT , A.TIME_SHEET_ID , A.WORK_ORDER_ID , A.LINE_NBR , A.DISTRIB_LINE_NUM , ' ' , A.TIME_LINE_STATUS , A.SPA_BILLING_ACTION , A1.WO_NAME , A1.CURRENCY_CD , A1.JOB_TITLE , C.SPA_TIMESHEET_NAME , 0 , 0 , 0 , 0 , 0 , ' ' , ' ' , ' ' , 0 , 0 , 0 , 0 , 0 FROM PS_SPA_TIME_DTL A , PS_SPF_WORDERREC A1 , PS_SPA_TIME_HDR C WHERE A.BUSINESS_UNIT = A1.BUSINESS_UNIT AND A.WORK_ORDER_ID = A1.WORK_ORDER_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.TIME_SHEET_ID = C.TIME_SHEET_ID UNION SELECT B.BUSINESS_UNIT , B.TIME_SHEET_ID , B.WORK_ORDER_ID , B.LINE_NBR , B.DISTRIB_LINE_NUM , ' ' , B.TIME_LINE_STATUS , B.SPA_BILLING_ACTION , B1.WO_NAME , B1.CURRENCY_CD , B1.JOB_TITLE , C.SPA_TIMESHEET_NAME , 0 , 0 , 0 , 0 , 0 , ' ' , ' ' , ' ' , 0 , 0 , 0 , 0 , 0 FROM PS_SPA_TIM_INCIDNT B , PS_SPF_WORDERREC B1 , PS_SPA_TIME_HDR C WHERE B.BUSINESS_UNIT = B1.BUSINESS_UNIT AND B.WORK_ORDER_ID = B1.WORK_ORDER_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.TIME_SHEET_ID = C.TIME_SHEET_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_SP_NONVW

2 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)

Default Value: NEXT

3 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
6 SPF_DISTRIB_NAME Character(30) VARCHAR2(30) NOT NULL Distribution Name
7 TIME_LINE_STATUS Character(3) VARCHAR2(3) NOT NULL Time Line Status
ADJ=Adjusted
APR=Approved
DEN=Denied
OPN=Open
PND=Pending
SUB=Submitted
8 SPA_BILLING_ACTION Character(1) VARCHAR2(1) NOT NULL Billing Action
B=Billable
U=Nonbillable
9 WO_NAME Character(30) VARCHAR2(30) NOT NULL Work Order Name
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 JOB_TITLE Character(50) VARCHAR2(50) NOT NULL Job Title
12 SPA_TIMESHEET_NAME Character(30) VARCHAR2(30) NOT NULL Time Sheet Name
13 POAMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Purchase Order / Work Order Amount
14 SP_CUR_BILL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Used to store the current billed amount with respect to Reassign WorkOrders.
15 AVAILABLE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Prepayment Available Amount
16 TIME_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Time Amount
17 NEW_AMT_REM Signed Number(28,3) DECIMAL(26,3) NOT NULL New Payment Amt Remaing
18 LABEL1 Character(30) VARCHAR2(30) NOT NULL Label Description 30 char
19 LABEL2 Character(30) VARCHAR2(30) NOT NULL Label Description 30 char
20 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
21 PARENT_POAMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Purchase Order / Work Order Amount
22 P_SP_CUR_BILL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Used to store the current billed amount with respect to Reassign WorkOrders.
23 P_AVAILABLE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Prepayment Available Amount
24 P_TIME_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Time Amount
25 P_NEW_AMT_REM Signed Number(28,3) DECIMAL(26,3) NOT NULL New Payment Amt Remaing