ASSET_SES_DELVW (SQL View)	Index Back
Asset PTSF Search Delete View Asset PTSF Search Delete View

ASSET_SES_DELVW

(SQL View)

Asset PTSF Search Delete View

SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.AUDLOG_DTTM FROM %Table(AM_ASST_AUD_TBL) A WHERE A.FS_EVENT_CODE = 'ASSET_DELETE' AND NOT EXISTS ( SELECT 'X' FROM %Table(ASSET) B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

3 DELETE_DTTM DateTime(26) TIMESTAMP Delete DTTM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
3	DELETE_DTTM	DateTime(26)	TIMESTAMP	Delete DTTM