RS_SRCH_LOG (SQL Table)	Index Back
Search Log Table This table is used to store transaction data changes used by Search Collection.

RS_SRCH_LOG

(SQL Table)

Search Log Table

This table is used to store transaction data changes used by Search Collection.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SRCH_TYPE_CD Character(5) VARCHAR2(5) NOT NULL Search Type
Prompt Table: RS_SRCH_HDR

2 DOCUMENT Character(30) VARCHAR2(30) NOT NULL Specifies a document used as a reference number for a Receivables item. Document ID is used by the Receivables Update program and the Maintenance Worksheet to "match" related invoices debit memos and credit memos.

3 VERITY_MODEL Character(1) VARCHAR2(1) NOT NULL Model

4 DTTM_MODIFIED DateTime(26) TIMESTAMP NOT NULL Datetime modified

5 ACTION_FLG Character(1) VARCHAR2(1) NOT NULL Action Flag
A=Action

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SRCH_TYPE_CD	Character(5)	VARCHAR2(5) NOT NULL	Search Type Prompt Table: RS_SRCH_HDR
2	DOCUMENT	Character(30)	VARCHAR2(30) NOT NULL	Specifies a document used as a reference number for a Receivables item. Document ID is used by the Receivables Update program and the Maintenance Worksheet to "match" related invoices debit memos and credit memos.
3	VERITY_MODEL	Character(1)	VARCHAR2(1) NOT NULL	Model
4	DTTM_MODIFIED	DateTime(26)	TIMESTAMP NOT NULL	Datetime modified
5	ACTION_FLG	Character(1)	VARCHAR2(1) NOT NULL	Action Flag A=Action