RB_TKN_SRCH_VW (SQL View)	Index Back
Config search Terms Configurable Search Terms to select Recipient Specific Terms

RB_TKN_SRCH_VW

(SQL View)

Config search Terms

Configurable Search Terms to select Recipient Specific Terms

SELECT T.RB_TOKEN_NAME , T.RB_TOKEN_ID , T.DESCR , T.RB_TKN_DATA_TYPE , T.ROW_LASTMANT_DTTM , T.ROW_LASTMANT_OPRID FROM PS_RBC_TOKEN_DFN T

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RB_TOKEN_NAME Character(30) VARCHAR2(30) NOT NULL Correspondence Management Token Name

2 RB_TOKEN_ID Number(31,0) DECIMAL(31) NOT NULL Unique Token Identifier

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 RB_TKN_DATA_TYPE Character(4) VARCHAR2(4) NOT NULL Token Data Type
HL=Hyperlink
IMG=Image
STR=String

5 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

6 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RB_TOKEN_NAME	Character(30)	VARCHAR2(30) NOT NULL	Correspondence Management Token Name
2	RB_TOKEN_ID	Number(31,0)	DECIMAL(31) NOT NULL	Unique Token Identifier
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	RB_TKN_DATA_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Token Data Type HL=Hyperlink IMG=Image STR=String
5	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
6	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.