TRX_CPINTA_VW

(SQL View)
Index Back

Daily Interest for CP deals

Used to calculate total interest using from and to dates for commercial paper that have issued on a CP facility. Total interest used in calculating estimated cost of funds of CP issued

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_CP_ISSUE_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