HRS_APPI_DEL_VW (SQL View)	Index Back
Internal Search Indexing View This record is used in the internal search indexing process to collect information for the Verity Index for deletes.

HRS_APPI_DEL_VW

(SQL View)

Internal Search Indexing View

This record is used in the internal search indexing process to collect information for the Verity Index for deletes.

SELECT AI.HRS_PERSON_ID , AI.HRS_PROFILE_SEQ , AI.HRS_ROW_UPD_DTTM FROM PS_HRS_APPINDX_CTL AI WHERE AI.INDEX_ACTION = 'D'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id

2 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece

3 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
2	HRS_PROFILE_SEQ	Number(3,0)	SMALLINT NOT NULL	Profile sequece
3	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime