HCR_SM_PARM_CHG (SQL Table)	Index Back
Search Match Parameter Change Search Match Parameter ChangeTable. This table stores the last update DateTime for any updates to a Parameter or a Rule within a Parameter. This data is useful for run controls that might point to a specific set of Parameters and require refresh when the setup data has changed.

HCR_SM_PARM_CHG

(SQL Table)

Search Match Parameter Change

Search Match Parameter ChangeTable. This table stores the last update DateTime for any updates to a Parameter or a Rule within a Parameter. This data is useful for run controls that might point to a specific set of Parameters and require refresh when the setup data has changed.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SM_TYPE Character(1) VARCHAR2(1) NOT NULL Search Match Type: This field identifies the domain of core data to be searched.
A=Applicant
O=Organization
P=Person

2 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.

3 LAST_CHANGED_DTTM DateTime(26) TIMESTAMP Last Changed

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SM_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Search Match Type: This field identifies the domain of core data to be searched. A=Applicant O=Organization P=Person
2	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.
3	LAST_CHANGED_DTTM	DateTime(26)	TIMESTAMP	Last Changed