TRA_WIRE_ID_VW (SQL View)	Index Back
Wire ID Prompt Tbl Treasury Wire - Events View This view lists all Treasury Wire events. PeopleCode: TRA_PANELS_WRK.TR_SOURCE_CD-FieldChange

TRA_WIRE_ID_VW

(SQL View)

Wire ID Prompt Tbl

Treasury Wire - Events View This view lists all Treasury Wire events. PeopleCode: TRA_PANELS_WRK.TR_SOURCE_CD-FieldChange

SELECT DISTINCT BUSINESS_UNIT , %Substring(EVENT_ID,1,12) FROM PS_TRA_EVENT_CAL WHERE TR_SOURCE_CD = 'W'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 TR_SOURCE_ID Character(12) VARCHAR2(12) NOT NULL An internal work field that represents a unique identifier for records depicting a given treasury po

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	TR_SOURCE_ID	Character(12)	VARCHAR2(12) NOT NULL	An internal work field that represents a unique identifier for records depicting a given treasury po