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.

SELECT AI.HRS_PERSON_ID , AI.HRS_PROFILE_SEQ 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