TRA_ACCTG_WKID (SQL Table)	Index Back
Work Record for TRACCTG AE pgm Work Record for storing OPRID for Treasury Accounting process.

TRA_ACCTG_WKID

(SQL Table)

Work Record for TRACCTG AE pgm

Work Record for storing OPRID for Treasury Accounting process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

3 TRA_SOURCE_CD Character(1) VARCHAR2(1) NOT NULL Note: Changes to Translate Values must also be made to TR_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Cash Flows only
B=BSP
D=Deals
E=Deal Fees
F=Facility Fees
H=Hedges
I=Interest
M=Deal: Estimated Maturity Accr
N=Netted Deal
O=Other
P=Investment Pools
R=EFT Fees
S=Securities
T=LC Fees
W=EFT Requests
X=Bank Transfers

4 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).

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	TRA_SOURCE_CD	Character(1)	VARCHAR2(1) NOT NULL	Note: Changes to Translate Values must also be made to TR_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Cash Flows only B=BSP D=Deals E=Deal Fees F=Facility Fees H=Hedges I=Interest M=Deal: Estimated Maturity Accr N=Netted Deal O=Other P=Investment Pools R=EFT Fees S=Securities T=LC Fees W=EFT Requests X=Bank Transfers
4	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).
5	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).