SPA_TS_PGCLH_VW

(SQL View)
 Index Back

sPro Timesheet Fluid Approval

View to display line's header information 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.JOB_TITLE , C.SPA_TIMESHEET_NAME , 0 , A1.CURRENCY_CD 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.JOB_TITLE , C.SPA_TIMESHEET_NAME , 0 , B1.CURRENCY_CD 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 JOB_TITLE Character(50) VARCHAR2(50) NOT NULL Job Title
11 SPA_TIMESHEET_NAME Character(30) VARCHAR2(30) NOT NULL Time Sheet Name
12 TIME_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Time Amount
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code