RS_XS_SO_DEL (SQL View)	Index Back
PTSF Expired Orders Query view to delete expired orders from the index

RS_XS_SO_DEL

(SQL View)

PTSF Expired Orders

Query view to delete expired orders from the index

SELECT %TrimSubstr(A.BUSINESS_UNIT,1,5) %Concat '' %Concat %TrimSubstr(A.SO_ID,1,15) %Concat '' %Concat %TrimSubstr(%NumToChar(A.SO_LINE),1,3) ,A.BUSINESS_UNIT ,A.SO_ID ,A.SO_LINE ,L.DTTM_MODIFIED FROM %Table(RS_SO_LINE) A , PS_RS_SRCH_LOG L WHERE L.DOCUMENT = %TrimSubstr(A.BUSINESS_UNIT,1,5) %Concat '' %Concat %TrimSubstr(A.SO_ID,1,15) %Concat '' %Concat %TrimSubstr(%NumToChar(A.SO_LINE),1,3) AND L.SRCH_TYPE_CD = 'RSRSR' AND L.ACTION_FLG = 'D'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SOID Character(29) VARCHAR2(29) NOT NULL Service Order Line Key

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID

4 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number

5 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SOID	Character(29)	VARCHAR2(29) NOT NULL	Service Order Line Key
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
4	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Line Number
5	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.