TRA_POOL_ID_VW (SQL View)	Index Back
Pool Event ID Prompt Tbl Pool Accounting Event ID Prompt Tbl

TRA_POOL_ID_VW

(SQL View)

Pool Event ID Prompt Tbl

Pool Accounting Event ID Prompt Tbl

SELECT DISTINCT BUSINESS_UNIT , EVENT_ID FROM PS_TRA_EVENT_CAL WHERE TR_SOURCE_CD = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 EVENT_ID Character(20) VARCHAR2(20) NOT NULL The unique key identifier that enumerates Treasury accounting events. Accounting events are transaction events that have been created by the Treasury sources (deals, fees, bank transfers, EFTs, etc).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	EVENT_ID	Character(20)	VARCHAR2(20) NOT NULL	The unique key identifier that enumerates Treasury accounting events. Accounting events are transaction events that have been created by the Treasury sources (deals, fees, bank transfers, EFTs, etc).