TR_COLLSRCH_PRF (SQL Table)	Index Back
Collateral Search Preferences.

TR_COLLSRCH_PRF

(SQL Table)

Collateral Search Preferences.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_FS_NONVW

4 COLLATERAL_ID Character(12) VARCHAR2(12) NOT NULL Collateral ID number. auto generated but can be overridden.
Prompt Table: TR_COLL_ID_VW

5 COLLATERAL_HELD_BY Character(4) VARCHAR2(4) NOT NULL Treasury Collateral Held By
CUST=Customer
EURO=Euro Brokers
OTHR=Other
US=Treasury

6 COUNTERPARTY Character(5) VARCHAR2(5) NOT NULL Represents a treasury dealing counterpart.
Prompt Table: BANK_TR_CPTY_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_FS_NONVW
4	COLLATERAL_ID	Character(12)	VARCHAR2(12) NOT NULL	Collateral ID number. auto generated but can be overridden. Prompt Table: TR_COLL_ID_VW
5	COLLATERAL_HELD_BY	Character(4)	VARCHAR2(4) NOT NULL	Treasury Collateral Held By CUST=Customer EURO=Euro Brokers OTHR=Other US=Treasury
6	COUNTERPARTY	Character(5)	VARCHAR2(5) NOT NULL	Represents a treasury dealing counterpart. Prompt Table: BANK_TR_CPTY_VW