TR_SEC_MTM_FEE (SQL Table)	Index Back
Work Table for TR_SEC_MTM AE Used as a temporary table in the TR_SEC_MTM Application Engine process. This table is used for Fee Data.

TR_SEC_MTM_FEE

(SQL Table)

Work Table for TR_SEC_MTM AE

Used as a temporary table in the TR_SEC_MTM Application Engine process. This table is used for Fee Data.

# 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 TR_SOURCE_CD Character(1) VARCHAR2(1) NOT NULL Note: Changes to Translate Values must also be made to TRA_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Accounting 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 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

5 FEE_SEQ_NUM Number(15,0) DECIMAL(15) NOT NULL Represents the sequential numbering of detail fee transactions within a given facility.

6 FA_FEE_CODE Character(20) VARCHAR2(20) NOT NULL Fee code mapped to Bank Fee code used for Fee Analysis.

7 FEE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL The transaction fee amount.

8 ACCRUED_UP_TO_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL "An internal work field utilized for calculating the interest

#	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	TR_SOURCE_CD	Character(1)	VARCHAR2(1) NOT NULL	Note: Changes to Translate Values must also be made to TRA_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Accounting 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	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
5	FEE_SEQ_NUM	Number(15,0)	DECIMAL(15) NOT NULL	Represents the sequential numbering of detail fee transactions within a given facility.
6	FA_FEE_CODE	Character(20)	VARCHAR2(20) NOT NULL	Fee code mapped to Bank Fee code used for Fee Analysis.
7	FEE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The transaction fee amount.
8	ACCRUED_UP_TO_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	"An internal work field utilized for calculating the interest