TRX_ACC_INT_TMP (SQL Table)	Index Back
Work table Work table used for interest accruals grid. Data is selected into this table from one of 5 views, however, data will never be stored in this table.

TRX_ACC_INT_TMP

(SQL Table)

Work table

Work table used for interest accruals grid. Data is selected into this table from one of 5 views, however, data will never be stored in this table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRX_YEAR_NUM Number(4,0) SMALLINT NOT NULL Year in numeric form

2 TRX_PERIOD_NUM Number(3,0) SMALLINT NOT NULL Period

3 FROM_DATE Date(10) DATE From Date

4 TO_DATE Date(10) DATE To Date

5 POSITION_CURRENCY Character(3) VARCHAR2(3) NOT NULL The transaction currency of a given position or exposure.

6 ACCRUED_INT Signed Number(28,3) DECIMAL(26,3) NOT NULL The periodic amount of accrued interest for a given deal transaction.

7 BOND_DISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amount for Straightline Bond

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRX_YEAR_NUM	Number(4,0)	SMALLINT NOT NULL	Year in numeric form
2	TRX_PERIOD_NUM	Number(3,0)	SMALLINT NOT NULL	Period
3	FROM_DATE	Date(10)	DATE	From Date
4	TO_DATE	Date(10)	DATE	To Date
5	POSITION_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The transaction currency of a given position or exposure.
6	ACCRUED_INT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The periodic amount of accrued interest for a given deal transaction.
7	BOND_DISC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount for Straightline Bond