SEARCH_CRIT_CHG (SQL View)	Index Back
Search Criteria Last Changed SEARCH_CRIT_CHG contains a Date/Time stamp of when the last change was made to the Search/Match criteria (via the HCR_SM_RULE or HCR_SM_PARM pages).

SEARCH_CRIT_CHG

(SQL View)

Search Criteria Last Changed

SEARCH_CRIT_CHG contains a Date/Time stamp of when the last change was made to the Search/Match criteria (via the HCR_SM_RULE or HCR_SM_PARM pages).

SELECT SM_PARM_CD , LAST_CHANGED_DTTM FROM PS_HCR_SM_PARM_CHG WHERE SM_TYPE = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SM_PARM_CD Character(15) VARCHAR2(15) NOT NULL Search Match Parameter Code. This field stores the high level key for a Search Match Parameter definition.

2 LAST_CHANGED_DTTM DateTime(26) TIMESTAMP NOT NULL Last Changed

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SM_PARM_CD	Character(15)	VARCHAR2(15) NOT NULL	Search Match Parameter Code. This field stores the high level key for a Search Match Parameter definition.
2	LAST_CHANGED_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Last Changed