STDNTKEY_EF_VW (SQL View)	Index Back
Effective Std. Note Keyword This view stores the effective dated key search words for a block of note text. Keywords could be used as search criteria for users formating queries or custom reports. This is an optional record.

STDNTKEY_EF_VW

(SQL View)

Effective Std. Note Keyword

This view stores the effective dated key search words for a block of note text. Keywords could be used as search criteria for users formating queries or custom reports. This is an optional record.

SELECT S.SETID , S.STD_NOTE_CD , S.EFFDT , S.KEY_WORD FROM PS_STD_NOTE_KEYWD S WHERE %EffdtCheck(STD_NOTE_KEYWD S2, S, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 STD_NOTE_CD Character(10) VARCHAR2(10) NOT NULL Standard Note Code

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 KEY_WORD Character(20) VARCHAR2(20) NOT NULL Key Word

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	STD_NOTE_CD	Character(10)	VARCHAR2(10) NOT NULL	Standard Note Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	KEY_WORD	Character(20)	VARCHAR2(20) NOT NULL	Key Word