Date Initials Issue Description 091608 SWA 1789772003 Modified View definition so that actual date on the WO determines the time frames available for time sheet.

SPA_SUP_RC_WO_V

(SQL View)

Index Back

SELECT DISTINCT O.ROLEUSER ,W.WO_CONID ,W.BUSINESS_UNIT ,W.TE_TEMPLATE_ID ,W.WORK_ORDER_ID ,W.ACT_START_DT ,W.ACT_END_DT , W.WO_NAME FROM PS_SPF_WORDERREC W , PS_ROLEXLATOPR O , PSOPRALIAS P WHERE W.WO_STATUS IN ('C','N','L','T') AND EXISTS ( SELECT 'X' FROM PS_SPF_WO_HISTORY WHERE PS_SPF_WO_HISTORY.BUSINESS_UNIT = W.BUSINESS_UNIT AND PS_SPF_WO_HISTORY.WORK_ORDER_ID = W.WORK_ORDER_ID AND PS_SPF_WO_HISTORY.WO_STATUS = 'L') AND W.SERVICE_METHOD = 'R' AND P.OPRID IN ( SELECT B.ROLEUSER FROM PS_SPB_SERVICE_PRV A , PS_ROLEXLATOPR B , PS_SPB_OPRALIAS_VW C ,PS_SET_CNTRL_GROUP S WHERE (A.SP_FUNCTION_TYPE = 'PRCT' OR A.SP_FUNCTION_TYPE = 'INDP') AND A.VENDOR_ID = W.VENDOR_ID AND A.LOCATION = W.VNDR_LOC AND C.OPRALIASTYPE = 'SPP' AND C.PERSON_ID = A.PERSON_ID AND B.ROLEUSER = C.OPRID AND S.SETCNTRLVALUE = W.BUSINESS_UNIT AND S.REC_GROUP_ID = 'FS_38' AND S.SETID = A.VENDOR_SETID) AND P.OPRID = O.ROLEUSER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

4 TE_TEMPLATE_ID Character(8) VARCHAR2(8) NOT NULL Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash expense sheets.

5 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID

6 ACT_START_DT Date(10) DATE Activity Start Date

7 ACT_END_DT Date(10) DATE Activity End Date

8 WO_NAME Character(30) VARCHAR2(30) NOT NULL Work Order Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
2	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
4	TE_TEMPLATE_ID	Character(8)	VARCHAR2(8) NOT NULL	Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash expense sheets.
5	WORK_ORDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Order ID
6	ACT_START_DT	Date(10)	DATE	Activity Start Date
7	ACT_END_DT	Date(10)	DATE	Activity End Date
8	WO_NAME	Character(30)	VARCHAR2(30) NOT NULL	Work Order Name