TRX_LOCINTA_VW (SQL View)	Index Back
Daily Interest for LOC deals Used to calculate total interest using from and to dates for loans that have been drawn down for the LOC facility. Total interest used in calculating estimated cost of funds of LOC borrowings

TRX_LOCINTA_VW

(SQL View)

Daily Interest for LOC deals

Used to calculate total interest using from and to dates for loans that have been drawn down for the LOC facility. Total interest used in calculating estimated cost of funds of LOC borrowings

SELECT A.SETID , B.FCLTY_ID , D.TRX_YEAR_NUM , D.TRX_DAY_OF_YR_NUM , D.CALENDAR_DATE , D.CALENDAR_DATE , C.POSITION_CURRENCY , %Round((%DecDiv(%DecMult(PERIOD_INT_ACCRUAL,(%DateDiff(PD_INT_START_DT, CALENDAR_DATE) + 1)), %DateDiff(PD_INT_START_DT, PERIOD_END_DT) ) - %DecDiv(%DecMult(PERIOD_INT_ACCRUAL, %DateDiff(PD_INT_START_DT, CALENDAR_DATE) ), %DateDiff( PD_INT_START_DT, PERIOD_END_DT))),3) , %Round((%DecDiv(%DecMult(DISCOUNT_AMT,(%DateDiff(PD_INT_START_DT, CALENDAR_DATE) + 1)), %DateDiff(PD_INT_START_DT, PERIOD_END_DT) ) - %DecDiv(%DecMult(DISCOUNT_AMT, %DateDiff(PD_INT_START_DT, CALENDAR_DATE) ), %DateDiff( PD_INT_START_DT, PERIOD_END_DT))),3) ,C.BUSINESS_UNIT ,C.TR_SOURCE_ID FROM PS_INSTR_HEADER_TR A , PS_TRX_HEADER_TR B , PS_TRX_POSITION_TR C , PS_POS_DAYS_TBL D WHERE A.TR_LOC_DEBT_FLG = 'Y' AND B.INSTRUMENT_TYPE = A.INSTRUMENT_TYPE AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.TR_SOURCE_ID = B.TREAS_HEADER_ID AND C.TR_SOURCE_CD='D' AND D.CALENDAR_DATE >= C.PERIOD_START_DT AND D.CALENDAR_DATE < C.PERIOD_END_DT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 FCLTY_ID Character(12) VARCHAR2(12) NOT NULL A unique key identifier that represents a given counterparty facility.

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

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

5 FROM_DATE Date(10) DATE From Date

6 TO_DATE Date(10) DATE To Date

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

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

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

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

11 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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	FCLTY_ID	Character(12)	VARCHAR2(12) NOT NULL	A unique key identifier that represents a given counterparty facility.
3	TRX_YEAR_NUM	Number(4,0)	SMALLINT NOT NULL	Year in numeric form
4	TRX_PERIOD_NUM	Number(3,0)	SMALLINT NOT NULL	Period
5	FROM_DATE	Date(10)	DATE	From Date
6	TO_DATE	Date(10)	DATE	To Date
7	POSITION_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The transaction currency of a given position or exposure.
8	ACCRUED_INT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The periodic amount of accrued interest for a given deal transaction.
9	BOND_DISC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount for Straightline Bond
10	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
11	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